Fork of start with lower and upper exist same time & lower not redirect in zhwikt by Xiplus
This query is marked as a draft This query has been published by Xiplus.

SQL

AخA
 
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:MovePage/",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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...