28/01/2023 08:41:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047267' AND id_product != '18440' AND ean13 != '' 28/01/2023 08:41:32 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884047267', date_upd = NOW() WHERE id_product = '18440' 28/01/2023 08:41:32 am >> UPDATE ps_product_lang SET name = 'SANTA RITA I QUINDICI GIOVEDI\' E NOVENA - 8036', description = '' WHERE id_product = '18440' 28/01/2023 08:41:32 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '18440' 28/01/2023 08:41:32 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18440' 28/01/2023 08:41:32 am >> DELETE FROM ps_specific_price WHERE id_product = '18440' 28/01/2023 08:45:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846071850' AND id_product != '9178' AND ean13 != '' 28/01/2023 08:45:05 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '8027846071850', date_upd = NOW() WHERE id_product = '9178' 28/01/2023 08:45:05 am >> UPDATE ps_product_lang SET name = 'ROSARIO ROSETTA LOURDES MM 04 - RL861', description = '' WHERE id_product = '9178' 28/01/2023 08:45:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9180' WHERE id_product = '9178' 28/01/2023 08:45:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9180', id_tax_rules_group = '1', id_category_default = '151', 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 = '9178' 28/01/2023 08:45:05 am >> DELETE FROM ps_specific_price WHERE id_product = '9178' 28/01/2023 09:09:22 am >> SELECT document_num FROM ps_document WHERE document_num = '295' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 09:09:22 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' , '295' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 28/01/2023 09:09:22 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 = '80566' 28/01/2023 09:09:22 am >> DELETE FROM ps_document_detail WHERE id_document = '80566' 28/01/2023 09:09:23 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 ( '80566' , '20638' , 'DAL NULLA AL MISTERO - B. WELTE' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 28/01/2023 09:32:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571536' AND id_product != '16147' AND ean13 != '' 28/01/2023 09:32:10 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571536', date_upd = NOW() WHERE id_product = '16147' 28/01/2023 09:32:10 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO LA MESSA', description = '' WHERE id_product = '16147' 28/01/2023 09:32:10 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '16147' 28/01/2023 09:32:10 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16147' 28/01/2023 09:32:10 am >> DELETE FROM ps_specific_price WHERE id_product = '16147' 28/01/2023 09:32:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571642' AND id_product != '17242' AND ean13 != '' 28/01/2023 09:32:24 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571642', date_upd = NOW() WHERE id_product = '17242' 28/01/2023 09:32:24 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME LA COMUNIONE', description = '' WHERE id_product = '17242' 28/01/2023 09:32:24 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '17242' 28/01/2023 09:32:24 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17242' 28/01/2023 09:32:24 am >> DELETE FROM ps_specific_price WHERE id_product = '17242' 28/01/2023 09:32:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571833' AND id_product != '18647' AND ean13 != '' 28/01/2023 09:32:36 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571833', date_upd = NOW() WHERE id_product = '18647' 28/01/2023 09:32:36 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME AVVENTO E NATALE', description = '' WHERE id_product = '18647' 28/01/2023 09:32:36 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '18647' 28/01/2023 09:32:36 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18647' 28/01/2023 09:32:36 am >> DELETE FROM ps_specific_price WHERE id_product = '18647' 28/01/2023 09:32:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571659' AND id_product != '18667' AND ean13 != '' 28/01/2023 09:32:50 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571659', date_upd = NOW() WHERE id_product = '18667' 28/01/2023 09:32:50 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO LA CRESIMA', description = '' WHERE id_product = '18667' 28/01/2023 09:32:50 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '18667' 28/01/2023 09:32:50 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '21', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18667' 28/01/2023 09:32:50 am >> DELETE FROM ps_specific_price WHERE id_product = '18667' 28/01/2023 09:33:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571857' AND id_product != '19294' AND ean13 != '' 28/01/2023 09:33:03 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571857', date_upd = NOW() WHERE id_product = '19294' 28/01/2023 09:33:03 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME IL VANGELO', description = '' WHERE id_product = '19294' 28/01/2023 09:33:03 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '19294' 28/01/2023 09:33:03 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '21', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19294' 28/01/2023 09:33:03 am >> DELETE FROM ps_specific_price WHERE id_product = '19294' 28/01/2023 09:33:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571734' AND id_product != '18064' AND ean13 != '' 28/01/2023 09:33:24 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571734', date_upd = NOW() WHERE id_product = '18064' 28/01/2023 09:33:24 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME LE RELIGIONI', description = '' WHERE id_product = '18064' 28/01/2023 09:33:24 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '18064' 28/01/2023 09:33:24 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18064' 28/01/2023 09:33:24 am >> DELETE FROM ps_specific_price WHERE id_product = '18064' 28/01/2023 09:33:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571901' AND id_product != '19565' AND ean13 != '' 28/01/2023 09:33:37 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571901', date_upd = NOW() WHERE id_product = '19565' 28/01/2023 09:33:37 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME SEGNI E SIMBOLI', description = '' WHERE id_product = '19565' 28/01/2023 09:33:37 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '19565' 28/01/2023 09:33:37 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19565' 28/01/2023 09:33:37 am >> DELETE FROM ps_specific_price WHERE id_product = '19565' 28/01/2023 09:33:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571819' AND id_product != '18448' AND ean13 != '' 28/01/2023 09:33:54 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571819', date_upd = NOW() WHERE id_product = '18448' 28/01/2023 09:33:54 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME IL CREDO ', description = '' WHERE id_product = '18448' 28/01/2023 09:33:54 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '18448' 28/01/2023 09:33:54 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '21', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18448' 28/01/2023 09:33:54 am >> DELETE FROM ps_specific_price WHERE id_product = '18448' 28/01/2023 09:34:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571581' AND id_product != '18666' AND ean13 != '' 28/01/2023 09:34:38 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571581', date_upd = NOW() WHERE id_product = '18666' 28/01/2023 09:34:38 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO LA BIBBIA', description = '' WHERE id_product = '18666' 28/01/2023 09:34:38 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '18666' 28/01/2023 09:34:39 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18666' 28/01/2023 09:34:39 am >> DELETE FROM ps_specific_price WHERE id_product = '18666' 28/01/2023 09:34:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571420' AND id_product != '17517' AND ean13 != '' 28/01/2023 09:34:52 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571420', date_upd = NOW() WHERE id_product = '17517' 28/01/2023 09:34:52 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME GESU\'', description = '' WHERE id_product = '17517' 28/01/2023 09:34:52 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '17517' 28/01/2023 09:34:52 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17517' 28/01/2023 09:34:52 am >> DELETE FROM ps_specific_price WHERE id_product = '17517' 28/01/2023 09:35:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571703' AND id_product != '17767' AND ean13 != '' 28/01/2023 09:35:12 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867571703', date_upd = NOW() WHERE id_product = '17767' 28/01/2023 09:35:12 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME LA QUARESIMA E PASQUA', description = '' WHERE id_product = '17767' 28/01/2023 09:35:12 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '17767' 28/01/2023 09:35:12 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', 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 = '17767' 28/01/2023 09:35:12 am >> DELETE FROM ps_specific_price WHERE id_product = '17767' 28/01/2023 09:39:19 am >> SELECT document_num FROM ps_document WHERE document_num = '296' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 09:39:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '296' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '11.89' , NOW() , NOW() ) 28/01/2023 09:39:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80567' 28/01/2023 09:39:19 am >> DELETE FROM ps_document_detail WHERE id_document = '80567' 28/01/2023 09:39: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 ( '80567' , '20171' , 'ANGELO CM 18 - AR105' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 28/01/2023 09:41:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245310' AND id_product != '11147' AND ean13 != '' 28/01/2023 09:41:08 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861245310', date_upd = NOW() WHERE id_product = '11147' 28/01/2023 09:41:08 am >> UPDATE ps_product_lang SET name = 'VANGELO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '11147' 28/01/2023 09:41:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '11147' 28/01/2023 09:41:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '11147' 28/01/2023 09:41:08 am >> DELETE FROM ps_specific_price WHERE id_product = '11147' 28/01/2023 09:41:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861246881' AND id_product != '13129' AND ean13 != '' 28/01/2023 09:41:21 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861246881', date_upd = NOW() WHERE id_product = '13129' 28/01/2023 09:41:21 am >> UPDATE ps_product_lang SET name = 'ESAME DI COSCIENZA SPIEGATO AI BAMBINI', description = '' WHERE id_product = '13129' 28/01/2023 09:41:21 am >> UPDATE ps_product SET wholesale_price = '2.73', on_sale = '0', price = '3.9000' WHERE id_product = '13129' 28/01/2023 09:41:21 am >> UPDATE ps_product_shop SET wholesale_price = '2.73', price = '3.9000', 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 = '13129' 28/01/2023 09:41:21 am >> DELETE FROM ps_specific_price WHERE id_product = '13129' 28/01/2023 09:41:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242272' AND id_product != '9307' AND ean13 != '' 28/01/2023 09:41:32 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861242272', date_upd = NOW() WHERE id_product = '9307' 28/01/2023 09:41:32 am >> UPDATE ps_product_lang SET name = 'SACRAMENTI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '9307' 28/01/2023 09:41:32 am >> UPDATE ps_product SET wholesale_price = '2.73', on_sale = '0', price = '3.9000' WHERE id_product = '9307' 28/01/2023 09:41:32 am >> UPDATE ps_product_shop SET wholesale_price = '2.73', price = '3.9000', 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 = '9307' 28/01/2023 09:41:32 am >> DELETE FROM ps_specific_price WHERE id_product = '9307' 28/01/2023 09:41:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245983' AND id_product != '6723' AND ean13 != '' 28/01/2023 09:41:44 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861245983', date_upd = NOW() WHERE id_product = '6723' 28/01/2023 09:41:44 am >> UPDATE ps_product_lang SET name = 'MIRACOLI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '6723' 28/01/2023 09:41:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '6723' 28/01/2023 09:41:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '6723' 28/01/2023 09:41:44 am >> DELETE FROM ps_specific_price WHERE id_product = '6723' 28/01/2023 09:41:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861243460' AND id_product != '661' AND ean13 != '' 28/01/2023 09:41:54 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861243460', date_upd = NOW() WHERE id_product = '661' 28/01/2023 09:41:54 am >> UPDATE ps_product_lang SET name = 'ANNO LITURGICO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '661' 28/01/2023 09:41:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '661' 28/01/2023 09:41:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '661' 28/01/2023 09:41:54 am >> DELETE FROM ps_specific_price WHERE id_product = '661' 28/01/2023 09:42:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861240810' AND id_product != '3437' AND ean13 != '' 28/01/2023 09:42:05 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861240810', date_upd = NOW() WHERE id_product = '3437' 28/01/2023 09:42:06 am >> UPDATE ps_product_lang SET name = 'DIECI COMANDAMENTI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '3437' 28/01/2023 09:42:06 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '3437' 28/01/2023 09:42:06 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '3437' 28/01/2023 09:42:06 am >> DELETE FROM ps_specific_price WHERE id_product = '3437' 28/01/2023 09:42:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244962' AND id_product != '10735' AND ean13 != '' 28/01/2023 09:42:16 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861244962', date_upd = NOW() WHERE id_product = '10735' 28/01/2023 09:42:16 am >> UPDATE ps_product_lang SET name = 'TRINITÀ SPIEGATA AI BAMBINI', description = '' WHERE id_product = '10735' 28/01/2023 09:42:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '10735' 28/01/2023 09:42:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '10735' 28/01/2023 09:42:16 am >> DELETE FROM ps_specific_price WHERE id_product = '10735' 28/01/2023 09:42:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244269' AND id_product != '8886' AND ean13 != '' 28/01/2023 09:42:28 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861244269', date_upd = NOW() WHERE id_product = '8886' 28/01/2023 09:42:28 am >> UPDATE ps_product_lang SET name = 'RELIGIONI SPIEGATE AI BAMBINI', description = '' WHERE id_product = '8886' 28/01/2023 09:42:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '8886' 28/01/2023 09:42:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8886' 28/01/2023 09:42:29 am >> DELETE FROM ps_specific_price WHERE id_product = '8886' 28/01/2023 09:42:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861243354' AND id_product != '4500' AND ean13 != '' 28/01/2023 09:42:42 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861243354', date_upd = NOW() WHERE id_product = '4500' 28/01/2023 09:42:42 am >> UPDATE ps_product_lang SET name = 'GESÙ SPIEGATO AI BAMBINI', description = '' WHERE id_product = '4500' 28/01/2023 09:42:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '4500' 28/01/2023 09:42:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4500' 28/01/2023 09:42:42 am >> DELETE FROM ps_specific_price WHERE id_product = '4500' 28/01/2023 09:42:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245587' AND id_product != '3523' AND ean13 != '' 28/01/2023 09:42:53 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861245587', date_upd = NOW() WHERE id_product = '3523' 28/01/2023 09:42:53 am >> UPDATE ps_product_lang SET name = 'DIO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '3523' 28/01/2023 09:42:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '3523' 28/01/2023 09:42:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '3523' 28/01/2023 09:42:53 am >> DELETE FROM ps_specific_price WHERE id_product = '3523' 28/01/2023 09:43:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861246980' AND id_product != '13470' AND ean13 != '' 28/01/2023 09:43:05 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861246980', date_upd = NOW() WHERE id_product = '13470' 28/01/2023 09:43:05 am >> UPDATE ps_product_lang SET name = 'CRISTIANI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '13470' 28/01/2023 09:43:05 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '13470' 28/01/2023 09:43:05 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '13470' 28/01/2023 09:43:05 am >> DELETE FROM ps_specific_price WHERE id_product = '13470' 28/01/2023 09:43:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861241534' AND id_product != '1991' AND ean13 != '' 28/01/2023 09:43:22 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861241534', date_upd = NOW() WHERE id_product = '1991' 28/01/2023 09:43:22 am >> UPDATE ps_product_lang SET name = 'CHI È IL SACERDOTE? - SPIEGATO AI BAMBINI', description = '' WHERE id_product = '1991' 28/01/2023 09:43:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '1991' 28/01/2023 09:43:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '1991' 28/01/2023 09:43:22 am >> DELETE FROM ps_specific_price WHERE id_product = '1991' 28/01/2023 09:43:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247628' AND id_product != '15278' AND ean13 != '' 28/01/2023 09:43:34 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861247628', date_upd = NOW() WHERE id_product = '15278' 28/01/2023 09:43:34 am >> UPDATE ps_product_lang SET name = 'SANTITA\' SPIEGATA AI BAMBINI', description = '' WHERE id_product = '15278' 28/01/2023 09:43:34 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '15278' 28/01/2023 09:43:34 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '15278' 28/01/2023 09:43:34 am >> DELETE FROM ps_specific_price WHERE id_product = '15278' 28/01/2023 09:43:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861242289' AND id_product != '2864' AND ean13 != '' 28/01/2023 09:43:47 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861242289', date_upd = NOW() WHERE id_product = '2864' 28/01/2023 09:43:47 am >> UPDATE ps_product_lang SET name = 'CREDO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '2864' 28/01/2023 09:43:47 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '2864' 28/01/2023 09:43:47 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '2864' 28/01/2023 09:43:47 am >> DELETE FROM ps_specific_price WHERE id_product = '2864' 28/01/2023 09:43:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861243675' AND id_product != '2045' AND ean13 != '' 28/01/2023 09:43:59 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861243675', date_upd = NOW() WHERE id_product = '2045' 28/01/2023 09:43:59 am >> UPDATE ps_product_lang SET name = 'CHIESA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '2045' 28/01/2023 09:43:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '2045' 28/01/2023 09:43:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2045' 28/01/2023 09:43:59 am >> DELETE FROM ps_specific_price WHERE id_product = '2045' 28/01/2023 09:44:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247666' AND id_product != '15471' AND ean13 != '' 28/01/2023 09:44:21 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861247666', date_upd = NOW() WHERE id_product = '15471' 28/01/2023 09:44:21 am >> UPDATE ps_product_lang SET name = 'ADORAZIONE EUCARISTICA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '15471' 28/01/2023 09:44:21 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '15471' 28/01/2023 09:44:21 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '15471' 28/01/2023 09:44:21 am >> DELETE FROM ps_specific_price WHERE id_product = '15471' 28/01/2023 09:44:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249158' AND id_product != '18117' AND ean13 != '' 28/01/2023 09:44:47 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861249158', date_upd = NOW() WHERE id_product = '18117' 28/01/2023 09:44:47 am >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '18117' 28/01/2023 09:44:47 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '18117' 28/01/2023 09:44:47 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '18117' 28/01/2023 09:44:47 am >> DELETE FROM ps_specific_price WHERE id_product = '18117' 28/01/2023 09:44:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245327' AND id_product != '7753' AND ean13 != '' 28/01/2023 09:44:59 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861245327', date_upd = NOW() WHERE id_product = '7753' 28/01/2023 09:44:59 am >> UPDATE ps_product_lang SET name = 'PECCATO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '7753' 28/01/2023 09:44:59 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '7753' 28/01/2023 09:44:59 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '7753' 28/01/2023 09:44:59 am >> DELETE FROM ps_specific_price WHERE id_product = '7753' 28/01/2023 09:45:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244771' AND id_product != '2876' AND ean13 != '' 28/01/2023 09:45:11 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861244771', date_upd = NOW() WHERE id_product = '2876' 28/01/2023 09:45:11 am >> UPDATE ps_product_lang SET name = 'CRESIMA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '2876' 28/01/2023 09:45:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '2876' 28/01/2023 09:45:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '2876' 28/01/2023 09:45:11 am >> DELETE FROM ps_specific_price WHERE id_product = '2876' 28/01/2023 09:45:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247932' AND id_product != '16076' AND ean13 != '' 28/01/2023 09:45:43 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861247932', date_upd = NOW() WHERE id_product = '16076' 28/01/2023 09:45:43 am >> UPDATE ps_product_lang SET name = 'GESTI CRISTIANI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '16076' 28/01/2023 09:45:43 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '16076' 28/01/2023 09:45:43 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '16076' 28/01/2023 09:45:43 am >> DELETE FROM ps_specific_price WHERE id_product = '16076' 28/01/2023 09:45:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861240674' AND id_product != '1830' AND ean13 != '' 28/01/2023 09:45:57 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861240674', date_upd = NOW() WHERE id_product = '1830' 28/01/2023 09:45:57 am >> UPDATE ps_product_lang SET name = 'CATECHISMO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '1830' 28/01/2023 09:45:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '1830' 28/01/2023 09:45:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1830' 28/01/2023 09:45:57 am >> DELETE FROM ps_specific_price WHERE id_product = '1830' 28/01/2023 09:46:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245495' AND id_product != '8319' AND ean13 != '' 28/01/2023 09:46:18 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861245495', date_upd = NOW() WHERE id_product = '8319' 28/01/2023 09:46:18 am >> UPDATE ps_product_lang SET name = 'PREGHIERA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '8319' 28/01/2023 09:46:18 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '8319' 28/01/2023 09:46:18 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '8319' 28/01/2023 09:46:18 am >> DELETE FROM ps_specific_price WHERE id_product = '8319' 28/01/2023 09:46:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861240322' AND id_product != '6538' AND ean13 != '' 28/01/2023 09:46:29 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861240322', date_upd = NOW() WHERE id_product = '6538' 28/01/2023 09:46:29 am >> UPDATE ps_product_lang SET name = 'MESSA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '6538' 28/01/2023 09:46:29 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '6538' 28/01/2023 09:46:29 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6538' 28/01/2023 09:46:29 am >> DELETE FROM ps_specific_price WHERE id_product = '6538' 28/01/2023 09:46:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245990' AND id_product != '7550' AND ean13 != '' 28/01/2023 09:46:51 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861245990', date_upd = NOW() WHERE id_product = '7550' 28/01/2023 09:46:51 am >> UPDATE ps_product_lang SET name = 'PARABOLE SPIEGATE AI BAMBINI', description = '' WHERE id_product = '7550' 28/01/2023 09:46:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9000' WHERE id_product = '7550' 28/01/2023 09:46:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9000', 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 = '7550' 28/01/2023 09:46:51 am >> DELETE FROM ps_specific_price WHERE id_product = '7550' 28/01/2023 09:47:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244092' AND id_product != '7682' AND ean13 != '' 28/01/2023 09:47:04 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861244092', date_upd = NOW() WHERE id_product = '7682' 28/01/2023 09:47:04 am >> UPDATE ps_product_lang SET name = 'PASQUA SPIEGATA AI BAMBINI ', description = '' WHERE id_product = '7682' 28/01/2023 09:47:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9000' WHERE id_product = '7682' 28/01/2023 09:47:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9000', 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 = '7682' 28/01/2023 09:47:04 am >> DELETE FROM ps_specific_price WHERE id_product = '7682' 28/01/2023 09:47:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861243149' AND id_product != '8728' AND ean13 != '' 28/01/2023 09:47:17 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861243149', date_upd = NOW() WHERE id_product = '8728' 28/01/2023 09:47:17 am >> UPDATE ps_product_lang SET name = 'QUARESIMA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '8728' 28/01/2023 09:47:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9000' WHERE id_product = '8728' 28/01/2023 09:47:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8728' 28/01/2023 09:47:17 am >> DELETE FROM ps_specific_price WHERE id_product = '8728' 28/01/2023 09:48:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861246072' AND id_product != '7249' AND ean13 != '' 28/01/2023 09:48:28 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861246072', date_upd = NOW() WHERE id_product = '7249' 28/01/2023 09:48:28 am >> UPDATE ps_product_lang SET name = 'OPERE DI MISERICORDIA SPIEGATE AI BAMBINI', description = '' WHERE id_product = '7249' 28/01/2023 09:48:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '7249' 28/01/2023 09:48:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '7249' 28/01/2023 09:48:28 am >> DELETE FROM ps_specific_price WHERE id_product = '7249' 28/01/2023 09:48:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244498' AND id_product != '4158' AND ean13 != '' 28/01/2023 09:48:46 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861244498', date_upd = NOW() WHERE id_product = '4158' 28/01/2023 09:48:46 am >> UPDATE ps_product_lang SET name = 'FESTE CRISTIANE SPIEGATE AI BAMBINI', description = '' WHERE id_product = '4158' 28/01/2023 09:48:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '4158' 28/01/2023 09:48:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '4158' 28/01/2023 09:48:46 am >> DELETE FROM ps_specific_price WHERE id_product = '4158' 28/01/2023 09:48:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245303' AND id_product != '4122' AND ean13 != '' 28/01/2023 09:48:58 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861245303', date_upd = NOW() WHERE id_product = '4122' 28/01/2023 09:48:58 am >> UPDATE ps_product_lang SET name = 'FEDE SPIEGATA AI BAMBINI', description = '' WHERE id_product = '4122' 28/01/2023 09:48:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '4122' 28/01/2023 09:48:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '4122' 28/01/2023 09:48:58 am >> DELETE FROM ps_specific_price WHERE id_product = '4122' 28/01/2023 09:49:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247819' AND id_product != '15717' AND ean13 != '' 28/01/2023 09:49:19 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861247819', date_upd = NOW() WHERE id_product = '15717' 28/01/2023 09:49:19 am >> UPDATE ps_product_lang SET name = 'SIMBOLI CRISTIANI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '15717' 28/01/2023 09:49:19 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '15717' 28/01/2023 09:49:19 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '15717' 28/01/2023 09:49:19 am >> DELETE FROM ps_specific_price WHERE id_product = '15717' 28/01/2023 09:49:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245129' AND id_product != '996' AND ean13 != '' 28/01/2023 09:49:32 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861245129', date_upd = NOW() WHERE id_product = '996' 28/01/2023 09:49:32 am >> UPDATE ps_product_lang SET name = 'BEATITUDINI SPIEGATE AI BAMBINI', description = '' WHERE id_product = '996' 28/01/2023 09:49:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '996' 28/01/2023 09:49:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '996' 28/01/2023 09:49:33 am >> DELETE FROM ps_specific_price WHERE id_product = '996' 28/01/2023 09:49:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244528' AND id_product != '6260' AND ean13 != '' 28/01/2023 09:49:45 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861244528', date_upd = NOW() WHERE id_product = '6260' 28/01/2023 09:49:45 am >> UPDATE ps_product_lang SET name = 'MARIA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '6260' 28/01/2023 09:49:45 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '6260' 28/01/2023 09:49:45 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6260' 28/01/2023 09:49:45 am >> DELETE FROM ps_specific_price WHERE id_product = '6260' 28/01/2023 09:49:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244252' AND id_product != '9635' AND ean13 != '' 28/01/2023 09:49:59 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861244252', date_upd = NOW() WHERE id_product = '9635' 28/01/2023 09:49:59 am >> UPDATE ps_product_lang SET name = 'SANTI SPIEGATI AI BAMBINI', description = '' WHERE id_product = '9635' 28/01/2023 09:49:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '9635' 28/01/2023 09:49:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', 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 = '9635' 28/01/2023 09:49:59 am >> DELETE FROM ps_specific_price WHERE id_product = '9635' 28/01/2023 09:50:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247413' AND id_product != '14656' AND ean13 != '' 28/01/2023 09:50:11 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861247413', date_upd = NOW() WHERE id_product = '14656' 28/01/2023 09:50:11 am >> UPDATE ps_product_lang SET name = 'ROSARIO SPIEGATO AI BAMBINI', description = '' WHERE id_product = '14656' 28/01/2023 09:50:11 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.5000' WHERE id_product = '14656' 28/01/2023 09:50:11 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.5000', 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 = '14656' 28/01/2023 09:50:11 am >> DELETE FROM ps_specific_price WHERE id_product = '14656' 28/01/2023 09:52:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713367' AND id_product != '19764' AND ean13 != '' 28/01/2023 09:52:39 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/4', ean13 = '9788832713367', date_upd = NOW() WHERE id_product = '19764' 28/01/2023 09:52:39 am >> UPDATE ps_product_lang SET name = 'PRIMO PASSO - TACCUINO', description = '' WHERE id_product = '19764' 28/01/2023 09:52:39 am >> UPDATE ps_product SET wholesale_price = '3.75', on_sale = '0', price = '5.0000' WHERE id_product = '19764' 28/01/2023 09:52:39 am >> UPDATE ps_product_shop SET wholesale_price = '3.75', price = '5.0000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19764' 28/01/2023 09:52:39 am >> DELETE FROM ps_specific_price WHERE id_product = '19764' 28/01/2023 09:52:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713442' AND id_product != '19767' AND ean13 != '' 28/01/2023 09:52:53 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/4', ean13 = '9788832713442', date_upd = NOW() WHERE id_product = '19767' 28/01/2023 09:52:53 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA - CALENDARIO', description = '' WHERE id_product = '19767' 28/01/2023 09:52:53 am >> UPDATE ps_product SET wholesale_price = '5.04', on_sale = '0', price = '7.0000' WHERE id_product = '19767' 28/01/2023 09:52:53 am >> UPDATE ps_product_shop SET wholesale_price = '5.04', price = '7.0000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19767' 28/01/2023 09:52:53 am >> DELETE FROM ps_specific_price WHERE id_product = '19767' 28/01/2023 09:53:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713343' AND id_product != '20051' AND ean13 != '' 28/01/2023 09:53:06 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/4', ean13 = '9788832713343', date_upd = NOW() WHERE id_product = '20051' 28/01/2023 09:53:06 am >> UPDATE ps_product_lang SET name = 'ANDATE DUNQUE 2022/23 ANNO A', description = '' WHERE id_product = '20051' 28/01/2023 09:53:06 am >> UPDATE ps_product SET wholesale_price = '7.65', on_sale = '0', price = '10.5000' WHERE id_product = '20051' 28/01/2023 09:53:06 am >> UPDATE ps_product_shop SET wholesale_price = '7.65', price = '10.5000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20051' 28/01/2023 09:53:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20051' 28/01/2023 09:53:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713374' AND id_product != '19762' AND ean13 != '' 28/01/2023 09:53:18 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/4', ean13 = '9788832713374', date_upd = NOW() WHERE id_product = '19762' 28/01/2023 09:53:18 am >> UPDATE ps_product_lang SET name = 'PRIMO PASSO - GUIDA', description = '' WHERE id_product = '19762' 28/01/2023 09:53:18 am >> UPDATE ps_product SET wholesale_price = '9.37', on_sale = '0', price = '12.5000' WHERE id_product = '19762' 28/01/2023 09:53:18 am >> UPDATE ps_product_shop SET wholesale_price = '9.37', price = '12.5000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19762' 28/01/2023 09:53:18 am >> DELETE FROM ps_specific_price WHERE id_product = '19762' 28/01/2023 09:53:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713404' AND id_product != '19758' AND ean13 != '' 28/01/2023 09:53:32 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/4', ean13 = '9788832713404', date_upd = NOW() WHERE id_product = '19758' 28/01/2023 09:53:32 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA - 1', description = '' WHERE id_product = '19758' 28/01/2023 09:53:32 am >> UPDATE ps_product SET wholesale_price = '12.37', on_sale = '0', price = '16.5000' WHERE id_product = '19758' 28/01/2023 09:53:32 am >> UPDATE ps_product_shop SET wholesale_price = '12.37', price = '16.5000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19758' 28/01/2023 09:53:32 am >> DELETE FROM ps_specific_price WHERE id_product = '19758' 28/01/2023 09:53:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713411' AND id_product != '19759' AND ean13 != '' 28/01/2023 09:53:44 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/4', ean13 = '9788832713411', date_upd = NOW() WHERE id_product = '19759' 28/01/2023 09:53:44 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA - 2', description = '' WHERE id_product = '19759' 28/01/2023 09:53:44 am >> UPDATE ps_product SET wholesale_price = '12.37', on_sale = '0', price = '16.5000' WHERE id_product = '19759' 28/01/2023 09:53:44 am >> UPDATE ps_product_shop SET wholesale_price = '12.37', price = '16.5000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19759' 28/01/2023 09:53:44 am >> DELETE FROM ps_specific_price WHERE id_product = '19759' 28/01/2023 09:53:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713398' AND id_product != '19761' AND ean13 != '' 28/01/2023 09:53:57 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/4', ean13 = '9788832713398', date_upd = NOW() WHERE id_product = '19761' 28/01/2023 09:53:57 am >> UPDATE ps_product_lang SET name = 'RAGAZZI CHE SQUADRA', description = '' WHERE id_product = '19761' 28/01/2023 09:53:57 am >> UPDATE ps_product SET wholesale_price = '12.37', on_sale = '0', price = '16.5000' WHERE id_product = '19761' 28/01/2023 09:53:57 am >> UPDATE ps_product_shop SET wholesale_price = '12.37', price = '16.5000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19761' 28/01/2023 09:53:57 am >> DELETE FROM ps_specific_price WHERE id_product = '19761' 28/01/2023 09:54:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832712360' AND id_product != '17595' AND ean13 != '' 28/01/2023 09:54:16 am >> UPDATE ps_product SET id_supplier = '109', reference = '1/2', ean13 = '9788832712360', date_upd = NOW() WHERE id_product = '17595' 28/01/2023 09:54:16 am >> UPDATE ps_product_lang SET name = 'STATUTO AZIONE CATTOLICA', description = '' WHERE id_product = '17595' 28/01/2023 09:54:16 am >> UPDATE ps_product SET wholesale_price = '4.90', on_sale = '0', price = '7.0000' WHERE id_product = '17595' 28/01/2023 09:54:16 am >> UPDATE ps_product_shop SET wholesale_price = '4.90', price = '7.0000', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '251', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17595' 28/01/2023 09:54:16 am >> DELETE FROM ps_specific_price WHERE id_product = '17595' 28/01/2023 09:54:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062588' AND id_product != '12342' AND ean13 != '' 28/01/2023 09:54:43 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/1', ean13 = '9788801062588', date_upd = NOW() WHERE id_product = '12342' 28/01/2023 09:54:43 am >> UPDATE ps_product_lang SET name = 'ALBERO DOVE I PICCOLI TROVANO IL NIDO 3 ', description = '' WHERE id_product = '12342' 28/01/2023 09:54:43 am >> UPDATE ps_product SET wholesale_price = '12.94', on_sale = '0', price = '19.9000' WHERE id_product = '12342' 28/01/2023 09:54:43 am >> UPDATE ps_product_shop SET wholesale_price = '12.94', price = '19.9000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '116', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12342' 28/01/2023 09:54:43 am >> DELETE FROM ps_specific_price WHERE id_product = '12342' 28/01/2023 09:54:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062045' AND id_product != '356' AND ean13 != '' 28/01/2023 09:54:56 am >> UPDATE ps_product SET id_supplier = '', reference = '2/1', ean13 = '9788801062045', date_upd = NOW() WHERE id_product = '356' 28/01/2023 09:54:56 am >> UPDATE ps_product_lang SET name = 'ALBERO DOVE I PICCOLI TROVANO IL NIDO 2', description = '' WHERE id_product = '356' 28/01/2023 09:54:56 am >> UPDATE ps_product SET wholesale_price = '10.99', on_sale = '0', price = '16.9000' WHERE id_product = '356' 28/01/2023 09:54:56 am >> UPDATE ps_product_shop SET wholesale_price = '10.99', price = '16.9000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '116', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '356' 28/01/2023 09:54:56 am >> DELETE FROM ps_specific_price WHERE id_product = '356' 28/01/2023 09:55:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801059182' AND id_product != '355' AND ean13 != '' 28/01/2023 09:55:09 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/1', ean13 = '9788801059182', date_upd = NOW() WHERE id_product = '355' 28/01/2023 09:55:09 am >> UPDATE ps_product_lang SET name = 'ALBERO DOVE I PICCOLI TROVANO IL NIDO 1', description = '' WHERE id_product = '355' 28/01/2023 09:55:09 am >> UPDATE ps_product SET wholesale_price = '10.99', on_sale = '0', price = '16.9000' WHERE id_product = '355' 28/01/2023 09:55:09 am >> UPDATE ps_product_shop SET wholesale_price = '10.99', price = '16.9000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '116', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '355' 28/01/2023 09:55:09 am >> DELETE FROM ps_specific_price WHERE id_product = '355' 28/01/2023 09:59:29 am >> SELECT document_num FROM ps_document WHERE document_num = '297' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 09:59: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' , '297' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 28/01/2023 09:59: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 = '80568' 28/01/2023 09:59:29 am >> DELETE FROM ps_document_detail WHERE id_document = '80568' 28/01/2023 09:59: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 ( '80568' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 28/01/2023 10:02:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831548960' AND id_product != '12868' AND ean13 != '' 28/01/2023 10:02:47 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831548960', date_upd = NOW() WHERE id_product = '12868' 28/01/2023 10:02:47 am >> UPDATE ps_product_lang SET name = 'GIOCANDO SCOPRIAMO L\'ANNO LITURGICO', description = '' WHERE id_product = '12868' 28/01/2023 10:02:47 am >> UPDATE ps_product SET wholesale_price = '3.02', on_sale = '0', price = '4.5000' WHERE id_product = '12868' 28/01/2023 10:02:47 am >> UPDATE ps_product_shop SET wholesale_price = '3.02', price = '4.5000', id_tax_rules_group = '4', id_category_default = '27', 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 = '12868' 28/01/2023 10:02:47 am >> DELETE FROM ps_specific_price WHERE id_product = '12868' 28/01/2023 10:03:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831524650' AND id_product != '4411' AND ean13 != '' 28/01/2023 10:03:04 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831524650', date_upd = NOW() WHERE id_product = '4411' 28/01/2023 10:03:04 am >> UPDATE ps_product_lang SET name = 'GESÙ CRISTO FIGLIO DI DIO - POSTER', description = '' WHERE id_product = '4411' 28/01/2023 10:03:04 am >> UPDATE ps_product SET wholesale_price = '1.21', on_sale = '0', price = '1.8000' WHERE id_product = '4411' 28/01/2023 10:03:05 am >> UPDATE ps_product_shop SET wholesale_price = '1.21', price = '1.8000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4411' 28/01/2023 10:03:05 am >> DELETE FROM ps_specific_price WHERE id_product = '4411' 28/01/2023 10:03:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067842' AND id_product != '19421' AND ean13 != '' 28/01/2023 10:03:24 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788801067842', date_upd = NOW() WHERE id_product = '19421' 28/01/2023 10:03:24 am >> UPDATE ps_product_lang SET name = 'DIO CON NOI - POSTER', description = '' WHERE id_product = '19421' 28/01/2023 10:03:24 am >> UPDATE ps_product SET wholesale_price = '1.24', on_sale = '0', price = '1.9000' WHERE id_product = '19421' 28/01/2023 10:03:24 am >> UPDATE ps_product_shop SET wholesale_price = '1.24', price = '1.9000', id_tax_rules_group = '4', id_category_default = '19', 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 = '19421' 28/01/2023 10:03:24 am >> DELETE FROM ps_specific_price WHERE id_product = '19421' 28/01/2023 10:03:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067248' AND id_product != '17585' AND ean13 != '' 28/01/2023 10:03:38 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788801067248', date_upd = NOW() WHERE id_product = '17585' 28/01/2023 10:03:38 am >> UPDATE ps_product_lang SET name = 'RUOTA DELLA S. MESSA - POSTER', description = '' WHERE id_product = '17585' 28/01/2023 10:03:38 am >> UPDATE ps_product SET wholesale_price = '0.65', on_sale = '0', price = '1.0000' WHERE id_product = '17585' 28/01/2023 10:03:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.65', price = '1.0000', id_tax_rules_group = '4', id_category_default = '19', 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 = '17585' 28/01/2023 10:03:38 am >> DELETE FROM ps_specific_price WHERE id_product = '17585' 28/01/2023 10:03:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831520416' AND id_product != '9300' AND ean13 != '' 28/01/2023 10:03:52 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831520416', date_upd = NOW() WHERE id_product = '9300' 28/01/2023 10:03:52 am >> UPDATE ps_product_lang SET name = 'SACRAMENTI - R. LUPI - POSTER', description = '' WHERE id_product = '9300' 28/01/2023 10:03:52 am >> UPDATE ps_product SET wholesale_price = '1.47', on_sale = '0', price = '2.2000' WHERE id_product = '9300' 28/01/2023 10:03:52 am >> UPDATE ps_product_shop SET wholesale_price = '1.47', price = '2.2000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9300' 28/01/2023 10:03:52 am >> DELETE FROM ps_specific_price WHERE id_product = '9300' 28/01/2023 10:04:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831520423' AND id_product != '9742' AND ean13 != '' 28/01/2023 10:04:10 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831520423', date_upd = NOW() WHERE id_product = '9742' 28/01/2023 10:04:10 am >> UPDATE ps_product_lang SET name = 'SCHEMA DEI VANGELI ', description = '' WHERE id_product = '9742' 28/01/2023 10:04:10 am >> UPDATE ps_product SET wholesale_price = '1.21', on_sale = '0', price = '1.8000' WHERE id_product = '9742' 28/01/2023 10:04:10 am >> UPDATE ps_product_shop SET wholesale_price = '1.21', price = '1.8000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9742' 28/01/2023 10:04:10 am >> DELETE FROM ps_specific_price WHERE id_product = '9742' 28/01/2023 10:04:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067446' AND id_product != '18116' AND ean13 != '' 28/01/2023 10:04:27 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788801067446', date_upd = NOW() WHERE id_product = '18116' 28/01/2023 10:04:27 am >> UPDATE ps_product_lang SET name = 'HO INCONTRATO GESU\' - POSTER', description = '' WHERE id_product = '18116' 28/01/2023 10:04:27 am >> UPDATE ps_product SET wholesale_price = '1.24', on_sale = '0', price = '1.9000' WHERE id_product = '18116' 28/01/2023 10:04:27 am >> UPDATE ps_product_shop SET wholesale_price = '1.24', price = '1.9000', id_tax_rules_group = '4', id_category_default = '19', 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 = '18116' 28/01/2023 10:04:27 am >> DELETE FROM ps_specific_price WHERE id_product = '18116' 28/01/2023 10:04:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831532372' AND id_product != '10623' AND ean13 != '' 28/01/2023 10:04:49 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831532372', date_upd = NOW() WHERE id_product = '10623' 28/01/2023 10:04:49 am >> UPDATE ps_product_lang SET name = 'TESTIMONI DI GEOVA - POSTER', description = '' WHERE id_product = '10623' 28/01/2023 10:04:49 am >> UPDATE ps_product SET wholesale_price = '1.34', on_sale = '0', price = '2.0000' WHERE id_product = '10623' 28/01/2023 10:04:49 am >> UPDATE ps_product_shop SET wholesale_price = '1.34', price = '2.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10623' 28/01/2023 10:04:49 am >> DELETE FROM ps_specific_price WHERE id_product = '10623' 28/01/2023 10:05:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062786' AND id_product != '11957' AND ean13 != '' 28/01/2023 10:05:04 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788801062786', date_upd = NOW() WHERE id_product = '11957' 28/01/2023 10:05:04 am >> UPDATE ps_product_lang SET name = 'RAGAZZI E L\'EUCARISTIA', description = '' WHERE id_product = '11957' 28/01/2023 10:05:04 am >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '2.0000' WHERE id_product = '11957' 28/01/2023 10:05:04 am >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '2.0000', id_tax_rules_group = '4', id_category_default = '19', 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 = '11957' 28/01/2023 10:05:04 am >> DELETE FROM ps_specific_price WHERE id_product = '11957' 28/01/2023 10:08:49 am >> SELECT document_num FROM ps_document WHERE document_num = '298' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 10:08:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '298' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.40' , '125.58' , NOW() , NOW() ) 28/01/2023 10:08:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80569' 28/01/2023 10:08:49 am >> DELETE FROM ps_document_detail WHERE id_document = '80569' 28/01/2023 10:08: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 ( '80569' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '3.5' , '3.5' , '0' , '0' , '14.00' ) 28/01/2023 10:08: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 ( '80569' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 28/01/2023 10:08: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 ( '80569' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 28/01/2023 10:08: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 ( '80569' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 28/01/2023 10:11:44 am >> SELECT document_num FROM ps_document WHERE document_num = '299' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 10:11:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '299' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 28/01/2023 10:11:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80570' 28/01/2023 10:11:44 am >> DELETE FROM ps_document_detail WHERE id_document = '80570' 28/01/2023 10:11:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80570' , '19432' , 'QUADRO DECORATO 35X25 - R35' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 28/01/2023 10:15:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831529501' AND id_product != '11400' AND ean13 != '' 28/01/2023 10:15:52 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831529501', date_upd = NOW() WHERE id_product = '11400' 28/01/2023 10:15:52 am >> UPDATE ps_product_lang SET name = 'VIRTÙ TEOLOGALI ', description = '' WHERE id_product = '11400' 28/01/2023 10:15:52 am >> UPDATE ps_product SET wholesale_price = '1.21', on_sale = '0', price = '1.8000' WHERE id_product = '11400' 28/01/2023 10:15:52 am >> UPDATE ps_product_shop SET wholesale_price = '1.21', price = '1.8000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11400' 28/01/2023 10:15:52 am >> DELETE FROM ps_specific_price WHERE id_product = '11400' 28/01/2023 10:16:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831526913' AND id_product != '3510' AND ean13 != '' 28/01/2023 10:16:08 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831526913', date_upd = NOW() WHERE id_product = '3510' 28/01/2023 10:16:08 am >> UPDATE ps_product_lang SET name = 'DIO PADRE - POSTER', description = '' WHERE id_product = '3510' 28/01/2023 10:16:08 am >> UPDATE ps_product SET wholesale_price = '1.21', on_sale = '0', price = '1.8000' WHERE id_product = '3510' 28/01/2023 10:16:08 am >> UPDATE ps_product_shop SET wholesale_price = '1.21', price = '1.8000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3510' 28/01/2023 10:16:08 am >> DELETE FROM ps_specific_price WHERE id_product = '3510' 28/01/2023 10:16:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831535397' AND id_product != '6228' AND ean13 != '' 28/01/2023 10:16:21 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831535397', date_upd = NOW() WHERE id_product = '6228' 28/01/2023 10:16:21 am >> UPDATE ps_product_lang SET name = 'MARIA DI NAZARET - POSTER', description = '' WHERE id_product = '6228' 28/01/2023 10:16:21 am >> UPDATE ps_product SET wholesale_price = '1.34', on_sale = '0', price = '2.0000' WHERE id_product = '6228' 28/01/2023 10:16:21 am >> UPDATE ps_product_shop SET wholesale_price = '1.34', price = '2.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6228' 28/01/2023 10:16:21 am >> DELETE FROM ps_specific_price WHERE id_product = '6228' 28/01/2023 10:16:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831535380' AND id_product != '9316' AND ean13 != '' 28/01/2023 10:16:35 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831535380', date_upd = NOW() WHERE id_product = '9316' 28/01/2023 10:16:35 am >> UPDATE ps_product_lang SET name = 'SACRAMENTO DELLA CONFERMAZIONE - POSTER', description = '' WHERE id_product = '9316' 28/01/2023 10:16:35 am >> UPDATE ps_product SET wholesale_price = '1.34', on_sale = '0', price = '2.0000' WHERE id_product = '9316' 28/01/2023 10:16:35 am >> UPDATE ps_product_shop SET wholesale_price = '1.34', price = '2.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9316' 28/01/2023 10:16:35 am >> DELETE FROM ps_specific_price WHERE id_product = '9316' 28/01/2023 10:16:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831545242' AND id_product != '10731' AND ean13 != '' 28/01/2023 10:16:55 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831545242', date_upd = NOW() WHERE id_product = '10731' 28/01/2023 10:16:55 am >> UPDATE ps_product_lang SET name = 'TRIDUO PASQUALE - POSTER', description = '' WHERE id_product = '10731' 28/01/2023 10:16:55 am >> UPDATE ps_product SET wholesale_price = '1.68', on_sale = '0', price = '2.5000' WHERE id_product = '10731' 28/01/2023 10:16:55 am >> UPDATE ps_product_shop SET wholesale_price = '1.68', price = '2.5000', id_tax_rules_group = '4', id_category_default = '27', 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 = '10731' 28/01/2023 10:16:55 am >> DELETE FROM ps_specific_price WHERE id_product = '10731' 28/01/2023 10:17:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831548236' AND id_product != '14805' AND ean13 != '' 28/01/2023 10:17:11 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831548236', date_upd = NOW() WHERE id_product = '14805' 28/01/2023 10:17:11 am >> UPDATE ps_product_lang SET name = 'BATTESIMO - POSTER', description = '' WHERE id_product = '14805' 28/01/2023 10:17:11 am >> UPDATE ps_product SET wholesale_price = '2.01', on_sale = '0', price = '3.0000' WHERE id_product = '14805' 28/01/2023 10:17:11 am >> UPDATE ps_product_shop SET wholesale_price = '2.01', price = '3.0000', id_tax_rules_group = '4', id_category_default = '27', 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 = '14805' 28/01/2023 10:17:11 am >> DELETE FROM ps_specific_price WHERE id_product = '14805' 28/01/2023 10:17:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831531269' AND id_product != '9321' AND ean13 != '' 28/01/2023 10:17:28 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831531269', date_upd = NOW() WHERE id_product = '9321' 28/01/2023 10:17:28 am >> UPDATE ps_product_lang SET name = 'SACRAMENTO DELLA RICONCILIAZIONE - POSTER', description = '' WHERE id_product = '9321' 28/01/2023 10:17:28 am >> UPDATE ps_product SET wholesale_price = '1.21', on_sale = '0', price = '1.8000' WHERE id_product = '9321' 28/01/2023 10:17:28 am >> UPDATE ps_product_shop SET wholesale_price = '1.21', price = '1.8000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9321' 28/01/2023 10:17:28 am >> DELETE FROM ps_specific_price WHERE id_product = '9321' 28/01/2023 10:17:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831529518' AND id_product != '3965' AND ean13 != '' 28/01/2023 10:17:41 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831529518', date_upd = NOW() WHERE id_product = '3965' 28/01/2023 10:17:41 am >> UPDATE ps_product_lang SET name = 'EUCARISTIA CORPO DI CRISTO - POSTER', description = '' WHERE id_product = '3965' 28/01/2023 10:17:41 am >> UPDATE ps_product SET wholesale_price = '1.34', on_sale = '0', price = '2.0000' WHERE id_product = '3965' 28/01/2023 10:17:41 am >> UPDATE ps_product_shop SET wholesale_price = '1.34', price = '2.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3965' 28/01/2023 10:17:41 am >> DELETE FROM ps_specific_price WHERE id_product = '3965' 28/01/2023 10:19:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870123' AND id_product != '19931' AND ean13 != '' 28/01/2023 10:19:39 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788892870123', date_upd = NOW() WHERE id_product = '19931' 28/01/2023 10:19:39 am >> UPDATE ps_product_lang SET name = '100 IDEE PER IL CATECHISMO', description = '' WHERE id_product = '19931' 28/01/2023 10:19:39 am >> UPDATE ps_product SET wholesale_price = '10.43', on_sale = '0', price = '14.9000' WHERE id_product = '19931' 28/01/2023 10:19:39 am >> UPDATE ps_product_shop SET wholesale_price = '10.43', price = '14.9000', 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 = '19931' 28/01/2023 10:19:39 am >> DELETE FROM ps_specific_price WHERE id_product = '19931' 28/01/2023 10:19:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870185' AND id_product != '20104' AND ean13 != '' 28/01/2023 10:19:50 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788892870185', date_upd = NOW() WHERE id_product = '20104' 28/01/2023 10:19:50 am >> UPDATE ps_product_lang SET name = 'BIBBIA DA COLORARE', description = '' WHERE id_product = '20104' 28/01/2023 10:19:50 am >> UPDATE ps_product SET wholesale_price = '6.93', on_sale = '0', price = '9.9000' WHERE id_product = '20104' 28/01/2023 10:19:50 am >> UPDATE ps_product_shop SET wholesale_price = '6.93', price = '9.9000', 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 = '20104' 28/01/2023 10:19:50 am >> DELETE FROM ps_specific_price WHERE id_product = '20104' 28/01/2023 10:20:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870130' AND id_product != '19932' AND ean13 != '' 28/01/2023 10:20:01 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788892870130', date_upd = NOW() WHERE id_product = '19932' 28/01/2023 10:20:01 am >> UPDATE ps_product_lang SET name = '100 IDEE PER IL CATECHISMO 2', description = '' WHERE id_product = '19932' 28/01/2023 10:20:01 am >> UPDATE ps_product SET wholesale_price = '10.43', on_sale = '0', price = '14.9000' WHERE id_product = '19932' 28/01/2023 10:20:01 am >> UPDATE ps_product_shop SET wholesale_price = '10.43', price = '14.9000', 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 = '19932' 28/01/2023 10:20:01 am >> DELETE FROM ps_specific_price WHERE id_product = '19932' 28/01/2023 10:20:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801064612' AND id_product != '14691' AND ean13 != '' 28/01/2023 10:20:12 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788801064612', date_upd = NOW() WHERE id_product = '14691' 28/01/2023 10:20:12 am >> UPDATE ps_product_lang SET name = 'INTORNO A UNA STORIA', description = '' WHERE id_product = '14691' 28/01/2023 10:20:12 am >> UPDATE ps_product SET wholesale_price = '9.69', on_sale = '0', price = '14.9000' WHERE id_product = '14691' 28/01/2023 10:20:12 am >> UPDATE ps_product_shop SET wholesale_price = '9.69', price = '14.9000', id_tax_rules_group = '4', id_category_default = '19', 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 = '14691' 28/01/2023 10:20:12 am >> DELETE FROM ps_specific_price WHERE id_product = '14691' 28/01/2023 10:20:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245235' AND id_product != '3622' AND ean13 != '' 28/01/2023 10:20:22 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861245235', date_upd = NOW() WHERE id_product = '3622' 28/01/2023 10:20:22 am >> UPDATE ps_product_lang SET name = 'DOMENICHE DA COLORARE - ANNO B', description = '' WHERE id_product = '3622' 28/01/2023 10:20:22 am >> UPDATE ps_product SET wholesale_price = '4.13', on_sale = '0', price = '5.9000' WHERE id_product = '3622' 28/01/2023 10:20:22 am >> UPDATE ps_product_shop SET wholesale_price = '4.13', price = '5.9000', 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 = '3622' 28/01/2023 10:20:22 am >> DELETE FROM ps_specific_price WHERE id_product = '3622' 28/01/2023 10:20:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245891' AND id_product != '3623' AND ean13 != '' 28/01/2023 10:20:33 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861245891', date_upd = NOW() WHERE id_product = '3623' 28/01/2023 10:20:33 am >> UPDATE ps_product_lang SET name = 'DOMENICHE DA COLORARE - ANNO C', description = '' WHERE id_product = '3623' 28/01/2023 10:20:33 am >> UPDATE ps_product SET wholesale_price = '4.83', on_sale = '0', price = '6.9000' WHERE id_product = '3623' 28/01/2023 10:20:33 am >> UPDATE ps_product_shop SET wholesale_price = '4.83', price = '6.9000', 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 = '3623' 28/01/2023 10:20:33 am >> DELETE FROM ps_specific_price WHERE id_product = '3623' 28/01/2023 10:20:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861243798' AND id_product != '11440' AND ean13 != '' 28/01/2023 10:20:43 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861243798', date_upd = NOW() WHERE id_product = '11440' 28/01/2023 10:20:43 am >> UPDATE ps_product_lang SET name = 'VITA DI GESÙ DA COLORARE', description = '' WHERE id_product = '11440' 28/01/2023 10:20:43 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '11440' 28/01/2023 10:20:43 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', 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 = '11440' 28/01/2023 10:20:43 am >> DELETE FROM ps_specific_price WHERE id_product = '11440' 28/01/2023 10:26:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801059922' AND id_product != '5148' AND ean13 != '' 28/01/2023 10:26:39 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788801059922', date_upd = NOW() WHERE id_product = '5148' 28/01/2023 10:26:39 am >> UPDATE ps_product_lang SET name = 'IN CAMMINO CON NOSTRO FIGLIO NELLA COMUNITÀ CRISTIANA', description = '' WHERE id_product = '5148' 28/01/2023 10:26:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.0000' WHERE id_product = '5148' 28/01/2023 10:26:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '242', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5148' 28/01/2023 10:26:39 am >> DELETE FROM ps_specific_price WHERE id_product = '5148' 28/01/2023 10:26:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062502' AND id_product != '4348' AND ean13 != '' 28/01/2023 10:26:51 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788801062502', date_upd = NOW() WHERE id_product = '4348' 28/01/2023 10:26:51 am >> UPDATE ps_product_lang SET name = 'GENITORI E NONNI', description = '' WHERE id_product = '4348' 28/01/2023 10:26:51 am >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '2.0000' WHERE id_product = '4348' 28/01/2023 10:26:51 am >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '2.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4348' 28/01/2023 10:26:51 am >> DELETE FROM ps_specific_price WHERE id_product = '4348' 28/01/2023 10:27:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8017009004047' AND id_product != '11541' AND ean13 != '' 28/01/2023 10:27:06 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '8017009004047', date_upd = NOW() WHERE id_product = '11541' 28/01/2023 10:27:06 am >> UPDATE ps_product_lang SET name = 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO - PER ANIMATORI E CATECHISTI', description = '' WHERE id_product = '11541' 28/01/2023 10:27:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.3900' WHERE id_product = '11541' 28/01/2023 10:27:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.3900', id_tax_rules_group = '1', id_category_default = '19', id_argoment_default = '48', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11541' 28/01/2023 10:27:06 am >> DELETE FROM ps_specific_price WHERE id_product = '11541' 28/01/2023 10:27:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801057515' AND id_product != '9683' AND ean13 != '' 28/01/2023 10:27:23 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788801057515', date_upd = NOW() WHERE id_product = '9683' 28/01/2023 10:27:23 am >> UPDATE ps_product_lang SET name = 'SARÒ PADRINO, SARÒ MADRINA - A. FONTANA', description = '' WHERE id_product = '9683' 28/01/2023 10:27:23 am >> UPDATE ps_product SET wholesale_price = '1.53', on_sale = '0', price = '2.5000' WHERE id_product = '9683' 28/01/2023 10:27:23 am >> UPDATE ps_product_shop SET wholesale_price = '1.53', price = '2.5000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9683' 28/01/2023 10:27:23 am >> DELETE FROM ps_specific_price WHERE id_product = '9683' 28/01/2023 10:28:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571215' AND id_product != '14241' AND ean13 != '' 28/01/2023 10:28:09 am >> UPDATE ps_product SET id_supplier = '7', reference = '4/4', ean13 = '9788867571215', date_upd = NOW() WHERE id_product = '14241' 28/01/2023 10:28:09 am >> UPDATE ps_product_lang SET name = 'BATTESIMO', description = '' WHERE id_product = '14241' 28/01/2023 10:28:09 am >> UPDATE ps_product SET wholesale_price = '1.40', on_sale = '0', price = '2.0000' WHERE id_product = '14241' 28/01/2023 10:28:09 am >> UPDATE ps_product_shop SET wholesale_price = '1.40', price = '2.0000', id_tax_rules_group = '4', id_category_default = '51', 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 = '14241' 28/01/2023 10:28:09 am >> DELETE FROM ps_specific_price WHERE id_product = '14241' 28/01/2023 10:31:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801006872' AND id_product != '11540' AND ean13 != '' 28/01/2023 10:31:29 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788801006872', date_upd = NOW() WHERE id_product = '11540' 28/01/2023 10:31:29 am >> UPDATE ps_product_lang SET name = 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO', description = '' WHERE id_product = '11540' 28/01/2023 10:31:29 am >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '2.0000' WHERE id_product = '11540' 28/01/2023 10:31:29 am >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '2.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11540' 28/01/2023 10:31:29 am >> DELETE FROM ps_specific_price WHERE id_product = '11540' 28/01/2023 10:31:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831540506' AND id_product != '9008' AND ean13 != '' 28/01/2023 10:31:48 am >> UPDATE ps_product SET id_supplier = '7', reference = '14', ean13 = '9788831540506', date_upd = NOW() WHERE id_product = '9008' 28/01/2023 10:31:48 am >> UPDATE ps_product_lang SET name = 'RITO DEL BATTESIMO - GUIDA PER GENITORI, PADRINI', description = '' WHERE id_product = '9008' 28/01/2023 10:31:48 am >> UPDATE ps_product SET wholesale_price = '2.35', on_sale = '0', price = '3.5000' WHERE id_product = '9008' 28/01/2023 10:31:48 am >> UPDATE ps_product_shop SET wholesale_price = '2.35', price = '3.5000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9008' 28/01/2023 10:31:48 am >> DELETE FROM ps_specific_price WHERE id_product = '9008' 28/01/2023 10:32:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062526' AND id_product != '11377' AND ean13 != '' 28/01/2023 10:32:56 am >> UPDATE ps_product SET id_supplier = '', reference = '2/1', ean13 = '9788801062526', date_upd = NOW() WHERE id_product = '11377' 28/01/2023 10:32:56 am >> UPDATE ps_product_lang SET name = 'VIENI SPIRITO SANTO', description = '' WHERE id_product = '11377' 28/01/2023 10:32:56 am >> UPDATE ps_product SET wholesale_price = '1.95', on_sale = '0', price = '3.0000' WHERE id_product = '11377' 28/01/2023 10:32:56 am >> UPDATE ps_product_shop SET wholesale_price = '1.95', price = '3.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11377' 28/01/2023 10:32:56 am >> DELETE FROM ps_specific_price WHERE id_product = '11377' 28/01/2023 10:33:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801062519' AND id_product != '11515' AND ean13 != '' 28/01/2023 10:33:14 am >> UPDATE ps_product SET id_supplier = '', reference = '2/1', ean13 = '9788801062519', date_upd = NOW() WHERE id_product = '11515' 28/01/2023 10:33:14 am >> UPDATE ps_product_lang SET name = 'VIVI PER AMORE - MONS. G. CAVALLOTTO', description = '' WHERE id_product = '11515' 28/01/2023 10:33:14 am >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '2.0000' WHERE id_product = '11515' 28/01/2023 10:33:14 am >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '2.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11515' 28/01/2023 10:33:14 am >> DELETE FROM ps_specific_price WHERE id_product = '11515' 28/01/2023 10:35:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801033960' AND id_product != '6691' AND ean13 != '' 28/01/2023 10:35:57 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/2', ean13 = '9788801033960', date_upd = NOW() WHERE id_product = '6691' 28/01/2023 10:35:57 am >> UPDATE ps_product_lang SET name = 'MIO BATTESIMO', description = '' WHERE id_product = '6691' 28/01/2023 10:35:57 am >> UPDATE ps_product SET wholesale_price = '1.24', on_sale = '0', price = '1.9000' WHERE id_product = '6691' 28/01/2023 10:35:57 am >> UPDATE ps_product_shop SET wholesale_price = '1.24', price = '1.9000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6691' 28/01/2023 10:35:57 am >> DELETE FROM ps_specific_price WHERE id_product = '6691' 28/01/2023 10:46:45 am >> SELECT document_num FROM ps_document WHERE document_num = '300' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 10:46: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' , '300' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.40' , '30.04' , NOW() , NOW() ) 28/01/2023 10:46: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 = '80571' 28/01/2023 10:46:45 am >> DELETE FROM ps_document_detail WHERE id_document = '80571' 28/01/2023 10:46: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 ( '80571' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 28/01/2023 10:46: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 ( '80571' , '15912' , 'QUADRETTO EFFFETTO PIETRA MAD. NODI - 2952/M251' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 28/01/2023 10:46: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 ( '80571' , '18648' , 'MADRE DI DIO - CD' , '1' , '-1' , '1' , '11.90' , '9.7540983606557' , '22' , '0' , '11.90' ) 28/01/2023 10:46: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 ( '80571' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/01/2023 10:46: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 ( '80571' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 28/01/2023 10:50:27 am >> SELECT document_num FROM ps_document WHERE document_num = '301' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 10:50:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '301' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 28/01/2023 10:50:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80572' 28/01/2023 10:50:27 am >> DELETE FROM ps_document_detail WHERE id_document = '80572' 28/01/2023 10:50:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80572' , '5975' , 'LUCERNA COLORATA - 1491' , '2' , '-2' , '1' , '21' , '17.213114754098' , '22' , '0' , '42.00' ) 28/01/2023 10:50:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80572' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/01/2023 11:17:15 am >> SELECT document_num FROM ps_document WHERE document_num = '302' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 11:17:15 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' , '302' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '39.00' , NOW() , NOW() ) 28/01/2023 11:17:15 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 = '80573' 28/01/2023 11:17:15 am >> DELETE FROM ps_document_detail WHERE id_document = '80573' 28/01/2023 11:17:15 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 ( '80573' , '3720' , 'DOVE SEI GESÙ? - M. GENISIO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 28/01/2023 11:17:15 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 ( '80573' , '20208' , 'SEGNI DELLA MESSA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 28/01/2023 11:17:15 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 ( '80573' , '20211' , 'COME E FATTA UNA CHIESA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 28/01/2023 11:17:15 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 ( '80573' , '18551' , 'IO CREDO' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/01/2023 11:17:15 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 ( '80573' , '14558' , 'CONOSCI LA STORIA DELLA SALVEZZA - GUIDA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 28/01/2023 11:17:15 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 ( '80573' , '14559' , 'CONOSCI LA STORIA DELLA SALVEZZA - QUADERNO' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 28/01/2023 11:17:15 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 ( '80573' , '20435' , 'BIBBIA E IL TESORO NASCOSTO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 28/01/2023 11:17:15 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 ( '80573' , '15982' , 'ANTICO TESTAMENTO - 1° ANNO' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 28/01/2023 11:17:15 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 ( '80573' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '1.91' , '1.91' , '0' , '0' , '1.91' ) 28/01/2023 11:24:20 am >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 11:24:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '303' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.00' , '108.87' , NOW() , NOW() ) 28/01/2023 11:24:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80574' 28/01/2023 11:24:20 am >> DELETE FROM ps_document_detail WHERE id_document = '80574' 28/01/2023 11:24:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80574' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '78.35' , '64.22131147541' , '22' , '0' , '78.35' ) 28/01/2023 11:24:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80574' , '20632' , 'MESSA MEDITAZIONE - MAR/APR 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/01/2023 11:24:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80574' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/01/2023 11:24:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80574' , '19221' , 'POSSESSIONE DIABOLICA - M. LANZA' , '1' , '-1' , '4' , '29.00' , '29' , '0' , '5' , '27.55' ) 28/01/2023 11:32:59 am >> SELECT document_num FROM ps_document WHERE document_num = '304' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 11:32:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '304' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 28/01/2023 11:32:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80575' 28/01/2023 11:32:59 am >> DELETE FROM ps_document_detail WHERE id_document = '80575' 28/01/2023 11:32:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80575' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 28/01/2023 11:32:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80575' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 28/01/2023 11:34:27 am >> SELECT document_num FROM ps_document WHERE document_num = '305' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 11:34:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '305' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 28/01/2023 11:34:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80576' 28/01/2023 11:34:27 am >> DELETE FROM ps_document_detail WHERE id_document = '80576' 28/01/2023 11:34:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80576' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 28/01/2023 11:38:47 am >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '80490' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-24') 28/01/2023 11:38:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '242', document_date = '2023-01-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '570.00', price_tax_excluded = '478.81', date_upd = NOW() WHERE id_document = '80490' 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80490' 28/01/2023 11:38:47 am >> DELETE FROM ps_document_detail WHERE id_document = '80490' 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '1914' , 'CERA DELLA LITURGIA' , '46' , '-46' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '207.00' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '0.9800' , '0.98' , '0' , '0' , '0.98' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '14001' , 'PAROLE GESTI SILENZI DELLA MESSA - C. MAGNOLI' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 28/01/2023 11:38:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '9.9300' , '8.1393442622951' , '22' , '0' , '9.93' ) 28/01/2023 11:38: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 ( '80490' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 28/01/2023 11:38: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 ( '80490' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '1' , '-1' , '1' , '25.3' , '20.737704918033' , '22' , '0' , '25.30' ) 28/01/2023 12:02:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '306' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 12:02:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '306' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 28/01/2023 12:02:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80577' 28/01/2023 12:02:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '80577' 28/01/2023 12:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80577' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 28/01/2023 12:17:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-28') 28/01/2023 12:17:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '307' , '2023-01-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.20' , '72.20' , NOW() , NOW() ) 28/01/2023 12:17:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80578' 28/01/2023 12:17:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '80578' 28/01/2023 12:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80578' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '2' , '-2' , '4' , '38.00' , '38' , '0' , '5' , '72.20' ) 28/01/2023 12:35:05 pm >> DELETE FROM ps_document WHERE id_document = '80454' 28/01/2023 12:35:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '80454'