Untitled query #74032

SQL

WITH conventions AS (SELECT DISTINCT(CASE WHEN page_is_redirect = 1 THEN pl_title ELSE page_title END) AS convention
  FROM page
  JOIN categorylinks ON page_id = cl_from AND cl_to = "Wikipedia_naming_conventions"
  JOIN pagelinks ON pl_from = page_id AND pl_namespace = 4
  WHERE page_namespace = 4
  AND page_title NOT IN ("Protection_policy", 
                         "Redirect", 
                         "Categorizing_redirects", 
                         "Subpages", 
                         "Requested_moves", 
                         "Namespace", 
                         "Project_namespace", 
                         "Requested_moves/Technical_requests")
  AND pl_title NOT IN ("Protection_policy", 
                       "Redirect", 
                       "Categorizing_redirects", 
                       "Subpages", 
                       "Requested_moves", 
                       "Namespace", 
                       "Project_namespace", 
                       "Requested_moves/Technical_requests")
                    
)

SELECT *
FROM conventions
SQL

Checking query status...
