upper redirect to lower in zhwikt template/module

SQL

USE zhwiktionary_p;
SELECT page.page_namespace, 
	CONCAT("[[", case
		when page.page_namespace = 10 then "Template:"
		when page.page_namespace = 11 then "Template talk:"
		when page.page_namespace = 828 then "Module:"
		when page.page_namespace = 829 then "Module talk:"
		end, page.page_title, "]]") AS 'title1',
	CONCAT("[[", case
		when page2.page_namespace = 10 then "Template:"
		when page2.page_namespace = 11 then "Template talk:"
		when page2.page_namespace = 828 then "Module:"
		when page2.page_namespace = 829 then "Module talk:"
		end, page2.page_title, "]]") AS 'title2',
    CONCAT("[https://zh.wiktionary.org/wiki/Special:%E7%A7%BB%E5%8A%A8%E9%A1%B5%E9%9D%A2/",case
		when page.page_namespace = 10 then "Template:"
		when page.page_namespace = 11 then "Template talk:"
		when page.page_namespace = 828 then "Module:"
		when page.page_namespace = 829 then "Module talk:"
		end, page.page_title
           ,"?wpNewTitle=", case
		when page2.page_namespace = 10 then "Template:"
		when page2.page_namespace = 11 then "Template talk:"
		when page2.page_namespace = 828 then "Module:"
		when page2.page_namespace = 829 then "Module talk:"
		end, page2.page_title, " Move]") AS "Action"
FROM page
INNER JOIN page AS page2 ON CONCAT(
  UCASE(
	SUBSTRING(
	  CONVERT(
		page.page_title USING utf8
	  ), 1, 1
	)
  ), SUBSTRING(
	page.page_title, 2, LENGTH(page.page_title)-1
  )
) = page2.page_title
LEFT JOIN redirect ON page2.page_id = redirect.rd_from
WHERE page.page_title REGEXP '^[a-z]'
	AND (
		(page.page_namespace = 10 AND page2.page_namespace = 10) OR 
		(page.page_namespace = 11 AND page2.page_namespace = 11) OR
		(page.page_namespace = 828 AND page2.page_namespace = 828) OR
		(page.page_namespace = 829 AND page2.page_namespace = 829)
	)
    AND page.page_title = redirect.rd_title
SQL

Checking query status...
