Untitled query #13360

SQL

USE skwiki_p;

SELECT
    p.page_title,
    count(r.rev_id) as rev_count,
    ( SELECT
          count(rev_id)
        FROM
          revision r1
        WHERE
          r1.rev_page = p.page_id and
          r1.rev_user not in (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') and
          not (lower(r1.rev_user_text) like '%bot')
    ) as rev_nobot_count,
    rf.rev_timestamp as rev_first,
    rf.rev_user_text as rev_first_user,
    rl.rev_timestamp as rev_last,
    rl.rev_user_text as rev_last_user,
    rlnb.rev_timestamp as rev_nobot_last,
    rlnb.rev_user_text as rev_nobot_last_user
  FROM
    page p, revision r, revision rf, revision rl, revision rlnb
  WHERE
    r.rev_page = p.page_id and
    rf.rev_page = p.page_id and rf.rev_parent_id = 0 and
    rl.rev_id = p.page_latest and
    rlnb.rev_id = (
      SELECT
          max(rev_id)
        FROM
          revision r1
        WHERE
          r1.rev_page = p.page_id and
          r1.rev_user not in (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') and
          not (lower(r1.rev_user_text) like '%bot')
       ) and
    p.page_namespace = 0 and
    p.page_is_redirect = 0
  GROUP BY
    p.page_id
  ORDER BY
    rev_first
  LIMIT
    100;
SQL

Checking query status...
