T268498 localwiki+wikidata example

SQL

SELECT
	fiwiki_p.page_title AS fiwiki_page, 
    wd_p.page_title AS item, 
    wd_pl.pl_title AS propname, 
    fiwiki_tl.tl_title AS fiwiki_commonscat 
FROM 
	fiwiki_p.page AS fiwiki_p 
    LEFT JOIN fiwiki_p.templatelinks AS fiwiki_tl 
    	ON fiwiki_tl.tl_from=fiwiki_p.page_id 
        	AND tl_title="Commonscat" 
            AND tl_namespace=10, 
    fiwiki_p.page_props AS fiwiki_pp, 
    wikidatawiki_p.page AS wd_p, 
    wikidatawiki_p.pagelinks AS wd_pl  
WHERE 
	fiwiki_p.page_id=fiwiki_pp.pp_page 
    AND fiwiki_pp.pp_propname="wikibase_item" 
    AND fiwiki_p.page_namespace=0 
    AND fiwiki_tl.tl_from IS null 
    AND fiwiki_pp.pp_value=wd_p.page_title 
    AND wd_p.page_namespace=0 
    AND wd_p.page_id=wd_pl.pl_from 
    AND wd_pl.pl_title="P373" 
    AND wd_pl.pl_namespace=120 
LIMIT 10000
SQL

Checking query status...
