05/05/2025 09:15:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1495' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 09:15:26 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' , '1495' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.30' , '130.57' , NOW() , NOW() ) 05/05/2025 09:15:26 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 = '96978' 05/05/2025 09:15:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96978' 05/05/2025 09:15:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96978' , '12824' , 'PIZZO MARIANO - P404' , '3' , '-3' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '156.00' ) 05/05/2025 09:15:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96978' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 05/05/2025 09:51:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1496' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 09:51:35 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' , '1496' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.80' , '66.65' , NOW() , NOW() ) 05/05/2025 09:51:35 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 = '96979' 05/05/2025 09:51:35 am >> DELETE FROM ps_document_detail WHERE id_document = '96979' 05/05/2025 09:51:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96979' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/05/2025 09:51:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96979' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 05/05/2025 09:51:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96979' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 05/05/2025 09:51:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96979' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/05/2025 10:12:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1497' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 10:12:41 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' , '1497' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '26.23' , NOW() , NOW() ) 05/05/2025 10:12: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 = '96980' 05/05/2025 10:12:41 am >> DELETE FROM ps_document_detail WHERE id_document = '96980' 05/05/2025 10:12: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 ( '96980' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '20' , '-20' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '32.00' ) 05/05/2025 10:15:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1498' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 10:15:53 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' , '1498' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.40' , '3.90' , NOW() , NOW() ) 05/05/2025 10:15:53 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 = '96981' 05/05/2025 10:15:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96981' 05/05/2025 10:15:53 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 ( '96981' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 05/05/2025 10:15:53 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 ( '96981' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 05/05/2025 10:21:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 10:21:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1499' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.90' , '63.03' , NOW() , NOW() ) 05/05/2025 10:21: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 = '96982' 05/05/2025 10:21:12 am >> DELETE FROM ps_document_detail WHERE id_document = '96982' 05/05/2025 10:21: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 ( '96982' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 05/05/2025 10:21: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 ( '96982' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 05/05/2025 10:29:13 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/05/2025 10:29:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23714' , '1' , '' , 'nuovo-prodotto' ) 05/05/2025 10:29:13 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23714' , '1' , '1' , '2' , NOW() , NOW() ) 05/05/2025 10:29:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23714' , '0' , '1' , '0' , '0' ) 05/05/2025 10:30:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392230' AND id_product != '23714' AND ean13 != '' 05/05/2025 10:30:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256392230', date_upd = NOW() WHERE id_product = '23714' 05/05/2025 10:30:00 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA - SETT OTT 25', description = '' WHERE id_product = '23714' 05/05/2025 10:30:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '23714' 05/05/2025 10:30:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23714' 05/05/2025 10:30:00 am >> DELETE FROM ps_specific_price WHERE id_product = '23714' 05/05/2025 10:30:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '6821/00/2025' , '2025-04-30' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '120.00' , '120.00' , NOW() , NOW() ) 05/05/2025 10:30:26 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 = '96983' 05/05/2025 10:30:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96983' 05/05/2025 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96983' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '10' , '10' , '4' , '5.00' , '5' , '0' , '40' , '30.0000' ) 05/05/2025 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23536' AND id_supplier = '38' 05/05/2025 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23536' , '38' , '1' ) 05/05/2025 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96983' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 05/05/2025 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23689' AND id_supplier = '38' 05/05/2025 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23689' , '38' , '1' ) 05/05/2025 10:30:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96983' , '23714' , 'SULLA TUA PAROLA - SETT OTT 25' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 05/05/2025 10:30:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23714' AND id_supplier = '38' 05/05/2025 10:30:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23714' , '38' , '1' ) 05/05/2025 10:37:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 10:37:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1500' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '780.00' , '639.34' , NOW() , NOW() ) 05/05/2025 10:37:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96984' 05/05/2025 10:37:42 am >> DELETE FROM ps_document_detail WHERE id_document = '96984' 05/05/2025 10:37:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96984' , '22781' , 'CASULA TRE CROCI - 1206' , '1' , '-1' , '1' , '440' , '360.65573770492' , '22' , '0' , '440.00' ) 05/05/2025 10:37:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96984' , '18369' , 'CAMICE MISTO COT. - 70/005212' , '1' , '-1' , '1' , '340' , '278.68852459016' , '22' , '0' , '340.00' ) 05/05/2025 11:12:18 am >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 11:12:18 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' , '76/A' , '2025-05-05' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA HOSPICE SOLOFRA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '748.50' , '632.37' , NOW() , NOW() ) 05/05/2025 11:12:18 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 = '96985' 05/05/2025 11:12:18 am >> DELETE FROM ps_document_detail WHERE id_document = '96985' 05/05/2025 11:12:18 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 ( '96985' , '17330' , 'MESSALE ROMANO D\'ALTARE N. E. ' , '1' , '-1' , '4' , '110' , '110' , '0' , '5' , '104.50' ) 05/05/2025 11:12:18 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 ( '96985' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 05/05/2025 11:12:18 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 ( '96985' , '22216' , 'CALICE CLASSICO - 885' , '1' , '-1' , '1' , '180.00' , '147.54098360656' , '22' , '0' , '180.00' ) 05/05/2025 11:12:18 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 ( '96985' , '16765' , 'MELOGRANO CON BASE OTTONE DORATO - 1021/B' , '2' , '-2' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '92.00' ) 05/05/2025 11:12:18 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 ( '96985' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '328.00' , '268.85245901639' , '22' , '0' , '328.00' ) 05/05/2025 11:13:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1501' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 11:13: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' , '1501' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 05/05/2025 11:13: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 = '96986' 05/05/2025 11:13:59 am >> DELETE FROM ps_document_detail WHERE id_document = '96986' 05/05/2025 11:13: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 ( '96986' , '7104' , 'NOVENA A SAN MICHELE ARCANGELO - 8196' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/05/2025 11:14:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1254' AND id_document != '96698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 05/05/2025 11:14:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1254', document_date = '2025-04-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '65.84', date_upd = NOW() WHERE id_document = '96698' 05/05/2025 11:14:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96698' 05/05/2025 11:14:39 am >> DELETE FROM ps_document_detail WHERE id_document = '96698' 05/05/2025 11:14:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96698' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.6000' , '40.655737704918' , '22' , '0' , '49.60' ) 05/05/2025 11:14:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96698' , '17628' , 'PREGHIERE A SAN CHARBEL - 8946' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 05/05/2025 11:14:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96698' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/05/2025 11:14:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96698' , '10687' , 'TORCIA A VENTO ' , '4' , '-4' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '16.00' ) 05/05/2025 11:14:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96698' , '18554' , 'MADONNA ROSARIO BABY - 023 MDR/9 BB' , '1' , '-1' , '1' , '9.9' , '8.1147540983607' , '22' , '0' , '9.90' ) 05/05/2025 11:14:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1325' AND id_document != '96782' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-19') 05/05/2025 11:14:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1325', document_date = '2025-04-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '96782' 05/05/2025 11:14:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96782' 05/05/2025 11:14:58 am >> DELETE FROM ps_document_detail WHERE id_document = '96782' 05/05/2025 11:14:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96782' , '22605' , 'CATENINA CON CROCE - BKSS-0210SI' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 05/05/2025 11:14:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96782' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 05/05/2025 11:15:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1324' AND id_document != '96781' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-19') 05/05/2025 11:15:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1324', document_date = '2025-04-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '96781' 05/05/2025 11:15:45 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 = '96781' 05/05/2025 11:15:45 am >> DELETE FROM ps_document_detail WHERE id_document = '96781' 05/05/2025 11:15:45 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 ( '96781' , '19818' , 'INCENSO NATURALE 3A KG 1' , '2' , '-2' , '1' , '22.5' , '18.44262295082' , '22' , '0' , '45.00' ) 05/05/2025 11:25:19 am >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '96985' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 11:25:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '76/A', document_date = '2025-05-05', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA HOSPICE SOLOFRA', 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 = '821.80', price_tax_excluded = '693.73', date_upd = NOW() WHERE id_document = '96985' 05/05/2025 11:25:19 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 = '96985' 05/05/2025 11:25:19 am >> DELETE FROM ps_document_detail WHERE id_document = '96985' 05/05/2025 11:25:19 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 ( '96985' , '17330' , 'MESSALE ROMANO D\'ALTARE N. E. ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 05/05/2025 11:25:19 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 ( '96985' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '44.0000' , '36.065573770492' , '22' , '0' , '44.00' ) 05/05/2025 11:25:19 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 ( '96985' , '22216' , 'CALICE CLASSICO - 885' , '1' , '-1' , '1' , '180.0000' , '147.54098360656' , '22' , '0' , '180.00' ) 05/05/2025 11:25:19 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 ( '96985' , '16765' , 'MELOGRANO CON BASE OTTONE DORATO - 1021/B' , '2' , '-2' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '92.00' ) 05/05/2025 11:25:19 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 ( '96985' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '328.0000' , '268.85245901639' , '22' , '0' , '328.00' ) 05/05/2025 11:25:19 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 ( '96985' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/05/2025 11:25:19 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 ( '96985' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/05/2025 11:25:19 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 ( '96985' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/05/2025 11:25:19 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 ( '96985' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 05/05/2025 11:29:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1502' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 11:29:03 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' , '1502' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '196.72' , NOW() , NOW() ) 05/05/2025 11:29:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96987' 05/05/2025 11:29:03 am >> DELETE FROM ps_document_detail WHERE id_document = '96987' 05/05/2025 11:29:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96987' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 05/05/2025 11:29:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96987' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 05/05/2025 11:29:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96987' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 05/05/2025 11:29:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96987' , '18129' , 'TAU COLORATO - T56' , '50' , '-50' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '60.00' ) 05/05/2025 11:36:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1503' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 11:36:18 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' , '1503' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.82' , NOW() , NOW() ) 05/05/2025 11:36:18 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 = '96988' 05/05/2025 11:36:18 am >> DELETE FROM ps_document_detail WHERE id_document = '96988' 05/05/2025 11:36:18 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 ( '96988' , '7930' , 'PERGAMENE - BATTESIMO MOD. D' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 05/05/2025 11:36:18 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 ( '96988' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 05/05/2025 11:36:18 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 ( '96988' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 05/05/2025 11:36:18 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 ( '96988' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 05/05/2025 11:36:18 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 ( '96988' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '10' , '-10' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '5.00' ) 05/05/2025 11:39:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1504' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 11:39:51 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' , '1504' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.00' , '193.68' , NOW() , NOW() ) 05/05/2025 11:39:51 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 = '96989' 05/05/2025 11:39:51 am >> DELETE FROM ps_document_detail WHERE id_document = '96989' 05/05/2025 11:39:51 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 ( '96989' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 05/05/2025 11:39:51 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 ( '96989' , '22710' , 'PRIMA DI STENDERE LE BRACCIA - O. VEZZOLI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 05/05/2025 11:39:51 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 ( '96989' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 05/05/2025 11:39:51 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 ( '96989' , '17460' , 'GIORNO SENZA TRAMONTO - M. CAMISASCA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/05/2025 11:39:51 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 ( '96989' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '106.8' , '87.540983606557' , '22' , '0' , '106.80' ) 05/05/2025 11:39:51 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 ( '96989' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '-1' , '1' , '46.90' , '38.44262295082' , '22' , '0' , '46.90' ) 05/05/2025 11:39:51 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 ( '96989' , '22433' , 'COPRI BOTTONE - 22178' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 05/05/2025 12:01:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1505' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 12:01:09 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' , '1505' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.18' , '8.30' , NOW() , NOW() ) 05/05/2025 12:01:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96990' 05/05/2025 12:01:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '96990' 05/05/2025 12:01:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96990' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 05/05/2025 12:01:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96990' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 05/05/2025 12:11:58 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'CqDvYx82KGRcwzEA' , NOW() , NOW() ) 05/05/2025 12:11:58 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4214' , '1' ) 05/05/2025 12:11:58 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4214' , '2' ) 05/05/2025 12:11:58 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4214' , '3' ) 05/05/2025 12:13:10 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4214' 05/05/2025 12:13:10 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4214' , '10' , '130' , '' , 'MOCCIA' , 'MAIKOL' , 'VIA AIA DEL GALLO 62' , '' , '83055' , 'STURNO' , '' , '' , '3667409763' , '' , '' , NOW() , NOW() ) 05/05/2025 12:13:10 pm >> UPDATE ps_customer SET email = 'mocciamaikol@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4214' 05/05/2025 12:13:32 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4214' 05/05/2025 12:13:32 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4214' , '10' , '130' , '' , 'MOCCIA' , 'MAIKOL' , 'VIA AIA DEL GALLO 62' , '' , '83055' , 'STURNO' , '' , '' , '3667409763' , '' , '' , NOW() , NOW() ) 05/05/2025 12:13:32 pm >> UPDATE ps_customer SET email = 'mocciamaikol@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4214' 05/05/2025 12:14:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '61' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 12:14:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '61' , '2025-05-05' , '' , '4214' , '0' , '4679505' , 'VIA AIA DEL GALLO 62 83055 STURNO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '15.45' , '15.45' , NOW() , NOW() ) 05/05/2025 12:14:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96991' 05/05/2025 12:14:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '96991' 05/05/2025 12:14:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96991' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/05/2025 12:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96991' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 05/05/2025 12:25:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1506' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 12:25:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1506' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 05/05/2025 12:25:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96992' 05/05/2025 12:25:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '96992' 05/05/2025 12:25:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96992' , '6809' , 'MOCCOLO 60X165' , '2' , '-2' , '1' , '4' , '3.2786885245902' , '22' , '0' , '8.00' ) 05/05/2025 12:48: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 ( '31' , '213' , '2025-04-29' , '' , '2765' , '0' , '11512' , 'C.SO UMBERTO I , 70 80034 MARIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '67.20' , '67.20' , NOW() , NOW() ) 05/05/2025 12:48: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 = '96993' 05/05/2025 12:48:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '96993' 05/05/2025 12:48: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 ( '96993' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '2560' , '2560' , '4' , '0.035' , '0.035' , '0' , '25' , '67.2000' ) 05/05/2025 03:52:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1507' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 03:52: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' , '1507' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '186.83' , '159.06' , NOW() , NOW() ) 05/05/2025 03:52: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 = '96994' 05/05/2025 03:52:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '96994' 05/05/2025 03:52: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 ( '96994' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 05/05/2025 03:52: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 ( '96994' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 05/05/2025 03:52: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 ( '96994' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '10' , '10' , '0' , '0' , '20.00' ) 05/05/2025 03:52: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 ( '96994' , '22488' , 'SANTO ROSARIO CON LE ICONE - A.M. CANOPI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/05/2025 03:52: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 ( '96994' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 05/05/2025 03:52: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 ( '96994' , '23629' , 'CON MARIA MADRE DEL SIGNORE - R. LUPI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 05/05/2025 03:53:09 pm >> DELETE FROM ps_document WHERE id_document = '92988' 05/05/2025 03:53:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '92988' 05/05/2025 03:55:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1156' AND id_document != '96587' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-09') 05/05/2025 03:55:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1156', document_date = '2025-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '310.00', price_tax_excluded = '254.10', date_upd = NOW() WHERE id_document = '96587' 05/05/2025 03:55:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96587' 05/05/2025 03:55:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '96587' 05/05/2025 03:55: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 ( '96587' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '290.00' ) 05/05/2025 03:55: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 ( '96587' , '22433' , 'COPRI BOTTONE - 22178' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 05/05/2025 03:57:31 pm >> DELETE FROM ps_document WHERE id_document = '96809' 05/05/2025 03:57:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '96809' 05/05/2025 04:09:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1508' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 04:09:08 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' , '1508' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.60' , '25.60' , NOW() , NOW() ) 05/05/2025 04:09:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96995' 05/05/2025 04:09:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '96995' 05/05/2025 04:09:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96995' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 05/05/2025 04:09:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '3714' , '2025-04-29' , '' , '0' , '163' , '4674530' , 'VIA CORTI 29 24126 BERGAMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '444.08' , '364.00' , NOW() , NOW() ) 05/05/2025 04:09:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96996' 05/05/2025 04:09:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '96996' 05/05/2025 04:09:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96996' , '22463' , 'CAMICE LEGGERO - 020/06' , '5' , '5' , '1' , '28' , '22.950819672131' , '22' , '0' , '170.8000' ) 05/05/2025 04:09:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22463' AND id_supplier = '163' 05/05/2025 04:09:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22463' , '163' , '1' ) 05/05/2025 04:09:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96996' , '22464' , 'CASULA LEGGERA - 1212' , '8' , '8' , '1' , '28' , '22.950819672131' , '22' , '0' , '273.2800' ) 05/05/2025 04:09:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22464' AND id_supplier = '163' 05/05/2025 04:09:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22464' , '163' , '1' ) 05/05/2025 04:21:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '25V602227' , '2025-04-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '897.21' , '897.21' , NOW() , NOW() ) 05/05/2025 04:21:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96997' 05/05/2025 04:21:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '96997' 05/05/2025 04:21:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23650' , 'PREGHIAMO IL ROSARIO CON CARLO ACUTIS' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '30' , '5.60' ) 05/05/2025 04:21:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23650' AND id_supplier = '7' 05/05/2025 04:21:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23650' , '7' , '1' ) 05/05/2025 04:21:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23651' , 'RIPARTIRE DA NICEA ' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 05/05/2025 04:21:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23651' AND id_supplier = '7' 05/05/2025 04:21:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23651' , '7' , '1' ) 05/05/2025 04:21:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23652' , 'CARLO UN TESTIMONE INCREDIBILE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 05/05/2025 04:21:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23652' AND id_supplier = '7' 05/05/2025 04:21:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23652' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23653' , 'TUTTA LA FELICITA DEL MONDO' , '1' , '0' , '4' , '12.5000' , '12.5' , '0' , '30' , '8.75' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23653' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23653' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23654' , 'MARIA LA PIU BELLA DEL MONDO - PAPA FRANCESCO' , '3' , '0' , '4' , '17.0000' , '17' , '0' , '30' , '35.70' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23654' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23654' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23655' , 'PAROLA CHE ACCAREZZA - O. FARINOLA' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23655' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23655' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23656' , 'PROFETI DI SPERANZA - T. GIANNUZZI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23656' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23656' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23657' , 'DENTRO I VELI - AAVV' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23657' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23657' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23658' , 'ROSARIO FLAGELLO DEI DEMONI - F. BAMONTE' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '33' , '8.64' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23658' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23658' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23659' , 'MARIA NELLE SUE APPARIZIONI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23659' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23659' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23660' , 'CREDO - P. CURTAZ' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23660' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23660' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23661' , 'NOVENA A SAN CARLO ACUTIS' , '3' , '0' , '4' , '4.0000' , '4' , '0' , '30' , '8.40' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23661' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23661' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23662' , 'SPIRITO SANTO - G. FORLAI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23662' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23662' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23663' , 'SPIAZZATI DALLO SPIRITO - P. CURTAZ' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23663' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23663' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23664' , 'RITA DA CASCIA - F. CORTESI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23664' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23664' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23665' , 'UMANISSIME STORIE - A. DEHO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 05/05/2025 04:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23665' AND id_supplier = '7' 05/05/2025 04:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23665' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23666' , 'CARLO ACUTIS SENZA DI LUI' , '5' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '6.03' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23666' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23666' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23667' , 'CARLO ACUTIS - MEYLAENDER/CARRERES' , '2' , '0' , '4' , '13.9000' , '13.9' , '0' , '35' , '18.07' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23667' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23667' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23668' , 'CUORE INDIVISO - J.R. BERNA' , '2' , '0' , '4' , '19.0000' , '19' , '0' , '33' , '25.46' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23668' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23668' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23669' , 'NUOVI MARTIRI - ACCATOLI/FUSCO' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '33' , '16.75' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23669' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23669' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23670' , 'PREGHIAMO CON CARLO ACUTIS' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '13.40' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23670' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23670' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '10.50' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23636' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23636' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8416' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8416' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23637' , 'PREGHIERA CHE SALVA IL MONDO' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '30' , '1.40' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23637' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23637' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23639' , 'UNA PARROCCHIA DI PALLINE DARGILLA' , '1' , '0' , '4' , '8.9000' , '8.9' , '0' , '33' , '5.96' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23639' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23639' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23640' , 'BIBBIA TOB NUOVO TESTAMENTO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23640' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23640' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '21692' , 'GENERATI DALLO SPIRITO - A. LOUF' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21692' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21692' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23679' , 'PIERRE TEILHARD DE CHARDIN - M. PRATS' , '1' , '0' , '4' , '29.0000' , '29' , '0' , '30' , '20.30' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23679' AND id_supplier = '7' 05/05/2025 04:21:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23679' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23671' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/1-2 - RATZINGER' , '1' , '0' , '4' , '130.0000' , '130' , '0' , '30' , '91.00' ) 05/05/2025 04:21:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23671' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23671' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23672' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/3 - RATZINGER' , '1' , '0' , '4' , '75.0000' , '75' , '0' , '30' , '52.50' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23672' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23672' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23658' , 'ROSARIO FLAGELLO DEI DEMONI - F. BAMONTE' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '33' , '8.64' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23658' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23658' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23637' , 'PREGHIERA CHE SALVA IL MONDO' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '30' , '1.40' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23637' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23637' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '20778' , 'PASSIO N.E.' , '11' , '0' , '4' , '6.0000' , '6' , '0' , '35' , '42.90' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20778' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20778' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23491' , 'AMEN - MAG 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23491' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23491' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23492' , 'AMEN - GIU 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23492' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23492' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23486' , 'SERVI INUTILI A TEMPO PIENO - T. BELLO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23486' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23486' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23443' , 'MA COME SI FA?' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23443' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23443' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23698' , 'INSIEME NELLA MESSA - LUG 25' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23698' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23698' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23697' , 'PAROLA E PREGHIERA - LUG 25' , '2' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '3.89' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23697' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23697' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23700' , 'AMEN - LUG 25' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23700' AND id_supplier = '7' 05/05/2025 04:21:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23700' , '7' , '1' ) 05/05/2025 04:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96997' , '23700' , 'AMEN - LUG 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 05/05/2025 04:21:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23700' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23700' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23699' , 'AMEN - AGO 25' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23699' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23699' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23699' , 'AMEN - AGO 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23699' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23699' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23702' , 'MARIA - R. FUSCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23702' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23702' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23694' , 'DONNA DI FRONTIERA ... - E.M. RONGHI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23694' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23694' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23690' , 'CARLO ACUTIS E IL POTERE DELLAMICIZIA - M.T. ANTOGNAZZA' , '1' , '0' , '4' , '9.5000' , '9.5' , '0' , '30' , '6.65' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23690' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23690' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23696' , 'IO SONO LA RISURREZIONE E LA VITA' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23696' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23696' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23695' , 'SANTITA - M. SEMERARO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23695' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23695' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23692' , 'SAN PAOLO LAPOSTOLO CREDIBILE - A. PISANO' , '1' , '0' , '4' , '7.9000' , '7.9' , '0' , '35' , '5.14' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23692' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23692' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23691' , 'CARLO ACUTIS LINFLUENCER DI DIO - C. GALATOLO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23691' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23691' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23701' , 'CHIESA E I SACRAMENTI - C. SIMONELLI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23701' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23701' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23703' , 'DONI DELLO SPIRITO SANTO - L. LALLEMANT' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 05/05/2025 04:21:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23703' AND id_supplier = '7' 05/05/2025 04:21:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23703' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23693' , 'GESU LO CONOSCI DAVVERO? - V. MORELLI' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '30' , '9.45' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23693' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23693' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23708' , 'INCONTRO ACCENDE LA SPERANZA - L. GIUSSANI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23708' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23708' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23709' , 'NELLATTESA DI UN NUOVO INIZIO - A. SCOLA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23709' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23709' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '3.50' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23636' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23636' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23666' , 'CARLO ACUTIS SENZA DI LUI' , '3' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '3.62' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23666' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23666' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23694' , 'DONNA DI FRONTIERA ... - E.M. RONGHI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23694' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23694' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23013' , 'EUCARISTIA LA MIA AUTOSTRADA N.E. - CARLO ACUTIS' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23013' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23013' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '23650' , 'PREGHIAMO IL ROSARIO CON CARLO ACUTIS' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '30' , '2.80' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23650' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23650' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '0' , '4' , '65.0000' , '65' , '0' , '15' , '55.25' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22149' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22149' , '7' , '1' ) 05/05/2025 04:21: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 ( '96997' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '0' , '25.25' , '25.25' , '' , '0' , '25.2500' ) 05/05/2025 04:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 05/05/2025 04:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 05/05/2025 04:34:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 04:34: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 ( '22' , '9/S' , '2025-05-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO APRILE 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1147.70' , '1147.70' , NOW() , NOW() ) 05/05/2025 04:34: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 = '14809' 05/05/2025 04:34:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '14809' 05/05/2025 04:34: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 ( '14809' , '17' , 'LA FEDE NELLO ZAINETTO' , '4' , '0' , '4' , '6.00' , '6' , '0' , '50' , '12.00' ) 05/05/2025 04:34: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 ( '14809' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '1' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 05/05/2025 04:34: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 ( '14809' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '30' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '22.50' ) 05/05/2025 04:34: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 ( '14809' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/05/2025 04:34: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 ( '14809' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '257' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '321.25' ) 05/05/2025 04:34: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 ( '14809' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 05/05/2025 04:34: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 ( '14809' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '208' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '260.00' ) 05/05/2025 04:34: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 ( '14809' , '125' , 'MIE PREGHIERINE - N. E.' , '32' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '24.00' ) 05/05/2025 04:34: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 ( '14809' , '33' , '100 GIORNI CON LO SPIRITO' , '13' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '48.75' ) 05/05/2025 04:34: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 ( '14809' , '50' , 'PERDONAMI SIGNORE' , '104' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '130.00' ) 05/05/2025 04:34: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 ( '14809' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '4' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 05/05/2025 04:34: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 ( '14809' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '11' , '0' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 05/05/2025 04:34: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 ( '14809' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/05/2025 04:34: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 ( '14809' , '88' , 'GESÙ È RISORTO' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/05/2025 04:34: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 ( '14809' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '12' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '10.80' ) 05/05/2025 04:34: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 ( '14809' , '92' , 'LA PREGHIERA DEL ROSARIO' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 04:34: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 ( '14809' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/05/2025 04:34: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 ( '14809' , '104' , 'TEMPO DI QUARESIMA' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 04:34: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 ( '14809' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/05/2025 04:34: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 ( '14809' , '110' , 'SE MI AMI NON PIANGERE' , '212' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '190.80' ) 05/05/2025 04:34: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 ( '14809' , '111' , 'I NONNI SONO UN TESORO' , '14' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '12.60' ) 05/05/2025 04:34: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 ( '14809' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2025 04:34: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 ( '14809' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '8' , '0' , '4' , '4.00' , '4' , '0' , '50' , '16.00' ) 05/05/2025 04:34: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 ( '14809' , '117' , 'La preghiera delle cinque dita n.e.' , '2' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 05/05/2025 04:34: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 ( '14809' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/05/2025 04:34: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 ( '14809' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 05/05/2025 04:34: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 ( '14809' , '138' , 'LA NASCITA DI GESU' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 04:34: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 ( '14809' , '139' , 'E NATO - n.e.' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/05/2025 04:34: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 ( '14809' , '136' , 'ANGELO DI DIO N.E.' , '2' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 05/05/2025 04:34: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 ( '14809' , '137' , 'AVVENTO' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 04:34: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 ( '14809' , '126' , 'SACRAMENTO DEL PERDONO' , '27' , '0' , '4' , '2.00' , '2' , '0' , '50' , '27.00' ) 05/05/2025 04:40:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 04:40:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '10/S' , '2025-05-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA APRILE 2025' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.70' , '112.70' , NOW() , NOW() ) 05/05/2025 04:40: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 = '14810' 05/05/2025 04:40:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '14810' 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '17' , 'LA FEDE NELLO ZAINETTO' , '10' , '10' , '4' , '6.00' , '6' , '0' , '50' , '30.00' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '8' , '8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '30' , 'LA BIBBIA: ANTICO TESTAMENTO' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '33' , '100 GIORNI CON LO SPIRITO' , '2' , '2' , '4' , '7.50' , '7.5' , '0' , '50' , '7.50' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '50' , 'PERDONAMI SIGNORE' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '72' , 'FEDE, SPERANZA E CARITA' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 05/05/2025 04:40:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14810' , '96' , 'LA PREGHIERA - MEDICINA DELLANIMA' , '8' , '8' , '4' , '1.50' , '1.5' , '0' , '50' , '6.00' ) 05/05/2025 04:40: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 ( '14810' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 05/05/2025 04:40: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 ( '14810' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/05/2025 04:40: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 ( '14810' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '8' , '8' , '4' , '1.50' , '1.5' , '0' , '50' , '6.00' ) 05/05/2025 04:40: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 ( '14810' , '104' , 'TEMPO DI QUARESIMA' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 04:40: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 ( '14810' , '111' , 'I NONNI SONO UN TESORO' , '20' , '20' , '4' , '1.80' , '1.8' , '0' , '50' , '18.00' ) 05/05/2025 04:40: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 ( '14810' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 04:40: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 ( '14810' , '139' , 'E NATO - n.e.' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/05/2025 04:40: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 ( '14810' , '137' , 'AVVENTO' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/05/2025 04:42:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '96750' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 05/05/2025 04:42:39 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2025-04-17', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 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 = '117.89', price_tax_excluded = '100.32', date_upd = NOW() WHERE id_document = '96750' 05/05/2025 04:42: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 = '96750' 05/05/2025 04:42:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96750' 05/05/2025 04:42: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 ( '96750' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 05/05/2025 04:42: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 ( '96750' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/05/2025 04:42: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 ( '96750' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/05/2025 04:42: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 ( '96750' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 05/05/2025 04:42: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 ( '96750' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 05/05/2025 04:42: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 ( '96750' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 05/05/2025 04:42: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 ( '96750' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/05/2025 04:42: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 ( '96750' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 05/05/2025 04:42: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 ( '96750' , '6014' , 'LUMINO BIANCO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 05/05/2025 04:42: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 ( '96750' , '' , '05/05' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 05/05/2025 04:42: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 ( '96750' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 05/05/2025 04:42: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 ( '96750' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/05/2025 04:42: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 ( '96750' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 05/05/2025 04:57:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 04:57:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '17/E' , '2025-05-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1278.90' , '1278.90' , NOW() , NOW() ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96998' 05/05/2025 04:57:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '96998' 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '73' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '87.60' ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '0' , '4' , '6.20' , '6.2' , '0' , '50' , '3.10' ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11191' , 'VENITE CON ME 1 PARTE' , '9' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '12.60' ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11192' , 'VENITE CON ME 2 PARTE' , '11' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '15.40' ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/05/2025 04:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '3978' , 'EUCARISTIA: RITO E VITA' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '6629' , 'MIA PREGHIERA' , '604' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '271.80' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '8408' , 'PRENDETE E MANGIATE' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '4154' , 'FESTA DEL PERDONO' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '2679' , 'CONOSCERE GESU' , '27' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '47.25' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '67' , '0' , '4' , '5.00' , '5' , '0' , '50' , '167.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '11' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '46.75' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '0' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12253' , 'MIO LIBRO DI PREGHIERE' , '29' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '40.60' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12255' , 'IN CAMMINO CON GESU' , '26' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '49.40' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '5' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '8.75' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '5' , '0' , '4' , '6.00' , '6' , '0' , '50' , '15.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '14032' , 'AVE MARIA' , '4' , '0' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '223' , '0' , '4' , '1.00' , '1' , '0' , '50' , '111.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '15019' , 'PREGHIAMO CON MARIA' , '33' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '13.20' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '15020' , 'PREGARE OGNI GIORNO' , '26' , '0' , '4' , '1.00' , '1' , '0' , '50' , '13.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '38' , '0' , '4' , '1.00' , '1' , '0' , '50' , '19.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '19' , '0' , '4' , '2.00' , '2' , '0' , '50' , '19.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17257' , 'IO TI BATTEZZO ' , '32' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '28.80' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17582' , 'SAN CESARE DE BUS' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '4' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '7.60' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '11' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18176' , 'ANTIQUUM MINISTERIUM ' , '1' , '0' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '62' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '58.90' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '8' , '0' , '4' , '7.00' , '7' , '0' , '50' , '28.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/05/2025 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20719' , 'CORONA DELL’ADDOLORATA' , '4' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20721' , 'AVE MARIA - L. CALABRETTA' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20722' , 'SEMINATORI DI GIOIA' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '22' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '27.50' ) 05/05/2025 04:57:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2025 04:58:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1509' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 04:58:04 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' , '1509' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.04' , '15.82' , NOW() , NOW() ) 05/05/2025 04:58:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96999' 05/05/2025 04:58:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96999' 05/05/2025 04:58:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96999' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 05/05/2025 04:58:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96999' , '23492' , 'AMEN - GIU 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 05/05/2025 04:58:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96999' , '23491' , 'AMEN - MAG 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 05/05/2025 05:22:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 05:22:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1510' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 05/05/2025 05:22:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97000' 05/05/2025 05:22:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '97000' 05/05/2025 05:22:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97000' , '22734' , 'CROCE SAN BENEDETTO - PG680BR' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 05/05/2025 05:26:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/E' AND id_document != '96998' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 05:26:04 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '17/E', document_date = '2025-05-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO APRILE 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 = '2210.60', price_tax_excluded = '2210.60', date_upd = NOW() WHERE id_document = '96998' 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96998' 05/05/2025 05:26:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96998' 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '73' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '87.60' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '0' , '4' , '6.2000' , '6.2' , '0' , '50' , '3.10' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11191' , 'VENITE CON ME 1 PARTE' , '9' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '12.60' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11192' , 'VENITE CON ME 2 PARTE' , '11' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '15.40' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '3978' , 'EUCARISTIA: RITO E VITA' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 05/05/2025 05:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '6629' , 'MIA PREGHIERA' , '604' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '271.80' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '8408' , 'PRENDETE E MANGIATE' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '4154' , 'FESTA DEL PERDONO' , '5' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '7.50' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '2679' , 'CONOSCERE GESU' , '27' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '47.25' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '67' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '167.50' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '11' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '46.75' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '50' , '12.50' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12253' , 'MIO LIBRO DI PREGHIERE' , '29' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '40.60' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12255' , 'IN CAMMINO CON GESU' , '26' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '49.40' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '5' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '8.75' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '15.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '14032' , 'AVE MARIA' , '4' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '223' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '111.50' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '15019' , 'PREGHIAMO CON MARIA' , '33' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '13.20' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '15020' , 'PREGARE OGNI GIORNO' , '26' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '13.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '38' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '19.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '19' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '19.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17257' , 'IO TI BATTEZZO ' , '32' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '28.80' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17582' , 'SAN CESARE DE BUS' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '4' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '7.60' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '11' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '13.75' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '0' , '4' , '4.8000' , '4.8' , '0' , '50' , '2.40' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18176' , 'ANTIQUUM MINISTERIUM ' , '1' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '0.50' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '62' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '58.90' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '3' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '2.25' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 05/05/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '8' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '28.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20719' , 'CORONA DELL’ADDOLORATA' , '4' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '3.60' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20721' , 'AVE MARIA - L. CALABRETTA' , '2' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '4.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20722' , 'SEMINATORI DI GIOIA' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '22' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '27.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '4' , '0' , '4' , '8.00' , '8' , '0' , '50' , '16.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '27' , '0' , '4' , '3.00' , '3' , '0' , '50' , '40.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '18' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '22.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '18' , '0' , '4' , '8.00' , '8' , '0' , '50' , '72.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '95' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '133.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '263' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '368.20' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22151' , 'MA DIO LO HA RISUSCITATO' , '4' , '0' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 05/05/2025 05:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96998' , '22152' , 'A TE RICORRIAMO' , '147' , '0' , '4' , '3.00' , '3' , '0' , '50' , '220.50' ) 05/05/2025 05:45:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 05:45:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '18/E' , '2025-05-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA APRILE 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1212.91' , '1211.20' , NOW() , NOW() ) 05/05/2025 05:45:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97001' 05/05/2025 05:45:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97001' 05/05/2025 05:45:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '20' , '4' , '2.40' , '2.4' , '0' , '50' , '24.00' ) 05/05/2025 05:45:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '34' , '34' , '4' , '2.50' , '2.5' , '0' , '50' , '42.50' ) 05/05/2025 05:45:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '2' , '2' , '4' , '5.16' , '5.16' , '0' , '50' , '5.16' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '9675' , 'SARETE MIEI TESTIMONI' , '10' , '10' , '4' , '3.50' , '3.5' , '0' , '50' , '17.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '5457' , 'IO SONO CON VOI 1 PARTE' , '58' , '58' , '4' , '2.80' , '2.8' , '0' , '50' , '81.20' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '5458' , 'IO SONO CON VOI 2 PARTE' , '68' , '68' , '4' , '2.80' , '2.8' , '0' , '50' , '95.20' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '11191' , 'VENITE CON ME 1 PARTE' , '58' , '58' , '4' , '2.80' , '2.8' , '0' , '50' , '81.20' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '11192' , 'VENITE CON ME 2 PARTE' , '86' , '86' , '4' , '2.80' , '2.8' , '0' , '50' , '120.40' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '7' , '7' , '4' , '3.50' , '3.5' , '0' , '50' , '12.25' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '3443' , 'DIECI PAROLE DAMORE' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '6629' , 'MIA PREGHIERA' , '20' , '20' , '4' , '0.90' , '0.9' , '0' , '50' , '9.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '8408' , 'PRENDETE E MANGIATE' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '5' , '5' , '4' , '5.00' , '5' , '0' , '50' , '12.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '4' , '4' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '2679' , 'CONOSCERE GESU' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1' , '1' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '5' , '5' , '4' , '1.60' , '1.6' , '0' , '50' , '4.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '12819' , 'REGISTRO DEL CATECHISTA ' , '19' , '19' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '9.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '14031' , 'SEGNO DELLA CROCE' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '14032' , 'AVE MARIA' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '4' , '4' , '4' , '1.00' , '1' , '0' , '50' , '2.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '2' , '4' , '1.00' , '1' , '0' , '50' , '1.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '1' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '16667' , 'VIA CRUCIS' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '17257' , 'IO TI BATTEZZO ' , '24' , '24' , '4' , '1.80' , '1.8' , '0' , '50' , '21.60' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '18036' , 'FERITE FERITOIE ' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/05/2025 05:45:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/05/2025 05:45: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 ( '97001' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/05/2025 05:45: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 ( '97001' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2025 05:45: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 ( '97001' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '1' , '4' , '1.90' , '1.9' , '0' , '50' , '0.95' ) 05/05/2025 05:45: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 ( '97001' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/05/2025 05:45: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 ( '97001' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '2' , '2' , '4' , '7.00' , '7' , '0' , '50' , '7.00' ) 05/05/2025 05:45: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 ( '97001' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/05/2025 05:45: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 ( '97001' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/05/2025 05:45: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 ( '97001' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' , '2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 05/05/2025 05:45: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 ( '97001' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 05/05/2025 05:45: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 ( '97001' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '2' , '2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/05/2025 05:45: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 ( '97001' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '10' , '10' , '4' , '4.50' , '4.5' , '0' , '50' , '22.50' ) 05/05/2025 05:45: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 ( '97001' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '8' , '8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 05/05/2025 05:45: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 ( '97001' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '5' , '5' , '4' , '10.00' , '10' , '0' , '50' , '25.00' ) 05/05/2025 05:45: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 ( '97001' , '20719' , 'CORONA DELL’ADDOLORATA' , '8' , '8' , '4' , '1.80' , '1.8' , '0' , '50' , '7.20' ) 05/05/2025 05:45: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 ( '97001' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/05/2025 05:45: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 ( '97001' , '20721' , 'AVE MARIA - L. CALABRETTA' , '3' , '3' , '4' , '4.50' , '4.5' , '0' , '50' , '6.75' ) 05/05/2025 05:45: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 ( '97001' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '8' , '8' , '4' , '4.50' , '4.5' , '0' , '50' , '18.00' ) 05/05/2025 05:45: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 ( '97001' , '20722' , 'SEMINATORI DI GIOIA' , '16' , '16' , '4' , '2.50' , '2.5' , '0' , '50' , '20.00' ) 05/05/2025 05:45: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 ( '97001' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/05/2025 05:45: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 ( '97001' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '2' , '2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/05/2025 05:45: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 ( '97001' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2025 05:45: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 ( '97001' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/05/2025 05:45: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 ( '97001' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '5' , '5' , '4' , '8.00' , '8' , '0' , '50' , '20.00' ) 05/05/2025 05:45: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 ( '97001' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '91' , '91' , '4' , '3.00' , '3' , '0' , '50' , '136.50' ) 05/05/2025 05:45: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 ( '97001' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/05/2025 05:45: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 ( '97001' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '12' , '12' , '4' , '2.00' , '2' , '0' , '50' , '12.00' ) 05/05/2025 05:45: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 ( '97001' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '11' , '11' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 05/05/2025 05:45: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 ( '97001' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '11' , '11' , '4' , '8.00' , '8' , '0' , '50' , '44.00' ) 05/05/2025 05:45: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 ( '97001' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '4' , '4' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 05/05/2025 05:45: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 ( '97001' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2025 05:45: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 ( '97001' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '8' , '8' , '4' , '8.00' , '8' , '0' , '50' , '32.00' ) 05/05/2025 05:45: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 ( '97001' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/05/2025 05:45: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 ( '97001' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 05/05/2025 05:45:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '3' , '3' , '4' , '2.80' , '2.8' , '0' , '50' , '4.20' ) 05/05/2025 05:45:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '9' , '9' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 05/05/2025 05:45:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '22152' , 'A TE RICORRIAMO' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/05/2025 05:45:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2025 05:45:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/05/2025 05:45:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97001' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '21' , '21' , '4' , '3.00' , '3' , '0' , '50' , '31.50' ) 05/05/2025 06:12:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1511' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 06:12: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' , '1511' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '177.13' , '152.15' , NOW() , NOW() ) 05/05/2025 06:12: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 = '97002' 05/05/2025 06:12:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '97002' 05/05/2025 06:12: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 ( '97002' , '9013' , 'RITO DELLINIZIAZIONE CRISTIANA DEGLI ADULTI' , '1' , '-1' , '4' , '20.66' , '20.66' , '0' , '5' , '19.63' ) 05/05/2025 06:12: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 ( '97002' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 05/05/2025 06:12: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 ( '97002' , '20116' , 'FATIMA CM 70 - 1037' , '1' , '-1' , '1' , '133.00' , '109.01639344262' , '22' , '0' , '133.00' ) 05/05/2025 06:12: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 ( '97002' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 05/05/2025 07:18:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '77/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 07:18: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 ( '24' , '77/A' , '2025-05-05' , 'A' , '178' , '0' , '4679446' , 'VIA S. MARGHERITA 1 84129 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.50' , '84.84' , NOW() , NOW() ) 05/05/2025 07:18: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 = '97003' 05/05/2025 07:18:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97003' 05/05/2025 07:18: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 ( '97003' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '50' , '-50' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '90.00' ) 05/05/2025 07:18: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 ( '97003' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 05/05/2025 07:18: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 ( '97003' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/05/2025 07:27:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '73/A' AND id_document != '96934' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-30') 05/05/2025 07:27:30 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '73/A', document_date = '2025-04-30', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '188.90', price_tax_excluded = '156.73', date_upd = NOW() WHERE id_document = '96934' 05/05/2025 07:27:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96934' 05/05/2025 07:27:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '96934' 05/05/2025 07:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96934' , '23705' , 'PAGELLA A TRE PAGINE - CORONA ANGELICA' , '300' , '-300' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '60.00' ) 05/05/2025 07:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96934' , '19398' , 'CLERGY COTONE 100% MM - C02' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 05/05/2025 07:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96934' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '0' , '10.50' ) 05/05/2025 07:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96934' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 05/05/2025 07:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96934' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 05/05/2025 07:44:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1512' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 05/05/2025 07:44:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1512' , '2025-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 05/05/2025 07:44:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97004' 05/05/2025 07:44:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '97004' 05/05/2025 07:44:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97004' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 05/05/2025 07:54:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001169' AND id_product != '15356' AND ean13 != '' 05/05/2025 07:54:22 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001169', date_upd = NOW() WHERE id_product = '15356' 05/05/2025 07:54:22 pm >> UPDATE ps_product_lang SET name = 'AMPOLLE A BRACCIO DORATE - 1511', description = '' WHERE id_product = '15356' 05/05/2025 07:54:22 pm >> UPDATE ps_product SET wholesale_price = '40.38', on_sale = '0', price = '86.0656' WHERE id_product = '15356' 05/05/2025 07:54:22 pm >> UPDATE ps_product_shop SET wholesale_price = '40.38', price = '86.0656', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15356' 05/05/2025 07:54:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '15356'