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 p.products_id = pd.products_id
' at line 3
in:
[SELECT distinct p.products_id, pd.products_name, p.products_ordered,p.products_image
FROM products p, products_description pd
WHERE p.products_id in ()
and p.products_id = pd.products_id
and pd.language_id = 2
order by p.products_ordered desc
limit 10]