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 10

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_short_description, p.products_status FROM products p, products_description pd WHERE p.products_status = '1' and p.products_id = and pd.products_id = p.products_id and pd.language_id = '2'

[XT SQL Error]