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'