Untitled query #60443

SQL

# SELECT * FROM  pagelinks LIMIT 10

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

Checking query status...
