Test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

Select Id, DisplayName, Reputation,

 (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Civic Duty') as 'Civic Duty'
 --  and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Strunk & White')
 --  and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Deputy')
 --  and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Convention')
  -- and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Yearling')
 from Users
 where Id = 1029088
order by Reputation asc

Enter Parameters

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