05/06/2025 10:06:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 10:06: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' , '1998' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.30' , '89.86' , NOW() , NOW() ) 05/06/2025 10:06: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 = '97562' 05/06/2025 10:06:24 am >> DELETE FROM ps_document_detail WHERE id_document = '97562' 05/06/2025 10:06: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 ( '97562' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '7.9' , '6.4754098360656' , '22' , '0' , '15.80' ) 05/06/2025 10:06: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 ( '97562' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 05/06/2025 10:06: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 ( '97562' , '7436' , 'PANE DI SANTANTONIO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/06/2025 10:06: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 ( '97562' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 05/06/2025 10:25:40 am >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '97503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-03') 05/06/2025 10:25:41 am >> UPDATE ps_document SET id_document_type = '24', document_num = '84/A', document_date = '2025-06-03', document_letter = 'A', id_customer = '177', id_supplier = '', id_address = '4670959', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'acconto € 500,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '750.00', price_tax_excluded = '614.75', date_upd = NOW() WHERE id_document = '97503' 05/06/2025 10:25:41 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 = '97503' 05/06/2025 10:25:41 am >> DELETE FROM ps_document_detail WHERE id_document = '97503' 05/06/2025 10:25:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97503' , '22160' , 'PISSIDE NODO APOSTOLI - 757' , '1' , '-1' , '1' , '395' , '323.77049180328' , '22' , '0' , '395.00' ) 05/06/2025 10:25:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97503' , '22159' , 'CALICE NODO APOSTOLI - 756' , '1' , '-1' , '1' , '355' , '290.98360655738' , '22' , '0' , '355.00' ) 05/06/2025 10:44:01 am >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 10:44:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '86/A' , '2025-06-05' , 'A' , '0' , '173' , '4678460' , 'CENTRO ORAFO IL TARI\\\' - ZONA INDUSTRIALE ASI SUD MOD. 114/4 81025 MARCIANISE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 05/06/2025 10:44:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97563' 05/06/2025 10:44:01 am >> DELETE FROM ps_document_detail WHERE id_document = '97563' 05/06/2025 10:44:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97563' , '' , 'CALICE BICOLORE - DORARE SOLO INTERNO COPPA' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 05/06/2025 10:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '173' 05/06/2025 10:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '173' , '1' ) 05/06/2025 10:44:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97563' , '' , 'CALICE DORATO - DORARE SOLO INTERNO COPPA' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 05/06/2025 10:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '173' 05/06/2025 10:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '173' , '1' ) 05/06/2025 10:55:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 10:55:59 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' , '1999' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 05/06/2025 10:55:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97564' 05/06/2025 10:55:59 am >> DELETE FROM ps_document_detail WHERE id_document = '97564' 05/06/2025 10:55:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97564' , '23642' , 'LUCE SUL MIO CAMMINO - F. CRISTOFARO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 05/06/2025 11:33:12 am >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 11: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 ( '21' , '76' , '2025-06-05' , '' , '3356' , '0' , '4671990' , 'VIA SALVATORE DE RENZI, 26 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '72.00' , NOW() , NOW() ) 05/06/2025 11: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 = '97565' 05/06/2025 11:33:12 am >> DELETE FROM ps_document_detail WHERE id_document = '97565' 05/06/2025 11: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 ( '97565' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '25' , '-25' , '4' , '2.80' , '2.8' , '0' , '15' , '59.50' ) 05/06/2025 11: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 ( '97565' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '25' , '-25' , '0' , '0.50' , '0.5' , '' , '0' , '12.50' ) 05/06/2025 11:34:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 11:34:04 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' , '2000' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '157.95' , '157.95' , NOW() , NOW() ) 05/06/2025 11:34:04 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 = '97566' 05/06/2025 11:34:04 am >> DELETE FROM ps_document_detail WHERE id_document = '97566' 05/06/2025 11:34:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97566' , '5929' , 'LODI E VESPRI' , '39' , '-39' , '4' , '4.05' , '4.05' , '0' , '0' , '157.95' ) 05/06/2025 11:39:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 11:39: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' , '2001' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.90' , '11.74' , NOW() , NOW() ) 05/06/2025 11:39: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 = '97567' 05/06/2025 11:39:55 am >> DELETE FROM ps_document_detail WHERE id_document = '97567' 05/06/2025 11:39: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 ( '97567' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 05/06/2025 11:39: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 ( '97567' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 05/06/2025 11:39: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 ( '97567' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 05/06/2025 11:42:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 11:42:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2002' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.80' , '6.80' , NOW() , NOW() ) 05/06/2025 11:42:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97568' 05/06/2025 11:42:38 am >> DELETE FROM ps_document_detail WHERE id_document = '97568' 05/06/2025 11:42:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97568' , '23484' , 'STORIA DI PIER GIORGIO FRASSATI' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 05/06/2025 11:42:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97568' , '23451' , 'PIER GIORGIO FRASSATI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 05/06/2025 11:57:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 11:57: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' , '2003' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 05/06/2025 11:57: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 = '97569' 05/06/2025 11:57:11 am >> DELETE FROM ps_document_detail WHERE id_document = '97569' 05/06/2025 11:57: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 ( '97569' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 05/06/2025 11:57: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 ( '97569' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '91' , '74.590163934426' , '22' , '0' , '91.00' ) 05/06/2025 11:57:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 11:57: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' , '2004' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 05/06/2025 11:57: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 = '97570' 05/06/2025 11:57:55 am >> DELETE FROM ps_document_detail WHERE id_document = '97570' 05/06/2025 11:57: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 ( '97570' , '23788' , 'PARROCCHIE DEL FUTURO - TONIOLO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 05/06/2025 02:58:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1760' AND id_document != '97290' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 05/06/2025 02:58:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1760', document_date = '2025-05-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 = '25.20', price_tax_excluded = '21.41', date_upd = NOW() WHERE id_document = '97290' 05/06/2025 02:58: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 = '97290' 05/06/2025 02:58:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '97290' 05/06/2025 02:58: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 ( '97290' , '18891' , 'ROSARIO LEGNO - R984' , '21' , '-21' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '21.00' ) 05/06/2025 02:58: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 ( '97290' , '5929' , 'LODI E VESPRI' , '1' , '-1' , '4' , '4.2' , '4.2' , '0' , '0' , '4.20' ) 05/06/2025 02:59:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1836' AND id_document != '97374' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-24') 05/06/2025 02:59:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1836', document_date = '2025-05-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 = '11.40', price_tax_excluded = '10.44', date_upd = NOW() WHERE id_document = '97374' 05/06/2025 02:59: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 = '97374' 05/06/2025 02:59:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97374' 05/06/2025 02:59: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 ( '97374' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 05/06/2025 02:59: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 ( '97374' , '1312' , 'BRACCIALE DECINA' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 05/06/2025 02:59: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 ( '97374' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.82' , '1.82' , '0' , '0' , '1.82' ) 05/06/2025 02:59: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 ( '97374' , '5929' , 'LODI E VESPRI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 05/06/2025 03:33:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 03:33:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2005' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 05/06/2025 03:33: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 = '97571' 05/06/2025 03:33:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97571' 05/06/2025 03:33: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 ( '97571' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 05/06/2025 03:33: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 ( '97571' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '-2' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '73.00' ) 05/06/2025 03:33: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 ( '97571' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '31' , '25.409836065574' , '22' , '0' , '31.00' ) 05/06/2025 04:12:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 04:12:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2006' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.40' , '22.19' , NOW() , NOW() ) 05/06/2025 04:12:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97572' 05/06/2025 04:12:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97572' 05/06/2025 04:12:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97572' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 05/06/2025 04:12:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97572' , '2640' , 'CONFESSIONI - S. AGOSTINO ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 05/06/2025 04:47:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 04:47:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '13/S' , '2025-06-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO MAGGIO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '857.10' , '857.10' , NOW() , NOW() ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14817' 05/06/2025 04:47:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '14817' 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '17' , 'LA FEDE NELLO ZAINETTO' , '5' , '0' , '4' , '6.00' , '6' , '0' , '50' , '15.00' ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '3' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '75' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '56.25' ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '18' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '22.50' ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/06/2025 04:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '71' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '88.75' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '33' , '100 GIORNI CON LO SPIRITO' , '11' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '41.25' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.90' , '9.9' , '0' , '50' , '4.95' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '46' , 'LE LETTERE DI SAN PAOLO' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '50' , 'PERDONAMI SIGNORE' , '126' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '157.50' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '8' , '0' , '4' , '30.00' , '30' , '0' , '50' , '120.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '80' , 'MISERICORDIA' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '88' , 'GESÙ È RISORTO' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '8' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '7.20' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '110' , 'SE MI AMI NON PIANGERE' , '9' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '8.10' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '2' , '0' , '4' , '4.00' , '4' , '0' , '50' , '4.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '117' , 'La preghiera delle cinque dita n.e.' , '6' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '55' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '68.75' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '8' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '12' , '0' , '4' , '3.00' , '3' , '0' , '50' , '18.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '138' , 'LA NASCITA DI GESU' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '139' , 'E NATO - n.e.' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '136' , 'ANGELO DI DIO N.E.' , '10' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '137' , 'AVVENTO' , '8' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 05/06/2025 04:47:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14817' , '126' , 'SACRAMENTO DEL PERDONO' , '134' , '0' , '4' , '2.00' , '2' , '0' , '50' , '134.00' ) 05/06/2025 04:50:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 04:50:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '14/S' , '2025-06-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MAGGIO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '19.85' , '19.85' , NOW() , NOW() ) 05/06/2025 04:50: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 = '14818' 05/06/2025 04:50:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '14818' 05/06/2025 04:50: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 ( '14818' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/06/2025 04:50: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 ( '14818' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/06/2025 04:50: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 ( '14818' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/06/2025 04:50: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 ( '14818' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 05/06/2025 04:50: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 ( '14818' , '117' , 'La preghiera delle cinque dita n.e.' , '6' , '6' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 05/06/2025 04:50: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 ( '14818' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/06/2025 04:50: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 ( '14818' , '138' , 'LA NASCITA DI GESU' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/06/2025 04:50: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 ( '14818' , '139' , 'E NATO - n.e.' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/06/2025 05:23:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 05:23:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2007' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.80' , '43.28' , NOW() , NOW() ) 05/06/2025 05:23:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97573' 05/06/2025 05:23:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '97573' 05/06/2025 05:23:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97573' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '50' , '-50' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '40.00' ) 05/06/2025 05:23:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97573' , '6333' , 'MEDAGLIA OVALE DECORATA - PADRE PIO - G291-D' , '16' , '-16' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '12.80' ) 05/06/2025 05:23:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 05:23: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' , '2008' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.90' , '1.90' , NOW() , NOW() ) 05/06/2025 05:23: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 = '97574' 05/06/2025 05:23:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '97574' 05/06/2025 05:23: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 ( '97574' , '9157' , 'ROSARIO MEDITATO SUL S. CUORE DI GESÙ - M. RATTA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 05/06/2025 05:25:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 05:25:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2009' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.00' , '50.82' , NOW() , NOW() ) 05/06/2025 05:25: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 = '97575' 05/06/2025 05:25:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '97575' 05/06/2025 05:25: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 ( '97575' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 05/06/2025 05:25: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 ( '97575' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 05/06/2025 05:26:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 05:26:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2010' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '13.20' , NOW() , NOW() ) 05/06/2025 05:26:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97576' 05/06/2025 05:26:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97576' 05/06/2025 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97576' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 05/06/2025 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97576' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 05/06/2025 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97576' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 05/06/2025 05:27:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 05:27:27 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' , '2011' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 05/06/2025 05:27:27 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 = '97577' 05/06/2025 05:27:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '97577' 05/06/2025 05:27:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97577' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '3' , '-3' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '27.00' ) 05/06/2025 05:37:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 05:37:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '22/E' , '2025-06-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO MAGGIO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1964.35' , '1964.35' , NOW() , NOW() ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97578' 05/06/2025 05:37:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97578' 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '6629' , 'MIA PREGHIERA' , '32' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '14.40' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '2679' , 'CONOSCERE GESU' , '7' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '12.25' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '10364' , 'SULLA STRADA DEL MAESTRO' , '2' , '0' , '4' , '14.00' , '14' , '0' , '50' , '14.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '0' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '13397' , 'MIO GESU' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '14032' , 'AVE MARIA' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '35' , '0' , '4' , '1.00' , '1' , '0' , '50' , '17.50' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '15019' , 'PREGHIAMO CON MARIA' , '140' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '56.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '0' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '17' , '0' , '4' , '1.00' , '1' , '0' , '50' , '8.50' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '12' , '0' , '4' , '2.00' , '2' , '0' , '50' , '12.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' , '0' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '17257' , 'IO TI BATTEZZO ' , '79' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '71.10' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '13' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '20' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '19.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '4' , '0' , '4' , '16.00' , '16' , '0' , '50' , '32.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.00' , '7' , '0' , '50' , '14.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/06/2025 05:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '3' , '0' , '4' , '12.00' , '12' , '0' , '50' , '18.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '3' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '6.75' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '20722' , 'SEMINATORI DI GIOIA' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '13' , '0' , '4' , '3.00' , '3' , '0' , '50' , '19.50' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '92' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '128.80' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '178' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '249.20' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '20909' , 'SAN GIOVANNI BATTISTA E SAN FRANCESCO DI PAOLA' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '22152' , 'A TE RICORRIAMO' , '14' , '0' , '4' , '3.00' , '3' , '0' , '50' , '21.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23092' , 'SPERANZA CHE E IN NOI' , '27' , '0' , '4' , '3.00' , '3' , '0' , '50' , '40.50' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23347' , 'PREGHIERA DEL ROSARIO' , '28' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '35.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '22809' , 'O LUCE BEATISSIMA' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '19' , '0' , '4' , '8.00' , '8' , '0' , '50' , '76.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '15' , '0' , '4' , '3.00' , '3' , '0' , '50' , '22.50' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '144' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '201.60' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '95' , '0' , '4' , '5.00' , '5' , '0' , '50' , '237.50' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '133' , '0' , '4' , '5.00' , '5' , '0' , '50' , '332.50' ) 05/06/2025 05:37:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97578' , '23721' , 'BEATITUDINI - M. DE ROSA' , '25' , '0' , '4' , '8.00' , '8' , '0' , '50' , '100.00' ) 05/06/2025 05:45:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 05:45:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2012' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.80' , '48.20' , NOW() , NOW() ) 05/06/2025 05:45: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 = '97579' 05/06/2025 05:45:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97579' 05/06/2025 05:45: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 ( '97579' , '22497' , 'QUADRETTO CRESIMA - 31/264-1K' , '12' , '-12' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '58.80' ) 05/06/2025 05:45: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 ( '97579' , '11376' , 'VIENI SPIRITO SANTO' , '12' , '-12' , '4' , '0.20' , '0.2' , '0' , '100' , '0.00' ) 05/06/2025 05:47:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '97486' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-31') 05/06/2025 05:47:47 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2025-05-31', document_letter = 'A', id_customer = '249', id_supplier = '', id_address = '4676358', address1 = 'VIA N. PETROSINO, 33 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '54.40', price_tax_excluded = '45.23', date_upd = NOW() WHERE id_document = '97486' 05/06/2025 05:47: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 = '97486' 05/06/2025 05:47:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97486' 05/06/2025 05:47:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97486' , '6075' , 'LOURDES BABY - PB19081' , '5' , '-5' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '45.00' ) 05/06/2025 05:47:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97486' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '7' , '-7' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '4.90' ) 05/06/2025 05:47:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97486' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 05/06/2025 06:13:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 06:13:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '23/E' , '2025-06-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '131.10' , '131.10' , NOW() , NOW() ) 05/06/2025 06:13:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97580' 05/06/2025 06:13:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97580' 05/06/2025 06:13:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/06/2025 06:13:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/06/2025 06:13:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '1' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 05/06/2025 06:13:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '3' , '4' , '2.80' , '2.8' , '0' , '50' , '4.20' ) 05/06/2025 06:13:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '1' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 05/06/2025 06:13:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '4' , '4' , '4' , '3.40' , '3.4' , '0' , '50' , '6.80' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '19' , '19' , '4' , '5.00' , '5' , '0' , '50' , '47.50' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '8408' , 'PRENDETE E MANGIATE' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '2679' , 'CONOSCERE GESU' , '11' , '11' , '4' , '3.50' , '3.5' , '0' , '50' , '19.25' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '12813' , 'MARIA MADRE NOSTRA' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '12255' , 'IN CAMMINO CON GESU' , '7' , '7' , '4' , '3.80' , '3.8' , '0' , '50' , '13.30' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/06/2025 06:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 05/06/2025 06:14:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 06:14: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' , '2013' , '2025-06-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.00' , '54.10' , NOW() , NOW() ) 05/06/2025 06:14: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 = '97581' 05/06/2025 06:14:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '97581' 05/06/2025 06:14: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 ( '97581' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '30' , '-30' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '66.00' ) 05/06/2025 06:20:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/E' AND id_document != '97580' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-05') 05/06/2025 06:20:06 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '23/E', document_date = '2025-06-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA MAGGIO 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 = '262.40', price_tax_excluded = '262.40', date_upd = NOW() WHERE id_document = '97580' 05/06/2025 06:20:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97580' 05/06/2025 06:20:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '97580' 05/06/2025 06:20: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 ( '97580' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 05/06/2025 06:20: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 ( '97580' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 05/06/2025 06:20: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 ( '97580' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '1' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 05/06/2025 06:20: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 ( '97580' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '3' , '4' , '2.8000' , '2.8' , '0' , '50' , '4.20' ) 05/06/2025 06:20: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 ( '97580' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '1' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 05/06/2025 06:20: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 ( '97580' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '4' , '4' , '4' , '3.4000' , '3.4' , '0' , '50' , '6.80' ) 05/06/2025 06:20: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 ( '97580' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '19' , '19' , '4' , '5.0000' , '5' , '0' , '50' , '47.50' ) 05/06/2025 06:20: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 ( '97580' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 05/06/2025 06:20: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 ( '97580' , '8408' , 'PRENDETE E MANGIATE' , '2' , '2' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 05/06/2025 06:20: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 ( '97580' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 05/06/2025 06:20: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 ( '97580' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 05/06/2025 06:20: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 ( '97580' , '2679' , 'CONOSCERE GESU' , '11' , '11' , '4' , '3.5000' , '3.5' , '0' , '50' , '19.25' ) 05/06/2025 06:20: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 ( '97580' , '12813' , 'MARIA MADRE NOSTRA' , '6' , '6' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 05/06/2025 06:20: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 ( '97580' , '12255' , 'IN CAMMINO CON GESU' , '7' , '7' , '4' , '3.8000' , '3.8' , '0' , '50' , '13.30' ) 05/06/2025 06:20: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 ( '97580' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '1' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/06/2025 06:20: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 ( '97580' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 05/06/2025 06:20: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 ( '97580' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/06/2025 06:20: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 ( '97580' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '16' , '16' , '4' , '2.00' , '2' , '0' , '50' , '16.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '2' , '2' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '2' , '2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '22152' , 'A TE RICORRIAMO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '12' , '12' , '4' , '3.00' , '3' , '0' , '50' , '18.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '8' , '8' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 05/06/2025 06:20:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97580' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '9' , '9' , '4' , '3.00' , '3' , '0' , '50' , '13.50' ) 05/06/2025 06:50:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1980' AND id_document != '97539' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-04') 05/06/2025 06:50:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1980', document_date = '2025-06-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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '97539' 05/06/2025 06:50: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 = '97539' 05/06/2025 06:50:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97539' 05/06/2025 06:50: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 ( '97539' , '21088' , 'BRACCIALE ARG. EMATITE - 1631CAV' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' )