25/11/2022 09:10:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3445' AND id_document != '73092' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-14') 25/11/2022 09:10:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3445', document_date = '2022-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '2', id_causal = '0', price_tax_included = '442.80', price_tax_excluded = '442.80', date_upd = NOW() WHERE id_document = '73092' 25/11/2022 09:10:46 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 = '73092' 25/11/2022 09:10:46 am >> DELETE FROM ps_document_detail WHERE id_document = '73092' 25/11/2022 09:10:46 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 ( '73092' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '60' , '-60' , '4' , '2.7000' , '2.7' , '0' , '0' , '162.00' ) 25/11/2022 09:10:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 25/11/2022 09:10:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 25/11/2022 09:10:46 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 ( '73092' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '20' , '-20' , '4' , '2.7000' , '2.7' , '0' , '0' , '54.00' ) 25/11/2022 09:10:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 25/11/2022 09:10:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 25/11/2022 09:10:46 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 ( '73092' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '29' , '-29' , '4' , '2.7000' , '2.7' , '0' , '0' , '78.30' ) 25/11/2022 09:10:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 25/11/2022 09:10:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 25/11/2022 09:10:46 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 ( '73092' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '55' , '-55' , '4' , '2.7000' , '2.7' , '0' , '0' , '148.50' ) 25/11/2022 09:10:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '' 25/11/2022 09:10:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '' , '1' ) 25/11/2022 09:15:28 am >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:15:28 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' , '313' , '2022-11-25' , '' , '1175' , '0' , '4672789' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '74.38' , '74.38' , NOW() , NOW() ) 25/11/2022 09:15:28 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 = '74864' 25/11/2022 09:15:28 am >> DELETE FROM ps_document_detail WHERE id_document = '74864' 25/11/2022 09:15:28 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 ( '74864' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 25/11/2022 09:16:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3602' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:16:20 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' , '3602' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.76' , '76.53' , NOW() , NOW() ) 25/11/2022 09:16:20 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 = '74865' 25/11/2022 09:16:20 am >> DELETE FROM ps_document_detail WHERE id_document = '74865' 25/11/2022 09:16:20 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 ( '74865' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 25/11/2022 09:16:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 25/11/2022 09:16:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 25/11/2022 09:16:20 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 ( '74865' , '20031' , 'AVVENTO E NATALE 2022/2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 25/11/2022 09:16:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20031' AND id_supplier = '' 25/11/2022 09:16:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20031' , '' , '1' ) 25/11/2022 09:18:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:18:25 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' , '3603' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.84' , '60.84' , NOW() , NOW() ) 25/11/2022 09:18:25 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 = '74866' 25/11/2022 09:18:25 am >> DELETE FROM ps_document_detail WHERE id_document = '74866' 25/11/2022 09:18:25 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 ( '74866' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '15' , '-15' , '4' , '2.7' , '2.7' , '0' , '0' , '40.50' ) 25/11/2022 09:18:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 25/11/2022 09:18:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 25/11/2022 09:18:25 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 ( '74866' , '13116' , 'NOVENA A MARIA IMMACOLATA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 25/11/2022 09:18:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '13116' AND id_supplier = '' 25/11/2022 09:18:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13116' , '' , '1' ) 25/11/2022 09:18:25 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 ( '74866' , '20031' , 'AVVENTO E NATALE 2022/2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 25/11/2022 09:18:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '20031' AND id_supplier = '' 25/11/2022 09:18:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20031' , '' , '1' ) 25/11/2022 09:18:25 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 ( '74866' , '19229' , 'spiritualita dei laici nella parrocchia sinodale - g. villata' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 25/11/2022 09:18:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19229' AND id_supplier = '' 25/11/2022 09:18:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19229' , '' , '1' ) 25/11/2022 09:23:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:23:22 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' , '3604' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 25/11/2022 09:23: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 = '74867' 25/11/2022 09:23:22 am >> DELETE FROM ps_document_detail WHERE id_document = '74867' 25/11/2022 09:23: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 ( '74867' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 25/11/2022 09:23:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 25/11/2022 09:23:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 25/11/2022 09:23: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 ( '74867' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 25/11/2022 09:23:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 25/11/2022 09:23:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 25/11/2022 09:41:13 am >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '61794' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 25/11/2022 09:41:13 am >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2022-09-14', 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 = '30.70', price_tax_excluded = '30.70', date_upd = NOW() WHERE id_document = '61794' 25/11/2022 09:41:13 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 = '61794' 25/11/2022 09:41:13 am >> DELETE FROM ps_document_detail WHERE id_document = '61794' 25/11/2022 09:41:13 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 ( '61794' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 25/11/2022 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 25/11/2022 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 25/11/2022 09:41:13 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 ( '61794' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 25/11/2022 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 25/11/2022 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 25/11/2022 09:41:13 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 ( '61794' , '20443' , 'PAROLA E PREGHIERA - GEN. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 25/11/2022 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20443' AND id_supplier = '' 25/11/2022 09:41:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20443' , '' , '1' ) 25/11/2022 09:41:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20462' , 'ASCOLTARLO ERA RIMANERE ACCESI - E. RONCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 25/11/2022 09:41:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '20462' AND id_supplier = '' 25/11/2022 09:41:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20462' , '' , '1' ) 25/11/2022 09:45:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:45:01 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' , '3605' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 25/11/2022 09:45:01 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 = '74868' 25/11/2022 09:45:01 am >> DELETE FROM ps_document_detail WHERE id_document = '74868' 25/11/2022 09:45:01 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 ( '74868' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 25/11/2022 09:45:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 25/11/2022 09:45:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 25/11/2022 09:48:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:48:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3606' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 25/11/2022 09:48:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74869' 25/11/2022 09:48:57 am >> DELETE FROM ps_document_detail WHERE id_document = '74869' 25/11/2022 09:48:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74869' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 25/11/2022 09:48:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 25/11/2022 09:48:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 25/11/2022 09:52:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:52:08 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' , '3607' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.70' , '48.47' , NOW() , NOW() ) 25/11/2022 09:52:08 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 = '74870' 25/11/2022 09:52:08 am >> DELETE FROM ps_document_detail WHERE id_document = '74870' 25/11/2022 09:52:08 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 ( '74870' , '19805' , 'DESIDERIO DESIDERAVI' , '13' , '-13' , '4' , '2.00' , '2' , '0' , '5' , '24.70' ) 25/11/2022 09:52:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 25/11/2022 09:52:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 25/11/2022 09:52:08 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 ( '74870' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 25/11/2022 09:52:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 25/11/2022 09:52:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 25/11/2022 09:52:08 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 ( '74870' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 25/11/2022 09:52:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '' 25/11/2022 09:52:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '' , '1' ) 25/11/2022 09:53:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 09:53:04 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' , '3608' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 25/11/2022 09:53:04 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 = '74871' 25/11/2022 09:53:04 am >> DELETE FROM ps_document_detail WHERE id_document = '74871' 25/11/2022 09:53:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74871' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 25/11/2022 09:53:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 25/11/2022 09:53:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 25/11/2022 10:04:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3609' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 10:04:11 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' , '3609' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.60' , '51.19' , NOW() , NOW() ) 25/11/2022 10:04:11 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 = '74872' 25/11/2022 10:04:11 am >> DELETE FROM ps_document_detail WHERE id_document = '74872' 25/11/2022 10:04:11 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 ( '74872' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 25/11/2022 10:04:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 25/11/2022 10:04:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 25/11/2022 10:04:11 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 ( '74872' , '19985' , 'LECTIO DIVINA CON IL VANGELO DI MATTEO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 25/11/2022 10:04:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19985' AND id_supplier = '' 25/11/2022 10:04:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19985' , '' , '1' ) 25/11/2022 10:04:11 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 ( '74872' , '19171' , 'QUEL CRETINO DI UN CRISTIANO - M. BOTTA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 25/11/2022 10:04:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19171' AND id_supplier = '' 25/11/2022 10:04:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19171' , '' , '1' ) 25/11/2022 10:05:09 am >> SELECT document_num FROM ps_document WHERE document_num = '102/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 10:05: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 ( '24' , '102/A' , '2022-11-25' , 'A' , '371' , '0' , '4670910' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 25/11/2022 10:05: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 = '74873' 25/11/2022 10:05:09 am >> DELETE FROM ps_document_detail WHERE id_document = '74873' 25/11/2022 10:05: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 ( '74873' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 25/11/2022 10:05:18 am >> DELETE FROM ps_document WHERE id_document = '74873' 25/11/2022 10:05:18 am >> DELETE FROM ps_document_detail WHERE id_document = '74873' 25/11/2022 10:05:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892223554' AND id_product != '17488' AND ean13 != '' 25/11/2022 10:05:38 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/5', ean13 = '9788892223554', date_upd = NOW() WHERE id_product = '17488' 25/11/2022 10:05:38 am >> UPDATE ps_product_lang SET name = 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO', description = '' WHERE id_product = '17488' 25/11/2022 10:05:38 am >> UPDATE ps_product SET wholesale_price = '10.05', on_sale = '0', price = '15.0000' WHERE id_product = '17488' 25/11/2022 10:05:38 am >> UPDATE ps_product_shop SET wholesale_price = '10.05', price = '15.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17488' 25/11/2022 10:05:38 am >> DELETE FROM ps_specific_price WHERE id_product = '17488' 25/11/2022 10:35:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3610' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 10:35:21 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' , '3610' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 25/11/2022 10:35: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 = '74874' 25/11/2022 10:35:21 am >> DELETE FROM ps_document_detail WHERE id_document = '74874' 25/11/2022 10:35: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 ( '74874' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 25/11/2022 10:35:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 25/11/2022 10:35:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 25/11/2022 11:00:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3611' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 11:00:27 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' , '3611' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.95' , '38.95' , NOW() , NOW() ) 25/11/2022 11:00:27 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 = '74875' 25/11/2022 11:00:27 am >> DELETE FROM ps_document_detail WHERE id_document = '74875' 25/11/2022 11:00:27 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 ( '74875' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 25/11/2022 11:00:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '17488' AND id_supplier = '' 25/11/2022 11:00:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17488' , '' , '1' ) 25/11/2022 11:00:27 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 ( '74875' , '20314' , 'NOVE AURORE E DODICI NOTTI - FR. M. DAVIDE' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 25/11/2022 11:00:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '20314' AND id_supplier = '' 25/11/2022 11:00:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20314' , '' , '1' ) 25/11/2022 11:00:27 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 ( '74875' , '20452' , 'DANZA DEI GREMBI - E. RONCHI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 25/11/2022 11:00:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '20452' AND id_supplier = '' 25/11/2022 11:00:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20452' , '' , '1' ) 25/11/2022 11:00:27 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 ( '74875' , '19029' , 'BEATA COLEI CHE HA CREDUTO - G. MASPERO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 25/11/2022 11:00:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19029' AND id_supplier = '' 25/11/2022 11:00:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19029' , '' , '1' ) 25/11/2022 11:08:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 11:08:46 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' , '3612' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.30' , '4.70' , NOW() , NOW() ) 25/11/2022 11:08:46 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 = '74876' 25/11/2022 11:08:46 am >> DELETE FROM ps_document_detail WHERE id_document = '74876' 25/11/2022 11:08:46 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 ( '74876' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 25/11/2022 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 25/11/2022 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 25/11/2022 11:08:46 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 ( '74876' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 25/11/2022 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18896' AND id_supplier = '' 25/11/2022 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18896' , '' , '1' ) 25/11/2022 11:08:46 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 ( '74876' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 25/11/2022 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 25/11/2022 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 25/11/2022 11:08:46 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 ( '74876' , '19693' , 'CALENDARIO LITURGICO 2023' , '3' , '-3' , '4' , '0.50' , '0.5' , '0' , '0' , '1.50' ) 25/11/2022 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 25/11/2022 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 25/11/2022 11:09:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 11:09: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' , '3613' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.20' , '70.81' , NOW() , NOW() ) 25/11/2022 11:09: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 = '74877' 25/11/2022 11:09:32 am >> DELETE FROM ps_document_detail WHERE id_document = '74877' 25/11/2022 11:09: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 ( '74877' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '26.00' ) 25/11/2022 11:09:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 25/11/2022 11:09:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 25/11/2022 11:09: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 ( '74877' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 25/11/2022 11:09:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 11:09:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 11:09: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 ( '74877' , '6629' , 'MIA PREGHIERA' , '10' , '-10' , '4' , '0.90' , '0.9' , '0' , '5' , '8.60' ) 25/11/2022 11:09:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 25/11/2022 11:09:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 25/11/2022 11:09:33 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 ( '74877' , '18357' , 'MIE PREGHIERINE N.E.' , '20' , '-20' , '4' , '1.50' , '1.5' , '0' , '5' , '28.60' ) 25/11/2022 11:09:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 25/11/2022 11:09:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 25/11/2022 11:17:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 11:17: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' , '3614' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.21' , NOW() , NOW() ) 25/11/2022 11:17: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 = '74878' 25/11/2022 11:17:09 am >> DELETE FROM ps_document_detail WHERE id_document = '74878' 25/11/2022 11:17: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 ( '74878' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 25/11/2022 11:17:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '10870' AND id_supplier = '' 25/11/2022 11:17:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10870' , '' , '1' ) 25/11/2022 11:17: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 ( '74878' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 25/11/2022 11:17:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 25/11/2022 11:17:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 25/11/2022 11:26:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 11:26:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3615' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.30' , '49.03' , NOW() , NOW() ) 25/11/2022 11:26:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74879' 25/11/2022 11:26:16 am >> DELETE FROM ps_document_detail WHERE id_document = '74879' 25/11/2022 11:26:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74879' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 25/11/2022 11:26:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 25/11/2022 11:26:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 25/11/2022 11:26:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74879' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 25/11/2022 11:26:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 25/11/2022 11:26:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 25/11/2022 11:26:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74879' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 25/11/2022 11:26:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 25/11/2022 11:26:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 25/11/2022 11:26:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74879' , '16310' , 'PORTACHIAVI COLOMBA' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '20.00' ) 25/11/2022 11:26:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16310' AND id_supplier = '' 25/11/2022 11:26:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16310' , '' , '1' ) 25/11/2022 11:26:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74879' , '16308' , 'PORTACHIAVI TAU' , '16' , '-16' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '16.00' ) 25/11/2022 11:26:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '16308' AND id_supplier = '' 25/11/2022 11:26:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16308' , '' , '1' ) 25/11/2022 11:45:43 am >> SELECT document_num FROM ps_document WHERE document_num = '314' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 11:45: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 ( '21' , '314' , '2022-11-25' , '' , '27' , '' , '4676523' , 'P.ZZA PIRONTI 83025 PIANO DI MONTORO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.10' , '87.10' , NOW() , NOW() ) 25/11/2022 11:45: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 = '74880' 25/11/2022 11:45:43 am >> DELETE FROM ps_document_detail WHERE id_document = '74880' 25/11/2022 11:45: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 ( '74880' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '15' , '83.30' ) 25/11/2022 11:45:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 25/11/2022 11:45:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 25/11/2022 11:45: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 ( '74880' , '20319' , 'SAN NICOLA DA TOLENTINO - R. PICCOLOMINI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 25/11/2022 11:45:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20319' AND id_supplier = '' 25/11/2022 11:45:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20319' , '' , '1' ) 25/11/2022 11:51:20 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'bZqa2ExVFp6Ipkep' , NOW() , NOW() ) 25/11/2022 11:51:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3983' , '1' ) 25/11/2022 11:51:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3983' , '2' ) 25/11/2022 11:51:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3983' , '3' ) 25/11/2022 11:53:36 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3983' 25/11/2022 11:53:36 am >> 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 ( '3983' , '10' , '160' , 'PARR. SS. ANNUNZIATA E BIAGIO' , '' , 'P. NJUCI' , 'P. ZZA ANNUNZIATA' , '' , '03037' , 'PONTECORVO' , '' , '' , '3358046464' , '' , '' , NOW() , NOW() ) 25/11/2022 11:53:36 am >> UPDATE ps_customer SET email = 'njuzi@ymail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3983' 25/11/2022 11:57:16 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3983' 25/11/2022 11:57:16 am >> 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 ( '3983' , '10' , '160' , 'PARR. SS. ANNUNZIATA E BIAGIO' , '' , 'P. NJUCI' , 'P. ZZA ANNUNZIATA' , '' , '03037' , 'PONTECORVO' , '' , '' , '3358046464' , '' , '90002350602' , NOW() , NOW() ) 25/11/2022 11:57:16 am >> UPDATE ps_customer SET email = 'njuzi@ymail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3983' 25/11/2022 11:57:30 am >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 11:57: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 ( '21' , '315' , '2022-11-25' , '' , '3983' , '0' , '4677540' , 'P. ZZA ANNUNZIATA 03037 PONTECORVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '424.59' , '424.59' , NOW() , NOW() ) 25/11/2022 11:57: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 = '74881' 25/11/2022 11:57:30 am >> DELETE FROM ps_document_detail WHERE id_document = '74881' 25/11/2022 11:57: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 ( '74881' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 25/11/2022 11:57: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 ( '74881' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 25/11/2022 11:57: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 ( '74881' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '-27' , '4' , '2.50' , '2.5' , '0' , '15' , '57.38' ) 25/11/2022 11:57: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 ( '74881' , '5458' , 'IO SONO CON VOI 2 PARTE' , '27' , '-27' , '4' , '2.50' , '2.5' , '0' , '15' , '57.38' ) 25/11/2022 11:57: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 ( '74881' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 25/11/2022 11:57: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 ( '74881' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 25/11/2022 11:57: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 ( '74881' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 25/11/2022 11:57: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 ( '74881' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 25/11/2022 11:57: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 ( '74881' , '4120' , 'FEDE NELLO ZAINETTO' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '15' , '72.25' ) 25/11/2022 11:57: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 ( '74881' , '9675' , 'SARETE MIEI TESTIMONI' , '23' , '-23' , '4' , '3.50' , '3.5' , '0' , '15' , '68.42' ) 25/11/2022 12:00:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:00:43 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' , '3616' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '325.00' , '325.00' , NOW() , NOW() ) 25/11/2022 12:00:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74882' 25/11/2022 12:00:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '74882' 25/11/2022 12:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74882' , '5444' , 'IO SONO CON VOI - CAT.' , '27' , '-27' , '4' , '5' , '5' , '0' , '0' , '135.00' ) 25/11/2022 12:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 25/11/2022 12:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 25/11/2022 12:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74882' , '11193' , 'VENITE CON ME CAT.' , '15' , '-15' , '4' , '5' , '5' , '0' , '0' , '75.00' ) 25/11/2022 12:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 25/11/2022 12:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 25/11/2022 12:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74882' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '23' , '-23' , '4' , '5' , '5' , '0' , '0' , '115.00' ) 25/11/2022 12:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 25/11/2022 12:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 25/11/2022 12:05:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:05:44 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' , '3617' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '127.00' , '108.25' , NOW() , NOW() ) 25/11/2022 12:05:44 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 = '74883' 25/11/2022 12:05:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '74883' 25/11/2022 12:05:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74883' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '5' , '7.60' ) 25/11/2022 12:05:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '' 25/11/2022 12:05:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '' , '1' ) 25/11/2022 12:05:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74883' , '529' , 'AMORIS LAETITIA' , '1' , '-1' , '4' , '2.10' , '2.1' , '0' , '0' , '2.10' ) 25/11/2022 12:05:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '' 25/11/2022 12:05:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '' , '1' ) 25/11/2022 12:05:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74883' , '20261' , 'GIOIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 25/11/2022 12:05:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20261' AND id_supplier = '' 25/11/2022 12:05:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20261' , '' , '1' ) 25/11/2022 12:05:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74883' , '2115' , 'CLERGY BIANCO ML - MISTO 40' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 25/11/2022 12:05:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2115' AND id_supplier = '' 25/11/2022 12:05:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2115' , '' , '1' ) 25/11/2022 12:05:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74883' , '12011' , 'CLERGY GRIGIO CHIARO ML - COTONE 39' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 25/11/2022 12:05:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12011' AND id_supplier = '' 25/11/2022 12:05:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12011' , '' , '1' ) 25/11/2022 12:05:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74883' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 25/11/2022 12:05:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4205' AND id_supplier = '' 25/11/2022 12:05:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4205' , '' , '1' ) 25/11/2022 12:05:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74883' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 25/11/2022 12:05:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '940' AND id_supplier = '' 25/11/2022 12:05:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '940' , '' , '1' ) 25/11/2022 12:06:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3618' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:06:27 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' , '3618' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 25/11/2022 12:06:27 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 = '74884' 25/11/2022 12:06:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '74884' 25/11/2022 12:06:27 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 ( '74884' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 25/11/2022 12:06:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '940' AND id_supplier = '' 25/11/2022 12:06:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '940' , '' , '1' ) 25/11/2022 12:09:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '314' AND id_document != '74880' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:09:57 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '314', document_date = '2022-11-25', document_letter = '', id_customer = '27', id_supplier = '', id_address = '4676523', address1 = 'P.ZZA PIRONTI 83025 PIANO DI MONTORO', 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 = '87.10', price_tax_excluded = '87.10', date_upd = NOW() WHERE id_document = '74880' 25/11/2022 12:09: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 = '74880' 25/11/2022 12:09:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '74880' 25/11/2022 12:09: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 ( '74880' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '28' , '-28' , '4' , '3.5000' , '3.5' , '0' , '15' , '83.30' ) 25/11/2022 12:09:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 25/11/2022 12:09:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 25/11/2022 12:09: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 ( '74880' , '20319' , 'SAN NICOLA DA TOLENTINO - R. PICCOLOMINI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 25/11/2022 12:09:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20319' AND id_supplier = '' 25/11/2022 12:09:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20319' , '' , '1' ) 25/11/2022 12:30:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:30:15 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' , '3619' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '188.00' , '154.10' , NOW() , NOW() ) 25/11/2022 12:30:15 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 = '74885' 25/11/2022 12:30:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '74885' 25/11/2022 12:30:15 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 ( '74885' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 25/11/2022 12:30:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 25/11/2022 12:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 25/11/2022 12:30: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 ( '74885' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 25/11/2022 12:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16865' AND id_supplier = '' 25/11/2022 12:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16865' , '' , '1' ) 25/11/2022 12:30: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 ( '74885' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 25/11/2022 12:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 12:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 12:30: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 ( '74885' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 25/11/2022 12:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 12:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 12:34:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:34:43 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' , '3620' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 25/11/2022 12:34:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74886' 25/11/2022 12:34:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '74886' 25/11/2022 12:34:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74886' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 25/11/2022 12:34:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 25/11/2022 12:34:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 25/11/2022 12:45:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:45:49 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' , '3621' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 25/11/2022 12:45:49 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 = '74887' 25/11/2022 12:45:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '74887' 25/11/2022 12:45: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 ( '74887' , '20276' , 'CONCILIO VATICANO II - VOL. 1 - 701' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 25/11/2022 12:45:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20276' AND id_supplier = '' 25/11/2022 12:45:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20276' , '' , '1' ) 25/11/2022 12:57:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '74881' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 12:57:41 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '315', document_date = '2022-11-25', document_letter = '', id_customer = '3983', id_supplier = '', id_address = '4677540', address1 = 'P. ZZA ANNUNZIATA 03037 PONTECORVO', 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 = '352.34', price_tax_excluded = '352.34', date_upd = NOW() WHERE id_document = '74881' 25/11/2022 12:57: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 = '74881' 25/11/2022 12:57:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '74881' 25/11/2022 12:57: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 ( '74881' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 25/11/2022 12:57:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 25/11/2022 12:57:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 25/11/2022 12:57: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 ( '74881' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 25/11/2022 12:57:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 25/11/2022 12:57:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 25/11/2022 12:57: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 ( '74881' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 25/11/2022 12:57:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 25/11/2022 12:57:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 25/11/2022 12:57: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 ( '74881' , '5458' , 'IO SONO CON VOI 2 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 25/11/2022 12:57:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 25/11/2022 12:57:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 25/11/2022 12:57: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 ( '74881' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 25/11/2022 12:57:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 25/11/2022 12:57:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 25/11/2022 12:57: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 ( '74881' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 25/11/2022 12:57:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 25/11/2022 12:57:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 25/11/2022 12:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 25/11/2022 12:57:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 25/11/2022 12:57:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 25/11/2022 12:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 25/11/2022 12:57:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 25/11/2022 12:57:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 25/11/2022 12:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '9675' , 'SARETE MIEI TESTIMONI' , '23' , '-23' , '4' , '3.5000' , '3.5' , '0' , '15' , '68.42' ) 25/11/2022 12:57:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 25/11/2022 12:57:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 25/11/2022 02:43:50 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ZKl11Xd1P2PeP8gs' , NOW() , NOW() ) 25/11/2022 02:43:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7013' , '1' ) 25/11/2022 02:43:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7013' , '2' ) 25/11/2022 02:43:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7013' , '3' ) 25/11/2022 02:45:07 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7013' 25/11/2022 02:45:07 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 ( '7013' , '10' , '160' , 'PARR. SS. ANNUNZIATA E BIAGIO' , '' , 'P. NJUCI' , 'P. ZZA ANNUNZIATA' , '' , '03037' , 'PONTECORVO' , '' , '' , '3358046464' , '' , '90002350602' , NOW() , NOW() ) 25/11/2022 02:45:07 pm >> UPDATE ps_customer SET email = 'njuzi@ymail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7013' 25/11/2022 02:45:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '124' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 02:45:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '124' , '2022-11-25' , '' , '7013' , '0' , '98016379' , 'P. ZZA ANNUNZIATA 03037 PONTECORVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.25' , '72.25' , NOW() , NOW() ) 25/11/2022 02:45:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '8715' 25/11/2022 02:45:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '8715' 25/11/2022 02:45:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8715' , '17' , 'LA FEDE NELLO ZAINETTO' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '15' , '72.25' ) 25/11/2022 02:47:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '124' AND id_document != '8715' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 02:47:43 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '124', document_date = '2022-11-25', document_letter = '', id_customer = '7013', id_supplier = '', id_address = '98016379', address1 = 'P. ZZA ANNUNZIATA 03037 PONTECORVO', 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 = '72.25', price_tax_excluded = '72.25', date_upd = NOW() WHERE id_document = '8715' 25/11/2022 02:47:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '8715' 25/11/2022 02:47:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '8715' 25/11/2022 02:47:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8715' , '17' , 'LA FEDE NELLO ZAINETTO' , '17' , '-17' , '4' , '5.0000' , '5' , '0' , '15' , '72.25' ) 25/11/2022 02:47:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = '' 25/11/2022 02:47:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' ) 25/11/2022 02:55:43 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' , '2382/22' , '2022-11-25' , '22' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '1560.00' , '1500.00' , NOW() , NOW() ) 25/11/2022 02:55:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74888' 25/11/2022 02:55:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '74888' 25/11/2022 02:55:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74888' , '17257' , 'IO TI BATTEZZO ' , '5000' , '5000' , '3' , '0.3' , '0.28846153846154' , '4' , '0' , '1560.0000' ) 25/11/2022 02:55:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '125' 25/11/2022 02:55:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '125' , '1' ) 25/11/2022 02:57:12 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '479', document_date = '2022-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669176', address1 = 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE', address2 = '', note = '', price_shipping = '0.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '918.92', price_tax_excluded = '753.22', date_upd = NOW() WHERE id_document = '74849' 25/11/2022 02:57:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74849' 25/11/2022 02:57:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '74849' 25/11/2022 02:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74849' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '6' , '6' , '1' , '54.0000' , '44.262295081967' , '22' , '3' , '383.4216' ) 25/11/2022 02:57:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '' 25/11/2022 02:57:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '' , '1' ) 25/11/2022 02:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74849' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '4' , '4' , '1' , '56.0000' , '45.901639344262' , '22' , '3' , '265.0816' ) 25/11/2022 02:57:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 25/11/2022 02:57:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 25/11/2022 02:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74849' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '2' , '2' , '1' , '78.0000' , '63.934426229508' , '22' , '3' , '184.6104' ) 25/11/2022 02:57:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14578' AND id_supplier = '' 25/11/2022 02:57:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14578' , '' , '1' ) 25/11/2022 02:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74849' , '20463' , 'STOLA DIACONALE MARIANA - 35150' , '1' , '1' , '1' , '59.0000' , '48.360655737705' , '22' , '3' , '69.8206' ) 25/11/2022 02:57:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20463' AND id_supplier = '' 25/11/2022 02:57:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20463' , '' , '1' ) 25/11/2022 02:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74849' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '13.5' , '11.065573770492' , '22' , '3' , '15.9759' ) 25/11/2022 02:57:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '' 25/11/2022 02:57:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '' , '1' ) 25/11/2022 02:58:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859009718' AND id_product != '5105' AND ean13 != '' 25/11/2022 02:58:47 pm >> UPDATE ps_product SET id_supplier = '23', reference = '2013', ean13 = '8018859009718', date_upd = NOW() WHERE id_product = '5105' 25/11/2022 02:58:47 pm >> UPDATE ps_product_lang SET name = 'IMMAGINI SACRE SERIE STELLA 20X25 ', description = '' WHERE id_product = '5105' 25/11/2022 02:58:47 pm >> UPDATE ps_product SET wholesale_price = '0.23', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '5105' 25/11/2022 02:58:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.23', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5105' 25/11/2022 02:58:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '5105' 25/11/2022 03:09:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3622' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 03:09:54 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' , '3622' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 25/11/2022 03:09:54 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 = '74889' 25/11/2022 03:09:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '74889' 25/11/2022 03:09:54 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 ( '74889' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8' , '6.5573770491803' , '22' , '0' , '96.00' ) 25/11/2022 03:09:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 25/11/2022 03:09:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 25/11/2022 03:09:54 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 ( '74889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '44' , '36.065573770492' , '22' , '0' , '44.00' ) 25/11/2022 03:09:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 03:09:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 03:23:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859019625' AND id_product != '4997' AND ean13 != '' 25/11/2022 03:23:17 pm >> UPDATE ps_product SET id_supplier = '23', reference = '2013', ean13 = '8018859019625', date_upd = NOW() WHERE id_product = '4997' 25/11/2022 03:23:17 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE SANTA LUCIA', description = '' WHERE id_product = '4997' 25/11/2022 03:23:17 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4997' 25/11/2022 03:23:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4997' 25/11/2022 03:23:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '4997' 25/11/2022 03:24:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859006052' AND id_product != '13714' AND ean13 != '' 25/11/2022 03:24:00 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859006052', date_upd = NOW() WHERE id_product = '13714' 25/11/2022 03:24:00 pm >> UPDATE ps_product_lang SET name = 'CROCIFISSO D\'ASSISI', description = '' WHERE id_product = '13714' 25/11/2022 03:24:00 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '13714' 25/11/2022 03:24:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', 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 = '13714' 25/11/2022 03:24:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '13714' 25/11/2022 03:24:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859007318' AND id_product != '4959' AND ean13 != '' 25/11/2022 03:24:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '8018859007318', date_upd = NOW() WHERE id_product = '4959' 25/11/2022 03:24:14 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE CUORE IMMACOLATO DI MARIA - OGGETTI', description = '' WHERE id_product = '4959' 25/11/2022 03:24:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4959' 25/11/2022 03:24:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4959' 25/11/2022 03:24:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '4959' 25/11/2022 03:24:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859029082' AND id_product != '4964' AND ean13 != '' 25/11/2022 03:24:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = '8018859029082', date_upd = NOW() WHERE id_product = '4964' 25/11/2022 03:24:26 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE GIOVANNI PAOLO II', description = '' WHERE id_product = '4964' 25/11/2022 03:24:26 pm >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4964' 25/11/2022 03:24:26 pm >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4964' 25/11/2022 03:24:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '4964' 25/11/2022 03:24:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859029396' AND id_product != '4965' AND ean13 != '' 25/11/2022 03:24:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = '8018859029396', date_upd = NOW() WHERE id_product = '4965' 25/11/2022 03:24:36 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE GIOVANNI XXIII', description = '' WHERE id_product = '4965' 25/11/2022 03:24:36 pm >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4965' 25/11/2022 03:24:36 pm >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4965' 25/11/2022 03:24:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '4965' 25/11/2022 03:24:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859022083' AND id_product != '4967' AND ean13 != '' 25/11/2022 03:24:44 pm >> UPDATE ps_product SET id_supplier = '23', reference = '2015', ean13 = '8018859022083', date_upd = NOW() WHERE id_product = '4967' 25/11/2022 03:24:44 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE IMMACOLATA CONCEZIONE - 9', description = '' WHERE id_product = '4967' 25/11/2022 03:24:44 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4967' 25/11/2022 03:24:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4967' 25/11/2022 03:24:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '4967' 25/11/2022 03:24:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859029402' AND id_product != '4973' AND ean13 != '' 25/11/2022 03:24:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = '8018859029402', date_upd = NOW() WHERE id_product = '4973' 25/11/2022 03:24:52 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE LOURDES', description = '' WHERE id_product = '4973' 25/11/2022 03:24:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4973' 25/11/2022 03:24:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4973' 25/11/2022 03:24:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '4973' 25/11/2022 03:25:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859035175' AND id_product != '4978' AND ean13 != '' 25/11/2022 03:25:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = '8018859035175', date_upd = NOW() WHERE id_product = '4978' 25/11/2022 03:25:06 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE MATER BONI CONSILII - 46', description = '' WHERE id_product = '4978' 25/11/2022 03:25:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4978' 25/11/2022 03:25:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4978' 25/11/2022 03:25:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '4978' 25/11/2022 03:25:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1100107400006' AND id_product != '4998' AND ean13 != '' 25/11/2022 03:25:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '1100107400006', date_upd = NOW() WHERE id_product = '4998' 25/11/2022 03:25:17 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE SANTA RITA ', description = '' WHERE id_product = '4998' 25/11/2022 03:25:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4998' 25/11/2022 03:25:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4998' 25/11/2022 03:25:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '4998' 25/11/2022 03:25:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859007356' AND id_product != '4996' AND ean13 != '' 25/11/2022 03:25:29 pm >> UPDATE ps_product SET id_supplier = '23', reference = '2013', ean13 = '8018859007356', date_upd = NOW() WHERE id_product = '4996' 25/11/2022 03:25:29 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE SAN PIO - OGGETTI', description = '' WHERE id_product = '4996' 25/11/2022 03:25:29 pm >> UPDATE ps_product SET wholesale_price = '0.15', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '4996' 25/11/2022 03:25:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.15', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4996' 25/11/2022 03:25:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '4996' 25/11/2022 03:25:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859017362' AND id_product != '5001' AND ean13 != '' 25/11/2022 03:25:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8018859017362', date_upd = NOW() WHERE id_product = '5001' 25/11/2022 03:25:38 pm >> UPDATE ps_product_lang SET name = 'IMMAGINE SPIRITO SANTO - 133', description = '' WHERE id_product = '5001' 25/11/2022 03:25:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '5001' 25/11/2022 03:25:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '206', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5001' 25/11/2022 03:25:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '5001' 25/11/2022 03:26:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859024988' AND id_product != '6218' AND ean13 != '' 25/11/2022 03:26:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '8018859024988', date_upd = NOW() WHERE id_product = '6218' 25/11/2022 03:26:22 pm >> UPDATE ps_product_lang SET name = 'MARIA CHE SCIOGLIE I NODI - 209 - OGGETTI', description = '' WHERE id_product = '6218' 25/11/2022 03:26:23 pm >> UPDATE ps_product SET wholesale_price = '0.18', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '6218' 25/11/2022 03:26:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.18', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6218' 25/11/2022 03:26:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '6218' 25/11/2022 03:26:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859022458' AND id_product != '7482' AND ean13 != '' 25/11/2022 03:26:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '8018859022458', date_upd = NOW() WHERE id_product = '7482' 25/11/2022 03:26:33 pm >> UPDATE ps_product_lang SET name = 'PAPA FRANCESCO - 204 - OGGETTI', description = '' WHERE id_product = '7482' 25/11/2022 03:26:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '7482' 25/11/2022 03:26:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7482' 25/11/2022 03:26:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '7482' 25/11/2022 03:26:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859015740' AND id_product != '16713' AND ean13 != '' 25/11/2022 03:26:48 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859015740', date_upd = NOW() WHERE id_product = '16713' 25/11/2022 03:26:48 pm >> UPDATE ps_product_lang SET name = 'SACRA FAMIGLIA - 179', description = '' WHERE id_product = '16713' 25/11/2022 03:26:48 pm >> UPDATE ps_product SET wholesale_price = '0.19', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '16713' 25/11/2022 03:26:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.19', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16713' 25/11/2022 03:26:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '16713' 25/11/2022 03:27:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1100120100006' AND id_product != '9260' AND ean13 != '' 25/11/2022 03:27:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '1100120100006', date_upd = NOW() WHERE id_product = '9260' 25/11/2022 03:27:28 pm >> UPDATE ps_product_lang SET name = 'SACRA FAMIGLIA - 201 - OGGETTI', description = '' WHERE id_product = '9260' 25/11/2022 03:27:28 pm >> UPDATE ps_product SET wholesale_price = '0.18', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '9260' 25/11/2022 03:27:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.18', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9260' 25/11/2022 03:27:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '9260' 25/11/2022 03:27:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859015788' AND id_product != '9324' AND ean13 != '' 25/11/2022 03:27:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '8018859015788', date_upd = NOW() WHERE id_product = '9324' 25/11/2022 03:27:37 pm >> UPDATE ps_product_lang SET name = 'SACRO CUORE - 25', description = '' WHERE id_product = '9324' 25/11/2022 03:27:37 pm >> UPDATE ps_product SET wholesale_price = '0.15', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '9324' 25/11/2022 03:27:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.15', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9324' 25/11/2022 03:27:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '9324' 25/11/2022 03:27:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859026241' AND id_product != '16714' AND ean13 != '' 25/11/2022 03:27:52 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859026241', date_upd = NOW() WHERE id_product = '16714' 25/11/2022 03:27:52 pm >> UPDATE ps_product_lang SET name = 'SACRO CUORE DI MARIA', description = '' WHERE id_product = '16714' 25/11/2022 03:27:52 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '16714' 25/11/2022 03:27:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', id_argoment_default = '235', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16714' 25/11/2022 03:27:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '16714' 25/11/2022 03:28:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859036073' AND id_product != '13716' AND ean13 != '' 25/11/2022 03:28:04 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859036073', date_upd = NOW() WHERE id_product = '13716' 25/11/2022 03:28:04 pm >> UPDATE ps_product_lang SET name = 'SALVATORE', description = '' WHERE id_product = '13716' 25/11/2022 03:28:04 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '13716' 25/11/2022 03:28:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', 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 = '13716' 25/11/2022 03:28:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '13716' 25/11/2022 03:28:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859026258' AND id_product != '13715' AND ean13 != '' 25/11/2022 03:28:13 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859026258', date_upd = NOW() WHERE id_product = '13715' 25/11/2022 03:28:13 pm >> UPDATE ps_product_lang SET name = 'SANTA TERESA', description = '' WHERE id_product = '13715' 25/11/2022 03:28:13 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '13715' 25/11/2022 03:28:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', 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 = '13715' 25/11/2022 03:28:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '13715' 25/11/2022 03:29:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2435' AND id_document != '59905' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-03') 25/11/2022 03:29:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2435', document_date = '2022-08-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 = '112.80', price_tax_excluded = '102.88', date_upd = NOW() WHERE id_document = '59905' 25/11/2022 03:29:49 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 = '59905' 25/11/2022 03:29:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '59905' 25/11/2022 03:29: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 ( '59905' , '18934' , 'SPOSI, PROFETI DELLAMORE - DE ROSA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 25/11/2022 03:29:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18934' AND id_supplier = '' 25/11/2022 03:29:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18934' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '19682' , 'IDENTITA SESSUALE - C. CORBELLA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19682' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19682' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '15580' , 'CHRISTUS VIVIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15580' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15580' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '15902' , 'MASCHIO E FEMMINA LI CREO' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15902' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15902' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '17377' , 'SAMARITANUS BONUS' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17377' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17377' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '19743' , 'CE POSTO PER TUTTI - A. RUCCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19743' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19743' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '19566' , 'FAMIGLIA AMORIS LAETITIA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19566' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19566' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18884' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18884' , '' , '1' ) 25/11/2022 03:29:50 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 ( '59905' , '17122' , 'MADONNA DI VLADIMIR' , '80' , '-80' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '48.00' ) 25/11/2022 03:29:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17122' AND id_supplier = '' 25/11/2022 03:29:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17122' , '' , '1' ) 25/11/2022 03:30:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859032563' AND id_product != '17122' AND ean13 != '' 25/11/2022 03:30:05 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859032563', date_upd = NOW() WHERE id_product = '17122' 25/11/2022 03:30:05 pm >> UPDATE ps_product_lang SET name = 'MADONNA DI VLADIMIR', description = '' WHERE id_product = '17122' 25/11/2022 03:30:05 pm >> UPDATE ps_product SET wholesale_price = '0.20', on_sale = '0', price = '0.6557377049180328' WHERE id_product = '17122' 25/11/2022 03:30:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.20', price = '0.6557377049180328', id_tax_rules_group = '1', id_category_default = '92', 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 = '17122' 25/11/2022 03:30:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '17122' 25/11/2022 03:35:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '117/2022' , '2022-11-25' , '2022' , '0' , '23' , '2618' , 'V.LE ISONZO, 52 20135 MILANO' , '' , 'CONTROLLARE NUMERO' , '16' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '171.32' , '140.43' , NOW() , NOW() ) 25/11/2022 03:35:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74890' 25/11/2022 03:35:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '74890' 25/11/2022 03:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '4997' , 'IMMAGINE SANTA LUCIA' , '50' , '50' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '18.3000' ) 25/11/2022 03:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4997' AND id_supplier = '23' 25/11/2022 03:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4997' , '23' , '1' ) 25/11/2022 03:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '4374' , 'GESÙ BAMBINO - 273' , '300' , '300' , '1' , '0.065' , '0.05327868852459' , '22' , '25' , '17.8425' ) 25/11/2022 03:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4374' AND id_supplier = '23' 25/11/2022 03:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4374' , '23' , '1' ) 25/11/2022 03:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '17617' , 'IMMAGINI ISONZO X 100' , '50' , '50' , '1' , '2' , '1.6393442622951' , '22' , '25' , '91.5000' ) 25/11/2022 03:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '23' 25/11/2022 03:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '23' , '1' ) 25/11/2022 03:36: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 ( '74890' , '13315' , 'SEGNALIBRI VIENI BAMBINO GESU - 119' , '200' , '200' , '1' , '0.066' , '0.054098360655738' , '22' , '25' , '12.0780' ) 25/11/2022 03:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13315' AND id_supplier = '23' 25/11/2022 03:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13315' , '23' , '1' ) 25/11/2022 03:36: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 ( '74890' , '13316' , 'SEGNALIBRI E NATALE - 120' , '200' , '200' , '1' , '0.066' , '0.054098360655738' , '22' , '25' , '12.0780' ) 25/11/2022 03:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13316' AND id_supplier = '23' 25/11/2022 03:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13316' , '23' , '1' ) 25/11/2022 04:08:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3623' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 04:08: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 ( '11' , '3623' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.38' , '3.20' , NOW() , NOW() ) 25/11/2022 04:08: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 = '74891' 25/11/2022 04:08:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '74891' 25/11/2022 04:08: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 ( '74891' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 25/11/2022 04:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 25/11/2022 04:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 25/11/2022 04:08: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 ( '74891' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 25/11/2022 04:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '' 25/11/2022 04:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '' , '1' ) 25/11/2022 04:23:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3624' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 04:23:35 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' , '3624' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1000.00' , '819.67' , NOW() , NOW() ) 25/11/2022 04:23:35 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 = '74892' 25/11/2022 04:23:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '74892' 25/11/2022 04:23:35 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 ( '74892' , '13160' , 'CASULA MOD. CRISTOGRAMMA' , '2' , '-2' , '1' , '335' , '274.59016393443' , '22' , '0' , '670.00' ) 25/11/2022 04:23:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13160' AND id_supplier = '' 25/11/2022 04:23:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13160' , '' , '1' ) 25/11/2022 04:23:35 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 ( '74892' , '13160' , 'CASULA MOD. CRISTOGRAMMA' , '1' , '-1' , '1' , '330' , '270.49180327869' , '22' , '0' , '330.00' ) 25/11/2022 04:23:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13160' AND id_supplier = '' 25/11/2022 04:23:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13160' , '' , '1' ) 25/11/2022 04:26:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3625' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 04:26:54 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' , '3625' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 25/11/2022 04:26:54 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 = '74893' 25/11/2022 04:26:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '74893' 25/11/2022 04:26:54 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 ( '74893' , '20308' , 'ATTENDERE E SPERARE - PAPA FRANCESCO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 25/11/2022 04:26:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20308' AND id_supplier = '' 25/11/2022 04:26:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20308' , '' , '1' ) 25/11/2022 04:36:18 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '27' 25/11/2022 04:36:18 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 ( '27' , '10' , '130' , 'PARROCCHIA S. GIOVANNI BAT.' , 'D\'AMORE' , 'DON ADRIANO' , 'P.ZZA PIRONTI' , '' , '83025' , 'PIANO DI MONTORO' , '' , '3494137218' , '' , '' , '92010080643' , NOW() , NOW() ) 25/11/2022 04:36:18 pm >> UPDATE ps_customer SET email = 'donadriano84@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '27' 25/11/2022 04:39:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3626' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 04:39:26 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' , '3626' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 25/11/2022 04:39:26 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 = '74894' 25/11/2022 04:39:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '74894' 25/11/2022 04:39:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74894' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 25/11/2022 04:39:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 25/11/2022 04:39:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 25/11/2022 04:50:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3627' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 04:50:47 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' , '3627' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 25/11/2022 04:50:47 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 = '74895' 25/11/2022 04:50:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '74895' 25/11/2022 04:50:47 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 ( '74895' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '5' , '-5' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '13.50' ) 25/11/2022 04:50:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '' 25/11/2022 04:50:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' ) 25/11/2022 05:05:34 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 25/11/2022 05:05:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20464' , '1' , '' , 'nuovo-prodotto' ) 25/11/2022 05:05:34 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20464' , '1' , '1' , '2' , NOW() , NOW() ) 25/11/2022 05:05:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20464' , '0' , '1' , '0' , '0' ) 25/11/2022 05:06:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607306' AND id_product != '20464' AND ean13 != '' 25/11/2022 05:06:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788826607306', date_upd = NOW() WHERE id_product = '20464' 25/11/2022 05:06:25 pm >> UPDATE ps_product_lang SET name = 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO', description = '' WHERE id_product = '20464' 25/11/2022 05:06:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20464' 25/11/2022 05:06:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '104', 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 = '20464' 25/11/2022 05:06:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20464' 25/11/2022 05:06:27 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 = '20464' 25/11/2022 05:06:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20465' , '1' , '' , 'nuovo-prodotto' ) 25/11/2022 05:06:27 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 '20465' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20464' 25/11/2022 05:06:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20465' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20464' 25/11/2022 05:07:15 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' , '2022-DL003569' , '2022-11-24' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.90' , '171.90' , NOW() , NOW() ) 25/11/2022 05:07:15 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 = '74896' 25/11/2022 05:07:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '74896' 25/11/2022 05:07:15 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 ( '74896' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '1' , '4' , '90.00' , '90' , '0' , '35' , '58.5000' ) 25/11/2022 05:07:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 25/11/2022 05:07:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 25/11/2022 05:07:15 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 ( '74896' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '2' , '2' , '4' , '15.00' , '15' , '0' , '45' , '16.5000' ) 25/11/2022 05:07:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20464' AND id_supplier = '79' 25/11/2022 05:07:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20464' , '79' , '1' ) 25/11/2022 05:07:15 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 ( '74896' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '1' , '4' , '27.00' , '27' , '0' , '30' , '18.9000' ) 25/11/2022 05:07:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '79' 25/11/2022 05:07:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '79' , '1' ) 25/11/2022 05:07:15 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 ( '74896' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 25/11/2022 05:07:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '79' 25/11/2022 05:07:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '79' , '1' ) 25/11/2022 05:07:15 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 ( '74896' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 25/11/2022 05:07:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '79' 25/11/2022 05:07:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '79' , '1' ) 25/11/2022 05:24:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 05:24:02 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' , '3628' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '215.00' , '176.23' , NOW() , NOW() ) 25/11/2022 05:24:02 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 = '74897' 25/11/2022 05:24:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '74897' 25/11/2022 05:24:02 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 ( '74897' , '7202' , 'ARTICOLI RELIGIOSI' , '60' , '-60' , '1' , '2.9' , '2.3770491803279' , '22' , '0' , '174.00' ) 25/11/2022 05:24:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 05:24:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 05:24:02 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 ( '74897' , '13506' , 'SANTO ROSARIO' , '60' , '-60' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '18.00' ) 25/11/2022 05:24:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 25/11/2022 05:24:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 25/11/2022 05:24:02 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 ( '74897' , '7202' , 'ARTICOLI RELIGIOSI' , '60' , '-60' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '18.00' ) 25/11/2022 05:24:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 05:24:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 05:24:02 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 ( '74897' , '7202' , 'ARTICOLI RELIGIOSI' , '50' , '-50' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '5.00' ) 25/11/2022 05:24:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 05:24:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 06:05:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '74897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 06:05:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3628', document_date = '2022-11-25', 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 = '215.00', price_tax_excluded = '176.23', date_upd = NOW() WHERE id_document = '74897' 25/11/2022 06:05:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74897' 25/11/2022 06:05:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '74897' 25/11/2022 06:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '13506' , 'SANTO ROSARIO' , '60' , '-60' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '18.00' ) 25/11/2022 06:05:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 25/11/2022 06:05:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 25/11/2022 06:05:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 25/11/2022 06:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 06:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 06:05:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '13363' , 'CORONA MM 6 ' , '60' , '-60' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '174.00' ) 25/11/2022 06:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13363' AND id_supplier = '' 25/11/2022 06:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13363' , '' , '1' ) 25/11/2022 06:05:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '13365' , 'SCATOLA 6x4' , '60' , '-60' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '15.00' ) 25/11/2022 06:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13365' AND id_supplier = '' 25/11/2022 06:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13365' , '' , '1' ) 25/11/2022 06:08:10 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 25/11/2022 06:08:10 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '171' , '1' ) 25/11/2022 06:08:10 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '171' , '1' ) 25/11/2022 06:08:10 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '171' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 25/11/2022 06:10:13 pm >> UPDATE ps_address SET id_state = '210', lastname = 'FRANCESCO D\'AMATO EDITORE', address1 = 'VIA ALFONSO ALBANESE 26', address2 = '', postcode = '84010', dni = '', vat_number = '', city = 'SANT\'EGIDIO DEL MONTALBINO', phone = '', phone_mobile = '3357855232', date_upd = NOW() WHERE id_supplier = '171' 25/11/2022 06:10:13 pm >> UPDATE ps_supplier SET email = '', name = 'FRANCESCO D\'AMATO EDITORE', date_upd = NOW() WHERE id_supplier = '171' 25/11/2022 06:10:13 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '171' 25/11/2022 06:16:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3597' AND id_document != '74858' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-24') 25/11/2022 06:16:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3597', document_date = '2022-11-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 = '0', id_causal = '0', price_tax_included = '28.00', price_tax_excluded = '28.00', date_upd = NOW() WHERE id_document = '74858' 25/11/2022 06:16:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74858' 25/11/2022 06:16:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '74858' 25/11/2022 06:16:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74858' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '800' , '-800' , '4' , '0.0300' , '0.03' , '0' , '0' , '24.00' ) 25/11/2022 06:16:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 25/11/2022 06:16:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 25/11/2022 06:16: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 ( '74858' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 25/11/2022 06:16:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '' 25/11/2022 06:16:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '' , '1' ) 25/11/2022 06:46:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 06:46:53 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' , '3629' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 25/11/2022 06:46:53 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 = '74898' 25/11/2022 06:46:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '74898' 25/11/2022 06:46:53 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 ( '74898' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 25/11/2022 06:46:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 25/11/2022 06:46:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 25/11/2022 06:49:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 25/11/2022 06:49:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3630' , '2022-11-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '6.89' , NOW() , NOW() ) 25/11/2022 06:49:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74899' 25/11/2022 06:49:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '74899' 25/11/2022 06:49:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74899' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '5.60' ) 25/11/2022 06:49:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 25/11/2022 06:49:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 25/11/2022 06:49:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74899' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '2' , '-2' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '2.80' ) 25/11/2022 06:49:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 25/11/2022 06:49:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 25/11/2022 07:25:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3492' AND id_document != '73172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 25/11/2022 07:25:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3492', document_date = '2022-11-17', 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 = '129.80', price_tax_excluded = '113.24', date_upd = NOW() WHERE id_document = '73172' 25/11/2022 07:25:26 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 = '73172' 25/11/2022 07:25:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '73172' 25/11/2022 07:25:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73172' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 25/11/2022 07:25:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 25/11/2022 07:25:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 25/11/2022 07:25:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73172' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 25/11/2022 07:25:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/11/2022 07:25:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/11/2022 07:25:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73172' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 25/11/2022 07:25:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 25/11/2022 07:25:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 25/11/2022 07:25:27 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 ( '73172' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 25/11/2022 07:25:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 25/11/2022 07:25:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 25/11/2022 07:25:27 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 ( '73172' , '5854' , 'LIBRO DELLE NOVENE N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 25/11/2022 07:25:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5854' AND id_supplier = '' 25/11/2022 07:25:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5854' , '' , '1' ) 25/11/2022 07:25:27 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 ( '73172' , '20108' , 'AVVENTO 2022' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 25/11/2022 07:25:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20108' AND id_supplier = '' 25/11/2022 07:25:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20108' , '' , '1' ) 25/11/2022 07:26:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3426' AND id_document != '72041' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-11') 25/11/2022 07:26:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3426', document_date = '2022-11-11', 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 = '7.50', price_tax_excluded = '7.35', date_upd = NOW() WHERE id_document = '72041' 25/11/2022 07:26:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '72041' 25/11/2022 07:26:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '72041' 25/11/2022 07:26:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72041' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/11/2022 07:26:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 25/11/2022 07:26:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 25/11/2022 07:26:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72041' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 25/11/2022 07:26:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 25/11/2022 07:26:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 25/11/2022 07:26:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72041' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '3' , '-3' , '4' , '0.50' , '0.5' , '0' , '0' , '1.50' ) 25/11/2022 07:26:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 25/11/2022 07:26:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' )