MI/CV deletion discussions, raw

Deletion discussions edited by Mark Ironie and/or CorbieVreccan.

See query 76564 for summary and overlap.

For [[WP:AN#Long-term meatpuppetry by two admins]] circa 12 Sep 2023.

SQL

SELECT rev_id, rev_timestamp, actor_name, page_title, comment_text
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
JOIN comment_revision ON comment_id = rev_comment_id
JOIN page ON page_id = rev_page
WHERE actor_name IN ('Mark Ironie', 'CorbieVreccan')
  AND page_namespace = 4
  AND ((page_title LIKE 'Articles_for_deletion/%' AND page_title NOT LIKE 'Articles_for_deletion/Log/%')
       OR page_title LIKE 'Categories_for_discussion/%'
       OR page_title LIKE 'Categories_for_deletion/%'
       OR page_title LIKE 'Templates_for_discussion/%'
       OR page_title LIKE 'Templates_for_deletion/%'
       OR page_title LIKE 'Redirects_for_discussion/%'
       OR page_title LIKE 'Redirects_for_deletion/%'
       OR page_title LIKE 'Miscellany_for_deletion/%')
ORDER BY page_title ASC, rev_timestamp ASC;

SQL

Checking query status...