12/06/2024 09:14:01 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 12/06/2024 09:14:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22693' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:14:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22693' , '1' , '1' , '2' , NOW() , NOW() ) 12/06/2024 09:14:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22693' , '0' , '1' , '0' , '0' ) 12/06/2024 09:14:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049582' AND id_product != '22693' AND ean13 != '' 12/06/2024 09:14:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884049582', date_upd = NOW() WHERE id_product = '22693' 12/06/2024 09:14:39 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA - SETT OTT 2024', description = '' WHERE id_product = '22693' 12/06/2024 09:14:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '22693' 12/06/2024 09:14:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22693' 12/06/2024 09:14:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22693' 12/06/2024 09:14: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 = '22693' 12/06/2024 09:14:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22694' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:14: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 '22694' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22693' 12/06/2024 09:14:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22694' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22693' 12/06/2024 09:15:48 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' , '8966/00/2024' , '2024-06-10' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '144.00' , '144.00' , NOW() , NOW() ) 12/06/2024 09:15:48 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 = '92252' 12/06/2024 09:15:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92252' 12/06/2024 09:15: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 ( '92252' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '20' , '20' , '4' , '5.00' , '5' , '0' , '40' , '60.0000' ) 12/06/2024 09:15:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22414' AND id_supplier = '38' 12/06/2024 09:15:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22414' , '38' , '1' ) 12/06/2024 09:15: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 ( '92252' , '22693' , 'SULLA TUA PAROLA - SETT OTT 2024' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 12/06/2024 09:15:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22693' AND id_supplier = '38' 12/06/2024 09:15:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22693' , '38' , '1' ) 12/06/2024 09:15: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 ( '92252' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 12/06/2024 09:15:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '38' 12/06/2024 09:15:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '38' , '1' ) 12/06/2024 09:15: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 ( '92252' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '2' , '4' , '10.00' , '10' , '0' , '40' , '12.0000' ) 12/06/2024 09:15:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 12/06/2024 09:15:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 12/06/2024 09:15: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 ( '92252' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '20' , '20' , '4' , '2.00' , '2' , '0' , '40' , '24.0000' ) 12/06/2024 09:15:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '38' 12/06/2024 09:15:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '38' , '1' ) 12/06/2024 09:20:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871274' AND id_product != '22694' AND ean13 != '' 12/06/2024 09:20:05 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788892871274', date_upd = NOW() WHERE id_product = '22694' 12/06/2024 09:20:05 am >> UPDATE ps_product_lang SET name = 'PARROCCHIE: MINISTERIALITA\' E PARTECIPAZIONE - F. ZACCARIA', description = '' WHERE id_product = '22694' 12/06/2024 09:20:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '22694' 12/06/2024 09:20:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22694' 12/06/2024 09:20:05 am >> DELETE FROM ps_specific_price WHERE id_product = '22694' 12/06/2024 09:20:06 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 = '22694' 12/06/2024 09:20:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22695' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:20:06 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 '22695' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22694' 12/06/2024 09:20:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22695' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22694' 12/06/2024 09:20:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871526' AND id_product != '22695' AND ean13 != '' 12/06/2024 09:20:45 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788892871526', date_upd = NOW() WHERE id_product = '22695' 12/06/2024 09:20:45 am >> UPDATE ps_product_lang SET name = 'ON THE ROAD', description = '' WHERE id_product = '22695' 12/06/2024 09:20:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.9' WHERE id_product = '22695' 12/06/2024 09:20:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22695' 12/06/2024 09:20:45 am >> DELETE FROM ps_specific_price WHERE id_product = '22695' 12/06/2024 09:20:46 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 = '22695' 12/06/2024 09:20:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22696' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:20:46 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 '22696' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22695' 12/06/2024 09:20:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22696' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22695' 12/06/2024 09:21:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249745' AND id_product != '22696' AND ean13 != '' 12/06/2024 09:21:45 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861249745', date_upd = NOW() WHERE id_product = '22696' 12/06/2024 09:21:45 am >> UPDATE ps_product_lang SET name = 'VANGELO A COLORI -', description = '' WHERE id_product = '22696' 12/06/2024 09:21:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.9' WHERE id_product = '22696' 12/06/2024 09:21:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22696' 12/06/2024 09:21:45 am >> DELETE FROM ps_specific_price WHERE id_product = '22696' 12/06/2024 09:21:46 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 = '22696' 12/06/2024 09:21:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22697' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:21:46 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 '22697' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22696' 12/06/2024 09:21:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22697' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22696' 12/06/2024 09:22:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244757' AND id_product != '22697' AND ean13 != '' 12/06/2024 09:22:59 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788892244757', date_upd = NOW() WHERE id_product = '22697' 12/06/2024 09:22:59 am >> UPDATE ps_product_lang SET name = 'CHI E\' DUNQUE QUESTO GESU\' - J.T. MENDONCA', description = '' WHERE id_product = '22697' 12/06/2024 09:22:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22697' 12/06/2024 09:22:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22697' 12/06/2024 09:22:59 am >> DELETE FROM ps_specific_price WHERE id_product = '22697' 12/06/2024 09:22: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 = '22697' 12/06/2024 09:22:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22698' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:22: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 '22698' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22697' 12/06/2024 09:22:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22698' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22697' 12/06/2024 09:23:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244658' AND id_product != '22698' AND ean13 != '' 12/06/2024 09:23:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892244658', date_upd = NOW() WHERE id_product = '22698' 12/06/2024 09:23:39 am >> UPDATE ps_product_lang SET name = 'CALENDARIO LITURGICO 2025', description = '' WHERE id_product = '22698' 12/06/2024 09:23:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.8' WHERE id_product = '22698' 12/06/2024 09:23:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22698' 12/06/2024 09:23:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22698' 12/06/2024 09:23: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 = '22698' 12/06/2024 09:23:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22699' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:23: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 '22699' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22698' 12/06/2024 09:23:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22699' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22698' 12/06/2024 09:25:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839928078' AND id_product != '22699' AND ean13 != '' 12/06/2024 09:25:12 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788839928078', date_upd = NOW() WHERE id_product = '22699' 12/06/2024 09:25:12 am >> UPDATE ps_product_lang SET name = 'PRENDERE LA PAROLA - BISCONTIN / LAURITA', description = '' WHERE id_product = '22699' 12/06/2024 09:25:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22699' 12/06/2024 09:25:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22699' 12/06/2024 09:25:13 am >> DELETE FROM ps_specific_price WHERE id_product = '22699' 12/06/2024 09:25:13 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 = '22699' 12/06/2024 09:25:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22700' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:25:13 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 '22700' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22699' 12/06/2024 09:25:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22700' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22699' 12/06/2024 09:26:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557276' AND id_product != '22700' AND ean13 != '' 12/06/2024 09:26:14 am >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788831557276', date_upd = NOW() WHERE id_product = '22700' 12/06/2024 09:26:14 am >> UPDATE ps_product_lang SET name = 'MISTICA E COSCIENZA - A. LUMINI', description = '' WHERE id_product = '22700' 12/06/2024 09:26:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '22700' 12/06/2024 09:26:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22700' 12/06/2024 09:26:14 am >> DELETE FROM ps_specific_price WHERE id_product = '22700' 12/06/2024 09:26:15 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 = '22700' 12/06/2024 09:26:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22701' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:26:15 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 '22701' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22700' 12/06/2024 09:26:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22701' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22700' 12/06/2024 09:27:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068986' AND id_product != '22701' AND ean13 != '' 12/06/2024 09:27:10 am >> UPDATE ps_product SET id_supplier = '', reference = '8/3', ean13 = '9788801068986', date_upd = NOW() WHERE id_product = '22701' 12/06/2024 09:27:10 am >> UPDATE ps_product_lang SET name = 'ARTE DI PREDICARE - A. GIARDINA', description = '' WHERE id_product = '22701' 12/06/2024 09:27:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.9' WHERE id_product = '22701' 12/06/2024 09:27:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22701' 12/06/2024 09:27:10 am >> DELETE FROM ps_specific_price WHERE id_product = '22701' 12/06/2024 09:27:11 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 = '22701' 12/06/2024 09:27:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22702' , '1' , '' , 'nuovo-prodotto' ) 12/06/2024 09:27:11 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 '22702' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22701' 12/06/2024 09:27:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22702' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22701' 12/06/2024 09:27:33 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' , '667084' , '2024-06-06' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.80' , '90.80' , NOW() , NOW() ) 12/06/2024 09:27:33 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 = '92253' 12/06/2024 09:27:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92253' 12/06/2024 09:27:33 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 ( '92253' , '22694' , 'PARROCCHIE: MINISTERIALITA E PARTECIPAZIONE - F. ZACCARIA' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22694' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22694' , '7' , '1' ) 12/06/2024 09:27:33 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 ( '92253' , '22695' , 'ON THE ROAD' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '30' , '9.0300' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22695' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22695' , '7' , '1' ) 12/06/2024 09:27:33 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 ( '92253' , '22696' , 'VANGELO A COLORI -' , '1' , '1' , '4' , '8.90' , '8.9' , '0' , '30' , '6.2300' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22696' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22696' , '7' , '1' ) 12/06/2024 09:27:33 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 ( '92253' , '22697' , 'CHI E DUNQUE QUESTO GESU - J.T. MENDONCA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22697' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22697' , '7' , '1' ) 12/06/2024 09:27:33 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 ( '92253' , '22698' , 'CALENDARIO LITURGICO 2025' , '36' , '36' , '4' , '0.80' , '0.8' , '0' , '33' , '19.2960' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22698' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22698' , '7' , '1' ) 12/06/2024 09:27:33 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 ( '92253' , '22698' , 'CALENDARIO LITURGICO 2025' , '3' , '3' , '4' , '0.80' , '0.8' , '0' , '100' , '0.0000' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22698' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22698' , '7' , '1' ) 12/06/2024 09:27:33 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 ( '92253' , '22699' , 'PRENDERE LA PAROLA - BISCONTIN / LAURITA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22699' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22699' , '7' , '1' ) 12/06/2024 09:27:33 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 ( '92253' , '22700' , 'MISTICA E COSCIENZA - A. LUMINI' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 12/06/2024 09:27:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22700' AND id_supplier = '7' 12/06/2024 09:27:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22700' , '7' , '1' ) 12/06/2024 09:27:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92253' , '22701' , 'ARTE DI PREDICARE - A. GIARDINA' , '1' , '1' , '4' , '8.90' , '8.9' , '0' , '35' , '5.7850' ) 12/06/2024 09:27:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '22701' AND id_supplier = '7' 12/06/2024 09:27:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22701' , '7' , '1' ) 12/06/2024 11:08:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1952' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 11:08:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1952' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 12/06/2024 11:08:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92254' 12/06/2024 11:08:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92254' 12/06/2024 11:08:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92254' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 12/06/2024 11:30:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 11:30:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1953' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 12/06/2024 11:30:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92255' 12/06/2024 11:30:45 am >> DELETE FROM ps_document_detail WHERE id_document = '92255' 12/06/2024 11:30:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92255' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '2' , '1.6393442622951' , '22' , '0' , '6.00' ) 12/06/2024 11:46:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 11:46:57 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' , '1954' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 12/06/2024 11:46:57 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 = '92256' 12/06/2024 11:46:57 am >> DELETE FROM ps_document_detail WHERE id_document = '92256' 12/06/2024 11: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 ( '92256' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 12/06/2024 11:54:50 am >> SELECT document_num FROM ps_document WHERE document_num = '66/A' AND id_document != '91993' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-24') 12/06/2024 11:54:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '66/A', document_date = '2024-05-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', 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 = '126.20', price_tax_excluded = '104.83', date_upd = NOW() WHERE id_document = '91993' 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91993' 12/06/2024 11:54:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91993' 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91993' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '41.40' ) 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91993' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91993' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91993' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91993' , '15481' , 'CROCE IHS - 2389/CZ' , '22' , '-22' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '55.00' ) 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91993' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 12/06/2024 11:54:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91993' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '25' , '-25' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '12.50' ) 12/06/2024 11:58:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 11:58:51 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' , '1955' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 12/06/2024 11:58:51 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 = '92257' 12/06/2024 11:58:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92257' 12/06/2024 11:58:51 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 ( '92257' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 12/06/2024 12:00:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '91976' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-23') 12/06/2024 12:00:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2024-05-23', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', 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 = '162.10', price_tax_excluded = '136.30', date_upd = NOW() WHERE id_document = '91976' 12/06/2024 12:00: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 = '91976' 12/06/2024 12:00:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '91976' 12/06/2024 12:00: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 ( '91976' , '15097' , 'CORONA MATRIMONIO - ORO' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 12/06/2024 12:00: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 ( '91976' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 12/06/2024 12:00: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 ( '91976' , '7943' , 'PERGAMENE - OCCASIONI MOD. B' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 12/06/2024 12:00: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 ( '91976' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '5' , '-5' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '3.00' ) 12/06/2024 12:00: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 ( '91976' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '2' , '-2' , '1' , '12.2000' , '10' , '22' , '0' , '24.40' ) 12/06/2024 12:01: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 ( '91976' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/06/2024 12:01: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 ( '91976' , '18129' , 'TAU COLORATO - T56' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 12/06/2024 12:01: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 ( '91976' , '18130' , 'TAU GRANDE CM 4 - T9' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/06/2024 12:01: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 ( '91976' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/06/2024 12:01: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 ( '91976' , '10456' , 'TAU ULIVO - PICCOLO - 738' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/06/2024 12:01: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 ( '91976' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 12/06/2024 12:01: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 ( '91976' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 12/06/2024 12:01: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 ( '91976' , '15481' , 'CROCE IHS - 2389/CZ' , '22' , '-22' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '55.00' ) 12/06/2024 12:01: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 ( '91976' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 12/06/2024 12:01: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 ( '91976' , '' , 'pergamene 1a comunione' , '25' , '-25' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '12.50' ) 12/06/2024 12:01:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '66/A' AND id_document != '91993' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-24') 12/06/2024 12:01:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '66/A', document_date = '2024-05-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', 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 = '51.20', price_tax_excluded = '43.36', date_upd = NOW() WHERE id_document = '91993' 12/06/2024 12:01: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 = '91993' 12/06/2024 12:01:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '91993' 12/06/2024 12:01: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 ( '91993' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '41.40' ) 12/06/2024 12:01: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 ( '91993' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 12/06/2024 12:01: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 ( '91993' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/06/2024 12:01: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 ( '91993' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 12/06/2024 12:13:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:13: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' , '1956' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '210.80' , NOW() , NOW() ) 12/06/2024 12:13: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 = '92258' 12/06/2024 12:13:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92258' 12/06/2024 12:13: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 ( '92258' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '13' , '-13' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '16.90' ) 12/06/2024 12:13: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 ( '92258' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 12/06/2024 12:13: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 ( '92258' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 12/06/2024 12:13: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 ( '92258' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '-1' , '4' , '130.00' , '130' , '0' , '5' , '123.50' ) 12/06/2024 12:13: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 ( '92258' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '19.8' , '16.229508196721' , '22' , '0' , '39.60' ) 12/06/2024 12:23:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:23: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' , '1957' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 12/06/2024 12:23: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 = '92259' 12/06/2024 12:23:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92259' 12/06/2024 12:23: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 ( '92259' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 12/06/2024 12:25:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:25:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1958' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 12/06/2024 12:25: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 = '92260' 12/06/2024 12:25:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92260' 12/06/2024 12:25: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 ( '92260' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 12/06/2024 12:27:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:27: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' , '1959' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.90' , '12.21' , NOW() , NOW() ) 12/06/2024 12:27: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 = '92261' 12/06/2024 12:27:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '92261' 12/06/2024 12:27: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 ( '92261' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 12/06/2024 12:27: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 ( '92261' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 12/06/2024 12:38:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:38:39 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' , '1960' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.00' , '74.10' , NOW() , NOW() ) 12/06/2024 12:38: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 = '92262' 12/06/2024 12:38:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '92262' 12/06/2024 12:38: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 ( '92262' , '1823' , 'CATECHISMO DELLA CHIESA CATTOLICA - COMPENDIO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '0' , '20.00' ) 12/06/2024 12:38: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 ( '92262' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/06/2024 12:38: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 ( '92262' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 12/06/2024 12:39:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:39: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 ( '11' , '1961' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 12/06/2024 12:39: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 = '92263' 12/06/2024 12:39:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '92263' 12/06/2024 12:39: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 ( '92263' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '40' , '32.786885245902' , '22' , '0' , '120.00' ) 12/06/2024 12:43:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1961' AND id_document != '92263' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:43:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1961', document_date = '2024-06-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '92263' 12/06/2024 12:43:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92263' 12/06/2024 12:43:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '92263' 12/06/2024 12:43:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92263' , '18246' , 'CLERGY JEANS NIDO DAPE MM - S' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 12:43:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92263' , '18256' , 'CLERGY BLU NIDO DAPE MM - 3XL' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 12:43:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92263' , '18245' , 'CLERGY GRIGIO NIDO DAPE MM - 3XL' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 12:45:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1961' AND id_document != '92263' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 12:45:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1961', document_date = '2024-06-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '92263' 12/06/2024 12:45:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92263' 12/06/2024 12:45:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92263' 12/06/2024 12:45:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92263' , '16120' , 'CLERGY GRIGIO JEANS - XL' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 12:45:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92263' , '18256' , 'CLERGY BLU NIDO DAPE MM - 3XL' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 12:45:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92263' , '18245' , 'CLERGY GRIGIO NIDO DAPE MM - 3XL' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 12:50:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1512' AND id_document != '91715' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 12/06/2024 12:50:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1512', document_date = '2024-05-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91715' 12/06/2024 12:50:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91715' 12/06/2024 12:50:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '91715' 12/06/2024 12:50:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91715' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/06/2024 12:50:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91715' , '18253' , 'CLERGY BLU NIDO DAPE MM - L' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 12/06/2024 12:51:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1707' AND id_document != '91944' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 12/06/2024 12:51:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1707', document_date = '2024-05-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '298.00', price_tax_excluded = '262.70', date_upd = NOW() WHERE id_document = '91944' 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91944' 12/06/2024 12:51:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91944' 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '16.00' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '0' , 'suppliche' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '0' , '50.00' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '18276' , 'CINGOLO CON NODI - 3280' , '7' , '-7' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '17.50' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22096' , 'CREARE CASA 3 - SUSSIDIO GIOVANI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22094' , 'CREARE CASA 1 - ANIMATORI RAGAZZI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '12' , '-12' , '4' , '2.4000' , '2.4' , '0' , '0' , '28.80' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '15357' , 'AMPOLLE ABBRACCIO NIKEL - 1512' , '1' , '-1' , '1' , '95.7400' , '78.475409836066' , '22' , '0' , '95.74' ) 12/06/2024 12:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '18258' , 'CLERGY GRIGIO NIDO DAPE MM - S' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 12:52:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1577' AND id_document != '91789' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-13') 12/06/2024 12:52:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1577', document_date = '2024-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '85.50', price_tax_excluded = '70.08', date_upd = NOW() WHERE id_document = '91789' 12/06/2024 12:52:24 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 = '91789' 12/06/2024 12:52:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91789' 12/06/2024 12:52: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 ( '91789' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '7' , '-7' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '8.40' ) 12/06/2024 12:52: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 ( '91789' , '1290' , 'BRACCIALE 7 DONI - 820/07' , '7' , '-7' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '26.60' ) 12/06/2024 12:52: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 ( '91789' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 12/06/2024 12:52: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 ( '91789' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '10' , '-10' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '7.00' ) 12/06/2024 12:52: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 ( '91789' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '38.5' , '31.55737704918' , '22' , '0' , '38.50' ) 12/06/2024 01:03:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 01:03: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 ( '11' , '1962' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.80' , '8.85' , NOW() , NOW() ) 12/06/2024 01:03: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 = '92264' 12/06/2024 01:03:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '92264' 12/06/2024 01:03: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 ( '92264' , '20516' , 'CROCE COMUNIONE - 42/08' , '9' , '-9' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '10.80' ) 12/06/2024 04:24:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 04:24:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1963' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '1.20' , NOW() , NOW() ) 12/06/2024 04:24: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 = '92265' 12/06/2024 04:24:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92265' 12/06/2024 04:24: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 ( '92265' , '8318' , 'PREGHIERA SEMPLICE' , '6' , '-6' , '4' , '0.20' , '0.2' , '0' , '0' , '1.20' ) 12/06/2024 05:19:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1956' AND id_document != '92258' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 05:19:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1956', document_date = '2024-06-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '230.00', price_tax_excluded = '210.80', date_upd = NOW() WHERE id_document = '92258' 12/06/2024 05:19: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 = '92258' 12/06/2024 05:19:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92258' 12/06/2024 05:19: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 ( '92258' , '20516' , 'CROCE COMUNIONE - 42/08' , '13' , '-13' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '16.90' ) 12/06/2024 05:19: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 ( '92258' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 12/06/2024 05:19: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 ( '92258' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 12/06/2024 05:19: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 ( '92258' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '-1' , '4' , '130.0000' , '130' , '0' , '5' , '123.50' ) 12/06/2024 05:19: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 ( '92258' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '19.8000' , '16.229508196721' , '22' , '0' , '39.60' ) 12/06/2024 05:22:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1953' AND id_document != '92255' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 05:22:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1953', document_date = '2024-06-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.00', price_tax_excluded = '4.92', date_upd = NOW() WHERE id_document = '92255' 12/06/2024 05:22: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 = '92255' 12/06/2024 05:22:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92255' 12/06/2024 05:22: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 ( '92255' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '3' , '-3' , '1' , '2' , '1.6393442622951' , '22' , '0' , '6.00' ) 12/06/2024 06:28:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 06:28:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1964' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 12/06/2024 06:28:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92266' 12/06/2024 06:28:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92266' 12/06/2024 06:28:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92266' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 12/06/2024 07:24:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-12') 12/06/2024 07:24:03 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' , '1965' , '2024-06-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 12/06/2024 07:24:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92267' 12/06/2024 07:24:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '92267' 12/06/2024 07:24:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92267' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' )