08/11/2025 09:10:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 09:10:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3709' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.33' , NOW() , NOW() ) 08/11/2025 09:10: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 = '99781' 08/11/2025 09:10:41 am >> DELETE FROM ps_document_detail WHERE id_document = '99781' 08/11/2025 09:10: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 ( '99781' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 08/11/2025 09:11:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 09:11:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3710' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.33' , NOW() , NOW() ) 08/11/2025 09:11: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 = '99782' 08/11/2025 09:11:19 am >> DELETE FROM ps_document_detail WHERE id_document = '99782' 08/11/2025 09:11: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 ( '99782' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 08/11/2025 09:42:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 09:42: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' , '3711' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 08/11/2025 09:42: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 = '99783' 08/11/2025 09:42:15 am >> DELETE FROM ps_document_detail WHERE id_document = '99783' 08/11/2025 09:42: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 ( '99783' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '30' , '-30' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '30.00' ) 08/11/2025 09:42: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 ( '99783' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 08/11/2025 10:12:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 10:12:39 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' , '3712' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 08/11/2025 10:12:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99784' 08/11/2025 10:12:39 am >> DELETE FROM ps_document_detail WHERE id_document = '99784' 08/11/2025 10:12:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99784' , '21083' , 'BRACCIALE ARG. CRISTALLO - 1351CAV' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 08/11/2025 10:25:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 10:25:36 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' , '3713' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 08/11/2025 10:25: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 = '99785' 08/11/2025 10:25:36 am >> DELETE FROM ps_document_detail WHERE id_document = '99785' 08/11/2025 10:25: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 ( '99785' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 08/11/2025 10:29:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3655' AND id_document != '99689' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 08/11/2025 10:29:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3655', document_date = '2025-11-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.33', price_tax_excluded = '14.33', date_upd = NOW() WHERE id_document = '99689' 08/11/2025 10:29:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99689' 08/11/2025 10:29:40 am >> DELETE FROM ps_document_detail WHERE id_document = '99689' 08/11/2025 10:29:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99689' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' , '0.75' , '0.75' , '0' , '0' , '1.50' ) 08/11/2025 10:29:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99689' , '22024' , 'TRATTATO DELLA VERA DEVOZIONE - 8576' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 08/11/2025 10:29:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99689' , '19268' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '6.5000' , '6.5' , '0' , '5' , '6.18' ) 08/11/2025 10:29:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3239' AND id_document != '99080' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-06') 08/11/2025 10:29:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3239', document_date = '2025-10-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.50', price_tax_excluded = '3.50', date_upd = NOW() WHERE id_document = '99080' 08/11/2025 10:29: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 = '99080' 08/11/2025 10:29:58 am >> DELETE FROM ps_document_detail WHERE id_document = '99080' 08/11/2025 10:29: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 ( '99080' , '23940' , 'ROSARIO CON PADRE PIO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 08/11/2025 10:29: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 ( '99080' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' , '0.75' , '0.75' , '0' , '0' , '1.50' ) 08/11/2025 10:30:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3558' AND id_document != '99538' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-28') 08/11/2025 10:30:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3558', document_date = '2025-10-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '37.45', price_tax_excluded = '34.11', date_upd = NOW() WHERE id_document = '99538' 08/11/2025 10:30:23 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 = '99538' 08/11/2025 10:30:23 am >> DELETE FROM ps_document_detail WHERE id_document = '99538' 08/11/2025 10:30:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99538' , '16124' , 'SAN GIOVANNI PAOLO II BABY - GP2-BB' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 08/11/2025 10:30:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99538' , '13110' , 'S. PAOLO BABY - 023 SGD 9 BB' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 08/11/2025 10:30:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99538' , '24186' , 'DILEXI TE ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 08/11/2025 10:30:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99538' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 08/11/2025 10:30:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99538' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 08/11/2025 10:31:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3487' AND id_document != '99441' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-24') 08/11/2025 10:31:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3487', document_date = '2025-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.00', price_tax_excluded = '189.68', date_upd = NOW() WHERE id_document = '99441' 08/11/2025 10:31: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 = '99441' 08/11/2025 10:31:20 am >> DELETE FROM ps_document_detail WHERE id_document = '99441' 08/11/2025 10:31: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 ( '99441' , '5929' , 'LODI E VESPRI' , '20' , '-20' , '4' , '4.5000' , '4.5' , '0' , '5' , '85.60' ) 08/11/2025 10:31: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 ( '99441' , '23916' , 'CE SPAZIO PER TE 2026 - 3-5 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 08/11/2025 10:31: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 ( '99441' , '24076' , 'SAN CARLO ACUTIS - ARS 490' , '100' , '-100' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '15.00' ) 08/11/2025 10:31: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 ( '99441' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 08/11/2025 10:31: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 ( '99441' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 08/11/2025 10:31: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 ( '99441' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '5' , '19.00' ) 08/11/2025 10:31: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 ( '99441' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 08/11/2025 10:31: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 ( '99441' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2025 10:31: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 ( '99441' , '23803' , 'MIA SPERANZA E IN TE - AGGIUNTA SPARTITI' , '1' , '-1' , '3' , '10.0000' , '9.6153846153846' , '4' , '0' , '10.00' ) 08/11/2025 10:31: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 ( '99441' , '23931' , 'IO HO FATTO LA MIA PARTE 2026' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '5.70' ) 08/11/2025 10:31: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 ( '99441' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 08/11/2025 10:31: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 ( '99441' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 08/11/2025 10:31: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 ( '99441' , '23920' , 'WORK IN PROGRESS ANNO A - EDUCATORI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 08/11/2025 10:31: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 ( '99441' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '0.9900' , '0.81147540983607' , '22' , '0' , '0.99' ) 08/11/2025 10:31: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 ( '99441' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' , '0.7' , '0.7' , '0' , '0' , '1.40' ) 08/11/2025 10:32:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3582' AND id_document != '99570' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-30') 08/11/2025 10:32:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3582', document_date = '2025-10-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1.80', price_tax_excluded = '1.80', date_upd = NOW() WHERE id_document = '99570' 08/11/2025 10:32:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99570' 08/11/2025 10:32:14 am >> DELETE FROM ps_document_detail WHERE id_document = '99570' 08/11/2025 10:32:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99570' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' , '0.9' , '0.9' , '0' , '0' , '1.80' ) 08/11/2025 10:39:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3405' AND id_document != '99321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-18') 08/11/2025 10:39:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3405', document_date = '2025-10-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '49.00', price_tax_excluded = '49.00', date_upd = NOW() WHERE id_document = '99321' 08/11/2025 10:39: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 = '99321' 08/11/2025 10:39:54 am >> DELETE FROM ps_document_detail WHERE id_document = '99321' 08/11/2025 10:39: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 ( '99321' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.58' , '2.58' , '0' , '0' , '2.58' ) 08/11/2025 10:39: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 ( '99321' , '23759' , 'NON IO MA DIO - A. SALZANO ACUTIS' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '5' , '17.96' ) 08/11/2025 10:39: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 ( '99321' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 08/11/2025 10:39: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 ( '99321' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.79' , '0.79' , '0' , '0' , '0.79' ) 08/11/2025 10:39: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 ( '99321' , '24142' , 'DILEXI TE' , '4' , '-4' , '4' , '2.90' , '2.9' , '0' , '5' , '11.04' ) 08/11/2025 10:39: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 ( '99321' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/11/2025 10:44:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 10:44: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' , '3714' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '9.00' , NOW() , NOW() ) 08/11/2025 10:44: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 = '99786' 08/11/2025 10:44:25 am >> DELETE FROM ps_document_detail WHERE id_document = '99786' 08/11/2025 10:44: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 ( '99786' , '4836' , 'HO VISTO DIO IN UN UOMO - CURATO DARS - 8415' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 08/11/2025 10:45:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3715' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 10:45:52 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' , '3715' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.75' , '7.75' , NOW() , NOW() ) 08/11/2025 10:45:52 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 = '99787' 08/11/2025 10:45:52 am >> DELETE FROM ps_document_detail WHERE id_document = '99787' 08/11/2025 10:45:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99787' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 08/11/2025 10:45:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99787' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/11/2025 10:51:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 10:51:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3716' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '15.30' , NOW() , NOW() ) 08/11/2025 10:51:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99788' 08/11/2025 10:51:29 am >> DELETE FROM ps_document_detail WHERE id_document = '99788' 08/11/2025 10:51:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99788' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 08/11/2025 10:51:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99788' , '23807' , 'CALENDARIO LITURGICO 2026' , '10' , '-10' , '4' , '0.80' , '0.8' , '0' , '0' , '8.00' ) 08/11/2025 11:08:24 am >> SELECT document_num FROM ps_document WHERE document_num = '138/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:08:24 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' , '138/A' , '2025-11-08' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.60' , '36.81' , NOW() , NOW() ) 08/11/2025 11:08:24 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 = '99789' 08/11/2025 11:08:24 am >> DELETE FROM ps_document_detail WHERE id_document = '99789' 08/11/2025 11:08: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 ( '99789' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 08/11/2025 11:08: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 ( '99789' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 08/11/2025 11:08: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 ( '99789' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 08/11/2025 11:13:55 am >> SELECT document_num FROM ps_document WHERE document_num = '213' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:13:55 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' , '213' , '2025-11-08' , '' , '1213' , '0' , '4679403' , 'VIA MARCONI 115 83025 MONTORO INFERIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '255.85' , '255.85' , NOW() , NOW() ) 08/11/2025 11:13:55 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 = '99790' 08/11/2025 11:13:55 am >> DELETE FROM ps_document_detail WHERE id_document = '99790' 08/11/2025 11:13:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99790' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.80' , '2.8' , '0' , '15' , '23.80' ) 08/11/2025 11:13:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99790' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 08/11/2025 11:13:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99790' , '11191' , 'VENITE CON ME 1 PARTE' , '27' , '-27' , '4' , '2.80' , '2.8' , '0' , '15' , '64.26' ) 08/11/2025 11:13:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99790' , '11192' , 'VENITE CON ME 2 PARTE' , '23' , '-23' , '4' , '2.80' , '2.8' , '0' , '15' , '54.74' ) 08/11/2025 11:13:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99790' , '2679' , 'CONOSCERE GESU\'' , '22' , '-22' , '4' , '3.50' , '3.5' , '0' , '15' , '65.45' ) 08/11/2025 11:16:11 am >> SELECT document_num FROM ps_document WHERE document_num = '214' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:16:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '214' , '2025-11-08' , '' , '2893' , '0' , '4672074' , 'VIA CONVENTO 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '152.92' , '152.92' , NOW() , NOW() ) 08/11/2025 11:16:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99791' 08/11/2025 11:16:11 am >> DELETE FROM ps_document_detail WHERE id_document = '99791' 08/11/2025 11:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99791' , '5457' , 'IO SONO CON VOI 1 PARTE' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 08/11/2025 11:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99791' , '5458' , 'IO SONO CON VOI 2 PARTE' , '11' , '-11' , '4' , '2.80' , '2.8' , '0' , '15' , '26.18' ) 08/11/2025 11:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99791' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '-16' , '4' , '2.80' , '2.8' , '0' , '15' , '38.08' ) 08/11/2025 11:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99791' , '11192' , 'VENITE CON ME 2 PARTE' , '11' , '-11' , '4' , '2.80' , '2.8' , '0' , '15' , '26.18' ) 08/11/2025 11:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99791' , '2679' , 'CONOSCERE GESU\'' , '9' , '-9' , '4' , '3.50' , '3.5' , '0' , '15' , '26.78' ) 08/11/2025 11:35:01 am >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:35:01 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' , '215' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.92' , '114.92' , NOW() , NOW() ) 08/11/2025 11:35:01 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 = '99792' 08/11/2025 11:35:01 am >> DELETE FROM ps_document_detail WHERE id_document = '99792' 08/11/2025 11:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 08/11/2025 11:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 08/11/2025 11:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' , '2.80' , '2.8' , '0' , '15' , '45.22' ) 08/11/2025 11:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 08/11/2025 11:39:18 am >> SELECT document_num FROM ps_document WHERE document_num = '216' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:39: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' , '216' , '2025-11-08' , '' , '3748' , '0' , '4679585' , 'P. ZZA GIOVANNI PAOLO II 84090 MONTECORVINO PUGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.63' , '44.63' , NOW() , NOW() ) 08/11/2025 11:39: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 = '99793' 08/11/2025 11:39:18 am >> DELETE FROM ps_document_detail WHERE id_document = '99793' 08/11/2025 11:39: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 ( '99793' , '2679' , 'CONOSCERE GESU' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 08/11/2025 11:43:10 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1235' 08/11/2025 11:43:10 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 ( '1235' , '10' , '210' , 'PARR. SAN MARCO A ROTA' , 'ALFANO' , 'DON MICHELE' , 'P. ZZA SAN MARCO - CURTERI' , '' , '84085' , 'MERCATO S. SEVERINO' , '' , '' , '' , '' , '95006090658' , NOW() , NOW() ) 08/11/2025 11:43:10 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1235' 08/11/2025 11:43:23 am >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '99792' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:43:23 am >> UPDATE ps_document SET id_document_type = '21', document_num = '215', document_date = '2025-11-08', document_letter = '', id_customer = '1235', id_supplier = '0', id_address = '4679636', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '158.70', price_tax_excluded = '158.70', date_upd = NOW() WHERE id_document = '99792' 08/11/2025 11:43:23 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 = '99792' 08/11/2025 11:43:23 am >> DELETE FROM ps_document_detail WHERE id_document = '99792' 08/11/2025 11:43:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 08/11/2025 11:43:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 08/11/2025 11:43:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 08/11/2025 11:43:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 08/11/2025 11:43:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 08/11/2025 11:43:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 08/11/2025 11:43:40 am >> SELECT document_num FROM ps_document WHERE document_num = '216' AND id_document != '99793' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:43:40 am >> UPDATE ps_document SET id_document_type = '21', document_num = '216', document_date = '2025-11-08', document_letter = '', id_customer = '3748', id_supplier = '', id_address = '4679585', address1 = 'P. ZZA GIOVANNI PAOLO II 84090 MONTECORVINO PUGLIANO', 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 = '44.63', price_tax_excluded = '44.63', date_upd = NOW() WHERE id_document = '99793' 08/11/2025 11:43:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99793' 08/11/2025 11:43:40 am >> DELETE FROM ps_document_detail WHERE id_document = '99793' 08/11/2025 11:43:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99793' , '2679' , 'CONOSCERE GESU' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 08/11/2025 11:45:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:45: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 ( '11' , '3717' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 08/11/2025 11:45: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 = '99794' 08/11/2025 11:45:54 am >> DELETE FROM ps_document_detail WHERE id_document = '99794' 08/11/2025 11:45: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 ( '99794' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 08/11/2025 11:48:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:48:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3718' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 08/11/2025 11:48:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99795' 08/11/2025 11:48:08 am >> DELETE FROM ps_document_detail WHERE id_document = '99795' 08/11/2025 11:48:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99795' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 08/11/2025 11:48:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99795' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 08/11/2025 11:48:42 am >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '99792' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:48:42 am >> UPDATE ps_document SET id_document_type = '21', document_num = '215', document_date = '2025-11-08', document_letter = '', id_customer = '1235', id_supplier = '', id_address = '4679636', address1 = '', address2 = '', note = 'DEVE SALDARE € 65.95', 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 = '158.70', price_tax_excluded = '158.70', date_upd = NOW() WHERE id_document = '99792' 08/11/2025 11:48:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99792' 08/11/2025 11:48:42 am >> DELETE FROM ps_document_detail WHERE id_document = '99792' 08/11/2025 11:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 08/11/2025 11:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 08/11/2025 11:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 08/11/2025 11:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 08/11/2025 11:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 08/11/2025 11:48:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99792' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 08/11/2025 11:59:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 11:59:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3719' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '30.74' , NOW() , NOW() ) 08/11/2025 11:59:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99796' 08/11/2025 11:59:06 am >> DELETE FROM ps_document_detail WHERE id_document = '99796' 08/11/2025 11:59:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99796' , '14400' , 'BALZA CM 10,5 ' , '2.5' , '-2.5' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '37.50' ) 08/11/2025 12:01:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:01:31 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' , '3720' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.92' , NOW() , NOW() ) 08/11/2025 12:01:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99797' 08/11/2025 12:01:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '99797' 08/11/2025 12:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99797' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 08/11/2025 12:05:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '99314' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-17') 08/11/2025 12:05:21 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2025-10-17', document_letter = 'A', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '73.79', price_tax_excluded = '73.11', date_upd = NOW() WHERE id_document = '99314' 08/11/2025 12:05:21 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 = '99314' 08/11/2025 12:05:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '99314' 08/11/2025 12:05:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 08/11/2025 12:05:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 08/11/2025 12:05:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '4' , '-4' , '4' , '3.8000' , '3.8' , '0' , '15' , '12.92' ) 08/11/2025 12:05:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '2679' , 'CONOSCERE GESU' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 08/11/2025 12:05:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '3.75' ) 08/11/2025 12:06:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '99792' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:06:27 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '215', document_date = '2025-11-08', document_letter = '', id_customer = '1235', id_supplier = '', id_address = '4679636', address1 = '', address2 = '', note = 'DEVE SALDARE € 65.95', 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 = '158.70', price_tax_excluded = '158.70', date_upd = NOW() WHERE id_document = '99792' 08/11/2025 12:06:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99792' 08/11/2025 12:06:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '99792' 08/11/2025 12:06: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 ( '99792' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 08/11/2025 12:06: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 ( '99792' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 08/11/2025 12:06: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 ( '99792' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 08/11/2025 12:06: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 ( '99792' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 08/11/2025 12:06: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 ( '99792' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 08/11/2025 12:06: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 ( '99792' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 08/11/2025 12:20:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '217' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:20:31 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' , '217' , '2025-11-08' , '' , '1129' , '0' , '4679256' , 'P.ZZA UMBERTO I 84084 FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.64' , '87.64' , NOW() , NOW() ) 08/11/2025 12:20:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99798' 08/11/2025 12:20:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '99798' 08/11/2025 12:20:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99798' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '17' , '-17' , '4' , '3.80' , '3.8' , '0' , '15' , '54.91' ) 08/11/2025 12:20:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99798' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 08/11/2025 12:20:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99798' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '15' , '-15' , '4' , '1.90' , '1.9' , '0' , '15' , '24.23' ) 08/11/2025 12:20:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:20:45 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' , '3721' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 08/11/2025 12:20:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99799' 08/11/2025 12:20:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99799' 08/11/2025 12:20:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99799' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/11/2025 12:21:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:21:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3722' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.52' , '24.52' , NOW() , NOW() ) 08/11/2025 12:21:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99800' 08/11/2025 12:21:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99800' 08/11/2025 12:21:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99800' , '17953' , 'GIOCHIAMO CON LA BIBBIA - 4/7 ANNI' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '5' , '10.36' ) 08/11/2025 12:21:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99800' , '19931' , '100 IDEE PER IL CATECHISMO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 08/11/2025 12:22:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '217' AND id_document != '99798' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:22:48 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '217', document_date = '2025-11-08', document_letter = '', id_customer = '1129', id_supplier = '', id_address = '4679256', address1 = 'P.ZZA UMBERTO I 84084 FISCIANO', 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 = '87.64', price_tax_excluded = '87.64', date_upd = NOW() WHERE id_document = '99798' 08/11/2025 12:22: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 = '99798' 08/11/2025 12:22:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99798' 08/11/2025 12:22: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 ( '99798' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '17' , '-17' , '4' , '3.8000' , '3.8' , '0' , '15' , '54.91' ) 08/11/2025 12:22: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 ( '99798' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 08/11/2025 12:22: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 ( '99798' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '15' , '-15' , '4' , '1.9000' , '1.9' , '0' , '15' , '24.23' ) 08/11/2025 12:26:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:26: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' , '3723' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.03' , '48.30' , NOW() , NOW() ) 08/11/2025 12:26: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 = '99801' 08/11/2025 12:26:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '99801' 08/11/2025 12:26: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 ( '99801' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 08/11/2025 12:26: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 ( '99801' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 08/11/2025 12:26: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 ( '99801' , '14955' , 'DARAI ALLA LUCE UN FIGLIO - NOVENA IMMACOLATA - G. FORLAI' , '1' , '-1' , '4' , '2.580' , '2.58' , '0' , '0' , '2.58' ) 08/11/2025 12:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99801' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '2.45' , '2.45' , '0' , '0' , '2.45' ) 08/11/2025 12:59:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 08/11/2025 12:59:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3724' , '2025-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '19.26' , NOW() , NOW() ) 08/11/2025 12:59: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 = '99802' 08/11/2025 12:59:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '99802' 08/11/2025 12:59: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 ( '99802' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 08/11/2025 12:59: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 ( '99802' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' )