Untitled query #1276

SQL

# test
# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg

use enwiki_p; 
select page_title AS article, pp_value AS Qid, el_to AS Url
from externallinks, page, page_props
WHERE pp_value IN ("Q6279","Q6294","Q11676","Q19673","Q22212","Q22686","Q44690","Q63879","Q69319","Q120260","Q155985","Q158813","Q215057","Q221997","Q249898","Q256380","Q295492","Q324546","Q359442","Q463557","Q532279","Q553254","Q705472","Q816459","Q888007","Q953554","Q2036942","Q6112447","Q6173381","Q6770165","Q7341104")
AND el_from = page.page_id
AND page_namespace=0
AND page_id = pp_page
AND pp_propname="wikibase_item"
limit 4000;
SQL

Checking query status...
