Q&A about the site for amateur radio enthusiasts
select top 15 users.id, users.displayname, count(posts.id) as postcount from users join posts on users.id=posts.owneruserid group by users.id,users.displayname order by postcount desc