An Error Was Encountered

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 'GROUP BY discussions.id ORDER BY last_reply_time desc LIMIT 61' at line 9

SELECT discussions.*, count(distinct discussion_viewers.id) as view_count, ci_users2.full_name as creator_full_name, discussion_sums.last_reply_id, discussion_sums.comment_count as comment_count, discussion_sums.last_reply_time, discussion_sums.last_reply_user, ci_users.full_name as last_reply_full_name FROM discussions LEFT JOIN discussion_viewers ON discussions.id = discussion_viewers.discussion_id LEFT JOIN ci_users as ci_users2 ON discussions.creator_id = ci_users2.user_id LEFT JOIN discussion_sums ON discussions.id = discussion_sums.discussion_id LEFT JOIN ci_users ON discussion_sums.last_reply_user = ci_users.user_id WHERE discussions.disabled = 0 AND (discussions.tags like '%loneliness%') AND discussions.group_id = GROUP BY discussions.id ORDER BY last_reply_time desc LIMIT 61