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?
Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.Sign up to join this community
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:
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):
Jon Skeet is not among them; his legend level is actually above "the most legendary".