Untitled query #77631

SQL

SELECT p.page_id, p.page_title, editors_count
FROM page p
JOIN (
  SELECT p.page_id, COUNT(DISTINCT u.user_id) AS editors_count
  FROM page p
  JOIN revision r ON p.page_id = r.rev_page
  JOIN actor a ON r.rev_actor = a.actor_id
  JOIN user u ON a.actor_user = u.user_id
  LEFT JOIN user_groups ug ON u.user_id = ug.ug_user AND ug.ug_group = 'editor'
  WHERE p.page_namespace = 0
    AND r.rev_parent_id = 0
    AND p.page_is_redirect = 0
    AND u.user_name != "Haida"
  GROUP BY p.page_id
) AS editor_counts ON p.page_id = editor_counts.page_id

ORDER BY editors_count DESC;
SQL

Checking query status...
