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
SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis, MIN(wp.cl_timestamp) FROM ( (SELECT pp_value, cl_timestamp, "en" As Wiki FROM enwiki_p.categorylinks JOIN enwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_deaths" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "de" As Wiki FROM dewiki_p.categorylinks JOIN dewiki_p.page_props ON pp_page=cl_from WHERE cl_to="Gestorben_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ru" As Wiki FROM ruwiki_p.categorylinks JOIN ruwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Умершие_в_2015_году" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "simple" As Wiki FROM simplewiki_p.categorylinks JOIN simplewiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_deaths" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "pl" As Wiki FROM plwiki_p.categorylinks JOIN plwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Zmarli_w_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "es" As Wiki FROM eswiki_p.categorylinks JOIN eswiki_p.page_props ON pp_page=cl_from WHERE cl_to="Fallecidos_en_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "it" As Wiki FROM itwiki_p.categorylinks JOIN itwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Morti_nel_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ja" As Wiki FROM jawiki_p.categorylinks JOIN jawiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015年没" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "fi" As Wiki FROM fiwiki_p.categorylinks JOIN fiwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Vuonna_2015_kuolleet" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "tr" As Wiki FROM trwiki_p.categorylinks JOIN trwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_yılında_ölenler" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "sv" As Wiki FROM svwiki_p.categorylinks JOIN svwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Avlidna_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "pt" As Wiki FROM ptwiki_p.categorylinks JOIN ptwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Mortos_em_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "zh" As Wiki FROM zhwiki_p.categorylinks JOIN zhwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015年逝世" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "uk" As Wiki FROM ukwiki_p.categorylinks JOIN ukwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Померли_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "cs" As Wiki FROM cswiki_p.categorylinks JOIN cswiki_p.page_props ON pp_page=cl_from WHERE cl_to="Úmrtí_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "hu" As Wiki FROM huwiki_p.categorylinks JOIN huwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015-ben_elhunyt_személyek" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "fa" As Wiki FROM fawiki_p.categorylinks JOIN fawiki_p.page_props ON pp_page=cl_from WHERE cl_to="درگذشتگان_۲۰۱۵_(میلادی)" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ar" As Wiki FROM arwiki_p.categorylinks JOIN arwiki_p.page_props ON pp_page=cl_from WHERE cl_to="وفيات_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "no" As Wiki FROM nowiki_p.categorylinks JOIN nowiki_p.page_props ON pp_page=cl_from WHERE cl_to="Dødsfall_i_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "la" As Wiki FROM lawiki_p.categorylinks JOIN lawiki_p.page_props ON pp_page=cl_from WHERE cl_to="Mortui_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "et" As Wiki FROM etwiki_p.categorylinks JOIN etwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Surnud_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "da" As Wiki FROM dawiki_p.categorylinks JOIN dawiki_p.page_props ON pp_page=cl_from WHERE cl_to="Døde_i_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ko" As Wiki FROM kowiki_p.categorylinks JOIN kowiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015년_죽음" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "id" As Wiki FROM idwiki_p.categorylinks JOIN idwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Kematian_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "eo" As Wiki FROM eowiki_p.categorylinks JOIN eowiki_p.page_props ON pp_page=cl_from WHERE cl_to="Mortintoj_en_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "bg" As Wiki FROM bgwiki_p.categorylinks JOIN bgwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Починали_през_2015_година" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "zh-yue" As Wiki FROM zh_yuewiki_p.categorylinks JOIN zh_yuewiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015年死" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ro" As Wiki FROM rowiki_p.categorylinks JOIN rowiki_p.page_props ON pp_page=cl_from WHERE cl_to="Decese_în_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "eu" As Wiki FROM euwiki_p.categorylinks JOIN euwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015eko_heriotzak" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "sk" As Wiki FROM skwiki_p.categorylinks JOIN skwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Úmrtia_v_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "sl" As Wiki FROM slwiki_p.categorylinks JOIN slwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Umrli_leta_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "sco" As Wiki FROM scowiki_p.categorylinks JOIN scowiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_daiths" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "el" As Wiki FROM elwiki_p.categorylinks JOIN elwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Θάνατοι_το_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "az" As Wiki FROM azwiki_p.categorylinks JOIN azwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015-ci_ildə_vəfat_edənlər" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "lb" As Wiki FROM lbwiki_p.categorylinks JOIN lbwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Gestuerwen_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "gl" As Wiki FROM glwiki_p.categorylinks JOIN glwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Finados_en_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "cy" As Wiki FROM cywiki_p.categorylinks JOIN cywiki_p.page_props ON pp_page=cl_from WHERE cl_to="Marwolaethau_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ta" As Wiki FROM tawiki_p.categorylinks JOIN tawiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_இறப்புகள்" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "th" As Wiki FROM thwiki_p.categorylinks JOIN thwiki_p.page_props ON pp_page=cl_from WHERE cl_to="บุคคลที่เสียชีวิตในปี_พ.ศ._2558" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "sr" As Wiki FROM srwiki_p.categorylinks JOIN srwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Умрли_2015." AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "vi" As Wiki FROM viwiki_p.categorylinks JOIN viwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Mất_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "nn" As Wiki FROM nnwiki_p.categorylinks JOIN nnwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Døde_i_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "hy" As Wiki FROM hywiki_p.categorylinks JOIN hywiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_մահեր" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "be" As Wiki FROM bewiki_p.categorylinks JOIN bewiki_p.page_props ON pp_page=cl_from WHERE cl_to="Памерлі_ў_2015_годзе" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "sh" As Wiki FROM shwiki_p.categorylinks JOIN shwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Umrli_2015." AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "br" As Wiki FROM brwiki_p.categorylinks JOIN brwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Marvioù_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "bn" As Wiki FROM bnwiki_p.categorylinks JOIN bnwiki_p.page_props ON pp_page=cl_from WHERE cl_to="২০১৫-এ_মৃত্যু" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "mr" As Wiki FROM mrwiki_p.categorylinks JOIN mrwiki_p.page_props ON pp_page=cl_from WHERE cl_to="इ.स._२०१५_मधील_मृत्यू" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ka" As Wiki FROM kawiki_p.categorylinks JOIN kawiki_p.page_props ON pp_page=cl_from WHERE cl_to="გარდაცვლილი_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "mk" As Wiki FROM mkwiki_p.categorylinks JOIN mkwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Починати_во_2015_година" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "hi" As Wiki FROM hiwiki_p.categorylinks JOIN hiwiki_p.page_props ON pp_page=cl_from WHERE cl_to="२०१५_में_निधन" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "lv" As Wiki FROM lvwiki_p.categorylinks JOIN lvwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015._gadā_mirušie" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "kk" As Wiki FROM kkwiki_p.categorylinks JOIN kkwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_жылы_қайтыс_болғандар" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "be-x-old" As Wiki FROM be_x_oldwiki_p.categorylinks JOIN be_x_oldwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Памерлі_ў_2015_годзе" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ga" As Wiki FROM gawiki_p.categorylinks JOIN gawiki_p.page_props ON pp_page=cl_from WHERE cl_to="Básanna_i_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "bs" As Wiki FROM bswiki_p.categorylinks JOIN bswiki_p.page_props ON pp_page=cl_from WHERE cl_to="Umrli_2015." AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "fo" As Wiki FROM fowiki_p.categorylinks JOIN fowiki_p.page_props ON pp_page=cl_from WHERE cl_to="Andlát_í_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ms" As Wiki FROM mswiki_p.categorylinks JOIN mswiki_p.page_props ON pp_page=cl_from WHERE cl_to="Kematian_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "or" As Wiki FROM orwiki_p.categorylinks JOIN orwiki_p.page_props ON pp_page=cl_from WHERE cl_to="୨୦୧୫_ମୃତ୍ୟୁ" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "tt" As Wiki FROM ttwiki_p.categorylinks JOIN ttwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_елда_вафатлар" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ur" As Wiki FROM urwiki_p.categorylinks JOIN urwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015ء_کی_وفیات" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "qu" As Wiki FROM quwiki_p.categorylinks JOIN quwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Wañusqa_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "arz" As Wiki FROM arzwiki_p.categorylinks JOIN arzwiki_p.page_props ON pp_page=cl_from WHERE cl_to="وفيات_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "fr" As Wiki FROM frwiki_p.categorylinks JOIN frwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Décès_en_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "nl" As Wiki FROM nlwiki_p.categorylinks JOIN nlwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Lijsten_van_personen_overleden_in_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "an" As Wiki FROM anwiki_p.categorylinks JOIN anwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_(muertes)" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ba" As Wiki FROM bawiki_p.categorylinks JOIN bawiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_йылда_вафаттар" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "jv" As Wiki FROM jvwiki_p.categorylinks JOIN jvwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Pati_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "sw" As Wiki FROM swwiki_p.categorylinks JOIN swwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Waliofariki_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "tl" As Wiki FROM tlwiki_p.categorylinks JOIN tlwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Namatay_noong_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "uz" As Wiki FROM uzwiki_p.categorylinks JOIN uzwiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015-yilda_vafot_etganlar" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ckb" As Wiki FROM ckbwiki_p.categorylinks JOIN ckbwiki_p.page_props ON pp_page=cl_from WHERE cl_to="مردووانی_٢٠١٥" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "dsb" As Wiki FROM dsbwiki_p.categorylinks JOIN dsbwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Wum._2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "hsb" As Wiki FROM hsbwiki_p.categorylinks JOIN hsbwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Zemr._2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "ilo" As Wiki FROM ilowiki_p.categorylinks JOIN ilowiki_p.page_props ON pp_page=cl_from WHERE cl_to="2015_nga_ipupusay" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "szl" As Wiki FROM szlwiki_p.categorylinks JOIN szlwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Umarći_we_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "war" As Wiki FROM warwiki_p.categorylinks JOIN warwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Mga_namatay_han_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "xmf" As Wiki FROM xmfwiki_p.categorylinks JOIN xmfwiki_p.page_props ON pp_page=cl_from WHERE cl_to="ნაღურა_2015" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "en" As Wiki FROM enwiki_p.categorylinks JOIN enwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Recent_deaths" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "fr" As Wiki FROM frwiki_p.categorylinks JOIN frwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Mort_récente" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCth" As Wiki FROM thwiki_p.categorylinks JOIN thwiki_p.page_props ON pp_page=cl_from WHERE cl_to="เพิ่งตาย" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCfa" As Wiki FROM fawiki_p.categorylinks JOIN fawiki_p.page_props ON pp_page=cl_from WHERE cl_to="بهتازگی_درگذشتگان" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCtl" As Wiki FROM tlwiki_p.categorylinks JOIN tlwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Namatay_kamakailan" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCuk" As Wiki FROM ukwiki_p.categorylinks JOIN ukwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Нещодавно_померлі" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCja" As Wiki FROM jawiki_p.categorylinks JOIN jawiki_p.page_props ON pp_page=cl_from WHERE cl_to="亡くなったばかりの人物" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCpt" As Wiki FROM ptwiki_p.categorylinks JOIN ptwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Mortes_recentes" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCes" As Wiki FROM eswiki_p.categorylinks JOIN eswiki_p.page_props ON pp_page=cl_from WHERE cl_to="Fallecidos_recientemente" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCsk" As Wiki FROM skwiki_p.categorylinks JOIN skwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Nedávne_úmrtia" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCru" As Wiki FROM ruwiki_p.categorylinks JOIN ruwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Недавно_умершие" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCro" As Wiki FROM rowiki_p.categorylinks JOIN rowiki_p.page_props ON pp_page=cl_from WHERE cl_to="Decese_recente" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCko" As Wiki FROM kowiki_p.categorylinks JOIN kowiki_p.page_props ON pp_page=cl_from WHERE cl_to="최근에_죽은_사람" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCzh" As Wiki FROM zhwiki_p.categorylinks JOIN zhwiki_p.page_props ON pp_page=cl_from WHERE cl_to="最近逝世" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCda" As Wiki FROM dawiki_p.categorylinks JOIN dawiki_p.page_props ON pp_page=cl_from WHERE cl_to="Nyligt_afdøde" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCsimple" As Wiki FROM simplewiki_p.categorylinks JOIN simplewiki_p.page_props ON pp_page=cl_from WHERE cl_to="Recent_deaths" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCsv" As Wiki FROM svwiki_p.categorylinks JOIN svwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Nyligen_avlidna_personer" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCzh-yue" As Wiki FROM zh_yuewiki_p.categorylinks JOIN zh_yuewiki_p.page_props ON pp_page=cl_from WHERE cl_to="最近死" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCmk" As Wiki FROM mkwiki_p.categorylinks JOIN mkwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Скоро_починати" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCas" As Wiki FROM aswiki_p.categorylinks JOIN aswiki_p.page_props ON pp_page=cl_from WHERE cl_to="শেহতীয়াভাৱে_মৃত্যু_হোৱা_ব্যক্তি" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCno" As Wiki FROM nowiki_p.categorylinks JOIN nowiki_p.page_props ON pp_page=cl_from WHERE cl_to="Nylig_avdøde" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCtr" As Wiki FROM trwiki_p.categorylinks JOIN trwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Yeni_ölümler" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCsco" As Wiki FROM scowiki_p.categorylinks JOIN scowiki_p.page_props ON pp_page=cl_from WHERE cl_to="Recent_daiths" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCar" As Wiki FROM arwiki_p.categorylinks JOIN arwiki_p.page_props ON pp_page=cl_from WHERE cl_to="وفيات_حديثة" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RChu" As Wiki FROM huwiki_p.categorylinks JOIN huwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Friss_halálesetek" AND pp_propname="wikibase_item" AND cl_type="page" ) UNION ALL (SELECT pp_value, cl_timestamp, "RCvi" As Wiki FROM viwiki_p.categorylinks JOIN viwiki_p.page_props ON pp_page=cl_from WHERE cl_to="Người_mới_qua_đời" AND pp_propname="wikibase_item" AND cl_type="page" ) ) As wp WHERE wp.pp_value NOT IN (SELECT page_title FROM wikidatawiki_p.page JOIN wikidatawiki_p.pagelinks ON page_id=pl_from WHERE pl_title = "P570" AND pl_namespace = 120) AND wp.pp_value NOT IN ("Q20066375", "Q20080934", "Q19670376", "Q18745613", "Q179466", "Q10339833", "Q11376505", "Q17223043", "Q18925942", "Q19283494" , "Q19361349", "Q19630599", "Q19665203", "Q19766054", "Q19828982", "Q19961074", "Q2265392", "Q2309504", "Q2831691", "Q5615832") GROUP BY wp.pp_value
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...