23/11/2022 08:35:05 am >> DELETE FROM ps_product WHERE id_product = '8857' 23/11/2022 08:35:05 am >> DELETE FROM ps_product_shop WHERE id_product = '8857' 23/11/2022 08:35:05 am >> DELETE FROM ps_product_lang WHERE id_product = '8857' 23/11/2022 08:35:05 am >> DELETE FROM ps_stock_available WHERE id_product = '8857' 23/11/2022 09:50:17 am >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '74269' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-21') 23/11/2022 09:50:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '96/A', document_date = '2022-11-21', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania OSPEDALE DA PROCIDA', 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 = '359.90', price_tax_excluded = '295.00', date_upd = NOW() WHERE id_document = '74269' 23/11/2022 09:50: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 = '74269' 23/11/2022 09:50:17 am >> DELETE FROM ps_document_detail WHERE id_document = '74269' 23/11/2022 09:50: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 ( '74269' , '19748' , 'CORONA D\'AVVENTO STELLE' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 23/11/2022 09:50:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19748' AND id_supplier = '' 23/11/2022 09:50:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19748' , '' , '1' ) 23/11/2022 09:50: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 ( '74269' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '26.00' ) 23/11/2022 09:50:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 23/11/2022 09:50:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 23/11/2022 09:50: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 ( '74269' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/11/2022 09:50:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/11/2022 09:50:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/11/2022 09:50: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 ( '74269' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '25.50' ) 23/11/2022 09:50:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 23/11/2022 09:50:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 23/11/2022 09:50: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 ( '74269' , '18846' , 'QUADRETTO MODELLO CAPANNA - P511' , '30' , '-30' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '75.00' ) 23/11/2022 09:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '18846' AND id_supplier = '' 23/11/2022 09:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18846' , '' , '1' ) 23/11/2022 09:50: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 ( '74269' , '18847' , 'QUADRETTO NATIVITA ORO A CALDO - P662' , '30' , '-30' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '81.00' ) 23/11/2022 09:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '18847' AND id_supplier = '' 23/11/2022 09:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18847' , '' , '1' ) 23/11/2022 09:50: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 ( '74269' , '14835' , 'STELLA COMETA - P581' , '30' , '-30' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '72.00' ) 23/11/2022 09:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '14835' AND id_supplier = '' 23/11/2022 09:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14835' , '' , '1' ) 23/11/2022 09:50:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3554' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 09:50: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' , '3554' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 23/11/2022 09:50: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 = '74801' 23/11/2022 09:50:36 am >> DELETE FROM ps_document_detail WHERE id_document = '74801' 23/11/2022 09:50: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 ( '74801' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/11/2022 09:50:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/11/2022 09:50:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/11/2022 09:51:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3555' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 09:51:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3555' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 23/11/2022 09:51:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74802' 23/11/2022 09:51:57 am >> DELETE FROM ps_document_detail WHERE id_document = '74802' 23/11/2022 09:51: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 ( '74802' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 23/11/2022 09:51:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20247' AND id_supplier = '' 23/11/2022 09:51:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20247' , '' , '1' ) 23/11/2022 10:15:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3556' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 10:15: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' , '3556' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.02' , '27.02' , NOW() , NOW() ) 23/11/2022 10:15: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 = '74803' 23/11/2022 10:15:10 am >> DELETE FROM ps_document_detail WHERE id_document = '74803' 23/11/2022 10:15: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 ( '74803' , '13397' , 'MIO GESU' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '5' , '9.99' ) 23/11/2022 10:15:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 23/11/2022 10:15:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 23/11/2022 10:15: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 ( '74803' , '2679' , 'CONOSCERE GESU' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '5' , '9.99' ) 23/11/2022 10:15:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 23/11/2022 10:15:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 23/11/2022 10:15: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 ( '74803' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 23/11/2022 10:15:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 23/11/2022 10:15:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 23/11/2022 10:15: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 ( '74803' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 23/11/2022 10:15:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '17242' AND id_supplier = '' 23/11/2022 10:15:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17242' , '' , '1' ) 23/11/2022 10:20:43 am >> SELECT document_num FROM ps_document WHERE document_num = '309' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 10:20:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '309' , '2022-11-23' , '' , '2757' , '0' , '4671725' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '5' , '0' , '92.23' , '92.23' , NOW() , NOW() ) 23/11/2022 10:20: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 = '74804' 23/11/2022 10:20:43 am >> DELETE FROM ps_document_detail WHERE id_document = '74804' 23/11/2022 10:20: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 ( '74804' , '2679' , 'CONOSCERE GESU\'' , '31' , '-31' , '4' , '3.50' , '3.5' , '0' , '15' , '92.23' ) 23/11/2022 10:20:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3557' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 10:20:58 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' , '3557' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '273.50' , '272.06' , NOW() , NOW() ) 23/11/2022 10:20:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74805' 23/11/2022 10:20:58 am >> DELETE FROM ps_document_detail WHERE id_document = '74805' 23/11/2022 10:20:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74805' , '18703' , 'IN_SEGUENDO GESU\' A CAFARNAO' , '21' , '-21' , '4' , '4.5' , '4.5' , '0' , '0' , '94.50' ) 23/11/2022 10:20:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '' 23/11/2022 10:20:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '' , '1' ) 23/11/2022 10:20:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74805' , '18704' , 'IN_SEGUENDO GESU\' A NAZARET' , '23' , '-23' , '4' , '4.5' , '4.5' , '0' , '0' , '103.50' ) 23/11/2022 10:20:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18704' AND id_supplier = '' 23/11/2022 10:20:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18704' , '' , '1' ) 23/11/2022 10:20:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74805' , '18691' , 'IN_SEGUENDO GESU\' a emmaus - QUADERNO' , '15' , '-15' , '4' , '4.5' , '4.5' , '0' , '0' , '67.50' ) 23/11/2022 10:20:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18691' AND id_supplier = '' 23/11/2022 10:20:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18691' , '' , '1' ) 23/11/2022 10:20:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74805' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '8.00' ) 23/11/2022 10:20:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 23/11/2022 10:20:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 23/11/2022 10:29:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3558' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 10:29: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' , '3558' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.31' , '9.31' , NOW() , NOW() ) 23/11/2022 10:29: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 = '74806' 23/11/2022 10:29:43 am >> DELETE FROM ps_document_detail WHERE id_document = '74806' 23/11/2022 10:29: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 ( '74806' , '9420' , 'SAN FRANCESCO DASSISI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/11/2022 10:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '9420' AND id_supplier = '' 23/11/2022 10:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9420' , '' , '1' ) 23/11/2022 10:29: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 ( '74806' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '-1' , '4' , '4.80' , '4.8' , '0' , '5' , '4.56' ) 23/11/2022 10:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18423' AND id_supplier = '' 23/11/2022 10:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18423' , '' , '1' ) 23/11/2022 10:36:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3559' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 10:36:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3559' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.17' , '50.17' , NOW() , NOW() ) 23/11/2022 10:36:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74807' 23/11/2022 10:36:16 am >> DELETE FROM ps_document_detail WHERE id_document = '74807' 23/11/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74807' , '20248' , 'FORZA DELLO SPIRITO - C. MIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 23/11/2022 10:36:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20248' AND id_supplier = '' 23/11/2022 10:36:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20248' , '' , '1' ) 23/11/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74807' , '20452' , 'DANZA DEI GREMBI - E. RONCHI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 23/11/2022 10:36:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20452' AND id_supplier = '' 23/11/2022 10:36:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20452' , '' , '1' ) 23/11/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74807' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 23/11/2022 10:36:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 23/11/2022 10:36:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 23/11/2022 10:36:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74807' , '20018' , 'VITA DI GESU - A. TORNIELLI' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '5' , '17.01' ) 23/11/2022 10:36:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20018' AND id_supplier = '' 23/11/2022 10:36:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20018' , '' , '1' ) 23/11/2022 10:58:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3560' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 10:58:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3560' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '128.00' , '104.92' , NOW() , NOW() ) 23/11/2022 10:58:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74808' 23/11/2022 10:58:12 am >> DELETE FROM ps_document_detail WHERE id_document = '74808' 23/11/2022 10:58: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 ( '74808' , '19319' , 'QUADRO PIASTRELLA 20X20 S. GIUSEPPE - 2189/I0119' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 23/11/2022 10:58:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19319' AND id_supplier = '' 23/11/2022 10:58:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19319' , '' , '1' ) 23/11/2022 10:58: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 ( '74808' , '19320' , 'QUADRO PIASTRELLA 20X20 SACRA FAMIGLIA - 2189/I0102' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 23/11/2022 10:58:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19320' AND id_supplier = '' 23/11/2022 10:58:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19320' , '' , '1' ) 23/11/2022 10:58: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 ( '74808' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 23/11/2022 10:58:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '12527' AND id_supplier = '' 23/11/2022 10:58:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12527' , '' , '1' ) 23/11/2022 10:58:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74808' , '5975' , 'LUCERNA IN VETRO ROSSO - DIAM. 14 - 1491' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 23/11/2022 10:58:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '5975' AND id_supplier = '' 23/11/2022 10:58:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5975' , '' , '1' ) 23/11/2022 11:09:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3561' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 11:09:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3561' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 23/11/2022 11:09:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74809' 23/11/2022 11:09:18 am >> DELETE FROM ps_document_detail WHERE id_document = '74809' 23/11/2022 11:09: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 ( '74809' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/11/2022 11:09:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 23/11/2022 11:09:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 23/11/2022 11:10:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3562' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 11:10:19 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' , '3562' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '16.90' , NOW() , NOW() ) 23/11/2022 11:10:19 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 = '74810' 23/11/2022 11:10:19 am >> DELETE FROM ps_document_detail WHERE id_document = '74810' 23/11/2022 11:10:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74810' , '20459' , 'ACCENDI LA LUCE AL TUO NATALE POSTER' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 23/11/2022 11:10:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '20459' AND id_supplier = '' 23/11/2022 11:10:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20459' , '' , '1' ) 23/11/2022 11:10:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74810' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 23/11/2022 11:10:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 23/11/2022 11:10:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 23/11/2022 11:12:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3563' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 11:12:38 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' , '3563' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '18.27' , NOW() , NOW() ) 23/11/2022 11:12:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74811' 23/11/2022 11:12:38 am >> DELETE FROM ps_document_detail WHERE id_document = '74811' 23/11/2022 11:12:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74811' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '19.00' ) 23/11/2022 11:12:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/11/2022 11:12:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/11/2022 11:27:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3564' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 11:27:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3564' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.75' , '34.26' , NOW() , NOW() ) 23/11/2022 11:27: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 = '74812' 23/11/2022 11:27:28 am >> DELETE FROM ps_document_detail WHERE id_document = '74812' 23/11/2022 11:27: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 ( '74812' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 23/11/2022 11:27:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 23/11/2022 11:27:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 23/11/2022 11:27: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 ( '74812' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/11/2022 11:27:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 23/11/2022 11:27:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 23/11/2022 11:40:05 am >> SELECT document_num FROM ps_document WHERE document_num = '309' AND id_document != '74804' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 11:40:05 am >> UPDATE ps_document SET id_document_type = '21', document_num = '309', document_date = '2022-11-23', document_letter = '', id_customer = '2757', id_supplier = '', id_address = '4671725', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '92.23', price_tax_excluded = '92.23', date_upd = NOW() WHERE id_document = '74804' 23/11/2022 11:40:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74804' 23/11/2022 11:40:05 am >> DELETE FROM ps_document_detail WHERE id_document = '74804' 23/11/2022 11:40:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74804' , '2679' , 'CONOSCERE GESU\'' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 23/11/2022 11:40:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 23/11/2022 11:40:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 23/11/2022 11:46: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 ( '34' , '639/X' , '2022-11-21' , 'X' , '0' , '73' , '2668' , 'VIA P. TRIBOLDI, 4 26015 SORESINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '658.80' , '540.00' , NOW() , NOW() ) 23/11/2022 11:46: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 = '74813' 23/11/2022 11:46:11 am >> DELETE FROM ps_document_detail WHERE id_document = '74813' 23/11/2022 11:46: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 ( '74813' , '20030' , 'CANDELE ALTARE 20X400' , '9' , '-9' , '1' , '60' , '49.180327868852' , '22' , '0' , '658.8000' ) 23/11/2022 11:46:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '20030' AND id_supplier = '73' 23/11/2022 11:46:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20030' , '73' , '1' ) 23/11/2022 11:46:46 am >> SELECT document_num FROM ps_document WHERE document_num = '95/A' AND id_document != '73157' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-16') 23/11/2022 11:46:46 am >> UPDATE ps_document SET id_document_type = '24', document_num = '95/A', document_date = '2022-11-16', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '2668', address1 = 'VIA P. TRIBOLDI, 4 26015 SORESINA', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '73157' 23/11/2022 11:46:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73157' 23/11/2022 11:46:46 am >> DELETE FROM ps_document_detail WHERE id_document = '73157' 23/11/2022 11:46:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73157' , '20030' , 'CANDELE ALTARE 20X400 9 cartoni da 10 kg' , '9' , '0' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 23/11/2022 11:46:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20030' AND id_supplier = '' 23/11/2022 11:46:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20030' , '' , '1' ) 23/11/2022 11:47:10 am >> DELETE FROM ps_document WHERE id_document = '73157' 23/11/2022 11:47:10 am >> DELETE FROM ps_document_detail WHERE id_document = '73157' 23/11/2022 11:51:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3454' AND id_document != '73106' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-14') 23/11/2022 11:51:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3454', document_date = '2022-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.50', price_tax_excluded = '32.56', date_upd = NOW() WHERE id_document = '73106' 23/11/2022 11:51:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73106' 23/11/2022 11:51:55 am >> DELETE FROM ps_document_detail WHERE id_document = '73106' 23/11/2022 11:51: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 ( '73106' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '16.50' ) 23/11/2022 11:51:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 23/11/2022 11:51:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 23/11/2022 11:51: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 ( '73106' , '12919' , 'CONFEZIONE CARTONCINO CON BAMBINO - P422' , '20' , '-20' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '12.00' ) 23/11/2022 11:51:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '12919' AND id_supplier = '' 23/11/2022 11:51:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12919' , '' , '1' ) 23/11/2022 11:51: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 ( '73106' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 23/11/2022 11:51:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 23/11/2022 11:51:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 23/11/2022 11:51: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 ( '73106' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/11/2022 11:51:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 23/11/2022 11:51:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 23/11/2022 11:58:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3565' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 11:58:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3565' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.90' , '39.90' , NOW() , NOW() ) 23/11/2022 11:58:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74814' 23/11/2022 11:58:49 am >> DELETE FROM ps_document_detail WHERE id_document = '74814' 23/11/2022 11:58:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74814' , '20327' , 'SIGNORE INSEGNACI A PREGARE' , '2' , '-2' , '4' , '15.00' , '15' , '0' , '5' , '28.50' ) 23/11/2022 11:58:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '20327' AND id_supplier = '' 23/11/2022 11:58:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20327' , '' , '1' ) 23/11/2022 11:58:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74814' , '20330' , 'VIVERE NELLA DIVINA VOLONTA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/11/2022 11:58:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '20330' AND id_supplier = '' 23/11/2022 11:58:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20330' , '' , '1' ) 23/11/2022 11:59:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3566' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 11:59:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3566' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 23/11/2022 11:59:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74815' 23/11/2022 11:59:27 am >> DELETE FROM ps_document_detail WHERE id_document = '74815' 23/11/2022 11:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74815' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 23/11/2022 11:59:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/11/2022 11:59:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/11/2022 12:16:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3567' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 12:16:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3567' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 23/11/2022 12:16:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74816' 23/11/2022 12:16:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '74816' 23/11/2022 12:16:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74816' , '17568' , 'BAMBINO IN RESINA FASCIA ORO - PB13629' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 23/11/2022 12:16:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17568' AND id_supplier = '' 23/11/2022 12:16:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17568' , '' , '1' ) 23/11/2022 12:48:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3568' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 12:48:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3568' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.33' , '3.33' , NOW() , NOW() ) 23/11/2022 12:48:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74817' 23/11/2022 12:48:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '74817' 23/11/2022 12:48:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74817' , '19043' , 'HA VINTO IL TUO AMORE - AGG. CANTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 23/11/2022 12:48:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19043' AND id_supplier = '' 23/11/2022 12:48:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19043' , '' , '1' ) 23/11/2022 03:52:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3569' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 03:52:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3569' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '340.00' , '278.69' , NOW() , NOW() ) 23/11/2022 03:52:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74818' 23/11/2022 03:52:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '74818' 23/11/2022 03:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74818' , '16764' , 'AMPOLLE SU VASSOIO IN VETRO - 1521' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 23/11/2022 03:52:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16764' AND id_supplier = '' 23/11/2022 03:52:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16764' , '' , '1' ) 23/11/2022 03:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74818' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 23/11/2022 03:52:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/11/2022 03:52:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/11/2022 03:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74818' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 23/11/2022 03:52:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/11/2022 03:52:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/11/2022 03:52:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3570' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 03:52:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3570' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 23/11/2022 03:52:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74819' 23/11/2022 03:52:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '74819' 23/11/2022 03:52:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74819' , '6810' , 'MOCCOLO 80X150' , '4' , '-4' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '28.00' ) 23/11/2022 03:52:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6810' AND id_supplier = '' 23/11/2022 03:52:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6810' , '' , '1' ) 23/11/2022 03:54:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3571' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 03:54: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' , '3571' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.80' , '39.07' , NOW() , NOW() ) 23/11/2022 03:54: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 = '74820' 23/11/2022 03:54:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '74820' 23/11/2022 03:54: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 ( '74820' , '6811' , 'MOCCOLO 80X200' , '3' , '-3' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '27.00' ) 23/11/2022 03:54:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 23/11/2022 03:54:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 23/11/2022 03:54: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 ( '74820' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 23/11/2022 03:54:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 23/11/2022 03:54:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 23/11/2022 03:54: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 ( '74820' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/11/2022 03:54:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/11/2022 03:54:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/11/2022 03:54: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 ( '74820' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 23/11/2022 03:54:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/11/2022 03:54:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/11/2022 03:55:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3572' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 03:55:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3572' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.80' , '47.38' , NOW() , NOW() ) 23/11/2022 03:55:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74821' 23/11/2022 03:55:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '74821' 23/11/2022 03:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74821' , '6811' , 'MOCCOLO 80X200' , '3' , '-3' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '27.00' ) 23/11/2022 03:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 23/11/2022 03:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 23/11/2022 03:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74821' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 23/11/2022 03:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 23/11/2022 03:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 23/11/2022 03:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74821' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '19' , '-19' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '22.80' ) 23/11/2022 03:55:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13334' AND id_supplier = '' 23/11/2022 03:55:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13334' , '' , '1' ) 23/11/2022 03:59:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3239' AND id_document != '69719' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-28') 23/11/2022 03:59:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3239', document_date = '2022-10-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.58', price_tax_excluded = '24.06', date_upd = NOW() WHERE id_document = '69719' 23/11/2022 03:59:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69719' 23/11/2022 03:59:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '69719' 23/11/2022 03:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69719' , '20238' , 'SARANNO TESTIMONI - W. CAZZANIGA' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 23/11/2022 03:59:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20238' AND id_supplier = '' 23/11/2022 03:59:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20238' , '' , '1' ) 23/11/2022 03:59:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69719' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 23/11/2022 03:59:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/11/2022 03:59:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/11/2022 03:59:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69719' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 23/11/2022 03:59:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 23/11/2022 03:59:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 23/11/2022 04:14:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '61794' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 23/11/2022 04:14:44 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2022-09-14', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.80', price_tax_excluded = '7.80', date_upd = NOW() WHERE id_document = '61794' 23/11/2022 04:14:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61794' 23/11/2022 04:14:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '61794' 23/11/2022 04:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 23/11/2022 04:14:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 23/11/2022 04:14:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 23/11/2022 04:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 23/11/2022 04:14:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 23/11/2022 04:14:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 23/11/2022 04:37:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3573' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 04:37:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3573' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '166.20' , '138.25' , NOW() , NOW() ) 23/11/2022 04:37:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74822' 23/11/2022 04:37:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '74822' 23/11/2022 04:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74822' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '1' , '-1' , '4' , '11.2' , '11.2' , '0' , '0' , '11.20' ) 23/11/2022 04:37:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 23/11/2022 04:37:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 23/11/2022 04:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74822' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 23/11/2022 04:37:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '' 23/11/2022 04:37:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '' , '1' ) 23/11/2022 04:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74822' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/11/2022 04:37:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 23/11/2022 04:37:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 23/11/2022 04:40:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3574' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 04:40:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3574' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 23/11/2022 04:40:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74823' 23/11/2022 04:40:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '74823' 23/11/2022 04:40:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74823' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '26.00' ) 23/11/2022 04:40:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 23/11/2022 04:40:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 23/11/2022 04:46:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3573' AND id_document != '74822' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 04:46:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3573', document_date = '2022-11-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '166.20', price_tax_excluded = '138.25', date_upd = NOW() WHERE id_document = '74822' 23/11/2022 04:46:56 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 = '74822' 23/11/2022 04:46:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '74822' 23/11/2022 04:46: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 ( '74822' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '1' , '-1' , '4' , '1.6' , '1.6' , '0' , '0' , '1.60' ) 23/11/2022 04:46:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 23/11/2022 04:46:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 23/11/2022 04:46: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 ( '74822' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 23/11/2022 04:46:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '' 23/11/2022 04:46:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '' , '1' ) 23/11/2022 04:46: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 ( '74822' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/11/2022 04:46:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 23/11/2022 04:46:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 23/11/2022 04:46: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 ( '74822' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '320' , '-320' , '4' , '0.03' , '0.03' , '0' , '0' , '9.60' ) 23/11/2022 04:46:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 23/11/2022 04:46:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 23/11/2022 05:00:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 05:00:51 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' , '310' , '2022-11-23' , '' , '979' , '0' , '4671729' , 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '17.00' , NOW() , NOW() ) 23/11/2022 05:00:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74824' 23/11/2022 05:00:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '74824' 23/11/2022 05:00:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74824' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '15' , '17.00' ) 23/11/2022 05:08:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400109' AND id_product != '20416' AND ean13 != '' 23/11/2022 05:08:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400109', date_upd = NOW() WHERE id_product = '20416' 23/11/2022 05:08:25 pm >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 11', description = '' WHERE id_product = '20416' 23/11/2022 05:08:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20416' 23/11/2022 05:08:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20416' 23/11/2022 05:08:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20416' 23/11/2022 05:08:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2022000006591' , '2022-11-22' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.57' , '108.57' , NOW() , NOW() ) 23/11/2022 05:08: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 = '74825' 23/11/2022 05:08:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '74825' 23/11/2022 05:08: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 ( '74825' , '20416' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 11' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 23/11/2022 05:08:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20416' AND id_supplier = '107' 23/11/2022 05:08:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20416' , '107' , '1' ) 23/11/2022 05:08: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 ( '74825' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 23/11/2022 05:08:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '107' 23/11/2022 05:08:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '107' , '1' ) 23/11/2022 05:08: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 ( '74825' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '5' , '5' , '4' , '4.00' , '4' , '0' , '35' , '13.0000' ) 23/11/2022 05:08:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '107' 23/11/2022 05:08:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '107' , '1' ) 23/11/2022 05:15:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3575' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 05:15:08 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' , '3575' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 23/11/2022 05:15:08 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 = '74826' 23/11/2022 05:15:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '74826' 23/11/2022 05:15: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 ( '74826' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '40' , '40' , '0' , '0' , '40.00' ) 23/11/2022 05:15:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 23/11/2022 05:15:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 23/11/2022 05:16:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '6590/00' , '2022-11-22' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '24.00' , NOW() , NOW() ) 23/11/2022 05:16:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74827' 23/11/2022 05:16:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '74827' 23/11/2022 05:16:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74827' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '12' , '12' , '4' , '2.00' , '2' , '0' , '0' , '24.0000' ) 23/11/2022 05:22:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '74824' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 05:22:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '310', document_date = '2022-11-23', document_letter = '', id_customer = '979', id_supplier = '', id_address = '4671729', address1 = 'VIA ROBERTO MAZZETTI, 5/A 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 = '17.00', price_tax_excluded = '17.00', date_upd = NOW() WHERE id_document = '74824' 23/11/2022 05:22: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 = '74824' 23/11/2022 05:22:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '74824' 23/11/2022 05:22: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 ( '74824' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '8' , '-8' , '4' , '2.5000' , '2.5' , '0' , '15' , '17.00' ) 23/11/2022 05:22:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 23/11/2022 05:22:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 23/11/2022 05:25: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 ( '33' , '6585/00' , '2022-11-22' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '500.00' , '500.00' , NOW() , NOW() ) 23/11/2022 05:25: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 = '8710' 23/11/2022 05:25:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '8710' 23/11/2022 05:25: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 ( '8710' , '17' , 'LA FEDE NELLO ZAINETTO' , '100' , '100' , '4' , '5.00' , '5' , '0' , '0' , '500.0000' ) 23/11/2022 05:26:06 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '6590/00', document_date = '2022-11-22', document_letter = '00', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RIENTRO', 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 = '24.00', price_tax_excluded = '24.00', date_upd = NOW() WHERE id_document = '74827' 23/11/2022 05:26:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74827' 23/11/2022 05:26:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '74827' 23/11/2022 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74827' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '12' , '12' , '4' , '2.0000' , '2' , '0' , '0' , '24.00' ) 23/11/2022 05:26:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = '' 23/11/2022 05:26:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' ) 23/11/2022 05:26:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '74257' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 23/11/2022 05:26:49 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '303', document_date = '2022-11-21', document_letter = '', id_customer = '559', id_supplier = '', id_address = '4677368', address1 = 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA', 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 = '230.35', price_tax_excluded = '230.35', date_upd = NOW() WHERE id_document = '74257' 23/11/2022 05:26:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74257' 23/11/2022 05:26:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '74257' 23/11/2022 05:26:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74257' , '2679' , 'CONOSCERE GESU\'' , '19' , '-19' , '4' , '3.5000' , '3.5' , '0' , '15' , '56.52' ) 23/11/2022 05:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 23/11/2022 05:26:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 23/11/2022 05:26:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74257' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '22' , '-22' , '4' , '3.5000' , '3.5' , '0' , '15' , '65.45' ) 23/11/2022 05:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 23/11/2022 05:26:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 23/11/2022 05:26:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74257' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 23/11/2022 05:26:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 23/11/2022 05:26:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 23/11/2022 05:26:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74257' , '9675' , 'SARETE MIEI TESTIMONI' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 23/11/2022 05:26:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 23/11/2022 05:26:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 23/11/2022 05:28:09 pm >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '4100' 23/11/2022 05:29:03 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '559' 23/11/2022 05:29:03 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '559' , '10' , '210' , 'PARROCCHIA SANTA TERESA DEL BAMBINO GESU\'' , 'PICCOLO' , 'DON LUIGI' , 'VIA TAVERNA DELLE ROSE' , '' , '84091' , 'BATTIPAGLIA' , '' , '' , '' , '' , '91001560654' , NOW() , NOW() ) 23/11/2022 05:29:03 pm >> UPDATE ps_customer SET email = 'parrocchia.steresa@tin.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '559' 23/11/2022 05:29:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '120' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-22') 23/11/2022 05:29:51 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' , '120' , '2022-11-22' , '' , '559' , '0' , '98016373' , 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '136.00' , '136.00' , NOW() , NOW() ) 23/11/2022 05:29:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '8711' 23/11/2022 05:29:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '8711' 23/11/2022 05:29:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8711' , '17' , 'LA FEDE NELLO ZAINETTO' , '32' , '-32' , '4' , '5.00' , '5' , '0' , '15' , '136.00' ) 23/11/2022 06:05:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3134' AND id_document != '68022' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-21') 23/11/2022 06:05:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3134', document_date = '2022-10-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '197.00', price_tax_excluded = '181.34', date_upd = NOW() WHERE id_document = '68022' 23/11/2022 06:05: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 = '68022' 23/11/2022 06:05:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '68022' 23/11/2022 06:05: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 ( '68022' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '42.00' ) 23/11/2022 06:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 23/11/2022 06:05:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 23/11/2022 06:05: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 ( '68022' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '15' , '-15' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '52.50' ) 23/11/2022 06:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/11/2022 06:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68022' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.9000' , '3.75' , '4' , '0' , '7.80' ) 23/11/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 23/11/2022 06:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68022' , '20033' , 'CAMMINO DEL DESIDERIO - G. PICCOLO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 23/11/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20033' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20033' , '' , '1' ) 23/11/2022 06:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68022' , '19520' , 'GRAMMATICA DI MARIA - N.M. BORGO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 23/11/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19520' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19520' , '' , '1' ) 23/11/2022 06:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68022' , '20017' , 'CHI DORME NON PIGLIA CRISTO - M. POZZA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 23/11/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20017' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20017' , '' , '1' ) 23/11/2022 06:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68022' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 23/11/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 23/11/2022 06:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68022' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 23/11/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 23/11/2022 06:05:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68022' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '' , '4.50' ) 23/11/2022 06:05:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '' 23/11/2022 06:05:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '' , '1' ) 23/11/2022 06:05: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 ( '68022' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 23/11/2022 06:05:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '' 23/11/2022 06:05:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '' , '1' ) 23/11/2022 06:09:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3576' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 06:09:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3576' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.90' , '13.90' , NOW() , NOW() ) 23/11/2022 06:09:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74828' 23/11/2022 06:09:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '74828' 23/11/2022 06:09: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 ( '74828' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 23/11/2022 06:09:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8702' AND id_supplier = '' 23/11/2022 06:09:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8702' , '' , '1' ) 23/11/2022 06:09: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 ( '74828' , '14639' , 'CALENDARIO DAVVENTO POSTER' , '1' , '-1' , '4' , '0.60' , '0.6' , '0' , '0' , '0.60' ) 23/11/2022 06:09:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14639' AND id_supplier = '' 23/11/2022 06:09:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14639' , '' , '1' ) 23/11/2022 06:10:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3577' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 06:10:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3577' , '2022-11-23' , '' , '' , '' , '' , 'L. GO G. LUCIANI, 1 84125 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 23/11/2022 06:10: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 = '74829' 23/11/2022 06:10:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '74829' 23/11/2022 06:10: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 ( '74829' , '8439' , 'PRESEPE COMPONIBILE IN MDF CON 5 PZ - OGGETTI' , '23' , '-23' , '1' , '2.0000' , '1.6393' , '22' , '0' , '46.00' ) 23/11/2022 06:10:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8439' AND id_supplier = '' 23/11/2022 06:10:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8439' , '' , '1' ) 23/11/2022 06:10: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 ( '74829' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' , '-20' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '4.00' ) 23/11/2022 06:10:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 23/11/2022 06:10:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 23/11/2022 06:23:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3578' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 06:23:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3578' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '23.49' , NOW() , NOW() ) 23/11/2022 06:23:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74830' 23/11/2022 06:23:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '74830' 23/11/2022 06:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74830' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 23/11/2022 06:23:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 23/11/2022 06:23:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 23/11/2022 06:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74830' , '5823' , 'LIBRO DORO' , '5' , '-5' , '4' , '0.60' , '0.6' , '0' , '0' , '3.00' ) 23/11/2022 06:23:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '' 23/11/2022 06:23:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '' , '1' ) 23/11/2022 06:35:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '97/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 06:35:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '97/A' , '2022-11-23' , 'A' , '27' , '0' , '4676523' , 'P.ZZA PIRONTI 83025 PIANO DI MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.10' , '87.10' , NOW() , NOW() ) 23/11/2022 06:35:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74831' 23/11/2022 06:35:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '74831' 23/11/2022 06:35: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 ( '74831' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '28' , '-28' , '4' , '3.50' , '3.5' , '0' , '15' , '83.30' ) 23/11/2022 06:35: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 ( '74831' , '20319' , 'SAN NICOLA DA TOLENTINO - R. PICCOLOMINI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 23/11/2022 06:40:39 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/11/2022 06:40:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '134' , '1' , '' , 'nuovo-prodotto' ) 23/11/2022 06:40:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '134' , '1' , '1' , '2' , NOW() , NOW() ) 23/11/2022 06:40:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '134' , '0' , '1' , '0' , '0' ) 23/11/2022 06:41:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688894' AND id_product != '134' AND ean13 != '' 23/11/2022 06:41:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788887688894', date_upd = NOW() WHERE id_product = '134' 23/11/2022 06:41:24 pm >> UPDATE ps_product_lang SET name = 'AVE MARIA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '134' 23/11/2022 06:41:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '134' 23/11/2022 06:41:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '449', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '134' 23/11/2022 06:41:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '134' 23/11/2022 06:42:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688894' AND id_product != '134' AND ean13 != '' 23/11/2022 06:42:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788887688894', date_upd = NOW() WHERE id_product = '134' 23/11/2022 06:42:56 pm >> UPDATE ps_product_lang SET name = 'AVE MARIA SPIEGATA AI BAMBINI', description = '
Da centinaia di anni tutti i cristiani si rivolgono a Maria con questa preghiera.
Nel libretto facciamo vedere ai bambini con parole e immagini come recitarla ogni giorno e in ogni occasione in cui senti di avere bisogno di rivolgerti alla Mamma celeste.
' WHERE id_product = '134' 23/11/2022 06:42:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '134' 23/11/2022 06:42:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '449', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '134' 23/11/2022 06:42:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '134' 23/11/2022 06:42:56 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '134' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 23/11/2022 06:43:13 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '134' 23/11/2022 06:43:47 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '55' 23/11/2022 06:44:02 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '134' 23/11/2022 06:44:26 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '134' 23/11/2022 06:44:48 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/11/2022 06:44:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20460' , '1' , '' , 'nuovo-prodotto' ) 23/11/2022 06:44:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20460' , '1' , '1' , '2' , NOW() , NOW() ) 23/11/2022 06:44:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20460' , '0' , '1' , '0' , '0' ) 23/11/2022 06:45:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688894' AND id_product != '20460' AND ean13 != '' 23/11/2022 06:45:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788887688894', date_upd = NOW() WHERE id_product = '20460' 23/11/2022 06:45:28 pm >> UPDATE ps_product_lang SET name = 'AVE MARIA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '20460' 23/11/2022 06:45:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '20460' 23/11/2022 06:45:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20460' 23/11/2022 06:45:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20460' 23/11/2022 06:45:29 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20460' 23/11/2022 06:45:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20461' , '1' , '' , 'nuovo-prodotto' ) 23/11/2022 06:45:29 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20461' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20460' 23/11/2022 06:45:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20461' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20460' 23/11/2022 07:45:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3579' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 23/11/2022 07:45:09 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' , '3579' , '2022-11-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 23/11/2022 07:45: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 = '74832' 23/11/2022 07:45:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '74832' 23/11/2022 07:45: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 ( '74832' , '9552' , 'SANTA CHIARA CM 13 - 023 SCH/13E' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/11/2022 07:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9552' AND id_supplier = '' 23/11/2022 07:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9552' , '' , '1' )