USE metawiki_p;

SELECT SUBSTR(MIN(rev_timestamp),1,4) AS page_create_year AS "Creation year", page_title

FROM revision

INNER JOIN page ON page_id = rev_page

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/%"

    )

GROUP BY rev_page