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 ('648','2775','17026','17757','20586','21988','21989','21990','30540','50241','58035') order by m.manufacturers_name