01/12/2022 08:18:58 am >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '74864' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 01/12/2022 08:18:58 am >> UPDATE ps_document SET id_document_type = '21', document_num = '313', document_date = '2022-11-25', document_letter = '', id_customer = '1175', id_supplier = '', id_address = '4672789', address1 = 'VIA 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 = '1', id_causal = '0', price_tax_included = '74.38', price_tax_excluded = '74.38', date_upd = NOW() WHERE id_document = '74864' 01/12/2022 08:18:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74864' 01/12/2022 08:18:58 am >> DELETE FROM ps_document_detail WHERE id_document = '74864' 01/12/2022 08:18:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74864' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 01/12/2022 08:18:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 01/12/2022 08:18:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 01/12/2022 09:32:24 am >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 09:32:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '131' , '2022-12-01' , '' , '7017' , '0' , '107350741' , 'via chiesa , 2 81016 piedimonte matese' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '41.10' , '41.10' , NOW() , NOW() ) 01/12/2022 09:32:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '9233' 01/12/2022 09:32:24 am >> DELETE FROM ps_document_detail WHERE id_document = '9233' 01/12/2022 09:32:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9233' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 01/12/2022 09:44:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3687' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 09:44:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3687' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.35' , '69.65' , NOW() , NOW() ) 01/12/2022 09:44:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75486' 01/12/2022 09:44:14 am >> DELETE FROM ps_document_detail WHERE id_document = '75486' 01/12/2022 09:44: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 ( '75486' , '12919' , 'CONFEZIONE CARTONCINO CON BAMBINO - P422' , '120' , '-120' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '72.00' ) 01/12/2022 09:44:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '12919' AND id_supplier = '' 01/12/2022 09:44:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12919' , '' , '1' ) 01/12/2022 09:44: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 ( '75486' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 01/12/2022 09:44:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '17350' AND id_supplier = '' 01/12/2022 09:44:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17350' , '' , '1' ) 01/12/2022 09:44: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 ( '75486' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 01/12/2022 09:44:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 01/12/2022 09:44:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 01/12/2022 10:00:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3688' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 10:00:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3688' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '17.32' , NOW() , NOW() ) 01/12/2022 10:00:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75487' 01/12/2022 10:00:26 am >> DELETE FROM ps_document_detail WHERE id_document = '75487' 01/12/2022 10:00:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75487' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '10' , '-10' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '3.50' ) 01/12/2022 10:00:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '941' AND id_supplier = '' 01/12/2022 10:00:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '941' , '' , '1' ) 01/12/2022 10:00:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75487' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 01/12/2022 10:00:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 01/12/2022 10:00:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 01/12/2022 10:00:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75487' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 01/12/2022 10:00:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 01/12/2022 10:00:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 01/12/2022 10:11:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '616735' , '2022-11-29' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '11.28' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '384.91' , '384.91' , NOW() , NOW() ) 01/12/2022 10:11:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75488' 01/12/2022 10:11:24 am >> DELETE FROM ps_document_detail WHERE id_document = '75488' 01/12/2022 10:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75488' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '2' , '2' , '4' , '9.00' , '9' , '0' , '30+7' , '11.7180' ) 01/12/2022 10:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '17713' AND id_supplier = '7' 01/12/2022 10:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17713' , '7' , '1' ) 01/12/2022 10:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75488' , '14642' , 'FIDES ET RATIO - GIOVANNI PAOLO II' , '1' , '1' , '4' , '4.00' , '4' , '0' , '33' , '2.6800' ) 01/12/2022 10:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '14642' AND id_supplier = '7' 01/12/2022 10:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14642' , '7' , '1' ) 01/12/2022 10:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75488' , '14738' , 'FIGURE DELLAVVENTO - F. PIAZZOLLA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 01/12/2022 10:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '14738' AND id_supplier = '7' 01/12/2022 10:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14738' , '7' , '1' ) 01/12/2022 10:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75488' , '18776' , 'GESU A COLORI' , '5' , '5' , '4' , '8.90' , '8.9' , '0' , '30' , '31.1500' ) 01/12/2022 10:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18776' AND id_supplier = '7' 01/12/2022 10:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18776' , '7' , '1' ) 01/12/2022 10:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75488' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '36' , '36' , '4' , '1.60' , '1.6' , '0' , '30' , '40.3200' ) 01/12/2022 10:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '14649' AND id_supplier = '7' 01/12/2022 10:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14649' , '7' , '1' ) 01/12/2022 10:11:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75488' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '3' , '3' , '4' , '1.60' , '1.6' , '0' , '100' , '0.0000' ) 01/12/2022 10:11:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '14649' AND id_supplier = '7' 01/12/2022 10:11:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14649' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '10748' , 'TU MI CHIAMI PER NOME' , '12' , '12' , '4' , '5.90' , '5.9' , '0' , '30+7' , '46.0908' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '1' , '4' , '5.90' , '5.9' , '0' , '100' , '0.0000' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '10751' , 'TU MI PERDONI' , '24' , '24' , '4' , '5.90' , '5.9' , '0' , '30+7' , '92.1816' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '10751' , 'TU MI PERDONI' , '2' , '2' , '4' , '5.90' , '5.9' , '0' , '100' , '0.0000' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '14719' , 'TU MI AMI DAVVERO' , '24' , '24' , '4' , '5.90' , '5.9' , '0' , '30+7' , '92.1816' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '14719' , 'TU MI AMI DAVVERO' , '2' , '2' , '4' , '5.90' , '5.9' , '0' , '100' , '0.0000' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '19043' , 'HA VINTO IL TUO AMORE - AGG. CANTI' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '30' , '4.9000' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19043' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19043' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '8702' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8702' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17242' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17242' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '20462' , 'ASCOLTARLO ERA RIMANERE ACCESI - E. RONCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '20462' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20462' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '7' , '1' ) 01/12/2022 10:11: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 ( '75488' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 01/12/2022 10:11:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '7' 01/12/2022 10:11:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '7' , '1' ) 01/12/2022 10:18:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3689' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 10:18:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3689' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.50' , '75.00' , NOW() , NOW() ) 01/12/2022 10:18:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75489' 01/12/2022 10:18:54 am >> DELETE FROM ps_document_detail WHERE id_document = '75489' 01/12/2022 10:18:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75489' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 01/12/2022 10:18:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '8053' AND id_supplier = '' 01/12/2022 10:18:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8053' , '' , '1' ) 01/12/2022 10:18:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75489' , '6008' , 'LUMINELLI AD OLIO - 1021C' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 01/12/2022 10:18:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '6008' AND id_supplier = '' 01/12/2022 10:18:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6008' , '' , '1' ) 01/12/2022 10:28:27 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/12/2022 10:28:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20472' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 10:28:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20472' , '1' , '1' , '2' , NOW() , NOW() ) 01/12/2022 10:28:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20472' , '0' , '1' , '0' , '0' ) 01/12/2022 10:29:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229945' AND id_product != '20472' AND ean13 != '' 01/12/2022 10:29:20 am >> UPDATE ps_product SET id_supplier = '', reference = '11/5', ean13 = '9788892229945', date_upd = NOW() WHERE id_product = '20472' 01/12/2022 10:29:20 am >> UPDATE ps_product_lang SET name = 'CAMMINARE NELLA LUCE - L. MONTI', description = '' WHERE id_product = '20472' 01/12/2022 10:29:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20472' 01/12/2022 10:29:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20472' 01/12/2022 10:29:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20472' 01/12/2022 10:29:22 am >> 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 = '20472' 01/12/2022 10:29:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20473' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 10:29:22 am >> 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 '20473' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20472' 01/12/2022 10:29:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20473' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20472' 01/12/2022 10:30:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068153' AND id_product != '20473' AND ean13 != '' 01/12/2022 10:30:35 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788801068153', date_upd = NOW() WHERE id_product = '20473' 01/12/2022 10:30:35 am >> UPDATE ps_product_lang SET name = 'GLI ANGELI CI PROTEGGONO', description = '' WHERE id_product = '20473' 01/12/2022 10:30:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '20473' 01/12/2022 10:30:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20473' 01/12/2022 10:30:35 am >> DELETE FROM ps_specific_price WHERE id_product = '20473' 01/12/2022 10:30:37 am >> 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 = '20473' 01/12/2022 10:30:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20474' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 10:30:37 am >> 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 '20474' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20473' 01/12/2022 10:30:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20474' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20473' 01/12/2022 10:30:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '616680' , '2022-11-28' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.68' , '15.68' , NOW() , NOW() ) 01/12/2022 10:30:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75490' 01/12/2022 10:30:49 am >> DELETE FROM ps_document_detail WHERE id_document = '75490' 01/12/2022 10:30:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75490' , '20472' , 'CAMMINARE NELLA LUCE - L. MONTI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 01/12/2022 10:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '20472' AND id_supplier = '7' 01/12/2022 10:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20472' , '7' , '1' ) 01/12/2022 10:30:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75490' , '20473' , 'GLI ANGELI CI PROTEGGONO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '35' , '2.2750' ) 01/12/2022 10:30:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '20473' AND id_supplier = '7' 01/12/2022 10:30:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20473' , '7' , '1' ) 01/12/2022 10:39:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '75459' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 01/12/2022 10:39:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3667', document_date = '2022-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '175.00', price_tax_excluded = '143.44', date_upd = NOW() WHERE id_document = '75459' 01/12/2022 10:39:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75459' 01/12/2022 10:39:12 am >> DELETE FROM ps_document_detail WHERE id_document = '75459' 01/12/2022 10:39:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75459' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 01/12/2022 10:39:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 01/12/2022 10:39:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 01/12/2022 10:39:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75459' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 01/12/2022 10:39:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 01/12/2022 10:39:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 01/12/2022 10:47:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3690' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 10:47:18 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' , '3690' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.66' , NOW() , NOW() ) 01/12/2022 10:47:18 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 = '75491' 01/12/2022 10:47:18 am >> DELETE FROM ps_document_detail WHERE id_document = '75491' 01/12/2022 10:47:18 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 ( '75491' , '452' , 'AMIAMO - SEGNALIBRO 145' , '100' , '-100' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '13.00' ) 01/12/2022 10:47:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '452' AND id_supplier = '' 01/12/2022 10:47:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '452' , '' , '1' ) 01/12/2022 10:47:18 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 ( '75491' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 01/12/2022 10:47:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 01/12/2022 10:47:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 01/12/2022 10:50:05 am >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 10:50:05 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' , '319' , '2022-12-01' , '' , '2021' , '0' , '4672489' , 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '268.60' , '268.60' , NOW() , NOW() ) 01/12/2022 10:50:05 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 = '75492' 01/12/2022 10:50:05 am >> DELETE FROM ps_document_detail WHERE id_document = '75492' 01/12/2022 10:50:05 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 ( '75492' , '2679' , 'CONOSCERE GESU\'' , '80' , '-80' , '4' , '3.50' , '3.5' , '0' , '15' , '238.00' ) 01/12/2022 10:50:05 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 ( '75492' , '2680' , 'CONOSCERE GESU - GUIDA' , '6' , '-6' , '4' , '6.00' , '6' , '0' , '15' , '30.60' ) 01/12/2022 11:02:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3691' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 11:02: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' , '3691' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '199.70' , NOW() , NOW() ) 01/12/2022 11:02: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 = '75493' 01/12/2022 11:02:09 am >> DELETE FROM ps_document_detail WHERE id_document = '75493' 01/12/2022 11:02: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 ( '75493' , '18894' , 'GESU BAMBINO BETLEMME ' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 01/12/2022 11:02:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18894' AND id_supplier = '' 01/12/2022 11:02:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18894' , '' , '1' ) 01/12/2022 11:02:10 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 ( '75493' , '19072' , 'BAMBINELLO CM 37 - PB9257' , '1' , '-1' , '1' , '82' , '67.213114754098' , '22' , '' , '82.00' ) 01/12/2022 11:02:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19072' AND id_supplier = '' 01/12/2022 11:02:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19072' , '' , '1' ) 01/12/2022 11:02:10 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 ( '75493' , '18885' , 'BAMBINELLO CM 23 - PB9942' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 01/12/2022 11:02:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18885' AND id_supplier = '' 01/12/2022 11:02:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18885' , '' , '1' ) 01/12/2022 11:02:10 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 ( '75493' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '200' , '-200' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '40.00' ) 01/12/2022 11:02:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 01/12/2022 11:02:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 01/12/2022 11:02:10 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 ( '75493' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/12/2022 11:02:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 01/12/2022 11:02:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 01/12/2022 11:02:10 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 ( '75493' , '10475' , 'TEALIGHTS X 50 ' , '20' , '-20' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '70.00' ) 01/12/2022 11:02:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '10475' AND id_supplier = '' 01/12/2022 11:02:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10475' , '' , '1' ) 01/12/2022 11:08:38 am >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '75492' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 11:08:38 am >> UPDATE ps_document SET id_document_type = '21', document_num = '319', document_date = '2022-12-01', document_letter = '', id_customer = '2021', id_supplier = '', id_address = '4672489', address1 = 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO', 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 = '378.09', price_tax_excluded = '378.09', date_upd = NOW() WHERE id_document = '75492' 01/12/2022 11:08:38 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 = '75492' 01/12/2022 11:08:38 am >> DELETE FROM ps_document_detail WHERE id_document = '75492' 01/12/2022 11:08:38 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 ( '75492' , '2679' , 'CONOSCERE GESU\'' , '75' , '-75' , '4' , '3.5000' , '3.5' , '0' , '15' , '223.13' ) 01/12/2022 11:08:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 01/12/2022 11:08:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 01/12/2022 11:08:38 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 ( '75492' , '2680' , 'CONOSCERE GESU - GUIDA' , '6' , '-6' , '4' , '6.0000' , '6' , '0' , '15' , '30.60' ) 01/12/2022 11:08:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 01/12/2022 11:08:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 01/12/2022 11:08:38 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 ( '75492' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '77' , '-77' , '4' , '1.90' , '1.9' , '0' , '15' , '124.36' ) 01/12/2022 11:08:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 01/12/2022 11:08:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 01/12/2022 11:10:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3692' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 11:10:56 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' , '3692' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.43' , '53.96' , NOW() , NOW() ) 01/12/2022 11:10:56 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 = '75494' 01/12/2022 11:10:56 am >> DELETE FROM ps_document_detail WHERE id_document = '75494' 01/12/2022 11:10:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75494' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 01/12/2022 11:10:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 01/12/2022 11:10:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 01/12/2022 11:10:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75494' , '17359' , 'SGUARDO DI UN AMORE CHE E DONO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 01/12/2022 11:10:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '17359' AND id_supplier = '' 01/12/2022 11:10:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17359' , '' , '1' ) 01/12/2022 11:10:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75494' , '17464' , 'NOVENA DELLIMMACOLATA CON SANTINA CAMPANA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 01/12/2022 11:10:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '17464' AND id_supplier = '' 01/12/2022 11:10:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17464' , '' , '1' ) 01/12/2022 11:10:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75494' , '19996' , 'GESU BAMBINO CM 34 - BJ142-34E' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 01/12/2022 11:10:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19996' AND id_supplier = '' 01/12/2022 11:10:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19996' , '' , '1' ) 01/12/2022 11:23:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3693' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 11:23: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' , '3693' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 01/12/2022 11:23: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 = '75495' 01/12/2022 11:23:16 am >> DELETE FROM ps_document_detail WHERE id_document = '75495' 01/12/2022 11:23: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 ( '75495' , '19430' , 'QUADRO DECORATO 50X35 - R35' , '1' , '-1' , '1' , '95' , '77.868852459016' , '22' , '0' , '95.00' ) 01/12/2022 11:23:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19430' AND id_supplier = '' 01/12/2022 11:23:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19430' , '' , '1' ) 01/12/2022 11:34:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3694' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 11:34:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3694' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.30' , '9.21' , NOW() , NOW() ) 01/12/2022 11:34:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75496' 01/12/2022 11:34:15 am >> DELETE FROM ps_document_detail WHERE id_document = '75496' 01/12/2022 11:34:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75496' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/12/2022 11:34:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 01/12/2022 11:34:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 01/12/2022 11:34:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75496' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 01/12/2022 11:34:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 01/12/2022 11:34:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 01/12/2022 11:34:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75496' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 01/12/2022 11:34:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/12/2022 11:34:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/12/2022 11:46:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 11:46:51 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' , '3695' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 01/12/2022 11:46:51 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 = '75497' 01/12/2022 11:46:51 am >> DELETE FROM ps_document_detail WHERE id_document = '75497' 01/12/2022 11:46:51 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 ( '75497' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 01/12/2022 11:46:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/12/2022 11:46:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/12/2022 12:00:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 12:00:52 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' , '3696' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.20' , '2.62' , NOW() , NOW() ) 01/12/2022 12:00:52 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 = '75498' 01/12/2022 12:00:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '75498' 01/12/2022 12:00:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75498' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '4' , '-4' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '3.20' ) 01/12/2022 12:00:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5105' AND id_supplier = '' 01/12/2022 12:00:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5105' , '' , '1' ) 01/12/2022 12:14:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 12:14:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3697' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.50' , '45.15' , NOW() , NOW() ) 01/12/2022 12:14:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75499' 01/12/2022 12:14:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '75499' 01/12/2022 12:14:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75499' , '7673' , 'PARTICOLE MM38' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 01/12/2022 12:14:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 01/12/2022 12:14:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 01/12/2022 12:14:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75499' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '2.3' , '2.3' , '0' , '0' , '11.50' ) 01/12/2022 12:14:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 01/12/2022 12:14:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 01/12/2022 12:16:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 12:16:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3698' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 01/12/2022 12:16:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75500' 01/12/2022 12:16:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '75500' 01/12/2022 12: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 ( '75500' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 01/12/2022 12:16:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 01/12/2022 12:16:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 01/12/2022 12:18:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240308' AND id_product != '20474' AND ean13 != '' 01/12/2022 12:18:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788892240308', date_upd = NOW() WHERE id_product = '20474' 01/12/2022 12:18:54 pm >> UPDATE ps_product_lang SET name = 'sfrontati e impertinenti cercatori di dio - r. fusco', description = '' WHERE id_product = '20474' 01/12/2022 12:18:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20474' 01/12/2022 12:18:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20474' 01/12/2022 12:18:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '20474' 01/12/2022 12:18:56 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 = '20474' 01/12/2022 12:18:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20475' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 12:18:56 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 '20475' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20474' 01/12/2022 12:18:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20475' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20474' 01/12/2022 12:20:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240308' AND id_product != '20474' AND ean13 != '' 01/12/2022 12:20:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788892240308', date_upd = NOW() WHERE id_product = '20474' 01/12/2022 12:20:44 pm >> UPDATE ps_product_lang SET name = 'SFRONTATI E IMPERTINENTI CERCATORI DI DIO - R. FUSCO', description = '' WHERE id_product = '20474' 01/12/2022 12:20:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.0000' WHERE id_product = '20474' 01/12/2022 12:20:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20474' 01/12/2022 12:20:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '20474' 01/12/2022 12:21:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240377' AND id_product != '20475' AND ean13 != '' 01/12/2022 12:21:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788892240377', date_upd = NOW() WHERE id_product = '20475' 01/12/2022 12:21:50 pm >> UPDATE ps_product_lang SET name = '50 DOMANDE A DIO - G. BIADER', description = '' WHERE id_product = '20475' 01/12/2022 12:21:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20475' 01/12/2022 12:21:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20475' 01/12/2022 12:21:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20475' 01/12/2022 12:21:51 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 = '20475' 01/12/2022 12:21:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20476' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 12:21:51 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 '20476' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20475' 01/12/2022 12:21:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20476' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20475' 01/12/2022 12:23:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934475' AND id_product != '20476' AND ean13 != '' 01/12/2022 12:23:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934475', date_upd = NOW() WHERE id_product = '20476' 01/12/2022 12:23:00 pm >> UPDATE ps_product_lang SET name = 'NON GUARDARE AI NOSTRI PECCATI - B.P. FLANAGAN', description = '' WHERE id_product = '20476' 01/12/2022 12:23:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '20476' 01/12/2022 12:23:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20476' 01/12/2022 12:23:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '20476' 01/12/2022 12:23:01 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 = '20476' 01/12/2022 12:23:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20477' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 12:23:01 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 '20477' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20476' 01/12/2022 12:23:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20477' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20476' 01/12/2022 12:24:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247629' AND id_product != '20477' AND ean13 != '' 01/12/2022 12:24:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788884247629', date_upd = NOW() WHERE id_product = '20477' 01/12/2022 12:24:02 pm >> UPDATE ps_product_lang SET name = 'VERITA\' E MENZOGNE - FULTON J. SHEEN', description = '' WHERE id_product = '20477' 01/12/2022 12:24:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20477' 01/12/2022 12:24:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20477' 01/12/2022 12:24:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '20477' 01/12/2022 12:24:03 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20477' 01/12/2022 12:24:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20478' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 12:24:03 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20478' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20477' 01/12/2022 12:24:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20478' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20477' 01/12/2022 12:24:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885589940' AND id_product != '20478' AND ean13 != '' 01/12/2022 12:24:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788885589940', date_upd = NOW() WHERE id_product = '20478' 01/12/2022 12:24:53 pm >> UPDATE ps_product_lang SET name = 'PANE QUOTIDIANO - GEN FEB 2023', description = '' WHERE id_product = '20478' 01/12/2022 12:24:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '20478' 01/12/2022 12:24:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '343', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20478' 01/12/2022 12:24:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20478' 01/12/2022 12:24:54 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 = '20478' 01/12/2022 12:24:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20479' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 12:24:54 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 '20479' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20478' 01/12/2022 12:24:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20479' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20478' 01/12/2022 12:25:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739455953' AND id_product != '20479' AND ean13 != '' 01/12/2022 12:25:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739455953', date_upd = NOW() WHERE id_product = '20479' 01/12/2022 12:25:39 pm >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - FEB 2023', description = '' WHERE id_product = '20479' 01/12/2022 12:25:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '20479' 01/12/2022 12:25:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20479' 01/12/2022 12:25:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '20479' 01/12/2022 12:25:39 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20479' 01/12/2022 12:25:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20480' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 12:25:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20480' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20479' 01/12/2022 12:25:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20480' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20479' 01/12/2022 12:25:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739456073' AND id_product != '20480' AND ean13 != '' 01/12/2022 12:25:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739456073', date_upd = NOW() WHERE id_product = '20480' 01/12/2022 12:25:59 pm >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - FEB 2023', description = '' WHERE id_product = '20480' 01/12/2022 12:25:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20480' 01/12/2022 12:25:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20480' 01/12/2022 12:25:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '20480' 01/12/2022 12:26:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739456073' AND id_product != '20480' AND ean13 != '' 01/12/2022 12:26:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739456073', date_upd = NOW() WHERE id_product = '20480' 01/12/2022 12:26:09 pm >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - FEB 2023', description = '' WHERE id_product = '20480' 01/12/2022 12:26:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '20480' 01/12/2022 12:26:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20480' 01/12/2022 12:26:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '20480' 01/12/2022 12:26:10 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 = '20480' 01/12/2022 12:26:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20481' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 12:26:10 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 '20481' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20480' 01/12/2022 12:26:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20481' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20480' 01/12/2022 12:26:41 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '616680', document_date = '2022-11-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '2.55', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '77.18', price_tax_excluded = '77.18', date_upd = NOW() WHERE id_document = '75490' 01/12/2022 12:26: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 = '75490' 01/12/2022 12:26:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '75490' 01/12/2022 12:26: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 ( '75490' , '20472' , 'CAMMINARE NELLA LUCE - L. MONTI' , '1' , '1' , '4' , '20.0000' , '20' , '0' , '33' , '13.40' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20472' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20472' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20473' , 'GLI ANGELI CI PROTEGGONO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '35' , '2.28' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20473' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20473' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20474' , 'SFRONTATI E IMPERTINENTI CERCATORI DI DIO - R. FUSCO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20474' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20474' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20475' , '50 DOMANDE A DIO - G. BIADER' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35' , '10.4000' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20475' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20475' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20476' , 'NON GUARDARE AI NOSTRI PECCATI - B.P. FLANAGAN' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20476' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20476' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20477' , 'VERITA E MENZOGNE - FULTON J. SHEEN' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20477' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20477' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20478' , 'PANE QUOTIDIANO - GEN FEB 2023' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20478' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20478' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20479' , 'PAROLA E PREGHIERA - FEB 2023' , '3' , '3' , '4' , '2.90' , '2.9' , '0' , '33' , '5.8290' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20479' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20479' , '' , '1' ) 01/12/2022 12:26: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 ( '75490' , '20480' , 'INSIEME NELLA MESSA - FEB 2023' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 01/12/2022 12:26:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20480' AND id_supplier = '' 01/12/2022 12:26:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20480' , '' , '1' ) 01/12/2022 12:38:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '000' , '2022-11-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , 'DA CORREGGERE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1745.00' , '1745.00' , NOW() , NOW() ) 01/12/2022 12:38: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 = '75501' 01/12/2022 12:38:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '75501' 01/12/2022 12:38: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 ( '75501' , '5444' , 'IO SONO CON VOI - CAT.' , '100' , '100' , '4' , '5.50' , '5.5' , '0' , '0' , '550.0000' ) 01/12/2022 12:38:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 01/12/2022 12:38:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 01/12/2022 12:38: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 ( '75501' , '11193' , 'VENITE CON ME CAT.' , '100' , '100' , '4' , '5.50' , '5.5' , '0' , '0' , '550.0000' ) 01/12/2022 12:38:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 01/12/2022 12:38:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 01/12/2022 12:38: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 ( '75501' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '100' , '100' , '4' , '5.50' , '5.5' , '0' , '0' , '550.0000' ) 01/12/2022 12:38:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '79' 01/12/2022 12:38:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '79' , '1' ) 01/12/2022 12:38: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 ( '75501' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '0' , '35.00' ) 01/12/2022 12:38:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 01/12/2022 12:38:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 01/12/2022 12:38: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 ( '75501' , '5765' , 'LEZIONARIO FERIALE TEMPI FORTI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 01/12/2022 12:38:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5765' AND id_supplier = '79' 01/12/2022 12:38:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5765' , '79' , '1' ) 01/12/2022 12:43:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '75492' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 12:43:18 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '319', document_date = '2022-12-01', document_letter = '', id_customer = '2021', id_supplier = '', id_address = '4672489', address1 = 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO', 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 = '378.09', price_tax_excluded = '378.09', date_upd = NOW() WHERE id_document = '75492' 01/12/2022 12:43:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75492' 01/12/2022 12:43:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '75492' 01/12/2022 12:43:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75492' , '2679' , 'CONOSCERE GESU\'' , '75' , '-75' , '4' , '3.5000' , '3.5' , '0' , '15' , '223.13' ) 01/12/2022 12:43:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 01/12/2022 12:43:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 01/12/2022 12:43:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75492' , '2680' , 'CONOSCERE GESU - GUIDA' , '6' , '-6' , '4' , '6.0000' , '6' , '0' , '15' , '30.60' ) 01/12/2022 12:43:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 01/12/2022 12:43:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 01/12/2022 12:43:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75492' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '77' , '-77' , '4' , '1.9000' , '1.9' , '0' , '15' , '124.36' ) 01/12/2022 12:43:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 01/12/2022 12:43:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 01/12/2022 12:59:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3613' AND id_document != '74877' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 01/12/2022 12:59:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3613', 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 = '78.20', price_tax_excluded = '70.81', date_upd = NOW() WHERE id_document = '74877' 01/12/2022 12:59:46 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 = '74877' 01/12/2022 12:59:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '74877' 01/12/2022 12:59:46 pm >> INSERT INTO ps_document_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.5000' , '5.327868852459' , '22' , '0' , '26.00' ) 01/12/2022 12:59:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 01/12/2022 12:59:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 01/12/2022 12:59: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 ( '74877' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '50' , '-50' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '15.00' ) 01/12/2022 12:59:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '942' AND id_supplier = '' 01/12/2022 12:59:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '942' , '' , '1' ) 01/12/2022 12:59: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 ( '74877' , '6629' , 'MIA PREGHIERA' , '10' , '-10' , '4' , '0.9000' , '0.9' , '0' , '5' , '8.60' ) 01/12/2022 12:59:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 01/12/2022 12:59:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 01/12/2022 12:59: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 ( '74877' , '18357' , 'MIE PREGHIERINE N.E.' , '20' , '-20' , '4' , '1.5000' , '1.5' , '0' , '5' , '28.60' ) 01/12/2022 12:59:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 01/12/2022 12:59:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 01/12/2022 02:27:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3640' AND id_document != '75427' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-28') 01/12/2022 02:27:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3640', document_date = '2022-11-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '75427' 01/12/2022 02:27:04 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 = '75427' 01/12/2022 02:27:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '75427' 01/12/2022 02:27:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75427' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 01/12/2022 02:27:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 01/12/2022 02:27:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 01/12/2022 02:39:12 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7017' 01/12/2022 02:39:12 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7017' , '10' , '145' , 'parrocchia San Marcello e San Michele' , 'meola' , 'emilio angelo' , 'via chiesa 2' , '' , '81016' , 'piedimonte matese' , '' , '' , '3496419105' , '' , '' , NOW() , NOW() ) 01/12/2022 02:39:12 pm >> UPDATE ps_customer SET email = 'emiliomeola@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7017' 01/12/2022 02:42:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 02:42:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3699' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.70' , '6.70' , NOW() , NOW() ) 01/12/2022 02:42:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75502' 01/12/2022 02:42:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '75502' 01/12/2022 02:42: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 ( '75502' , '19043' , 'HA VINTO IL TUO AMORE - AGG. CANTI' , '2' , '-2' , '4' , '3.35' , '3.35' , '0' , '0' , '6.70' ) 01/12/2022 02:42:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19043' AND id_supplier = '' 01/12/2022 02:42:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19043' , '' , '1' ) 01/12/2022 03:29:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 03:29:28 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' , '3700' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 01/12/2022 03:29:28 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 = '75503' 01/12/2022 03:29:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '75503' 01/12/2022 03:29:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75503' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 01/12/2022 03:29:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 01/12/2022 03:29:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 01/12/2022 03:51:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 03:51: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 ( '24' , '105/A' , '2022-12-01' , 'A' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , 'sordina' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2700.00' , '2213.11' , NOW() , NOW() ) 01/12/2022 03:51: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 = '75504' 01/12/2022 03:51:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '75504' 01/12/2022 03:51: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 ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700' , '2213.1147540984' , '22' , '0' , '2700.00' ) 01/12/2022 04:03:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 04:03: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' , '3701' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/12/2022 04:03: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 = '75505' 01/12/2022 04:03:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '75505' 01/12/2022 04:03: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 ( '75505' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/12/2022 04:03:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 01/12/2022 04:03:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 01/12/2022 04:31:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 04:31:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3702' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 01/12/2022 04:31:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75506' 01/12/2022 04:31:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '75506' 01/12/2022 04:31:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75506' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 01/12/2022 04:31:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 01/12/2022 04:31:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 01/12/2022 04:43:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 04:43:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3703' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '13.52' , NOW() , NOW() ) 01/12/2022 04:43:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75507' 01/12/2022 04:43:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '75507' 01/12/2022 04:43:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75507' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '16.50' ) 01/12/2022 04:43:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 01/12/2022 04:43:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 01/12/2022 05:06:54 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'TZs8fpRpq9rq5EsT' , NOW() , NOW() ) 01/12/2022 05:06:54 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3984' , '1' ) 01/12/2022 05:06:54 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3984' , '2' ) 01/12/2022 05:06:54 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3984' , '3' ) 01/12/2022 05:08:31 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3984' 01/12/2022 05:08:31 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 ( '3984' , '10' , '210' , 'PARR. S. GIACOMO' , 'GALLO ' , 'DON VINCENZO ' , 'VIA M. ALETTA 1' , '' , '84030' , 'MONTE S. GIACOMO' , '' , '' , '3494248267' , '' , '' , NOW() , NOW() ) 01/12/2022 05:08:32 pm >> UPDATE ps_customer SET email = 'enzogallo@yahoo.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3984' 01/12/2022 05:09:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '320' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 05:09:10 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' , '320' , '2022-12-01' , '' , '3984' , '0' , '4677546' , 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.63' , '44.63' , NOW() , NOW() ) 01/12/2022 05:09:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75508' 01/12/2022 05:09:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '75508' 01/12/2022 05:09:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75508' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' , '-6' , '4' , '3.50' , '3.5' , '0' , '15' , '17.85' ) 01/12/2022 05:09:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75508' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '9' , '-9' , '4' , '3.50' , '3.5' , '0' , '15' , '26.78' ) 01/12/2022 05:10:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 05:10:21 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' , '3704' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.10' , '26.30' , NOW() , NOW() ) 01/12/2022 05:10:21 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 = '75509' 01/12/2022 05:10:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '75509' 01/12/2022 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75509' , '20243' , 'VIVA LA PARROCCHIA! ' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 01/12/2022 05:10:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20243' AND id_supplier = '' 01/12/2022 05:10:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20243' , '' , '1' ) 01/12/2022 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75509' , '16314' , 'BAMBINO CM 6' , '5' , '-5' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '8.50' ) 01/12/2022 05:10:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16314' AND id_supplier = '' 01/12/2022 05:10:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16314' , '' , '1' ) 01/12/2022 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75509' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 01/12/2022 05:10:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 01/12/2022 05:10:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 01/12/2022 05:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75509' , '4373' , 'GESÙ BAMBINO - 266' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 01/12/2022 05:10:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4373' AND id_supplier = '' 01/12/2022 05:10:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4373' , '' , '1' ) 01/12/2022 05:12:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '320' AND id_document != '75508' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 05:12:18 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '320', document_date = '2022-12-01', document_letter = '', id_customer = '3984', id_supplier = '', id_address = '4677546', address1 = 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO', 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 = '44.63', price_tax_excluded = '44.63', date_upd = NOW() WHERE id_document = '75508' 01/12/2022 05:12:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75508' 01/12/2022 05:12:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '75508' 01/12/2022 05:12: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 ( '75508' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '15' , '17.85' ) 01/12/2022 05:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 01/12/2022 05:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 01/12/2022 05:12: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 ( '75508' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '9' , '-9' , '4' , '3.5000' , '3.5' , '0' , '15' , '26.78' ) 01/12/2022 05:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 01/12/2022 05:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 01/12/2022 05:17:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 05:17:04 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 ( '23' , '17/L' , '2022-12-01' , 'L' , '2516' , '0' , '4673726' , 'VIA MARECHIARO, 96/A 80123 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '6.56' , '5.38' , NOW() , NOW() ) 01/12/2022 05:17:04 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 = '75510' 01/12/2022 05:17:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '75510' 01/12/2022 05:17:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75510' , '964' , 'BATTESIMO' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '5' , '6.56' ) 01/12/2022 05:18:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8017009003828' AND id_product != '150' AND ean13 != '' 01/12/2022 05:18:07 pm >> UPDATE ps_product SET id_supplier = '7', reference = '1/6', ean13 = '8017009003828', date_upd = NOW() WHERE id_product = '150' 01/12/2022 05:18:07 pm >> UPDATE ps_product_lang SET name = 'ABBRACCIO DEL PADRE PRIMA CONFESSIONE ', description = '' WHERE id_product = '150' 01/12/2022 05:18:07 pm >> UPDATE ps_product SET wholesale_price = '6.39', on_sale = '0', price = '11.3934' WHERE id_product = '150' 01/12/2022 05:18:07 pm >> UPDATE ps_product_shop SET wholesale_price = '6.39', price = '11.3934', id_tax_rules_group = '1', id_category_default = '19', id_argoment_default = '48', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '150' 01/12/2022 05:18:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '150' 01/12/2022 05:18:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/L' AND id_document != '75510' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 05:18:53 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '17/L', document_date = '2022-12-01', document_letter = 'L', id_customer = '2516', id_supplier = '', id_address = '4673726', address1 = 'VIA MARECHIARO, 96/A 80123 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '54.48', price_tax_excluded = '48.41', date_upd = NOW() WHERE id_document = '75510' 01/12/2022 05:18: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 = '75510' 01/12/2022 05:18:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '75510' 01/12/2022 05:18: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 ( '75510' , '964' , 'BATTESIMO' , '1' , '-1' , '1' , '6.9000' , '5.655737704918' , '22' , '5' , '6.56' ) 01/12/2022 05:18:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '964' AND id_supplier = '' 01/12/2022 05:18:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '964' , '' , '1' ) 01/12/2022 05:18: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 ( '75510' , '951' , 'BANCHETTO DELLA VITA PRIMA COMUNIONE - PER ANIMATORI E CATECHISTI' , '1' , '-1' , '1' , '13.90' , '11.393442622951' , '22' , '5' , '13.21' ) 01/12/2022 05:18:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '951' AND id_supplier = '' 01/12/2022 05:18:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '951' , '' , '1' ) 01/12/2022 05:18: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 ( '75510' , '2866' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 01/12/2022 05:18:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2866' AND id_supplier = '' 01/12/2022 05:18:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2866' , '' , '1' ) 01/12/2022 05:18: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 ( '75510' , '14488' , 'VANGELO DEI PICCOLI + DVD' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 01/12/2022 05:18:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14488' AND id_supplier = '' 01/12/2022 05:18:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14488' , '' , '1' ) 01/12/2022 05:18: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 ( '75510' , '150' , 'ABBRACCIO DEL PADRE PRIMA CONFESSIONE ' , '1' , '-1' , '1' , '13.90' , '11.393442622951' , '22' , '5' , '13.90' ) 01/12/2022 05:18:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '150' AND id_supplier = '' 01/12/2022 05:18:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '150' , '' , '1' ) 01/12/2022 05:58:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 05:58: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' , '3705' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.90' , '65.49' , NOW() , NOW() ) 01/12/2022 05:58: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 = '75511' 01/12/2022 05:58:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '75511' 01/12/2022 05:58: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 ( '75511' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '10' , '-10' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '75.00' ) 01/12/2022 05:58:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4696' AND id_supplier = '' 01/12/2022 05:58:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4696' , '' , '1' ) 01/12/2022 05:58: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 ( '75511' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 01/12/2022 05:58:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/12/2022 05:58:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/12/2022 06:02:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 06:02: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' , '3706' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 01/12/2022 06:02: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 = '75512' 01/12/2022 06:02:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '75512' 01/12/2022 06:02: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 ( '75512' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/12/2022 06:02:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 01/12/2022 06:02:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 01/12/2022 06:16:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002077' AND id_product != '20481' AND ean13 != '' 01/12/2022 06:16:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002077', date_upd = NOW() WHERE id_product = '20481' 01/12/2022 06:16:27 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 50CM - PB8940 + PB8942', description = '' WHERE id_product = '20481' 01/12/2022 06:16:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '523.7704918032787' WHERE id_product = '20481' 01/12/2022 06:16:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '523.7704918032787', id_tax_rules_group = '1', id_category_default = '458', 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 = '20481' 01/12/2022 06:16:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '20481' 01/12/2022 06:22:19 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/12/2022 06:22:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20482' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 06:22:19 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20482' , '1' , '1' , '2' , NOW() , NOW() ) 01/12/2022 06:22:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20482' , '0' , '1' , '0' , '0' ) 01/12/2022 06:27:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002078' AND id_product != '20482' AND ean13 != '' 01/12/2022 06:27:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002078', date_upd = NOW() WHERE id_product = '20482' 01/12/2022 06:27:14 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 56CM - PB13874 + PB13875', description = '' WHERE id_product = '20482' 01/12/2022 06:27:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '376.2295081967213' WHERE id_product = '20482' 01/12/2022 06:27:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '376.2295081967213', id_tax_rules_group = '1', id_category_default = '458', 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 = '20482' 01/12/2022 06:27:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '20482' 01/12/2022 06:28:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002078' AND id_product != '20482' AND ean13 != '' 01/12/2022 06:28:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002078', date_upd = NOW() WHERE id_product = '20482' 01/12/2022 06:28:07 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 56CM - PB13874 + PB13875', description = '' WHERE id_product = '20482' 01/12/2022 06:28:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '376.2295081967213' WHERE id_product = '20482' 01/12/2022 06:28:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '376.2295081967213', id_tax_rules_group = '1', id_category_default = '458', 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 = '20482' 01/12/2022 06:28:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '20482' 01/12/2022 06:28:08 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 = '20482' 01/12/2022 06:28:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20483' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 06:28:08 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 '20483' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20482' 01/12/2022 06:28:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20483' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20482' 01/12/2022 06:29:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB0494' AND id_product != '20483' AND ean13 != '' 01/12/2022 06:29:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PB0494', date_upd = NOW() WHERE id_product = '20483' 01/12/2022 06:29:57 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 43CM - 11 PEZZI - PB0494', description = '' WHERE id_product = '20483' 01/12/2022 06:29:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '433.60655737704917' WHERE id_product = '20483' 01/12/2022 06:29:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '433.60655737704917', id_tax_rules_group = '1', id_category_default = '458', 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 = '20483' 01/12/2022 06:29:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '20483' 01/12/2022 06:33:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB0494' AND id_product != '20483' AND ean13 != '' 01/12/2022 06:33:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PB0494', date_upd = NOW() WHERE id_product = '20483' 01/12/2022 06:33:21 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 43CM - 11 PEZZI - PB0494', description = '' WHERE id_product = '20483' 01/12/2022 06:33:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '433.60655737704917' WHERE id_product = '20483' 01/12/2022 06:33:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '433.60655737704917', id_tax_rules_group = '1', id_category_default = '458', 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 = '20483' 01/12/2022 06:33:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '20483' 01/12/2022 06:33:22 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 = '20483' 01/12/2022 06:33:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20484' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 06:33:22 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 '20484' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20483' 01/12/2022 06:33:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20484' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20483' 01/12/2022 06:35:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB18540' AND id_product != '20484' AND ean13 != '' 01/12/2022 06:35:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PB18540', date_upd = NOW() WHERE id_product = '20484' 01/12/2022 06:35:22 pm >> UPDATE ps_product_lang SET name = 'PRESEPE GROTTA - PB18540', description = '' WHERE id_product = '20484' 01/12/2022 06:35:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '138.52459016393442' WHERE id_product = '20484' 01/12/2022 06:35:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '138.52459016393442', id_tax_rules_group = '1', id_category_default = '458', 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 = '20484' 01/12/2022 06:35:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '20484' 01/12/2022 06:36:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB18540' AND id_product != '20484' AND ean13 != '' 01/12/2022 06:36:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PB18540', date_upd = NOW() WHERE id_product = '20484' 01/12/2022 06:36:42 pm >> UPDATE ps_product_lang SET name = 'PRESEPE GROTTA - PB18540', description = '' WHERE id_product = '20484' 01/12/2022 06:36:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '138.5246' WHERE id_product = '20484' 01/12/2022 06:36:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '138.5246', id_tax_rules_group = '1', id_category_default = '458', 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 = '20484' 01/12/2022 06:36:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '20484' 01/12/2022 06:36:42 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 = '20484' 01/12/2022 06:36:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20485' , '1' , '' , 'nuovo-prodotto' ) 01/12/2022 06:36:42 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 '20485' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20484' 01/12/2022 06:36:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20485' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20484' 01/12/2022 06:37:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB18139' AND id_product != '20485' AND ean13 != '' 01/12/2022 06:37:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PB18139', date_upd = NOW() WHERE id_product = '20485' 01/12/2022 06:37:40 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' MADONNA SDRAIATA - PB18139', description = '' WHERE id_product = '20485' 01/12/2022 06:37:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '43.442622950819676' WHERE id_product = '20485' 01/12/2022 06:37:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '43.442622950819676', id_tax_rules_group = '1', id_category_default = '458', 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 = '20485' 01/12/2022 06:37:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '20485' 01/12/2022 06:38:05 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' , '5961' , '2022-11-29' , '' , '0' , '134' , '4670785' , 'VIA ROMA 44 00053 CIVITAVECCHIA' , '' , '' , '22.87' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '958.11' , '785.34' , NOW() , NOW() ) 01/12/2022 06:38:05 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 = '75513' 01/12/2022 06:38:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '75513' 01/12/2022 06:38:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75513' , '20481' , 'NATIVITA 50CM - PB8940 + PB8942' , '1' , '1' , '1' , '298' , '244.26229508197' , '22' , '20+5' , '276.3056' ) 01/12/2022 06:38:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20481' AND id_supplier = '134' 01/12/2022 06:38:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20481' , '134' , '1' ) 01/12/2022 06:38:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75513' , '20482' , 'NATIVITA 56CM - PB13874 + PB13875' , '1' , '1' , '1' , '273' , '223.77049180328' , '22' , '20+5' , '253.1256' ) 01/12/2022 06:38:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20482' AND id_supplier = '134' 01/12/2022 06:38:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20482' , '134' , '1' ) 01/12/2022 06:38:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75513' , '20483' , 'NATIVITA 43CM - 11 PEZZI - PB0494' , '1' , '1' , '1' , '248' , '203.27868852459' , '22' , '20+5' , '229.9456' ) 01/12/2022 06:38:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20483' AND id_supplier = '134' 01/12/2022 06:38:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20483' , '134' , '1' ) 01/12/2022 06:38:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75513' , '20484' , 'PRESEPE GROTTA - PB18540' , '2' , '2' , '1' , '78.5' , '64.344262295082' , '22' , '20+5' , '145.5704' ) 01/12/2022 06:38:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20484' AND id_supplier = '134' 01/12/2022 06:38:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20484' , '134' , '1' ) 01/12/2022 06:38:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75513' , '20485' , 'NATIVITA MADONNA SDRAIATA - PB18139' , '1' , '1' , '1' , '21.8' , '17.868852459016' , '22' , '5' , '25.2662' ) 01/12/2022 06:38:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20485' AND id_supplier = '134' 01/12/2022 06:38:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20485' , '134' , '1' ) 01/12/2022 06:48:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3707' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-01') 01/12/2022 06:48: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' , '3707' , '2022-12-01' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 01/12/2022 06:48: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 = '75514' 01/12/2022 06:48:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '75514' 01/12/2022 06:48: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 ( '75514' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 01/12/2022 06:48:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '' 01/12/2022 06:48:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '' , '1' ) 01/12/2022 07:20:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3663' AND id_document != '75455' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 01/12/2022 07:20:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3663', document_date = '2022-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '25.96', price_tax_excluded = '23.98', date_upd = NOW() WHERE id_document = '75455' 01/12/2022 07:20:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75455' 01/12/2022 07:20:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '75455' 01/12/2022 07:20: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 ( '75455' , '18131' , 'TAU MEDIO CM3 - T6' , '11' , '-11' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '11.00' ) 01/12/2022 07:20:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '' 01/12/2022 07:20:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '' , '1' ) 01/12/2022 07:20: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 ( '75455' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.96' , '14.96' , '0' , '0' , '14.96' ) 01/12/2022 07:20:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20237' AND id_supplier = '' 01/12/2022 07:20:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20237' , '' , '1' )