USE metawiki_p;

SELECT 

  page_title,

  user_name

FROM page

INNER JOIN revision ON rev_id = page_latest

INNER JOIN user ON user_id = rev_user

INNER JOIN comment ON comment_id = rev_comment_id /* NEW: For my comment */

WHERE

    page_namespace = 4

    AND NOT page_is_redirect

    AND page_title LIKE "Requests_for_%"

    AND (

      page_title LIKE "Requests_for_adminship/%"

      OR page_title LIKE "Requests_for_bot_status/%"

      OR page_title LIKE "Requests_for_bureaucratship/%"

      OR page_title LIKE "Requests_for_CentralNotice_adminship/%"

      OR page_title LIKE "Requests_for_checkuser/%"

      OR page_title LIKE "Requests_for_interface_adminship/%"

      OR page_title LIKE "Requests_for_oversight/%"

      OR page_title LIKE "Requests_for_temporary_adminship/%"

      OR page_title LIKE "Requests_for_translation_adminship/%"

    )

    AND page_title != "Requests_for_adminship/Archives"

    AND page_title NOT LIKE "%Election_Committee" /* Hopefully, no will ever suffix their name with this and request permissions. */