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 16

SELECT pd.products_name, p.products_model, p.productskk_manufacturerpn, pd.products_meta_title, pd.products_meta_description , pd.products_meta_keywords, pd.products_meta_title, pd.products_short_description, p.products_status, p.productskk_hersteller, p.productskk_nobumodelname, p.productskk_prodtype, pd.products_description FROM prd_std_0_products p, prd_std_0_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]