USE enwiki_p;

SELECT

    CASE page_namespace

      WHEN 10 THEN CONCAT("Template:", page_title)

      WHEN 11 THEN CONCAT("Template talk:", page_title)

    END

FROM page

WHERE

    (

      page_namespace = 10

      OR page_namespace = 11

    )

    AND page_title LIKE "%section%"

    AND page_title NOT LIKE "%/doc"

    AND page_title NOT LIKE "%/sandbox"

    AND page_title NOT LIKE "%/testcases"

ORDER BY page_title, page_namespace