20/09/2024 09:29:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/09/2024 09:29:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22935' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:29:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22935' , '1' , '1' , '2' , NOW() , NOW() ) 20/09/2024 09:29:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22935' , '0' , '1' , '0' , '0' ) 20/09/2024 09:30:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837237882' AND id_product != '22935' AND ean13 != '' 20/09/2024 09:30:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788837237882', date_upd = NOW() WHERE id_product = '22935' 20/09/2024 09:30:01 am >> UPDATE ps_product_lang SET name = 'DIPLOMAZIA DELLA SPERANZA - E. FATTORINI', description = '' WHERE id_product = '22935' 20/09/2024 09:30:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '22935' 20/09/2024 09:30:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '161', 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 = '22935' 20/09/2024 09:30:01 am >> DELETE FROM ps_specific_price WHERE id_product = '22935' 20/09/2024 09:30:04 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22935' 20/09/2024 09:30:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22936' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:30:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22936' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22935' 20/09/2024 09:30:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22936' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22935' 20/09/2024 09:30:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788815387646' AND id_product != '22936' AND ean13 != '' 20/09/2024 09:30:38 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788815387646', date_upd = NOW() WHERE id_product = '22936' 20/09/2024 09:30:38 am >> UPDATE ps_product_lang SET name = 'STORIA DELLA DEMOCRAZIA CRISTIANA', description = '' WHERE id_product = '22936' 20/09/2024 09:30:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38' WHERE id_product = '22936' 20/09/2024 09:30:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38', id_tax_rules_group = '4', id_category_default = '364', 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 = '22936' 20/09/2024 09:30:38 am >> DELETE FROM ps_specific_price WHERE id_product = '22936' 20/09/2024 09:30:39 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22936' 20/09/2024 09:30:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22937' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:30:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22937' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22936' 20/09/2024 09:30:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22937' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22936' 20/09/2024 09:32: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 ( '33' , '1451737' , '2024-09-18' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , 'ARRIVATI ALTRI 8 TITOLI RESI SUBITO AL DISTRIBUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.00' , '63.00' , NOW() , NOW() ) 20/09/2024 09:32: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 = '93215' 20/09/2024 09:32:38 am >> DELETE FROM ps_document_detail WHERE id_document = '93215' 20/09/2024 09:32: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 ( '93215' , '22936' , 'STORIA DELLA DEMOCRAZIA CRISTIANA' , '1' , '1' , '4' , '38.00' , '38' , '0' , '0' , '38.00' ) 20/09/2024 09:32:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22936' AND id_supplier = '177' 20/09/2024 09:32:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22936' , '177' , '1' ) 20/09/2024 09:32: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 ( '93215' , '22935' , 'DIPLOMAZIA DELLA SPERANZA - E. FATTORINI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 20/09/2024 09:32:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22935' AND id_supplier = '177' 20/09/2024 09:32:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22935' , '177' , '1' ) 20/09/2024 09:43:38 am >> SELECT document_num FROM ps_document WHERE document_num = '118' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 09:43: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 ( '21' , '118' , '2024-09-20' , '' , '1738' , '0' , '4679089' , 'VIA VECCHIO 4 92020 CAMASTRA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.46' , '36.46' , NOW() , NOW() ) 20/09/2024 09:43: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 = '93216' 20/09/2024 09:43:38 am >> DELETE FROM ps_document_detail WHERE id_document = '93216' 20/09/2024 09:43: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 ( '93216' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '14' , '-14' , '4' , '2.40' , '2.4' , '0' , '15' , '28.56' ) 20/09/2024 09:43: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 ( '93216' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 09:48:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457360' AND id_product != '22937' AND ean13 != '' 20/09/2024 09:48:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457360', date_upd = NOW() WHERE id_product = '22937' 20/09/2024 09:48:27 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - DIC 2024', description = '' WHERE id_product = '22937' 20/09/2024 09:48:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '22937' 20/09/2024 09:48:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22937' 20/09/2024 09:48:27 am >> DELETE FROM ps_specific_price WHERE id_product = '22937' 20/09/2024 09:48:27 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22937' 20/09/2024 09:48:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22938' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:48:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22938' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22937' 20/09/2024 09:48:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22938' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22937' 20/09/2024 09:48:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457483' AND id_product != '22938' AND ean13 != '' 20/09/2024 09:48:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457483', date_upd = NOW() WHERE id_product = '22938' 20/09/2024 09:48:47 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - DIC 2024', description = '' WHERE id_product = '22938' 20/09/2024 09:48:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '22938' 20/09/2024 09:48:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22938' 20/09/2024 09:48:47 am >> DELETE FROM ps_specific_price WHERE id_product = '22938' 20/09/2024 09:48:48 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22938' 20/09/2024 09:48:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22939' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:48:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22939' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22938' 20/09/2024 09:48:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22939' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22938' 20/09/2024 09:49:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245761' AND id_product != '22939' AND ean13 != '' 20/09/2024 09:49:51 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788892245761', date_upd = NOW() WHERE id_product = '22939' 20/09/2024 09:49:51 am >> UPDATE ps_product_lang SET name = 'AI PIEDI DI MARIA', description = '' WHERE id_product = '22939' 20/09/2024 09:49:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '22939' 20/09/2024 09:49:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22939' 20/09/2024 09:49:51 am >> DELETE FROM ps_specific_price WHERE id_product = '22939' 20/09/2024 09:49:52 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22939' 20/09/2024 09:49:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22940' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:49:52 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22940' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22939' 20/09/2024 09:49:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22940' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22939' 20/09/2024 09:50:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245273' AND id_product != '22940' AND ean13 != '' 20/09/2024 09:50:27 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788892245273', date_upd = NOW() WHERE id_product = '22940' 20/09/2024 09:50:27 am >> UPDATE ps_product_lang SET name = 'SALTERIO CORALE - N.E', description = '' WHERE id_product = '22940' 20/09/2024 09:50:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22940' 20/09/2024 09:50:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', 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 = '22940' 20/09/2024 09:50:27 am >> DELETE FROM ps_specific_price WHERE id_product = '22940' 20/09/2024 09:50:29 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22940' 20/09/2024 09:50:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22941' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:50:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22941' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22940' 20/09/2024 09:50:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22941' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22940' 20/09/2024 09:51:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788880713531' AND id_product != '22941' AND ean13 != '' 20/09/2024 09:51:35 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788880713531', date_upd = NOW() WHERE id_product = '22941' 20/09/2024 09:51:35 am >> UPDATE ps_product_lang SET name = 'VOLTI DI DIO - AAVV', description = '' WHERE id_product = '22941' 20/09/2024 09:51:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22941' 20/09/2024 09:51:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '52', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22941' 20/09/2024 09:51:35 am >> DELETE FROM ps_specific_price WHERE id_product = '22941' 20/09/2024 09:51:36 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22941' 20/09/2024 09:51:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22942' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:51:36 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22942' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22941' 20/09/2024 09:51:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22942' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22941' 20/09/2024 09:52:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465091' AND id_product != '22942' AND ean13 != '' 20/09/2024 09:52:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281465091', date_upd = NOW() WHERE id_product = '22942' 20/09/2024 09:52:21 am >> UPDATE ps_product_lang SET name = 'PENSIERI EUCARISTICI 2025', description = '' WHERE id_product = '22942' 20/09/2024 09:52:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '22942' 20/09/2024 09:52:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22942' 20/09/2024 09:52:21 am >> DELETE FROM ps_specific_price WHERE id_product = '22942' 20/09/2024 09:52:23 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22942' 20/09/2024 09:52:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22943' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:52:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22943' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22942' 20/09/2024 09:52:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22943' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22942' 20/09/2024 09:52:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465107' AND id_product != '22943' AND ean13 != '' 20/09/2024 09:52:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281465107', date_upd = NOW() WHERE id_product = '22943' 20/09/2024 09:53:00 am >> UPDATE ps_product_lang SET name = 'AVVENTO 2024', description = '' WHERE id_product = '22943' 20/09/2024 09:53:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '22943' 20/09/2024 09:53:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '97', 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 = '22943' 20/09/2024 09:53:00 am >> DELETE FROM ps_specific_price WHERE id_product = '22943' 20/09/2024 09:53:01 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22943' 20/09/2024 09:53:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22944' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:53:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22944' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22943' 20/09/2024 09:53:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22944' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22943' 20/09/2024 09:54:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465114' AND id_product != '22944' AND ean13 != '' 20/09/2024 09:54:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281465114', date_upd = NOW() WHERE id_product = '22944' 20/09/2024 09:54:11 am >> UPDATE ps_product_lang SET name = 'SUI TUOI PASSI - ADORAZIONE', description = '' WHERE id_product = '22944' 20/09/2024 09:54:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.8' WHERE id_product = '22944' 20/09/2024 09:54:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.8', id_tax_rules_group = '4', id_category_default = '97', 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 = '22944' 20/09/2024 09:54:11 am >> DELETE FROM ps_specific_price WHERE id_product = '22944' 20/09/2024 09:54:12 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22944' 20/09/2024 09:54:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22945' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:54:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22945' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22944' 20/09/2024 09:54:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22945' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22944' 20/09/2024 09:55:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465084' AND id_product != '22945' AND ean13 != '' 20/09/2024 09:55:17 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9791281465084', date_upd = NOW() WHERE id_product = '22945' 20/09/2024 09:55:17 am >> UPDATE ps_product_lang SET name = 'E CHI E\' MIO PROSSIMO? - ANNO C - L. DELLA GIOVANNA', description = '' WHERE id_product = '22945' 20/09/2024 09:55:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22945' 20/09/2024 09:55:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22945' 20/09/2024 09:55:17 am >> DELETE FROM ps_specific_price WHERE id_product = '22945' 20/09/2024 09:55:18 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22945' 20/09/2024 09:55:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22946' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:55:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22946' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22945' 20/09/2024 09:55:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22946' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22945' 20/09/2024 09:56:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618138' AND id_product != '22946' AND ean13 != '' 20/09/2024 09:56:50 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791281618138', date_upd = NOW() WHERE id_product = '22946' 20/09/2024 09:56:50 am >> UPDATE ps_product_lang SET name = 'SPIRITO SANTO E I SUOI SETTE DONI - G. D\'AMORE', description = '' WHERE id_product = '22946' 20/09/2024 09:56:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22946' 20/09/2024 09:56:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '76', 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 = '22946' 20/09/2024 09:56:50 am >> DELETE FROM ps_specific_price WHERE id_product = '22946' 20/09/2024 09:56:51 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22946' 20/09/2024 09:56:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22947' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:56:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22947' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22946' 20/09/2024 09:56:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22947' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22946' 20/09/2024 09:57:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618138' AND id_product != '22946' AND ean13 != '' 20/09/2024 09:57:09 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281618138', date_upd = NOW() WHERE id_product = '22946' 20/09/2024 09:57:09 am >> UPDATE ps_product_lang SET name = 'SPIRITO SANTO E I SUOI SETTE DONI - G. D\'AMORE', description = '' WHERE id_product = '22946' 20/09/2024 09:57:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.0000' WHERE id_product = '22946' 20/09/2024 09:57:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.0000', id_tax_rules_group = '4', id_category_default = '76', 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 = '22946' 20/09/2024 09:57:09 am >> DELETE FROM ps_specific_price WHERE id_product = '22946' 20/09/2024 09:58:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8013147483904' AND id_product != '22947' AND ean13 != '' 20/09/2024 09:58:31 am >> UPDATE ps_product SET id_supplier = '', reference = '1/7', ean13 = '8013147483904', date_upd = NOW() WHERE id_product = '22947' 20/09/2024 09:58:31 am >> UPDATE ps_product_lang SET name = 'MADRE SOLEDAD - DVD', description = '' WHERE id_product = '22947' 20/09/2024 09:58:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '22947' 20/09/2024 09:58:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '30', 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 = '22947' 20/09/2024 09:58:31 am >> DELETE FROM ps_specific_price WHERE id_product = '22947' 20/09/2024 09:58:33 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22947' 20/09/2024 09:58:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22948' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 09:58:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22948' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22947' 20/09/2024 09:58:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22948' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22947' 20/09/2024 09:58:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8013147483904' AND id_product != '22947' AND ean13 != '' 20/09/2024 09:58:44 am >> UPDATE ps_product SET id_supplier = '', reference = '1/7', ean13 = '8013147483904', date_upd = NOW() WHERE id_product = '22947' 20/09/2024 09:58:44 am >> UPDATE ps_product_lang SET name = 'MADRE SOLEDAD - DVD', description = '' WHERE id_product = '22947' 20/09/2024 09:58:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.114754098360656' WHERE id_product = '22947' 20/09/2024 09:58:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '30', 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 = '22947' 20/09/2024 09:58:44 am >> DELETE FROM ps_specific_price WHERE id_product = '22947' 20/09/2024 10:00:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450206' AND id_product != '22948' AND ean13 != '' 20/09/2024 10:00:53 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA', ean13 = '9791256450206', date_upd = NOW() WHERE id_product = '22948' 20/09/2024 10:00:53 am >> UPDATE ps_product_lang SET name = 'PELLEGRINAGGIO SPIRITUALE ATTRAVERSO LA PORTA SANTA', description = '' WHERE id_product = '22948' 20/09/2024 10:00:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '22948' 20/09/2024 10:00:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '518', 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 = '22948' 20/09/2024 10:00:53 am >> DELETE FROM ps_specific_price WHERE id_product = '22948' 20/09/2024 10:00:54 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22948' 20/09/2024 10:00:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22949' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 10:00:54 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22949' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22948' 20/09/2024 10:00:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22949' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22948' 20/09/2024 10:01:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450237' AND id_product != '22949' AND ean13 != '' 20/09/2024 10:01:34 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA', ean13 = '9791256450237', date_upd = NOW() WHERE id_product = '22949' 20/09/2024 10:01:34 am >> UPDATE ps_product_lang SET name = 'IL GIUBILEO DEI RAGAZZI - L. PELLEGRINI', description = '' WHERE id_product = '22949' 20/09/2024 10:01:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '22949' 20/09/2024 10:01:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '518', 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 = '22949' 20/09/2024 10:01:34 am >> DELETE FROM ps_specific_price WHERE id_product = '22949' 20/09/2024 10:01:35 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22949' 20/09/2024 10:01:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22950' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 10:01:35 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22950' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22949' 20/09/2024 10:01:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22950' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22949' 20/09/2024 10:02:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248626' AND id_product != '22950' AND ean13 != '' 20/09/2024 10:02:20 am >> UPDATE ps_product SET id_supplier = '', reference = '4/1', ean13 = '9788884248626', date_upd = NOW() WHERE id_product = '22950' 20/09/2024 10:02:20 am >> UPDATE ps_product_lang SET name = 'PUZZLE ANGELICO', description = '' WHERE id_product = '22950' 20/09/2024 10:02:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '22950' 20/09/2024 10:02:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '83', 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 = '22950' 20/09/2024 10:02:20 am >> DELETE FROM ps_specific_price WHERE id_product = '22950' 20/09/2024 10:02:22 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22950' 20/09/2024 10:02:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22951' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 10:02:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22951' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22950' 20/09/2024 10:02:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22951' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22950' 20/09/2024 10:03:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839927989' AND id_product != '22951' AND ean13 != '' 20/09/2024 10:03:30 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788839927989', date_upd = NOW() WHERE id_product = '22951' 20/09/2024 10:03:30 am >> UPDATE ps_product_lang SET name = 'DA CUORE A CUORE - H. NOUWEN', description = '' WHERE id_product = '22951' 20/09/2024 10:03:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '22951' 20/09/2024 10:03:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '111', 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 = '22951' 20/09/2024 10:03:30 am >> DELETE FROM ps_specific_price WHERE id_product = '22951' 20/09/2024 10:03:31 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22951' 20/09/2024 10:03:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22952' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 10:03:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22952' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22951' 20/09/2024 10:03:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22952' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22951' 20/09/2024 10:03:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '674078' , '2024-09-16' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.25' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '151.89' , '150.55' , NOW() , NOW() ) 20/09/2024 10:03:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93217' 20/09/2024 10:03:58 am >> DELETE FROM ps_document_detail WHERE id_document = '93217' 20/09/2024 10:03: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 ( '93217' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '4' , '4' , '4' , '2.90' , '2.9' , '0' , '33' , '7.7720' ) 20/09/2024 10:03:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22937' AND id_supplier = '7' 20/09/2024 10:03:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22937' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22938' , 'INSIEME NELLA MESSA - DIC 2024' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 20/09/2024 10:03:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22938' AND id_supplier = '7' 20/09/2024 10:03:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22938' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22941' , 'VOLTI DI DIO - AAVV' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 20/09/2024 10:03:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22941' AND id_supplier = '7' 20/09/2024 10:03:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22941' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22942' , 'PENSIERI EUCARISTICI 2025' , '2' , '2' , '4' , '6.90' , '6.9' , '0' , '30' , '9.6600' ) 20/09/2024 10:03:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22942' AND id_supplier = '7' 20/09/2024 10:03:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22942' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22943' , 'AVVENTO 2024' , '12' , '12' , '4' , '3.50' , '3.5' , '0' , '30' , '29.4000' ) 20/09/2024 10:03:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22943' AND id_supplier = '7' 20/09/2024 10:03:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22943' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22943' , 'AVVENTO 2024' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '100' , '0.0000' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22943' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22943' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22944' , 'SUI TUOI PASSI - ADORAZIONE' , '3' , '3' , '4' , '3.80' , '3.8' , '0' , '30' , '7.9800' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22944' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22944' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22945' , 'E CHI E MIO PROSSIMO? - ANNO C - L. DELLA GIOVANNA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22945' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22945' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22946' , 'SPIRITO SANTO E I SUOI SETTE DONI - G. DAMORE' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22946' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22946' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22947' , 'MADRE SOLEDAD - DVD' , '1' , '1' , '1' , '8.11' , '6.6475409836066' , '22' , '25' , '7.4206' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22947' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22947' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22948' , 'PELLEGRINAGGIO SPIRITUALE ATTRAVERSO LA PORTA SANTA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '30' , '3.5000' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22948' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22948' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22949' , 'IL GIUBILEO DEI RAGAZZI - L. PELLEGRINI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '30' , '2.1000' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22949' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22949' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22950' , 'PUZZLE ANGELICO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22950' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22950' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22940' , 'SALTERIO CORALE - N.E' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22940' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22940' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22939' , 'AI PIEDI DI MARIA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22939' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22939' , '7' , '1' ) 20/09/2024 10:03: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 ( '93217' , '22951' , 'DA CUORE A CUORE - H. NOUWEN' , '1' , '1' , '4' , '8.00' , '8' , '0' , '30' , '5.6000' ) 20/09/2024 10:03:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22951' AND id_supplier = '7' 20/09/2024 10:03:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22951' , '7' , '1' ) 20/09/2024 10:07:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 20/09/2024 10:07:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '86.70', price_tax_excluded = '86.70', date_upd = NOW() WHERE id_document = '89846' 20/09/2024 10:07:24 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 = '89846' 20/09/2024 10:07:25 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22717' , 'PAROLA E PREGHIERA - SETT 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22768' , 'PAROLA E PREGHIERA - OTT 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22808' , 'GIONA - L. SANDRIN' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22825' , 'PAROLA E PREGHIERA - NOV 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '5929' , 'LODI E VESPRI' , '2' , '-2' , '4' , '4.5000' , '4.5' , '0' , '0' , '9.00' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22874' , 'PREGARE CON I SALMI - H. LONA' , '1' , '-1' , '4' , '21.0000' , '21' , '0' , '0' , '21.00' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 20/09/2024 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 10:29:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2742' AND id_document != '93212' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 20/09/2024 10:29:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2742', document_date = '2024-09-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '131.00', price_tax_excluded = '113.15', date_upd = NOW() WHERE id_document = '93212' 20/09/2024 10:29:54 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 = '93212' 20/09/2024 10:29:54 am >> DELETE FROM ps_document_detail WHERE id_document = '93212' 20/09/2024 10:29:54 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 ( '93212' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '99.0000' , '81.147540983607' , '22' , '0' , '99.00' ) 20/09/2024 10:29:54 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 ( '93212' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '32' , '32' , '0' , '0' , '32.00' ) 20/09/2024 10:31:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2355' AND id_document != '92732' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 20/09/2024 10:31:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2355', document_date = '2024-07-26', 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 = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '92732' 20/09/2024 10:31:13 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 = '92732' 20/09/2024 10:31:13 am >> DELETE FROM ps_document_detail WHERE id_document = '92732' 20/09/2024 10:31:13 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 ( '92732' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 20/09/2024 10:31:13 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 ( '92732' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '370' , '303.27868852459' , '22' , '0' , '370.00' ) 20/09/2024 10:31:13 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 ( '92732' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 20/09/2024 10:31:13 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 ( '92732' , '15133' , 'CAMICE IN CANAPA BIANCO' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 20/09/2024 10:31:13 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 ( '92732' , '19795' , 'STOLA IN ASSISI CON RICAMO - 633' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 20/09/2024 10:42:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000645' AND id_product != '1935' AND ean13 != '' 20/09/2024 10:42:22 am >> UPDATE ps_product SET id_supplier = '31', reference = '2014', ean13 = '000645', date_upd = NOW() WHERE id_product = '1935' 20/09/2024 10:42:22 am >> UPDATE ps_product_lang SET name = 'CERETTI DIAM 20X600 ART. 200', description = '' WHERE id_product = '1935' 20/09/2024 10:42:22 am >> UPDATE ps_product SET wholesale_price = '0.97', on_sale = '0', price = '1.8032786885245904' WHERE id_product = '1935' 20/09/2024 10:42:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.97', price = '1.8032786885245904', id_tax_rules_group = '1', id_category_default = '169', 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 = '1935' 20/09/2024 10:42:22 am >> DELETE FROM ps_specific_price WHERE id_product = '1935' 20/09/2024 10:44:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '24FVEN2652' , '2024-09-18' , '' , '0' , '31' , '2626' , 'ZONA IND.LE PIAN DI LAURA 56043 LORENZANA' , '' , 'TOTALE VERSATO PER ACCONTO VESTINE € 2305.86' , '0.01' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1525.77' , '1250.63' , NOW() , NOW() ) 20/09/2024 10:44:46 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 = '93218' 20/09/2024 10:44:46 am >> DELETE FROM ps_document_detail WHERE id_document = '93218' 20/09/2024 10:44:46 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 ( '93218' , '17160' , 'CARBONCINI ROSSI - CARRO' , '120' , '120' , '1' , '4.45' , '3.6475409836066' , '22' , '3' , '631.9356' ) 20/09/2024 10:44:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '31' 20/09/2024 10:44:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '31' , '1' ) 20/09/2024 10:44:46 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 ( '93218' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '120' , '120' , '1' , '1.93' , '1.5819672131148' , '22' , '50+3' , '137.0377' ) 20/09/2024 10:44:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '31' 20/09/2024 10:44:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '31' , '1' ) 20/09/2024 10:44:46 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 ( '93218' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '55' , '55' , '1' , '2.28' , '1.8688524590164' , '22' , '50+3' , '74.1992' ) 20/09/2024 10:44:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '13142' AND id_supplier = '31' 20/09/2024 10:44:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13142' , '31' , '1' ) 20/09/2024 10:44: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 ( '93218' , '15387' , 'VESTINA BATTESIMALE ' , '560' , '560' , '1' , '1.03' , '0.84426229508197' , '22' , '3' , '682.5851' ) 20/09/2024 10:44:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '31' 20/09/2024 10:44:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '31' , '1' ) 20/09/2024 10:46:10 am >> SELECT document_num FROM ps_document WHERE document_num = '118' AND id_document != '93216' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 10:46:10 am >> UPDATE ps_document SET id_document_type = '21', document_num = '118', document_date = '2024-09-20', document_letter = '', id_customer = '1738', id_supplier = '', id_address = '4679089', address1 = 'VIA VECCHIO 4 92020 CAMASTRA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '36.46', price_tax_excluded = '36.46', date_upd = NOW() WHERE id_document = '93216' 20/09/2024 10:46:10 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 = '93216' 20/09/2024 10:46:10 am >> DELETE FROM ps_document_detail WHERE id_document = '93216' 20/09/2024 10:46:10 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 ( '93216' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '14' , '-14' , '4' , '2.4000' , '2.4' , '0' , '15' , '28.56' ) 20/09/2024 10:46:10 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 ( '93216' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 10:51:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2745' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 10:51:14 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' , '2745' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 20/09/2024 10:51:14 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 = '93219' 20/09/2024 10:51:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93219' 20/09/2024 10:51:14 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 ( '93219' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 20/09/2024 10:51:14 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 ( '93219' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 20/09/2024 11:11:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2746' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 11:11: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' , '2746' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 20/09/2024 11:11: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 = '93220' 20/09/2024 11:11:38 am >> DELETE FROM ps_document_detail WHERE id_document = '93220' 20/09/2024 11:11: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 ( '93220' , '14031' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 20/09/2024 11:13:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2747' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 11:13:53 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' , '2747' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 20/09/2024 11:13:53 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 = '93221' 20/09/2024 11:13:53 am >> DELETE FROM ps_document_detail WHERE id_document = '93221' 20/09/2024 11:13:53 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 ( '93221' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 20/09/2024 11:17:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2748' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 11:17:32 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' , '2748' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 20/09/2024 11:17:32 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 = '93222' 20/09/2024 11:17:32 am >> DELETE FROM ps_document_detail WHERE id_document = '93222' 20/09/2024 11:17:32 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 ( '93222' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/09/2024 11:35:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 20/09/2024 11:35:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '83.80', price_tax_excluded = '83.80', date_upd = NOW() WHERE id_document = '89846' 20/09/2024 11:35: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 = '89846' 20/09/2024 11:35:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22717' , 'PAROLA E PREGHIERA - SETT 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22768' , 'PAROLA E PREGHIERA - OTT 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22808' , 'GIONA - L. SANDRIN' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22825' , 'PAROLA E PREGHIERA - NOV 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '5929' , 'LODI E VESPRI' , '2' , '-2' , '4' , '4.5000' , '4.5' , '0' , '0' , '9.00' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22874' , 'PREGARE CON I SALMI - H. LONA' , '1' , '-1' , '4' , '21.0000' , '21' , '0' , '0' , '21.00' ) 20/09/2024 11:35:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 20/09/2024 11:36:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 20/09/2024 11:36:02 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2.90', price_tax_excluded = '2.90', date_upd = NOW() WHERE id_document = '89846' 20/09/2024 11:36:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 20/09/2024 11:36:02 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 20/09/2024 11:36:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 20/09/2024 11:36:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2441' AND id_document != '92838' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-07') 20/09/2024 11:36:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2441', document_date = '2024-08-07', 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 = '21.85', price_tax_excluded = '21.85', date_upd = NOW() WHERE id_document = '92838' 20/09/2024 11:36:56 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 = '92838' 20/09/2024 11:36:56 am >> DELETE FROM ps_document_detail WHERE id_document = '92838' 20/09/2024 11:36:56 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 ( '92838' , '22808' , 'GIONA - L. SANDRIN' , '1' , '-1' , '4' , '12.35' , '12.35' , '0' , '0' , '12.35' ) 20/09/2024 11:36:56 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 ( '92838' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/09/2024 11:37:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2550' AND id_document != '92971' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-03') 20/09/2024 11:37:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2550', document_date = '2024-09-03', 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 = '318.78', price_tax_excluded = '269.78', date_upd = NOW() WHERE id_document = '92971' 20/09/2024 11:37: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 = '92971' 20/09/2024 11:37:45 am >> DELETE FROM ps_document_detail WHERE id_document = '92971' 20/09/2024 11:37: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 ( '92971' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 20/09/2024 11:37: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 ( '92971' , '1826' , 'CATECHISMO DELLA CHIESA CATTOLICA COMPENDIO' , '2' , '-2' , '4' , '6.5000' , '6.5' , '0' , '5' , '12.36' ) 20/09/2024 11:37: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 ( '92971' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 20/09/2024 11:37: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 ( '92971' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 20/09/2024 11:37: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 ( '92971' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 20/09/2024 11:37: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 ( '92971' , '22874' , 'PREGARE CON I SALMI - H. LONA' , '1' , '-1' , '4' , '21.00' , '21' , '0' , '0' , '21.00' ) 20/09/2024 11:38:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2525' AND id_document != '92938' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 20/09/2024 11:38:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2525', document_date = '2024-09-02', 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 = '35.00', price_tax_excluded = '35.00', date_upd = NOW() WHERE id_document = '92938' 20/09/2024 11:38: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 = '92938' 20/09/2024 11:38:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92938' 20/09/2024 11:38: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 ( '92938' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.0000' , '9' , '0' , '0' , '27.00' ) 20/09/2024 11:38: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 ( '92938' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 20/09/2024 11:38: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 ( '92938' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 20/09/2024 11:40:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2449' AND id_document != '92851' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-08') 20/09/2024 11:40:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2449', document_date = '2024-08-08', 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 = '90.00', price_tax_excluded = '81.50', date_upd = NOW() WHERE id_document = '92851' 20/09/2024 11:40: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 = '92851' 20/09/2024 11:40:11 am >> DELETE FROM ps_document_detail WHERE id_document = '92851' 20/09/2024 11:40: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 ( '92851' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 20/09/2024 11:40: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 ( '92851' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 20/09/2024 11:40: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 ( '92851' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 20/09/2024 11:40: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 ( '92851' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 20/09/2024 11:40: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 ( '92851' , '22448' , 'PREGHIERA DI MARIA - 7' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 20/09/2024 11:40: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 ( '92851' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 20/09/2024 11:40: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 ( '92851' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 20/09/2024 11:40: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 ( '92851' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.76' , '3.76' , '0' , '0' , '3.76' ) 20/09/2024 11:47:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2512' AND id_document != '92924' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-30') 20/09/2024 11:47:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2512', document_date = '2024-08-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '7.20', price_tax_excluded = '7.20', date_upd = NOW() WHERE id_document = '92924' 20/09/2024 11:47: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 = '92924' 20/09/2024 11:47:22 am >> DELETE FROM ps_document_detail WHERE id_document = '92924' 20/09/2024 11:47:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92924' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 20/09/2024 11:47:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92924' , '22717' , 'PAROLA E PREGHIERA - SETT 24' , '1' , '-1' , '4' , '2.1' , '2.1' , '0' , '0' , '2.10' ) 20/09/2024 11:47:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92924' , '22768' , 'PAROLA E PREGHIERA - OTT 24' , '1' , '-1' , '4' , '2.1' , '2.1' , '0' , '0' , '2.10' ) 20/09/2024 11:48:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2537' AND id_document != '92953' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 20/09/2024 11:48:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2537', document_date = '2024-09-02', 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 = '58.80', price_tax_excluded = '49.87', date_upd = NOW() WHERE id_document = '92953' 20/09/2024 11:48:23 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 = '92953' 20/09/2024 11:48:23 am >> DELETE FROM ps_document_detail WHERE id_document = '92953' 20/09/2024 11:48: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 ( '92953' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 20/09/2024 11:48: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 ( '92953' , '22825' , 'PAROLA E PREGHIERA - NOV 24' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 20/09/2024 11:48: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 ( '92953' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 20/09/2024 11:48: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 ( '92953' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 20/09/2024 11:48: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 ( '92953' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/09/2024 11:48: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 ( '92953' , '21180' , 'ROSARIO ARGENTO/EMATITE - 1498CAV' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 20/09/2024 11:48: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 ( '92953' , '16244' , 'QUADRO 10X10' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 20/09/2024 11:49:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2664' AND id_document != '93110' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-12') 20/09/2024 11:49:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2664', document_date = '2024-09-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.80', price_tax_excluded = '5.80', date_upd = NOW() WHERE id_document = '93110' 20/09/2024 11:49:17 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 = '93110' 20/09/2024 11:49:17 am >> DELETE FROM ps_document_detail WHERE id_document = '93110' 20/09/2024 11:49:17 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 ( '93110' , '9742' , 'SCHEMA DEI VANGELI ' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 20/09/2024 11:49:17 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 ( '93110' , '5929' , 'LODI E VESPRI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 20/09/2024 11:51:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2735' AND id_document != '93204' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 20/09/2024 11:51:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2735', document_date = '2024-09-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '46.20', price_tax_excluded = '41.23', date_upd = NOW() WHERE id_document = '93204' 20/09/2024 11:51:10 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 = '93204' 20/09/2024 11:51:10 am >> DELETE FROM ps_document_detail WHERE id_document = '93204' 20/09/2024 11:51:10 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 ( '93204' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/09/2024 11:51:10 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 ( '93204' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/09/2024 11:51:10 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 ( '93204' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 20/09/2024 11:51:10 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 ( '93204' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 20/09/2024 11:51:10 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 ( '93204' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 20/09/2024 11:51:10 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 ( '93204' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 20/09/2024 11:51:10 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 ( '93204' , '5929' , 'LODI E VESPRI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 20/09/2024 11:51:10 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 ( '93204' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 20/09/2024 11:51:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2589' AND id_document != '93013' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 20/09/2024 11:51:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2589', document_date = '2024-09-05', 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 = '100.00', price_tax_excluded = '87.88', date_upd = NOW() WHERE id_document = '93013' 20/09/2024 11:51:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93013' 20/09/2024 11:51:50 am >> DELETE FROM ps_document_detail WHERE id_document = '93013' 20/09/2024 11:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 20/09/2024 11:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 20/09/2024 11:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 20/09/2024 11:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '18391' , 'CATENINA ACCIAIO 10 ESSENZE' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 20/09/2024 11:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14' , '14' , '0' , '0' , '14.00' ) 20/09/2024 11:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 20/09/2024 12:39:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872294482' AND id_product != '22952' AND ean13 != '' 20/09/2024 12:39:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788872294482', date_upd = NOW() WHERE id_product = '22952' 20/09/2024 12:39:36 pm >> UPDATE ps_product_lang SET name = 'ROSARIO CON SANTA TERESA DI G. BAMBINO', description = '' WHERE id_product = '22952' 20/09/2024 12:39:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '22952' 20/09/2024 12:39:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '128', 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 = '22952' 20/09/2024 12:39:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '22952' 20/09/2024 12:39:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22952' 20/09/2024 12:39:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22953' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 12:39:37 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22953' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22952' 20/09/2024 12:39:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22953' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22952' 20/09/2024 12:40:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872291054' AND id_product != '22953' AND ean13 != '' 20/09/2024 12:40:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788872291054', date_upd = NOW() WHERE id_product = '22953' 20/09/2024 12:40:07 pm >> UPDATE ps_product_lang SET name = 'NOVENA DELLE ROSE', description = '' WHERE id_product = '22953' 20/09/2024 12:40:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.1' WHERE id_product = '22953' 20/09/2024 12:40:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.1', id_tax_rules_group = '4', id_category_default = '128', 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 = '22953' 20/09/2024 12:40:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22953' 20/09/2024 12:40:08 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22953' 20/09/2024 12:40:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22954' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 12:40:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22954' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22953' 20/09/2024 12:40:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22954' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22953' 20/09/2024 12:40:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887103496' AND id_product != '14543' AND ean13 != '' 20/09/2024 12:40:42 pm >> UPDATE ps_product SET id_supplier = '47', reference = 'BANCO', ean13 = '9788887103496', date_upd = NOW() WHERE id_product = '14543' 20/09/2024 12:40:42 pm >> UPDATE ps_product_lang SET name = 'CALENDARIO LITURGICO MARIANO 2025', description = '' WHERE id_product = '14543' 20/09/2024 12:40:42 pm >> UPDATE ps_product SET wholesale_price = '0.70', on_sale = '0', price = '1.0000' WHERE id_product = '14543' 20/09/2024 12:40:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.70', price = '1.0000', id_tax_rules_group = '4', id_category_default = '434', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14543' 20/09/2024 12:40:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '14543' 20/09/2024 12:41:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210432' AND id_product != '22954' AND ean13 != '' 20/09/2024 12:41:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9791280210432', date_upd = NOW() WHERE id_product = '22954' 20/09/2024 12:41:28 pm >> UPDATE ps_product_lang SET name = 'SANTO VOLTO', description = '' WHERE id_product = '22954' 20/09/2024 12:41:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '22954' 20/09/2024 12:41:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '99', 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 = '22954' 20/09/2024 12:41:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22954' 20/09/2024 12:41:33 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22954' 20/09/2024 12:41:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22955' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 12:41:33 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22955' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22954' 20/09/2024 12:41:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22955' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22954' 20/09/2024 12:42:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863664263' AND id_product != '22955' AND ean13 != '' 20/09/2024 12:42:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788863664263', date_upd = NOW() WHERE id_product = '22955' 20/09/2024 12:42:51 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA OSSIGENO PER L\'ANIMA - J. PHILIPPE', description = '' WHERE id_product = '22955' 20/09/2024 12:42:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22955' 20/09/2024 12:42:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '24', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22955' 20/09/2024 12:42:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '22955' 20/09/2024 12:42:52 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22955' 20/09/2024 12:42:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22956' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 12:42:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22956' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22955' 20/09/2024 12:42:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22956' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22955' 20/09/2024 12:44:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831282154' AND id_product != '22956' AND ean13 != '' 20/09/2024 12:44:00 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA', ean13 = '9788831282154', date_upd = NOW() WHERE id_product = '22956' 20/09/2024 12:44:00 pm >> UPDATE ps_product_lang SET name = 'GENERATI MEDIANTE IL VANGELO - F. ROSINI', description = '' WHERE id_product = '22956' 20/09/2024 12:44:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22956' 20/09/2024 12:44:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '249', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22956' 20/09/2024 12:44:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '22956' 20/09/2024 12:44:01 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22956' 20/09/2024 12:44:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22957' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 12:44:01 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22957' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22956' 20/09/2024 12:44:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22957' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22956' 20/09/2024 12:45:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863664119' AND id_product != '22957' AND ean13 != '' 20/09/2024 12:45:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788863664119', date_upd = NOW() WHERE id_product = '22957' 20/09/2024 12:45:05 pm >> UPDATE ps_product_lang SET name = 'DON DOLINDO RUOTOLO, SANTA FAUSTINA - M. STANZIONE', description = '' WHERE id_product = '22957' 20/09/2024 12:45:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '22957' 20/09/2024 12:45:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '24', 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 = '22957' 20/09/2024 12:45:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '22957' 20/09/2024 12:45:06 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22957' 20/09/2024 12:45:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22958' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 12:45:06 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22958' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22957' 20/09/2024 12:45:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22958' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22957' 20/09/2024 12:46:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817190787' AND id_product != '22958' AND ean13 != '' 20/09/2024 12:46:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788817190787', date_upd = NOW() WHERE id_product = '22958' 20/09/2024 12:46:01 pm >> UPDATE ps_product_lang SET name = 'CHI ULTIMO ARRIVA MEGLIO ALLOGGIA - M. POZZA', description = '' WHERE id_product = '22958' 20/09/2024 12:46:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '22958' 20/09/2024 12:46:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '113', 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 = '22958' 20/09/2024 12:46:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '22958' 20/09/2024 12:46:02 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22958' 20/09/2024 12:46:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22959' , '1' , '' , 'nuovo-prodotto' ) 20/09/2024 12:46:02 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22959' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22958' 20/09/2024 12:46:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22959' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22958' 20/09/2024 12:46:27 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 ( '31' , '4222' , '2024-09-18' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.22' , '80.22' , NOW() , NOW() ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93223' 20/09/2024 12:46:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93223' 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '22952' , 'ROSARIO CON SANTA TERESA DI G. BAMBINO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '30' , '2.1000' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22952' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22952' , '47' , '1' ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '22953' , 'NOVENA DELLE ROSE' , '1' , '1' , '4' , '1.10' , '1.1' , '0' , '30' , '0.7700' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22953' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22953' , '47' , '1' ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '14' , '14' , '4' , '1.00' , '1' , '0' , '30' , '9.8000' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '1' , '1' , '4' , '1.00' , '1' , '0' , '100' , '0.0000' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '22954' , 'SANTO VOLTO' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '30' , '5.9500' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22954' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22954' , '47' , '1' ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '22955' , 'PREGHIERA OSSIGENO PER LANIMA - J. PHILIPPE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22955' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22955' , '47' , '1' ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20879' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20879' , '47' , '1' ) 20/09/2024 12:46:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '2' , '2' , '4' , '16.00' , '16' , '0' , '30' , '22.4000' ) 20/09/2024 12:46:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22956' AND id_supplier = '47' 20/09/2024 12:46:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22956' , '47' , '1' ) 20/09/2024 12:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '22957' , 'DON DOLINDO RUOTOLO, SANTA FAUSTINA - M. STANZIONE' , '1' , '1' , '4' , '11.00' , '11' , '0' , '30' , '7.7000' ) 20/09/2024 12:46:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22957' AND id_supplier = '47' 20/09/2024 12:46:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22957' , '47' , '1' ) 20/09/2024 12:46:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93223' , '22958' , 'CHI ULTIMO ARRIVA MEGLIO ALLOGGIA - M. POZZA' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 20/09/2024 12:46:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22958' AND id_supplier = '47' 20/09/2024 12:46:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22958' , '47' , '1' ) 20/09/2024 12:47:05 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 ( '33' , '4222' , '2024-09-20' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.22' , '80.22' , NOW() , NOW() ) 20/09/2024 12:47:05 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 = '93224' 20/09/2024 12:47:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '93224' 20/09/2024 12:47:05 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 ( '93224' , '22952' , 'ROSARIO CON SANTA TERESA DI G. BAMBINO' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '30' , '2.10' ) 20/09/2024 12:47:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22952' AND id_supplier = '47' 20/09/2024 12:47:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22952' , '47' , '1' ) 20/09/2024 12:47:05 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 ( '93224' , '22953' , 'NOVENA DELLE ROSE' , '1' , '1' , '4' , '1.1000' , '1.1' , '0' , '30' , '0.77' ) 20/09/2024 12:47:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22953' AND id_supplier = '47' 20/09/2024 12:47:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22953' , '47' , '1' ) 20/09/2024 12:47:05 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 ( '93224' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '14' , '14' , '4' , '1.0000' , '1' , '0' , '30' , '9.80' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 20/09/2024 12:47:06 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 ( '93224' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '1' , '1' , '4' , '1.0000' , '1' , '0' , '100' , '0.00' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 20/09/2024 12:47:06 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 ( '93224' , '22954' , 'SANTO VOLTO' , '1' , '1' , '4' , '8.5000' , '8.5' , '0' , '30' , '5.95' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22954' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22954' , '47' , '1' ) 20/09/2024 12:47:06 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 ( '93224' , '22955' , 'PREGHIERA OSSIGENO PER LANIMA - J. PHILIPPE' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22955' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22955' , '47' , '1' ) 20/09/2024 12:47:06 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 ( '93224' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20879' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20879' , '47' , '1' ) 20/09/2024 12:47:06 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 ( '93224' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '2' , '2' , '4' , '16.0000' , '16' , '0' , '30' , '22.40' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22956' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22956' , '47' , '1' ) 20/09/2024 12:47:06 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 ( '93224' , '22957' , 'DON DOLINDO RUOTOLO, SANTA FAUSTINA - M. STANZIONE' , '1' , '1' , '4' , '11.0000' , '11' , '0' , '30' , '7.70' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22957' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22957' , '47' , '1' ) 20/09/2024 12:47:06 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 ( '93224' , '22958' , 'CHI ULTIMO ARRIVA MEGLIO ALLOGGIA - M. POZZA' , '1' , '1' , '4' , '17.0000' , '17' , '0' , '30' , '11.90' ) 20/09/2024 12:47:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22958' AND id_supplier = '47' 20/09/2024 12:47:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22958' , '47' , '1' ) 20/09/2024 12:47:13 pm >> DELETE FROM ps_document WHERE id_document = '93223' 20/09/2024 12:47:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '93223' 20/09/2024 12:47:28 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '4222', document_date = '2024-09-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = '', price_shipping = '5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '85.22', price_tax_excluded = '85.22', date_upd = NOW() WHERE id_document = '93224' 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93224' 20/09/2024 12:47:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '93224' 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '22952' , 'ROSARIO CON SANTA TERESA DI G. BAMBINO' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '30' , '2.10' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '22953' , 'NOVENA DELLE ROSE' , '1' , '1' , '4' , '1.1000' , '1.1' , '0' , '30' , '0.77' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '14' , '14' , '4' , '1.0000' , '1' , '0' , '30' , '9.80' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '1' , '1' , '4' , '1.0000' , '1' , '0' , '100' , '0.00' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '22954' , 'SANTO VOLTO' , '1' , '1' , '4' , '8.5000' , '8.5' , '0' , '30' , '5.95' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '22955' , 'PREGHIERA OSSIGENO PER LANIMA - J. PHILIPPE' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '2' , '2' , '4' , '16.0000' , '16' , '0' , '30' , '22.40' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '22957' , 'DON DOLINDO RUOTOLO, SANTA FAUSTINA - M. STANZIONE' , '1' , '1' , '4' , '11.0000' , '11' , '0' , '30' , '7.70' ) 20/09/2024 12:47:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93224' , '22958' , 'CHI ULTIMO ARRIVA MEGLIO ALLOGGIA - M. POZZA' , '1' , '1' , '4' , '17.0000' , '17' , '0' , '30' , '11.90' ) 20/09/2024 12:54:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2749' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 12:54:14 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' , '2749' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '199.00' , '166.00' , NOW() , NOW() ) 20/09/2024 12:54:14 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 = '93225' 20/09/2024 12:54:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '93225' 20/09/2024 12:54:14 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 ( '93225' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 20/09/2024 12:54:14 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 ( '93225' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 20/09/2024 12:54:14 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 ( '93225' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 20/09/2024 03:18:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2750' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 03:18:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2750' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 20/09/2024 03:18:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93226' 20/09/2024 03:18:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '93226' 20/09/2024 03:18:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93226' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 20/09/2024 03:22:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2751' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 03:22:41 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' , '2751' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 20/09/2024 03:22:41 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 = '93227' 20/09/2024 03:22:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '93227' 20/09/2024 03:22:41 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 ( '93227' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/09/2024 03:22:41 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 ( '93227' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/09/2024 03:45:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2752' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 03:45:31 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' , '2752' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.40' , '80.66' , NOW() , NOW() ) 20/09/2024 03:45:31 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 = '93228' 20/09/2024 03:45:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93228' 20/09/2024 03:45:31 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 ( '93228' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '23.40' ) 20/09/2024 03:45:31 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 ( '93228' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 20/09/2024 03:46:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2753' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 03:46:02 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' , '2753' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 20/09/2024 03:46:02 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 = '93229' 20/09/2024 03:46:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '93229' 20/09/2024 03:46:02 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 ( '93229' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 20/09/2024 03:47:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2754' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 03:47:48 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' , '2754' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '5.66' , NOW() , NOW() ) 20/09/2024 03:47:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93230' 20/09/2024 03:47:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93230' 20/09/2024 03:47:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93230' , '18354' , 'PORTA ROSARIO IN VELLUTO GRANDE - 314- NT 4' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/09/2024 03:47:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93230' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 20/09/2024 03:48:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2755' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 03:48:44 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' , '2755' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 20/09/2024 03:48:44 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 = '93231' 20/09/2024 03:48:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '93231' 20/09/2024 03:48:44 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 ( '93231' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 20/09/2024 04:00:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2756' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 04:00:09 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' , '2756' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 20/09/2024 04:00:09 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 = '93232' 20/09/2024 04:00:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '93232' 20/09/2024 04:00:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93232' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 20/09/2024 04:14:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2757' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 04:14:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2757' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 20/09/2024 04:14:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93233' 20/09/2024 04:14:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93233' 20/09/2024 04:14:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93233' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 20/09/2024 04:26:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2179' AND id_document != '92525' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 20/09/2024 04:26:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2179', document_date = '2024-07-03', 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 = '11.30', price_tax_excluded = '9.26', date_upd = NOW() WHERE id_document = '92525' 20/09/2024 04:26:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92525' 20/09/2024 04:26:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92525' 20/09/2024 04:26:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92525' , '18130' , 'TAU GRANDE CM 4 - T9' , '2' , '-2' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '1.80' ) 20/09/2024 04:26:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92525' , '18133' , 'CROCE SAN BENEDETTO CM 11 - CSB2' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 20/09/2024 05:19:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0205482/F' AND id_product != '16796' AND ean13 != '' 20/09/2024 05:19:15 pm >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '0205482/F', date_upd = NOW() WHERE id_product = '16796' 20/09/2024 05:19:15 pm >> UPDATE ps_product_lang SET name = 'LUMINO 5B BIANCO', description = '' WHERE id_product = '16796' 20/09/2024 05:19:15 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.2459' WHERE id_product = '16796' 20/09/2024 05:19:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.2459', id_tax_rules_group = '1', id_category_default = '205', 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 = '16796' 20/09/2024 05:19:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '16796' 20/09/2024 05:19:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0205482' AND id_product != '16796' AND ean13 != '' 20/09/2024 05:19:36 pm >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '0205482', date_upd = NOW() WHERE id_product = '16796' 20/09/2024 05:19:36 pm >> UPDATE ps_product_lang SET name = 'LUMINO 5B BIANCO', description = '' WHERE id_product = '16796' 20/09/2024 05:19:36 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.2459' WHERE id_product = '16796' 20/09/2024 05:19:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.2459', id_tax_rules_group = '1', id_category_default = '205', 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 = '16796' 20/09/2024 05:19:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '16796' 20/09/2024 05:28:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1312' , '2024-09-13' , '' , '0' , '36' , '2631' , 'VIA FRIZZONI,56 24048 TREVIOLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1025.49' , '840.56' , NOW() , NOW() ) 20/09/2024 05:28:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93234' 20/09/2024 05:28:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '93234' 20/09/2024 05:28:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93234' , '6019' , 'LUMINO ROSSO - 10B' , '576' , '576' , '1' , '0.20' , '0.16393442622951' , '22' , '3' , '136.3277' ) 20/09/2024 05:28:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6019' AND id_supplier = '36' 20/09/2024 05:28:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6019' , '36' , '1' ) 20/09/2024 05:28:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93234' , '6014' , 'LUMINO BIANCO - 10B' , '576' , '576' , '1' , '0.20' , '0.16393442622951' , '22' , '3' , '136.3277' ) 20/09/2024 05:28:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6014' AND id_supplier = '36' 20/09/2024 05:28:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6014' , '36' , '1' ) 20/09/2024 05:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93234' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '3360' , '1' , '0.10' , '0.081967213114754' , '22' , '3' , '397.6224' ) 20/09/2024 05:28:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16796' AND id_supplier = '36' 20/09/2024 05:28:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16796' , '36' , '1' ) 20/09/2024 05:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93234' , '21137' , 'MOCCOLO 70X200' , '40' , '40' , '1' , '2.98' , '2.4426229508197' , '22' , '3' , '141.0613' ) 20/09/2024 05:28:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21137' AND id_supplier = '36' 20/09/2024 05:28:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21137' , '36' , '1' ) 20/09/2024 05:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93234' , '6811' , 'MOCCOLO 80X200' , '48' , '48' , '1' , '3.77' , '3.0901639344262' , '22' , '3' , '214.1481' ) 20/09/2024 05:28:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '36' 20/09/2024 05:28:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '36' , '1' ) 20/09/2024 05:43:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2758' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 05:43:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2758' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 20/09/2024 05:43:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93235' 20/09/2024 05:43:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93235' 20/09/2024 05:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93235' , '20487' , 'STELLARIO CM 14 - ART. 70' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 20/09/2024 05:48:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2759' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 20/09/2024 05:48:42 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' , '2759' , '2024-09-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '268.70' , '230.20' , NOW() , NOW() ) 20/09/2024 05:48:42 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 = '93236' 20/09/2024 05:48:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '93236' 20/09/2024 05:48:42 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 ( '93236' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 20/09/2024 05:48:42 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 ( '93236' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '6.40' ) 20/09/2024 05:48:42 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 ( '93236' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 20/09/2024 05:48:42 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 ( '93236' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '20' , '-20' , '4' , '1.50' , '1.5' , '0' , '5' , '28.60' ) 20/09/2024 05:48: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 ( '93236' , '21185' , 'RIPORTARE I GIOVANI A MESSA - A. MATTEO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 20/09/2024 05:48: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 ( '93236' , '18288' , 'SE CARLO ACUTIS AVESSE TRENANNI - A. DEHO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 20/09/2024 05:48: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 ( '93236' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/09/2024 05:48: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 ( '93236' , '22298' , 'RELIQUIARIODORATO CON PIETRE CM 23' , '1' , '-1' , '1' , '145.00' , '118.85245901639' , '22' , '0' , '145.00' ) 20/09/2024 05:48: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 ( '93236' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '20' , '-20' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '36.00' ) 20/09/2024 05:52:22 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '1312', document_date = '2024-09-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2631', address1 = 'VIA FRIZZONI,56 24048 TREVIOLO', address2 = '', note = '', price_shipping = '65', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '3117.90', price_tax_excluded = '2555.65', date_upd = NOW() WHERE id_document = '93234' 20/09/2024 05:52:22 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 = '93234' 20/09/2024 05:52:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '93234' 20/09/2024 05:52:22 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 ( '93234' , '6019' , 'LUMINO ROSSO - 10B' , '576' , '576' , '1' , '0.2000' , '0.16393442622951' , '22' , '3' , '136.33' ) 20/09/2024 05:52:22 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 ( '93234' , '6014' , 'LUMINO BIANCO - 10B' , '576' , '576' , '1' , '0.2000' , '0.16393442622951' , '22' , '3' , '136.33' ) 20/09/2024 05:52:22 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 ( '93234' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '3360' , '1' , '0.1000' , '0.081967213114754' , '22' , '3' , '397.62' ) 20/09/2024 05:52:22 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 ( '93234' , '21137' , 'MOCCOLO 70X200' , '40' , '40' , '1' , '2.9800' , '2.4426229508197' , '22' , '3' , '141.06' ) 20/09/2024 05:52:22 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 ( '93234' , '6811' , 'MOCCOLO 80X200' , '48' , '48' , '1' , '3.7700' , '3.0901639344262' , '22' , '3' , '214.15' ) 20/09/2024 05:52:22 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 ( '93234' , '6812' , 'MOCCOLO 80X300 ' , '6' , '6' , '1' , '7.44' , '6.0983606557377' , '22' , '3' , '52.8270' ) 20/09/2024 05:52:22 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 ( '93234' , '1914' , 'CERA DELLA LITURGIA' , '732' , '732' , '1' , '2.2' , '1.8032786885246' , '22' , '3' , '1905.7474' ) 20/09/2024 05:52:22 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 ( '93234' , '6809' , 'MOCCOLO 60X165' , '24' , '24' , '1' , '1.92' , '1.5737704918033' , '22' , '3' , '54.5311' ) 20/09/2024 05:54:17 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '000076-1C2', document_date = '2024-02-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669556', address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '67.10', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '90289' 20/09/2024 05:54:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90289' 20/09/2024 05:54:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '90289' 20/09/2024 05:54:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90289' , '21916' , 'TOVAGLIA DALTARE SU MISURA' , '1' , '1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '67.10' ) 20/09/2024 05:56:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-218M' AND id_product != '22298' AND ean13 != '' 20/09/2024 05:56:45 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-218M', date_upd = NOW() WHERE id_product = '22298' 20/09/2024 05:56:45 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO DORATO CON PIETRE CM 23', description = '' WHERE id_product = '22298' 20/09/2024 05:56:46 pm >> UPDATE ps_product SET wholesale_price = '56.47', on_sale = '0', price = '118.8525' WHERE id_product = '22298' 20/09/2024 05:56:46 pm >> UPDATE ps_product_shop SET wholesale_price = '56.47', price = '118.8525', id_tax_rules_group = '1', id_category_default = '394', 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 = '22298' 20/09/2024 05:56:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22298'