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 ('927','1228','1460','1943','1955','2271','2294','2902','2962','2963','2964','2967','2968','2969','2971','3647','3672','3674','3733','3755','3757','3762','4655','4657','5797','5801','5819','5822','6236','6239','6818','6966','6967','6969','7542','8194','8210','8211','16949','16950','16951','17110','18718','18722','18727','18731','19223','23287','31433','36592','36593','41934','46843','46844','47207','47209','48104','49336','50598','50599','50600','50617','54701','55747','59857','59858','60290','60294') order by m.manufacturers_name