Section variants of article message boxes (a.k.a. header templates)

SQL

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"
) AS section_pages
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
SQL

Checking query status...
