Users that most often redirecting other users to Code Review

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select
  min(Users.DisplayName) as username,
  min(Users.Reputation) as reputation,
  Comments.UserId,
  count(Score) as numcomments,
  sum(Score) as totalscore
from Comments
join Users on (Comments.UserId = Users.Id)
where 
 Text LIKE '%codereview%'
group by Comments.UserId
order by numcomments desc

Enter Parameters

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