SELECT u.user_id, u.username, u.user_posts, count(u.user_id) as user_posts
FROM nuke_users u, nuke_bbposts p
WHERE (u.user_id <> 1 AND u.user_id = p.poster_id) AND (u.user_id != 8)
GROUP BY user_id, username
ORDER BY user_posts DESC
LIMIT 10 Line : 933 File : functions.php