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 ('20014','20017','63156','63157','63158','63159','63160','63161','63162','63163','63165','63166','63167','63168','63170','63171','63172','63173','63175','64483','64484','64485','64486','64487','64488','64489','64490','64491','64492','64493','64494','64495','64496','64497','64498','64500','64513','64514','64515','64569','64570','64572','64573','64632','64633','64659','64682','64726','64742','64743','64744','64745','64782','64783','64784','64785','65359','65361','65362') order by m.manufacturers_name