16

I have seen this - nicely laying out that even meta sites (with assumed low "traffic") can have legendary users.

Simply wondering now: is there a list somewhere providing a "ranking" of users that hold "the most" legendary badges?

0
15

It was too much work to not post it but @Glorfindel beat me by a few minutes.

Here is the query:

(do note this looks at both regular sites AND site meta's. The latter might feel strange because site meta's don't show rep but you still earn the reputation related badges)

-- result table, don't rename and keep the site column
create table #results ( site nvarchar(250)
                       , username nvarchar(35)
                       , accountid int
                       , days int);

declare @sql nvarchar(max) = ''   -- holds build up sql string

-- build one biq union sql, for each db
select @sql = @sql 
+ iif( len(@sql) > 1 
     , 'union'
     , 'insert into #results'
) +
-- here goes the per site query, fully qualify the database objects
N'
select ''' + name + '''
     , u.displayname
     , u.accountid
     , datediff(d, u.creationdate, b.[date])
from ' + quotename(name) + '.dbo.badges b 
inner join ' + quotename(name) + '.dbo.users u on u.id = b.userid
where b.name = ''Legendary''
'
from sys.databases
where database_id > 5
-- and (name not like '%.Meta' or name = 'StackExchange.Meta')

--print @sql

-- execute it
exec (@sql)

-- show results
select    
       ( 'https://stackexchange.com/users/' + cast(o.accountid as nvarchar)
       + '|' 
       + (select min(username) from #results r where r.accountid = o.accountid) 
       ) as [Network profile]
      , count(*) as [# times earned]
      , min(days) as [# days to reach]
from #results o
group by accountid
order by count(*) desc
       , min(days) asc

drop table #results

Notice that I added the days it took between user joining a site and the actual awarding of the badge. The less days that took makes them even more legendary. Luckily this didn't reveal any weird SEDE madness where users earned the badge before they joined ...

And here are the results when run today:

league of legendary network wide

5
  • 4
    Hey, I beat @rene with SEDE. Do I get a badge for that? – Glorfindel Aug 15 '17 at 10:40
  • 1
    I especially like the "days" column ;-) – GhostCat Aug 15 '17 at 10:41
  • @Glorfindel well, this one is more.... detailed. So it's a fair game. ;) (buh, both your name and OP's starts with same letter!) – Shadow The Vaccinated Wizard Aug 15 '17 at 10:42
  • @ShaWizDowArd I agree, that's why I have upvoted this post but not my own :P – Glorfindel Aug 15 '17 at 10:45
  • 4:4:2, nice numbers! – Shadow The Vaccinated Wizard Aug 15 '17 at 10:46
11

According to this SEDE query, no user on Stack Exchange has more than two legendary badges. That is surprisingly low, but obtaining the badge requires a lot of dedication.

Those users are (at the moment of writing this):

Stack Overflow & Meta Stack Exchange

Stack Overflow & Meta Stack Overflow

Meta Stack Exchange & Meta Stack Overflow

Other combinations

Honourable mentions

Jon Skeet is not among them; his legend level is actually above "the most legendary".

4
  • 2
    Not really surprising. Skeet is Programming God, but on other sites he's just "active", not legendary. – Shadow The Vaccinated Wizard Aug 15 '17 at 10:38
  • No, not really. But I'd thought it would be fun to continue the Jon Skeet adoration from the comments through my answer. – Glorfindel Aug 15 '17 at 10:39
  • @ShaWizDowArd Yes. I also didn't expect Jon to show in such a ranking. Now I am wondering: is there a badge for finding a ranking in which Jon doesn't show up? – GhostCat Aug 15 '17 at 10:39
  • @GhostCat sure, Anti Skeet badge. Gold, of course. :-P – Shadow The Vaccinated Wizard Aug 15 '17 at 10:40
5

More of an addendum, to occasionally keep track of new entries, and (for today) slightly adapted usernames, rerun(s) of renes query, with all "2 legendary badge" holders:

top-legends-jan2020

2
  • 5
    can't resist upvoting posts which mention me – Glorfindel Jan 6 '20 at 16:48
  • 2
    Wow, that's a pretty elite club I'm now part of. – Rand al'Thor Jan 6 '20 at 19:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .