SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes FROM cms_uc_ratings WHERE item_id = GROUP BY item_id
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 'GROUP BY item_id' at line 4