31/10/2022 08:18:11 am >> SELECT document_num FROM ps_document WHERE document_num = '103' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 08:18:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '103' , '2022-10-31' , '' , '7002' , '0' , '93349181' , 'Via Pietralacroce , 102 60129 Ancona ' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '31.16' , '31.16' , NOW() , NOW() ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '8178' 31/10/2022 08:18:11 am >> DELETE FROM ps_document_detail WHERE id_document = '8178' 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '20' , 'GIOVEDÌ SANTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '67' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '92' , 'LA PREGHIERA DEL ROSARIO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 31/10/2022 08:18:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8178' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 31/10/2022 08:21:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3261' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 08:21:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3261' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 31/10/2022 08:21:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70256' 31/10/2022 08:21:32 am >> DELETE FROM ps_document_detail WHERE id_document = '70256' 31/10/2022 08:21:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70256' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '9.90' ) 31/10/2022 08:21:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 31/10/2022 08:21:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 31/10/2022 08:28:50 am >> SELECT document_num FROM ps_document WHERE document_num = '227' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 08:28:50 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' , '227' , '2022-10-31' , '' , '3954' , '0' , '4676355' , 'VICO BERIO , 18 81013 PIANA DI MONTE VERNA ' , '' , '' , '5.00' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '25.01' , '25.01' , NOW() , NOW() ) 31/10/2022 08:28: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 = '70257' 31/10/2022 08:28:50 am >> DELETE FROM ps_document_detail WHERE id_document = '70257' 31/10/2022 08:28: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 ( '70257' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 31/10/2022 08:28: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 ( '70257' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/10/2022 08:28: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 ( '70257' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 31/10/2022 08:28: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 ( '70257' , '13397' , 'MIO GESU\'' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '5' , '3.33' ) 31/10/2022 08:28: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 ( '70257' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 31/10/2022 08:29:11 am >> SELECT document_num FROM ps_document WHERE document_num = '227' AND id_document != '70257' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 08:29:11 am >> UPDATE ps_document SET id_document_type = '21', document_num = '227', document_date = '2022-10-31', document_letter = '', id_customer = '3954', id_supplier = '', id_address = '4676355', address1 = 'VICO BERIO , 18 81013 PIANA DI MONTE VERNA ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '25.01', price_tax_excluded = '25.01', date_upd = NOW() WHERE id_document = '70257' 31/10/2022 08:29:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70257' 31/10/2022 08:29:11 am >> DELETE FROM ps_document_detail WHERE id_document = '70257' 31/10/2022 08:29:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70257' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 31/10/2022 08:29:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 31/10/2022 08:29:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 31/10/2022 08:29: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 ( '70257' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/10/2022 08:29:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 31/10/2022 08:29:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 31/10/2022 08:29: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 ( '70257' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 31/10/2022 08:29:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 31/10/2022 08:29:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 31/10/2022 08:29: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 ( '70257' , '13397' , 'MIO GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 31/10/2022 08:29:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 31/10/2022 08:29:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 31/10/2022 08:29: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 ( '70257' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 31/10/2022 08:29:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 31/10/2022 08:29:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 31/10/2022 08:29:46 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-10-30' WHERE id_order = '393' 31/10/2022 08:29:46 am >> DELETE FROM ps_document WHERE document_num = '393' AND id_document_type = '28' 31/10/2022 09:12:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3262' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 09:12: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 ( '11' , '3262' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 31/10/2022 09:12: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 = '70258' 31/10/2022 09:12:36 am >> DELETE FROM ps_document_detail WHERE id_document = '70258' 31/10/2022 09:12: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 ( '70258' , '623' , 'ANGELO CANDELA CELESTE CM 11' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 31/10/2022 09:12:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '623' AND id_supplier = '' 31/10/2022 09:12:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '623' , '' , '1' ) 31/10/2022 09:18:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3263' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 09:18:55 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' , '3263' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.70' , '37.26' , NOW() , NOW() ) 31/10/2022 09:18: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 = '70259' 31/10/2022 09:18:55 am >> DELETE FROM ps_document_detail WHERE id_document = '70259' 31/10/2022 09:18: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 ( '70259' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 31/10/2022 09:18:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 31/10/2022 09:18:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 31/10/2022 09:18: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 ( '70259' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/10/2022 09:18:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 31/10/2022 09:18:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 31/10/2022 09:18: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 ( '70259' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 31/10/2022 09:18:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '12578' AND id_supplier = '' 31/10/2022 09:18:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12578' , '' , '1' ) 31/10/2022 09:18: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 ( '70259' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 31/10/2022 09:18:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 31/10/2022 09:18:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 31/10/2022 09:18: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 ( '70259' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 31/10/2022 09:18:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 31/10/2022 09:18:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 31/10/2022 09:20:29 am >> SELECT document_num FROM ps_document WHERE document_num = '228' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 09:20:29 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' , '228' , '2022-10-31' , '' , '835' , '0' , '4671989' , 'VIA BRIGNANO INF 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.95' , '124.95' , NOW() , NOW() ) 31/10/2022 09:20:29 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 = '70260' 31/10/2022 09:20:29 am >> DELETE FROM ps_document_detail WHERE id_document = '70260' 31/10/2022 09:20:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70260' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.50' , '3.5' , '0' , '15' , '68.42' ) 31/10/2022 09:20:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70260' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 31/10/2022 09:20:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70260' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '15' , '11.90' ) 31/10/2022 09:23:17 am >> SELECT document_num FROM ps_document WHERE document_num = '211' AND id_document != '68628' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 31/10/2022 09:23:17 am >> UPDATE ps_document SET id_document_type = '21', document_num = '211', document_date = '2022-10-26', document_letter = '', id_customer = '344', id_supplier = '', id_address = '4676196', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '345.11', price_tax_excluded = '345.11', date_upd = NOW() WHERE id_document = '68628' 31/10/2022 09:23:17 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 = '68628' 31/10/2022 09:23:17 am >> DELETE FROM ps_document_detail WHERE id_document = '68628' 31/10/2022 09:23:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2022 09:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 31/10/2022 09:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 31/10/2022 09:23:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 31/10/2022 09:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 31/10/2022 09:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 31/10/2022 09:23:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 31/10/2022 09:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 31/10/2022 09:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 31/10/2022 09:23:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '45' , '-45' , '4' , '2.4000' , '2.4' , '0' , '15' , '91.80' ) 31/10/2022 09:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 31/10/2022 09:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 31/10/2022 09:23:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '4120' , 'FEDE NELLO ZAINETTO' , '30' , '-30' , '4' , '5.0000' , '5' , '0' , '15' , '127.50' ) 31/10/2022 09:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 31/10/2022 09:23:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 31/10/2022 09:23:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 31/10/2022 09:23:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 31/10/2022 09:23:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 31/10/2022 09:23:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 31/10/2022 09:23:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 31/10/2022 09:23:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 31/10/2022 09:23:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 31/10/2022 09:23:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 31/10/2022 09:23:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 31/10/2022 09:26:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3264' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 09:26:48 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' , '3264' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 31/10/2022 09:26:48 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 = '70261' 31/10/2022 09:26:48 am >> DELETE FROM ps_document_detail WHERE id_document = '70261' 31/10/2022 09:26:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70261' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 31/10/2022 09:26:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 31/10/2022 09:26:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 31/10/2022 09:29:07 am >> SELECT document_num FROM ps_document WHERE document_num = '228' AND id_document != '70260' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 09:29:07 am >> UPDATE ps_document SET id_document_type = '21', document_num = '228', document_date = '2022-10-31', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '124.95', price_tax_excluded = '124.95', date_upd = NOW() WHERE id_document = '70260' 31/10/2022 09:29:07 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 = '70260' 31/10/2022 09:29:07 am >> DELETE FROM ps_document_detail WHERE id_document = '70260' 31/10/2022 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70260' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.5000' , '3.5' , '0' , '15' , '68.42' ) 31/10/2022 09:29:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 31/10/2022 09:29:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 31/10/2022 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70260' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 31/10/2022 09:29:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 31/10/2022 09:29:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 31/10/2022 09:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70260' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 31/10/2022 09:29:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 31/10/2022 09:29:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 31/10/2022 09:32:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3265' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 09:32:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3265' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '7.33' , NOW() , NOW() ) 31/10/2022 09:32:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70262' 31/10/2022 09:32:20 am >> DELETE FROM ps_document_detail WHERE id_document = '70262' 31/10/2022 09:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70262' , '11379' , 'VIENI SPIRITO SANTO - 35 ' , '11' , '-11' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '1.65' ) 31/10/2022 09:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '11379' AND id_supplier = '' 31/10/2022 09:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11379' , '' , '1' ) 31/10/2022 09:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70262' , '8295' , 'PREGHIERA DELLAMMALATO - 19 - OGGETTI' , '5' , '-5' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.75' ) 31/10/2022 09:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8295' AND id_supplier = '' 31/10/2022 09:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8295' , '' , '1' ) 31/10/2022 09:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70262' , '5325' , 'INSEGNAMI LAMORE - 28' , '5' , '-5' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.75' ) 31/10/2022 09:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '5325' AND id_supplier = '' 31/10/2022 09:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5325' , '' , '1' ) 31/10/2022 09:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70262' , '5877' , 'LITANIE LAURETANE - 8674' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2022 09:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '5877' AND id_supplier = '' 31/10/2022 09:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5877' , '' , '1' ) 31/10/2022 09:33:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3266' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 09:33: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' , '3266' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 31/10/2022 09:33: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 = '70263' 31/10/2022 09:33:51 am >> DELETE FROM ps_document_detail WHERE id_document = '70263' 31/10/2022 09:33: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 ( '70263' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 31/10/2022 09:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 31/10/2022 09:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 31/10/2022 09:41:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '613185' , '2022-10-27' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.1' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.57' , '65.57' , NOW() , NOW() ) 31/10/2022 09:41:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70264' 31/10/2022 09:41:59 am >> DELETE FROM ps_document_detail WHERE id_document = '70264' 31/10/2022 09:41:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70264' , '14530' , 'PANE E VINO - GUIDA 3' , '7' , '7' , '4' , '15.00' , '15' , '0' , '35+7' , '63.4725' ) 31/10/2022 09:41:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '7' 31/10/2022 09:41:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '7' , '1' ) 31/10/2022 09:42:29 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/10/2022 09:42:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20250' , '1' , '' , 'nuovo-prodotto' ) 31/10/2022 09:42:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20250' , '1' , '1' , '2' , NOW() , NOW() ) 31/10/2022 09:42:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20250' , '0' , '1' , '0' , '0' ) 31/10/2022 09:43:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229884' AND id_product != '20250' AND ean13 != '' 31/10/2022 09:43:43 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA', ean13 = '9788892229884', date_upd = NOW() WHERE id_product = '20250' 31/10/2022 09:43:43 am >> UPDATE ps_product_lang SET name = 'PREGA MANGIA AMA - L. M. EPICOCO', description = '' WHERE id_product = '20250' 31/10/2022 09:43:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20250' 31/10/2022 09:43:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20250' 31/10/2022 09:43:43 am >> DELETE FROM ps_specific_price WHERE id_product = '20250' 31/10/2022 09:43:48 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20250' 31/10/2022 09:43:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20251' , '1' , '' , 'nuovo-prodotto' ) 31/10/2022 09:43:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20251' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20250' 31/10/2022 09:43:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20251' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20250' 31/10/2022 09:44:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '613306' , '2022-10-27' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '7.68' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '264.96' , '264.96' , NOW() , NOW() ) 31/10/2022 09:44:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70265' 31/10/2022 09:44:56 am >> DELETE FROM ps_document_detail WHERE id_document = '70265' 31/10/2022 09:44:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70265' , '20250' , 'PREGA MANGIA AMA - L. M. EPICOCO' , '24' , '24' , '4' , '16.00' , '16' , '0' , '33' , '257.2800' ) 31/10/2022 09:44:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '7' 31/10/2022 09:44:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '7' , '1' ) 31/10/2022 09:44:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70265' , '20250' , 'PREGA MANGIA AMA - L. M. EPICOCO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '100' , '0.0000' ) 31/10/2022 09:44:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '7' 31/10/2022 09:44:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '7' , '1' ) 31/10/2022 10:06:48 am >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 10:06:48 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' , '89/A' , '2022-10-31' , 'A' , '189' , '0' , '4670598' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '238.34' , '226.62' , NOW() , NOW() ) 31/10/2022 10:06:48 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 = '70266' 31/10/2022 10:06:48 am >> DELETE FROM ps_document_detail WHERE id_document = '70266' 31/10/2022 10:06:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70266' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '38' , '43.40' ) 31/10/2022 10:06:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70266' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '80' , '-80' , '4' , '2.40' , '2.4' , '0' , '38' , '119.04' ) 31/10/2022 10:06:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70266' , '12819' , 'REGISTRO DEL CATECHISTA ' , '100' , '-100' , '1' , '1.00' , '0.81967213114754' , '22' , '35' , '65.00' ) 31/10/2022 10:06:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70266' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '10.9' , '10.9' , '0' , '0' , '10.90' ) 31/10/2022 10:22:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3267' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 10:22:03 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' , '3267' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 31/10/2022 10:22:03 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 = '70267' 31/10/2022 10:22:03 am >> DELETE FROM ps_document_detail WHERE id_document = '70267' 31/10/2022 10:22:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70267' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 31/10/2022 10:22:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 31/10/2022 10:22:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 31/10/2022 10:27:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3268' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 10:27:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3268' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.31' , '14.13' , NOW() , NOW() ) 31/10/2022 10:27:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70268' 31/10/2022 10:27:26 am >> DELETE FROM ps_document_detail WHERE id_document = '70268' 31/10/2022 10:27:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70268' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 31/10/2022 10:27:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 31/10/2022 10:27:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 31/10/2022 10:27:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70268' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 31/10/2022 10:27:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 31/10/2022 10:27:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 31/10/2022 10:27:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70268' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 31/10/2022 10:27:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 31/10/2022 10:27:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 31/10/2022 10:27:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70268' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 31/10/2022 10:27:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 31/10/2022 10:27:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 31/10/2022 10:31:33 am >> SELECT document_num FROM ps_document WHERE document_num = '229' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 10:31:33 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' , '229' , '2022-10-31' , '' , '2823' , '0' , '4672634' , 'VIA ROMA, 1 83028 SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.13' , '36.13' , NOW() , NOW() ) 31/10/2022 10:31:33 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 = '70269' 31/10/2022 10:31:33 am >> DELETE FROM ps_document_detail WHERE id_document = '70269' 31/10/2022 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 31/10/2022 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 31/10/2022 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 31/10/2022 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 31/10/2022 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 31/10/2022 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 31/10/2022 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 31/10/2022 10:34:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3269' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 10:34:34 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' , '3269' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 31/10/2022 10:34:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70270' 31/10/2022 10:34:34 am >> DELETE FROM ps_document_detail WHERE id_document = '70270' 31/10/2022 10:34:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70270' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2022 10:34:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 31/10/2022 10:34:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 31/10/2022 10:38:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3270' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 10:38:34 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' , '3270' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.73' , '89.76' , NOW() , NOW() ) 31/10/2022 10:38:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70271' 31/10/2022 10:38:34 am >> DELETE FROM ps_document_detail WHERE id_document = '70271' 31/10/2022 10:38:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70271' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 31/10/2022 10:38:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 31/10/2022 10:38: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 ( '70271' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 31/10/2022 10:38:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 31/10/2022 10:38: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 ( '70271' , '20108' , 'AVVENTO 2022' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 31/10/2022 10:38:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20108' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20108' , '' , '1' ) 31/10/2022 10:38: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 ( '70271' , '13002' , 'ECCOMI TI ASCOLTO! - ANNO B - G. CALABRESE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 31/10/2022 10:38:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '13002' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13002' , '' , '1' ) 31/10/2022 10:38: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 ( '70271' , '14640' , 'ECCOMI TI ASCOLTO! - ANNO C - G. CALABRESE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 31/10/2022 10:38:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '14640' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14640' , '' , '1' ) 31/10/2022 10:38: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 ( '70271' , '20106' , 'GRIDIAMO IL VANGELO ANNO A - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 31/10/2022 10:38:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20106' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20106' , '' , '1' ) 31/10/2022 10:38: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 ( '70271' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '9' , '-9' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '18.00' ) 31/10/2022 10:38:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18896' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18896' , '' , '1' ) 31/10/2022 10:38: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 ( '70271' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '9' , '-9' , '4' , '1.00' , '1' , '0' , '5' , '8.55' ) 31/10/2022 10:38:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 31/10/2022 10:38:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 31/10/2022 10:42:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3271' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 10:42:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3271' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 31/10/2022 10:42:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70272' 31/10/2022 10:42:43 am >> DELETE FROM ps_document_detail WHERE id_document = '70272' 31/10/2022 10:42:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70272' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 31/10/2022 10:42:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '1370' AND id_supplier = '' 31/10/2022 10:42:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1370' , '' , '1' ) 31/10/2022 10:42:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70272' , '8937' , 'RICAMBIO TAPPO PER AMPOLLINA 503/4 - 102' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/10/2022 10:42:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '8937' AND id_supplier = '' 31/10/2022 10:42:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8937' , '' , '1' ) 31/10/2022 11:08:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3272' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 11:08:10 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' , '3272' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '86.99' , NOW() , NOW() ) 31/10/2022 11:08: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 = '70273' 31/10/2022 11:08:10 am >> DELETE FROM ps_document_detail WHERE id_document = '70273' 31/10/2022 11:08: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 ( '70273' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 31/10/2022 11:08: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 ( '70273' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 31/10/2022 11:08: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 ( '70273' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 31/10/2022 11:08: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 ( '70273' , '20057' , 'CINQUE PANI DORZO 2023' , '2' , '-2' , '4' , '6.90' , '6.9' , '0' , '5' , '13.12' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '' , '1' ) 31/10/2022 11:08: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 ( '70273' , '17416' , 'RETINA RICAMBIO ART 355' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '17416' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17416' , '' , '1' ) 31/10/2022 11:08: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 ( '70273' , '18031' , 'BRUCIAINCENSO H 8' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '18031' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18031' , '' , '1' ) 31/10/2022 11:08: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 ( '70273' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '29.63' , '24.286885245902' , '22' , '0' , '29.63' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 31/10/2022 11:08: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 ( '70273' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 31/10/2022 11:08:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '1621' AND id_supplier = '' 31/10/2022 11:08:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1621' , '' , '1' ) 31/10/2022 11:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70273' , '18846' , 'QUADRETTO MODELLO CAPANNA - P511' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 31/10/2022 11:08:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18846' AND id_supplier = '' 31/10/2022 11:08:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18846' , '' , '1' ) 31/10/2022 11:14:00 am >> DELETE FROM ps_document WHERE id_document = '69741' 31/10/2022 11:14:00 am >> DELETE FROM ps_document_detail WHERE id_document = '69741' 31/10/2022 11:16:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3273' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 11:16:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3273' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.00' , '229.51' , NOW() , NOW() ) 31/10/2022 11:16:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70274' 31/10/2022 11:16:56 am >> DELETE FROM ps_document_detail WHERE id_document = '70274' 31/10/2022 11:16: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 ( '70274' , '20223' , 'BAMBINELLO IN GESSO CM 50 - J202OA/50' , '1' , '-1' , '1' , '280' , '229.50819672131' , '22' , '0' , '280.00' ) 31/10/2022 11:16:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '20223' AND id_supplier = '' 31/10/2022 11:16:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20223' , '' , '1' ) 31/10/2022 11:30:09 am >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 11:30: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 ( '21' , '230' , '2022-10-31' , '' , '326' , '0' , '4671618' , 'VIALE 18 DICEMBRE 04100 LATINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '499.80' , '499.80' , NOW() , NOW() ) 31/10/2022 11:30: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 = '70275' 31/10/2022 11:30:09 am >> DELETE FROM ps_document_detail WHERE id_document = '70275' 31/10/2022 11:30: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 ( '70275' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.00' , '3' , '0' , '15' , '45.90' ) 31/10/2022 11:30: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 ( '70275' , '16199' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '18' , '-18' , '4' , '3.00' , '3' , '0' , '15' , '45.90' ) 31/10/2022 11:30: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 ( '70275' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '15' , '85.00' ) 31/10/2022 11:30: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 ( '70275' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '25' , '-25' , '4' , '6.20' , '6.2' , '0' , '15' , '131.75' ) 31/10/2022 11:30: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 ( '70275' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '150' , '-150' , '4' , '1.50' , '1.5' , '0' , '15' , '191.25' ) 31/10/2022 11:32:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3274' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 11:32:47 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' , '3274' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '242.90' , '208.13' , NOW() , NOW() ) 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70276' 31/10/2022 11:32:47 am >> DELETE FROM ps_document_detail WHERE id_document = '70276' 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70276' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 31/10/2022 11:32:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 31/10/2022 11:32:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70276' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 31/10/2022 11:32:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 31/10/2022 11:32:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70276' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 31/10/2022 11:32:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 31/10/2022 11:32:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70276' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/10/2022 11:32:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 31/10/2022 11:32:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70276' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 31/10/2022 11:32:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 31/10/2022 11:32:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70276' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 31/10/2022 11:32:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 31/10/2022 11:32:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 31/10/2022 11:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70276' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 31/10/2022 11:32:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 31/10/2022 11:32:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 31/10/2022 11:48:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3275' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 11:48:03 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' , '3275' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '413.00' , '338.52' , NOW() , NOW() ) 31/10/2022 11:48:03 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 = '70277' 31/10/2022 11:48:03 am >> DELETE FROM ps_document_detail WHERE id_document = '70277' 31/10/2022 11:48:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70277' , '18294' , 'TECA - 332' , '1' , '-1' , '1' , '275' , '225.40983606557' , '22' , '0' , '275.00' ) 31/10/2022 11:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18294' AND id_supplier = '' 31/10/2022 11:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18294' , '' , '1' ) 31/10/2022 11:48:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70277' , '18348' , 'TECA OSTIA MAGNA 17x23 - 823/M' , '1' , '-1' , '1' , '138.00' , '113.11475409836' , '22' , '0' , '138.00' ) 31/10/2022 11:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18348' AND id_supplier = '' 31/10/2022 11:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18348' , '' , '1' ) 31/10/2022 11:54:28 am >> SELECT document_num FROM ps_document WHERE document_num = '229' AND id_document != '70269' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 11:54:28 am >> UPDATE ps_document SET id_document_type = '21', document_num = '229', document_date = '2022-10-31', document_letter = '', id_customer = '2823', id_supplier = '', id_address = '4672634', address1 = 'VIA ROMA, 1 83028 SERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '36.13', price_tax_excluded = '36.13', date_upd = NOW() WHERE id_document = '70269' 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70269' 31/10/2022 11:54:28 am >> DELETE FROM ps_document_detail WHERE id_document = '70269' 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 31/10/2022 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 31/10/2022 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2022 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 31/10/2022 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 31/10/2022 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 31/10/2022 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2022 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 31/10/2022 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 31/10/2022 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 31/10/2022 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 31/10/2022 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 31/10/2022 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 31/10/2022 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70269' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2022 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 31/10/2022 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 31/10/2022 12:16:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3276' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 12:16:46 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' , '3276' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.10' , '18.76' , NOW() , NOW() ) 31/10/2022 12:16:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70278' 31/10/2022 12:16:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '70278' 31/10/2022 12:16:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70278' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 31/10/2022 12:16:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 31/10/2022 12:16:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 31/10/2022 12:16:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70278' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.1' , '8.1' , '0' , '0' , '8.10' ) 31/10/2022 12:16:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 31/10/2022 12:16:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 31/10/2022 12:33:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3277' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 12:33:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3277' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.00' , '159.84' , NOW() , NOW() ) 31/10/2022 12:33:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70279' 31/10/2022 12:33:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '70279' 31/10/2022 12:33: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 ( '70279' , '15666' , 'MIRACOLOSA CM 60 - PA602' , '1' , '-1' , '1' , '195.00' , '159.83606557377' , '22' , '0' , '195.00' ) 31/10/2022 12:33:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = '' 31/10/2022 12:33:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '' , '1' ) 31/10/2022 12:35:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '68029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-21') 31/10/2022 12:35:37 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2022-10-21', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '216.40', price_tax_excluded = '182.52', date_upd = NOW() WHERE id_document = '68029' 31/10/2022 12:35: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 = '68029' 31/10/2022 12:35:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '68029' 31/10/2022 12:35: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 ( '68029' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '29' , '-29' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '20.30' ) 31/10/2022 12:35:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16307' AND id_supplier = '' 31/10/2022 12:35:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16307' , '' , '1' ) 31/10/2022 12:35: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 ( '68029' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '14.00' ) 31/10/2022 12:35:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 31/10/2022 12:35:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 31/10/2022 12:35:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 31/10/2022 12:35:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 31/10/2022 12:35:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 31/10/2022 12:35:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '6019' , 'LUMINO ROSSO - 10B' , '384' , '-384' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '153.60' ) 31/10/2022 12:35:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6019' AND id_supplier = '' 31/10/2022 12:35:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6019' , '' , '1' ) 31/10/2022 12:36:43 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 31/10/2022 12:36:43 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '168' , '1' ) 31/10/2022 12:36:43 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '168' , '1' ) 31/10/2022 12:36:43 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '168' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 31/10/2022 12:38:14 pm >> UPDATE ps_address SET id_state = '210', lastname = 'DIGITAL PRESS SRL', address1 = 'VIA PALATUCCI 2', address2 = '', postcode = '84048', dni = '', vat_number = '04585630652', city = 'CASYELLABATE', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '168' 31/10/2022 12:38:14 pm >> UPDATE ps_supplier SET email = 'v.mucciolo@libero.it', name = 'DIGITAL PRESS SRL', date_upd = NOW() WHERE id_supplier = '168' 31/10/2022 12:38:14 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '168' 31/10/2022 12:39:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'FPR257/22' , '2022-10-31' , '22' , '0' , '168' , '4676356' , 'VIA PALATUCCI 2 84048 CASYELLABATE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '312.00' , '300.00' , NOW() , NOW() ) 31/10/2022 12:39:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70280' 31/10/2022 12:39:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '70280' 31/10/2022 12:39:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70280' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '150' , '150' , '3' , '2' , '1.9230769230769' , '4' , '0' , '312.0000' ) 31/10/2022 12:39:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '168' 31/10/2022 12:39:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '168' , '1' ) 31/10/2022 12:49:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '70275' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 12:49:57 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '230', document_date = '2022-10-31', document_letter = '', id_customer = '326', id_supplier = '', id_address = '4671618', address1 = 'VIALE 18 DICEMBRE 04100 LATINA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '499.80', price_tax_excluded = '499.80', date_upd = NOW() WHERE id_document = '70275' 31/10/2022 12: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 = '70275' 31/10/2022 12:49:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '70275' 31/10/2022 12: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 ( '70275' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 12:49:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 31/10/2022 12:49:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 31/10/2022 12: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 ( '70275' , '16199' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 12:49:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16199' AND id_supplier = '' 31/10/2022 12:49:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16199' , '' , '1' ) 31/10/2022 12: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 ( '70275' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '15' , '85.00' ) 31/10/2022 12:49:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 31/10/2022 12:49:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 31/10/2022 12: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 ( '70275' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '25' , '-25' , '4' , '6.2000' , '6.2' , '0' , '15' , '131.75' ) 31/10/2022 12:49:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '107' AND id_supplier = '' 31/10/2022 12:49:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '107' , '' , '1' ) 31/10/2022 12: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 ( '70275' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '150' , '-150' , '4' , '1.5000' , '1.5' , '0' , '15' , '191.25' ) 31/10/2022 12:49:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 31/10/2022 12:49:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 31/10/2022 02:44:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2282' AND id_document != '59704' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-15') 31/10/2022 02:44:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2282', 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 = '220.00', price_tax_excluded = '183.57', date_upd = NOW() WHERE id_document = '59704' 31/10/2022 02:44: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 = '59704' 31/10/2022 02:44:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '59704' 31/10/2022 02:44: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 ( '59704' , '12659' , 'CAMICE BIANCO - MISTO COT. 140' , '1' , '-1' , '1' , '54.5400' , '44.704918032787' , '22' , '0' , '54.54' ) 31/10/2022 02:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12659' AND id_supplier = '' 31/10/2022 02:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12659' , '' , '1' ) 31/10/2022 02:44: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 ( '59704' , '14796' , 'BELLA ADDORMENTATA' , '1' , '-1' , '4' , '8.9000' , '8.9' , '0' , '5' , '8.46' ) 31/10/2022 02:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14796' AND id_supplier = '' 31/10/2022 02:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14796' , '' , '1' ) 31/10/2022 02:44: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 ( '59704' , '11881' , 'IO E TE - BIBBIA DEI PICCOLI - 8828' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 31/10/2022 02:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11881' AND id_supplier = '' 31/10/2022 02:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11881' , '' , '1' ) 31/10/2022 02:44: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 ( '59704' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2022 02:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 31/10/2022 02:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 31/10/2022 02:44: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 ( '59704' , '16863' , 'CROCIFISSO SAGOMATO 50X32 ULIVO RAME - 105062' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 31/10/2022 02:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16863' AND id_supplier = '' 31/10/2022 02:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16863' , '' , '1' ) 31/10/2022 02:44: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 ( '59704' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 31/10/2022 02:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 31/10/2022 02:44:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 31/10/2022 02:44: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 ( '59704' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '4' , '-4' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '6.00' ) 31/10/2022 02:44:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 31/10/2022 02:44:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 31/10/2022 02:44: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 ( '59704' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 31/10/2022 02:44:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 31/10/2022 02:44:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 31/10/2022 03:31:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '68605' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-25') 31/10/2022 03:31:02 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '84/A', document_date = '2022-10-25', document_letter = 'A', id_customer = '3501', id_supplier = '', id_address = '4676192', address1 = 'PIAZZA S. EUSTACCHIO 84096 MONTECORVINO ROVELLA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '124.20', price_tax_excluded = '124.20', date_upd = NOW() WHERE id_document = '68605' 31/10/2022 03:31:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68605' 31/10/2022 03:31:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '68605' 31/10/2022 03:31: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 ( '68605' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '24' , '-24' , '4' , '2.7000' , '2.7' , '0' , '' , '64.80' ) 31/10/2022 03:31:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 31/10/2022 03:31:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 31/10/2022 03:31: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 ( '68605' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '22' , '-22' , '4' , '2.7000' , '2.7' , '0' , '0' , '59.40' ) 31/10/2022 03:31:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 31/10/2022 03:31:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 31/10/2022 03:33:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3278' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 03:33:11 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' , '3278' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.60' , '134.60' , NOW() , NOW() ) 31/10/2022 03:33: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 = '70281' 31/10/2022 03:33:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '70281' 31/10/2022 03:33: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 ( '70281' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '24' , '-24' , '4' , '2.7' , '2.7' , '0' , '0' , '64.80' ) 31/10/2022 03:33:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 31/10/2022 03:33:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 31/10/2022 03:33: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 ( '70281' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '22' , '-22' , '4' , '2.7' , '2.7' , '0' , '0' , '59.40' ) 31/10/2022 03:33:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 31/10/2022 03:33:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 31/10/2022 03:33: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 ( '70281' , '20055' , 'NON TEMERE - AVVENTO 2022' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '0' , '3.40' ) 31/10/2022 03:33:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20055' AND id_supplier = '' 31/10/2022 03:33:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20055' , '' , '1' ) 31/10/2022 03:33: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 ( '70281' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 31/10/2022 03:33:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 31/10/2022 03:33:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 31/10/2022 03:33:51 pm >> DELETE FROM ps_document WHERE id_document = '68605' 31/10/2022 03:33:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '68605' 31/10/2022 04:48:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '231' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 04:48: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' , '231' , '2022-10-31' , '' , '3453' , '0' , '4672147' , 'VIA SERGENTE MAGG. TAGLIANETTI 84024 CONTURSI TERME' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '168.13' , '168.13' , NOW() , NOW() ) 31/10/2022 04:48: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 = '70282' 31/10/2022 04:48:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '70282' 31/10/2022 04:48: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 ( '70282' , '4154' , 'FESTA DEL PERDONO' , '26' , '-26' , '4' , '3.00' , '3' , '0' , '15' , '66.30' ) 31/10/2022 04:48: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 ( '70282' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 31/10/2022 04:48: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 ( '70282' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '28' , '-28' , '4' , '1.60' , '1.6' , '0' , '15' , '38.08' ) 31/10/2022 04:48:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3279' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 04:48:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3279' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '19.38' , NOW() , NOW() ) 31/10/2022 04:48:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70283' 31/10/2022 04:48:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '70283' 31/10/2022 04:48:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70283' , '17241' , 'ACCENDIAMO IL NATALE - SPARTITO' , '1' , '-1' , '3' , '9.50' , '9.1346153846154' , '4' , '' , '9.50' ) 31/10/2022 04:48:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17241' AND id_supplier = '' 31/10/2022 04:48:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17241' , '' , '1' ) 31/10/2022 04:48:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70283' , '17240' , 'ACCENDIAMO IL NATALE - CD' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 31/10/2022 04:48:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17240' AND id_supplier = '' 31/10/2022 04:48:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17240' , '' , '1' ) 31/10/2022 04:51:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3280' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 04:51:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3280' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.40' , '10.16' , NOW() , NOW() ) 31/10/2022 04:51:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70284' 31/10/2022 04:51:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '70284' 31/10/2022 04:51:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70284' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '12.40' ) 31/10/2022 04:51:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 31/10/2022 04:51:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 31/10/2022 04:58:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3281' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 04:58: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' , '3281' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.45' , '29.71' , NOW() , NOW() ) 31/10/2022 04:58: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 = '70285' 31/10/2022 04:58:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '70285' 31/10/2022 04:58: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 ( '70285' , '7647' , 'PAROLE DI GESÙ MISERICORDIOSO - SUOR FAUSTINA' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 31/10/2022 04:58:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7647' AND id_supplier = '' 31/10/2022 04:58:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7647' , '' , '1' ) 31/10/2022 04:58: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 ( '70285' , '2935' , 'CROCE 20 CM FORATO - 4493/2' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 31/10/2022 04:58:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2935' AND id_supplier = '' 31/10/2022 04:58:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2935' , '' , '1' ) 31/10/2022 04:58: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 ( '70285' , '7125' , 'NOVENA E CORONCINA ALLANGELO RAFFAELE - 8262' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 31/10/2022 04:58:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7125' AND id_supplier = '' 31/10/2022 04:58:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7125' , '' , '1' ) 31/10/2022 04:58: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 ( '70285' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.80' , '4.7540983606557' , '22' , '0' , '5.80' ) 31/10/2022 04:58:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19717' AND id_supplier = '' 31/10/2022 04:58:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19717' , '' , '1' ) 31/10/2022 04:58: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 ( '70285' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2022 04:58:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 31/10/2022 04:58:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 31/10/2022 04:58:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3282' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 04:58:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3282' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/10/2022 04:58:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70286' 31/10/2022 04:58:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '70286' 31/10/2022 04:58:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70286' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2022 04:58:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 31/10/2022 04:58:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 31/10/2022 05:06:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '231' AND id_document != '70282' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:06:08 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '231', document_date = '2022-10-31', document_letter = '', id_customer = '3453', id_supplier = '', id_address = '4672147', address1 = 'VIA SERGENTE MAGG. TAGLIANETTI 84024 CONTURSI TERME', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '168.13', price_tax_excluded = '168.13', date_upd = NOW() WHERE id_document = '70282' 31/10/2022 05:06:09 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 = '70282' 31/10/2022 05:06:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '70282' 31/10/2022 05:06:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '4154' , 'FESTA DEL PERDONO' , '26' , '-26' , '4' , '3.0000' , '3' , '0' , '15' , '66.30' ) 31/10/2022 05:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 31/10/2022 05:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 31/10/2022 05:06:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 31/10/2022 05:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 31/10/2022 05:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 31/10/2022 05:06:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 31/10/2022 05:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 31/10/2022 05:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 31/10/2022 05:06:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.38' , '2.38' , '0' , '0' , '2.38' ) 31/10/2022 05:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 31/10/2022 05:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 31/10/2022 05:07:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '232' AND id_document != '70275' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:07:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '232', document_date = '2022-10-31', document_letter = '', id_customer = '326', id_supplier = '', id_address = '4671618', address1 = 'VIALE 18 DICEMBRE 04100 LATINA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '499.80', price_tax_excluded = '499.80', date_upd = NOW() WHERE id_document = '70275' 31/10/2022 05:07:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70275' 31/10/2022 05:07:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '70275' 31/10/2022 05:07:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 05:07:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 31/10/2022 05:07:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 31/10/2022 05:07:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '16199' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 05:07:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16199' AND id_supplier = '' 31/10/2022 05:07:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16199' , '' , '1' ) 31/10/2022 05:07:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '15' , '85.00' ) 31/10/2022 05:07:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 31/10/2022 05:07:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 31/10/2022 05:07:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '25' , '-25' , '4' , '6.2000' , '6.2' , '0' , '15' , '131.75' ) 31/10/2022 05:07:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '107' AND id_supplier = '' 31/10/2022 05:07:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '107' , '' , '1' ) 31/10/2022 05:07:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '150' , '-150' , '4' , '1.5000' , '1.5' , '0' , '15' , '191.25' ) 31/10/2022 05:07:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 31/10/2022 05:07:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 31/10/2022 05:07:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '70282' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:07:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '230', document_date = '2022-10-31', document_letter = '', id_customer = '3453', id_supplier = '', id_address = '4672147', address1 = 'VIA SERGENTE MAGG. TAGLIANETTI 84024 CONTURSI TERME', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '168.13', price_tax_excluded = '168.13', date_upd = NOW() WHERE id_document = '70282' 31/10/2022 05:07:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70282' 31/10/2022 05:07:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '70282' 31/10/2022 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '4154' , 'FESTA DEL PERDONO' , '26' , '-26' , '4' , '3.0000' , '3' , '0' , '15' , '66.30' ) 31/10/2022 05:07:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 31/10/2022 05:07:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 31/10/2022 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 31/10/2022 05:07:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 31/10/2022 05:07:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 31/10/2022 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 31/10/2022 05:07:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 31/10/2022 05:07:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 31/10/2022 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70282' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.3800' , '2.38' , '0' , '0' , '2.38' ) 31/10/2022 05:07:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 31/10/2022 05:07:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 31/10/2022 05:07:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '231' AND id_document != '70275' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:07:34 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '231', document_date = '2022-10-31', document_letter = '', id_customer = '326', id_supplier = '', id_address = '4671618', address1 = 'VIALE 18 DICEMBRE 04100 LATINA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '499.80', price_tax_excluded = '499.80', date_upd = NOW() WHERE id_document = '70275' 31/10/2022 05:07:34 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 = '70275' 31/10/2022 05:07:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '70275' 31/10/2022 05:07: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 ( '70275' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 05:07:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 31/10/2022 05:07:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 31/10/2022 05:07: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 ( '70275' , '16199' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 05:07:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16199' AND id_supplier = '' 31/10/2022 05:07:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16199' , '' , '1' ) 31/10/2022 05:07: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 ( '70275' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '15' , '85.00' ) 31/10/2022 05:07:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 31/10/2022 05:07:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 31/10/2022 05:07: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 ( '70275' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '25' , '-25' , '4' , '6.2000' , '6.2' , '0' , '15' , '131.75' ) 31/10/2022 05:07:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '107' AND id_supplier = '' 31/10/2022 05:07:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '107' , '' , '1' ) 31/10/2022 05:07: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 ( '70275' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '150' , '-150' , '4' , '1.5000' , '1.5' , '0' , '15' , '191.25' ) 31/10/2022 05:07:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 31/10/2022 05:07:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 31/10/2022 05:35:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3281' AND id_document != '70285' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:35:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3281', document_date = '2022-10-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 = '34.45', price_tax_excluded = '29.71', date_upd = NOW() WHERE id_document = '70285' 31/10/2022 05:35:30 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 = '70285' 31/10/2022 05:35:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '70285' 31/10/2022 05:35: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 ( '70285' , '7647' , 'PAROLE DI GESÙ MISERICORDIOSO - SUOR FAUSTINA' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 31/10/2022 05:35:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7647' AND id_supplier = '' 31/10/2022 05:35:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7647' , '' , '1' ) 31/10/2022 05:35: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 ( '70285' , '2935' , 'CROCE 20 CM FORATO - 4493/2' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 31/10/2022 05:35:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2935' AND id_supplier = '' 31/10/2022 05:35:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2935' , '' , '1' ) 31/10/2022 05:35: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 ( '70285' , '7125' , 'NOVENA E CORONCINA ALLANGELO RAFFAELE - 8262' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 31/10/2022 05:35:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7125' AND id_supplier = '' 31/10/2022 05:35:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7125' , '' , '1' ) 31/10/2022 05:35: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 ( '70285' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.8000' , '4.7540983606557' , '22' , '0' , '5.80' ) 31/10/2022 05:35:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19717' AND id_supplier = '' 31/10/2022 05:35:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19717' , '' , '1' ) 31/10/2022 05:35: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 ( '70285' , '9182' , 'ROSARIO S. BRIGIDA - 12-76 ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2022 05:35:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9182' AND id_supplier = '' 31/10/2022 05:35:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9182' , '' , '1' ) 31/10/2022 05:36:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3283' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:36:34 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' , '3283' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '1.97' , NOW() , NOW() ) 31/10/2022 05:36:34 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 = '70287' 31/10/2022 05:36:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '70287' 31/10/2022 05:36: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 ( '70287' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 31/10/2022 05:36:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 31/10/2022 05:36:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 31/10/2022 05:40:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3284' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:40:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3284' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.50' , '79.33' , NOW() , NOW() ) 31/10/2022 05:40:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70288' 31/10/2022 05:40:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '70288' 31/10/2022 05:40:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70288' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '30.00' ) 31/10/2022 05:40:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 31/10/2022 05:40:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 31/10/2022 05:40:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70288' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 31/10/2022 05:40:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 31/10/2022 05:40:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 31/10/2022 05:42:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '88/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 05:42:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '88/A' , '2022-10-31' , 'A' , '3510' , '0' , '4673605' , 'P.ZZA MACCHIARELLI 84084 VILLA DI FISCIANO' , '' , 'ACCONTO € 15,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 31/10/2022 05:42:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70289' 31/10/2022 05:42:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '70289' 31/10/2022 05:42:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70289' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 31/10/2022 06:04: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 ( '32' , '2022010001925' , '2022-10-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '39.84' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '907.60' , '907.60' , NOW() , NOW() ) 31/10/2022 06:04: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 = '70290' 31/10/2022 06:04:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '70290' 31/10/2022 06:04: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 ( '70290' , '18700' , 'DIO CAPOVOLTO - B. MAGGIONI' , '1' , '0' , '4' , '23.9000' , '23.9' , '0' , '35' , '15.54' ) 31/10/2022 06:04:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18700' AND id_supplier = '107' 31/10/2022 06:04:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18700' , '107' , '1' ) 31/10/2022 06:04: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 ( '70290' , '5868' , 'LINEAMENTI DI PATROLOGIA - L. DATTRINO' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '35' , '14.30' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5868' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5868' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '20139' , 'BANALITA DEL MALE - V. SERPE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20139' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20139' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '24' , '0' , '4' , '1.2000' , '1.2' , '0' , '35' , '18.72' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '2' , '0' , '4' , '1.2000' , '1.2' , '0' , '100' , '0.00' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '14322' , 'RELIGIOCANDO - SACRAMENTI E MIRACOLI' , '2' , '0' , '4' , '8.6000' , '8.6' , '0' , '35' , '11.18' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14322' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14322' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '5' , '0' , '4' , '14.8000' , '14.8' , '0' , '35' , '48.10' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20150' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20150' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '0' , '4' , '99.0000' , '99' , '0' , '35' , '64.35' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20151' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20151' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '10' , '0' , '4' , '1.2000' , '1.2' , '0' , '35' , '7.80' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '8469' , 'PRETE UNO SPOSO - BONETTI/PEDROLI' , '1' , '0' , '4' , '11.9000' , '11.9' , '0' , '35' , '7.74' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8469' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8469' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '20139' , 'BANALITA DEL MALE - V. SERPE' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '15.60' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20139' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20139' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '20191' , 'LITURGIA UNINTRODUZIONE' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '19.50' ) 31/10/2022 06:04:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20191' AND id_supplier = '107' 31/10/2022 06:04:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20191' , '107' , '1' ) 31/10/2022 06:04:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70290' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '46' , '0' , '4' , '1.2000' , '1.2' , '0' , '35' , '35.88' ) 31/10/2022 06:04:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 31/10/2022 06:04:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 31/10/2022 06:04: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 ( '70290' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 31/10/2022 06:04:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20009' AND id_supplier = '107' 31/10/2022 06:04:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20009' , '107' , '1' ) 31/10/2022 06:04: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 ( '70290' , '18311' , 'ANDATE E FATE IN MODO ... ANNO A - E. DELLA CORTE' , '1' , '0' , '4' , '27.0000' , '27' , '0' , '35' , '17.55' ) 31/10/2022 06:04:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18311' AND id_supplier = '107' 31/10/2022 06:04:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18311' , '107' , '1' ) 31/10/2022 06:04: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 ( '70290' , '19084' , 'OMELIE E PREDICAZIONE - CAVOLO/SODI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35' , '10.40' ) 31/10/2022 06:04:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19084' AND id_supplier = '107' 31/10/2022 06:04:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19084' , '107' , '1' ) 31/10/2022 06:04: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 ( '70290' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/10/2022 06:04:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 31/10/2022 06:04:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 31/10/2022 06:04: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 ( '70290' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '8' , '0' , '4' , '99.0000' , '99' , '0' , '35' , '514.80' ) 31/10/2022 06:04:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20151' AND id_supplier = '107' 31/10/2022 06:04:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20151' , '107' , '1' ) 31/10/2022 06:12:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 06:12:46 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' , '3285' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 31/10/2022 06:12:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70291' 31/10/2022 06:12:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '70291' 31/10/2022 06:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70291' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 31/10/2022 06:12:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 31/10/2022 06:12:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 31/10/2022 06:34:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '189' AND id_document != '67972' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-19') 31/10/2022 06:34:39 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '189', document_date = '2022-10-19', document_letter = '', id_customer = '964', id_supplier = '', id_address = '4671035', address1 = 'P.ZZA S. MICHELE 83029 SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '224.40', price_tax_excluded = '224.40', date_upd = NOW() WHERE id_document = '67972' 31/10/2022 06:34:39 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 = '67972' 31/10/2022 06:34:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '67972' 31/10/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67972' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '100' , '-100' , '4' , '2.4000' , '2.4' , '0' , '15' , '204.00' ) 31/10/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 31/10/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 31/10/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67972' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '4' , '-4' , '4' , '6.0000' , '6' , '0' , '15' , '20.40' ) 31/10/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 31/10/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 31/10/2022 06:42:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3286' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 06:42:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3286' , '2022-10-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 31/10/2022 06:42:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70292' 31/10/2022 06:42:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '70292' 31/10/2022 06:42:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70292' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 31/10/2022 06:42:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 31/10/2022 06:42:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 31/10/2022 06:43:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3286' AND id_document != '70292' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 31/10/2022 06:43:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3286', document_date = '2022-10-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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '70292' 31/10/2022 06:43:30 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 = '70292' 31/10/2022 06:43:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '70292' 31/10/2022 06:43: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 ( '70292' , '19344' , 'BALZA IN RASO - P354' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 31/10/2022 06:43:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19344' AND id_supplier = '' 31/10/2022 06:43:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19344' , '' , '1' ) 31/10/2022 07:04:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '231' AND id_document != '70275' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-02') 31/10/2022 07:04:00 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '231', document_date = '2022-11-02', document_letter = '', id_customer = '326', id_supplier = '', id_address = '4671618', address1 = 'VIALE 18 DICEMBRE 04100 LATINA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '499.80', price_tax_excluded = '499.80', date_upd = NOW() WHERE id_document = '70275' 31/10/2022 07:04: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 = '70275' 31/10/2022 07:04:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '70275' 31/10/2022 07:04: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 ( '70275' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 07:04:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 31/10/2022 07:04:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 31/10/2022 07:04: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 ( '70275' , '16199' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 31/10/2022 07:04:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16199' AND id_supplier = '' 31/10/2022 07:04:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16199' , '' , '1' ) 31/10/2022 07:04: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 ( '70275' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '15' , '85.00' ) 31/10/2022 07:04:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 31/10/2022 07:04:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 31/10/2022 07:04: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 ( '70275' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '25' , '-25' , '4' , '6.2000' , '6.2' , '0' , '15' , '131.75' ) 31/10/2022 07:04:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '107' AND id_supplier = '' 31/10/2022 07:04:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '107' , '' , '1' ) 31/10/2022 07:04: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 ( '70275' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '150' , '-150' , '4' , '1.5000' , '1.5' , '0' , '15' , '191.25' ) 31/10/2022 07:04:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 31/10/2022 07:04:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 31/10/2022 07:19:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870246' AND id_product != '20237' AND ean13 != '' 31/10/2022 07:19:35 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892870246', date_upd = NOW() WHERE id_product = '20237' 31/10/2022 07:19:35 pm >> UPDATE ps_product_lang SET name = 'SIATE FELICI - PAPA FRANCESCO', description = '' WHERE id_product = '20237' 31/10/2022 07:19:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.0000' WHERE id_product = '20237' 31/10/2022 07:19:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.0000', id_tax_rules_group = '4', id_category_default = '26', 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 = '20237' 31/10/2022 07:19:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '20237' 31/10/2022 07:27:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '5406' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-01') 31/10/2022 07:27:14 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '51', document_date = '2022-09-01', document_letter = '', id_customer = '3347', id_supplier = '', id_address = '4669949', address1 = 'LARGO DELLA VITTORIA, 4 25065 LUMEZZANE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '90.00', date_upd = NOW() WHERE id_document = '5406' 31/10/2022 07:27:14 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 = '5406' 31/10/2022 07:27:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '5406' 31/10/2022 07:27: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 ( '5406' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '5' , '-5' , '4' , '18.0000' , '18' , '0' , '0' , '90.00' ) 31/10/2022 07:27:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 31/10/2022 07:27:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 31/10/2022 08:01:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2965' AND id_document != '65206' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 31/10/2022 08:01:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2965', document_date = '2022-10-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.56', price_tax_excluded = '28.56', date_upd = NOW() WHERE id_document = '65206' 31/10/2022 08:01:14 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 = '65206' 31/10/2022 08:01:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '65206' 31/10/2022 08:01: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 ( '65206' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/10/2022 08:01:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6283' AND id_supplier = '' 31/10/2022 08:01:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6283' , '' , '1' ) 31/10/2022 08:01: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 ( '65206' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/10/2022 08:01:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 31/10/2022 08:01:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 31/10/2022 08:01: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 ( '65206' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 31/10/2022 08:01:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 31/10/2022 08:01:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 31/10/2022 08:01: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 ( '65206' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '5' , '14.16' ) 31/10/2022 08:01:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19932' AND id_supplier = '' 31/10/2022 08:01:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19932' , '' , '1' ) 31/10/2022 08:01: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 ( '65206' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.4' , '0.4' , '0' , '0' , '0.40' ) 31/10/2022 08:01:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 31/10/2022 08:01:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 31/10/2022 08:01: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 ( '65206' , '13878' , 'GAUDETE ET EXSULTATE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 31/10/2022 08:01:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13878' AND id_supplier = '' 31/10/2022 08:01:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13878' , '' , '1' )