Untitled query #77631

SQL

SELECT p.page_id, p.page_title,
  (SELECT COUNT(DISTINCT u2.user_id)
   FROM revision r2
   JOIN actor a2 ON r2.rev_actor = a2.actor_id
   JOIN user u2 ON a2.actor_user = u2.user_id
   JOIN user_groups ug ON u2.user_id = ug.user_id
   WHERE r2.rev_page = p.page_id
     AND ug.group_name = 'editor'  
  ) 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 AND u.user_name = "Haida"
WHERE p.page_namespace = 0
  AND r.rev_parent_id = 0
  AND p.page_is_redirect = 0
ORDER BY editors_count DESC;
SQL

Checking query status...
