20/11/2025 11:01:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 11:01:45 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' , '3862' , '2025-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.49' , '12.86' , NOW() , NOW() ) 20/11/2025 11:01:45 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 = '100006' 20/11/2025 11:01:45 am >> DELETE FROM ps_document_detail WHERE id_document = '100006' 20/11/2025 11:01:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100006' , '2679' , 'CONOSCERE GESU' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '5' , '9.99' ) 20/11/2025 11:01:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100006' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 20/11/2025 11:02:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 11:02:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3863' , '2025-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 20/11/2025 11:02:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100007' 20/11/2025 11:02:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100007' 20/11/2025 11:02:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100007' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '98' , '-98' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '24.50' ) 20/11/2025 11:14:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 11:14: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 ( '11' , '3864' , '2025-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 20/11/2025 11:14: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 = '100008' 20/11/2025 11:14:21 am >> DELETE FROM ps_document_detail WHERE id_document = '100008' 20/11/2025 11:14: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 ( '100008' , '6234' , 'MARIA DONNA EUCARISTICA - MADONNA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 20/11/2025 11:23:24 am >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '99883' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-11-13') 20/11/2025 11:23:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '33', document_date = '2025-11-13', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '7136.00', price_tax_excluded = '7136.00', date_upd = NOW() WHERE id_document = '99883' 20/11/2025 11:23: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 = '99883' 20/11/2025 11:23:25 am >> DELETE FROM ps_document_detail WHERE id_document = '99883' 20/11/2025 11:23: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 ( '99883' , '11183' , 'VENITE CON ME - GUIDA' , '20' , '-20' , '4' , '8.0000' , '8' , '0' , '0' , '160.00' ) 20/11/2025 11:23: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 ( '99883' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '640' , '-640' , '4' , '3.0000' , '3' , '0' , '0' , '1920.00' ) 20/11/2025 11:23: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 ( '99883' , '24129' , 'DIECI COMANDAMENTI - M. DE ROSA' , '60' , '-60' , '4' , '6.0000' , '6' , '0' , '0' , '360.00' ) 20/11/2025 11:23: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 ( '99883' , '18357' , 'MIE PREGHIERINE N.E.' , '800' , '-800' , '4' , '1.5000' , '1.5' , '0' , '0' , '1200.00' ) 20/11/2025 11:23: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 ( '99883' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '280' , '-280' , '4' , '3.5000' , '3.5' , '0' , '0' , '980.00' ) 20/11/2025 11:23: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 ( '99883' , '24202' , 'GRANDI DONNE E GRANDI SANTE' , '50' , '-50' , '4' , '6.0000' , '6' , '0' , '0' , '300.00' ) 20/11/2025 11:23: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 ( '99883' , '23677' , 'RICETTE DI MAMMA ROSA' , '10' , '-10' , '4' , '20.0000' , '20' , '0' , '0' , '200.00' ) 20/11/2025 11:23: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 ( '99883' , '11192' , 'VENITE CON ME 2 PARTE' , '720' , '-720' , '4' , '2.8000' , '2.8' , '0' , '0' , '2016.00' ) 20/11/2025 11:23:49 am >> DELETE FROM ps_document WHERE id_document = '99789' 20/11/2025 11:23:49 am >> DELETE FROM ps_document_detail WHERE id_document = '99789' 20/11/2025 11:25:49 am >> SELECT document_num FROM ps_document WHERE document_num = '125/A' AND id_document != '99322' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-18') 20/11/2025 11:25:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '125/A', document_date = '2025-10-18', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA BATTIPAGLIA', 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 = '71.70', price_tax_excluded = '69.82', date_upd = NOW() WHERE id_document = '99322' 20/11/2025 11:25:49 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 = '99322' 20/11/2025 11:25:49 am >> DELETE FROM ps_document_detail WHERE id_document = '99322' 20/11/2025 11:25: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 ( '99322' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 20/11/2025 11:25: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 ( '99322' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 20/11/2025 11:25: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 ( '99322' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/11/2025 11:25: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 ( '99322' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 20/11/2025 11:25: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 ( '99322' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 20/11/2025 11:25: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 ( '99322' , '0' , 'PREGHIERA DEL MALATO' , '200' , '-200' , '4' , '0.1500' , '0.15' , '0' , '0' , '30.00' ) 20/11/2025 11:55:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 11:55:43 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' , '3865' , '2025-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 20/11/2025 11:55:43 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 = '100009' 20/11/2025 11:55:43 am >> DELETE FROM ps_document_detail WHERE id_document = '100009' 20/11/2025 11:55:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100009' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 20/11/2025 11:55:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100009' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 20/11/2025 11:55:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100009' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 20/11/2025 11:55:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100009' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 20/11/2025 11:56:12 am >> SELECT document_num FROM ps_document WHERE document_num = '249' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 11:56: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 ( '21' , '249' , '2025-11-20' , '' , '292' , '0' , '4676365' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.60' , '47.60' , NOW() , NOW() ) 20/11/2025 11:56: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 = '100010' 20/11/2025 11:56:12 am >> DELETE FROM ps_document_detail WHERE id_document = '100010' 20/11/2025 11:56: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 ( '100010' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 20/11/2025 12:04:25 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3463' 20/11/2025 12:04:25 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3463' , '10' , '210' , 'PARROCCHIA SAN BARTOLOMEO' , 'VIVO' , 'DON EMMANUEL' , 'VIA G. AMENDOLA, 81' , '' , '84025' , 'EBOLI' , '' , '0828 364940' , '' , '' , '91004780655' , NOW() , NOW() ) 20/11/2025 12:04:25 pm >> UPDATE ps_customer SET email = 'san.bartolomeo.eboli@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3463' 20/11/2025 12:13:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '250' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 12:13: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 ( '21' , '250' , '2025-11-20' , '' , '3463' , '0' , '4679654' , 'VIA G. AMENDOLA, 81 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.25' , '89.25' , NOW() , NOW() ) 20/11/2025 12:13: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 = '100011' 20/11/2025 12:13:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '100011' 20/11/2025 12:13: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 ( '100011' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 20/11/2025 12:28:44 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') 20/11/2025 12:28:44 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 = '167.20', price_tax_excluded = '167.20', date_upd = NOW() WHERE id_document = '99792' 20/11/2025 12:28:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99792' 20/11/2025 12:28:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '99792' 20/11/2025 12:28: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 ( '99792' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 20/11/2025 12:28: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 ( '99792' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 20/11/2025 12:28: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 ( '99792' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 20/11/2025 12:28: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 ( '99792' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 20/11/2025 12:28: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 ( '99792' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 20/11/2025 12:28: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 ( '99792' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 20/11/2025 12:28: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 ( '99792' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 20/11/2025 12:28: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 ( '99792' , '2679' , 'CONOSCERE GESU' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 20/11/2025 12:31:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3866' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 12:31:58 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' , '3866' , '2025-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '24.50' , NOW() , NOW() ) 20/11/2025 12:31:58 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 = '100012' 20/11/2025 12:31:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '100012' 20/11/2025 12:31:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100012' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 20/11/2025 12:31:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100012' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 20/11/2025 12:41:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3867' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 12:41:21 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' , '3867' , '2025-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.16' , '149.85' , NOW() , NOW() ) 20/11/2025 12:41: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 = '100013' 20/11/2025 12:41:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '100013' 20/11/2025 12:41: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 ( '100013' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/11/2025 12:41: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 ( '100013' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 20/11/2025 12:41: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 ( '100013' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 20/11/2025 12:41: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 ( '100013' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 20/11/2025 12:41: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 ( '100013' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 20/11/2025 12:41: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 ( '100013' , '8275' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 2 - TEMPO ORDINARIO' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 20/11/2025 12:41: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 ( '100013' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 20/11/2025 12:47:51 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') 20/11/2025 12:47:51 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 = '', 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 = '167.20', price_tax_excluded = '167.20', date_upd = NOW() WHERE id_document = '99792' 20/11/2025 12:47: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 = '99792' 20/11/2025 12:47:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '99792' 20/11/2025 12:47: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 ( '99792' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 20/11/2025 12:47: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 ( '99792' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 20/11/2025 12:47: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 ( '99792' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 20/11/2025 12:47: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 ( '99792' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 20/11/2025 12:47: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 ( '99792' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 20/11/2025 12:47:52 pm >> INSERT INTO ps_document_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' ) 20/11/2025 12:47:52 pm >> INSERT INTO ps_document_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.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 20/11/2025 12:47:52 pm >> INSERT INTO ps_document_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' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 20/11/2025 12:49:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '99990' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-19') 20/11/2025 12:49:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '247', document_date = '2025-11-19', document_letter = '', id_customer = '1083', id_supplier = '', id_address = '4674059', address1 = 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO', 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 = '217.09', price_tax_excluded = '217.09', date_upd = NOW() WHERE id_document = '99990' 20/11/2025 12:49: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 = '99990' 20/11/2025 12:49:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99990' 20/11/2025 12:49: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 ( '99990' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '15' , '10.20' ) 20/11/2025 12:49: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 ( '99990' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 20/11/2025 12:49: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 ( '99990' , '11192' , 'VENITE CON ME 2 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 20/11/2025 12:49: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 ( '99990' , '11191' , 'VENITE CON ME 1 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 20/11/2025 12:49: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 ( '99990' , '2679' , 'CONOSCERE GESU' , '26' , '-26' , '4' , '3.5000' , '3.5' , '0' , '15' , '77.35' ) 20/11/2025 02:07:01 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/11/2025 02:07:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24298' , '1' , '' , 'nuovo-prodotto' ) 20/11/2025 02:07:01 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24298' , '1' , '1' , '2' , NOW() , NOW() ) 20/11/2025 02:07:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24298' , '0' , '1' , '0' , '0' ) 20/11/2025 02:07:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826610474' AND id_product != '24298' AND ean13 != '' 20/11/2025 02:07:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788826610474', date_upd = NOW() WHERE id_product = '24298' 20/11/2025 02:07:39 pm >> UPDATE ps_product_lang SET name = 'DISEGNARE NUOVE MAPPE DI SPERANZA', description = '' WHERE id_product = '24298' 20/11/2025 02:07:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '24298' 20/11/2025 02:07:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24298' 20/11/2025 02:07:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '24298' 20/11/2025 02:07:40 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24298' 20/11/2025 02:07:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24299' , '1' , '' , 'nuovo-prodotto' ) 20/11/2025 02:07:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24299' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24298' 20/11/2025 02:07:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24299' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24298' 20/11/2025 02:09: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 ( '33' , '716736' , '2025-11-19' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.16' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '149.46' , '149.46' , NOW() , NOW() ) 20/11/2025 02:09: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 = '100014' 20/11/2025 02:09:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100014' 20/11/2025 02:09: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 ( '100014' , '16686' , 'EVANGELIARIO' , '1' , '1' , '4' , '150.00' , '150' , '0' , '30' , '105.0000' ) 20/11/2025 02:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16686' AND id_supplier = '7' 20/11/2025 02:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16686' , '7' , '1' ) 20/11/2025 02:09: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 ( '100014' , '23881' , 'VITA RESPONSABILE - D. BONHOEFFER' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 20/11/2025 02:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23881' AND id_supplier = '7' 20/11/2025 02:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23881' , '7' , '1' ) 20/11/2025 02:09: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 ( '100014' , '24298' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '24' , '24' , '4' , '2.00' , '2' , '0' , '30' , '33.6000' ) 20/11/2025 02:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24298' AND id_supplier = '7' 20/11/2025 02:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24298' , '7' , '1' ) 20/11/2025 02:09: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 ( '100014' , '24298' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '2' , '2' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 20/11/2025 02:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24298' AND id_supplier = '7' 20/11/2025 02:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24298' , '7' , '1' ) 20/11/2025 03:51:42 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'TnMikKzTqUr1H4IC' , NOW() , NOW() ) 20/11/2025 03:51:42 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4287' , '1' ) 20/11/2025 03:51:42 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4287' , '2' ) 20/11/2025 03:51:42 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4287' , '3' ) 20/11/2025 03:53:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4287' 20/11/2025 03:53:44 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4287' , '10' , '223' , 'PARROCCHIA MADONNA DEL MARE' , 'MUSCHI' , 'DON VALERIO ' , 'PIAZZALE ROSMINI 6' , '' , '34143' , 'TRIESTE' , '' , '' , '' , '' , '90031430326 ' , NOW() , NOW() ) 20/11/2025 03:53:44 pm >> UPDATE ps_customer SET email = 'parrocchia@madonnadelmare.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4287' 20/11/2025 03:54:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '251' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 03:54:20 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' , '251' , '2025-11-20' , '' , '4287' , '0' , '4679655' , 'PIAZZALE ROSMINI 6 34143 TRIESTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '96.90' , '96.90' , NOW() , NOW() ) 20/11/2025 03:54:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100015' 20/11/2025 03:54:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '100015' 20/11/2025 03:54:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100015' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '60' , '-60' , '4' , '1.90' , '1.9' , '0' , '15' , '96.90' ) 20/11/2025 03:59:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '250' AND id_document != '100011' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 03:59:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '250', document_date = '2025-11-20', document_letter = '', id_customer = '3463', id_supplier = '', id_address = '4679654', address1 = 'VIA G. AMENDOLA, 81 84025 EBOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '89.25', price_tax_excluded = '89.25', date_upd = NOW() WHERE id_document = '100011' 20/11/2025 03:59: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 = '100011' 20/11/2025 03:59:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '100011' 20/11/2025 03:59: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 ( '100011' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 20/11/2025 03:59:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '249' AND id_document != '100010' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 03:59:23 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '249', document_date = '2025-11-20', document_letter = '', id_customer = '292', id_supplier = '', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '47.60', price_tax_excluded = '47.60', date_upd = NOW() WHERE id_document = '100010' 20/11/2025 03:59:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100010' 20/11/2025 03:59:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100010' 20/11/2025 03:59:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100010' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 20/11/2025 04:05:20 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '79', document_date = '2025-01-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2631', address1 = 'VIA FRIZZONI,56 24048 TREVIOLO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '6972.73', price_tax_excluded = '5715.35', date_upd = NOW() WHERE id_document = '95399' 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95399' 20/11/2025 04:05:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '95399' 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '1914' , 'CERA DELLA LITURGIA' , '1080' , '1080' , '1' , '2.2000' , '1.8032786885246' , '22' , '3' , '2811.76' ) 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1440' , '1440' , '1' , '1.5900' , '1.3032786885246' , '22' , '3' , '2709.51' ) 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '16796' , 'LUMINO 5B BIANCO' , '8064' , '8064' , '1' , '0.1000' , '0.081967213114754' , '22' , '3' , '954.29' ) 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '6809' , 'MOCCOLO 60X165' , '32' , '32' , '1' , '1.9200' , '1.5737704918033' , '22' , '3' , '72.71' ) 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '6810' , 'MOCCOLO 80X150' , '24' , '24' , '1' , '2.9800' , '2.4426229508197' , '22' , '3' , '84.64' ) 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '21137' , 'MOCCOLO 70X200' , '32' , '32' , '1' , '2.9800' , '2.4426229508197' , '22' , '3' , '112.85' ) 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '10475' , 'TEALIGHTS X 50 ' , '36' , '36' , '1' , '2.5000' , '2.0491803278689' , '22' , '3' , '106.51' ) 20/11/2025 04:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '6811' , 'MOCCOLO 80X200' , '27' , '27' , '1' , '3.77' , '3.0901639344262' , '22' , '3' , '120.4583' ) 20/11/2025 04:08:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3711' AND id_document != '99783' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-08') 20/11/2025 04:08:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3711', document_date = '2025-11-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.00', price_tax_excluded = '34.43', date_upd = NOW() WHERE id_document = '99783' 20/11/2025 04:08: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 = '99783' 20/11/2025 04:08:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99783' 20/11/2025 04:08: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 ( '99783' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '30' , '-30' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '30.00' ) 20/11/2025 04:08: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 ( '99783' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '6' , '4.9180327868852' , '22' , '0' , '12.00' ) 20/11/2025 04:08:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3775' AND id_document != '99879' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-13') 20/11/2025 04:08:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3775', document_date = '2025-11-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '115.00', price_tax_excluded = '94.26', date_upd = NOW() WHERE id_document = '99879' 20/11/2025 04:08:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99879' 20/11/2025 04:08:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '99879' 20/11/2025 04:08: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 ( '99879' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/11/2025 04:08: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 ( '99879' , '19150' , 'MOCCOLO 70X200' , '5' , '-5' , '1' , '5' , '4.0983606557377' , '22' , '0' , '25.00' ) 20/11/2025 04:09:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3811' AND id_document != '99928' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-15') 20/11/2025 04:09:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3811', document_date = '2025-11-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '65.08', date_upd = NOW() WHERE id_document = '99928' 20/11/2025 04:09: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 = '99928' 20/11/2025 04:09:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99928' 20/11/2025 04:09: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 ( '99928' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 20/11/2025 04:09: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 ( '99928' , '19150' , 'MOCCOLO 70X200' , '11' , '-11' , '1' , '5' , '4.0983606557377' , '22' , '0' , '55.00' ) 20/11/2025 04:10:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3856' AND id_document != '99997' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-19') 20/11/2025 04:10:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3856', document_date = '2025-11-19', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '99997' 20/11/2025 04:10: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 = '99997' 20/11/2025 04:10:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '99997' 20/11/2025 04:10: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 ( '99997' , '19150' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 20/11/2025 04:10: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 ( '99997' , '20029' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 20/11/2025 04:15:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3523' AND id_document != '99488' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-25') 20/11/2025 04:15:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3523', document_date = '2025-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '99488' 20/11/2025 04:15:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99488' 20/11/2025 04:15:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99488' 20/11/2025 04:15:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99488' , '13141' , 'CORONA D\'AVVENTO ' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 20/11/2025 04:15:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99488' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '20.00' ) 20/11/2025 04:15:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99488' , '20029' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '5' , '4.0983606557377' , '22' , '0' , '20.00' ) 20/11/2025 04:15:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3516' AND id_document != '99480' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-25') 20/11/2025 04:15:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3516', document_date = '2025-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '99480' 20/11/2025 04:15:33 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 = '99480' 20/11/2025 04:15:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '99480' 20/11/2025 04:15:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99480' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/11/2025 04:15:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99480' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/11/2025 04:15:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99480' , '20029' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '7' , '5.7377049180328' , '22' , '0' , '28.00' ) 20/11/2025 04:16:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '837' AND id_document != '96190' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-12') 20/11/2025 04:16:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '837', document_date = '2025-03-12', 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 = '32.50', price_tax_excluded = '26.64', date_upd = NOW() WHERE id_document = '96190' 20/11/2025 04: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 = '96190' 20/11/2025 04:16:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '96190' 20/11/2025 04: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 ( '96190' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '6.50' ) 20/11/2025 04: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 ( '96190' , '20029' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '26.00' ) 20/11/2025 04:16:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1085' AND id_document != '96509' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-04') 20/11/2025 04:16:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1085', document_date = '2025-04-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.00', price_tax_excluded = '5.74', date_upd = NOW() WHERE id_document = '96509' 20/11/2025 04:16:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96509' 20/11/2025 04:16:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '96509' 20/11/2025 04:16:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96509' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 20/11/2025 04:17:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3570' AND id_document != '74819' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-23') 20/11/2025 04:17:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3570', document_date = '2022-11-23', 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 = '28.00', price_tax_excluded = '22.95', date_upd = NOW() WHERE id_document = '74819' 20/11/2025 04:17:16 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 = '74819' 20/11/2025 04:17:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '74819' 20/11/2025 04:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74819' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '7' , '5.7377049180328' , '22' , '0' , '28.00' ) 20/11/2025 04:18:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '4300' AND id_document != '49809' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2021-12-22') 20/11/2025 04:18:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4300', document_date = '2021-12-22', 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 = '113.50', price_tax_excluded = '93.03', date_upd = NOW() WHERE id_document = '49809' 20/11/2025 04:18:10 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 = '49809' 20/11/2025 04:18:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '49809' 20/11/2025 04:18:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49809' , '6809' , 'MOCCOLO 60X165' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '42.00' ) 20/11/2025 04:18:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49809' , '6811' , 'MOCCOLO 80X200' , '10' , '-10' , '1' , '7.15' , '5.8606557377049' , '22' , '0' , '71.50' ) 20/11/2025 04:20:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3369' AND id_document != '70922' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-07') 20/11/2025 04:20:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3369', document_date = '2022-11-07', 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 = '42.00', price_tax_excluded = '34.43', date_upd = NOW() WHERE id_document = '70922' 20/11/2025 04:20: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 = '70922' 20/11/2025 04:20:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '70922' 20/11/2025 04:20: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 ( '70922' , '6810' , 'MOCCOLO 80X150' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 20/11/2025 04:20: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 ( '70922' , '21137' , 'MOCCOLO 70X200' , '5' , '-5' , '1' , '7' , '5.7377049180328' , '22' , '0' , '35.00' ) 20/11/2025 04:24: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 ( '31' , '752/25' , '2025-11-14' , '25' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '960.00' , '923.08' , NOW() , NOW() ) 20/11/2025 04:24: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 = '100016' 20/11/2025 04:24:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '100016' 20/11/2025 04:24:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100016' , '24202' , 'GRANDI DONNE E GRANDI SANTE' , '1500' , '1500' , '3' , '0.615385' , '0.59171634615385' , '4' , '0' , '960.0006' ) 20/11/2025 04:24:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24202' AND id_supplier = '159' 20/11/2025 04:24:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24202' , '159' , '1' ) 20/11/2025 04:32:37 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'kalwJjRaTcKxigSL' , NOW() , NOW() ) 20/11/2025 04:32:37 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4288' , '1' ) 20/11/2025 04:32:37 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4288' , '2' ) 20/11/2025 04:32:37 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4288' , '3' ) 20/11/2025 04:35:02 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4288' 20/11/2025 04:35:02 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4288' , '10' , '170' , 'PARROCCHIA SS SIMONE E GIUDA IN TABIACO' , 'BIANCHI' , 'DON LUIGI' , 'VIA DON OLIMPIO MONETA 7' , '' , '23825' , 'NIBIONNO' , '' , '' , '' , '' , '91002820131' , NOW() , NOW() ) 20/11/2025 04:35:02 pm >> UPDATE ps_customer SET email = 'donluigibianchi@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4288' 20/11/2025 04:36:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '252' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-20') 20/11/2025 04:36:15 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' , '252' , '2025-11-20' , '' , '4288' , '0' , '4679656' , 'VIA DON OLIMPIO MONETA 7 23825 NIBIONNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '120.00' , '120.00' , NOW() , NOW() ) 20/11/2025 04:36: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 = '100017' 20/11/2025 04:36:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '100017' 20/11/2025 04:36: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 ( '100017' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '60' , '-60' , '4' , '2' , '2' , '0' , '0' , '120.00' ) 20/11/2025 04:46:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3361' AND id_document != '99248' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-15') 20/11/2025 04:46:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3361', document_date = '2025-10-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '109.70', price_tax_excluded = '93.78', date_upd = NOW() WHERE id_document = '99248' 20/11/2025 04:46:08 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 = '99248' 20/11/2025 04:46:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '99248' 20/11/2025 04:46: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 ( '99248' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 20/11/2025 04:46: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 ( '99248' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 20/11/2025 04:46: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 ( '99248' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 20/11/2025 04:46: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 ( '99248' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/11/2025 04:46: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 ( '99248' , '24142' , 'DILEXI TE' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/11/2025 04:46: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 ( '99248' , '23807' , 'CALENDARIO LITURGICO 2026' , '2' , '-2' , '4' , '0.8000' , '0.8' , '0' , '0' , '1.60' ) 20/11/2025 04:46: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 ( '99248' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/11/2025 04:46: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 ( '99248' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '5' , '4.0983606557377' , '22' , '0' , '20.00' ) 20/11/2025 04:46: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 ( '99248' , '6811' , 'MOCCOLO 80X200' , '3' , '-3' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '28.50' ) 20/11/2025 04:46: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 ( '99248' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 20/11/2025 04:46:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3940' AND id_document != '94854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-13') 20/11/2025 04:46:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3940', document_date = '2024-12-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '900.00', price_tax_excluded = '761.06', date_upd = NOW() WHERE id_document = '94854' 20/11/2025 04:46: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 = '94854' 20/11/2025 04:46:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94854' 20/11/2025 04:46: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 ( '94854' , '16796' , 'LUMINO 5B BIANCO' , '1680' , '-1680' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '336.00' ) 20/11/2025 04:46: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 ( '94854' , '1914' , 'CERA DELLA LITURGIA' , '30' , '-30' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '135.00' ) 20/11/2025 04:46: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 ( '94854' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 20/11/2025 04:46: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 ( '94854' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 20/11/2025 04:46: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 ( '94854' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '60.00' ) 20/11/2025 04:46: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 ( '94854' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '18.00' ) 20/11/2025 04:46: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 ( '94854' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 20/11/2025 04:46: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 ( '94854' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/11/2025 04:46: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 ( '94854' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 20/11/2025 04:46: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 ( '94854' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 20/11/2025 04:46: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 ( '94854' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 20/11/2025 04:46: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 ( '94854' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 20/11/2025 04:46: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 ( '94854' , '9715' , 'SCATOLA PORTA OSTIE - CM 17 - 683' , '1' , '-1' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '41.00' ) 20/11/2025 04:46: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 ( '94854' , '22496' , 'PREGHIERA CATECHESI PAPA FRANCESCO - 8654' , '1' , '-1' , '4' , '5.9500' , '5.95' , '0' , '0' , '5.95' ) 20/11/2025 04:46: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 ( '94854' , '23169' , 'DILEXIT NOS ' , '45' , '-45' , '4' , '2.2000' , '2.2' , '0' , '5' , '94.05' ) 20/11/2025 04:47:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3497' AND id_document != '94289' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-15') 20/11/2025 04:47:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3497', document_date = '2024-11-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.70', price_tax_excluded = '15.33', date_upd = NOW() WHERE id_document = '94289' 20/11/2025 04:47: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 = '94289' 20/11/2025 04:47:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94289' 20/11/2025 04:47: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 ( '94289' , '2653' , 'CONFEZIONE CARTONCINO CON BAMBINO - P391' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 20/11/2025 04:47: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 ( '94289' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '18.00' ) 20/11/2025 04:47:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3374' AND id_document != '94119' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-07') 20/11/2025 04:47:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3374', document_date = '2024-11-07', 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 = '220.80', price_tax_excluded = '188.21', date_upd = NOW() WHERE id_document = '94119' 20/11/2025 04:47: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 = '94119' 20/11/2025 04:47:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94119' 20/11/2025 04:47: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 ( '94119' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 20/11/2025 04:47: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 ( '94119' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 20/11/2025 04:47: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 ( '94119' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 20/11/2025 04:47: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 ( '94119' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '100' , '0.00' ) 20/11/2025 04:47:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94119' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 20/11/2025 04:47:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94119' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '18.00' ) 20/11/2025 04:47:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94119' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '34.00' ) 20/11/2025 04:47:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94119' , '14114' , 'CINGOLO ORO - CING08ORO' , '4' , '-4' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '120.00' ) 20/11/2025 04:49:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3817' AND id_document != '99939' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-17') 20/11/2025 04:49:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3817', document_date = '2025-11-17', 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 = '250.00', price_tax_excluded = '204.92', date_upd = NOW() WHERE id_document = '99939' 20/11/2025 04:49: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 = '99939' 20/11/2025 04:49:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99939' 20/11/2025 04: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 ( '99939' , '15210' , 'CERO PASQUALE API 80X120' , '5' , '-5' , '1' , '50' , '40.983606557377' , '22' , '0' , '250.00' ) 20/11/2025 04:51:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1337' AND id_document != '96798' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 20/11/2025 04:51:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1337', document_date = '2025-04-22', 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 = '1046.80', price_tax_excluded = '880.10', date_upd = NOW() WHERE id_document = '96798' 20/11/2025 04:51: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 = '96798' 20/11/2025 04:51:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '96798' 20/11/2025 04:51: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 ( '96798' , '16796' , 'LUMINO 5B BIANCO' , '476' , '-476' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '95.20' ) 20/11/2025 04:51: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 ( '96798' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '120.00' ) 20/11/2025 04:51: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 ( '96798' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 20/11/2025 04:51: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 ( '96798' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 20/11/2025 04:51: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 ( '96798' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 20/11/2025 04:51: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 ( '96798' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 20/11/2025 04:51: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 ( '96798' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/11/2025 04:51: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 ( '96798' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 20/11/2025 04:51: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 ( '96798' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/11/2025 04:51: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 ( '96798' , '6405' , 'MENSA DIAM 40X250 - M4025' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 20/11/2025 04:51: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 ( '96798' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.6000' , '0.6' , '0' , '0' , '0.60' ) 20/11/2025 04:51: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 ( '96798' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 20/11/2025 04:51: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 ( '96798' , '17141' , 'RICAMBIO VETRO - 34/V' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 20/11/2025 04:51: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 ( '96798' , '23605' , 'CALICE BAROCCO - 1887' , '1' , '-1' , '1' , '308.0000' , '252.45901639344' , '22' , '0' , '308.00' ) 20/11/2025 04:51: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 ( '96798' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '5' , '95.00' ) 20/11/2025 04:51:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96798' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 20/11/2025 04:51:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1336' AND id_document != '96797' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-22') 20/11/2025 04:51:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1336', document_date = '2025-04-22', 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 = '971.00', price_tax_excluded = '811.40', date_upd = NOW() WHERE id_document = '96797' 20/11/2025 04:51: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 = '96797' 20/11/2025 04:51:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '96797' 20/11/2025 04:51: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 ( '96797' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 20/11/2025 04:51: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 ( '96797' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '48.00' ) 20/11/2025 04:51: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 ( '96797' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 20/11/2025 04:51: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 ( '96797' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '-3360' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '672.00' ) 20/11/2025 04:51: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 ( '96797' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/11/2025 04:51: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 ( '96797' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 20/11/2025 04:51: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 ( '96797' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/11/2025 04:51: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 ( '96797' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/11/2025 04:51: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 ( '96797' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '12' , '-12' , '4' , '5.0000' , '5' , '0' , '5' , '57.00' ) 20/11/2025 04:51: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 ( '96797' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 20/11/2025 04:52:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1265' AND id_document != '96710' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 20/11/2025 04:52:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1265', document_date = '2025-04-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '979.40', price_tax_excluded = '848.39', date_upd = NOW() WHERE id_document = '96710' 20/11/2025 04:52: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 = '96710' 20/11/2025 04:52:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '96710' 20/11/2025 04:52: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 ( '96710' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/11/2025 04:52: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 ( '96710' , '23503' , 'TRISTE CASO DELL\'OMELIA - F. ROSINI' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 20/11/2025 04:52: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 ( '96710' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '10' , '-10' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '18.00' ) 20/11/2025 04:52: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 ( '96710' , '15210' , 'CERO PASQUALE API 80X120' , '4' , '-4' , '1' , '60' , '49.180327868852' , '22' , '0' , '240.00' ) 20/11/2025 04:52: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 ( '96710' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 20/11/2025 04:52: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 ( '96710' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 20/11/2025 04:52: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 ( '96710' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 20/11/2025 04:52: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 ( '96710' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 20/11/2025 04:52: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 ( '96710' , '23672' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/3 - RATZINGER' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '5' , '71.25' ) 20/11/2025 04:52: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 ( '96710' , '23671' , 'IN DIALOGO CON IL PROPRIO TEMPO - 13/1-2 - RATZINGER' , '1' , '-1' , '4' , '130.0000' , '130' , '0' , '5' , '123.50' ) 20/11/2025 04:52: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 ( '96710' , '19757' , 'PIVIALE - KKP/024/02/20' , '1' , '-1' , '1' , '350.0000' , '286.88524590164' , '22' , '0' , '350.00' ) 20/11/2025 04:52: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 ( '96710' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.0000' , '7' , '0' , '5' , '19.95' ) 20/11/2025 04:52: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 ( '96710' , '1938' , 'CERO PASQUALE API 80X100' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 20/11/2025 04:53:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2487' AND id_document != '98140' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-18') 20/11/2025 04:53:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2487', document_date = '2025-07-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '520.50', price_tax_excluded = '431.05', date_upd = NOW() WHERE id_document = '98140' 20/11/2025 04:53: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 = '98140' 20/11/2025 04:53:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '98140' 20/11/2025 04:53: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 ( '98140' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '25' , '-25' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '60.00' ) 20/11/2025 04:53: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 ( '98140' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '18' , '-18' , '4' , '0.7000' , '0.7' , '0' , '0' , '12.60' ) 20/11/2025 04:53: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 ( '98140' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/11/2025 04:53: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 ( '98140' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/11/2025 04:53: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 ( '98140' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 20/11/2025 04:53: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 ( '98140' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/11/2025 04:53: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 ( '98140' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 20/11/2025 04:53: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 ( '98140' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.3400' , '2.7377049180328' , '22' , '0' , '10.02' ) 20/11/2025 04:53: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 ( '98140' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/11/2025 04:53: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 ( '98140' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 20/11/2025 04:53: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 ( '98140' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 20/11/2025 04:53: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 ( '98140' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.0800' , '2' , '4' , '0' , '2.08' ) 20/11/2025 04:53: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 ( '98140' , '23052' , 'DALMATICA MORELLO - PDA004' , '1' , '-1' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '90.00' ) 20/11/2025 04:53: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 ( '98140' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 20/11/2025 04:54:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1192' AND id_document != '96631' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-11') 20/11/2025 04:54:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1192', document_date = '2025-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '492.00', price_tax_excluded = '416.63', date_upd = NOW() WHERE id_document = '96631' 20/11/2025 04:54: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 = '96631' 20/11/2025 04:54:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '96631' 20/11/2025 04:54: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 ( '96631' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 20/11/2025 04:54: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 ( '96631' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 20/11/2025 04:54: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 ( '96631' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.15' ) 20/11/2025 04:54: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 ( '96631' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '14' , '-14' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '49.00' ) 20/11/2025 04:54: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 ( '96631' , '7311' , 'OSTIA SOTTILE 74MM' , '18' , '-18' , '3' , '1.0000' , '0.96153846153846' , '4' , '0' , '18.00' ) 20/11/2025 04:54: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 ( '96631' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '9.00' ) 20/11/2025 04:54: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 ( '96631' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 20/11/2025 04:54: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 ( '96631' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 20/11/2025 04:54: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 ( '96631' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 20/11/2025 04:54: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 ( '96631' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/11/2025 04:54: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 ( '96631' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/11/2025 04:54: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 ( '96631' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/11/2025 04:54: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 ( '96631' , '2168' , 'CLERGY BASIC - ML - B&P' , '2' , '-2' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '72.00' ) 20/11/2025 04:54: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 ( '96631' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '7' , '-7' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '2.10' ) 20/11/2025 04:54: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 ( '96631' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '7' , '-7' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '1.75' ) 20/11/2025 04:54: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 ( '96631' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '7' , '-7' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '1.75' ) 20/11/2025 04:54: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 ( '96631' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '5' , '-5' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '3.50' ) 20/11/2025 04:54: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 ( '96631' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 20/11/2025 04:54: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 ( '96631' , '18561' , 'FORMELLA SAGOMATA 26X26 ' , '1' , '-1' , '1' , '80.0000' , '65.573770491803' , '22' , '0' , '80.00' ) 20/11/2025 04:54: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 ( '96631' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 20/11/2025 04:55:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1190' AND id_document != '96628' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-11') 20/11/2025 04:55:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1190', document_date = '2025-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '185.00', price_tax_excluded = '158.13', date_upd = NOW() WHERE id_document = '96628' 20/11/2025 04:55: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 = '96628' 20/11/2025 04:55:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '96628' 20/11/2025 04:55: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 ( '96628' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 20/11/2025 04:55: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 ( '96628' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/11/2025 04:55: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 ( '96628' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '69.5' , '56.967213114754' , '22' , '0' , '139.00' ) 20/11/2025 04:55: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 ( '96628' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '12' , '-12' , '4' , '3.0000' , '3' , '0' , '0' , '36.00' ) 20/11/2025 04:56:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1169' AND id_document != '96604' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-10') 20/11/2025 04:56:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1169', document_date = '2025-04-10', 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 = '139.00', price_tax_excluded = '113.93', date_upd = NOW() WHERE id_document = '96604' 20/11/2025 04:56:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96604' 20/11/2025 04:56:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '96604' 20/11/2025 04:56:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96604' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '69.5' , '56.967213114754' , '22' , '0' , '139.00' ) 20/11/2025 04:56:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1156' AND id_document != '96587' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-09') 20/11/2025 04:56:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1156', document_date = '2025-04-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '310.00', price_tax_excluded = '254.10', date_upd = NOW() WHERE id_document = '96587' 20/11/2025 04:56: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 = '96587' 20/11/2025 04:56:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '96587' 20/11/2025 04:56: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 ( '96587' , '15210' , 'CERO PASQUALE API 80X120' , '4' , '-4' , '1' , '72.5' , '59.426229508197' , '22' , '0' , '290.00' ) 20/11/2025 04:56: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 ( '96587' , '22433' , 'COPRI BOTTONE - 22178' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 20/11/2025 05:24:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '126/A' AND id_document != '99347' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-20') 20/11/2025 05:24:05 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '126/A', document_date = '2025-10-20', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA UNIVERSITARIA - DON CESARE D\'ANDREA', 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 = '146.20', price_tax_excluded = '123.60', date_upd = NOW() WHERE id_document = '99347' 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99347' 20/11/2025 05:24:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99347' 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '22809' , 'O LUCE BEATISSIMA' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '0' , '12.50' ) 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' , '33.5000' , '27.459016393443' , '22' , '0' , '33.50' ) 20/11/2025 05:24:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99347' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/11/2025 05:25:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '126/A' AND id_document != '99347' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-20') 20/11/2025 05:25:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '126/A', document_date = '2025-10-20', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA UNIVERSITARIA - DON CESARE D\'ANDREA', 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 = '159.50', price_tax_excluded = '134.50', date_upd = NOW() WHERE id_document = '99347' 20/11/2025 05:25: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 = '99347' 20/11/2025 05:25:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99347' 20/11/2025 05:25: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 ( '99347' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 20/11/2025 05:25: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 ( '99347' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 20/11/2025 05:25: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 ( '99347' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/11/2025 05:25: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 ( '99347' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/11/2025 05:25: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 ( '99347' , '22809' , 'O LUCE BEATISSIMA' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '0' , '12.50' ) 20/11/2025 05:25: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 ( '99347' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' , '33.5000' , '27.459016393443' , '22' , '0' , '33.50' ) 20/11/2025 05:25: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 ( '99347' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 20/11/2025 05:25: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 ( '99347' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '13.30' ) 20/11/2025 06:17:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '702' AND id_document != '96009' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-03') 20/11/2025 06:17:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '702', document_date = '2025-03-03', 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 = '111.50', price_tax_excluded = '94.48', date_upd = NOW() WHERE id_document = '96009' 20/11/2025 06:17: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 = '96009' 20/11/2025 06:17:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96009' 20/11/2025 06:17: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 ( '96009' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '36' , '-36' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '90.00' ) 20/11/2025 06:17: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 ( '96009' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 20/11/2025 06:17: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 ( '96009' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 20/11/2025 06:17: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 ( '96009' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 20/11/2025 06:17:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '253' AND id_document != '95426' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 20/11/2025 06:17:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '253', document_date = '2025-01-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 = '21.00', price_tax_excluded = '17.21', date_upd = NOW() WHERE id_document = '95426' 20/11/2025 06:17: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 = '95426' 20/11/2025 06:17:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '95426' 20/11/2025 06:17: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 ( '95426' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '7' , '-7' , '1' , '3' , '2.4590163934426' , '22' , '0' , '21.00' ) 20/11/2025 06:18:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3604' AND id_document != '94435' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 20/11/2025 06:18:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3604', document_date = '2024-11-22', 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 = '92.20', price_tax_excluded = '75.97', date_upd = NOW() WHERE id_document = '94435' 20/11/2025 06:18:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94435' 20/11/2025 06:18:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94435' 20/11/2025 06:18:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94435' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '36' , '-36' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '90.00' ) 20/11/2025 06:18:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94435' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 20/11/2025 06:18:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3453' AND id_document != '94225' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 20/11/2025 06:18:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3453', document_date = '2024-11-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.80', price_tax_excluded = '74.57', date_upd = NOW() WHERE id_document = '94225' 20/11/2025 06:18:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94225' 20/11/2025 06:18:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94225' 20/11/2025 06:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94225' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '36' , '-36' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '90.00' ) 20/11/2025 06:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94225' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '' , '0.80' ) 20/11/2025 06:18:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3361' AND id_document != '94102' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-07') 20/11/2025 06:18:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3361', document_date = '2024-11-07', 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 = '292.80', price_tax_excluded = '240.00', date_upd = NOW() WHERE id_document = '94102' 20/11/2025 06: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 = '94102' 20/11/2025 06:18:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '94102' 20/11/2025 06: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 ( '94102' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 20/11/2025 06: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 ( '94102' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '72' , '-72' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '180.00' ) 20/11/2025 06:19:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3093' AND id_document != '93698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-18') 20/11/2025 06:19:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3093', document_date = '2024-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 = '640.00', price_tax_excluded = '562.31', date_upd = NOW() WHERE id_document = '93698' 20/11/2025 06:19:03 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 = '93698' 20/11/2025 06:19:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93698' 20/11/2025 06:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '5929' , 'LODI E VESPRI' , '40' , '-40' , '4' , '4.5000' , '4.5' , '0' , '5' , '171.20' ) 20/11/2025 06:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 20/11/2025 06:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '12' , '-12' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '90.00' ) 20/11/2025 06:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '72' , '-72' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '180.00' ) 20/11/2025 06:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 20/11/2025 06:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '20.8000' , '17.049180327869' , '22' , '0' , '20.80' ) 20/11/2025 06:19:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 20/11/2025 06:19:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '22870' , 'AGENDA SAN PAOLO 2025' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 20/11/2025 06:19:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93698' , '15871' , 'FINTA CANDELA 4X100 - 143' , '2' , '-2' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '60.00' ) 20/11/2025 06:19:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '971' AND id_document != '96363' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-25') 20/11/2025 06:19:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '971', document_date = '2025-03-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '318.40', price_tax_excluded = '260.98', date_upd = NOW() WHERE id_document = '96363' 20/11/2025 06:19: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 = '96363' 20/11/2025 06:19:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '96363' 20/11/2025 06:19: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 ( '96363' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 20/11/2025 06:19: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 ( '96363' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/11/2025 06:19: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 ( '96363' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '36' , '-36' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '90.00' ) 20/11/2025 06:19: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 ( '96363' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/11/2025 06:19: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 ( '96363' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' )