Untitled query #1332

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

use wikidatawiki_p; 
SELECT SQL_NO_CACHE wp.pp_value, GROUP_CONCAT(wp.wiki) AS wikis, MIN(wp.cl_timestamp) AS ts FROM ((SELECT pp_value, cl_timestamp, "commons" AS Wiki FROM commonswiki_p.categorylinks JOIN commonswiki_p.page_props ON pp_page=cl_from WHERE cl_to="1980_deaths" AND pp_propname="wikibase_item" AND cl_type="subcat" ) 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="?????????????????????_?.?._2523" 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="1980_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="Décès_en_1980" 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_janvier_1980" 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_février_1980" 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_mars_1980" 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_avril_1980" 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_mai_1980" 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_juin_1980" 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_juillet_1980" 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_août_1980" 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_septembre_1980" 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_octobre_1980" 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_novembre_1980" 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_décembre_1980" 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_1980" 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="???????_?_1980_????" 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="1980_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_1980" 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_1980" 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_1980" 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="1980??" 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_1980_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="1980_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_1980" 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_1980" 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="1980???" 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="???????_1980" 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í_1980" 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="1980-ban_elhunyt_személyek" 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="1980-ben_elhunyt_személyek" 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="?????_1980" 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_1980" 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_1980" 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_1980" 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_1980" 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="1980?_??" 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_1980" 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_1980" 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="????????_????_1980_??????" 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_1980" 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="1980eko_heriotzak" 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="1980ko_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_1980" 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_1980" 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="1980_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="???????_??_1980" 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="1980-ci_ild?_v?fat_ed?nl?r" 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="1980-c?_ild?_v?fat_ed?nl?r" 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="1980-cü_ild?_v?fat_ed?nl?r" 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="1980-cu_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_1980" 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_1980" 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_1980" 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="1980_?????????" 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="?????_1980" 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_1980" 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_1980" 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="1980_?????" 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_1980." 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="????????_??_1980_??????" 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="1980_????_??????_?????????" AND pp_propname="wikibase_item" AND cl_type="page" )
 UNION ALL (SELECT pp_value, cl_timestamp, "ca" AS Wiki FROM cawiki_p.categorylinks JOIN cawiki_p.page_props ON pp_page=cl_from WHERE cl_to="Morts_el_1980" 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_1980" 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="?_??_?????1980" 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="???????_?_1980_?????" AND pp_propname="wikibase_item" AND cl_type="page" )
 UNION ALL (SELECT pp_value, cl_timestamp, "zh_min_nan" AS Wiki FROM zh_min_nanwiki_p.categorylinks JOIN zh_min_nanwiki_p.page_props ON pp_page=cl_from WHERE cl_to="1980_nî_kòe-sin" 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="???????????_1980" 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 ORDER BY MIN(wp.cl_timestamp)
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...
