Vanity: Which users earned a particular tag-based badge sooner than me?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

-- DECLARE @TagName nvarchar(255) = '##TagName##'
-- DECLARE @UserId int = ##UserId##

SELECT TOP 5 *
FROM Badges
  INNER JOIN Users ON Users.Id = Badges.UserId
WHERE
  Badges.Class = 1
  AND Badges.TagBased = 1 -- for true
  AND Badges.Name = 'r'

Enter Parameters

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