Skip to content

Instantly share code, notes, and snippets.

@tateisu

tateisu/gist:fc136d45c7e7773e285d37042106958f Secret

Last active April 4, 2021 08:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tateisu/fc136d45c7e7773e285d37042106958f to your computer and use it in GitHub Desktop.
Save tateisu/fc136d45c7e7773e285d37042106958f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
sqlite> select count(*) from instance_info;
4673
sqlite> select count(*) from instance_info where is_mastodon;
3440
sqlite> select sum(user_count) from instance_info;
3139980
sqlite> select sum(user_count) from instance_info where is_mastodon;
3085408
sqlite> select sum(user_count) from instance_info where is_mastodon and ( is_jp_domain or is_j
p_location or has_ja);
960149
sqlite> select sum(login_activity) from instance_info;
195808
sqlite> select sum(login_activity) from instance_info where is_mastodon;
195808
sqlite> select sum(login_activity) from instance_info where is_mastodon and ( is_jp_domain or
is_jp_location or has_ja);
38812
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment