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,

    rfa.actor_name as rev_first_user,

    rl.rev_timestamp as rev_last,

    rla.actor_name as rev_last_user

  FROM

    page p

      LEFT OUTER JOIN revision rf ON rf.rev_page = p.page_id AND rf.rev_parent_id = 0

      LEFT OUTER JOIN actor rfa ON rfa.actor_id = rf.rev_actor,

    revision r, revision rl, actor rla

  WHERE

    -- p.page_id = 632422 AND

    r.rev_page = p.page_id AND

    -- rf.rev_page = p.page_id AND -- rf.rev_parent_id = 0 AND

    -- rfa.actor_id = rf.rev_actor AND

    rl.rev_id = p.page_latest AND

    rla.actor_id = rl.rev_actor 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

    -- 240000

  ;