Ukwiki templates with links to disambiguations

SQL

	SELECT "{| class=\"wikitable sortable\"" as template_name "" as number_of_links,, "\n" as links
UNION ALL
	SELECT "|-\n! Template !! Page title !! Disambigs linked"
UNION ALL
	SELECT	CONCAT("\n|-\n| {{tl|", page_title, "}} || ") as template_name,
    COUNT(pl_title) as number_of_links,
    CONCAT(" || [[", GROUP_CONCAT(pl_title ORDER BY pl_title ASC SEPARATOR "]], [["), "]]") as links
    FROM ukwiki_p.pagelinks
    JOIN ukwiki_p.page ON page_namespace = 10 AND ukwiki_p.page.page_id = ukwiki_p.pagelinks.pl_from
    WHERE pl_from_namespace = 10
    AND pl_namespace = 0
    AND pl_title IN (
        SELECT page_title
        FROM ukwiki_p.page_props
        JOIN ukwiki_p.page ON ukwiki_p.page.page_id = ukwiki_p.page_props.pp_page
        WHERE ukwiki_p.page_props.pp_propname = "disambiguation"
        AND page_namespace = 0
    )
    GROUP BY page_title
    ORDER BY number_of_links DESC, page_title ASC
UNION ALL
	SELECT "\n|}" as template_name, "" as number_of_links, "" as links
SQL

Checking query status...
