‌ - Quarry

SQL

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 = 'بوابة_برمجيات_حرة/مقالات_متعلقة'
order by rev_timestamp desc
limit 10000;
SQL

Checking query status...
