An Error Was Encountered

Error Number: 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_description.language_id=1 AND status.language_id=1' at line 5

SELECT * FROM products JOIN products_description ON products.products_id = products_description.products_id JOIN status ON products.status = status.status_id WHERE products.products_id = AND products_description.language_id=1 AND status.language_id=1