MySQL Error!
MySQL error in file: /views/category.php at line 676
Error Number: 1064
The Error returned was:
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 pr.is_free = '0' ORDER BY pr.adsense DESC, pr.dcount DESC LIMIT 0,50' at line 3
SQL query:
SELECT pr.id, pr.title, pr.alt_name, pr.product_id, pr.category_type_id, pr.adsense, pr.is_free FROM products as pr
LEFT JOIN products_title_translation as pr_i18n_title ON (pr.product_id = pr_i18n_title.product_id AND pr.category_type_id = pr_i18n_title.category_type_id)
WHERE pr.approve = '1' AND pr.category_type_id = '33' AND pr.id IN () AND pr.is_free = '0' ORDER BY pr.adsense DESC, pr.dcount DESC LIMIT 0,50