31/03/2023 09:03:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1061' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 09:03:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1061' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 31/03/2023 09:03: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 = '82567' 31/03/2023 09:03:35 am >> DELETE FROM ps_document_detail WHERE id_document = '82567' 31/03/2023 09:03: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 ( '82567' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 31/03/2023 09:24:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03007-M' AND id_product != '7911' AND ean13 != '' 31/03/2023 09:24:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03007-M', date_upd = NOW() WHERE id_product = '7911' 31/03/2023 09:24:37 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A COMUNIONE MOD. B', description = '' WHERE id_product = '7911' 31/03/2023 09:24:37 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.4098' WHERE id_product = '7911' 31/03/2023 09:24:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7911' 31/03/2023 09:24:37 am >> DELETE FROM ps_specific_price WHERE id_product = '7911' 31/03/2023 09:24:37 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '7911' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 31/03/2023 09:24:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03006-XP' AND id_product != '7910' AND ean13 != '' 31/03/2023 09:24:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03006-XP', date_upd = NOW() WHERE id_product = '7910' 31/03/2023 09:24:48 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A COMUNIONE MOD. A', description = '' WHERE id_product = '7910' 31/03/2023 09:24:48 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.1230' WHERE id_product = '7910' 31/03/2023 09:24:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.1230', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7910' 31/03/2023 09:24:48 am >> DELETE FROM ps_specific_price WHERE id_product = '7910' 31/03/2023 09:25:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03008-P' AND id_product != '7914' AND ean13 != '' 31/03/2023 09:25:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03008-P', date_upd = NOW() WHERE id_product = '7914' 31/03/2023 09:25:05 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A COMUNIONE MOD. C', description = '' WHERE id_product = '7914' 31/03/2023 09:25:05 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.2459' WHERE id_product = '7914' 31/03/2023 09:25:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.2459', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7914' 31/03/2023 09:25:05 am >> DELETE FROM ps_specific_price WHERE id_product = '7914' 31/03/2023 09:25:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03009-M' AND id_product != '7915' AND ean13 != '' 31/03/2023 09:25:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03009-M', date_upd = NOW() WHERE id_product = '7915' 31/03/2023 09:25:14 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A COMUNIONE MOD. D', description = '' WHERE id_product = '7915' 31/03/2023 09:25:14 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.4100' WHERE id_product = '7915' 31/03/2023 09:25:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.4100', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7915' 31/03/2023 09:25:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7915' 31/03/2023 09:25:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030014-M' AND id_product != '7916' AND ean13 != '' 31/03/2023 09:25:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030014-M', date_upd = NOW() WHERE id_product = '7916' 31/03/2023 09:25:28 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A RICONCILIAZIONE MOD. A', description = '' WHERE id_product = '7916' 31/03/2023 09:25:29 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.4098' WHERE id_product = '7916' 31/03/2023 09:25:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7916' 31/03/2023 09:25:29 am >> DELETE FROM ps_specific_price WHERE id_product = '7916' 31/03/2023 09:25:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030017-M' AND id_product != '7920' AND ean13 != '' 31/03/2023 09:25:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030017-M', date_upd = NOW() WHERE id_product = '7920' 31/03/2023 09:25:54 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. A', description = '' WHERE id_product = '7920' 31/03/2023 09:25:54 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.4098' WHERE id_product = '7920' 31/03/2023 09:25:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7920' 31/03/2023 09:25:54 am >> DELETE FROM ps_specific_price WHERE id_product = '7920' 31/03/2023 09:26:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030018-G' AND id_product != '7921' AND ean13 != '' 31/03/2023 09:26:04 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030018-G', date_upd = NOW() WHERE id_product = '7921' 31/03/2023 09:26:05 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B', description = '' WHERE id_product = '7921' 31/03/2023 09:26:05 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.5738' WHERE id_product = '7921' 31/03/2023 09:26:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.5738', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7921' 31/03/2023 09:26:05 am >> DELETE FROM ps_specific_price WHERE id_product = '7921' 31/03/2023 09:26:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030018-M' AND id_product != '7922' AND ean13 != '' 31/03/2023 09:26:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030018-M', date_upd = NOW() WHERE id_product = '7922' 31/03/2023 09:26:14 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B', description = '' WHERE id_product = '7922' 31/03/2023 09:26:14 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.4098' WHERE id_product = '7922' 31/03/2023 09:26:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7922' 31/03/2023 09:26:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7922' 31/03/2023 09:26:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030018-P' AND id_product != '7923' AND ean13 != '' 31/03/2023 09:26:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030018-P', date_upd = NOW() WHERE id_product = '7923' 31/03/2023 09:26:22 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B', description = '' WHERE id_product = '7923' 31/03/2023 09:26:22 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.2459' WHERE id_product = '7923' 31/03/2023 09:26:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.2459', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7923' 31/03/2023 09:26:23 am >> DELETE FROM ps_specific_price WHERE id_product = '7923' 31/03/2023 09:26:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03002-M' AND id_product != '7924' AND ean13 != '' 31/03/2023 09:26:31 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03002-M', date_upd = NOW() WHERE id_product = '7924' 31/03/2023 09:26:31 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - BATTESIMO MOD. A', description = '' WHERE id_product = '7924' 31/03/2023 09:26:31 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.4098' WHERE id_product = '7924' 31/03/2023 09:26:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7924' 31/03/2023 09:26:31 am >> DELETE FROM ps_specific_price WHERE id_product = '7924' 31/03/2023 09:26:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03002-XP' AND id_product != '7925' AND ean13 != '' 31/03/2023 09:26:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03002-XP', date_upd = NOW() WHERE id_product = '7925' 31/03/2023 09:26:39 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - BATTESIMO MOD. A', description = '' WHERE id_product = '7925' 31/03/2023 09:26:39 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.1230' WHERE id_product = '7925' 31/03/2023 09:26:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.1230', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7925' 31/03/2023 09:26:39 am >> DELETE FROM ps_specific_price WHERE id_product = '7925' 31/03/2023 09:26:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03003-M' AND id_product != '7926' AND ean13 != '' 31/03/2023 09:26:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03003-M', date_upd = NOW() WHERE id_product = '7926' 31/03/2023 09:26:47 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - BATTESIMO MOD. B', description = '' WHERE id_product = '7926' 31/03/2023 09:26:47 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.4098' WHERE id_product = '7926' 31/03/2023 09:26:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7926' 31/03/2023 09:26:47 am >> DELETE FROM ps_specific_price WHERE id_product = '7926' 31/03/2023 09:26:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03004-G' AND id_product != '7927' AND ean13 != '' 31/03/2023 09:26:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03004-G', date_upd = NOW() WHERE id_product = '7927' 31/03/2023 09:26:54 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - BATTESIMO MOD. C', description = '' WHERE id_product = '7927' 31/03/2023 09:26:54 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.5738' WHERE id_product = '7927' 31/03/2023 09:26:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.5738', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7927' 31/03/2023 09:26:54 am >> DELETE FROM ps_specific_price WHERE id_product = '7927' 31/03/2023 09:27:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03004-M' AND id_product != '7928' AND ean13 != '' 31/03/2023 09:27:01 am >> UPDATE ps_product SET id_supplier = '107', reference = '', ean13 = '03004-M', date_upd = NOW() WHERE id_product = '7928' 31/03/2023 09:27:01 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - BATTESIMO MOD. C', description = '' WHERE id_product = '7928' 31/03/2023 09:27:01 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.4098' WHERE id_product = '7928' 31/03/2023 09:27:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7928' 31/03/2023 09:27:01 am >> DELETE FROM ps_specific_price WHERE id_product = '7928' 31/03/2023 09:27:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03004-P' AND id_product != '7929' AND ean13 != '' 31/03/2023 09:27:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03004-P', date_upd = NOW() WHERE id_product = '7929' 31/03/2023 09:27:08 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - BATTESIMO MOD. C', description = '' WHERE id_product = '7929' 31/03/2023 09:27:08 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.2459' WHERE id_product = '7929' 31/03/2023 09:27:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.2459', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7929' 31/03/2023 09:27:08 am >> DELETE FROM ps_specific_price WHERE id_product = '7929' 31/03/2023 09:27:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03005-M' AND id_product != '7930' AND ean13 != '' 31/03/2023 09:27:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03005-M', date_upd = NOW() WHERE id_product = '7930' 31/03/2023 09:27:14 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - BATTESIMO MOD. D', description = '' WHERE id_product = '7930' 31/03/2023 09:27:14 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.4098' WHERE id_product = '7930' 31/03/2023 09:27:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7930' 31/03/2023 09:27:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7930' 31/03/2023 09:27:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030010-M' AND id_product != '7931' AND ean13 != '' 31/03/2023 09:27:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030010-M', date_upd = NOW() WHERE id_product = '7931' 31/03/2023 09:27:22 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - CRESIMA MOD. A', description = '' WHERE id_product = '7931' 31/03/2023 09:27:22 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.4098' WHERE id_product = '7931' 31/03/2023 09:27:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7931' 31/03/2023 09:27:22 am >> DELETE FROM ps_specific_price WHERE id_product = '7931' 31/03/2023 09:27:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030012-G' AND id_product != '7933' AND ean13 != '' 31/03/2023 09:27:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030012-G', date_upd = NOW() WHERE id_product = '7933' 31/03/2023 09:27:34 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - CRESIMA MOD. B', description = '' WHERE id_product = '7933' 31/03/2023 09:27:34 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.5700' WHERE id_product = '7933' 31/03/2023 09:27:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.5700', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7933' 31/03/2023 09:27:34 am >> DELETE FROM ps_specific_price WHERE id_product = '7933' 31/03/2023 09:27:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030012-P' AND id_product != '7935' AND ean13 != '' 31/03/2023 09:27:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030012-P', date_upd = NOW() WHERE id_product = '7935' 31/03/2023 09:27:45 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - CRESIMA MOD. B', description = '' WHERE id_product = '7935' 31/03/2023 09:27:45 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '7935' 31/03/2023 09:27:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7935' 31/03/2023 09:27:45 am >> DELETE FROM ps_specific_price WHERE id_product = '7935' 31/03/2023 09:27:59 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7932' 31/03/2023 09:27:59 am >> UPDATE ps_stock_available SET quantity = quantity + '-260' WHERE id_product = '7932' 31/03/2023 09:28:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030022-M' AND id_product != '7940' AND ean13 != '' 31/03/2023 09:28:27 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030022-M', date_upd = NOW() WHERE id_product = '7940' 31/03/2023 09:28:27 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - OCCASIONI MOD. A', description = '' WHERE id_product = '7940' 31/03/2023 09:28:27 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.4098' WHERE id_product = '7940' 31/03/2023 09:28:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7940' 31/03/2023 09:28:27 am >> DELETE FROM ps_specific_price WHERE id_product = '7940' 31/03/2023 09:28:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030022-XP' AND id_product != '7941' AND ean13 != '' 31/03/2023 09:28:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030022-XP', date_upd = NOW() WHERE id_product = '7941' 31/03/2023 09:28:35 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - OCCASIONI MOD. A', description = '' WHERE id_product = '7941' 31/03/2023 09:28:35 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.1230' WHERE id_product = '7941' 31/03/2023 09:28:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.1230', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7941' 31/03/2023 09:28:35 am >> DELETE FROM ps_specific_price WHERE id_product = '7941' 31/03/2023 09:28:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030023-G' AND id_product != '7942' AND ean13 != '' 31/03/2023 09:28:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030023-G', date_upd = NOW() WHERE id_product = '7942' 31/03/2023 09:28:41 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - OCCASIONI MOD. B', description = '' WHERE id_product = '7942' 31/03/2023 09:28:41 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.5738' WHERE id_product = '7942' 31/03/2023 09:28:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.5738', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7942' 31/03/2023 09:28:41 am >> DELETE FROM ps_specific_price WHERE id_product = '7942' 31/03/2023 09:28:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030023-M' AND id_product != '7943' AND ean13 != '' 31/03/2023 09:28:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030023-M', date_upd = NOW() WHERE id_product = '7943' 31/03/2023 09:28:49 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - OCCASIONI MOD. B', description = '' WHERE id_product = '7943' 31/03/2023 09:28:49 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.4098' WHERE id_product = '7943' 31/03/2023 09:28:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7943' 31/03/2023 09:28:49 am >> DELETE FROM ps_specific_price WHERE id_product = '7943' 31/03/2023 09:30:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030015-P' AND id_product != '7918' AND ean13 != '' 31/03/2023 09:30:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030015-P', date_upd = NOW() WHERE id_product = '7918' 31/03/2023 09:30:41 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A RICONCILIAZIONE MOD. B', description = '' WHERE id_product = '7918' 31/03/2023 09:30:41 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.2459' WHERE id_product = '7918' 31/03/2023 09:30:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.2459', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7918' 31/03/2023 09:30:41 am >> DELETE FROM ps_specific_price WHERE id_product = '7918' 31/03/2023 09:30:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '03008-G' AND id_product != '7912' AND ean13 != '' 31/03/2023 09:30:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '03008-G', date_upd = NOW() WHERE id_product = '7912' 31/03/2023 09:30:48 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A COMUNIONE MOD. C', description = '' WHERE id_product = '7912' 31/03/2023 09:30:48 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.5738' WHERE id_product = '7912' 31/03/2023 09:30:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.5738', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7912' 31/03/2023 09:30:48 am >> DELETE FROM ps_specific_price WHERE id_product = '7912' 31/03/2023 09:31:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030021' AND id_product != '7939' AND ean13 != '' 31/03/2023 09:31:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030021', date_upd = NOW() WHERE id_product = '7939' 31/03/2023 09:31:05 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - MATRIMONIO-C', description = '' WHERE id_product = '7939' 31/03/2023 09:31:05 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.5738' WHERE id_product = '7939' 31/03/2023 09:31:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.5738', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7939' 31/03/2023 09:31:05 am >> DELETE FROM ps_specific_price WHERE id_product = '7939' 31/03/2023 09:31:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030020' AND id_product != '7938' AND ean13 != '' 31/03/2023 09:31:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030020', date_upd = NOW() WHERE id_product = '7938' 31/03/2023 09:31:12 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - MATRIMONIO-B', description = '' WHERE id_product = '7938' 31/03/2023 09:31:12 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.6557' WHERE id_product = '7938' 31/03/2023 09:31:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.6557', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7938' 31/03/2023 09:31:13 am >> DELETE FROM ps_specific_price WHERE id_product = '7938' 31/03/2023 09:31:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030019' AND id_product != '7937' AND ean13 != '' 31/03/2023 09:31:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030019', date_upd = NOW() WHERE id_product = '7937' 31/03/2023 09:31:21 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - MATRIMONIO-A', description = '' WHERE id_product = '7937' 31/03/2023 09:31:21 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.6557' WHERE id_product = '7937' 31/03/2023 09:31:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.6557', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7937' 31/03/2023 09:31:21 am >> DELETE FROM ps_specific_price WHERE id_product = '7937' 31/03/2023 09:31:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030013-M' AND id_product != '7936' AND ean13 != '' 31/03/2023 09:31:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030013-M', date_upd = NOW() WHERE id_product = '7936' 31/03/2023 09:31:32 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - CRESIMA MOD. C', description = '' WHERE id_product = '7936' 31/03/2023 09:31:32 am >> UPDATE ps_product SET wholesale_price = '0.06', on_sale = '0', price = '0.4100' WHERE id_product = '7936' 31/03/2023 09:31:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.06', price = '0.4100', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7936' 31/03/2023 09:31:32 am >> DELETE FROM ps_specific_price WHERE id_product = '7936' 31/03/2023 09:31:48 am >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7919' 31/03/2023 09:32:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '030015-M' AND id_product != '7917' AND ean13 != '' 31/03/2023 09:32:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '030015-M', date_upd = NOW() WHERE id_product = '7917' 31/03/2023 09:32:13 am >> UPDATE ps_product_lang SET name = 'PERGAMENE - 1A RICONCILIAZIONE MOD. B', description = '' WHERE id_product = '7917' 31/03/2023 09:32:13 am >> UPDATE ps_product SET wholesale_price = '0.04', on_sale = '0', price = '0.4098' WHERE id_product = '7917' 31/03/2023 09:32:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.04', price = '0.4098', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '5', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7917' 31/03/2023 09:32:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7917' 31/03/2023 09:44:01 am >> SELECT document_num FROM ps_document WHERE document_num = '36/A' AND id_document != '82448' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-24') 31/03/2023 09:44:01 am >> UPDATE ps_document SET id_document_type = '24', document_num = '36/A', document_date = '2023-03-24', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', 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 = '127.00', price_tax_excluded = '108.90', date_upd = NOW() WHERE id_document = '82448' 31/03/2023 09:44:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82448' 31/03/2023 09:44:01 am >> DELETE FROM ps_document_detail WHERE id_document = '82448' 31/03/2023 09:44: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 ( '82448' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '72.00' ) 31/03/2023 09:44: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 ( '82448' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '22.00' ) 31/03/2023 09:44: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 ( '82448' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '3' , '10.00' , '9.6153846153846' , '4' , '0' , '30.00' ) 31/03/2023 09:44: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 ( '82448' , '11376' , 'VIENI SPIRITO SANTO' , '15' , '-15' , '4' , '0.2000' , '0.2' , '0' , '0' , '3.00' ) 31/03/2023 09:44:50 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '82289' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-14') 31/03/2023 09:44:50 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2023-03-14', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '641.00', price_tax_excluded = '526.04', date_upd = NOW() WHERE id_document = '82289' 31/03/2023 09:44: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 = '82289' 31/03/2023 09:44:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82289' 31/03/2023 09:44: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 ( '82289' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '2' , '-2' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '90.00' ) 31/03/2023 09:44: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 ( '82289' , '16730' , 'TUNICA AVORIO BORDO ORO - AETA03B05' , '8' , '-8' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '440.00' ) 31/03/2023 09:44: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 ( '82289' , '15481' , 'CROCE IHS - 2389/CZ' , '27' , '-27' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '67.50' ) 31/03/2023 09:44: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 ( '82289' , '18223' , 'CORONA MISSIONARIA - R102' , '40' , '-40' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '40.00' ) 31/03/2023 09:44: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 ( '82289' , '20516' , 'CROCE COMUNIONE - 42/08' , '8' , '-8' , '1' , '1.2000' , '0.98360655737705' , '22' , '100' , '0.00' ) 31/03/2023 09:44: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 ( '82289' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 31/03/2023 10:05:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 10:05:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1062' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.40' , NOW() , NOW() ) 31/03/2023 10:05:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82568' 31/03/2023 10:05:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82568' 31/03/2023 10:05:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82568' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 31/03/2023 10:10:38 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '82289' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-14') 31/03/2023 10:10:38 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2023-03-14', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '641.00', price_tax_excluded = '641.00', date_upd = NOW() WHERE id_document = '82289' 31/03/2023 10:10:38 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 = '82289' 31/03/2023 10:10:38 am >> DELETE FROM ps_document_detail WHERE id_document = '82289' 31/03/2023 10:10:38 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 ( '82289' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '2' , '-2' , '0' , '45.0000' , '45' , '' , '0' , '90.00' ) 31/03/2023 10:10:38 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 ( '82289' , '16730' , 'TUNICA AVORIO BORDO ORO - AETA03B05' , '8' , '-8' , '0' , '55.0000' , '55' , '' , '0' , '440.00' ) 31/03/2023 10:10:38 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 ( '82289' , '15481' , 'CROCE IHS - 2389/CZ' , '27' , '-27' , '0' , '2.5000' , '2.5' , '' , '0' , '67.50' ) 31/03/2023 10:10:38 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 ( '82289' , '18223' , 'CORONA MISSIONARIA - R102' , '40' , '-40' , '0' , '1.0000' , '1' , '' , '0' , '40.00' ) 31/03/2023 10:10:38 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 ( '82289' , '20516' , 'CROCE COMUNIONE - 42/08' , '6' , '-6' , '0' , '1.2000' , '1.2' , '' , '100' , '0.00' ) 31/03/2023 10:10:38 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 ( '82289' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 31/03/2023 10:13:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 10:13:21 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' , '1063' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 31/03/2023 10:13:21 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 = '82569' 31/03/2023 10:13:21 am >> DELETE FROM ps_document_detail WHERE id_document = '82569' 31/03/2023 10:13:21 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 ( '82569' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 31/03/2023 10:13:21 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 ( '82569' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '30' , '-30' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '54.00' ) 31/03/2023 10:13:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 31/03/2023 10:13:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 31/03/2023 10:13:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 31/03/2023 10:21:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 10:21:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1064' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.95' , '19.95' , NOW() , NOW() ) 31/03/2023 10:21:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82570' 31/03/2023 10:21:01 am >> DELETE FROM ps_document_detail WHERE id_document = '82570' 31/03/2023 10:21:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82570' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.00' , '7' , '0' , '5' , '19.95' ) 31/03/2023 10:29:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 10:29:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1065' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 31/03/2023 10:29:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82571' 31/03/2023 10:29:34 am >> DELETE FROM ps_document_detail WHERE id_document = '82571' 31/03/2023 10:29: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 ( '82571' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '10' , '-10' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '22.00' ) 31/03/2023 10:31:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 10:31:29 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' , '1066' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 31/03/2023 10:31:29 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 = '82572' 31/03/2023 10:31:29 am >> DELETE FROM ps_document_detail WHERE id_document = '82572' 31/03/2023 10:31:29 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 ( '82572' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 31/03/2023 11:04:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1067' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 11:04:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1067' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 31/03/2023 11:04: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 = '82573' 31/03/2023 11:04:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82573' 31/03/2023 11:04: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 ( '82573' , '18068' , 'SACCO PORTA ELEMOSINA - 1751' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 31/03/2023 11:21:18 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 ( '32' , '2023-FV000618' , '2023-03-31' , '' , '0' , '0' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '13' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '347.45' , '347.45' , NOW() , NOW() ) 31/03/2023 11:21:18 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 = '82574' 31/03/2023 11:21:18 am >> DELETE FROM ps_document_detail WHERE id_document = '82574' 31/03/2023 11:21:18 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 ( '82574' , '20797' , 'QUALCHE PAROLA PRIMA DELLAPOCALISSE - A. CANDIARD' , '1' , '0' , '4' , '11.0000' , '11' , '0' , '45' , '6.05' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '13380' , 'INTERPRETAZIONE DELLA BIBBIA NELLA CHIESA' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '45' , '3.30' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '2' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '78.00' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '10119' , 'SPE SALVI' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '1.10' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 31/03/2023 11:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82574' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '16.50' ) 31/03/2023 11:34:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1068' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 11:34:03 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' , '1068' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.00' , '50.82' , NOW() , NOW() ) 31/03/2023 11:34:03 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 = '82575' 31/03/2023 11:34:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82575' 31/03/2023 11:34:03 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 ( '82575' , '16731' , 'COPRILEGGIO CROCE ORO - AVCL01' , '1' , '-1' , '1' , '62.00' , '50.819672131148' , '22' , '0' , '62.00' ) 31/03/2023 11:41:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '364/TP' AND id_product != '12744' AND ean13 != '' 31/03/2023 11:41:57 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '364/TP', date_upd = NOW() WHERE id_product = '12744' 31/03/2023 11:41:57 am >> UPDATE ps_product_lang SET name = 'COPRILEGGIO MARIANO - 364/TP', description = '' WHERE id_product = '12744' 31/03/2023 11:41:57 am >> UPDATE ps_product SET wholesale_price = '25.80', on_sale = '0', price = '61.47540983606557' WHERE id_product = '12744' 31/03/2023 11:41:57 am >> UPDATE ps_product_shop SET wholesale_price = '25.80', price = '61.47540983606557', 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 = '12744' 31/03/2023 11:41:57 am >> DELETE FROM ps_specific_price WHERE id_product = '12744' 31/03/2023 11:44:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '317/TP' AND id_product != '13929' AND ean13 != '' 31/03/2023 11:44:13 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '317/TP', date_upd = NOW() WHERE id_product = '13929' 31/03/2023 11:44:13 am >> UPDATE ps_product_lang SET name = 'COPRILEGGIO - 317/TP', description = '' WHERE id_product = '13929' 31/03/2023 11:44:13 am >> UPDATE ps_product SET wholesale_price = '23.70', on_sale = '0', price = '57.37704918032787' WHERE id_product = '13929' 31/03/2023 11:44:13 am >> UPDATE ps_product_shop SET wholesale_price = '23.70', price = '57.37704918032787', 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 = '13929' 31/03/2023 11:44:13 am >> DELETE FROM ps_specific_price WHERE id_product = '13929' 31/03/2023 11:46:25 am >> SELECT document_num FROM ps_document WHERE document_num = '416' AND id_document != '81231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-04') 31/03/2023 11:46:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '416', document_date = '2023-02-04', 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 = '590.00', price_tax_excluded = '510.30', date_upd = NOW() WHERE id_document = '81231' 31/03/2023 11:46:25 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 = '81231' 31/03/2023 11:46:25 am >> DELETE FROM ps_document_detail WHERE id_document = '81231' 31/03/2023 11:46:25 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 ( '81231' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.0000' , '140' , '0' , '5' , '133.00' ) 31/03/2023 11:46:25 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 ( '81231' , '14000' , 'GALATEO IN CHIESA' , '15' , '-15' , '4' , '1.0000' , '1' , '0' , '0' , '15.00' ) 31/03/2023 11:46:25 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 ( '81231' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '36.00' ) 31/03/2023 11:46:25 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 ( '81231' , '2722' , 'COPRI AMBONE FIGLIOL PRODIGO' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 31/03/2023 11:46:25 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 ( '81231' , '14214' , 'CASULA IN POLIESTERE ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 31/03/2023 11:46: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 ( '81231' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 31/03/2023 11:46: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 ( '81231' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '31.0000' , '25.409836065574' , '22' , '0' , '31.00' ) 31/03/2023 11:46: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 ( '81231' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 31/03/2023 11:46: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 ( '81231' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 31/03/2023 12:20:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872296028' AND id_product != '17894' AND ean13 != '' 31/03/2023 12:20:57 pm >> UPDATE ps_product SET id_supplier = '47', reference = '6/3', ean13 = '9788872296028', date_upd = NOW() WHERE id_product = '17894' 31/03/2023 12:20:57 pm >> UPDATE ps_product_lang SET name = 'OPERE TERESA DI GESU\'', description = '' WHERE id_product = '17894' 31/03/2023 12:20:57 pm >> UPDATE ps_product SET wholesale_price = '21.00', on_sale = '0', price = '30.0000' WHERE id_product = '17894' 31/03/2023 12:20:57 pm >> UPDATE ps_product_shop SET wholesale_price = '21.00', price = '30.0000', id_tax_rules_group = '4', id_category_default = '128', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17894' 31/03/2023 12:20:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '17894' 31/03/2023 12:21:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872297988' AND id_product != '17418' AND ean13 != '' 31/03/2023 12:21:13 pm >> UPDATE ps_product SET id_supplier = '47', reference = '6/3', ean13 = '9788872297988', date_upd = NOW() WHERE id_product = '17418' 31/03/2023 12:21:13 pm >> UPDATE ps_product_lang SET name = 'OPERE COMPLETE S. GIOVANNI DELLA CROCE', description = '' WHERE id_product = '17418' 31/03/2023 12:21:13 pm >> UPDATE ps_product SET wholesale_price = '29.40', on_sale = '0', price = '42.0000' WHERE id_product = '17418' 31/03/2023 12:21:13 pm >> UPDATE ps_product_shop SET wholesale_price = '29.40', price = '42.0000', id_tax_rules_group = '4', id_category_default = '128', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17418' 31/03/2023 12:21:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '17418' 31/03/2023 12:21:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576785' AND id_product != '19136' AND ean13 != '' 31/03/2023 12:21:29 pm >> UPDATE ps_product SET id_supplier = '107', reference = '6/3', ean13 = '9788873576785', date_upd = NOW() WHERE id_product = '19136' 31/03/2023 12:21:29 pm >> UPDATE ps_product_lang SET name = 'SCRITTI DI S. IGNAZIO', description = '' WHERE id_product = '19136' 31/03/2023 12:21:29 pm >> UPDATE ps_product SET wholesale_price = '32.50', on_sale = '0', price = '50.0000' WHERE id_product = '19136' 31/03/2023 12:21:29 pm >> UPDATE ps_product_shop SET wholesale_price = '32.50', price = '50.0000', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19136' 31/03/2023 12:21:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '19136' 31/03/2023 12:42:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1069' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 12:42:11 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' , '1069' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 31/03/2023 12:42: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 = '82576' 31/03/2023 12:42:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82576' 31/03/2023 12:42: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 ( '82576' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '80' , '65.573770491803' , '22' , '0' , '160.00' ) 31/03/2023 12:42:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1070' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 12:42:40 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' , '1070' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '43.27' , NOW() , NOW() ) 31/03/2023 12:42:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82577' 31/03/2023 12:42:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82577' 31/03/2023 12:42:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82577' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 31/03/2023 12:42:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82577' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 31/03/2023 12:44:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1071' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 12:44: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' , '1071' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 31/03/2023 12:44: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 = '82578' 31/03/2023 12:44:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82578' 31/03/2023 12:44: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 ( '82578' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/03/2023 12:46:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1072' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 31/03/2023 12:46:33 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' , '1072' , '2023-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '16.85' , NOW() , NOW() ) 31/03/2023 12:46:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82579' 31/03/2023 12:46:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '82579' 31/03/2023 12:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82579' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 31/03/2023 12:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82579' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 31/03/2023 12:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82579' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/03/2023 03:36:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 31/03/2023 03:36:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', 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 = '141.60', price_tax_excluded = '141.60', date_upd = NOW() WHERE id_document = '81317' 31/03/2023 03:36: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 = '81317' 31/03/2023 03:36:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 31/03/2023 03:36: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 ( '81317' , '16267' , 'DIO SI RACCONTA - P. DE MARTINO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 31/03/2023 03:36: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 ( '81317' , '16444' , 'VANGELO DI MARCO - 8998' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 31/03/2023 03:36: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 ( '81317' , '20766' , 'AMEN - GIU 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 31/03/2023 03:36: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 ( '81317' , '20765' , 'AMEN - MAG 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 31/03/2023 03:36: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 ( '81317' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 31/03/2023 03:36: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 ( '81317' , '20731' , 'PAROLA E PREGHIERA APR 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 31/03/2023 03:36: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 ( '81317' , '20764' , 'PAROLA E PREGHIERA - MAG 2023' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 31/03/2023 03:36: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 ( '81317' , '20756' , 'COMMENTARIO BIBLICO' , '1' , '-1' , '4' , '50.0000' , '50' , '0' , '0' , '50.00' ) 31/03/2023 03:36: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 ( '81317' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 31/03/2023 03:36: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 ( '81317' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 31/03/2023 03:36: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 ( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 31/03/2023 03:58:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983455' AND id_product != '13506' AND ean13 != '' 31/03/2023 03:58:30 pm >> UPDATE ps_product SET id_supplier = '53', reference = 'ESPOSITORE SAN PAOLO', ean13 = '9788895983455', date_upd = NOW() WHERE id_product = '13506' 31/03/2023 03:58:30 pm >> UPDATE ps_product_lang SET name = 'SANTO ROSARIO', description = '
Pagellina tascabile con le indicazioni per la recita del S. Rosario. Contiene l\'esposizione dei misteri e le litanie lauretane e la preghiera finale
Cartoncino pieghevole utile per aiutare giovani e adulti a prepararsi a ricevere il Sacramento della Confessione. L\'esame di coscienza proposto è tratto dai suggerimenti di Papa Francesco.
Un piccolo cartoncino pieghevole utile come sussidio per preparare i bambini alla prima Confessione e per continuare a celebrare il Sacramento del perdono con un esame di coscienza adatto alla loro età.