19/06/2025 09:29:56 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 19/06/2025 09:29:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = 'ACCONTO: 13/06 € 283,50', 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 = '816.07', price_tax_excluded = '681.85', date_upd = NOW() WHERE id_document = '95409' 19/06/2025 09:29: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 = '95409' 19/06/2025 09:29:56 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 19/06/2025 09:29: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 ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 19/06/2025 09:29: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 ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29: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 ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 19/06/2025 09:29: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 ( '95409' , '0' , '27/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29: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 ( '95409' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 19/06/2025 09:29: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 ( '95409' , '0' , '26/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29: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 ( '95409' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/06/2025 09:29: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 ( '95409' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/06/2025 09:29: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 ( '95409' , '0' , '11/04' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29:57 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 ( '95409' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 19/06/2025 09:29:57 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 ( '95409' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/06/2025 09:29:57 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 ( '95409' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 19/06/2025 09:29:57 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 ( '95409' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3400' , '2.7377049180328' , '22' , '0' , '10.02' ) 19/06/2025 09:29:57 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 ( '95409' , '7202' , 'ARTICOLI RELIGIOSI buste palma' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 19/06/2025 09:29:57 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 ( '95409' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 19/06/2025 09:29:57 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 ( '95409' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 19/06/2025 09:29:57 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 ( '95409' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 19/06/2025 09:29:57 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 ( '95409' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '56.00' ) 19/06/2025 09:29:57 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 ( '95409' , '0' , '30/04/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29:57 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 ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 19/06/2025 09:29:57 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 ( '95409' , '0' , '24/05' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29:57 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 ( '95409' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/06/2025 09:29:57 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 ( '95409' , '0' , '4/6/25' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29:57 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 ( '95409' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 19/06/2025 09:29:57 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 ( '95409' , '15463' , 'PICCOLO CATECHISMO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 19/06/2025 09:29:57 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 ( '95409' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/06/2025 09:29:57 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 ( '95409' , '7202' , 'ARTICOLI RELIGIOSI PLACCA COMUNIONE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/06/2025 09:29:57 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 ( '95409' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '25' , '-25' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '55.00' ) 19/06/2025 09:29:57 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 ( '95409' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 19/06/2025 09:29:57 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 ( '95409' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 19/06/2025 09:29:57 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 ( '95409' , '0' , '06/06' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29:57 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 ( '95409' , '6019' , 'LUMINO ROSSO - 10B' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 19/06/2025 09:29:57 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 ( '95409' , '5312' , 'INNO ALLO SPIRITO SANTO' , '50' , '-50' , '4' , '0.2000' , '0.2' , '0' , '0' , '10.00' ) 19/06/2025 09:29:57 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 ( '95409' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 19/06/2025 09:29:57 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 ( '95409' , '0' , '14/06' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 09:29:57 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 ( '95409' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 19/06/2025 09:29:57 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 ( '95409' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 19/06/2025 09:29:57 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 ( '95409' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '10' , '-10' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '22.00' ) 19/06/2025 09:29:57 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 ( '95409' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 19/06/2025 09:29:57 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 ( '95409' , '' , '19/6/25' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 19/06/2025 09:29:57 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 ( '95409' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/06/2025 09:29:57 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 ( '95409' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/06/2025 10:18:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2171' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-19') 19/06/2025 10:18:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2171' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1400.00' , '1147.54' , NOW() , NOW() ) 19/06/2025 10:18:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97761' 19/06/2025 10:18:05 am >> DELETE FROM ps_document_detail WHERE id_document = '97761' 19/06/2025 10:18:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97761' , '7202' , 'casula' , '1' , '-1' , '1' , '1400' , '1147.5409836066' , '22' , '0' , '1400.00' ) 19/06/2025 10:22:28 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('2025-06-19') 19/06/2025 10:22:28 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' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.53' , '37.53' , NOW() , NOW() ) 19/06/2025 10:22:28 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 = '97762' 19/06/2025 10:22:28 am >> DELETE FROM ps_document_detail WHERE id_document = '97762' 19/06/2025 10:22:28 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 ( '97762' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 19/06/2025 10:22:28 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 ( '97762' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 19/06/2025 10:27:53 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('2025-06-19') 19/06/2025 10:27:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2173' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.71' , '22.71' , NOW() , NOW() ) 19/06/2025 10:27:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97763' 19/06/2025 10:27:53 am >> DELETE FROM ps_document_detail WHERE id_document = '97763' 19/06/2025 10:27:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97763' , '23567' , 'SEGRETO DI MIO FIGLIO - SALZANO/ACUTIS' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.96' ) 19/06/2025 10:27:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97763' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/06/2025 10:34:00 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('2025-06-19') 19/06/2025 10:34:00 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' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '129.00' , '115.53' , NOW() , NOW() ) 19/06/2025 10:34:00 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 = '97764' 19/06/2025 10:34:00 am >> DELETE FROM ps_document_detail WHERE id_document = '97764' 19/06/2025 10:34:00 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 ( '97764' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 19/06/2025 10:34:00 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 ( '97764' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 19/06/2025 10:34:00 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 ( '97764' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 19/06/2025 10:34:00 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 ( '97764' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '22.50' ) 19/06/2025 10:34:00 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 ( '97764' , '22199' , 'VINO LIQUOROSO ROSSO ' , '3' , '-3' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '22.50' ) 19/06/2025 10:34:00 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 ( '97764' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 19/06/2025 10:34:00 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 ( '97764' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 19/06/2025 10:34:00 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 ( '97764' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.5' , '7.5' , '0' , '0' , '7.50' ) 19/06/2025 10:38:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1686' AND id_document != '97205' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 19/06/2025 10:38:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1686', document_date = '2025-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '406.00', price_tax_excluded = '332.79', date_upd = NOW() WHERE id_document = '97205' 19/06/2025 10:38:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97205' 19/06/2025 10:38:42 am >> DELETE FROM ps_document_detail WHERE id_document = '97205' 19/06/2025 10:38:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97205' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 19/06/2025 10:38:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97205' , '22159' , 'CALICE NODO APOSTOLI - 756' , '1' , '-1' , '1' , '356' , '291.80327868852' , '22' , '0' , '356.00' ) 19/06/2025 10:41:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2168' AND id_document != '97758' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 19/06/2025 10:41:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2168', document_date = '2025-06-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '310.00', price_tax_excluded = '254.10', date_upd = NOW() WHERE id_document = '97758' 19/06/2025 10:41:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97758' 19/06/2025 10:41:11 am >> DELETE FROM ps_document_detail WHERE id_document = '97758' 19/06/2025 10:41:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97758' , '22159' , 'CALICE NODO APOSTOLI - 756' , '1' , '-1' , '1' , '310' , '254.09836065574' , '22' , '0' , '310.00' ) 19/06/2025 10:41:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1686' AND id_document != '97205' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 19/06/2025 10:41:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1686', document_date = '2025-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '406.00', price_tax_excluded = '332.79', date_upd = NOW() WHERE id_document = '97205' 19/06/2025 10:41:33 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 = '97205' 19/06/2025 10:41:33 am >> DELETE FROM ps_document_detail WHERE id_document = '97205' 19/06/2025 10:41:33 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 ( '97205' , '22160' , 'PISSIDE NODO APOSTOLI - 757' , '1' , '-1' , '1' , '406' , '332.7868852459' , '22' , '0' , '406.00' ) 19/06/2025 10:42:19 am >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '97503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-03') 19/06/2025 10:42:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '84/A', document_date = '2025-06-03', document_letter = 'A', id_customer = '177', id_supplier = '', id_address = '4670959', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'acconto € 50,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '97503' 19/06/2025 10:42:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97503' 19/06/2025 10:42:19 am >> DELETE FROM ps_document_detail WHERE id_document = '97503' 19/06/2025 10:42:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97503' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 19/06/2025 10:42:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97503' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 19/06/2025 11:25:08 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('2025-06-19') 19/06/2025 11:25:08 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' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.20' , '34.60' , NOW() , NOW() ) 19/06/2025 11:25:08 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 = '97765' 19/06/2025 11:25:08 am >> DELETE FROM ps_document_detail WHERE id_document = '97765' 19/06/2025 11:25:08 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 ( '97765' , '23625' , 'TESTIMONI DI SPERANZA - M. FRISINA - ' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 19/06/2025 11:25:08 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 ( '97765' , '23613' , 'TESTIMONI DI SPERANZA - SPARTITO' , '1' , '-1' , '3' , '20.90' , '20.096153846154' , '4' , '0' , '20.90' ) 19/06/2025 11:25:08 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 ( '97765' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.8' , '1.8' , '0' , '0' , '1.80' ) 19/06/2025 11:30:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2176' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-19') 19/06/2025 11:30:37 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' , '2176' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '71.48' , NOW() , NOW() ) 19/06/2025 11:30:37 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 = '97766' 19/06/2025 11:30:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97766' 19/06/2025 11:30:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97766' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '25' , '-25' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '55.00' ) 19/06/2025 11:30:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97766' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 19/06/2025 11:30:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97766' , '6019' , 'LUMINO ROSSO - 10B' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 19/06/2025 11:30:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97766' , '5312' , 'INNO ALLO SPIRITO SANTO' , '50' , '-50' , '4' , '0.20' , '0.2' , '0' , '0' , '10.00' ) 19/06/2025 11:36:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2177' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-19') 19/06/2025 11:36:08 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' , '2177' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 19/06/2025 11:36:08 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 = '97767' 19/06/2025 11:36:08 am >> DELETE FROM ps_document_detail WHERE id_document = '97767' 19/06/2025 11:36:08 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 ( '97767' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 19/06/2025 11:36:08 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 ( '97767' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 19/06/2025 11:38:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2178' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-19') 19/06/2025 11:38:16 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' , '2178' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.90' , '28.44' , NOW() , NOW() ) 19/06/2025 11:38:16 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 = '97768' 19/06/2025 11:38:16 am >> DELETE FROM ps_document_detail WHERE id_document = '97768' 19/06/2025 11:38:16 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 ( '97768' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 19/06/2025 11:38:16 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 ( '97768' , '23801' , 'MIA SPERANZA E IN TE - SPARTITO' , '1' , '-1' , '3' , '12.00' , '11.538461538462' , '4' , '0' , '12.00' ) 19/06/2025 11:42:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118310521' AND id_product != '23625' AND ean13 != '' 19/06/2025 11:42:07 am >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '8019118310521', date_upd = NOW() WHERE id_product = '23625' 19/06/2025 11:42:07 am >> UPDATE ps_product_lang SET name = 'TESTIMONI DI SPERANZA - M. FRISINA ', description = '' WHERE id_product = '23625' 19/06/2025 11:42:07 am >> UPDATE ps_product SET wholesale_price = '8.89', on_sale = '0', price = '12.7049' WHERE id_product = '23625' 19/06/2025 11:42:07 am >> UPDATE ps_product_shop SET wholesale_price = '8.89', price = '12.7049', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23625' 19/06/2025 11:42:07 am >> DELETE FROM ps_specific_price WHERE id_product = '23625' 19/06/2025 11:42:59 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 19/06/2025 11:42:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = 'ACCONTO: 13/06 € 283,50', 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 = '731.07', price_tax_excluded = '610.38', date_upd = NOW() WHERE id_document = '95409' 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95409' 19/06/2025 11:42:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '90.00' ) 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '9/3/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '27/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '0' , '26/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/06/2025 11:43:00 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 ( '95409' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/06/2025 11:43:00 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 ( '95409' , '0' , '11/04' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:43:00 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 ( '95409' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '145.00' ) 19/06/2025 11:43:00 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 ( '95409' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/06/2025 11:43:00 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 ( '95409' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 19/06/2025 11:43:00 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 ( '95409' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3400' , '2.7377049180328' , '22' , '0' , '10.02' ) 19/06/2025 11:43:00 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 ( '95409' , '7202' , 'ARTICOLI RELIGIOSI buste palma' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 19/06/2025 11:43:00 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 ( '95409' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 19/06/2025 11:43:00 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 ( '95409' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 19/06/2025 11:43:00 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 ( '95409' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 19/06/2025 11:43:00 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 ( '95409' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '56.00' ) 19/06/2025 11:43:00 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 ( '95409' , '0' , '30/04/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:43:00 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 ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 19/06/2025 11:43:00 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 ( '95409' , '0' , '24/05' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:43:00 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 ( '95409' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/06/2025 11:43:00 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 ( '95409' , '0' , '4/6/25' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:43:00 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 ( '95409' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 19/06/2025 11:43:00 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 ( '95409' , '15463' , 'PICCOLO CATECHISMO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 19/06/2025 11:43:00 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 ( '95409' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/06/2025 11:43:00 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 ( '95409' , '7202' , 'ARTICOLI RELIGIOSI PLACCA COMUNIONE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/06/2025 11:43:00 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 ( '95409' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 19/06/2025 11:43:00 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 ( '95409' , '0' , '06/06' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:43:00 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 ( '95409' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 19/06/2025 11:43:00 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 ( '95409' , '0' , '14/06' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:43:00 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 ( '95409' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 19/06/2025 11:43:00 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 ( '95409' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 19/06/2025 11:43:00 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 ( '95409' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '10' , '-10' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '22.00' ) 19/06/2025 11:43:00 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 ( '95409' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 19/06/2025 11:43:00 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 ( '95409' , '0' , '19/6/25' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 19/06/2025 11:43:00 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 ( '95409' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/06/2025 11:43:00 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 ( '95409' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/06/2025 11:52:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-19') 19/06/2025 11:52:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2179' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 19/06/2025 11:52:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97769' 19/06/2025 11:52:59 am >> DELETE FROM ps_document_detail WHERE id_document = '97769' 19/06/2025 11:52:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97769' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 19/06/2025 11:57:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002352' AND id_product != '23549' AND ean13 != '' 19/06/2025 11:57:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002352', date_upd = NOW() WHERE id_product = '23549' 19/06/2025 11:57:22 am >> UPDATE ps_product_lang SET name = 'STOLA CROCE - 860', description = '' WHERE id_product = '23549' 19/06/2025 11:57:22 am >> UPDATE ps_product SET wholesale_price = '42.00', on_sale = '0', price = '110.65573770491804' WHERE id_product = '23549' 19/06/2025 11:57:22 am >> UPDATE ps_product_shop SET wholesale_price = '42.00', price = '110.65573770491804', id_tax_rules_group = '1', id_category_default = '499', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23549' 19/06/2025 11:57:22 am >> DELETE FROM ps_specific_price WHERE id_product = '23549' 19/06/2025 04:00:13 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4223' 19/06/2025 04:00:13 pm >> UPDATE ps_stock_available SET quantity = quantity + '-34' WHERE id_product = '4223' 19/06/2025 04:00:28 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11858' 19/06/2025 04:00:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '-335' WHERE id_product = '11858' 19/06/2025 04:19:37 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('2025-06-19') 19/06/2025 04:19:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2180' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.50' , '47.50' , NOW() , NOW() ) 19/06/2025 04:19:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97770' 19/06/2025 04:19:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '97770' 19/06/2025 04:19: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 ( '97770' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '5' , '47.50' ) 19/06/2025 04:54:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-06-19') 19/06/2025 04:54:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '18' , '2025-06-19' , '' , '2939' , '0' , '4659156' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , 'RESA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '896.80' , '896.80' , NOW() , NOW() ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97771' 19/06/2025 04:54:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97771' 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '3910' , 'ESERCIZI SPIRITUALI DI SANTIGNAZIO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '4' , '-4' , '4' , '16.00' , '16' , '0' , '0' , '64.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23517' , 'PROCLAMERO LANNO DI GRAZIA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23060' , 'GIUBILEO DEI MALATI E DEI SOFFERENTI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23143' , 'CATECHISTI DI SPERANZA - F. VANNOTTI' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23208' , 'SPERANZA NELLA TRADIZIONE EBRAICA - AAVV' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23211' , 'VIVERE IL GIUBILEO - E. FORTUNATO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23361' , 'PERCORSI DEL GIUBILEO - L. FERRAIUOLO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '5' , '-5' , '4' , '2.90' , '2.9' , '0' , '0' , '14.50' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23292' , 'SPERANZA NON DELUDE - PAPA FRANCESCO' , '2' , '-2' , '4' , '17.90' , '17.9' , '0' , '0' , '35.80' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22171' , 'AMORE DI DIO E PER TUTTI - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23012' , 'COME GESU CI HA INSEGNATO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 19/06/2025 04:54:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23145' , 'SEI GRANDE! - PAPA FRANCESCO' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '0' , '28.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22766' , 'CONNESSI COL CIELO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23307' , 'AVETE FATTO A ME - E. BOLIS' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22172' , 'NEL GREMBO DELLA PAROLA - R. MANGOLINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23132' , 'RINASCERE - E. BIANCHI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23483' , 'INDAGINE SULLA MORTE DI GESU - S. LEONE' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '0' , '54.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22401' , 'CHRISTIAN DE CHERGE - C. SALENSON' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '0' , '32.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20476' , 'NON GUARDARE AI NOSTRI PECCATI - B.P. FLANAGAN' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '0' , '28.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20727' , 'RINNOVAMENTO E UNITA - K. KOCH' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '0' , '32.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20873' , 'SILENZIO DI DIO - M. STRIET' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20927' , 'FEDE SENZA VERITA - M. SEEWALD' , '1' , '-1' , '4' , '33.00' , '33' , '0' , '0' , '33.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22180' , 'LASCIATE CHE CRESCANO INSIEME - A. ANGENENDT' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '0' , '39.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20772' , 'VADO E TORNERO DA VOI - L. VOZZA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '20871' , 'NELLA STORIA ACCOMPAGNATI DA MARIA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '0' , '12.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23514' , 'TU SEI LA LUCE - A. COMASTRI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23457' , 'QUARESIMA 2025 GIORNO PER GIORNO' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '0' , '24.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23357' , 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA' , '7' , '-7' , '4' , '3.60' , '3.6' , '0' , '0' , '25.20' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22139' , 'TRAFITTI PER AMORE - SEREGNI/DI STEFANO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23356' , 'PAROLA E PREGHIERA - MAR 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23452' , 'TUTTO RICOMINCIA ' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '0' , '5.60' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23359' , 'SUSSIDIO DI QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23453' , 'COLPO DI SCENA' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '0' , '17.50' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22136' , 'PER DI QUA - BASTIA/RIMINITTI' , '2' , '-2' , '4' , '6.50' , '6.5' , '0' , '0' , '13.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23358' , 'MIO FIGLIO E TORNATO' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '0' , '3.80' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22687' , 'DARANNO ANCORA FRUTTI - AAVV' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '19544' , 'SENTIERI DI SINODALITA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '21172' , 'CAMMINARE INSIEME - L. FALLICA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '18688' , 'GLI ULTIMI CENTO GIORNI DI GESU - A. GINOTTA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23657' , 'DENTRO I VELI - AAVV' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23221' , 'CHE BELLA STORIA QUELLA DI GESU - P. VILLANUEVA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23438' , 'ANTIQUA ET NOVA' , '20' , '-20' , '4' , '2.00' , '2' , '0' , '0' , '40.00' ) 19/06/2025 04:54:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97771' , '23165' , 'DILEXIT NOS' , '20' , '-20' , '4' , '2.20' , '2.2' , '0' , '0' , '44.00' ) 19/06/2025 04:54:12 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('2025-06-19') 19/06/2025 04:54:13 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' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 19/06/2025 04:54:13 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 = '97772' 19/06/2025 04:54:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97772' 19/06/2025 04:54:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97772' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 19/06/2025 05:19:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '97771' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-06-19') 19/06/2025 05:19:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '18', document_date = '2025-06-19', document_letter = '', id_customer = '2939', id_supplier = '', id_address = '4659156', address1 = 'P.ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'RESA', 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 = '1276.00', price_tax_excluded = '1276.00', date_upd = NOW() WHERE id_document = '97771' 19/06/2025 05:19: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 = '97771' 19/06/2025 05:19:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97771' 19/06/2025 05:19: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 ( '97771' , '3910' , 'ESERCIZI SPIRITUALI DI SANTIGNAZIO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2025 05:19: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 ( '97771' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 19/06/2025 05:19: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 ( '97771' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '4' , '-4' , '4' , '16.0000' , '16' , '0' , '0' , '64.00' ) 19/06/2025 05:19: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 ( '97771' , '23517' , 'PROCLAMERO LANNO DI GRAZIA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 19/06/2025 05:19: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 ( '97771' , '23060' , 'GIUBILEO DEI MALATI E DEI SOFFERENTI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 19/06/2025 05:19: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 ( '97771' , '23143' , 'CATECHISTI DI SPERANZA - F. VANNOTTI' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2025 05:19: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 ( '97771' , '23208' , 'SPERANZA NELLA TRADIZIONE EBRAICA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 19/06/2025 05:19: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 ( '97771' , '23211' , 'VIVERE IL GIUBILEO - E. FORTUNATO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 19/06/2025 05:19: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 ( '97771' , '23361' , 'PERCORSI DEL GIUBILEO - L. FERRAIUOLO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 19/06/2025 05:19: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 ( '97771' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 19/06/2025 05:19: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 ( '97771' , '23292' , 'SPERANZA NON DELUDE - PAPA FRANCESCO' , '2' , '-2' , '4' , '17.9000' , '17.9' , '0' , '0' , '35.80' ) 19/06/2025 05:19: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 ( '97771' , '22171' , 'AMORE DI DIO E PER TUTTI - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/06/2025 05:19: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 ( '97771' , '23012' , 'COME GESU CI HA INSEGNATO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 19/06/2025 05:19: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 ( '97771' , '23145' , 'SEI GRANDE! - PAPA FRANCESCO' , '2' , '-2' , '4' , '14.0000' , '14' , '0' , '0' , '28.00' ) 19/06/2025 05:19: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 ( '97771' , '22766' , 'CONNESSI COL CIELO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 19/06/2025 05:19: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 ( '97771' , '23307' , 'AVETE FATTO A ME - E. BOLIS' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 19/06/2025 05:19: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 ( '97771' , '22172' , 'NEL GREMBO DELLA PAROLA - R. MANGOLINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/06/2025 05:19: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 ( '97771' , '23132' , 'RINASCERE - E. BIANCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/06/2025 05:19: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 ( '97771' , '23483' , 'INDAGINE SULLA MORTE DI GESU - S. LEONE' , '3' , '-3' , '4' , '18.0000' , '18' , '0' , '0' , '54.00' ) 19/06/2025 05:19: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 ( '97771' , '22401' , 'CHRISTIAN DE CHERGE - C. SALENSON' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '0' , '32.00' ) 19/06/2025 05:19: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 ( '97771' , '20476' , 'NON GUARDARE AI NOSTRI PECCATI - B.P. FLANAGAN' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 19/06/2025 05:19: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 ( '97771' , '20727' , 'RINNOVAMENTO E UNITA - K. KOCH' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '0' , '32.00' ) 19/06/2025 05:19: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 ( '97771' , '20873' , 'SILENZIO DI DIO - M. STRIET' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 19/06/2025 05:19: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 ( '97771' , '20927' , 'FEDE SENZA VERITA - M. SEEWALD' , '1' , '-1' , '4' , '33.0000' , '33' , '0' , '0' , '33.00' ) 19/06/2025 05:19: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 ( '97771' , '22180' , 'LASCIATE CHE CRESCANO INSIEME - A. ANGENENDT' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '0' , '39.00' ) 19/06/2025 05:19: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 ( '97771' , '20772' , 'VADO E TORNERO DA VOI - L. VOZZA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 19/06/2025 05:19: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 ( '97771' , '20871' , 'NELLA STORIA ACCOMPAGNATI DA MARIA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 19/06/2025 05:19: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 ( '97771' , '23514' , 'TU SEI LA LUCE - A. COMASTRI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 19/06/2025 05:19: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 ( '97771' , '23457' , 'QUARESIMA 2025 GIORNO PER GIORNO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 19/06/2025 05:19: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 ( '97771' , '23357' , 'QUARESIMA 2025 - ALLE SORGENTI DELLA SPERANZA' , '7' , '-7' , '4' , '3.6000' , '3.6' , '0' , '0' , '25.20' ) 19/06/2025 05:19: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 ( '97771' , '22139' , 'TRAFITTI PER AMORE - SEREGNI/DI STEFANO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 19/06/2025 05:19: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 ( '97771' , '23356' , 'PAROLA E PREGHIERA - MAR 25' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 19/06/2025 05:19: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 ( '97771' , '23452' , 'TUTTO RICOMINCIA ' , '2' , '-2' , '4' , '2.8000' , '2.8' , '0' , '0' , '5.60' ) 19/06/2025 05:19: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 ( '97771' , '23359' , 'SUSSIDIO DI QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 19/06/2025 05:19: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 ( '97771' , '23453' , 'COLPO DI SCENA' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '0' , '17.50' ) 19/06/2025 05:19: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 ( '97771' , '22136' , 'PER DI QUA - BASTIA/RIMINITTI' , '2' , '-2' , '4' , '6.5000' , '6.5' , '0' , '0' , '13.00' ) 19/06/2025 05:19: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 ( '97771' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 19/06/2025 05:19: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 ( '97771' , '23358' , 'MIO FIGLIO E TORNATO' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '0' , '3.80' ) 19/06/2025 05:19: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 ( '97771' , '22687' , 'DARANNO ANCORA FRUTTI - AAVV' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 19/06/2025 05:19: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 ( '97771' , '19544' , 'SENTIERI DI SINODALITA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/06/2025 05:19: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 ( '97771' , '21172' , 'CAMMINARE INSIEME - L. FALLICA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2025 05:19: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 ( '97771' , '18688' , 'GLI ULTIMI CENTO GIORNI DI GESU - A. GINOTTA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/06/2025 05:19: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 ( '97771' , '23657' , 'DENTRO I VELI - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 19/06/2025 05:19: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 ( '97771' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 19/06/2025 05:19: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 ( '97771' , '23221' , 'CHE BELLA STORIA QUELLA DI GESU - P. VILLANUEVA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 19/06/2025 05:19: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 ( '97771' , '23438' , 'ANTIQUA ET NOVA' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '0' , '40.00' ) 19/06/2025 05:19: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 ( '97771' , '23165' , 'DILEXIT NOS' , '20' , '-20' , '4' , '2.2000' , '2.2' , '0' , '0' , '44.00' ) 19/06/2025 05:19: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 ( '97771' , '22873' , 'COME ESSERE CHIESA SINODALE MISSIONARIA' , '9' , '-9' , '4' , '3.50' , '3.5' , '0' , '0' , '31.50' ) 19/06/2025 05:19: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 ( '97771' , '23169' , 'DILEXIT NOS ' , '19' , '-19' , '4' , '2.20' , '2.2' , '0' , '0' , '41.80' ) 19/06/2025 05:19: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 ( '97771' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 19/06/2025 05:19: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 ( '97771' , '23441' , 'ANTIQUA ET NOVA' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '0' , '7.80' ) 19/06/2025 05:19: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 ( '97771' , '22506' , 'DIGNITAS INFINITA' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '0' , '10.00' ) 19/06/2025 05:19: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 ( '97771' , '9011' , 'RITO DEL MATRIMONIO - RP29 - CONF 25 PZ' , '3' , '-3' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 19/06/2025 05:19: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 ( '97771' , '22351' , 'AMORE CELIBE - A. FUMAGALLI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 19/06/2025 05:19: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 ( '97771' , '22758' , 'PICCOLO LESSICO DEL FINE VITA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2025 05:19: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 ( '97771' , '1731' , 'CARO AMICO SANTO TI SCRIVO ...' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2025 05:19: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 ( '97771' , '22719' , '101 PENSIERI SU DIO - D. BONHOEFFER' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2025 05:19: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 ( '97771' , '21924' , '101 PENSIERI PER RESISTERE ALLODIO - E. HILLESUM' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2025 05:19: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 ( '97771' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2025 05:19: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 ( '97771' , '11412' , 'VITA AUTENTICA DEL CURATO DARS - CURATO DARS' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '0' , '24.00' ) 19/06/2025 05:19: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 ( '97771' , '20728' , 'OCCHI CHE SI APRONO' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '0' , '12.00' ) 19/06/2025 05:19: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 ( '97771' , '23493' , 'PAROLA E PREGHIERA - MAG 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/06/2025 05:19: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 ( '97771' , '23516' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 25' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 19/06/2025 05:19: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 ( '97771' , '21502' , 'SALMI PER PICCOLI CUORI' , '2' , '-2' , '4' , '4.90' , '4.9' , '0' , '0' , '9.80' ) 19/06/2025 05:19: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 ( '97771' , '13409' , 'MESSIA - LA MERAVIGLIOSA STORIA DI PASQUA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/06/2025 05:19: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 ( '97771' , '19540' , 'CRESIMA N.E.' , '4' , '-4' , '4' , '3.00' , '3' , '0' , '0' , '12.00' ) 19/06/2025 05:19: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 ( '97771' , '19538' , 'MESSA DEI FANCIULLI - N.E.' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '0' , '10.00' ) 19/06/2025 05:19: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 ( '97771' , '18727' , '10 COMANDAMENTI - P. QUATTRONE' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 19/06/2025 05:19: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 ( '97771' , '12053' , 'MIA CRESIMA CON PAPA FRANCESCO' , '10' , '-10' , '4' , '1.50' , '1.5' , '0' , '0' , '15.00' ) 19/06/2025 05:19: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 ( '97771' , '22450' , 'DIO E SEMPRE CON NOI' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 19/06/2025 05:19: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 ( '97771' , '19157' , 'GUASTI' , '1' , '-1' , '4' , '0' , '0' , '0' , '0' , '0.00' ) 19/06/2025 05:19: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 ( '97771' , '20778' , 'PASSIO N.E.' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 19/06/2025 05:19: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 ( '97771' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 19/06/2025 05:19: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 ( '97771' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '11' , '-11' , '4' , '2.00' , '2' , '0' , '0' , '22.00' ) 19/06/2025 05:45:12 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/06/2025 05:45:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23821' , '1' , '' , 'nuovo-prodotto' ) 19/06/2025 05:45:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23821' , '1' , '1' , '2' , NOW() , NOW() ) 19/06/2025 05:45:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23821' , '0' , '1' , '0' , '0' ) 19/06/2025 05:46:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002383' AND id_product != '19357' AND ean13 != '' 19/06/2025 05:46:08 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '002383', date_upd = NOW() WHERE id_product = '19357' 19/06/2025 05:46:08 pm >> UPDATE ps_product_lang SET name = 'DALMATICA ROSA - AEDA01', description = '' WHERE id_product = '19357' 19/06/2025 05:46:08 pm >> UPDATE ps_product SET wholesale_price = '38.00', on_sale = '0', price = '81.9672131147541' WHERE id_product = '19357' 19/06/2025 05:46:09 pm >> UPDATE ps_product_shop SET wholesale_price = '38.00', price = '81.9672131147541', id_tax_rules_group = '1', id_category_default = '441', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19357' 19/06/2025 05:46:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '19357' 19/06/2025 05:48: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 ( '33' , '532' , '2025-06-17' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '339.16' , '278.00' , NOW() , NOW() ) 19/06/2025 05:48: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 = '97773' 19/06/2025 05:48:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '97773' 19/06/2025 05:48: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 ( '97773' , '15833' , 'STOLA DIAC. - PST010' , '2' , '2' , '1' , '25' , '20.491803278689' , '22' , '0' , '61.0000' ) 19/06/2025 05:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15833' AND id_supplier = '122' 19/06/2025 05:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15833' , '122' , '1' ) 19/06/2025 05:48: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 ( '97773' , '23336' , 'DALMATICA - PDA004' , '1' , '1' , '1' , '41' , '33.606557377049' , '22' , '0' , '50.0200' ) 19/06/2025 05:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23336' AND id_supplier = '122' 19/06/2025 05:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23336' , '122' , '1' ) 19/06/2025 05:48: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 ( '97773' , '19357' , 'DALMATICA ROSA - AEDA01' , '1' , '1' , '1' , '42' , '34.426229508197' , '22' , '0' , '51.2400' ) 19/06/2025 05:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19357' AND id_supplier = '122' 19/06/2025 05:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19357' , '122' , '1' ) 19/06/2025 05:48: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 ( '97773' , '14926' , 'VESTINA BATTESIMALE' , '30' , '30' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '76.8600' ) 19/06/2025 05:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '122' 19/06/2025 05:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '122' , '1' ) 19/06/2025 05:48: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 ( '97773' , '23052' , 'DALMATICA MORELLO - PDA004' , '2' , '2' , '1' , '41' , '33.606557377049' , '22' , '0' , '100.0400' ) 19/06/2025 05:48:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23052' AND id_supplier = '122' 19/06/2025 05:48:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23052' , '122' , '1' ) 19/06/2025 06:42:04 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('2025-06-19') 19/06/2025 06:42:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2182' , '2025-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '122.00' , '100.00' , NOW() , NOW() ) 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97774' 19/06/2025 06:42:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '97774' 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '18080' , 'BAMBINO DI PRAGA CM 20 - 311' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '25' , '20.491803278689' , '22' , '0' , '50.00' ) 19/06/2025 06:42:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97774' , '17617' , 'IMMAGINI ISONZO X 100' , '10' , '-10' , '1' , '3' , '2.4590163934426' , '22' , '0' , '30.00' )