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 ('198','524','559','1152','2145','2146','5584','7461','8242','10431','17116','21931','21933','21935','23400','23524','24651','40134','40135','45474','45866','45870','45872','46708','46777','48706','48707','48708','50817','50864','55657','55658','55823','58176','59086','62627','62628','62629') order by m.manufacturers_name