SELECT DISTINCT from_page.page_title, pl_title

FROM pagelinks

    LEFT 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