04/01/2024 09:25:19 am >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 09:25:19 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' , '26' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '234.00' , '191.80' , NOW() , NOW() ) 04/01/2024 09:25:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89802' 04/01/2024 09:25:19 am >> DELETE FROM ps_document_detail WHERE id_document = '89802' 04/01/2024 09:25:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89802' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 04/01/2024 09:25:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89802' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 04/01/2024 09:25:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89802' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 04/01/2024 09:26:10 am >> SELECT document_num FROM ps_document WHERE document_num = '27' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 09:26:10 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' , '27' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 04/01/2024 09:26:10 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 = '89803' 04/01/2024 09:26:10 am >> DELETE FROM ps_document_detail WHERE id_document = '89803' 04/01/2024 09:26:10 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 ( '89803' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 04/01/2024 09:50:41 am >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 09:50:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '28' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 04/01/2024 09:50:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89804' 04/01/2024 09:50:41 am >> DELETE FROM ps_document_detail WHERE id_document = '89804' 04/01/2024 09:50:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89804' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 04/01/2024 09:50:56 am >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 09:50:56 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' , '29' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 04/01/2024 09:50:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89805' 04/01/2024 09:50:56 am >> DELETE FROM ps_document_detail WHERE id_document = '89805' 04/01/2024 09:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89805' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 04/01/2024 10:52:20 am >> SELECT document_num FROM ps_document WHERE document_num = '30' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 10:52:20 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' , '30' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 04/01/2024 10:52:20 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 = '89806' 04/01/2024 10:52:20 am >> DELETE FROM ps_document_detail WHERE id_document = '89806' 04/01/2024 10:52:20 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 ( '89806' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 04/01/2024 11:35:11 am >> SELECT document_num FROM ps_document WHERE document_num = '31' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 11:35: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' , '31' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 04/01/2024 11:35: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 = '89807' 04/01/2024 11:35:11 am >> DELETE FROM ps_document_detail WHERE id_document = '89807' 04/01/2024 11:35: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 ( '89807' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 04/01/2024 12:00:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '32' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 12:00:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '32' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 04/01/2024 12:00:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89808' 04/01/2024 12:00:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89808' 04/01/2024 12:00:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89808' , '17846' , 'QUADRO DECORATO 23X15' , '1' , '-1' , '1' , '25.50' , '20.901639344262' , '22' , '0' , '25.50' ) 04/01/2024 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89808' , '11691' , 'BRACCIALE TRECCIA DECINA - 818/7' , '2' , '-2' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '7.50' ) 04/01/2024 12:13:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 12:13: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' , '33' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.22' , '78.22' , NOW() , NOW() ) 04/01/2024 12:13: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 = '89809' 04/01/2024 12:13:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '89809' 04/01/2024 12:13: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 ( '89809' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '20' , '-20' , '4' , '0.70' , '0.7' , '0' , '0' , '14.00' ) 04/01/2024 12:13: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 ( '89809' , '21881' , 'INSIEME NELLA MESSA - FEB 2024' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 04/01/2024 12:13: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 ( '89809' , '21753' , 'INSIEME NELLA MESSA - GEN 2024' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 04/01/2024 12:13: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 ( '89809' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/01/2024 12:13: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 ( '89809' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/01/2024 12:13: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 ( '89809' , '21923' , 'PER NARRARE ALLA GENERAZIONE - AAVV' , '1' , '-1' , '4' , '25' , '25' , '0' , '0' , '25.00' ) 04/01/2024 12:13: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 ( '89809' , '20972' , 'PADRE NOSTRO - P. STEFANI' , '1' , '-1' , '4' , '13' , '13' , '0' , '0' , '13.00' ) 04/01/2024 12:20:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 12:20: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' , '34' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.76' , '2.76' , NOW() , NOW() ) 04/01/2024 12:20: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 = '89810' 04/01/2024 12:20:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89810' 04/01/2024 12:20: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 ( '89810' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 04/01/2024 12:24:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 12:24:14 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' , '35' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.32' , NOW() , NOW() ) 04/01/2024 12:24:14 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 = '89811' 04/01/2024 12:24:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89811' 04/01/2024 12:24:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89811' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 04/01/2024 12:24:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89811' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/01/2024 12:24:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89811' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/01/2024 12:32:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 12:32: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' , '36' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 04/01/2024 12:32: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 = '89812' 04/01/2024 12:32:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '89812' 04/01/2024 12:32: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 ( '89812' , '15054' , 'TAVOLETTA PADRE NOSTRO' , '36' , '-36' , '1' , '2' , '1.6393442622951' , '22' , '0' , '72.00' ) 04/01/2024 12:37:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '37' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 12:37:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '37' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.60' , '35.74' , NOW() , NOW() ) 04/01/2024 12:37:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89813' 04/01/2024 12:37:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89813' 04/01/2024 12:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89813' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '41.40' ) 04/01/2024 12:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89813' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 04/01/2024 12:47:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 12:47: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 ( '11' , '38' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 04/01/2024 12:47: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 = '89814' 04/01/2024 12:47:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89814' 04/01/2024 12:47: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 ( '89814' , '21691' , 'PENDENTE FF 10X11' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/01/2024 03:08:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '39' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 03:08:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '39' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 04/01/2024 03:08:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89815' 04/01/2024 03:08:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '89815' 04/01/2024 03:08:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89815' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '10' , '18.00' ) 04/01/2024 03:13:50 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/01/2024 03:13:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22036' , '1' , '' , 'nuovo-prodotto' ) 04/01/2024 03:13:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22036' , '1' , '1' , '2' , NOW() , NOW() ) 04/01/2024 03:13:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22036' , '0' , '1' , '0' , '0' ) 04/01/2024 03:14:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831136310' AND id_product != '22036' AND ean13 != '' 04/01/2024 03:14:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831136310', date_upd = NOW() WHERE id_product = '22036' 04/01/2024 03:14:38 pm >> UPDATE ps_product_lang SET name = 'VANGELO DI GIOVANNI COMM. ESEGETICO', description = '' WHERE id_product = '22036' 04/01/2024 03:14:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '65' WHERE id_product = '22036' 04/01/2024 03:14:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '65', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22036' 04/01/2024 03:14:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22036' 04/01/2024 03:16:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831136310' AND id_product != '22036' AND ean13 != '' 04/01/2024 03:16:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831136310', date_upd = NOW() WHERE id_product = '22036' 04/01/2024 03:16:13 pm >> UPDATE ps_product_lang SET name = 'VANGELO DI GIOVANNI COMM. ESEGETICO', description = '' WHERE id_product = '22036' 04/01/2024 03:16:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '65' WHERE id_product = '22036' 04/01/2024 03:16:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '65', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22036' 04/01/2024 03:16:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '22036' 04/01/2024 03:16:14 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22036' 04/01/2024 03:16:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22037' , '1' , '' , 'nuovo-prodotto' ) 04/01/2024 03:16:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22037' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22036' 04/01/2024 03:16:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22037' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22036' 04/01/2024 03:27:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259623676' AND id_product != '22037' AND ean13 != '' 04/01/2024 03:27:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9791259623676', date_upd = NOW() WHERE id_product = '22037' 04/01/2024 03:27:03 pm >> UPDATE ps_product_lang SET name = 'TEOLOGIA DEI SACRAMENTI - J. GRANADOS', description = '' WHERE id_product = '22037' 04/01/2024 03:27:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27' WHERE id_product = '22037' 04/01/2024 03:27:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22037' 04/01/2024 03:27:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '22037' 04/01/2024 03:27:04 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22037' 04/01/2024 03:27:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22038' , '1' , '' , 'nuovo-prodotto' ) 04/01/2024 03:27:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22038' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22037' 04/01/2024 03:27:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22038' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22037' 04/01/2024 03: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 ( '33' , '462' , '2024-01-03' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '310.50' , '310.50' , NOW() , NOW() ) 04/01/2024 03: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 = '89816' 04/01/2024 03:27:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '89816' 04/01/2024 03: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 ( '89816' , '22036' , 'VANGELO DI GIOVANNI COMM. ESEGETICO' , '1' , '1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 04/01/2024 03:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22036' AND id_supplier = '109' 04/01/2024 03:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22036' , '109' , '1' ) 04/01/2024 03: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 ( '89816' , '2403' , 'CODICE DI DIRITTO CANONICO - 1' , '1' , '1' , '4' , '59.50' , '59.5' , '0' , '0' , '59.50' ) 04/01/2024 03:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2403' AND id_supplier = '109' 04/01/2024 03:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2403' , '109' , '1' ) 04/01/2024 03: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 ( '89816' , '2404' , 'CODICE DI DIRITTO CANONICO - 2' , '1' , '1' , '4' , '59.50' , '59.5' , '0' , '0' , '59.50' ) 04/01/2024 03:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2404' AND id_supplier = '109' 04/01/2024 03:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2404' , '109' , '1' ) 04/01/2024 03: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 ( '89816' , '2405' , 'CODICE DI DIRITTO CANONICO - 3' , '1' , '1' , '4' , '59.50' , '59.5' , '0' , '0' , '59.50' ) 04/01/2024 03:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2405' AND id_supplier = '109' 04/01/2024 03:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2405' , '109' , '1' ) 04/01/2024 03: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 ( '89816' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 04/01/2024 03:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20639' AND id_supplier = '109' 04/01/2024 03:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20639' , '109' , '1' ) 04/01/2024 03: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 ( '89816' , '22037' , 'TEOLOGIA DEI SACRAMENTI - J. GRANADOS' , '1' , '1' , '4' , '27.00' , '27' , '0' , '0' , '27.00' ) 04/01/2024 03:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22037' AND id_supplier = '109' 04/01/2024 03:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22037' , '109' , '1' ) 04/01/2024 03: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 ( '89816' , '5823' , 'LIBRO DORO' , '25' , '25' , '4' , '0.60' , '0.6' , '0' , '0' , '15.0000' ) 04/01/2024 03:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '109' 04/01/2024 03:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '109' , '1' ) 04/01/2024 03:29:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3914' AND id_document != '89399' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 04/01/2024 03:29:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3914', document_date = '2023-12-07', 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 = '28.50', price_tax_excluded = '26.07', date_upd = NOW() WHERE id_document = '89399' 04/01/2024 03:29:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89399' 04/01/2024 03:29:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89399' 04/01/2024 03:29:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89399' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 04/01/2024 03:29:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89399' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '5.5' , '5.5' , '0' , '0' , '5.50' ) 04/01/2024 03:29:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89399' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 04/01/2024 03:29:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3850' AND id_document != '89299' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 04/01/2024 03:29:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3850', document_date = '2023-12-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '41.41', price_tax_excluded = '41.41', date_upd = NOW() WHERE id_document = '89299' 04/01/2024 03:29:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89299' 04/01/2024 03:29:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89299' 04/01/2024 03:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89299' , '18733' , 'CREA IL TUO POPUP CON LA STORIA DI NATALE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 04/01/2024 03:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89299' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '32' , '32' , '0' , '0' , '32.00' ) 04/01/2024 03:40:32 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '95FdAOE6e5GdJSBV' , NOW() , NOW() ) 04/01/2024 03:40:32 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4078' , '1' ) 04/01/2024 03:40:32 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4078' , '2' ) 04/01/2024 03:40:32 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4078' , '3' ) 04/01/2024 03:41:45 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4078' 04/01/2024 03:41:45 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4078' , '10' , '180' , '' , 'RIVA' , 'DON ANTONIO' , 'VIA N. SAURO 7' , '' , '20017' , 'MAZZO DI RHO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 04/01/2024 03:41:45 pm >> UPDATE ps_customer SET email = 'rivada60@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4078' 04/01/2024 03:42:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 03:42:14 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' , '7' , '2024-01-04' , '' , '4078' , '0' , '4679246' , 'VIA N. SAURO 7 20017 MAZZO DI RHO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '95.00' , '95.00' , NOW() , NOW() ) 04/01/2024 03:42:14 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 = '89817' 04/01/2024 03:42:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89817' 04/01/2024 03:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89817' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '100' , '-100' , '4' , '1.00' , '1' , '0' , '5' , '95.00' ) 04/01/2024 05:00:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '40' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 05:00:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '40' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/01/2024 05:00:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89818' 04/01/2024 05:00:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89818' 04/01/2024 05:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89818' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/01/2024 05:22:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 05:22:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '41' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 04/01/2024 05:22:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89819' 04/01/2024 05:22:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89819' 04/01/2024 05:22:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89819' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 04/01/2024 05:24:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '42' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 05:24:44 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' , '42' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 04/01/2024 05:24:44 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 = '89820' 04/01/2024 05:24:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89820' 04/01/2024 05:24: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 ( '89820' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 04/01/2024 05:24: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 ( '89820' , '21099' , 'BRACCIALE DECINA - BD008' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 04/01/2024 06:22:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3605' AND id_document != '88952' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 04/01/2024 06:22:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3605', document_date = '2023-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '114.00', price_tax_excluded = '105.89', date_upd = NOW() WHERE id_document = '88952' 04/01/2024 06:22: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 = '88952' 04/01/2024 06:22:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88952' 04/01/2024 06:22: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 ( '88952' , '19997' , 'GESU\' BAMBINO CM 34 - BJ140-34E' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 04/01/2024 06:22: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 ( '88952' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 04/01/2024 06:22: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 ( '88952' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 04/01/2024 06:22: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 ( '88952' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 04/01/2024 06:22: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 ( '88952' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 04/01/2024 06:22: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 ( '88952' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '5.35' , '5.35' , '0' , '0' , '5.35' ) 04/01/2024 06:22:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3678' AND id_document != '89061' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-21') 04/01/2024 06:22:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3678', document_date = '2023-11-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 = '1.20', price_tax_excluded = '1.20', date_upd = NOW() WHERE id_document = '89061' 04/01/2024 06:22:31 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 = '89061' 04/01/2024 06:22:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '89061' 04/01/2024 06:22:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89061' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.6' , '0.6' , '0' , '0' , '1.20' ) 04/01/2024 06:23:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3688' AND id_document != '89082' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-22') 04/01/2024 06:23:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3688', document_date = '2023-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.20', price_tax_excluded = '7.20', date_upd = NOW() WHERE id_document = '89082' 04/01/2024 06:23:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89082' 04/01/2024 06:23:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89082' 04/01/2024 06:23:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89082' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '3.6' , '3.6' , '0' , '0' , '7.20' ) 04/01/2024 06:23:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3724' AND id_document != '89132' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 04/01/2024 06:23:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3724', document_date = '2023-11-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '17.50', price_tax_excluded = '17.50', date_upd = NOW() WHERE id_document = '89132' 04/01/2024 06:23:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89132' 04/01/2024 06:23:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '89132' 04/01/2024 06:23:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89132' , '3511' , 'DIO PARLA ALL\'UOMO' , '2' , '-2' , '4' , '8.75' , '8.75' , '0' , '0' , '17.50' ) 04/01/2024 06:24:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3733' AND id_document != '89143' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 04/01/2024 06:24:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3733', document_date = '2023-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.00', price_tax_excluded = '15.00', date_upd = NOW() WHERE id_document = '89143' 04/01/2024 06:24:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89143' 04/01/2024 06:24:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '89143' 04/01/2024 06:24:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89143' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 04/01/2024 06:25:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3775' AND id_document != '89199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 04/01/2024 06:25:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3775', document_date = '2023-11-28', 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 = '270.00', price_tax_excluded = '228.78', date_upd = NOW() WHERE id_document = '89199' 04/01/2024 06:25: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 = '89199' 04/01/2024 06:25:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '89199' 04/01/2024 06:25: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 ( '89199' , '19625' , 'CROCIFISSO CM 30 - 1004' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 04/01/2024 06:25: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 ( '89199' , '19882' , 'CROCE CM 25 LUNA/TORTORA - 4965/727' , '1' , '-1' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 04/01/2024 06:25: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 ( '89199' , '12190' , 'CROCE VETRO CASABLANCA BIA/ARG CM 23' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '18031' , 'BRUCIAINCENSO H 8' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '15704' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2980/F0024' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '5.39' , '5.39' , '0' , '0' , '5.39' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '19884' , 'COPPIA SPOSI H 12 CON CUORE LUM - 4249/822' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '13275' , 'NATIVITA CON LED CM 12' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '21150' , 'QUADRO 15X15' , '1' , '-1' , '1' , '19.5000' , '15.983606557377' , '22' , '0' , '19.50' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '21688' , 'ANGELO PIEGHEVOLE CM 15' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '24' , '-24' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '4.80' ) 04/01/2024 06:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '21991' , 'MIO PRESEPE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '5' , '17.01' ) 04/01/2024 06:26:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3776' AND id_document != '89200' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 04/01/2024 06:26:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3776', document_date = '2023-11-28', 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 = '21.95', price_tax_excluded = '19.21', date_upd = NOW() WHERE id_document = '89200' 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89200' 04/01/2024 06:26:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89200' 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '6' , '-6' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '1.20' ) 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '21688' , 'ANGELO PIEGHEVOLE CM 15' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 04/01/2024 06:26:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 04/01/2024 06:27:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3809' AND id_document != '89241' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-30') 04/01/2024 06:27:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3809', document_date = '2023-11-30', 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 = '47.25', price_tax_excluded = '47.25', date_upd = NOW() WHERE id_document = '89241' 04/01/2024 06:27:51 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 = '89241' 04/01/2024 06:27:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89241' 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '16911' , 'DIAVOLI CHI SONO - 8991' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '19586' , 'UNA MAMMA PER TUTTI - NATUZZA EVOLO - 8072' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.3' , '3.3' , '0' , '0' , '3.30' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '9993' , 'SIGNORE, DACCI OGGI...' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '2756' , 'CORONA ANGELICA - 8197' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '19585' , 'PREGHIERE AL SACRO CUORE - 8071' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 04/01/2024 06:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89241' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/01/2024 06:33:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 06:33:33 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' , '43' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '4.89' , NOW() , NOW() ) 04/01/2024 06:33:33 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 = '89821' 04/01/2024 06:33:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '89821' 04/01/2024 06:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89821' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 04/01/2024 06:33:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89821' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 04/01/2024 06:34:21 pm >> DELETE FROM ps_document WHERE id_document = '89347' 04/01/2024 06:34:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '89347' 04/01/2024 06:35:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '4084' AND id_document != '89604' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-20') 04/01/2024 06:35:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4084', document_date = '2023-12-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.40', price_tax_excluded = '5.40', date_upd = NOW() WHERE id_document = '89604' 04/01/2024 06:35:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89604' 04/01/2024 06:35:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '89604' 04/01/2024 06:35: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 ( '89604' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 04/01/2024 06:35: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 ( '89604' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 04/01/2024 06:35: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 ( '89604' , '21919' , 'AMEN - APR 24' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 04/01/2024 06:36:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '4063' AND id_document != '89581' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-19') 04/01/2024 06:36:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4063', document_date = '2023-12-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 = '88.11', price_tax_excluded = '82.70', date_upd = NOW() WHERE id_document = '89581' 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89581' 04/01/2024 06:36:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89581' 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '13888' , 'VI E STATO DETTO MA IO VI DICO - C. MILITELLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '21496' , 'PAROLA CHE RISANA - ANNO B - A. SANSONE' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '17314' , 'E SUBITO LO SEGUIRONO - ANNO B - A.M. CANOPI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.2' , '0.2' , '0' , '0' , '0.20' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '18032' , 'BRUCIAINCENSO H 11' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '40' , '-40' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '12.00' ) 04/01/2024 06:36:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '21920' , 'AMEN - MAR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 04/01/2024 06:56:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '44' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 04/01/2024 06:56: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' , '44' , '2024-01-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '54.00' , NOW() , NOW() ) 04/01/2024 06:56: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 = '89822' 04/01/2024 06:56:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89822' 04/01/2024 06:56: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 ( '89822' , '18311' , 'ANDATE E FATE IN MODO ... ANNO A - E. DELLA CORTE' , '1' , '-1' , '4' , '27.00' , '27' , '0' , '0' , '27.00' ) 04/01/2024 06:56: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 ( '89822' , '18313' , 'GESU RICORDATI ... ANNO C - E. DELLA CORTE' , '1' , '-1' , '4' , '27.00' , '27' , '0' , '0' , '27.00' ) 04/01/2024 06:58:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '4161' AND id_document != '89692' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-23') 04/01/2024 06:58:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4161', document_date = '2023-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '580.00', price_tax_excluded = '480.95', date_upd = NOW() WHERE id_document = '89692' 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89692' 04/01/2024 06:58:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89692' 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '1203' , 'BIBBIA TUTTA MIA' , '1' , '-1' , '4' , '12.3000' , '12.3' , '0' , '0' , '12.30' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '10957' , 'UNIFORMITÀ ALLA VOLONTÀ DI DIO - 8549' , '1' , '-1' , '4' , '6.7000' , '6.7' , '0' , '0' , '6.70' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '36.00' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '143.0000' , '117.2131147541' , '22' , '0' , '143.00' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.85' , '0.85' , '0' , '0' , '0.85' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO' , '2' , '-2' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '350.00' ) 04/01/2024 06:58:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89692' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/01/2024 06:59:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3995' AND id_document != '89500' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 04/01/2024 06:59:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3995', document_date = '2023-12-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.95', price_tax_excluded = '4.87', date_upd = NOW() WHERE id_document = '89500' 04/01/2024 06:59:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89500' 04/01/2024 06:59:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89500' 04/01/2024 06:59:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '16710' , 'MESSAGGIO DI TENEREZZA - 17' , '3' , '-3' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.45' ) 04/01/2024 06:59:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '0' , '0.90' ) 04/01/2024 06:59:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 04/01/2024 06:59:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '21201' , 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 04/01/2024 06:59:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 04/01/2024 06:59:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4167' AND id_document != '89699' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-27') 04/01/2024 06:59:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4167', document_date = '2023-12-27', 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 = '15.96', price_tax_excluded = '15.96', date_upd = NOW() WHERE id_document = '89699' 04/01/2024 06:59:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89699' 04/01/2024 06:59:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '89699' 04/01/2024 06:59:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89699' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 04/01/2024 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89699' , '21752' , 'PAROLA E PREGHIERA - GEN 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/01/2024 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89699' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 04/01/2024 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89699' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/01/2024 06:59:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89699' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '0.8' , '0.8' , '0' , '0' , '0.80' ) 04/01/2024 07:00:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4217' AND id_document != '89753' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-30') 04/01/2024 07:00:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4217', document_date = '2023-12-30', 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 = '59.70', price_tax_excluded = '59.43', date_upd = NOW() WHERE id_document = '89753' 04/01/2024 07:00: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 = '89753' 04/01/2024 07:00:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89753' 04/01/2024 07:00: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 ( '89753' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '12' , '-12' , '4' , '5.0000' , '5' , '0' , '5' , '57.00' ) 04/01/2024 07:00: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 ( '89753' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/01/2024 07:00: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 ( '89753' , '6629' , 'MIA PREGHIERA' , '2' , '-2' , '4' , '0.6' , '0.6' , '0' , '0' , '1.20' ) 04/01/2024 07:00:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '4172' AND id_document != '89704' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-27') 04/01/2024 07:00:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4172', document_date = '2023-12-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.60', price_tax_excluded = '8.09', date_upd = NOW() WHERE id_document = '89704' 04/01/2024 07:00:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89704' 04/01/2024 07:00:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89704' 04/01/2024 07:00: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 ( '89704' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.2000' , '5.0819672131148' , '22' , '0' , '6.20' ) 04/01/2024 07:00: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 ( '89704' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 04/01/2024 07:00: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 ( '89704' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/01/2024 07:00: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 ( '89704' , '6629' , 'MIA PREGHIERA' , '2' , '-2' , '4' , '0.6' , '0.6' , '0' , '0' , '1.20' ) 04/01/2024 07:02:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3978' AND id_document != '89480' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 04/01/2024 07:02:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3978', document_date = '2023-12-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.10', price_tax_excluded = '10.56', date_upd = NOW() WHERE id_document = '89480' 04/01/2024 07:02: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 = '89480' 04/01/2024 07:02:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89480' 04/01/2024 07:02: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 ( '89480' , '21515' , 'CINQUE PANI DORZO 2024' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 04/01/2024 07:02: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 ( '89480' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/01/2024 07:02: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 ( '89480' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/01/2024 07:02: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 ( '89480' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '2' , '-2' , '4' , '0.6' , '0.6' , '0' , '0' , '1.20' ) 04/01/2024 07:02:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '89790' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-03') 04/01/2024 07:02:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '21', document_date = '2024-01-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '89790' 04/01/2024 07:02:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89790' 04/01/2024 07:02:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89790' 04/01/2024 07:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89790' , '19618' , 'CARLO ACUTIS' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 04/01/2024 07:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89790' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 04/01/2024 07:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89790' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 04/01/2024 07:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89790' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '3.6' , '3.6' , '0' , '0' , '3.60' ) 04/01/2024 07:03:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3909' AND id_document != '89391' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 04/01/2024 07:03:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3909', document_date = '2023-12-07', 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 = '83.53', price_tax_excluded = '79.38', date_upd = NOW() WHERE id_document = '89391' 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89391' 04/01/2024 07:03:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89391' 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '21915' , 'CI SPOSIAMO? - N. E. - L. FAGGIOLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '6629' , 'MIA PREGHIERA' , '5' , '-5' , '4' , '0.9000' , '0.9' , '0' , '0' , '4.50' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '3604' , 'DOCUMENTI DEL CONCILIO VATICANO II' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '3585' , 'DIVINA RIVELAZIONE' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '4842' , 'HUMANAE VITAE' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '6005' , 'LUMEN GENTIUM' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '9338' , 'SACROSANCTUM CONCILIUM' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '3433' , 'DIECI COMANDAMENTI' , '10' , '-10' , '4' , '0.2000' , '0.2' , '0' , '0' , '2.00' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 04/01/2024 07:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 04/01/2024 07:04:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '4063' AND id_document != '89581' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-19') 04/01/2024 07:04:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4063', document_date = '2023-12-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 = '88.11', price_tax_excluded = '82.70', date_upd = NOW() WHERE id_document = '89581' 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89581' 04/01/2024 07:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89581' 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '13888' , 'VI E STATO DETTO MA IO VI DICO - C. MILITELLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '21496' , 'PAROLA CHE RISANA - ANNO B - A. SANSONE' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '17314' , 'E SUBITO LO SEGUIRONO - ANNO B - A.M. CANOPI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '0.2' , '0.2' , '0' , '0' , '0.20' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '18032' , 'BRUCIAINCENSO H 11' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '40' , '-40' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '12.00' ) 04/01/2024 07:04:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89581' , '21920' , 'AMEN - MAR 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/01/2024 07:04:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3841' AND id_document != '89289' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 04/01/2024 07:04:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3841', document_date = '2023-12-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '39.59', date_upd = NOW() WHERE id_document = '89289' 04/01/2024 07:04: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 = '89289' 04/01/2024 07:04:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '89289' 04/01/2024 07:04: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 ( '89289' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 04/01/2024 07:04: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 ( '89289' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 04/01/2024 07:04: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 ( '89289' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/01/2024 07:04: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 ( '89289' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '4' , '-4' , '4' , '0.9' , '0.9' , '0' , '0' , '3.60' ) 04/01/2024 07:05:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3779' AND id_document != '89204' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 04/01/2024 07:05:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3779', document_date = '2023-11-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '60.00', date_upd = NOW() WHERE id_document = '89204' 04/01/2024 07:05:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89204' 04/01/2024 07:05:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '89204' 04/01/2024 07:05:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89204' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '9.6' , '9.6' , '0' , '0' , '9.60' ) 04/01/2024 07:05:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89204' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 04/01/2024 07:05:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89204' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 04/01/2024 07:05:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89204' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' )