>

Moderators:

SELECT SQL_CALC_FOUND_ROWS d.id, d.`locked`, d.sticky, d.title, d.slug, d.author_id, d.`views`, d.count_posts, d.last_post_id, DATE_FORMAT(com.posted_at, '%b %d, %Y
%h:%i %p') as created_at, UNIX_TIMESTAMP(com.posted_at) as ts, com.author_id as cm_id ,m.username FROM mtr_gdiscussions d INNER JOIN mtr_gposts com ON d.last_post_id = com.id INNER JOIN mtr_members m ON d.author_id = m.id WHERE d.member_status = 'active' AND d.status = 'active' AND d.group_id = GROUP BY d.id ORDER BY d.sticky DESC, com.posted_at DESC LIMIT 0, 20

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 d.id ORDER BY d.sticky DESC, com.posted_at DESC LIMIT 0, 20' at line 19