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 ') AND products_status = 1)' at line 1

SELECT DISTINCT manufacturers_name FROM manufacturers WHERE manufacturers_id IN (SELECT DISTINCT manufacturers_id FROM products WHERE products_id IN ( ) AND products_status = 1)

[XT SQL Error]