select users.id as [User Link], users.reputation, users.c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
	users.id as [User Link], 
	users.reputation, 
    users.creationdate,
	users.upvotes, 
	users.downvotes,
    users.location, 
	users.aboutme,
    count(posts.id)
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 >= 15 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.creationdate desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results