Count the number of Deputy with less than 10K reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Compute how much user with deputy badge does not have access to moderation tool.

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Count the number of Deputy with less than 10K reputation
-- Compute how much user with deputy badge does not have access to moderation tool.
Select count(*)
from Badges
inner join users on users.id = Badges.userid
where Name like 'Deputy'
and reputation < 10000;

Enter Parameters

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