Indefinitely blocked users with over 5000 edits (last 30 days)

SQL

SELECT 
    p.page_id,
    p.page_title,
    r1.rev_timestamp AS submission_time,
    r2.rev_timestamp AS decline_time,
    r1.rev_comment AS submission_summary,
    r2.rev_comment AS decline_summary
FROM
    page p
JOIN
    categorylinks cl ON p.page_id = cl.cl_page
JOIN
    revision r1 ON p.page_id = r1.rev_page
JOIN
    revision r2 ON p.page_id = r2.rev_page
WHERE
    cl.cl_title = 'Category:Pending_AfC_submissions'
    AND r1.rev_comment LIKE '%Submitting using%'
    AND r2.rev_comment LIKE '%Declining submission:%'
    AND r1.rev_timestamp > r2.rev_timestamp
ORDER BY
    p.page_title;

SQL

Checking query status...