01/07/2025 09:17:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 09:17:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2315' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.19' , NOW() , NOW() ) 01/07/2025 09:17:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97931' 01/07/2025 09:17:05 am >> DELETE FROM ps_document_detail WHERE id_document = '97931' 01/07/2025 09:17:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97931' , '6062' , 'MADONNA DELLE GRAZIE - G. PESENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 01/07/2025 09:17:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97931' , '20124' , 'FATIMA CM 11 - 1011' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 01/07/2025 09:34:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 09:34:30 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' , '2316' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 01/07/2025 09:34:30 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 = '97932' 01/07/2025 09:34:30 am >> DELETE FROM ps_document_detail WHERE id_document = '97932' 01/07/2025 09:34:30 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 ( '97932' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 01/07/2025 09:36:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 09:36:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2317' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.78' , NOW() , NOW() ) 01/07/2025 09:36:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97933' 01/07/2025 09:36:11 am >> DELETE FROM ps_document_detail WHERE id_document = '97933' 01/07/2025 09:36:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97933' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 01/07/2025 09:36:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97933' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 01/07/2025 09:52:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1732' AND id_document != '97257' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-19') 01/07/2025 09:52:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1732', document_date = '2025-05-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 = '97257' 01/07/2025 09:52:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97257' 01/07/2025 09:52:07 am >> DELETE FROM ps_document_detail WHERE id_document = '97257' 01/07/2025 09:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97257' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '0.60' ) 01/07/2025 09:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97257' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 01/07/2025 09:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97257' , '20124' , 'FATIMA CM 11 - 1011' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 01/07/2025 09:52:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1779' AND id_document != '97310' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 01/07/2025 09:52:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1779', document_date = '2025-05-21', 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 = '97310' 01/07/2025 09:52:36 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 = '97310' 01/07/2025 09:52:36 am >> DELETE FROM ps_document_detail WHERE id_document = '97310' 01/07/2025 09:52:36 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 ( '97310' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 01/07/2025 09:52:36 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 ( '97310' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 01/07/2025 09:52:36 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 ( '97310' , '20124' , 'FATIMA CM 11 - 1011' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 01/07/2025 10:21:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 10:21: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' , '2318' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.00' , '109.84' , NOW() , NOW() ) 01/07/2025 10:21: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 = '97934' 01/07/2025 10:21:26 am >> DELETE FROM ps_document_detail WHERE id_document = '97934' 01/07/2025 10:21:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97934' , '22921' , 'CASULA GIUBILEO 2025' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 01/07/2025 10:21:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97934' , '8147' , 'POLO BASIC' , '2' , '-2' , '1' , '27' , '22.131147540984' , '22' , '0' , '54.00' ) 01/07/2025 10:28:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 10:28:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2319' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.60' , '13.61' , NOW() , NOW() ) 01/07/2025 10:28:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97935' 01/07/2025 10:28:21 am >> DELETE FROM ps_document_detail WHERE id_document = '97935' 01/07/2025 10:28:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97935' , '23777' , 'BRACCIALE MADREPERLA - BC1506' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 01/07/2025 10:28:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97935' , '23554' , 'CORONA NOVENA ACUTIS - 10950' , '1' , '-1' , '1' , '5.40' , '4.4262295081967' , '22' , '0' , '5.40' ) 01/07/2025 10:28:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97935' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 01/07/2025 10:28:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97935' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/07/2025 10:28:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97935' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/07/2025 10:28:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97935' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '1' , '-1' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 01/07/2025 10:44:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 10:44:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2320' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 01/07/2025 10:44:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97936' 01/07/2025 10:44:04 am >> DELETE FROM ps_document_detail WHERE id_document = '97936' 01/07/2025 10:44:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97936' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 01/07/2025 11:59:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 11:59:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2321' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '375.00' , '307.38' , NOW() , NOW() ) 01/07/2025 11:59:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97937' 01/07/2025 11:59:38 am >> DELETE FROM ps_document_detail WHERE id_document = '97937' 01/07/2025 11:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97937' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 01/07/2025 11:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97937' , '23841' , 'CAMICE SVASATO 100% MODAL - 434 MD' , '1' , '-1' , '1' , '190' , '155.73770491803' , '22' , '0' , '190.00' ) 01/07/2025 11:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97937' , '14724' , 'STOLA MARIANA - ART.1028/342' , '1' , '-1' , '1' , '145' , '118.85245901639' , '22' , '0' , '145.00' ) 01/07/2025 12:07:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 12:07:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2322' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.64' , '58.44' , NOW() , NOW() ) 01/07/2025 12:07:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97938' 01/07/2025 12:07:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '97938' 01/07/2025 12:07:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97938' , '23823' , 'AMEN - SET 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/07/2025 12:07:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97938' , '23822' , 'AMEN - OTT 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/07/2025 12:07:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97938' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/07/2025 12:07:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97938' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/07/2025 12:07:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97938' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.8' , '1.8' , '0' , '0' , '1.80' ) 01/07/2025 12:07:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97938' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 01/07/2025 12:26:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 12:26:24 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' , '2323' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.80' , '4.75' , NOW() , NOW() ) 01/07/2025 12:26:24 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 = '97939' 01/07/2025 12:26:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '97939' 01/07/2025 12:26: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 ( '97939' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 01/07/2025 12:26: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 ( '97939' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 01/07/2025 12:27:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 12:27:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2324' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 01/07/2025 12:27:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97940' 01/07/2025 12:27:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97940' 01/07/2025 12:27: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 ( '97940' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 01/07/2025 12:27:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 12:27:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2325' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 01/07/2025 12:27:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97941' 01/07/2025 12:27:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '97941' 01/07/2025 12:27:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97941' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/07/2025 12:39:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2326' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 12:39:37 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' , '2326' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 01/07/2025 12:39:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97942' 01/07/2025 12:39:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '97942' 01/07/2025 12:39:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97942' , '23761' , 'ECCO IO VEDO I CIELI - R. TALMELLI' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 01/07/2025 12:41:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2327' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 12:41:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2327' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 01/07/2025 12:41:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97943' 01/07/2025 12:41:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '97943' 01/07/2025 12:41:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97943' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 01/07/2025 03:29:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/S' AND id_document != '14816' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-04') 01/07/2025 03:29:57 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '12/S', document_date = '2025-06-04', document_letter = 'S', id_customer = '3487', id_supplier = '', id_address = '177359088', address1 = 'VIA RIGLA 44 24010 PONTERANICA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '270.00', price_tax_excluded = '270.00', date_upd = NOW() WHERE id_document = '14816' 01/07/2025 03:29:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14816' 01/07/2025 03:29:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '14816' 01/07/2025 03:29: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 ( '14816' , '111' , 'I NONNI SONO UN TESORO' , '300' , '-300' , '4' , '1.8000' , '1.8' , '0' , '50' , '270.00' ) 01/07/2025 04:07:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2328' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 04:07:19 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' , '2328' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 01/07/2025 04:07:19 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 = '97944' 01/07/2025 04:07:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '97944' 01/07/2025 04:07:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97944' , '2177' , 'CLERGY BASIC - MM - B&P' , '2' , '-2' , '1' , '32.5' , '26.639344262295' , '22' , '0' , '65.00' ) 01/07/2025 04:41:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 04:41:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2329' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '25.41' , NOW() , NOW() ) 01/07/2025 04:41:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97945' 01/07/2025 04:41:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '97945' 01/07/2025 04:41: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 ( '97945' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 01/07/2025 04:41: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 ( '97945' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/07/2025 04:41:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/07/2025 04:41:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97945' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '' , '2.00' ) 01/07/2025 04:43:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 04:43:55 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' , '2330' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 01/07/2025 04:43:55 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 = '97946' 01/07/2025 04:43:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97946' 01/07/2025 04:43: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 ( '97946' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '10' , '-10' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '20.00' ) 01/07/2025 04:43: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 ( '97946' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '2' , '-2' , '1' , '2' , '1.6393442622951' , '22' , '0' , '4.00' ) 01/07/2025 04:44:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 04:44:19 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' , '2331' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.50' , NOW() , NOW() ) 01/07/2025 04:44:19 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 = '97947' 01/07/2025 04:44:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '97947' 01/07/2025 04:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97947' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '1.5' , '1.5' , '0' , '0' , '7.50' ) 01/07/2025 04:50:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 04:50:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2332' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 01/07/2025 04:50:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97948' 01/07/2025 04:50:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97948' 01/07/2025 04:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97948' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/07/2025 04:50:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97948' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/07/2025 04:51:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 04:51:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '82' , '2025-07-01' , '' , '3859' , '0' , '4679261' , 'VIA G.B.VENTURI , 140 42021 BIBBIANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.75' , '104.75' , NOW() , NOW() ) 01/07/2025 04:51:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97949' 01/07/2025 04:51:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '97949' 01/07/2025 04:51:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97949' , '14499' , 'COMUNIONE AI MALATI' , '50' , '-50' , '0' , '0.30' , '0.3' , '' , '5' , '14.25' ) 01/07/2025 04:51:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97949' , '17257' , 'IO TI BATTEZZO ' , '50' , '-50' , '4' , '1.80' , '1.8' , '0' , '5' , '85.50' ) 01/07/2025 04:51:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '97949' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 04:51:23 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '82', document_date = '2025-07-01', document_letter = '', id_customer = '3859', id_supplier = '', id_address = '4679261', address1 = 'VIA G.B.VENTURI , 140 42021 BIBBIANO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '104.75', price_tax_excluded = '104.75', date_upd = NOW() WHERE id_document = '97949' 01/07/2025 04:51: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 = '97949' 01/07/2025 04:51:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97949' 01/07/2025 04:51: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 ( '97949' , '14499' , 'COMUNIONE AI MALATI' , '50' , '-50' , '0' , '0.3000' , '0.3' , '0' , '5' , '14.25' ) 01/07/2025 04:51: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 ( '97949' , '17257' , 'IO TI BATTEZZO ' , '50' , '-50' , '4' , '1.8000' , '1.8' , '0' , '5' , '85.50' ) 01/07/2025 05:17:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 05:17:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2333' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '7.82' , NOW() , NOW() ) 01/07/2025 05:17: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 = '97950' 01/07/2025 05:17:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '97950' 01/07/2025 05:17: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 ( '97950' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '15' , '-15' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '3.75' ) 01/07/2025 05:17: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 ( '97950' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/07/2025 06:57:00 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' , '25V603426' , '2025-06-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '952.88' , '950.94' , NOW() , NOW() ) 01/07/2025 06:57:00 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 = '97951' 01/07/2025 06:57:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '97951' 01/07/2025 06:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23787' , 'SACRO CUORE - MEDITAZIONI E PREGHIERE' , '2' , '0' , '4' , '9.5000' , '9.5' , '0' , '30' , '13.30' ) 01/07/2025 06:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23787' AND id_supplier = '7' 01/07/2025 06:57:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23787' , '7' , '1' ) 01/07/2025 06:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '15' , '21.25' ) 01/07/2025 06:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '7' 01/07/2025 06:57:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '7' , '1' ) 01/07/2025 06:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '8966' , 'RIDERE CON IL CUORE - VALERIO ALBISETTI' , '2' , '0' , '4' , '11.0000' , '11' , '0' , '33' , '14.74' ) 01/07/2025 06:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8966' AND id_supplier = '7' 01/07/2025 06:57:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8966' , '7' , '1' ) 01/07/2025 06:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 01/07/2025 06:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '7' 01/07/2025 06:57:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '7' , '1' ) 01/07/2025 06:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23788' , 'PARROCCHIE DEL FUTURO - TONIOLO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 01/07/2025 06:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23788' AND id_supplier = '7' 01/07/2025 06:57:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23788' , '7' , '1' ) 01/07/2025 06:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23055' , 'NOVISSIMI - M.A. BENEDETTELLI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 01/07/2025 06:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23055' AND id_supplier = '7' 01/07/2025 06:57:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23055' , '7' , '1' ) 01/07/2025 06:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '22745' , 'VANGELO DEL CORAGGIO - TONINO BELLO' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '33' , '6.63' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22745' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22745' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '16154' , 'SULLA TUA PAROLA - TONINO BELLO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16154' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16154' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '16931' , 'ROSARIO CON SAN PIO DA PIETRELCINA' , '6' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '15.68' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16931' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16931' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '22706' , 'FRANCESCO DASSISI - A. COMASTRI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22706' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22706' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23752' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23752' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23789' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23789' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23790' , 'LEGGERE JURGEN MOLTMANN - AAVV' , '1' , '0' , '4' , '29.0000' , '29' , '0' , '30' , '20.30' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23790' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23790' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23791' , 'SPERANZA NELLAPOCALISSE - S. QUINZIO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33' , '13.40' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23791' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23791' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23792' , 'PRAY CONNESSI CON IL CIELO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23792' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23792' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23798' , 'SANTITA NEL QUOTIDIANO - F. CORRIGNAN' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '35' , '3.19' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23798' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23798' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23799' , 'UOMINI IN DISCERNIMENTO - G. NACCI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23799' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23799' , '7' , '1' ) 01/07/2025 06:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23800' , 'MIA SPERANZA E IN TE- CD' , '12' , '0' , '4' , '16.9000' , '16.9' , '0' , '27' , '148.04' ) 01/07/2025 06:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23800' AND id_supplier = '7' 01/07/2025 06:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23800' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '0' , '4' , '16.9000' , '16.9' , '0' , '100' , '0.00' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23800' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23800' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23801' , 'MIA SPERANZA E IN TE - SPARTITO' , '3' , '0' , '3' , '12.0000' , '11.5385' , '4' , '27' , '27.33' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23801' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23801' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '12' , '0' , '4' , '4.5000' , '4.5' , '0' , '27' , '39.42' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23802' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23802' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '1' , '0' , '4' , '4.5000' , '4.5' , '0' , '100' , '0.00' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23802' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23802' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23803' , 'MIA SPERANZA E IN TE - AGGIUNTA SPARTITI' , '3' , '0' , '3' , '9.6100' , '9.2404' , '4' , '27' , '21.89' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23803' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23803' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23804' , 'GESU ZERO - P. CURTAZ' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '33' , '12.73' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23804' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23804' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23805' , 'COMANDAMENTI - G. RAVASI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23805' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23805' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23806' , 'CHI PREGA CAMBIA IL MONDO - TONINO BELLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23806' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23806' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23807' , 'CALENDARIO LITURGICO 2026' , '24' , '0' , '4' , '0.8000' , '0.8' , '0' , '33' , '12.86' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23807' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23807' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '0' , '4' , '0.8000' , '0.8' , '0' , '100' , '0.00' ) 01/07/2025 06:57:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23807' AND id_supplier = '7' 01/07/2025 06:57:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23807' , '7' , '1' ) 01/07/2025 06:57:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23808' , 'DANIELE - D. SCAIOLA' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23808' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23808' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23809' , 'UN TESORO DA RISCOPRIRE - M. PANERO' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '33' , '8.71' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23809' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23809' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23810' , 'AMORE NEGLI OCCHI - R. MANDIROLA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23810' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23810' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23811' , 'PARLO CON DIO? - L. INVERNIZZI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '30' , '6.30' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23811' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23811' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23825' , 'INSIEME NELLA MESSA - SET 25' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23825' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23825' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23824' , 'PAROLA E PREGHIERA - SET 25' , '2' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '3.89' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23824' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23824' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23823' , 'AMEN - SET 25' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23823' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23823' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23823' , 'AMEN - SET 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23823' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23823' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23822' , 'AMEN - OTT 25' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23822' AND id_supplier = '7' 01/07/2025 06:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23822' , '7' , '1' ) 01/07/2025 06:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23822' , 'AMEN - OTT 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 01/07/2025 06:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23822' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23822' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23828' , 'AGNELLO DI DIO - I. ALFEEV' , '1' , '0' , '4' , '45.0000' , '45' , '0' , '33' , '30.15' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23828' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23828' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23827' , 'GESTIRE I CONFLITTI - G. MATARAZZO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23827' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23827' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23829' , 'VIA DELLA PREGHIERA - A. GASPARINO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23829' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23829' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23835' , 'BIBBIA TOB - N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23835' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23835' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23832' , 'GESU ABITA TRA NOI - S. STEVAN' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23832' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23832' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23831' , 'ESERCIZI SPIRITUALI - SANTIGNAZIO DI LOYOLA' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23831' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23831' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23826' , 'MOLTIPLICATE LA GIOIA - A. DE DONATIS' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '33' , '21.44' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23826' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23826' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23830' , 'SEMPRE ALLEGRO PIER GIORGIO FRASSATI ' , '1' , '0' , '4' , '5.9000' , '5.9' , '0' , '33' , '3.95' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23830' AND id_supplier = '7' 01/07/2025 06:57:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23830' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23833' , 'PENSIERI E PAROLE DI PADRE PIO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '33' , '2.68' ) 01/07/2025 06:57:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23833' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23833' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23834' , 'LA PAROLA E I GIORNI 2026' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '33' , '12.06' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23834' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23834' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '12' , '0' , '4' , '2.0000' , '2' , '0' , '33' , '16.08' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '100' , '0.00' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23789' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23789' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '16806' , 'EVANGELII NUNTIANDI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '33' , '2.35' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16806' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16806' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23667' , 'CARLO ACUTIS - MEYLAENDER/CARRERES' , '1' , '0' , '4' , '13.9000' , '13.9' , '0' , '35' , '9.04' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23667' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23667' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8416' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8416' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '14000' , 'GALATEO IN CHIESA' , '5' , '0' , '4' , '1.0000' , '1' , '0' , '33' , '3.35' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14000' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14000' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23443' , 'MA COME SI FA?' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23443' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23443' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23752' AND id_supplier = '7' 01/07/2025 06:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23752' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23690' , 'CARLO ACUTIS E IL POTERE DELLAMICIZIA - M.T. ANTOGNAZZA' , '1' , '0' , '4' , '9.5000' , '9.5' , '0' , '30' , '6.65' ) 01/07/2025 06:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23690' AND id_supplier = '7' 01/07/2025 06:57:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23690' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23165' , 'DILEXIT NOS' , '48' , '0' , '4' , '2.2000' , '2.2' , '0' , '33' , '70.75' ) 01/07/2025 06:57:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23165' AND id_supplier = '7' 01/07/2025 06:57:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23165' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '23165' , 'DILEXIT NOS' , '4' , '0' , '4' , '2.2000' , '2.2' , '0' , '100' , '0.00' ) 01/07/2025 06:57:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23165' AND id_supplier = '7' 01/07/2025 06:57:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23165' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '25.32' , '25.32' , '0' , '0' , '25.3200' ) 01/07/2025 06:57:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 01/07/2025 06:57:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 01/07/2025 06:57: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 ( '97951' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '3' , '1.34' , '1.2884615384615' , '4' , '0' , '1.3936' ) 01/07/2025 06:57:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 01/07/2025 06:57:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 01/07/2025 07:08:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 07:08:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2334' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.70' , '11.49' , NOW() , NOW() ) 01/07/2025 07:08:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97952' 01/07/2025 07:08:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97952' 01/07/2025 07:08:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 01/07/2025 07:08:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '4.50' ) 01/07/2025 07:08:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '4406' , 'GESÙ CONFIDO IN TE - ARS 70' , '10' , '-10' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '1.50' ) 01/07/2025 07:08:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '7481' , 'PAPA FRANCESCO' , '2' , '-2' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.40' ) 01/07/2025 07:08:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '9478' , 'SAN MATTEO - OGGETTI' , '2' , '-2' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.30' ) 01/07/2025 07:21:43 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '25V603426', document_date = '2025-06-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '951.82', price_tax_excluded = '949.92', date_upd = NOW() WHERE id_document = '97951' 01/07/2025 07:21:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97951' 01/07/2025 07:21:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97951' 01/07/2025 07: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 ( '97951' , '23787' , 'SACRO CUORE - MEDITAZIONI E PREGHIERE' , '2' , '0' , '4' , '9.5000' , '9.5' , '0' , '30' , '13.30' ) 01/07/2025 07: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 ( '97951' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '15' , '21.25' ) 01/07/2025 07: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 ( '97951' , '8966' , 'RIDERE CON IL CUORE - VALERIO ALBISETTI' , '2' , '0' , '4' , '11.0000' , '11' , '0' , '33' , '14.74' ) 01/07/2025 07: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 ( '97951' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 01/07/2025 07: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 ( '97951' , '23788' , 'PARROCCHIE DEL FUTURO - TONIOLO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 01/07/2025 07: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 ( '97951' , '23055' , 'NOVISSIMI - M.A. BENEDETTELLI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 01/07/2025 07: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 ( '97951' , '22745' , 'VANGELO DEL CORAGGIO - TONINO BELLO' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '33' , '6.63' ) 01/07/2025 07: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 ( '97951' , '16154' , 'SULLA TUA PAROLA - TONINO BELLO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 07: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 ( '97951' , '16931' , 'ROSARIO CON SAN PIO DA PIETRELCINA' , '6' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '15.68' ) 01/07/2025 07: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 ( '97951' , '22706' , 'FRANCESCO DASSISI - A. COMASTRI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 07: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 ( '97951' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 01/07/2025 07: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 ( '97951' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 01/07/2025 07: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 ( '97951' , '23790' , 'LEGGERE JURGEN MOLTMANN - AAVV' , '1' , '0' , '4' , '29.0000' , '29' , '0' , '30' , '20.30' ) 01/07/2025 07: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 ( '97951' , '23791' , 'SPERANZA NELLAPOCALISSE - S. QUINZIO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33' , '13.40' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23792' , 'PRAY CONNESSI CON IL CIELO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23798' , 'SANTITA NEL QUOTIDIANO - F. CORRIGNAN' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '35' , '3.19' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23799' , 'UOMINI IN DISCERNIMENTO - G. NACCI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23800' , 'MIA SPERANZA E IN TE- CD' , '12' , '0' , '4' , '16.9000' , '16.9' , '0' , '27' , '148.04' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '0' , '4' , '16.9000' , '16.9' , '0' , '100' , '0.00' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23801' , 'MIA SPERANZA E IN TE - SPARTITO' , '3' , '0' , '3' , '11.53' , '11.086538461538' , '4' , '27' , '26.2607' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '12' , '0' , '4' , '4.5000' , '4.5' , '0' , '27' , '39.42' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '1' , '0' , '4' , '4.5000' , '4.5' , '0' , '100' , '0.00' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23803' , 'MIA SPERANZA E IN TE - AGGIUNTA SPARTITI' , '3' , '0' , '3' , '9.6100' , '9.2403846153846' , '4' , '27' , '21.89' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23804' , 'GESU ZERO - P. CURTAZ' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '33' , '12.73' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23805' , 'COMANDAMENTI - G. RAVASI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23806' , 'CHI PREGA CAMBIA IL MONDO - TONINO BELLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23807' , 'CALENDARIO LITURGICO 2026' , '24' , '0' , '4' , '0.8000' , '0.8' , '0' , '33' , '12.86' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '0' , '4' , '0.8000' , '0.8' , '0' , '100' , '0.00' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23808' , 'DANIELE - D. SCAIOLA' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23809' , 'UN TESORO DA RISCOPRIRE - M. PANERO' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '33' , '8.71' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23810' , 'AMORE NEGLI OCCHI - R. MANDIROLA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23811' , 'PARLO CON DIO? - L. INVERNIZZI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '30' , '6.30' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23825' , 'INSIEME NELLA MESSA - SET 25' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23824' , 'PAROLA E PREGHIERA - SET 25' , '2' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '3.89' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23823' , 'AMEN - SET 25' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23823' , 'AMEN - SET 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23822' , 'AMEN - OTT 25' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23822' , 'AMEN - OTT 25' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23828' , 'AGNELLO DI DIO - I. ALFEEV' , '1' , '0' , '4' , '45.0000' , '45' , '0' , '33' , '30.15' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23827' , 'GESTIRE I CONFLITTI - G. MATARAZZO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23829' , 'VIA DELLA PREGHIERA - A. GASPARINO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23835' , 'BIBBIA TOB - N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23832' , 'GESU ABITA TRA NOI - S. STEVAN' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23831' , 'ESERCIZI SPIRITUALI - SANTIGNAZIO DI LOYOLA' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23826' , 'MOLTIPLICATE LA GIOIA - A. DE DONATIS' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '33' , '21.44' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23830' , 'SEMPRE ALLEGRO PIER GIORGIO FRASSATI ' , '1' , '0' , '4' , '5.9000' , '5.9' , '0' , '33' , '3.95' ) 01/07/2025 07:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23833' , 'PENSIERI E PAROLE DI PADRE PIO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '33' , '2.68' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23834' , 'LA PAROLA E I GIORNI 2026' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '33' , '12.06' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '12' , '0' , '4' , '2.0000' , '2' , '0' , '33' , '16.08' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '100' , '0.00' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '16806' , 'EVANGELII NUNTIANDI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '33' , '2.35' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23667' , 'CARLO ACUTIS - MEYLAENDER/CARRERES' , '1' , '0' , '4' , '13.9000' , '13.9' , '0' , '35' , '9.04' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '14000' , 'GALATEO IN CHIESA' , '5' , '0' , '4' , '1.0000' , '1' , '0' , '33' , '3.35' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23443' , 'MA COME SI FA?' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23690' , 'CARLO ACUTIS E IL POTERE DELLAMICIZIA - M.T. ANTOGNAZZA' , '1' , '0' , '4' , '9.5000' , '9.5' , '0' , '30' , '6.65' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23165' , 'DILEXIT NOS' , '48' , '0' , '4' , '2.2000' , '2.2' , '0' , '33' , '70.75' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '23165' , 'DILEXIT NOS' , '4' , '0' , '4' , '2.2000' , '2.2' , '0' , '100' , '0.00' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '25.3200' , '25.32' , '0' , '0' , '25.32' ) 01/07/2025 07:21:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97951' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '3' , '1.3400' , '1.2884615384615' , '4' , '0' , '1.39' ) 01/07/2025 07:25:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2334' AND id_document != '97952' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 07:25:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2334', document_date = '2025-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.70', price_tax_excluded = '11.49', date_upd = NOW() WHERE id_document = '97952' 01/07/2025 07:25:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97952' 01/07/2025 07:25:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '97952' 01/07/2025 07:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 01/07/2025 07:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '3' , '-3' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '4.50' ) 01/07/2025 07:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '4406' , 'GESÙ CONFIDO IN TE - ARS 70' , '10' , '-10' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '1.50' ) 01/07/2025 07:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '7481' , 'PAPA FRANCESCO' , '2' , '-2' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.40' ) 01/07/2025 07:25:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97952' , '9478' , 'SAN MATTEO - OGGETTI' , '2' , '-2' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.30' ) 01/07/2025 07:31:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-01') 01/07/2025 07:31:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2335' , '2025-07-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '25.59' , NOW() , NOW() ) 01/07/2025 07:31:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97953' 01/07/2025 07:31:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '97953' 01/07/2025 07:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97953' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/07/2025 07:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97953' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 01/07/2025 07:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97953' , '7910' , 'PERGAMENE - 1A COMUNIONE MOD. A' , '12' , '-12' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '6.00' )