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 COUNT(rev_id) AS counter, 'zhwikisource' AS dbname FROM zhwikisource_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zhwikivoyage' AS dbname FROM zhwikivoyage_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zhwiktionary' AS dbname FROM zhwiktionary_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zh_classicalwiki' AS dbname FROM zh_classicalwiki_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zh_min_nanwiki' AS dbname FROM zh_min_nanwiki_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zh_min_nanwikisource' AS dbname FROM zh_min_nanwikisource_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zh_min_nanwiktionary' AS dbname FROM zh_min_nanwiktionary_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zh_yuewiki' AS dbname FROM zh_yuewiki_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zuwiki' AS dbname FROM zuwiki_p.revision_userindex WHERE rev_user_text = 'Krinkle' UNION ALL SELECT COUNT(rev_id) AS counter, 'zuwiktionary' AS dbname FROM zuwiktionary_p.revision_userindex WHERE rev_user_text = 'Krinkle'
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...
