Worst comments per user

3

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select numComments, numPosts, reputation, users.id as [User Link], ((numComments*1.0)/numPosts) as commentPostRatio from
(select count(*) as numComments, users.id as userid
from comments join users on (comments.userid = users.id)
group by users.id) nC join 
(select count(*) as numPosts, users.id as userid
from posts join users on (posts.owneruserid = users.id)
group by users.id) nP on (nC.userid = nP.userid) 
join users on (nc.userid = users.id)
where reputation > 500
order by commentPostRatio desc, reputation

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results