MariaDB [centralauth]> select count(*), gu_home_db from globaluser where gu_home_db IN ('alswikibooks', 'alswikiquote', 'alswiktionary', 'bawiktionary', 'chwikimedia', 'closed_zh_twwiki', 'comcomwiki', 'de_labswikimedia', 'dkwiki', 'dkwikibooks', 'dkwiktionary', 'en_labswikimedia', 'fixcopyrightwiki', 'flaggedrevs_labswikimedia', 'langcomwiki', 'liquidthreads_labswikimedia', 'mowiki', 'mowiktionary', 'noboardwiki', 'nomcomwiki', 'readerfeedback_labswikimedia', 'rel13testwiki', 'ru_sibwiki', 'sep11wiki', 'strategyappswiki', 'tlhwiki', 'tlhwiktionary', 'tokiponawiki', 'tokiponawikibooks', 'tokiponawikiquote', 'tokiponawikisource', 'tokiponawiktionary', 'ukwikimedia', 'vewikimedia', 'zerowiki', 'zh_cnwiki', 'zh_twwiki') GROUP BY gu_home_db; +----------+------------------------------+ | count(*) | gu_home_db | +----------+------------------------------+ | 12 | alswikibooks | | 10 | alswikiquote | | 17 | alswiktionary | | 2 | chwikimedia | | 12 | de_labswikimedia | | 93 | en_labswikimedia | | 36 | flaggedrevs_labswikimedia | | 187 | mowiki | | 21 | mowiktionary | | 10 | readerfeedback_labswikimedia | | 1682 | ukwikimedia | +----------+------------------------------+ 11 rows in set (1 min 22.56 sec)
While I don't thinks has many practical issues... It does seem messy