USE skwiki_p;

​

SELECT

    p.page_id,

    (SELECT pp_value FROM page_props WHERE pp_page = page_id AND pp_propname = 'wikibase_item') as wb_item,

    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

    rf.rev_user_text = 'Maros' and

    -- rf.rev_user_text = 'Wizzo-Bot' 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

  LIMIT

    60000

  OFFSET

    0

    -- 60000

    -- 120000

    -- 180000

  ;