Users with 1K and two badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

Select Id as [User Link], Reputation, LastAccessDate
 from Users
 where Reputation >= 1000
   and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Civic Duty')
   and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Deputy')
order by LastAccessDate desc

Enter Parameters

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