select distinct m.manufacturers_id, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id where p.products_status = '1' and p.manufacturers_id != '0'and p.products_id in ('386','389','390','391','486','565','582','599','1255','1327','1328','1335','1474','1499','1982','1983','1984','1985','1987','1988','1989','1994','1996','2001','2002','2003','2004','2005','2007','2054','2059','2060','2336','2338','2592','5933','5935','5936','5937','5938','5939','5952','6101','6122','6148','6387','6388','6431','6648','6650','6950','6952','7493','7499','7750','8022','8023','8170','8179','8196','8212','8213','8214','9453','9455','9492','9493','9494','9495','9502','9667','9668','9781','9782','9791','9839','20763','20786','20800','20849','20850','20855','20857','20860','21443','21445','21464','21469','21503','21507','21508','21515','21529','23955','23960','23964','25507','26832','32332','32362','32405','32461','32462','35393','35396','35397','35398','35400','35401','35406','35412','35415','35417','35419','36823','36824','36825','36826','36827','38474','38475','38476','38477','38478','40390','40391','41832','43256','43343','43344','45605','45606','46414','47385','47386','47513','47514','47515','49568','49880','50560','50581','50629','50702','55359','56054','58318','58347','58502','58504','58505','58506','58507','58508','58509','58511','59599','59600','59601','62166','62296','62415','62455','62456','62770','62771','62803','62898','62899','62900','62921','63411','64495','64497','64632','64633','65359','65361','65362') order by m.manufacturers_name