SELECT concat( "[https://en.wikipedia.org/w/index.php?title={{urlencode:",

              p.page_title, "}}&redirect=no ", p.page_title, "] redirects to [[Template:", r.rd_title, "]]" )

AS "Mainspace-to-template redirects"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE p.page_namespace = 0

AND   r.rd_namespace = 10

ORDER by page_title;

​

SELECT CONCAT("{{wlh|", CONVERT(p.page_title USING utf8), "|", REPLACE(CONVERT(p.page_title USING utf8), "_", " "), "}}")

AS "Mainspace-to-template redirects",

COUNT(*) AS "Incoming<br>links"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE p.page_namespace = 0

AND   r.rd_namespace = 10

ORDER by page_title;

​

/*

SELECT CONCAT("{{wlh|", CONVERT(p1.page_title USING utf8), "|", REPLACE(CONVERT(p1.page_title USING utf8), "_", " "), "}}") AS "Article",

          COUNT(*) AS "Incoming<br>links"

        FROM page AS p1

        JOIN redirect AS r1 ON p1.page_id=r1.rd_from

        JOIN categorylinks

        ON p1.page_id = cl_from

        JOIN linktarget

        ON p1.page_title = lt_title AND lt_namespace = 0

        JOIN pagelinks

        ON lt_id = pl_target_id

        JOIN page AS p2

        ON pl_from = p2.page_id AND p2.page_namespace = 0

        LEFT JOIN redirect AS r2 ON p2.page_id=r2.rd_from

        WHERE p1.page_namespace = 0

        AND p1.page_is_redirect = 1

        AND cl_to = 'Redirects_from_misspellings'

        AND NOT ( r1.rd_namespace <=> r2.rd_namespace AND r1.rd_title <=> r2.rd_title )

        GROUP BY 1

        LIMIT 1000;

        */