Which user is "the most" legendary across the whole network of sites?

Question

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?

Answer 1

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:

Answer 2

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

• Nick Craver (1 and 2)
• Bill the Lizard (1 and 2)
• Oded (1 and 2)
• Pekka supports GoFundMonica (1 and 2)

Stack Overflow & Meta Stack Overflow

• Martijn Pieters (1 and 2)
• Servy (1 and 2)
• BoltClock (1 and 2)

Meta Stack Exchange & Meta Stack Overflow

• Tim Post (1 and 2)
• Shog9 (1 and 2)
• Glorfindel (1 and 2)

Other combinations

• Aaron Bertrand (Stack Overflow and Database Administrators)
• janos (Stack Overflow and Code Review)
• Daniel Fischer (Stack Overflow and Mathematics)
• egreg (Mathematics and TeX - LaTeX)
• Rand al'Thor (Science Fiction & Fantasy and Puzzling)

Honourable mentions

• Robert Harvey has one on Software Engineering and used to have one on Meta Stack Exchange but he deleted his account there.

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

Answer 3

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: