09/01/2023 08:40:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048080' AND id_product != '20592' AND ean13 != '' 09/01/2023 08:40:06 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884048080', date_upd = NOW() WHERE id_product = '20592' 09/01/2023 08:40:06 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA MAR/APR 2023', description = '' WHERE id_product = '20592' 09/01/2023 08:40:06 am >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '20592' 09/01/2023 08:40:06 am >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20592' 09/01/2023 08:40:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20592' 09/01/2023 08:40:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048080' AND id_product != '20592' AND ean13 != '' 09/01/2023 08:40:23 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884048080', date_upd = NOW() WHERE id_product = '20592' 09/01/2023 08:40:23 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA MAR/APR 2023 -515', description = '' WHERE id_product = '20592' 09/01/2023 08:40:23 am >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '20592' 09/01/2023 08:40:23 am >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20592' 09/01/2023 08:40:23 am >> DELETE FROM ps_specific_price WHERE id_product = '20592' 09/01/2023 08:41:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/01/2023 08:41:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20608' , '1' , '' , 'nuovo-prodotto' ) 09/01/2023 08:41:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20608' , '1' , '1' , '2' , NOW() , NOW() ) 09/01/2023 08:41:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20608' , '0' , '1' , '0' , '0' ) 09/01/2023 08:41:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048110' AND id_product != '20608' AND ean13 != '' 09/01/2023 08:41:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884048110', date_upd = NOW() WHERE id_product = '20608' 09/01/2023 08:41:50 am >> UPDATE ps_product_lang SET name = 'ROSARI CON L\'ANGELO CUSTODE - 8116', description = '' WHERE id_product = '20608' 09/01/2023 08:41:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '20608' 09/01/2023 08:41:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20608' 09/01/2023 08:41:50 am >> DELETE FROM ps_specific_price WHERE id_product = '20608' 09/01/2023 08:41:51 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20608' 09/01/2023 08:41:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20609' , '1' , '' , 'nuovo-prodotto' ) 09/01/2023 08:41:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20609' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20608' 09/01/2023 08:41:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20609' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20608' 09/01/2023 08:43: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 ( '31' , '290/00/2023' , '2023-01-04' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '125.70' , '125.70' , NOW() , NOW() ) 09/01/2023 08:43: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 = '78204' 09/01/2023 08:43:40 am >> DELETE FROM ps_document_detail WHERE id_document = '78204' 09/01/2023 08:43: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 ( '78204' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '5' , '5' , '4' , '5.00' , '5' , '0' , '40' , '15.0000' ) 09/01/2023 08:43:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '38' 09/01/2023 08:43:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '38' , '1' ) 09/01/2023 08:43: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 ( '78204' , '20592' , 'SULLA TUA PAROLA MAR/APR 2023 -515' , '14' , '14' , '4' , '5.00' , '5' , '0' , '40' , '42.0000' ) 09/01/2023 08:43:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20592' AND id_supplier = '38' 09/01/2023 08:43:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20592' , '38' , '1' ) 09/01/2023 08:43: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 ( '78204' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '1' , '4' , '19.00' , '19' , '0' , '40' , '11.4000' ) 09/01/2023 08:43:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '38' 09/01/2023 08:43:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '38' , '1' ) 09/01/2023 08:43: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 ( '78204' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '5' , '5' , '4' , '0.50' , '0.5' , '0' , '40' , '1.5000' ) 09/01/2023 08:43:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '38' 09/01/2023 08:43:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '38' , '1' ) 09/01/2023 08:43: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 ( '78204' , '20608' , 'ROSARI CON LANGELO CUSTODE - 8116' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 09/01/2023 08:43:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20608' AND id_supplier = '38' 09/01/2023 08:43:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20608' , '38' , '1' ) 09/01/2023 08:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78204' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '2' , '2' , '4' , '12.00' , '12' , '0' , '40' , '14.4000' ) 09/01/2023 08:43:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 09/01/2023 08:43:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 09/01/2023 08:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78204' , '9105' , 'ROSARIO EUCARISTICO - 8183' , '2' , '2' , '4' , '4.00' , '4' , '0' , '40' , '4.8000' ) 09/01/2023 08:43:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '9105' AND id_supplier = '38' 09/01/2023 08:43:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9105' , '38' , '1' ) 09/01/2023 08:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78204' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 09/01/2023 08:43:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '10870' AND id_supplier = '38' 09/01/2023 08:43:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10870' , '38' , '1' ) 09/01/2023 08:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78204' , '4948' , 'IMITAZIONE DI CRISTO - TASC - 8818' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 09/01/2023 08:43:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '4948' AND id_supplier = '38' 09/01/2023 08:43:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4948' , '38' , '1' ) 09/01/2023 08:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78204' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '1' , '4' , '20.00' , '20' , '0' , '40' , '12.0000' ) 09/01/2023 08:43:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '11882' AND id_supplier = '38' 09/01/2023 08:43:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11882' , '38' , '1' ) 09/01/2023 08:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78204' , '13947' , 'NELLA MIA LOTTA, SIGNORE, SII TU A LOTTARE' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 09/01/2023 08:43:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '13947' AND id_supplier = '38' 09/01/2023 08:43:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13947' , '38' , '1' ) 09/01/2023 08:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78204' , '8387' , 'PREGHIERE PER LE ANIME DEI DEFUNTI - 8147' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 09/01/2023 08:43:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '8387' AND id_supplier = '38' 09/01/2023 08:43:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8387' , '38' , '1' ) 09/01/2023 10:34:10 am >> SELECT document_num FROM ps_document WHERE document_num = '68' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 10:34:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '68' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.96' , '78.96' , NOW() , NOW() ) 09/01/2023 10:34:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78205' 09/01/2023 10:34:10 am >> DELETE FROM ps_document_detail WHERE id_document = '78205' 09/01/2023 10:34:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78205' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.56' , '0.56' , '0' , '0' , '19.60' ) 09/01/2023 10:34:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78205' , '20528' , 'AMEN - MAR 2023' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.84' ) 09/01/2023 10:34:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78205' , '20527' , 'AMEN - APR 2023' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.84' ) 09/01/2023 10:34:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78205' , '20441' , 'AMEN - GEN. 23' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.84' ) 09/01/2023 10:34:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78205' , '20440' , 'AMEN - FEB. 23' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.84' ) 09/01/2023 10:43:58 am >> SELECT document_num FROM ps_document WHERE document_num = '69' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 10:43:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '69' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.94' , '16.81' , NOW() , NOW() ) 09/01/2023 10:43: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 = '78206' 09/01/2023 10:43:58 am >> DELETE FROM ps_document_detail WHERE id_document = '78206' 09/01/2023 10:43: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 ( '78206' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '24' , '-24' , '4' , '0.56' , '0.56' , '0' , '0' , '13.44' ) 09/01/2023 10:43: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 ( '78206' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/01/2023 10:46:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2911' AND id_document != '63592' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 09/01/2023 10:46:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2911', document_date = '2022-10-04', 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 = '145.81', price_tax_excluded = '128.09', date_upd = NOW() WHERE id_document = '63592' 09/01/2023 10:46: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 = '63592' 09/01/2023 10:46:57 am >> DELETE FROM ps_document_detail WHERE id_document = '63592' 09/01/2023 10:46: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 ( '63592' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '9.9' , '9.9' , '0' , '0' , '9.90' ) 09/01/2023 10:46: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 ( '63592' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '19.00' ) 09/01/2023 10:46: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 ( '63592' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '1' , '1.0000' , '0.81967213114754' , '22' , '5' , '3.80' ) 09/01/2023 10:46: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 ( '63592' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '1.9' , '1.9' , '0' , '0' , '3.80' ) 09/01/2023 10:46: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 ( '63592' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 09/01/2023 10:46: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 ( '63592' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 09/01/2023 10:46: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 ( '63592' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '45.2000' , '37.049180327869' , '22' , '0' , '45.20' ) 09/01/2023 10:46: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 ( '63592' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 09/01/2023 10:46: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 ( '63592' , '16970' , 'PELLEGRINI DI MARIA - GIOCO' , '1' , '-1' , '4' , '19.9000' , '19.9' , '0' , '5' , '18.91' ) 09/01/2023 11:17:56 am >> SELECT document_num FROM ps_document WHERE document_num = '70' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 11:17:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '70' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 09/01/2023 11:17:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78207' 09/01/2023 11:17:56 am >> DELETE FROM ps_document_detail WHERE id_document = '78207' 09/01/2023 11:17:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78207' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 09/01/2023 11:17:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78207' , '2168' , 'CLERGY BASIC - ML - B&P' , '3' , '-3' , '1' , '32' , '26.229508196721' , '22' , '0' , '96.00' ) 09/01/2023 11:20:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 11:20:39 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' , '2' , '2023-01-09' , '' , '559' , '0' , '4677368' , 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '192.00' , '192.00' , NOW() , NOW() ) 09/01/2023 11:20:39 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 = '78208' 09/01/2023 11:20:39 am >> DELETE FROM ps_document_detail WHERE id_document = '78208' 09/01/2023 11:20:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78208' , '3511' , 'DIO PARLA ALL\'UOMO' , '20' , '-20' , '4' , '12.00' , '12' , '0' , '20' , '192.00' ) 09/01/2023 11:22:04 am >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 11:22:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '71' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '41.80' , NOW() , NOW() ) 09/01/2023 11:22:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78209' 09/01/2023 11:22:05 am >> DELETE FROM ps_document_detail WHERE id_document = '78209' 09/01/2023 11:22:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78209' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '1' , '-1' , '4' , '44.00' , '44' , '0' , '5' , '41.80' ) 09/01/2023 11:22:24 am >> SELECT document_num FROM ps_document WHERE document_num = '72' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 11:22:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '72' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 09/01/2023 11:22:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78210' 09/01/2023 11:22:24 am >> DELETE FROM ps_document_detail WHERE id_document = '78210' 09/01/2023 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78210' , '14499' , 'COMUNIONE AI MALATI' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 09/01/2023 11:28:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '78208' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 11:28:09 am >> UPDATE ps_document SET id_document_type = '21', document_num = '2', document_date = '2023-01-09', document_letter = '', id_customer = '559', id_supplier = '', id_address = '4677368', address1 = 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '192.00', price_tax_excluded = '192.00', date_upd = NOW() WHERE id_document = '78208' 09/01/2023 11:28:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78208' 09/01/2023 11:28:09 am >> DELETE FROM ps_document_detail WHERE id_document = '78208' 09/01/2023 11:28:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78208' , '3511' , 'DIO PARLA ALL\'UOMO' , '20' , '-20' , '4' , '12.0000' , '12' , '0' , '20' , '192.00' ) 09/01/2023 11:31:28 am >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 11:31:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '73' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.70' , '16.97' , NOW() , NOW() ) 09/01/2023 11:31:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78211' 09/01/2023 11:31:28 am >> DELETE FROM ps_document_detail WHERE id_document = '78211' 09/01/2023 11:31:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78211' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 09/01/2023 11:31:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78211' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 09/01/2023 11:43:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2944' AND id_document != '65180' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-06') 09/01/2023 11:43:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2944', document_date = '2022-10-06', 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 = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '65180' 09/01/2023 11:43:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65180' 09/01/2023 11:43:32 am >> DELETE FROM ps_document_detail WHERE id_document = '65180' 09/01/2023 11:43:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65180' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '2' , '2' , '0' , '0' , '40.00' ) 09/01/2023 11:43:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3087' AND id_document != '67946' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-18') 09/01/2023 11:43:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3087', 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 = '60.00', price_tax_excluded = '54.82', date_upd = NOW() WHERE id_document = '67946' 09/01/2023 11:43: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 = '67946' 09/01/2023 11:43:55 am >> DELETE FROM ps_document_detail WHERE id_document = '67946' 09/01/2023 11:43:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67946' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 09/01/2023 11:43:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67946' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 09/01/2023 11:43:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67946' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '18.00' ) 09/01/2023 11:43:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67946' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '10' , '-10' , '4' , '2.3' , '2.3' , '0' , '0' , '23.00' ) 09/01/2023 11:45:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3145' AND id_document != '68043' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-21') 09/01/2023 11:45:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3145', document_date = '2022-10-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.35', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '300.00', price_tax_excluded = '300.00', date_upd = NOW() WHERE id_document = '68043' 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68043' 09/01/2023 11:45:03 am >> DELETE FROM ps_document_detail WHERE id_document = '68043' 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '5444' , 'IO SONO CON VOI - CAT.' , '25' , '-25' , '4' , '4.9500' , '4.95' , '0' , '0' , '123.75' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '13879' , 'FORTISSIMI GIOVANI - P. PELLEGRINO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '20137' , 'FOLLOWERS 2.0 - QUADERNO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '9008' , 'RITO DEL BATTESIMO - GUIDA PER GENITORI, PADRINI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '15817' , 'RINATI DALLACQUA E DALLO SPIRITO ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '18712' , 'NELLA FEDE IO VIVRO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 09/01/2023 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '2' , '-2' , '4' , '10.8000' , '10.8' , '0' , '0' , '21.60' ) 09/01/2023 11:45:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '10.8000' , '10.8' , '0' , '0' , '10.80' ) 09/01/2023 11:45:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '28' , '-28' , '4' , '2.5' , '2.5' , '0' , '0' , '70.00' ) 09/01/2023 11:45:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68043' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 09/01/2023 11:46:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3238' AND id_document != '69716' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-28') 09/01/2023 11:46:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3238', document_date = '2022-10-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '149.78', date_upd = NOW() WHERE id_document = '69716' 09/01/2023 11:46:44 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 = '69716' 09/01/2023 11:46:44 am >> DELETE FROM ps_document_detail WHERE id_document = '69716' 09/01/2023 11:46:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69716' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '7' , '-7' , '4' , '5.5000' , '5.5' , '0' , '5' , '36.61' ) 09/01/2023 11:46:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69716' , '5444' , 'IO SONO CON VOI - CAT.' , '7' , '-7' , '4' , '5.5000' , '5.5' , '0' , '15' , '32.76' ) 09/01/2023 11:46:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69716' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.93' , '0.93' , '0' , '0' , '0.93' ) 09/01/2023 11:46:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69716' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 09/01/2023 11:46:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69716' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '2.96' , '2.96' , '0' , '0' , '74.00' ) 09/01/2023 11:47:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3871' AND id_document != '77276' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-14') 09/01/2023 11:47:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3871', document_date = '2022-12-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '47.50', price_tax_excluded = '47.50', date_upd = NOW() WHERE id_document = '77276' 09/01/2023 11:47:13 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 = '77276' 09/01/2023 11:47:13 am >> DELETE FROM ps_document_detail WHERE id_document = '77276' 09/01/2023 11:47:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77276' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 09/01/2023 11:47:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77276' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.23' , '3.23' , '0' , '0' , '32.30' ) 09/01/2023 11:48:27 am >> SELECT document_num FROM ps_document WHERE document_num = '4031' AND id_document != '77470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-22') 09/01/2023 11:48:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4031', document_date = '2022-12-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '58.00', price_tax_excluded = '53.85', date_upd = NOW() WHERE id_document = '77470' 09/01/2023 11:48:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77470' 09/01/2023 11:48:27 am >> DELETE FROM ps_document_detail WHERE id_document = '77470' 09/01/2023 11:48:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77470' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 09/01/2023 11:48:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77470' , '20588' , 'FELICITA DEL CUORE - F. SHEEN' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 09/01/2023 11:48:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77470' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '1.41' , '1.41' , '0' , '0' , '14.10' ) 09/01/2023 11:49:28 am >> SELECT document_num FROM ps_document WHERE document_num = '4063' AND id_document != '77508' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 09/01/2023 11:49:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4063', document_date = '2022-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '44.40', price_tax_excluded = '44.40', date_upd = NOW() WHERE id_document = '77508' 09/01/2023 11:49:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77508' 09/01/2023 11:49:28 am >> DELETE FROM ps_document_detail WHERE id_document = '77508' 09/01/2023 11:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77508' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '11.15' , '11.15' , '0' , '0' , '11.15' ) 09/01/2023 11:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77508' , '12438' , 'MARIETTA E IL SUO CIELO - G. ALBERTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 09/01/2023 11:49:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77508' , '18758' , 'DAL CUORE DI SANTAGOSTINO ALLE LABBRA DI BENEDETTO XVI - A. FIGLIUZZI' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 09/01/2023 11:51:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4065' AND id_document != '77510' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 09/01/2023 11:51:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4065', document_date = '2022-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '32.00', price_tax_excluded = '31.28', date_upd = NOW() WHERE id_document = '77510' 09/01/2023 11:51:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77510' 09/01/2023 11:51:55 am >> DELETE FROM ps_document_detail WHERE id_document = '77510' 09/01/2023 11:51:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77510' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 09/01/2023 11:51:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77510' , '20479' , 'PAROLA E PREGHIERA - FEB 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 09/01/2023 11:51:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77510' , '20583' , 'PAROLA E PREGHIERA - MAR. 23' , '1' , '-1' , '4' , '2.74' , '2.74' , '0' , '' , '2.74' ) 09/01/2023 11:51:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77510' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '2.248' , '2.248' , '0' , '0' , '22.50' ) 09/01/2023 11:52:43 am >> SELECT document_num FROM ps_document WHERE document_num = '4091' AND id_document != '77541' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 09/01/2023 11:52:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4091', document_date = '2022-12-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO', 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 = '395.10', price_tax_excluded = '327.15', date_upd = NOW() WHERE id_document = '77541' 09/01/2023 11:52:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77541' 09/01/2023 11:52:43 am >> DELETE FROM ps_document_detail WHERE id_document = '77541' 09/01/2023 11:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '6' , '-6' , '4' , '3.05' , '3.05' , '0' , '0' , '18.30' ) 09/01/2023 11:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 09/01/2023 11:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 09/01/2023 11:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/01/2023 11:52:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '180.00' ) 09/01/2023 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 09/01/2023 11:53:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4145' AND id_document != '78119' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-30') 09/01/2023 11:53:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4145', document_date = '2022-12-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 = '12.00', price_tax_excluded = '12.00', date_upd = NOW() WHERE id_document = '78119' 09/01/2023 11:53:02 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 = '78119' 09/01/2023 11:53:02 am >> DELETE FROM ps_document_detail WHERE id_document = '78119' 09/01/2023 11:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78119' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '4' , '-4' , '4' , '3' , '3' , '0' , '0' , '12.00' ) 09/01/2023 11:53:24 am >> DELETE FROM ps_document WHERE id_document = '77553' 09/01/2023 11:53:24 am >> DELETE FROM ps_document_detail WHERE id_document = '77553' 09/01/2023 12:16:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '74' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 12:16:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '74' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '192.30' , '161.21' , NOW() , NOW() ) 09/01/2023 12:16:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78212' 09/01/2023 12:16:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '78212' 09/01/2023 12:16:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78212' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 09/01/2023 12:16:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78212' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 09/01/2023 12:16:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78212' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '13.30' ) 09/01/2023 12:16:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78212' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 09/01/2023 12:16:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78212' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 09/01/2023 12:21:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '75' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 12:21:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '75' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 09/01/2023 12:21:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78213' 09/01/2023 12:21:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '78213' 09/01/2023 12:21: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 ( '78213' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/01/2023 12:21: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 ( '78213' , '20592' , 'SULLA TUA PAROLA MAR/APR 2023 -515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/01/2023 12:34:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 12:34:35 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' , '76' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 09/01/2023 12:34: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 = '78214' 09/01/2023 12:34:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '78214' 09/01/2023 12:34: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 ( '78214' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 09/01/2023 12:36:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '77' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 12:36:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '77' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.03' , '5.54' , NOW() , NOW() ) 09/01/2023 12:36: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 = '78215' 09/01/2023 12:36:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '78215' 09/01/2023 12:36: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 ( '78215' , '14111' , 'BATTESIMO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 09/01/2023 12:36: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 ( '78215' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 09/01/2023 12:36: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 ( '78215' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '1.20' ) 09/01/2023 02:55:41 pm >> DELETE FROM ps_product WHERE id_product = '14246' 09/01/2023 02:55:41 pm >> DELETE FROM ps_product_shop WHERE id_product = '14246' 09/01/2023 02:55:41 pm >> DELETE FROM ps_product_lang WHERE id_product = '14246' 09/01/2023 02:55:41 pm >> DELETE FROM ps_stock_available WHERE id_product = '14246' 09/01/2023 03:00:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048080' AND id_product != '20592' AND ean13 != '' 09/01/2023 03:00:13 pm >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884048080', date_upd = NOW() WHERE id_product = '20592' 09/01/2023 03:00:13 pm >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA MAR/APR 23 - 515', description = '' WHERE id_product = '20592' 09/01/2023 03:00:13 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '20592' 09/01/2023 03:00:13 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20592' 09/01/2023 03:00:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '20592' 09/01/2023 03:01:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240438' AND id_product != '20528' AND ean13 != '' 09/01/2023 03:01:32 pm >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788892240438', date_upd = NOW() WHERE id_product = '20528' 09/01/2023 03:01:32 pm >> UPDATE ps_product_lang SET name = 'AMEN - MAR 23', description = '' WHERE id_product = '20528' 09/01/2023 03:01:32 pm >> UPDATE ps_product SET wholesale_price = '2.61', on_sale = '0', price = '3.9000' WHERE id_product = '20528' 09/01/2023 03:01:32 pm >> UPDATE ps_product_shop SET wholesale_price = '2.61', price = '3.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20528' 09/01/2023 03:01:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '20528' 09/01/2023 03:01:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240445' AND id_product != '20527' AND ean13 != '' 09/01/2023 03:01:41 pm >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788892240445', date_upd = NOW() WHERE id_product = '20527' 09/01/2023 03:01:41 pm >> UPDATE ps_product_lang SET name = 'AMEN - APR 23', description = '' WHERE id_product = '20527' 09/01/2023 03:01:41 pm >> UPDATE ps_product SET wholesale_price = '2.61', on_sale = '0', price = '3.9000' WHERE id_product = '20527' 09/01/2023 03:01:41 pm >> UPDATE ps_product_shop SET wholesale_price = '2.61', price = '3.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20527' 09/01/2023 03:01:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '20527' 09/01/2023 04:04:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '78' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 04:04:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '78' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 09/01/2023 04:04: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 = '78216' 09/01/2023 04:04:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '78216' 09/01/2023 04:04:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78216' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 09/01/2023 04:46:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '79' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 04:46:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '79' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.50' , '120.99' , NOW() , NOW() ) 09/01/2023 04:46:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78217' 09/01/2023 04:46:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '78217' 09/01/2023 04:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78217' , '14401' , 'BALZA CM 19' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 09/01/2023 04:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78217' , '7554' , 'PARAFIAMMA PLEXIGLASS CM 5' , '4' , '-4' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '76.00' ) 09/01/2023 04:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78217' , '15114' , 'BOCCIA VETRO TRASPARENTE - 489' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 09/01/2023 04:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78217' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 09/01/2023 04:57:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '80' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 04:57:50 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' , '80' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 09/01/2023 04:57:50 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 = '78218' 09/01/2023 04:57:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '78218' 09/01/2023 04:57: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 ( '78218' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '190' , '155.73770491803' , '22' , '0' , '190.00' ) 09/01/2023 04:58:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '81' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 04:58:50 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' , '81' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 09/01/2023 04:58:50 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 = '78219' 09/01/2023 04:58:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '78219' 09/01/2023 04:58: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 ( '78219' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 09/01/2023 05:08:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 05:08: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' , '82' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '189.40' , '161.63' , NOW() , NOW() ) 09/01/2023 05:08: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 = '78220' 09/01/2023 05:08:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '78220' 09/01/2023 05:08: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 ( '78220' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/01/2023 05:08: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 ( '78220' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 09/01/2023 05:08: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 ( '78220' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 09/01/2023 05:08: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 ( '78220' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 09/01/2023 05:08: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 ( '78220' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 09/01/2023 05:08: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 ( '78220' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/01/2023 05:27:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '83' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 05:27:39 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' , '83' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.50' , '61.39' , NOW() , NOW() ) 09/01/2023 05:27: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 = '78221' 09/01/2023 05:27:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '78221' 09/01/2023 05:27: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 ( '78221' , '19996' , 'GESU BAMBINO CM 34 - BJ142-34E' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 09/01/2023 05:27: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 ( '78221' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '24.5' , '24.5' , '0' , '0' , '24.50' ) 09/01/2023 06:54:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '80' AND id_document != '78218' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 06:54:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '80', document_date = '2023-01-09', 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 = '190.00', price_tax_excluded = '155.74', date_upd = NOW() WHERE id_document = '78218' 09/01/2023 06:54: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 = '78218' 09/01/2023 06:54:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '78218' 09/01/2023 06:54: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 ( '78218' , '15539' , 'STOLA LINO/LUREX SFILATURA A MANO' , '1' , '-1' , '1' , '190.00' , '155.73770491803' , '22' , '0' , '190.00' ) 09/01/2023 07:39:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '84' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 09/01/2023 07:39: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' , '84' , '2023-01-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.60' , '10.33' , NOW() , NOW() ) 09/01/2023 07:39: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 = '78222' 09/01/2023 07:39:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '78222' 09/01/2023 07:39: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 ( '78222' , '20071' , 'ROSARIO MISSIONARIO MM8' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 09/01/2023 07:39: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 ( '78222' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '9.00' )