11/07/2022 08:55:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2239' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-11') 11/07/2022 08:55:57 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' , '2239' , '2022-07-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 11/07/2022 08:55:57 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 = '59138' 11/07/2022 08:55:57 am >> DELETE FROM ps_document_detail WHERE id_document = '59138' 11/07/2022 08:55:57 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 ( '59138' , '7202' , 'ARTICOLI RELIGIOSI' , '15' , '-15' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '54.00' ) 11/07/2022 08:55:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 11/07/2022 08:55:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 11/07/2022 09:03:16 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' , '604510' , '2022-07-07' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '26.08' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.84' , '180.84' , NOW() , NOW() ) 11/07/2022 09:03:16 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 = '59139' 11/07/2022 09:03:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59139' 11/07/2022 09:03:16 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 ( '59139' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 11/07/2022 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 11/07/2022 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 11/07/2022 09:03:16 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 ( '59139' , '5596' , 'LECTIO DIVINA OGNI GIORNO - 6' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 11/07/2022 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '5596' AND id_supplier = '7' 11/07/2022 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5596' , '7' , '1' ) 11/07/2022 09:03:16 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 ( '59139' , '5597' , 'LECTIO DIVINA OGNI GIORNO - 7' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 11/07/2022 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '5597' AND id_supplier = '7' 11/07/2022 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5597' , '7' , '1' ) 11/07/2022 09:03:16 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 ( '59139' , '5588' , 'LECTIO DIVINA OGNI GIORNO - 14' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '30' , '11.5500' ) 11/07/2022 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '5588' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5588' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '5586' , 'LECTIO DIVINA OGNI GIORNO - 12' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '5586' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5586' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '5585' , 'LECTIO DIVINA OGNI GIORNO - 11' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '5585' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5585' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '5584' , 'LECTIO DIVINA OGNI GIORNO - 10' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '5584' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5584' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '19684' , 'AMEN - SETT. 2022' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '19685' , 'AMEN - OTT 2022' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '19516' , 'AMEN - AGO 2022' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '17063' , 'MADONNA DEL CARMINE' , '1' , '1' , '4' , '7.90' , '7.9' , '0' , '33' , '5.2930' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '17063' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17063' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '2528' , 'COMPIETA' , '36' , '36' , '4' , '1.30' , '1.3' , '0' , '33' , '31.3560' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '2528' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2528' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '2528' , 'COMPIETA' , '3' , '3' , '4' , '1.30' , '1.3' , '0' , '100' , '0.0000' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '2528' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2528' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '529' , 'AMORIS LAETITIA' , '12' , '12' , '4' , '2.20' , '2.2' , '0' , '35' , '17.1600' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '7' , '1' ) 11/07/2022 09:03: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 ( '59139' , '529' , 'AMORIS LAETITIA' , '1' , '1' , '4' , '2.20' , '2.2' , '0' , '100' , '0.0000' ) 11/07/2022 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '7' 11/07/2022 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '7' , '1' ) 11/07/2022 10:53:37 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '59132' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-09') 11/07/2022 10:53:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '51/A', document_date = '2022-07-09', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = 'p. enzo', 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 = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '59132' 11/07/2022 10:53:37 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 = '59132' 11/07/2022 10:53:37 am >> DELETE FROM ps_document_detail WHERE id_document = '59132' 11/07/2022 10:53:37 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 ( '59132' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 11/07/2022 10:53:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '8340' AND id_supplier = '' 11/07/2022 10:53:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8340' , '' , '1' ) 11/07/2022 10:53:37 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 ( '59132' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 11/07/2022 10:53:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '15816' AND id_supplier = '' 11/07/2022 10:53:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15816' , '' , '1' ) 11/07/2022 10:53:37 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 ( '59132' , '19377' , 'VANGELO SECONDO MARCO - L. BRUNI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 11/07/2022 10:53:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19377' AND id_supplier = '' 11/07/2022 10:53:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19377' , '' , '1' ) 11/07/2022 11:17:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-11') 11/07/2022 11:17:58 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' , '2240' , '2022-07-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.50' , '19.69' , NOW() , NOW() ) 11/07/2022 11:17:58 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 = '59140' 11/07/2022 11:17:58 am >> DELETE FROM ps_document_detail WHERE id_document = '59140' 11/07/2022 11:17:58 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 ( '59140' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 11/07/2022 11:17:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 11/07/2022 11:17:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 11/07/2022 11:17:58 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 ( '59140' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 11/07/2022 11:17:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 11/07/2022 11:17:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 11/07/2022 11:17:58 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 ( '59140' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '' , '16.00' ) 11/07/2022 11:17:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 11/07/2022 11:17:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 11/07/2022 03:49:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-11') 11/07/2022 03:49:31 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' , '2241' , '2022-07-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.40' , '87.21' , NOW() , NOW() ) 11/07/2022 03:49:31 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 = '59141' 11/07/2022 03:49:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '59141' 11/07/2022 03:49:31 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 ( '59141' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 11/07/2022 03:49:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 11/07/2022 03:49:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 11/07/2022 03:49:31 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 ( '59141' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 11/07/2022 03:49:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 11/07/2022 03:49:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 11/07/2022 04:18:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '59080' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-06') 11/07/2022 04:18:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '48/A', document_date = '2022-07-06', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '31.60', price_tax_excluded = '25.90', date_upd = NOW() WHERE id_document = '59080' 11/07/2022 04:18:29 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 = '59080' 11/07/2022 04:18:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '59080' 11/07/2022 04:18:29 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 ( '59080' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '2' , '-2' , '1' , '15.8000' , '12.950819672131' , '22' , '0' , '31.60' ) 11/07/2022 04:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 11/07/2022 04:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 11/07/2022 04:19:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 11/07/2022 04:19:17 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTI 650,00', 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 = '2872.60', price_tax_excluded = '2354.59', date_upd = NOW() WHERE id_document = '56617' 11/07/2022 04:19: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 = '56617' 11/07/2022 04:19:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 11/07/2022 04:19: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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875.0000' , '717.2131147541' , '22' , '0' , '875.00' ) 11/07/2022 04:19:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 11/07/2022 04:19:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 11/07/2022 04:19: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 11/07/2022 04:19:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 11/07/2022 04:19:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 11/07/2022 04:19: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 ( '56617' , '19594' , 'POLO JERSEY COTONE 100%' , '4' , '-4' , '1' , '36.90' , '30.245901639344' , '22' , '0' , '147.60' ) 11/07/2022 04:19:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 11/07/2022 04:19:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 11/07/2022 05:16:02 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/07/2022 05:16:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19736' , '1' , '' , 'nuovo-prodotto' ) 11/07/2022 05:16:02 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19736' , '1' , '1' , '2' , NOW() , NOW() ) 11/07/2022 05:16:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19736' , '0' , '1' , '0' , '0' ) 11/07/2022 05:23:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736086' AND id_product != '19736' AND ean13 != '' 11/07/2022 05:26:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736086' AND id_product != '19728' AND ean13 != '' 11/07/2022 05:26:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9791280736086', date_upd = NOW() WHERE id_product = '19728' 11/07/2022 05:26:15 pm >> UPDATE ps_product_lang SET name = 'MOSTRATI MADRE - V. SALVOLDI', description = '

Il libretto, insieme ad una guida per pregare il Rosario, propone per ogni mistero un’interessante e profonda meditazione di DonValentino Salvoldi che si trasforma in dialogo-preghiera intimo e fiducioso con Maria, nostra Madre.

' WHERE id_product = '19728' 11/07/2022 05:26:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5000' WHERE id_product = '19728' 11/07/2022 05:26:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '28', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19728' 11/07/2022 05:26:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '19728' 11/07/2022 05:26:16 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '19728' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 11/07/2022 05:26:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736079' AND id_product != '19730' AND ean13 != '' 11/07/2022 05:26:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9791280736079', date_upd = NOW() WHERE id_product = '19730' 11/07/2022 05:26:46 pm >> UPDATE ps_product_lang SET name = 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI', description = '

Per arrivare alla santità richiesta a tutti i battezzati, questo sussidio di meditazione e preghiera per l’Avvento propone di rispondere al dono del Natale di Gesù cercando di conoscere e di amare sempre di più la nostra Chiesa che si rinnova e si santifica ogni volta che un cristiano decide di tornare a rinascere con Cristo, ad ogni Natale.

Quel Dio che ci ha creati a sua immagine e somiglianza nasce come uomo per farci rinascere come Dio. Ci fa come Lui, ci dà la sua Parola per divinizzarci, ci offre i sacramenti per identificarci sempre più con Lui e ci dona lo Spirito Santo, che fa di noi tabernacoli viventi di Dio. Tutto ciò è possibile grazie alla Chiesa, che continua in ciascuno di noi l’opera del Salvatore.

' WHERE id_product = '19730' 11/07/2022 05:26:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '19730' 11/07/2022 05:26:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '39', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19730' 11/07/2022 05:26:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19730' 11/07/2022 05:26:46 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '19730' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 11/07/2022 06:01:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2209' AND id_document != '59099' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-07') 11/07/2022 06:01:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2209', document_date = '2022-07-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 = '1.00', price_tax_excluded = '0.82', date_upd = NOW() WHERE id_document = '59099' 11/07/2022 06:01: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 = '59099' 11/07/2022 06:01:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '59099' 11/07/2022 06:01: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 ( '59099' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/07/2022 06:01:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 11/07/2022 06:01:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 11/07/2022 06:02:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1688' AND id_document != '58485' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-28') 11/07/2022 06:02:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1688', document_date = '2022-05-28', 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.80', price_tax_excluded = '5.57', date_upd = NOW() WHERE id_document = '58485' 11/07/2022 06:02:22 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 = '58485' 11/07/2022 06:02:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '58485' 11/07/2022 06:02:22 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 ( '58485' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '22' , '-22' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '6.60' ) 11/07/2022 06:02:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 11/07/2022 06:02:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 11/07/2022 06:02:22 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 ( '58485' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 11/07/2022 06:02:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 11/07/2022 06:02:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 11/07/2022 06:02:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2021' AND id_document != '58874' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 11/07/2022 06:02:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2021', document_date = '2022-06-23', 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 = '46.00', price_tax_excluded = '37.70', date_upd = NOW() WHERE id_document = '58874' 11/07/2022 06:02:58 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 = '58874' 11/07/2022 06:02:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '58874' 11/07/2022 06:02: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 ( '58874' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '46' , '37.704918032787' , '22' , '0' , '46.00' ) 11/07/2022 06:02:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 11/07/2022 06:02:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 11/07/2022 06:03:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2063' AND id_document != '58926' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 11/07/2022 06:03:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2063', document_date = '2022-06-27', 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 = '41.60', price_tax_excluded = '34.10', date_upd = NOW() WHERE id_document = '58926' 11/07/2022 06:03:42 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 = '58926' 11/07/2022 06:03:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '58926' 11/07/2022 06:03:42 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 ( '58926' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 11/07/2022 06:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 11/07/2022 06:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 11/07/2022 06:03:42 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 ( '58926' , '13113' , 'GUADALUPE BABY - 023 GUA 9 BB' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 11/07/2022 06:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13113' AND id_supplier = '' 11/07/2022 06:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13113' , '' , '1' ) 11/07/2022 06:03:42 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 ( '58926' , '14623' , 'BAMBINO DI PRAGA BABY - 023 IP/9 BB' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 11/07/2022 06:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14623' AND id_supplier = '' 11/07/2022 06:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14623' , '' , '1' ) 11/07/2022 06:03:42 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 ( '58926' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 11/07/2022 06:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 11/07/2022 06:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 11/07/2022 06:04:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1939' AND id_document != '58783' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 11/07/2022 06:04:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1939', document_date = '2022-06-15', 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 = '140.00', price_tax_excluded = '123.32', date_upd = NOW() WHERE id_document = '58783' 11/07/2022 06:04:07 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 = '58783' 11/07/2022 06:04:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '58783' 11/07/2022 06:04:07 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 ( '58783' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 11/07/2022 06:04:07 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 ( '58783' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6058' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6058' , '' , '1' ) 11/07/2022 06:04:07 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 ( '58783' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '20' , '-20' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '22.00' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 11/07/2022 06:04:07 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 ( '58783' , '19644' , 'CHIESA CHE VERRA - A. MATTEO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19644' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19644' , '' , '1' ) 11/07/2022 06:04:07 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 ( '58783' , '19334' , 'INSEGNACI A PREGARE - J. MARTIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19334' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19334' , '' , '1' ) 11/07/2022 06:04:07 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 ( '58783' , '19131' , 'VIVI CRESCI AMA - M. DANIELI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19131' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19131' , '' , '1' ) 11/07/2022 06:04:07 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 ( '58783' , '19597' , 'MEDAGLIA SAN BENEDETTO ARG. RA631' , '1' , '-1' , '1' , '15.8000' , '12.950819672131' , '22' , '0' , '15.80' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19597' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19597' , '' , '1' ) 11/07/2022 06:04:07 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 ( '58783' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 11/07/2022 06:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '' 11/07/2022 06:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '' , '1' ) 11/07/2022 06:04:08 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 ( '58783' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 11/07/2022 06:04:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 11/07/2022 06:04:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 11/07/2022 06:04:08 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 ( '58783' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 11/07/2022 06:04:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19301' AND id_supplier = '' 11/07/2022 06:04:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19301' , '' , '1' ) 11/07/2022 06:04:08 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 ( '58783' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '78' , '-78' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '11.70' ) 11/07/2022 06:04:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 11/07/2022 06:04:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 11/07/2022 06:04:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1925' AND id_document != '58769' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 11/07/2022 06:04:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1925', document_date = '2022-06-15', 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 = '4.10', price_tax_excluded = '3.58', date_upd = NOW() WHERE id_document = '58769' 11/07/2022 06:04:43 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 = '58769' 11/07/2022 06:04:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '58769' 11/07/2022 06:04:43 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 ( '58769' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 11/07/2022 06:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 11/07/2022 06:04:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 11/07/2022 06:04:43 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 ( '58769' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.15' ) 11/07/2022 06:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 11/07/2022 06:04:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 11/07/2022 06:04:43 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 ( '58769' , '17006' , 'SEGNALIBRO PR' , '5' , '-5' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '1.75' ) 11/07/2022 06:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17006' AND id_supplier = '' 11/07/2022 06:04:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17006' , '' , '1' ) 11/07/2022 06:04:43 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 ( '58769' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.15' ) 11/07/2022 06:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 11/07/2022 06:04:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 11/07/2022 06:04:43 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 ( '58769' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 11/07/2022 06:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19468' AND id_supplier = '' 11/07/2022 06:04:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19468' , '' , '1' ) 11/07/2022 06:04:43 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 ( '58769' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 - OGGETTI' , '2' , '-2' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.50' ) 11/07/2022 06:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9797' AND id_supplier = '' 11/07/2022 06:04:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9797' , '' , '1' ) 11/07/2022 06:04:43 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 ( '58769' , '7910' , 'PERGAMENE - 1A COMUNIONE MOD. A' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 11/07/2022 06:04:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7910' AND id_supplier = '' 11/07/2022 06:04:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7910' , '' , '1' ) 11/07/2022 06:04:44 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 ( '58769' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 11/07/2022 06:04:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 11/07/2022 06:04:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 11/07/2022 06:05:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1938' AND id_document != '58782' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 11/07/2022 06:05:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1938', document_date = '2022-06-15', 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 = '20.69', price_tax_excluded = '20.69', date_upd = NOW() WHERE id_document = '58782' 11/07/2022 06:05:10 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 = '58782' 11/07/2022 06:05:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '58782' 11/07/2022 06:05: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 ( '58782' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 11/07/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16050' AND id_supplier = '' 11/07/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16050' , '' , '1' ) 11/07/2022 06:05: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 ( '58782' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 11/07/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 11/07/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 11/07/2022 06:05: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 ( '58782' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.14' , '6.14' , '0' , '0' , '6.14' ) 11/07/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 11/07/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 11/07/2022 06:05: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 ( '58782' , '11202' , 'VENITE E VEDRETE CAT.' , '1' , '-1' , '4' , '9.3000' , '9.3' , '0' , '5' , '8.84' ) 11/07/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11202' AND id_supplier = '' 11/07/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11202' , '' , '1' ) 11/07/2022 06:06:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2129' AND id_document != '58999' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-01') 11/07/2022 06:06:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2129', document_date = '2022-07-01', 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 = '64.00', price_tax_excluded = '52.46', date_upd = NOW() WHERE id_document = '58999' 11/07/2022 06:06:25 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 = '58999' 11/07/2022 06:06:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58999' 11/07/2022 06:06:25 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 ( '58999' , '5536' , 'LACCIO' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 11/07/2022 06:06:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5536' AND id_supplier = '' 11/07/2022 06:06:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5536' , '' , '1' ) 11/07/2022 06:06:26 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 ( '58999' , '6345' , 'MEDAGLIA S. BENEDETTO MET. DOR. SMALT. 3,2 - Q2006-D' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 11/07/2022 06:06:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6345' AND id_supplier = '' 11/07/2022 06:06:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6345' , '' , '1' ) 11/07/2022 06:06:26 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 ( '58999' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '5' , '-5' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '6.00' ) 11/07/2022 06:06:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 11/07/2022 06:06:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 11/07/2022 06:06:26 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 ( '58999' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 11/07/2022 06:06:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19128' AND id_supplier = '' 11/07/2022 06:06:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19128' , '' , '1' ) 11/07/2022 06:06:26 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 ( '58999' , '19150' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 11/07/2022 06:06:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 11/07/2022 06:06:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 11/07/2022 06:06:26 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 ( '58999' , '19106' , 'FRAGRANZA NARDO' , '2' , '-2' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '31.80' ) 11/07/2022 06:06:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19106' AND id_supplier = '' 11/07/2022 06:06:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19106' , '' , '1' ) 11/07/2022 06:06:26 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 ( '58999' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 11/07/2022 06:06:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 11/07/2022 06:06:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 11/07/2022 06:06:26 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 ( '58999' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 11/07/2022 06:06:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 11/07/2022 06:06:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 11/07/2022 06:06:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1900' AND id_document != '58741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 11/07/2022 06:06:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1900', document_date = '2022-06-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 = '11.00', price_tax_excluded = '10.19', date_upd = NOW() WHERE id_document = '58741' 11/07/2022 06:06:41 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 = '58741' 11/07/2022 06:06:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '58741' 11/07/2022 06:06:41 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 ( '58741' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 11/07/2022 06:06:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 11/07/2022 06:06:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 11/07/2022 06:06:41 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 ( '58741' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '6.5000' , '6.5' , '0' , '0' , '6.50' ) 11/07/2022 06:06:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 11/07/2022 06:06:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 11/07/2022 06:07:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2061' AND id_document != '58921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 11/07/2022 06:07:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2061', document_date = '2022-06-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '71.12', price_tax_excluded = '60.95', date_upd = NOW() WHERE id_document = '58921' 11/07/2022 06:07: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 = '58921' 11/07/2022 06:07:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58921' 11/07/2022 06:07: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 ( '58921' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 11/07/2022 06:07:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 11/07/2022 06:07:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 11/07/2022 06:07: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 ( '58921' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14.72' , '14.72' , '0' , '0' , '14.72' ) 11/07/2022 06:07:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 11/07/2022 06:07:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 11/07/2022 06:07:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1990' AND id_document != '58842' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 11/07/2022 06:07:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1990', document_date = '2022-06-22', 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 = '86.34', price_tax_excluded = '84.63', date_upd = NOW() WHERE id_document = '58842' 11/07/2022 06:07:43 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 = '58842' 11/07/2022 06:07:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '58842' 11/07/2022 06:07:43 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 ( '58842' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '16265' , 'MIE PREGHIERE' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16265' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16265' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '19481' , 'UN DIO CHE MUORE - P. CURTAZ' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19481' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19481' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '19326' , 'sul dolore - p. curtaz' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19326' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19326' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '18446' , 'MIA BIBBIA MORBIDA' , '1' , '-1' , '4' , '11.9000' , '11.9' , '0' , '5' , '11.31' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18446' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18446' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17583' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17583' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '13648' , 'BIOTESTAMENTO' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '0' , '0.90' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13648' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13648' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '1905' , 'CENTESIMUS ANNUS - GIOV. PAOLO II' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1905' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1905' , '' , '1' ) 11/07/2022 06:07:43 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 ( '58842' , '9505' , 'SAN PIO X - M.CARMINATI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 11/07/2022 06:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9505' AND id_supplier = '' 11/07/2022 06:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9505' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '1035' , 'BENEDETTO XV - M. DABRIZIO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1035' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1035' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '8041' , 'PIO XII IL PAPA DELLA CARITÀ - E. ARTIGLIERI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8041' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8041' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '9630' , 'SANTI FILIPPO E GIACOMO APOSTOLI - A. GOVERNALE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9630' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9630' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9471' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9471' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16065' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16065' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18658' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18658' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '19420' , 'PREGO ANCHE IO ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19420' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19420' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '14162' , 'DIECI COMANDAMENTI' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14162' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14162' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 11/07/2022 06:07:44 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 ( '58842' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '5.50' ) 11/07/2022 06:07:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 11/07/2022 06:07:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 11/07/2022 06:07: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 ( '58842' , '14777' , 'DECINA LEGNO CON LACCIO' , '1' , '-1' , '1' , '1.3100' , '1.0737704918033' , '22' , '0' , '1.31' ) 11/07/2022 06:07:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14777' AND id_supplier = '' 11/07/2022 06:07:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14777' , '' , '1' ) 11/07/2022 06:07: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 ( '58842' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 11/07/2022 06:07:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18527' AND id_supplier = '' 11/07/2022 06:07:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18527' , '' , '1' ) 11/07/2022 06:07: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 ( '58842' , '1319' , 'BRACCIALE DECINA TAU' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 11/07/2022 06:07:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 11/07/2022 06:07:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 11/07/2022 07:23:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-11') 11/07/2022 07:23:13 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' , '2242' , '2022-07-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 11/07/2022 07:23:13 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 = '59142' 11/07/2022 07:23:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '59142' 11/07/2022 07:23:13 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 ( '59142' , '19586' , 'UNA MAMMA PER TUTTI - NATUZZA EVOLO - 8072' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 11/07/2022 07:23:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19586' AND id_supplier = '' 11/07/2022 07:23:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19586' , '' , '1' ) 11/07/2022 07:29:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2243' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-11') 11/07/2022 07:29: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' , '2243' , '2022-07-11' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 11/07/2022 07:29: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 = '59143' 11/07/2022 07:29:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '59143' 11/07/2022 07:29: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 ( '59143' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 11/07/2022 07:29:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 11/07/2022 07:29:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' )