USE enwiki_p;

SELECT

  CASE page_namespace

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

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

  END AS "Page title",

  R,

  GROUP_CONCAT(cl_to SEPARATOR "; ") AS "Categories"

FROM

(  

  SELECT

    page_namespace,

    page_title,

    CASE page_is_redirect

      WHEN 1 THEN "(R)"

    END AS R,

    CASE

      WHEN page_is_redirect = 1 THEN page_id

      ELSE page_id

    END AS primary_page_id,

    page_id

    /* Ideally, I would utilize some link following code

    so talk pages and redirects can benefit from the categorization of their target pages.

    */

  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"

)

LEFT JOIN categorylinks ON cl_from = primary_page_id

WHERE

  /* AND cl_to != "Templates_for_railway_lines_of_India"

  AND c1_to NOT LIKE "%_Indian_railways_articles"

  AND cl_to NOT LIKE "%_sports_templates" */

GROUP BY page_id

ORDER BY page_title, page_namespace DESC