select distinct u.id, b.Name, b2.id From Users u join Bad...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select distinct
   u.id,
   b.Name,
   b2.id
   From Users u
   join Badges b on b.UserId=u.Id
   left join Badges b2 on b2.userid = b.userid
                      and b2.id     = b.id
  where u.id = 70345
  and b.Name in (
         'Civic Duty', 
         'Cleanup',
         'Constituent',
         'Convention',
         'Copy Editor',
         'Deputy',
         'Electorate',
         'Enthusiast',
         'Explainer',
         'Investor',
         'Marshal',
         'Organizer',
         'Quorum',
         'Refiner',
         'Sportsmanship',
         'Strunk & White',
         'Tag Editor',
         'Reviewer',
         'Steward', 
         'Yearling'
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results