USE metawiki_p;

SELECT 

  page_title,

  user_name,

      CASE WHEN

        user_name = "E to the Pi times i"

      /*  AND comment_text = "Maintenance: adding {{[[Help:Substitution|subst]]:[[Template:Closed request top|Closed request top]]}} and {{[[Help:Substitution|subst]]:[[Template:Closed request bottom|Closed request bottom]]}} to old closed request." 

      */THEN 1 ELSE 0 END AS closed_by_me

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. */