Untitled query #68295

SQL

USE skwiki_p;

SELECT
    *
  FROM
    revision r
  WHERE
    r.rev_id = 6843027
  ORDER BY
    r.rev_timestamp;

SELECT
    *
  FROM
    revision r
  WHERE
    r.rev_page = 632422
  ORDER BY
    r.rev_timestamp;

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,
    rf.rev_parent_id as rev_first_parent
  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
  ;
SQL

Checking query status...
