3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

select top 100 COUNT(*) as Count, v.UserId as VoteUserId, s.OwnerUserId as Suggester, u.Reputation as SuggesterReputation from SuggestedEditVotes v
inner join SuggestedEdits s on s.Id = v.SuggestedEditId
inner join Posts p on p.Id = s.PostId
inner join Users u on u.Id=s.OwnerUserId
where v.VoteTypeId=2
and v.UserId=p.OwnerUserId
group by v.UserId, s.OwnerUserId, u.Reputation
order by Count desc

view current version

edited aug 9 14

created aug 9 14 Undo