USE skwiki_p;

​

SELECT

    @i := @i + 1 AS rank, 

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

    REPLACE(p.page_title, '_', ' ') as page_title,

    CONCAT(SUBSTRING(r.rev_timestamp, 1, 4), '-', SUBSTRING(r.rev_timestamp, 5, 2), '-', SUBSTRING(r.rev_timestamp, 7, 2), ' ', SUBSTRING(r.rev_timestamp, 9, 2), ':', SUBSTRING(r.rev_timestamp, 11, 2), ':', SUBSTRING(r.rev_timestamp, 13, 2)) as rev_at,

    ra.actor_name as rev_by,

    p.page_id,

    -- p.page_namespace,

    -- p.page_is_redirect,

    r.rev_id,

    r.rev_len,

    r.rev_parent_id

  FROM

    page p, revision r, actor ra, (SELECT @i := 0) AS rank

  WHERE

    r.rev_page = p.page_id and

    ra.actor_id = r.rev_actor and

    p.page_namespace = 0 and

    p.page_is_redirect = 0

  ORDER BY

    r.rev_timestamp

  LIMIT

    1000

  ;

​