Select 'https://ja.stackoverflow.com/help/badges/' + CAST...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

Select 
  'https://ja.stackoverflow.com/help/badges/' + CAST(Id AS nvarchar) + '/' + Name,
  UserId as [User Link],
  Date,
  Class,
  TagBased
From Badges
-- Where TagBased = 'true'
Where
  Class >= 2
  And TagBased = 'true'
Order By Date Desc

Enter Parameters

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