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 = 11) OR

        (page.page_namespace = 829)

    )

    AND page.page_is_redirect = 0