0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter Query Description

Q&A for anime and manga fans

-- Eligible for mod
-- Enter Query Description

SELECT userid , u.DisplayName
FROM badges  b inner join users u
on b.userid = u.id
where 
b.name in ('Civic Duty', 'Strunk & White', 'Deputy', 'Convention') or
(b.name = 'Yearling' and b.date > '1/1/2011')
GROUP BY b.userid, u.DisplayName

HAVING count(b.id) = 5 
ORDER BY u.DisplayName

fork query

created nov 7 11 conradfrix