04/05/2022 08:57:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 04/05/2022 08:57:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '5.80', price_tax_excluded = '5.80', date_upd = NOW() WHERE id_document = '50074' 04/05/2022 08:57: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 = '50074' 04/05/2022 08:57:36 am >> DELETE FROM ps_document_detail WHERE id_document = '50074' 04/05/2022 08:57: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 ( '50074' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 04/05/2022 08:57:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 04/05/2022 08:57:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 04/05/2022 08:58:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1314' AND id_document != '56495' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 04/05/2022 08:58:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1314', document_date = '2022-04-29', 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 = '165.00', price_tax_excluded = '136.33', date_upd = NOW() WHERE id_document = '56495' 04/05/2022 08:58: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 = '56495' 04/05/2022 08:58:47 am >> DELETE FROM ps_document_detail WHERE id_document = '56495' 04/05/2022 08:58: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 ( '56495' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 04/05/2022 08:58:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 04/05/2022 08:58:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 04/05/2022 08:58: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 ( '56495' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '159.0000' , '130.32786885246' , '22' , '0' , '159.00' ) 04/05/2022 08:58:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/05/2022 08:58:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/05/2022 08:58: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 ( '56495' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 04/05/2022 08:58:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 04/05/2022 08:58:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 04/05/2022 08:59:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1366' AND id_document != '56554' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02') 04/05/2022 08:59:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1366', document_date = '2022-05-02', 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 = '8.70', price_tax_excluded = '8.70', date_upd = NOW() WHERE id_document = '56554' 04/05/2022 08:59:21 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 = '56554' 04/05/2022 08:59:21 am >> DELETE FROM ps_document_detail WHERE id_document = '56554' 04/05/2022 08:59:21 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 ( '56554' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 04/05/2022 08:59:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '' 04/05/2022 08:59:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '' , '1' ) 04/05/2022 08:59:21 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 ( '56554' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 04/05/2022 08:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '14929' AND id_supplier = '' 04/05/2022 08:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14929' , '' , '1' ) 04/05/2022 08:59:22 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 ( '56554' , '19489' , 'ATTO DI CONSACRAZIONE A MARIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 04/05/2022 08:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19489' AND id_supplier = '' 04/05/2022 08:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19489' , '' , '1' ) 04/05/2022 08:59:22 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 ( '56554' , '19375' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2022' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 04/05/2022 08:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19375' AND id_supplier = '' 04/05/2022 08:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19375' , '' , '1' ) 04/05/2022 09:00:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1337' AND id_document != '56520' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-30') 04/05/2022 09:00:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1337', document_date = '2022-04-30', 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 = '79.00', price_tax_excluded = '68.52', date_upd = NOW() WHERE id_document = '56520' 04/05/2022 09:00:35 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 = '56520' 04/05/2022 09:00:35 am >> DELETE FROM ps_document_detail WHERE id_document = '56520' 04/05/2022 09:00:35 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 ( '56520' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 04/05/2022 09:00:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 04/05/2022 09:00:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 04/05/2022 09:00:35 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 ( '56520' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/05/2022 09:00:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 04/05/2022 09:00:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 04/05/2022 09:00:35 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 ( '56520' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '6.00' ) 04/05/2022 09:00:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 04/05/2022 09:00:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 04/05/2022 09:00: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 ( '56520' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/05/2022 09:00:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 04/05/2022 09:00:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 04/05/2022 09:00: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 ( '56520' , '18644' , 'IN PRINCIPIO ERA IL VERBO - L.F. PARRAVICINI' , '1' , '-1' , '4' , '13' , '13' , '0' , '0' , '13.00' ) 04/05/2022 09:00:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '18644' AND id_supplier = '' 04/05/2022 09:00:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18644' , '' , '1' ) 04/05/2022 09:02:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1223' AND id_document != '55879' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 04/05/2022 09:02:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1223', document_date = '2022-04-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 = '19.60', price_tax_excluded = '19.60', date_upd = NOW() WHERE id_document = '55879' 04/05/2022 09:02:02 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 = '55879' 04/05/2022 09:02:02 am >> DELETE FROM ps_document_detail WHERE id_document = '55879' 04/05/2022 09:02:02 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 ( '55879' , '19516' , 'AMEN - AGO 2022' , '1' , '-1' , '4' , '3.75' , '3.75' , '0' , '0' , '3.75' ) 04/05/2022 09:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 04/05/2022 09:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 04/05/2022 09:02:02 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 ( '55879' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '-1' , '4' , '1.6000' , '1.6' , '0' , '0' , '1.60' ) 04/05/2022 09:02:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 04/05/2022 09:02:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 04/05/2022 09:02: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 ( '55879' , '19082' , 'IPNOSI DEL SENSIBILE - D. ZANELLA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 04/05/2022 09:02:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19082' AND id_supplier = '' 04/05/2022 09:02:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19082' , '' , '1' ) 04/05/2022 09:02:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1197' AND id_document != '55335' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-21') 04/05/2022 09:02:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1197', document_date = '2022-04-21', 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 = '27.00', price_tax_excluded = '25.29', date_upd = NOW() WHERE id_document = '55335' 04/05/2022 09:02:55 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 = '55335' 04/05/2022 09:02:55 am >> DELETE FROM ps_document_detail WHERE id_document = '55335' 04/05/2022 09:02:56 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 ( '55335' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.3' , '2.3' , '0' , '0' , '2.30' ) 04/05/2022 09:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/05/2022 09:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/05/2022 09:02:56 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 ( '55335' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '5' , '-5' , '1' , '1.9000' , '1.5573770491803' , '22' , '0' , '9.50' ) 04/05/2022 09:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '2436' AND id_supplier = '' 04/05/2022 09:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2436' , '' , '1' ) 04/05/2022 09:02:56 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 ( '55335' , '19493' , 'PROFEZIA E STORIA - L. BRUNI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/05/2022 09:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19493' AND id_supplier = '' 04/05/2022 09:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19493' , '' , '1' ) 04/05/2022 09:03:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1178' AND id_document != '55311' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-19') 04/05/2022 09:03:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1178', document_date = '2022-04-19', 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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '55311' 04/05/2022 09:03:34 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 = '55311' 04/05/2022 09:03:34 am >> DELETE FROM ps_document_detail WHERE id_document = '55311' 04/05/2022 09:03:34 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 ( '55311' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 04/05/2022 09:03:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/05/2022 09:03:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/05/2022 09:03:34 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 ( '55311' , '19508' , 'MIRACOLI DI GESU - I. ALFEEV' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '5' , '42.75' ) 04/05/2022 09:03:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19508' AND id_supplier = '' 04/05/2022 09:03:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19508' , '' , '1' ) 04/05/2022 09:04:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1369' AND id_document != '56557' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 04/05/2022 09:04:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1369', document_date = '2022-05-03', 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 = '31.00', price_tax_excluded = '27.03', date_upd = NOW() WHERE id_document = '56557' 04/05/2022 09:04: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 = '56557' 04/05/2022 09:04:36 am >> DELETE FROM ps_document_detail WHERE id_document = '56557' 04/05/2022 09:04: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 ( '56557' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/05/2022 09:04:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 04/05/2022 09:04:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 04/05/2022 09:04: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 ( '56557' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/05/2022 09:04:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 04/05/2022 09:04:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 04/05/2022 09:04: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 ( '56557' , '19503' , 'UN MESE CON MARIA - 8064' , '3' , '-3' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 04/05/2022 09:04:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '' 04/05/2022 09:04:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '' , '1' ) 04/05/2022 09:05:23 am >> SELECT document_num FROM ps_document WHERE document_num = '847' AND id_document != '53380' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-24') 04/05/2022 09:05:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '847', document_date = '2022-03-24', 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 = '3', id_causal = '0', price_tax_included = '108.40', price_tax_excluded = '90.91', date_upd = NOW() WHERE id_document = '53380' 04/05/2022 09:05:23 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 = '53380' 04/05/2022 09:05:23 am >> DELETE FROM ps_document_detail WHERE id_document = '53380' 04/05/2022 09:05:23 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 ( '53380' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 04/05/2022 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '15210' AND id_supplier = '' 04/05/2022 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15210' , '' , '1' ) 04/05/2022 09:05:23 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 ( '53380' , '19202' , 'LETTERA AGLI SPOSI' , '4' , '-4' , '4' , '3.0000' , '3' , '0' , '5' , '11.40' ) 04/05/2022 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19202' AND id_supplier = '' 04/05/2022 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19202' , '' , '1' ) 04/05/2022 09:05:23 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 ( '53380' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/05/2022 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/05/2022 09:05:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/05/2022 09:05:23 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 ( '53380' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/05/2022 09:05:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '13805' AND id_supplier = '' 04/05/2022 09:05:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13805' , '' , '1' ) 04/05/2022 09:17:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1387' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 09:17:35 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' , '1387' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '105.67' , NOW() , NOW() ) 04/05/2022 09:17:35 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 = '56578' 04/05/2022 09:17:35 am >> DELETE FROM ps_document_detail WHERE id_document = '56578' 04/05/2022 09:17:35 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 ( '56578' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 04/05/2022 09:17:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/05/2022 09:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/05/2022 09:17: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 ( '56578' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/05/2022 09:17:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 04/05/2022 09:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 04/05/2022 09:17: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 ( '56578' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9.44' , '9.44' , '0' , '0' , '9.44' ) 04/05/2022 09:17:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/05/2022 09:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/05/2022 09:17: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 ( '56578' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 04/05/2022 09:17:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '' 04/05/2022 09:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '' , '1' ) 04/05/2022 09:17: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 ( '56578' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '48.00' ) 04/05/2022 09:17:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 04/05/2022 09:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 04/05/2022 09:17: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 ( '56578' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/05/2022 09:17:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19361' AND id_supplier = '' 04/05/2022 09:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19361' , '' , '1' ) 04/05/2022 09:17: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 ( '56578' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 04/05/2022 09:17:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '18906' AND id_supplier = '' 04/05/2022 09:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18906' , '' , '1' ) 04/05/2022 09:26:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1388' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 09:26: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' , '1388' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 04/05/2022 09:26: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 = '56579' 04/05/2022 09:26:09 am >> DELETE FROM ps_document_detail WHERE id_document = '56579' 04/05/2022 09:26: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 ( '56579' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 04/05/2022 09:26:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 04/05/2022 09:26:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 04/05/2022 09:54:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1389' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 09:54:06 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' , '1389' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 04/05/2022 09:54:06 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 = '56580' 04/05/2022 09:54:06 am >> DELETE FROM ps_document_detail WHERE id_document = '56580' 04/05/2022 09:54:06 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 ( '56580' , '12042' , 'CROCE IN RESINA EFFETTO PIETRA - 2876/G52' , '3' , '-3' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '7.50' ) 04/05/2022 09:54:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '12042' AND id_supplier = '' 04/05/2022 09:54:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12042' , '' , '1' ) 04/05/2022 09:54:06 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 ( '56580' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.5' , '12.704918032787' , '22' , '0' , '15.50' ) 04/05/2022 09:54:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/05/2022 09:54:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/05/2022 09:56:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1390' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 09:56:12 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' , '1390' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.80' , '16.64' , NOW() , NOW() ) 04/05/2022 09:56:12 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 = '56581' 04/05/2022 09:56:12 am >> DELETE FROM ps_document_detail WHERE id_document = '56581' 04/05/2022 09:56:12 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 ( '56581' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '160' , '-160' , '4' , '0.03' , '0.03' , '0' , '0' , '4.80' ) 04/05/2022 09:56:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 04/05/2022 09:56:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 04/05/2022 09:56:12 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 ( '56581' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/05/2022 09:56:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 04/05/2022 09:56:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 04/05/2022 09:56:12 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 ( '56581' , '16898' , 'PREGHIERE E DEVOZIONI - FATIMA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/05/2022 09:56:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '16898' AND id_supplier = '' 04/05/2022 09:56:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16898' , '' , '1' ) 04/05/2022 10:03:58 am >> SELECT document_num FROM ps_document WHERE document_num = '60' AND id_document != '54563' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-04-04') 04/05/2022 10:03:59 am >> UPDATE ps_document SET id_document_type = '21', document_num = '60', document_date = '2022-04-04', document_letter = '', id_customer = '2054', id_supplier = '', id_address = '4671710', address1 = 'VIA S. GIOVANNI, 51 27029 VIGEVANO', address2 = '', note = '', price_shipping = '2', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '54563' 04/05/2022 10:03: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 = '54563' 04/05/2022 10:03:59 am >> DELETE FROM ps_document_detail WHERE id_document = '54563' 04/05/2022 10:03: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 ( '54563' , '15020' , 'PREGARE OGNI GIORNO' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '10' , '18.00' ) 04/05/2022 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/05/2022 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/05/2022 10:05:59 am >> SELECT document_num FROM ps_document WHERE document_num = '66' AND id_document != '55315' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-04-19') 04/05/2022 10:05:59 am >> UPDATE ps_document SET id_document_type = '21', document_num = '66', document_date = '2022-04-19', document_letter = '', id_customer = '3045', id_supplier = '', id_address = '4671988', address1 = 'VIA MAESTRI DEL LAVORO, 17 85100 POTENZA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '97.00', price_tax_excluded = '97.00', date_upd = NOW() WHERE id_document = '55315' 04/05/2022 10:05: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 = '55315' 04/05/2022 10:05:59 am >> DELETE FROM ps_document_detail WHERE id_document = '55315' 04/05/2022 10:05: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 ( '55315' , '11193' , 'VENITE CON ME CAT.' , '5' , '-5' , '4' , '5.5000' , '5.5' , '0' , '10' , '24.75' ) 04/05/2022 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 04/05/2022 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 04/05/2022 10:05: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 ( '55315' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '5' , '-5' , '4' , '5.5000' , '5.5' , '0' , '10' , '24.75' ) 04/05/2022 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 04/05/2022 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 04/05/2022 10:05: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 ( '55315' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '2' , '-2' , '4' , '1.25' , '1.25' , '0' , '0' , '2.50' ) 04/05/2022 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 04/05/2022 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 04/05/2022 10:05: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 ( '55315' , '15020' , 'PREGARE OGNI GIORNO' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '10' , '45.00' ) 04/05/2022 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/05/2022 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/05/2022 10:06:50 am >> SELECT document_num FROM ps_document WHERE document_num = '68' AND id_document != '55876' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-04-22') 04/05/2022 10:06:50 am >> UPDATE ps_document SET id_document_type = '21', document_num = '68', document_date = '2022-04-22', document_letter = '', id_customer = '3878', id_supplier = '', id_address = '4674051', address1 = 'Piazza Santa Chiara , 2 56020 Montopoli Val d’Arno', address2 = '', note = '', price_shipping = '5.2', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '14.40', price_tax_excluded = '14.40', date_upd = NOW() WHERE id_document = '55876' 04/05/2022 10:06:50 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 = '55876' 04/05/2022 10:06:50 am >> DELETE FROM ps_document_detail WHERE id_document = '55876' 04/05/2022 10:06:50 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 ( '55876' , '0' , 'contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/05/2022 10:06:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 04/05/2022 10:06:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 04/05/2022 10:06:50 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 ( '55876' , '15020' , 'PREGARE OGNI GIORNO' , '7' , '-7' , '4' , '1.00' , '1' , '0' , '10' , '6.30' ) 04/05/2022 10:06:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/05/2022 10:06:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/05/2022 10:08:15 am >> SELECT document_num FROM ps_document WHERE document_num = '72' AND id_document != '56462' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-04-28') 04/05/2022 10:08:15 am >> UPDATE ps_document SET id_document_type = '21', document_num = '72', document_date = '2022-04-28', document_letter = '', id_customer = '3544', id_supplier = '', id_address = '4674054', address1 = 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '116.50', price_tax_excluded = '116.50', date_upd = NOW() WHERE id_document = '56462' 04/05/2022 10:08:15 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 = '56462' 04/05/2022 10:08:15 am >> DELETE FROM ps_document_detail WHERE id_document = '56462' 04/05/2022 10:08:15 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 ( '56462' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '33' , '-33' , '4' , '3.0000' , '3' , '0' , '0' , '99.00' ) 04/05/2022 10:08:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11105' AND id_supplier = '' 04/05/2022 10:08:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11105' , '' , '1' ) 04/05/2022 10:08:15 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 ( '56462' , '15020' , 'PREGARE OGNI GIORNO' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '15' , '17.00' ) 04/05/2022 10:08:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/05/2022 10:08:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/05/2022 10:16:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1391' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 10:16:32 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' , '1391' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.10' , '50.44' , NOW() , NOW() ) 04/05/2022 10:16:32 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 = '56582' 04/05/2022 10:16:32 am >> DELETE FROM ps_document_detail WHERE id_document = '56582' 04/05/2022 10:16:32 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 ( '56582' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.00' , '2.8846153846154' , '4' , '0' , '9.00' ) 04/05/2022 10:16:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 04/05/2022 10:16:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 04/05/2022 10:16:32 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 ( '56582' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.70' , '1.6346153846154' , '4' , '0' , '5.10' ) 04/05/2022 10:16:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/05/2022 10:16:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/05/2022 10:16:32 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 ( '56582' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 04/05/2022 10:16:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 04/05/2022 10:16:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 04/05/2022 10:16:32 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 ( '56582' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 04/05/2022 10:16:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 04/05/2022 10:16:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 04/05/2022 10:16:32 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 ( '56582' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '13.50' ) 04/05/2022 10:16:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 04/05/2022 10:16:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 04/05/2022 10:30:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1392' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 10:30:31 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' , '1392' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '11.50' , NOW() , NOW() ) 04/05/2022 10:30:31 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 = '56583' 04/05/2022 10:30:31 am >> DELETE FROM ps_document_detail WHERE id_document = '56583' 04/05/2022 10:30:31 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 ( '56583' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 04/05/2022 10:30:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '8765' AND id_supplier = '' 04/05/2022 10:30:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8765' , '' , '1' ) 04/05/2022 10:30:31 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 ( '56583' , '10718' , 'TRE AVE MARIA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/05/2022 10:30:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '10718' AND id_supplier = '' 04/05/2022 10:30:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10718' , '' , '1' ) 04/05/2022 10:30:31 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 ( '56583' , '2761' , 'CORONA DI CENTO REQUIEM - 8181' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2022 10:30:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '2761' AND id_supplier = '' 04/05/2022 10:30:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2761' , '' , '1' ) 04/05/2022 10:30:31 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 ( '56583' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/05/2022 10:30:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7271' AND id_supplier = '' 04/05/2022 10:30:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7271' , '' , '1' ) 04/05/2022 10:30:31 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 ( '56583' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/05/2022 10:30:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 04/05/2022 10:30:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 04/05/2022 10:34:37 am >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 10:34:37 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' , '24' , '2022-05-04' , '' , '3466' , '0' , '4670122' , 'PIAZZA GARIBALDI 21 46048 ROVERBELLA' , '' , '' , '6.25' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '125.00' , '125.00' , NOW() , NOW() ) 04/05/2022 10:34: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 = '4700' 04/05/2022 10:34:37 am >> DELETE FROM ps_document_detail WHERE id_document = '4700' 04/05/2022 10:34: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 ( '4700' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '5' , '118.75' ) 04/05/2022 11:21:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1393' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:21:43 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' , '1393' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '11.09' , NOW() , NOW() ) 04/05/2022 11:21:43 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 = '56584' 04/05/2022 11:21:43 am >> DELETE FROM ps_document_detail WHERE id_document = '56584' 04/05/2022 11:21:43 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 ( '56584' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.00' , '2.8846153846154' , '4' , '0' , '6.00' ) 04/05/2022 11:21:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 04/05/2022 11:21:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 04/05/2022 11:21:43 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 ( '56584' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.70' , '1.6346153846154' , '4' , '0' , '1.70' ) 04/05/2022 11:21:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/05/2022 11:21:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/05/2022 11:21:43 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 ( '56584' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 04/05/2022 11:21:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 04/05/2022 11:21:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 04/05/2022 11:30:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1394' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:30:24 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' , '1394' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.00' , '52.46' , NOW() , NOW() ) 04/05/2022 11:30:24 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 = '56585' 04/05/2022 11:30:24 am >> DELETE FROM ps_document_detail WHERE id_document = '56585' 04/05/2022 11:30:24 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 ( '56585' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '20' , '-20' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '58.00' ) 04/05/2022 11:30:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13338' AND id_supplier = '' 04/05/2022 11:30:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13338' , '' , '1' ) 04/05/2022 11:30:24 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 ( '56585' , '13506' , 'SANTO ROSARIO' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 04/05/2022 11:30:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 04/05/2022 11:30:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 04/05/2022 11:35:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1395' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:35:15 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' , '1395' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '9.24' , NOW() , NOW() ) 04/05/2022 11:35:15 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 = '56586' 04/05/2022 11:35:15 am >> DELETE FROM ps_document_detail WHERE id_document = '56586' 04/05/2022 11:35:15 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 ( '56586' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 04/05/2022 11:35:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '' 04/05/2022 11:35:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '' , '1' ) 04/05/2022 11:35:15 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 ( '56586' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 04/05/2022 11:35:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/05/2022 11:35:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/05/2022 11:37:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1396' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:37:15 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' , '1396' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.10' , '11.10' , NOW() , NOW() ) 04/05/2022 11:37:15 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 = '56587' 04/05/2022 11:37:15 am >> DELETE FROM ps_document_detail WHERE id_document = '56587' 04/05/2022 11:37:15 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 ( '56587' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '1.7' , '1.7' , '0' , '0' , '5.10' ) 04/05/2022 11:37:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/05/2022 11:37:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/05/2022 11:37:15 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 ( '56587' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 04/05/2022 11:37:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/05/2022 11:37:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/05/2022 11:42:31 am >> SELECT document_num FROM ps_document WHERE document_num = '75' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:42:32 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' , '75' , '2022-05-04' , '' , '1954' , '0' , '4670787' , 'C.DA RETTIFILO - VIA G. GALILEI 84040 CAPACCIO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '178.50' , '178.50' , NOW() , NOW() ) 04/05/2022 11:42:32 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 = '56588' 04/05/2022 11:42:32 am >> DELETE FROM ps_document_detail WHERE id_document = '56588' 04/05/2022 11:42:32 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 ( '56588' , '9996' , 'SIGNORE, TI PREGO' , '35' , '-35' , '4' , '6.00' , '6' , '0' , '15' , '178.50' ) 04/05/2022 11:43:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1397' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:43:42 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' , '1397' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.50' , '37.30' , NOW() , NOW() ) 04/05/2022 11:43:42 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 = '56589' 04/05/2022 11:43:42 am >> DELETE FROM ps_document_detail WHERE id_document = '56589' 04/05/2022 11:43:42 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 ( '56589' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '35' , '-35' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '45.50' ) 04/05/2022 11:43:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 04/05/2022 11:43:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 04/05/2022 11:46:22 am >> SELECT document_num FROM ps_document WHERE document_num = '75' AND id_document != '56588' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:46:22 am >> UPDATE ps_document SET id_document_type = '21', document_num = '75', document_date = '2022-05-04', document_letter = '', id_customer = '1954', id_supplier = '', id_address = '4670787', address1 = 'C.DA RETTIFILO - VIA G. GALILEI 84040 CAPACCIO SCALO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '178.50', price_tax_excluded = '178.50', date_upd = NOW() WHERE id_document = '56588' 04/05/2022 11:46:22 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 = '56588' 04/05/2022 11:46:22 am >> DELETE FROM ps_document_detail WHERE id_document = '56588' 04/05/2022 11:46:22 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 ( '56588' , '9996' , 'SIGNORE, TI PREGO' , '35' , '-35' , '4' , '6.0000' , '6' , '0' , '15' , '178.50' ) 04/05/2022 11:46:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '9996' AND id_supplier = '' 04/05/2022 11:46:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9996' , '' , '1' ) 04/05/2022 11:49:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1398' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:49:30 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' , '1398' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 04/05/2022 11:49:30 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 = '56590' 04/05/2022 11:49:30 am >> DELETE FROM ps_document_detail WHERE id_document = '56590' 04/05/2022 11:49:30 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 ( '56590' , '12198' , 'CROCE MURANO FIOCCO - F. ARGENTO' , '1' , '-1' , '1' , '34' , '27.868852459016' , '22' , '0' , '34.00' ) 04/05/2022 11:49:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '12198' AND id_supplier = '' 04/05/2022 11:49:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12198' , '' , '1' ) 04/05/2022 11:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1399' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:53:54 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' , '1399' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.80' , '6.72' , NOW() , NOW() ) 04/05/2022 11:53:54 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 = '56591' 04/05/2022 11:53:54 am >> DELETE FROM ps_document_detail WHERE id_document = '56591' 04/05/2022 11:53:54 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 ( '56591' , '17520' , 'LUMINO SMERALDO' , '15' , '-15' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '6.00' ) 04/05/2022 11:53:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '17520' AND id_supplier = '' 04/05/2022 11:53:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17520' , '' , '1' ) 04/05/2022 11:53:54 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 ( '56591' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 04/05/2022 11:53:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = '' 04/05/2022 11:53:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' ) 04/05/2022 11:56:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1400' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 11:56:26 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' , '1400' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 04/05/2022 11:56:26 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 = '56592' 04/05/2022 11:56:26 am >> DELETE FROM ps_document_detail WHERE id_document = '56592' 04/05/2022 11:56:26 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 ( '56592' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/05/2022 11:56:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '2436' AND id_supplier = '' 04/05/2022 11:56:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2436' , '' , '1' ) 04/05/2022 11:56:26 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 ( '56592' , '12463' , 'QUADRO CON MAGNETE FATIMA' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 04/05/2022 11:56:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '12463' AND id_supplier = '' 04/05/2022 11:56:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12463' , '' , '1' ) 04/05/2022 12:45:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 12:45:18 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' , '1401' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.13' , '11.13' , NOW() , NOW() ) 04/05/2022 12:45:18 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 = '56593' 04/05/2022 12:45:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '56593' 04/05/2022 12:45:18 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 ( '56593' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 04/05/2022 12:45:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 04/05/2022 12:45:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 04/05/2022 12:45:18 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 ( '56593' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 04/05/2022 12:45:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 04/05/2022 12:45:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 04/05/2022 12:45:18 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 ( '56593' , '19516' , 'AMEN - AGO 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 04/05/2022 12:45:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 04/05/2022 12:45:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 04/05/2022 12:46:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 12:46:16 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' , '1402' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 04/05/2022 12:46:16 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 = '56594' 04/05/2022 12:46:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '56594' 04/05/2022 12:46:16 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 ( '56594' , '15300' , 'BENEDIZIONI - MADONNA MURILLO' , '200' , '-200' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '30.00' ) 04/05/2022 12:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15300' AND id_supplier = '' 04/05/2022 12:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15300' , '' , '1' ) 04/05/2022 12:55:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001692' AND id_product != '18130' AND ean13 != '' 04/05/2022 12:55:52 pm >> UPDATE ps_product SET id_supplier = '148', reference = '', ean13 = '001692', date_upd = NOW() WHERE id_product = '18130' 04/05/2022 12:55:52 pm >> UPDATE ps_product_lang SET name = 'TAU GRANDE CM 4 - T9', description = '' WHERE id_product = '18130' 04/05/2022 12:55:52 pm >> UPDATE ps_product SET wholesale_price = '0.28', on_sale = '0', price = '0.8197' WHERE id_product = '18130' 04/05/2022 12:55:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.28', price = '0.8197', id_tax_rules_group = '1', id_category_default = '477', 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 = '18130' 04/05/2022 12:55:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '18130' 04/05/2022 12:58:58 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 ( '31' , '282/2022' , '2022-05-03' , '2022' , '0' , '148' , '4671093' , 'VIALE EUROPA 62 - FRAZ. OSPEDALICCHIO 06083 BASTIA UMBRA ' , '' , '' , '9.5' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '436.15' , '357.50' , NOW() , NOW() ) 04/05/2022 12:58: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 = '56595' 04/05/2022 12:58:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '56595' 04/05/2022 12:58:58 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 ( '56595' , '18130' , 'TAU GRANDE CM 4 - T4' , '300' , '300' , '1' , '0.29' , '0.23770491803279' , '22' , '0' , '106.1400' ) 04/05/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18130' AND id_supplier = '148' 04/05/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18130' , '148' , '1' ) 04/05/2022 12:58:58 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 ( '56595' , '18131' , 'TAU MEDIO CM3 - T6' , '500' , '500' , '1' , '0.29' , '0.23770491803279' , '22' , '0' , '176.9000' ) 04/05/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '148' 04/05/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '148' , '1' ) 04/05/2022 12:58:58 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 ( '56595' , '18133' , 'CROCE SAN BENEDETTO CM 11 - CSB2' , '10' , '10' , '1' , '3.85' , '3.155737704918' , '22' , '0' , '46.9700' ) 04/05/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18133' AND id_supplier = '148' 04/05/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18133' , '148' , '1' ) 04/05/2022 12:58:58 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 ( '56595' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '50' , '50' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '54.9000' ) 04/05/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18135' AND id_supplier = '148' 04/05/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18135' , '148' , '1' ) 04/05/2022 12:58:58 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 ( '56595' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '25' , '25' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '39.6500' ) 04/05/2022 12:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18134' AND id_supplier = '148' 04/05/2022 12:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18134' , '148' , '1' ) 04/05/2022 01:02:30 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/05/2022 01:02:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19525' , '1' , '' , 'nuovo-prodotto' ) 04/05/2022 01:02:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19525' , '1' , '1' , '2' , NOW() , NOW() ) 04/05/2022 01:02:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19525' , '0' , '1' , '0' , '0' ) 04/05/2022 01:03:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879623896' AND id_product != '19525' AND ean13 != '' 04/05/2022 01:03:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788879623896', date_upd = NOW() WHERE id_product = '19525' 04/05/2022 01:03:18 pm >> UPDATE ps_product_lang SET name = 'OGGI VOGLIO PORTARVI TUTTI IN PARADISO', description = '' WHERE id_product = '19525' 04/05/2022 01:03:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.557377049180328' WHERE id_product = '19525' 04/05/2022 01:03:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.557377049180328', id_tax_rules_group = '1', id_category_default = '110', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19525' 04/05/2022 01:03:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '19525' 04/05/2022 01:03:19 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 = '19525' 04/05/2022 01:03:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19526' , '1' , '' , 'nuovo-prodotto' ) 04/05/2022 01:03:19 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 '19526' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19525' 04/05/2022 01:03:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19526' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19525' 04/05/2022 01:04:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881991754' AND id_product != '19526' AND ean13 != '' 04/05/2022 01:04:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788881991754', date_upd = NOW() WHERE id_product = '19526' 04/05/2022 01:04:02 pm >> UPDATE ps_product_lang SET name = 'POSTA DELL\'ANIMA - R. CANTALAMESSA', description = '' WHERE id_product = '19526' 04/05/2022 01:04:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.836065573770492' WHERE id_product = '19526' 04/05/2022 01:04:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '219', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19526' 04/05/2022 01:04:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '19526' 04/05/2022 01:04:03 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 = '19526' 04/05/2022 01:04:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19527' , '1' , '' , 'nuovo-prodotto' ) 04/05/2022 01:04:03 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 '19527' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19526' 04/05/2022 01:04:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19527' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19526' 04/05/2022 01:04:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881991761' AND id_product != '19527' AND ean13 != '' 04/05/2022 01:04:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788881991761', date_upd = NOW() WHERE id_product = '19527' 04/05/2022 01:04:51 pm >> UPDATE ps_product_lang SET name = 'CANTICO DELLE CREATURE', description = '' WHERE id_product = '19527' 04/05/2022 01:04:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.377049180327869' WHERE id_product = '19527' 04/05/2022 01:04:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.377049180327869', id_tax_rules_group = '1', id_category_default = '219', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19527' 04/05/2022 01:04:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '19527' 04/05/2022 01:04:52 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 = '19527' 04/05/2022 01:04:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19528' , '1' , '' , 'nuovo-prodotto' ) 04/05/2022 01:04:52 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 '19528' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19527' 04/05/2022 01:04:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19528' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19527' 04/05/2022 01:05:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254820100' AND id_product != '19368' AND ean13 != '' 04/05/2022 01:05:27 pm >> UPDATE ps_product SET id_supplier = '107', reference = '13/6', ean13 = '9791254820100', date_upd = NOW() WHERE id_product = '19368' 04/05/2022 01:05:27 pm >> UPDATE ps_product_lang SET name = 'CASA COSTRUITA SULLA SABBIA', description = '' WHERE id_product = '19368' 04/05/2022 01:05:27 pm >> UPDATE ps_product SET wholesale_price = '22.75', on_sale = '0', price = '35' WHERE id_product = '19368' 04/05/2022 01:05:27 pm >> UPDATE ps_product_shop SET wholesale_price = '22.75', price = '35', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19368' 04/05/2022 01:05:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19368' 04/05/2022 01:07:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821313981' AND id_product != '19528' AND ean13 != '' 04/05/2022 01:07:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788821313981', date_upd = NOW() WHERE id_product = '19528' 04/05/2022 01:07:17 pm >> UPDATE ps_product_lang SET name = 'CATECHISTI OGGI IN ITALIA', description = '' WHERE id_product = '19528' 04/05/2022 01:07:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '19528' 04/05/2022 01:07:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '87', id_argoment_default = '35', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19528' 04/05/2022 01:07:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '19528' 04/05/2022 01:07:18 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 = '19528' 04/05/2022 01:07:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19529' , '1' , '' , 'nuovo-prodotto' ) 04/05/2022 01:07:18 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 '19529' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19528' 04/05/2022 01:07:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19529' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19528' 04/05/2022 01:07:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879623896' AND id_product != '19525' AND ean13 != '' 04/05/2022 01:07:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788879623896', date_upd = NOW() WHERE id_product = '19525' 04/05/2022 01:07:39 pm >> UPDATE ps_product_lang SET name = 'OGGI VOGLIO PORTARVI TUTTI IN PARADISO', description = '' WHERE id_product = '19525' 04/05/2022 01:07:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '19525' 04/05/2022 01:07:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '110', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19525' 04/05/2022 01:07:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19525' 04/05/2022 01:08:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881991754' AND id_product != '19526' AND ean13 != '' 04/05/2022 01:08:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788881991754', date_upd = NOW() WHERE id_product = '19526' 04/05/2022 01:08:03 pm >> UPDATE ps_product_lang SET name = 'POSTA DELL\'ANIMA - R. CANTALAMESSA', description = '' WHERE id_product = '19526' 04/05/2022 01:08:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '19526' 04/05/2022 01:08:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '219', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19526' 04/05/2022 01:08:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19526' 04/05/2022 01:08:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881991761' AND id_product != '19527' AND ean13 != '' 04/05/2022 01:08:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788881991761', date_upd = NOW() WHERE id_product = '19527' 04/05/2022 01:08:19 pm >> UPDATE ps_product_lang SET name = 'CANTICO DELLE CREATURE', description = '' WHERE id_product = '19527' 04/05/2022 01:08:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '19527' 04/05/2022 01:08:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '219', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19527' 04/05/2022 01:08:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '19527' 04/05/2022 01:08:48 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' , '2022000002558' , '2022-05-03' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.85' , '115.85' , NOW() , NOW() ) 04/05/2022 01:08:48 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 = '56596' 04/05/2022 01:08:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '56596' 04/05/2022 01:08:48 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 ( '56596' , '19525' , 'OGGI VOGLIO PORTARVI TUTTI IN PARADISO' , '1' , '1' , '4' , '8.00' , '8' , '0' , '35' , '5.2000' ) 04/05/2022 01:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19525' AND id_supplier = '107' 04/05/2022 01:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19525' , '107' , '1' ) 04/05/2022 01:08:48 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 ( '56596' , '19526' , 'POSTA DELLANIMA - R. CANTALAMESSA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 04/05/2022 01:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19526' AND id_supplier = '107' 04/05/2022 01:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19526' , '107' , '1' ) 04/05/2022 01:08:48 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 ( '56596' , '19527' , 'CANTICO DELLE CREATURE' , '1' , '1' , '4' , '9.00' , '9' , '0' , '35' , '5.8500' ) 04/05/2022 01:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19527' AND id_supplier = '107' 04/05/2022 01:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19527' , '107' , '1' ) 04/05/2022 01:08:49 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 ( '56596' , '19368' , 'CASA COSTRUITA SULLA SABBIA' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 04/05/2022 01:08:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19368' AND id_supplier = '107' 04/05/2022 01:08:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19368' , '107' , '1' ) 04/05/2022 01:08:49 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 ( '56596' , '19367' , 'ARS PREDICANDI - AAVV' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 04/05/2022 01:08:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19367' AND id_supplier = '107' 04/05/2022 01:08:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19367' , '107' , '1' ) 04/05/2022 01:08:49 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 ( '56596' , '19133' , 'GIUSEPPE MOSCATI UN ESPONENTE ... - A. MARRANZINI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 04/05/2022 01:08:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19133' AND id_supplier = '107' 04/05/2022 01:08:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19133' , '107' , '1' ) 04/05/2022 01:08:49 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 ( '56596' , '19132' , 'GIUSEPPE MOSCATI MODELLO ... - A. MARRAZINI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 04/05/2022 01:08:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19132' AND id_supplier = '107' 04/05/2022 01:08:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19132' , '107' , '1' ) 04/05/2022 01:08:49 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 ( '56596' , '19496' , 'DIACONI - A. STRAUCH' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35' , '10.4000' ) 04/05/2022 01:08:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19496' AND id_supplier = '107' 04/05/2022 01:08:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19496' , '107' , '1' ) 04/05/2022 01:08:49 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 ( '56596' , '19528' , 'CATECHISTI OGGI IN ITALIA' , '2' , '2' , '4' , '20.00' , '20' , '0' , '35' , '26.0000' ) 04/05/2022 01:08:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19528' AND id_supplier = '107' 04/05/2022 01:08:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19528' , '107' , '1' ) 04/05/2022 02:31:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1390' AND id_document != '56581' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 02:31:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1390', document_date = '2022-05-04', 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 = '18.80', price_tax_excluded = '16.64', date_upd = NOW() WHERE id_document = '56581' 04/05/2022 02:31:55 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 = '56581' 04/05/2022 02:31:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '56581' 04/05/2022 02:31:55 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 ( '56581' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '160' , '-160' , '4' , '0.0300' , '0.03' , '0' , '0' , '4.80' ) 04/05/2022 02:31:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 04/05/2022 02:31:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 04/05/2022 02:31:56 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 ( '56581' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/05/2022 02:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 04/05/2022 02:31:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 04/05/2022 02:31:56 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 ( '56581' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 04/05/2022 02:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/05/2022 02:31:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/05/2022 02:56:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '31/A' AND id_document != '56447' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-04-27') 04/05/2022 02:56:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '31/A', document_date = '2022-04-27', document_letter = 'A', id_customer = '3501', id_supplier = '', id_address = '4670864', address1 = 'P.ZZA DUOMO, 1 84096 MONTECORVINO ROVELLA', 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 = '253.60', price_tax_excluded = '219.92', date_upd = NOW() WHERE id_document = '56447' 04/05/2022 02:56:51 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 = '56447' 04/05/2022 02:56:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '56447' 04/05/2022 02:56:51 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 ( '56447' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 04/05/2022 02:56:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 04/05/2022 02:56:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 04/05/2022 02:56:51 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 ( '56447' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '-4' , '4' , '6.0000' , '6' , '0' , '5' , '22.80' ) 04/05/2022 02:56:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '' 04/05/2022 02:56:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '' , '1' ) 04/05/2022 02:56:51 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 ( '56447' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '6.80' ) 04/05/2022 02:56:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/05/2022 02:56:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/05/2022 02:56:51 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 ( '56447' , '7673' , 'PARTICOLE MM38' , '6' , '-6' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '18.00' ) 04/05/2022 02:56:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 04/05/2022 02:56:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 04/05/2022 02:56:52 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 ( '56447' , '0' , '28/04' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 04/05/2022 02:56:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 04/05/2022 02:56:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 04/05/2022 02:56:52 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 ( '56447' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/05/2022 02:56:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 04/05/2022 02:56:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 04/05/2022 02:56:52 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 ( '56447' , '' , '04/05/2022' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 04/05/2022 02:56:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 04/05/2022 02:56:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 04/05/2022 02:56:52 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 ( '56447' , '15666' , 'MIRACOLOSA CM 60' , '1' , '-1' , '1' , '180.00' , '147.54098360656' , '22' , '0' , '180.00' ) 04/05/2022 02:56:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = '' 04/05/2022 02:56:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '' , '1' ) 04/05/2022 03:20:00 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '478' 04/05/2022 03:20:00 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '478' , '10' , '140' , 'PARROCCHIA S. LORENZO DA BRINDISI' , 'PRINCIPALLI ' , 'DON ANGELO' , 'VIA G. MATTEOTTI, 41' , '' , '72013' , 'CEGLIE MESSAPICA' , 'ATTENZIONE PAGA IN RITARDO solo contrassegno' , '3397757680 MIMMA' , '' , '' , '90001580746' , NOW() , NOW() ) 04/05/2022 03:20:00 pm >> UPDATE ps_customer SET email = 'mimmavenerito@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '478' 04/05/2022 03:23:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3724' 04/05/2022 03:23:44 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3724' , '10' , '134' , 'PARR. S. GIOVANNI BATT.' , 'RAVIELE' , 'MONS. ANTONIO' , 'P. ZZA UMBERTO I' , '' , '88016' , 'MONTESARCHIO ' , 'SPEDIRE A: CAPORASO LUIGIA STRADA VICINALE PANTANO, 23 82016 MONTESARCHIO BN \r\nTEL. 3460822285\r\n\r\nspedire in contrassegno' , '0824847436' , '3381240462' , '' , '92007290627' , NOW() , NOW() ) 04/05/2022 03:23:44 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3724' 04/05/2022 04:32:00 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 ( '32' , '6022245570' , '2022-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '20.71' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '1043.06' , '1043.06' , NOW() , NOW() ) 04/05/2022 04:32: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 = '56597' 04/05/2022 04:32:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '56597' 04/05/2022 04:32: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 ( '56597' , '8288' , 'PREGHIERA DEL MATTINO E DELLA SERA - GR - PER LAICI' , '2' , '0' , '4' , '11.43' , '11.43' , '0' , '0' , '22.8600' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8288' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8288' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '8286' , 'PREGHIERA DEL MATTINO E DELLA SERA' , '2' , '0' , '4' , '7.91' , '7.91' , '0' , '0' , '15.8200' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8286' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8286' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '15' , '0' , '4' , '20.53' , '20.53' , '0' , '0' , '307.9500' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '11740' , 'BIBBIA DI GERUSALEMME - GIGANTE DA ALTARE' , '1' , '0' , '4' , '67.45' , '67.45' , '0' , '0' , '67.4500' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11740' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11740' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '3' , '0' , '4' , '23.17' , '23.17' , '0' , '0' , '69.5100' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '1134' , 'BIBBIA DI GERUSALEMME - PLASTICA' , '3' , '0' , '4' , '18.77' , '18.77' , '0' , '0' , '56.3100' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1134' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1134' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '1136' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '5' , '0' , '4' , '20.23' , '20.23' , '0' , '0' , '101.1500' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1136' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1136' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '10' , '0' , '4' , '25.81' , '25.81' , '0' , '0' , '258.1000' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1147' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1147' , '109' , '1' ) 04/05/2022 04:32: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 ( '56597' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '5' , '0' , '4' , '24.64' , '24.64' , '0' , '0' , '123.2000' ) 04/05/2022 04:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1146' AND id_supplier = '109' 04/05/2022 04:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1146' , '109' , '1' ) 04/05/2022 04:33: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 ( '32' , ' 6022245568' , '2022-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.32' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '11.24' , '11.24' , NOW() , NOW() ) 04/05/2022 04:33: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 = '56598' 04/05/2022 04:33:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '56598' 04/05/2022 04:33: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 ( '56598' , '19493' , 'PROFEZIA E\' STORIA - L. BRUNI' , '1' , '0' , '4' , '10.92' , '10.92' , '0' , '0' , '10.9200' ) 04/05/2022 04:33:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19493' AND id_supplier = '109' 04/05/2022 04:33:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19493' , '109' , '1' ) 04/05/2022 04:36:41 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 ( '32' , '6022245569' , '2022-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.82' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '105.83' , '105.83' , NOW() , NOW() ) 04/05/2022 04:36: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 = '56599' 04/05/2022 04:36:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '56599' 04/05/2022 04:36: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 ( '56599' , '19492' , 'GRAZIE E DISGRAZIE DELLA VITA RELIGIOSA - P. SCIADINI' , '1' , '0' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 04/05/2022 04:36:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19492' AND id_supplier = '109' 04/05/2022 04:36:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19492' , '109' , '1' ) 04/05/2022 04:36: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 ( '56599' , '19425' , 'CREDIAMO NELLO SPIRITO SANTO - 4' , '1' , '0' , '4' , '52.00' , '52' , '0' , '30' , '36.4000' ) 04/05/2022 04:36:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19425' AND id_supplier = '109' 04/05/2022 04:36:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19425' , '109' , '1' ) 04/05/2022 04:36: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 ( '56599' , '16353' , 'QUALCUNO A CUI GUARDARE - L. EPICOCO' , '2' , '0' , '4' , '12.00' , '12' , '0' , '30' , '16.8000' ) 04/05/2022 04:36:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16353' AND id_supplier = '109' 04/05/2022 04:36:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16353' , '109' , '1' ) 04/05/2022 04:36: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 ( '56599' , '19491' , 'IN DIALOGO CON IL MONDO - PAPA FRANCESCO' , '1' , '0' , '4' , '10.65' , '10.65' , '0' , '0' , '10.6500' ) 04/05/2022 04:36:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19491' AND id_supplier = '109' 04/05/2022 04:36:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19491' , '109' , '1' ) 04/05/2022 04:36: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 ( '56599' , '10713' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA ' , '2' , '0' , '4' , '4.83' , '4.83' , '0' , '0' , '9.6600' ) 04/05/2022 04:36:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10713' AND id_supplier = '109' 04/05/2022 04:36:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10713' , '109' , '1' ) 04/05/2022 04:36: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 ( '56599' , '19324' , 'SIGNORE - R. GUARDINI' , '1' , '0' , '4' , '27.00' , '27' , '0' , '30' , '18.9000' ) 04/05/2022 04:36:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19324' AND id_supplier = '109' 04/05/2022 04:36:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19324' , '109' , '1' ) 04/05/2022 04:40:59 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'T8kxmn3hR2PJoJzY' , NOW() , NOW() ) 04/05/2022 04:40:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6966' , '1' ) 04/05/2022 04:40:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6966' , '2' ) 04/05/2022 04:40:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6966' , '3' ) 04/05/2022 04:42:49 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6966' 04/05/2022 04:42:49 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '6966' , '10' , '135' , 'CONVENTO SUORE ORSOLINE' , 'PASSERA' , 'SUOR ROSA' , 'VIA DEL CASTELLO 19' , '' , '24024' , 'GANDINO ' , '' , '035745569' , '3201138392' , '' , '' , NOW() , NOW() ) 04/05/2022 04:42:49 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6966' 04/05/2022 04:43:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 04:43: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 ( '21' , '25' , '2022-05-04' , '' , '6966' , '0' , '65346170' , 'VIA DEL CASTELLO 19 24024 GANDINO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '106.25' , '106.25' , NOW() , NOW() ) 04/05/2022 04:43: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 = '4701' 04/05/2022 04:43:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '4701' 04/05/2022 04:43: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 ( '4701' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '15' , '106.25' ) 04/05/2022 04:52:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892219588' AND id_product != '16005' AND ean13 != '' 04/05/2022 04:52:10 pm >> UPDATE ps_product SET id_supplier = '7', reference = '11/5', ean13 = '9788892219588', date_upd = NOW() WHERE id_product = '16005' 04/05/2022 04:52:10 pm >> UPDATE ps_product_lang SET name = 'DOMANDE DI GESU\' - L. MONTI', description = '' WHERE id_product = '16005' 04/05/2022 04:52:10 pm >> UPDATE ps_product SET wholesale_price = '12.73', on_sale = '0', price = '19.0000' WHERE id_product = '16005' 04/05/2022 04:52:10 pm >> UPDATE ps_product_shop SET wholesale_price = '12.73', price = '19.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16005' 04/05/2022 04:52:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '16005' 04/05/2022 05:12:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '33/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 05:12: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 ( '24' , '33/A' , '2022-05-04' , 'A' , '321' , '0' , '4672782' , 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '208.05' , '208.05' , NOW() , NOW() ) 04/05/2022 05:12: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 = '56600' 04/05/2022 05:12:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '56600' 04/05/2022 05:12: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 ( '56600' , '10916' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MARCO' , '1' , '-1' , '4' , '57.00' , '57' , '0' , '5' , '54.15' ) 04/05/2022 05:12: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 ( '56600' , '10917' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MATTEO' , '1' , '-1' , '4' , '51.00' , '51' , '0' , '5' , '48.45' ) 04/05/2022 05:12: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 ( '56600' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '-1' , '4' , '63.00' , '63' , '0' , '5' , '59.85' ) 04/05/2022 05:12: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 ( '56600' , '10914' , 'UNA COMUNITÀ LEGGE IL VANGELO DI GIOVANNI' , '1' , '-1' , '4' , '48.00' , '48' , '0' , '5' , '45.60' ) 04/05/2022 05:34:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 05:34:00 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' , '1403' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '11.09' , NOW() , NOW() ) 04/05/2022 05:34: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 = '56601' 04/05/2022 05:34:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '56601' 04/05/2022 05:34: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 ( '56601' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 04/05/2022 05:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16190' AND id_supplier = '' 04/05/2022 05:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16190' , '' , '1' ) 04/05/2022 05:34: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 ( '56601' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/05/2022 05:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19298' AND id_supplier = '' 04/05/2022 05:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19298' , '' , '1' ) 04/05/2022 05:34: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 ( '56601' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 04/05/2022 05:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 04/05/2022 05:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 04/05/2022 05:34: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 ( '56601' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '0.80' ) 04/05/2022 05:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19298' AND id_supplier = '' 04/05/2022 05:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19298' , '' , '1' ) 04/05/2022 05:34: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 ( '56601' , '19423' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 04/05/2022 05:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19423' AND id_supplier = '' 04/05/2022 05:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19423' , '' , '1' ) 04/05/2022 05:34: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 ( '56601' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/05/2022 05:34:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 04/05/2022 05:34:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 04/05/2022 05:39:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '56567' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-05-03') 04/05/2022 05:39:38 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '15', document_date = '2022-05-03', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '4216.00', price_tax_excluded = '4216.00', date_upd = NOW() WHERE id_document = '56567' 04/05/2022 05:39:38 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 = '56567' 04/05/2022 05:39:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '56567' 04/05/2022 05:39:38 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 ( '56567' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1600' , '-1600' , '4' , '1.6000' , '1.6' , '0' , '0' , '2560.00' ) 04/05/2022 05:39:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 04/05/2022 05:39:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 04/05/2022 05:39: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 ( '56567' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '92' , '-92' , '4' , '18.0000' , '18' , '0' , '0' , '1656.00' ) 04/05/2022 05:39:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18950' AND id_supplier = '' 04/05/2022 05:39:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18950' , '' , '1' ) 04/05/2022 06:25:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 06:25:06 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' , '1404' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.59' , '18.59' , NOW() , NOW() ) 04/05/2022 06:25:06 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 = '56602' 04/05/2022 06:25:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '56602' 04/05/2022 06:25:06 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 ( '56602' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '13' , '-13' , '4' , '1.50' , '1.5' , '0' , '5' , '18.59' ) 04/05/2022 06:25:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '' 04/05/2022 06:25:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '' , '1' ) 04/05/2022 06:34:10 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Wg6eZZlzNOwsxdSg' , NOW() , NOW() ) 04/05/2022 06:34:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3880' , '1' ) 04/05/2022 06:34:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3880' , '2' ) 04/05/2022 06:34:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3880' , '3' ) 04/05/2022 06:38:12 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3880' 04/05/2022 06:38:12 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3880' , '10' , '219' , 'PARROCCHIA SANTI BERNARDO E BRIGIDA' , 'LOVERA' , 'DON MARIO' , 'VIA FOGLIZZO 3' , '' , '10149' , 'TORINO' , 'LIA MAZZETTI 3397040447 - lia.atik@gmail.com' , '' , '' , '' , '97522000013' , NOW() , NOW() ) 04/05/2022 06:38:12 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3880' 04/05/2022 06:40:33 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3880' 04/05/2022 06:40:33 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3880' , '10' , '219' , 'PARROCCHIA SANTI BERNARDO E BRIGIDA' , 'LOVERA' , 'DON MARIO' , 'VIA FOGLIZZO 3' , '' , '10149' , 'TORINO' , 'LIA MAZZETTI 3397040447 - lia.atik@gmail.com\r\n\r\nspedire a: LIA MAZZETTI ATIK CAFFETTERIA PIER VIA BORSI 93 ANGOLO CORSO TOSCANA 10149 TORINO' , '' , '' , '' , '97522000013' , NOW() , NOW() ) 04/05/2022 06:40:33 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3880' 04/05/2022 06:41:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 06:41:57 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' , '1405' , '2022-05-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 04/05/2022 06:41:57 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 = '56603' 04/05/2022 06:41:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '56603' 04/05/2022 06:41:57 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 ( '56603' , '18012' , 'NOVENA AL SACRO CUORE DI GESU - 8020' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 04/05/2022 06:41:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18012' AND id_supplier = '' 04/05/2022 06:41:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18012' , '' , '1' ) 04/05/2022 06:43:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-04') 04/05/2022 06:43:55 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 ( '21' , '76' , '2022-05-04' , '' , '3880' , '0' , '4674058' , 'VIA FOGLIZZO 3 10149 TORINO' , '' , '' , '2.5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '50.00' , '41.43' , NOW() , NOW() ) 04/05/2022 06:43:55 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 = '56604' 04/05/2022 06:43:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '56604' 04/05/2022 06:43:55 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 ( '56604' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '5' , '47.50' ) 04/05/2022 07:16:36 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6966' 04/05/2022 07:16:36 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '6966' , '10' , '135' , 'CONVENTO SUORE ORSOLINE' , 'PASSERA' , 'SUOR ROSA' , 'VIA DEL CASTELLO 19' , '' , '24024' , 'GANDINO ' , '' , '035745569' , '3201138392' , '' , '00660710161' , NOW() , NOW() ) 04/05/2022 07:16:36 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6966'