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 ('607','611','616','775','950','1633','2655','3148','3164','6183','6204','6206','6207','6240','6402','9780','9792','23259','23647','25966','30934','30935','33270','46940','53884','53885','53886','61461') order by m.manufacturers_name