29/12/2025 09:27:43 am >> SELECT document_num FROM ps_document WHERE document_num = '4415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 09:27:44 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' , '4415' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 29/12/2025 09:27:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100698' 29/12/2025 09:27:44 am >> DELETE FROM ps_document_detail WHERE id_document = '100698' 29/12/2025 09:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 29/12/2025 09:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/12/2025 09:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25.6' , '20.983606557377' , '22' , '0' , '25.60' ) 29/12/2025 09:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100698' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '4.40' ) 29/12/2025 09:33:12 am >> SELECT document_num FROM ps_document WHERE document_num = '4416' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 09:33:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4416' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 29/12/2025 09:33:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100699' 29/12/2025 09:33:12 am >> DELETE FROM ps_document_detail WHERE id_document = '100699' 29/12/2025 09:33:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100699' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 29/12/2025 10:21:33 am >> SELECT document_num FROM ps_document WHERE document_num = '4417' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 10:21:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4417' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/12/2025 10:21: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 = '100700' 29/12/2025 10:21:33 am >> DELETE FROM ps_document_detail WHERE id_document = '100700' 29/12/2025 10:21: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 ( '100700' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2025 10:22:07 am >> SELECT document_num FROM ps_document WHERE document_num = '4418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 10:22:07 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' , '4418' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.00' , '65.33' , NOW() , NOW() ) 29/12/2025 10:22: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 = '100701' 29/12/2025 10:22:07 am >> DELETE FROM ps_document_detail WHERE id_document = '100701' 29/12/2025 10:22: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 ( '100701' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 29/12/2025 10:22: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 ( '100701' , '24112' , 'NATIVITA CM 13 - ST292-NTS' , '1' , '-1' , '1' , '12.94' , '10.606557377049' , '22' , '0' , '12.94' ) 29/12/2025 10:22: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 ( '100701' , '20157' , 'ALBERO DI NATALE - MIX' , '10' , '-10' , '1' , '2' , '1.6393442622951' , '22' , '0' , '20.00' ) 29/12/2025 10:22: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 ( '100701' , '23096' , 'QUADRETTO EFFETTO CERAMICA - P734/F38' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 29/12/2025 10:22: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 ( '100701' , '24284' , 'CUORE NATIVITA CM 16 - PB17823' , '3' , '-3' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '13.50' ) 29/12/2025 10:22: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 ( '100701' , '24427' , 'SACRA FAMIGLIA CM 6 - P696' , '2' , '-2' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '5.80' ) 29/12/2025 10:22: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 ( '100701' , '24304' , 'GIORNI DELLE STELLE - B. FERRERO' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 29/12/2025 10:27:24 am >> SELECT document_num FROM ps_document WHERE document_num = '4419' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 10:27: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' , '4419' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.85' , '33.24' , NOW() , NOW() ) 29/12/2025 10:27: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 = '100702' 29/12/2025 10:27:24 am >> DELETE FROM ps_document_detail WHERE id_document = '100702' 29/12/2025 10:27: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 ( '100702' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 29/12/2025 10:27: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 ( '100702' , '16598' , 'DEVOZIONE A GESU BAMBINO - 8943' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2025 10:27: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 ( '100702' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 29/12/2025 10:27: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 ( '100702' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 29/12/2025 10:27: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 ( '100702' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 29/12/2025 10:27: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 ( '100702' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 29/12/2025 10:27: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 ( '100702' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/12/2025 10:46:21 am >> SELECT document_num FROM ps_document WHERE document_num = '63/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 10:46: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 ( '23' , '63/E' , '2025-12-29' , 'E' , '2938' , '0' , '4679642' , 'VIA ARCIVESCOVATO 31 55100 LUCCA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 29/12/2025 10:46: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 = '100703' 29/12/2025 10:46:21 am >> DELETE FROM ps_document_detail WHERE id_document = '100703' 29/12/2025 10:46: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 ( '100703' , '24435' , 'SEGNO DELLA CROCE SPIEGATO AI BAMBINI' , '50' , '-50' , '4' , '1.80' , '1.8' , '0' , '40' , '54.00' ) 29/12/2025 10:57:08 am >> SELECT document_num FROM ps_document WHERE document_num = '4312' AND id_document != '100575' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-18') 29/12/2025 10:57:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4312', 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 = '6.00', price_tax_excluded = '5.78', date_upd = NOW() WHERE id_document = '100575' 29/12/2025 10:57:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100575' 29/12/2025 10:57:09 am >> DELETE FROM ps_document_detail WHERE id_document = '100575' 29/12/2025 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100575' , '20758' , 'SEGNALIBRO 5X15' , '6' , '-6' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '1.20' ) 29/12/2025 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100575' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' ) 29/12/2025 10:57:22 am >> SELECT document_num FROM ps_document WHERE document_num = '4387' AND id_document != '100667' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 29/12/2025 10:57:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4387', document_date = '2025-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.00', price_tax_excluded = '5.00', date_upd = NOW() WHERE id_document = '100667' 29/12/2025 10:57:22 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 = '100667' 29/12/2025 10:57:22 am >> DELETE FROM ps_document_detail WHERE id_document = '100667' 29/12/2025 10:57:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100667' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 29/12/2025 10:57:42 am >> SELECT document_num FROM ps_document WHERE document_num = '4166' AND id_document != '100396' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-11') 29/12/2025 10:57:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4166', 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 = '30.20', price_tax_excluded = '30.20', date_upd = NOW() WHERE id_document = '100396' 29/12/2025 10:57: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 = '100396' 29/12/2025 10:57:42 am >> DELETE FROM ps_document_detail WHERE id_document = '100396' 29/12/2025 10:57: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 ( '100396' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '30' , '-30' , '4' , '0.7000' , '0.7' , '0' , '0' , '21.00' ) 29/12/2025 10:57: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 ( '100396' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '2' , '-2' , '4' , '4.60' , '4.6' , '0' , '0' , '9.20' ) 29/12/2025 10:59:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4420' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 10:59: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' , '4420' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.75' , '13.40' , NOW() , NOW() ) 29/12/2025 10:59: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 = '100704' 29/12/2025 10:59:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100704' 29/12/2025 10:59: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 ( '100704' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2025 10:59: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 ( '100704' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 29/12/2025 10:59: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 ( '100704' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/12/2025 11:02:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4421' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 11:02:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4421' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/12/2025 11:02:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100705' 29/12/2025 11:02:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100705' 29/12/2025 11:02:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100705' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2025 11:36:17 am >> SELECT document_num FROM ps_document WHERE document_num = '283' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 11:36: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 ( '21' , '283' , '2025-12-29' , '' , '161' , '0' , '4679379' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '126.35' , '126.35' , NOW() , NOW() ) 29/12/2025 11:36: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 = '100706' 29/12/2025 11:36:17 am >> DELETE FROM ps_document_detail WHERE id_document = '100706' 29/12/2025 11:36: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 ( '100706' , '21835' , 'DIDACHE ' , '10' , '-10' , '4' , '8.50' , '8.5' , '0' , '5' , '80.75' ) 29/12/2025 11:36: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 ( '100706' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '4' , '-4' , '4' , '12.00' , '12' , '0' , '5' , '45.60' ) 29/12/2025 11:37:21 am >> SELECT document_num FROM ps_document WHERE document_num = '4422' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 11:37: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 ( '11' , '4422' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1600.00' , '1311.48' , NOW() , NOW() ) 29/12/2025 11:37: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 = '100707' 29/12/2025 11:37:21 am >> DELETE FROM ps_document_detail WHERE id_document = '100707' 29/12/2025 11:37: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 ( '100707' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1600' , '1311.4754098361' , '22' , '0' , '1600.00' ) 29/12/2025 11:37:36 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/12/2025 11:37:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24462' , '1' , '' , 'nuovo-prodotto' ) 29/12/2025 11:37:36 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24462' , '1' , '1' , '2' , NOW() , NOW() ) 29/12/2025 11:37:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24462' , '0' , '1' , '0' , '0' ) 29/12/2025 11:38:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839913227' AND id_product != '24462' AND ean13 != '' 29/12/2025 11:38:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839913227', date_upd = NOW() WHERE id_product = '24462' 29/12/2025 11:38:25 am >> UPDATE ps_product_lang SET name = 'guaritore ferito - h. nouwen', description = '' WHERE id_product = '24462' 29/12/2025 11:38:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '24462' 29/12/2025 11:38:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24462' 29/12/2025 11:38:25 am >> DELETE FROM ps_specific_price WHERE id_product = '24462' 29/12/2025 11:38:30 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 = '24462' 29/12/2025 11:38:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24463' , '1' , '' , 'nuovo-prodotto' ) 29/12/2025 11:38:30 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 '24463' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24462' 29/12/2025 11:38:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24463' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24462' 29/12/2025 11:38:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826610283' AND id_product != '24463' AND ean13 != '' 29/12/2025 11:38:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826610283', date_upd = NOW() WHERE id_product = '24463' 29/12/2025 11:38:53 am >> UPDATE ps_product_lang SET name = 'pace sia con tutti voi', description = '' WHERE id_product = '24463' 29/12/2025 11:38:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '24463' 29/12/2025 11:38:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24463' 29/12/2025 11:38:53 am >> DELETE FROM ps_specific_price WHERE id_product = '24463' 29/12/2025 11:43:11 am >> SELECT document_num FROM ps_document WHERE document_num = '4423' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 11:43: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 ( '11' , '4423' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 29/12/2025 11:43: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 = '100708' 29/12/2025 11:43:11 am >> DELETE FROM ps_document_detail WHERE id_document = '100708' 29/12/2025 11:43: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 ( '100708' , '21788' , 'MADONNA DEL CARMINE CM 22 - 345' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 29/12/2025 11:48:25 am >> SELECT document_num FROM ps_document WHERE document_num = '4424' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 11:48:25 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' , '4424' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.50' , '94.73' , NOW() , NOW() ) 29/12/2025 11:48:25 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 = '100709' 29/12/2025 11:48:25 am >> DELETE FROM ps_document_detail WHERE id_document = '100709' 29/12/2025 11:48: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 ( '100709' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '20' , '-20' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '32.00' ) 29/12/2025 11:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100709' , '24463' , 'pace sia con tutti voi' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/12/2025 11:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100709' , '24462' , 'guaritore ferito - h. nouwen' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '5' , '22.80' ) 29/12/2025 11:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100709' , '24453' , 'PRATICHE PASTORALI, ESPERIENZE' , '1' , '-1' , '4' , '46.00' , '46' , '0' , '5' , '43.70' ) 29/12/2025 11:58:34 am >> SELECT document_num FROM ps_document WHERE document_num = '4425' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 11:58:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4425' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.60' , '4.27' , NOW() , NOW() ) 29/12/2025 11:58: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 = '100710' 29/12/2025 11:58:34 am >> DELETE FROM ps_document_detail WHERE id_document = '100710' 29/12/2025 11:58: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 ( '100710' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 29/12/2025 11:58: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 ( '100710' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 29/12/2025 12:25:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4426' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 12:25:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4426' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.40' , '38.03' , NOW() , NOW() ) 29/12/2025 12:25: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 = '100711' 29/12/2025 12:25:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '100711' 29/12/2025 12:25: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 ( '100711' , '5655' , 'LEGGIO IN PLEXIGLASS - 40986' , '1' , '-1' , '1' , '41.9' , '34.344262295082' , '22' , '0' , '41.90' ) 29/12/2025 12:25: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 ( '100711' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 29/12/2025 12:27:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826610283' AND id_product != '24463' AND ean13 != '' 29/12/2025 12:27:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826610283', date_upd = NOW() WHERE id_product = '24463' 29/12/2025 12:27:50 pm >> UPDATE ps_product_lang SET name = 'PACE SIA CON TUTTI VOI', description = '' WHERE id_product = '24463' 29/12/2025 12:27:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0000' WHERE id_product = '24463' 29/12/2025 12:27:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24463' 29/12/2025 12:27:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '24463' 29/12/2025 12:36:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4427' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 12:36: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' , '4427' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 29/12/2025 12:36: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 = '100712' 29/12/2025 12:36:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '100712' 29/12/2025 12:36: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 ( '100712' , '12582' , 'VETRO ANTIVENTO PER F. CANDELA DIAM 3,2 - 73/32' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 29/12/2025 12:39: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 ( '33' , '720580' , '2025-12-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '6.11' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '195.85' , '195.85' , NOW() , NOW() ) 29/12/2025 12:39: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 = '100713' 29/12/2025 12:39:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '100713' 29/12/2025 12:39: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 ( '100713' , '24462' , 'guaritore ferito - h. nouwen' , '2' , '2' , '4' , '12.00' , '12' , '0' , '30' , '16.8000' ) 29/12/2025 12:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24462' AND id_supplier = '7' 29/12/2025 12:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24462' , '7' , '1' ) 29/12/2025 12:39: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 ( '100713' , '7967' , 'PIACERE DIO! 1 GUIDA - PEIRETTI/FERRERO' , '4' , '4' , '4' , '15.00' , '15' , '0' , '35+7' , '36.2700' ) 29/12/2025 12:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7967' AND id_supplier = '7' 29/12/2025 12:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7967' , '7' , '1' ) 29/12/2025 12:39: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 ( '100713' , '7968' , 'PIACERE DIO! 1 QUADERNO - A. PEIRETTI' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35+7' , '36.2700' ) 29/12/2025 12:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7968' AND id_supplier = '7' 29/12/2025 12:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7968' , '7' , '1' ) 29/12/2025 12:39: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 ( '100713' , '7969' , 'PIACERE DIO! 2 GUIDA - FERRERO/PAIRETTI' , '3' , '3' , '4' , '16.00' , '16' , '0' , '35+7' , '29.0160' ) 29/12/2025 12:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7969' AND id_supplier = '7' 29/12/2025 12:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7969' , '7' , '1' ) 29/12/2025 12:39: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 ( '100713' , '7970' , 'PIACERE DIO! 2 QUADERNO - A. PAIRETTI' , '15' , '15' , '4' , '5.00' , '5' , '0' , '35+7' , '45.3375' ) 29/12/2025 12:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7970' AND id_supplier = '7' 29/12/2025 12:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7970' , '7' , '1' ) 29/12/2025 12:39: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 ( '100713' , '24107' , 'IO E IL MIO AMICO GESU - GUIDA - B. FERRERO' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30+7' , '6.4449' ) 29/12/2025 12:39:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24107' AND id_supplier = '7' 29/12/2025 12:39:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24107' , '7' , '1' ) 29/12/2025 12:39:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100713' , '23339' , 'PASTORES DABO VOBIS' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '33+7' , '2.8039' ) 29/12/2025 12:39:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23339' AND id_supplier = '7' 29/12/2025 12:39:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23339' , '7' , '1' ) 29/12/2025 12:39:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100713' , '24463' , 'PACE SIA CON TUTTI VOI' , '12' , '12' , '4' , '2.00' , '2' , '0' , '30' , '16.8000' ) 29/12/2025 12:39:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24463' AND id_supplier = '7' 29/12/2025 12:39:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24463' , '7' , '1' ) 29/12/2025 12:39:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100713' , '24463' , 'PACE SIA CON TUTTI VOI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 29/12/2025 12:39:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24463' AND id_supplier = '7' 29/12/2025 12:39:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24463' , '7' , '1' ) 29/12/2025 12:43:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '4428' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 12:43:36 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' , '4428' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.53' , '18.53' , NOW() , NOW() ) 29/12/2025 12:43: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 = '100714' 29/12/2025 12:43:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '100714' 29/12/2025 12:43: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 ( '100714' , '24079' , 'FRANCESCO IL PRIMO ITALIANO - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 29/12/2025 12:50:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '4116' AND id_document != '100337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 29/12/2025 12:50:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4116', document_date = '2025-12-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '35.49', date_upd = NOW() WHERE id_document = '100337' 29/12/2025 12:50:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100337' 29/12/2025 12:50:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '100337' 29/12/2025 12:50: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 ( '100337' , '23188' , 'GRUPPO NATIVITA CAMPANA CON LUCI - PB20515' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 29/12/2025 12:50: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 ( '100337' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 29/12/2025 12:50: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 ( '100337' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.59' , '2.59' , '0' , '0' , '2.59' ) 29/12/2025 12:50: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 ( '100337' , '24107' , 'IO E IL MIO AMICO GESU - GUIDA - B. FERRERO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 29/12/2025 02:14:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3490' AND id_document != '99446' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 29/12/2025 02:14:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3490', document_date = '2025-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.90', price_tax_excluded = '37.82', date_upd = NOW() WHERE id_document = '99446' 29/12/2025 02:14:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99446' 29/12/2025 02:14:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99446' 29/12/2025 02:14: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 ( '99446' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 29/12/2025 02:14: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 ( '99446' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 29/12/2025 02:14: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 ( '99446' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 29/12/2025 02:14: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 ( '99446' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 29/12/2025 02:14: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 ( '99446' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 29/12/2025 02:14: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 ( '99446' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.38' , '6.38' , '0' , '0' , '6.38' ) 29/12/2025 02:14:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3867' AND id_document != '100013' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20') 29/12/2025 02:14:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3867', document_date = '2025-11-20', 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 = '156.16', price_tax_excluded = '149.85', date_upd = NOW() WHERE id_document = '100013' 29/12/2025 02:14: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 = '100013' 29/12/2025 02:14:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100013' 29/12/2025 02:14: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 ( '100013' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 29/12/2025 02:14: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 ( '100013' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 29/12/2025 02:14: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 ( '100013' , '4120' , 'FEDE NELLO ZAINETTO' , '6' , '-6' , '4' , '5' , '5' , '0' , '0' , '30.00' ) 29/12/2025 02:14: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 ( '100013' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 29/12/2025 02:14: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 ( '100013' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '5' , '26.60' ) 29/12/2025 02:14: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 ( '100013' , '8275' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 2 - TEMPO ORDINARIO' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '5' , '36.10' ) 29/12/2025 02:14: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 ( '100013' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 29/12/2025 02:15:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3905' AND id_document != '100064' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 29/12/2025 02:15:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3905', document_date = '2025-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.00', price_tax_excluded = '33.00', date_upd = NOW() WHERE id_document = '100064' 29/12/2025 02:15:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100064' 29/12/2025 02:15:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '100064' 29/12/2025 02:15:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100064' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 29/12/2025 02:15:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100064' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '0' , '30.00' ) 29/12/2025 02:16:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '4065' AND id_document != '100276' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-04') 29/12/2025 02:16:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4065', 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 = '24.00', price_tax_excluded = '24.00', date_upd = NOW() WHERE id_document = '100276' 29/12/2025 02:16:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100276' 29/12/2025 02:16:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '100276' 29/12/2025 02:16:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100276' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 29/12/2025 02:16:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100276' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 29/12/2025 02:17:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3597' AND id_document != '99591' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 29/12/2025 02:17:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3597', document_date = '2025-10-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '60.00', date_upd = NOW() WHERE id_document = '99591' 29/12/2025 02:17:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99591' 29/12/2025 02:17:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '99591' 29/12/2025 02:17:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99591' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 29/12/2025 02:17:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99591' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 29/12/2025 03:15:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4429' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 03:15:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4429' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.20' , '6.72' , NOW() , NOW() ) 29/12/2025 03:15: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 = '100715' 29/12/2025 03:15:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100715' 29/12/2025 03:15: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 ( '100715' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 29/12/2025 03:15: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 ( '100715' , '21102' , 'BRACCIALE DECINA LEGNO CORDA - BC568' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 29/12/2025 03:24:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4430' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 03:24:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4430' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 29/12/2025 03:24: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 = '100716' 29/12/2025 03:24:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '100716' 29/12/2025 03:24: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 ( '100716' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '3.00' ) 29/12/2025 03:59:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '64/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 03:59: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 ( '22' , '64/E' , '2025-12-29' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '2677.10' , '2675.21' , NOW() , NOW() ) 29/12/2025 03:59: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 = '100717' 29/12/2025 03:59:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100717' 29/12/2025 03:59: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 ( '100717' , '4120' , 'FEDE NELLO ZAINETTO' , '8' , '0' , '4' , '6.00' , '6' , '0' , '50' , '24.00' ) 29/12/2025 03:59: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 ( '100717' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '3' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 03:59: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 ( '100717' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '41' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '30.75' ) 29/12/2025 03:59: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 ( '100717' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 03:59: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 ( '100717' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '31' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '38.75' ) 29/12/2025 03:59: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 ( '100717' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 03:59: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 ( '100717' , '18357' , 'MIE PREGHIERINE N.E.' , '41' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '30.75' ) 29/12/2025 03:59: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 ( '100717' , '14330' , '100 GIORNI CON LO SPIRITO' , '3' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '11.25' ) 29/12/2025 03:59: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 ( '100717' , '15739' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 29/12/2025 03:59: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 ( '100717' , '15318' , 'PERDONAMI SIGNORE ' , '25' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 29/12/2025 03:59: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 ( '100717' , '15602' , 'AMICO GESU ALBUM' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 29/12/2025 03:59: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 ( '100717' , '24147' , 'AMICO GESU - SCATOLA 60 PZ' , '2' , '0' , '4' , '30.00' , '30' , '0' , '50' , '30.00' ) 29/12/2025 03:59: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 ( '100717' , '9815' , 'SEGNO DELLA CROCE' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 29/12/2025 03:59: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 ( '100717' , '15317' , 'LA COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 03:59: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 ( '100717' , '15743' , 'PREGHIERA DEL ROSARIO' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 03:59: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 ( '100717' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 29/12/2025 03:59: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 ( '100717' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 03:59: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 ( '100717' , '13462' , 'SE MI AMI NON PIANGERE' , '6' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 29/12/2025 03:59: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 ( '100717' , '13840' , 'NONNI SONO UN TESORO' , '13' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '11.70' ) 29/12/2025 03:59: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 ( '100717' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 29/12/2025 03:59: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 ( '100717' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '15' , '0' , '4' , '4.00' , '4' , '0' , '50' , '30.00' ) 29/12/2025 03:59: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 ( '100717' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 03:59: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 ( '100717' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '51' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '63.75' ) 29/12/2025 03:59: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 ( '100717' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '0' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 29/12/2025 03:59: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 ( '100717' , '21701' , 'NASCITA DI GESU' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 03:59: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 ( '100717' , '21700' , 'E NATO - N.E.' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 29/12/2025 03:59: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 ( '100717' , '23934' , 'ANGELO DI DIO - N.E.' , '3' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 03:59: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 ( '100717' , '21650' , 'AVVENTO' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 03:59: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 ( '100717' , '17034' , 'SACRAMENTO DEL PERDONO' , '36' , '0' , '4' , '2.00' , '2' , '0' , '50' , '36.00' ) 29/12/2025 03:59: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 ( '100717' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '88' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '105.60' ) 29/12/2025 03:59: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 ( '100717' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '13' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 29/12/2025 03:59: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 ( '100717' , '9675' , 'SARETE MIEI TESTIMONI' , '91' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '159.25' ) 29/12/2025 03:59: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 ( '100717' , '5457' , 'IO SONO CON VOI 1 PARTE' , '235' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '329.00' ) 29/12/2025 03:59: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 ( '100717' , '5458' , 'IO SONO CON VOI 2 PARTE' , '118' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '165.20' ) 29/12/2025 03:59: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 ( '100717' , '11191' , 'VENITE CON ME 1 PARTE' , '98' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '137.20' ) 29/12/2025 03:59: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 ( '100717' , '11192' , 'VENITE CON ME 2 PARTE' , '101' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '141.40' ) 29/12/2025 03:59: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 ( '100717' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '239' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '418.25' ) 29/12/2025 03:59: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 ( '100717' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 29/12/2025 03:59: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 ( '100717' , '1872' , 'CELEBRARE LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 29/12/2025 03:59: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 ( '100717' , '6629' , 'MIA PREGHIERA' , '1' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '0.45' ) 29/12/2025 03:59: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 ( '100717' , '8408' , 'PRENDETE E MANGIATE' , '99' , '0' , '4' , '3.00' , '3' , '0' , '50' , '148.50' ) 29/12/2025 03:59: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 ( '100717' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 29/12/2025 03:59: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 ( '100717' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '5' , '0' , '4' , '5.00' , '5' , '0' , '50' , '12.50' ) 29/12/2025 03:59: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 ( '100717' , '4154' , 'FESTA DEL PERDONO' , '113' , '0' , '4' , '3.00' , '3' , '0' , '50' , '169.50' ) 29/12/2025 03:59: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 ( '100717' , '2679' , 'CONOSCERE GESU' , '76' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '133.00' ) 29/12/2025 03:59: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 ( '100717' , '2680' , 'CONOSCERE GESU - GUIDA' , '3' , '0' , '4' , '6.00' , '6' , '0' , '50' , '9.00' ) 29/12/2025 03:59: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 ( '100717' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '5' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '21.25' ) 29/12/2025 03:59: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 ( '100717' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '0' , '4' , '14.00' , '14' , '0' , '50' , '7.00' ) 29/12/2025 03:59: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 ( '100717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 03:59: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 ( '100717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 03:59: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 ( '100717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 03:59: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 ( '100717' , '12819' , 'REGISTRO DEL CATECHISTA ' , '21' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '10.50' ) 29/12/2025 03:59: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 ( '100717' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '4' , '0' , '4' , '6.00' , '6' , '0' , '50' , '12.00' ) 29/12/2025 03:59: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 ( '100717' , '13397' , 'MIO GESU' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 29/12/2025 03:59: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 ( '100717' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '3' , '0' , '4' , '9.00' , '9' , '0' , '50' , '13.50' ) 29/12/2025 03:59: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 ( '100717' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '6' , '0' , '4' , '1.00' , '1' , '0' , '50' , '3.00' ) 29/12/2025 03:59: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 ( '100717' , '15019' , 'PREGHIAMO CON MARIA' , '5' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '2.00' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15020' , 'PREGARE OGNI GIORNO' , '10' , '0' , '4' , '1.00' , '1' , '0' , '50' , '5.00' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17257' , 'IO TI BATTEZZO ' , '15' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '13.50' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '14' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '13.30' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.00' , '7' , '0' , '50' , '14.00' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '3' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '6.75' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.00' , '35' , '0' , '50' , '17.50' ) 29/12/2025 03:59:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 04:03:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4431' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 04:03: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' , '4431' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 29/12/2025 04:03: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 = '100718' 29/12/2025 04:03:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100718' 29/12/2025 04:03: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 ( '100718' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '18' , '-18' , '4' , '5.00' , '5' , '0' , '0' , '90.00' ) 29/12/2025 04:04:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '4431' AND id_document != '100718' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 04:04:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4431', document_date = '2025-12-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '25.00', price_tax_excluded = '25.00', date_upd = NOW() WHERE id_document = '100718' 29/12/2025 04:04: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 = '100718' 29/12/2025 04:04:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100718' 29/12/2025 04:04: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 ( '100718' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '5' , '-5' , '4' , '5.0000' , '5' , '0' , '0' , '25.00' ) 29/12/2025 04:04:10 pm >> DELETE FROM ps_document WHERE id_document = '100718' 29/12/2025 04:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '100718' 29/12/2025 04:05:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4431' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 04:05: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' , '4431' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.10' , '90.87' , NOW() , NOW() ) 29/12/2025 04:05: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 = '100719' 29/12/2025 04:05:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100719' 29/12/2025 04:05: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 ( '100719' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 29/12/2025 04:05: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 ( '100719' , '24232' , 'MESSA MEDITAZIONE - GEN/FEB 26' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 29/12/2025 04:05: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 ( '100719' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/12/2025 04:30:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '64/E' AND id_document != '100717' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 04:30:39 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '64/E', document_date = '2025-12-29', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '2678.00', price_tax_excluded = '2676.11', date_upd = NOW() WHERE id_document = '100717' 29/12/2025 04:30: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 = '100717' 29/12/2025 04:30:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100717' 29/12/2025 04:30: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 ( '100717' , '4120' , 'FEDE NELLO ZAINETTO' , '8' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '24.00' ) 29/12/2025 04:30: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 ( '100717' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 04:30: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 ( '100717' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '41' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '30.75' ) 29/12/2025 04:30: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 ( '100717' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 04:30: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 ( '100717' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '31' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '38.75' ) 29/12/2025 04:30: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 ( '100717' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 04:30: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 ( '100717' , '18357' , 'MIE PREGHIERINE N.E.' , '41' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '30.75' ) 29/12/2025 04:30: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 ( '100717' , '14330' , '100 GIORNI CON LO SPIRITO' , '3' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '11.25' ) 29/12/2025 04:30: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 ( '100717' , '15739' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 29/12/2025 04:30: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 ( '100717' , '15318' , 'PERDONAMI SIGNORE ' , '25' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '31.25' ) 29/12/2025 04:30: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 ( '100717' , '15602' , 'AMICO GESU ALBUM' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 29/12/2025 04:30: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 ( '100717' , '24147' , 'AMICO GESU - SCATOLA 60 PZ' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '50' , '30.00' ) 29/12/2025 04:30: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 ( '100717' , '9815' , 'SEGNO DELLA CROCE' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 29/12/2025 04:30: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 ( '100717' , '15317' , 'LA COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 04:30: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 ( '100717' , '15743' , 'PREGHIERA DEL ROSARIO' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 04:30: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 ( '100717' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 29/12/2025 04:30: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 ( '100717' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 04:30: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 ( '100717' , '13462' , 'SE MI AMI NON PIANGERE' , '6' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '5.40' ) 29/12/2025 04:30: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 ( '100717' , '13840' , 'NONNI SONO UN TESORO' , '13' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '11.70' ) 29/12/2025 04:30: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 ( '100717' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 29/12/2025 04:30: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 ( '100717' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '15' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '30.00' ) 29/12/2025 04:30: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 ( '100717' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 04:30: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 ( '100717' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '51' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '63.75' ) 29/12/2025 04:30: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 ( '100717' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '10.50' ) 29/12/2025 04:30: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 ( '100717' , '21701' , 'NASCITA DI GESU' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 04:30: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 ( '100717' , '21700' , 'E NATO - N.E.' , '6' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '6.00' ) 29/12/2025 04:30: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 ( '100717' , '23934' , 'ANGELO DI DIO - N.E.' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 04:30: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 ( '100717' , '21650' , 'AVVENTO' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 04:30: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 ( '100717' , '17034' , 'SACRAMENTO DEL PERDONO' , '36' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '36.00' ) 29/12/2025 04:30: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 ( '100717' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '88' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '105.60' ) 29/12/2025 04:30: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 ( '100717' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 29/12/2025 04:30: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 ( '100717' , '9675' , 'SARETE MIEI TESTIMONI' , '91' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '159.25' ) 29/12/2025 04:30: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 ( '100717' , '5457' , 'IO SONO CON VOI 1 PARTE' , '235' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '329.00' ) 29/12/2025 04:30: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 ( '100717' , '5458' , 'IO SONO CON VOI 2 PARTE' , '118' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '165.20' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '11191' , 'VENITE CON ME 1 PARTE' , '98' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '137.20' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '11192' , 'VENITE CON ME 2 PARTE' , '101' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '141.40' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '239' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '418.25' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '1872' , 'CELEBRARE LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '6629' , 'MIA PREGHIERA' , '1' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.45' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '8408' , 'PRENDETE E MANGIATE' , '99' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '148.50' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '5' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '12.50' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '4154' , 'FESTA DEL PERDONO' , '113' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '169.50' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '2679' , 'CONOSCERE GESU' , '76' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '133.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '2680' , 'CONOSCERE GESU - GUIDA' , '3' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '9.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '5' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '21.25' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '50' , '7.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '12819' , 'REGISTRO DEL CATECHISTA ' , '21' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '10.50' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '4' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '12.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '13397' , 'MIO GESU' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '3' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '13.50' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '6' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '3.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15019' , 'PREGHIAMO CON MARIA' , '5' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '2.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15020' , 'PREGARE OGNI GIORNO' , '10' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '5.00' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 04:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17257' , 'IO TI BATTEZZO ' , '15' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '13.50' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '14' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '13.30' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '14.00' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '3' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '6.75' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '17.50' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 04:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 29/12/2025 04:39:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '64/E' AND id_document != '100717' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 04:39:03 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '64/E', document_date = '2025-12-29', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO DICEMBRE 2025', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '3845.60', price_tax_excluded = '3843.71', date_upd = NOW() WHERE id_document = '100717' 29/12/2025 04:39: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 = '100717' 29/12/2025 04:39:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100717' 29/12/2025 04:39: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 ( '100717' , '4120' , 'FEDE NELLO ZAINETTO' , '8' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '24.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '41' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '30.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '31' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '38.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '18357' , 'MIE PREGHIERINE N.E.' , '41' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '30.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '14330' , '100 GIORNI CON LO SPIRITO' , '3' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '11.25' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15739' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15318' , 'PERDONAMI SIGNORE ' , '25' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '31.25' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15602' , 'AMICO GESU ALBUM' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '24147' , 'AMICO GESU - SCATOLA 60 PZ' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '50' , '30.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '9815' , 'SEGNO DELLA CROCE' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15317' , 'LA COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15743' , 'PREGHIERA DEL ROSARIO' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '13462' , 'SE MI AMI NON PIANGERE' , '6' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '5.40' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '13840' , 'NONNI SONO UN TESORO' , '13' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '11.70' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '15' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '30.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '51' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '63.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '10.50' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '21701' , 'NASCITA DI GESU' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '21700' , 'E NATO - N.E.' , '6' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '6.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23934' , 'ANGELO DI DIO - N.E.' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '21650' , 'AVVENTO' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '17034' , 'SACRAMENTO DEL PERDONO' , '36' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '36.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '88' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '105.60' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '9675' , 'SARETE MIEI TESTIMONI' , '91' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '159.25' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '5457' , 'IO SONO CON VOI 1 PARTE' , '235' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '329.00' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '5458' , 'IO SONO CON VOI 2 PARTE' , '118' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '165.20' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '11191' , 'VENITE CON ME 1 PARTE' , '98' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '137.20' ) 29/12/2025 04:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '11192' , 'VENITE CON ME 2 PARTE' , '101' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '141.40' ) 29/12/2025 04: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 ( '100717' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '239' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '418.25' ) 29/12/2025 04: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 ( '100717' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 29/12/2025 04: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 ( '100717' , '1872' , 'CELEBRARE LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 29/12/2025 04: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 ( '100717' , '6629' , 'MIA PREGHIERA' , '1' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.45' ) 29/12/2025 04: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 ( '100717' , '8408' , 'PRENDETE E MANGIATE' , '99' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '148.50' ) 29/12/2025 04: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 ( '100717' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 29/12/2025 04: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 ( '100717' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '5' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '12.50' ) 29/12/2025 04: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 ( '100717' , '4154' , 'FESTA DEL PERDONO' , '113' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '169.50' ) 29/12/2025 04: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 ( '100717' , '2679' , 'CONOSCERE GESU' , '76' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '133.00' ) 29/12/2025 04: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 ( '100717' , '2680' , 'CONOSCERE GESU - GUIDA' , '3' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '9.00' ) 29/12/2025 04: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 ( '100717' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '5' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '21.25' ) 29/12/2025 04: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 ( '100717' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '50' , '7.00' ) 29/12/2025 04: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 ( '100717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 04: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 ( '100717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 04: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 ( '100717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '38.00' ) 29/12/2025 04: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 ( '100717' , '12819' , 'REGISTRO DEL CATECHISTA ' , '21' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '10.50' ) 29/12/2025 04: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 ( '100717' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '4' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '12.00' ) 29/12/2025 04: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 ( '100717' , '13397' , 'MIO GESU' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 29/12/2025 04: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 ( '100717' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '3' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '13.50' ) 29/12/2025 04: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 ( '100717' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '6' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '3.00' ) 29/12/2025 04: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 ( '100717' , '15019' , 'PREGHIAMO CON MARIA' , '5' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '2.00' ) 29/12/2025 04: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 ( '100717' , '15020' , 'PREGARE OGNI GIORNO' , '10' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '5.00' ) 29/12/2025 04: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 ( '100717' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 29/12/2025 04: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 ( '100717' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 04: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 ( '100717' , '17257' , 'IO TI BATTEZZO ' , '15' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '13.50' ) 29/12/2025 04: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 ( '100717' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 29/12/2025 04: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 ( '100717' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '14' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '13.30' ) 29/12/2025 04: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 ( '100717' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 29/12/2025 04: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 ( '100717' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '14.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '3' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '6.75' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '17.50' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '0.90' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20722' , 'SEMINATORI DI GIOIA' , '13' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '82' , '0' , '4' , '3.00' , '3' , '0' , '50' , '123.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '4' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '5.60' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '66' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '92.40' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '30' , '2.10' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23347' , 'PREGHIERA DEL ROSARIO' , '20' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '25.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '22809' , 'O LUCE BEATISSIMA' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '31' , '0' , '4' , '3.00' , '3' , '0' , '50' , '46.50' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '25' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '35.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '15' , '0' , '4' , '3.00' , '3' , '0' , '50' , '22.50' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '17' , '0' , '4' , '3.00' , '3' , '0' , '50' , '25.50' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23677' , 'RICETTE DI MAMMA ROSA' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '6' , '0' , '4' , '10.00' , '10' , '0' , '50' , '30.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '28' , '0' , '4' , '5.00' , '5' , '0' , '50' , '70.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '47' , '0' , '4' , '5.00' , '5' , '0' , '50' , '117.50' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23954' , 'SAN BARTOLO LONGO ' , '13' , '0' , '4' , '10.00' , '10' , '0' , '50' , '65.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '24129' , 'DIECI COMANDAMENTI - M. DE ROSA' , '14' , '0' , '4' , '6.00' , '6' , '0' , '50' , '42.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '24202' , 'GRANDI DONNE E GRANDI SANTE' , '6' , '0' , '4' , '6.00' , '6' , '0' , '50' , '18.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '24325' , 'EUCARISTIA' , '145' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '348.00' ) 29/12/2025 04:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100717' , '23721' , 'BEATITUDINI - M. DE ROSA' , '10' , '0' , '4' , '8.00' , '8' , '0' , '50' , '40.00' ) 29/12/2025 05:01:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '4432' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 05:01:42 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' , '4432' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.06' , '24.70' , NOW() , NOW() ) 29/12/2025 05:01:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100720' 29/12/2025 05:01:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100720' 29/12/2025 05:01:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100720' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 29/12/2025 05:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100720' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 29/12/2025 05:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100720' , '24351' , 'AMEN - GEN 26' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/12/2025 05:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100720' , '24352' , 'AMEN - FEB 26' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/12/2025 05:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100720' , '24398' , 'AMEN - MAR 26' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 29/12/2025 05:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100720' , '24399' , 'AMEN - APR 26' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 29/12/2025 05:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100720' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 29/12/2025 05:07:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '65/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 05:07:29 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 ( '25' , '65/E' , '2025-12-29' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '149.85' , '149.85' , NOW() , NOW() ) 29/12/2025 05:07:29 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 = '100721' 29/12/2025 05:07:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '100721' 29/12/2025 05:07:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 29/12/2025 05:07: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 ( '100721' , '11183' , 'VENITE CON ME - GUIDA' , '5' , '5' , '4' , '8.00' , '8' , '0' , '50' , '20.00' ) 29/12/2025 05:07: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 ( '100721' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 29/12/2025 05:07: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 ( '100721' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '13' , '4' , '2.80' , '2.8' , '0' , '50' , '18.20' ) 29/12/2025 05:07: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 ( '100721' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 29/12/2025 05:07: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 ( '100721' , '11191' , 'VENITE CON ME 1 PARTE' , '24' , '24' , '4' , '2.80' , '2.8' , '0' , '50' , '33.60' ) 29/12/2025 05:07: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 ( '100721' , '11192' , 'VENITE CON ME 2 PARTE' , '37' , '37' , '4' , '2.80' , '2.8' , '0' , '50' , '51.80' ) 29/12/2025 05:07: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 ( '100721' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 29/12/2025 05:07: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 ( '100721' , '3443' , 'DIECI PAROLE DAMORE' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 05:11:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4433' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 05:11: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' , '4433' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 29/12/2025 05:11: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 = '100722' 29/12/2025 05:11:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '100722' 29/12/2025 05:11: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 ( '100722' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.9' , '4.8360655737705' , '22' , '0' , '5.90' ) 29/12/2025 05:11: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 ( '100722' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 29/12/2025 05:23:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '65/E' AND id_document != '100721' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 05:23:57 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '65/E', document_date = '2025-12-29', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '149.85', price_tax_excluded = '149.85', date_upd = NOW() WHERE id_document = '100721' 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100721' 29/12/2025 05:23:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '100721' 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '11183' , 'VENITE CON ME - GUIDA' , '5' , '5' , '4' , '8.0000' , '8' , '0' , '50' , '20.00' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '13' , '4' , '2.8000' , '2.8' , '0' , '50' , '18.20' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '10' , '4' , '2.8000' , '2.8' , '0' , '50' , '14.00' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '11191' , 'VENITE CON ME 1 PARTE' , '24' , '24' , '4' , '2.8000' , '2.8' , '0' , '50' , '33.60' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '11192' , 'VENITE CON ME 2 PARTE' , '37' , '37' , '4' , '2.8000' , '2.8' , '0' , '50' , '51.80' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 29/12/2025 05:23:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '3443' , 'DIECI PAROLE DAMORE' , '2' , '2' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 05:25:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '4434' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 05:25: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' , '4434' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/12/2025 05:25: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 = '100723' 29/12/2025 05:25:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '100723' 29/12/2025 05:25: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 ( '100723' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2025 05:41:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '65/E' AND id_document != '100721' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 05:41:40 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '65/E', document_date = '2025-12-29', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA DICEMBRE 2025', 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 = '941.40', price_tax_excluded = '941.40', date_upd = NOW() WHERE id_document = '100721' 29/12/2025 05:41: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 = '100721' 29/12/2025 05:41:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '100721' 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '11183' , 'VENITE CON ME - GUIDA' , '5' , '5' , '4' , '8.0000' , '8' , '0' , '50' , '20.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '13' , '4' , '2.8000' , '2.8' , '0' , '50' , '18.20' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '10' , '4' , '2.8000' , '2.8' , '0' , '50' , '14.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '11191' , 'VENITE CON ME 1 PARTE' , '24' , '24' , '4' , '2.8000' , '2.8' , '0' , '50' , '33.60' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '11192' , 'VENITE CON ME 2 PARTE' , '37' , '37' , '4' , '2.8000' , '2.8' , '0' , '50' , '51.80' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '3443' , 'DIECI PAROLE DAMORE' , '2' , '2' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '15' , '15' , '4' , '3.40' , '3.4' , '0' , '50' , '25.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '3' , '3' , '4' , '3.40' , '3.4' , '0' , '50' , '5.10' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '2' , '2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '8408' , 'PRENDETE E MANGIATE' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '6' , '6' , '4' , '0.90' , '0.9' , '0' , '50' , '2.70' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '2679' , 'CONOSCERE GESU' , '10' , '10' , '4' , '3.50' , '3.5' , '0' , '50' , '17.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '2' , '2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '1' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '15019' , 'PREGHIAMO CON MARIA' , '4' , '4' , '4' , '0.80' , '0.8' , '0' , '50' , '1.60' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17257' , 'IO TI BATTEZZO ' , '16' , '16' , '4' , '1.80' , '1.8' , '0' , '50' , '14.40' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17630' , 'RACCONTI SOTTO LALBERO - G. CELENTANO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '4' , '4' , '4' , '9.00' , '9' , '0' , '50' , '18.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '4' , '4' , '4' , '9.00' , '9' , '0' , '50' , '18.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '3' , '3' , '4' , '9.00' , '9' , '0' , '50' , '13.50' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '2' , '4' , '35.00' , '35' , '0' , '50' , '35.00' ) 29/12/2025 05:41:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '20722' , 'SEMINATORI DI GIOIA' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '39' , '39' , '4' , '3.00' , '3' , '0' , '50' , '58.50' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '3' , '3' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '2' , '2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22151' , 'MA DIO LO HA RISUSCITATO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22152' , 'A TE RICORRIAMO' , '8' , '8' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23092' , 'SPERANZA CHE E IN NOI' , '19' , '19' , '4' , '3.00' , '3' , '0' , '50' , '28.50' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23347' , 'PREGHIERA DEL ROSARIO' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '10' , '10' , '4' , '8.00' , '8' , '0' , '50' , '40.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '4' , '4' , '4' , '2.80' , '2.8' , '0' , '50' , '5.60' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23271' , 'OMELIA, ECO DELLA PAROLA DI DIO - R. RAMPOLLA' , '6' , '6' , '4' , '5.00' , '5' , '0' , '50' , '15.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '8' , '8' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '10' , '10' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23677' , 'RICETTE DI MAMMA ROSA' , '2' , '2' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '10' , '10' , '4' , '5.00' , '5' , '0' , '50' , '25.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23954' , 'SAN BARTOLO LONGO ' , '30' , '30' , '4' , '10.00' , '10' , '0' , '50' , '150.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23721' , 'BEATITUDINI - M. DE ROSA' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 29/12/2025 05:41:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '8' , '8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '15318' , 'PERDONAMI SIGNORE ' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '15317' , 'LA COMUNIONE SPIEGATA AI RAGAZZI' , '7' , '7' , '4' , '1.80' , '1.8' , '0' , '50' , '6.30' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '15743' , 'PREGHIERA DEL ROSARIO' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '15742' , 'AVE MARIA - PREGHIERE MARIANE' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '23933' , 'TEMPO DI QUARESIMA' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '13840' , 'NONNI SONO UN TESORO' , '6' , '6' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '21701' , 'NASCITA DI GESU' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 29/12/2025 05:41:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100721' , '17034' , 'SACRAMENTO DEL PERDONO' , '11' , '11' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 29/12/2025 05:44:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3763' AND id_document != '99862' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-12') 29/12/2025 05:44:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3763', document_date = '2025-11-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 = '264.20', price_tax_excluded = '234.55', date_upd = NOW() WHERE id_document = '99862' 29/12/2025 05:44:41 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 = '99862' 29/12/2025 05:44:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '99862' 29/12/2025 05:44:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99862' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/12/2025 05:44:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99862' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/12/2025 05:44:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99862' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 29/12/2025 05:44:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99862' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '1.95' , '1.95' , '0' , '0' , '1.95' ) 29/12/2025 05:44:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99862' , '3528' , 'DIO VIVO E VERO - L. F. LADARIA' , '1' , '-1' , '4' , '59.0000' , '59' , '0' , '5' , '56.05' ) 29/12/2025 05:44:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99862' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '5' , '37.05' ) 29/12/2025 05:44:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99862' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/12/2025 06:04:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2688' , '2025-12-24' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.27' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.17' , '59.17' , NOW() , NOW() ) 29/12/2025 06:04:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100724' 29/12/2025 06:04:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100724' 29/12/2025 06:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '10525' , 'TEMPO DI LIBERAZIONE' , '2' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '19.60' ) 29/12/2025 06:04:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10525' AND id_supplier = '47' 29/12/2025 06:04:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10525' , '47' , '1' ) 29/12/2025 06:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '10' , '0' , '4' , '0.7000' , '0.7' , '0' , '30' , '4.90' ) 29/12/2025 06:04:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19323' AND id_supplier = '47' 29/12/2025 06:04:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19323' , '47' , '1' ) 29/12/2025 06:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '24408' , 'TU SEI DEGNO DI STIMA - G. CELLI' , '2' , '0' , '4' , '16.5000' , '16.5' , '0' , '30' , '23.10' ) 29/12/2025 06:04:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24408' AND id_supplier = '47' 29/12/2025 06:04:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24408' , '47' , '1' ) 29/12/2025 06:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '24409' , 'HO BISOGNO DI MISERICORDIA' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '30' , '6.30' ) 29/12/2025 06:04:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24409' AND id_supplier = '47' 29/12/2025 06:04:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24409' , '47' , '1' ) 29/12/2025 06:06:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '565-1C2' , '2025-12-23' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '153.72' , '126.00' , NOW() , NOW() ) 29/12/2025 06:06:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100725' 29/12/2025 06:06:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '100725' 29/12/2025 06:06:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100725' , '19357' , 'DALMATICA ROSA - AEDA01' , '2' , '0' , '1' , '42.0000' , '34.4262' , '22' , '0' , '102.48' ) 29/12/2025 06:06:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19357' AND id_supplier = '122' 29/12/2025 06:06:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19357' , '122' , '1' ) 29/12/2025 06:06:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100725' , '14926' , 'VESTINA BATTESIMALE' , '20' , '0' , '1' , '2.1000' , '1.7213' , '22' , '0' , '51.24' ) 29/12/2025 06:06:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '122' 29/12/2025 06:06:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '122' , '1' ) 29/12/2025 06:07:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '886/25' , '2025-12-23' , '25' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '2262.00' , '2175.00' , NOW() , NOW() ) 29/12/2025 06:07:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100726' 29/12/2025 06:07:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '100726' 29/12/2025 06:07:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100726' , '24460' , 'CRESIMA: IL SIGILLO DELLO SPIRITO SANTO - A. SORRENTINO' , '1000' , '0' , '3' , '2.175' , '2.0913461538462' , '4' , '0' , '2262.0000' ) 29/12/2025 06:07:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24460' AND id_supplier = '159' 29/12/2025 06:07:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24460' , '159' , '1' ) 29/12/2025 06:08:08 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '565-1C2', document_date = '2025-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669556', address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO', 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 = '153.72', price_tax_excluded = '126.00', date_upd = NOW() WHERE id_document = '100725' 29/12/2025 06:08:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100725' 29/12/2025 06:08:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '100725' 29/12/2025 06:08: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 ( '100725' , '19357' , 'DALMATICA ROSA - AEDA01' , '2' , '0' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '102.48' ) 29/12/2025 06:08: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 ( '100725' , '14926' , 'VESTINA BATTESIMALE' , '20' , '0' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '51.24' ) 29/12/2025 06:08:18 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '2688', document_date = '2025-12-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = '', price_shipping = '5.27', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '59.17', price_tax_excluded = '59.17', date_upd = NOW() WHERE id_document = '100724' 29/12/2025 06:08:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100724' 29/12/2025 06:08:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '100724' 29/12/2025 06:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '10525' , 'TEMPO DI LIBERAZIONE' , '2' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '19.60' ) 29/12/2025 06:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '10' , '0' , '4' , '0.7000' , '0.7' , '0' , '30' , '4.90' ) 29/12/2025 06:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '24408' , 'TU SEI DEGNO DI STIMA - G. CELLI' , '2' , '0' , '4' , '16.5000' , '16.5' , '0' , '30' , '23.10' ) 29/12/2025 06:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100724' , '24409' , 'HO BISOGNO DI MISERICORDIA' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '30' , '6.30' ) 29/12/2025 06:21:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '4435' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 06:21:41 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' , '4435' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 29/12/2025 06:21:41 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 = '100727' 29/12/2025 06:21:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '100727' 29/12/2025 06:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100727' , '23339' , 'PASTORES DABO VOBIS' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 29/12/2025 07:09:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '4436' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 07:09:42 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' , '4436' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 29/12/2025 07:09:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100728' 29/12/2025 07:09:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100728' 29/12/2025 07:09:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100728' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/12/2025 07:42:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '4437' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 29/12/2025 07:42:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4437' , '2025-12-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/12/2025 07:42: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 = '100729' 29/12/2025 07:42:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100729' 29/12/2025 07:42: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 ( '100729' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )