Templates linking to disambiguations in elwiki

Fork of Templates linking to disambiguations in cswiki by Matěj Suchánek

This query is marked as a draft This query has been published by Geraki.

SQL

USE elwiki_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 = 'αποσαφήνιση' 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...