Untitled query #77631

SQL

SELECT p.page_id, p.page_title, 
    (SELECT COUNT(DISTINCT u2.user_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_id = p.page_id
       AND u2.user_name = "Haida"
    ) 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
WHERE p.page_namespace = 0
  AND r.rev_parent_id = 0
  AND p.page_is_redirect = 0;
SQL

Checking query status...
