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 ('636','762','1077','1449','1475','4654','6344','7480','7613','19227','25016','34889','35243','41134','47208','47214','48039','49812','49815','52437','54832','55590','55594','55794','57943','59408','59409','59411','59415','59537','59540','59811','60286','60292','60294','60296') order by m.manufacturers_name