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 SELECT COUNT(*), "an" AS Wiki FROM anwiki_p.categorylinks WHERE cl_to="2015 (muertes)" UNION SELECT COUNT(*), "ar" AS Wiki FROM arwiki_p.categorylinks WHERE cl_to="وفيات 2015" UNION SELECT COUNT(*), "arz" AS Wiki FROM arzwiki_p.categorylinks WHERE cl_to="وفيات 2015" UNION SELECT COUNT(*), "az" AS Wiki FROM azwiki_p.categorylinks WHERE cl_to="2015-ci ildə vəfat edənlər" UNION SELECT COUNT(*), "ba" AS Wiki FROM bawiki_p.categorylinks WHERE cl_to="2015 йылда вафаттар" UNION SELECT COUNT(*), "be" AS Wiki FROM bewiki_p.categorylinks WHERE cl_to="Памерлі ў 2015 годзе" UNION SELECT COUNT(*), "be-x-old" AS Wiki FROM be-x-oldwiki_p.categorylinks WHERE cl_to="Памерлі ў 2015 годзе" UNION SELECT COUNT(*), "bg" AS Wiki FROM bgwiki_p.categorylinks WHERE cl_to="Починали през 2015 година" UNION SELECT COUNT(*), "bn" AS Wiki FROM bnwiki_p.categorylinks WHERE cl_to="২০১৫-এ মৃত্যু" UNION SELECT COUNT(*), "br" AS Wiki FROM brwiki_p.categorylinks WHERE cl_to="Marvioù 2015" UNION SELECT COUNT(*), "bs" AS Wiki FROM bswiki_p.categorylinks WHERE cl_to="Umrli 2015." UNION SELECT COUNT(*), "ca" AS Wiki FROM cawiki_p.categorylinks WHERE cl_to="Morts el 2015" UNION SELECT COUNT(*), "ckb" AS Wiki FROM ckbwiki_p.categorylinks WHERE cl_to="مردووانی ٢٠١٥" UNION SELECT COUNT(*), "cs" AS Wiki FROM cswiki_p.categorylinks WHERE cl_to="Úmrtí 2015" UNION SELECT COUNT(*), "cy" AS Wiki FROM cywiki_p.categorylinks WHERE cl_to="Marwolaethau 2015" UNION SELECT COUNT(*), "da" AS Wiki FROM dawiki_p.categorylinks WHERE cl_to="Døde i 2015" UNION SELECT COUNT(*), "de" AS Wiki FROM dewiki_p.categorylinks WHERE cl_to="Gestorben 2015" UNION SELECT COUNT(*), "dsb" AS Wiki FROM dsbwiki_p.categorylinks WHERE cl_to="Wum. 2015" UNION SELECT COUNT(*), "el" AS Wiki FROM elwiki_p.categorylinks WHERE cl_to="Θάνατοι το 2015" UNION SELECT COUNT(*), "en" AS Wiki FROM enwiki_p.categorylinks WHERE cl_to="2015 deaths" UNION SELECT COUNT(*), "eo" AS Wiki FROM eowiki_p.categorylinks WHERE cl_to="Mortintoj en 2015" UNION SELECT COUNT(*), "es" AS Wiki FROM eswiki_p.categorylinks WHERE cl_to="Fallecidos en 2015" UNION SELECT COUNT(*), "et" AS Wiki FROM etwiki_p.categorylinks WHERE cl_to="Surnud 2015" UNION SELECT COUNT(*), "eu" AS Wiki FROM euwiki_p.categorylinks WHERE cl_to="2015eko heriotzak" UNION SELECT COUNT(*), "fa" AS Wiki FROM fawiki_p.categorylinks WHERE cl_to="درگذشتگان ۲۰۱۵ (میلادی)" UNION SELECT COUNT(*), "fi" AS Wiki FROM fiwiki_p.categorylinks WHERE cl_to="Vuonna 2015 kuolleet" UNION SELECT COUNT(*), "fo" AS Wiki FROM fowiki_p.categorylinks WHERE cl_to="Andlát í 2015" UNION SELECT COUNT(*), "fr" AS Wiki FROM frwiki_p.categorylinks WHERE cl_to="Décès en 2015" UNION SELECT COUNT(*), "ga" AS Wiki FROM gawiki_p.categorylinks WHERE cl_to="Básanna i 2015" UNION SELECT COUNT(*), "gl" AS Wiki FROM glwiki_p.categorylinks WHERE cl_to="Finados en 2015" UNION SELECT COUNT(*), "hi" AS Wiki FROM hiwiki_p.categorylinks WHERE cl_to="२०१५ में निधन" UNION SELECT COUNT(*), "hsb" AS Wiki FROM hsbwiki_p.categorylinks WHERE cl_to="Zemr. 2015" UNION SELECT COUNT(*), "hu" AS Wiki FROM huwiki_p.categorylinks WHERE cl_to="2015-ben elhunyt személyek" UNION SELECT COUNT(*), "hy" AS Wiki FROM hywiki_p.categorylinks WHERE cl_to="2015 մահեր" UNION SELECT COUNT(*), "id" AS Wiki FROM idwiki_p.categorylinks WHERE cl_to="Kematian 2015" UNION SELECT COUNT(*), "ilo" AS Wiki FROM ilowiki_p.categorylinks WHERE cl_to="2015 nga ipupusay" UNION SELECT COUNT(*), "it" AS Wiki FROM itwiki_p.categorylinks WHERE cl_to="Morti nel 2015" UNION SELECT COUNT(*), "ja" AS Wiki FROM jawiki_p.categorylinks WHERE cl_to="2015年没" UNION SELECT COUNT(*), "jv" AS Wiki FROM jvwiki_p.categorylinks WHERE cl_to="Pati 2015" UNION SELECT COUNT(*), "ka" AS Wiki FROM kawiki_p.categorylinks WHERE cl_to="გარდაცვლილი 2015" UNION SELECT COUNT(*), "kk" AS Wiki FROM kkwiki_p.categorylinks WHERE cl_to="2015 жылы қайтыс болғандар" UNION SELECT COUNT(*), "ko" AS Wiki FROM kowiki_p.categorylinks WHERE cl_to="2015년 죽음" UNION SELECT COUNT(*), "la" AS Wiki FROM lawiki_p.categorylinks WHERE cl_to="Mortui 2015" UNION SELECT COUNT(*), "lb" AS Wiki FROM lbwiki_p.categorylinks WHERE cl_to="Gestuerwen 2015" UNION SELECT COUNT(*), "lv" AS Wiki FROM lvwiki_p.categorylinks WHERE cl_to="2015. gadā mirušie" UNION SELECT COUNT(*), "mk" AS Wiki FROM mkwiki_p.categorylinks WHERE cl_to="Починати во 2015 година" UNION SELECT COUNT(*), "mr" AS Wiki FROM mrwiki_p.categorylinks WHERE cl_to="इ.स. २०१५ मधील मृत्यू" UNION SELECT COUNT(*), "ms" AS Wiki FROM mswiki_p.categorylinks WHERE cl_to="Kematian 2015" UNION SELECT COUNT(*), "nl" AS Wiki FROM nlwiki_p.categorylinks WHERE cl_to="Lijsten van personen overleden in 2015" UNION SELECT COUNT(*), "nn" AS Wiki FROM nnwiki_p.categorylinks WHERE cl_to="Døde i 2015" UNION SELECT COUNT(*), "no" AS Wiki FROM nowiki_p.categorylinks WHERE cl_to="Dødsfall i 2015" UNION SELECT COUNT(*), "or" AS Wiki FROM orwiki_p.categorylinks WHERE cl_to="୨୦୧୫ ମୃତ୍ୟୁ" UNION SELECT COUNT(*), "pl" AS Wiki FROM plwiki_p.categorylinks WHERE cl_to="Zmarli w 2015" UNION SELECT COUNT(*), "pt" AS Wiki FROM ptwiki_p.categorylinks WHERE cl_to="Mortos em 2015" UNION SELECT COUNT(*), "qu" AS Wiki FROM quwiki_p.categorylinks WHERE cl_to="Wañusqa 2015" UNION SELECT COUNT(*), "ro" AS Wiki FROM rowiki_p.categorylinks WHERE cl_to="Decese în 2015" UNION SELECT COUNT(*), "ru" AS Wiki FROM ruwiki_p.categorylinks WHERE cl_to="Умершие в 2015 году" UNION SELECT COUNT(*), "sco" AS Wiki FROM scowiki_p.categorylinks WHERE cl_to="2015 daiths" UNION SELECT COUNT(*), "sh" AS Wiki FROM shwiki_p.categorylinks WHERE cl_to="Umrli 2015." UNION SELECT COUNT(*), "simple" AS Wiki FROM simplewiki_p.categorylinks WHERE cl_to="2015 deaths" UNION SELECT COUNT(*), "sk" AS Wiki FROM skwiki_p.categorylinks WHERE cl_to="Úmrtia v 2015" UNION SELECT COUNT(*), "sl" AS Wiki FROM slwiki_p.categorylinks WHERE cl_to="Umrli leta 2015" UNION SELECT COUNT(*), "sr" AS Wiki FROM srwiki_p.categorylinks WHERE cl_to="Умрли 2015." UNION SELECT COUNT(*), "sv" AS Wiki FROM svwiki_p.categorylinks WHERE cl_to="Avlidna 2015" UNION SELECT COUNT(*), "sw" AS Wiki FROM swwiki_p.categorylinks WHERE cl_to="Waliofariki 2015" UNION SELECT COUNT(*), "szl" AS Wiki FROM szlwiki_p.categorylinks WHERE cl_to="Umarći we 2015" UNION SELECT COUNT(*), "ta" AS Wiki FROM tawiki_p.categorylinks WHERE cl_to="2015 இறப்புகள்" UNION SELECT COUNT(*), "th" AS Wiki FROM thwiki_p.categorylinks WHERE cl_to="บุคคลที่เสียชีวิตในปี พ.ศ. 2558" UNION SELECT COUNT(*), "tl" AS Wiki FROM tlwiki_p.categorylinks WHERE cl_to="Namatay noong 2015" UNION SELECT COUNT(*), "tr" AS Wiki FROM trwiki_p.categorylinks WHERE cl_to="2015 yılında ölenler" UNION SELECT COUNT(*), "tt" AS Wiki FROM ttwiki_p.categorylinks WHERE cl_to="2015 елда вафатлар" UNION SELECT COUNT(*), "uk" AS Wiki FROM ukwiki_p.categorylinks WHERE cl_to="Померли 2015" UNION SELECT COUNT(*), "ur" AS Wiki FROM urwiki_p.categorylinks WHERE cl_to="2015ء کی وفیات" UNION SELECT COUNT(*), "uz" AS Wiki FROM uzwiki_p.categorylinks WHERE cl_to="2015-yilda vafot etganlar" UNION SELECT COUNT(*), "vi" AS Wiki FROM viwiki_p.categorylinks WHERE cl_to="Mất 2015" UNION SELECT COUNT(*), "war" AS Wiki FROM warwiki_p.categorylinks WHERE cl_to="Mga namatay han 2015" UNION SELECT COUNT(*), "xmf" AS Wiki FROM xmfwiki_p.categorylinks WHERE cl_to="ნაღურა 2015" UNION SELECT COUNT(*), "zh" AS Wiki FROM zhwiki_p.categorylinks WHERE cl_to="2015年逝世" UNION SELECT COUNT(*), "zh-yue" AS Wiki FROM zh-yuewiki_p.categorylinks WHERE cl_to="2015年死"
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...