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",

    JSON_ARRAYAGG(cl_to) AS "Categories"

FROM page

INNER 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