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",
    CASE page_is_redirect
      WHEN 1 THEN "(R)"
    END AS "R",
    GROUP_CONCAT(cl_to SEPARATOR "; ") AS "Categories"
FROM page
LEFT JOIN categorylinks ON cl_from = page_id
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"
    /* AND cl_to != "Templates_for_railway_lines_of_India"
    AND cl_to != "Greece_sports_templates" */
GROUP BY page_id
ORDER BY page_title, page_namespace

SQL

Checking query status...