27/10/2022 09:22:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '17314/00/2022' , '2022-10-24' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '510.61' , '505.20' , NOW() , NOW() ) 27/10/2022 09:22:00 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 = '69672' 27/10/2022 09:22:00 am >> DELETE FROM ps_document_detail WHERE id_document = '69672' 27/10/2022 09:22:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69672' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '150' , '150' , '4' , '5.00' , '5' , '0' , '40' , '450.0000' ) 27/10/2022 09:22:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '38' 27/10/2022 09:22:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '38' , '1' ) 27/10/2022 09:22:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69672' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '1' , '4' , '19.00' , '19' , '0' , '40' , '11.4000' ) 27/10/2022 09:22:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '38' 27/10/2022 09:22:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '38' , '1' ) 27/10/2022 09:22:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69672' , '8387' , 'PREGHIERE PER LE ANIME DEI DEFUNTI - 8147' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 27/10/2022 09:22:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '8387' AND id_supplier = '38' 27/10/2022 09:22:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8387' , '38' , '1' ) 27/10/2022 09:22:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69672' , '8333' , 'PREGHIERE A SAN GIUDA TADDEO APOSTOLO - 8159' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 27/10/2022 09:22:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '8333' AND id_supplier = '38' 27/10/2022 09:22:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8333' , '38' , '1' ) 27/10/2022 09:22:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69672' , '11880' , 'ANNO CON LA BIBBIA - 8829' , '1' , '1' , '4' , '15.00' , '15' , '0' , '40' , '9.0000' ) 27/10/2022 09:22:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '11880' AND id_supplier = '38' 27/10/2022 09:22:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11880' , '38' , '1' ) 27/10/2022 09:22:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69672' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '5' , '5' , '1' , '8.2' , '6.7213114754098' , '22' , '40' , '30.0120' ) 27/10/2022 09:22:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '38' 27/10/2022 09:22:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '38' , '1' ) 27/10/2022 09:28:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 09:28:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3210' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.50' , '85.50' , NOW() , NOW() ) 27/10/2022 09:28:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69673' 27/10/2022 09:28:50 am >> DELETE FROM ps_document_detail WHERE id_document = '69673' 27/10/2022 09:28:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69673' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '18' , '-18' , '4' , '5.00' , '5' , '0' , '5' , '85.50' ) 27/10/2022 09:28:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 09:28:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 09:31:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 09:31:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3211' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 27/10/2022 09:31: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 = '69674' 27/10/2022 09:31:54 am >> DELETE FROM ps_document_detail WHERE id_document = '69674' 27/10/2022 09:31:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69674' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '5' , '42.75' ) 27/10/2022 09:31:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 09:31:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 10:04:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 10:04:40 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' , '3212' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 27/10/2022 10:04:40 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 = '69675' 27/10/2022 10:04:40 am >> DELETE FROM ps_document_detail WHERE id_document = '69675' 27/10/2022 10:04:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69675' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/10/2022 10:04:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 27/10/2022 10:04:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 27/10/2022 10:16:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831148757' AND id_product != '20216' AND ean13 != '' 27/10/2022 10:16:59 am >> UPDATE ps_product SET id_supplier = '109', reference = '', ean13 = '9788831148757', date_upd = NOW() WHERE id_product = '20216' 27/10/2022 10:16:59 am >> UPDATE ps_product_lang SET name = 'RESPIRO DELL\'ANIMA - C. LUBIGH / F. CIARDI', description = '' WHERE id_product = '20216' 27/10/2022 10:16:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.9000' WHERE id_product = '20216' 27/10/2022 10:16:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.9000', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20216' 27/10/2022 10:16:59 am >> DELETE FROM ps_specific_price WHERE id_product = '20216' 27/10/2022 10:19:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3188' AND id_document != '68618' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 27/10/2022 10:19:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3188', document_date = '2022-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '195.50', price_tax_excluded = '160.25', date_upd = NOW() WHERE id_document = '68618' 27/10/2022 10:19: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 = '68618' 27/10/2022 10:19:58 am >> DELETE FROM ps_document_detail WHERE id_document = '68618' 27/10/2022 10:19: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 ( '68618' , '15647' , 'CLERGY CELESTE - 100% - 42 - 160/10' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 27/10/2022 10:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '15647' AND id_supplier = '' 27/10/2022 10:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15647' , '' , '1' ) 27/10/2022 10:19: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 ( '68618' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '36.50' ) 27/10/2022 10:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 27/10/2022 10:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 27/10/2022 10:19: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 ( '68618' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 27/10/2022 10:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 27/10/2022 10:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 27/10/2022 10:19: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 ( '68618' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 27/10/2022 10:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19397' AND id_supplier = '' 27/10/2022 10:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19397' , '' , '1' ) 27/10/2022 10:19: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 ( '68618' , '19800' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/10/2022 10:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19800' AND id_supplier = '' 27/10/2022 10:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19800' , '' , '1' ) 27/10/2022 10:23:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 10:23:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3213' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 27/10/2022 10:23:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69676' 27/10/2022 10:23:30 am >> DELETE FROM ps_document_detail WHERE id_document = '69676' 27/10/2022 10:23:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69676' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 27/10/2022 10:23:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '12202' AND id_supplier = '' 27/10/2022 10:23:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12202' , '' , '1' ) 27/10/2022 10:29:12 am >> SELECT document_num FROM ps_document WHERE document_num = '216' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 10:29: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 ( '21' , '216' , '2022-10-27' , '' , '3191' , '0' , '4670958' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '160.23' , '160.23' , NOW() , NOW() ) 27/10/2022 10:29: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 = '69677' 27/10/2022 10:29:12 am >> DELETE FROM ps_document_detail WHERE id_document = '69677' 27/10/2022 10:29:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69677' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 27/10/2022 10:29:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69677' , '8408' , 'PRENDETE E MANGIATE' , '18' , '-18' , '4' , '3.00' , '3' , '0' , '15' , '45.90' ) 27/10/2022 10:29:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69677' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '17' , '-17' , '4' , '3.50' , '3.5' , '0' , '15' , '50.58' ) 27/10/2022 10:30:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 10:30:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3214' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 27/10/2022 10:30:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69678' 27/10/2022 10:30:15 am >> DELETE FROM ps_document_detail WHERE id_document = '69678' 27/10/2022 10:30:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69678' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 27/10/2022 10:30:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 27/10/2022 10:30:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 27/10/2022 10:35:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 10:35: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' , '3215' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '40.17' , NOW() , NOW() ) 27/10/2022 10:35: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 = '69679' 27/10/2022 10:35:57 am >> DELETE FROM ps_document_detail WHERE id_document = '69679' 27/10/2022 10:35: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 ( '69679' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 27/10/2022 10:35:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 27/10/2022 10:35:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 27/10/2022 10:35: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 ( '69679' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 27/10/2022 10:35:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 27/10/2022 10:35:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 27/10/2022 10:35: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 ( '69679' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 27/10/2022 10:35:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/10/2022 10:35:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/10/2022 10:35: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 ( '69679' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 27/10/2022 10:35:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/10/2022 10:35:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/10/2022 10:54:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 10:54:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3216' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.33' , '3.33' , NOW() , NOW() ) 27/10/2022 10:54:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69680' 27/10/2022 10:54:33 am >> DELETE FROM ps_document_detail WHERE id_document = '69680' 27/10/2022 10:54:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69680' , '6055' , 'MADONNA DEL CARMINE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 27/10/2022 10:54:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '6055' AND id_supplier = '' 27/10/2022 10:54:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6055' , '' , '1' ) 27/10/2022 11:05:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 11:05:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3217' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 27/10/2022 11:05:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69681' 27/10/2022 11:05:01 am >> DELETE FROM ps_document_detail WHERE id_document = '69681' 27/10/2022 11:05:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69681' , '4385' , 'GESÙ BAMBINO C/CULLA CM 18' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 27/10/2022 11:05:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '4385' AND id_supplier = '' 27/10/2022 11:05:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4385' , '' , '1' ) 27/10/2022 11:31:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 11:31: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' , '3218' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 27/10/2022 11:31: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 = '69682' 27/10/2022 11:31:57 am >> DELETE FROM ps_document_detail WHERE id_document = '69682' 27/10/2022 11:31: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 ( '69682' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 27/10/2022 11:31:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 11:31:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 11:34:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 11:34:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3219' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 27/10/2022 11:34:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69683' 27/10/2022 11:34:34 am >> DELETE FROM ps_document_detail WHERE id_document = '69683' 27/10/2022 11:34:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69683' , '6008' , 'LUMINELLI AD OLIO - 1021C' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/10/2022 11:34:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '6008' AND id_supplier = '' 27/10/2022 11:34:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6008' , '' , '1' ) 27/10/2022 11:39:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 11:39:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3220' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 27/10/2022 11:39:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69684' 27/10/2022 11:39:14 am >> DELETE FROM ps_document_detail WHERE id_document = '69684' 27/10/2022 11:39:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69684' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '21' , '-21' , '4' , '5.00' , '5' , '0' , '0' , '105.00' ) 27/10/2022 11:39:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 11:39:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 11:39:31 am >> DELETE FROM ps_document WHERE id_document = '69684' 27/10/2022 11:39:31 am >> DELETE FROM ps_document_detail WHERE id_document = '69684' 27/10/2022 11:44:48 am >> DELETE FROM ps_product WHERE id_product = '19193' 27/10/2022 11:44:48 am >> DELETE FROM ps_product_shop WHERE id_product = '19193' 27/10/2022 11:44:48 am >> DELETE FROM ps_product_lang WHERE id_product = '19193' 27/10/2022 11:44:48 am >> DELETE FROM ps_stock_available WHERE id_product = '19193' 27/10/2022 11:46:39 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/10/2022 11:46:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20245' , '1' , '' , 'nuovo-prodotto' ) 27/10/2022 11:46:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20245' , '1' , '1' , '2' , NOW() , NOW() ) 27/10/2022 11:46:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20245' , '0' , '1' , '0' , '0' ) 27/10/2022 11:49:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002059' AND id_product != '20245' AND ean13 != '' 27/10/2022 11:49:17 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002059', date_upd = NOW() WHERE id_product = '20245' 27/10/2022 11:49:18 am >> UPDATE ps_product_lang SET name = 'formella crocifisso 25x30', description = '' WHERE id_product = '20245' 27/10/2022 11:49:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '48.36065573770492' WHERE id_product = '20245' 27/10/2022 11:49:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '48.36065573770492', id_tax_rules_group = '1', id_category_default = '192', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20245' 27/10/2022 11:49:18 am >> DELETE FROM ps_specific_price WHERE id_product = '20245' 27/10/2022 11:49:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002059' AND id_product != '20245' AND ean13 != '' 27/10/2022 11:49:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002059', date_upd = NOW() WHERE id_product = '20245' 27/10/2022 11:49:36 am >> UPDATE ps_product_lang SET name = 'FORMELLA CROCIFISSO 25X30', description = '' WHERE id_product = '20245' 27/10/2022 11:49:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '48.3607' WHERE id_product = '20245' 27/10/2022 11:49:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '48.3607', id_tax_rules_group = '1', id_category_default = '192', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20245' 27/10/2022 11:49:36 am >> DELETE FROM ps_specific_price WHERE id_product = '20245' 27/10/2022 11:54: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 ( '31' , '806' , '2022-10-25' , '' , '0' , '13' , '2608' , 'VIA ECCE HOMO, 15 37054 NOGARA' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '344.56' , '282.43' , NOW() , NOW() ) 27/10/2022 11:54: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 = '69685' 27/10/2022 11:54:12 am >> DELETE FROM ps_document_detail WHERE id_document = '69685' 27/10/2022 11:54: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 ( '69685' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '4' , '4' , '1' , '34' , '27.868852459016' , '22' , '5' , '157.6240' ) 27/10/2022 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '16865' AND id_supplier = '13' 27/10/2022 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16865' , '13' , '1' ) 27/10/2022 11:54: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 ( '69685' , '16863' , 'CROCIFISSO SAGOMATO 50X32 ULIVO RAME - 105062' , '1' , '1' , '1' , '69' , '56.55737704918' , '22' , '5' , '79.9710' ) 27/10/2022 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '16863' AND id_supplier = '13' 27/10/2022 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16863' , '13' , '1' ) 27/10/2022 11:54: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 ( '69685' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '3' , '3' , '1' , '25.5' , '20.901639344262' , '22' , '5' , '88.6635' ) 27/10/2022 11:54:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '20245' AND id_supplier = '13' 27/10/2022 11:54:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20245' , '13' , '1' ) 27/10/2022 11:57:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '5910/00' , '2022-10-26' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO ' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 27/10/2022 11:57: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 = '69686' 27/10/2022 11:57:49 am >> DELETE FROM ps_document_detail WHERE id_document = '69686' 27/10/2022 11:57: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 ( '69686' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '15' , '15' , '4' , '6.00' , '6' , '0' , '0' , '90.0000' ) 27/10/2022 12:00:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '69667' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 27/10/2022 12:00:54 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '215', document_date = '2022-10-26', document_letter = '', id_customer = '3951', id_supplier = '', id_address = '4676199', address1 = 'VIA FATTORI - FRAZ. CARATTANO 81010 GIOIA SANNITICA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '64.80', price_tax_excluded = '64.80', date_upd = NOW() WHERE id_document = '69667' 27/10/2022 12:00:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69667' 27/10/2022 12:00:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '69667' 27/10/2022 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '10' , '15.75' ) 27/10/2022 12:00:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 12:00:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '10' , '5.40' ) 27/10/2022 12:00:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 27/10/2022 12:00:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 27/10/2022 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '10' , '15.75' ) 27/10/2022 12:00:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 27/10/2022 12:00:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 27/10/2022 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11191' , 'VENITE CON ME 1 PARTE' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '10' , '11.25' ) 27/10/2022 12:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 27/10/2022 12:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 27/10/2022 12:00:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '10' , '11.25' ) 27/10/2022 12:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 27/10/2022 12:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 27/10/2022 12:00:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69667' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '10' , '5.40' ) 27/10/2022 12:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 27/10/2022 12:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 27/10/2022 12: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' , '2022000005911' , '2022-10-26' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '53.45' , '53.45' , NOW() , NOW() ) 27/10/2022 12: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 = '69687' 27/10/2022 12:08:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '69687' 27/10/2022 12: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 ( '69687' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 27/10/2022 12:08:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20009' AND id_supplier = '107' 27/10/2022 12:08:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20009' , '107' , '1' ) 27/10/2022 12:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69687' , '18311' , 'ANDATE E FATE IN MODO ... ANNO A - E. DELLA CORTE' , '1' , '1' , '4' , '27.00' , '27' , '0' , '35' , '17.5500' ) 27/10/2022 12:08:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18311' AND id_supplier = '107' 27/10/2022 12:08:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18311' , '107' , '1' ) 27/10/2022 12:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69687' , '19084' , 'OMELIE E PREDICAZIONE - CAVOLO/SODI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35' , '10.4000' ) 27/10/2022 12:08:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19084' AND id_supplier = '107' 27/10/2022 12:08:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19084' , '107' , '1' ) 27/10/2022 12:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69687' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 27/10/2022 12:08:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 27/10/2022 12:08:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 27/10/2022 12:11:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '87/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 12:11: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 ( '24' , '87/A' , '2022-10-27' , 'A' , '846' , '0' , '4670897' , 'VIA ROCCO COCCHIA, 12/16 84129 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '265.20' , '265.20' , NOW() , NOW() ) 27/10/2022 12:11: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 = '69688' 27/10/2022 12:11:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '69688' 27/10/2022 12:11: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 ( '69688' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '130' , '-130' , '4' , '2.40' , '2.4' , '0' , '15' , '265.20' ) 27/10/2022 12:26:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 27/10/2022 12:26:58 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2022-05-16', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'acconto € 50,00+ 40,00', 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 = '192.10', price_tax_excluded = '170.40', date_upd = NOW() WHERE id_document = '57793' 27/10/2022 12:26:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57793' 27/10/2022 12:26:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '57793' 27/10/2022 12:26:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '13' , '-13' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '24.70' ) 27/10/2022 12:26:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/10/2022 12:26:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/10/2022 12:26:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 27/10/2022 12:26:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 27/10/2022 12:26:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 27/10/2022 12:26:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/10/2022 12:26:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 27/10/2022 12:26:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 27/10/2022 12:26:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7673' , 'PARTICOLE MM38' , '19' , '-19' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '66.50' ) 27/10/2022 12:26:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 27/10/2022 12:26:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 27/10/2022 12:26:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '11384' , 'VINO BIANCO DOLCE - 102' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/10/2022 12:26:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 27/10/2022 12:26:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 27/10/2022 12:26:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/10/2022 12:26:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/10/2022 12:26:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/10/2022 03:07:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '68051' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 27/10/2022 03:07:57 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '201', document_date = '2022-10-22', document_letter = '', id_customer = '541', id_supplier = '', id_address = '4671522', address1 = 'VIA GALLIANO 84126 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '68.00', price_tax_excluded = '68.00', date_upd = NOW() WHERE id_document = '68051' 27/10/2022 03:07: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 = '68051' 27/10/2022 03:07:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '68051' 27/10/2022 03:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 27/10/2022 03:07:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/10/2022 03:07:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/10/2022 03:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 27/10/2022 03:07:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/10/2022 03:07:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/10/2022 03:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 27/10/2022 03:07:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/10/2022 03:07:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/10/2022 03:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 03:07:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 27/10/2022 03:07:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 27/10/2022 03:09:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '68051' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 27/10/2022 03:09:01 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '201', document_date = '2022-10-22', document_letter = '', id_customer = '541', id_supplier = '', id_address = '4671522', address1 = 'VIA GALLIANO 84126 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 = '68.00', price_tax_excluded = '68.00', date_upd = NOW() WHERE id_document = '68051' 27/10/2022 03:09:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68051' 27/10/2022 03:09:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '68051' 27/10/2022 03:09:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 27/10/2022 03:09:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/10/2022 03:09:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/10/2022 03:09:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 27/10/2022 03:09:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/10/2022 03:09:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/10/2022 03:09:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 27/10/2022 03:09:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/10/2022 03:09:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/10/2022 03:09:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 03:09:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 27/10/2022 03:09:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 27/10/2022 03:29:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '217' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 03:29:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '217' , '2022-10-27' , '' , '1739' , '0' , '4671006' , 'VIA PROVINCIALE, 1 00010 MONTEFLAVIO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '30.70' , '30.70' , NOW() , NOW() ) 27/10/2022 03:29:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69689' 27/10/2022 03:29:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '69689' 27/10/2022 03:29: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 ( '69689' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '10' , '-10' , '4' , '2.40' , '2.4' , '0' , '5' , '22.80' ) 27/10/2022 03:29: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 ( '69689' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 27/10/2022 03:37:04 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1739' 27/10/2022 03:37:04 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 ( '1739' , '10' , '208' , 'ISTITUTO FIGLIE DI NOSTRA SIGNORA AL MONTE CALVARIO' , 'TEODORI ' , 'DON FIORENZO' , 'VIA PROVINCIALE, 1' , '' , '00010' , 'MONTEFLAVIO' , '' , '349 2720436' , '' , '' , '' , NOW() , NOW() ) 27/10/2022 03:37:04 pm >> UPDATE ps_customer SET email = 'donteodori@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1739' 27/10/2022 03:42:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 03:42:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3220' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 27/10/2022 03:42:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69690' 27/10/2022 03:42:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '69690' 27/10/2022 03:42: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 ( '69690' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 27/10/2022 03:42:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 27/10/2022 03:42:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 27/10/2022 04:48:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3029' AND id_document != '65815' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-12') 27/10/2022 04:48:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3029', document_date = '2022-10-12', 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 = '75.00', price_tax_excluded = '75.00', date_upd = NOW() WHERE id_document = '65815' 27/10/2022 04:48:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65815' 27/10/2022 04:48:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '65815' 27/10/2022 04:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65815' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.75' , '3.75' , '0' , '0' , '3.75' ) 27/10/2022 04:48:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/10/2022 04:48:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/10/2022 04:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65815' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '5' , '71.25' ) 27/10/2022 04:48:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 04:48:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 04:48:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 04:48:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3221' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 27/10/2022 04:48:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69691' 27/10/2022 04:48:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '69691' 27/10/2022 04:48:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69691' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 27/10/2022 04:48:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 04:48:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 04:57:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '67942' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-18') 27/10/2022 04:57:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '29', document_date = '2022-10-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2633', address1 = 'VIA GALVANI, 1 60020 CAMERATA PICENA', address2 = '', note = 'RESA- NOTA CREDITO ARRIVATA N. 442 DEL 27/10/2022', 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 = '66.00', price_tax_excluded = '66.00', date_upd = NOW() WHERE id_document = '67942' 27/10/2022 04:57:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67942' 27/10/2022 04:57:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '67942' 27/10/2022 04:57: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 ( '67942' , '9690' , 'SCAPOLARE DEL CARMELO - 8339' , '1' , '-1' , '4' , '4' , '4' , '0' , '40' , '2.40' ) 27/10/2022 04:57:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9690' AND id_supplier = '' 27/10/2022 04:57:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9690' , '' , '1' ) 27/10/2022 04:57: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 ( '67942' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '40' , '2.40' ) 27/10/2022 04:57:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 27/10/2022 04:57:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 27/10/2022 04:57: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 ( '67942' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '40' , '3.00' ) 27/10/2022 04:57:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/10/2022 04:57:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/10/2022 04:57: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 ( '67942' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '40' , '9.00' ) 27/10/2022 04:57:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 27/10/2022 04:57:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 27/10/2022 04:57: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 ( '67942' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '40' , '6.00' ) 27/10/2022 04:57:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 27/10/2022 04:57:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 27/10/2022 04:57: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 ( '67942' , '19110' , 'SULLA TUA PAROLA MAR/APR 2022' , '8' , '-8' , '4' , '5.0000' , '5' , '0' , '40' , '24.00' ) 27/10/2022 04:57:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19110' AND id_supplier = '' 27/10/2022 04:57:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19110' , '' , '1' ) 27/10/2022 04:57: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 ( '67942' , '11498' , 'VIVERE LA SANTA MESSA - 8363' , '2' , '-2' , '4' , '5' , '5' , '0' , '40' , '6.00' ) 27/10/2022 04:57:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11498' AND id_supplier = '' 27/10/2022 04:57:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11498' , '' , '1' ) 27/10/2022 04:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67942' , '17706' , 'PATRIS CORDE' , '22' , '-22' , '4' , '1.0000' , '1' , '0' , '40' , '13.20' ) 27/10/2022 04:57:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17706' AND id_supplier = '' 27/10/2022 04:57:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17706' , '' , '1' ) 27/10/2022 05:22:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '218' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 05:22:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '218' , '2022-10-27' , '' , '979' , '0' , '4671729' , 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '57.80' , '57.80' , NOW() , NOW() ) 27/10/2022 05:22: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 = '69692' 27/10/2022 05:22:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '69692' 27/10/2022 05:22: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 ( '69692' , '2679' , 'CONOSCERE GESU' , '8' , '-8' , '4' , '3.50' , '3.5' , '0' , '15' , '23.80' ) 27/10/2022 05:22: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 ( '69692' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '-16' , '4' , '2.50' , '2.5' , '0' , '15' , '34.00' ) 27/10/2022 05:25:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '162' AND id_document != '65790' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-11') 27/10/2022 05:25:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '162', document_date = '2022-10-11', document_letter = '', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 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 = '101.16', price_tax_excluded = '101.16', date_upd = NOW() WHERE id_document = '65790' 27/10/2022 05:25:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65790' 27/10/2022 05:25:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '65790' 27/10/2022 05:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65790' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 27/10/2022 05:25:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 27/10/2022 05:25:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 27/10/2022 05:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65790' , '2679' , 'CONOSCERE GESU' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 27/10/2022 05:25:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 27/10/2022 05:25:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 27/10/2022 05:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65790' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '15' , '17.85' ) 27/10/2022 05:25:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/10/2022 05:25:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/10/2022 05:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65790' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 27/10/2022 05:25:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/10/2022 05:25:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/10/2022 05:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65790' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 27/10/2022 05:25:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/10/2022 05:25:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/10/2022 05:29:36 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') 27/10/2022 05:29:36 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 = '5.80', price_tax_excluded = '5.80', date_upd = NOW() WHERE id_document = '61794' 27/10/2022 05:29:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61794' 27/10/2022 05:29:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '61794' 27/10/2022 05:29:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 27/10/2022 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20036' AND id_supplier = '' 27/10/2022 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20036' , '' , '1' ) 27/10/2022 05:32:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2834' AND id_document != '61937' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-26') 27/10/2022 05:32:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2834', document_date = '2022-09-26', 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 = '101.00', price_tax_excluded = '100.69', date_upd = NOW() WHERE id_document = '61937' 27/10/2022 05:32: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 = '61937' 27/10/2022 05:32:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '61937' 27/10/2022 05:32: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 ( '61937' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 27/10/2022 05:32:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 27/10/2022 05:32:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 27/10/2022 05:32: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 ( '61937' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.52' ) 27/10/2022 05:32:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19928' AND id_supplier = '' 27/10/2022 05:32:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19928' , '' , '1' ) 27/10/2022 05:32: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 ( '61937' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.52' ) 27/10/2022 05:32:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19929' AND id_supplier = '' 27/10/2022 05:32:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19929' , '' , '1' ) 27/10/2022 05:32:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61937' , '19125' , 'LETTERE DI SAN PAOLO - B. STANDAERT' , '1' , '-1' , '4' , '29.00' , '29' , '0' , '5' , '27.55' ) 27/10/2022 05:32:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19125' AND id_supplier = '' 27/10/2022 05:32:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19125' , '' , '1' ) 27/10/2022 05:32:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61937' , '20209' , 'CHIESA CHE FAREMO - P. CURTAZ' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 27/10/2022 05:32:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20209' AND id_supplier = '' 27/10/2022 05:32:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20209' , '' , '1' ) 27/10/2022 05:32:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61937' , '19741' , 'PARLARE CON DIO - J. MARTIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 27/10/2022 05:32:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19741' AND id_supplier = '' 27/10/2022 05:32:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19741' , '' , '1' ) 27/10/2022 05:32:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61937' , '19334' , 'INSEGNACI A PREGARE - J. MARTIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 27/10/2022 05:32:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19334' AND id_supplier = '' 27/10/2022 05:32:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19334' , '' , '1' ) 27/10/2022 05:32:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61937' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.21' , '1.21' , '0' , '0' , '1.21' ) 27/10/2022 05:32:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:32:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:33:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2859' AND id_document != '62489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-28') 27/10/2022 05:33:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2859', document_date = '2022-09-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 = '80.00', price_tax_excluded = '80.00', date_upd = NOW() WHERE id_document = '62489' 27/10/2022 05:33:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '62489' 27/10/2022 05:33:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '62489' 27/10/2022 05:33:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '62489' , '5457' , 'IO SONO CON VOI 1 PARTE' , '40' , '-40' , '4' , '2' , '2' , '0' , '0' , '80.00' ) 27/10/2022 05:33:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:33:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:35:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2877' AND id_document != '63030' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-30') 27/10/2022 05:35:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2877', document_date = '2022-09-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '169.41', price_tax_excluded = '164.65', date_upd = NOW() WHERE id_document = '63030' 27/10/2022 05:35:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63030' 27/10/2022 05:35:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '63030' 27/10/2022 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 27/10/2022 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 27/10/2022 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 27/10/2022 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '16.00' ) 27/10/2022 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 27/10/2022 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 27/10/2022 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '20031' , 'AVVENTO E NATALE 2022/2023' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 27/10/2022 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20031' AND id_supplier = '' 27/10/2022 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20031' , '' , '1' ) 27/10/2022 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 27/10/2022 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18950' AND id_supplier = '' 27/10/2022 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18950' , '' , '1' ) 27/10/2022 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '20023' , 'albino luciani - malnati/roncalli' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 27/10/2022 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20023' AND id_supplier = '' 27/10/2022 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20023' , '' , '1' ) 27/10/2022 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 27/10/2022 05:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 27/10/2022 05:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 27/10/2022 05:35:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '16' , '-16' , '4' , '3.50' , '3.5' , '0' , '5' , '53.28' ) 27/10/2022 05:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/10/2022 05:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/10/2022 05:35:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63030' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '1.56' , '1.56' , '0' , '0' , '3.12' ) 27/10/2022 05:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:40:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2882' AND id_document != '63041' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-30') 27/10/2022 05:40:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2882', document_date = '2022-09-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '47.60', price_tax_excluded = '47.60', date_upd = NOW() WHERE id_document = '63041' 27/10/2022 05:40:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63041' 27/10/2022 05:40:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '63041' 27/10/2022 05:40:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63041' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '5' , '43.29' ) 27/10/2022 05:40:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/10/2022 05:40:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/10/2022 05:40:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63041' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.65' , '0.65' , '0' , '0' , '1.30' ) 27/10/2022 05:40:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 27/10/2022 05:40:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 27/10/2022 05:40:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63041' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '1.5' , '1.5' , '0' , '0' , '3.00' ) 27/10/2022 05:40:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:40:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:41:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3094' AND id_document != '67954' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-18') 27/10/2022 05:41:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3094', document_date = '2022-10-18', 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 = '170.00', price_tax_excluded = '145.12', date_upd = NOW() WHERE id_document = '67954' 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67954' 27/10/2022 05:41:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '67954' 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67954' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '5' , '17.01' ) 27/10/2022 05:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '' 27/10/2022 05:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '' , '1' ) 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67954' , '5457' , 'IO SONO CON VOI 1 PARTE' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '0' , '15.00' ) 27/10/2022 05:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67954' , '12819' , 'REGISTRO DEL CATECHISTA ' , '11' , '-11' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '11.00' ) 27/10/2022 05:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 27/10/2022 05:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67954' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 27/10/2022 05:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 27/10/2022 05:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67954' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '65.5900' , '53.762295081967' , '22' , '0' , '65.59' ) 27/10/2022 05:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18399' AND id_supplier = '' 27/10/2022 05:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18399' , '' , '1' ) 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67954' , '18782' , 'PADRE NOSTRO - POSTER' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '100' , '0.00' ) 27/10/2022 05:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18782' AND id_supplier = '' 27/10/2022 05:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18782' , '' , '1' ) 27/10/2022 05:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67954' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 27/10/2022 05:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14088' AND id_supplier = '' 27/10/2022 05:41:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14088' , '' , '1' ) 27/10/2022 05:42:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '66374' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-15') 27/10/2022 05:42:18 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '170', document_date = '2022-10-15', document_letter = '', id_customer = '1175', id_supplier = '', id_address = '4672789', address1 = 'VIA BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '140.00', date_upd = NOW() WHERE id_document = '66374' 27/10/2022 05:42: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 = '66374' 27/10/2022 05:42:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '66374' 27/10/2022 05:42: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 ( '66374' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12813' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12813' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '4' , '1.0000' , '1' , '0' , '15' , '5.10' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 27/10/2022 05:42:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '0' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.6800' , '-0.68' , '0' , '0' , '-0.68' ) 27/10/2022 05:42:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 27/10/2022 05:42:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 27/10/2022 05:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 27/10/2022 05:42:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:42:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:44:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '66374' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-15') 27/10/2022 05:44:56 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '170', document_date = '2022-10-15', document_letter = '', id_customer = '1175', id_supplier = '', id_address = '4672789', address1 = 'VIA BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.17', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '140.00', date_upd = NOW() WHERE id_document = '66374' 27/10/2022 05:44: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 = '66374' 27/10/2022 05:44:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '66374' 27/10/2022 05:44: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 ( '66374' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 27/10/2022 05:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/10/2022 05:44:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 05:44:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 27/10/2022 05:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 05:44:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 27/10/2022 05:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 27/10/2022 05:44:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/10/2022 05:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 27/10/2022 05:44:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/10/2022 05:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 05:44:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 27/10/2022 05:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 27/10/2022 05:44:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12813' AND id_supplier = '' 27/10/2022 05:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12813' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 27/10/2022 05:44:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 27/10/2022 05:44:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 27/10/2022 05:44: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 ( '66374' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 27/10/2022 05:44:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:44:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:46:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '163' AND id_document != '65796' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-12') 27/10/2022 05:46:06 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '163', document_date = '2022-10-12', document_letter = '', id_customer = '2885', id_supplier = '', id_address = '4675594', address1 = 'VIA COLLE, 1 62026 SAN GINESIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '251.60', price_tax_excluded = '251.60', date_upd = NOW() WHERE id_document = '65796' 27/10/2022 05:46: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 = '65796' 27/10/2022 05:46:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '65796' 27/10/2022 05:46: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 ( '65796' , '15020' , 'PREGARE OGNI GIORNO' , '40' , '-40' , '4' , '1.0000' , '1' , '0' , '15' , '34.00' ) 27/10/2022 05:46:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 27/10/2022 05:46:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 27/10/2022 05:46: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 ( '65796' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '40' , '-40' , '4' , '1.9000' , '1.9' , '0' , '15' , '64.60' ) 27/10/2022 05:46:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 27/10/2022 05:46:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 27/10/2022 05:46: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 ( '65796' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 27/10/2022 05:46:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16050' AND id_supplier = '' 27/10/2022 05:46:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16050' , '' , '1' ) 27/10/2022 05:46: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 ( '65796' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 27/10/2022 05:46:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 27/10/2022 05:46:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 27/10/2022 05:46: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 ( '65796' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 27/10/2022 05:46:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19977' AND id_supplier = '' 27/10/2022 05:46:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19977' , '' , '1' ) 27/10/2022 05:46: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 ( '65796' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '15' , '8.50' ) 27/10/2022 05:46:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:46:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:47:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '55' AND id_document != '53954' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-03-29') 27/10/2022 05:47:44 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '55', document_date = '2022-03-29', document_letter = '', id_customer = '3871', id_supplier = '', id_address = '4673826', address1 = 'via XVI Marzo 20 , 20 88045 Gimigliano', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '38.68', price_tax_excluded = '38.68', date_upd = NOW() WHERE id_document = '53954' 27/10/2022 05:47: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 = '53954' 27/10/2022 05:47:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '53954' 27/10/2022 05:47: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 ( '53954' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '8' , '-8' , '4' , '0.8100' , '0.81' , '0' , '0' , '6.48' ) 27/10/2022 05:47:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '523' AND id_supplier = '' 27/10/2022 05:47:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '523' , '' , '1' ) 27/10/2022 05:47: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 ( '53954' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/10/2022 05:47:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 27/10/2022 05:47:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 27/10/2022 05:47: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 ( '53954' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.43' , '2.43' , '0' , '0' , '24.30' ) 27/10/2022 05:47:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:47:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:52:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3164' AND id_document != '68071' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-24') 27/10/2022 05:52:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3164', document_date = '2022-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '25.40', price_tax_excluded = '23.60', date_upd = NOW() WHERE id_document = '68071' 27/10/2022 05:52:20 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 = '68071' 27/10/2022 05:52:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '68071' 27/10/2022 05:52:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68071' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 27/10/2022 05:52:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 27/10/2022 05:52:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 27/10/2022 05:52:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68071' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '5' , '-5' , '4' , '0.5000' , '0.5' , '0' , '0' , '2.50' ) 27/10/2022 05:52:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 27/10/2022 05:52:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 27/10/2022 05:52:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68071' , '20055' , 'NON TEMERE - AVVENTO 2022' , '1' , '-1' , '4' , '3.38' , '3.38' , '0' , '0' , '3.38' ) 27/10/2022 05:52:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20055' AND id_supplier = '' 27/10/2022 05:52:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20055' , '' , '1' ) 27/10/2022 05:52:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68071' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '5' , '9.52' ) 27/10/2022 05:52:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:52:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:55:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '65' AND id_document != '28848' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2021-05-24') 27/10/2022 05:55:35 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '65', document_date = '2021-05-24', document_letter = '', id_customer = '2021', id_supplier = '', id_address = '4670987', address1 = 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO', address2 = '', note = '', price_shipping = '0.31', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '55.25', price_tax_excluded = '55.25', date_upd = NOW() WHERE id_document = '28848' 27/10/2022 05:55:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '28848' 27/10/2022 05:55:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '28848' 27/10/2022 05:55:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28848' , '8254' , 'PREGHIAMO CON MARIA' , '8' , '-8' , '4' , '0.6500' , '0.65' , '0' , '15' , '4.42' ) 27/10/2022 05:55:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 27/10/2022 05:55:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 27/10/2022 05:55:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28848' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '20' , '20.00' ) 27/10/2022 05:55:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 27/10/2022 05:55:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 27/10/2022 05:55:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28848' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '11' , '-11' , '4' , '1.9000' , '1.9' , '0' , '15' , '17.77' ) 27/10/2022 05:55:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 27/10/2022 05:55:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 27/10/2022 05:55:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28848' , '5457' , 'IO SONO CON VOI 1 PARTE' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '15' , '12.75' ) 27/10/2022 05:55:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:55:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:56:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '211' AND id_document != '68628' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-26') 27/10/2022 05:56:38 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '211', document_date = '2022-10-26', document_letter = '', id_customer = '344', id_supplier = '', id_address = '4676196', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', address2 = '', note = 'ACCONTO € 150,00', 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 = '345.11', price_tax_excluded = '345.11', date_upd = NOW() WHERE id_document = '68628' 27/10/2022 05:56:38 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 = '68628' 27/10/2022 05:56:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '68628' 27/10/2022 05:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 27/10/2022 05:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 27/10/2022 05:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 27/10/2022 05:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 27/10/2022 05:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 27/10/2022 05:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 27/10/2022 05:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 27/10/2022 05:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 27/10/2022 05:56:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 27/10/2022 05:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '45' , '-45' , '4' , '2.4000' , '2.4' , '0' , '15' , '91.80' ) 27/10/2022 05:56:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 27/10/2022 05:56:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 27/10/2022 05:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '4120' , 'FEDE NELLO ZAINETTO' , '30' , '-30' , '4' , '5.0000' , '5' , '0' , '15' , '127.50' ) 27/10/2022 05:56:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 27/10/2022 05:56:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 27/10/2022 05:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 27/10/2022 05:56:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 27/10/2022 05:56:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 27/10/2022 05:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 27/10/2022 05:56:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:56:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68628' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 27/10/2022 05:56:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 27/10/2022 05:56:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 27/10/2022 05:58:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '188' AND id_document != '67970' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-19') 27/10/2022 05:58:01 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '188', document_date = '2022-10-19', document_letter = '', id_customer = '3942', id_supplier = '', id_address = '4676031', address1 = 'PIAZZA SAN GIULIANO 108 83029 SOLOFRA', address2 = '', note = '', price_shipping = '1.27', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '40.80', price_tax_excluded = '40.80', date_upd = NOW() WHERE id_document = '67970' 27/10/2022 05:58:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67970' 27/10/2022 05:58:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '67970' 27/10/2022 05:58: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 ( '67970' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '10' , '-10' , '4' , '2.4000' , '2.4' , '0' , '15' , '20.40' ) 27/10/2022 05:58:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 27/10/2022 05:58:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 27/10/2022 05:58: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 ( '67970' , '5457' , 'IO SONO CON VOI 1 PARTE' , '9' , '-9' , '4' , '2.50' , '2.5' , '0' , '15' , '19.13' ) 27/10/2022 05:58:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:58:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 05:59:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '167' AND id_document != '66332' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-13') 27/10/2022 05:59:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '167', document_date = '2022-10-13', document_letter = '', id_customer = '2787', id_supplier = '', id_address = '4670997', address1 = 'VIALE KENNEDY, 19 71013 S. GIOVANNI ROTONDO', address2 = '', note = '', price_shipping = '0.42', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '180.21', price_tax_excluded = '180.21', date_upd = NOW() WHERE id_document = '66332' 27/10/2022 05:59:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66332' 27/10/2022 05:59:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '66332' 27/10/2022 05:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66332' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '80' , '-80' , '4' , '2.4000' , '2.4' , '0' , '15' , '163.20' ) 27/10/2022 05:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 27/10/2022 05:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 27/10/2022 05:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66332' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 27/10/2022 05:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 27/10/2022 05:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 27/10/2022 05:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66332' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.50' , '2.5' , '0' , '15' , '14.88' ) 27/10/2022 05:59:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 05:59:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 06:00:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '180' AND id_document != '67936' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-17') 27/10/2022 06:00:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '180', document_date = '2022-10-17', document_letter = '', id_customer = '3931', id_supplier = '', id_address = '4675592', address1 = 'VIALE DELLA LIBERA 11 80079 PROCIDA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '482.21', price_tax_excluded = '482.21', date_upd = NOW() WHERE id_document = '67936' 27/10/2022 06:00:42 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 = '67936' 27/10/2022 06:00:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '67936' 27/10/2022 06:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67936' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '15' , '17.00' ) 27/10/2022 06:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4479' AND id_supplier = '' 27/10/2022 06:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4479' , '' , '1' ) 27/10/2022 06:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67936' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '15' , '17.00' ) 27/10/2022 06:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4480' AND id_supplier = '' 27/10/2022 06:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4480' , '' , '1' ) 27/10/2022 06:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67936' , '9815' , 'SEGNO DELLA CROCE' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 27/10/2022 06:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9815' AND id_supplier = '' 27/10/2022 06:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9815' , '' , '1' ) 27/10/2022 06:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67936' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 27/10/2022 06:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 27/10/2022 06:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 27/10/2022 06:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 27/10/2022 06:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '7543' , 'PARABOLE DI GESÙ' , '13' , '-13' , '4' , '3.0000' , '3' , '0' , '15' , '33.15' ) 27/10/2022 06:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 27/10/2022 06:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '15739' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '26' , '-26' , '4' , '2.5000' , '2.5' , '0' , '15' , '55.25' ) 27/10/2022 06:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15739' AND id_supplier = '' 27/10/2022 06:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15739' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 27/10/2022 06:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 27/10/2022 06:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 27/10/2022 06:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 27/10/2022 06:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '18357' , 'MIE PREGHIERINE N.E.' , '13' , '-13' , '4' , '1.5000' , '1.5' , '0' , '15' , '16.57' ) 27/10/2022 06:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 27/10/2022 06:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 27/10/2022 06:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 27/10/2022 06:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 27/10/2022 06:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 27/10/2022 06:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '32' , '-32' , '4' , '2.4000' , '2.4' , '0' , '15' , '65.28' ) 27/10/2022 06:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 27/10/2022 06:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '5457' , 'IO SONO CON VOI 1 PARTE' , '12' , '-12' , '4' , '2.50' , '2.5' , '0' , '15' , '25.50' ) 27/10/2022 06:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 06:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '8408' , 'PRENDETE E MANGIATE' , '14' , '-14' , '4' , '3.0000' , '3' , '0' , '15' , '35.70' ) 27/10/2022 06:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 27/10/2022 06:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 27/10/2022 06:00:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 27/10/2022 06:00:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '17034' , 'SACRAMENTO DEL PERDONO' , '14' , '-14' , '4' , '2.0000' , '2' , '0' , '15' , '23.80' ) 27/10/2022 06:00:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '' 27/10/2022 06:00:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/10/2022 06:00:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 27/10/2022 06:00:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '4120' , 'FEDE NELLO ZAINETTO' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 27/10/2022 06:00:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 27/10/2022 06:00:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 27/10/2022 06:00: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 ( '67936' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '10' , '-10' , '4' , '1.0000' , '1' , '0' , '15' , '8.50' ) 27/10/2022 06:00:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15030' AND id_supplier = '' 27/10/2022 06:00:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15030' , '' , '1' ) 27/10/2022 06:02:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 06:02: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' , '3222' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/10/2022 06:02: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 = '69693' 27/10/2022 06:02:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '69693' 27/10/2022 06:02: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 ( '69693' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/10/2022 06:02:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 27/10/2022 06:02:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 27/10/2022 06:03:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 06:03:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3223' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 27/10/2022 06:03: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 = '69694' 27/10/2022 06:03:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '69694' 27/10/2022 06:03: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 ( '69694' , '19542' , 'LETTERA AGLI SPOSI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 27/10/2022 06:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19542' AND id_supplier = '' 27/10/2022 06:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19542' , '' , '1' ) 27/10/2022 06:06:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '50037' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-01-08') 27/10/2022 06:06:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '99', document_date = '2022-01-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '50037' 27/10/2022 06:06:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '50037' 27/10/2022 06:06:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '50037' 27/10/2022 06:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50037' , '980' , 'BEATI CONIUGI LUIGI MARTIN E ZELIA GUÉRIN - G PESENTI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 27/10/2022 06:06:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '980' AND id_supplier = '' 27/10/2022 06:06:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '980' , '' , '1' ) 27/10/2022 06:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50037' , '11308' , 'VIA CRUCIS ' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 27/10/2022 06:06:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11308' AND id_supplier = '' 27/10/2022 06:06:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11308' , '' , '1' ) 27/10/2022 06:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50037' , '5457' , 'IO SONO CON VOI 1 PARTE' , '16' , '-16' , '4' , '2.50' , '2.5' , '0' , '0' , '40.00' ) 27/10/2022 06:06:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/10/2022 06:06:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/10/2022 06:26:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 06:26:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3224' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.67' , '40.67' , NOW() , NOW() ) 27/10/2022 06: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 = '69695' 27/10/2022 06:26:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '69695' 27/10/2022 06: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 ( '69695' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '5' , '33.25' ) 27/10/2022 06:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 06:26:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 06: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 ( '69695' , '19925' , 'AMEN - NOV. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/10/2022 06:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 27/10/2022 06:26:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 27/10/2022 06: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 ( '69695' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/10/2022 06:26:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 27/10/2022 06:26:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 27/10/2022 06:27:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 06:27:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3225' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.80' , '156.80' , NOW() , NOW() ) 27/10/2022 06:27:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69696' 27/10/2022 06:27:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '69696' 27/10/2022 06:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69696' , '19963' , 'MESSA MEDITAZIONE - DIC 2022' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '5' , '7.60' ) 27/10/2022 06:27:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19963' AND id_supplier = '' 27/10/2022 06:27:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19963' , '' , '1' ) 27/10/2022 06:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69696' , '19962' , 'MESSA MEDITAZIONE - NOV 2022' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '5' , '7.60' ) 27/10/2022 06:27:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19962' AND id_supplier = '' 27/10/2022 06:27:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19962' , '' , '1' ) 27/10/2022 06:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69696' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 27/10/2022 06:27:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 27/10/2022 06:27:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 27/10/2022 06:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69696' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 27/10/2022 06:27:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 27/10/2022 06:27:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 27/10/2022 06:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69696' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '22' , '-22' , '4' , '5.00' , '5' , '0' , '5' , '104.50' ) 27/10/2022 06:27:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 06:27:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 06:27:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69696' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 27/10/2022 06:27:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/10/2022 06:27:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/10/2022 07:26:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 07:26:06 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' , '3226' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 27/10/2022 07: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 = '69697' 27/10/2022 07:26:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '69697' 27/10/2022 07: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 ( '69697' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 27/10/2022 07:26:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20122' AND id_supplier = '' 27/10/2022 07:26:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20122' , '' , '1' ) 27/10/2022 07:48:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-27') 27/10/2022 07:48:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3227' , '2022-10-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '16.50' , NOW() , NOW() ) 27/10/2022 07:48:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69698' 27/10/2022 07:48:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '69698' 27/10/2022 07:48:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69698' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '' , '16.50' ) 27/10/2022 07:48:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '' 27/10/2022 07:48:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '' , '1' )