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 ('387','444','602','637','702','704','705','1105','1202','1206','1234','1250','1260','1451','1942','1943','1949','1950','1951','2015','2254','2256','2261','2264','2266','2270','2271','2294','2299','3643','3644','3645','3731','3733','3738','3739','3742','3747','3752','3756','4669','4672','4682','4691','4692','4704','5013','5014','5630','5767','5769','5770','5771','5772','5774','6554','6555','6557','6558','6559','6571','6572','6628','6647','6859','7411','7518','7544','7868','9614','9615','16953','16955','16956','16958','16983','16984','17110','19206','19210','19211','19224','19226','19227','19295','24444','25015','33244','33427','34350','34354','35241','36759','39359','39396','39998','40415','40416','41131','41133','43373','43863','43864','44652','47211','47215','48452','49192','49337','49339','50243','50285','51367','51480','53758','53898','53899','53900','54198','54199','54201','54779','54780','54864','55576','55577','55585','55589','55591','55811','55902','55905','58269','58525','58526','59414','59417','59420','59536','59855','60288','60293','60299','60302','62988','62990','62991','64715','64716','64717') order by m.manufacturers_name