Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Krinkle
.
Toggle Highlighting
SQL
SELECT SUM(*) FROM (/*quarry-expand: ok (specials)*/ SELECT COUNT(*) FROM advisorywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM arwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM arbcom_cswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM arbcom_dewiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM arbcom_enwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM arbcom_fiwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM arbcom_nlwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM auditcomwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM bdwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM bewikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM betawikiversity_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM boardwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM boardgovcomwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM brwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM cawikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM chairwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM chapcomwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM checkuserwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM cnwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM cowikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM collabwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM commonswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM dkwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM donatewiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM ecwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM etwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM execwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM fdcwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM fiwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM foundationwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM grantswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM iegcomwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM ilwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM incubatorwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM internalwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM legalteamwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM loginwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM mediawikiwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM metawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM mkwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM movementroleswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM mxwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM nlwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM nowikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM noboard_chapterswikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM nostalgiawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM nycwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM nzwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM officewiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM ombudsmenwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM otrs_wikiwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM outreachwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM pa_uswikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM plwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM projectcomwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM qualitywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM rswikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM ruwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM sewikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM searchcomwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM sourceswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM spcomwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM specieswiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM stewardwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM strategywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM tenwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM testwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM test2wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM testwikidatawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM trwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM transitionteamwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM uawikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM ukwikimedia_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM usabilitywiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM votewiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wg_enwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikidatawiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2005wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2006wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2007wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2008wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2009wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2010wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2011wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2012wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2013wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2014wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2015wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2016wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimania2017wiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM wikimaniateamwiki_p.revision_userindex WHERE rev_user_text='Krinkle' AND rev_comment LIKE 'Maintenance:%' UNION ALL SELECT COUNT(*) FROM zerowiki_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
.
Checking query status...