Untitled query #30512

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

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'
union select 'pa_uswikimedia_p', count(ug_user) from pa_uswikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'pagwiki_p', count(ug_user) from pagwiki_p.user_groups where ug_group = 'interface-admin'
union select 'pamwiki_p', count(ug_user) from pamwiki_p.user_groups where ug_group = 'interface-admin'
union select 'papwiki_p', count(ug_user) from papwiki_p.user_groups where ug_group = 'interface-admin'
union select 'pawiki_p', count(ug_user) from pawiki_p.user_groups where ug_group = 'interface-admin'
union select 'pawikibooks_p', count(ug_user) from pawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'pawikisource_p', count(ug_user) from pawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'pawiktionary_p', count(ug_user) from pawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'pcdwiki_p', count(ug_user) from pcdwiki_p.user_groups where ug_group = 'interface-admin'
union select 'pdcwiki_p', count(ug_user) from pdcwiki_p.user_groups where ug_group = 'interface-admin'
union select 'pflwiki_p', count(ug_user) from pflwiki_p.user_groups where ug_group = 'interface-admin'
union select 'pihwiki_p', count(ug_user) from pihwiki_p.user_groups where ug_group = 'interface-admin'
union select 'piwiki_p', count(ug_user) from piwiki_p.user_groups where ug_group = 'interface-admin'
union select 'piwiktionary_p', count(ug_user) from piwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'plwiki_p', count(ug_user) from plwiki_p.user_groups where ug_group = 'interface-admin'
union select 'plwikibooks_p', count(ug_user) from plwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'plwikimedia_p', count(ug_user) from plwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'plwikinews_p', count(ug_user) from plwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'plwikiquote_p', count(ug_user) from plwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'plwikisource_p', count(ug_user) from plwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'plwikivoyage_p', count(ug_user) from plwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'plwiktionary_p', count(ug_user) from plwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'pmswiki_p', count(ug_user) from pmswiki_p.user_groups where ug_group = 'interface-admin'
union select 'pmswikisource_p', count(ug_user) from pmswikisource_p.user_groups where ug_group = 'interface-admin'
union select 'pnbwiki_p', count(ug_user) from pnbwiki_p.user_groups where ug_group = 'interface-admin'
union select 'pnbwiktionary_p', count(ug_user) from pnbwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'pntwiki_p', count(ug_user) from pntwiki_p.user_groups where ug_group = 'interface-admin'
union select 'pswiki_p', count(ug_user) from pswiki_p.user_groups where ug_group = 'interface-admin'
union select 'pswikibooks_p', count(ug_user) from pswikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'pswikivoyage_p', count(ug_user) from pswikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'pswiktionary_p', count(ug_user) from pswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'ptwiki_p', count(ug_user) from ptwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ptwikibooks_p', count(ug_user) from ptwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ptwikimedia_p', count(ug_user) from ptwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'ptwikinews_p', count(ug_user) from ptwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'ptwikiquote_p', count(ug_user) from ptwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'ptwikisource_p', count(ug_user) from ptwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'ptwikiversity_p', count(ug_user) from ptwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'ptwikivoyage_p', count(ug_user) from ptwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'ptwiktionary_p', count(ug_user) from ptwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'qualitywiki_p', count(ug_user) from qualitywiki_p.user_groups where ug_group = 'interface-admin'
union select 'quwiki_p', count(ug_user) from quwiki_p.user_groups where ug_group = 'interface-admin'
union select 'quwikibooks_p', count(ug_user) from quwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'quwikiquote_p', count(ug_user) from quwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'quwiktionary_p', count(ug_user) from quwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'rmwiki_p', count(ug_user) from rmwiki_p.user_groups where ug_group = 'interface-admin'
union select 'rmwikibooks_p', count(ug_user) from rmwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'rmwiktionary_p', count(ug_user) from rmwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'rmywiki_p', count(ug_user) from rmywiki_p.user_groups where ug_group = 'interface-admin'
union select 'rnwiki_p', count(ug_user) from rnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'rnwiktionary_p', count(ug_user) from rnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'roa_rupwiki_p', count(ug_user) from roa_rupwiki_p.user_groups where ug_group = 'interface-admin'
union select 'roa_rupwiktionary_p', count(ug_user) from roa_rupwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'roa_tarawiki_p', count(ug_user) from roa_tarawiki_p.user_groups where ug_group = 'interface-admin'
union select 'romdwikimedia_p', count(ug_user) from romdwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'rowiki_p', count(ug_user) from rowiki_p.user_groups where ug_group = 'interface-admin'
union select 'rowikibooks_p', count(ug_user) from rowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'rowikinews_p', count(ug_user) from rowikinews_p.user_groups where ug_group = 'interface-admin'
union select 'rowikiquote_p', count(ug_user) from rowikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'rowikisource_p', count(ug_user) from rowikisource_p.user_groups where ug_group = 'interface-admin'
union select 'rowikivoyage_p', count(ug_user) from rowikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'rowiktionary_p', count(ug_user) from rowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'rswikimedia_p', count(ug_user) from rswikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'ruewiki_p', count(ug_user) from ruewiki_p.user_groups where ug_group = 'interface-admin'
union select 'ruwiki_p', count(ug_user) from ruwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ruwikibooks_p', count(ug_user) from ruwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ruwikimedia_p', count(ug_user) from ruwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'ruwikinews_p', count(ug_user) from ruwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'ruwikiquote_p', count(ug_user) from ruwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'ruwikisource_p', count(ug_user) from ruwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'ruwikiversity_p', count(ug_user) from ruwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'ruwikivoyage_p', count(ug_user) from ruwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'ruwiktionary_p', count(ug_user) from ruwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'rwwiki_p', count(ug_user) from rwwiki_p.user_groups where ug_group = 'interface-admin'
union select 'rwwiktionary_p', count(ug_user) from rwwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'sahwiki_p', count(ug_user) from sahwiki_p.user_groups where ug_group = 'interface-admin'
union select 'sahwikiquote_p', count(ug_user) from sahwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'sahwikisource_p', count(ug_user) from sahwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'satwiki_p', count(ug_user) from satwiki_p.user_groups where ug_group = 'interface-admin'
union select 'sawiki_p', count(ug_user) from sawiki_p.user_groups where ug_group = 'interface-admin'
union select 'sawikibooks_p', count(ug_user) from sawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'sawikiquote_p', count(ug_user) from sawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'sawikisource_p', count(ug_user) from sawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'sawiktionary_p', count(ug_user) from sawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'scnwiki_p', count(ug_user) from scnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'scnwiktionary_p', count(ug_user) from scnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'scowiki_p', count(ug_user) from scowiki_p.user_groups where ug_group = 'interface-admin'
union select 'scwiki_p', count(ug_user) from scwiki_p.user_groups where ug_group = 'interface-admin'
union select 'scwiktionary_p', count(ug_user) from scwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'sdwiki_p', count(ug_user) from sdwiki_p.user_groups where ug_group = 'interface-admin'
union select 'sdwikinews_p', count(ug_user) from sdwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'sdwiktionary_p', count(ug_user) from sdwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'sewiki_p', count(ug_user) from sewiki_p.user_groups where ug_group = 'interface-admin'
union select 'sewikibooks_p', count(ug_user) from sewikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'sewikimedia_p', count(ug_user) from sewikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'sgwiki_p', count(ug_user) from sgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'sgwiktionary_p', count(ug_user) from sgwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'shwiki_p', count(ug_user) from shwiki_p.user_groups where ug_group = 'interface-admin'
union select 'shwiktionary_p', count(ug_user) from shwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'simplewiki_p', count(ug_user) from simplewiki_p.user_groups where ug_group = 'interface-admin'
union select 'simplewikibooks_p', count(ug_user) from simplewikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'simplewikiquote_p', count(ug_user) from simplewikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'simplewiktionary_p', count(ug_user) from simplewiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'siwiki_p', count(ug_user) from siwiki_p.user_groups where ug_group = 'interface-admin'
union select 'siwikibooks_p', count(ug_user) from siwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'siwiktionary_p', count(ug_user) from siwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'skwiki_p', count(ug_user) from skwiki_p.user_groups where ug_group = 'interface-admin'
union select 'skwikibooks_p', count(ug_user) from skwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'skwikiquote_p', count(ug_user) from skwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'skwikisource_p', count(ug_user) from skwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'skwiktionary_p', count(ug_user) from skwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'slwiki_p', count(ug_user) from slwiki_p.user_groups where ug_group = 'interface-admin'
union select 'slwikibooks_p', count(ug_user) from slwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'slwikiquote_p', count(ug_user) from slwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'slwikisource_p', count(ug_user) from slwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'slwikiversity_p', count(ug_user) from slwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'slwiktionary_p', count(ug_user) from slwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'smwiki_p', count(ug_user) from smwiki_p.user_groups where ug_group = 'interface-admin'
union select 'smwiktionary_p', count(ug_user) from smwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'snwiki_p', count(ug_user) from snwiki_p.user_groups where ug_group = 'interface-admin'
union select 'snwiktionary_p', count(ug_user) from snwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'sourceswiki_p', count(ug_user) from sourceswiki_p.user_groups where ug_group = 'interface-admin'
union select 'sowiki_p', count(ug_user) from sowiki_p.user_groups where ug_group = 'interface-admin'
union select 'sowiktionary_p', count(ug_user) from sowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'specieswiki_p', count(ug_user) from specieswiki_p.user_groups where ug_group = 'interface-admin'
union select 'sqwiki_p', count(ug_user) from sqwiki_p.user_groups where ug_group = 'interface-admin'
union select 'sqwikibooks_p', count(ug_user) from sqwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'sqwikinews_p', count(ug_user) from sqwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'sqwikiquote_p', count(ug_user) from sqwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'sqwiktionary_p', count(ug_user) from sqwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'srnwiki_p', count(ug_user) from srnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'srwiki_p', count(ug_user) from srwiki_p.user_groups where ug_group = 'interface-admin'
union select 'srwikibooks_p', count(ug_user) from srwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'srwikinews_p', count(ug_user) from srwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'srwikiquote_p', count(ug_user) from srwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'srwikisource_p', count(ug_user) from srwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'srwiktionary_p', count(ug_user) from srwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'sswiki_p', count(ug_user) from sswiki_p.user_groups where ug_group = 'interface-admin'
union select 'sswiktionary_p', count(ug_user) from sswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'stqwiki_p', count(ug_user) from stqwiki_p.user_groups where ug_group = 'interface-admin'
union select 'strategywiki_p', count(ug_user) from strategywiki_p.user_groups where ug_group = 'interface-admin'
union select 'stwiki_p', count(ug_user) from stwiki_p.user_groups where ug_group = 'interface-admin'
union select 'stwiktionary_p', count(ug_user) from stwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'suwiki_p', count(ug_user) from suwiki_p.user_groups where ug_group = 'interface-admin'
union select 'suwikibooks_p', count(ug_user) from suwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'suwikiquote_p', count(ug_user) from suwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'suwiktionary_p', count(ug_user) from suwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'svwiki_p', count(ug_user) from svwiki_p.user_groups where ug_group = 'interface-admin'
union select 'svwikibooks_p', count(ug_user) from svwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'svwikinews_p', count(ug_user) from svwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'svwikiquote_p', count(ug_user) from svwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'svwikisource_p', count(ug_user) from svwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'svwikiversity_p', count(ug_user) from svwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'svwikivoyage_p', count(ug_user) from svwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'svwiktionary_p', count(ug_user) from svwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'swwiki_p', count(ug_user) from swwiki_p.user_groups where ug_group = 'interface-admin'
union select 'swwikibooks_p', count(ug_user) from swwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'swwiktionary_p', count(ug_user) from swwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'szlwiki_p', count(ug_user) from szlwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tawiki_p', count(ug_user) from tawiki_p.user_groups where ug_group = 'interface-admin'
union select 'tawikibooks_p', count(ug_user) from tawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'tawikinews_p', count(ug_user) from tawikinews_p.user_groups where ug_group = 'interface-admin'
union select 'tawikiquote_p', count(ug_user) from tawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'tawikisource_p', count(ug_user) from tawikisource_p.user_groups where ug_group = 'interface-admin'
union select 'tawiktionary_p', count(ug_user) from tawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tcywiki_p', count(ug_user) from tcywiki_p.user_groups where ug_group = 'interface-admin'
union select 'tenwiki_p', count(ug_user) from tenwiki_p.user_groups where ug_group = 'interface-admin'
union select 'test2wiki_p', count(ug_user) from test2wiki_p.user_groups where ug_group = 'interface-admin'
union select 'testwiki_p', count(ug_user) from testwiki_p.user_groups where ug_group = 'interface-admin'
union select 'testwikidatawiki_p', count(ug_user) from testwikidatawiki_p.user_groups where ug_group = 'interface-admin'
union select 'tetwiki_p', count(ug_user) from tetwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tewiki_p', count(ug_user) from tewiki_p.user_groups where ug_group = 'interface-admin'
union select 'tewikibooks_p', count(ug_user) from tewikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'tewikiquote_p', count(ug_user) from tewikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'tewikisource_p', count(ug_user) from tewikisource_p.user_groups where ug_group = 'interface-admin'
union select 'tewiktionary_p', count(ug_user) from tewiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tgwiki_p', count(ug_user) from tgwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tgwikibooks_p', count(ug_user) from tgwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'tgwiktionary_p', count(ug_user) from tgwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'thwiki_p', count(ug_user) from thwiki_p.user_groups where ug_group = 'interface-admin'
union select 'thwikibooks_p', count(ug_user) from thwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'thwikinews_p', count(ug_user) from thwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'thwikiquote_p', count(ug_user) from thwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'thwikisource_p', count(ug_user) from thwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'thwiktionary_p', count(ug_user) from thwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tiwiki_p', count(ug_user) from tiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tiwiktionary_p', count(ug_user) from tiwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tkwiki_p', count(ug_user) from tkwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tkwikibooks_p', count(ug_user) from tkwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'tkwikiquote_p', count(ug_user) from tkwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'tkwiktionary_p', count(ug_user) from tkwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tlwiki_p', count(ug_user) from tlwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tlwikibooks_p', count(ug_user) from tlwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'tlwiktionary_p', count(ug_user) from tlwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tnwiki_p', count(ug_user) from tnwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tnwiktionary_p', count(ug_user) from tnwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'towiki_p', count(ug_user) from towiki_p.user_groups where ug_group = 'interface-admin'
union select 'towiktionary_p', count(ug_user) from towiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tpiwiki_p', count(ug_user) from tpiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tpiwiktionary_p', count(ug_user) from tpiwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'trwiki_p', count(ug_user) from trwiki_p.user_groups where ug_group = 'interface-admin'
union select 'trwikibooks_p', count(ug_user) from trwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'trwikimedia_p', count(ug_user) from trwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'trwikinews_p', count(ug_user) from trwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'trwikiquote_p', count(ug_user) from trwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'trwikisource_p', count(ug_user) from trwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'trwiktionary_p', count(ug_user) from trwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tswiki_p', count(ug_user) from tswiki_p.user_groups where ug_group = 'interface-admin'
union select 'tswiktionary_p', count(ug_user) from tswiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'ttwiki_p', count(ug_user) from ttwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ttwikibooks_p', count(ug_user) from ttwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ttwikiquote_p', count(ug_user) from ttwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'ttwiktionary_p', count(ug_user) from ttwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tumwiki_p', count(ug_user) from tumwiki_p.user_groups where ug_group = 'interface-admin'
union select 'twwiki_p', count(ug_user) from twwiki_p.user_groups where ug_group = 'interface-admin'
union select 'twwiktionary_p', count(ug_user) from twwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'tyvwiki_p', count(ug_user) from tyvwiki_p.user_groups where ug_group = 'interface-admin'
union select 'tywiki_p', count(ug_user) from tywiki_p.user_groups where ug_group = 'interface-admin'
union select 'uawikimedia_p', count(ug_user) from uawikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'udmwiki_p', count(ug_user) from udmwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ugwiki_p', count(ug_user) from ugwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ugwikibooks_p', count(ug_user) from ugwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ugwikiquote_p', count(ug_user) from ugwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'ugwiktionary_p', count(ug_user) from ugwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'ukwiki_p', count(ug_user) from ukwiki_p.user_groups where ug_group = 'interface-admin'
union select 'ukwikibooks_p', count(ug_user) from ukwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'ukwikinews_p', count(ug_user) from ukwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'ukwikiquote_p', count(ug_user) from ukwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'ukwikisource_p', count(ug_user) from ukwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'ukwikivoyage_p', count(ug_user) from ukwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'ukwiktionary_p', count(ug_user) from ukwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'urwiki_p', count(ug_user) from urwiki_p.user_groups where ug_group = 'interface-admin'
union select 'urwikibooks_p', count(ug_user) from urwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'urwikiquote_p', count(ug_user) from urwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'urwiktionary_p', count(ug_user) from urwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'usabilitywiki_p', count(ug_user) from usabilitywiki_p.user_groups where ug_group = 'interface-admin'
union select 'uzwiki_p', count(ug_user) from uzwiki_p.user_groups where ug_group = 'interface-admin'
union select 'uzwikibooks_p', count(ug_user) from uzwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'uzwikiquote_p', count(ug_user) from uzwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'uzwiktionary_p', count(ug_user) from uzwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'vecwiki_p', count(ug_user) from vecwiki_p.user_groups where ug_group = 'interface-admin'
union select 'vecwikisource_p', count(ug_user) from vecwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'vecwiktionary_p', count(ug_user) from vecwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'vepwiki_p', count(ug_user) from vepwiki_p.user_groups where ug_group = 'interface-admin'
union select 'vewiki_p', count(ug_user) from vewiki_p.user_groups where ug_group = 'interface-admin'
union select 'viwiki_p', count(ug_user) from viwiki_p.user_groups where ug_group = 'interface-admin'
union select 'viwikibooks_p', count(ug_user) from viwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'viwikiquote_p', count(ug_user) from viwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'viwikisource_p', count(ug_user) from viwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'viwikivoyage_p', count(ug_user) from viwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'viwiktionary_p', count(ug_user) from viwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'vlswiki_p', count(ug_user) from vlswiki_p.user_groups where ug_group = 'interface-admin'
union select 'votewiki_p', count(ug_user) from votewiki_p.user_groups where ug_group = 'interface-admin'
union select 'vowiki_p', count(ug_user) from vowiki_p.user_groups where ug_group = 'interface-admin'
union select 'vowikibooks_p', count(ug_user) from vowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'vowikiquote_p', count(ug_user) from vowikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'vowiktionary_p', count(ug_user) from vowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'warwiki_p', count(ug_user) from warwiki_p.user_groups where ug_group = 'interface-admin'
union select 'wawiki_p', count(ug_user) from wawiki_p.user_groups where ug_group = 'interface-admin'
union select 'wawikibooks_p', count(ug_user) from wawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'wawiktionary_p', count(ug_user) from wawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'wbwikimedia_p', count(ug_user) from wbwikimedia_p.user_groups where ug_group = 'interface-admin'
union select 'wikidatawiki_p', count(ug_user) from wikidatawiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2005wiki_p', count(ug_user) from wikimania2005wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2006wiki_p', count(ug_user) from wikimania2006wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2007wiki_p', count(ug_user) from wikimania2007wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2008wiki_p', count(ug_user) from wikimania2008wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2009wiki_p', count(ug_user) from wikimania2009wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2010wiki_p', count(ug_user) from wikimania2010wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2011wiki_p', count(ug_user) from wikimania2011wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2012wiki_p', count(ug_user) from wikimania2012wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2013wiki_p', count(ug_user) from wikimania2013wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2014wiki_p', count(ug_user) from wikimania2014wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2015wiki_p', count(ug_user) from wikimania2015wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2016wiki_p', count(ug_user) from wikimania2016wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2017wiki_p', count(ug_user) from wikimania2017wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimania2018wiki_p', count(ug_user) from wikimania2018wiki_p.user_groups where ug_group = 'interface-admin'
union select 'wikimaniawiki_p', count(ug_user) from wikimaniawiki_p.user_groups where ug_group = 'interface-admin'
union select 'wowiki_p', count(ug_user) from wowiki_p.user_groups where ug_group = 'interface-admin'
union select 'wowikiquote_p', count(ug_user) from wowikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'wowiktionary_p', count(ug_user) from wowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'wuuwiki_p', count(ug_user) from wuuwiki_p.user_groups where ug_group = 'interface-admin'
union select 'xalwiki_p', count(ug_user) from xalwiki_p.user_groups where ug_group = 'interface-admin'
union select 'xhwiki_p', count(ug_user) from xhwiki_p.user_groups where ug_group = 'interface-admin'
union select 'xhwikibooks_p', count(ug_user) from xhwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'xhwiktionary_p', count(ug_user) from xhwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'xmfwiki_p', count(ug_user) from xmfwiki_p.user_groups where ug_group = 'interface-admin'
union select 'yiwiki_p', count(ug_user) from yiwiki_p.user_groups where ug_group = 'interface-admin'
union select 'yiwikisource_p', count(ug_user) from yiwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'yiwiktionary_p', count(ug_user) from yiwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'yowiki_p', count(ug_user) from yowiki_p.user_groups where ug_group = 'interface-admin'
union select 'yowikibooks_p', count(ug_user) from yowikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'yowiktionary_p', count(ug_user) from yowiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'zawiki_p', count(ug_user) from zawiki_p.user_groups where ug_group = 'interface-admin'
union select 'zawikibooks_p', count(ug_user) from zawikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'zawikiquote_p', count(ug_user) from zawikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'zawiktionary_p', count(ug_user) from zawiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'zeawiki_p', count(ug_user) from zeawiki_p.user_groups where ug_group = 'interface-admin'
union select 'zh_classicalwiki_p', count(ug_user) from zh_classicalwiki_p.user_groups where ug_group = 'interface-admin'
union select 'zh_min_nanwiki_p', count(ug_user) from zh_min_nanwiki_p.user_groups where ug_group = 'interface-admin'
union select 'zh_min_nanwikibooks_p', count(ug_user) from zh_min_nanwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'zh_min_nanwikiquote_p', count(ug_user) from zh_min_nanwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'zh_min_nanwikisource_p', count(ug_user) from zh_min_nanwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'zh_min_nanwiktionary_p', count(ug_user) from zh_min_nanwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'zh_yuewiki_p', count(ug_user) from zh_yuewiki_p.user_groups where ug_group = 'interface-admin'
union select 'zhwiki_p', count(ug_user) from zhwiki_p.user_groups where ug_group = 'interface-admin'
union select 'zhwikibooks_p', count(ug_user) from zhwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'zhwikinews_p', count(ug_user) from zhwikinews_p.user_groups where ug_group = 'interface-admin'
union select 'zhwikiquote_p', count(ug_user) from zhwikiquote_p.user_groups where ug_group = 'interface-admin'
union select 'zhwikisource_p', count(ug_user) from zhwikisource_p.user_groups where ug_group = 'interface-admin'
union select 'zhwikiversity_p', count(ug_user) from zhwikiversity_p.user_groups where ug_group = 'interface-admin'
union select 'zhwikivoyage_p', count(ug_user) from zhwikivoyage_p.user_groups where ug_group = 'interface-admin'
union select 'zhwiktionary_p', count(ug_user) from zhwiktionary_p.user_groups where ug_group = 'interface-admin'
union select 'zuwiki_p', count(ug_user) from zuwiki_p.user_groups where ug_group = 'interface-admin'
union select 'zuwikibooks_p', count(ug_user) from zuwikibooks_p.user_groups where ug_group = 'interface-admin'
union select 'zuwiktionary_p', count(ug_user) from zuwiktionary_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...
