quarry-expand (aggregate)

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

php

quarry-expand
output:
/*quarry-expand: ok (specials)*/
SELECT "arwikimedia" as w, COUNT(*) as c FROM arwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "bdwikimedia" as w, COUNT(*) as c FROM bdwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "bewikimedia" as w, COUNT(*) as c FROM bewikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "betawikiversity" as w, COUNT(*) as c FROM betawikiversity_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "brwikimedia" as w, COUNT(*) as c FROM brwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "cawikimedia" as w, COUNT(*) as c FROM cawikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "cowikimedia" as w, COUNT(*) as c FROM cowikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "commonswiki" as w, COUNT(*) as c FROM commonswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "dkwikimedia" as w, COUNT(*) as c FROM dkwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "etwikimedia" as w, COUNT(*) as c FROM etwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "fiwikimedia" as w, COUNT(*) as c FROM fiwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "incubatorwiki" as w, COUNT(*) as c FROM incubatorwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "loginwiki" as w, COUNT(*) as c FROM loginwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "mediawikiwiki" as w, COUNT(*) as c FROM mediawikiwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "metawiki" as w, COUNT(*) as c FROM metawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "mkwikimedia" as w, COUNT(*) as c FROM mkwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "mxwikimedia" as w, COUNT(*) as c FROM mxwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "nlwikimedia" as w, COUNT(*) as c FROM nlwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "nowikimedia" as w, COUNT(*) as c FROM nowikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "nycwikimedia" as w, COUNT(*) as c FROM nycwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "outreachwiki" as w, COUNT(*) as c FROM outreachwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "plwikimedia" as w, COUNT(*) as c FROM plwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "ruwikimedia" as w, COUNT(*) as c FROM ruwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "sewikimedia" as w, COUNT(*) as c FROM sewikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "sourceswiki" as w, COUNT(*) as c FROM sourceswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "specieswiki" as w, COUNT(*) as c FROM specieswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "testwiki" as w, COUNT(*) as c FROM testwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "test2wiki" as w, COUNT(*) as c FROM test2wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "testwikidatawiki" as w, COUNT(*) as c FROM testwikidatawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "trwikimedia" as w, COUNT(*) as c FROM trwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "uawikimedia" as w, COUNT(*) as c FROM uawikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "wikidatawiki" as w, COUNT(*) as c FROM wikidatawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "wikimania2016wiki" as w, COUNT(*) as c FROM wikimania2016wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT "wikimania2017wiki" as w, COUNT(*) as c FROM wikimania2017wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%';
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...
