Untitled query #42271

SQL

select 
	sum(1) as c 
from 
	fiwiki_p.iwlinks, 
    fiwiki_p.page_props as fpp1, 
    fiwiki_p.page as fp1, 
    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 
limit 40;
SQL

Checking query status...
