Untitled query #80181

SQL

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,
    -- p.page_len,
    -- (SELECT count(*) FROM langlinks WHERE ll_from = p.page_id) as iw_count,
    CONCAT(SUBSTRING(rf.rev_timestamp, 1, 4), '-', SUBSTRING(rf.rev_timestamp, 5, 2), '-', SUBSTRING(rf.rev_timestamp, 7, 2), ' ', SUBSTRING(rf.rev_timestamp, 9, 2), ':', SUBSTRING(rf.rev_timestamp, 11, 2), ':', SUBSTRING(rf.rev_timestamp, 13, 2)) as created_at,
    rfa.actor_name as created_by,
    -- count(r.rev_id) as rev_count
    p.page_id,
    p.page_namespace,
    -- p.page_is_redirect,
    rf.rev_id,
    rf.rev_len
  FROM
    page p, revision r, revision rf, actor rfa, (SELECT @i := 0) AS rank
  WHERE
    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
    -- p.page_namespace = 0 and
    p.page_is_redirect = 0
  GROUP BY
    p.page_id
  ORDER BY
    -- p.page_id
    rf.rev_timestamp
  LIMIT
    1000
  ;
SQL

Checking query status...
