Self-redirects on enwiki

SQL

SELECT DISTINCT from_page.page_title, pl_title
FROM pagelinks
	INNER JOIN linktarget ON lt_title = pl_title AND lt_namespace = pl_namespace
	LEFT JOIN templatelinks ON tl_from = pl_from AND tl_target_id = lt_id
	INNER JOIN page to_page ON to_page.page_title = pl_title
	INNER JOIN redirect on rd_from = to_page.page_id
	INNER JOIN page from_page ON from_page.page_id = pl_from
WHERE pl_from_namespace = 0
	AND pl_namespace = 0
	AND from_page.page_title = rd_title
	AND lt_title IS NULL -- Exclude transclusions
SQL

Checking query status...
