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 ('331','527','1050','1824','1866','6931','7184','7494','10418','34181','39615','41968') order by m.manufacturers_name