Skip to main content
replaced http://data.stackexchange.com/ with https://data.stackexchange.com/
Source Link

Until this feature request is implemented you can use the following queryquery to list all recent awarded goldbadges. I'll leave it as an exercise to the reader to add the silver and bronze badges.

with goldtagbadges as 
(select max(badges.id) as Id
 from badges
 inner join tags t on t.tagname = name
 group by userid, name
 having count(*) > 2 )

select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
where name in ( 'Socratic'
, 'Stellar Question'
, 'Great Question'
, 'Famous Question'
, 'Illuminator'
, 'Great Answer'
, 'Populist' 
, 'Reversal'
, 'Unsung Hero'
, 'Fanatic'
, 'Legendary'
, 'Marshal'
, 'Constable'
, 'Sheriff'
, 'Steward'
, 'Copy Editor'
, 'Electorate' 
, 'Publicist'
) union
select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
inner join goldtagbadges g on g.id = badges.id
order by [date] desc

Until this feature request is implemented you can use the following query to list all recent awarded goldbadges. I'll leave it as an exercise to the reader to add the silver and bronze badges.

with goldtagbadges as 
(select max(badges.id) as Id
 from badges
 inner join tags t on t.tagname = name
 group by userid, name
 having count(*) > 2 )

select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
where name in ( 'Socratic'
, 'Stellar Question'
, 'Great Question'
, 'Famous Question'
, 'Illuminator'
, 'Great Answer'
, 'Populist' 
, 'Reversal'
, 'Unsung Hero'
, 'Fanatic'
, 'Legendary'
, 'Marshal'
, 'Constable'
, 'Sheriff'
, 'Steward'
, 'Copy Editor'
, 'Electorate' 
, 'Publicist'
) union
select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
inner join goldtagbadges g on g.id = badges.id
order by [date] desc

Until this feature request is implemented you can use the following query to list all recent awarded goldbadges. I'll leave it as an exercise to the reader to add the silver and bronze badges.

with goldtagbadges as 
(select max(badges.id) as Id
 from badges
 inner join tags t on t.tagname = name
 group by userid, name
 having count(*) > 2 )

select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
where name in ( 'Socratic'
, 'Stellar Question'
, 'Great Question'
, 'Famous Question'
, 'Illuminator'
, 'Great Answer'
, 'Populist' 
, 'Reversal'
, 'Unsung Hero'
, 'Fanatic'
, 'Legendary'
, 'Marshal'
, 'Constable'
, 'Sheriff'
, 'Steward'
, 'Copy Editor'
, 'Electorate' 
, 'Publicist'
) union
select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
inner join goldtagbadges g on g.id = badges.id
order by [date] desc
Source Link
rene Mod
  • 92.1k
  • 17
  • 245
  • 516

Until this feature request is implemented you can use the following query to list all recent awarded goldbadges. I'll leave it as an exercise to the reader to add the silver and bronze badges.

with goldtagbadges as 
(select max(badges.id) as Id
 from badges
 inner join tags t on t.tagname = name
 group by userid, name
 having count(*) > 2 )

select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
where name in ( 'Socratic'
, 'Stellar Question'
, 'Great Question'
, 'Famous Question'
, 'Illuminator'
, 'Great Answer'
, 'Populist' 
, 'Reversal'
, 'Unsung Hero'
, 'Fanatic'
, 'Legendary'
, 'Marshal'
, 'Constable'
, 'Sheriff'
, 'Steward'
, 'Copy Editor'
, 'Electorate' 
, 'Publicist'
) union
select Name, [UserId] as [User Link], [date] as [Awarded] 
from badges 
inner join goldtagbadges g on g.id = badges.id
order by [date] desc