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 ('7136','7145','7146','8716','8896','32980','32982','32992','32993','33014','33019','33020','35744','35767','36456','46834','46835','46836','46837','61875','61876','61877','64513','64514','64515','65869') order by m.manufacturers_name