23/10/2024 09:16:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 09:16:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3140' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '503.32' , '418.66' , NOW() , NOW() ) 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93769' 23/10/2024 09:16:49 am >> DELETE FROM ps_document_detail WHERE id_document = '93769' 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93769' , '23071' , 'CASULA MORELLO - 65/016212' , '1' , '-1' , '1' , '360' , '295.08196721311' , '22' , '0' , '360.00' ) 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93769' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '21.50' ) 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93769' , '16461' , 'CLERGY NIDO D\'APE ML - C22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93769' , '16588' , 'CLERGY DIAGONALE MISTO ML - C06' , '1' , '-1' , '1' , '46.90' , '38.44262295082' , '22' , '0' , '46.90' ) 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93769' , '22984' , 'GIUBILEO DELLA SPERANZA - D. COSO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93769' , '23014' , 'GIUBILEO 2025 - SUSSIDIO RAGAZZI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/10/2024 09:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93769' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/10/2024 09:17:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3141' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 09:17:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3141' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '360.00' , '295.08' , NOW() , NOW() ) 23/10/2024 09:17:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93770' 23/10/2024 09:17:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93770' 23/10/2024 09:17:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93770' , '23071' , 'CASULA MORELLO - 65/016212' , '1' , '-1' , '1' , '360' , '295.08196721311' , '22' , '0' , '360.00' ) 23/10/2024 09:22:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001427' AND id_product != '16588' AND ean13 != '' 23/10/2024 09:22:06 am >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001427', date_upd = NOW() WHERE id_product = '16588' 23/10/2024 09:22:06 am >> UPDATE ps_product_lang SET name = 'CLERGY DIAGONALE ML - C06', description = '' WHERE id_product = '16588' 23/10/2024 09:22:06 am >> UPDATE ps_product SET wholesale_price = '18.72', on_sale = '0', price = '38.4426' WHERE id_product = '16588' 23/10/2024 09:22:06 am >> UPDATE ps_product_shop SET wholesale_price = '18.72', price = '38.4426', id_tax_rules_group = '1', id_category_default = '462', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16588' 23/10/2024 09:22:06 am >> DELETE FROM ps_specific_price WHERE id_product = '16588' 23/10/2024 09:29:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 09:29:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3142' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.92' , NOW() , NOW() ) 23/10/2024 09:29:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93771' 23/10/2024 09:29:09 am >> DELETE FROM ps_document_detail WHERE id_document = '93771' 23/10/2024 09:29:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93771' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 23/10/2024 09:29:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93771' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 23/10/2024 09:31:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '34' , '268' , '2024-10-22' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '326.11' , '267.30' , NOW() , NOW() ) 23/10/2024 09:31:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93772' 23/10/2024 09:31:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93772' 23/10/2024 09:31:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93772' , '18962' , 'POLO MISTO VISCOSA ML ' , '9' , '-9' , '1' , '24' , '19.672131147541' , '22' , '10' , '237.1680' ) 23/10/2024 09:31:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18962' AND id_supplier = '137' 23/10/2024 09:31:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18962' , '137' , '1' ) 23/10/2024 09:31:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93772' , '18984' , 'POLO FELPATO ML ' , '3' , '-3' , '1' , '27' , '22.131147540984' , '22' , '10' , '88.9380' ) 23/10/2024 09:32:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '137' 23/10/2024 09:32:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '137' , '1' ) 23/10/2024 09:54:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3143' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 09:54:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3143' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 23/10/2024 09:54:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93773' 23/10/2024 09:54:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93773' 23/10/2024 09:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93773' , '19150' , 'MOCCOLO 70X200' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 23/10/2024 10:11:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2674' AND id_document != '93123' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-13') 23/10/2024 10:11:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2674', document_date = '2024-09-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.00', price_tax_excluded = '4.92', date_upd = NOW() WHERE id_document = '93123' 23/10/2024 10:11:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93123' 23/10/2024 10:11:47 am >> DELETE FROM ps_document_detail WHERE id_document = '93123' 23/10/2024 10:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93123' , '7925' , 'PERGAMENE - BATTESIMO MOD. A' , '1' , '-1' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '0.10' ) 23/10/2024 10:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93123' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 23/10/2024 10:20:36 am >> SELECT document_num FROM ps_document WHERE document_num = '176' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 10:20:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '176' , '2024-10-23' , '' , '3978' , '0' , '4679334' , 'VIA MALTA 3 83100 AVELLINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '364.04' , '364.04' , NOW() , NOW() ) 23/10/2024 10:20:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93774' 23/10/2024 10:20:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93774' 23/10/2024 10:20:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93774' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 23/10/2024 10:20:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93774' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '22' , '-22' , '4' , '3.80' , '3.8' , '0' , '5' , '79.42' ) 23/10/2024 10:20:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93774' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '5' , '38.00' ) 23/10/2024 10:20:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93774' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '17' , '-17' , '4' , '3.80' , '3.8' , '0' , '5' , '61.37' ) 23/10/2024 10:20:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93774' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '8' , '-8' , '4' , '10.00' , '10' , '0' , '5' , '76.00' ) 23/10/2024 10:20:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93774' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.80' , '3.8' , '0' , '5' , '90.25' ) 23/10/2024 10:23:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3144' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 10:23:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3144' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.90' , '49.59' , NOW() , NOW() ) 23/10/2024 10:23:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93775' 23/10/2024 10:23:44 am >> DELETE FROM ps_document_detail WHERE id_document = '93775' 23/10/2024 10:23:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93775' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/10/2024 10:23:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93775' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/10/2024 10:37:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3145' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 10:37:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3145' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 23/10/2024 10:37:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93776' 23/10/2024 10:37:17 am >> DELETE FROM ps_document_detail WHERE id_document = '93776' 23/10/2024 10:37:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93776' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '7' , '-7' , '4' , '0.70' , '0.7' , '0' , '0' , '4.90' ) 23/10/2024 10:40:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '9005/24' , '2024-10-23' , '24' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 23/10/2024 10:40:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93777' 23/10/2024 10:40:45 am >> DELETE FROM ps_document_detail WHERE id_document = '93777' 23/10/2024 10:40:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93777' , '2679' , 'CONOSCERE GESU\'' , '2000' , '2000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 23/10/2024 10:40:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '125' 23/10/2024 10:40:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '125' , '1' ) 23/10/2024 11:18:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3146' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 11:18:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3146' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '19.18' , NOW() , NOW() ) 23/10/2024 11:18:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93778' 23/10/2024 11:18:03 am >> DELETE FROM ps_document_detail WHERE id_document = '93778' 23/10/2024 11:18:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93778' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 23/10/2024 11:18:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93778' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/10/2024 11:18:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93778' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/10/2024 11:18:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93778' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 23/10/2024 11:28:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3147' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 11:28:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3147' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 23/10/2024 11:28:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93779' 23/10/2024 11:28:41 am >> DELETE FROM ps_document_detail WHERE id_document = '93779' 23/10/2024 11:28:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93779' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 23/10/2024 12:00:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3148' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 12:00:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3148' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.74' , '54.74' , NOW() , NOW() ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93780' 23/10/2024 12:00:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93780' 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '5' , '1.90' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '22450' , 'DIO E SEMPRE CON NOI' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/10/2024 12:00:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93780' , '12712' , 'CRESIMA UNA FESTA DA VIVERE' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 23/10/2024 12:03:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3149' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 12:03:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3149' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.73' , '33.73' , NOW() , NOW() ) 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93781' 23/10/2024 12:03:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '93781' 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93781' , '7896' , 'PERDONO GUARISCE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93781' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93781' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93781' , '22897' , 'VOGLIO PASSARE IL MIO CIELO A FARE DEL BENE SULLA TERRA - S. M. LIESSE' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93781' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93781' , '7462' , 'PAOLO VI - T. BOSCO - G. FOCCOLI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 23/10/2024 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93781' , '22746' , 'COME SE VEDESSE LINVISIBILE - G.M. DOS SANTOS' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 23/10/2024 12:19:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3150' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 12:19:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3150' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 23/10/2024 12:19:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93782' 23/10/2024 12:19:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93782' 23/10/2024 12:19:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93782' , '15337' , 'SERVIZIO AMPOLLE FIESOLE NIK' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 23/10/2024 12:19:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93782' , '15733' , 'CASULA SPIGHE UVA - 95' , '1' , '-1' , '1' , '140.00' , '114.75409836066' , '22' , '0' , '140.00' ) 23/10/2024 12:35:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3151' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 12:35:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3151' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '298.50' , '247.72' , NOW() , NOW() ) 23/10/2024 12:35:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93783' 23/10/2024 12:35:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '93783' 23/10/2024 12:35:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93783' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 23/10/2024 12:35:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93783' , '12535' , 'BROCCA CON PIATTINO - 1006/15+731/100' , '1' , '-1' , '1' , '82.00' , '67.213114754098' , '22' , '0' , '82.00' ) 23/10/2024 12:35:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93783' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 23/10/2024 12:35:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93783' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 23/10/2024 12:35:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93783' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/10/2024 12:38:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2938' AND id_document != '93485' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-07') 23/10/2024 12:38:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2938', document_date = '2024-10-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '63.00', price_tax_excluded = '61.74', date_upd = NOW() WHERE id_document = '93485' 23/10/2024 12:38:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93485' 23/10/2024 12:38:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '93485' 23/10/2024 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '22507' , 'SPES NON CONFUNDIT' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '5' , '38.00' ) 23/10/2024 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 23/10/2024 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '20522' , 'CROCE BASE NIK - 105 ALV' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 23/10/2024 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/10/2024 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/10/2024 12:38:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/10/2024 12:38:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2692' AND id_document != '93147' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-14') 23/10/2024 12:38:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2692', document_date = '2024-09-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '93147' 23/10/2024 12:38:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93147' 23/10/2024 12:38:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93147' 23/10/2024 12:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93147' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.2' , '3.4426229508197' , '22' , '0' , '4.20' ) 23/10/2024 12:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93147' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '190.0000' , '155.73770491803' , '22' , '0' , '190.00' ) 23/10/2024 12:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93147' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '2' , '-2' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '5.80' ) 23/10/2024 12:50:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3152' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 12:50:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3152' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 23/10/2024 12:50:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93784' 23/10/2024 12:50:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93784' 23/10/2024 12:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93784' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 23/10/2024 12:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93784' , '21099' , 'BRACCIALE DECINA - BD008' , '26' , '-26' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '52.00' ) 23/10/2024 12:51:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 12:51:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3153' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.36' , '8.36' , NOW() , NOW() ) 23/10/2024 12:51:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93785' 23/10/2024 12:51:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93785' 23/10/2024 12:51:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93785' , '17734' , 'VANGELO E ATTI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 23/10/2024 12:51:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93785' , '11099' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 23/10/2024 12:51:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93785' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 23/10/2024 01:00:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3154' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 01:00:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3154' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 23/10/2024 01:00:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93786' 23/10/2024 01:00:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93786' 23/10/2024 01:00:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93786' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/10/2024 01:00:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93786' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 23/10/2024 02:48:04 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/10/2024 02:48:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23088' , '1' , '' , 'nuovo-prodotto' ) 23/10/2024 02:48:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23088' , '1' , '1' , '2' , NOW() , NOW() ) 23/10/2024 02:48:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23088' , '0' , '1' , '0' , '0' ) 23/10/2024 02:49:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739458473' AND id_product != '23088' AND ean13 != '' 23/10/2024 02:49:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739458473', date_upd = NOW() WHERE id_product = '23088' 23/10/2024 02:49:35 pm >> UPDATE ps_product_lang SET name = 'CAMPANA DEL GIUBILEO', description = '' WHERE id_product = '23088' 23/10/2024 02:49:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '23088' 23/10/2024 02:49:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.39344262295082', id_tax_rules_group = '1', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23088' 23/10/2024 02:49:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '23088' 23/10/2024 02:49:39 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23088' 23/10/2024 02:49:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23089' , '1' , '' , 'nuovo-prodotto' ) 23/10/2024 02:49:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23089' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23088' 23/10/2024 02:49:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23089' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23088' 23/10/2024 02:53:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '678233' , '2024-10-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.35' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.37' , '118.09' , NOW() , NOW() ) 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93787' 23/10/2024 02:53:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '93787' 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '23088' , 'CAMPANA DEL GIUBILEO' , '3' , '3' , '1' , '8.9' , '7.2950819672131' , '22' , '0' , '32.5740' ) 23/10/2024 02:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23088' AND id_supplier = '7' 23/10/2024 02:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23088' , '7' , '1' ) 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '23035' , 'PADRE NOSTRO - SPARTITO' , '1' , '1' , '3' , '11.53' , '11.086538461538' , '4' , '30' , '8.3938' ) 23/10/2024 02:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23035' AND id_supplier = '7' 23/10/2024 02:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23035' , '7' , '1' ) 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '1738' , 'CARTINE CATECHISTICHE' , '2' , '2' , '1' , '7.29' , '5.9754098360656' , '22' , '35' , '11.5619' ) 23/10/2024 02:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1738' AND id_supplier = '7' 23/10/2024 02:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1738' , '7' , '1' ) 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '17315' , 'TESSITORI DI FELICITA\' ' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '33' , '8.6430' ) 23/10/2024 02:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17315' AND id_supplier = '7' 23/10/2024 02:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17315' , '7' , '1' ) 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '19936' , 'SANTI PER IL CATECHISMO' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 23/10/2024 02:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19936' AND id_supplier = '7' 23/10/2024 02:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19936' , '7' , '1' ) 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 23/10/2024 02:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18163' AND id_supplier = '7' 23/10/2024 02:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18163' , '7' , '1' ) 23/10/2024 02:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 23/10/2024 02:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23069' AND id_supplier = '7' 23/10/2024 02:53:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23069' , '7' , '1' ) 23/10/2024 02:53:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '23017' , 'GRIDIAMO IL VANGELO - ANNO C - COMASTRI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 23/10/2024 02:53:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23017' AND id_supplier = '7' 23/10/2024 02:53:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23017' , '7' , '1' ) 23/10/2024 02:53:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '22876' , 'AMEN - NOV 24' , '3' , '3' , '4' , '3.90' , '3.9' , '0' , '33' , '7.8390' ) 23/10/2024 02:53:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22876' AND id_supplier = '7' 23/10/2024 02:53:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22876' , '7' , '1' ) 23/10/2024 02:53:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93787' , '22875' , 'AMEN - DIC 24' , '3' , '3' , '4' , '3.90' , '3.9' , '0' , '33' , '7.8390' ) 23/10/2024 02:53:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22875' AND id_supplier = '7' 23/10/2024 02:53:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22875' , '7' , '1' ) 23/10/2024 04:25:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3155' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 04:25:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3155' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '169.00' , '138.52' , NOW() , NOW() ) 23/10/2024 04:25:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93788' 23/10/2024 04:25:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93788' 23/10/2024 04:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93788' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 23/10/2024 04:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93788' , '16461' , 'CLERGY NIDO D\'APE ML - C22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 23/10/2024 04:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93788' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405/TPAD' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 23/10/2024 04:35:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3156' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 04:35:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3156' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '208.00' , '178.07' , NOW() , NOW() ) 23/10/2024 04:35:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93789' 23/10/2024 04:35:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93789' 23/10/2024 04:35:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93789' , '14725' , 'STOLA LANA/SETA/VISC. - ART. 1125' , '1' , '-1' , '1' , '132.00' , '108.19672131148' , '22' , '0' , '132.00' ) 23/10/2024 04:35:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93789' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '0' , '42.00' ) 23/10/2024 04:35:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93789' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 23/10/2024 04:52:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3157' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 04:52:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3157' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 23/10/2024 04:52:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93790' 23/10/2024 04:52:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93790' 23/10/2024 04:52:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93790' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 23/10/2024 05:03:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2935' AND id_document != '93480' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-05') 23/10/2024 05:03:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2935', document_date = '2024-10-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '93480' 23/10/2024 05:03:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93480' 23/10/2024 05:03:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93480' 23/10/2024 05:03:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93480' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/10/2024 05:17:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 05:17:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3158' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.30' , '69.31' , NOW() , NOW() ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93791' 23/10/2024 05:17:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93791' 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '19618' , 'CARLO ACUTIS' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '1' , '-1' , '4' , '11.90' , '11.9' , '0' , '5' , '11.31' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '21031' , 'MADONNA DEL ROSARIO - A. CAMPAGNA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '6242' , 'MARIA IMMACOLATA - S. CECCHIN' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '13.20' ) 23/10/2024 05:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93791' , '23088' , 'CAMPANA DEL GIUBILEO' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 23/10/2024 05:28:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 05:28:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '110/A' , '2024-10-23' , 'A' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.80' , '27.30' , NOW() , NOW() ) 23/10/2024 05:28:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93792' 23/10/2024 05:28:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93792' 23/10/2024 05:28:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 23/10/2024 05:28:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/10/2024 05:28:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '0' , '15.00' ) 23/10/2024 05:28:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 23/10/2024 06:17:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 06:17:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3159' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 23/10/2024 06:17:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93793' 23/10/2024 06:17:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '93793' 23/10/2024 06:17:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93793' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 23/10/2024 06:28:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-23') 23/10/2024 06:28:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3160' , '2024-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 23/10/2024 06:28:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93794' 23/10/2024 06:28:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93794' 23/10/2024 06:28:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93794' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' )