Untitled query #30512

This query is marked as a draft This query has been published by Putnik.
SQL

select 'aawiki_p', count(ug_user) from aawiki_p.user_groups where ug_group = 'interface-admin'
union select 'aawikibooks_p', count(ug_user) from aawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'aawiktionary_p', count(ug_user) from aawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'abwiki_p', count(ug_user) from abwiki_p.user_groups where ug_group = 'interface-admin'
union select 'abwiktionary_p', count(ug_user) from abwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'acewiki_p', count(ug_user) from acewiki_p.user_groups where ug_group = 'interface-admin'
union select 'advisorywiki_p', count(ug_user) from advisorywiki_p.user_groups where ug_group = 'interface-admin'
union select 'adywiki_p', count(ug_user) from adywiki_p.user_groups where ug_group = 'interface-admin'
union select 'afwiki_p', count(ug_user) from afwiki_p.user_groups where ug_group = 'interface-admin'
union select 'afwikibooks_p', count(ug_user) from afwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'afwikiquote_p', count(ug_user) from afwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'afwiktionary_p', count(ug_user) from afwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'akwiki_p', count(ug_user) from akwiki_p.user_groups where ug_group = 'interface-admin'
union select 'akwikibooks_p', count(ug_user) from akwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'akwiktionary_p', count(ug_user) from akwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'alswiki_p', count(ug_user) from alswiki_p.user_groups where ug_group = 'interface-admin'
union select 'amwiki_p', count(ug_user) from amwiki_p.user_groups where ug_group = 'interface-admin'
union select 'amwikimedia_p', count(ug_user) from amwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'amwikiquote_p', count(ug_user) from amwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'amwiktionary_p', count(ug_user) from amwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'angwiki_p', count(ug_user) from angwiki_p.user_groups where ug_group = 'interface-admin'
union select 'angwikibooks_p', count(ug_user) from angwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'angwikiquote_p', count(ug_user) from angwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'angwikisource_p', count(ug_user) from angwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'angwiktionary_p', count(ug_user) from angwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'anwiki_p', count(ug_user) from anwiki_p.user_groups where ug_group = 'interface-admin'
union select 'anwiktionary_p', count(ug_user) from anwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'arcwiki_p', count(ug_user) from arcwiki_p.user_groups where ug_group = 'interface-admin'
union select 'arwiki_p', count(ug_user) from arwiki_p.user_groups where ug_group = 'interface-admin'
union select 'arwikibooks_p', count(ug_user) from arwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'arwikimedia_p', count(ug_user) from arwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'arwikinews_p', count(ug_user) from arwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'arwikiquote_p', count(ug_user) from arwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'arwikisource_p', count(ug_user) from arwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'arwikiversity_p', count(ug_user) from arwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'arwiktionary_p', count(ug_user) from arwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'arzwiki_p', count(ug_user) from arzwiki_p.user_groups where ug_group = 'interface-admin'
union select 'astwiki_p', count(ug_user) from astwiki_p.user_groups where ug_group = 'interface-admin'
union select 'astwikibooks_p', count(ug_user) from astwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'astwikiquote_p', count(ug_user) from astwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'astwiktionary_p', count(ug_user) from astwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'aswiki_p', count(ug_user) from aswiki_p.user_groups where ug_group = 'interface-admin'
union select 'aswikibooks_p', count(ug_user) from aswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'aswikisource_p', count(ug_user) from aswikisource_p.user_groups where ug_group = 'interface-admin'
union select 'aswiktionary_p', count(ug_user) from aswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'atjwiki_p', count(ug_user) from atjwiki_p.user_groups where ug_group = 'interface-admin'
union select 'avwiki_p', count(ug_user) from avwiki_p.user_groups where ug_group = 'interface-admin'
union select 'avwiktionary_p', count(ug_user) from avwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'aywiki_p', count(ug_user) from aywiki_p.user_groups where ug_group = 'interface-admin'
union select 'aywikibooks_p', count(ug_user) from aywikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'aywiktionary_p', count(ug_user) from aywiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'azbwiki_p', count(ug_user) from azbwiki_p.user_groups where ug_group = 'interface-admin'
union select 'azwiki_p', count(ug_user) from azwiki_p.user_groups where ug_group = 'interface-admin'
union select 'azwikibooks_p', count(ug_user) from azwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'azwikiquote_p', count(ug_user) from azwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'azwikisource_p', count(ug_user) from azwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'azwiktionary_p', count(ug_user) from azwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'barwiki_p', count(ug_user) from barwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bat_smgwiki_p', count(ug_user) from bat_smgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bawiki_p', count(ug_user) from bawiki_p.user_groups where ug_group = 'interface-admin'
union select 'bawikibooks_p', count(ug_user) from bawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'bclwiki_p', count(ug_user) from bclwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bdwikimedia_p', count(ug_user) from bdwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'be_x_oldwiki_p', count(ug_user) from be_x_oldwiki_p.user_groups where ug_group = 'interface-admin'
union select 'betawikiversity_p', count(ug_user) from betawikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'bewiki_p', count(ug_user) from bewiki_p.user_groups where ug_group = 'interface-admin'
union select 'bewikibooks_p', count(ug_user) from bewikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'bewikimedia_p', count(ug_user) from bewikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'bewikiquote_p', count(ug_user) from bewikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'bewikisource_p', count(ug_user) from bewikisource_p.user_groups where ug_group = 'interface-admin'
union select 'bewiktionary_p', count(ug_user) from bewiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bgwiki_p', count(ug_user) from bgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bgwikibooks_p', count(ug_user) from bgwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'bgwikinews_p', count(ug_user) from bgwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'bgwikiquote_p', count(ug_user) from bgwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'bgwikisource_p', count(ug_user) from bgwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'bgwiktionary_p', count(ug_user) from bgwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bhwiki_p', count(ug_user) from bhwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bhwiktionary_p', count(ug_user) from bhwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'biwiki_p', count(ug_user) from biwiki_p.user_groups where ug_group = 'interface-admin'
union select 'biwikibooks_p', count(ug_user) from biwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'biwiktionary_p', count(ug_user) from biwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bjnwiki_p', count(ug_user) from bjnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bmwiki_p', count(ug_user) from bmwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bmwikibooks_p', count(ug_user) from bmwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'bmwikiquote_p', count(ug_user) from bmwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'bmwiktionary_p', count(ug_user) from bmwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bnwiki_p', count(ug_user) from bnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bnwikibooks_p', count(ug_user) from bnwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'bnwikisource_p', count(ug_user) from bnwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'bnwikivoyage_p', count(ug_user) from bnwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'bnwiktionary_p', count(ug_user) from bnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bowiki_p', count(ug_user) from bowiki_p.user_groups where ug_group = 'interface-admin'
union select 'bowikibooks_p', count(ug_user) from bowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'bowiktionary_p', count(ug_user) from bowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bpywiki_p', count(ug_user) from bpywiki_p.user_groups where ug_group = 'interface-admin'
union select 'brwiki_p', count(ug_user) from brwiki_p.user_groups where ug_group = 'interface-admin'
union select 'brwikimedia_p', count(ug_user) from brwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'brwikiquote_p', count(ug_user) from brwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'brwikisource_p', count(ug_user) from brwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'brwiktionary_p', count(ug_user) from brwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bswiki_p', count(ug_user) from bswiki_p.user_groups where ug_group = 'interface-admin'
union select 'bswikibooks_p', count(ug_user) from bswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'bswikinews_p', count(ug_user) from bswikinews_p.user_groups where ug_group = 'interface-admin'
union select 'bswikiquote_p', count(ug_user) from bswikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'bswikisource_p', count(ug_user) from bswikisource_p.user_groups where ug_group = 'interface-admin'
union select 'bswiktionary_p', count(ug_user) from bswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'bugwiki_p', count(ug_user) from bugwiki_p.user_groups where ug_group = 'interface-admin'
union select 'bxrwiki_p', count(ug_user) from bxrwiki_p.user_groups where ug_group = 'interface-admin'
union select 'cawiki_p', count(ug_user) from cawiki_p.user_groups where ug_group = 'interface-admin'
union select 'cawikibooks_p', count(ug_user) from cawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'cawikimedia_p', count(ug_user) from cawikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'cawikinews_p', count(ug_user) from cawikinews_p.user_groups where ug_group = 'interface-admin'
union select 'cawikiquote_p', count(ug_user) from cawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'cawikisource_p', count(ug_user) from cawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'cawiktionary_p', count(ug_user) from cawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'cbk_zamwiki_p', count(ug_user) from cbk_zamwiki_p.user_groups where ug_group = 'interface-admin'
union select 'cdowiki_p', count(ug_user) from cdowiki_p.user_groups where ug_group = 'interface-admin'
union select 'cebwiki_p', count(ug_user) from cebwiki_p.user_groups where ug_group = 'interface-admin'
union select 'cewiki_p', count(ug_user) from cewiki_p.user_groups where ug_group = 'interface-admin'
union select 'chowiki_p', count(ug_user) from chowiki_p.user_groups where ug_group = 'interface-admin'
union select 'chrwiki_p', count(ug_user) from chrwiki_p.user_groups where ug_group = 'interface-admin'
union select 'chrwiktionary_p', count(ug_user) from chrwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'chwiki_p', count(ug_user) from chwiki_p.user_groups where ug_group = 'interface-admin'
union select 'chwikibooks_p', count(ug_user) from chwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'chwiktionary_p', count(ug_user) from chwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'chywiki_p', count(ug_user) from chywiki_p.user_groups where ug_group = 'interface-admin'
union select 'ckbwiki_p', count(ug_user) from ckbwiki_p.user_groups where ug_group = 'interface-admin'
union select 'cnwikimedia_p', count(ug_user) from cnwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'commonswiki_p', count(ug_user) from commonswiki_p.user_groups where ug_group = 'interface-admin'
union select 'cowiki_p', count(ug_user) from cowiki_p.user_groups where ug_group = 'interface-admin'
union select 'cowikibooks_p', count(ug_user) from cowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'cowikimedia_p', count(ug_user) from cowikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'cowikiquote_p', count(ug_user) from cowikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'cowiktionary_p', count(ug_user) from cowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'crhwiki_p', count(ug_user) from crhwiki_p.user_groups where ug_group = 'interface-admin'
union select 'crwiki_p', count(ug_user) from crwiki_p.user_groups where ug_group = 'interface-admin'
union select 'crwikiquote_p', count(ug_user) from crwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'crwiktionary_p', count(ug_user) from crwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'csbwiki_p', count(ug_user) from csbwiki_p.user_groups where ug_group = 'interface-admin'
union select 'csbwiktionary_p', count(ug_user) from csbwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'cswiki_p', count(ug_user) from cswiki_p.user_groups where ug_group = 'interface-admin'
union select 'cswikibooks_p', count(ug_user) from cswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'cswikinews_p', count(ug_user) from cswikinews_p.user_groups where ug_group = 'interface-admin'
union select 'cswikiquote_p', count(ug_user) from cswikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'cswikisource_p', count(ug_user) from cswikisource_p.user_groups where ug_group = 'interface-admin'
union select 'cswikiversity_p', count(ug_user) from cswikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'cswiktionary_p', count(ug_user) from cswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'cuwiki_p', count(ug_user) from cuwiki_p.user_groups where ug_group = 'interface-admin'
union select 'cvwiki_p', count(ug_user) from cvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'cvwikibooks_p', count(ug_user) from cvwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'cywiki_p', count(ug_user) from cywiki_p.user_groups where ug_group = 'interface-admin'
union select 'cywikibooks_p', count(ug_user) from cywikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'cywikiquote_p', count(ug_user) from cywikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'cywikisource_p', count(ug_user) from cywikisource_p.user_groups where ug_group = 'interface-admin'
union select 'cywiktionary_p', count(ug_user) from cywiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'dawiki_p', count(ug_user) from dawiki_p.user_groups where ug_group = 'interface-admin'
union select 'dawikibooks_p', count(ug_user) from dawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'dawikiquote_p', count(ug_user) from dawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'dawikisource_p', count(ug_user) from dawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'dawiktionary_p', count(ug_user) from dawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'dewiki_p', count(ug_user) from dewiki_p.user_groups where ug_group = 'interface-admin'
union select 'dewikibooks_p', count(ug_user) from dewikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'dewikinews_p', count(ug_user) from dewikinews_p.user_groups where ug_group = 'interface-admin'
union select 'dewikiquote_p', count(ug_user) from dewikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'dewikisource_p', count(ug_user) from dewikisource_p.user_groups where ug_group = 'interface-admin'
union select 'dewikiversity_p', count(ug_user) from dewikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'dewikivoyage_p', count(ug_user) from dewikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'dewiktionary_p', count(ug_user) from dewiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'dinwiki_p', count(ug_user) from dinwiki_p.user_groups where ug_group = 'interface-admin'
union select 'diqwiki_p', count(ug_user) from diqwiki_p.user_groups where ug_group = 'interface-admin'
union select 'dkwikimedia_p', count(ug_user) from dkwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'donatewiki_p', count(ug_user) from donatewiki_p.user_groups where ug_group = 'interface-admin'
union select 'dsbwiki_p', count(ug_user) from dsbwiki_p.user_groups where ug_group = 'interface-admin'
union select 'dtywiki_p', count(ug_user) from dtywiki_p.user_groups where ug_group = 'interface-admin'
union select 'dvwiki_p', count(ug_user) from dvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'dvwiktionary_p', count(ug_user) from dvwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'dzwiki_p', count(ug_user) from dzwiki_p.user_groups where ug_group = 'interface-admin'
union select 'dzwiktionary_p', count(ug_user) from dzwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'eewiki_p', count(ug_user) from eewiki_p.user_groups where ug_group = 'interface-admin'
union select 'elwiki_p', count(ug_user) from elwiki_p.user_groups where ug_group = 'interface-admin'
union select 'elwikibooks_p', count(ug_user) from elwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'elwikinews_p', count(ug_user) from elwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'elwikiquote_p', count(ug_user) from elwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'elwikisource_p', count(ug_user) from elwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'elwikiversity_p', count(ug_user) from elwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'elwikivoyage_p', count(ug_user) from elwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'elwiktionary_p', count(ug_user) from elwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'emlwiki_p', count(ug_user) from emlwiki_p.user_groups where ug_group = 'interface-admin'
union select 'enwiki_p', count(ug_user) from enwiki_p.user_groups where ug_group = 'interface-admin'
union select 'enwikibooks_p', count(ug_user) from enwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'enwikinews_p', count(ug_user) from enwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'enwikiquote_p', count(ug_user) from enwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'enwikisource_p', count(ug_user) from enwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'enwikiversity_p', count(ug_user) from enwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'enwikivoyage_p', count(ug_user) from enwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'enwiktionary_p', count(ug_user) from enwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'eowiki_p', count(ug_user) from eowiki_p.user_groups where ug_group = 'interface-admin'
union select 'eowikibooks_p', count(ug_user) from eowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'eowikinews_p', count(ug_user) from eowikinews_p.user_groups where ug_group = 'interface-admin'
union select 'eowikiquote_p', count(ug_user) from eowikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'eowikisource_p', count(ug_user) from eowikisource_p.user_groups where ug_group = 'interface-admin'
union select 'eowiktionary_p', count(ug_user) from eowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'eswiki_p', count(ug_user) from eswiki_p.user_groups where ug_group = 'interface-admin'
union select 'eswikibooks_p', count(ug_user) from eswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'eswikinews_p', count(ug_user) from eswikinews_p.user_groups where ug_group = 'interface-admin'
union select 'eswikiquote_p', count(ug_user) from eswikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'eswikisource_p', count(ug_user) from eswikisource_p.user_groups where ug_group = 'interface-admin'
union select 'eswikiversity_p', count(ug_user) from eswikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'eswikivoyage_p', count(ug_user) from eswikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'eswiktionary_p', count(ug_user) from eswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'etwiki_p', count(ug_user) from etwiki_p.user_groups where ug_group = 'interface-admin'
union select 'etwikibooks_p', count(ug_user) from etwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'etwikimedia_p', count(ug_user) from etwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'etwikiquote_p', count(ug_user) from etwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'etwikisource_p', count(ug_user) from etwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'etwiktionary_p', count(ug_user) from etwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'euwiki_p', count(ug_user) from euwiki_p.user_groups where ug_group = 'interface-admin'
union select 'euwikibooks_p', count(ug_user) from euwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'euwikiquote_p', count(ug_user) from euwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'euwikisource_p', count(ug_user) from euwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'euwiktionary_p', count(ug_user) from euwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'extwiki_p', count(ug_user) from extwiki_p.user_groups where ug_group = 'interface-admin'
union select 'fawiki_p', count(ug_user) from fawiki_p.user_groups where ug_group = 'interface-admin'
union select 'fawikibooks_p', count(ug_user) from fawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'fawikinews_p', count(ug_user) from fawikinews_p.user_groups where ug_group = 'interface-admin'
union select 'fawikiquote_p', count(ug_user) from fawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'fawikisource_p', count(ug_user) from fawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'fawikivoyage_p', count(ug_user) from fawikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'fawiktionary_p', count(ug_user) from fawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'ffwiki_p', count(ug_user) from ffwiki_p.user_groups where ug_group = 'interface-admin'
union select 'fiu_vrowiki_p', count(ug_user) from fiu_vrowiki_p.user_groups where ug_group = 'interface-admin'
union select 'fiwiki_p', count(ug_user) from fiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'fiwikibooks_p', count(ug_user) from fiwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'fiwikimedia_p', count(ug_user) from fiwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'fiwikinews_p', count(ug_user) from fiwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'fiwikiquote_p', count(ug_user) from fiwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'fiwikisource_p', count(ug_user) from fiwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'fiwikiversity_p', count(ug_user) from fiwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'fiwikivoyage_p', count(ug_user) from fiwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'fiwiktionary_p', count(ug_user) from fiwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'fixcopyrightwiki_p', count(ug_user) from fixcopyrightwiki_p.user_groups where ug_group = 'interface-admin'
union select 'fjwiki_p', count(ug_user) from fjwiki_p.user_groups where ug_group = 'interface-admin'
union select 'fjwiktionary_p', count(ug_user) from fjwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'foundationwiki_p', count(ug_user) from foundationwiki_p.user_groups where ug_group = 'interface-admin'
union select 'fowiki_p', count(ug_user) from fowiki_p.user_groups where ug_group = 'interface-admin'
union select 'fowikisource_p', count(ug_user) from fowikisource_p.user_groups where ug_group = 'interface-admin'
union select 'fowiktionary_p', count(ug_user) from fowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'frpwiki_p', count(ug_user) from frpwiki_p.user_groups where ug_group = 'interface-admin'
union select 'frrwiki_p', count(ug_user) from frrwiki_p.user_groups where ug_group = 'interface-admin'
union select 'frwiki_p', count(ug_user) from frwiki_p.user_groups where ug_group = 'interface-admin'
union select 'frwikibooks_p', count(ug_user) from frwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'frwikinews_p', count(ug_user) from frwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'frwikiquote_p', count(ug_user) from frwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'frwikisource_p', count(ug_user) from frwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'frwikiversity_p', count(ug_user) from frwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'frwikivoyage_p', count(ug_user) from frwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'frwiktionary_p', count(ug_user) from frwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'furwiki_p', count(ug_user) from furwiki_p.user_groups where ug_group = 'interface-admin'
union select 'fywiki_p', count(ug_user) from fywiki_p.user_groups where ug_group = 'interface-admin'
union select 'fywikibooks_p', count(ug_user) from fywikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'fywiktionary_p', count(ug_user) from fywiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'gagwiki_p', count(ug_user) from gagwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ganwiki_p', count(ug_user) from ganwiki_p.user_groups where ug_group = 'interface-admin'
union select 'gawiki_p', count(ug_user) from gawiki_p.user_groups where ug_group = 'interface-admin'
union select 'gawikibooks_p', count(ug_user) from gawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'gawikiquote_p', count(ug_user) from gawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'gawiktionary_p', count(ug_user) from gawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'gdwiki_p', count(ug_user) from gdwiki_p.user_groups where ug_group = 'interface-admin'
union select 'gdwiktionary_p', count(ug_user) from gdwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'glkwiki_p', count(ug_user) from glkwiki_p.user_groups where ug_group = 'interface-admin'
union select 'glwiki_p', count(ug_user) from glwiki_p.user_groups where ug_group = 'interface-admin'
union select 'glwikibooks_p', count(ug_user) from glwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'glwikiquote_p', count(ug_user) from glwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'glwikisource_p', count(ug_user) from glwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'glwiktionary_p', count(ug_user) from glwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'gnwiki_p', count(ug_user) from gnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'gnwikibooks_p', count(ug_user) from gnwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'gnwiktionary_p', count(ug_user) from gnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'gomwiki_p', count(ug_user) from gomwiki_p.user_groups where ug_group = 'interface-admin'
union select 'gorwiki_p', count(ug_user) from gorwiki_p.user_groups where ug_group = 'interface-admin'
union select 'gotwiki_p', count(ug_user) from gotwiki_p.user_groups where ug_group = 'interface-admin'
union select 'gotwikibooks_p', count(ug_user) from gotwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'guwiki_p', count(ug_user) from guwiki_p.user_groups where ug_group = 'interface-admin'
union select 'guwikibooks_p', count(ug_user) from guwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'guwikiquote_p', count(ug_user) from guwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'guwikisource_p', count(ug_user) from guwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'guwiktionary_p', count(ug_user) from guwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'gvwiki_p', count(ug_user) from gvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'gvwiktionary_p', count(ug_user) from gvwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'hakwiki_p', count(ug_user) from hakwiki_p.user_groups where ug_group = 'interface-admin'
union select 'hawiki_p', count(ug_user) from hawiki_p.user_groups where ug_group = 'interface-admin'
union select 'hawiktionary_p', count(ug_user) from hawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'hawwiki_p', count(ug_user) from hawwiki_p.user_groups where ug_group = 'interface-admin'
union select 'hewiki_p', count(ug_user) from hewiki_p.user_groups where ug_group = 'interface-admin'
union select 'hewikibooks_p', count(ug_user) from hewikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'hewikinews_p', count(ug_user) from hewikinews_p.user_groups where ug_group = 'interface-admin'
union select 'hewikiquote_p', count(ug_user) from hewikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'hewikisource_p', count(ug_user) from hewikisource_p.user_groups where ug_group = 'interface-admin'
union select 'hewikivoyage_p', count(ug_user) from hewikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'hewiktionary_p', count(ug_user) from hewiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'hifwiki_p', count(ug_user) from hifwiki_p.user_groups where ug_group = 'interface-admin'
union select 'hifwiktionary_p', count(ug_user) from hifwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'hiwiki_p', count(ug_user) from hiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'hiwikibooks_p', count(ug_user) from hiwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'hiwikimedia_p', count(ug_user) from hiwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'hiwikiquote_p', count(ug_user) from hiwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'hiwikiversity_p', count(ug_user) from hiwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'hiwikivoyage_p', count(ug_user) from hiwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'hiwiktionary_p', count(ug_user) from hiwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'howiki_p', count(ug_user) from howiki_p.user_groups where ug_group = 'interface-admin'
union select 'hrwiki_p', count(ug_user) from hrwiki_p.user_groups where ug_group = 'interface-admin'
union select 'hrwikibooks_p', count(ug_user) from hrwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'hrwikiquote_p', count(ug_user) from hrwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'hrwikisource_p', count(ug_user) from hrwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'hrwiktionary_p', count(ug_user) from hrwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'hsbwiki_p', count(ug_user) from hsbwiki_p.user_groups where ug_group = 'interface-admin'
union select 'hsbwiktionary_p', count(ug_user) from hsbwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'htwiki_p', count(ug_user) from htwiki_p.user_groups where ug_group = 'interface-admin'
union select 'htwikisource_p', count(ug_user) from htwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'huwiki_p', count(ug_user) from huwiki_p.user_groups where ug_group = 'interface-admin'
union select 'huwikibooks_p', count(ug_user) from huwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'huwikinews_p', count(ug_user) from huwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'huwikiquote_p', count(ug_user) from huwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'huwikisource_p', count(ug_user) from huwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'huwiktionary_p', count(ug_user) from huwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'hywiki_p', count(ug_user) from hywiki_p.user_groups where ug_group = 'interface-admin'
union select 'hywikibooks_p', count(ug_user) from hywikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'hywikiquote_p', count(ug_user) from hywikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'hywikisource_p', count(ug_user) from hywikisource_p.user_groups where ug_group = 'interface-admin'
union select 'hywiktionary_p', count(ug_user) from hywiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'hzwiki_p', count(ug_user) from hzwiki_p.user_groups where ug_group = 'interface-admin'
union select 'iawiki_p', count(ug_user) from iawiki_p.user_groups where ug_group = 'interface-admin'
union select 'iawikibooks_p', count(ug_user) from iawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'iawiktionary_p', count(ug_user) from iawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'idwiki_p', count(ug_user) from idwiki_p.user_groups where ug_group = 'interface-admin'
union select 'idwikibooks_p', count(ug_user) from idwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'idwikimedia_p', count(ug_user) from idwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'idwikiquote_p', count(ug_user) from idwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'idwikisource_p', count(ug_user) from idwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'idwiktionary_p', count(ug_user) from idwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'iewiki_p', count(ug_user) from iewiki_p.user_groups where ug_group = 'interface-admin'
union select 'iewikibooks_p', count(ug_user) from iewikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'iewiktionary_p', count(ug_user) from iewiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'igwiki_p', count(ug_user) from igwiki_p.user_groups where ug_group = 'interface-admin'
union select 'iiwiki_p', count(ug_user) from iiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ikwiki_p', count(ug_user) from ikwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ikwiktionary_p', count(ug_user) from ikwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'ilowiki_p', count(ug_user) from ilowiki_p.user_groups where ug_group = 'interface-admin'
union select 'incubatorwiki_p', count(ug_user) from incubatorwiki_p.user_groups where ug_group = 'interface-admin'
union select 'inhwiki_p', count(ug_user) from inhwiki_p.user_groups where ug_group = 'interface-admin'
union select 'iowiki_p', count(ug_user) from iowiki_p.user_groups where ug_group = 'interface-admin'
union select 'iowiktionary_p', count(ug_user) from iowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'iswiki_p', count(ug_user) from iswiki_p.user_groups where ug_group = 'interface-admin'
union select 'iswikibooks_p', count(ug_user) from iswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'iswikiquote_p', count(ug_user) from iswikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'iswikisource_p', count(ug_user) from iswikisource_p.user_groups where ug_group = 'interface-admin'
union select 'iswiktionary_p', count(ug_user) from iswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'itwiki_p', count(ug_user) from itwiki_p.user_groups where ug_group = 'interface-admin'
union select 'itwikibooks_p', count(ug_user) from itwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'itwikinews_p', count(ug_user) from itwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'itwikiquote_p', count(ug_user) from itwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'itwikisource_p', count(ug_user) from itwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'itwikiversity_p', count(ug_user) from itwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'itwikivoyage_p', count(ug_user) from itwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'itwiktionary_p', count(ug_user) from itwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'iuwiki_p', count(ug_user) from iuwiki_p.user_groups where ug_group = 'interface-admin'
union select 'iuwiktionary_p', count(ug_user) from iuwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'jamwiki_p', count(ug_user) from jamwiki_p.user_groups where ug_group = 'interface-admin'
union select 'jawiki_p', count(ug_user) from jawiki_p.user_groups where ug_group = 'interface-admin'
union select 'jawikibooks_p', count(ug_user) from jawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'jawikinews_p', count(ug_user) from jawikinews_p.user_groups where ug_group = 'interface-admin'
union select 'jawikiquote_p', count(ug_user) from jawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'jawikisource_p', count(ug_user) from jawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'jawikiversity_p', count(ug_user) from jawikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'jawiktionary_p', count(ug_user) from jawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'jbowiki_p', count(ug_user) from jbowiki_p.user_groups where ug_group = 'interface-admin'
union select 'jbowiktionary_p', count(ug_user) from jbowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'jvwiki_p', count(ug_user) from jvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'jvwiktionary_p', count(ug_user) from jvwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'kaawiki_p', count(ug_user) from kaawiki_p.user_groups where ug_group = 'interface-admin'
union select 'kabwiki_p', count(ug_user) from kabwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kawiki_p', count(ug_user) from kawiki_p.user_groups where ug_group = 'interface-admin'
union select 'kawikibooks_p', count(ug_user) from kawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'kawikiquote_p', count(ug_user) from kawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kawiktionary_p', count(ug_user) from kawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'kbdwiki_p', count(ug_user) from kbdwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kbpwiki_p', count(ug_user) from kbpwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kgwiki_p', count(ug_user) from kgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kiwiki_p', count(ug_user) from kiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kjwiki_p', count(ug_user) from kjwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kkwiki_p', count(ug_user) from kkwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kkwikibooks_p', count(ug_user) from kkwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'kkwikiquote_p', count(ug_user) from kkwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kkwiktionary_p', count(ug_user) from kkwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'klwiki_p', count(ug_user) from klwiki_p.user_groups where ug_group = 'interface-admin'
union select 'klwiktionary_p', count(ug_user) from klwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'kmwiki_p', count(ug_user) from kmwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kmwikibooks_p', count(ug_user) from kmwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'kmwiktionary_p', count(ug_user) from kmwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'knwiki_p', count(ug_user) from knwiki_p.user_groups where ug_group = 'interface-admin'
union select 'knwikibooks_p', count(ug_user) from knwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'knwikiquote_p', count(ug_user) from knwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'knwikisource_p', count(ug_user) from knwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'knwiktionary_p', count(ug_user) from knwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'koiwiki_p', count(ug_user) from koiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kowiki_p', count(ug_user) from kowiki_p.user_groups where ug_group = 'interface-admin'
union select 'kowikibooks_p', count(ug_user) from kowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'kowikinews_p', count(ug_user) from kowikinews_p.user_groups where ug_group = 'interface-admin'
union select 'kowikiquote_p', count(ug_user) from kowikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kowikisource_p', count(ug_user) from kowikisource_p.user_groups where ug_group = 'interface-admin'
union select 'kowikiversity_p', count(ug_user) from kowikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'kowiktionary_p', count(ug_user) from kowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'krcwiki_p', count(ug_user) from krcwiki_p.user_groups where ug_group = 'interface-admin'
union select 'krwiki_p', count(ug_user) from krwiki_p.user_groups where ug_group = 'interface-admin'
union select 'krwikiquote_p', count(ug_user) from krwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kshwiki_p', count(ug_user) from kshwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kswiki_p', count(ug_user) from kswiki_p.user_groups where ug_group = 'interface-admin'
union select 'kswikibooks_p', count(ug_user) from kswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'kswikiquote_p', count(ug_user) from kswikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kswiktionary_p', count(ug_user) from kswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'kuwiki_p', count(ug_user) from kuwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kuwikibooks_p', count(ug_user) from kuwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'kuwikiquote_p', count(ug_user) from kuwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kuwiktionary_p', count(ug_user) from kuwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'kvwiki_p', count(ug_user) from kvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kwwiki_p', count(ug_user) from kwwiki_p.user_groups where ug_group = 'interface-admin'
union select 'kwwikiquote_p', count(ug_user) from kwwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kwwiktionary_p', count(ug_user) from kwwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'kywiki_p', count(ug_user) from kywiki_p.user_groups where ug_group = 'interface-admin'
union select 'kywikibooks_p', count(ug_user) from kywikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'kywikiquote_p', count(ug_user) from kywikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'kywiktionary_p', count(ug_user) from kywiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'ladwiki_p', count(ug_user) from ladwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lawiki_p', count(ug_user) from lawiki_p.user_groups where ug_group = 'interface-admin'
union select 'lawikibooks_p', count(ug_user) from lawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'lawikiquote_p', count(ug_user) from lawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'lawikisource_p', count(ug_user) from lawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'lawiktionary_p', count(ug_user) from lawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'lbewiki_p', count(ug_user) from lbewiki_p.user_groups where ug_group = 'interface-admin'
union select 'lbwiki_p', count(ug_user) from lbwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lbwikibooks_p', count(ug_user) from lbwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'lbwikiquote_p', count(ug_user) from lbwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'lbwiktionary_p', count(ug_user) from lbwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'lezwiki_p', count(ug_user) from lezwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lfnwiki_p', count(ug_user) from lfnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lgwiki_p', count(ug_user) from lgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lijwiki_p', count(ug_user) from lijwiki_p.user_groups where ug_group = 'interface-admin'
union select 'liwiki_p', count(ug_user) from liwiki_p.user_groups where ug_group = 'interface-admin'
union select 'liwikibooks_p', count(ug_user) from liwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'liwikiquote_p', count(ug_user) from liwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'liwikisource_p', count(ug_user) from liwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'liwiktionary_p', count(ug_user) from liwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'lmowiki_p', count(ug_user) from lmowiki_p.user_groups where ug_group = 'interface-admin'
union select 'lnwiki_p', count(ug_user) from lnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lnwikibooks_p', count(ug_user) from lnwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'lnwiktionary_p', count(ug_user) from lnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'loginwiki_p', count(ug_user) from loginwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lowiki_p', count(ug_user) from lowiki_p.user_groups where ug_group = 'interface-admin'
union select 'lowiktionary_p', count(ug_user) from lowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'lrcwiki_p', count(ug_user) from lrcwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ltgwiki_p', count(ug_user) from ltgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ltwiki_p', count(ug_user) from ltwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ltwikibooks_p', count(ug_user) from ltwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ltwikiquote_p', count(ug_user) from ltwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'ltwikisource_p', count(ug_user) from ltwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'ltwiktionary_p', count(ug_user) from ltwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'lvwiki_p', count(ug_user) from lvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'lvwikibooks_p', count(ug_user) from lvwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'lvwiktionary_p', count(ug_user) from lvwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'maiwiki_p', count(ug_user) from maiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'maiwikimedia_p', count(ug_user) from maiwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'map_bmswiki_p', count(ug_user) from map_bmswiki_p.user_groups where ug_group = 'interface-admin'
union select 'mdfwiki_p', count(ug_user) from mdfwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mediawikiwiki_p', count(ug_user) from mediawikiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'meta_p', count(ug_user) from meta_p.user_groups where ug_group = 'interface-admin'
union select 'metawiki_p', count(ug_user) from metawiki_p.user_groups where ug_group = 'interface-admin'
union select 'mgwiki_p', count(ug_user) from mgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mgwikibooks_p', count(ug_user) from mgwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'mgwiktionary_p', count(ug_user) from mgwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mhrwiki_p', count(ug_user) from mhrwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mhwiki_p', count(ug_user) from mhwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mhwiktionary_p', count(ug_user) from mhwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'minwiki_p', count(ug_user) from minwiki_p.user_groups where ug_group = 'interface-admin'
union select 'miwiki_p', count(ug_user) from miwiki_p.user_groups where ug_group = 'interface-admin'
union select 'miwikibooks_p', count(ug_user) from miwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'miwiktionary_p', count(ug_user) from miwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mkwiki_p', count(ug_user) from mkwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mkwikibooks_p', count(ug_user) from mkwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'mkwikimedia_p', count(ug_user) from mkwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'mkwikisource_p', count(ug_user) from mkwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'mkwiktionary_p', count(ug_user) from mkwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mlwiki_p', count(ug_user) from mlwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mlwikibooks_p', count(ug_user) from mlwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'mlwikiquote_p', count(ug_user) from mlwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'mlwikisource_p', count(ug_user) from mlwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'mlwiktionary_p', count(ug_user) from mlwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mnwiki_p', count(ug_user) from mnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mnwikibooks_p', count(ug_user) from mnwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'mnwiktionary_p', count(ug_user) from mnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mrjwiki_p', count(ug_user) from mrjwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mrwiki_p', count(ug_user) from mrwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mrwikibooks_p', count(ug_user) from mrwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'mrwikiquote_p', count(ug_user) from mrwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'mrwikisource_p', count(ug_user) from mrwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'mrwiktionary_p', count(ug_user) from mrwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mswiki_p', count(ug_user) from mswiki_p.user_groups where ug_group = 'interface-admin'
union select 'mswikibooks_p', count(ug_user) from mswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'mswiktionary_p', count(ug_user) from mswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mtwiki_p', count(ug_user) from mtwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mtwiktionary_p', count(ug_user) from mtwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'muswiki_p', count(ug_user) from muswiki_p.user_groups where ug_group = 'interface-admin'
union select 'mwlwiki_p', count(ug_user) from mwlwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mxwikimedia_p', count(ug_user) from mxwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'myvwiki_p', count(ug_user) from myvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'mywiki_p', count(ug_user) from mywiki_p.user_groups where ug_group = 'interface-admin'
union select 'mywikibooks_p', count(ug_user) from mywikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'mywiktionary_p', count(ug_user) from mywiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'mznwiki_p', count(ug_user) from mznwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nahwiki_p', count(ug_user) from nahwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nahwikibooks_p', count(ug_user) from nahwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'nahwiktionary_p', count(ug_user) from nahwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'napwiki_p', count(ug_user) from napwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nawiki_p', count(ug_user) from nawiki_p.user_groups where ug_group = 'interface-admin'
union select 'nawikibooks_p', count(ug_user) from nawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'nawikiquote_p', count(ug_user) from nawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'nawiktionary_p', count(ug_user) from nawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'nds_nlwiki_p', count(ug_user) from nds_nlwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ndswiki_p', count(ug_user) from ndswiki_p.user_groups where ug_group = 'interface-admin'
union select 'ndswikibooks_p', count(ug_user) from ndswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ndswikiquote_p', count(ug_user) from ndswikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'ndswiktionary_p', count(ug_user) from ndswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'newiki_p', count(ug_user) from newiki_p.user_groups where ug_group = 'interface-admin'
union select 'newikibooks_p', count(ug_user) from newikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'newiktionary_p', count(ug_user) from newiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'newwiki_p', count(ug_user) from newwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ngwiki_p', count(ug_user) from ngwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nlwiki_p', count(ug_user) from nlwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nlwikibooks_p', count(ug_user) from nlwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'nlwikimedia_p', count(ug_user) from nlwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'nlwikinews_p', count(ug_user) from nlwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'nlwikiquote_p', count(ug_user) from nlwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'nlwikisource_p', count(ug_user) from nlwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'nlwikivoyage_p', count(ug_user) from nlwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'nlwiktionary_p', count(ug_user) from nlwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'nnwiki_p', count(ug_user) from nnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nnwikiquote_p', count(ug_user) from nnwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'nnwiktionary_p', count(ug_user) from nnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'nostalgiawiki_p', count(ug_user) from nostalgiawiki_p.user_groups where ug_group = 'interface-admin'
union select 'novwiki_p', count(ug_user) from novwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nowiki_p', count(ug_user) from nowiki_p.user_groups where ug_group = 'interface-admin'
union select 'nowikibooks_p', count(ug_user) from nowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'nowikimedia_p', count(ug_user) from nowikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'nowikinews_p', count(ug_user) from nowikinews_p.user_groups where ug_group = 'interface-admin'
union select 'nowikiquote_p', count(ug_user) from nowikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'nowikisource_p', count(ug_user) from nowikisource_p.user_groups where ug_group = 'interface-admin'
union select 'nowiktionary_p', count(ug_user) from nowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'nrmwiki_p', count(ug_user) from nrmwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nsowiki_p', count(ug_user) from nsowiki_p.user_groups where ug_group = 'interface-admin'
union select 'nvwiki_p', count(ug_user) from nvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'nycwikimedia_p', count(ug_user) from nycwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'nywiki_p', count(ug_user) from nywiki_p.user_groups where ug_group = 'interface-admin'
union select 'nzwikimedia_p', count(ug_user) from nzwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'ocwiki_p', count(ug_user) from ocwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ocwikibooks_p', count(ug_user) from ocwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ocwiktionary_p', count(ug_user) from ocwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'olowiki_p', count(ug_user) from olowiki_p.user_groups where ug_group = 'interface-admin'
union select 'omwiki_p', count(ug_user) from omwiki_p.user_groups where ug_group = 'interface-admin'
union select 'omwiktionary_p', count(ug_user) from omwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'orwiki_p', count(ug_user) from orwiki_p.user_groups where ug_group = 'interface-admin'
union select 'orwikisource_p', count(ug_user) from orwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'orwiktionary_p', count(ug_user) from orwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'oswiki_p', count(ug_user) from oswiki_p.user_groups where ug_group = 'interface-admin'
union select 'outreachwiki_p', count(ug_user) from outreachwiki_p.user_groups where ug_group = 'interface-admin'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
