Untitled query #42271

SQL

select 
	fp1.page_title 
from 
	fiwiki_p.iwlinks, 
    fiwiki_p.page_props as fpp1, 
    fiwiki_p.page as fp1 LEFT JOIN fiwiki_p.templatelinks as ftl1 
    	ON fp1.page_id=ftl1.tl_from 
        AND ftl1.tl_title="Auktoriteettitunnisteet" 
        and tl_namespace=10 
        and tl_from_namespace=0, wikidatawiki_p.page as wp1, 
    wikidatawiki_p.pagelinks as wpl1, 
    wikidatawiki_p.page as wp2 
where 
	iwl_from=1256287 
    and iwl_title like "Property:%" 
    and wp1.page_title=replace(iwl_title, "Property:", "") 
    and wp1.page_namespace=120 
    and wpl1.pl_title=wp1.page_title 
    and wpl1.pl_from=wp2.page_id 
    and wp2.page_namespace=0 
    and wp2.page_title=fpp1.pp_value 
    and fpp1.pp_propname="wikibase_item" 
    and fpp1.pp_page=fp1.page_id 
    and fp1.page_namespacE=0 
    and ftl1.tl_from IS NULL 
limit 200;
SQL

Checking query status...
