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

SQL

Checking query status...