30/06/2025 08:59:37 am >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 08:59:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '19' , '2025-06-30' , '' , '835' , '0' , '4671989' , 'VIA BRIGNANO INF 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 30/06/2025 08:59:37 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 = '97915' 30/06/2025 08:59:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97915' 30/06/2025 08:59:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97915' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '60.00' ) 30/06/2025 09:09:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2303' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 09:09: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' , '2303' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 30/06/2025 09:09: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 = '97916' 30/06/2025 09:09:27 am >> DELETE FROM ps_document_detail WHERE id_document = '97916' 30/06/2025 09:09: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 ( '97916' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2025 09:09: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 ( '97916' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2025 09:32:53 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/06/2025 09:32:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23840' , '1' , '' , 'nuovo-prodotto' ) 30/06/2025 09:32:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23840' , '1' , '1' , '2' , NOW() , NOW() ) 30/06/2025 09:32:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23840' , '0' , '1' , '0' , '0' ) 30/06/2025 09:34:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002359' AND id_product != '23840' AND ean13 != '' 30/06/2025 09:34:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002360' AND id_product != '23840' AND ean13 != '' 30/06/2025 09:34:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002386' AND id_product != '23840' AND ean13 != '' 30/06/2025 09:34:58 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002386', date_upd = NOW() WHERE id_product = '23840' 30/06/2025 09:34:58 am >> UPDATE ps_product_lang SET name = 'COPRI LEGGIO - 331/TP', description = '' WHERE id_product = '23840' 30/06/2025 09:34:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '55.73770491803279' WHERE id_product = '23840' 30/06/2025 09:34:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '55.73770491803279', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23840' 30/06/2025 09:34:58 am >> DELETE FROM ps_specific_price WHERE id_product = '23840' 30/06/2025 09:34:59 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 = '23840' 30/06/2025 09:34:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23841' , '1' , '' , 'nuovo-prodotto' ) 30/06/2025 09:34:59 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 '23841' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23840' 30/06/2025 09:34:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23841' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23840' 30/06/2025 09:36:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002387' AND id_product != '23841' AND ean13 != '' 30/06/2025 09:36:51 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002387', date_upd = NOW() WHERE id_product = '23841' 30/06/2025 09:36:51 am >> UPDATE ps_product_lang SET name = 'CAMICE SVASATO 100% MODAL - 434 MD', description = '' WHERE id_product = '23841' 30/06/2025 09:36:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '159.8360655737705' WHERE id_product = '23841' 30/06/2025 09:36:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '159.8360655737705', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23841' 30/06/2025 09:36:51 am >> DELETE FROM ps_specific_price WHERE id_product = '23841' 30/06/2025 09:36:52 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 = '23841' 30/06/2025 09:36:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23842' , '1' , '' , 'nuovo-prodotto' ) 30/06/2025 09:36:52 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 '23842' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23841' 30/06/2025 09:36:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23842' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23841' 30/06/2025 09:40:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002388' AND id_product != '23842' AND ean13 != '' 30/06/2025 09:40:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002388', date_upd = NOW() WHERE id_product = '23842' 30/06/2025 09:40:20 am >> UPDATE ps_product_lang SET name = 'CASULA POL RICAMO FASCIONE - 60532/TP', description = '' WHERE id_product = '23842' 30/06/2025 09:40:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '200.81967213114754' WHERE id_product = '23842' 30/06/2025 09:40:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '200.81967213114754', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23842' 30/06/2025 09:40:20 am >> DELETE FROM ps_specific_price WHERE id_product = '23842' 30/06/2025 09:40:24 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 = '23842' 30/06/2025 09:40:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23843' , '1' , '' , 'nuovo-prodotto' ) 30/06/2025 09:40:24 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 '23843' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23842' 30/06/2025 09:40:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23843' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23842' 30/06/2025 09:42:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002389' AND id_product != '23843' AND ean13 != '' 30/06/2025 09:42:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002389', date_upd = NOW() WHERE id_product = '23843' 30/06/2025 09:42:15 am >> UPDATE ps_product_lang SET name = 'CASULA CON APPLICAZIONI IN TESSUTO - 60533/TP', description = '' WHERE id_product = '23843' 30/06/2025 09:42:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '155.7377049180328' WHERE id_product = '23843' 30/06/2025 09:42:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '155.7377049180328', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23843' 30/06/2025 09:42:15 am >> DELETE FROM ps_specific_price WHERE id_product = '23843' 30/06/2025 09:42:20 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 = '23843' 30/06/2025 09:42:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23844' , '1' , '' , 'nuovo-prodotto' ) 30/06/2025 09:42:20 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 '23844' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23843' 30/06/2025 09:42:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23844' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23843' 30/06/2025 09:44:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002390' AND id_product != '23844' AND ean13 != '' 30/06/2025 09:44:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002390', date_upd = NOW() WHERE id_product = '23844' 30/06/2025 09:44:21 am >> UPDATE ps_product_lang SET name = 'CASULA BORDO APPLICATO - 60537/TP', description = '' WHERE id_product = '23844' 30/06/2025 09:44:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '94.26229508196721' WHERE id_product = '23844' 30/06/2025 09:44:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '94.26229508196721', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23844' 30/06/2025 09:44:21 am >> DELETE FROM ps_specific_price WHERE id_product = '23844' 30/06/2025 09:44:21 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 = '23844' 30/06/2025 09:44:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23845' , '1' , '' , 'nuovo-prodotto' ) 30/06/2025 09:44:21 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 '23845' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23844' 30/06/2025 09:44:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23845' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23844' 30/06/2025 09:46:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002391' AND id_product != '23845' AND ean13 != '' 30/06/2025 09:46:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002391', date_upd = NOW() WHERE id_product = '23845' 30/06/2025 09:46:25 am >> UPDATE ps_product_lang SET name = 'CASULA MICROFIBRA - 60560/PM', description = '' WHERE id_product = '23845' 30/06/2025 09:46:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '64.75409836065575' WHERE id_product = '23845' 30/06/2025 09:46:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '64.75409836065575', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23845' 30/06/2025 09:46:25 am >> DELETE FROM ps_specific_price WHERE id_product = '23845' 30/06/2025 09:46:26 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 = '23845' 30/06/2025 09:46:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23846' , '1' , '' , 'nuovo-prodotto' ) 30/06/2025 09:46:26 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 '23846' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23845' 30/06/2025 09:46:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23846' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23845' 30/06/2025 09:48: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 ( '31' , '400' , '2025-06-25' , '' , '0' , '89' , '2729' , 'VIA COLLE DI NAVA, 127D 12060 MAGLIANO ALPI' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '1323.33' , '1084.70' , NOW() , NOW() ) 30/06/2025 09:48: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 = '97917' 30/06/2025 09:48:02 am >> DELETE FROM ps_document_detail WHERE id_document = '97917' 30/06/2025 09:48: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 ( '97917' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '1' , '1' , '31' , '25.409836065574' , '22' , '0' , '37.8200' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '12742' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12742' , '89' , '1' ) 30/06/2025 09:48: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 ( '97917' , '23840' , 'COPRI LEGGIO - 331/TP' , '1' , '1' , '1' , '28.5' , '23.360655737705' , '22' , '0' , '34.7700' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23840' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23840' , '89' , '1' ) 30/06/2025 09:48: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 ( '97917' , '23841' , 'CAMICE SVASATO 100% MODAL - 434 MD' , '3' , '3' , '1' , '80.5' , '65.983606557377' , '22' , '0' , '294.6300' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23841' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23841' , '89' , '1' ) 30/06/2025 09:48: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 ( '97917' , '23717' , 'CASULA - 60530 tP' , '1' , '1' , '1' , '46' , '37.704918032787' , '22' , '0' , '56.1200' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23717' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23717' , '89' , '1' ) 30/06/2025 09:48: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 ( '97917' , '23842' , 'CASULA POL RICAMO FASCIONE - 60532/TP' , '1' , '1' , '1' , '99.5' , '81.55737704918' , '22' , '0' , '121.3900' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23842' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23842' , '89' , '1' ) 30/06/2025 09:48: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 ( '97917' , '23843' , 'CASULA CON APPLICAZIONI IN TESSUTO - 60533/TP' , '4' , '4' , '1' , '77' , '63.114754098361' , '22' , '0' , '375.7600' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23843' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23843' , '89' , '1' ) 30/06/2025 09:48: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 ( '97917' , '23844' , 'CASULA BORDO APPLICATO - 60537/TP' , '4' , '4' , '1' , '46.8' , '38.360655737705' , '22' , '0' , '228.3840' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23844' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23844' , '89' , '1' ) 30/06/2025 09:48: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 ( '97917' , '23845' , 'CASULA MICROFIBRA - 60560/PM' , '4' , '4' , '1' , '32' , '26.229508196721' , '22' , '0' , '156.1600' ) 30/06/2025 09:48:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '23845' AND id_supplier = '89' 30/06/2025 09:48:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23845' , '89' , '1' ) 30/06/2025 10:14:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2283' AND id_document != '97893' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-27') 30/06/2025 10:14:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2283', document_date = '2025-06-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '79.00', price_tax_excluded = '64.75', date_upd = NOW() WHERE id_document = '97893' 30/06/2025 10:14:47 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 = '97893' 30/06/2025 10:14:47 am >> DELETE FROM ps_document_detail WHERE id_document = '97893' 30/06/2025 10:14: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 ( '97893' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 30/06/2025 10:23:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2304' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 10:23:37 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' , '2304' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 30/06/2025 10:23:37 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 = '97918' 30/06/2025 10:23:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97918' 30/06/2025 10:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13.8' , '11.311475409836' , '22' , '0' , '13.80' ) 30/06/2025 10:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/06/2025 10:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 30/06/2025 10:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 30/06/2025 10:46:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2305' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 10:46:58 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' , '2305' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 30/06/2025 10:46:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97919' 30/06/2025 10:46:58 am >> DELETE FROM ps_document_detail WHERE id_document = '97919' 30/06/2025 10:46:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97919' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 30/06/2025 11:49:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3039' , '2025-06-26' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.60' , '59.60' , NOW() , NOW() ) 30/06/2025 11:49:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97920' 30/06/2025 11:49:35 am >> DELETE FROM ps_document_detail WHERE id_document = '97920' 30/06/2025 11:49:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97920' , '18114' , 'MIA VITA - TERESA DI GESU' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 30/06/2025 11:49:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18114' AND id_supplier = '47' 30/06/2025 11:49:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18114' , '47' , '1' ) 30/06/2025 11:49: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 ( '97920' , '22432' , 'IN SINU JESU' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 30/06/2025 11:49:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22432' AND id_supplier = '47' 30/06/2025 11:49:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22432' , '47' , '1' ) 30/06/2025 11:49: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 ( '97920' , '23761' , 'ECCO IO VEDO I CIELI - R. TALMELLI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 30/06/2025 11:49:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '23761' AND id_supplier = '47' 30/06/2025 11:49:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23761' , '47' , '1' ) 30/06/2025 11:55:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2306' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 11:55:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2306' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '229.90' , '229.90' , NOW() , NOW() ) 30/06/2025 11:55:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97921' 30/06/2025 11:55:11 am >> DELETE FROM ps_document_detail WHERE id_document = '97921' 30/06/2025 11:55:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 30/06/2025 11:55:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 30/06/2025 11:55:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 30/06/2025 11:55:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 30/06/2025 12:03:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1879' AND id_document != '97422' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-27') 30/06/2025 12:03:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1879', document_date = '2025-05-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '46.30', price_tax_excluded = '38.31', date_upd = NOW() WHERE id_document = '97422' 30/06/2025 12:03:36 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 = '97422' 30/06/2025 12:03:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '97422' 30/06/2025 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97422' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 30/06/2025 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97422' , '21479' , 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 30/06/2025 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97422' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '20.00' ) 30/06/2025 12:03:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97422' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '23.5' , '19.262295081967' , '22' , '0' , '23.50' ) 30/06/2025 12:08:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2306' AND id_document != '97921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 12:08:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2306', document_date = '2025-06-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '229.90', price_tax_excluded = '229.90', date_upd = NOW() WHERE id_document = '97921' 30/06/2025 12:08:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97921' 30/06/2025 12:08:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '97921' 30/06/2025 12:08:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 30/06/2025 12:08:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 30/06/2025 12:08:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '60' , '60' , '0' , '0' , '60.00' ) 30/06/2025 12:08:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97921' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 30/06/2025 12:13:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2307' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 12:13:46 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' , '2307' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.50' , '66.50' , NOW() , NOW() ) 30/06/2025 12:13: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 = '97922' 30/06/2025 12:13:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97922' 30/06/2025 12:13: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 ( '97922' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '14' , '-14' , '4' , '5.00' , '5' , '0' , '5' , '66.50' ) 30/06/2025 12:14:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2308' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 12:14:36 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' , '2308' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.10' , '5.82' , NOW() , NOW() ) 30/06/2025 12:14:36 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 = '97923' 30/06/2025 12:14:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '97923' 30/06/2025 12:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97923' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '2' , '-2' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.60' ) 30/06/2025 12:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97923' , '11695' , 'BRACCIALE ROSARIO LEGNO - 469/01' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 30/06/2025 12:46:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2309' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 12:46:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2309' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 30/06/2025 12:46: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 = '97924' 30/06/2025 12:46:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '97924' 30/06/2025 12:46: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 ( '97924' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 30/06/2025 12:56:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 12:56:36 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' , '2310' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 30/06/2025 12:56:36 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 = '97925' 30/06/2025 12:56:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '97925' 30/06/2025 12:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97925' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 30/06/2025 12:56:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97925' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 30/06/2025 03:45:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 03:45:25 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' , '2311' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 30/06/2025 03:45: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 = '97926' 30/06/2025 03:45:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '97926' 30/06/2025 03:45: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 ( '97926' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2025 03:45: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 ( '97926' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2025 03:54:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1516' AND id_document != '97008' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 30/06/2025 03:54:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1516', 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 = '419.16', price_tax_excluded = '385.62', date_upd = NOW() WHERE id_document = '97008' 30/06/2025 03:54: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 = '97008' 30/06/2025 03:54:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '97008' 30/06/2025 03:54: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 ( '97008' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 30/06/2025 03:54: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 ( '97008' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 30/06/2025 03:54: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 ( '97008' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 30/06/2025 03:54: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 ( '97008' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 30/06/2025 03:54: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 ( '97008' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 30/06/2025 03:54: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 ( '97008' , '19096' , 'BIBBIA SCRUTATE - TASC.' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '5' , '26.60' ) 30/06/2025 03:54: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 ( '97008' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 30/06/2025 03:54: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 ( '97008' , '15227' , 'ALBUM DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 30/06/2025 03:54: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 ( '97008' , '15387' , 'VESTINA BATTESIMALE ' , '4' , '-4' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '12.00' ) 30/06/2025 03:54: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 ( '97008' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '27' , '-27' , '4' , '3' , '3' , '0' , '0' , '81.00' ) 30/06/2025 03:54: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 ( '97008' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.3800' , '2.38' , '0' , '0' , '71.40' ) 30/06/2025 03:54: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 ( '97008' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 30/06/2025 03:55:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1797' AND id_document != '97332' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 30/06/2025 03:55:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1797', 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 = '195.00', price_tax_excluded = '194.10', date_upd = NOW() WHERE id_document = '97332' 30/06/2025 03:55: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 = '97332' 30/06/2025 03:55:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97332' 30/06/2025 03:55:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 30/06/2025 03:55:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 30/06/2025 03:55:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.4' , '0.4' , '0' , '0' , '0.40' ) 30/06/2025 03:55:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '23' , '-23' , '4' , '4.5000' , '4.5' , '0' , '0' , '103.50' ) 30/06/2025 03:55:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '23607' , 'MESSA MEDITAZIONE - LUG/AGO 25' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 30/06/2025 03:55:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '3' , '3' , '0' , '0' , '60.00' ) 30/06/2025 03:55:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2174' AND id_document != '97764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-19') 30/06/2025 03:55:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2174', document_date = '2025-06-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '129.00', price_tax_excluded = '115.53', date_upd = NOW() WHERE id_document = '97764' 30/06/2025 03:55: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 = '97764' 30/06/2025 03:55:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97764' 30/06/2025 03:55: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 ( '97764' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 30/06/2025 03:55: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 ( '97764' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/06/2025 03:55: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 ( '97764' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 30/06/2025 03:55: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 ( '97764' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 30/06/2025 03:55: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 ( '97764' , '22199' , 'VINO LIQUOROSO ROSSO ' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 30/06/2025 03:55: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 ( '97764' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 30/06/2025 03:55: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 ( '97764' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 30/06/2025 03:55: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 ( '97764' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '7.5' , '7.5' , '0' , '0' , '7.50' ) 30/06/2025 03:56:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2202' AND id_document != '97795' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-21') 30/06/2025 03:56:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2202', document_date = '2025-06-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 = '22.70', price_tax_excluded = '22.70', date_upd = NOW() WHERE id_document = '97795' 30/06/2025 03:56: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 = '97795' 30/06/2025 03:56:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '97795' 30/06/2025 03:56: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 ( '97795' , '23751' , 'GESU VERAMENTE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 30/06/2025 03:56: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 ( '97795' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.35' , '3.35' , '0' , '0' , '6.70' ) 30/06/2025 03:56:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2236' AND id_document != '97836' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-24') 30/06/2025 03:56:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2236', document_date = '2025-06-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.00', price_tax_excluded = '39.00', date_upd = NOW() WHERE id_document = '97836' 30/06/2025 03:56:39 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 = '97836' 30/06/2025 03:56:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '97836' 30/06/2025 03:56: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 ( '97836' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '5' , '28.50' ) 30/06/2025 03:56: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 ( '97836' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '10.5' , '10.5' , '0' , '0' , '10.50' ) 30/06/2025 03:57:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2301' AND id_document != '97913' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-28') 30/06/2025 03:57:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2301', document_date = '2025-06-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '214.88', price_tax_excluded = '181.70', date_upd = NOW() WHERE id_document = '97913' 30/06/2025 03:57: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 = '97913' 30/06/2025 03:57:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '97913' 30/06/2025 03:57: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 ( '97913' , '19866' , 'CASULA CROCE UVA - CSL111' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 30/06/2025 03:57: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 ( '97913' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 30/06/2025 03:57: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 ( '97913' , '15000' , 'TECA ALTA IHS - 825' , '1' , '-1' , '1' , '32.0000' , '26.229508196721' , '22' , '0' , '32.00' ) 30/06/2025 03:57: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 ( '97913' , '22152' , 'A TE RICORRIAMO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 30/06/2025 03:57: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 ( '97913' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 30/06/2025 03:57: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 ( '97913' , '23347' , 'PREGHIERA DEL ROSARIO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 30/06/2025 03:57: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 ( '97913' , '23776' , 'ROSARIO LEGNO 10MM - R987' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 30/06/2025 03:57: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 ( '97913' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 30/06/2025 03:57: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 ( '97913' , '19304' , 'VIA CRUCIS - 8076' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 30/06/2025 03:57: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 ( '97913' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 30/06/2025 03:57: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 ( '97913' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.14' , '1.14' , '0' , '0' , '1.14' ) 30/06/2025 03:57: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 ( '97913' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 30/06/2025 03:57:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2306' AND id_document != '97921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 03:57:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2306', document_date = '2025-06-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '229.90', price_tax_excluded = '229.90', date_upd = NOW() WHERE id_document = '97921' 30/06/2025 03:57: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 = '97921' 30/06/2025 03:57:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '97921' 30/06/2025 03:57: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 ( '97921' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 30/06/2025 03:57: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 ( '97921' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 30/06/2025 03:57: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 ( '97921' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 30/06/2025 03:57: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 ( '97921' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '3' , '3' , '0' , '0' , '60.00' ) 30/06/2025 04:21:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 04:21:50 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' , '2312' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 30/06/2025 04:21:50 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 = '97927' 30/06/2025 04:21:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97927' 30/06/2025 04:21:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97927' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 30/06/2025 04:30:08 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 ( '32' , '2025010001084' , '2025-06-30' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.35' , '83.35' , NOW() , NOW() ) 30/06/2025 04:30: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 = '97928' 30/06/2025 04:30:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '97928' 30/06/2025 04:30: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 ( '97928' , '23793' , 'FAI AMICIZIA CON IL TUO ANGELO - SUOR E. MAILLARD' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 30/06/2025 04:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23793' AND id_supplier = '107' 30/06/2025 04:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23793' , '107' , '1' ) 30/06/2025 04:30: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 ( '97928' , '23794' , 'TEOLOGIA LITURGICA DEI SACRAMENTI - A. MIRALLES' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 30/06/2025 04:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23794' AND id_supplier = '107' 30/06/2025 04:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23794' , '107' , '1' ) 30/06/2025 04:30: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 ( '97928' , '23795' , 'DIALOGO DELLA DIVINA PROVVIDENZA - CATERINA DA SIENA' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '35' , '11.05' ) 30/06/2025 04:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23795' AND id_supplier = '107' 30/06/2025 04:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23795' , '107' , '1' ) 30/06/2025 04:30: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 ( '97928' , '23193' , 'ACCOMPAGNARE NEL CAMMINO MATRIMONIALE ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 30/06/2025 04:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23193' AND id_supplier = '107' 30/06/2025 04:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23193' , '107' , '1' ) 30/06/2025 04:30: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 ( '97928' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 30/06/2025 04:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22042' AND id_supplier = '107' 30/06/2025 04:30:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22042' , '107' , '1' ) 30/06/2025 04:30: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 ( '97928' , '23747' , 'PADRE NELLE TUE MANI... - E. DELLA CORTE' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '35' , '20.80' ) 30/06/2025 04:30:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23747' AND id_supplier = '107' 30/06/2025 04:30:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23747' , '107' , '1' ) 30/06/2025 05:37:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 05:37:07 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' , '2313' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 30/06/2025 05:37:07 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 = '97929' 30/06/2025 05:37:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '97929' 30/06/2025 05:37:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97929' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 30/06/2025 06:55:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2314' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 30/06/2025 06:55: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' , '2314' , '2025-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 30/06/2025 06:55: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 = '97930' 30/06/2025 06:55:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '97930' 30/06/2025 06:55: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 ( '97930' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 30/06/2025 06:55: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 ( '97930' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' )