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 cd.language_id= 1' at line 3
in:
[SELECT pca.categories_id as pid,cd.categories_name FROM products_to_categories as pca left join categories_description as cd on cd.categories_id = pca.categories_id where pca.products_id= and cd.language_id= 1]