22/12/2025 09:03:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4350' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 09:03:13 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' , '4350' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.90' , '38.44' , NOW() , NOW() ) 22/12/2025 09:03: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 = '100620' 22/12/2025 09:03:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100620' 22/12/2025 09:03: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 ( '100620' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '-1' , '1' , '46.90' , '38.44262295082' , '22' , '0' , '46.90' ) 22/12/2025 09:36:23 am >> SELECT document_num FROM ps_document WHERE document_num = '4351' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 09:36:23 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' , '4351' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 22/12/2025 09:36:23 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 = '100621' 22/12/2025 09:36:23 am >> DELETE FROM ps_document_detail WHERE id_document = '100621' 22/12/2025 09:36:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100621' , '14957' , 'QUADRETTO NATIVITA\' 16X12 - P577' , '3' , '-3' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '13.50' ) 22/12/2025 09:39:33 am >> SELECT document_num FROM ps_document WHERE document_num = '158/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 09:39: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 ( '24' , '158/A' , '2025-12-22' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'HOSPICE CASA DI LARA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '16.14' , NOW() , NOW() ) 22/12/2025 09:39: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 = '100622' 22/12/2025 09:39:33 am >> DELETE FROM ps_document_detail WHERE id_document = '100622' 22/12/2025 09:39: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 ( '100622' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/12/2025 09:39: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 ( '100622' , '4374' , 'GESÙ BAMBINO - 273' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 22/12/2025 09:55:28 am >> SELECT document_num FROM ps_document WHERE document_num = '4352' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 09:55: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' , '4352' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 22/12/2025 09:55: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 = '100623' 22/12/2025 09:55:28 am >> DELETE FROM ps_document_detail WHERE id_document = '100623' 22/12/2025 09:55: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 ( '100623' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 22/12/2025 10:09:43 am >> SELECT document_num FROM ps_document WHERE document_num = '4353' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 10:09:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4353' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 22/12/2025 10:09: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 = '100624' 22/12/2025 10:09:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100624' 22/12/2025 10:09: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 ( '100624' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 22/12/2025 10:20:56 am >> DELETE FROM ps_document WHERE id_document = '100599' 22/12/2025 10:20:56 am >> DELETE FROM ps_document_detail WHERE id_document = '100599' 22/12/2025 10:26:58 am >> SELECT document_num FROM ps_document WHERE document_num = '155/A' AND id_document != '100541' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-17') 22/12/2025 10:26:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '155/A', document_date = '2025-12-17', document_letter = 'A', id_customer = '2869', id_supplier = '0', id_address = '4671030', 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 = '2100.00', price_tax_excluded = '2100.00', date_upd = NOW() WHERE id_document = '100541' 22/12/2025 10:26:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100541' 22/12/2025 10:26:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100541' 22/12/2025 10:26:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100541' , '0' , 'SET 3 PEZZI NATIVITA\' CM 105' , '1' , '-1' , '0' , '1570' , '1570' , '' , '0' , '1570.00' ) 22/12/2025 10:26:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100541' , '0' , 'BAMBINELLO IN TERRACOTTA CM 40' , '1' , '-1' , '0' , '530' , '530' , '' , '0' , '530.00' ) 22/12/2025 10:27:06 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/12/2025 10:27:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24449' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 10:27:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24449' , '1' , '1' , '2' , NOW() , NOW() ) 22/12/2025 10:27:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24449' , '0' , '1' , '0' , '0' ) 22/12/2025 10:28:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826610641' AND id_product != '24449' AND ean13 != '' 22/12/2025 10:28:07 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788826610641', date_upd = NOW() WHERE id_product = '24449' 22/12/2025 10:28:07 am >> UPDATE ps_product_lang SET name = 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO', description = '' WHERE id_product = '24449' 22/12/2025 10:28:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '24449' 22/12/2025 10:28:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24449' 22/12/2025 10:28:07 am >> DELETE FROM ps_specific_price WHERE id_product = '24449' 22/12/2025 10:28:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '720131' , '2025-12-18' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '92.40' , '92.40' , NOW() , NOW() ) 22/12/2025 10:28: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 = '100625' 22/12/2025 10:28:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100625' 22/12/2025 10:28: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 ( '100625' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '12' , '12' , '4' , '11.00' , '11' , '0' , '30' , '92.4000' ) 22/12/2025 10:28:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '24449' AND id_supplier = '7' 22/12/2025 10:28:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24449' , '7' , '1' ) 22/12/2025 10:28: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 ( '100625' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '1' , '4' , '11.00' , '11' , '0' , '100' , '0.0000' ) 22/12/2025 10:28:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '24449' AND id_supplier = '7' 22/12/2025 10:28:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24449' , '7' , '1' ) 22/12/2025 10:29:07 am >> UPDATE ps_document SET id_document_type = '33', document_num = '720131', document_date = '2025-12-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '2.64', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '95.04', price_tax_excluded = '95.04', date_upd = NOW() WHERE id_document = '100625' 22/12/2025 10:29:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100625' 22/12/2025 10:29:07 am >> DELETE FROM ps_document_detail WHERE id_document = '100625' 22/12/2025 10:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100625' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '12' , '12' , '4' , '11.0000' , '11' , '0' , '30' , '92.40' ) 22/12/2025 10:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100625' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '1' , '4' , '11.0000' , '11' , '0' , '100' , '0.00' ) 22/12/2025 10:59:54 am >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 10:59:54 am >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679682', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 10:59: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 = '100593' 22/12/2025 10:59:54 am >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 10:59: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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNNR (M.C3-INVESTIMENTO 2.2) ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 10:59: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 ( '100593' , '0' , 'finanziato dall\'Unione Europea- nextGenerationEu \"Restauro e consolidamento struttura della chiesa ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 10:59: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 ( '100593' , '0' , 'della Madonna della Salute\" ID: PNNR-MC--2022-007500 CUP B97B22001270004.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 10:59: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 ( '100593' , '' , 'documento contabile rendicontato per un importo di ' , '1' , '-1' , '1' , '4380' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 11:06:56 am >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 11:06:56 am >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679682', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 11:06: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 = '100593' 22/12/2025 11:06:56 am >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 11:06: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 ( '100593' , '0' , 'Acconto 100% per spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNNR (M.C3-INVESTIMENTO 2.2) ' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 22/12/2025 11:06: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 ( '100593' , '0' , 'finanziato dall\'Unione Europea- nextGenerationEu \"Restauro e consolidamento struttura della chiesa ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 11:06: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 ( '100593' , '0' , 'della Madonna della Salute\" ID: PNNR-MC--2022-007500 CUP B97B22001270004.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 11:06: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 ( '100593' , '0' , 'documento contabile rendicontato per un importo di ' , '1' , '-1' , '1' , '4380.0000' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 11:13:34 am >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 11:13:34 am >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679682', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 11:13: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 = '100593' 22/12/2025 11:13:34 am >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 11:13: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 ( '100593' , '0' , 'Acconto 100% per spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 22/12/2025 11:13: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 ( '100593' , '0' , 'Progetto PNNR (M.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 22/12/2025 11:13:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 22/12/2025 11:13:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , 'ID: PNNR-MC--2022-007500 CUP B97B22001270004.' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0.00' ) 22/12/2025 11:13:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '' , 'documento contabile rendicontato per un importo di' , '1' , '-1' , '1' , '4380' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 11:17:24 am >> SELECT document_num FROM ps_document WHERE document_num = '4354' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 11:17: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' , '4354' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.00' , '103.48' , NOW() , NOW() ) 22/12/2025 11:17: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 = '100626' 22/12/2025 11:17:24 am >> DELETE FROM ps_document_detail WHERE id_document = '100626' 22/12/2025 11:17: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 ( '100626' , '23188' , 'GRUPPO NATIVITA\' CAMPANA CON LUCI - PB20515' , '1' , '-1' , '1' , '26.81' , '21.975409836066' , '22' , '0' , '26.81' ) 22/12/2025 11:17: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 ( '100626' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/12/2025 11:17:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100626' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/12/2025 11:17:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100626' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 22/12/2025 11:17:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100626' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 22/12/2025 11:17:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100626' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/12/2025 11:21:17 am >> SELECT document_num FROM ps_document WHERE document_num = '4355' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 11:21:17 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' , '4355' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 22/12/2025 11:21:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100627' 22/12/2025 11:21:17 am >> DELETE FROM ps_document_detail WHERE id_document = '100627' 22/12/2025 11:21:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100627' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 22/12/2025 11:27:42 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/12/2025 11:27:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24450' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 11:27:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24450' , '1' , '1' , '2' , NOW() , NOW() ) 22/12/2025 11:27:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24450' , '0' , '1' , '0' , '0' ) 22/12/2025 11:28:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793279' AND id_product != '24450' AND ean13 != '' 22/12/2025 11:28:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788878793279', date_upd = NOW() WHERE id_product = '24450' 22/12/2025 11:28:41 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - MAR APR 26', description = '' WHERE id_product = '24450' 22/12/2025 11:28:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '24450' 22/12/2025 11:28:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', 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 = '24450' 22/12/2025 11:28:41 am >> DELETE FROM ps_specific_price WHERE id_product = '24450' 22/12/2025 11:28:43 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 = '24450' 22/12/2025 11:28:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24451' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 11:28:43 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 '24451' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24450' 22/12/2025 11:28:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24451' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24450' 22/12/2025 11:31:11 am >> SELECT document_num FROM ps_document WHERE document_num = '159/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 11:31:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '159/A' , '2025-12-22' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , 'ACCONTO € 400,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1600.00' , '1311.48' , NOW() , NOW() ) 22/12/2025 11:31:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100628' 22/12/2025 11:31:11 am >> DELETE FROM ps_document_detail WHERE id_document = '100628' 22/12/2025 11:31:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100628' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1600' , '1311.4754098361' , '22' , '0' , '1600.00' ) 22/12/2025 11:32:21 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' , '536/2025' , '2025-12-15' , '2025' , '0' , '40' , '2635' , 'VIA CARLO POMA, 2 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '38.40' , '38.40' , NOW() , NOW() ) 22/12/2025 11:32:21 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 = '100629' 22/12/2025 11:32:21 am >> DELETE FROM ps_document_detail WHERE id_document = '100629' 22/12/2025 11:32:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100629' , '24450' , 'MESSA MEDITAZIONE - MAR APR 26' , '8' , '8' , '4' , '8.00' , '8' , '0' , '40' , '38.4000' ) 22/12/2025 11:32:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '24450' AND id_supplier = '40' 22/12/2025 11:32:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24450' , '40' , '1' ) 22/12/2025 11:42:43 am >> SELECT document_num FROM ps_document WHERE document_num = '4356' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 11:42:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4356' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.90' , '119.26' , NOW() , NOW() ) 22/12/2025 11:42:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100630' 22/12/2025 11:42:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100630' 22/12/2025 11:42:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100630' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '75' , '-75' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '120.00' ) 22/12/2025 11:42:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100630' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '2' , '-2' , '4' , '11.00' , '11' , '0' , '5' , '20.90' ) 22/12/2025 11:48:42 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' , '007706' , '2025-12-02' , '' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 22/12/2025 11:48:42 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 = '100631' 22/12/2025 11:48:42 am >> DELETE FROM ps_document_detail WHERE id_document = '100631' 22/12/2025 11:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100631' , '24437' , 'PADRE NOSTRO POSTER - R. LUPI' , '300' , '300' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 22/12/2025 11:48:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '24437' AND id_supplier = '125' 22/12/2025 11:48:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24437' , '125' , '1' ) 22/12/2025 11:54:21 am >> SELECT document_num FROM ps_document WHERE document_num = '280' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 11:54:21 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' , '280' , '2025-12-22' , '' , '321' , '0' , '4672782' , 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '379.75' , '379.75' , NOW() , NOW() ) 22/12/2025 11:54:21 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 = '100632' 22/12/2025 11:54:21 am >> DELETE FROM ps_document_detail WHERE id_document = '100632' 22/12/2025 11:54:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100632' , '2679' , 'CONOSCERE GESU\'' , '22' , '-22' , '4' , '3.5000' , '3.5' , '0' , '15' , '65.45' ) 22/12/2025 11:54:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100632' , '5457' , 'IO SONO CON VOI 1 PARTE' , '25' , '-25' , '4' , '2.8000' , '2.8' , '0' , '15' , '59.50' ) 22/12/2025 11:54:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100632' , '4154' , 'FESTA DEL PERDONO' , '19' , '-19' , '4' , '3.0000' , '3' , '0' , '15' , '48.45' ) 22/12/2025 11:54:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100632' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '27' , '-27' , '4' , '3.0000' , '3' , '0' , '15' , '68.85' ) 22/12/2025 11:54:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100632' , '5444' , 'IO SONO CON VOI - CAT.' , '25' , '-25' , '4' , '5.5000' , '5.5' , '0' , '0' , '137.50' ) 22/12/2025 11:54:35 am >> DELETE FROM ps_document WHERE id_document = '100252' 22/12/2025 11:54:35 am >> DELETE FROM ps_document_detail WHERE id_document = '100252' 22/12/2025 12:02:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4357' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:02:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4357' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.00' , '95.08' , NOW() , NOW() ) 22/12/2025 12:02: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 = '100633' 22/12/2025 12:02:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '100633' 22/12/2025 12:02: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 ( '100633' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '58' , '47.540983606557' , '22' , '0' , '116.00' ) 22/12/2025 12:10:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '4071' AND id_document != '100282' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-04') 22/12/2025 12:10:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4071', document_date = '2025-12-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 = '122.00', price_tax_excluded = '100.00', date_upd = NOW() WHERE id_document = '100282' 22/12/2025 12:10:03 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 = '100282' 22/12/2025 12:10:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100282' 22/12/2025 12:10: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 ( '100282' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 22/12/2025 12:10: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 ( '100282' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '40' , '-40' , '1' , '3' , '2.4590163934426' , '22' , '0' , '120.00' ) 22/12/2025 12:10: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 ( '100282' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '7' , '-7' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.75' ) 22/12/2025 12:14:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3796' AND id_document != '99907' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-14') 22/12/2025 12:14:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3796', document_date = '2025-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '290.00', price_tax_excluded = '237.70', date_upd = NOW() WHERE id_document = '99907' 22/12/2025 12:14:25 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 = '99907' 22/12/2025 12:14:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '99907' 22/12/2025 12:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99907' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 22/12/2025 12:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99907' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '50' , '-50' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '150.00' ) 22/12/2025 12:15:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3845' AND id_document != '99980' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 22/12/2025 12:15:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3845', document_date = '2025-11-19', 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 = '189.00', price_tax_excluded = '154.92', date_upd = NOW() WHERE id_document = '99980' 22/12/2025 12:15:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99980' 22/12/2025 12:15:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '99980' 22/12/2025 12:15: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 ( '99980' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 22/12/2025 12:15: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 ( '99980' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 22/12/2025 12:15: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 ( '99980' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '90' , '73.770491803279' , '22' , '0' , '180.00' ) 22/12/2025 12:18:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4358' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:18:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4358' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.96' , '17.96' , NOW() , NOW() ) 22/12/2025 12:18: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 = '100634' 22/12/2025 12:18:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '100634' 22/12/2025 12:18: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 ( '100634' , '23567' , 'SEGRETO DI MIO FIGLIO - SALZANO/ACUTIS' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.96' ) 22/12/2025 12:22:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3855' AND id_document != '99992' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 22/12/2025 12:22:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3855', document_date = '2025-11-19', 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 = '130.60', price_tax_excluded = '115.50', date_upd = NOW() WHERE id_document = '99992' 22/12/2025 12:22:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99992' 22/12/2025 12:22:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '99992' 22/12/2025 12:22:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99992' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 22/12/2025 12:22:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99992' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 22/12/2025 12:22:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99992' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 22/12/2025 12:22:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99992' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 22/12/2025 12:22:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99992' , '24286' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '2' , '-2' , '4' , '1.8000' , '1.8' , '0' , '0' , '3.60' ) 22/12/2025 12:22:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99992' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '8' , '-8' , '1' , '3' , '2.4590163934426' , '22' , '0' , '24.00' ) 22/12/2025 12:22:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3893' AND id_document != '100047' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-22') 22/12/2025 12:22:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3893', document_date = '2025-11-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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '100047' 22/12/2025 12:22: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 = '100047' 22/12/2025 12:22:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100047' 22/12/2025 12:22: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 ( '100047' , '6328' , 'MEDAGLIA MISERICORDIOSO MM 22 - METALLO OX' , '6' , '-6' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.50' ) 22/12/2025 12:22: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 ( '100047' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '11' , '-11' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '38.50' ) 22/12/2025 12:23:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '4063' AND id_document != '100274' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-04') 22/12/2025 12:23:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4063', document_date = '2025-12-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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '100274' 22/12/2025 12:23:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100274' 22/12/2025 12:23:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '100274' 22/12/2025 12:23:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100274' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 22/12/2025 12:23:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100274' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3' , '2.4590163934426' , '22' , '0' , '15.00' ) 22/12/2025 12:23:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '4208' AND id_document != '100447' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-13') 22/12/2025 12:23:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4208', document_date = '2025-12-13', 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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '100447' 22/12/2025 12:23:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100447' 22/12/2025 12:23:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '100447' 22/12/2025 12:23:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100447' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '2' , '-2' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '32.00' ) 22/12/2025 12:23:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100447' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '6' , '-6' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '30.00' ) 22/12/2025 12:23:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100447' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 22/12/2025 12:23:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100447' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '13' , '-13' , '1' , '3' , '2.4590163934426' , '22' , '0' , '39.00' ) 22/12/2025 12:24:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '4233' AND id_document != '100479' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-15') 22/12/2025 12:24:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4233', document_date = '2025-12-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '100479' 22/12/2025 12:24:03 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 = '100479' 22/12/2025 12:24:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100479' 22/12/2025 12:24: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 ( '100479' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3' , '2.4590163934426' , '22' , '0' , '30.00' ) 22/12/2025 12:25:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4012' AND id_document != '100202' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-02') 22/12/2025 12:25:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4012', document_date = '2025-12-02', 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 = '10.90', price_tax_excluded = '8.93', date_upd = NOW() WHERE id_document = '100202' 22/12/2025 12:25:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100202' 22/12/2025 12:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100202' 22/12/2025 12:25:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100202' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.7' , '2.2131147540984' , '22' , '0' , '2.70' ) 22/12/2025 12:25:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100202' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 22/12/2025 12:25:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100202' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/12/2025 12:25:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100202' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 22/12/2025 12:25:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100202' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 22/12/2025 12:26:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '4205' AND id_document != '100444' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 22/12/2025 12:26:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4205', document_date = '2025-12-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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '100444' 22/12/2025 12:26: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 = '100444' 22/12/2025 12:26:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '100444' 22/12/2025 12:26: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 ( '100444' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 22/12/2025 12:26: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 ( '100444' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/12/2025 12:26:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4293' AND id_document != '100555' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-18') 22/12/2025 12:26:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4293', document_date = '2025-12-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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '100555' 22/12/2025 12:26: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 = '100555' 22/12/2025 12:26:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '100555' 22/12/2025 12:26: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 ( '100555' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 22/12/2025 12:26: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 ( '100555' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/12/2025 12:27:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '4190' AND id_document != '100425' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 22/12/2025 12:27:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4190', document_date = '2025-12-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 = '39.50', price_tax_excluded = '32.38', date_upd = NOW() WHERE id_document = '100425' 22/12/2025 12:27: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 = '100425' 22/12/2025 12:27:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '100425' 22/12/2025 12:27: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 ( '100425' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '46' , '-46' , '1' , '0.7500' , '0.61475409836066' , '22' , '0' , '34.50' ) 22/12/2025 12:27: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 ( '100425' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 22/12/2025 12:27:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4179' AND id_document != '100413' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-11') 22/12/2025 12:27:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4179', document_date = '2025-12-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '72.60', price_tax_excluded = '60.86', date_upd = NOW() WHERE id_document = '100413' 22/12/2025 12:27: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 = '100413' 22/12/2025 12:27:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '100413' 22/12/2025 12:27: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 ( '100413' , '23041' , 'CORONA SANTA RITA - 10944' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 22/12/2025 12:27: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 ( '100413' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '3' , '-3' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.50' ) 22/12/2025 12:27: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 ( '100413' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 22/12/2025 12:27: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 ( '100413' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '3' , '-3' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '37.50' ) 22/12/2025 12:27: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 ( '100413' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.75' , '2.2540983606557' , '22' , '0' , '5.50' ) 22/12/2025 12:27: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 ( '100413' , '6242' , 'MARIA IMMACOLATA - S. CECCHIN' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/12/2025 12:27: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 ( '100413' , '18199' , 'QUADRETTO EFFETTO PIETRA SANTA RITA - 2952' , '2' , '-2' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '8.00' ) 22/12/2025 12:27: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 ( '100413' , '475' , 'AMICO GESÙ - FIGURINE' , '5' , '-5' , '4' , '0.5000' , '0.5' , '0' , '0' , '2.50' ) 22/12/2025 12:31:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:31:01 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679682', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 12:31: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 = '100593' 22/12/2025 12:31:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 12:31: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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 22/12/2025 12:31: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 ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 22/12/2025 12:31: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 ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 12:31: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 ( '100593' , '0' , 'ID: PNNR-MC--2022-007500 CUP B97B22001270004.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 12:31: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 ( '100593' , '0' , 'documento contabile rendicontato per un importo di € 3590.16 + IVA' , '1' , '-1' , '1' , '4380.0000' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 12:33:08 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4299' 22/12/2025 12:33:08 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 ( '4299' , '10' , '210' , 'ASSOCIAZIONE SAN VITO MARTIRE' , '' , '' , 'PIAZZA SAN VITO' , '' , '84020' , 'SAN GREGORIO MAGNO ' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNRR [M1.C3 - INVESTIMENTO 2.2] finanziato dall\'Unione Europea - NextGenerationEU \"Restauro e consolidamento strutturale della chiesa della Madonna della Salute\" ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004. Documento contabile rendicontato per un importo di Euro 3.590,16 € + iva.' , '' , '' , '91048770654' , '' , NOW() , NOW() ) 22/12/2025 12:33:09 pm >> UPDATE ps_customer SET email = '', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4299' 22/12/2025 12:34:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:34:10 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679682', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 12:34: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 = '100593' 22/12/2025 12:34:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 12:34: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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 12:34: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 ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 12:34: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 ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 12:34: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 ( '100593' , '0' , ' ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 22/12/2025 12:34: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 ( '100593' , '0' , 'documento contabile rendicontato per un importo di € 3590.16 + IVA' , '1' , '-1' , '1' , '4380.0000' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 12:36:13 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4299' 22/12/2025 12:36:13 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 ( '4299' , '10' , '210' , 'ASSOCIAZIONE SAN VITO MARTIRE' , '' , '' , 'PIAZZA SAN VITO' , '' , '84020' , 'SAN GREGORIO MAGNO ' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNRR [M1.C3 - INVESTIMENTO 2.2] finanziato dall\'Unione Europea - NextGenerationEU \"Restauro e consolidamento strutturale della chiesa della Madonna della Salute\" ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004. Documento contabile rendicontato per un importo di Euro 3.590,16 € + iva.' , '' , '' , '91048770654' , '' , NOW() , NOW() ) 22/12/2025 12:36:13 pm >> UPDATE ps_customer SET email = '', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4299' 22/12/2025 12:45:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '4359' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:45: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' , '4359' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 22/12/2025 12:45: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 = '100635' 22/12/2025 12:45:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '100635' 22/12/2025 12:45: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 ( '100635' , '22440' , 'ROSARIO ARGENTO/LAVA - 7692/50' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 22/12/2025 12:45: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 ( '100635' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 22/12/2025 12:52:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '4360' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:52:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4360' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 22/12/2025 12:52:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100636' 22/12/2025 12:52:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '100636' 22/12/2025 12:52: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 ( '100636' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '35.00' ) 22/12/2025 12:53:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '4360' AND id_document != '100636' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:53:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4360', document_date = '2025-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 = '35.00', price_tax_excluded = '28.69', date_upd = NOW() WHERE id_document = '100636' 22/12/2025 12:53: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 = '100636' 22/12/2025 12:53:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '100636' 22/12/2025 12:53: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 ( '100636' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 22/12/2025 12:55:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831558631' AND id_product != '24451' AND ean13 != '' 22/12/2025 12:55:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831558631', date_upd = NOW() WHERE id_product = '24451' 22/12/2025 12:55:25 pm >> UPDATE ps_product_lang SET name = 'LETTERE INSOLITE PER IL NATALE', description = '' WHERE id_product = '24451' 22/12/2025 12:55:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '24451' 22/12/2025 12:55:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24451' 22/12/2025 12:55:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '24451' 22/12/2025 12:55:26 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24451' 22/12/2025 12:55:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24452' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 12:55:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24452' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24451' 22/12/2025 12:55:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24452' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24451' 22/12/2025 12:55:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831558433' AND id_product != '24452' AND ean13 != '' 22/12/2025 12:55:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831558433', date_upd = NOW() WHERE id_product = '24452' 22/12/2025 12:55:55 pm >> UPDATE ps_product_lang SET name = 'ANGELI SUL MIO CAMMINO', description = '' WHERE id_product = '24452' 22/12/2025 12:55:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '24452' 22/12/2025 12:55:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24452' 22/12/2025 12:55:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '24452' 22/12/2025 12:55:56 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24452' 22/12/2025 12:55:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24453' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 12:55:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24453' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24452' 22/12/2025 12:55:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24453' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24452' 22/12/2025 12:57:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '281' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 12:57: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 ( '21' , '281' , '2025-12-22' , '' , '4081' , '0' , '4679276' , 'VIA PAZZIGNO 6 80146 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '67.50' , '67.50' , NOW() , NOW() ) 22/12/2025 12: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 = '100637' 22/12/2025 12:57:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '100637' 22/12/2025 12: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 ( '100637' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 22/12/2025 12: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 ( '100637' , '24266' , 'VENITE A ME - F. CRISTOFARO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 22/12/2025 12: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 ( '100637' , '24431' , 'ROSARIO E NOVENA CON LA SERVA DI DIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/12/2025 12: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 ( '100637' , '24220' , 'SIATE SANTI SIATE FELICI - 8404' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 22/12/2025 12: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 ( '100637' , '24432' , 'SANTA MARIA TRONCATTI - 8567' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 22/12/2025 12: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 ( '100637' , '24451' , 'LETTERE INSOLITE PER IL NATALE' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 22/12/2025 12: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 ( '100637' , '24452' , 'ANGELI SUL MIO CAMMINO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 22/12/2025 12: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 ( '100637' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 22/12/2025 02:24:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241336' AND id_product != '24453' AND ean13 != '' 22/12/2025 02:24:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788892241336', date_upd = NOW() WHERE id_product = '24453' 22/12/2025 02:24:47 pm >> UPDATE ps_product_lang SET name = 'PRATICHE PASTORALI, ESPERIENZE', description = '' WHERE id_product = '24453' 22/12/2025 02:24:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '46' WHERE id_product = '24453' 22/12/2025 02:24:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '46', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24453' 22/12/2025 02:24:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '24453' 22/12/2025 02:24:48 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24453' 22/12/2025 02:24:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24454' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 02:24:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24454' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24453' 22/12/2025 02:24:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24454' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24453' 22/12/2025 02:26:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019285' AND id_product != '24454' AND ean13 != '' 22/12/2025 02:26:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788825019285', date_upd = NOW() WHERE id_product = '24454' 22/12/2025 02:26:14 pm >> UPDATE ps_product_lang SET name = 'ASCOLTARE E\' UNA FESTA ANNO C - F. ARMELLINI', description = '' WHERE id_product = '24454' 22/12/2025 02:26:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '24454' 22/12/2025 02:26:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '17', 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 = '24454' 22/12/2025 02:26:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '24454' 22/12/2025 02:26:23 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24454' 22/12/2025 02:26:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24455' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 02:26:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24455' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24454' 22/12/2025 02:26:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24455' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24454' 22/12/2025 02:26:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019278' AND id_product != '24455' AND ean13 != '' 22/12/2025 02:26:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788825019278', date_upd = NOW() WHERE id_product = '24455' 22/12/2025 02:26:49 pm >> UPDATE ps_product_lang SET name = 'ASCOLTARE E\' UNA FESTA ANNO B - F. ARMELLINI', description = '' WHERE id_product = '24455' 22/12/2025 02:26:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '24455' 22/12/2025 02:26:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '17', 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 = '24455' 22/12/2025 02:26:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '24455' 22/12/2025 02:26:50 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24455' 22/12/2025 02:26:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24456' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 02:26:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24456' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24455' 22/12/2025 02:26:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24456' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24455' 22/12/2025 02:27:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019261' AND id_product != '24456' AND ean13 != '' 22/12/2025 02:27:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788825019261', date_upd = NOW() WHERE id_product = '24456' 22/12/2025 02:27:08 pm >> UPDATE ps_product_lang SET name = 'ASCOLTARE E\' UNA FESTA ANNO A - F. ARMELLINI', description = '' WHERE id_product = '24456' 22/12/2025 02:27:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '24456' 22/12/2025 02:27:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '17', 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 = '24456' 22/12/2025 02:27:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '24456' 22/12/2025 02:27:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24456' 22/12/2025 02:27:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24457' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 02:27:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24457' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24456' 22/12/2025 02:27:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24457' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24456' 22/12/2025 02:29:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868948337' AND id_product != '24457' AND ean13 != '' 22/12/2025 02:29:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868948337', date_upd = NOW() WHERE id_product = '24457' 22/12/2025 02:29:16 pm >> UPDATE ps_product_lang SET name = 'QUANTI VOLTI HA DIO - G. CRIVELLER', description = '' WHERE id_product = '24457' 22/12/2025 02:29:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '24457' 22/12/2025 02:29:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24457' 22/12/2025 02:29:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '24457' 22/12/2025 02:29:17 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24457' 22/12/2025 02:29:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24458' , '1' , '' , 'nuovo-prodotto' ) 22/12/2025 02:29:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24458' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24457' 22/12/2025 02:29:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24458' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24457' 22/12/2025 02:30:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '720318' , '2025-12-19' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.72' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.88' , '167.88' , NOW() , NOW() ) 22/12/2025 02:30: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 = '100638' 22/12/2025 02:30:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '100638' 22/12/2025 02:30: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 ( '100638' , '24453' , 'PRATICHE PASTORALI, ESPERIENZE' , '1' , '1' , '4' , '46.00' , '46' , '0' , '33' , '30.8200' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24453' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24453' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '16429' , 'ASCOLTARTI E UNA FESTA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16429' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16429' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '24454' , 'ASCOLTARE E UNA FESTA ANNO C - F. ARMELLINI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24454' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24454' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '24456' , 'ASCOLTARE E UNA FESTA ANNO A - F. ARMELLINI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24456' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24456' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '24455' , 'ASCOLTARE E UNA FESTA ANNO B - F. ARMELLINI' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24455' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24455' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '24452' , 'ANGELI SUL MIO CAMMINO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24452' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24452' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '24451' , 'LETTERE INSOLITE PER IL NATALE' , '1' , '1' , '4' , '8.00' , '8' , '0' , '33' , '5.3600' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24451' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24451' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '24457' , 'QUANTI VOLTI HA DIO - G. CRIVELLER' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24457' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24457' , '7' , '1' ) 22/12/2025 02:30: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 ( '100638' , '24425' , 'DIO E LA VERA REALTA - BENEDETTO XVI' , '2' , '2' , '4' , '25.00' , '25' , '0' , '30' , '35.0000' ) 22/12/2025 02:30:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24425' AND id_supplier = '7' 22/12/2025 02:30:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24425' , '7' , '1' ) 22/12/2025 02:32:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4299' 22/12/2025 02:32:22 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 ( '4299' , '10' , '210' , 'ASSOCIAZIONE SAN VITO MARTIRE' , '' , '' , 'PIAZZA SAN VITO' , '' , '84020' , 'SAN GREGORIO MAGNO ' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNRR [M1.C3 - INVESTIMENTO 2.2] finanziato dall\'Unione Europea - NextGenerationEU \"Restauro e consolidamento strutturale della chiesa della Madonna della Salute\" ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004. Documento contabile rendicontato per un importo di Euro 3.590,16 € + iva.' , '' , '' , '91048770654' , '91048770654' , NOW() , NOW() ) 22/12/2025 02:32:22 pm >> UPDATE ps_customer SET email = '', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4299' 22/12/2025 02:32:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 02:32:37 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '0', id_address = '4679685', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 02:32:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 02:32:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 02:32:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:32:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:32:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:32:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , ' ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:32:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , 'documento contabile rendicontato per un importo di € 3590.16 + IVA' , '1' , '-1' , '1' , '4380.0000' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 02:37:42 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4299' 22/12/2025 02:37:42 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 ( '4299' , '10' , '210' , 'ASSOCIAZIONE ' , 'MARTIRE' , 'SAN VITO ' , 'PIAZZA SAN VITO' , '' , '84020' , 'SAN GREGORIO MAGNO ' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNRR [M1.C3 - INVESTIMENTO 2.2] finanziato dall\'Unione Europea - NextGenerationEU \"Restauro e consolidamento strutturale della chiesa della Madonna della Salute\" ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004. Documento contabile rendicontato per un importo di Euro 3.590,16 € + iva.' , '' , '' , '91048770654' , '91048770654' , NOW() , NOW() ) 22/12/2025 02:37:42 pm >> UPDATE ps_customer SET email = '', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4299' 22/12/2025 02:38:50 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4299' 22/12/2025 02:38:50 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 ( '4299' , '10' , '210' , 'ASSOCIAZIONE ' , 'SAN VITO ' , 'MARTIRE ' , 'PIAZZA SAN VITO' , '' , '84020' , 'SAN GREGORIO MAGNO ' , 'Spesa relativa ai lavori di fornitura di arredi sacri. Progetto PNRR [M1.C3 - INVESTIMENTO 2.2] finanziato dall\'Unione Europea - NextGenerationEU \"Restauro e consolidamento strutturale della chiesa della Madonna della Salute\" ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004. Documento contabile rendicontato per un importo di Euro 3.590,16 € + iva.' , '' , '' , '91048770654' , '91048770654' , NOW() , NOW() ) 22/12/2025 02:38:50 pm >> UPDATE ps_customer SET email = '', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4299' 22/12/2025 02:39:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 02:39:15 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '0', id_address = '4679687', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 02:39: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 = '100593' 22/12/2025 02:39:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 02:39: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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:39: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 ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:39: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 ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:39: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 ( '100593' , '0' , ' ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:39: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 ( '100593' , '0' , 'documento contabile rendicontato per un importo di € 3590.16 + IVA' , '1' , '-1' , '1' , '4380.0000' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 02:41:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 02:41:30 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679687', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 02:41: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 = '100593' 22/12/2025 02:41:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 02:41: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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:41: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 ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:41: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 ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:41: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 ( '100593' , '0' , ' ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 02:41: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 ( '100593' , '0' , 'documento contabile rendicontato per un importo di ' , '1' , '-1' , '1' , '4380.0000' , '3590.1639344262' , '22' , '0' , '4380.00' ) 22/12/2025 03:10:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4361' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 03:10:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4361' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 22/12/2025 03:10:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100639' 22/12/2025 03:10:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100639' 22/12/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100639' , '21902' , 'BAMBINO OCCHI DIPINTI CM 30 - 30/PL' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 22/12/2025 03:23:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4081' 22/12/2025 03:23:53 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 ( '4081' , '10' , '183' , '' , 'TUBELLI' , 'LUIGI' , 'VIA PAZZIGNO 6' , '' , '80146' , 'NAPOLI' , '' , '0817527736' , '3389922636' , '' , '' , NOW() , NOW() ) 22/12/2025 03:23:53 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4081' 22/12/2025 03:26:46 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4081' 22/12/2025 03:26:46 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 ( '4081' , '10' , '183' , '' , 'TUBELLI' , 'LUIGI' , 'VIA PAZZIGNO 6' , '' , '80146' , 'NAPOLI' , 'VIA FERRANTE IMPARATO 213' , '0817527736' , '3389922636' , '' , '' , NOW() , NOW() ) 22/12/2025 03:26:46 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4081' 22/12/2025 03:28:18 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4081' 22/12/2025 03:28:18 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 ( '4081' , '10' , '183' , '' , 'TUBELLI' , 'LUIGI' , 'VIA PAZZIGNO 6' , '' , '80146' , 'NAPOLI' , 'VIA FERRANTE IMPARATO 213\r\nDA CONSEGNARE AL PORTIERE' , '0817527736' , '3389922636' , '' , '' , NOW() , NOW() ) 22/12/2025 03:28:18 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4081' 22/12/2025 03:33:33 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4081' 22/12/2025 03:33:33 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 ( '4081' , '10' , '183' , '' , 'TUBELLI' , 'LUIGI' , 'VIA PAZZIGNO 6' , '' , '80146' , 'NAPOLI' , 'VIA FERRANTE IMPARATO 213\r\nDA CONSEGNARE AL PORTIERE' , '0817527736' , '3389922636' , '' , '' , NOW() , NOW() ) 22/12/2025 03:33:33 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4081' 22/12/2025 03:39:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '4362' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 03:39:05 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' , '4362' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 22/12/2025 03:39:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100640' 22/12/2025 03:39:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '100640' 22/12/2025 03:39: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 ( '100640' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 22/12/2025 04:16:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4363' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 04:16:25 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' , '4363' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.70' , '24.70' , NOW() , NOW() ) 22/12/2025 04:16:25 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 = '100641' 22/12/2025 04:16:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '100641' 22/12/2025 04:16:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100641' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 22/12/2025 04:16:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100641' , '24288' , 'FORZA DEL VANGELO - LEONE XIV' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/12/2025 04:19:34 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4081' 22/12/2025 04:19:34 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 ( '4081' , '10' , '183' , '' , 'TUBELLI' , 'LUIGI' , 'VIA PAZZIGNO 6' , '' , '80146' , 'NAPOLI' , 'VIA FERRANTE IMPARATO 213\r\nDA CONSEGNARE AL PORTIERE\r\nSIGNORA 3807083389' , '0817527736' , 'LUIGI 3389922636' , '' , '' , NOW() , NOW() ) 22/12/2025 04:19:34 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4081' 22/12/2025 04:27:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 04:27:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4364' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '11.00' , NOW() , NOW() ) 22/12/2025 04:27: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 = '100642' 22/12/2025 04:27:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '100642' 22/12/2025 04:27: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 ( '100642' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 22/12/2025 04:58:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '4365' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 04:58:28 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' , '4365' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '64.75' , NOW() , NOW() ) 22/12/2025 04:58:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100643' 22/12/2025 04:58:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '100643' 22/12/2025 04:58:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100643' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 22/12/2025 04:58:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100643' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 22/12/2025 04:59:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4366' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 04:59:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4366' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 22/12/2025 04:59: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 = '100644' 22/12/2025 04:59:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '100644' 22/12/2025 04:59: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 ( '100644' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 22/12/2025 05:05:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '4367' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 05:05: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' , '4367' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '21.48' , NOW() , NOW() ) 22/12/2025 05:05: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 = '100645' 22/12/2025 05:05:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '100645' 22/12/2025 05:05: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 ( '100645' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '2' , '-2' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '14.00' ) 22/12/2025 05:05: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 ( '100645' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/12/2025 05:06:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '4368' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 05:06:22 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' , '4368' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '20.19' , NOW() , NOW() ) 22/12/2025 05:06: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 = '100646' 22/12/2025 05:06:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '100646' 22/12/2025 05:06: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 ( '100646' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 22/12/2025 05:11:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 05:11:58 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679687', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '1480.00', price_tax_excluded = '1213.11', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 05:11: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 = '100593' 22/12/2025 05:11:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 05:11: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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:11: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 ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:11: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 ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:11: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 ( '100593' , '0' , ' ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:11: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 ( '100593' , '0' , 'documento contabile rendicontato per un importo di € 3590,16+ IVA' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 22/12/2025 05:11: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 ( '100593' , '24439' , 'ALTARE IN LEGNO - 358' , '1' , '-1' , '1' , '1480.00' , '1213.1147540984' , '22' , '0' , '1480.00' ) 22/12/2025 05:11: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 ( '100593' , '24440' , 'LEGGIO LEGNO - 333/L ' , '1' , '-1' , '1' , '200.00' , '163.93442622951' , '22' , '0' , '' ) 22/12/2025 05:12:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 05:12:45 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679687', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 05:12:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 05:12:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 05:12: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 ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:12: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 ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:12: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 ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:12: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 ( '100593' , '0' , ' ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:12: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 ( '100593' , '0' , 'documento contabile rendicontato per un importo di € 3590,16+ IVA' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 22/12/2025 05:12: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 ( '100593' , '24439' , 'ALTARE IN LEGNO - 358' , '1' , '-1' , '1' , '1480.0000' , '1213.1147540984' , '22' , '0' , '1480.00' ) 22/12/2025 05:12: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 ( '100593' , '24440' , 'LEGGIO LEGNO - 333/L ' , '1' , '-1' , '1' , '200.00' , '163.93442622951' , '22' , '0' , '200.00' ) 22/12/2025 05:12: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 ( '100593' , '24441' , 'LEGGIO A STELO - 196' , '1' , '-1' , '1' , '250.00' , '204.91803278689' , '22' , '0' , '250.00' ) 22/12/2025 05:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24442' , 'CROCIFISSO LEGNO CORPO CM 80 - 180' , '1' , '-1' , '1' , '870.00' , '713.11475409836' , '22' , '0' , '870.00' ) 22/12/2025 05:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24443' , 'BASE PER CROCE IN LEGNO 60X40 - 1890' , '1' , '-1' , '1' , '280.00' , '229.50819672131' , '22' , '0' , '280.00' ) 22/12/2025 05:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24444' , 'POLTRONA IN VELLUTO - 7101' , '1' , '-1' , '1' , '760.00' , '622.95081967213' , '22' , '0' , '760.00' ) 22/12/2025 05:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24445' , 'SGABELLO IN NOCE - 7102' , '2' , '-2' , '1' , '270.00' , '221.31147540984' , '22' , '0' , '540.00' ) 22/12/2025 05:14:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/L' AND id_document != '100593' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 05:14:09 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '41/L', document_date = '2025-12-22', document_letter = 'L', id_customer = '4299', id_supplier = '', id_address = '4679687', address1 = 'PIAZZA SAN VITO 84020 SAN GREGORIO MAGNO ', 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 = '4380.00', price_tax_excluded = '3590.16', date_upd = NOW() WHERE id_document = '100593' 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 05:14:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '100593' 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , 'Spesa relativa ai lavori di fornitura di arredi sacri.' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , 'Progetto PNNR (M1.C3-INVESTIMENTO 2.2) finanziato dall\'Unione Europea- nextGenerationEu' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , '\"Restauro e consolidamento struttura della chiesa della Madonna della Salute\" ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , ' ID: PNRR-M1 C3-2.2-2022-007500 CUP B97B22001270004' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '0' , 'documento contabile rendicontato per un importo di ' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24439' , 'ALTARE IN LEGNO - 358' , '1' , '-1' , '1' , '1480.0000' , '1213.1147540984' , '22' , '0' , '1480.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24440' , 'LEGGIO LEGNO - 333/L ' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24441' , 'LEGGIO A STELO - 196' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24442' , 'CROCIFISSO LEGNO CORPO CM 80 - 180' , '1' , '-1' , '1' , '870.0000' , '713.11475409836' , '22' , '0' , '870.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24443' , 'BASE PER CROCE IN LEGNO 60X40 - 1890' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24444' , 'POLTRONA IN VELLUTO - 7101' , '1' , '-1' , '1' , '760.0000' , '622.95081967213' , '22' , '0' , '760.00' ) 22/12/2025 05:14:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100593' , '24445' , 'SGABELLO IN NOCE - 7102' , '2' , '-2' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '540.00' ) 22/12/2025 05:17:30 pm >> UPDATE ps_address SET id_state = '129', lastname = 'LABORATORIO GRUPPO LITURGICO', address1 = 'VIA GARDINI 2', address2 = '', postcode = '14015', dni = '', vat_number = '01384370050', city = 'SAN DAMINO D\'ASTI', phone = '0141975139', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '222' 22/12/2025 05:17:30 pm >> UPDATE ps_supplier SET email = 'info@gruppoliturgico.com', name = 'LABORATORIO GRUPPO LITURGICO', date_upd = NOW() WHERE id_supplier = '222' 22/12/2025 05:17:30 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '222' 22/12/2025 05:17:51 pm >> UPDATE ps_address SET id_state = '129', lastname = 'LABORATORIO GRUPPO LITURGICO srl', address1 = 'VIA GARDINI 2', address2 = '', postcode = '14015', dni = '', vat_number = '01384370050', city = 'SAN DAMINO D\'ASTI', phone = '0141975139', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '222' 22/12/2025 05:17:51 pm >> UPDATE ps_supplier SET email = 'info@gruppoliturgico.com', name = 'LABORATORIO GRUPPO LITURGICO srl', date_upd = NOW() WHERE id_supplier = '222' 22/12/2025 05:17:51 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '222' 22/12/2025 05:27:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '403/25' , '2025-12-22' , '25' , '0' , '222' , '4679679' , 'VIA GARDINI 2 14015 SAN DAMINO D\\\'ASTI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '3006.08' , '2464.00' , NOW() , NOW() ) 22/12/2025 05:27: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 = '100647' 22/12/2025 05:27:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '100647' 22/12/2025 05:27: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 ( '100647' , '24441' , 'LEGGIO A STELO - 196' , '1' , '1' , '1' , '250' , '204.91803278689' , '22' , '20' , '244.0000' ) 22/12/2025 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24441' AND id_supplier = '222' 22/12/2025 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24441' , '222' , '1' ) 22/12/2025 05:27: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 ( '100647' , '24440' , 'LEGGIO LEGNO - 333/L ' , '1' , '1' , '1' , '200' , '163.93442622951' , '22' , '20' , '195.2000' ) 22/12/2025 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24440' AND id_supplier = '222' 22/12/2025 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24440' , '222' , '1' ) 22/12/2025 05:27: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 ( '100647' , '24439' , 'ALTARE IN LEGNO - 358' , '1' , '1' , '1' , '1480' , '1213.1147540984' , '22' , '20' , '1444.4800' ) 22/12/2025 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24439' AND id_supplier = '222' 22/12/2025 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24439' , '222' , '1' ) 22/12/2025 05:27: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 ( '100647' , '24442' , 'CROCIFISSO LEGNO CORPO CM 80 - 180' , '1' , '1' , '1' , '870' , '713.11475409836' , '22' , '20' , '849.1200' ) 22/12/2025 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24442' AND id_supplier = '222' 22/12/2025 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24442' , '222' , '1' ) 22/12/2025 05:27: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 ( '100647' , '24443' , 'BASE PER CROCE IN LEGNO 60X40 - 1890' , '1' , '1' , '1' , '280' , '229.50819672131' , '22' , '20' , '273.2800' ) 22/12/2025 05:27:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24443' AND id_supplier = '222' 22/12/2025 05:27:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24443' , '222' , '1' ) 22/12/2025 05:31:25 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '403/25', document_date = '2025-12-22', document_letter = '25', id_customer = '0', id_supplier = '', id_address = '4679679', address1 = 'VIA GARDINI 2 14015 SAN DAMINO D\\\'ASTI', address2 = '', note = '', price_shipping = '0.03', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '2464.00', price_tax_excluded = '2019.68', date_upd = NOW() WHERE id_document = '100647' 22/12/2025 05:31:25 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 = '100647' 22/12/2025 05:31:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '100647' 22/12/2025 05:31:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100647' , '24441' , 'LEGGIO A STELO - 196' , '1' , '1' , '1' , '204.91' , '167.95901639344' , '22' , '20' , '199.9922' ) 22/12/2025 05:31:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100647' , '24440' , 'LEGGIO LEGNO - 333/L ' , '1' , '1' , '1' , '163.93' , '134.36885245902' , '22' , '20' , '159.9957' ) 22/12/2025 05:31:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100647' , '24439' , 'ALTARE IN LEGNO - 358' , '1' , '1' , '1' , '1213.11' , '994.35245901639' , '22' , '20' , '1183.9954' ) 22/12/2025 05:31:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100647' , '24442' , 'CROCIFISSO LEGNO CORPO CM 80 - 180' , '1' , '1' , '1' , '713.11' , '584.51639344262' , '22' , '20' , '695.9954' ) 22/12/2025 05:31:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100647' , '24443' , 'BASE PER CROCE IN LEGNO 60X40 - 1890' , '1' , '1' , '1' , '229.50' , '188.11475409836' , '22' , '20' , '223.9920' ) 22/12/2025 05:38:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4369' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 05:38:38 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' , '4369' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 22/12/2025 05:38: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 = '100648' 22/12/2025 05:38:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100648' 22/12/2025 05:38: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 ( '100648' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 22/12/2025 05:45:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4370' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 05:45:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4370' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.20' , '47.17' , NOW() , NOW() ) 22/12/2025 05:45:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100649' 22/12/2025 05:45:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100649' 22/12/2025 05:45:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100649' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '6' , '-6' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '39.00' ) 22/12/2025 05:45:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100649' , '24305' , 'DE CURA OBSESSIS - P. CARLIN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 22/12/2025 06:18:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 06:18: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' , '4371' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 22/12/2025 06:18: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 = '100650' 22/12/2025 06:18:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '100650' 22/12/2025 06:18: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 ( '100650' , '20966' , 'CROCE METALLO BLU - CL273BLU' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 22/12/2025 06:58:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 06:58: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' , '4372' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/12/2025 06:58: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 = '100651' 22/12/2025 06:58:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100651' 22/12/2025 06:58: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 ( '100651' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/12/2025 07:13:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '4373' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 07:13:56 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' , '4373' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 22/12/2025 07:13: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 = '100652' 22/12/2025 07:13:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '100652' 22/12/2025 07:13: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 ( '100652' , '15047' , 'ICONA DIPINTA A MANO 32X44' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 22/12/2025 07:15:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4374' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 07:15:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4374' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 22/12/2025 07:15:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100653' 22/12/2025 07:15:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100653' 22/12/2025 07:15: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 ( '100653' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 22/12/2025 07:25:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '4269' AND id_document != '100527' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-16') 22/12/2025 07:25:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4269', document_date = '2025-12-16', 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 = '68.80', price_tax_excluded = '57.30', date_upd = NOW() WHERE id_document = '100527' 22/12/2025 07:25: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 = '100527' 22/12/2025 07:25:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '100527' 22/12/2025 07:25: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 ( '100527' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '2' , '-2' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '23.00' ) 22/12/2025 07:25: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 ( '100527' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '2.80' ) 22/12/2025 07:25: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 ( '100527' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '13.00' ) 22/12/2025 07:25: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 ( '100527' , '22681' , 'OGNI GIORNO PREGHIAMO' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 22/12/2025 07:25: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 ( '100527' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14 - ria' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 22/12/2025 07:47:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 22/12/2025 07:47: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' , '4375' , '2025-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.50' , '46.31' , NOW() , NOW() ) 22/12/2025 07:47: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 = '100654' 22/12/2025 07:47:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '100654' 22/12/2025 07:47: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 ( '100654' , '7202' , 'ARTICOLI RELIGIOSI' , '8' , '-8' , '1' , '5' , '4.0983606557377' , '22' , '0' , '40.00' ) 22/12/2025 07:47: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 ( '100654' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 22/12/2025 07:47: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 ( '100654' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '5' , '-5' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '12.50' )