10k users who have never flagged, downvoted or reviewed a post

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 l.Id as [User Link], l.reputation as Reputation
from Users l
where l.id not in ( select userid as id from badges r where r.name like 'Citizen Patrol' or
r.name like 'Custodian')  and
l.reputation >= 10000
and l.downvotes=0
order by l.reputation DESC

Enter Parameters

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