Untitled query #77631

SQL

SELECT p.page_id, p.page_title, ec.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 ec ON p.page_id = ec.page_id
WHERE p.page_id IN (
  SELECT p2.page_id
  FROM page p2
  JOIN revision r2 ON p2.page_id = r2.rev_page
  JOIN actor a2 ON r2.rev_actor = a2.actor_id
  JOIN user u2 ON a2.actor_user = u2.user_id
  WHERE p2.page_namespace = 0
    AND r2.rev_parent_id = 0
    AND p2.page_is_redirect = 0
    AND u2.user_name = "Haida"
);
SQL

Checking query status...
