1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by manufacturers_name' at line 5
in:
[select distinct m.manufacturers_id, m.manufacturers_name from manufacturers m left join products p on m.manufacturers_id = p.manufacturers_id where m.manufacturers_id = p.manufacturers_id and p.products_status= 1 AND p.products_id IN () order by manufacturers_name]