31/10/2025 08:56:31 am >> SELECT document_num FROM ps_document WHERE document_num = '179' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 08:56:31 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 ( '21' , '179' , '2025-10-31' , '' , '3475' , '0' , '4679568' , 'VIA DEL DUCA 89 52045 FOIANO DELLA CHIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '33.82' , '33.82' , NOW() , NOW() ) 31/10/2025 08:56:31 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 = '99589' 31/10/2025 08:56:31 am >> DELETE FROM ps_document_detail WHERE id_document = '99589' 31/10/2025 08:56:31 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 ( '99589' , '16094' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '5' , '3.80' ) 31/10/2025 08:56:31 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 ( '99589' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '5' , '2.85' ) 31/10/2025 08:56:31 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 ( '99589' , '15743' , 'PREGHIERA DEL ROSARIO' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 31/10/2025 08:56:31 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 ( '99589' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 31/10/2025 08:56:31 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 ( '99589' , '17034' , 'SACRAMENTO DEL PERDONO' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '5' , '3.80' ) 31/10/2025 08:56:31 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 ( '99589' , '15318' , 'PERDONAMI SIGNORE ' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 31/10/2025 08:56:31 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 ( '99589' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 31/10/2025 08:56:31 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 ( '99589' , '15317' , 'LA COMUNIONE SPIEGATA AI RAGAZZI' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '5' , '3.42' ) 31/10/2025 09:36:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3596' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 09:36: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' , '3596' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '6.00' , NOW() , NOW() ) 31/10/2025 09:36: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 = '99590' 31/10/2025 09:36:00 am >> DELETE FROM ps_document_detail WHERE id_document = '99590' 31/10/2025 09:36: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 ( '99590' , '18012' , 'NOVENA AL SACRO CUORE DI GESU - 8020' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 31/10/2025 09:36: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 ( '99590' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 31/10/2025 09:42:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3597' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 09:42:33 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' , '3597' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 31/10/2025 09:42: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 = '99591' 31/10/2025 09:42:33 am >> DELETE FROM ps_document_detail WHERE id_document = '99591' 31/10/2025 09:42: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 ( '99591' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 31/10/2025 09:57:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3598' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 09:57:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3598' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.40' , '185.34' , NOW() , NOW() ) 31/10/2025 09:57:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99592' 31/10/2025 09:57:35 am >> DELETE FROM ps_document_detail WHERE id_document = '99592' 31/10/2025 09:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99592' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '10' , '-10' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '25.00' ) 31/10/2025 09:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99592' , '17958' , 'TELA 50X70 - 2967' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 31/10/2025 09:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99592' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 31/10/2025 09:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99592' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 31/10/2025 09:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99592' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 31/10/2025 09:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99592' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 31/10/2025 10:03:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3599' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 10:03:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3599' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 31/10/2025 10:03:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99593' 31/10/2025 10:03:35 am >> DELETE FROM ps_document_detail WHERE id_document = '99593' 31/10/2025 10:03:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99593' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 31/10/2025 10:14:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 10:14:13 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' , '3600' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.80' , '21.50' , NOW() , NOW() ) 31/10/2025 10:14:13 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 = '99594' 31/10/2025 10:14:13 am >> DELETE FROM ps_document_detail WHERE id_document = '99594' 31/10/2025 10:14:13 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 ( '99594' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 31/10/2025 10:14:13 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 ( '99594' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.5' , '6.5' , '0' , '0' , '6.50' ) 31/10/2025 10:14:13 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 ( '99594' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '3.00' ) 31/10/2025 10:14:13 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 ( '99594' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '4' , '-4' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '4.80' ) 31/10/2025 10:20:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3601' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 10:20:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3601' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '212.30' , '179.97' , NOW() , NOW() ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99595' 31/10/2025 10:20:07 am >> DELETE FROM ps_document_detail WHERE id_document = '99595' 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '24032' , 'BUSTINA CON MEDAGLIA C. ACUTIS - A101' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '' , '10.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 31/10/2025 10:20:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99595' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/10/2025 10:23:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3501' AND id_document != '99462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 31/10/2025 10:23:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3501', document_date = '2025-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.20', price_tax_excluded = '12.46', date_upd = NOW() WHERE id_document = '99462' 31/10/2025 10:23: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 = '99462' 31/10/2025 10:23:28 am >> DELETE FROM ps_document_detail WHERE id_document = '99462' 31/10/2025 10:23:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99462' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 31/10/2025 10:23:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99462' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '1.90' ) 31/10/2025 10:23:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99462' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 31/10/2025 10:31:11 am >> SELECT document_num FROM ps_document WHERE document_num = '180' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 10:31:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '180' , '2025-10-31' , '' , '1155' , '0' , '4672061' , 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.79' , '167.79' , NOW() , NOW() ) 31/10/2025 10:31: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 = '99596' 31/10/2025 10:31:11 am >> DELETE FROM ps_document_detail WHERE id_document = '99596' 31/10/2025 10:31: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 ( '99596' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 31/10/2025 10:31: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 ( '99596' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.80' , '2.8' , '0' , '15' , '59.50' ) 31/10/2025 10:31: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 ( '99596' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 31/10/2025 10:31: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 ( '99596' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 31/10/2025 10:32:09 am >> SELECT document_num FROM ps_document WHERE document_num = '180' AND id_document != '99596' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 10:32:09 am >> UPDATE ps_document SET id_document_type = '21', document_num = '180', document_date = '2025-10-31', document_letter = '', id_customer = '1155', id_supplier = '', id_address = '4672061', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '167.79', price_tax_excluded = '167.79', date_upd = NOW() WHERE id_document = '99596' 31/10/2025 10:32:09 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 = '99596' 31/10/2025 10:32:09 am >> DELETE FROM ps_document_detail WHERE id_document = '99596' 31/10/2025 10:32:09 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 ( '99596' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '15' , '2.38' ) 31/10/2025 10:32:09 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 ( '99596' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.8000' , '2.8' , '0' , '15' , '59.50' ) 31/10/2025 10:32:09 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 ( '99596' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.8000' , '2.8' , '0' , '15' , '16.66' ) 31/10/2025 10:32:09 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 ( '99596' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 31/10/2025 10:42:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 10:42:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3602' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '19.26' , NOW() , NOW() ) 31/10/2025 10:42: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 = '99597' 31/10/2025 10:42:56 am >> DELETE FROM ps_document_detail WHERE id_document = '99597' 31/10/2025 10:42: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 ( '99597' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/10/2025 10:42: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 ( '99597' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 31/10/2025 10:55:00 am >> SELECT document_num FROM ps_document WHERE document_num = '131/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 10:55: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 ( '24' , '131/A' , '2025-10-31' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '17.66' , NOW() , NOW() ) 31/10/2025 10:55: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 = '99598' 31/10/2025 10:55:00 am >> DELETE FROM ps_document_detail WHERE id_document = '99598' 31/10/2025 10:55: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 ( '99598' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 31/10/2025 10:55: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 ( '99598' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '0' , '7.00' ) 31/10/2025 11:26:11 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3152' 31/10/2025 11:26:11 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3152' , '10' , '217' , 'PARROCCHIA S. DONATO MARTIRE' , 'COCOMAZZI' , 'DON MICHELE' , 'L.GO GARIBALDI 5' , '' , '64034' , 'CASTIGLIONE MESSER RAIMONDO' , '' , '' , '3776831707' , '' , '92001770673' , NOW() , NOW() ) 31/10/2025 11:26:11 am >> UPDATE ps_customer SET email = 'cocomazzim@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3152' 31/10/2025 11:31:40 am >> SELECT document_num FROM ps_document WHERE document_num = '181' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 11:31:40 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 ( '21' , '181' , '2025-10-31' , '' , '3152' , '0' , '4670974' , 'L.GO GARIBALDI, 5 64034 CASTIGLIONE MESSER RAIMONDO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '320.80' , '320.80' , NOW() , NOW() ) 31/10/2025 11:31:40 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 = '99599' 31/10/2025 11:31:40 am >> DELETE FROM ps_document_detail WHERE id_document = '99599' 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '3443' , 'DIECI PAROLE D\'AMORE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '15' , '-15' , '4' , '2.1000' , '2.1' , '0' , '15' , '26.78' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '2448' , 'COLUI IN CUI CREDO' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '15' , '51.00' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '15' , '51.00' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '4154' , 'FESTA DEL PERDONO' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '8408' , 'PRENDETE E MANGIATE' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 31/10/2025 11:31:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '8855' , 'REGISTRO DEL CATECHISTA' , '10' , '-10' , '4' , '0.75' , '0.75' , '0' , '5' , '7.13' ) 31/10/2025 11:32:46 am >> SELECT document_num FROM ps_document WHERE document_num = '181' AND id_document != '99599' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 11:32:46 am >> UPDATE ps_document SET id_document_type = '21', document_num = '181', document_date = '2025-10-31', document_letter = '', id_customer = '3152', id_supplier = '', id_address = '4670974', address1 = 'L.GO GARIBALDI, 5 64034 CASTIGLIONE MESSER RAIMONDO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '320.80', price_tax_excluded = '320.80', date_upd = NOW() WHERE id_document = '99599' 31/10/2025 11:32:46 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 = '99599' 31/10/2025 11:32:46 am >> DELETE FROM ps_document_detail WHERE id_document = '99599' 31/10/2025 11:32:46 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 ( '99599' , '3443' , 'DIECI PAROLE D\'AMORE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 31/10/2025 11:32:46 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 ( '99599' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '15' , '-15' , '4' , '2.1000' , '2.1' , '0' , '15' , '26.78' ) 31/10/2025 11:32:46 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 ( '99599' , '2448' , 'COLUI IN CUI CREDO' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 31/10/2025 11:32:46 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 ( '99599' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '15' , '51.00' ) 31/10/2025 11:32:46 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 ( '99599' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '15' , '51.00' ) 31/10/2025 11:32:46 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 ( '99599' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 31/10/2025 11:32:46 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 ( '99599' , '4154' , 'FESTA DEL PERDONO' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 31/10/2025 11:32:46 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 ( '99599' , '8408' , 'PRENDETE E MANGIATE' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 31/10/2025 11:32:46 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 ( '99599' , '8855' , 'REGISTRO DEL CATECHISTA' , '10' , '-10' , '4' , '0.7500' , '0.75' , '0' , '5' , '7.13' ) 31/10/2025 11:49:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 11:49:06 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' , '3603' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 31/10/2025 11:49:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99600' 31/10/2025 11:49:06 am >> DELETE FROM ps_document_detail WHERE id_document = '99600' 31/10/2025 11:49:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99600' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 31/10/2025 11:54:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 11:54:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3604' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 31/10/2025 11:54:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99601' 31/10/2025 11:54:03 am >> DELETE FROM ps_document_detail WHERE id_document = '99601' 31/10/2025 11:54:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99601' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 31/10/2025 11:54:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99601' , '20823' , 'BRUCIA INCENSO CM 9' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 31/10/2025 12:00:13 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3572' 31/10/2025 12:00:13 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3572' , '10' , '210' , 'PARROCCHIA S. MARIA ASSUNTA' , 'SCAPOLATEMPO' , 'DON PIETRO' , 'P. ZZA DUOMO 1' , '' , '84067' , 'POLICASTRO BUSSENTINO' , '' , '' , '3404623220' , '' , '93002870652' , NOW() , NOW() ) 31/10/2025 12:00:13 pm >> UPDATE ps_customer SET email = 'pietroscapolatempo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3572' 31/10/2025 12:01:07 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3572' 31/10/2025 12:01:07 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3572' , '10' , '210' , 'PARROCCHIA S. MARIA ASSUNTA' , 'SCAPOLATEMPO' , 'DON PIETRO' , 'P. ZZA DUOMO 1' , '' , '84067' , 'POLICASTRO BUSSENTINO' , 'SPEDIRE A: SCAPOLATEMPO DON PIETRO CORSO UMBERTO I 84070 TORRE ORSAIA SA' , '' , '3404623220' , '' , '93002870652' , NOW() , NOW() ) 31/10/2025 12:01:07 pm >> UPDATE ps_customer SET email = 'pietroscapolatempo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3572' 31/10/2025 12:02:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3572' 31/10/2025 12:02:53 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3572' , '10' , '210' , 'PARROCCHIA S. MARIA ASSUNTA' , 'SCAPOLATEMPO' , 'DON PIETRO' , 'P. ZZA DUOMO 1' , '' , '84067' , 'POLICASTRO BUSSENTINO' , 'SPEDIRE A: SCAPOLATEMPO DON PIETRO CORSO UMBERTO I 84070 TORRE ORSAIA SA' , '' , '3404623220' , '' , '93002870652' , NOW() , NOW() ) 31/10/2025 12:02:53 pm >> UPDATE ps_customer SET email = 'pietroscapolatempo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3572' 31/10/2025 12:03:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '182' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 12:03:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '182' , '2025-10-31' , '' , '3572' , '0' , '4679607' , 'P. ZZA DUOMO 1 84067 POLICASTRO BUSSENTINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '714.00' , '714.00' , NOW() , NOW() ) 31/10/2025 12:03:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99602' 31/10/2025 12:03:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '99602' 31/10/2025 12:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99602' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '300' , '-300' , '4' , '2.80' , '2.8' , '0' , '15' , '714.00' ) 31/10/2025 12:26:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 12:26:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3605' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/10/2025 12:26:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99603' 31/10/2025 12:26:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '99603' 31/10/2025 12:26:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99603' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2025 12:38: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 ( '32' , '214/2025' , '2025-10-31' , '2025' , '0' , '139' , '4670854' , 'VIA SAN SILVESTRO 16 06053 DERUTA ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1375.19' , '1127.20' , NOW() , NOW() ) 31/10/2025 12:38: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 = '99604' 31/10/2025 12:38:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '99604' 31/10/2025 12:38: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 ( '99604' , '16761' , 'LAMPADA MARIANA - 096DP2K' , '3' , '0' , '1' , '19.1500' , '15.6967' , '22' , '0' , '70.09' ) 31/10/2025 12:38:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16761' AND id_supplier = '139' 31/10/2025 12:38:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16761' , '139' , '1' ) 31/10/2025 12:38: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 ( '99604' , '17858' , 'LAMPADA IHS - 096DP1K' , '3' , '0' , '1' , '19.1500' , '15.6967' , '22' , '0' , '70.09' ) 31/10/2025 12:38:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17858' AND id_supplier = '139' 31/10/2025 12:38:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17858' , '139' , '1' ) 31/10/2025 12:38: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 ( '99604' , '16760' , 'LAMPADA MARIANA - 097DP2K' , '2' , '0' , '1' , '38.2500' , '31.3525' , '22' , '0' , '93.33' ) 31/10/2025 12:38:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16760' AND id_supplier = '139' 31/10/2025 12:38:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16760' , '139' , '1' ) 31/10/2025 12:38: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 ( '99604' , '24156' , 'LUCERNA TONDA IHS ORO - 067H2K' , '2' , '0' , '1' , '12.9000' , '10.5738' , '22' , '0' , '31.48' ) 31/10/2025 12:38:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24156' AND id_supplier = '139' 31/10/2025 12:38:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24156' , '139' , '1' ) 31/10/2025 12:38: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 ( '99604' , '24157' , 'LUCERNA TONDA TERRACOTTA - 056TEK' , '91' , '0' , '1' , '10.0000' , '8.1967' , '22' , '0' , '1110.20' ) 31/10/2025 12:38:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24157' AND id_supplier = '139' 31/10/2025 12:38:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24157' , '139' , '1' ) 31/10/2025 12:49:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3604' AND id_document != '99601' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 12:49:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3604', document_date = '2025-10-31', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '99601' 31/10/2025 12:49:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99601' 31/10/2025 12:49:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '99601' 31/10/2025 12:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99601' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 31/10/2025 12:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99601' , '20824' , 'BRUCIA INCENSO CM 14' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 31/10/2025 02:59:46 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3572' 31/10/2025 02:59:46 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3572' , '10' , '210' , 'PARROCCHIA S. MARIA ASSUNTA' , 'SCAPOLATEMPO' , 'DON PIETRO' , 'P. ZZA DUOMO 1' , '' , '84067' , 'POLICASTRO BUSSENTINO' , 'SPEDIRE A: SCAPOLATEMPO DON PIETRO CORSO UMBERTO I 84077 TORRE ORSAIA SA' , '' , '3404623220' , '' , '93002870652' , NOW() , NOW() ) 31/10/2025 02:59:46 pm >> UPDATE ps_customer SET email = 'pietroscapolatempo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3572' 31/10/2025 03:22:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 03:22:06 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' , '3606' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '57.81' , NOW() , NOW() ) 31/10/2025 03:22:06 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 = '99605' 31/10/2025 03:22:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '99605' 31/10/2025 03:22:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99605' , '24017' , 'GESU CONFIDO IN TE 2026 - 8272' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 31/10/2025 03:22:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99605' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '13.30' ) 31/10/2025 03:22:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99605' , '22257' , 'QUADRO DECORATO 36X22' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 31/10/2025 03:22:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99605' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '3.20' ) 31/10/2025 03:22:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99605' , '24179' , 'DILEXI TE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 31/10/2025 03:57:57 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/10/2025 03:57:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24210' , '1' , '' , 'nuovo-prodotto' ) 31/10/2025 03:57:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24210' , '1' , '1' , '2' , NOW() , NOW() ) 31/10/2025 03:57:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24210' , '0' , '1' , '0' , '0' ) 31/10/2025 03:58:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856698435' AND id_product != '24210' AND ean13 != '' 31/10/2025 03:58:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788856698435', date_upd = NOW() WHERE id_product = '24210' 31/10/2025 03:58:42 pm >> UPDATE ps_product_lang SET name = 'LIBERI DI AMARE - CHIARA AMIRANTE', description = '' WHERE id_product = '24210' 31/10/2025 03:58:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.9' WHERE id_product = '24210' 31/10/2025 03:58:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.9', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24210' 31/10/2025 03:58:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '24210' 31/10/2025 03:58:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24210' 31/10/2025 03:58:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24211' , '1' , '' , 'nuovo-prodotto' ) 31/10/2025 03:58:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24211' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24210' 31/10/2025 03:58:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24211' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24210' 31/10/2025 03:59:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281368811' AND id_product != '24211' AND ean13 != '' 31/10/2025 03:59:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281368811', date_upd = NOW() WHERE id_product = '24211' 31/10/2025 03:59:52 pm >> UPDATE ps_product_lang SET name = 'PAPA LEONE XIV - C. HENNING', description = '' WHERE id_product = '24211' 31/10/2025 03:59:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '24211' 31/10/2025 03:59:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '511', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24211' 31/10/2025 03:59:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '24211' 31/10/2025 03:59:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24211' 31/10/2025 03:59:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24212' , '1' , '' , 'nuovo-prodotto' ) 31/10/2025 03:59:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24212' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24211' 31/10/2025 03:59:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24212' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24211' 31/10/2025 04:00:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1749063' , '2025-10-30' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.40' , '112.40' , NOW() , NOW() ) 31/10/2025 04:00:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99606' 31/10/2025 04:00:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99606' 31/10/2025 04:00:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99606' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 31/10/2025 04:00:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23005' AND id_supplier = '177' 31/10/2025 04:00:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23005' , '177' , '1' ) 31/10/2025 04:00:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99606' , '24210' , 'LIBERI DI AMARE - CHIARA AMIRANTE' , '2' , '2' , '4' , '12.90' , '12.9' , '0' , '0' , '25.8000' ) 31/10/2025 04:00:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24210' AND id_supplier = '177' 31/10/2025 04:00:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24210' , '177' , '1' ) 31/10/2025 04:00:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99606' , '23759' , 'NON IO MA DIO - A. SALZANO ACUTIS' , '1' , '1' , '4' , '18.90' , '18.9' , '0' , '0' , '18.90' ) 31/10/2025 04:00:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23759' AND id_supplier = '177' 31/10/2025 04:00:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23759' , '177' , '1' ) 31/10/2025 04:00:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99606' , '24211' , 'PAPA LEONE XIV - C. HENNING' , '2' , '2' , '4' , '15.90' , '15.9' , '0' , '0' , '31.8000' ) 31/10/2025 04:00:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24211' AND id_supplier = '177' 31/10/2025 04:00:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24211' , '177' , '1' ) 31/10/2025 04:00:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99606' , '23567' , 'SEGRETO DI MIO FIGLIO - SALZANO/ACUTIS' , '1' , '1' , '4' , '18.90' , '18.9' , '0' , '0' , '18.90' ) 31/10/2025 04:00:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23567' AND id_supplier = '177' 31/10/2025 04:00:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23567' , '177' , '1' ) 31/10/2025 04:17:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 04:17:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3607' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '262.40' , '262.40' , NOW() , NOW() ) 31/10/2025 04:17:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99607' 31/10/2025 04:17:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '99607' 31/10/2025 04:17:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99607' , '21591' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 1' , '40' , '-40' , '4' , '6.90' , '6.9' , '0' , '5' , '262.40' ) 31/10/2025 04:45:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 04:45:36 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' , '3608' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 31/10/2025 04:45:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99608' 31/10/2025 04:45:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '99608' 31/10/2025 04:45:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99608' , '13060' , 'SAN PIO - COLORATO CM 30 - 236000/30' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 31/10/2025 04:49:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '183' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 04:49:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '183' , '2025-10-31' , '' , '3496' , '0' , '4679247' , 'VIA ALLA BASILICA 1 23808 VERCURAGO' , '' , 'COPIE OMAGGIO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 31/10/2025 04:49:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99609' 31/10/2025 04:49:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '99609' 31/10/2025 04:49:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99609' , '24202' , 'GRANDI DONNE E GRANDI SANTE' , '30' , '-30' , '4' , '6.00' , '6' , '0' , '100' , '0.00' ) 31/10/2025 04:51:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3609' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 04:51:46 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' , '3609' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.97' , '15.97' , NOW() , NOW() ) 31/10/2025 04:51:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99610' 31/10/2025 04:51:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99610' 31/10/2025 04:51:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99610' , '23989' , 'AMEN - NOV 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/10/2025 04:51:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99610' , '23988' , 'AMEN - DIC 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/10/2025 04:51:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99610' , '24128' , 'GIARDINO PIENO DI FIORI ' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 31/10/2025 05:29:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000342' AND id_product != '13060' AND ean13 != '' 31/10/2025 05:29:02 pm >> UPDATE ps_product SET id_supplier = '98', reference = '', ean13 = '000342', date_upd = NOW() WHERE id_product = '13060' 31/10/2025 05:29:02 pm >> UPDATE ps_product_lang SET name = 'SAN PIO - COLORATO CM 30 - 236000/30', description = '' WHERE id_product = '13060' 31/10/2025 05:29:02 pm >> UPDATE ps_product SET wholesale_price = '89.60', on_sale = '0', price = '163.9344262295082' WHERE id_product = '13060' 31/10/2025 05:29:02 pm >> UPDATE ps_product_shop SET wholesale_price = '89.60', price = '163.9344262295082', id_tax_rules_group = '1', id_category_default = '412', 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 = '13060' 31/10/2025 05:29:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '13060' 31/10/2025 05:29:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3169' AND id_document != '98983' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-01') 31/10/2025 05:29:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3169', document_date = '2025-10-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '13.60', price_tax_excluded = '12.95', date_upd = NOW() WHERE id_document = '98983' 31/10/2025 05:29:48 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 = '98983' 31/10/2025 05:29:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '98983' 31/10/2025 05:29:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98983' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 31/10/2025 05:29:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98983' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 31/10/2025 05:29:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98983' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 31/10/2025 05:30:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3610' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 05:30:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3610' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '500.00' , '409.84' , NOW() , NOW() ) 31/10/2025 05:30:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99611' 31/10/2025 05:30:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '99611' 31/10/2025 05:30:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99611' , '23894' , 'CASULA - 65/016430' , '1' , '-1' , '1' , '500' , '409.83606557377' , '22' , '0' , '500.00' ) 31/10/2025 05:49:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 05:49:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3611' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.44' , NOW() , NOW() ) 31/10/2025 05:49: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 = '99612' 31/10/2025 05:49:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '99612' 31/10/2025 05:49: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 ( '99612' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 31/10/2025 05:49: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 ( '99612' , '24179' , 'DILEXI TE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 31/10/2025 05:49: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 ( '99612' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/10/2025 05:49: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 ( '99612' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 31/10/2025 05:50:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '184' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 05:50:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '184' , '2025-10-31' , '' , '835' , '0' , '4671989' , 'VIA BRIGNANO INF 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '129.20' , '129.20' , NOW() , NOW() ) 31/10/2025 05:50:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99613' 31/10/2025 05:50:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99613' 31/10/2025 05:50:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99613' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '-8' , '4' , '3.80' , '3.8' , '0' , '15' , '25.84' ) 31/10/2025 05:50:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99613' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '14' , '-14' , '4' , '3.80' , '3.8' , '0' , '15' , '45.22' ) 31/10/2025 05:50:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99613' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '18' , '-18' , '4' , '3.80' , '3.8' , '0' , '15' , '58.14' ) 31/10/2025 05:55:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '184' AND id_document != '99613' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 05:55:45 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '184', document_date = '2025-10-31', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '129.20', price_tax_excluded = '129.20', date_upd = NOW() WHERE id_document = '99613' 31/10/2025 05:55:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99613' 31/10/2025 05:55:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99613' 31/10/2025 05:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99613' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 31/10/2025 05:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99613' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '14' , '-14' , '4' , '3.8000' , '3.8' , '0' , '15' , '45.22' ) 31/10/2025 05:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99613' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '18' , '-18' , '4' , '3.8000' , '3.8' , '0' , '15' , '58.14' ) 31/10/2025 06:00:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 06:00: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' , '3612' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/10/2025 06:00: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 = '99614' 31/10/2025 06:00:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '99614' 31/10/2025 06:00: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 ( '99614' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/10/2025 06:18:42 pm >> DELETE FROM ps_document WHERE id_document = '99573' 31/10/2025 06:18:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99573' 31/10/2025 06:50:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '98980' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-01') 31/10/2025 06:50:49 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '105', document_date = '2025-10-01', document_letter = '', id_customer = '93', id_supplier = '', id_address = '4679549', address1 = 'VIA SELVONE, SNC - S. ANGELO TH 03043 CASSINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '110.68', price_tax_excluded = '110.68', date_upd = NOW() WHERE id_document = '98980' 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98980' 31/10/2025 06:50:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '98980' 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '5' , '49.88' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.85' , '2.85' , '0' , '0' , '5.70' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 31/10/2025 06:50:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98980' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 31/10/2025 06:53:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '116' AND id_document != '99165' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-10') 31/10/2025 06:53:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '116', document_date = '2025-10-10', document_letter = '', id_customer = '2843', id_supplier = '', id_address = '4673405', address1 = 'V. PICENZA, 63 BIS 84131 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '47.50', price_tax_excluded = '47.50', date_upd = NOW() WHERE id_document = '99165' 31/10/2025 06:53:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99165' 31/10/2025 06:53:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99165' 31/10/2025 06:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99165' , '2679' , 'CONOSCERE GESU' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 31/10/2025 06:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99165' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 31/10/2025 06:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99165' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 31/10/2025 06:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99165' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 31/10/2025 06:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99165' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 31/10/2025 06:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99165' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 31/10/2025 06:55:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '117' AND id_document != '99175' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-10') 31/10/2025 06:55:25 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '117', document_date = '2025-10-10', document_letter = '', id_customer = '4251', id_supplier = '', id_address = '4679561', address1 = 'VIA PONTE NOVE LUCI 18 58100 POTENZA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '114.25', price_tax_excluded = '114.25', date_upd = NOW() WHERE id_document = '99175' 31/10/2025 06:55:25 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 = '99175' 31/10/2025 06:55:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '99175' 31/10/2025 06:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99175' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '5' , '33.25' ) 31/10/2025 06:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99175' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '3' , '-3' , '4' , '5.5000' , '5.5' , '0' , '0' , '16.50' ) 31/10/2025 06:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99175' , '11193' , 'VENITE CON ME CAT.' , '10' , '-10' , '4' , '5.5000' , '5.5' , '0' , '0' , '55.00' ) 31/10/2025 06:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99175' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 31/10/2025 06:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99175' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '0' , '7.00' ) 31/10/2025 06:57:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '99224' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-14') 31/10/2025 06:57:44 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '122', document_date = '2025-10-14', document_letter = '', id_customer = '2054', id_supplier = '', id_address = '4679526', address1 = 'VIA S. GIOVANNI 51 27029 VIGEVANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '385.05', price_tax_excluded = '385.05', date_upd = NOW() WHERE id_document = '99224' 31/10/2025 06:57: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 = '99224' 31/10/2025 06:57:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '99224' 31/10/2025 06:57: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 ( '99224' , '6629' , 'MIA PREGHIERA' , '100' , '-100' , '4' , '0.9000' , '0.9' , '0' , '15' , '76.50' ) 31/10/2025 06:57: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 ( '99224' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '60' , '-60' , '4' , '2.8000' , '2.8' , '0' , '15' , '142.80' ) 31/10/2025 06:57: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 ( '99224' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '10' , '-10' , '4' , '18.5000' , '18.5' , '0' , '15' , '157.25' ) 31/10/2025 06:57: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 ( '99224' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '0' , '7.00' ) 31/10/2025 06:57: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 ( '99224' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '0.75' , '0.75' , '0' , '0' , '1.50' ) 31/10/2025 06:58:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '124' AND id_document != '99243' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-14') 31/10/2025 06:58:59 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '124', document_date = '2025-10-14', document_letter = '', id_customer = '4255', id_supplier = '', id_address = '4679567', address1 = 'PIAZZA SANT\\\'ANDREA 12 57023 CECINA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '19.25', price_tax_excluded = '19.25', date_upd = NOW() WHERE id_document = '99243' 31/10/2025 06:58:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99243' 31/10/2025 06:58:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99243' 31/10/2025 06:58:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99243' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.75' , '0.75' , '0' , '0' , '0.75' ) 31/10/2025 06:58:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99243' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '5' , '-5' , '4' , '2.7' , '2.7' , '0' , '0' , '13.50' ) 31/10/2025 07:01:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '99252' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-15') 31/10/2025 07:01:31 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '127', document_date = '2025-10-15', document_letter = '', id_customer = '964', id_supplier = '', id_address = '4671035', address1 = 'P.ZZA S. MICHELE 83029 SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '288.48', price_tax_excluded = '288.48', date_upd = NOW() WHERE id_document = '99252' 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99252' 31/10/2025 07:01:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '99252' 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 31/10/2025 07:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99252' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 31/10/2025 07:02:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '99258' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-15') 31/10/2025 07:02:32 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '130', document_date = '2025-10-15', document_letter = '', id_customer = '1656', id_supplier = '', id_address = '4679422', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '168.30', price_tax_excluded = '168.30', date_upd = NOW() WHERE id_document = '99258' 31/10/2025 07:02:32 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 = '99258' 31/10/2025 07:02:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '99258' 31/10/2025 07:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99258' , '4120' , 'FEDE NELLO ZAINETTO' , '33' , '-33' , '4' , '6.0000' , '6' , '0' , '15' , '168.30' ) 31/10/2025 07:11:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '99428' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 31/10/2025 07:11:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '156', document_date = '2025-10-23', document_letter = '', id_customer = '2312', id_supplier = '', id_address = '4675584', address1 = 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '266.82', price_tax_excluded = '266.82', date_upd = NOW() WHERE id_document = '99428' 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99428' 31/10/2025 07:11:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99428' 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99428' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99428' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99428' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99428' , '5458' , 'IO SONO CON VOI 2 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99428' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99428' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.75' , '0.75' , '0' , '0' , '0.75' ) 31/10/2025 07:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99428' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 31/10/2025 07:13:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '99433' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 31/10/2025 07:13:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '158', document_date = '2025-10-23', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679517', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = '', price_shipping = '3.23', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '80.00', date_upd = NOW() WHERE id_document = '99433' 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99433' 31/10/2025 07:13:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99433' 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99433' , '24144' , 'LIBERI NELLA VERITA - M. DE MAIO' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99433' , '13083' , 'LIBRI PREGHIERA PER I DEFUNTI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99433' , '23954' , 'SAN BARTOLO LONGO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99433' , '17670' , 'NOVENA ALLA BEATA VERGINE ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99433' , '22805' , 'RESPIRO DELLA LODE - A. VENA' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99433' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '0' , '10.50' ) 31/10/2025 07:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99433' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' , '3.1' , '3.1' , '0' , '0' , '3.10' ) 31/10/2025 07:21:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 07:21:18 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' , '3613' , '2025-10-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '17.62' , NOW() , NOW() ) 31/10/2025 07:21:18 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 = '99615' 31/10/2025 07:21:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '99615' 31/10/2025 07:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 31/10/2025 07:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '18136' , 'CROCE - CC3' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 31/10/2025 07:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '11681' , 'CROCE TRAFORATA CON LACCIO' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 31/10/2025 07:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 31/10/2025 07:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 31/10/2025 07:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '2' , '-2' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '1.60' ) 31/10/2025 07:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2025 07:23:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3613' AND id_document != '99615' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 07:23:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3613', document_date = '2025-10-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.50', price_tax_excluded = '17.62', date_upd = NOW() WHERE id_document = '99615' 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99615' 31/10/2025 07:23:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99615' 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.6000' , '3.7704918032787' , '22' , '0' , '4.60' ) 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '18136' , 'CROCE - CC3' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '11681' , 'CROCE TRAFORATA CON LACCIO' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '6331' , 'MEDAGLIA OVALE DECORATA - MIRACOLOSA - G011.3' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 31/10/2025 07:23:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99615' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 31/10/2025 07:29:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '172' AND id_document != '99526' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-28') 31/10/2025 07:29:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '172', document_date = '2025-10-28', document_letter = '', id_customer = '3980', id_supplier = '', id_address = '4679588', address1 = 'P. ZZA RISORGIMENTO 1 80047 S. GIUSEPPE VESUVIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '114.00', price_tax_excluded = '114.00', date_upd = NOW() WHERE id_document = '99526' 31/10/2025 07:29:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99526' 31/10/2025 07:29:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99526' 31/10/2025 07:29:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99526' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 31/10/2025 07:29:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99526' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 31/10/2025 07:29:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99526' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '2' , '-2' , '4' , '11.00' , '11' , '0' , '15' , '18.70' ) 31/10/2025 07:29:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99526' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '9.4' , '9.4' , '0' , '0' , '18.80' ) 31/10/2025 07:31:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '181' AND id_document != '99599' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-31') 31/10/2025 07:31:45 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '181', document_date = '2025-10-31', document_letter = '', id_customer = '3152', id_supplier = '', id_address = '4670974', address1 = 'L.GO GARIBALDI, 5 64034 CASTIGLIONE MESSER RAIMONDO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '320.80', price_tax_excluded = '320.80', date_upd = NOW() WHERE id_document = '99599' 31/10/2025 07:31:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99599' 31/10/2025 07:31:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99599' 31/10/2025 07:31:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '3443' , 'DIECI PAROLE D\'AMORE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 31/10/2025 07:31:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '15' , '-15' , '4' , '2.1000' , '2.1' , '0' , '15' , '26.78' ) 31/10/2025 07:31:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '2448' , 'COLUI IN CUI CREDO' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 31/10/2025 07:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '15' , '51.00' ) 31/10/2025 07:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '15' , '51.00' ) 31/10/2025 07:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 31/10/2025 07:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '4154' , 'FESTA DEL PERDONO' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 31/10/2025 07:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '8408' , 'PRENDETE E MANGIATE' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 31/10/2025 07:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.63' , '0.63' , '0' , '0' , '0.63' ) 31/10/2025 07:31:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99599' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.25' , '3.25' , '0' , '0' , '6.50' ) 31/10/2025 07:44:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3180' AND id_document != '98999' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-01') 31/10/2025 07:44:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3180', document_date = '2025-10-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '123.45', date_upd = NOW() WHERE id_document = '98999' 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98999' 31/10/2025 07:44:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '98999' 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '60' , '-60' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '60.00' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '4' , '-4' , '1' , '12.8000' , '10.491803278689' , '22' , '0' , '51.20' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '8.2' , '6.7213114754098' , '22' , '0' , '8.20' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '24094' , 'BRACCIALE SAN BENEDETTO - CC 111-SB' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1.6000' , '1.3114754098361' , '22' , '0' , '1.60' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '21102' , 'BRACCIALE DECINA LEGNO CORDA - BC568' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 31/10/2025 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98999' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '3' , '-3' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '9.00' )