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 ('209','378','392','583','600','631','676','767','880','956','958','1076','1180','1211','1238','1244','1251','1343','1344','1370','1443','1487','1498','1524','1629','1676','2252','2257','2258','2260','2263','2267','2269','2339','2560','2561','2576','2579','2583','2664','2833','2837','2853','3650','3743','3760','4553','4554','4651','4658','4659','4660','4665','4689','4693','4701','4703','4707','5035','5036','5040','5361','5368','5371','5768','5775','6217','6219','6284','6293','6345','6429','6556','6577','7166','7417','7601','7708','7791','7793','7874','7881','9172','9349','9644','10492','16954','16957','16965','16982','17032','19223','20236','25477','25687','31074','31409','31451','33234','33425','36758','36847','40252','40405','41020','41128','45433','47210','47212','47216','47586','47587','48141','48226','48308','49340','49813','49816','49822','50247','50601','50618','50806','51366','51388','51505','54317','54594','54693','54831','55536','55582','55583','55588','55592','55593','55794','55903','55968','58090','58219','58254','58522','58523','58524','58697','59016','59273','59359','59410','59416','59419','59421','59535','59542','59812','59856','60038','60289','60295','61219','61503','61504','62256','62257','62258','62259','62344','62345','62989','63886','64718','64719') order by m.manufacturers_name