start with lower & not redirect template talk or module talk in zhwikt

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 'title',
FROM page
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_is_redirect = 0

SQL

Checking query status...