WhatLinksHere all in one

SQL

/*
SELECT page_title FROM (
	SELECT tl_from AS A, tl_title AS B, target.page_id AS C FROM templatelinks
	JOIN page AS target ON target.page_title = tl_title AND target.page_namespace = tl_namespace
	JOIN redirect ON rd_from = target.page_id AND rd_namespace = 10 AND rd_title = "Infobox_settlement"
	UNION
	SELECT tl_from AS A, NULL AS B, tl_from AS C FROM templatelinks
	WHERE tl_namespace = 10 AND tl_title = "Infobox_settlement"
) `temp-backlinks-whatever`
JOIN page ON page_id = A
ORDER BY C, B
LIMIT 501
*/


SELECT tl_from, rd_from FROM templatelinks
LEFT JOIN (
	SELECT tl_from AS indirect_from, rd_from FROM templatelinks
	JOIN page ON page_title = tl_title AND page_namespace = tl_namespace
	JOIN redirect ON rd_from = page_id AND rd_namespace = 10 AND rd_title = "Template_link"
) AS `temp` ON indirect_from = tl_from # AND rd_from >= 0
JOIN page ON page_id = tl_from
WHERE tl_from >= 66732612 AND tl_namespace = 10 AND tl_title = "Template_link"
ORDER BY tl_from
LIMIT 10;
SQL

Checking query status...
