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 ('603','780','784','1226','1764','1765','1766','2377','2378','3912','3941','3942','5434','6988','7467','7827','23266','25928','30184','30187','31861','59395','59396') order by m.manufacturers_name