A Database Error Occurred
Error Number: 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 published='1' GROUP BY products.product_url ORDER BY price ASC LIMIT 0,1' at line 1
SELECT DISTINCT products.product_url, products.*, drinkprice_approved_category_crossrefs.cat_id, drinkprice_approved_category_crossrefs.cat_appr_cr_id, drinkprice_approved_country_crossrefs.country_id, drinkprice_approved_country_crossrefs.country_appr_cr_id FROM products LEFT JOIN drinkprice_approved_category_crossrefs ON drinkprice_approved_category_crossrefs.product_id=products.id LEFT JOIN drinkprice_approved_country_crossrefs ON drinkprice_approved_country_crossrefs.product_id=products.id WHERE (drinkprice_approved_category_crossrefs.cat_id IN) ) AND published='1' GROUP BY products.product_url ORDER BY price ASC LIMIT 0,10