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 ('1104','1139','1263','4066','4067','4414','4415','4416','5347','5348','5669','7185','7407','7704','26750','61456') order by m.manufacturers_name