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 SUM(ct) As overall, GROUP_CONCAT(lang, ":", ct ORDER BY ct DESC) As bylang FROM ( (SELECT COUNT(*) AS ct, "en" AS lang FROM enwiki_p.categorylinks, enwiki_p.page WHERE cl_to="2015_deaths" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM enwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "de" AS lang FROM dewiki_p.categorylinks, dewiki_p.page WHERE cl_to="Gestorben_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM dewiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ru" AS lang FROM ruwiki_p.categorylinks, ruwiki_p.page WHERE cl_to="Умершие_в_2015_году" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM ruwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "simple" AS lang FROM simplewiki_p.categorylinks, simplewiki_p.page WHERE cl_to="2015_deaths" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM simplewiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "pl" AS lang FROM plwiki_p.categorylinks, plwiki_p.page WHERE cl_to="Zmarli_w_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM plwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "es" AS lang FROM eswiki_p.categorylinks, eswiki_p.page WHERE cl_to="Fallecidos_en_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM eswiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "it" AS lang FROM itwiki_p.categorylinks, itwiki_p.page WHERE cl_to="Morti_nel_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM itwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ja" AS lang FROM jawiki_p.categorylinks, jawiki_p.page WHERE cl_to="2015年没" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM jawiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "fi" AS lang FROM fiwiki_p.categorylinks, fiwiki_p.page WHERE cl_to="Vuonna_2015_kuolleet" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM fiwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "tr" AS lang FROM trwiki_p.categorylinks, trwiki_p.page WHERE cl_to="2015_yılında_ölenler" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM trwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "sv" AS lang FROM svwiki_p.categorylinks, svwiki_p.page WHERE cl_to="Avlidna_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM svwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "pt" AS lang FROM ptwiki_p.categorylinks, ptwiki_p.page WHERE cl_to="Mortos_em_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM ptwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "zh" AS lang FROM zhwiki_p.categorylinks, zhwiki_p.page WHERE cl_to="2015年逝世" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM zhwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "uk" AS lang FROM ukwiki_p.categorylinks, ukwiki_p.page WHERE cl_to="Померли_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM ukwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "cs" AS lang FROM cswiki_p.categorylinks, cswiki_p.page WHERE cl_to="Úmrtí_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM cswiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "hu" AS lang FROM huwiki_p.categorylinks, huwiki_p.page WHERE cl_to="2015-ben_elhunyt_személyek" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM huwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "fa" AS lang FROM fawiki_p.categorylinks, fawiki_p.page WHERE cl_to="درگذشتگان_۲۰۱۵_(میلادی)" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM fawiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ar" AS lang FROM arwiki_p.categorylinks, arwiki_p.page WHERE cl_to="وفيات_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM arwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "no" AS lang FROM nowiki_p.categorylinks, nowiki_p.page WHERE cl_to="Dødsfall_i_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM nowiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "la" AS lang FROM lawiki_p.categorylinks, lawiki_p.page WHERE cl_to="Mortui_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM lawiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "et" AS lang FROM etwiki_p.categorylinks, etwiki_p.page WHERE cl_to="Surnud_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM etwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "da" AS lang FROM dawiki_p.categorylinks, dawiki_p.page WHERE cl_to="Døde_i_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM dawiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ko" AS lang FROM kowiki_p.categorylinks, kowiki_p.page WHERE cl_to="2015년_죽음" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM kowiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "id" AS lang FROM idwiki_p.categorylinks, idwiki_p.page WHERE cl_to="Kematian_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM idwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "eo" AS lang FROM eowiki_p.categorylinks, eowiki_p.page WHERE cl_to="Mortintoj_en_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM eowiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "bg" AS lang FROM bgwiki_p.categorylinks, bgwiki_p.page WHERE cl_to="Починали_през_2015_година" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM bgwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "zh-yue" AS lang FROM zh_yuewiki_p.categorylinks, zh_yuewiki_p.page WHERE cl_to="2015年死" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM zh_yuewiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ro" AS lang FROM rowiki_p.categorylinks, rowiki_p.page WHERE cl_to="Decese_în_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM rowiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "eu" AS lang FROM euwiki_p.categorylinks, euwiki_p.page WHERE cl_to="2015eko_heriotzak" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM euwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "sk" AS lang FROM skwiki_p.categorylinks, skwiki_p.page WHERE cl_to="Úmrtia_v_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM skwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "sl" AS lang FROM slwiki_p.categorylinks, slwiki_p.page WHERE cl_to="Umrli_leta_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM slwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "sco" AS lang FROM scowiki_p.categorylinks, scowiki_p.page WHERE cl_to="2015_daiths" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM scowiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "el" AS lang FROM elwiki_p.categorylinks, elwiki_p.page WHERE cl_to="Θάνατοι_το_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM elwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "az" AS lang FROM azwiki_p.categorylinks, azwiki_p.page WHERE cl_to="2015-ci_ildə_vəfat_edənlər" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM azwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "lb" AS lang FROM lbwiki_p.categorylinks, lbwiki_p.page WHERE cl_to="Gestuerwen_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM lbwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "gl" AS lang FROM glwiki_p.categorylinks, glwiki_p.page WHERE cl_to="Finados_en_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM glwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "cy" AS lang FROM cywiki_p.categorylinks, cywiki_p.page WHERE cl_to="Marwolaethau_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM cywiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ta" AS lang FROM tawiki_p.categorylinks, tawiki_p.page WHERE cl_to="2015_இறப்புகள்" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM tawiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "th" AS lang FROM thwiki_p.categorylinks, thwiki_p.page WHERE cl_to="บุคคลที่เสียชีวิตในปี_พ.ศ._2558" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM thwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "sr" AS lang FROM srwiki_p.categorylinks, srwiki_p.page WHERE cl_to="Умрли_2015." AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM srwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "vi" AS lang FROM viwiki_p.categorylinks, viwiki_p.page WHERE cl_to="Mất_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM viwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "nn" AS lang FROM nnwiki_p.categorylinks, nnwiki_p.page WHERE cl_to="Døde_i_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM nnwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "hy" AS lang FROM hywiki_p.categorylinks, hywiki_p.page WHERE cl_to="2015_մահեր" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM hywiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "be" AS lang FROM bewiki_p.categorylinks, bewiki_p.page WHERE cl_to="Памерлі_ў_2015_годзе" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM bewiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "sh" AS lang FROM shwiki_p.categorylinks, shwiki_p.page WHERE cl_to="Umrli_2015." AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM shwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "br" AS lang FROM brwiki_p.categorylinks, brwiki_p.page WHERE cl_to="Marvioù_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM brwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "bn" AS lang FROM bnwiki_p.categorylinks, bnwiki_p.page WHERE cl_to="২০১৫-এ_মৃত্যু" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM bnwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "mr" AS lang FROM mrwiki_p.categorylinks, mrwiki_p.page WHERE cl_to="इ.स._२०१५_मधील_मृत्यू" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM mrwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ka" AS lang FROM kawiki_p.categorylinks, kawiki_p.page WHERE cl_to="გარდაცვლილი_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM kawiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "mk" AS lang FROM mkwiki_p.categorylinks, mkwiki_p.page WHERE cl_to="Починати_во_2015_година" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM mkwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "hi" AS lang FROM hiwiki_p.categorylinks, hiwiki_p.page WHERE cl_to="२०१५_में_निधन" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM hiwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "lv" AS lang FROM lvwiki_p.categorylinks, lvwiki_p.page WHERE cl_to="2015._gadā_mirušie" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM lvwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "kk" AS lang FROM kkwiki_p.categorylinks, kkwiki_p.page WHERE cl_to="2015_жылы_қайтыс_болғандар" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM kkwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "be-x-old" AS lang FROM be_x_oldwiki_p.categorylinks, be_x_oldwiki_p.page WHERE cl_to="Памерлі_ў_2015_годзе" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM be_x_oldwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ga" AS lang FROM gawiki_p.categorylinks, gawiki_p.page WHERE cl_to="Básanna_i_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM gawiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "bs" AS lang FROM bswiki_p.categorylinks, bswiki_p.page WHERE cl_to="Umrli_2015." AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM bswiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "fo" AS lang FROM fowiki_p.categorylinks, fowiki_p.page WHERE cl_to="Andlát_í_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM fowiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ms" AS lang FROM mswiki_p.categorylinks, mswiki_p.page WHERE cl_to="Kematian_2015" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM mswiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "or" AS lang FROM orwiki_p.categorylinks, orwiki_p.page WHERE cl_to="୨୦୧୫_ମୃତ୍ୟୁ" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM orwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "tt" AS lang FROM ttwiki_p.categorylinks, ttwiki_p.page WHERE cl_to="2015_елда_вафатлар" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM ttwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "ur" AS lang FROM urwiki_p.categorylinks, urwiki_p.page WHERE cl_to="2015ء_کی_وفیات" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM urwiki_p.page_props WHERE pp_propname="wikibase_item")) UNION (SELECT COUNT(*) AS ct, "fr" AS lang FROM frwiki_p.categorylinks, frwiki_p.page WHERE cl_to="Morte_récente" AND cl_type="page" AND page_id = cl_from AND page_is_redirect = 0 AND page_namespace = 0 AND cl_from NOT IN (SELECT pp_page FROM frwiki_p.page_props WHERE pp_propname="wikibase_item")) ) AS wp
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...