31/05/2022 08:35:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '10985' AND id_product != '11888' AND ean13 != '' 31/05/2022 08:35:27 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '10985', date_upd = NOW() WHERE id_product = '11888' 31/05/2022 08:35:27 am >> UPDATE ps_product_lang SET name = 'CORONA GESU\' BAMBINO DI PRAGA', description = '' WHERE id_product = '11888' 31/05/2022 08:35:27 am >> UPDATE ps_product SET wholesale_price = '1.13', on_sale = '0', price = '2.459016393442623' WHERE id_product = '11888' 31/05/2022 08:35:27 am >> UPDATE ps_product_shop SET wholesale_price = '1.13', price = '2.459016393442623', id_tax_rules_group = '1', id_category_default = '106', 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 = '11888' 31/05/2022 08:35:27 am >> DELETE FROM ps_specific_price WHERE id_product = '11888' 31/05/2022 08:35:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '10985' AND id_product != '11888' AND ean13 != '' 31/05/2022 08:35:47 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '10985', date_upd = NOW() WHERE id_product = '11888' 31/05/2022 08:35:47 am >> UPDATE ps_product_lang SET name = 'CORONA GESU\' BAMBINO DI PRAGA', description = '' WHERE id_product = '11888' 31/05/2022 08:35:47 am >> UPDATE ps_product SET wholesale_price = '1.13', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '11888' 31/05/2022 08:35:47 am >> UPDATE ps_product_shop SET wholesale_price = '1.13', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '106', 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 = '11888' 31/05/2022 08:35:47 am >> DELETE FROM ps_specific_price WHERE id_product = '11888' 31/05/2022 08:35:52 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' , '9414/00/2022' , '2022-05-27' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '183.12' , '182.56' , NOW() , NOW() ) 31/05/2022 08:35:52 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 = '58511' 31/05/2022 08:35:52 am >> DELETE FROM ps_document_detail WHERE id_document = '58511' 31/05/2022 08:35: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 ( '58511' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '100' , '100' , '4' , '3.00' , '3' , '0' , '40' , '180.0000' ) 31/05/2022 08:35:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '15746' AND id_supplier = '38' 31/05/2022 08:35:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15746' , '38' , '1' ) 31/05/2022 08:35: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 ( '58511' , '11888' , 'CORONA GESU\' BAMBINO DI PRAGA' , '2' , '2' , '1' , '2.13115' , '1.7468442622951' , '22' , '40' , '3.1200' ) 31/05/2022 08:35:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '11888' AND id_supplier = '38' 31/05/2022 08:35:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11888' , '38' , '1' ) 31/05/2022 09:03:21 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/05/2022 09:03:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19608' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:03:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19608' , '1' , '1' , '2' , NOW() , NOW() ) 31/05/2022 09:03:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19608' , '0' , '1' , '0' , '0' ) 31/05/2022 09:04:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067811' AND id_product != '19608' AND ean13 != '' 31/05/2022 09:04:03 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788801067811', date_upd = NOW() WHERE id_product = '19608' 31/05/2022 09:04:03 am >> UPDATE ps_product_lang SET name = 'GIOPRONET - AAVV', description = '' WHERE id_product = '19608' 31/05/2022 09:04:03 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.475409836065573' WHERE id_product = '19608' 31/05/2022 09:04:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19608' 31/05/2022 09:04:03 am >> DELETE FROM ps_specific_price WHERE id_product = '19608' 31/05/2022 09:04:04 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19608' 31/05/2022 09:04:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19609' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:04:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19609' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19608' 31/05/2022 09:04:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19609' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19608' 31/05/2022 09:05:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832047677' AND id_product != '19609' AND ean13 != '' 31/05/2022 09:05:11 am >> UPDATE ps_product SET id_supplier = '', reference = '2/3', ean13 = '9788832047677', date_upd = NOW() WHERE id_product = '19609' 31/05/2022 09:05:11 am >> UPDATE ps_product_lang SET name = 'CON ABRAMO VERSO GESU\'', description = '' WHERE id_product = '19609' 31/05/2022 09:05:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '19609' 31/05/2022 09:05:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '57', 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 = '19609' 31/05/2022 09:05:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19609' 31/05/2022 09:05:11 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 = '19609' 31/05/2022 09:05:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19610' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:05:11 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 '19610' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19609' 31/05/2022 09:05:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19610' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19609' 31/05/2022 09:05:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067811' AND id_product != '19608' AND ean13 != '' 31/05/2022 09:05:27 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788801067811', date_upd = NOW() WHERE id_product = '19608' 31/05/2022 09:05:27 am >> UPDATE ps_product_lang SET name = 'GIOPRONET - AAVV', description = '' WHERE id_product = '19608' 31/05/2022 09:05:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19608' 31/05/2022 09:05:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19608' 31/05/2022 09:05:27 am >> DELETE FROM ps_specific_price WHERE id_product = '19608' 31/05/2022 09:06:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934437' AND id_product != '19610' AND ean13 != '' 31/05/2022 09:06:31 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934437', date_upd = NOW() WHERE id_product = '19610' 31/05/2022 09:06:31 am >> UPDATE ps_product_lang SET name = 'CHIESA E LIBERTA\' - B. SESBOUE', description = '' WHERE id_product = '19610' 31/05/2022 09:06:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '19610' 31/05/2022 09:06:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19610' 31/05/2022 09:06:31 am >> DELETE FROM ps_specific_price WHERE id_product = '19610' 31/05/2022 09:06:33 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19610' 31/05/2022 09:06:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19611' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:06:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19611' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19610' 31/05/2022 09:06:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19611' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19610' 31/05/2022 09:07:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839920355' AND id_product != '19611' AND ean13 != '' 31/05/2022 09:07:31 am >> UPDATE ps_product SET id_supplier = '', reference = '11/5', ean13 = '9788839920355', date_upd = NOW() WHERE id_product = '19611' 31/05/2022 09:07:31 am >> UPDATE ps_product_lang SET name = 'GENESI DEL BENE E DEL MALE - M.S. SMITH', description = '' WHERE id_product = '19611' 31/05/2022 09:07:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '19611' 31/05/2022 09:07:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19611' 31/05/2022 09:07:31 am >> DELETE FROM ps_specific_price WHERE id_product = '19611' 31/05/2022 09:07: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 = '19611' 31/05/2022 09:07:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19612' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:07: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 '19612' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19611' 31/05/2022 09:07:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19612' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19611' 31/05/2022 09:08:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554787' AND id_product != '19612' AND ean13 != '' 31/05/2022 09:08:26 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788831554787', date_upd = NOW() WHERE id_product = '19612' 31/05/2022 09:08:26 am >> UPDATE ps_product_lang SET name = 'PAROLE DI GESU\' - L. PACOMIO', description = '' WHERE id_product = '19612' 31/05/2022 09:08:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '19612' 31/05/2022 09:08:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19612' 31/05/2022 09:08:26 am >> DELETE FROM ps_specific_price WHERE id_product = '19612' 31/05/2022 09:08:27 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19612' 31/05/2022 09:08:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19613' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:08:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19613' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19612' 31/05/2022 09:08:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19613' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19612' 31/05/2022 09:09:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553827' AND id_product != '19613' AND ean13 != '' 31/05/2022 09:09:16 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788831553827', date_upd = NOW() WHERE id_product = '19613' 31/05/2022 09:09:16 am >> UPDATE ps_product_lang SET name = 'AMICI CON L\'AUREOLA', description = '' WHERE id_product = '19613' 31/05/2022 09:09:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '19613' 31/05/2022 09:09:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19613' 31/05/2022 09:09:16 am >> DELETE FROM ps_specific_price WHERE id_product = '19613' 31/05/2022 09:09:17 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 = '19613' 31/05/2022 09:09:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19614' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:09: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 '19614' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19613' 31/05/2022 09:09:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19614' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19613' 31/05/2022 09:10:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882276003' AND id_product != '19614' AND ean13 != '' 31/05/2022 09:10:17 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788882276003', date_upd = NOW() WHERE id_product = '19614' 31/05/2022 09:10:17 am >> UPDATE ps_product_lang SET name = 'INSEGNACI A PREGARE - J.L. GONZALES', description = '' WHERE id_product = '19614' 31/05/2022 09:10:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '19614' 31/05/2022 09:10:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '248', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19614' 31/05/2022 09:10:17 am >> DELETE FROM ps_specific_price WHERE id_product = '19614' 31/05/2022 09:10:18 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19614' 31/05/2022 09:10:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19615' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:10:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19615' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19614' 31/05/2022 09:10:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19615' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19614' 31/05/2022 09:11:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228931' AND id_product != '19615' AND ean13 != '' 31/05/2022 09:11:31 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788892228931', date_upd = NOW() WHERE id_product = '19615' 31/05/2022 09:11:31 am >> UPDATE ps_product_lang SET name = 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA', description = '' WHERE id_product = '19615' 31/05/2022 09:11:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '19615' 31/05/2022 09:11:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '141', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19615' 31/05/2022 09:11:31 am >> DELETE FROM ps_specific_price WHERE id_product = '19615' 31/05/2022 09:11: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 = '19615' 31/05/2022 09:11:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19616' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:11: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 '19616' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19615' 31/05/2022 09:11:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19616' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19615' 31/05/2022 09:12:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228993' AND id_product != '19616' AND ean13 != '' 31/05/2022 09:12:42 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788892228993', date_upd = NOW() WHERE id_product = '19616' 31/05/2022 09:12:42 am >> UPDATE ps_product_lang SET name = 'VENTO DI DIO - G. CAROZZA', description = '' WHERE id_product = '19616' 31/05/2022 09:12:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.5' WHERE id_product = '19616' 31/05/2022 09:12:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19616' 31/05/2022 09:12:42 am >> DELETE FROM ps_specific_price WHERE id_product = '19616' 31/05/2022 09:12:43 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 = '19616' 31/05/2022 09:12:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19617' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:12:43 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 '19617' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19616' 31/05/2022 09:12:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19617' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19616' 31/05/2022 09:13:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554978' AND id_product != '19617' AND ean13 != '' 31/05/2022 09:13:36 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9788831554978', date_upd = NOW() WHERE id_product = '19617' 31/05/2022 09:13:36 am >> UPDATE ps_product_lang SET name = 'PREGHIAMO CON IL CREDO - R. GOZZELINO', description = '' WHERE id_product = '19617' 31/05/2022 09:13:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '19617' 31/05/2022 09:13:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19617' 31/05/2022 09:13:36 am >> DELETE FROM ps_specific_price WHERE id_product = '19617' 31/05/2022 09:13:37 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 = '19617' 31/05/2022 09:13:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19618' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:13:37 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 '19618' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19617' 31/05/2022 09:13:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19618' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19617' 31/05/2022 09:14:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249721' AND id_product != '19618' AND ean13 != '' 31/05/2022 09:14:19 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788861249721', date_upd = NOW() WHERE id_product = '19618' 31/05/2022 09:14:19 am >> UPDATE ps_product_lang SET name = 'CARLO ACUTIS', description = '' WHERE id_product = '19618' 31/05/2022 09:14:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '19618' 31/05/2022 09:14:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19618' 31/05/2022 09:14:19 am >> DELETE FROM ps_specific_price WHERE id_product = '19618' 31/05/2022 09:14:20 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 = '19618' 31/05/2022 09:14:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19619' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:14:20 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 '19619' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19618' 31/05/2022 09:14:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19619' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19618' 31/05/2022 09:15:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247148' AND id_product != '19619' AND ean13 != '' 31/05/2022 09:15:10 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788884247148', date_upd = NOW() WHERE id_product = '19619' 31/05/2022 09:15:10 am >> UPDATE ps_product_lang SET name = 'EMOGRAFIE DI NATUZZA EVOLO - V. MARINELLI', description = '' WHERE id_product = '19619' 31/05/2022 09:15:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19619' 31/05/2022 09:15:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '83', 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 = '19619' 31/05/2022 09:15:10 am >> DELETE FROM ps_specific_price WHERE id_product = '19619' 31/05/2022 09:15:11 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 = '19619' 31/05/2022 09:15:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19620' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 09:15:11 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 '19620' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19619' 31/05/2022 09:15:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19620' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19619' 31/05/2022 09:15:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '600783' , '2022-05-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.34' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.72' , '117.72' , NOW() , NOW() ) 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58512' 31/05/2022 09:15:35 am >> DELETE FROM ps_document_detail WHERE id_document = '58512' 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19608' , 'GIOPRONET - AAVV' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35' , '9.1000' ) 31/05/2022 09:15:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19608' AND id_supplier = '7' 31/05/2022 09:15:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19608' , '7' , '1' ) 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19609' , 'CON ABRAMO VERSO GESU' , '1' , '1' , '4' , '3.00' , '3' , '0' , '30' , '2.1000' ) 31/05/2022 09:15:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19609' AND id_supplier = '7' 31/05/2022 09:15:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19609' , '7' , '1' ) 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19610' , 'CHIESA E LIBERTA - B. SESBOUE' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 31/05/2022 09:15:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19610' AND id_supplier = '7' 31/05/2022 09:15:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19610' , '7' , '1' ) 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19611' , 'GENESI DEL BENE E DEL MALE - M.S. SMITH' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 31/05/2022 09:15:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19611' AND id_supplier = '7' 31/05/2022 09:15:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19611' , '7' , '1' ) 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19612' , 'PAROLE DI GESU - L. PACOMIO' , '1' , '1' , '4' , '11.00' , '11' , '0' , '33' , '7.3700' ) 31/05/2022 09:15:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19612' AND id_supplier = '7' 31/05/2022 09:15:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19612' , '7' , '1' ) 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19613' , 'AMICI CON LAUREOLA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 31/05/2022 09:15:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19613' AND id_supplier = '7' 31/05/2022 09:15:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19613' , '7' , '1' ) 31/05/2022 09:15:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19614' , 'INSEGNACI A PREGARE - J.L. GONZALES' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 31/05/2022 09:15:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19614' AND id_supplier = '7' 31/05/2022 09:15:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19614' , '7' , '1' ) 31/05/2022 09:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '30' , '2.4500' ) 31/05/2022 09:15:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '7' 31/05/2022 09:15:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '7' , '1' ) 31/05/2022 09:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 31/05/2022 09:15:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19615' AND id_supplier = '7' 31/05/2022 09:15:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19615' , '7' , '1' ) 31/05/2022 09:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19616' , 'VENTO DI DIO - G. CAROZZA' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '33' , '8.3750' ) 31/05/2022 09:15:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19616' AND id_supplier = '7' 31/05/2022 09:15:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19616' , '7' , '1' ) 31/05/2022 09:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19617' , 'PREGHIAMO CON IL CREDO - R. GOZZELINO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '33' , '2.0100' ) 31/05/2022 09:15:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19617' AND id_supplier = '7' 31/05/2022 09:15:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19617' , '7' , '1' ) 31/05/2022 09:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19618' , 'CARLO ACUTIS' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 31/05/2022 09:15:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19618' AND id_supplier = '7' 31/05/2022 09:15:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19618' , '7' , '1' ) 31/05/2022 09:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58512' , '19619' , 'EMOGRAFIE DI NATUZZA EVOLO - V. MARINELLI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 31/05/2022 09:15:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19619' AND id_supplier = '7' 31/05/2022 09:15:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19619' , '7' , '1' ) 31/05/2022 09:37:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 09:37:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1710' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.70' , '39.13' , NOW() , NOW() ) 31/05/2022 09:37:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58513' 31/05/2022 09:37:19 am >> DELETE FROM ps_document_detail WHERE id_document = '58513' 31/05/2022 09:37:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58513' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 31/05/2022 09:37:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 31/05/2022 09:37:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 31/05/2022 09:37:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58513' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 31/05/2022 09:37:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 31/05/2022 09:37:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 31/05/2022 09:48:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 09:48:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1711' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.70' , '116.38' , NOW() , NOW() ) 31/05/2022 09:48:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58514' 31/05/2022 09:48:14 am >> DELETE FROM ps_document_detail WHERE id_document = '58514' 31/05/2022 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 31/05/2022 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '' 31/05/2022 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '' , '1' ) 31/05/2022 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 31/05/2022 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '' 31/05/2022 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '' , '1' ) 31/05/2022 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/05/2022 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 31/05/2022 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 31/05/2022 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '15805' , 'TREDICINA A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 31/05/2022 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '15805' AND id_supplier = '' 31/05/2022 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15805' , '' , '1' ) 31/05/2022 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 31/05/2022 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '12705' AND id_supplier = '' 31/05/2022 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12705' , '' , '1' ) 31/05/2022 09:48:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '9535' , 'SANTANTONIO DA PADOVA - 381 ' , '1' , '-1' , '1' , '3.49' , '2.8606557377049' , '22' , '0' , '3.49' ) 31/05/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '9535' AND id_supplier = '' 31/05/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9535' , '' , '1' ) 31/05/2022 09:48:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '9384' , 'SAN BARTOLOMEO APOSTOLO - G. PESENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 31/05/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '9384' AND id_supplier = '' 31/05/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9384' , '' , '1' ) 31/05/2022 09:48:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '9533' , 'SANTANNA - F.DI STASIO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 31/05/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '9533' AND id_supplier = '' 31/05/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9533' , '' , '1' ) 31/05/2022 09:48:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '9399' , 'SAN CAMILLO DE LELLIS - F.RUFFINI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 31/05/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '9399' AND id_supplier = '' 31/05/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9399' , '' , '1' ) 31/05/2022 09:48:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58514' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '13' , '-13' , '1' , '2' , '1.6393442622951' , '22' , '0' , '26.00' ) 31/05/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 31/05/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 31/05/2022 09:50:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 09:50:16 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' , '1712' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 31/05/2022 09:50: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 = '58515' 31/05/2022 09:50:16 am >> DELETE FROM ps_document_detail WHERE id_document = '58515' 31/05/2022 09:50: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 ( '58515' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 31/05/2022 09:50:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 31/05/2022 09:50:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 31/05/2022 10:05:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 10:05:33 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' , '1713' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 31/05/2022 10:05:33 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 = '58516' 31/05/2022 10:05:33 am >> DELETE FROM ps_document_detail WHERE id_document = '58516' 31/05/2022 10:05:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58516' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '10' , '-10' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.00' ) 31/05/2022 10:05:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '5105' AND id_supplier = '' 31/05/2022 10:05:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5105' , '' , '1' ) 31/05/2022 10:06:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 10:06: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' , '1714' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 31/05/2022 10:06: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 = '58517' 31/05/2022 10:06:45 am >> DELETE FROM ps_document_detail WHERE id_document = '58517' 31/05/2022 10:06: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 ( '58517' , '14354' , 'CAMICE BENEDETTINO LINO' , '1' , '-1' , '1' , '133' , '109.01639344262' , '22' , '0' , '133.00' ) 31/05/2022 10:06:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 31/05/2022 10:06:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 31/05/2022 10:06: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 ( '58517' , '13175' , 'CLERGY SLIM BLU - MISTO ML 43' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 31/05/2022 10:06:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '13175' AND id_supplier = '' 31/05/2022 10:06:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13175' , '' , '1' ) 31/05/2022 11:18:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1715' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 11:18:04 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' , '1715' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.70' , '22.70' , NOW() , NOW() ) 31/05/2022 11:18:04 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 = '58518' 31/05/2022 11:18:04 am >> DELETE FROM ps_document_detail WHERE id_document = '58518' 31/05/2022 11:18: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 ( '58518' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 31/05/2022 11:18:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 31/05/2022 11:18:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 31/05/2022 11:18: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 ( '58518' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 31/05/2022 11:18:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 31/05/2022 11:18:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 31/05/2022 11:21:47 am >> SELECT document_num FROM ps_document WHERE document_num = '35/A' AND id_document != '56634' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-06') 31/05/2022 11:21:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '35/A', document_date = '2022-05-06', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '292.80', price_tax_excluded = '240.36', date_upd = NOW() WHERE id_document = '56634' 31/05/2022 11:21:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56634' 31/05/2022 11:21:47 am >> DELETE FROM ps_document_detail WHERE id_document = '56634' 31/05/2022 11:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '78.0000' , '63.934426229508' , '22' , '0' , '78.00' ) 31/05/2022 11:21:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '14920' AND id_supplier = '' 31/05/2022 11:21:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14920' , '' , '1' ) 31/05/2022 11:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 31/05/2022 11:21:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 31/05/2022 11:21:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '3074' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3074' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '30' , '-30' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '6.00' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '36' , '-36' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '43.20' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '15' , '32.30' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '7939' , 'PERGAMENE - MATRIMONIO-C' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7939' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7939' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '7929' , 'PERGAMENE - BATTESIMO MOD. C' , '50' , '-50' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '15.00' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7929' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7929' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '11376' , 'VIENI SPIRITO SANTO' , '10' , '-10' , '4' , '0.20' , '0.2' , '0' , '0' , '2.00' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '11376' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11376' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '30' , '-30' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '21.00' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '3045' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3045' , '' , '1' ) 31/05/2022 11:21:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56634' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '15' , '32.30' ) 31/05/2022 11:21:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '12818' AND id_supplier = '' 31/05/2022 11:21:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12818' , '' , '1' ) 31/05/2022 11:22:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 11:22: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' , '1716' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 31/05/2022 11:22: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 = '58519' 31/05/2022 11:22:42 am >> DELETE FROM ps_document_detail WHERE id_document = '58519' 31/05/2022 11:22: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 ( '58519' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/05/2022 11:22:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 31/05/2022 11:22:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 31/05/2022 11:28:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 11:28: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' , '1717' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 31/05/2022 11:28: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 = '58520' 31/05/2022 11:28:51 am >> DELETE FROM ps_document_detail WHERE id_document = '58520' 31/05/2022 11:28: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 ( '58520' , '19330' , 'PRESENZA REALE - M. BELLI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 31/05/2022 11:28:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19330' AND id_supplier = '' 31/05/2022 11:28:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19330' , '' , '1' ) 31/05/2022 11:36:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 11:36:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1718' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 31/05/2022 11:36:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58521' 31/05/2022 11:36:35 am >> DELETE FROM ps_document_detail WHERE id_document = '58521' 31/05/2022 11:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58521' , '15547' , 'SPIRITO SANTO NELLAGIRE UMANO - M. BOHNKE' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 31/05/2022 11:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '15547' AND id_supplier = '' 31/05/2022 11:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15547' , '' , '1' ) 31/05/2022 11:51:47 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4223' 31/05/2022 11:51:47 am >> UPDATE ps_stock_available SET quantity = quantity + '-279' WHERE id_product = '4223' 31/05/2022 11:53:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 11:53:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1719' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.40' , '9.40' , NOW() , NOW() ) 31/05/2022 11:53: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 = '58522' 31/05/2022 11:53:11 am >> DELETE FROM ps_document_detail WHERE id_document = '58522' 31/05/2022 11:53: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 ( '58522' , '15805' , 'TREDICINA A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 31/05/2022 11:53:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '15805' AND id_supplier = '' 31/05/2022 11:53:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15805' , '' , '1' ) 31/05/2022 11:53: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 ( '58522' , '11151' , 'LIBRI' , '24' , '-24' , '4' , '0.35' , '0.35' , '0' , '0' , '8.40' ) 31/05/2022 11:53:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 31/05/2022 11:53:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 31/05/2022 12:35:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607436' AND id_product != '19620' AND ean13 != '' 31/05/2022 12:35:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788826607436', date_upd = NOW() WHERE id_product = '19620' 31/05/2022 12:35:50 pm >> UPDATE ps_product_lang SET name = 'PRAEDICATE EVANGELIUM', description = '' WHERE id_product = '19620' 31/05/2022 12:35:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '19620' 31/05/2022 12:35:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19620' 31/05/2022 12:35:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '19620' 31/05/2022 12:35:51 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19620' 31/05/2022 12:35:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19621' , '1' , '' , 'nuovo-prodotto' ) 31/05/2022 12:35:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19621' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19620' 31/05/2022 12:35:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19621' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19620' 31/05/2022 12:36: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 ( '33' , '2293' , '2022-05-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '6.60' , NOW() , NOW() ) 31/05/2022 12:36: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 = '58523' 31/05/2022 12:36:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '58523' 31/05/2022 12:36: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 ( '58523' , '19620' , 'PRAEDICATE EVANGELIUM' , '2' , '2' , '4' , '6.00' , '6' , '0' , '45' , '6.6000' ) 31/05/2022 12:36:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19620' AND id_supplier = '79' 31/05/2022 12:36:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19620' , '79' , '1' ) 31/05/2022 12:38:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 12:38:28 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' , '1720' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.99' , '9.99' , NOW() , NOW() ) 31/05/2022 12:38:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58524' 31/05/2022 12:38:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '58524' 31/05/2022 12:38: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 ( '58524' , '9499' , 'SAN PIETRO - A.GOVERNALE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 31/05/2022 12:38:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9499' AND id_supplier = '' 31/05/2022 12:38:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9499' , '' , '1' ) 31/05/2022 12:38: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 ( '58524' , '7450' , 'PAOLO - T.BOSCO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 31/05/2022 12:38:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7450' AND id_supplier = '' 31/05/2022 12:38:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7450' , '' , '1' ) 31/05/2022 12:38: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 ( '58524' , '6242' , 'MARIA IMMACOLATA - S. CECCHIN' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 31/05/2022 12:38:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6242' AND id_supplier = '' 31/05/2022 12:38:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6242' , '' , '1' ) 31/05/2022 12:48:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '42/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 12:48:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '42/A' , '2022-05-31' , 'A' , '1178' , '0' , '4671042' , 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 31/05/2022 12:48:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58525' 31/05/2022 12:48:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '58525' 31/05/2022 12:48:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58525' , '' , 'TUNICA' , '1' , '-1' , '0' , '50' , '50' , '' , '0' , '50.00' ) 31/05/2022 04:32:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 04:32:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1721' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 31/05/2022 04:32:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58526' 31/05/2022 04:32:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58526' 31/05/2022 04:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58526' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '47.2' , '38.688524590164' , '22' , '0' , '47.20' ) 31/05/2022 04:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16535' AND id_supplier = '' 31/05/2022 04:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16535' , '' , '1' ) 31/05/2022 04:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58526' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 31/05/2022 04:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 31/05/2022 04:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 31/05/2022 04:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58526' , '16489' , 'CLERGY DIAMANTINO ML - C19' , '1' , '-1' , '1' , '67' , '54.918032786885' , '22' , '0' , '67.00' ) 31/05/2022 04:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16489' AND id_supplier = '' 31/05/2022 04:32:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16489' , '' , '1' ) 31/05/2022 04:32: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 ( '58526' , '1557' , 'CAMICIA PER TALARE P/GEMELLI COTONE - BIANCO ML 42' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '15' , '40.80' ) 31/05/2022 04:32:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1557' AND id_supplier = '' 31/05/2022 04:32:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1557' , '' , '1' ) 31/05/2022 04:32:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 04:32:29 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' , '1722' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/05/2022 04:32: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 = '58527' 31/05/2022 04:32:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '58527' 31/05/2022 04:32: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 ( '58527' , '19375' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/05/2022 04:32:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19375' AND id_supplier = '' 31/05/2022 04:32:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19375' , '' , '1' ) 31/05/2022 04:33:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 04:33:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1723' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.35' , '14.35' , NOW() , NOW() ) 31/05/2022 04:33:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58528' 31/05/2022 04:33:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '58528' 31/05/2022 04:33:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58528' , '529' , 'AMORIS LAETITIA' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '5' , '2.09' ) 31/05/2022 04:33:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '' 31/05/2022 04:33:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '' , '1' ) 31/05/2022 04:33:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58528' , '18171' , 'MARIA - U. DE VANNA' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 31/05/2022 04:33:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18171' AND id_supplier = '' 31/05/2022 04:33:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18171' , '' , '1' ) 31/05/2022 04:57:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '53221' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-03-12') 31/05/2022 04:57:35 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2022-03-12', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4672633', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '147.20', price_tax_excluded = '124.34', date_upd = NOW() WHERE id_document = '53221' 31/05/2022 04:57: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 = '53221' 31/05/2022 04:57:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '53221' 31/05/2022 04:57: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 ( '53221' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 31/05/2022 04:57:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 31/05/2022 04:57:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 31/05/2022 04:57: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 ( '53221' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 31/05/2022 04:57:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 31/05/2022 04:57:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 31/05/2022 04:57: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 ( '53221' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '19.00' ) 31/05/2022 04:57:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 31/05/2022 04:57:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 31/05/2022 04:57: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 ( '53221' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 31/05/2022 04:57:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 31/05/2022 04:57:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 31/05/2022 04:57: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 ( '53221' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 31/05/2022 04:57:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 31/05/2022 04:57:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 31/05/2022 04:57: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 ( '53221' , '18095' , 'CROCE IN ULIVO - 2882' , '1' , '-1' , '1' , '24.80' , '20.327868852459' , '22' , '0' , '24.80' ) 31/05/2022 04:57:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18095' AND id_supplier = '' 31/05/2022 04:57:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18095' , '' , '1' ) 31/05/2022 04:57: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 ( '53221' , '17005' , 'BIGLIETTO AUGURALE medio' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 31/05/2022 04:57:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 31/05/2022 04:57:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 31/05/2022 05:04:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 05:04:08 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' , '1724' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.00' , '113.75' , NOW() , NOW() ) 31/05/2022 05:04:08 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 = '58529' 31/05/2022 05:04:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '58529' 31/05/2022 05:04:08 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 ( '58529' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '4' , '-4' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '60.00' ) 31/05/2022 05:04:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '' 31/05/2022 05:04:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '' , '1' ) 31/05/2022 05:04:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58529' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 31/05/2022 05:04:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 31/05/2022 05:04:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 31/05/2022 05:04:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58529' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '16.00' ) 31/05/2022 05:04:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 31/05/2022 05:04:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 31/05/2022 05:43:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1725' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 05:43:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1725' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 31/05/2022 05:43:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58530' 31/05/2022 05:43:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '58530' 31/05/2022 05:43:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58530' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 31/05/2022 05:43:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 31/05/2022 05:43:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 31/05/2022 06:25:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 06:25:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '91' , '2022-05-31' , '' , '1238' , '0' , '4670917' , 'P.ZZA DUOMO, 1 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '54.40' , '54.40' , NOW() , NOW() ) 31/05/2022 06:25:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58531' 31/05/2022 06:25:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '58531' 31/05/2022 06:25:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58531' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '40' , '-40' , '4' , '1.60' , '1.6' , '0' , '15' , '54.40' ) 31/05/2022 06:26:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1726' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 06:26:19 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' , '1726' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 31/05/2022 06:26: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 = '58532' 31/05/2022 06:26:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '58532' 31/05/2022 06:26: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 ( '58532' , '7202' , 'ARTICOLI RELIGIOSI' , '35' , '-35' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '42.00' ) 31/05/2022 06:26:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 31/05/2022 06:26:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 31/05/2022 06:37:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1727' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 06:37:15 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' , '1727' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.87' , '18.52' , NOW() , NOW() ) 31/05/2022 06:37:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58533' 31/05/2022 06:37:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '58533' 31/05/2022 06:37:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '9664' , 'SAPIENZA - 117' , '50' , '-50' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '7.50' ) 31/05/2022 06:37:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9664' AND id_supplier = '' 31/05/2022 06:37:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9664' , '' , '1' ) 31/05/2022 06:37:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '12712' , 'CRESIMA UNA FESTA DA VIVERE' , '2' , '-2' , '4' , '1.90' , '1.9' , '0' , '5' , '3.62' ) 31/05/2022 06:37:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12712' AND id_supplier = '' 31/05/2022 06:37:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12712' , '' , '1' ) 31/05/2022 06:37:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5+' , '1.90' ) 31/05/2022 06:37:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 31/05/2022 06:37:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 31/05/2022 06:37:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 31/05/2022 06:37:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 31/05/2022 06:37:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 31/05/2022 06:37:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '15125' , 'MESSA DI PRIMA COMUNIONE - 8338' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/05/2022 06:37:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15125' AND id_supplier = '' 31/05/2022 06:37:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15125' , '' , '1' ) 31/05/2022 06:37:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 31/05/2022 06:37:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 31/05/2022 06:37:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 31/05/2022 07:07:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 07:07:23 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' , '1728' , '2022-05-31' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 31/05/2022 07:07:23 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 = '58534' 31/05/2022 07:07:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '58534' 31/05/2022 07:07:23 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 ( '58534' , '17599' , 'STATUA S. MICHELE CM 20 COLORATA - 213SM' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 31/05/2022 07:07:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17599' AND id_supplier = '' 31/05/2022 07:07:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17599' , '' , '1' ) 31/05/2022 07:18:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 31/05/2022 07:18:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo ', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '304.74', price_tax_excluded = '263.41', date_upd = NOW() WHERE id_document = '51968' 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '51968' 31/05/2022 07:18:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968' 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '17402' , 'BRACCIALE ELASTICO ' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17402' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17402' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '46.80' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'sacro cuore' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'MIRACOLOSA' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '9128' , 'ROSARIO LEGNO - RLE5896/5812***oggetti' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9128' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9128' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '1312' , 'BRACCIALE DECINA' , '10' , '-10' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '13.00' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 31/05/2022 07:18:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '11678' , '30/05/2022' , '0' , '0' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 31/05/2022 07:18:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11678' AND id_supplier = '' 31/05/2022 07:18:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11678' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '1319' , 'BRACCIALE DECINA TAU' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '18837' , 'CAPOCULLA PICCOLO MATERNITA' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18837' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18837' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '14.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '7.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '18890' , 'ROSARIO LEGNO - R980' , '12' , '-12' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '12.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18890' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18890' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '19515' , 'AMEN - LUG 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '19516' , 'AMEN - AGO 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '11678' , 'SOPRACULLA - 1132' , '4' , '-4' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '10.00' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11678' AND id_supplier = '' 31/05/2022 07:18:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11678' , '' , '1' ) 31/05/2022 07:18:21 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 ( '51968' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 31/05/2022 07:18:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 31/05/2022 07:18:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 31/05/2022 07:19:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '58531' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-31') 31/05/2022 07:19:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '91', document_date = '2022-05-31', document_letter = '', id_customer = '1238', id_supplier = '', id_address = '4670917', address1 = 'P.ZZA DUOMO, 1 84096 MONTECORVINO ROVELLA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '54.40', price_tax_excluded = '54.40', date_upd = NOW() WHERE id_document = '58531' 31/05/2022 07:19:53 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 = '58531' 31/05/2022 07:19:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58531' 31/05/2022 07:19:53 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 ( '58531' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '40' , '-40' , '4' , '1.6000' , '1.6' , '0' , '15' , '54.40' ) 31/05/2022 07:19:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11103' AND id_supplier = '' 31/05/2022 07:19:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11103' , '' , '1' )