Newest pages in category

SQL

set @category_name = 'Proto-Norse_lemmas'

select
	page_namespace as namespace,
    replace(page_title, '_', ' ') as title,
    actor_name as first_editor,
    comment_text as first_edit_summary,
    date_format(rev_timestamp, '%Y-%m-%d %H:%i:%s') as first_edit_timestamp
from categorylinks
join page on page_id = cl_from
join revision_userindex on rev_page = cl_from and rev_parent_id = 0
join actor on actor_id = rev_actor
join comment on comment_id = rev_comment_id
where cl_to = @category_name
order by rev_timestamp desc
limit 100;
SQL

Checking query status...
