SELECT userid FROM badges b inner join users u on b.use...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

-- Enter Query Title
-- Enter Query Description

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

Enter Parameters

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