Vicious Dog based on Suggested Edits

3

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select COUNT(*) as Count, MAX(s.CreationDate), v.UserId as [User Link], uu.Reputation as MainUserReputation, s.OwnerUserId as [User Link], su.Reputation as SuggesterReputation, su.CreationDate as SuggesterCreationDate from SuggestedEditVotes v
inner join SuggestedEdits s on s.Id = v.SuggestedEditId
inner join Posts p on p.Id = s.PostId
inner join Users su on su.Id=s.OwnerUserId
inner join Users uu on uu.Id=v.UserId
where v.VoteTypeId=2
and v.UserId=p.OwnerUserId
and su.Reputation<uu.Reputation
and su.Reputation>=15
group by v.UserId, s.OwnerUserId, su.Reputation, uu.Reputation, su.CreationDate
--order by Count desc
having COUNT(*)>4
order by MAX(s.CreationDate) desc

Enter Parameters

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