Untitled query #1276

This query is marked as a draft This query has been published by Jura1.
SQL

#LAST ITEMs added
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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" AND pp_propname="wikibase_item" AND cl_type="page" )
UNION (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 cl_sortkey_prefix NOT LIKE " %" AND cl_sortkey_prefix NOT LIKE "*%" 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 ("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.
SQL

Checking query status...
