27/11/2025 09:01:23 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/11/2025 09:01:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24326' , '1' , '' , 'nuovo-prodotto' ) 27/11/2025 09:01:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24326' , '1' , '1' , '2' , NOW() , NOW() ) 27/11/2025 09:01:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24326' , '0' , '1' , '0' , '0' ) 27/11/2025 09:02:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259755384' AND id_product != '24326' AND ean13 != '' 27/11/2025 09:02:10 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791259755384', date_upd = NOW() WHERE id_product = '24326' 27/11/2025 09:02:10 am >> UPDATE ps_product_lang SET name = 'IO SONO COME GUARDO - L.M. EPICOCO', description = '' WHERE id_product = '24326' 27/11/2025 09:02:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '24326' 27/11/2025 09:02:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '243', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24326' 27/11/2025 09:02:11 am >> DELETE FROM ps_specific_price WHERE id_product = '24326' 27/11/2025 09:02:12 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24326' 27/11/2025 09:02:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24327' , '1' , '' , 'nuovo-prodotto' ) 27/11/2025 09:02:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24327' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24326' 27/11/2025 09:02:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24327' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24326' 27/11/2025 09:02:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '717295' , '2025-11-25' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.43' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.42' , '125.42' , NOW() , NOW() ) 27/11/2025 09:02:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100109' 27/11/2025 09:02:41 am >> DELETE FROM ps_document_detail WHERE id_document = '100109' 27/11/2025 09:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100109' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 27/11/2025 09:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '8274' AND id_supplier = '7' 27/11/2025 09:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8274' , '7' , '1' ) 27/11/2025 09:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100109' , '8275' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 2 - TEMPO ORDINARIO' , '1' , '1' , '4' , '38.00' , '38' , '0' , '30' , '26.6000' ) 27/11/2025 09:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '8275' AND id_supplier = '7' 27/11/2025 09:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8275' , '7' , '1' ) 27/11/2025 09:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100109' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '4' , '4' , '4' , '3.90' , '3.9' , '0' , '33' , '10.4520' ) 27/11/2025 09:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '7' 27/11/2025 09:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '7' , '1' ) 27/11/2025 09:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100109' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '3' , '3' , '4' , '14.00' , '14' , '0' , '33' , '28.1400' ) 27/11/2025 09:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23966' AND id_supplier = '7' 27/11/2025 09:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23966' , '7' , '1' ) 27/11/2025 09:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100109' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '4' , '4' , '6.00' , '6' , '0' , '15' , '20.4000' ) 27/11/2025 09:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '7' 27/11/2025 09:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '7' , '1' ) 27/11/2025 09:02:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100109' , '24326' , 'IO SONO COME GUARDO - L.M. EPICOCO' , '2' , '2' , '4' , '12.00' , '12' , '0' , '30' , '16.8000' ) 27/11/2025 09:02:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '24326' AND id_supplier = '7' 27/11/2025 09:02:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24326' , '7' , '1' ) 27/11/2025 09:23:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '717296' , '2025-11-25' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '12.61' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '417.62' , '417.62' , NOW() , NOW() ) 27/11/2025 09:23:34 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 = '100110' 27/11/2025 09:23:34 am >> DELETE FROM ps_document_detail WHERE id_document = '100110' 27/11/2025 09:23:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 27/11/2025 09:23:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '21735' AND id_supplier = '7' 27/11/2025 09:23:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21735' , '7' , '1' ) 27/11/2025 09:23:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '24120' , 'CHE BELLO! CAMMINA CON GESU ' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35+7' , '3.0225' ) 27/11/2025 09:23:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '24120' AND id_supplier = '7' 27/11/2025 09:23:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24120' , '7' , '1' ) 27/11/2025 09:23:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30+7' , '9.6999' ) 27/11/2025 09:23:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19932' AND id_supplier = '7' 27/11/2025 09:23:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19932' , '7' , '1' ) 27/11/2025 09:23:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '23876' , 'MIO PRIMO CALENDARIO LITURGICO - A. OLDONI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30+7' , '7.8120' ) 27/11/2025 09:23:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23876' AND id_supplier = '7' 27/11/2025 09:23:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23876' , '7' , '1' ) 27/11/2025 09:23:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '23508' , 'CON TE SULLALTARE' , '1' , '1' , '4' , '9.00' , '9' , '0' , '30+7' , '5.8590' ) 27/11/2025 09:23:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23508' AND id_supplier = '7' 27/11/2025 09:23:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23508' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '23407' , 'PROCESSO AL PROCESSETTO' , '2' , '2' , '4' , '10.00' , '10' , '0' , '33+7' , '12.4620' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23407' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23407' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '23443' , 'MA COME SI FA?' , '2' , '2' , '4' , '10.00' , '10' , '0' , '33+7' , '12.4620' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23443' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23443' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33+7' , '9.3465' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '23752' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23752' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '3' , '3' , '4' , '5.90' , '5.9' , '0' , '30+7' , '11.5227' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '17244' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17244' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35+7' , '6.0450' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18564' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18564' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '7' , '7' , '4' , '5.00' , '5' , '0' , '35+7' , '21.1575' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '10748' , 'TU MI CHIAMI PER NOME' , '24' , '24' , '4' , '6.90' , '6.9' , '0' , '30+7' , '107.8056' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '14719' , 'TU MI AMI DAVVERO' , '25' , '25' , '4' , '6.90' , '6.9' , '0' , '30+7' , '112.2975' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 27/11/2025 09:23:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100110' , '10751' , 'TU MI PERDONI' , '15' , '15' , '4' , '6.90' , '6.9' , '0' , '30+7' , '67.3785' ) 27/11/2025 09:23:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 27/11/2025 09:23:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 27/11/2025 10:23:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3886' AND id_document != '100040' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-22') 27/11/2025 10:23:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3886', document_date = '2025-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 = '54.32', price_tax_excluded = '54.32', date_upd = NOW() WHERE id_document = '100040' 27/11/2025 10:23:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100040' 27/11/2025 10:23:41 am >> DELETE FROM ps_document_detail WHERE id_document = '100040' 27/11/2025 10:23:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100040' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.7000' , '0.7' , '0' , '0' , '4.20' ) 27/11/2025 10:23:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100040' , '11193' , 'VENITE CON ME CAT.' , '5' , '-5' , '4' , '5.5000' , '5.5' , '0' , '0' , '27.50' ) 27/11/2025 10:23:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100040' , '21709' , 'GESU E IL PANE DI VITA' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 27/11/2025 10:23:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100040' , '21592' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 2' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 27/11/2025 10:23:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100040' , '24107' , 'IO E IL MIO AMICO GESU - GUIDA - B. FERRERO' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 27/11/2025 10:36:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3939' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 10:36:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3939' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 27/11/2025 10:36:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100111' 27/11/2025 10:36:36 am >> DELETE FROM ps_document_detail WHERE id_document = '100111' 27/11/2025 10:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100111' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 27/11/2025 10:40:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3940' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 10:40:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3940' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 27/11/2025 10:40:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100112' 27/11/2025 10:40:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100112' 27/11/2025 10:40:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100112' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/11/2025 10:42:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3941' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 10:42:10 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' , '3941' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 27/11/2025 10:42:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100113' 27/11/2025 10:42:10 am >> DELETE FROM ps_document_detail WHERE id_document = '100113' 27/11/2025 10:42:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100113' , '24232' , 'MESSA MEDITAZIONE - GEN/FEB 26' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/11/2025 10:45:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3942' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 10:45:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3942' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.65' , '18.65' , NOW() , NOW() ) 27/11/2025 10:45:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100114' 27/11/2025 10:45:35 am >> DELETE FROM ps_document_detail WHERE id_document = '100114' 27/11/2025 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100114' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 27/11/2025 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100114' , '23654' , 'MARIA LA PIU BELLA DEL MONDO - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 27/11/2025 10:52:11 am >> SELECT document_num FROM ps_document WHERE document_num = '144/A' AND id_document != '100087' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-26') 27/11/2025 10:52:11 am >> UPDATE ps_document SET id_document_type = '24', document_num = '144/A', document_date = '2025-11-26', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4679537', 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 = '172.00', price_tax_excluded = '141.55', date_upd = NOW() WHERE id_document = '100087' 27/11/2025 10:52:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100087' 27/11/2025 10:52:11 am >> DELETE FROM ps_document_detail WHERE id_document = '100087' 27/11/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '12531' , 'LAMPADA A SFERA ROSSA' , '4' , '-4' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '100.00' ) 27/11/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/11/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '38.00' ) 27/11/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/11/2025 11:05:44 am >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 11:05:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '145/A' , '2025-11-27' , 'A' , '302' , '0' , '4679587' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '274.00' , '274.00' , NOW() , NOW() ) 27/11/2025 11:05:44 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 = '100115' 27/11/2025 11:05:44 am >> DELETE FROM ps_document_detail WHERE id_document = '100115' 27/11/2025 11:05:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '2' , '-2' , '4' , '9.50' , '9.5' , '0' , '0' , '19.00' ) 27/11/2025 11:05: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 ( '100115' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '4' , '34.00' , '34' , '0' , '0' , '34.00' ) 27/11/2025 11:05: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 ( '100115' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.50' , '19.5' , '' , '0' , '19.50' ) 27/11/2025 11:05: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 ( '100115' , '17569' , 'BAMBINO IN RESINA - PB6277' , '3' , '-3' , '0' , '13.50' , '13.5' , '' , '0' , '40.50' ) 27/11/2025 11:05: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 ( '100115' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '3' , '-3' , '0' , '2.00' , '2' , '' , '0' , '6.00' ) 27/11/2025 11:05: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 ( '100115' , '21795' , 'GRUPPO NATIVITA\' CM 10 LEGNO - PB19888' , '9' , '-9' , '0' , '4.20' , '4.2' , '' , '0' , '37.80' ) 27/11/2025 11:05: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 ( '100115' , '24284' , 'CUORE NATIVITA CM 16 - PB17823' , '5' , '-5' , '0' , '4.50' , '4.5' , '' , '0' , '22.50' ) 27/11/2025 11:05: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 ( '100115' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.00' , '7' , '' , '0' , '21.00' ) 27/11/2025 11:05: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 ( '100115' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '3' , '-3' , '4' , '12.90' , '12.9' , '0' , '0' , '38.70' ) 27/11/2025 11:05: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 ( '100115' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.00' , '6' , '' , '0' , '18.00' ) 27/11/2025 11:05: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 ( '100115' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '0' , '17.00' , '17' , '' , '0' , '17.00' ) 27/11/2025 11:07:22 am >> SELECT document_num FROM ps_document WHERE document_num = '146/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 11:07:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '146/A' , '2025-11-27' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.45' , '75.50' , NOW() , NOW() ) 27/11/2025 11:07:22 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 = '100116' 27/11/2025 11:07:22 am >> DELETE FROM ps_document_detail WHERE id_document = '100116' 27/11/2025 11:07:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100116' , '23990' , 'DI PASQUA IN PASQUA - F. ROSINI' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 27/11/2025 11:07:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100116' , '24326' , 'IO SONO COME GUARDO - L.M. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 27/11/2025 11:07:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100116' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 27/11/2025 11:07:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100116' , '6810' , 'MOCCOLO 80X150' , '4' , '-4' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '28.00' ) 27/11/2025 11:08:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3943' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 11:08:20 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' , '3943' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 27/11/2025 11:08:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100117' 27/11/2025 11:08:20 am >> DELETE FROM ps_document_detail WHERE id_document = '100117' 27/11/2025 11:08:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100117' , '24326' , 'IO SONO COME GUARDO - L.M. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 27/11/2025 11:31:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3944' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 11:31:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3944' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.43' , '59.82' , NOW() , NOW() ) 27/11/2025 11:31:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100118' 27/11/2025 11:31:39 am >> DELETE FROM ps_document_detail WHERE id_document = '100118' 27/11/2025 11:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100118' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '20.00' ) 27/11/2025 11:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100118' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 27/11/2025 11:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100118' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 27/11/2025 11:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100118' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 27/11/2025 11:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100118' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 27/11/2025 11:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100118' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 27/11/2025 11:38:15 am >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '100115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 11:38:15 am >> UPDATE ps_document SET id_document_type = '24', document_num = '145/A', document_date = '2025-11-27', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4679587', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', 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 = '416.80', price_tax_excluded = '416.80', date_upd = NOW() WHERE id_document = '100115' 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100115' 27/11/2025 11:38:15 am >> DELETE FROM ps_document_detail WHERE id_document = '100115' 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '2' , '-2' , '4' , '9.5000' , '9.5' , '0' , '0' , '19.00' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '4' , '34.0000' , '34' , '0' , '0' , '34.00' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '17569' , 'BAMBINO IN RESINA - PB6277' , '3' , '-3' , '0' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '3' , '-3' , '0' , '2.0000' , '2' , '0' , '0' , '6.00' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21795' , 'GRUPPO NATIVITA\' CM 10 LEGNO - PB19888' , '9' , '-9' , '0' , '4.2000' , '4.2' , '0' , '0' , '37.80' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24284' , 'CUORE NATIVITA CM 16 - PB17823' , '5' , '-5' , '0' , '4.5000' , '4.5' , '0' , '0' , '22.50' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.0000' , '7' , '0' , '0' , '21.00' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '3' , '-3' , '4' , '12.9000' , '12.9' , '0' , '0' , '38.70' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.0000' , '6' , '0' , '0' , '18.00' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '0' , '17.0000' , '17' , '0' , '0' , '17.00' ) 27/11/2025 11:38:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '0' , '24.00' , '24' , '' , '0' , '24.00' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.50' , '11.5' , '' , '0' , '11.50' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '1' , '-1' , '0' , '4.80' , '4.8' , '' , '0' , '4.80' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '2' , '-2' , '0' , '6.00' , '6' , '' , '0' , '12.00' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '0' , '5.00' , '5' , '' , '0' , '5.00' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '0' , '5.00' , '5' , '' , '0' , '5.00' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '14883' , 'ANGELO IN RESINA PREGHIERA CM 9 - KS122-P' , '3' , '-3' , '0' , '6.50' , '6.5' , '' , '0' , '19.50' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '19602' , 'QUADRETTO EFFETTO PIETRA - 2952 VARI MODELLI' , '9' , '-9' , '0' , '4.00' , '4' , '' , '0' , '36.00' ) 27/11/2025 11:38:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '1' , '-1' , '0' , '25.00' , '25' , '' , '0' , '25.00' ) 27/11/2025 11:41:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3945' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 11:41:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3945' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.20' , '197.20' , NOW() , NOW() ) 27/11/2025 11:41:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100119' 27/11/2025 11:41:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100119' 27/11/2025 11:41:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100119' , '1090' , 'BIBBIA' , '20' , '-20' , '4' , '9.90' , '9.9' , '0' , '10' , '178.20' ) 27/11/2025 11:41:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100119' , '17229' , 'FELICI SUI PASSI DI GESU\' - 5 - SUSSIDIO' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 27/11/2025 11:46:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3946' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 11:47:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3946' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.50' , '34.74' , NOW() , NOW() ) 27/11/2025 11:47:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100120' 27/11/2025 11:47:00 am >> DELETE FROM ps_document_detail WHERE id_document = '100120' 27/11/2025 11:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100120' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 27/11/2025 11:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100120' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '20.00' ) 27/11/2025 11:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100120' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 27/11/2025 12:01:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '100115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 12:01:19 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '145/A', document_date = '2025-11-27', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4679587', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', 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 = '613.60', price_tax_excluded = '613.60', date_upd = NOW() WHERE id_document = '100115' 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100115' 27/11/2025 12:01:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100115' 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '2' , '-2' , '4' , '9.5000' , '9.5' , '0' , '0' , '19.00' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '4' , '34.0000' , '34' , '0' , '0' , '34.00' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '17569' , 'BAMBINO IN RESINA - PB6277' , '3' , '-3' , '0' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '3' , '-3' , '0' , '2.0000' , '2' , '0' , '0' , '6.00' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21795' , 'GRUPPO NATIVITA\' CM 10 LEGNO - PB19888' , '9' , '-9' , '0' , '4.2000' , '4.2' , '0' , '0' , '37.80' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '24284' , 'CUORE NATIVITA CM 16 - PB17823' , '5' , '-5' , '0' , '4.5000' , '4.5' , '0' , '0' , '22.50' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.0000' , '7' , '0' , '0' , '21.00' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '3' , '-3' , '4' , '12.9000' , '12.9' , '0' , '0' , '38.70' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.0000' , '6' , '0' , '0' , '18.00' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '0' , '17.0000' , '17' , '0' , '0' , '17.00' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '0' , '24.0000' , '24' , '0' , '0' , '24.00' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '1' , '-1' , '0' , '4.8000' , '4.8' , '0' , '0' , '4.80' ) 27/11/2025 12:01:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100115' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '2' , '-2' , '0' , '6.0000' , '6' , '0' , '0' , '12.00' ) 27/11/2025 12:01: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 ( '100115' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '0' , '5.0000' , '5' , '0' , '0' , '5.00' ) 27/11/2025 12:01: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 ( '100115' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '0' , '5.0000' , '5' , '0' , '0' , '5.00' ) 27/11/2025 12:01: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 ( '100115' , '14883' , 'ANGELO IN RESINA PREGHIERA CM 9 - KS122-P' , '3' , '-3' , '0' , '6.5000' , '6.5' , '0' , '0' , '19.50' ) 27/11/2025 12:01: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 ( '100115' , '19602' , 'QUADRETTO EFFETTO PIETRA - 2952 VARI MODELLI' , '9' , '-9' , '0' , '4.0000' , '4' , '0' , '0' , '36.00' ) 27/11/2025 12:01: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 ( '100115' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '1' , '-1' , '0' , '25.0000' , '25' , '0' , '0' , '25.00' ) 27/11/2025 12:01: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 ( '100115' , '24174' , 'CUORE DI MAMMA - CALENDARIO 2026' , '1' , '-1' , '0' , '7.00' , '7' , '' , '0' , '7.00' ) 27/11/2025 12:01: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 ( '100115' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 27/11/2025 12:01: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 ( '100115' , '24015' , 'UN ANNO CON GESU' , '1' , '-1' , '0' , '5.00' , '5' , '' , '0' , '5.00' ) 27/11/2025 12:01: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 ( '100115' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '1' , '-1' , '0' , '14.00' , '14' , '' , '0' , '14.00' ) 27/11/2025 12:01: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 ( '100115' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 27/11/2025 12:01: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 ( '100115' , '23751' , 'GESU VERAMENTE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 27/11/2025 12:01: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 ( '100115' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 27/11/2025 12:01: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 ( '100115' , '24059' , 'FRANCESCO E CHIARA - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 27/11/2025 12:01: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 ( '100115' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 27/11/2025 12:01: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 ( '100115' , '23998' , 'PENSIERI EUCARISTICI 2026' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 27/11/2025 12:01: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 ( '100115' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 27/11/2025 12:01: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 ( '100115' , '24183' , 'PAPA LEONE XIV - F. INNOCENTE' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '0' , '7.50' ) 27/11/2025 12:01: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 ( '100115' , '24072' , 'LEONE XVI - N. MONOPOLI - 8358' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 27/11/2025 12:01: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 ( '100115' , '21202' , 'PREGHIAMO CON IL NONNO E LA NONNA' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 27/11/2025 12:01: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 ( '100115' , '13840' , 'NONNI SONO UN TESORO' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '0' , '3.60' ) 27/11/2025 12:01: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 ( '100115' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 27/11/2025 12:01: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 ( '100115' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 27/11/2025 12:01: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 ( '100115' , '24058' , 'SFIDA TRA SUPEREROI DELLA BIBBIA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 27/11/2025 12:01:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3947' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 12:01:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3947' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 27/11/2025 12:01:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100121' 27/11/2025 12:01:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100121' 27/11/2025 12:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100121' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '38.00' ) 27/11/2025 12:16:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '100115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 12:16:47 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '145/A', document_date = '2025-11-27', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4679587', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI SCONTI 10/15% --- OGGETTISTICA 15%', 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 = '711.70', price_tax_excluded = '711.70', date_upd = NOW() WHERE id_document = '100115' 27/11/2025 12: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 = '100115' 27/11/2025 12:16:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100115' 27/11/2025 12: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 ( '100115' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '2' , '-2' , '4' , '9.5000' , '9.5' , '0' , '0' , '19.00' ) 27/11/2025 12: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 ( '100115' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '4' , '34.0000' , '34' , '0' , '0' , '34.00' ) 27/11/2025 12: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 ( '100115' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 27/11/2025 12: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 ( '100115' , '17569' , 'BAMBINO IN RESINA - PB6277' , '3' , '-3' , '0' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 27/11/2025 12: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 ( '100115' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '3' , '-3' , '0' , '2.0000' , '2' , '0' , '0' , '6.00' ) 27/11/2025 12: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 ( '100115' , '21795' , 'GRUPPO NATIVITA\' CM 10 LEGNO - PB19888' , '9' , '-9' , '0' , '4.2000' , '4.2' , '0' , '0' , '37.80' ) 27/11/2025 12: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 ( '100115' , '24284' , 'CUORE NATIVITA CM 16 - PB17823' , '5' , '-5' , '0' , '4.5000' , '4.5' , '0' , '0' , '22.50' ) 27/11/2025 12: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 ( '100115' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.0000' , '7' , '0' , '0' , '21.00' ) 27/11/2025 12: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 ( '100115' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '3' , '-3' , '4' , '12.9000' , '12.9' , '0' , '0' , '38.70' ) 27/11/2025 12: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 ( '100115' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.0000' , '6' , '0' , '0' , '18.00' ) 27/11/2025 12: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 ( '100115' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '0' , '17.0000' , '17' , '0' , '0' , '17.00' ) 27/11/2025 12: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 ( '100115' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '0' , '24.0000' , '24' , '0' , '0' , '24.00' ) 27/11/2025 12: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 ( '100115' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 27/11/2025 12: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 ( '100115' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '1' , '-1' , '0' , '4.8000' , '4.8' , '0' , '0' , '4.80' ) 27/11/2025 12:16: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 ( '100115' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '2' , '-2' , '0' , '6.0000' , '6' , '0' , '0' , '12.00' ) 27/11/2025 12:16: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 ( '100115' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '0' , '5.0000' , '5' , '0' , '0' , '5.00' ) 27/11/2025 12:16: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 ( '100115' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '0' , '5.0000' , '5' , '0' , '0' , '5.00' ) 27/11/2025 12:16: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 ( '100115' , '14883' , 'ANGELO IN RESINA PREGHIERA CM 9 - KS122-P' , '3' , '-3' , '0' , '6.5000' , '6.5' , '0' , '0' , '19.50' ) 27/11/2025 12:16: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 ( '100115' , '19602' , 'QUADRETTO EFFETTO PIETRA - 2952 VARI MODELLI' , '9' , '-9' , '0' , '4.0000' , '4' , '0' , '0' , '36.00' ) 27/11/2025 12:16: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 ( '100115' , '23608' , 'QUADRO DECORATO 33X33 - PR-R' , '1' , '-1' , '0' , '25.0000' , '25' , '0' , '0' , '25.00' ) 27/11/2025 12:16: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 ( '100115' , '24174' , 'CUORE DI MAMMA - CALENDARIO 2026' , '1' , '-1' , '0' , '7.0000' , '7' , '0' , '0' , '7.00' ) 27/11/2025 12:16: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 ( '100115' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 27/11/2025 12:16: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 ( '100115' , '24015' , 'UN ANNO CON GESU' , '1' , '-1' , '0' , '5.0000' , '5' , '0' , '0' , '5.00' ) 27/11/2025 12:16: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 ( '100115' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '1' , '-1' , '0' , '14.0000' , '14' , '0' , '0' , '14.00' ) 27/11/2025 12:16: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 ( '100115' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 27/11/2025 12:16: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 ( '100115' , '23751' , 'GESU VERAMENTE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/11/2025 12:16: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 ( '100115' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/11/2025 12:16: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 ( '100115' , '24059' , 'FRANCESCO E CHIARA - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 27/11/2025 12:16: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 ( '100115' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 27/11/2025 12:16: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 ( '100115' , '23998' , 'PENSIERI EUCARISTICI 2026' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 27/11/2025 12:16: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 ( '100115' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/11/2025 12:16: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 ( '100115' , '24183' , 'PAPA LEONE XIV - F. INNOCENTE' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 27/11/2025 12:16: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 ( '100115' , '24072' , 'LEONE XVI - N. MONOPOLI - 8358' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/11/2025 12:16: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 ( '100115' , '21202' , 'PREGHIAMO CON IL NONNO E LA NONNA' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 27/11/2025 12:16: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 ( '100115' , '13840' , 'NONNI SONO UN TESORO' , '2' , '-2' , '4' , '1.8000' , '1.8' , '0' , '0' , '3.60' ) 27/11/2025 12:16: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 ( '100115' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/11/2025 12:16: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 ( '100115' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 27/11/2025 12:16: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 ( '100115' , '24058' , 'SFIDA TRA SUPEREROI DELLA BIBBIA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 27/11/2025 12:16: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 ( '100115' , '1090' , 'BIBBIA' , '2' , '-2' , '4' , '9.90' , '9.9' , '0' , '0' , '19.80' ) 27/11/2025 12:16: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 ( '100115' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '0' , '17.50' ) 27/11/2025 12:16: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 ( '100115' , '16309' , 'BRACCIALE EMATITE SANTI - BC38' , '2' , '-2' , '0' , '2.00' , '2' , '' , '0' , '4.00' ) 27/11/2025 12:16: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 ( '100115' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '3' , '-3' , '0' , '3.00' , '3' , '' , '0' , '9.00' ) 27/11/2025 12:16: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 ( '100115' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '2' , '-2' , '0' , '1.00' , '1' , '' , '0' , '2.00' ) 27/11/2025 12:16: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 ( '100115' , '18129' , 'TAU COLORATO - T56' , '2' , '-2' , '0' , '1.20' , '1.2' , '' , '0' , '2.40' ) 27/11/2025 12:16: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 ( '100115' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '1' , '-1' , '0' , '12.00' , '12' , '' , '0' , '12.00' ) 27/11/2025 12:16: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 ( '100115' , '16075' , 'SCOPRI E DIPINGI LA BIBBIA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 27/11/2025 12:16: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 ( '100115' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 27/11/2025 12:16: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 ( '100115' , '20948' , 'MIA PRIMA GRANDE BIBBIA' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 27/11/2025 12:16: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 ( '100115' , '5659' , 'LEGGO E GIOCO CON LA BIBBIA' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 27/11/2025 12:42:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736642' AND id_product != '24325' AND ean13 != '' 27/11/2025 12:42:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9791280736642', date_upd = NOW() WHERE id_product = '24325' 27/11/2025 12:42:31 pm >> UPDATE ps_product_lang SET name = 'EUCARISTIA', description = '
Oggi siamo alla costante ricerca del farmaco che risolva i nostri malanni. Anche la nostra società è in attesa di un farmaco che la guarisca dalla profonda crisi spirituale che sta attraversando. La medicina per guarire la nostra società c’è! È l’Eucaristia! È un farmaco particolare e unico, perché fa sempre bene a tutti e non ha effetti collaterali. Gesù Eucaristia è l’unica medicina che davvero ci salva la vita. Come ricorda sant’Ignazio d’Antiochia: «Spezzando un solo pane, che è farmaco d’immortalità, antidoto per non morire ma vivere in Gesù Cristo per sempre»
' WHERE id_product = '24325' 27/11/2025 12:42:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.8' WHERE id_product = '24325' 27/11/2025 12:42:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '64', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24325' 27/11/2025 12:42:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '24325' 27/11/2025 12:42:31 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '24325' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/11/2025 12:43:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '527' , '2025-11-25' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 14 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 27/11/2025 12:43:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100122' 27/11/2025 12:43:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '100122' 27/11/2025 12:43: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 ( '100122' , '24325' , 'EUCARISTIA' , '100' , '100' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 27/11/2025 12:43:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24325' AND id_supplier = '145' 27/11/2025 12:43:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24325' , '145' , '1' ) 27/11/2025 01:02:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3948' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 01:02:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3948' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '588.00' , '481.97' , NOW() , NOW() ) 27/11/2025 01:02: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 = '100123' 27/11/2025 01:02:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100123' 27/11/2025 01:02: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 ( '100123' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/11/2025 01:02: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 ( '100123' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '38.00' ) 27/11/2025 01:02: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 ( '100123' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 27/11/2025 01:02: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 ( '100123' , '19798' , 'CAMICE ARIANNA MISTO LINO' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 27/11/2025 01:02: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 ( '100123' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 27/11/2025 01:02: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 ( '100123' , '6405' , 'MENSA DIAM 40X250 - M4025' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 27/11/2025 01:05:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3948' AND id_document != '100123' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 01:05:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3948', document_date = '2025-11-27', 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 = '588.00', price_tax_excluded = '481.97', date_upd = NOW() WHERE id_document = '100123' 27/11/2025 01:05:00 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 = '100123' 27/11/2025 01:05:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '100123' 27/11/2025 01:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100123' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/11/2025 01:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100123' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 27/11/2025 01:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100123' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 27/11/2025 01:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100123' , '19798' , 'CAMICE ARIANNA MISTO LINO' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 27/11/2025 01:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100123' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/11/2025 01:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100123' , '6405' , 'MENSA DIAM 40X250 - M4025' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 27/11/2025 01:05:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100123' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 27/11/2025 03:22:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '99314' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-17') 27/11/2025 03:22:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2025-10-17', document_letter = 'A', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', address2 = '', note = '', price_shipping = '-1.68', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '99314' 27/11/2025 03:22:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99314' 27/11/2025 03:22:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '99314' 27/11/2025 03:22:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 27/11/2025 03:22:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 27/11/2025 03:22:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99314' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 27/11/2025 03:23:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '262' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 03:23:29 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' , '262' , '2025-11-27' , '' , '232' , '0' , '4671450' , 'VIA V. LASPRO, 8/A 84126 SALERNO' , '' , '' , '-1.68' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 27/11/2025 03:23:29 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 = '100124' 27/11/2025 03:23:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '100124' 27/11/2025 03:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100124' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 27/11/2025 03:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100124' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 27/11/2025 03:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100124' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 27/11/2025 03:23:37 pm >> DELETE FROM ps_document WHERE id_document = '99314' 27/11/2025 03:23:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '99314' 27/11/2025 03:25:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '262' AND id_document != '100124' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 03:25:28 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '262', document_date = '2025-11-27', document_letter = '', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', address2 = '', note = '', price_shipping = '0', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '100124' 27/11/2025 03:25:28 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 = '100124' 27/11/2025 03:25:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '100124' 27/11/2025 03:25:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100124' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.8000' , '3.8' , '0' , '15' , '19.38' ) 27/11/2025 03:25:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100124' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '-8' , '4' , '3.8000' , '3.8' , '0' , '15' , '25.84' ) 27/11/2025 03:25:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100124' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '15' , '6.46' ) 27/11/2025 03:25:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100124' , '' , 'ARROTONDAMENTO' , '1' , '-1' , '0' , '-1.68' , '-1.68' , '' , '0' , '-1.68' ) 27/11/2025 04:00:03 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1739' 27/11/2025 04:00:03 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 ( '1739' , '10' , '208' , 'ISTITUTO FIGLIE DI NOSTRA SIGNORA AL MONTE CALVARIO' , 'TEODORI ' , 'DON FIORENZO' , 'VIA PROVINCIALE 1' , '' , '00010' , 'MONTEFLAVIO' , '' , '349 2720436' , '' , '' , '' , NOW() , NOW() ) 27/11/2025 04:00:04 pm >> UPDATE ps_customer SET email = 'donteodori@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1739' 27/11/2025 04:02:44 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'M8SsNqlSBAkpO67F' , NOW() , NOW() ) 27/11/2025 04:02:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4292' , '1' ) 27/11/2025 04:02:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4292' , '2' ) 27/11/2025 04:02:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4292' , '3' ) 27/11/2025 04:05:54 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4292' 27/11/2025 04:05:54 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 ( '4292' , '10' , '208' , '' , 'TEODORI' , 'MARIA' , 'VIA VAL D\'OSSOLA 11' , '' , '00013' , 'MENTANA' , '' , '' , '3492720436' , '' , '' , NOW() , NOW() ) 27/11/2025 04:05:54 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4292' 27/11/2025 04:06:24 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4292' 27/11/2025 04:06:24 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 ( '4292' , '10' , '208' , '' , 'TEODORI' , 'DON FIORENZO' , 'VIA VAL D\'OSSOLA 11' , '' , '00013' , 'MENTANA' , '' , '' , '3492720436' , '' , '' , NOW() , NOW() ) 27/11/2025 04:06:24 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4292' 27/11/2025 04:06:38 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4292' 27/11/2025 04:06:38 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 ( '4292' , '10' , '208' , '' , 'TEODORI' , 'DON FIORENZO' , 'VIA VAL D\'OSSOLA 11' , '' , '00013' , 'MENTANA' , '' , '' , '3492720436' , '' , '' , NOW() , NOW() ) 27/11/2025 04:06:38 pm >> UPDATE ps_customer SET email = 'donteodori@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4292' 27/11/2025 04:09:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '263' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 04:09: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' , '263' , '2025-11-27' , '' , '4292' , '0' , '4679665' , 'VIA VAL D\\\'OSSOLA 11 00013 MENTANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '83.40' , '83.40' , NOW() , NOW() ) 27/11/2025 04:09: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 = '100125' 27/11/2025 04:09:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '100125' 27/11/2025 04:09: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 ( '100125' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.00' , '52' , '0' , '5' , '49.40' ) 27/11/2025 04:09: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 ( '100125' , '6962' , 'NELLA CASA DEL DEFUNTO' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 27/11/2025 04:09: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 ( '100125' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 27/11/2025 04:09: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 ( '100125' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 27/11/2025 04:22:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3949' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 04:22:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3949' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.90' , '17.95' , NOW() , NOW() ) 27/11/2025 04:22:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100126' 27/11/2025 04:22:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100126' 27/11/2025 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100126' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 27/11/2025 04:22:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100126' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 27/11/2025 04:28: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 ( '33' , '526' , '2025-11-25' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1920.00' , '1920.00' , NOW() , NOW() ) 27/11/2025 04:28: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 = '100127' 27/11/2025 04:28:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '100127' 27/11/2025 04:28: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 ( '100127' , '24325' , 'EUCARISTIA' , '400' , '400' , '4' , '4.80' , '4.8' , '0' , '0' , '1920.0000' ) 27/11/2025 04:30:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 04:30:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '34' , '2025-11-27' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI - SPEDITI DA VELAR' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1920.00' , '1920.00' , NOW() , NOW() ) 27/11/2025 04:30: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 = '100128' 27/11/2025 04:30:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100128' 27/11/2025 04:30: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 ( '100128' , '24325' , 'EUCARISTIA' , '400' , '-400' , '4' , '4.80' , '4.8' , '0' , '0' , '1920.00' ) 27/11/2025 04:33:45 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '526', document_date = '2025-11-25', document_letter = '', id_customer = '4166', id_supplier = '0', id_address = '4679469', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '1920.00', price_tax_excluded = '1920.00', date_upd = NOW() WHERE id_document = '100127' 27/11/2025 04:33: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 = '100127' 27/11/2025 04:33:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '100127' 27/11/2025 04:33: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 ( '100127' , '24325' , 'EUCARISTIA' , '400' , '400' , '4' , '4.8000' , '4.8' , '0' , '0' , '1920.00' ) 27/11/2025 04:34:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3950' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 04:34:17 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' , '3950' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 27/11/2025 04:34:17 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 = '100129' 27/11/2025 04:34:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '100129' 27/11/2025 04:34:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100129' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '38.00' ) 27/11/2025 05:47:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3951' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 05:47:12 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' , '3951' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '35.97' , NOW() , NOW() ) 27/11/2025 05:47:12 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 = '100130' 27/11/2025 05:47:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '100130' 27/11/2025 05: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 ( '100130' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 27/11/2025 05: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 ( '100130' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/11/2025 05: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 ( '100130' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 27/11/2025 05: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 ( '100130' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 27/11/2025 05:49:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3952' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 05:49: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' , '3952' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 27/11/2025 05:49: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 = '100131' 27/11/2025 05:49:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '100131' 27/11/2025 05:49: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 ( '100131' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/11/2025 06:09:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 06:09:35 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' , '3953' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.20' , '29.67' , NOW() , NOW() ) 27/11/2025 06:09:35 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 = '100132' 27/11/2025 06:09:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '100132' 27/11/2025 06:09:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100132' , '7202' , 'ARTICOLI RELIGIOSI' , '18' , '-18' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '34.20' ) 27/11/2025 06:09:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100132' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/11/2025 06:14:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 27/11/2025 06:14:52 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' , '3954' , '2025-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 27/11/2025 06:14:52 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 = '100133' 27/11/2025 06:14:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100133' 27/11/2025 06:14: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 ( '100133' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' )