28/09/2022 08:38:54 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3409' 28/09/2022 08:38:54 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3409' , '10' , '232' , '' , 'DON GIUSEPPE' , 'PERNIGOTTI' , 'VIA VALLE DEI PRINCIPI 9' , '' , '01034' , 'FABRICA DI ROMA' , '' , '' , '3392466613' , '' , '' , NOW() , NOW() ) 28/09/2022 08:38:54 am >> UPDATE ps_customer SET email = 'pernigotti43@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3409' 28/09/2022 08:48:52 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 ( '31' , '404' , '2022-09-20' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '730.16' , '598.49' , NOW() , NOW() ) 28/09/2022 08:48:52 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 = '61965' 28/09/2022 08:48:52 am >> DELETE FROM ps_document_detail WHERE id_document = '61965' 28/09/2022 08:48:52 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 ( '61965' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '3' , '1' , '58' , '47.540983606557' , '22' , '3' , '205.9116' ) 28/09/2022 08:48:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '143' 28/09/2022 08:48:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '143' , '1' ) 28/09/2022 08:48:52 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 ( '61965' , '19990' , 'CASULA - 65/060288' , '1' , '1' , '1' , '443' , '363.11475409836' , '22' , '3' , '524.2462' ) 28/09/2022 08:48:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19990' AND id_supplier = '143' 28/09/2022 08:48:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19990' , '143' , '1' ) 28/09/2022 08:52:37 am >> UPDATE ps_document SET id_document_type = '33', document_num = '138/22', document_date = '2022-09-16', document_letter = '22', id_customer = '0', id_supplier = '', id_address = '4671003', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '61855' 28/09/2022 08:52: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 = '61855' 28/09/2022 08:52:38 am >> DELETE FROM ps_document_detail WHERE id_document = '61855' 28/09/2022 08:52: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 ( '61855' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '9471' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9471' , '' , '1' ) 28/09/2022 08:52: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 ( '61855' , '9555' , 'SANTA ELISABETTA DUNGHERIA - L. CAVAGNA' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '9555' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9555' , '' , '1' ) 28/09/2022 08:52: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 ( '61855' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '9490' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9490' , '' , '1' ) 28/09/2022 08:52: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 ( '61855' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.7500' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '9479' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9479' , '' , '1' ) 28/09/2022 08:52: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 ( '61855' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '9438' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9438' , '' , '1' ) 28/09/2022 08:52: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 ( '61855' , '9593' , 'SANTA MONICA - R.PICCOLOMINI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '9593' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9593' , '' , '1' ) 28/09/2022 08:52: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 ( '61855' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19666' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19666' , '' , '1' ) 28/09/2022 08:52: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 ( '61855' , '19964' , 'SANTA MARIA GORETTI - G. ALBERTI' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '50' , '3.50' ) 28/09/2022 08:52:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19964' AND id_supplier = '' 28/09/2022 08:52:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19964' , '' , '1' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '259/22' , '2022-09-16' , '22' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61966' 28/09/2022 08:53:41 am >> DELETE FROM ps_document_detail WHERE id_document = '61966' 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9555' , 'SANTA ELISABETTA DUNGHERIA - L. CAVAGNA' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '9593' , 'SANTA MONICA - R.PICCOLOMINI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 28/09/2022 08:53:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61966' , '19964' , 'SANTA MARIA GORETTI - G. ALBERTI' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '3.50' ) 28/09/2022 09:05:45 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'o2UYirkX28OnTPjM' , NOW() , NOW() ) 28/09/2022 09:05:45 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3909' , '1' ) 28/09/2022 09:05:45 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3909' , '2' ) 28/09/2022 09:05:45 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3909' , '3' ) 28/09/2022 09:08:57 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3909' 28/09/2022 09:08:57 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3909' , '10' , '219' , 'PARR. S. GIOVANNI B.' , 'FOMA\'' , 'DON MATTEO' , 'PIAZZA GARIBALDI 17' , '' , '10089' , 'VALCHIUSA' , '' , '' , '3319190586' , '' , '93008430014' , NOW() , NOW() ) 28/09/2022 09:08:57 am >> UPDATE ps_customer SET email = 'don.matteofoma@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3909' 28/09/2022 09:09:24 am >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 09:09: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' , '128' , '2022-09-28' , '' , '3909' , '0' , '4674906' , 'PIAZZA GARIBALDI 17 10089 VALCHIUSA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '39.20' , '33.03' , NOW() , NOW() ) 28/09/2022 09:09: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 = '61967' 28/09/2022 09:09:24 am >> DELETE FROM ps_document_detail WHERE id_document = '61967' 28/09/2022 09:09: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 ( '61967' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '3' , '-3' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '34.20' ) 28/09/2022 09:48:10 am >> SELECT document_num FROM ps_document WHERE document_num = '68' AND id_document != '6346' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 28/09/2022 09:48:10 am >> UPDATE ps_document SET id_document_type = '21', document_num = '68', document_date = '2022-09-23', document_letter = '', id_customer = '3474', id_supplier = '', id_address = '4670135', address1 = 'PIAZZA N.S. DI GUADALUPE, 12 00135 ROMA', address2 = '', note = '', price_shipping = '4.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '39.10', price_tax_excluded = '39.10', date_upd = NOW() WHERE id_document = '6346' 28/09/2022 09:48:10 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 = '6346' 28/09/2022 09:48:10 am >> DELETE FROM ps_document_detail WHERE id_document = '6346' 28/09/2022 09:48: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 ( '6346' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '5' , '34.20' ) 28/09/2022 09:48:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 28/09/2022 09:48:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 28/09/2022 10:02:55 am >> UPDATE ps_document SET id_document_type = '33', document_num = '617415', document_date = '2022-09-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '140.90', price_tax_excluded = '140.90', date_upd = NOW() WHERE id_document = '61832' 28/09/2022 10:02:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61832' 28/09/2022 10:02:55 am >> DELETE FROM ps_document_detail WHERE id_document = '61832' 28/09/2022 10:02:55 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 ( '61832' , '19959' , 'PREGHIERE PER DUE' , '1' , '1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 28/09/2022 10:02:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19959' AND id_supplier = '' 28/09/2022 10:02:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19959' , '' , '1' ) 28/09/2022 10:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61832' , '17254' , 'PADRE NOSTRO PER I PICCOLI - M. BALDACCI' , '1' , '1' , '4' , '13.9000' , '13.9' , '0' , '0' , '13.90' ) 28/09/2022 10:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '17254' AND id_supplier = '' 28/09/2022 10:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17254' , '' , '1' ) 28/09/2022 10:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61832' , '19958' , 'FINO IN CIMA - A. BELLO' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 28/09/2022 10:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19958' AND id_supplier = '' 28/09/2022 10:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19958' , '' , '1' ) 28/09/2022 10:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61832' , '19957' , 'ESERCIZI SPIRITUALI CON SAN PAOLO - B. SECONDIN' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 28/09/2022 10:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19957' AND id_supplier = '' 28/09/2022 10:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19957' , '' , '1' ) 28/09/2022 10:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61832' , '19956' , 'VITA DI CRISTO - F. SHEEN' , '2' , '2' , '4' , '25.0000' , '25' , '0' , '0' , '50.00' ) 28/09/2022 10:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19956' AND id_supplier = '' 28/09/2022 10:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19956' , '' , '1' ) 28/09/2022 10:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61832' , '19837' , 'ABBANDONATEVI A CRISTO - F. SHEEN' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 28/09/2022 10:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19837' AND id_supplier = '' 28/09/2022 10:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19837' , '' , '1' ) 28/09/2022 10:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61832' , '19955' , 'SAN FRANCESCO DI SALES - G. JEANGUENIN' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 28/09/2022 10:02:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19955' AND id_supplier = '' 28/09/2022 10:02:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19955' , '' , '1' ) 28/09/2022 10:14:36 am >> SELECT document_num FROM ps_document WHERE document_num = '129' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 10:14:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '129' , '2022-09-28' , '' , '618' , '0' , '4671023' , 'S. ANGELO 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '291.38' , '289.46' , NOW() , NOW() ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61968' 28/09/2022 10:14:36 am >> DELETE FROM ps_document_detail WHERE id_document = '61968' 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '-13' , '4' , '2.50' , '2.5' , '0' , '15' , '27.63' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '15' , '12.75' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '11191' , 'VENITE CON ME 1 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '11192' , 'VENITE CON ME 2 PARTE' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '9675' , 'SARETE MIEI TESTIMONI' , '11' , '-11' , '4' , '3.00' , '3' , '0' , '15' , '28.05' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '12819' , 'REGISTRO DEL CATECHISTA ' , '9' , '-9' , '1' , '1.00' , '0.81967213114754' , '22' , '15' , '7.65' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '9' , '-9' , '4' , '5.50' , '5.5' , '0' , '10' , '44.55' ) 28/09/2022 10:14:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '5444' , 'IO SONO CON VOI - CAT.' , '10' , '-10' , '4' , '5.50' , '5.5' , '0' , '10' , '49.50' ) 28/09/2022 10:14:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61968' , '11193' , 'VENITE CON ME CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '10' , '24.75' ) 28/09/2022 10:20:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2854' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 10:20: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' , '2854' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.41' , NOW() , NOW() ) 28/09/2022 10:20: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 = '61969' 28/09/2022 10:20:51 am >> DELETE FROM ps_document_detail WHERE id_document = '61969' 28/09/2022 10:20: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 ( '61969' , '14126' , 'SAN FRANCESCO DASSISI - 70' , '6' , '-6' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '21.00' ) 28/09/2022 10:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '14126' AND id_supplier = '' 28/09/2022 10:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14126' , '' , '1' ) 28/09/2022 10:20: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 ( '61969' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 28/09/2022 10:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/09/2022 10:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/09/2022 10:20: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 ( '61969' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/09/2022 10:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 28/09/2022 10:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 28/09/2022 10:34:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 10:34: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' , '2855' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 28/09/2022 10:34: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 = '61970' 28/09/2022 10:34:09 am >> DELETE FROM ps_document_detail WHERE id_document = '61970' 28/09/2022 10:34: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 ( '61970' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 28/09/2022 10:34:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 28/09/2022 10:34:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 28/09/2022 10:34: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 ( '61970' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 28/09/2022 10:34:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 28/09/2022 10:34:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 28/09/2022 10:46:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 10:46:52 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' , '2856' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.90' , '55.46' , NOW() , NOW() ) 28/09/2022 10:46:52 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 = '61971' 28/09/2022 10:46:52 am >> DELETE FROM ps_document_detail WHERE id_document = '61971' 28/09/2022 10:46:52 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 ( '61971' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 28/09/2022 10:46:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/09/2022 10:46:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/09/2022 10:46:52 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 ( '61971' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 28/09/2022 10:46:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 28/09/2022 10:46:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 28/09/2022 10:46:52 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 ( '61971' , '11151' , 'LIBRI' , '7' , '-7' , '4' , '3.5' , '3.5' , '0' , '0' , '24.50' ) 28/09/2022 10:46:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/09/2022 10:46:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/09/2022 11:46:12 am >> SELECT document_num FROM ps_document WHERE document_num = '73/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 11:46:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '73/A' , '2022-09-28' , 'A' , '752' , '0' , '752' , 'VIA AURELIA, 1100 00166 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '549.00' , '549.00' , NOW() , NOW() ) 28/09/2022 11:46: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 = '61972' 28/09/2022 11:46:12 am >> DELETE FROM ps_document_detail WHERE id_document = '61972' 28/09/2022 11:46: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 ( '61972' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '3' , '-3' , '0' , '68.00' , '68' , '' , '0' , '204.00' ) 28/09/2022 11:46: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 ( '61972' , '2269' , 'CLERGY GRIGIO CHIARO ML - COTONE 44 ' , '1' , '-1' , '0' , '45' , '45' , '' , '0' , '45.00' ) 28/09/2022 11:46: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 ( '61972' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '0' , '36.50' , '36.5' , '' , '0' , '36.50' ) 28/09/2022 11:46: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 ( '61972' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '0' , '40.00' ) 28/09/2022 11:46: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 ( '61972' , '8351' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 28/09/2022 11:46: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 ( '61972' , '17073' , 'DIRETTORIO PER LA CATECHESI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 28/09/2022 11:46: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 ( '61972' , '19685' , 'AMEN - OTT 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '0' , '7.80' ) 28/09/2022 11:46: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 ( '61972' , '19978' , 'MESSALE FESTIVO 2023' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 28/09/2022 11:46: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 ( '61972' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '0' , '35.00' ) 28/09/2022 11:46: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 ( '61972' , '12096' , 'BIBBIA DI GERUSALEMME ' , '1' , '-1' , '4' , '29.00' , '29' , '0' , '0' , '29.00' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '11278' , 'VI HO CHIAMATO AMICI' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '0' , '8.50' , '8.5' , '' , '0' , '51.00' ) 28/09/2022 11:46:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61972' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '0' , '1.10' , '1.1' , '' , '0' , '2.20' ) 28/09/2022 11:46:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2113' AND id_document != '58980' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 28/09/2022 11:46:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2113', document_date = '2022-06-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.50', price_tax_excluded = '19.50', date_upd = NOW() WHERE id_document = '58980' 28/09/2022 11:46:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58980' 28/09/2022 11:46:50 am >> DELETE FROM ps_document_detail WHERE id_document = '58980' 28/09/2022 11:46:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/09/2022 11:46:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 28/09/2022 11:46:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 28/09/2022 11:46:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/09/2022 11:46:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 28/09/2022 11:46:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 28/09/2022 11:46:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '19664' , 'ANTONIO ROSMINI - V. SALVOLDI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 28/09/2022 11:46:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19664' AND id_supplier = '' 28/09/2022 11:46:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19664' , '' , '1' ) 28/09/2022 11:46:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '17933' , 'PADRE FELICE CAPPELLO' , '1' , '-1' , '4' , '6.5' , '6.5' , '0' , '0' , '6.50' ) 28/09/2022 11:46:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '17933' AND id_supplier = '' 28/09/2022 11:46:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17933' , '' , '1' ) 28/09/2022 11:48:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2277' AND id_document != '59695' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 28/09/2022 11:48:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2277', document_date = '2022-07-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.50', price_tax_excluded = '8.42', date_upd = NOW() WHERE id_document = '59695' 28/09/2022 11:48:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59695' 28/09/2022 11:48:35 am >> DELETE FROM ps_document_detail WHERE id_document = '59695' 28/09/2022 11:48:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59695' , '9384' , 'SAN BARTOLOMEO APOSTOLO - G. PESENTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 28/09/2022 11:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '9384' AND id_supplier = '' 28/09/2022 11:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9384' , '' , '1' ) 28/09/2022 11:48:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59695' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 28/09/2022 11:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18214' AND id_supplier = '' 28/09/2022 11:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18214' , '' , '1' ) 28/09/2022 11:48:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59695' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/09/2022 11:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '9691' AND id_supplier = '' 28/09/2022 11:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9691' , '' , '1' ) 28/09/2022 11:48:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59695' , '18130' , 'TAU GRANDE CM 4 - T9' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/09/2022 11:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18130' AND id_supplier = '' 28/09/2022 11:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18130' , '' , '1' ) 28/09/2022 11:48:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59695' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 28/09/2022 11:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '14772' AND id_supplier = '' 28/09/2022 11:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14772' , '' , '1' ) 28/09/2022 02:18:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 02:18:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '130' , '2022-09-28' , '' , '3409' , '0' , '4674905' , 'VIA VALLE DEI PRINCIPI 9 01034 FABRICA DI ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '69.40' , '69.40' , NOW() , NOW() ) 28/09/2022 02:18:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61973' 28/09/2022 02:18:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '61973' 28/09/2022 02:18:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61973' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '5' , '66.50' ) 28/09/2022 02:18:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61973' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 28/09/2022 02:30:00 pm >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-09-07' WHERE id_order = '371' 28/09/2022 02:30:00 pm >> DELETE FROM ps_document WHERE document_num = '371' AND id_document_type = '28' 28/09/2022 02:30:06 pm >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-09-15' WHERE id_order = '372' 28/09/2022 02:30:06 pm >> DELETE FROM ps_document WHERE document_num = '372' AND id_document_type = '28' 28/09/2022 02:31:13 pm >> 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-09-28') 28/09/2022 02:31: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 ( '21' , '131' , '2022-09-28' , '' , '3911' , '' , '4675030' , 'Via Castello , 24 27020 Cergnago ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '74.32' , '74.32' , NOW() , NOW() ) 28/09/2022 02:31: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 = '62485' 28/09/2022 02:31:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '62485' 28/09/2022 02:31: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 ( '62485' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:31:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 28/09/2022 02:31:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 28/09/2022 02:31: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 ( '62485' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4479' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4479' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4480' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4480' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '8855' , 'REGISTRO DEL CATECHISTA' , '3' , '-3' , '1' , '0.7501' , '0.6148' , '22' , '5' , '2.13' ) 28/09/2022 02:31:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8855' AND id_supplier = '' 28/09/2022 02:31:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8855' , '' , '1' ) 28/09/2022 02:31:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '13397' , 'MIO GESU\'' , '1' , '-1' , '1' , '4.2700' , '3.5' , '22' , '5' , '4.06' ) 28/09/2022 02:31:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 28/09/2022 02:31:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 28/09/2022 02:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '13956' , 'MIRACOLI DI GESU\'' , '1' , '-1' , '1' , '3.6600' , '3' , '22' , '5' , '3.48' ) 28/09/2022 02:31:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13956' AND id_supplier = '' 28/09/2022 02:31:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13956' , '' , '1' ) 28/09/2022 02:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '1' , '7.3200' , '6' , '22' , '5' , '6.95' ) 28/09/2022 02:31:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 28/09/2022 02:31:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 28/09/2022 02:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '1' , '3.6600' , '3' , '22' , '5' , '3.48' ) 28/09/2022 02:31:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17274' AND id_supplier = '' 28/09/2022 02:31:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17274' , '' , '1' ) 28/09/2022 02:31:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 28/09/2022 02:31:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 28/09/2022 02:31:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 28/09/2022 02:38:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '62485' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 02:38:33 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '131', document_date = '2022-09-28', document_letter = '', id_customer = '3911', id_supplier = '', id_address = '4675030', address1 = 'Via Castello , 24 27020 Cergnago ', address2 = '', note = '', price_shipping = '-0.01', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '68.18', price_tax_excluded = '68.18', date_upd = NOW() WHERE id_document = '62485' 28/09/2022 02:38: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 = '62485' 28/09/2022 02:38:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '62485' 28/09/2022 02:38: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 ( '62485' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 28/09/2022 02:38: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 ( '62485' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 28/09/2022 02:38: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 ( '62485' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 28/09/2022 02:38: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 ( '62485' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 28/09/2022 02:38: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 ( '62485' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 28/09/2022 02:38: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 ( '62485' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4479' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4479' , '' , '1' ) 28/09/2022 02:38: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 ( '62485' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4480' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4480' , '' , '1' ) 28/09/2022 02:38: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 ( '62485' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 28/09/2022 02:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '8855' , 'REGISTRO DEL CATECHISTA' , '3' , '-3' , '4' , '0.75' , '0.75' , '0' , '5' , '2.14' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8855' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8855' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '13397' , 'MIO GESU\'' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '13956' , 'MIRACOLI DI GESU\'' , '1' , '-1' , '4' , '3' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13956' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13956' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6' , '6' , '0' , '5' , '5.70' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 28/09/2022 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:38:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17274' AND id_supplier = '' 28/09/2022 02:38:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17274' , '' , '1' ) 28/09/2022 02:38:58 pm >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-09-28' WHERE id_order = '373' 28/09/2022 02:38:58 pm >> DELETE FROM ps_document WHERE document_num = '373' AND id_document_type = '28' 28/09/2022 02:43:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 02:43:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2857' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 28/09/2022 02:43:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62486' 28/09/2022 02:43:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '62486' 28/09/2022 02:43:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62486' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 28/09/2022 02:43:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 28/09/2022 02:43:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 28/09/2022 02:46:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '62485' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 02:46:28 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '131', document_date = '2022-09-28', document_letter = '', id_customer = '3911', id_supplier = '', id_address = '4675030', address1 = 'Via Castello , 24 27020 Cergnago ', address2 = '', note = '', price_shipping = '-0.01', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '68.18', price_tax_excluded = '68.18', date_upd = NOW() WHERE id_document = '62485' 28/09/2022 02:46: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 = '62485' 28/09/2022 02:46:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '62485' 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4479' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4479' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4480' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4480' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 28/09/2022 02:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '8855' , 'REGISTRO DEL CATECHISTA' , '3' , '-3' , '4' , '0.7500' , '0.75' , '0' , '5' , '2.14' ) 28/09/2022 02:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8855' AND id_supplier = '' 28/09/2022 02:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8855' , '' , '1' ) 28/09/2022 02:46:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '13397' , 'MIO GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 28/09/2022 02:46:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 28/09/2022 02:46:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 28/09/2022 02:46:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '13956' , 'MIRACOLI DI GESU\'' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:46:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13956' AND id_supplier = '' 28/09/2022 02:46:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13956' , '' , '1' ) 28/09/2022 02:46:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 28/09/2022 02:46:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 28/09/2022 02:46:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 28/09/2022 02:46:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62485' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 28/09/2022 02:46:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17274' AND id_supplier = '' 28/09/2022 02:46:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17274' , '' , '1' ) 28/09/2022 03:22:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3911' 28/09/2022 03:22:23 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 ( '3911' , '10' , '192' , '' , 'Ciccotti' , 'Paolo' , 'Via Castello , 24' , '' , '27020' , 'Cergnago' , '' , '' , '3397123450' , '' , '' , NOW() , NOW() ) 28/09/2022 03:22:23 pm >> UPDATE ps_customer SET email = 'donpaolociccotti@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3911' 28/09/2022 03:22:48 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/09/2022 03:22:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20014' , '1' , '' , 'nuovo-prodotto' ) 28/09/2022 03:22:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20014' , '1' , '1' , '2' , NOW() , NOW() ) 28/09/2022 03:22:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20014' , '0' , '1' , '0' , '0' ) 28/09/2022 03:24:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002024' AND id_product != '20014' AND ean13 != '' 28/09/2022 03:24:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002024', date_upd = NOW() WHERE id_product = '20014' 28/09/2022 03:24:29 pm >> UPDATE ps_product_lang SET name = 'SAN GIUSEPPE CON GESU\' - ORO ZECCHINO - 5951', description = '' WHERE id_product = '20014' 28/09/2022 03:24:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '729.5081967213115' WHERE id_product = '20014' 28/09/2022 03:24:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '729.5081967213115', id_tax_rules_group = '1', id_category_default = '503', 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 = '20014' 28/09/2022 03:24:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '20014' 28/09/2022 03:24:31 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 = '20014' 28/09/2022 03:24:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20015' , '1' , '' , 'nuovo-prodotto' ) 28/09/2022 03:24:31 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 '20015' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20014' 28/09/2022 03:24:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20015' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20014' 28/09/2022 03:33:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1558' , '2022-09-22' , '' , '0' , '166' , '4674902' , 'VIA PALUA 10 39047 S. CRISTINA VAL GARDENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '489.16' , '400.95' , NOW() , NOW() ) 28/09/2022 03:33:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62487' 28/09/2022 03:33:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '62487' 28/09/2022 03:33:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62487' , '20014' , 'SAN GIUSEPPE CON GESU - ORO ZECCHINO - 5951' , '1' , '1' , '1' , '400.95' , '328.64754098361' , '22' , '0' , '489.1590' ) 28/09/2022 03:33:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20014' AND id_supplier = '166' 28/09/2022 03:33:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20014' , '166' , '1' ) 28/09/2022 03:49:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2858' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 03:49:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2858' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 28/09/2022 03:49: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 = '62488' 28/09/2022 03:49:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '62488' 28/09/2022 03:49: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 ( '62488' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 28/09/2022 03:49:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 28/09/2022 03:49:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 28/09/2022 04:06:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2005' AND id_document != '58858' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 28/09/2022 04:06:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2005', document_date = '2022-06-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '215.00', price_tax_excluded = '176.23', date_upd = NOW() WHERE id_document = '58858' 28/09/2022 04:06: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 = '58858' 28/09/2022 04:06:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '58858' 28/09/2022 04:06: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 ( '58858' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 28/09/2022 04:06:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18399' AND id_supplier = '' 28/09/2022 04:06:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18399' , '' , '1' ) 28/09/2022 04:06: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 ( '58858' , '18400' , 'CAMICE DUE PIEGONI POL. CERNIERA SPALLA - 405TPAS' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 28/09/2022 04:06:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18400' AND id_supplier = '' 28/09/2022 04:06:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18400' , '' , '1' ) 28/09/2022 04:06: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 ( '58858' , '2269' , 'CLERGY GRIGIO CHIARO ML - COTONE 44 ' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 28/09/2022 04:06:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2269' AND id_supplier = '' 28/09/2022 04:06:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2269' , '' , '1' ) 28/09/2022 04:06: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 ( '58858' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '31' , '25.409836065574' , '22' , '0' , '31.00' ) 28/09/2022 04:06:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 28/09/2022 04:06:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 28/09/2022 04:06: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 ( '58858' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '39.00' ) 28/09/2022 04:06:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 28/09/2022 04:06:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 28/09/2022 04:08:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2604' AND id_document != '61127' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-01') 28/09/2022 04:08:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2604', document_date = '2022-09-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '61127' 28/09/2022 04:08:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61127' 28/09/2022 04:08:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '61127' 28/09/2022 04:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61127' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '8' , '-8' , '4' , '4' , '4' , '0' , '0' , '32.00' ) 28/09/2022 04:08:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 28/09/2022 04:08:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 28/09/2022 04:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61127' , '19685' , 'AMEN - OTT 2022' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 28/09/2022 04:08:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 28/09/2022 04:08:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 28/09/2022 04:08: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 ( '61127' , '19978' , 'MESSALE FESTIVO 2023' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 28/09/2022 04:08:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19978' AND id_supplier = '' 28/09/2022 04:08:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19978' , '' , '1' ) 28/09/2022 04:10:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2578' AND id_document != '61099' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-31') 28/09/2022 04:10:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2578', document_date = '2022-08-31', 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 = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '61099' 28/09/2022 04:10:11 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 = '61099' 28/09/2022 04:10:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '61099' 28/09/2022 04:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61099' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 28/09/2022 04:10:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8290' AND id_supplier = '' 28/09/2022 04:10:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8290' , '' , '1' ) 28/09/2022 04:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61099' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 28/09/2022 04:10:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5559' AND id_supplier = '' 28/09/2022 04:10:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5559' , '' , '1' ) 28/09/2022 04:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61099' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 28/09/2022 04:10:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 28/09/2022 04:10:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 28/09/2022 04:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61099' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 28/09/2022 04:10:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 28/09/2022 04:10:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 28/09/2022 04:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61099' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 28/09/2022 04:10:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 28/09/2022 04:10:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 28/09/2022 04:10:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2504' AND id_document != '59985' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-11') 28/09/2022 04:10:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2504', document_date = '2022-08-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.40', price_tax_excluded = '5.40', date_upd = NOW() WHERE id_document = '59985' 28/09/2022 04:10: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 = '59985' 28/09/2022 04:10:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '59985' 28/09/2022 04:10:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59985' , '11278' , 'VI HO CHIAMATO AMICI' , '1' , '-1' , '4' , '5.4' , '5.4' , '0' , '0' , '5.40' ) 28/09/2022 04:10:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11278' AND id_supplier = '' 28/09/2022 04:10:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11278' , '' , '1' ) 28/09/2022 04:10:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2559' AND id_document != '61077' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-30') 28/09/2022 04:10:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2559', document_date = '2022-08-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '61077' 28/09/2022 04:10:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61077' 28/09/2022 04:10:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '61077' 28/09/2022 04:10:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61077' , '4619' , 'GIOVANNI PAOLO I - ALBINO LUCIANI' , '1' , '-1' , '4' , '34.0000' , '34' , '0' , '5' , '32.30' ) 28/09/2022 04:10:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4619' AND id_supplier = '' 28/09/2022 04:10:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4619' , '' , '1' ) 28/09/2022 04:10:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61077' , '12096' , 'BIBBIA DI GERUSALEMME ' , '1' , '-1' , '4' , '22.7' , '22.7' , '0' , '0' , '22.70' ) 28/09/2022 04:10:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12096' AND id_supplier = '' 28/09/2022 04:10:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12096' , '' , '1' ) 28/09/2022 04:12:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2381' AND id_document != '59823' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-27') 28/09/2022 04:12:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2381', document_date = '2022-07-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.10', price_tax_excluded = '4.10', date_upd = NOW() WHERE id_document = '59823' 28/09/2022 04:12:01 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 = '59823' 28/09/2022 04:12:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '59823' 28/09/2022 04:12:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59823' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/09/2022 04:12:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 28/09/2022 04:12:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 28/09/2022 04:12:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59823' , '8351' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 28/09/2022 04:12:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8351' AND id_supplier = '' 28/09/2022 04:12:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8351' , '' , '1' ) 28/09/2022 04:13:14 pm >> DELETE FROM ps_document WHERE id_document = '61972' 28/09/2022 04:13:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61972' 28/09/2022 04:28:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2859' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 04:28:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2859' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '80.00' , NOW() , NOW() ) 28/09/2022 04:28:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62489' 28/09/2022 04:28:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '62489' 28/09/2022 04:28:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62489' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '80' , '80' , '0' , '0' , '80.00' ) 28/09/2022 04:28:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 28/09/2022 04:28:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 28/09/2022 04:54:46 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'CZ446mdMqYooRmhd' , NOW() , NOW() ) 28/09/2022 04:54:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6982' , '1' ) 28/09/2022 04:54:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6982' , '2' ) 28/09/2022 04:54:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6982' , '3' ) 28/09/2022 04:57:40 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6982' 28/09/2022 04:57:40 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 ( '6982' , '10' , '200' , 'PARR. SAN NICOLA DI BARI' , 'CAPANO' , 'DON GIUSEPPE' , 'VIA AMATORE SCIESA 30' , '' , '85042' , 'LAGONEGRO' , 'VIA AMATORE SCIESA 30' , '' , '3773799028' , '' , '91000110766' , NOW() , NOW() ) 28/09/2022 04:57:40 pm >> UPDATE ps_customer SET email = 'gecap94@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6982' 28/09/2022 05:10:35 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6982' 28/09/2022 05:10:35 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 ( '6982' , '10' , '200' , 'PARR. SAN NICOLA DI BARI' , 'CAPANO' , 'DON GIUSEPPE' , 'PIAZZETTA ITALIA' , '' , '85042' , 'LAGONEGRO' , 'DA SPEDIRE A: DON GIUSEPPE CAPANO - CASA CANONICA - VIA AMATORE SCIESA 30' , '' , '3773799028' , '' , '91000110766' , NOW() , NOW() ) 28/09/2022 05:10:35 pm >> UPDATE ps_customer SET email = 'gecap94@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6982' 28/09/2022 05:13:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '77' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 05:13: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 ( '21' , '77' , '2022-09-28' , '' , '6982' , '0' , '79347653' , 'PIAZZETTA ITALIA 85042 LAGONEGRO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1048.15' , '1048.15' , NOW() , NOW() ) 28/09/2022 05:13: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 = '6355' 28/09/2022 05:13:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '6355' 28/09/2022 05:13: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 ( '6355' , '125' , 'MIE PREGHIERINE - N. E.' , '150' , '-150' , '4' , '1.50' , '1.5' , '0' , '15' , '191.25' ) 28/09/2022 05:13: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 ( '6355' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '100' , '-100' , '4' , '2.50' , '2.5' , '0' , '15' , '212.50' ) 28/09/2022 05:13: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 ( '6355' , '17' , 'LA FEDE NELLO ZAINETTO' , '150' , '-150' , '4' , '5.00' , '5' , '0' , '15' , '637.50' ) 28/09/2022 05:46:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2860' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 05:46:29 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' , '2860' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 28/09/2022 05:46:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62490' 28/09/2022 05:46:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '62490' 28/09/2022 05:46:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62490' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 28/09/2022 05:46:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 28/09/2022 05:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 28/09/2022 05:55:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 05:55:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2861' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.00' , '54.92' , NOW() , NOW() ) 28/09/2022 05:55:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62491' 28/09/2022 05:55:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '62491' 28/09/2022 05:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62491' , '6403' , 'MENSA BIANCA 80X150 ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/09/2022 05:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6403' AND id_supplier = '' 28/09/2022 05:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6403' , '' , '1' ) 28/09/2022 05:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62491' , '5998' , 'LUME VETRO SOFFIATO - CM 20 - 1023' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 28/09/2022 05:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5998' AND id_supplier = '' 28/09/2022 05:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5998' , '' , '1' ) 28/09/2022 05:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62491' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '1' , '-1' , '1' , '15.5' , '12.704918032787' , '22' , '0' , '15.50' ) 28/09/2022 05:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 28/09/2022 05:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 28/09/2022 05:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62491' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 28/09/2022 05:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1912' AND id_supplier = '' 28/09/2022 05:55:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1912' , '' , '1' ) 28/09/2022 05:57:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 05:57:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2862' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.80' , '4.75' , NOW() , NOW() ) 28/09/2022 05:57:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62492' 28/09/2022 05:57:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '62492' 28/09/2022 05:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62492' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 28/09/2022 05:57:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '' 28/09/2022 05:57:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '' , '1' ) 28/09/2022 05:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62492' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 28/09/2022 05:57:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 28/09/2022 05:57:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 28/09/2022 06:02:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 06:02:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2863' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.10' , '0.90' , NOW() , NOW() ) 28/09/2022 06:02:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62493' 28/09/2022 06:02:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '62493' 28/09/2022 06:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62493' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 28/09/2022 06:02:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 28/09/2022 06:02:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 28/09/2022 06:09:32 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6982' 28/09/2022 06:09:32 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 ( '6982' , '10' , '200' , 'PARR. SAN NICOLA DI BARI' , 'CAPANO' , 'DON GERARDO' , 'PIAZZETTA ITALIA' , '' , '85042' , 'LAGONEGRO' , 'DA SPEDIRE A: DON GERARDO CAPANO - CASA CANONICA - VIA AMATORE SCIESA 30' , '' , '3773799028' , '' , '91000110766' , NOW() , NOW() ) 28/09/2022 06:09:32 pm >> UPDATE ps_customer SET email = 'gecap94@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6982' 28/09/2022 06:10:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '77' AND id_document != '6355' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 06:10:04 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '77', document_date = '2022-09-28', document_letter = '', id_customer = '6982', id_supplier = '0', id_address = '79347654', address1 = 'PIAZZETTA ITALIA 85042 LAGONEGRO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '1048.15', price_tax_excluded = '1048.15', date_upd = NOW() WHERE id_document = '6355' 28/09/2022 06:10: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 = '6355' 28/09/2022 06:10:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '6355' 28/09/2022 06:10: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 ( '6355' , '125' , 'MIE PREGHIERINE - N. E.' , '150' , '-150' , '4' , '1.5000' , '1.5' , '0' , '15' , '191.25' ) 28/09/2022 06:10: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 ( '6355' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '100' , '-100' , '4' , '2.5000' , '2.5' , '0' , '15' , '212.50' ) 28/09/2022 06:10: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 ( '6355' , '17' , 'LA FEDE NELLO ZAINETTO' , '150' , '-150' , '4' , '5.0000' , '5' , '0' , '15' , '637.50' ) 28/09/2022 06:21:39 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'XVjYsQNQnsVCjzQg' , NOW() , NOW() ) 28/09/2022 06:21:39 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3912' , '1' ) 28/09/2022 06:21:39 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3912' , '2' ) 28/09/2022 06:21:39 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3912' , '3' ) 28/09/2022 06:23:15 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3912' 28/09/2022 06:23:15 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 ( '3912' , '10' , '179' , 'PARROCCHIA SAN GIUSEPPE' , 'MIRABITO' , 'DON GIUSEPPE' , 'SALITA SAN GIUSEPPE 14' , '' , '98055' , 'LIPARI' , '' , '' , '3337761639' , '' , '81000630830' , NOW() , NOW() ) 28/09/2022 06:23:15 pm >> UPDATE ps_customer SET email = 'dongiuseppemirabito@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3912' 28/09/2022 06:27:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3912' 28/09/2022 06:27:19 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 ( '3912' , '10' , '179' , 'PARROCCHIA SAN GIUSEPPE' , 'MIRABITO' , 'DON GIUSEPPE' , 'SALITA SAN GIUSEPPE 14' , '' , '98055' , 'LIPARI' , '' , '' , '3337761639' , '' , '81000630830' , NOW() , NOW() ) 28/09/2022 06:27:19 pm >> UPDATE ps_customer SET email = 'dongiuseppemirabito@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3912' 28/09/2022 06:29:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 06:29: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 ( '21' , '132' , '2022-09-28' , '' , '3912' , '0' , '4675033' , 'SALITA SAN GIUSEPPE 14 98055 LIPARI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '222.15' , '217.34' , NOW() , NOW() ) 28/09/2022 06:29: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 = '62494' 28/09/2022 06:29:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '62494' 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '4154' , 'FESTA DEL PERDONO' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '15' , '76.50' ) 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '15' , '76.50' ) 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '4' , '1.00' , '1' , '0' , '15' , '3.40' ) 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '17257' , 'IO TI BATTEZZO ' , '20' , '-20' , '4' , '1.80' , '1.8' , '0' , '15' , '30.60' ) 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '5' , '23.75' ) 28/09/2022 06:29:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62494' , '' , 'CONTRASSEGNO' , '1' , '-1' , '1' , '2.9' , '2.3770491803279' , '22' , '0' , '2.90' ) 28/09/2022 06:31:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 06:31:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2864' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.30' , '11.72' , NOW() , NOW() ) 28/09/2022 06:31:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62495' 28/09/2022 06:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '62495' 28/09/2022 06:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62495' , '19362' , 'LUMINO DIAMANTE VARI COLORI' , '17' , '-17' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '8.50' ) 28/09/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19362' AND id_supplier = '' 28/09/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19362' , '' , '1' ) 28/09/2022 06:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62495' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '2.80' ) 28/09/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 28/09/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 28/09/2022 06:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62495' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 28/09/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 28/09/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 28/09/2022 06:35:59 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'wwJv9f3z32dHTN8a' , NOW() , NOW() ) 28/09/2022 06:35:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6983' , '1' ) 28/09/2022 06:35:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6983' , '2' ) 28/09/2022 06:35:59 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6983' , '3' ) 28/09/2022 06:37:21 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6983' 28/09/2022 06:37:21 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 ( '6983' , '10' , '150' , 'PARROCCHIA SAN NICOLA DI BARI' , '' , '' , 'PIAZZA DUOMO' , '' , '87040' , 'MENDICINO' , 'DA SPEDIRE: BAR TODARO - PASQUALI ' , '' , '3478491318' , '' , '' , NOW() , NOW() ) 28/09/2022 06:37:22 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6983' 28/09/2022 06:44:45 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'AY7ZZIf4rKdORQEd' , NOW() , NOW() ) 28/09/2022 06:44:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3913' , '1' ) 28/09/2022 06:44:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3913' , '2' ) 28/09/2022 06:44:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3913' , '3' ) 28/09/2022 06:44:55 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'cmjkMcrjhawAZpgf' , NOW() , NOW() ) 28/09/2022 06:44:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3914' , '1' ) 28/09/2022 06:44:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3914' , '2' ) 28/09/2022 06:44:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3914' , '3' ) 28/09/2022 06:46:51 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3914' 28/09/2022 06:46:51 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 ( '3914' , '10' , '145' , 'PARROCCHIA SAN RUFINO' , '' , '' , 'VIALE REGINA MARGHERITA 177' , '' , '81034' , 'MONDRAGONE' , '' , '' , '' , '' , '' , NOW() , NOW() ) 28/09/2022 06:46:51 pm >> UPDATE ps_customer SET email = 'ronieeyong@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3914' 28/09/2022 06:53:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 06:53:01 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' , '2865' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.14' , NOW() , NOW() ) 28/09/2022 06:53:01 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 = '62496' 28/09/2022 06:53:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '62496' 28/09/2022 06:53:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62496' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 28/09/2022 06:53:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 28/09/2022 06:53:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 28/09/2022 06:53:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62496' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 28/09/2022 06:53:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 28/09/2022 06:53:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 28/09/2022 07:01:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2866' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 07:01:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2866' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.90' , '15.67' , NOW() , NOW() ) 28/09/2022 07:01:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62497' 28/09/2022 07:01:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '62497' 28/09/2022 07:01:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62497' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 28/09/2022 07:01:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 28/09/2022 07:01:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 28/09/2022 07:01:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62497' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/09/2022 07:01:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 28/09/2022 07:01:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 28/09/2022 07:01:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62497' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 28/09/2022 07:01:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 28/09/2022 07:01:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 28/09/2022 07:09:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571313' AND id_product != '14487' AND ean13 != '' 28/09/2022 07:09:16 pm >> UPDATE ps_product SET id_supplier = '127', reference = 'ESPOSITORE SAN PAOLO', ean13 = '9788899571313', date_upd = NOW() WHERE id_product = '14487' 28/09/2022 07:09:16 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DELLE 5 DITA', description = '' WHERE id_product = '14487' 28/09/2022 07:09:16 pm >> UPDATE ps_product SET wholesale_price = '0.98', on_sale = '0', price = '1.8' WHERE id_product = '14487' 28/09/2022 07:09:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.98', price = '1.8', id_tax_rules_group = '4', id_category_default = '37', 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 = '14487' 28/09/2022 07:09:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '14487' 28/09/2022 07:16:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 07:16:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '133' , '2022-09-28' , '' , '3914' , '0' , '4675034' , 'VIALE REGINA MARGHERITA 177 81034 MONDRAGONE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '57.69' , '53.41' , NOW() , NOW() ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62498' 28/09/2022 07:16:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '62498' 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '14487' , 'PREGHIERA DELLE 5 DITA' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '5' , '3.42' ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '17034' , 'SACRAMENTO DEL PERDONO' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '5' , '3.80' ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '14492' , 'SACRAMENTI SPIEGATI AI RAGAZZI - BATTESIMO' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '5' , '4.28' ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '14486' , 'SEMPRE CON TE ' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '5' , '23.75' ) 28/09/2022 07:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 28/09/2022 07:16:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 28/09/2022 07:16:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62498' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 28/09/2022 07:28:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2867' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 28/09/2022 07:28:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2867' , '2022-09-28' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 28/09/2022 07:28:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62499' 28/09/2022 07:28:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '62499' 28/09/2022 07:28:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62499' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 28/09/2022 07:28:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16865' AND id_supplier = '' 28/09/2022 07:28:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16865' , '' , '1' )