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;