Basic page metadata for decorating dump-based lists (old)

SQL

USE skwiki_p;

SELECT
    p.page_id,
    p.page_title,
    p.page_len,
    (SELECT count(*) FROM langlinks WHERE ll_from = p.page_id) as iw_count,
    count(r.rev_id) as rev_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
  FROM
    page p, revision r, revision rf, revision rl
  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
    p.page_namespace = 0 and
    p.page_is_redirect = 0
  GROUP BY
    p.page_id
  ORDER BY
    p.page_id
  ;

SQL

Checking query status...