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

SELECT convention, COUNT(*)
FROM conventions
JOIN pagelinks AS direct ON direct.pl_title = convention AND pl_namespace = 4
#LEFT JOIN page on direct.pl_from = page_id AND page_is_redirect = 1 AND page_namespace = 4
#JOIN pagelinks AS indirect ON page_title = indirect.pl_title
GROUP by convention
SQL

Checking query status...
