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 pd.products_id = p.products_id and pd.language_id = '2'' at line 13

SELECT pd.products_name, p.products_model, pd.products_meta_title, pd.products_meta_description , pd.products_meta_keywords, pd.products_meta_title, pd.products_description, p.products_status, pd.products_description FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id WHERE p.products_status = '1' and p.products_id = and pd.products_id = p.products_id and pd.language_id = '2'

[XT SQL Error]