Untitled query #60443

SQL

SELECT REPLACE(templatelinks.tl_title,'_',' ') as template, page_props.pp_value, Count(*) AS ct
FROM  pagelinks
INNER JOIN page 	ON pagelinks.pl_title = page.page_title 
			and pagelinks.pl_namespace = page.page_namespace
INNER JOIN templatelinks ON templatelinks.tl_from = page.page_id
                        and templatelinks.tl_from_namespace = page.page_namespace
LEFT JOIN page_props ON templatelinks.tl_from = page_props.pp_page
WHERE  
pagelinks.pl_from = 14498881
and templatelinks.tl_namespace = 10
and page_props.pp_propname = "wikibase_item" 
GROUP BY templatelinks.tl_title, page_props.pp_value
HAVING Count(*) > 2
ORDER BY ct DESC;
SQL

Checking query status...
