05/12/2025 07:24:24 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/12/2025 07:24:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24394' , '1' , '' , 'nuovo-prodotto' ) 05/12/2025 07:24:24 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24394' , '1' , '1' , '2' , NOW() , NOW() ) 05/12/2025 07:24:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24394' , '0' , '1' , '0' , '0' ) 05/12/2025 09:15:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4077' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 09:15:14 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' , '4077' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.00' , '52.46' , NOW() , NOW() ) 05/12/2025 09:15:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100292' 05/12/2025 09:15:14 am >> DELETE FROM ps_document_detail WHERE id_document = '100292' 05/12/2025 09:15:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100292' , '24194' , 'PRESEPE NATIVITA - P780' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 05/12/2025 09:15:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100292' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '2' , '-2' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '48.00' ) 05/12/2025 09:25:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392896' AND id_product != '24394' AND ean13 != '' 05/12/2025 09:25:38 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256392896', date_upd = NOW() WHERE id_product = '24394' 05/12/2025 09:25:38 am >> UPDATE ps_product_lang SET name = 'PREGHIAMO CON S. FRANCESCO E S. CHIARA - 8333', description = '' WHERE id_product = '24394' 05/12/2025 09:25:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '24394' 05/12/2025 09:25:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24394' 05/12/2025 09:25:38 am >> DELETE FROM ps_specific_price WHERE id_product = '24394' 05/12/2025 09:25:40 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 = '24394' 05/12/2025 09:25:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24395' , '1' , '' , 'nuovo-prodotto' ) 05/12/2025 09:25:40 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 '24395' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24394' 05/12/2025 09:25:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24395' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24394' 05/12/2025 09:26:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392940' AND id_product != '24395' AND ean13 != '' 05/12/2025 09:26:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256392940', date_upd = NOW() WHERE id_product = '24395' 05/12/2025 09:26:32 am >> UPDATE ps_product_lang SET name = 'SAN GERARDO MAIELLA - 7433', description = '' WHERE id_product = '24395' 05/12/2025 09:26:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '24395' 05/12/2025 09:26:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24395' 05/12/2025 09:26:32 am >> DELETE FROM ps_specific_price WHERE id_product = '24395' 05/12/2025 09:26:32 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 = '24395' 05/12/2025 09:26:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24396' , '1' , '' , 'nuovo-prodotto' ) 05/12/2025 09:26:32 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 '24396' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24395' 05/12/2025 09:26:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24396' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24395' 05/12/2025 09:30:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042279' AND id_product != '7109' AND ean13 != '' 05/12/2025 09:30:53 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884042279', date_upd = NOW() WHERE id_product = '7109' 05/12/2025 09:30:53 am >> UPDATE ps_product_lang SET name = 'NOVENA ALL\'IMMACOLATA CONCEZIONE - 8520', description = '' WHERE id_product = '7109' 05/12/2025 09:30:53 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '4' WHERE id_product = '7109' 05/12/2025 09:30:53 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '4', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7109' 05/12/2025 09:30:53 am >> DELETE FROM ps_specific_price WHERE id_product = '7109' 05/12/2025 09:31: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 ( '31' , '18280/002025' , '2025-12-03' , '002025' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0.01' , '1' , '0' , '0' , '0' , '' , '1' , '0' , '154.79' , '146.79' , NOW() , NOW() ) 05/12/2025 09:31: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 = '100293' 05/12/2025 09:31:46 am >> DELETE FROM ps_document_detail WHERE id_document = '100293' 05/12/2025 09:31: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 ( '100293' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '7' , '7' , '4' , '5.00' , '5' , '0' , '40' , '21.0000' ) 05/12/2025 09:31:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '24214' AND id_supplier = '38' 05/12/2025 09:31:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24214' , '38' , '1' ) 05/12/2025 09:31: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 ( '100293' , '17624' , 'ADORIAMO IL SS SACRAMENTO - AVVENTO E NATALE' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 05/12/2025 09:31:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17624' AND id_supplier = '38' 05/12/2025 09:31:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17624' , '38' , '1' ) 05/12/2025 09:31: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 ( '100293' , '18804' , 'NOVENA AL NATALE - 8045' , '5' , '5' , '4' , '3.00' , '3' , '0' , '40' , '9.0000' ) 05/12/2025 09:31:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18804' AND id_supplier = '38' 05/12/2025 09:31:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18804' , '38' , '1' ) 05/12/2025 09:31: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 ( '100293' , '8334' , 'PREGHIERE A SAN GIUSEPPE - 8115' , '1' , '1' , '4' , '8.00' , '8' , '0' , '40' , '4.8000' ) 05/12/2025 09:31:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '8334' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8334' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '10299' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10299' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '4699' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4699' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '6317' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6317' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '24394' , 'PREGHIAMO CON S. FRANCESCO E S. CHIARA - 8333' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '24394' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24394' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '24395' , 'SAN GERARDO MAIELLA - 7433' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '24395' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24395' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '3' , '3' , '4' , '4' , '4' , '0' , '40' , '7.2000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '22024' , 'TRATTATO DELLA VERA DEVOZIONE - 8576' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '22024' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22024' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '22412' , 'SACRA BIBBIA - 8602' , '1' , '1' , '4' , '30.00' , '30' , '0' , '40' , '18.0000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '22412' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22412' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '9647' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9647' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '6720' , 'MIRACOLI EUCARISTICI - 8735' , '1' , '1' , '4' , '15.00' , '15' , '0' , '40' , '9.0000' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '6720' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6720' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '24126' , 'AGENDA DEVOZIONALE 2026 PREGAGENDA - 40829' , '3' , '3' , '1' , '11.47' , '9.4016393442623' , '22' , '40' , '25.1881' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '24126' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24126' , '38' , '1' ) 05/12/2025 09:31:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '1' , '1' , '11.475' , '9.405737704918' , '22' , '40' , '8.3997' ) 05/12/2025 09:31:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '24073' AND id_supplier = '38' 05/12/2025 09:31:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24073' , '38' , '1' ) 05/12/2025 09:31:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '3' , '3' , '1' , '2.459' , '2.0155737704918' , '22' , '40' , '5.4000' ) 05/12/2025 09:31:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '24016' AND id_supplier = '38' 05/12/2025 09:31:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24016' , '38' , '1' ) 05/12/2025 09:31:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '24074' , 'AGENDA SETTIMANALE POCKET 2026 ROSSA' , '1' , '1' , '1' , '7.37' , '6.0409836065574' , '22' , '40' , '5.3948' ) 05/12/2025 09:31:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '24074' AND id_supplier = '38' 05/12/2025 09:31:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24074' , '38' , '1' ) 05/12/2025 09:31:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100293' , '7108' , 'NOVENA AL SANTO NATALE - 8521' , '2' , '2' , '4' , '2.00' , '2' , '0' , '40' , '2.4000' ) 05/12/2025 09:31:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7108' AND id_supplier = '38' 05/12/2025 09:31:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7108' , '38' , '1' ) 05/12/2025 09:43: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 ( '31' , '17189/00/2025' , '2025-11-14' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '390.00' , '390.00' , NOW() , NOW() ) 05/12/2025 09:43: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 = '100294' 05/12/2025 09:43:44 am >> DELETE FROM ps_document_detail WHERE id_document = '100294' 05/12/2025 09:43: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 ( '100294' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '130' , '130' , '4' , '5.00' , '5' , '0' , '40' , '390.0000' ) 05/12/2025 09:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '24214' AND id_supplier = '38' 05/12/2025 09:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24214' , '38' , '1' ) 05/12/2025 09:48:19 am >> SELECT document_num FROM ps_document WHERE document_num = '4078' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 09:48:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4078' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 05/12/2025 09:48:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100295' 05/12/2025 09:48:19 am >> DELETE FROM ps_document_detail WHERE id_document = '100295' 05/12/2025 09:48:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100295' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '7.20' ) 05/12/2025 10:40:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4079' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 10:40:02 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' , '4079' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '26.36' , NOW() , NOW() ) 05/12/2025 10:40:02 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 = '100296' 05/12/2025 10:40:02 am >> DELETE FROM ps_document_detail WHERE id_document = '100296' 05/12/2025 10:40:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100296' , '24038' , 'VITA CRISTIANA 2026' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 05/12/2025 10:40:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100296' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/12/2025 10:40:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100296' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 05/12/2025 10:40:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100296' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 05/12/2025 10:40:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100296' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 05/12/2025 10:40:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100296' , '21860' , 'BAMBINELLO CM 10 - PKS10-C' , '1' , '-1' , '1' , '6.1' , '5' , '22' , '0' , '6.10' ) 05/12/2025 10:47:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4080' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 10:47:13 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' , '4080' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 05/12/2025 10:47:13 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 = '100297' 05/12/2025 10:47:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100297' 05/12/2025 10:47:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100297' , '24089' , 'ICONA GRECA SERIGRAFATA 14X11 - K094.A' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 05/12/2025 11:07:05 am >> SELECT document_num FROM ps_document WHERE document_num = '4081' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 11:07:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4081' , '2025-12-05' , '' , '0' , '0' , '0' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.45' , '48.45' , NOW() , NOW() ) 05/12/2025 11:07:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100298' 05/12/2025 11:07:05 am >> DELETE FROM ps_document_detail WHERE id_document = '100298' 05/12/2025 11:07:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100298' , '23990' , 'DI PASQUA IN PASQUA - F. ROSINI' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 05/12/2025 11:07:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100298' , '24326' , 'IO SONO COME GUARDO - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/12/2025 11:07:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4082' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 11:07:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4082' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 05/12/2025 11:07:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100299' 05/12/2025 11:07:36 am >> DELETE FROM ps_document_detail WHERE id_document = '100299' 05/12/2025 11:07:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100299' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '5.0000' , '4.0984' , '22' , '0' , '5.00' ) 05/12/2025 11:07:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100299' , '6810' , 'MOCCOLO 80X150' , '4' , '-4' , '1' , '7.0000' , '5.7377' , '22' , '0' , '28.00' ) 05/12/2025 11:07:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100299' , '19345' , 'BALZA IN RASO H CM 19 - P456' , '3' , '-3' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '69.00' ) 05/12/2025 11:08:01 am >> DELETE FROM ps_document WHERE id_document = '100116' 05/12/2025 11:08:01 am >> DELETE FROM ps_document_detail WHERE id_document = '100116' 05/12/2025 11:09:01 am >> SELECT document_num FROM ps_document WHERE document_num = '4083' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 11:09:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4083' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '182.26' , '155.80' , NOW() , NOW() ) 05/12/2025 11:09:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100300' 05/12/2025 11:09:01 am >> DELETE FROM ps_document_detail WHERE id_document = '100300' 05/12/2025 11:09:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100300' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/12/2025 11:09:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100300' , '18357' , 'MIE PREGHIERINE N.E.' , '17' , '-17' , '4' , '1.28' , '1.28' , '0' , '0' , '21.76' ) 05/12/2025 11:09:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100300' , '19345' , 'BALZA IN RASO H CM 19 - P456' , '5' , '-5' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '115.00' ) 05/12/2025 11:09:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100300' , '6810' , 'MOCCOLO 80X150' , '4' , '-4' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '28.00' ) 05/12/2025 11:27:49 am >> SELECT document_num FROM ps_document WHERE document_num = '4084' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 11:27: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' , '4084' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 05/12/2025 11:27: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 = '100301' 05/12/2025 11:27:49 am >> DELETE FROM ps_document_detail WHERE id_document = '100301' 05/12/2025 11:27: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 ( '100301' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 05/12/2025 11:29:36 am >> SELECT document_num FROM ps_document WHERE document_num = '4085' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 11:29:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4085' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.90' , '1.56' , NOW() , NOW() ) 05/12/2025 11:29:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100302' 05/12/2025 11:29:36 am >> DELETE FROM ps_document_detail WHERE id_document = '100302' 05/12/2025 11:29:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100302' , '15484' , 'CROCE - 076BIS ALV.' , '1' , '-1' , '1' , '1.90' , '1.5573770491803' , '22' , '0' , '1.90' ) 05/12/2025 11:52:27 am >> SELECT document_num FROM ps_document WHERE document_num = '4086' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 11:52:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4086' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 05/12/2025 11:52:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100303' 05/12/2025 11:52:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100303' 05/12/2025 11:52: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 ( '100303' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 05/12/2025 12:17:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4087' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 12:17:47 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' , '4087' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 05/12/2025 12:17:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100304' 05/12/2025 12:17:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '100304' 05/12/2025 12:17:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100304' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '58' , '47.540983606557' , '22' , '0' , '58.00' ) 05/12/2025 12:27:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '144/A' AND id_document != '100087' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-26') 05/12/2025 12:27:16 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '144/A', document_date = '2025-11-26', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4679537', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '237.00', price_tax_excluded = '206.55', date_upd = NOW() WHERE id_document = '100087' 05/12/2025 12:27: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 = '100087' 05/12/2025 12:27:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '100087' 05/12/2025 12:27: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 ( '100087' , '12531' , 'LAMPADA A SFERA ROSSA' , '4' , '-4' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '100.00' ) 05/12/2025 12:27: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 ( '100087' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/12/2025 12:27: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 ( '100087' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 05/12/2025 12:27: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 ( '100087' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 05/12/2025 12:27: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 ( '100087' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 05/12/2025 12:27:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '4088' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 12:27: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 ( '11' , '4088' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 05/12/2025 12:27: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 = '100305' 05/12/2025 12:27:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '100305' 05/12/2025 12:27: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 ( '100305' , '21701' , 'NASCITA DI GESU' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 05/12/2025 12:47:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '718679' , '2025-12-04' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.12' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.64' , '107.64' , NOW() , NOW() ) 05/12/2025 12:47:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100306' 05/12/2025 12:47:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '100306' 05/12/2025 12:47:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100306' , '2048' , 'CHRISTIFIDELES LAICI' , '39' , '39' , '4' , '4.00' , '4' , '0' , '33' , '104.5200' ) 05/12/2025 12:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2048' AND id_supplier = '7' 05/12/2025 12:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2048' , '7' , '1' ) 05/12/2025 12:47:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100306' , '2048' , 'CHRISTIFIDELES LAICI' , '5' , '5' , '4' , '4.00' , '4' , '0' , '100' , '0.0000' ) 05/12/2025 12:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2048' AND id_supplier = '7' 05/12/2025 12:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2048' , '7' , '1' ) 05/12/2025 04:47:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4089' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 04:47:19 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' , '4089' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 05/12/2025 04:47:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100307' 05/12/2025 04:47:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100307' 05/12/2025 04:47:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100307' , '4374' , 'GESÙ BAMBINO - 273' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 05/12/2025 04:49:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4090' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 04:49:38 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' , '4090' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.20' , '64.92' , NOW() , NOW() ) 05/12/2025 04:49: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 = '100308' 05/12/2025 04:49:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100308' 05/12/2025 04:49:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100308' , '1951' , 'CERONI S.S. T60 - CARTA ROSSO' , '24' , '-24' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '79.20' ) 05/12/2025 05:01:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4091' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 05:01:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4091' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 05/12/2025 05:01:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100309' 05/12/2025 05:01:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100309' 05/12/2025 05:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100309' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/12/2025 05:01:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100309' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.2' , '1.8032786885246' , '22' , '0' , '2.20' ) 05/12/2025 05:03:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '4092' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 05:03:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4092' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 05/12/2025 05:03:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100310' 05/12/2025 05:03:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '100310' 05/12/2025 05:03:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100310' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 05/12/2025 05:32:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '4093' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 05:32: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' , '4093' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 05/12/2025 05:32: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 = '100311' 05/12/2025 05:32:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '100311' 05/12/2025 05:32: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 ( '100311' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 05/12/2025 05:38:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '4090' AND id_document != '100308' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 05:38:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4090', document_date = '2025-12-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 = '79.20', price_tax_excluded = '64.92', date_upd = NOW() WHERE id_document = '100308' 05/12/2025 05:38: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 = '100308' 05/12/2025 05:38:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '100308' 05/12/2025 05:38: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 ( '100308' , '1951' , 'CERONI S.S. T60 - CARTA ROSSO' , '21' , '-21' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '69.30' ) 05/12/2025 05:38: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 ( '100308' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '9.90' ) 05/12/2025 05:39:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3909' AND id_document != '100069' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 05/12/2025 05:39:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3909', document_date = '2025-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.00', price_tax_excluded = '3.28', date_upd = NOW() WHERE id_document = '100069' 05/12/2025 05:39:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100069' 05/12/2025 05:39:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '100069' 05/12/2025 05:39:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100069' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 05/12/2025 05:39:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100069' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 05/12/2025 05:42:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4025' AND id_document != '100221' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-02') 05/12/2025 05:42:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4025', document_date = '2025-12-02', 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 = '10.40', price_tax_excluded = '8.52', date_upd = NOW() WHERE id_document = '100221' 05/12/2025 05:42: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 = '100221' 05/12/2025 05:42:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100221' 05/12/2025 05:42: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 ( '100221' , '22546' , 'ROSARIO LEGNO - MM5 - R944' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 05/12/2025 05:42: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 ( '100221' , '24093' , 'ROSARIO ACUTIS - RE 1959-254' , '1' , '-1' , '1' , '5.6000' , '4.5901639344262' , '22' , '0' , '5.60' ) 05/12/2025 05:42: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 ( '100221' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '1.80' ) 05/12/2025 05:43:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3681' AND id_document != '99738' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 05/12/2025 05:43:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3681', document_date = '2025-11-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 = '4.00', price_tax_excluded = '3.28', date_upd = NOW() WHERE id_document = '99738' 05/12/2025 05:43: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 = '99738' 05/12/2025 05:43:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '99738' 05/12/2025 05:43: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 ( '99738' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '2.40' ) 05/12/2025 05:43: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 ( '99738' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 05/12/2025 05:43: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 ( '99738' , '6332' , 'MEDAGLIA OVALE DECORATA - MISERICORDIOSO - G291-D' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 05/12/2025 05:45:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '30' AND id_document != '99271' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-10-15') 05/12/2025 05:45:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '30', document_date = '2025-10-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2635', address1 = 'VIA CARLO POMA, 2 00151 ROMA', address2 = '', note = 'RESA - n. c. ricevuta € 44,80', 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 = '48.00', date_upd = NOW() WHERE id_document = '99271' 05/12/2025 05:45: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 = '99271' 05/12/2025 05:45:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '99271' 05/12/2025 05:45: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 ( '99271' , '22753' , 'MESSA MEDITAZIONE - SETT/OTT 2024' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 05/12/2025 05:45: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 ( '99271' , '23607' , 'MESSA MEDITAZIONE - LUG/AGO 25' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 05/12/2025 05:45: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 ( '99271' , '22307' , 'MESSA MEDITAZIONE - LUG/AGO 2024' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 05/12/2025 05:45: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 ( '99271' , '23606' , 'MESSA MEDITAZIONE - MAG/GIU 25' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 05/12/2025 05:45: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 ( '99271' , '21869' , 'MESSA MEDITAZIONE - MAR/APR 2024' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 05/12/2025 05:46:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '99268' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-10-15') 05/12/2025 05:46:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '29', document_date = '2025-10-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'RESA - N.C. RICEVUTA € 631,17', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '967.20', price_tax_excluded = '966.35', date_upd = NOW() WHERE id_document = '99268' 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99268' 05/12/2025 05:46:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '99268' 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23990' , 'DI PASQUA IN PASQUA - F. ROSINI' , '6' , '-6' , '4' , '39.0000' , '39' , '0' , '0' , '234.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23802' , 'MIA SPERANZA E IN TE - AGGIUNTA LIBRETTO' , '7' , '-7' , '4' , '4.5000' , '4.5' , '0' , '0' , '31.50' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23803' , 'MIA SPERANZA E IN TE - AGGIUNTA SPARTITI' , '1' , '-1' , '3' , '10.0000' , '9.6153846153846' , '4' , '0' , '10.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '15828' , 'NOVUM TESTAMENTUM ET PSALTERIUM' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '22784' , 'ROSARIO CON PADRE PIO' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '1800' , 'CATECHESI AI PRINCIPIANTI - SANTAGOSTINO' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '11225' , 'VERGINE MARIA - A. DIPPONA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '3724' , 'DOVERE DI AMARE DIO - B. DI CHIARAVALLE' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '2912' , 'CRISTO GESÙ DIO DELLA MIA VITA - T.DAVILA' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23470' , 'SUO AMORE E PER SEMPRE - SPARTITO' , '1' , '-1' , '3' , '12.0000' , '11.538461538462' , '4' , '0' , '12.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23469' , 'SUO AMORE E PER SEMPRE' , '1' , '-1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.90' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '14503' , 'GIOVANI LIBERI DI AMARE' , '3' , '-3' , '4' , '1.8000' , '1.8' , '0' , '0' , '5.40' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '19641' , 'PREGHIERA SEMINA VITA - O. MARRAFFA' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '23197' , 'AIUTAMI A PREGARE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '21717' , 'AIUTAMI AD ESSERE MADRE ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '22326' , 'AIUTAMI A SUPERARE IL LUTTO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '21922' , 'A TU PER TU - S. JURGENS' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '19293' , '10 OTTIMI MOTIVI PER CONFESSARSI - A. COMASTRI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '3' , '-3' , '4' , '1.0000' , '1' , '0' , '0' , '3.00' ) 05/12/2025 05:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99268' , '22979' , 'SCOPRIAMO INSIEME IL GIUBILEO' , '3' , '-3' , '4' , '4.9000' , '4.9' , '0' , '0' , '14.70' ) 05/12/2025 05:46: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 ( '99268' , '15896' , 'SEGUIRE GESU INSIEME A SAN PIETRO - O. DE BERTOLIS' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/12/2025 05:46: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 ( '99268' , '22818' , 'MOSCHETTIERI DI PADRE PIO - ALLEGRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/12/2025 05:46: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 ( '99268' , '18434' , 'QUANDO LA FEDE DIVENTA CONCRETA - F. KAMPHAUS' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/12/2025 05:46: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 ( '99268' , '14381' , 'DIACONIA ALLA COCIENZA - M. TRAVASCIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 05/12/2025 05:46: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 ( '99268' , '23481' , 'MEDITAZIONI TEOLOGICHE SULLA VIA CRUCIS - S. MACCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/12/2025 05:46: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 ( '99268' , '20672' , 'VOLGERANNO LO SGUARDO A COLUI ... - P. MONTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/12/2025 05:46: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 ( '99268' , '20761' , 'LUCE ATTRAVERSO IL TEMPO - M. CAMISASCA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 05/12/2025 05:46: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 ( '99268' , '21566' , 'CON FRANCESCO ALLA SCOPERTA DELLA REGOLA ' , '2' , '-2' , '4' , '6.9000' , '6.9' , '0' , '0' , '13.80' ) 05/12/2025 05:46: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 ( '99268' , '20450' , 'VANGELO PER IMMAGINI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/12/2025 05:46: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 ( '99268' , '23509' , 'DIECI PARROCCHIE E UN SOLO PARROCO - S. BORGHI' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '0' , '32.00' ) 05/12/2025 05:46: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 ( '99268' , '23145' , 'SEI GRANDE! - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/12/2025 05:46: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 ( '99268' , '22485' , 'MARIA DONNA CHE APRE SENTIERI - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/12/2025 05:46: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 ( '99268' , '23521' , 'VERO BENE COMUNE - PAPA FRANCESCO' , '2' , '-2' , '4' , '18.0000' , '18' , '0' , '0' , '36.00' ) 05/12/2025 05:46: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 ( '99268' , '20663' , 'CON MARIA SULLA STRADA DELLA PASQUA - L. FANZAGA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/12/2025 05:46: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 ( '99268' , '22490' , 'MARIA DI NAZARET - F. MANZI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/12/2025 05:46: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 ( '99268' , '23250' , 'PREGANDO LA PAROLA - ANNO C - M. TELLAN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/12/2025 05:46: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 ( '99268' , '23070' , 'PAROLA CHE RISANA - ANNO C - A. SANSONE' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 05/12/2025 05:46: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 ( '99268' , '8025' , 'PIER GIORGIO FRASSATI: MODELLO PER I CRISTIANI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/12/2025 05:46: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 ( '99268' , '4273' , 'FRANCESCO DASSISI - A. DE SIMONE' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 05/12/2025 05:46: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 ( '99268' , '4507' , 'GESÙ, CONFIDO IN TE!' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 05/12/2025 05:46: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 ( '99268' , '17929' , 'UOMO GIUSTO - E. FERRO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/12/2025 05:46: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 ( '99268' , '19415' , 'BIBBIA - PAROLA UNA E PLURALE - Y. BLANCHARD' , '1' , '-1' , '4' , '21.0000' , '21' , '0' , '0' , '21.00' ) 05/12/2025 05:46: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 ( '99268' , '19060' , 'NOI TI PREGHIAMO - ANNO C - S. SAVAGLIA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/12/2025 05:46: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 ( '99268' , '15854' , 'QOHELET - A. PONSO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 05/12/2025 05:46: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 ( '99268' , '16974' , 'PER STRADE DESERTE - C. BARONE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/12/2025 05:46: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 ( '99268' , '22941' , 'VOLTI DI DIO - AAVV' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/12/2025 05:46: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 ( '99268' , '19333' , 'LORO VOCE PERCORRE LA TERRA - A.M. CANOPI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 05/12/2025 05:46: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 ( '99268' , '0' , 'TITOLI GUASTI AUTORIZZATI' , '0' , '0' , '4' , '0.0000' , '0' , '0' , '0' , '0.00' ) 05/12/2025 05:46: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 ( '99268' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.9000' , '9.9' , '0' , '0' , '29.70' ) 05/12/2025 05:46: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 ( '99268' , '12809' , 'SEDOTTI DALLA PAROLA - P. SCALABRINI' , '1' , '-1' , '4' , '24.0000' , '24' , '0' , '0' , '24.00' ) 05/12/2025 05:57:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 05:57:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4094' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 05/12/2025 05:57:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100312' 05/12/2025 05:57:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '100312' 05/12/2025 05:57:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100312' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 05/12/2025 06:35:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-05') 05/12/2025 06:35:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4095' , '2025-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 05/12/2025 06:35:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100313' 05/12/2025 06:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '100313' 05/12/2025 06:35:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100313' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' )