03/07/2024 09:11:14 am >> SELECT document_num FROM ps_document WHERE document_num = '77/A' AND id_document != '92279' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-13') 03/07/2024 09:11:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '77/A', document_date = '2024-06-13', document_letter = 'A', id_customer = '3432', id_supplier = '', id_address = '4670953', address1 = 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.80', price_tax_excluded = '17.05', date_upd = NOW() WHERE id_document = '92279' 03/07/2024 09:11:14 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 = '92279' 03/07/2024 09:11:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92279' 03/07/2024 09:11:14 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 ( '92279' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '16' , '-16' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '20.80' ) 03/07/2024 09:11:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1559' AND id_document != '91768' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-13') 03/07/2024 09:11:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1559', document_date = '2024-05-13', 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.00', price_tax_excluded = '9.02', date_upd = NOW() WHERE id_document = '91768' 03/07/2024 09:11:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91768' 03/07/2024 09:11:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91768' 03/07/2024 09:11:40 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 ( '91768' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 03/07/2024 09:11:40 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 ( '91768' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.7' , '7.1311475409836' , '22' , '0' , '8.70' ) 03/07/2024 09:11:40 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 ( '91768' , '14773' , 'BRACCIALE RIGATO - 0825N' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 03/07/2024 09:12:06 am >> SELECT document_num FROM ps_document WHERE document_num = '78/A' AND id_document != '92377' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-21') 03/07/2024 09:12:06 am >> UPDATE ps_document SET id_document_type = '24', document_num = '78/A', document_date = '2024-06-21', document_letter = 'A', id_customer = '3842', id_supplier = '', id_address = '4673208', address1 = 'VIA SAN LEONARDO 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '98.94', price_tax_excluded = '92.20', date_upd = NOW() WHERE id_document = '92377' 03/07/2024 09:12:06 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 = '92377' 03/07/2024 09:12:06 am >> DELETE FROM ps_document_detail WHERE id_document = '92377' 03/07/2024 09:12:06 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 ( '92377' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 03/07/2024 09:12:06 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 ( '92377' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '5' , '19.00' ) 03/07/2024 09:12:06 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 ( '92377' , '22712' , 'AMEN - OTT 24' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 03/07/2024 09:12:06 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 ( '92377' , '22713' , 'AMEN - SET 24' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 03/07/2024 09:12:06 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 ( '92377' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '3' , '-3' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '6.00' ) 03/07/2024 09:12:06 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 ( '92377' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '3' , '-3' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '3.30' ) 03/07/2024 09:12:06 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 ( '92377' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '7' , '-7' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '9.10' ) 03/07/2024 09:13:25 am >> UPDATE ps_document SET id_document_type = '31', document_num = '176', document_date = '2024-06-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670816', address1 = 'VIA G. BATTISTA VICO 73 80010 VILLARICCA', address2 = '', note = '', price_shipping = '8.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '297.32', price_tax_excluded = '243.71', date_upd = NOW() WHERE id_document = '92482' 03/07/2024 09:13:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92482' 03/07/2024 09:13:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92482' 03/07/2024 09:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92482' , '22508' , 'POLO PIQUET - M06' , '4' , '4' , '1' , '26.5' , '21.72131147541' , '22' , '5' , '122.8540' ) 03/07/2024 09:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92482' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '3' , '3' , '1' , '17.2000' , '14.098360655738' , '22' , '8' , '57.92' ) 03/07/2024 09:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92482' , '22732' , 'TUNICA CON SCAPOLARE - S12' , '2' , '2' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '63.44' ) 03/07/2024 09:13:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92482' , '21132' , 'CLERGY F/F MC - C03' , '2' , '2' , '1' , '18.9000' , '15.491803278689' , '22' , '6' , '43.35' ) 03/07/2024 10:46:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2172' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 10:46: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' , '2172' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 03/07/2024 10:46: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 = '92514' 03/07/2024 10:46:56 am >> DELETE FROM ps_document_detail WHERE id_document = '92514' 03/07/2024 10:46: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 ( '92514' , '13111' , 'FATIMA BABY - 023 FAT 9 BB' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 03/07/2024 10:46: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 ( '92514' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 03/07/2024 10:46: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 ( '92514' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 03/07/2024 10:46: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 ( '92514' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '51' , '41.803278688525' , '22' , '0' , '51.00' ) 03/07/2024 10:53:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 10:53:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2173' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 03/07/2024 10:53:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92515' 03/07/2024 10:53:07 am >> DELETE FROM ps_document_detail WHERE id_document = '92515' 03/07/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92515' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 03/07/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92515' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 03/07/2024 11:10:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2174' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 11:10:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2174' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.40' , '65.08' , NOW() , NOW() ) 03/07/2024 11:10:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92516' 03/07/2024 11:10:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92516' 03/07/2024 11:10:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92516' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/07/2024 11:10:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92516' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 03/07/2024 11:27:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2175' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 11:27:29 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' , '2175' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.40' , '0.33' , NOW() , NOW() ) 03/07/2024 11:27:29 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 = '92517' 03/07/2024 11:27:29 am >> DELETE FROM ps_document_detail WHERE id_document = '92517' 03/07/2024 11:27:29 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 ( '92517' , '16132' , 'DECINA IN METALLO - M0123' , '1' , '-1' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.40' ) 03/07/2024 11:45:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3590/00' , '2024-07-02' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'rientro fuori catalogo' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2064.20' , '2064.20' , NOW() , NOW() ) 03/07/2024 11:45:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92518' 03/07/2024 11:45:18 am >> DELETE FROM ps_document_detail WHERE id_document = '92518' 03/07/2024 11:45:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92518' , '12255' , 'IN CAMMINO CON GESU\'' , '218' , '218' , '4' , '3.80' , '3.8' , '0' , '0' , '828.4000' ) 03/07/2024 11:45:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92518' , '12253' , 'MIO LIBRO DI PREGHIERE' , '377' , '377' , '4' , '2.80' , '2.8' , '0' , '0' , '1055.6000' ) 03/07/2024 11:45:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92518' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '205' , '205' , '4' , '0.85' , '0.85' , '0' , '0' , '174.2500' ) 03/07/2024 11:45:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92518' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '7' , '7' , '4' , '0.85' , '0.85' , '0' , '0' , '5.9500' ) 03/07/2024 12:05:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '226/2024' , '2024-07-02' , '2024' , '0' , '130' , '4670548' , 'VIA CARRAIA,4/6/8 55025 COREGLIA ANTELMINELLI' , '' , '' , '20' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '232.32' , '190.43' , NOW() , NOW() ) 03/07/2024 12:05:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92519' 03/07/2024 12:05:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92519' 03/07/2024 12:05:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92519' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '3' , '3' , '1' , '32.4' , '26.55737704918' , '22' , '5' , '112.6548' ) 03/07/2024 12:05:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17400' AND id_supplier = '130' 03/07/2024 12:05:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17400' , '130' , '1' ) 03/07/2024 12:05:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92519' , '18615' , 'SAN ROCCO CM 20 - 340' , '1' , '1' , '1' , '12.6' , '10.327868852459' , '22' , '5' , '14.6034' ) 03/07/2024 12:05:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18615' AND id_supplier = '130' 03/07/2024 12:05:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18615' , '130' , '1' ) 03/07/2024 12:05:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92519' , '21787' , 'AUSILIATRICE CM 30 - 623' , '2' , '2' , '1' , '22.8' , '18.688524590164' , '22' , '5' , '52.8504' ) 03/07/2024 12:05:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21787' AND id_supplier = '130' 03/07/2024 12:05:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21787' , '130' , '1' ) 03/07/2024 12:05: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 ( '92519' , '17077' , 'IMMACOLATA DEL MURILLO CM 33 - 610' , '1' , '1' , '1' , '24' , '19.672131147541' , '22' , '5' , '27.8160' ) 03/07/2024 12:05:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17077' AND id_supplier = '130' 03/07/2024 12:05:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17077' , '130' , '1' ) 03/07/2024 12:07:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2176' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 12:07:54 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' , '2176' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.15' , '6.15' , NOW() , NOW() ) 03/07/2024 12:07:54 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 = '92520' 03/07/2024 12:07:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '92520' 03/07/2024 12:07: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 ( '92520' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 03/07/2024 12:07: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 ( '92520' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/07/2024 12:29:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2177' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 12:29:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2177' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 03/07/2024 12:29:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92521' 03/07/2024 12:29:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '92521' 03/07/2024 12:29:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92521' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.90' , '16.311475409836' , '22' , '0' , '19.90' ) 03/07/2024 12:29:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92521' , '20703' , 'QUADRETTO 30X15 - POSTO TRANQUILLO' , '1' , '-1' , '1' , '39.1' , '32.049180327869' , '22' , '0' , '39.10' ) 03/07/2024 12:30:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2178' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 12:30: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' , '2178' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 03/07/2024 12:30: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 = '92522' 03/07/2024 12:30:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92522' 03/07/2024 12:30: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 ( '92522' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/07/2024 03:47:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '28/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 03:47:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '28/E' , '2024-07-03' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GIUGNO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1204.55' , '1204.55' , NOW() , NOW() ) 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92523' 03/07/2024 03:47:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '92523' 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '2448' , 'COLUI IN CUI CREDO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '5457' , 'IO SONO CON VOI 1 PARTE' , '52' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '72.80' ) 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '5458' , 'IO SONO CON VOI 2 PARTE' , '50' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '70.00' ) 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '11191' , 'VENITE CON ME 1 PARTE' , '55' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '77.00' ) 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '11192' , 'VENITE CON ME 2 PARTE' , '55' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '77.00' ) 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '5251' , 'INCONTRI EUCARISTICI' , '6' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '13.50' ) 03/07/2024 03:47:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '4' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '6.80' ) 03/07/2024 03:47: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 ( '92523' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 03/07/2024 03:47: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 ( '92523' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 03/07/2024 03:47: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 ( '92523' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '1.70' ) 03/07/2024 03:47: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 ( '92523' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 03/07/2024 03:47: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 ( '92523' , '6629' , 'MIA PREGHIERA' , '26' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '11.70' ) 03/07/2024 03:47: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 ( '92523' , '8408' , 'PRENDETE E MANGIATE' , '11' , '0' , '4' , '3.00' , '3' , '0' , '50' , '16.50' ) 03/07/2024 03:47: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 ( '92523' , '4154' , 'FESTA DEL PERDONO' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 03/07/2024 03:47: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 ( '92523' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '4' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '17.00' ) 03/07/2024 03:47: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 ( '92523' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 03/07/2024 03:47: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 ( '92523' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '8' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '6.40' ) 03/07/2024 03:47: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 ( '92523' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '0' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 03/07/2024 03:47: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 ( '92523' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '5' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '4.00' ) 03/07/2024 03:47: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 ( '92523' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 03/07/2024 03:47: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 ( '92523' , '12813' , 'MARIA MADRE NOSTRA' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 03/07/2024 03:47: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 ( '92523' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/07/2024 03:47: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 ( '92523' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '10' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '17.50' ) 03/07/2024 03:47: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 ( '92523' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '221' , '0' , '4' , '1.00' , '1' , '0' , '50' , '110.50' ) 03/07/2024 03:47: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 ( '92523' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '0.80' ) 03/07/2024 03:47: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 ( '92523' , '15020' , 'PREGARE OGNI GIORNO' , '36' , '0' , '4' , '1.00' , '1' , '0' , '50' , '18.00' ) 03/07/2024 03:47: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 ( '92523' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 03/07/2024 03:47: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 ( '92523' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '49' , '0' , '4' , '1.00' , '1' , '0' , '50' , '24.50' ) 03/07/2024 03:47: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 ( '92523' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 03/07/2024 03:47: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 ( '92523' , '16667' , 'VIA CRUCIS' , '10' , '0' , '4' , '3.00' , '3' , '0' , '50' , '15.00' ) 03/07/2024 03:47: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 ( '92523' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '2' , '0' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 03/07/2024 03:47: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 ( '92523' , '17257' , 'IO TI BATTEZZO ' , '60' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '54.00' ) 03/07/2024 03:47: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 ( '92523' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 03/07/2024 03:47: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 ( '92523' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '14' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '33.60' ) 03/07/2024 03:47: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 ( '92523' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '8' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '7.60' ) 03/07/2024 03:47: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 ( '92523' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 03/07/2024 03:47: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 ( '92523' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '2' , '0' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 03/07/2024 03:47: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 ( '92523' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 03/07/2024 03:47: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 ( '92523' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '3' , '0' , '4' , '7.00' , '7' , '0' , '50' , '10.50' ) 03/07/2024 03:47: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 ( '92523' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 03/07/2024 03:47: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 ( '92523' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 03/07/2024 03:47: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 ( '92523' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 03/07/2024 03:47: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 ( '92523' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.00' , '35' , '0' , '50' , '17.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20719' , 'CORONA DELL’ADDOLORATA' , '5' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '27' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '60.75' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '14' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '3' , '0' , '4' , '25.00' , '25' , '0' , '50' , '37.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '15' , '0' , '4' , '3.00' , '3' , '0' , '50' , '22.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '28' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '35.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '11' , '0' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '10' , '0' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '12' , '0' , '4' , '10.00' , '10' , '0' , '50' , '60.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '5' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '7.00' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '9' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '12.60' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '11' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 03/07/2024 03:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92523' , '22152' , 'A TE RICORRIAMO' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 03/07/2024 04:01:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '29/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 04:01:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '29/E' , '2024-07-03' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GIUGNO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1149.75' , '1149.75' , NOW() , NOW() ) 03/07/2024 04:01:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92524' 03/07/2024 04:01:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '92524' 03/07/2024 04:01:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '21' , '21' , '4' , '2.40' , '2.4' , '0' , '50' , '25.20' ) 03/07/2024 04:01:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 03/07/2024 04:01:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 03/07/2024 04:01:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '9675' , 'SARETE MIEI TESTIMONI' , '54' , '54' , '4' , '3.50' , '3.5' , '0' , '50' , '94.50' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '5457' , 'IO SONO CON VOI 1 PARTE' , '29' , '29' , '4' , '2.80' , '2.8' , '0' , '50' , '40.60' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '5458' , 'IO SONO CON VOI 2 PARTE' , '29' , '29' , '4' , '2.80' , '2.8' , '0' , '50' , '40.60' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '11191' , 'VENITE CON ME 1 PARTE' , '73' , '73' , '4' , '2.80' , '2.8' , '0' , '50' , '102.20' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '11192' , 'VENITE CON ME 2 PARTE' , '59' , '59' , '4' , '2.80' , '2.8' , '0' , '50' , '82.60' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '3443' , 'DIECI PAROLE DAMORE' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '20' , '20' , '4' , '3.40' , '3.4' , '0' , '50' , '34.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '4' , '4' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '5' , '5' , '4' , '8.00' , '8' , '0' , '50' , '20.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8408' , 'PRENDETE E MANGIATE' , '18' , '18' , '4' , '3.00' , '3' , '0' , '50' , '27.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8710' , 'QUANDO PREGATE DITE...' , '1' , '1' , '4' , '2.40' , '2.4' , '0' , '50' , '1.20' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '4154' , 'FESTA DEL PERDONO' , '19' , '19' , '4' , '3.00' , '3' , '0' , '50' , '28.50' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '2679' , 'CONOSCERE GESU' , '37' , '37' , '4' , '3.50' , '3.5' , '0' , '50' , '64.75' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '2680' , 'CONOSCERE GESU - GUIDA' , '4' , '4' , '4' , '6.00' , '6' , '0' , '50' , '12.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '5' , '5' , '4' , '8.00' , '8' , '0' , '50' , '20.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '6' , '6' , '4' , '6.00' , '6' , '0' , '50' , '18.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '12' , '12' , '4' , '1.00' , '1' , '0' , '50' , '6.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '10' , '10' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '16667' , 'VIA CRUCIS' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '17582' , 'SAN CESARE DE BUS' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '18036' , 'FERITE FERITOIE ' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 03/07/2024 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92524' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 03/07/2024 04:01: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 ( '92524' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '13' , '13' , '4' , '1.50' , '1.5' , '0' , '50' , '9.75' ) 03/07/2024 04:01: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 ( '92524' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '1' , '4' , '7.00' , '7' , '0' , '50' , '3.50' ) 03/07/2024 04:01: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 ( '92524' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 03/07/2024 04:01: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 ( '92524' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 03/07/2024 04:01: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 ( '92524' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 03/07/2024 04:01: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 ( '92524' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 03/07/2024 04:01: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 ( '92524' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '6' , '6' , '4' , '4.50' , '4.5' , '0' , '50' , '13.50' ) 03/07/2024 04:01: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 ( '92524' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 03/07/2024 04:01: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 ( '92524' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '29' , '29' , '4' , '2.50' , '2.5' , '0' , '50' , '36.25' ) 03/07/2024 04:01: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 ( '92524' , '20719' , 'CORONA DELL’ADDOLORATA' , '4' , '4' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 03/07/2024 04:01: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 ( '92524' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '15' , '15' , '4' , '2.00' , '2' , '0' , '50' , '15.00' ) 03/07/2024 04:01: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 ( '92524' , '20721' , 'AVE MARIA - L. CALABRETTA' , '3' , '3' , '4' , '4.50' , '4.5' , '0' , '50' , '6.75' ) 03/07/2024 04:01: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 ( '92524' , '20722' , 'SEMINATORI DI GIOIA' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 03/07/2024 04:01: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 ( '92524' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 03/07/2024 04:01: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 ( '92524' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 03/07/2024 04:01: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 ( '92524' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 03/07/2024 04:01: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 ( '92524' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '20' , '20' , '4' , '2.50' , '2.5' , '0' , '50' , '25.00' ) 03/07/2024 04:01: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 ( '92524' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '16' , '16' , '4' , '10.00' , '10' , '0' , '50' , '80.00' ) 03/07/2024 04:01: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 ( '92524' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 03/07/2024 04:01: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 ( '92524' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 03/07/2024 04:01: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 ( '92524' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '51' , '51' , '4' , '2.50' , '2.5' , '0' , '50' , '63.75' ) 03/07/2024 04:01: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 ( '92524' , '22151' , 'MA DIO LO HA RISUSCITATO' , '13' , '13' , '4' , '10.00' , '10' , '0' , '50' , '65.00' ) 03/07/2024 04:01: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 ( '92524' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 03/07/2024 04:01: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 ( '92524' , '22152' , 'A TE RICORRIAMO' , '7' , '7' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 03/07/2024 04:01: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 ( '92524' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 03/07/2024 04:10:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 04:10:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '13/S' , '2024-07-03' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GIUGNO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '331.50' , '331.50' , NOW() , NOW() ) 03/07/2024 04:10:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14735' 03/07/2024 04:10:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '14735' 03/07/2024 04:10:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14735' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 03/07/2024 04:10:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14735' , '20' , 'GIOVEDÌ SANTO' , '7' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '5.25' ) 03/07/2024 04:10:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14735' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '1' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 03/07/2024 04:10: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 ( '14735' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '26' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '19.50' ) 03/07/2024 04:10: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 ( '14735' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 03/07/2024 04:10: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 ( '14735' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '11' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 03/07/2024 04:10: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 ( '14735' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '11' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 03/07/2024 04:10: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 ( '14735' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '3.75' ) 03/07/2024 04:10: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 ( '14735' , '34' , 'LE MIE PREGHIERINE' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 03/07/2024 04:10: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 ( '14735' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 03/07/2024 04:10: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 ( '14735' , '46' , 'LE LETTERE DI SAN PAOLO' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 03/07/2024 04:10: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 ( '14735' , '50' , 'PERDONAMI SIGNORE' , '21' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '26.25' ) 03/07/2024 04:10: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 ( '14735' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 03/07/2024 04:10: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 ( '14735' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 03/07/2024 04:10: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 ( '14735' , '88' , 'GESÙ È RISORTO' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 03/07/2024 04:10: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 ( '14735' , '92' , 'LA PREGHIERA DEL ROSARIO' , '38' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '47.50' ) 03/07/2024 04:10: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 ( '14735' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 03/07/2024 04:10: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 ( '14735' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 03/07/2024 04:10: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 ( '14735' , '104' , 'TEMPO DI QUARESIMA' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/07/2024 04:10: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 ( '14735' , '110' , 'SE MI AMI NON PIANGERE' , '17' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '15.30' ) 03/07/2024 04:10: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 ( '14735' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '0' , '4' , '4.00' , '4' , '0' , '50' , '2.00' ) 03/07/2024 04:10: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 ( '14735' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/07/2024 04:10: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 ( '14735' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 03/07/2024 04:10: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 ( '14735' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 03/07/2024 04:10: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 ( '14735' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '0' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 03/07/2024 04:10: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 ( '14735' , '138' , 'LA NASCITA DI GESU' , '59' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '73.75' ) 03/07/2024 04:10: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 ( '14735' , '139' , 'E NATO - n.e.' , '17' , '0' , '4' , '2.00' , '2' , '0' , '50' , '17.00' ) 03/07/2024 04:10: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 ( '14735' , '136' , 'ANGELO DI DIO N.E.' , '22' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '19.80' ) 03/07/2024 04:10:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14735' , '137' , 'AVVENTO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 03/07/2024 04:10:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14735' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 03/07/2024 04:14:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 04:14: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 ( '25' , '14/S' , '2024-07-03' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GIUGNO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.30' , '116.30' , NOW() , NOW() ) 03/07/2024 04:14: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 = '14736' 03/07/2024 04:14:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '14736' 03/07/2024 04:14: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 ( '14736' , '17' , 'LA FEDE NELLO ZAINETTO' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 03/07/2024 04:14: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 ( '14736' , '20' , 'GIOVEDÌ SANTO' , '6' , '6' , '4' , '1.50' , '1.5' , '0' , '50' , '4.50' ) 03/07/2024 04:14: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 ( '14736' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 03/07/2024 04:14: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 ( '14736' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 03/07/2024 04:14: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 ( '14736' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 03/07/2024 04:14: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 ( '14736' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '1' , '4' , '7.50' , '7.5' , '0' , '50' , '3.75' ) 03/07/2024 04:14: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 ( '14736' , '52' , 'Il Padre Nostro spiegato ai bambini' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 03/07/2024 04:14: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 ( '14736' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '17' , '17' , '4' , '2.00' , '2' , '0' , '50' , '17.00' ) 03/07/2024 04:14: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 ( '14736' , '74' , 'DIO È , IN DIECI PAROLE' , '2' , '2' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 03/07/2024 04:14: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 ( '14736' , '75' , 'IL SEGNO DELLA CROCE' , '4' , '4' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 03/07/2024 04:14: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 ( '14736' , '88' , 'GESÙ È RISORTO' , '5' , '5' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 03/07/2024 04:14: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 ( '14736' , '104' , 'TEMPO DI QUARESIMA' , '15' , '15' , '4' , '2.50' , '2.5' , '0' , '50' , '18.75' ) 03/07/2024 04:14: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 ( '14736' , '110' , 'SE MI AMI NON PIANGERE' , '2' , '2' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 03/07/2024 04:14: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 ( '14736' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 03/07/2024 04:14: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 ( '14736' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '4' , '4' , '4' , '18.00' , '18' , '0' , '50' , '36.00' ) 03/07/2024 04:14: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 ( '14736' , '136' , 'ANGELO DI DIO N.E.' , '5' , '5' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 03/07/2024 04:28:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 04:28:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2179' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.30' , '9.26' , NOW() , NOW() ) 03/07/2024 04:28: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 = '92525' 03/07/2024 04:28:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92525' 03/07/2024 04:28: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 ( '92525' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 03/07/2024 04:28: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 ( '92525' , '18133' , 'CROCE SAN BENEDETTO CM 11 - CSB2' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 03/07/2024 05:11:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2180' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 05:11:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2180' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 03/07/2024 05:11:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92526' 03/07/2024 05:11:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '92526' 03/07/2024 05:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92526' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/07/2024 05:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92526' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/07/2024 05:25:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 05:25:17 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' , '2181' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 03/07/2024 05:25:17 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 = '92527' 03/07/2024 05:25:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '92527' 03/07/2024 05:25:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92527' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 03/07/2024 05:47:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 05:47:11 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' , '2182' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 03/07/2024 05:47:11 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 = '92528' 03/07/2024 05:47:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '92528' 03/07/2024 05:47:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92528' , '21787' , 'AUSILIATRICE CM 30 - 623' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 03/07/2024 05:48:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 05:48:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2183' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '2.40' , NOW() , NOW() ) 03/07/2024 05:48: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 = '92529' 03/07/2024 05:48:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '92529' 03/07/2024 05:48: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 ( '92529' , '22698' , 'CALENDARIO LITURGICO 2025' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 03/07/2024 05:52:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2184' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 05:52:05 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' , '2184' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 03/07/2024 05:52:05 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 = '92530' 03/07/2024 05:52:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92530' 03/07/2024 05:52:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92530' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '43' , '35.245901639344' , '22' , '0' , '43.00' ) 03/07/2024 05:57:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1900' AND id_document != '92189' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-06') 03/07/2024 05:57:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1900', document_date = '2024-06-06', 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.30', price_tax_excluded = '1.30', date_upd = NOW() WHERE id_document = '92189' 03/07/2024 05:57:20 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 = '92189' 03/07/2024 05:57:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92189' 03/07/2024 05:57:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92189' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.65' , '0.65' , '0' , '0' , '1.30' ) 03/07/2024 05:57:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1921' AND id_document != '92218' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-08') 03/07/2024 05:57:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1921', document_date = '2024-06-08', 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 = '100.73', price_tax_excluded = '100.73', date_upd = NOW() WHERE id_document = '92218' 03/07/2024 05:57: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 = '92218' 03/07/2024 05:57:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92218' 03/07/2024 05:57: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 ( '92218' , '475' , 'AMICO GESÙ - FIGURINE' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '10' , '0.45' ) 03/07/2024 05:57: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 ( '92218' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '-1' , '4' , '99.0000' , '99' , '0' , '5' , '94.05' ) 03/07/2024 05:57:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92218' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 03/07/2024 05:57:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92218' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '5' , '3.23' ) 03/07/2024 05:57:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1951' AND id_document != '92251' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 03/07/2024 05:57:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1951', document_date = '2024-06-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.14', price_tax_excluded = '16.14', date_upd = NOW() WHERE id_document = '92251' 03/07/2024 05:57:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92251' 03/07/2024 05:57:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92251' 03/07/2024 05:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92251' , '22476' , 'AMEN - AGO 2024' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 03/07/2024 05:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92251' , '22475' , 'AMEN - LUG. 2024' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 03/07/2024 05:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92251' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '0.65' , '0.65' , '0' , '0' , '1.30' ) 03/07/2024 05:58:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1974' AND id_document != '92278' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-13') 03/07/2024 05:58:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1974', document_date = '2024-06-13', 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 = '50.00', price_tax_excluded = '47.11', date_upd = NOW() WHERE id_document = '92278' 03/07/2024 05:58:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92278' 03/07/2024 05:58:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '92278' 03/07/2024 05:58: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 ( '92278' , '9506' , 'SAN PIO- 781-5 TMD ' , '1' , '-1' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '2.80' ) 03/07/2024 05:58: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 ( '92278' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.2' , '3.2' , '0' , '0' , '6.40' ) 03/07/2024 05:58: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 ( '92278' , '20905' , 'PADRE PIO STORIA DEL SANTO - A. TORNIELLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 03/07/2024 05:58: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 ( '92278' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 03/07/2024 05:58: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 ( '92278' , '22584' , 'CATENINA DORATA CON CROCE - WKSS-0136G' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 03/07/2024 05:58: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 ( '92278' , '22475' , 'AMEN - LUG 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 03/07/2024 05:58: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 ( '92278' , '22476' , 'AMEN - AGO 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 03/07/2024 05:58: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 ( '92278' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 03/07/2024 05:58: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 ( '92278' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 03/07/2024 05:58:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1995' AND id_document != '92300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-14') 03/07/2024 05:58:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1995', document_date = '2024-06-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 = '16.15', price_tax_excluded = '16.15', date_upd = NOW() WHERE id_document = '92300' 03/07/2024 05:58: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 = '92300' 03/07/2024 05:58:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '92300' 03/07/2024 05:58: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 ( '92300' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 03/07/2024 05:58: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 ( '92300' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 03/07/2024 05:58: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 ( '92300' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 03/07/2024 05:58: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 ( '92300' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 03/07/2024 05:59:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1978' AND id_document != '92283' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-14') 03/07/2024 05:59:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1978', document_date = '2024-06-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 = '7.95', price_tax_excluded = '7.95', date_upd = NOW() WHERE id_document = '92283' 03/07/2024 05:59:17 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 = '92283' 03/07/2024 05:59:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '92283' 03/07/2024 05:59:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92283' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 03/07/2024 05:59:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92283' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '0.65' , '0.65' , '0' , '0' , '1.30' ) 03/07/2024 05:59:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2074' AND id_document != '92396' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-25') 03/07/2024 05:59:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2074', document_date = '2024-06-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 = '25.46', price_tax_excluded = '25.46', date_upd = NOW() WHERE id_document = '92396' 03/07/2024 05:59: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 = '92396' 03/07/2024 05:59:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92396' 03/07/2024 05:59: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 ( '92396' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 03/07/2024 05:59: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 ( '92396' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 03/07/2024 05:59: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 ( '92396' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 03/07/2024 05:59: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 ( '92396' , '12600' , 'SUL MALE - J. HERNANDEZ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 03/07/2024 05:59: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 ( '92396' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 03/07/2024 05:59:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2096' AND id_document != '92420' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 03/07/2024 05:59:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2096', document_date = '2024-06-26', 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 = '19.25', price_tax_excluded = '19.25', date_upd = NOW() WHERE id_document = '92420' 03/07/2024 05:59: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 = '92420' 03/07/2024 05:59:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '92420' 03/07/2024 05:59: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 ( '92420' , '21470' , 'UN GIORNO UNA PAROLA 2024' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 03/07/2024 05:59: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 ( '92420' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 03/07/2024 07:42:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2185' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 07:42:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2185' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 03/07/2024 07:42:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92531' 03/07/2024 07:42:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '92531' 03/07/2024 07:42:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92531' , '22732' , 'TUNICA CON SCAPOLARE - S12' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 03/07/2024 07:46:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2186' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 03/07/2024 07:46: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' , '2186' , '2024-07-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 03/07/2024 07:46: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 = '92532' 03/07/2024 07:46:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92532' 03/07/2024 07:46: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 ( '92532' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' )