Where do Stack Exchange Network sites count come from?

Question

If you hover over the Stack Exchange logo (top left) you will get a tooltip message saying "A list of all 149 Stack Exchange sites".

Screenshot:

Where do the count of SE Network sites come from? Is it dynamically generated or by some other mechanism? Can anyone please explain this?

Community · Accepted Answer · 2021-01-18 12:17:03Z

4

Based on the answer from Adam Lear I expect this to be dynamically determined, probably based on the number of databases available.

select count(*) as [#sites]
from sys.databases 
where database_id > 5 -- exclude system db's and DataExplorer
and name not like '%.Meta'

You'll notice the number is 147 there. That is because Open Sience and Computer Graphics went live Tuesday and SEDE is updated once a week on Sunday.

CommunityBot

1

answered Aug 6, 2015 at 18:45

reneMod

92k17 gold badges244 silver badges515 bronze badges

Thank you. rene your're SQL master... So based on your query, they all come from one single database? the reason for asking was the count differs on SO Careers 132 and StackExchange.com 154
– HackerKarma
Commented Aug 6, 2015 at 19:30
1

Not everything is on the same code base that could explain the differences there. StackExchange should be inline though so that might be a bug. Don't know it that is true for careers
– rene Mod
Commented Aug 6, 2015 at 19:37
As for the Meta.SE goes, your answer solves my question. I will dig more for other mis-match.
– HackerKarma
Commented Aug 6, 2015 at 19:54

Add a comment |

1 Answer 1