Untitled query #77631

SQL

USE ukwiki_p;

SELECT p.page_id, p.page_title, unique_patrollers
FROM page p
JOIN (
  SELECT p.page_id,
         COUNT(DISTINCT ppat.actor_user) AS unique_patrollers
  FROM page p
  JOIN revision r ON p.page_id = r.rev_page
  JOIN actor a ON r.rev_actor = a.actor_id
  LEFT JOIN user u ON a.actor_user = u.user_id
  LEFT JOIN user_groups ug ON u.user_id = ug.ug_user
  LEFT JOIN actor ppat ON ug.ug_group = 'editor' AND ppat.actor_user = u.user_id
  WHERE p.page_namespace = 0
    AND r.rev_parent_id = 0
    AND NOT EXISTS (
      SELECT 1
      FROM comment c
      WHERE c.comment_id = r.rev_comment_id
      AND c.comment_text LIKE 'Скасування%'
    )
  GROUP BY p.page_id
  HAVING MIN(r.rev_len) >= 1000 
) AS subquery ON p.page_id = subquery.page_id
WHERE p.page_id IN (
    SELECT p.page_id
    FROM page p
    JOIN revision r ON p.page_id = r.rev_page
    JOIN actor a ON r.rev_actor = a.actor_id
    LEFT JOIN user u ON a.actor_user = u.user_id
    WHERE p.page_namespace = 0
    AND r.rev_parent_id = 0
    AND u.user_name = "Haida"
  )
AND p.page_is_redirect = 0
ORDER BY unique_patrollers DESC;
SQL

Checking query status...
