pages creator and last edit

SQL

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;
SQL

Checking query status...
