Untitled query #1276

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

SELECT wp.pp_value, GROUP_CONCAT(wp.wiki) As wikis FROM 
(
(SELECT pp_value, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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, "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) 
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...
