20/09/2022 08:30:03 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/09/2022 08:30:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19965' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 08:30:03 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19965' , '1' , '1' , '2' , NOW() , NOW() ) 20/09/2022 08:30:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19965' , '0' , '1' , '0' , '0' ) 20/09/2022 08:30:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827009611' AND id_product != '19965' AND ean13 != '' 20/09/2022 08:30:56 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788827009611', date_upd = NOW() WHERE id_product = '19965' 20/09/2022 08:30:56 am >> UPDATE ps_product_lang SET name = 'ROSARIO FRANCESCANO', description = '' WHERE id_product = '19965' 20/09/2022 08:30:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '19965' 20/09/2022 08:30:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '186', 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 = '19965' 20/09/2022 08:30:56 am >> DELETE FROM ps_specific_price WHERE id_product = '19965' 20/09/2022 08:30:56 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 = '19965' 20/09/2022 08:30:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19966' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 08:30:56 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 '19966' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19965' 20/09/2022 08:30:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19966' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19965' 20/09/2022 08:32:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118034151' AND id_product != '19966' AND ean13 != '' 20/09/2022 08:32:34 am >> UPDATE ps_product SET id_supplier = '', reference = '8/3', ean13 = '8019118034151', date_upd = NOW() WHERE id_product = '19966' 20/09/2022 08:32:34 am >> UPDATE ps_product_lang SET name = 'CANTO DI NATALE - SPARTITO', description = '' WHERE id_product = '19966' 20/09/2022 08:32:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '19966' 20/09/2022 08:32:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19966' 20/09/2022 08:32:34 am >> DELETE FROM ps_specific_price WHERE id_product = '19966' 20/09/2022 08:32: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 = '19966' 20/09/2022 08:32:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19967' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 08:32: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 '19967' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19966' 20/09/2022 08:32:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19967' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19966' 20/09/2022 08:32:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118034151' AND id_product != '19966' AND ean13 != '' 20/09/2022 08:32:49 am >> UPDATE ps_product SET id_supplier = '', reference = '8/3', ean13 = '8019118034151', date_upd = NOW() WHERE id_product = '19966' 20/09/2022 08:32:49 am >> UPDATE ps_product_lang SET name = 'CANTO DI NATALE - SPARTITO', description = '' WHERE id_product = '19966' 20/09/2022 08:32:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.25' WHERE id_product = '19966' 20/09/2022 08:32:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.25', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19966' 20/09/2022 08:32:49 am >> DELETE FROM ps_specific_price WHERE id_product = '19966' 20/09/2022 08:33:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118021274' AND id_product != '19967' AND ean13 != '' 20/09/2022 08:33:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8019118021274', date_upd = NOW() WHERE id_product = '19967' 20/09/2022 08:33:50 am >> UPDATE ps_product_lang SET name = 'CANTO DI NATALE - CD', description = '' WHERE id_product = '19967' 20/09/2022 08:33:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '19967' 20/09/2022 08:33:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19967' 20/09/2022 08:33:50 am >> DELETE FROM ps_specific_price WHERE id_product = '19967' 20/09/2022 08:33: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 = '19967' 20/09/2022 08:33:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19968' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 08:33: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 '19968' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19967' 20/09/2022 08:33:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19968' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19967' 20/09/2022 08:36:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788889669402' AND id_product != '19968' AND ean13 != '' 20/09/2022 08:36:04 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788889669402', date_upd = NOW() WHERE id_product = '19968' 20/09/2022 08:36:04 am >> UPDATE ps_product_lang SET name = 'PAURE CHE CI ABITANO - A. CASATI', description = '' WHERE id_product = '19968' 20/09/2022 08:36:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '19968' 20/09/2022 08:36:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '302', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19968' 20/09/2022 08:36:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19968' 20/09/2022 08:36:05 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 = '19968' 20/09/2022 08:36:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19969' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 08:36:05 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 '19969' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19968' 20/09/2022 08:36:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19969' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19968' 20/09/2022 08:37:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788871054339' AND id_product != '19969' AND ean13 != '' 20/09/2022 08:37:28 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788871054339', date_upd = NOW() WHERE id_product = '19969' 20/09/2022 08:37:28 am >> UPDATE ps_product_lang SET name = 'BRECCIA NEL TEMPO - L. INVERNIZZI', description = '' WHERE id_product = '19969' 20/09/2022 08:37:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '19969' 20/09/2022 08:37:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '114', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19969' 20/09/2022 08:37:28 am >> DELETE FROM ps_specific_price WHERE id_product = '19969' 20/09/2022 08:37: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 = '19969' 20/09/2022 08:37:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19970' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 08:37: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 '19970' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19969' 20/09/2022 08:37:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19970' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19969' 20/09/2022 08:38:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '608620' , '2022-09-16' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.48' , '79.66' , NOW() , NOW() ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61864' 20/09/2022 08:38:03 am >> DELETE FROM ps_document_detail WHERE id_document = '61864' 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '19965' , 'ROSARIO FRANCESCANO' , '3' , '3' , '4' , '2.00' , '2' , '0' , '30' , '4.2000' ) 20/09/2022 08:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19965' AND id_supplier = '7' 20/09/2022 08:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19965' , '7' , '1' ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '19966' , 'CANTO DI NATALE - SPARTITO' , '1' , '1' , '3' , '6.25' , '6.0096153846154' , '4' , '30' , '4.5500' ) 20/09/2022 08:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19966' AND id_supplier = '7' 20/09/2022 08:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19966' , '7' , '1' ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '19967' , 'CANTO DI NATALE - CD' , '1' , '1' , '1' , '10.65' , '8.7295081967213' , '22' , '30' , '9.0951' ) 20/09/2022 08:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19967' AND id_supplier = '7' 20/09/2022 08:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19967' , '7' , '1' ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '19891' , 'FATTI PER LETERNITA - F. SHEEN' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 20/09/2022 08:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19891' AND id_supplier = '7' 20/09/2022 08:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19891' , '7' , '1' ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 20/09/2022 08:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16393' AND id_supplier = '7' 20/09/2022 08:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16393' , '7' , '1' ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '14259' , 'ARCA DI NOE - GIOCO' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30' , '10.4300' ) 20/09/2022 08:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '14259' AND id_supplier = '7' 20/09/2022 08:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14259' , '7' , '1' ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '19968' , 'PAURE CHE CI ABITANO - A. CASATI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 20/09/2022 08:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19968' AND id_supplier = '7' 20/09/2022 08:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19968' , '7' , '1' ) 20/09/2022 08:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61864' , '15725' , 'SARA - L. INVERNIZZI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 20/09/2022 08:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '15725' AND id_supplier = '7' 20/09/2022 08:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15725' , '7' , '1' ) 20/09/2022 08:38:04 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 ( '61864' , '19969' , 'BRECCIA NEL TEMPO - L. INVERNIZZI' , '1' , '1' , '4' , '9.00' , '9' , '0' , '30' , '6.3000' ) 20/09/2022 08:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19969' AND id_supplier = '7' 20/09/2022 08:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19969' , '7' , '1' ) 20/09/2022 08:38:04 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 ( '61864' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 20/09/2022 08:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 20/09/2022 08:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 20/09/2022 08:50:36 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 20/09/2022 08:50:36 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '165' , '1' ) 20/09/2022 08:50:36 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '165' , '1' ) 20/09/2022 08:50:36 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '165' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 20/09/2022 08:52:54 am >> UPDATE ps_address SET id_state = '172', lastname = 'FRADEL SNC DI SARDELLA ALESSANDRO, ANDREA, EDOARDO', address1 = 'VIA MATTEOTTI 16', address2 = '', postcode = '26838', dni = '', vat_number = '08558480151', city = 'TAVAZZANO CON VILLAVESCO ', phone = '03711760519', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '165' 20/09/2022 08:52:54 am >> UPDATE ps_supplier SET email = 'info@fradel.it', name = 'FRADEL SNC DI SARDELLA ALESSANDRO, ANDREA, EDOARDO', date_upd = NOW() WHERE id_supplier = '165' 20/09/2022 08:52:54 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '165' 20/09/2022 08:53:17 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 20/09/2022 08:53:17 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '502' , '1' ) 20/09/2022 08:53:17 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '502' , '2' ) 20/09/2022 08:53:17 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '502' , '3' ) 20/09/2022 08:53:17 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '502' , '1' , 'FRADEL' , LOWER('FRADEL') ) 20/09/2022 08:53:17 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '502' , '1' , '0' ) 20/09/2022 08:55:04 am >> UPDATE ps_address SET id_state = '172', lastname = 'FRADEL SNC DI SARDELLA ALESSANDRO, ANDREA, EDOARDO', address1 = 'VIA MATTEOTTI 16', address2 = '', postcode = '26838', dni = '', vat_number = '08558480151', city = 'TAVAZZANO CON VILLAVESCO', phone = '03711760519', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '150' 20/09/2022 08:55:04 am >> UPDATE ps_supplier SET email = 'info@fradel.it', name = 'FRADEL SNC DI SARDELLA ALESSANDRO, ANDREA, EDOARDO', date_upd = NOW() WHERE id_supplier = '150' 20/09/2022 08:55:04 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '150' 20/09/2022 08:55:11 am >> UPDATE ps_supplier SET active = '0' , date_upd = NOW() WHERE id_supplier = '165' 20/09/2022 08:55:11 am >> UPDATE ps_address SET deleted='1' , active = '0' , date_upd = NOW() WHERE id_supplier = '165' 20/09/2022 08:56:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002017' AND id_product != '19970' AND ean13 != '' 20/09/2022 08:56:35 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002017', date_upd = NOW() WHERE id_product = '19970' 20/09/2022 08:56:35 am >> UPDATE ps_product_lang SET name = 'CALICE - ART 715', description = '' WHERE id_product = '19970' 20/09/2022 08:56:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '241.80327868852459' WHERE id_product = '19970' 20/09/2022 08:56:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '241.80327868852459', id_tax_rules_group = '1', id_category_default = '481', 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 = '19970' 20/09/2022 08:56:35 am >> DELETE FROM ps_specific_price WHERE id_product = '19970' 20/09/2022 08:56:42 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 = '19970' 20/09/2022 08:56:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19971' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 08:56:42 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 '19971' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19970' 20/09/2022 08:56:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19971' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19970' 20/09/2022 09:08:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002018' AND id_product != '19971' AND ean13 != '' 20/09/2022 09:08:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002018', date_upd = NOW() WHERE id_product = '19971' 20/09/2022 09:08:46 am >> UPDATE ps_product_lang SET name = 'CALICE - ART. 642', description = '' WHERE id_product = '19971' 20/09/2022 09:08:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '439.344262295082' WHERE id_product = '19971' 20/09/2022 09:08:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '439.344262295082', id_tax_rules_group = '1', id_category_default = '481', 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 = '19971' 20/09/2022 09:08:46 am >> DELETE FROM ps_specific_price WHERE id_product = '19971' 20/09/2022 09:08:47 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 = '19971' 20/09/2022 09:08:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19972' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 09:08:47 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 '19972' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19971' 20/09/2022 09:08:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19972' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19971' 20/09/2022 09:16:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002019' AND id_product != '19972' AND ean13 != '' 20/09/2022 09:16:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002019', date_upd = NOW() WHERE id_product = '19972' 20/09/2022 09:16:12 am >> UPDATE ps_product_lang SET name = 'CALICE - ART. 570', description = '' WHERE id_product = '19972' 20/09/2022 09:16:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '377.04918032786884' WHERE id_product = '19972' 20/09/2022 09:16:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '377.04918032786884', id_tax_rules_group = '1', id_category_default = '481', 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 = '19972' 20/09/2022 09:16:12 am >> DELETE FROM ps_specific_price WHERE id_product = '19972' 20/09/2022 09:16:14 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 = '19972' 20/09/2022 09:16:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19973' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 09:16:14 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 '19973' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19972' 20/09/2022 09:16:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19973' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19972' 20/09/2022 09:34:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002020' AND id_product != '19973' AND ean13 != '' 20/09/2022 09:34:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002020', date_upd = NOW() WHERE id_product = '19973' 20/09/2022 09:34:30 am >> UPDATE ps_product_lang SET name = 'AMPOLLINE - ART. 194/1', description = '' WHERE id_product = '19973' 20/09/2022 09:34:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '180.32786885245903' WHERE id_product = '19973' 20/09/2022 09:34:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '180.32786885245903', id_tax_rules_group = '1', id_category_default = '481', 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 = '19973' 20/09/2022 09:34:30 am >> DELETE FROM ps_specific_price WHERE id_product = '19973' 20/09/2022 09:34:32 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 = '19973' 20/09/2022 09:34:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19974' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 09:34:32 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 '19974' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19973' 20/09/2022 09:34:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19974' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19973' 20/09/2022 09:38:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002021' AND id_product != '19974' AND ean13 != '' 20/09/2022 09:38:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002021', date_upd = NOW() WHERE id_product = '19974' 20/09/2022 09:38:13 am >> UPDATE ps_product_lang SET name = 'PISSIDE BASSA - ART 119/3', description = '' WHERE id_product = '19974' 20/09/2022 09:38:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '200' WHERE id_product = '19974' 20/09/2022 09:38:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '200', id_tax_rules_group = '1', id_category_default = '481', 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 = '19974' 20/09/2022 09:38:13 am >> DELETE FROM ps_specific_price WHERE id_product = '19974' 20/09/2022 09:41:07 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' , '92' , '2022-09-15' , '' , '0' , '150' , '4671103' , 'VIA MATTEOTTI 16 26838 TAVAZZANO CON VILLAVESCO' , '' , '' , '20' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1000.28' , '819.90' , NOW() , NOW() ) 20/09/2022 09:41:07 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 = '61865' 20/09/2022 09:41:07 am >> DELETE FROM ps_document_detail WHERE id_document = '61865' 20/09/2022 09:41:07 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 ( '61865' , '19970' , 'CALICE - ART 715' , '2' , '2' , '1' , '121' , '99.180327868852' , '22' , '5' , '280.4780' ) 20/09/2022 09:41:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19970' AND id_supplier = '150' 20/09/2022 09:41:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19970' , '150' , '1' ) 20/09/2022 09:41:07 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 ( '61865' , '19971' , 'CALICE - ART. 642' , '1' , '1' , '1' , '220' , '180.32786885246' , '22' , '5' , '254.9800' ) 20/09/2022 09:41:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19971' AND id_supplier = '150' 20/09/2022 09:41:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19971' , '150' , '1' ) 20/09/2022 09:41:07 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 ( '61865' , '19972' , 'CALICE - ART. 570' , '1' , '1' , '1' , '190' , '155.73770491803' , '22' , '5' , '220.2100' ) 20/09/2022 09:41:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19972' AND id_supplier = '150' 20/09/2022 09:41:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19972' , '150' , '1' ) 20/09/2022 09:41:07 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 ( '61865' , '19973' , 'AMPOLLINE - ART. 194/1' , '1' , '1' , '1' , '90' , '73.770491803279' , '22' , '5' , '104.3100' ) 20/09/2022 09:41:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19973' AND id_supplier = '150' 20/09/2022 09:41:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19973' , '150' , '1' ) 20/09/2022 09:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61865' , '19974' , 'PISSIDE BASSA - ART 119/3' , '1' , '1' , '1' , '100' , '81.967213114754' , '22' , '5' , '115.9000' ) 20/09/2022 09:41:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19974' AND id_supplier = '150' 20/09/2022 09:41:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19974' , '150' , '1' ) 20/09/2022 09:41:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002021' AND id_product != '19974' AND ean13 != '' 20/09/2022 09:41:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002021', date_upd = NOW() WHERE id_product = '19974' 20/09/2022 09:41:14 am >> UPDATE ps_product_lang SET name = 'PISSIDE BASSA - ART 119/3', description = '' WHERE id_product = '19974' 20/09/2022 09:41:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '200' WHERE id_product = '19974' 20/09/2022 09:41:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '200', id_tax_rules_group = '1', id_category_default = '481', 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 = '19974' 20/09/2022 09:41:14 am >> DELETE FROM ps_specific_price WHERE id_product = '19974' 20/09/2022 09:41:16 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 = '19974' 20/09/2022 09:41:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19975' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 09:41:17 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 '19975' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19974' 20/09/2022 09:41:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19975' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19974' 20/09/2022 09:58:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 09:58:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2782' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.20' , '22.98' , NOW() , NOW() ) 20/09/2022 09:58:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61866' 20/09/2022 09:58:51 am >> DELETE FROM ps_document_detail WHERE id_document = '61866' 20/09/2022 09:58:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61866' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 20/09/2022 09:58:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/09/2022 09:58:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/09/2022 09:58:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61866' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '3.5' , '3.5' , '0' , '0' , '17.50' ) 20/09/2022 09:58:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/09/2022 09:58:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/09/2022 10:50:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892982338' AND id_product != '19975' AND ean13 != '' 20/09/2022 10:50:08 am >> UPDATE ps_product SET id_supplier = '', reference = '6/1', ean13 = '9788892982338', date_upd = NOW() WHERE id_product = '19975' 20/09/2022 10:50:08 am >> UPDATE ps_product_lang SET name = 'POSTINO DI DIO - A. LUCIANI', description = '' WHERE id_product = '19975' 20/09/2022 10:50:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '19975' 20/09/2022 10:50:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '146', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19975' 20/09/2022 10:50:08 am >> DELETE FROM ps_specific_price WHERE id_product = '19975' 20/09/2022 10:50: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 = '19975' 20/09/2022 10:50:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19976' , '1' , '' , 'nuovo-prodotto' ) 20/09/2022 10:50: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 '19976' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19975' 20/09/2022 10:50:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19976' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19975' 20/09/2022 10:50:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887103496' AND id_product != '14543' AND ean13 != '' 20/09/2022 10:50:52 am >> UPDATE ps_product SET id_supplier = '47', reference = 'BANCO', ean13 = '9788887103496', date_upd = NOW() WHERE id_product = '14543' 20/09/2022 10:50:52 am >> UPDATE ps_product_lang SET name = 'CALENDARIO LITURGICO MARIANO 2023', description = '' WHERE id_product = '14543' 20/09/2022 10:50:52 am >> UPDATE ps_product SET wholesale_price = '0.70', on_sale = '0', price = '1.0000' WHERE id_product = '14543' 20/09/2022 10:50:52 am >> 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/2022 10:50:52 am >> DELETE FROM ps_specific_price WHERE id_product = '14543' 20/09/2022 10:51:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '4710' , '2022-09-19' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.83' , '58.83' , NOW() , NOW() ) 20/09/2022 10:51: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 = '61867' 20/09/2022 10:51:45 am >> DELETE FROM ps_document_detail WHERE id_document = '61867' 20/09/2022 10:51: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 ( '61867' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '12' , '12' , '4' , '1.00' , '1' , '0' , '30' , '8.4000' ) 20/09/2022 10:51:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 20/09/2022 10:51:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 20/09/2022 10:51: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 ( '61867' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '1' , '1' , '4' , '1.00' , '1' , '0' , '100' , '0.0000' ) 20/09/2022 10:51:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '47' 20/09/2022 10:51:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '47' , '1' ) 20/09/2022 10:51: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 ( '61867' , '19975' , 'POSTINO DI DIO - A. LUCIANI' , '2' , '2' , '4' , '19.00' , '19' , '0' , '30' , '26.6000' ) 20/09/2022 10:51:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19975' AND id_supplier = '47' 20/09/2022 10:51:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19975' , '47' , '1' ) 20/09/2022 10:51: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 ( '61867' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '2' , '2' , '4' , '12.90' , '12.9' , '0' , '27' , '18.8340' ) 20/09/2022 10:51:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '47' 20/09/2022 10:51:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '47' , '1' ) 20/09/2022 11:04:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:04:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2783' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1400.00' , '1147.54' , NOW() , NOW() ) 20/09/2022 11:04:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61868' 20/09/2022 11:04:51 am >> DELETE FROM ps_document_detail WHERE id_document = '61868' 20/09/2022 11:04:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61868' , '18227' , 'CALICE IN OTTONE ARGENTATO - 154' , '1' , '-1' , '1' , '1360.00' , '1114.7540983607' , '22' , '0' , '1360.00' ) 20/09/2022 11:04:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18227' AND id_supplier = '' 20/09/2022 11:04:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18227' , '' , '1' ) 20/09/2022 11:04:52 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 ( '61868' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 20/09/2022 11:04:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '' 20/09/2022 11:04:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '' , '1' ) 20/09/2022 11:11:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2784' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:11:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2784' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.44' , '60.44' , NOW() , NOW() ) 20/09/2022 11:11:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61869' 20/09/2022 11:11:08 am >> DELETE FROM ps_document_detail WHERE id_document = '61869' 20/09/2022 11:11:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61869' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 20/09/2022 11:11:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 20/09/2022 11:11:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 20/09/2022 11:11:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61869' , '19514' , 'DIREZIONE SPIRITUALE - U. OCCHIALINI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 20/09/2022 11:11:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19514' AND id_supplier = '' 20/09/2022 11:11:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19514' , '' , '1' ) 20/09/2022 11:11:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61869' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 20/09/2022 11:11:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '' 20/09/2022 11:11:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '' , '1' ) 20/09/2022 11:11:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61869' , '19565' , 'SCOPRIAMO INSIEME SEGNI E SIMBOLI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 20/09/2022 11:11:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19565' AND id_supplier = '' 20/09/2022 11:11:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19565' , '' , '1' ) 20/09/2022 11:11:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61869' , '16147' , 'SCOPRIAMO LA MESSA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 20/09/2022 11:11:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '16147' AND id_supplier = '' 20/09/2022 11:11:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16147' , '' , '1' ) 20/09/2022 11:11:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61869' , '18448' , 'SCOPRIAMO INSIEME IL CREDO ' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 20/09/2022 11:11:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '18448' AND id_supplier = '' 20/09/2022 11:11:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18448' , '' , '1' ) 20/09/2022 11:11:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2785' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:11:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2785' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.41' , '27.95' , NOW() , NOW() ) 20/09/2022 11:11:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61870' 20/09/2022 11:11:44 am >> DELETE FROM ps_document_detail WHERE id_document = '61870' 20/09/2022 11:11:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61870' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '5' , '11.88' ) 20/09/2022 11:11:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19762' AND id_supplier = '' 20/09/2022 11:11:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19762' , '' , '1' ) 20/09/2022 11:11:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61870' , '19966' , 'CANTO DI NATALE - SPARTITO' , '1' , '-1' , '3' , '6.50' , '6.25' , '4' , '5' , '6.18' ) 20/09/2022 11:11:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19966' AND id_supplier = '' 20/09/2022 11:11:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19966' , '' , '1' ) 20/09/2022 11:11:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61870' , '19967' , 'CANTO DI NATALE - CD' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '5' , '12.35' ) 20/09/2022 11:11:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19967' AND id_supplier = '' 20/09/2022 11:11:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19967' , '' , '1' ) 20/09/2022 11:13:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:13:42 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' , '2786' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.40' , '22.88' , NOW() , NOW() ) 20/09/2022 11:13:42 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 = '61871' 20/09/2022 11:13:42 am >> DELETE FROM ps_document_detail WHERE id_document = '61871' 20/09/2022 11:13:42 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 ( '61871' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 20/09/2022 11:13:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 20/09/2022 11:13:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 20/09/2022 11:13:42 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 ( '61871' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 20/09/2022 11:13:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 20/09/2022 11:13:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 20/09/2022 11:13:42 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 ( '61871' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 20/09/2022 11:13:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 20/09/2022 11:13:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 20/09/2022 11:25:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:25:12 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' , '2787' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.52' , '24.52' , NOW() , NOW() ) 20/09/2022 11:25:12 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 = '61872' 20/09/2022 11:25:12 am >> DELETE FROM ps_document_detail WHERE id_document = '61872' 20/09/2022 11:25:12 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 ( '61872' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '2' , '-2' , '4' , '12.90' , '12.9' , '0' , '5' , '24.52' ) 20/09/2022 11:25:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '' 20/09/2022 11:25:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '' , '1' ) 20/09/2022 11:37:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:37:00 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' , '2788' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.37' , NOW() , NOW() ) 20/09/2022 11:37:00 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 = '61873' 20/09/2022 11:37:00 am >> DELETE FROM ps_document_detail WHERE id_document = '61873' 20/09/2022 11:37:00 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 ( '61873' , '19965' , 'ROSARIO FRANCESCANO' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 20/09/2022 11:37:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19965' AND id_supplier = '' 20/09/2022 11:37:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19965' , '' , '1' ) 20/09/2022 11:37:00 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 ( '61873' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/09/2022 11:37:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/09/2022 11:37:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/09/2022 11:50:54 am >> DELETE FROM ps_product WHERE id_product = '9843' 20/09/2022 11:50:54 am >> DELETE FROM ps_product_shop WHERE id_product = '9843' 20/09/2022 11:50:54 am >> DELETE FROM ps_product_lang WHERE id_product = '9843' 20/09/2022 11:50:54 am >> DELETE FROM ps_stock_available WHERE id_product = '9843' 20/09/2022 11:53:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:53:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2789' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.48' , '95.48' , NOW() , NOW() ) 20/09/2022 11:53: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 = '61874' 20/09/2022 11:53:45 am >> DELETE FROM ps_document_detail WHERE id_document = '61874' 20/09/2022 11:53: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 ( '61874' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '' , '1' ) 20/09/2022 11:53: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 ( '61874' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17713' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17713' , '' , '1' ) 20/09/2022 11:53: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 ( '61874' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17127' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17127' , '' , '1' ) 20/09/2022 11:53: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 ( '61874' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17852' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17852' , '' , '1' ) 20/09/2022 11:53: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 ( '61874' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '' , '1' ) 20/09/2022 11:53: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 ( '61874' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 20/09/2022 11:53: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 ( '61874' , '19807' , 'GIOVANI FEDE, VOCAZIONE... - AAVV' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19807' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19807' , '' , '1' ) 20/09/2022 11:53: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 ( '61874' , '19472' , 'SINODALITA ... - U SARTORI' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 20/09/2022 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19472' AND id_supplier = '' 20/09/2022 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19472' , '' , '1' ) 20/09/2022 11:57:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1958' AND id_document != '58806' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-17') 20/09/2022 11:57:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1958', document_date = '2022-06-17', 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 = '13.00', price_tax_excluded = '10.66', date_upd = NOW() WHERE id_document = '58806' 20/09/2022 11:57:16 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 = '58806' 20/09/2022 11:57:16 am >> DELETE FROM ps_document_detail WHERE id_document = '58806' 20/09/2022 11:57:16 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 ( '58806' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.40' ) 20/09/2022 11:57:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 20/09/2022 11:57:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 20/09/2022 11:57:16 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 ( '58806' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '21' , '-21' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '12.60' ) 20/09/2022 11:57:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '9132' AND id_supplier = '' 20/09/2022 11:57:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9132' , '' , '1' ) 20/09/2022 11:59:11 am >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 11:59:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '71/A' , '2022-09-20' , 'A' , '71' , '0' , '71' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '740.00' , '606.56' , NOW() , NOW() ) 20/09/2022 11:59: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 = '61875' 20/09/2022 11:59:11 am >> DELETE FROM ps_document_detail WHERE id_document = '61875' 20/09/2022 11:59: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 ( '61875' , '18881' , 'STOLA POLIESTERE - PST020' , '40' , '-40' , '1' , '18.5' , '15.16393442623' , '22' , '0' , '740.00' ) 20/09/2022 11:59:22 am >> DELETE FROM ps_document WHERE id_document = '61875' 20/09/2022 11:59:22 am >> DELETE FROM ps_document_detail WHERE id_document = '61875' 20/09/2022 12:01:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 12:01:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2790' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '740.00' , '606.56' , NOW() , NOW() ) 20/09/2022 12:01:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61876' 20/09/2022 12:01:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '61876' 20/09/2022 12:01:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61876' , '18881' , 'STOLA POLIESTERE - PST020' , '40' , '-40' , '1' , '18.5' , '15.16393442623' , '22' , '0' , '740.00' ) 20/09/2022 12:01:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18881' AND id_supplier = '' 20/09/2022 12:01:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18881' , '' , '1' ) 20/09/2022 12:05:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 12:05:01 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' , '2791' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.45' , '74.37' , NOW() , NOW() ) 20/09/2022 12:05:01 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 = '61877' 20/09/2022 12:05:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '61877' 20/09/2022 12:05:01 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 ( '61877' , '1090' , 'BIBBIA' , '5' , '-5' , '4' , '9.90' , '9.9' , '0' , '5' , '47.05' ) 20/09/2022 12:05:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '' 20/09/2022 12:05:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '' , '1' ) 20/09/2022 12:05:01 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 ( '61877' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/09/2022 12:05:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/09/2022 12:05:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/09/2022 12:05:01 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 ( '61877' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 20/09/2022 12:05:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/09/2022 12:05:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/09/2022 12:05:01 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 ( '61877' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 20/09/2022 12:05:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/09/2022 12:05:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/09/2022 12:15:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2049' AND id_document != '58906' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 20/09/2022 12:15:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2049', document_date = '2022-06-25', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '58906' 20/09/2022 12:15:01 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 = '58906' 20/09/2022 12:15:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '58906' 20/09/2022 12:15:01 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 ( '58906' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/09/2022 12:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 20/09/2022 12:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 20/09/2022 12:15:01 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 ( '58906' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '6' , '-6' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '3.60' ) 20/09/2022 12:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9132' AND id_supplier = '' 20/09/2022 12:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9132' , '' , '1' ) 20/09/2022 12:15:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2560' AND id_document != '61078' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-30') 20/09/2022 12:15:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2560', document_date = '2022-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 = '1.20', price_tax_excluded = '0.98', date_upd = NOW() WHERE id_document = '61078' 20/09/2022 12:15:29 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 = '61078' 20/09/2022 12:15:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '61078' 20/09/2022 12:15:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61078' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '2' , '-2' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '1.20' ) 20/09/2022 12:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9132' AND id_supplier = '' 20/09/2022 12:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9132' , '' , '1' ) 20/09/2022 12:15:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2698' AND id_document != '61751' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-09') 20/09/2022 12:15:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2698', document_date = '2022-09-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.55', price_tax_excluded = '27.68', date_upd = NOW() WHERE id_document = '61751' 20/09/2022 12:15:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61751' 20/09/2022 12:15:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '61751' 20/09/2022 12:15: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 ( '61751' , '9112' , 'ROSARIO FRANCESCANO - GRANI PICCOLI - 1535' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/09/2022 12:15:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9112' AND id_supplier = '' 20/09/2022 12:15:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9112' , '' , '1' ) 20/09/2022 12:15: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 ( '61751' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '3' , '-3' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '1.80' ) 20/09/2022 12:15:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9132' AND id_supplier = '' 20/09/2022 12:15:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9132' , '' , '1' ) 20/09/2022 12:15: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 ( '61751' , '19582' , 'SACRA BIBBIA TASC. TELATA' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 20/09/2022 12:15:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19582' AND id_supplier = '' 20/09/2022 12:15:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19582' , '' , '1' ) 20/09/2022 12:16:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2737' AND id_document != '61804' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-15') 20/09/2022 12:16:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2737', document_date = '2022-09-15', 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 = '19.70', price_tax_excluded = '16.33', date_upd = NOW() WHERE id_document = '61804' 20/09/2022 12:16:35 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 = '61804' 20/09/2022 12:16:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '61804' 20/09/2022 12:16:35 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 ( '61804' , '19723' , 'ROSARIO COPPIGLIATO MM8 - RE1715-SM' , '1' , '-1' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '11.50' ) 20/09/2022 12:16:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19723' AND id_supplier = '' 20/09/2022 12:16:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19723' , '' , '1' ) 20/09/2022 12:16:35 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 ( '61804' , '18221' , 'CATENINA CON CROCE - NS049' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 20/09/2022 12:16:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18221' AND id_supplier = '' 20/09/2022 12:16:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18221' , '' , '1' ) 20/09/2022 12:16:35 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 ( '61804' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 20/09/2022 12:16:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 20/09/2022 12:16:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 20/09/2022 12:16:35 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 ( '61804' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '4' , '-4' , '1' , '0.55' , '0.45081967213115' , '22' , '0' , '2.20' ) 20/09/2022 12:16:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9132' AND id_supplier = '' 20/09/2022 12:16:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9132' , '' , '1' ) 20/09/2022 12:22:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 12:22: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 ( '24' , '71/A' , '2022-09-20' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.60' , '43.93' , NOW() , NOW() ) 20/09/2022 12:22:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61878' 20/09/2022 12:22:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '61878' 20/09/2022 12:24:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '61878' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 12:24:19 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '71/A', document_date = '2022-09-20', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '53.60', price_tax_excluded = '43.93', date_upd = NOW() WHERE id_document = '61878' 20/09/2022 12:24:19 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 = '61878' 20/09/2022 12:24:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '61878' 20/09/2022 12:24:19 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 ( '61878' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 20/09/2022 12:24:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 20/09/2022 12:24:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 20/09/2022 12:24:19 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 ( '61878' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 20/09/2022 12:24:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 20/09/2022 12:24:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 20/09/2022 12:24:19 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 ( '61878' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '8.40' ) 20/09/2022 12:24:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 20/09/2022 12:24:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 20/09/2022 12:24:19 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 ( '61878' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '4.20' ) 20/09/2022 12:24:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 20/09/2022 12:24:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 20/09/2022 12:30:50 pm >> DELETE FROM ps_document WHERE id_document = '60531' 20/09/2022 12:30:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '60531' 20/09/2022 12:31:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 12:31:47 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' , '2792' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.60' , '143.72' , NOW() , NOW() ) 20/09/2022 12:31:47 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 = '61879' 20/09/2022 12:31:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '61879' 20/09/2022 12:31: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 ( '61879' , '15387' , 'VESTINA BATTESIMALE ' , '60' , '-60' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '150.00' ) 20/09/2022 12:31:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 20/09/2022 12:31:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 20/09/2022 12:31: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 ( '61879' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 20/09/2022 12:31:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/09/2022 12:31:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/09/2022 12:31: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 ( '61879' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 20/09/2022 12:31:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 20/09/2022 12:31:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 20/09/2022 12:36:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2394' AND id_document != '59841' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-29') 20/09/2022 12:36:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2394', document_date = '2022-07-29', 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 = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '59841' 20/09/2022 12:36:29 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 = '59841' 20/09/2022 12:36:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '59841' 20/09/2022 12:36:29 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 ( '59841' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '4.70' ) 20/09/2022 12:36:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 20/09/2022 12:36:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 20/09/2022 12:36:29 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 ( '59841' , '11691' , 'BRACCIALE TRECCIA DECINA - 818/7' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 20/09/2022 12:36:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11691' AND id_supplier = '' 20/09/2022 12:36:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11691' , '' , '1' ) 20/09/2022 04:29:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '61' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:29:47 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 ( '21' , '61' , '2022-09-20' , '' , '3389' , '0' , '4670152' , 'VIA DELLA SCAFFA 171 00054 FIUMICINO' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 20/09/2022 04:29:47 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 = '6076' 20/09/2022 04:29:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '6076' 20/09/2022 04:29: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 ( '6076' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 20/09/2022 04:32:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:32:25 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' , '2793' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '348.51' , '341.18' , NOW() , NOW() ) 20/09/2022 04:32:25 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 = '61880' 20/09/2022 04:32:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '61880' 20/09/2022 04:32:25 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 ( '61880' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 20/09/2022 04:32:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1671' AND id_supplier = '' 20/09/2022 04:32:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1671' , '' , '1' ) 20/09/2022 04:32:25 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 ( '61880' , '14439' , 'CARLO MARIA MARTINI' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14439' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14439' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14440' , 'GINO BARTALI' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14440' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14440' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14441' , 'LORENZO MILANI' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14441' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14441' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14442' , 'MALALA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14442' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14442' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14443' , 'MARCELLO CANDIA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14443' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14443' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14445' , 'CHIARA LUBICH' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14445' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14445' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14444' , 'CARLO GNOCCHI' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14444' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14444' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14446' , 'EUGENIA BONETTI' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14446' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14446' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14447' , 'ROSARIO LIVATINO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14447' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14447' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '14448' , 'GIORGIO LA PIRA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14448' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14448' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '19482' , 'MARIA NELLA NOTTE DELLA FEDE - M. T. DI CALCUTTA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19482' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19482' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '19484' , 'DONO DI LIBERTA - M. KOLBE' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19484' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19484' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '19764' , 'PRIMO PASSO - TACCUINO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19764' AND id_supplier = '' 20/09/2022 04:32:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19764' , '' , '1' ) 20/09/2022 04:32:26 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 ( '61880' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '-1' , '4' , '11.50' , '11.5' , '0' , '5' , '10.93' ) 20/09/2022 04:32:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '0.15' , '0.15' , '0' , '0' , '1.50' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '19202' , 'LETTERA AGLI SPOSI' , '6' , '-6' , '4' , '3.00' , '3' , '0' , '5' , '17.10' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19202' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19202' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '19542' , 'LETTERA AGLI SPOSI' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '5' , '13.32' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19542' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19542' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '13' , '-13' , '4' , '1.20' , '1.2' , '0' , '0' , '15.60' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18376' , 'NOSTALGIA DEL PANE - L. EPICOCO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18376' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18376' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18377' , 'CHI RESTA SALDO? - E. BIANCHI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18377' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18377' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18378' , 'RAGIONE E IL CORAGGIO - A. COMASTRI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18378' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18378' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18379' , 'STUPIDITA - D. BONHOEFFER' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18379' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18379' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18381' , 'DIREZIONE PER CUI SI AVANZA - A. CANOPI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18381' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18381' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18380' , 'BELLEZZA DELLORDINE - S. WEIL' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18380' AND id_supplier = '' 20/09/2022 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18380' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18382' , 'MADRE E IL FIGLIO - G. RAVASI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18382' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18382' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18383' , 'TALENTO DI VIVERE TUTTO - E. HILLESUM' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18383' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18383' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18384' , 'SULLE TRACCE DI GESU - C. MARTINI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18384' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18384' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '18385' , 'LETTERA A GESU NEL DESERTO - T. BELLO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18385' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18385' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '6' , '-6' , '4' , '5.50' , '5.5' , '0' , '5' , '31.38' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5559' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5559' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '11151' , 'LIBRI' , '16' , '-16' , '4' , '1.5' , '1.5' , '0' , '0' , '24.00' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 20/09/2022 04:32: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 ( '61880' , '9948' , 'SFERA DIAMETRO MM 100' , '6' , '-6' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '39.00' ) 20/09/2022 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 20/09/2022 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 20/09/2022 04:33:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '118' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:33:16 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 ( '21' , '118' , '2022-09-20' , '' , '3553' , '0' , '4671021' , 'VIALE ITALIA 83100 AVELLINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 20/09/2022 04:33:16 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 = '61881' 20/09/2022 04:33:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '61881' 20/09/2022 04:33:16 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 ( '61881' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '100' , '-100' , '4' , '1.00' , '1' , '0' , '15' , '85.00' ) 20/09/2022 04:42:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:42:57 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' , '2794' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 20/09/2022 04:42:57 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 = '61882' 20/09/2022 04:42:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '61882' 20/09/2022 04:42:57 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 ( '61882' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 20/09/2022 04:42:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 20/09/2022 04:42:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 20/09/2022 04:43:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:43:10 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' , '2795' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 20/09/2022 04:43:10 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 = '61883' 20/09/2022 04:43:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '61883' 20/09/2022 04:43:10 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 ( '61883' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 20/09/2022 04:43:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 20/09/2022 04:43:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 20/09/2022 04:43:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:43:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2796' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.05' , '10.05' , NOW() , NOW() ) 20/09/2022 04:43:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61884' 20/09/2022 04:43:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '61884' 20/09/2022 04:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61884' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/09/2022 04:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 20/09/2022 04:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 20/09/2022 04:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61884' , '7896' , 'PERDONO GUARISCE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 20/09/2022 04:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7896' AND id_supplier = '' 20/09/2022 04:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7896' , '' , '1' ) 20/09/2022 04:43:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61884' , '8352' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 20/09/2022 04:43:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8352' AND id_supplier = '' 20/09/2022 04:43:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8352' , '' , '1' ) 20/09/2022 04:53:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:53: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' , '2797' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '33.65' , NOW() , NOW() ) 20/09/2022 04:53: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 = '61885' 20/09/2022 04:53:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '61885' 20/09/2022 04:53: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 ( '61885' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 20/09/2022 04:53:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 20/09/2022 04:53:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 20/09/2022 04:53: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 ( '61885' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 20/09/2022 04:53:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 20/09/2022 04:53:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 20/09/2022 04:53: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 ( '61885' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 20/09/2022 04:53:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 20/09/2022 04:53:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 20/09/2022 04:54:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 04:54: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' , '2798' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.16' , '14.16' , NOW() , NOW() ) 20/09/2022 04:54: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 = '61886' 20/09/2022 04:54:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '61886' 20/09/2022 04:54: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 ( '61886' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 20/09/2022 04:54:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19388' AND id_supplier = '' 20/09/2022 04:54:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19388' , '' , '1' ) 20/09/2022 05:00:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 05:00:36 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' , '2799' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.40' , '30.66' , NOW() , NOW() ) 20/09/2022 05:00:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61887' 20/09/2022 05:00:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '61887' 20/09/2022 05:00:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61887' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '18' , '-18' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '36.00' ) 20/09/2022 05:00:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 20/09/2022 05:00:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 20/09/2022 05:00:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61887' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 20/09/2022 05:00:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 20/09/2022 05:00:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 20/09/2022 05:02:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2717' AND id_document != '61776' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 20/09/2022 05:02:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2717', document_date = '2022-09-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '60.12', date_upd = NOW() WHERE id_document = '61776' 20/09/2022 05:02: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 = '61776' 20/09/2022 05:02:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '61776' 20/09/2022 05:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61776' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/09/2022 05:02:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 20/09/2022 05:02:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 20/09/2022 05:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61776' , '17966' , 'DEI VIZI E DELLE VIRTU - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 20/09/2022 05:02:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17966' AND id_supplier = '' 20/09/2022 05:02:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17966' , '' , '1' ) 20/09/2022 05:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61776' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 20/09/2022 05:02:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 20/09/2022 05:02:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 20/09/2022 05:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61776' , '18897' , 'BRACCIALE DECINA PIETRA - BC1843' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 20/09/2022 05:02:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18897' AND id_supplier = '' 20/09/2022 05:02:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18897' , '' , '1' ) 20/09/2022 05:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61776' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/09/2022 05:02:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 20/09/2022 05:02:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 20/09/2022 05:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61776' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35.8000' , '29.344262295082' , '22' , '0' , '35.80' ) 20/09/2022 05:02:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 20/09/2022 05:02:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 20/09/2022 05:14:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 05:14:04 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 ( '24' , '9' , '2022-09-20' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1380.00' , '1380.00' , NOW() , NOW() ) 20/09/2022 05:14:04 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 = '6077' 20/09/2022 05:14:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '6077' 20/09/2022 05:14:04 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 ( '6077' , '33' , '100 GIORNI CON LO SPIRITO' , '88' , '-88' , '4' , '7.50' , '7.5' , '0' , '0' , '660.00' ) 20/09/2022 05:14: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 ( '6077' , '111' , 'I NONNI SONO UN TESORO' , '400' , '-400' , '4' , '1.80' , '1.8' , '0' , '0' , '720.00' ) 20/09/2022 05:17:34 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' , '312/22' , '2022-06-23' , '22' , '0' , '129' , '74680480' , 'STRADA STATALE 7/bis 45-47 83030 MANOCALZATI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1774.24' , '1706.00' , NOW() , NOW() ) 20/09/2022 05:17:34 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 = '6078' 20/09/2022 05:17:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '6078' 20/09/2022 05:17:34 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 ( '6078' , '33' , '100 GIORNI CON LO SPIRITO' , '995' , '995' , '3' , '1.714573' , '1.6486278846154' , '4' , '0' , '1774.2401' ) 20/09/2022 05:17:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '33' AND id_supplier = '129' 20/09/2022 05:17:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '33' , '129' , '1' ) 20/09/2022 05:20:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 05:20:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '23' , '2022-09-20' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9650.00' , '9650.00' , NOW() , NOW() ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61888' 20/09/2022 05:20:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '61888' 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '4154' , 'FESTA DEL PERDONO' , '1050' , '-1050' , '4' , '3.00' , '3' , '0' , '0' , '3150.00' ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '2679' , 'CONOSCERE GESU\'' , '1020' , '-1020' , '4' , '3.50' , '3.5' , '0' , '0' , '3570.00' ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '160' , '-160' , '4' , '3.50' , '3.5' , '0' , '0' , '560.00' ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '160' , '-160' , '4' , '3.50' , '3.5' , '0' , '0' , '560.00' ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '160' , '-160' , '4' , '3.50' , '3.5' , '0' , '0' , '560.00' ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '500' , '-500' , '4' , '2.50' , '2.5' , '0' , '0' , '1250.00' ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '' , 'CALENDARI OMAGGIO' , '0' , '0' , '4' , '0' , '0' , '0' , '0' , '0.00' ) 20/09/2022 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61888' , '' , 'CATALOGHI' , '1' , '-1' , '4' , '0' , '0' , '0' , '0' , '0' ) 20/09/2022 05:22:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 05:22: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' , '2800' , '2022-09-20' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.25' , '9.08' , NOW() , NOW() ) 20/09/2022 05:22: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 = '61889' 20/09/2022 05:22:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '61889' 20/09/2022 05:22: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 ( '61889' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/09/2022 05:22:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 20/09/2022 05:22:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 20/09/2022 05:22:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61889' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 20/09/2022 05:22:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '' 20/09/2022 05:22:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '' , '1' ) 20/09/2022 05:23:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '32/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 05:23: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 ( '23' , '32/E' , '2022-09-20' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '816.00' , '668.85' , NOW() , NOW() ) 20/09/2022 05:23: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 = '61890' 20/09/2022 05:23:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '61890' 20/09/2022 05:23: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 ( '61890' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 20/09/2022 05:23: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 ( '61890' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 20/09/2022 05:23: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 ( '61890' , '12849' , 'LIBRO DELLE SS. MESSE' , '20' , '-20' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '240.00' ) 20/09/2022 05:26:17 pm >> DELETE FROM ps_document WHERE id_document = '5382' 20/09/2022 05:26:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '5382' 20/09/2022 05:26:38 pm >> DELETE FROM ps_document WHERE id_document = '5381' 20/09/2022 05:26:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '5381' 20/09/2022 05:26:50 pm >> DELETE FROM ps_document WHERE id_document = '5377' 20/09/2022 05:26:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '5377' 20/09/2022 05:29:58 pm >> DELETE FROM ps_document WHERE id_document = '5379' 20/09/2022 05:29:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '5379' 20/09/2022 05:31:10 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' , '158/22' , '2022-07-15' , '22' , '0' , '127' , '4670269' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '4241.95' , '4078.80' , NOW() , NOW() ) 20/09/2022 05:31:10 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 = '6079' 20/09/2022 05:31:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '6079' 20/09/2022 05:31:10 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 ( '6079' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1030' , '1030' , '3' , '3.96' , '3.8076923076923' , '4' , '0' , '4241.9520' ) 20/09/2022 05:31:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '127' 20/09/2022 05:31:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '127' , '1' ) 20/09/2022 05:43:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '62' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 05:43:12 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 ( '21' , '62' , '2022-09-20' , '' , '3487' , '0' , '4670192' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '369.00' , '369.00' , NOW() , NOW() ) 20/09/2022 05:43:12 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 = '6080' 20/09/2022 05:43:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '6080' 20/09/2022 05:43:12 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 ( '6080' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '10' , '-10' , '4' , '18.00' , '18' , '0' , '50' , '90.00' ) 20/09/2022 05:43:12 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 ( '6080' , '111' , 'I NONNI SONO UN TESORO' , '310' , '-310' , '4' , '1.80' , '1.8' , '0' , '50' , '279.00' ) 20/09/2022 05:44:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 05:44:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '18/S' , '2022-09-20' , 'S' , '3487' , '' , '4670192' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '369.00' , '369.00' , NOW() , NOW() ) 20/09/2022 05:44:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6081' 20/09/2022 05:44:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '6081' 20/09/2022 05:44:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6081' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '10' , '-10' , '4' , '18.0000' , '18' , '0' , '50' , '90.00' ) 20/09/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 20/09/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 20/09/2022 05:44:04 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 ( '6081' , '111' , 'I NONNI SONO UN TESORO' , '310' , '-310' , '4' , '1.8000' , '1.8' , '0' , '50' , '279.00' ) 20/09/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '111' AND id_supplier = '' 20/09/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '111' , '' , '1' ) 20/09/2022 05:44:14 pm >> DELETE FROM ps_document WHERE id_document = '6080' 20/09/2022 05:44:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '6080' 20/09/2022 06:15:40 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Um3Eozgc0ISuDgx4' , NOW() , NOW() ) 20/09/2022 06:15:40 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3904' , '1' ) 20/09/2022 06:15:40 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3904' , '2' ) 20/09/2022 06:15:40 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3904' , '3' ) 20/09/2022 06:16:05 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'oDiljREvieXUbXsk' , NOW() , NOW() ) 20/09/2022 06:16:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3905' , '1' ) 20/09/2022 06:16:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3905' , '2' ) 20/09/2022 06:16:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3905' , '3' ) 20/09/2022 06:21:54 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3905' 20/09/2022 06:21:54 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3905' , '10' , '135' , 'PARR. S. MARIA ASS.' , 'CARMINATI' , 'DON DANIELE' , 'PIAZZA VITTORIO EMANUELE II 1' , '' , '24040' , 'BONATE SOPRA' , '' , '035991145' , '' , '' , '82002990164' , NOW() , NOW() ) 20/09/2022 06:21:54 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3905' 20/09/2022 06:23:28 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3905' 20/09/2022 06:23:28 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3905' , '10' , '135' , 'PARR. S. MARIA ASS.' , 'CARMINATI' , 'DON DANIELE' , 'PIAZZA VITTORIO EMANUELE II 1' , '' , '24040' , 'BONATE SOPRA' , '' , '035991145' , '' , '' , '82002990164' , NOW() , NOW() ) 20/09/2022 06:23:28 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3905' 20/09/2022 06:24:20 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '5pT4KIk9fBqUDQ1S' , NOW() , NOW() ) 20/09/2022 06:24:20 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6979' , '1' ) 20/09/2022 06:24:20 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6979' , '2' ) 20/09/2022 06:24:20 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6979' , '3' ) 20/09/2022 07:04:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 20/09/2022 07:04:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '2835.00', price_tax_excluded = '2323.77', date_upd = NOW() WHERE id_document = '56617' 20/09/2022 07:04:29 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 = '56617' 20/09/2022 07:04:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 20/09/2022 07:04:29 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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 20/09/2022 07:04:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 20/09/2022 07:04:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 20/09/2022 07:04:29 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 ( '56617' , '19961' , 'AMITTO M/LANA - 099' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 20/09/2022 07:04:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19961' AND id_supplier = '' 20/09/2022 07:04:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19961' , '' , '1' ) 20/09/2022 07:04:29 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 ( '56617' , '19799' , 'CAMICE MARIANO IN LANA - 0774/06' , '1' , '-1' , '1' , '265.00' , '217.2131147541' , '22' , '0' , '265.00' ) 20/09/2022 07:04:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19799' AND id_supplier = '' 20/09/2022 07:04:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19799' , '' , '1' ) 20/09/2022 07:04:29 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 ( '56617' , '' , 'COTTA ' , '1' , '-1' , '1' , '680' , '557.37704918033' , '22' , '0' , '680.00' ) 20/09/2022 07:04:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 20/09/2022 07:04:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 20/09/2022 07:07:29 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '337', document_date = '2022-09-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670978', address1 = 'VIA TORQUATO TASSO 10 24020 GORLE', 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 = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '61857' 20/09/2022 07:07:29 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 = '61857' 20/09/2022 07:07:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '61857' 20/09/2022 07:07:29 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 ( '61857' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '500' , '500' , '4' , '2.5000' , '2.5' , '0' , '0' , '1250.00' ) 20/09/2022 07:07:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '' 20/09/2022 07:07:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '' , '1' ) 20/09/2022 07:07:29 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 ( '61857' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '500' , '500' , '4' , '2.50' , '2.5' , '0' , '0' , '1250.0000' ) 20/09/2022 07:07:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '' 20/09/2022 07:07:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '' , '1' ) 20/09/2022 07:08:52 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '342', document_date = '2022-09-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670978', address1 = 'VIA TORQUATO TASSO 10 24020 GORLE', 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 = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '61858' 20/09/2022 07:08:52 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 = '61858' 20/09/2022 07:08:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '61858' 20/09/2022 07:08:52 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 ( '61858' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '500' , '500' , '4' , '2.5000' , '2.5' , '0' , '0' , '1250.00' ) 20/09/2022 07:08:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 20/09/2022 07:08:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 20/09/2022 07:08:52 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 ( '61858' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '500' , '500' , '4' , '2.50' , '2.5' , '0' , '0' , '1250.0000' ) 20/09/2022 07:08:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 20/09/2022 07:08:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 20/09/2022 07:09:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 07:09:10 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 ( '24' , '24' , '2022-09-20' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'SPEDITI DA VELAR' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2500.00' , '2500.00' , NOW() , NOW() ) 20/09/2022 07:09:10 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 = '61891' 20/09/2022 07:09:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '61891' 20/09/2022 07:10:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '61891' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-20') 20/09/2022 07:10:49 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '24', document_date = '2022-09-20', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'SPEDITI DA VELAR', 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 = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '61891' 20/09/2022 07:10:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61891' 20/09/2022 07:10:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '61891' 20/09/2022 07:10:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61891' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '500' , '-500' , '4' , '2.50' , '2.5' , '0' , '0' , '1250.00' ) 20/09/2022 07:10:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 20/09/2022 07:10:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 20/09/2022 07:10:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61891' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '500' , '-500' , '4' , '2.50' , '2.5' , '0' , '0' , '1250.00' ) 20/09/2022 07:10:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '' 20/09/2022 07:10:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '' , '1' ) 20/09/2022 07:32:38 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' , '4787/00' , '2022-09-19' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO FUORI CATALOGO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '594.00' , '594.00' , NOW() , NOW() ) 20/09/2022 07:32:38 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 = '61892' 20/09/2022 07:32:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '61892' 20/09/2022 07:32:38 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 ( '61892' , '19160' , 'PERCHE\' IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '297' , '297' , '4' , '2.00' , '2' , '0' , '0' , '594.0000' ) 20/09/2022 07:33:38 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' , '4786/00' , '2022-09-19' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO - V. E.' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.00' , '93.00' , NOW() , NOW() ) 20/09/2022 07:33:38 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 = '6082' 20/09/2022 07:33:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '6082' 20/09/2022 07:33:38 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 ( '6082' , '111' , 'I NONNI SONO UN TESORO' , '62' , '62' , '4' , '1.5' , '1.5' , '0' , '0' , '93.0000' )