Untitled query #77631

SQL

USE ukwiki_p;

SELECT p.page_id, p.page_title
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
WHERE p.page_namespace = 0
  AND u.user_name = "Haida"
  AND r.rev_parent_id = 0
  AND r.rev_deleted = 0
  AND NOT EXISTS (
    SELECT 1
    FROM revision rev
    WHERE rev.rev_page = p.page_id
    AND (rev.rev_comment LIKE "%rollback%" OR rev.rev_comment LIKE "%page moved%" OR rev.rev_len < r.rev_len - 100)
  )
  AND NOT EXISTS (
    SELECT 1
    FROM user_groups ug2
    WHERE ug2.ug_user = u.user_id
    AND ug2.ug_group = 'bot'
  )
  AND ug.ug_group = 'patroller';
SQL

Checking query status...
