USE metawiki_p;

SELECT page.page_title, mwuser.user_name

FROM page

INNER JOIN revision ON revision.rev_id = page.page_latest

INNER JOIN user ON mwuser.user_id = revision.rev_user

WHERE

    page.page_namespace = 4

    AND NOT page.page_is_redirect

    AND page.page_title LIKE "Requests_for_%"

    AND (

      page.page_title LIKE "Requests_for_adminship/%"

      OR page.page_title LIKE "Requests_for_bot_status/%"

      OR page.page_title LIKE "Requests_for_bureaucratship/%"

      OR page.page_title LIKE "Requests_for_CentralNotice_adminship/%"

      OR page.page_title LIKE "Requests_for_checkuser/%"

      OR page.page_title LIKE "Requests_for_interface_adminship/%"

      OR page.page_title LIKE "Requests_for_oversight/%"

      OR page.page_title LIKE "Requests_for_temporary_adminship/%"

      OR page.page_title LIKE "Requests_for_translation_adminship/%"

    )