USE metawiki_p;

SELECT page_create_year AS "Creation year", COUNT(*) AS "Requests created" 

FROM ( /* Derived table to define page_create_year */

  SELECT SUBSTR(MIN(rev_timestamp),1,4) AS page_create_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

) AS revision_augmented

GROUP BY page_create_year