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 ('641','649','725','726','745','746','747','748','2701','6046','6047','6049','6215','6216','6218','7310','7311','7316','7317','7318','7319','7320','7653','7657','18795','18815','18819','18823','18825','18835','18836','18841','31228','31234','31243','31252','31255','31261','31264','32101','37014','37452','37709','37710','37711','37712','37715','37716','37717','37718','37719','37720','37721','37722','37723','37724','37725','37726','37727','37728','37729','37730','40961','41015','41060','41678','52617','52618','52619','52620','52621','52622') order by m.manufacturers_name