quarry-expand (aggregate)

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

SELECT SUM(c) FROM (/*quarry-expand: ok (specials)*/
SELECT COUNT(*) c FROM advisorywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM arwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM bdwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM bewikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM betawikiversity_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM brwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM cawikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM cowikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM commonswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM dkwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM etwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM fiwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM incubatorwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM loginwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM mediawikiwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM metawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM mkwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM mxwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM nlwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM nowikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM nycwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM nzwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM outreachwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM pa_uswikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM plwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM qualitywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM ruwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM sewikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM sourceswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM specieswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM strategywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM tenwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM testwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM test2wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM testwikidatawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM trwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM uawikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM ukwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM usabilitywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikidatawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2005wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2006wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2007wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2008wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2009wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2010wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2011wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2012wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2013wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2014wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2015wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2016wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
UNION ALL SELECT COUNT(*) c FROM wikimania2017wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%'
) as x;
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...
