select

    page_namespace,

    page_title,

    (select actor_name from revision inner join actor on rev_actor = actor_id where rev_page = page_id order by rev_timestamp asc limit 1) 'creator',

    (select TIMESTAMP(rev_timestamp) from revision where rev_page = page_id order by rev_timestamp asc limit 1) 'creation date',

    a1.actor_name 'last editor',

    timestamp(r1.rev_timestamp) 'last edit date'

from page

inner join revision r1 on r1.rev_id = page_latest

inner join actor a1 on actor_id = r1.rev_actor

limit 140;