Untitled query #77631

SQL

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 r.rev_len >= (SELECT rev_len FROM revision WHERE rev_id = r.rev_id - 1) + 100
  AND NOT EXISTS (
    SELECT 1
    FROM user_groups ug2
    WHERE ug2.ug_user = u.user_id
    AND ug2.ug_group = 'bot'
  )
;
SQL

Checking query status...
