‎ - Quarry

Fork of Last edits to pages in Maltese lemmas by Fenakhay

This query is marked as a draft This query has been published by Red Director.

SQL

set @category_name = 'National_Football_League_teams';

select
    replace(page_title, '_', ' ') as title,
    actor_name as last_editor,
    comment_text as last_edit_summary,
    date_format(rev_timestamp, '%Y-%m-%d %H:%i:%s') as last_edit_timestamp
from categorylinks
join page on page_id = cl_from
join revision_userindex on rev_id = page_latest
join actor on actor_id = rev_actor
join comment on comment_id = rev_comment_id
where cl_to = @category_name
	AND rev_actor = 100613
order by rev_timestamp asc
limit 100;

SQL

Checking query status...