SELECT page_title AS 'redirect from', rd_title AS 'redirect to'

FROM redirect

JOIN page ON page_id = rd_from

LEFT JOIN categorylinks ON cl_from = page_id AND cl_to = 'Redirects_from_short_names'

WHERE page_namespace = 0

  AND rd_namespace = 0

  AND LOWER(CONVERT(rd_title USING utf8)) != LOWER(CONVERT(page_title USING utf8))

  AND INSTR(LOWER(CONVERT(rd_title USING utf8)), LOWER(CONVERT(page_title USING utf8))) != 0

  AND cl_from IS NULL

  AND page_title LIKE 'Red%';