22/02/2023 08:27:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '623644' , '2023-02-20' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.57' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.79' , '88.41' , NOW() , NOW() ) 22/02/2023 08:27:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81450' 22/02/2023 08:27:57 am >> DELETE FROM ps_document_detail WHERE id_document = '81450' 22/02/2023 08:27:57 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 ( '81450' , '20762' , 'ABBIAMO VISTO IL SIGNORE - CD' , '1' , '1' , '1' , '12.29' , '10.073770491803' , '22' , '30' , '10.4957' ) 22/02/2023 08:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20762' AND id_supplier = '7' 22/02/2023 08:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20762' , '7' , '1' ) 22/02/2023 08:27:57 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 ( '81450' , '20763' , 'ABBIAMO VISTO IL SIGNORE - SPARTITO' , '1' , '1' , '3' , '17.3' , '16.634615384615' , '4' , '30' , '12.5944' ) 22/02/2023 08:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20763' AND id_supplier = '7' 22/02/2023 08:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20763' , '7' , '1' ) 22/02/2023 08:27:57 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 ( '81450' , '14643' , 'ISAIA - G.DELLORTO' , '1' , '1' , '4' , '29.00' , '29' , '0' , '30' , '20.3000' ) 22/02/2023 08:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '14643' AND id_supplier = '7' 22/02/2023 08:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14643' , '7' , '1' ) 22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81450' , '12809' , 'SEDOTTI DALLA PAROLA - P. SCALABRINI' , '1' , '1' , '4' , '24.00' , '24' , '0' , '35' , '15.6000' ) 22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '12809' AND id_supplier = '7' 22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12809' , '7' , '1' ) 22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81450' , '13039' , 'LIBRO DEL BEBE - ROSA' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '35' , '5.5250' ) 22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '13039' AND id_supplier = '7' 22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13039' , '7' , '1' ) 22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81450' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20237' AND id_supplier = '7' 22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20237' , '7' , '1' ) 22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81450' , '20751' , 'QUARESIMA OMELIE BENEDETTO XVI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20751' AND id_supplier = '7' 22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20751' , '7' , '1' ) 22/02/2023 08:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81450' , '13882' , 'GAUDETE ET EXSULTATE' , '1' , '1' , '4' , '2.00' , '2' , '0' , '35' , '1.3000' ) 22/02/2023 08:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '13882' AND id_supplier = '7' 22/02/2023 08:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13882' , '7' , '1' ) 22/02/2023 08:53:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801048827' AND id_product != '4535' AND ean13 != '' 22/02/2023 08:53:09 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/3', ean13 = '9788801048827', date_upd = NOW() WHERE id_product = '4535' 22/02/2023 08:53:09 am >> UPDATE ps_product_lang SET name = 'GIOCA E COLORA - IO SONO II', description = '' WHERE id_product = '4535' 22/02/2023 08:53:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0000' WHERE id_product = '4535' 22/02/2023 08:53:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '56', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4535' 22/02/2023 08:53:09 am >> DELETE FROM ps_specific_price WHERE id_product = '4535' 22/02/2023 08:53:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861080379' AND id_product != '14326' AND ean13 != '' 22/02/2023 08:53:34 am >> UPDATE ps_product SET id_supplier = '107', reference = '2/3', ean13 = '9788861080379', date_upd = NOW() WHERE id_product = '14326' 22/02/2023 08:53:34 am >> UPDATE ps_product_lang SET name = 'RELIGIOCANDO - GESU\' BAMBINO', description = '' WHERE id_product = '14326' 22/02/2023 08:53:34 am >> UPDATE ps_product SET wholesale_price = '1.63', on_sale = '0', price = '2.5000' WHERE id_product = '14326' 22/02/2023 08:53:34 am >> UPDATE ps_product_shop SET wholesale_price = '1.63', price = '2.5000', id_tax_rules_group = '4', id_category_default = '15', 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 = '14326' 22/02/2023 08:53:34 am >> DELETE FROM ps_specific_price WHERE id_product = '14326' 22/02/2023 09:19:21 am >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '81297' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-09') 22/02/2023 09:19:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2023-02-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'OSP. S. LEONARDO', note = 'OSP. S. LEONARDO', 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 = '47.00', price_tax_excluded = '42.13', date_upd = NOW() WHERE id_document = '81297' 22/02/2023 09:19:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81297' 22/02/2023 09:19:21 am >> DELETE FROM ps_document_detail WHERE id_document = '81297' 22/02/2023 09:19:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 22/02/2023 09:19:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '' , '22/02' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 22/02/2023 09:19:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '18223' , 'CORONA MISSIONARIA - R102' , '12' , '-12' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '12.00' ) 22/02/2023 09:19:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.00' , '2' , '0' , '0' , '20.00' ) 22/02/2023 09:19:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 22/02/2023 09:41:11 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '3975' 22/02/2023 09:41:11 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '3975' 22/02/2023 09:47:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571047' AND id_product != '14492' AND ean13 != '' 22/02/2023 09:47:47 am >> UPDATE ps_product SET id_supplier = '127', reference = 'ESPOSITORE', ean13 = '9788899571047', date_upd = NOW() WHERE id_product = '14492' 22/02/2023 09:47:47 am >> UPDATE ps_product_lang SET name = 'SACRAMENTI SPIEGATI AI RAGAZZI - BATTESIMO', description = '' WHERE id_product = '14492' 22/02/2023 09:47:47 am >> UPDATE ps_product SET wholesale_price = '0.98', on_sale = '0', price = '1.5000' WHERE id_product = '14492' 22/02/2023 09:47:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.98', price = '1.5000', id_tax_rules_group = '4', id_category_default = '37', 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 = '14492' 22/02/2023 09:47:47 am >> DELETE FROM ps_specific_price WHERE id_product = '14492' 22/02/2023 09:55:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688948' AND id_product != '15251' AND ean13 != '' 22/02/2023 09:55:28 am >> UPDATE ps_product SET id_supplier = '127', reference = '2/3', ean13 = '9788887688948', date_upd = NOW() WHERE id_product = '15251' 22/02/2023 09:55:28 am >> UPDATE ps_product_lang SET name = 'FATE QUESTO IN MEMORIA DI ME', description = '' WHERE id_product = '15251' 22/02/2023 09:55:28 am >> UPDATE ps_product SET wholesale_price = '1.63', on_sale = '0', price = '2.5000' WHERE id_product = '15251' 22/02/2023 09:55:28 am >> UPDATE ps_product_shop SET wholesale_price = '1.63', price = '2.5000', id_tax_rules_group = '4', id_category_default = '37', 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 = '15251' 22/02/2023 09:55:28 am >> DELETE FROM ps_specific_price WHERE id_product = '15251' 22/02/2023 10:01:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801052305' AND id_product != '4253' AND ean13 != '' 22/02/2023 10:01:26 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788801052305', date_upd = NOW() WHERE id_product = '4253' 22/02/2023 10:01:26 am >> UPDATE ps_product_lang SET name = 'FORZA PIÙ GRANDE - GUGLIELMONI/NEGRI', description = '' WHERE id_product = '4253' 22/02/2023 10:01:26 am >> UPDATE ps_product SET wholesale_price = '5.53', on_sale = '0', price = '8.5000' WHERE id_product = '4253' 22/02/2023 10:01:26 am >> UPDATE ps_product_shop SET wholesale_price = '5.53', price = '8.5000', id_tax_rules_group = '4', id_category_default = '19', 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 = '4253' 22/02/2023 10:01:26 am >> DELETE FROM ps_specific_price WHERE id_product = '4253' 22/02/2023 10:04:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118023742' AND id_product != '9844' AND ean13 != '' 22/02/2023 10:04:33 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '8019118023742', date_upd = NOW() WHERE id_product = '9844' 22/02/2023 10:04:33 am >> UPDATE ps_product_lang SET name = 'SEI L\'AMICO CHE PERDONA', description = '' WHERE id_product = '9844' 22/02/2023 10:04:33 am >> UPDATE ps_product SET wholesale_price = '6.59', on_sale = '0', price = '9.4262' WHERE id_product = '9844' 22/02/2023 10:04:33 am >> UPDATE ps_product_shop SET wholesale_price = '6.59', price = '9.4262', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9844' 22/02/2023 10:04:33 am >> DELETE FROM ps_specific_price WHERE id_product = '9844' 22/02/2023 10:04:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868944094' AND id_product != '19025' AND ean13 != '' 22/02/2023 10:04:48 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/4', ean13 = '9788868944094', date_upd = NOW() WHERE id_product = '19025' 22/02/2023 10:04:48 am >> UPDATE ps_product_lang SET name = 'ORA ANDIAMO!', description = '' WHERE id_product = '19025' 22/02/2023 10:04:48 am >> UPDATE ps_product SET wholesale_price = '5.60', on_sale = '0', price = '8.0000' WHERE id_product = '19025' 22/02/2023 10:04:48 am >> UPDATE ps_product_shop SET wholesale_price = '5.60', price = '8.0000', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '244', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19025' 22/02/2023 10:04:48 am >> DELETE FROM ps_specific_price WHERE id_product = '19025' 22/02/2023 10:05:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868944629' AND id_product != '19026' AND ean13 != '' 22/02/2023 10:05:00 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/4', ean13 = '9788868944629', date_upd = NOW() WHERE id_product = '19026' 22/02/2023 10:05:00 am >> UPDATE ps_product_lang SET name = 'BELLEZZA INVISIBILE AGLI OCCHI', description = '' WHERE id_product = '19026' 22/02/2023 10:05:00 am >> UPDATE ps_product SET wholesale_price = '6.30', on_sale = '0', price = '9.0000' WHERE id_product = '19026' 22/02/2023 10:05:00 am >> UPDATE ps_product_shop SET wholesale_price = '6.30', price = '9.0000', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '244', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19026' 22/02/2023 10:05:00 am >> DELETE FROM ps_specific_price WHERE id_product = '19026' 22/02/2023 10:07:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801063158' AND id_product != '12625' AND ean13 != '' 22/02/2023 10:07:38 am >> UPDATE ps_product SET id_supplier = '', reference = '2/3', ean13 = '9788801063158', date_upd = NOW() WHERE id_product = '12625' 22/02/2023 10:07:38 am >> UPDATE ps_product_lang SET name = 'COLORIAMO LA NOSTRA MESSA', description = '' WHERE id_product = '12625' 22/02/2023 10:07:38 am >> UPDATE ps_product SET wholesale_price = '2.54', on_sale = '0', price = '3.9000' WHERE id_product = '12625' 22/02/2023 10:07:38 am >> UPDATE ps_product_shop SET wholesale_price = '2.54', price = '3.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 = '12625' 22/02/2023 10:07:38 am >> DELETE FROM ps_specific_price WHERE id_product = '12625' 22/02/2023 10:08:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801049954' AND id_product != '5249' AND ean13 != '' 22/02/2023 10:08:12 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/4', ean13 = '9788801049954', date_upd = NOW() WHERE id_product = '5249' 22/02/2023 10:08:12 am >> UPDATE ps_product_lang SET name = 'INCONTRI DI GIOIA - GUIDA', description = '' WHERE id_product = '5249' 22/02/2023 10:08:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.0000' WHERE id_product = '5249' 22/02/2023 10:08:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '56', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5249' 22/02/2023 10:08:12 am >> DELETE FROM ps_specific_price WHERE id_product = '5249' 22/02/2023 10:37:18 am >> SELECT document_num FROM ps_document WHERE document_num = '583' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 10:37:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '583' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.02' , '114.77' , NOW() , NOW() ) 22/02/2023 10:37:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81451' 22/02/2023 10:37:18 am >> DELETE FROM ps_document_detail WHERE id_document = '81451' 22/02/2023 10:37:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81451' , '14020' , 'BALZA CON RICAMO IN ORO' , '3.3' , '-3.3' , '1' , '42.43' , '34.77868852459' , '22' , '0' , '140.02' ) 22/02/2023 10:54:05 am >> SELECT document_num FROM ps_document WHERE document_num = '584' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 10:54:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '584' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/02/2023 10:54:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81452' 22/02/2023 10:54:05 am >> DELETE FROM ps_document_detail WHERE id_document = '81452' 22/02/2023 10:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81452' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/02/2023 10:57:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801058345' AND id_product != '4850' AND ean13 != '' 22/02/2023 10:58:00 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788801058345', date_upd = NOW() WHERE id_product = '4850' 22/02/2023 10:58:00 am >> UPDATE ps_product_lang SET name = 'ICEBERG E LA DUNA - B. FERRERO', description = '' WHERE id_product = '4850' 22/02/2023 10:58:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.0000' WHERE id_product = '4850' 22/02/2023 10:58:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4850' 22/02/2023 10:58:00 am >> DELETE FROM ps_specific_price WHERE id_product = '4850' 22/02/2023 10:58:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869295652' AND id_product != '17597' AND ean13 != '' 22/02/2023 10:58:48 am >> UPDATE ps_product SET id_supplier = '109', reference = '1/5', ean13 = '9788869295652', date_upd = NOW() WHERE id_product = '17597' 22/02/2023 10:58:48 am >> UPDATE ps_product_lang SET name = 'SALMI NEL CANTO DELL\'AMORE - SPARTITO', description = '' WHERE id_product = '17597' 22/02/2023 10:58:48 am >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '10.0000' WHERE id_product = '17597' 22/02/2023 10:58:48 am >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '10.0000', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17597' 22/02/2023 10:58:48 am >> DELETE FROM ps_specific_price WHERE id_product = '17597' 22/02/2023 10:59:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298776' AND id_product != '20489' AND ean13 != '' 22/02/2023 10:59:12 am >> UPDATE ps_product SET id_supplier = '109', reference = '1/5', ean13 = '9788869298776', date_upd = NOW() WHERE id_product = '20489' 22/02/2023 10:59:12 am >> UPDATE ps_product_lang SET name = 'SALMI NEL CANTO L\'AMORE - M. VERSACI', description = '' WHERE id_product = '20489' 22/02/2023 10:59:12 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '20489' 22/02/2023 10:59:12 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20489' 22/02/2023 10:59:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20489' 22/02/2023 10:59:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869298776' AND id_product != '20489' AND ean13 != '' 22/02/2023 10:59:22 am >> UPDATE ps_product SET id_supplier = '109', reference = '1/5', ean13 = '9788869298776', date_upd = NOW() WHERE id_product = '20489' 22/02/2023 10:59:22 am >> UPDATE ps_product_lang SET name = 'SALMI NEL CANTO L\'AMORE - M. VERSACI', description = '' WHERE id_product = '20489' 22/02/2023 10:59:22 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '20489' 22/02/2023 10:59:22 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20489' 22/02/2023 10:59:22 am >> DELETE FROM ps_specific_price WHERE id_product = '20489' 22/02/2023 11:00:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983929' AND id_product != '18718' AND ean13 != '' 22/02/2023 11:00:06 am >> UPDATE ps_product SET id_supplier = '53', reference = '1/5', ean13 = '9788895983929', date_upd = NOW() WHERE id_product = '18718' 22/02/2023 11:00:06 am >> UPDATE ps_product_lang SET name = 'TUA VOCE IN ME + CD - FRA F. MARIA REA', description = '' WHERE id_product = '18718' 22/02/2023 11:00:06 am >> UPDATE ps_product SET wholesale_price = '3.60', on_sale = '0', price = '15.0000' WHERE id_product = '18718' 22/02/2023 11:00:06 am >> UPDATE ps_product_shop SET wholesale_price = '3.60', price = '15.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '66', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18718' 22/02/2023 11:00:06 am >> DELETE FROM ps_specific_price WHERE id_product = '18718' 22/02/2023 11:00:06 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '18718' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 22/02/2023 11:01:04 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '990' 22/02/2023 11:01:04 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '990' 22/02/2023 11:02:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736062' AND id_product != '19562' AND ean13 != '' 22/02/2023 11:02:08 am >> UPDATE ps_product SET id_supplier = '53', reference = 'GONDOLA 1', ean13 = '9791280736062', date_upd = NOW() WHERE id_product = '19562' 22/02/2023 11:02:08 am >> UPDATE ps_product_lang SET name = 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ', description = '

\"Dalla testimonianza di Cesare de Bus Paolo VI ricavò i tratti essenziali del vero catechista: essere l\'uomo della Bibbia e l\'uomo della Chiesa, ansioso di trasmettere la vera dottrina di Cristo. Sullo stile e sul metodo particolare di fare catechesi di san Cesare de Bus in questo libro ci si sofferma doverosamente, nel quadro generale della sua figura e del suo tempo, nonché del suo cammino spirituale. Questo libro ci aiuta a conoscerlo e ad amarlo e c\'incoraggia a imitarlo.\" Marcello Card. Semeraro

' WHERE id_product = '19562' 22/02/2023 11:02:08 am >> UPDATE ps_product SET wholesale_price = '2.67', on_sale = '0', price = '20.0000' WHERE id_product = '19562' 22/02/2023 11:02:08 am >> UPDATE ps_product_shop SET wholesale_price = '2.67', price = '20.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '226', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19562' 22/02/2023 11:02:08 am >> DELETE FROM ps_specific_price WHERE id_product = '19562' 22/02/2023 11:02:08 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '19562' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 22/02/2023 11:02:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736062' AND id_product != '19562' AND ean13 != '' 22/02/2023 11:02:17 am >> UPDATE ps_product SET id_supplier = '53', reference = 'GONDOLA 1', ean13 = '9791280736062', date_upd = NOW() WHERE id_product = '19562' 22/02/2023 11:02:17 am >> UPDATE ps_product_lang SET name = 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ', description = '

\"Dalla testimonianza di Cesare de Bus Paolo VI ricavò i tratti essenziali del vero catechista: essere l\'uomo della Bibbia e l\'uomo della Chiesa, ansioso di trasmettere la vera dottrina di Cristo. Sullo stile e sul metodo particolare di fare catechesi di san Cesare de Bus in questo libro ci si sofferma doverosamente, nel quadro generale della sua figura e del suo tempo, nonché del suo cammino spirituale. Questo libro ci aiuta a conoscerlo e ad amarlo e c\'incoraggia a imitarlo.\" Marcello Card. Semeraro

' WHERE id_product = '19562' 22/02/2023 11:02:17 am >> UPDATE ps_product SET wholesale_price = '2.67', on_sale = '0', price = '20.0000' WHERE id_product = '19562' 22/02/2023 11:02:17 am >> UPDATE ps_product_shop SET wholesale_price = '2.67', price = '20.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '226', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19562' 22/02/2023 11:02:17 am >> DELETE FROM ps_specific_price WHERE id_product = '19562' 22/02/2023 11:02:17 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '19562' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 22/02/2023 11:07:38 am >> SELECT document_num FROM ps_document WHERE document_num = '585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 11:07:38 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' , '585' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '86.54' , NOW() , NOW() ) 22/02/2023 11:07:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81453' 22/02/2023 11:07:38 am >> DELETE FROM ps_document_detail WHERE id_document = '81453' 22/02/2023 11:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81453' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 22/02/2023 11:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81453' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 22/02/2023 11:09:11 am >> SELECT document_num FROM ps_document WHERE document_num = '586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 11:09:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '586' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 22/02/2023 11:09:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81454' 22/02/2023 11:09:11 am >> DELETE FROM ps_document_detail WHERE id_document = '81454' 22/02/2023 11:09:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81454' , '6809' , 'MOCCOLO 60X165' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 22/02/2023 11:19:08 am >> SELECT document_num FROM ps_document WHERE document_num = '587' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 11:19:08 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' , '587' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '13.63' , NOW() , NOW() ) 22/02/2023 11:19:08 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 = '81455' 22/02/2023 11:19:08 am >> DELETE FROM ps_document_detail WHERE id_document = '81455' 22/02/2023 11:19:08 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 ( '81455' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 22/02/2023 11:19:08 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 ( '81455' , '6962' , 'NELLA CASA DEL DEFUNTO' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '0' , '4.50' ) 22/02/2023 11:25:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066630' AND id_product != '17632' AND ean13 != '' 22/02/2023 11:25:51 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788801066630', date_upd = NOW() WHERE id_product = '17632' 22/02/2023 11:25:51 am >> UPDATE ps_product_lang SET name = 'FUORI DAL CORO - P. PELLEGRINO', description = '' WHERE id_product = '17632' 22/02/2023 11:25:51 am >> UPDATE ps_product SET wholesale_price = '2.60', on_sale = '0', price = '4.0000' WHERE id_product = '17632' 22/02/2023 11:25:51 am >> UPDATE ps_product_shop SET wholesale_price = '2.60', price = '4.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 = '17632' 22/02/2023 11:25:51 am >> DELETE FROM ps_specific_price WHERE id_product = '17632' 22/02/2023 11:26:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066630' AND id_product != '17632' AND ean13 != '' 22/02/2023 11:26:15 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788801066630', date_upd = NOW() WHERE id_product = '17632' 22/02/2023 11:26:15 am >> UPDATE ps_product_lang SET name = 'FUORI DAL CORO - P. PELLEGRINO', description = '' WHERE id_product = '17632' 22/02/2023 11:26:15 am >> UPDATE ps_product SET wholesale_price = '2.60', on_sale = '0', price = '4.0000' WHERE id_product = '17632' 22/02/2023 11:26:15 am >> UPDATE ps_product_shop SET wholesale_price = '2.60', price = '4.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 = '17632' 22/02/2023 11:26:15 am >> DELETE FROM ps_specific_price WHERE id_product = '17632' 22/02/2023 11:26:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882275365' AND id_product != '16530' AND ean13 != '' 22/02/2023 11:26:32 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/5', ean13 = '9788882275365', date_upd = NOW() WHERE id_product = '16530' 22/02/2023 11:26:32 am >> UPDATE ps_product_lang SET name = 'MESSA DI BOSE', description = '' WHERE id_product = '16530' 22/02/2023 11:26:32 am >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '16530' 22/02/2023 11:26:32 am >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '248', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16530' 22/02/2023 11:26:32 am >> DELETE FROM ps_specific_price WHERE id_product = '16530' 22/02/2023 11:26:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882275365' AND id_product != '16530' AND ean13 != '' 22/02/2023 11:26:43 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/5', ean13 = '9788882275365', date_upd = NOW() WHERE id_product = '16530' 22/02/2023 11:26:43 am >> UPDATE ps_product_lang SET name = 'MESSA DI BOSE', description = '' WHERE id_product = '16530' 22/02/2023 11:26:43 am >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '16530' 22/02/2023 11:26:43 am >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '248', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16530' 22/02/2023 11:26:43 am >> DELETE FROM ps_specific_price WHERE id_product = '16530' 22/02/2023 11:49:43 am >> SELECT document_num FROM ps_document WHERE document_num = '588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 11:49:43 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' , '588' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 22/02/2023 11:49:43 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 = '81456' 22/02/2023 11:49:43 am >> DELETE FROM ps_document_detail WHERE id_document = '81456' 22/02/2023 11:49:43 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 ( '81456' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 22/02/2023 11:54:09 am >> SELECT document_num FROM ps_document WHERE document_num = '589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 11:54:09 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' , '589' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 22/02/2023 11:54:09 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 = '81457' 22/02/2023 11:54:09 am >> DELETE FROM ps_document_detail WHERE id_document = '81457' 22/02/2023 11:54:09 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 ( '81457' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '5' , '42.75' ) 22/02/2023 11:57:11 am >> SELECT document_num FROM ps_document WHERE document_num = '590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 11:57:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '590' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 22/02/2023 11:57:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81458' 22/02/2023 11:57:11 am >> DELETE FROM ps_document_detail WHERE id_document = '81458' 22/02/2023 11:57:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81458' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 22/02/2023 12:27:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810820650' AND id_product != '1146' AND ean13 != '' 22/02/2023 12:27:13 pm >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810820650', date_upd = NOW() WHERE id_product = '1146' 22/02/2023 12:27:13 pm >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME X OCCASIONI ', description = '' WHERE id_product = '1146' 22/02/2023 12:27:13 pm >> UPDATE ps_product SET wholesale_price = '24.64', on_sale = '0', price = '45' WHERE id_product = '1146' 22/02/2023 12:27:13 pm >> UPDATE ps_product_shop SET wholesale_price = '24.64', price = '45', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1146' 22/02/2023 12:27:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '1146' 22/02/2023 12:27:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '589' AND id_document != '81457' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 12:27:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '589', document_date = '2023-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.75', price_tax_excluded = '42.75', date_upd = NOW() WHERE id_document = '81457' 22/02/2023 12:27:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81457' 22/02/2023 12:27:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '81457' 22/02/2023 12:27:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81457' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '5' , '42.75' ) 22/02/2023 12:36:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '591' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 12:36:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '591' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 22/02/2023 12:36:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81459' 22/02/2023 12:36:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '81459' 22/02/2023 12:36:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81459' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 22/02/2023 12:55:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '592' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 12:55:30 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' , '592' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/02/2023 12:55:30 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 = '81460' 22/02/2023 12:55:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '81460' 22/02/2023 12:55:30 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 ( '81460' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/02/2023 02:32:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '586' AND id_document != '81454' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 02:32:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '586', document_date = '2023-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '81454' 22/02/2023 02:32:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81454' 22/02/2023 02:32:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '81454' 22/02/2023 02:32:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81454' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 22/02/2023 03:57:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '593' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 03:57:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '593' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.40' , '13.40' , NOW() , NOW() ) 22/02/2023 03:57:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81461' 22/02/2023 03:57:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '81461' 22/02/2023 03:57:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81461' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 22/02/2023 03:57:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81461' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 22/02/2023 03:57:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81461' , '20774' , 'messaggio per la quaresima 2023' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 22/02/2023 04:27:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '594' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 04:27:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '594' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 22/02/2023 04:27:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81462' 22/02/2023 04:27:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '81462' 22/02/2023 04:27:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81462' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 22/02/2023 04:27:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81462' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 22/02/2023 05:58:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608037' AND id_product != '20774' AND ean13 != '' 22/02/2023 05:58:23 pm >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9788826608037', date_upd = NOW() WHERE id_product = '20774' 22/02/2023 05:58:23 pm >> UPDATE ps_product_lang SET name = 'MESSAGGIO PER LA QUARESIMA 2023', description = '' WHERE id_product = '20774' 22/02/2023 05:58:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.0000' WHERE id_product = '20774' 22/02/2023 05:58:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20774' 22/02/2023 05:58:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '20774' 22/02/2023 06:49:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 22/02/2023 06:49:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '595' , '2023-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.41' , '16.35' , NOW() , NOW() ) 22/02/2023 06:49:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81463' 22/02/2023 06:49:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '81463' 22/02/2023 06:49:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81463' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 22/02/2023 06:49:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81463' , '17748' , 'SEGNALIBRO - PR 349' , '1' , '-1' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '0.35' )