28/05/2025 09:09:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1880' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 09:09:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1880' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 28/05/2025 09:09:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97423' 28/05/2025 09:09:45 am >> DELETE FROM ps_document_detail WHERE id_document = '97423' 28/05/2025 09:09: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 ( '97423' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 28/05/2025 09:15:50 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/05/2025 09:15:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23785' , '1' , '' , 'nuovo-prodotto' ) 28/05/2025 09:15:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23785' , '1' , '1' , '2' , NOW() , NOW() ) 28/05/2025 09:15:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23785' , '0' , '1' , '0' , '0' ) 28/05/2025 09:16:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391325' AND id_product != '23785' AND ean13 != '' 28/05/2025 09:16:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256391325', date_upd = NOW() WHERE id_product = '23785' 28/05/2025 09:16:34 am >> UPDATE ps_product_lang SET name = 'SANTA MESSA DEGLI SPOSI - 8211', description = '' WHERE id_product = '23785' 28/05/2025 09:16:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '23785' 28/05/2025 09:16:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23785' 28/05/2025 09:16:34 am >> DELETE FROM ps_specific_price WHERE id_product = '23785' 28/05/2025 09:16:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391325' AND id_product != '23785' AND ean13 != '' 28/05/2025 09:16:42 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9791256391325', date_upd = NOW() WHERE id_product = '23785' 28/05/2025 09:16:42 am >> UPDATE ps_product_lang SET name = 'SANTA MESSA DEGLI SPOSI - 8211', description = '' WHERE id_product = '23785' 28/05/2025 09:16:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '23785' 28/05/2025 09:16:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23785' 28/05/2025 09:16:42 am >> DELETE FROM ps_specific_price WHERE id_product = '23785' 28/05/2025 09:16:44 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 = '23785' 28/05/2025 09:16:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23786' , '1' , '' , 'nuovo-prodotto' ) 28/05/2025 09:16:44 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 '23786' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23785' 28/05/2025 09:16:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23786' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23785' 28/05/2025 09:19:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884044495' AND id_product != '11882' AND ean13 != '' 28/05/2025 09:19:57 am >> UPDATE ps_product SET id_supplier = '38', reference = '5/2', ean13 = '9788884044495', date_upd = NOW() WHERE id_product = '11882' 28/05/2025 09:19:57 am >> UPDATE ps_product_lang SET name = '365 GIORNI CON LA BIBBIA - 8827', description = '' WHERE id_product = '11882' 28/05/2025 09:19:57 am >> UPDATE ps_product SET wholesale_price = '12.00', on_sale = '0', price = '25' WHERE id_product = '11882' 28/05/2025 09:19:57 am >> UPDATE ps_product_shop SET wholesale_price = '12.00', price = '25', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11882' 28/05/2025 09:19:57 am >> DELETE FROM ps_specific_price WHERE id_product = '11882' 28/05/2025 09:21:26 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 ( '31' , '8407/00/2025' , '2025-05-26' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '97.02' , '97.02' , NOW() , NOW() ) 28/05/2025 09:21:26 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 = '97424' 28/05/2025 09:21:26 am >> DELETE FROM ps_document_detail WHERE id_document = '97424' 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '23785' , 'SANTA MESSA DEGLI SPOSI - 8211' , '3' , '3' , '4' , '2.90' , '2.9' , '0' , '40' , '5.2200' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23785' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23785' , '38' , '1' ) 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '30' , '30' , '4' , '2.00' , '2' , '0' , '40' , '36.0000' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '9070' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9070' , '38' , '1' ) 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '5411' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5411' , '38' , '1' ) 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '8336' , 'PREGHIERE A SANTA RITA DA CASCIA - 8352' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '8336' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8336' , '38' , '1' ) 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '23646' , 'DOMANDE A UN ESORCISTA - 8354' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '23646' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23646' , '38' , '1' ) 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '6283' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6283' , '38' , '1' ) 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '20895' , 'NOVE MARTEDI DELLANGELO CUSTODE - 8458' , '1' , '1' , '4' , '3.00' , '3' , '0' , '40' , '1.8000' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20895' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20895' , '38' , '1' ) 28/05/2025 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '5' , '5' , '4' , '4.00' , '4' , '0' , '40' , '12.0000' ) 28/05/2025 09:21:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '13830' AND id_supplier = '38' 28/05/2025 09:21:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13830' , '38' , '1' ) 28/05/2025 09:21:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '22555' , 'RITA DA CASCIA - 8658' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 28/05/2025 09:21:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22555' AND id_supplier = '38' 28/05/2025 09:21:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22555' , '38' , '1' ) 28/05/2025 09:21:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '1' , '4' , '25.00' , '25' , '0' , '40' , '15.0000' ) 28/05/2025 09:21:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '11882' AND id_supplier = '38' 28/05/2025 09:21:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11882' , '38' , '1' ) 28/05/2025 09:22:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1881' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 09:22:46 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' , '1881' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.90' , '56.97' , NOW() , NOW() ) 28/05/2025 09:22:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97425' 28/05/2025 09:22:46 am >> DELETE FROM ps_document_detail WHERE id_document = '97425' 28/05/2025 09:22:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97425' , '15492' , 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIK' , '1' , '-1' , '1' , '29.3' , '24.016393442623' , '22' , '0' , '29.30' ) 28/05/2025 09:22:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97425' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 28/05/2025 09:22:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97425' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 28/05/2025 09:30:59 am >> UPDATE ps_document SET id_document_type = '31', document_num = '8407/00/2025', document_date = '2025-05-26', document_letter = '00', id_customer = '0', id_supplier = '', id_address = '2633', address1 = 'VIA GALVANI, 1 60020 CAMERATA PICENA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '114.12', price_tax_excluded = '114.12', date_upd = NOW() WHERE id_document = '97424' 28/05/2025 09:30: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 = '97424' 28/05/2025 09:30:59 am >> DELETE FROM ps_document_detail WHERE id_document = '97424' 28/05/2025 09:30: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 ( '97424' , '23785' , 'SANTA MESSA DEGLI SPOSI - 8211' , '3' , '3' , '4' , '2.9000' , '2.9' , '0' , '40' , '5.22' ) 28/05/2025 09:30: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 ( '97424' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '30' , '30' , '4' , '2.0000' , '2' , '0' , '40' , '36.00' ) 28/05/2025 09:30: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 ( '97424' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '40' , '7.20' ) 28/05/2025 09:30: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 ( '97424' , '8336' , 'PREGHIERE A SANTA RITA DA CASCIA - 8352' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '40' , '4.20' ) 28/05/2025 09:30: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 ( '97424' , '23646' , 'DOMANDE A UN ESORCISTA - 8354' , '1' , '1' , '4' , '9.0000' , '9' , '0' , '40' , '5.40' ) 28/05/2025 09:30: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 ( '97424' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '40' , '4.20' ) 28/05/2025 09:30: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 ( '97424' , '20895' , 'NOVE MARTEDI DELLANGELO CUSTODE - 8458' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '40' , '1.80' ) 28/05/2025 09:30: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 ( '97424' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '5' , '5' , '4' , '4.0000' , '4' , '0' , '40' , '12.00' ) 28/05/2025 09:30: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 ( '97424' , '22555' , 'RITA DA CASCIA - 8658' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '40' , '6.00' ) 28/05/2025 09:30: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 ( '97424' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '40' , '15.00' ) 28/05/2025 09:30: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 ( '97424' , '11880' , 'ANNO CON LA BIBBIA - 8829' , '1' , '1' , '4' , '15.00' , '15' , '0' , '40' , '9.0000' ) 28/05/2025 09:30: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 ( '97424' , '23163' , 'SANTA FILOMENA - 8841' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 28/05/2025 09:30: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 ( '97424' , '22990' , 'CORONCINA A SANTA RITA DA CASCIA - 8843' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '40' , '2.7000' ) 28/05/2025 09:30: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 ( '97424' , '17628' , 'PREGHIERE A SAN CHARBEL - 8946' , '1' , '1' , '4' , '2.00' , '2' , '0' , '40' , '1.2000' ) 28/05/2025 09:40:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 09:40: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' , '1882' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '304.50' , '267.11' , NOW() , NOW() ) 28/05/2025 09:40: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 = '97426' 28/05/2025 09:40:20 am >> DELETE FROM ps_document_detail WHERE id_document = '97426' 28/05/2025 09:40: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 ( '97426' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 28/05/2025 09:40: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 ( '97426' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 28/05/2025 09:40: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 ( '97426' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 28/05/2025 09:40: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 ( '97426' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '13.50' ) 28/05/2025 09:40: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 ( '97426' , '14389' , 'CAMICE MISTO COTONE - COLLO QUADRO - 446TCAQ' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 28/05/2025 09:45:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1883' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 09:45:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1883' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.75' , '125.54' , NOW() , NOW() ) 28/05/2025 09:45:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97427' 28/05/2025 09:45:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97427' 28/05/2025 09:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97427' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 28/05/2025 09:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97427' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 28/05/2025 09:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97427' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/05/2025 09:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97427' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 28/05/2025 09:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97427' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 28/05/2025 09:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97427' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 28/05/2025 09:49:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '10974' AND id_product != '16969' AND ean13 != '' 28/05/2025 09:49:41 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '10974', date_upd = NOW() WHERE id_product = '16969' 28/05/2025 09:49:42 am >> UPDATE ps_product_lang SET name = 'CORONA DELLE ROSE - 10974', description = '' WHERE id_product = '16969' 28/05/2025 09:49:42 am >> UPDATE ps_product SET wholesale_price = '2.66', on_sale = '0', price = '4.4262' WHERE id_product = '16969' 28/05/2025 09:49:42 am >> UPDATE ps_product_shop SET wholesale_price = '2.66', price = '4.4262', id_tax_rules_group = '1', id_category_default = '106', id_argoment_default = '42', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16969' 28/05/2025 09:49:42 am >> DELETE FROM ps_specific_price WHERE id_product = '16969' 28/05/2025 09:50:30 am >> UPDATE ps_document SET id_document_type = '31', document_num = '8407/00/2025', document_date = '2025-05-26', document_letter = '00', id_customer = '0', id_supplier = '', id_address = '2633', address1 = 'VIA GALVANI, 1 60020 CAMERATA PICENA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '140.89', price_tax_excluded = '136.06', date_upd = NOW() WHERE id_document = '97424' 28/05/2025 09:50:30 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 = '97424' 28/05/2025 09:50:30 am >> DELETE FROM ps_document_detail WHERE id_document = '97424' 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '23785' , 'SANTA MESSA DEGLI SPOSI - 8211' , '3' , '3' , '4' , '2.9000' , '2.9' , '0' , '40' , '5.22' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '30' , '30' , '4' , '2.0000' , '2' , '0' , '40' , '36.00' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '40' , '7.20' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '8336' , 'PREGHIERE A SANTA RITA DA CASCIA - 8352' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '40' , '4.20' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '23646' , 'DOMANDE A UN ESORCISTA - 8354' , '1' , '1' , '4' , '9.0000' , '9' , '0' , '40' , '5.40' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '40' , '4.20' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '20895' , 'NOVE MARTEDI DELLANGELO CUSTODE - 8458' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '40' , '1.80' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '5' , '5' , '4' , '4.0000' , '4' , '0' , '40' , '12.00' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '22555' , 'RITA DA CASCIA - 8658' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '40' , '6.00' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '40' , '15.00' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '11880' , 'ANNO CON LA BIBBIA - 8829' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '40' , '9.00' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '23163' , 'SANTA FILOMENA - 8841' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '40' , '4.20' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '22990' , 'CORONCINA A SANTA RITA DA CASCIA - 8843' , '3' , '3' , '4' , '1.5000' , '1.5' , '0' , '40' , '2.70' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '17628' , 'PREGHIERE A SAN CHARBEL - 8946' , '1' , '1' , '4' , '2.0000' , '2' , '0' , '40' , '1.20' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '23041' , 'CORONA SANTA RITA - 10944' , '2' , '2' , '1' , '7.21' , '5.9098360655738' , '22' , '40' , '10.5554' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '23554' , 'CORONA NOVENA ACUTIS - 10950' , '3' , '3' , '1' , '4.43' , '3.6311475409836' , '22' , '40' , '9.7283' ) 28/05/2025 09:50:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97424' , '16969' , 'CORONA DELLE ROSE - 10974' , '2' , '2' , '1' , '4.43' , '3.6311475409836' , '22' , '40' , '6.4855' ) 28/05/2025 11:08:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1884' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 11:08:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1884' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.41' , NOW() , NOW() ) 28/05/2025 11:08:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97428' 28/05/2025 11:08:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97428' 28/05/2025 11:08:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97428' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 28/05/2025 11:09:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1803' AND id_document != '97339' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 28/05/2025 11:09:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1803', document_date = '2025-05-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 = '4.80', price_tax_excluded = '4.80', date_upd = NOW() WHERE id_document = '97339' 28/05/2025 11:09:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97339' 28/05/2025 11:09:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97339' 28/05/2025 11:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97339' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' ) 28/05/2025 11:14:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1885' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 11:14:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1885' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 28/05/2025 11:14:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97429' 28/05/2025 11:14:45 am >> DELETE FROM ps_document_detail WHERE id_document = '97429' 28/05/2025 11:14: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 ( '97429' , '22025' , 'GUARDARE A GESU CON LO SGUARDO DI MARIA - 8582' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 28/05/2025 11:21:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 11:21:49 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' , '1886' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 28/05/2025 11:21:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97430' 28/05/2025 11:21:49 am >> DELETE FROM ps_document_detail WHERE id_document = '97430' 28/05/2025 11:21:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97430' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/05/2025 11:21:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97430' , '22267' , 'MIEI VIAGGI DEL CUORE - D. BANZATO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 28/05/2025 11:32:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 11:32:28 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' , '1887' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.75' , '12.44' , NOW() , NOW() ) 28/05/2025 11:32:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97431' 28/05/2025 11:32:28 am >> DELETE FROM ps_document_detail WHERE id_document = '97431' 28/05/2025 11:32:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97431' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 28/05/2025 11:32:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97431' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/05/2025 11:34:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 11:34: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' , '1888' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 28/05/2025 11:34: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 = '97432' 28/05/2025 11:34:59 am >> DELETE FROM ps_document_detail WHERE id_document = '97432' 28/05/2025 11:34: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 ( '97432' , '23056' , 'TERESA DI LISIEUX - GENNARI/COMBES' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/05/2025 11:34: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 ( '97432' , '18114' , 'MIA VITA - TERESA DI GESU' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 28/05/2025 11:49:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 11:49: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 ( '11' , '1889' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.10' , '44.57' , NOW() , NOW() ) 28/05/2025 11:49: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 = '97433' 28/05/2025 11:49:44 am >> DELETE FROM ps_document_detail WHERE id_document = '97433' 28/05/2025 11:49: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 ( '97433' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 28/05/2025 11:49: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 ( '97433' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 28/05/2025 11:49: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 ( '97433' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 28/05/2025 11:49: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 ( '97433' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 28/05/2025 12:01:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 12:01:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1890' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.92' , '17.92' , NOW() , NOW() ) 28/05/2025 12:01: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 = '97434' 28/05/2025 12:01:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97434' 28/05/2025 12:01: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 ( '97434' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '7' , '-7' , '4' , '0.90' , '0.9' , '0' , '5' , '6.02' ) 28/05/2025 12:01: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 ( '97434' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '5' , '-5' , '4' , '1.90' , '1.9' , '0' , '5' , '9.05' ) 28/05/2025 12:01: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 ( '97434' , '19540' , 'CRESIMA N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 28/05/2025 12:08:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 12:08:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1891' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '43.42' , NOW() , NOW() ) 28/05/2025 12:08:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97435' 28/05/2025 12:08:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '97435' 28/05/2025 12:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97435' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 28/05/2025 12:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97435' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 28/05/2025 12:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97435' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 28/05/2025 12:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97435' , '23661' , 'NOVENA A SAN CARLO ACUTIS' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 28/05/2025 12:08:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97435' , '23145' , 'SEI GRANDE! - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 28/05/2025 12:11:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '96242' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-15') 28/05/2025 12:11:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2025-03-15', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'PRIME COMUNIONI', 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 = '178.80', price_tax_excluded = '146.56', date_upd = NOW() WHERE id_document = '96242' 28/05/2025 12:11:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96242' 28/05/2025 12:11:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '96242' 28/05/2025 12:11:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '20516' , 'CROCE COMUNIONE - 42/08' , '24' , '-24' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '28.80' ) 28/05/2025 12:11:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '60.00' ) 28/05/2025 12:11:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '' , '27/05' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 28/05/2025 12:11:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 28/05/2025 12:11:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96242' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 28/05/2025 12:37:10 pm >> DELETE FROM ps_document WHERE id_document = '97421' 28/05/2025 12:37:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '97421' 28/05/2025 12:37:13 pm >> DELETE FROM ps_document WHERE id_document = '97127' 28/05/2025 12:37:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '97127' 28/05/2025 02:53:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '16/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 02:53:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '16/L' , '2025-05-28' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALIERA CURTERI' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '104.40' , '86.35' , NOW() , NOW() ) 28/05/2025 02:53:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97436' 28/05/2025 02:53:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '97436' 28/05/2025 02:53:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97436' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 28/05/2025 02:53:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97436' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 28/05/2025 02:53:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97436' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/05/2025 02:53:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97436' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 28/05/2025 03:03:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1518' AND id_document != '97010' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 28/05/2025 03:03:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1518', document_date = '2025-05-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '34.00', price_tax_excluded = '34.00', date_upd = NOW() WHERE id_document = '97010' 28/05/2025 03:03: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 = '97010' 28/05/2025 03:03:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '97010' 28/05/2025 03:03: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 ( '97010' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '22' , '22' , '0' , '0' , '22.00' ) 28/05/2025 03:03: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 ( '97010' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 28/05/2025 03:04:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1231' AND id_document != '96672' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-14') 28/05/2025 03:04:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1231', document_date = '2025-04-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.50', price_tax_excluded = '34.84', date_upd = NOW() WHERE id_document = '96672' 28/05/2025 03:04:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96672' 28/05/2025 03:04:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '96672' 28/05/2025 03:04:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96672' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '42.5' , '34.83606557377' , '22' , '0' , '42.50' ) 28/05/2025 03:04:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1761' AND id_document != '97291' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 28/05/2025 03:04:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1761', document_date = '2025-05-20', 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 = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '97291' 28/05/2025 03:04:57 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 = '97291' 28/05/2025 03:04:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '97291' 28/05/2025 03:04: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 ( '97291' , '17005' , 'BIGLIETTO AUGURALE medio' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 28/05/2025 03:04: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 ( '97291' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 28/05/2025 03:04: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 ( '97291' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 28/05/2025 03:05:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1809' AND id_document != '97347' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-23') 28/05/2025 03:05:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1809', document_date = '2025-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '128.90', price_tax_excluded = '107.55', date_upd = NOW() WHERE id_document = '97347' 28/05/2025 03:05:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97347' 28/05/2025 03:05:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '97347' 28/05/2025 03:05:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97347' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 28/05/2025 03:05:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97347' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 28/05/2025 03:05:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97347' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 28/05/2025 03:05:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97347' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 28/05/2025 03:06:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 28/05/2025 03:06:12 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '191.50', price_tax_excluded = '156.97', date_upd = NOW() WHERE id_document = '95744' 28/05/2025 03:06: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 = '95744' 28/05/2025 03:06:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '95744' 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '20516' , 'CROCE COMUNIONE - 42/08' , '30' , '-30' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '36.00' ) 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7907' , 'PERGAMENE' , '30' , '-30' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '15.00' ) 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '30' , '-30' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '15.00' ) 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 28/05/2025 03:06:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '19398' , 'CLERGY COTONE 100% MM - C02 ' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 28/05/2025 03:06:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1809' AND id_document != '97347' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-23') 28/05/2025 03:06:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1809', document_date = '2025-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '128.90', price_tax_excluded = '107.55', date_upd = NOW() WHERE id_document = '97347' 28/05/2025 03:06:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97347' 28/05/2025 03:06:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '97347' 28/05/2025 03:06:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97347' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '78.9' , '64.672131147541' , '22' , '0' , '78.90' ) 28/05/2025 03:06:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97347' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 28/05/2025 03:06:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97347' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 28/05/2025 03:07:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 28/05/2025 03:07:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '191.50', price_tax_excluded = '156.97', date_upd = NOW() WHERE id_document = '95744' 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95744' 28/05/2025 03:07:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95744' 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '20516' , 'CROCE COMUNIONE - 42/08' , '30' , '-30' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '36.00' ) 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7907' , 'PERGAMENE' , '30' , '-30' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '15.00' ) 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '30' , '-30' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '15.00' ) 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 28/05/2025 03:07:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '7202' , 'ARTICOLI RELIGIOSI CLERGY' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 28/05/2025 03:08:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1499' AND id_document != '96982' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 28/05/2025 03:08:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1499', document_date = '2025-05-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '76.90', price_tax_excluded = '63.03', date_upd = NOW() WHERE id_document = '96982' 28/05/2025 03:08:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96982' 28/05/2025 03:08:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '96982' 28/05/2025 03:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96982' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 28/05/2025 03:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96982' , '20851' , 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187' , '1' , '-1' , '1' , '38.50' , '31.55737704918' , '22' , '0' , '38.50' ) 28/05/2025 03:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96982' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '2' , '-2' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '1.40' ) 28/05/2025 03:09:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1417' AND id_document != '96886' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-29') 28/05/2025 03:09:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1417', document_date = '2025-04-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '137.86', date_upd = NOW() WHERE id_document = '96886' 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96886' 28/05/2025 03:09:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '96886' 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '40' , '-40' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '20.00' ) 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '20851' , 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '22975' , 'VERGINITA DELLA MADRE DI GESU - S.M. PERRELLA' , '1' , '-1' , '4' , '55.0000' , '55' , '0' , '5' , '52.25' ) 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '22278' , 'MARIA NEL MISTERO DI CRISTO - C. MAGGIONI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '17' , '-17' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '20.40' ) 28/05/2025 03:09:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96886' , '1937' , 'CERETTI DIAM. 40X400 - ART.500 - 4040' , '1' , '-1' , '1' , '3.8500' , '3.155737704918' , '22' , '0' , '3.85' ) 28/05/2025 03:10:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '880' AND id_document != '53418' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-26') 28/05/2025 03:10:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '880', document_date = '2022-03-26', 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 = '11.00', price_tax_excluded = '9.02', date_upd = NOW() WHERE id_document = '53418' 28/05/2025 03:10:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '53418' 28/05/2025 03:10:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '53418' 28/05/2025 03:10:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53418' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 28/05/2025 03:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53418' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 28/05/2025 03:11:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 28/05/2025 03:11:08 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '506.10', price_tax_excluded = '422.72', date_upd = NOW() WHERE id_document = '94912' 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912' 28/05/2025 03:11:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '16454' , 'PALLA ORO CM 16' , '1' , '-1' , '1' , '118.0000' , '96.72131147541' , '22' , '0' , '118.00' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '0' , 'COLLETTO' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7202' , 'ARTICOLI RELIGIOSI PETTORINA' , '2' , '-2' , '1' , '13' , '10.655737704918' , '22' , '0' , '26.00' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '5' , '-5' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '62.50' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '19' , '-19' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '180.50' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/05/2025 03:11:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 28/05/2025 03:11:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1135' AND id_document != '96565' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-08') 28/05/2025 03:11:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1135', document_date = '2025-04-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '34.00', price_tax_excluded = '27.87', date_upd = NOW() WHERE id_document = '96565' 28/05/2025 03:11:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96565' 28/05/2025 03:11:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '96565' 28/05/2025 03:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96565' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 28/05/2025 03:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96565' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 28/05/2025 03:12:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1676' AND id_document != '97193' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 28/05/2025 03:12:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1676', document_date = '2025-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.00', price_tax_excluded = '15.57', date_upd = NOW() WHERE id_document = '97193' 28/05/2025 03:12: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 = '97193' 28/05/2025 03:12:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '97193' 28/05/2025 03:12: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 ( '97193' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.3' , '13.360655737705' , '22' , '0' , '16.30' ) 28/05/2025 03:12: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 ( '97193' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '1' , '-1' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '2.70' ) 28/05/2025 03:12:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1669' AND id_document != '97185' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-14') 28/05/2025 03:12:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1669', document_date = '2025-05-14', 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 = '45.70', price_tax_excluded = '37.46', date_upd = NOW() WHERE id_document = '97185' 28/05/2025 03:12:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97185' 28/05/2025 03:12:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97185' 28/05/2025 03:12: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 ( '97185' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 28/05/2025 03:12: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 ( '97185' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 28/05/2025 03:15:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1504' AND id_document != '96989' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 28/05/2025 03:15:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1504', document_date = '2025-05-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '225.00', price_tax_excluded = '193.68', date_upd = NOW() WHERE id_document = '96989' 28/05/2025 03:15: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 = '96989' 28/05/2025 03:15:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '96989' 28/05/2025 03:15: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 ( '96989' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 28/05/2025 03:15: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 ( '96989' , '22710' , 'PRIMA DI STENDERE LE BRACCIA - O. VEZZOLI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 28/05/2025 03:15: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 ( '96989' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 28/05/2025 03:15: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 ( '96989' , '17460' , 'GIORNO SENZA TRAMONTO - M. CAMISASCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 28/05/2025 03:15: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 ( '96989' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '-1' , '1' , '46.9000' , '38.44262295082' , '22' , '0' , '46.90' ) 28/05/2025 03:15: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 ( '96989' , '22433' , 'COPRI BOTTONE - 22178' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 28/05/2025 03:15: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 ( '96989' , '20851' , 'FINTA CANDELA COMPLETA CARTUCCIA 8X25 - 1187' , '2' , '-2' , '1' , '31.4' , '25.737704918033' , '22' , '0' , '62.80' ) 28/05/2025 03:15: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 ( '96989' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '2' , '-2' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '44.00' ) 28/05/2025 03:16:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1686' AND id_document != '97205' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 28/05/2025 03:16:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1686', document_date = '2025-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '406.00', price_tax_excluded = '332.79', date_upd = NOW() WHERE id_document = '97205' 28/05/2025 03:16:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97205' 28/05/2025 03:16:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97205' 28/05/2025 03:16:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97205' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '406' , '332.7868852459' , '22' , '0' , '406.00' ) 28/05/2025 03:16:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1638' AND id_document != '97150' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-13') 28/05/2025 03:16:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1638', document_date = '2025-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '108.00', price_tax_excluded = '88.52', date_upd = NOW() WHERE id_document = '97150' 28/05/2025 03:16:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97150' 28/05/2025 03:16:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '97150' 28/05/2025 03:16:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97150' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '108' , '88.524590163934' , '22' , '0' , '108.00' ) 28/05/2025 03:17:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1604' AND id_document != '97105' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-09') 28/05/2025 03:17:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1604', document_date = '2025-05-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '97105' 28/05/2025 03:17:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97105' 28/05/2025 03:17:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '97105' 28/05/2025 03:17:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97105' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 28/05/2025 03:19:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 03:19:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1892' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 28/05/2025 03:19:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97437' 28/05/2025 03:19:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97437' 28/05/2025 03:19:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97437' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 28/05/2025 03:23:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1641' AND id_document != '97153' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-13') 28/05/2025 03:23:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1641', document_date = '2025-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '48.00', price_tax_excluded = '39.81', date_upd = NOW() WHERE id_document = '97153' 28/05/2025 03:23: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 = '97153' 28/05/2025 03:23:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '97153' 28/05/2025 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.6000' , '2.6' , '0' , '0' , '2.60' ) 28/05/2025 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 28/05/2025 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '23383' , 'BRACCIALE DECINA - BD020' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 28/05/2025 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '1' , '-1' , '1' , '7.2000' , '5.9016393442623' , '22' , '0' , '7.20' ) 28/05/2025 03:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 28/05/2025 03:28:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 03: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 ( '11' , '1893' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.50' , '102.07' , NOW() , NOW() ) 28/05/2025 03: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 = '97438' 28/05/2025 03:28:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '97438' 28/05/2025 03: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 ( '97438' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '18' , '-18' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '9.00' ) 28/05/2025 03: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 ( '97438' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 28/05/2025 03: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 ( '97438' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/05/2025 03: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 ( '97438' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 28/05/2025 03:42:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1814' AND id_document != '97352' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-23') 28/05/2025 03:42:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1814', document_date = '2025-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '97352' 28/05/2025 03:42:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97352' 28/05/2025 03:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97352' 28/05/2025 03:42: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 ( '97352' , '1596' , 'CAMPANELLO 4 SUONI - 629' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 28/05/2025 04:01:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 04:01:23 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' , '1894' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 28/05/2025 04:01:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97439' 28/05/2025 04:01:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97439' 28/05/2025 04:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97439' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 28/05/2025 04:44:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 04:44:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1895' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.40' , '41.31' , NOW() , NOW() ) 28/05/2025 04:44: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 = '97440' 28/05/2025 04:44:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '97440' 28/05/2025 04:44: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 ( '97440' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 28/05/2025 04:44: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 ( '97440' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '17' , '-17' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '20.40' ) 28/05/2025 05:04:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1780' AND id_document != '97312' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 28/05/2025 05:04:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1780', document_date = '2025-05-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.00', price_tax_excluded = '5.74', date_upd = NOW() WHERE id_document = '97312' 28/05/2025 05:04: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 = '97312' 28/05/2025 05:04:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '97312' 28/05/2025 05:04: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 ( '97312' , '19104' , 'LUMINELLI A OLIO' , '7' , '-7' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '7.00' ) 28/05/2025 05:04:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1770' AND id_document != '97300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 28/05/2025 05:04:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1770', document_date = '2025-05-21', 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 = '47.80', price_tax_excluded = '43.22', date_upd = NOW() WHERE id_document = '97300' 28/05/2025 05:04:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97300' 28/05/2025 05:04:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97300' 28/05/2025 05:04:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97300' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 28/05/2025 05:04:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97300' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/05/2025 05:04:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97300' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '9.00' ) 28/05/2025 05:04:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97300' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/05/2025 05:04:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97300' , '19104' , 'LUMINELLI A OLIO' , '2' , '-2' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '1.50' ) 28/05/2025 05:04:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97300' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 28/05/2025 05:40:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 05:40:00 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' , '1896' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '27.89' , NOW() , NOW() ) 28/05/2025 05:40: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 = '97441' 28/05/2025 05:40:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '97441' 28/05/2025 05:40: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 ( '97441' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/05/2025 05:40: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 ( '97441' , '14064' , 'STELLARIO PLEX CM 16' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 28/05/2025 06:09:09 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'qEQMzEjmKM9H4l0n' , NOW() , NOW() ) 28/05/2025 06:09:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4215' , '1' ) 28/05/2025 06:09:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4215' , '2' ) 28/05/2025 06:09:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4215' , '3' ) 28/05/2025 06:11:24 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4215' 28/05/2025 06:11: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 ( '4215' , '10' , '130' , '' , 'BARBATO' , 'DILETTA ' , 'VIA ANNARUMMA 8 PARCO DEI CEDRI' , '' , '83100' , 'AVELLINO' , '' , '' , '32826833603' , '' , '' , NOW() , NOW() ) 28/05/2025 06:11:24 pm >> UPDATE ps_customer SET email = 'robertoca@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4215' 28/05/2025 06:13:58 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4215' 28/05/2025 06:13:58 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 ( '4215' , '10' , '130' , '' , 'BARBATO' , 'DILETTA ' , 'VIA ANNARUMMA 8 PARCO DEI CEDRI' , '' , '83100' , 'AVELLINO' , '' , '' , '32826833603' , '' , '' , NOW() , NOW() ) 28/05/2025 06:13:58 pm >> UPDATE ps_customer SET email = 'robertoca@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4215' 28/05/2025 06:16:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '72' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 06:16:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '72' , '2025-05-28' , '' , '4215' , '0' , '4679508' , 'VIA ANNARUMMA 8 PARCO DEI CEDRI 83100 AVELLINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '66.50' , '66.50' , NOW() , NOW() ) 28/05/2025 06:16:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97442' 28/05/2025 06:16:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '97442' 28/05/2025 06:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97442' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/05/2025 06:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97442' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/05/2025 06:16:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97442' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 28/05/2025 06:16:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97442' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 28/05/2025 06:16:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97442' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 28/05/2025 06:18:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1897' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 06:18:56 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' , '1897' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 28/05/2025 06:18:56 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 = '97443' 28/05/2025 06:18:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '97443' 28/05/2025 06:18:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97443' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 28/05/2025 06:22:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1898' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 06:22:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1898' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.50' , '44.67' , NOW() , NOW() ) 28/05/2025 06:22:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97444' 28/05/2025 06:22:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '97444' 28/05/2025 06:22:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97444' , '7202' , 'ARTICOLI RELIGIOSI' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 28/05/2025 06:22:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97444' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.50' ) 28/05/2025 06:23:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1899' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 06:23:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1899' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 28/05/2025 06:23:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97445' 28/05/2025 06:23:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97445' 28/05/2025 06:23:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97445' , '23754' , 'CANTO DELLA RANA - G. RAVASI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/05/2025 06:52:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1900' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 06:52:56 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' , '1900' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 28/05/2025 06:52:56 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 = '97446' 28/05/2025 06:52:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '97446' 28/05/2025 06:52:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97446' , '3525' , 'DIO UNO E TRINO - P. CODA' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 28/05/2025 07:01:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 07:01:23 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' , '73' , '2025-05-28' , '' , '939' , '0' , '4670801' , 'VIA MAZZARINO,12 90018 TERMINI IMERESE' , '' , '' , '5' , '4' , '' , '0' , '0' , '' , '6' , '0' , '41.00' , '41.00' , NOW() , NOW() ) 28/05/2025 07:01:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97447' 28/05/2025 07:01:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97447' 28/05/2025 07:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97447' , '13397' , 'MIO GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '5' , '33.25' ) 28/05/2025 07:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97447' , '' , 'spese di contrassegno' , '1' , '-1' , '4' , '2.75' , '2.75' , '0' , '0' , '2.75' ) 28/05/2025 07:09:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1901' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 07:09: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' , '1901' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 28/05/2025 07:09: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 = '97448' 28/05/2025 07:09:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '97448' 28/05/2025 07:09: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 ( '97448' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 28/05/2025 07:39:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1902' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-28') 28/05/2025 07:39:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1902' , '2025-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 28/05/2025 07:39:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97449' 28/05/2025 07:39:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '97449' 28/05/2025 07:39:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97449' , '14489' , 'SAN FRANCESCO + DVD' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' )