Qanat: undo candidates

SQL

use fawiki_p;
select page_title, max_rev_id, rev_len, max_rev_len
from revision r
join
(
  select
    max(rev_id) as max_rev_id,
    rev_page as page_id,
    q.page_title
  from
  (
    select page_id, page_title
    from revision
    join page
    on rev_page = page_id
    where page_title like 'قنات%'
    and rev_user = 100607 -- HujiBot
    and page_is_redirect = 1
  ) q
  join revision
    on q.page_id = rev_page
    and rev_user <> 100607 -- Hujibot
    and rev_user_text <> 'JYBot'
    and rev_user <> 0
    and rev_minor_edit <> 1
  group by rev_page
) qq
on r.rev_page = qq.page_id
and r.rev_id = qq.max_rev_id
join
(
  select rev_page, max(rev_id) max_rev_len
  from revision
) t
on t.rev_page = r.rev_page
order by rev_len desc
SQL

Checking query status...
