Could recent gold (or silver or bronze) badges be shown somewhere separately?

Question

On the pages explaining badges, list of recent badges is shown on the right. (They have been moved there from the frontpage.)

One reason I find list of recent badges interesting is that it shows achievements by users of particular sites. This might help me to notice some interesting posts or some remarkable thing a particular user was able to do.

The gold badges seem to be the most interesting from this viewpoint. (Admittedly, there are even gold badges which are easy to obtain, such as fanatic badge. But, in general, it is more difficult to get a golden badge than silver or bronze one.)

I think that an appropriate place for list of gold/silver/bronze badges could be on the badges page, when choosing to display only gold, silver, bronze badges.

Feature request: Could we have on the badges page in the view for gold/silver/bronze badges the list of recently awarded gold/silver/bronze badges (instead of the list of all recent badges, which is shown there now)?

Answer 1

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