SELECT p.*, pl.*, cl.slug as clslug FROM product p, product_lang pl, category c, category_lang cl WHERE p.product_id=pl.product_id AND pl.lang_id=1 AND c.category_id=p.category_id AND c.category_id=cl.category_id AND cl.lang_id=1 AND p.active=1 AND c.category_id= ORDER BY p.views DESC LIMIT 10
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 'ORDER BY p.views DESC LIMIT 10' at line 13