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