Untitled query #1276

SQL

# test
# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg
SELECT DISTINCT wp.pp_value FROM 
((
SELECT pp_value, cl_timestamp, cl_sortkey_prefix
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, cl_sortkey_prefix
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" )
) 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)
SQL

Checking query status...
