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 ('2665','9354','9355','9356','9358','9718','10306','20685','26304','30153','32000','32001','32004','32007','32012','46867','47725') order by m.manufacturers_name