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
)

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...
