3

Please login or register to vote for this query.

(click on this box to dismiss)

Find users in the Penalty Box

Q&A for pro webmasters

-- Boxed Users
-- Find users in the Penalty Box

Select BoxedUser.Id as [User Link]
From Users as BoxedUser
Where BoxedUser.Reputation = 1 AND
(select count(*) from posts where posts.owneruserid = BoxedUser.id) > 20

fork query

created jul 1 10 jjnguy