23/10/2025 08:26:50 am >> SELECT document_num FROM ps_document WHERE document_num = '129/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 08:26:50 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' , '129/A' , '2025-10-23' , 'A' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.29' , NOW() , NOW() ) 23/10/2025 08:26:50 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 = '99403' 23/10/2025 08:26:50 am >> DELETE FROM ps_document_detail WHERE id_document = '99403' 23/10/2025 08:26:50 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 ( '99403' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/10/2025 08:26:50 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 ( '99403' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/10/2025 08:31:54 am >> SELECT document_num FROM ps_document WHERE document_num = '151' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 08:31:54 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' , '151' , '2025-10-23' , '' , '4163' , '0' , '4679464' , 'VIA SAN ROCCO 17 84038 SASSANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '79.80' , '79.80' , NOW() , NOW() ) 23/10/2025 08:31:54 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 = '99404' 23/10/2025 08:31:54 am >> DELETE FROM ps_document_detail WHERE id_document = '99404' 23/10/2025 08:31:54 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 ( '99404' , '8408' , 'PRENDETE E MANGIATE' , '28' , '-28' , '4' , '3.00' , '3' , '0' , '5' , '79.80' ) 23/10/2025 08:53:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '289' , '2025-10-22' , '' , '0' , '161' , '4673833' , 'VIA TORRIONE 125 84127 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '81.00' , '81.00' , NOW() , NOW() ) 23/10/2025 08:53:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99405' 23/10/2025 08:53:21 am >> DELETE FROM ps_document_detail WHERE id_document = '99405' 23/10/2025 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99405' , '24144' , 'LIBERI NELLA VERITA\' - M. DE MAIO' , '3' , '0' , '4' , '36.00' , '36' , '0' , '25' , '81.0000' ) 23/10/2025 08:53:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '24144' AND id_supplier = '161' 23/10/2025 08:53:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24144' , '161' , '1' ) 23/10/2025 08:54:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '101' , '2025-10-22' , '' , '0' , '161' , '4673833' , 'VIA TORRIONE 125 84127 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '135.00' , NOW() , NOW() ) 23/10/2025 08:54:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99406' 23/10/2025 08:54:05 am >> DELETE FROM ps_document_detail WHERE id_document = '99406' 23/10/2025 08:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99406' , '24144' , 'LIBERI NELLA VERITA\' - M. DE MAIO' , '5' , '5' , '4' , '36.00' , '36' , '0' , '25' , '135.0000' ) 23/10/2025 08:54:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '24144' AND id_supplier = '161' 23/10/2025 08:54:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24144' , '161' , '1' ) 23/10/2025 09:36:24 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '344' 23/10/2025 09:36:24 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 ( '344' , '10' , '210' , 'PARR. S. MARIA DELLA MISERICORDIA' , 'RUMBOLD' , 'DON JULIAN' , 'L.GO MONS. G. PALUMBO' , '' , '84020' , 'OLIVETO CITRA' , '' , '0828798327' , '3408104009' , '' , '91036840659' , NOW() , NOW() ) 23/10/2025 09:36:25 am >> UPDATE ps_customer SET email = 'parrocchiaoliveto@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '344' 23/10/2025 09:37:37 am >> SELECT document_num FROM ps_document WHERE document_num = '152' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 09:37:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '152' , '2025-10-23' , '' , '344' , '0' , '4679592' , 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '182.75' , '182.75' , NOW() , NOW() ) 23/10/2025 09:37:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99407' 23/10/2025 09:37:38 am >> DELETE FROM ps_document_detail WHERE id_document = '99407' 23/10/2025 09:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '42' , '-42' , '4' , '3.00' , '3' , '0' , '15' , '107.10' ) 23/10/2025 09:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '4' , '-4' , '4' , '8.00' , '8' , '0' , '15' , '27.20' ) 23/10/2025 09:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 23/10/2025 09:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 23/10/2025 09:39:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 09:39:12 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' , '3466' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.90' , '32.90' , NOW() , NOW() ) 23/10/2025 09:39:12 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 = '99408' 23/10/2025 09:39:12 am >> DELETE FROM ps_document_detail WHERE id_document = '99408' 23/10/2025 09:39:12 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 ( '99408' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 23/10/2025 09:39:12 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 ( '99408' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 23/10/2025 09:41:20 am >> SELECT document_num FROM ps_document WHERE document_num = '152' AND id_document != '99407' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 09:41:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '152', document_date = '2025-10-23', document_letter = '', id_customer = '344', id_supplier = '', id_address = '4679592', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', 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 = '182.75', price_tax_excluded = '182.75', date_upd = NOW() WHERE id_document = '99407' 23/10/2025 09:41:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99407' 23/10/2025 09:41:20 am >> DELETE FROM ps_document_detail WHERE id_document = '99407' 23/10/2025 09:41:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '42' , '-42' , '4' , '3.0000' , '3' , '0' , '15' , '107.10' ) 23/10/2025 09:41:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 23/10/2025 09:41:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 23/10/2025 09:41:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99407' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 23/10/2025 09:49:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3467' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 09:49:27 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' , '3467' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.30' , '117.94' , NOW() , NOW() ) 23/10/2025 09:49:27 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 = '99409' 23/10/2025 09:49:27 am >> DELETE FROM ps_document_detail WHERE id_document = '99409' 23/10/2025 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99409' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '2' , '-2' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '90.00' ) 23/10/2025 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99409' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 23/10/2025 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99409' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 23/10/2025 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99409' , '18395' , 'EDITH STEIN - SCRITTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/10/2025 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99409' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '34.00' ) 23/10/2025 09:51:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3468' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 09:51:58 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' , '3468' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 23/10/2025 09:51:58 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 = '99410' 23/10/2025 09:51:58 am >> DELETE FROM ps_document_detail WHERE id_document = '99410' 23/10/2025 09:51:58 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 ( '99410' , '23969' , 'CALENDARIO FRATE INDOVINO 2026' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '0' , '10.00' ) 23/10/2025 10:07:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3469' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 10:07:15 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' , '3469' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.50' , '28.28' , NOW() , NOW() ) 23/10/2025 10:07:15 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 = '99411' 23/10/2025 10:07:15 am >> DELETE FROM ps_document_detail WHERE id_document = '99411' 23/10/2025 10:07:15 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 ( '99411' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 23/10/2025 10:07:15 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 ( '99411' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/10/2025 10:08:05 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/10/2025 10:08:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24175' , '1' , '' , 'nuovo-prodotto' ) 23/10/2025 10:08:05 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24175' , '1' , '1' , '2' , NOW() , NOW() ) 23/10/2025 10:08:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24175' , '0' , '1' , '0' , '0' ) 23/10/2025 10:11:35 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 23/10/2025 10:11:35 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '589' , '1' ) 23/10/2025 10:11:35 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '589' , '2' ) 23/10/2025 10:11:35 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '589' , '3' ) 23/10/2025 10:11:35 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '589' , '1' , 'EDITRICE SONDA' , LOWER('EDITRICE-SONDA') ) 23/10/2025 10:11:35 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '589' , '1' , '0' ) 23/10/2025 10:11:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872242810' AND id_product != '24175' AND ean13 != '' 23/10/2025 10:11:41 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788872242810', date_upd = NOW() WHERE id_product = '24175' 23/10/2025 10:11:41 am >> UPDATE ps_product_lang SET name = 'STORIA DI GESU\' BAMBINO - J. TAYLOR', description = '' WHERE id_product = '24175' 23/10/2025 10:11:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.9' WHERE id_product = '24175' 23/10/2025 10:11:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.9', id_tax_rules_group = '4', id_category_default = '589', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24175' 23/10/2025 10:11:41 am >> DELETE FROM ps_specific_price WHERE id_product = '24175' 23/10/2025 10:11:42 am >> 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 = '24175' 23/10/2025 10:11:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24176' , '1' , '' , 'nuovo-prodotto' ) 23/10/2025 10:11:42 am >> 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 '24176' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24175' 23/10/2025 10:11:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24176' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24175' 23/10/2025 10:13:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256271252' AND id_product != '24176' AND ean13 != '' 23/10/2025 10:13:16 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9791256271252', date_upd = NOW() WHERE id_product = '24176' 23/10/2025 10:13:16 am >> UPDATE ps_product_lang SET name = 'VANGELO SECONDO GIOVANNI ', description = '' WHERE id_product = '24176' 23/10/2025 10:13:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24176' 23/10/2025 10:13:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '137', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24176' 23/10/2025 10:13:16 am >> DELETE FROM ps_specific_price WHERE id_product = '24176' 23/10/2025 10:13:20 am >> 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 = '24176' 23/10/2025 10:13:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24177' , '1' , '' , 'nuovo-prodotto' ) 23/10/2025 10:13:20 am >> 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 '24177' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24176' 23/10/2025 10:13:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24177' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24176' 23/10/2025 10:14:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845908828' AND id_product != '24177' AND ean13 != '' 23/10/2025 10:14:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845908828', date_upd = NOW() WHERE id_product = '24177' 23/10/2025 10:14:29 am >> UPDATE ps_product_lang SET name = 'ANGELO NECESSARIO - M. CACCIARI', description = '' WHERE id_product = '24177' 23/10/2025 10:14:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '24177' 23/10/2025 10:14:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '463', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24177' 23/10/2025 10:14:29 am >> DELETE FROM ps_specific_price WHERE id_product = '24177' 23/10/2025 10:14:31 am >> 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 = '24177' 23/10/2025 10:14:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24178' , '1' , '' , 'nuovo-prodotto' ) 23/10/2025 10:14:31 am >> 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 '24178' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24177' 23/10/2025 10:14:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24178' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24177' 23/10/2025 10:22:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '00314080' , '2025-10-21' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '273.40' , '273.40' , NOW() , NOW() ) 23/10/2025 10:22:54 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 = '99412' 23/10/2025 10:22:54 am >> DELETE FROM ps_document_detail WHERE id_document = '99412' 23/10/2025 10:22:54 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 ( '99412' , '24080' , 'SAN FRANCESCO - A. BARBERO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '24080' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24080' , '109' , '1' ) 23/10/2025 10:22:54 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 ( '99412' , '24176' , 'VANGELO SECONDO GIOVANNI ' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '24176' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24176' , '109' , '1' ) 23/10/2025 10:22:54 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 ( '99412' , '16097' , 'PICCOLO CATECHISMO EUCARISTICO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16097' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16097' , '109' , '1' ) 23/10/2025 10:22:54 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 ( '99412' , '24175' , 'STORIA DI GESU BAMBINO - J. TAYLOR' , '1' , '1' , '4' , '24.90' , '24.9' , '0' , '0' , '24.90' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '24175' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24175' , '109' , '1' ) 23/10/2025 10:22:54 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 ( '99412' , '24177' , 'ANGELO NECESSARIO - M. CACCIARI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '24177' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24177' , '109' , '1' ) 23/10/2025 10:22:54 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 ( '99412' , '23918' , 'CE SPAZIO PER TE 2026 - 9-11 ANNI' , '5' , '5' , '4' , '16.50' , '16.5' , '0' , '0' , '82.5000' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '23918' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23918' , '109' , '1' ) 23/10/2025 10:22:54 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 ( '99412' , '23917' , 'CE SPAZIO PER TE 2026 - 6-8 ANNI' , '4' , '4' , '4' , '16.50' , '16.5' , '0' , '0' , '66.0000' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '23917' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23917' , '109' , '1' ) 23/10/2025 10:22:54 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 ( '99412' , '24134' , 'PASSAGGI DI STATO - GIOVANI 19/30' , '2' , '2' , '4' , '13.00' , '13' , '0' , '0' , '26.0000' ) 23/10/2025 10:22:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '24134' AND id_supplier = '109' 23/10/2025 10:22:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24134' , '109' , '1' ) 23/10/2025 10:26:19 am >> SELECT document_num FROM ps_document WHERE document_num = '150' AND id_document != '99384' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-22') 23/10/2025 10:26:19 am >> UPDATE ps_document SET id_document_type = '21', document_num = '150', document_date = '2025-10-22', document_letter = '', id_customer = '3775', id_supplier = '', id_address = '4679370', address1 = 'VIA DEL CASALE DI SAN PIO V, 11/13 00165 ROMA ', 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 = '754.32', price_tax_excluded = '754.32', date_upd = NOW() WHERE id_document = '99384' 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99384' 23/10/2025 10:26:19 am >> DELETE FROM ps_document_detail WHERE id_document = '99384' 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '5444' , 'IO SONO CON VOI - CAT.' , '29' , '-29' , '4' , '5.5000' , '5.5' , '0' , '0' , '159.50' ) 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '5457' , 'IO SONO CON VOI 1 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '5' , '93.10' ) 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '5458' , 'IO SONO CON VOI 2 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '5' , '93.10' ) 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '40' , '-40' , '4' , '2.4000' , '2.4' , '0' , '5' , '91.20' ) 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '11191' , 'VENITE CON ME 1 PARTE' , '40' , '-40' , '4' , '2.8000' , '2.8' , '0' , '5' , '106.40' ) 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '11192' , 'VENITE CON ME 2 PARTE' , '34' , '-34' , '4' , '2.8000' , '2.8' , '0' , '5' , '90.44' ) 23/10/2025 10:26:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '11193' , 'VENITE CON ME CAT.' , '31' , '-31' , '4' , '5.5000' , '5.5' , '0' , '0' , '170.50' ) 23/10/2025 10:32:22 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '4j5BbQNVxdnVpfjp' , NOW() , NOW() ) 23/10/2025 10:32:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4262' , '1' ) 23/10/2025 10:32:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4262' , '2' ) 23/10/2025 10:32:22 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4262' , '3' ) 23/10/2025 10:44:18 am >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 10:44:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '153' , '2025-10-23' , '' , '3134' , '0' , '4679140' , 'VIA MICHELANGELO 2 94013 LEONFORTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '71.68' , '71.68' , NOW() , NOW() ) 23/10/2025 10:44:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99413' 23/10/2025 10:44:18 am >> DELETE FROM ps_document_detail WHERE id_document = '99413' 23/10/2025 10:44:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99413' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '6' , '-6' , '4' , '5.50' , '5.5' , '0' , '0' , '33.00' ) 23/10/2025 10:44:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99413' , '9675' , 'SARETE MIEI TESTIMONI' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 23/10/2025 10:44:48 am >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '99413' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 10:44:48 am >> UPDATE ps_document SET id_document_type = '21', document_num = '153', document_date = '2025-10-23', document_letter = '', id_customer = '3134', id_supplier = '', id_address = '4679140', address1 = 'VIA MICHELANGELO 2 94013 LEONFORTE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '71.68', price_tax_excluded = '71.68', date_upd = NOW() WHERE id_document = '99413' 23/10/2025 10:44:48 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 = '99413' 23/10/2025 10:44:48 am >> DELETE FROM ps_document_detail WHERE id_document = '99413' 23/10/2025 10:44:48 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 ( '99413' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '6' , '-6' , '4' , '5.5000' , '5.5' , '0' , '0' , '33.00' ) 23/10/2025 10:44:48 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 ( '99413' , '9675' , 'SARETE MIEI TESTIMONI' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 23/10/2025 10:55:36 am >> SELECT document_num FROM ps_document WHERE document_num = '150' AND id_document != '99384' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-22') 23/10/2025 10:55:36 am >> UPDATE ps_document SET id_document_type = '21', document_num = '150', document_date = '2025-10-22', document_letter = '', id_customer = '3775', id_supplier = '', id_address = '4679370', address1 = 'VIA DEL CASALE DI SAN PIO V, 11/13 00165 ROMA ', 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 = '754.32', price_tax_excluded = '754.32', date_upd = NOW() WHERE id_document = '99384' 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99384' 23/10/2025 10:55:36 am >> DELETE FROM ps_document_detail WHERE id_document = '99384' 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '5444' , 'IO SONO CON VOI - CAT.' , '29' , '-29' , '4' , '5.5000' , '5.5' , '0' , '0' , '159.50' ) 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '5457' , 'IO SONO CON VOI 1 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '15' , '83.30' ) 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '5458' , 'IO SONO CON VOI 2 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '15' , '83.30' ) 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '40' , '-40' , '4' , '2.4000' , '2.4' , '0' , '15' , '81.60' ) 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '11191' , 'VENITE CON ME 1 PARTE' , '40' , '-40' , '4' , '2.8000' , '2.8' , '0' , '15' , '95.20' ) 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '11192' , 'VENITE CON ME 2 PARTE' , '34' , '-34' , '4' , '2.8000' , '2.8' , '0' , '15' , '80.92' ) 23/10/2025 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99384' , '11193' , 'VENITE CON ME CAT.' , '31' , '-31' , '4' , '5.5000' , '5.5' , '0' , '0' , '170.50' ) 23/10/2025 11:15:41 am >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 11:15:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '154' , '2025-10-23' , '' , '3389' , '0' , '4676360' , 'P. ZZA DANTE, 9 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.80' , '23.80' , NOW() , NOW() ) 23/10/2025 11:15:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99414' 23/10/2025 11:15:41 am >> DELETE FROM ps_document_detail WHERE id_document = '99414' 23/10/2025 11:15:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99414' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '10' , '-10' , '4' , '2.80' , '2.8' , '0' , '15' , '23.80' ) 23/10/2025 11:20:16 am >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 11:20:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '155' , '2025-10-23' , '' , '964' , '0' , '4671035' , 'P.ZZA S. MICHELE 83029 SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.63' , '57.63' , NOW() , NOW() ) 23/10/2025 11:20:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99415' 23/10/2025 11:20:16 am >> DELETE FROM ps_document_detail WHERE id_document = '99415' 23/10/2025 11:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99415' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 23/10/2025 11:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99415' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' , '-6' , '4' , '3.80' , '3.8' , '0' , '15' , '19.38' ) 23/10/2025 11:21:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3470' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 11:21:25 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' , '3470' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.37' , '64.52' , NOW() , NOW() ) 23/10/2025 11:21:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99416' 23/10/2025 11:21:25 am >> DELETE FROM ps_document_detail WHERE id_document = '99416' 23/10/2025 11:21:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99416' , '24142' , 'DILEXI TE' , '4' , '-4' , '4' , '2.90' , '2.9' , '0' , '5' , '11.04' ) 23/10/2025 11:21:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99416' , '24057' , 'AVVENTO 2025' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 23/10/2025 11:21:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99416' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '38.00' ) 23/10/2025 11:21:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99416' , '24080' , 'SAN FRANCESCO - A. BARBERO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 23/10/2025 11:24:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3471' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 11:24:58 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' , '3471' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.98' , '121.36' , NOW() , NOW() ) 23/10/2025 11:24:58 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 = '99417' 23/10/2025 11:24:58 am >> DELETE FROM ps_document_detail WHERE id_document = '99417' 23/10/2025 11:24:58 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 ( '99417' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 23/10/2025 11:24:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99417' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 23/10/2025 11:24:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99417' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 23/10/2025 11:24:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99417' , '23962' , 'CARLO ACUTIS - 8288' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 23/10/2025 11:24:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99417' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 23/10/2025 11:24:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99417' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 23/10/2025 11:24:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99417' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 23/10/2025 11:26:54 am >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '99415' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 11:26:54 am >> UPDATE ps_document SET id_document_type = '21', document_num = '155', document_date = '2025-10-23', 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 = '57.63', price_tax_excluded = '57.63', date_upd = NOW() WHERE id_document = '99415' 23/10/2025 11:26:54 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 = '99415' 23/10/2025 11:26:54 am >> DELETE FROM ps_document_detail WHERE id_document = '99415' 23/10/2025 11:26:54 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 ( '99415' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 23/10/2025 11:26:54 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 ( '99415' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 23/10/2025 11:27:10 am >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '99414' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 11:27:10 am >> UPDATE ps_document SET id_document_type = '21', document_num = '154', document_date = '2025-10-23', document_letter = '', id_customer = '3389', id_supplier = '', id_address = '4676360', address1 = 'P. ZZA DANTE, 9 84085 MERCATO SAN SEVERINO', 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 = '23.80', price_tax_excluded = '23.80', date_upd = NOW() WHERE id_document = '99414' 23/10/2025 11:27:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99414' 23/10/2025 11:27:10 am >> DELETE FROM ps_document_detail WHERE id_document = '99414' 23/10/2025 11:27:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99414' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '10' , '-10' , '4' , '2.8000' , '2.8' , '0' , '15' , '23.80' ) 23/10/2025 12:15:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3472' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:15:42 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' , '3472' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.36' , '29.36' , NOW() , NOW() ) 23/10/2025 12:15: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 = '99418' 23/10/2025 12:15:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99418' 23/10/2025 12:15: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 ( '99418' , '24177' , 'ANGELO NECESSARIO - M. CACCIARI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 23/10/2025 12:15: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 ( '99418' , '23451' , 'PIER GIORGIO FRASSATI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 23/10/2025 12:16:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3473' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:16:30 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' , '3473' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.55' , '26.68' , NOW() , NOW() ) 23/10/2025 12:16:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99419' 23/10/2025 12:16:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '99419' 23/10/2025 12:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99419' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 23/10/2025 12:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99419' , '24074' , 'AGENDA SETTIMANALE POCKET 2026 ROSSA' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '5' , '8.55' ) 23/10/2025 12:20:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3474' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:20:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3474' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 23/10/2025 12:20:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99420' 23/10/2025 12:20:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '99420' 23/10/2025 12:20:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99420' , '23988' , 'AMEN - DIC 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/10/2025 12:20:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99420' , '23989' , 'AMEN - NOV 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/10/2025 12:21:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3475' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:21:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3475' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 23/10/2025 12:21:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99421' 23/10/2025 12:21:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '99421' 23/10/2025 12:21:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99421' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 23/10/2025 12:24:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '130/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:24:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '130/A' , '2025-10-23' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '370.00' , '339.73' , NOW() , NOW() ) 23/10/2025 12:24:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99422' 23/10/2025 12:24:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99422' 23/10/2025 12:24:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99422' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 23/10/2025 12:24:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99422' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '140.00' ) 23/10/2025 12:24:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99422' , '7311' , 'OSTIA SOTTILE 74MM' , '50' , '-50' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '100.00' ) 23/10/2025 12:24:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99422' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 23/10/2025 12:24:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99422' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 23/10/2025 12:24:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99422' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '41.7' , '34.180327868852' , '22' , '0' , '41.70' ) 23/10/2025 12:25:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '130/A' AND id_document != '99422' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:25:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '130/A', document_date = '2025-10-23', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'acquisto materiale liturgico', 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 = '370.00', price_tax_excluded = '339.73', date_upd = NOW() WHERE id_document = '99422' 23/10/2025 12:25: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 = '99422' 23/10/2025 12:25:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '99422' 23/10/2025 12:25: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 ( '99422' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 23/10/2025 12:25: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 ( '99422' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '140.00' ) 23/10/2025 12:25: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 ( '99422' , '7311' , 'OSTIA SOTTILE 74MM' , '50' , '-50' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '100.00' ) 23/10/2025 12:25: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 ( '99422' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 23/10/2025 12:25: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 ( '99422' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 23/10/2025 12:25: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 ( '99422' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '41.7000' , '34.180327868852' , '22' , '0' , '41.70' ) 23/10/2025 12:27:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '98376' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-06') 23/10/2025 12:27:09 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2025-08-06', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '410.00', price_tax_excluded = '347.54', date_upd = NOW() WHERE id_document = '98376' 23/10/2025 12:27: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 = '98376' 23/10/2025 12:27:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '98376' 23/10/2025 12:27: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 ( '98376' , '1914' , 'CERA DELLA LITURGIA' , '36' , '-36' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '169.20' ) 23/10/2025 12:27: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 ( '98376' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/10/2025 12:27: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 ( '98376' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '54.15' , '44.385245901639' , '22' , '0' , '54.15' ) 23/10/2025 12:27: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 ( '98376' , '23975' , 'MESSALINO QUOTIDIANO - NOV DIC GEN' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 23/10/2025 12:27: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 ( '98376' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 23/10/2025 12:27: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 ( '98376' , '3908' , 'ESERCIZI SPIRITUALI - IGNAZIO DI LOYOLA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 23/10/2025 12:27: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 ( '98376' , '18114' , 'MIA VITA - TERESA DI GESU' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '5' , '26.60' ) 23/10/2025 12:27: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 ( '98376' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 23/10/2025 12:27: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 ( '98376' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 23/10/2025 12:27: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 ( '98376' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '100' , '0.00' ) 23/10/2025 12:27: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 ( '98376' , '24082' , 'INNESTO PER CERO PASQUALE - 167/G' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 23/10/2025 12:27: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 ( '98376' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 23/10/2025 12:27: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 ( '98376' , '24080' , 'SAN FRANCESCO - A. BARBERO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 23/10/2025 12:31:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3476' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:31:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3476' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 23/10/2025 12:31: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 = '99423' 23/10/2025 12:31:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99423' 23/10/2025 12:31: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 ( '99423' , '24146' , 'INFERNO CHE TRISTEZZA - M. BOTTA' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 23/10/2025 12:49:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3477' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:49:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3477' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.17' , '12.17' , NOW() , NOW() ) 23/10/2025 12:49:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99424' 23/10/2025 12:49:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99424' 23/10/2025 12:49:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99424' , '23988' , 'AMEN - DIC 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/10/2025 12:49:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99424' , '23989' , 'AMEN - NOV 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/10/2025 12:49:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99424' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/10/2025 12:50:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3478' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:50:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3478' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.60' , '5.60' , NOW() , NOW() ) 23/10/2025 12:50:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99425' 23/10/2025 12:50:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '99425' 23/10/2025 12:50:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99425' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '8' , '-8' , '4' , '0.70' , '0.7' , '0' , '0' , '5.60' ) 23/10/2025 12:58:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3479' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 12:58:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3479' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.90' , NOW() , NOW() ) 23/10/2025 12:58:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99426' 23/10/2025 12:58:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '99426' 23/10/2025 12:58:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99426' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 23/10/2025 03:17:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3480' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 03: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' , '3480' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.90' , '63.56' , NOW() , NOW() ) 23/10/2025 03: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 = '99427' 23/10/2025 03:17:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '99427' 23/10/2025 03: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 ( '99427' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 23/10/2025 03: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 ( '99427' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 23/10/2025 04:09:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 04:09:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '156' , '2025-10-23' , '' , '2312' , '0' , '4675584' , 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '266.82' , '266.05' , NOW() , NOW() ) 23/10/2025 04:09: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 = '99428' 23/10/2025 04:09:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99428' 23/10/2025 04:09: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 ( '99428' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '15' , '76.50' ) 23/10/2025 04:09: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 ( '99428' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 23/10/2025 04:09: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 ( '99428' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 23/10/2025 04:09: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 ( '99428' , '5458' , 'IO SONO CON VOI 2 PARTE' , '18' , '-18' , '4' , '2.80' , '2.8' , '0' , '15' , '42.84' ) 23/10/2025 04:09: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 ( '99428' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 23/10/2025 04:09: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 ( '99428' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '15' , '4.25' ) 23/10/2025 04:09:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3481' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 04:09: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' , '3481' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '10.90' , NOW() , NOW() ) 23/10/2025 04:09: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 = '99429' 23/10/2025 04:09:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '99429' 23/10/2025 04:09: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 ( '99429' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '13.30' ) 23/10/2025 04:14:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3482' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 04:14:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3482' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '255.00' , '213.92' , NOW() , NOW() ) 23/10/2025 04:14:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99430' 23/10/2025 04:14:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '99430' 23/10/2025 04:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99430' , '24117' , 'GIOIA - E. BORGNA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 23/10/2025 04:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99430' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '132.8' , '108.85245901639' , '22' , '0' , '132.80' ) 23/10/2025 04:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99430' , '16760' , 'LAMPADA MARIANA - 097DP2K' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 23/10/2025 04:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99430' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 23/10/2025 04:15:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 04:15:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '157' , '2025-10-23' , '' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.38' , '70.38' , NOW() , NOW() ) 23/10/2025 04:15:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99431' 23/10/2025 04:15:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '99431' 23/10/2025 04:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 23/10/2025 04:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 23/10/2025 04:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 23/10/2025 04:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '15' , '6.46' ) 23/10/2025 04:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '15' , '6.46' ) 23/10/2025 04:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '15' , '6.46' ) 23/10/2025 04:17:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '99431' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 04:17:55 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '157', document_date = '2025-10-23', document_letter = '', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '70.00', price_tax_excluded = '70.00', date_upd = NOW() WHERE id_document = '99431' 23/10/2025 04:17:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99431' 23/10/2025 04:17:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '99431' 23/10/2025 04:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 23/10/2025 04:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 23/10/2025 04:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 23/10/2025 04:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 23/10/2025 04:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 23/10/2025 04:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 23/10/2025 04:17:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99431' , '' , 'arrotondamento' , '1' , '-1' , '0' , '-0.38' , '-0.38' , '' , '0' , '-0.38' ) 23/10/2025 04:18:19 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') 23/10/2025 04:18:19 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.05', date_upd = NOW() WHERE id_document = '99428' 23/10/2025 04:18: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 = '99428' 23/10/2025 04:18:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '99428' 23/10/2025 04:18: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 ( '99428' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 23/10/2025 04:18: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 ( '99428' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 23/10/2025 04:18: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 ( '99428' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 23/10/2025 04:18: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 ( '99428' , '5458' , 'IO SONO CON VOI 2 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 23/10/2025 04:18: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 ( '99428' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 23/10/2025 04:18: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 ( '99428' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '15' , '4.25' ) 23/10/2025 04:27:35 pm >> DELETE FROM ps_document WHERE id_document = '99102' 23/10/2025 04:27:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '99102' 23/10/2025 05:18:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 05:18:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3483' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.21' , '89.86' , NOW() , NOW() ) 23/10/2025 05:18:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99432' 23/10/2025 05:18:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '99432' 23/10/2025 05:18:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99432' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 23/10/2025 05:18: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 ( '99432' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/10/2025 05:18: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 ( '99432' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/10/2025 05:18: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 ( '99432' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 23/10/2025 05:18: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 ( '99432' , '24047' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE GUIDA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 23/10/2025 05:18: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 ( '99432' , '24045' , 'GESU E IL MIO AMICO SPECIALE - LA RICONCILIAZIONE' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 23/10/2025 05:18: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 ( '99432' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 23/10/2025 05:18: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 ( '99432' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 23/10/2025 05:18: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 ( '99432' , '997' , 'BEATITUDINI SPIEGATE AI RAGAZZI - V. BOCCI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 23/10/2025 05:18: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 ( '99432' , '24107' , 'IO E IL MIO AMICO GESU - GUIDA - B. FERRERO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 23/10/2025 05:18: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 ( '99432' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 23/10/2025 05:58:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 05:58: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 ( '21' , '158' , '2025-10-23' , '' , '65' , '0' , '4679517' , 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE' , '' , '' , '3.23' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '80.00' , '80.00' , NOW() , NOW() ) 23/10/2025 05:58: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 = '99433' 23/10/2025 05:58:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '99433' 23/10/2025 05:58: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 ( '99433' , '24144' , 'LIBERI NELLA VERITA - M. DE MAIO' , '1' , '-1' , '4' , '36.00' , '36' , '0' , '0' , '36.00' ) 23/10/2025 05:58: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 ( '99433' , '13083' , 'PREGHIERA PER I DEFUNTI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 23/10/2025 05:58: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 ( '99433' , '23954' , 'SAN BARTOLO LONGO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 23/10/2025 05:58: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 ( '99433' , '17670' , 'NOVENA ALLA BEATA VERGINE ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 23/10/2025 05:58: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 ( '99433' , '' , 'IMMAGINI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 23/10/2025 05:58: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 ( '99433' , '' , 'IMMAGINI' , '1' , '-1' , '4' , '3.6' , '3.6' , '0' , '0' , '3.60' ) 23/10/2025 05:58: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 ( '99433' , '22805' , 'RESPIRO DELLA LODE - A. VENA' , '1' , '-1' , '4' , '13.50' , '13.5' , '0' , '5' , '12.82' ) 23/10/2025 06:23:42 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'PWmoJBW4pkbyXBf8' , NOW() , NOW() ) 23/10/2025 06:23:42 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4263' , '1' ) 23/10/2025 06:23:43 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4263' , '2' ) 23/10/2025 06:23:43 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4263' , '3' ) 23/10/2025 06:36:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 06:36:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3484' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 23/10/2025 06:36: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 = '99434' 23/10/2025 06:36:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99434' 23/10/2025 06:36: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 ( '99434' , '15103' , 'GIROCOLLO - 870/24' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 23/10/2025 06:39:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2743/25' , '2025-10-21' , '25' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1067.51' , '1026.45' , NOW() , NOW() ) 23/10/2025 06:39:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99435' 23/10/2025 06:39:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '99435' 23/10/2025 06:39:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99435' , '7311' , 'OSTIA SOTTILE 74MM' , '125' , '125' , '3' , '1.16' , '1.1153846153846' , '4' , '3' , '146.2760' ) 23/10/2025 06:39:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 23/10/2025 06:39:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 23/10/2025 06:39:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99435' , '16689' , 'OSTIA PAN DI CENA mm80' , '100' , '100' , '3' , '1.2' , '1.1538461538462' , '4' , '3' , '121.0560' ) 23/10/2025 06:39:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '22' 23/10/2025 06:39:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '22' , '1' ) 23/10/2025 06:39:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99435' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '200' , '200' , '3' , '2.15' , '2.0673076923077' , '4' , '0' , '447.2000' ) 23/10/2025 06:39:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 23/10/2025 06:39:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 23/10/2025 06:39:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99435' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '133' , '133' , '3' , '2.3' , '2.2115384615385' , '4' , '3' , '308.5919' ) 23/10/2025 06:39:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20433' AND id_supplier = '22' 23/10/2025 06:39:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20433' , '22' , '1' ) 23/10/2025 06:39:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99435' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '40' , '40' , '3' , '1.1' , '1.0576923076923' , '4' , '3' , '44.3872' ) 23/10/2025 06:39:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16164' AND id_supplier = '22' 23/10/2025 06:39:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16164' , '22' , '1' ) 23/10/2025 07:06:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:06:51 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' , '3485' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 23/10/2025 07:06:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99436' 23/10/2025 07:06:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '99436' 23/10/2025 07:06:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99436' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/10/2025 07:20:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:20:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3486' , '2025-10-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 23/10/2025 07:20:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99437' 23/10/2025 07:20:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '99437' 23/10/2025 07:20:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99437' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '7' , '-7' , '4' , '0.70' , '0.7' , '0' , '0' , '4.90' ) 23/10/2025 07:32:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:32:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '159' , '2025-10-23' , '' , '1656' , '0' , '4679422' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '219.30' , '219.30' , NOW() , NOW() ) 23/10/2025 07:32:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99438' 23/10/2025 07:32:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '99438' 23/10/2025 07:32: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 ( '99438' , '4120' , 'FEDE NELLO ZAINETTO' , '43' , '-43' , '4' , '6.00' , '6' , '0' , '15' , '219.30' ) 23/10/2025 07:33:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:33:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '33' , '2025-10-23' , '' , '1656' , '0' , '4679422' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '168.30' , '168.30' , NOW() , NOW() ) 23/10/2025 07:33: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 = '99439' 23/10/2025 07:33:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '99439' 23/10/2025 07:33: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 ( '99439' , '4120' , 'FEDE NELLO ZAINETTO' , '33' , '-33' , '4' , '6.00' , '6' , '0' , '15' , '168.30' ) 23/10/2025 07:33:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '99439' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:33:48 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '33', document_date = '2025-10-23', 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 = '0', id_causal = '0', price_tax_included = '51.00', price_tax_excluded = '51.00', date_upd = NOW() WHERE id_document = '99439' 23/10/2025 07:33: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 = '99439' 23/10/2025 07:33:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99439' 23/10/2025 07:33: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 ( '99439' , '4120' , 'FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '15' , '51.00' ) 23/10/2025 07:33:58 pm >> DELETE FROM ps_document WHERE id_document = '99439' 23/10/2025 07:33:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '99439' 23/10/2025 07:37:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '160' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:37:40 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' , '160' , '2025-10-23' , '' , '1656' , '0' , '4679422' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '181.31' , '181.31' , NOW() , NOW() ) 23/10/2025 07:37:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99440' 23/10/2025 07:37:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '99440' 23/10/2025 07:37:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99440' , '23934' , 'ANGELO DI DIO - N.E.' , '31' , '-31' , '4' , '1.80' , '1.8' , '0' , '15' , '47.43' ) 23/10/2025 07:37:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99440' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '20' , '-20' , '4' , '1.80' , '1.8' , '0' , '15' , '30.60' ) 23/10/2025 07:37:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99440' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.80' , '3.8' , '0' , '15' , '64.60' ) 23/10/2025 07:37:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99440' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 23/10/2025 07:43:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '99438' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:43:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '159', document_date = '2025-10-23', 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 = '0', id_causal = '0', price_tax_included = '214.20', price_tax_excluded = '214.20', date_upd = NOW() WHERE id_document = '99438' 23/10/2025 07:43: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 = '99438' 23/10/2025 07:43:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '99438' 23/10/2025 07:43: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 ( '99438' , '4120' , 'FEDE NELLO ZAINETTO' , '42' , '-42' , '4' , '6.0000' , '6' , '0' , '15' , '214.20' ) 23/10/2025 07:49:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '99438' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:49:15 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '159', document_date = '2025-10-23', 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 = '214.20', price_tax_excluded = '214.20', date_upd = NOW() WHERE id_document = '99438' 23/10/2025 07:49:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99438' 23/10/2025 07:49:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '99438' 23/10/2025 07:49:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99438' , '4120' , 'FEDE NELLO ZAINETTO' , '42' , '-42' , '4' , '6.0000' , '6' , '0' , '15' , '214.20' ) 23/10/2025 07:49:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '160' AND id_document != '99440' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-23') 23/10/2025 07:49:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '160', document_date = '2025-10-23', 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 = '181.31', price_tax_excluded = '181.31', date_upd = NOW() WHERE id_document = '99440' 23/10/2025 07:49:26 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 = '99440' 23/10/2025 07:49:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '99440' 23/10/2025 07:49:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99440' , '23934' , 'ANGELO DI DIO - N.E.' , '31' , '-31' , '4' , '1.8000' , '1.8' , '0' , '15' , '47.43' ) 23/10/2025 07:49: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 ( '99440' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '20' , '-20' , '4' , '1.8000' , '1.8' , '0' , '15' , '30.60' ) 23/10/2025 07:49: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 ( '99440' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.8000' , '3.8' , '0' , '15' , '64.60' ) 23/10/2025 07:49: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 ( '99440' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' )