Tewiki: Templates linking to disambig pages

SQL

USE tewiki_p;
SELECT CONCAT("మూస:",SUBSTRING_INDEX(templates.page_title, '/', 1)), GROUP_CONCAT(DISTINCT pl_title SEPARATOR ", ") AS disambigs,
	COUNT(DISTINCT tl_from) AS uses
	FROM page_props
	JOIN page AS pages
    	ON pages.page_id = pp_page
	JOIN pagelinks
		ON pl_title = pages.page_title AND pl_namespace = pages.page_namespace
	JOIN page AS templates
		ON templates.page_id = pl_from
	LEFT JOIN templatelinks
		ON tl_title = templates.page_title AND tl_namespace = templates.page_namespace
WHERE pp_propname = 'disambiguation' AND tl_from_namespace = 0
GROUP BY pl_from, SUBSTRING_INDEX(templates.page_title, '/', 1)
ORDER BY COUNT(DISTINCT pl_title) DESC, uses DESC, templates.page_title;
SQL

Checking query status...
