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 ('540','867','1622','1623','6230','6231','6232','6233','7483','7693','10196','10197','26050','26051','26052','26053','26805','26807','26810','26812') order by m.manufacturers_name