Users with only suggested edits and a lot of upvotes

1

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 
	users.id as [User Link], 
	users.reputation, 
    users.creationdate,
	users.upvotes, 
	users.downvotes,
    users.location, 
	users.aboutme
from users
inner join suggestededits 
	on suggestededits.owneruserid = users.id 
left outer join posts
    on posts.owneruserid = users.id
where 
	users.creationdate > '2018-01-01'
	and reputation >= 10 and reputation < 100
	and upvotes > 10
group by 
	users.id, 
	users.reputation, 
	users.creationdate, 
	users.displayname, 
	users.location, 
	users.aboutme, 
	users.upvotes, 
	users.downvotes
having count(distinct suggestededits.id) >= 3
   and count(distinct posts.id) = 0
order by users.upvotes desc

Enter Parameters

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