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(*), "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年逝世"
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...