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

SQL

SELECT 
    REPLACE(p.page_title, 'Draft:', '') AS article_title,  -- Remove the "Draft:" prefix
    MAX(CASE WHEN r.rev_comment LIKE '%Submitting using%' THEN r.rev_timestamp ELSE NULL END) AS submission_time,
    MAX(CASE WHEN r.rev_comment LIKE '%Declining submission:%' THEN r.rev_timestamp ELSE NULL END) AS decline_time,
    MAX(CASE WHEN r.rev_comment LIKE '%Submitting using%' THEN r.rev_comment ELSE NULL END) AS submission_summary,
    MAX(CASE WHEN r.rev_comment LIKE '%Declining submission:%' THEN r.rev_comment ELSE NULL END) AS decline_summary
FROM
    page p
JOIN
    categorylinks cl ON p.page_id = cl.cl_page
JOIN
    revision r ON p.page_id = r.rev_page
WHERE
    cl.cl_title = 'Category:Pending_AfC_submissions'
    AND p.page_namespace = 118
GROUP BY
    p.page_id, p.page_title
ORDER BY
    p.page_title;

SQL

Checking query status...