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
Jura1
.
Toggle Highlighting
SQL
# test # See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg UNION SELECT COUNT(*), "th" AS Wiki FROM thwiki_p.categorylinks WHERE cl_to="เพิ่งตาย" UNION SELECT COUNT(*), "fa" AS Wiki FROM fawiki_p.categorylinks WHERE cl_to="بهتازگی_درگذشتگان" UNION SELECT COUNT(*), "tl" AS Wiki FROM tlwiki_p.categorylinks WHERE cl_to="Namatay_kamakailan" UNION SELECT COUNT(*), "uk" AS Wiki FROM ukwiki_p.categorylinks WHERE cl_to="Нещодавно_померлі" UNION SELECT COUNT(*), "ja" AS Wiki FROM jawiki_p.categorylinks WHERE cl_to="亡くなったばかりの人物" UNION SELECT COUNT(*), "pt" AS Wiki FROM ptwiki_p.categorylinks WHERE cl_to="Mortes_recentes" UNION SELECT COUNT(*), "es" AS Wiki FROM eswiki_p.categorylinks WHERE cl_to="Fallecidos_recientemente" UNION SELECT COUNT(*), "sk" AS Wiki FROM skwiki_p.categorylinks WHERE cl_to="Nedávne_úmrtia" UNION SELECT COUNT(*), "en" AS Wiki FROM enwiki_p.categorylinks WHERE cl_to="Recent_deaths" UNION SELECT COUNT(*), "ru" AS Wiki FROM ruwiki_p.categorylinks WHERE cl_to="Недавно_умершие" UNION SELECT COUNT(*), "ro" AS Wiki FROM rowiki_p.categorylinks WHERE cl_to="Decese_recente" UNION SELECT COUNT(*), "ko" AS Wiki FROM kowiki_p.categorylinks WHERE cl_to="최근에_죽은_사람" UNION SELECT COUNT(*), "fr" AS Wiki FROM frwiki_p.categorylinks WHERE cl_to="Mort_récente" UNION SELECT COUNT(*), "zh" AS Wiki FROM zhwiki_p.categorylinks WHERE cl_to="最近逝世" UNION SELECT COUNT(*), "da" AS Wiki FROM dawiki_p.categorylinks WHERE cl_to="Nyligt_afdøde" UNION SELECT COUNT(*), "simple" AS Wiki FROM simplewiki_p.categorylinks WHERE cl_to="Recent_deaths" UNION SELECT COUNT(*), "sv" AS Wiki FROM svwiki_p.categorylinks WHERE cl_to="Nyligen_avlidna_personer" UNION SELECT COUNT(*), "zh-yue" AS Wiki FROM zh_yuewiki_p.categorylinks WHERE cl_to="最近死" UNION SELECT COUNT(*), "mk" AS Wiki FROM mkwiki_p.categorylinks WHERE cl_to="Скоро_починати" UNION SELECT COUNT(*), "as" AS Wiki FROM aswiki_p.categorylinks WHERE cl_to="শেহতীয়াভাৱে_মৃত্যু_হোৱা_ব্যক্তি" UNION SELECT COUNT(*), "no" AS Wiki FROM nowiki_p.categorylinks WHERE cl_to="Nylig_avdøde" UNION SELECT COUNT(*), "tr" AS Wiki FROM trwiki_p.categorylinks WHERE cl_to="Yeni_ölümler" UNION SELECT COUNT(*), "sco" AS Wiki FROM scowiki_p.categorylinks WHERE cl_to="Recent_daiths" UNION SELECT COUNT(*), "ar" AS Wiki FROM arwiki_p.categorylinks WHERE cl_to="وفيات_حديثة" UNION SELECT COUNT(*), "hu" AS Wiki FROM huwiki_p.categorylinks WHERE cl_to="Friss_halálesetek" UNION SELECT COUNT(*), "vi" AS Wiki FROM viwiki_p.categorylinks WHERE cl_to="Người_mới_qua_đời"
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...