SELECT DISTINCT REPLACE(SUBSTRING_INDEX(page_title, '/', 1), '_', ' ') AS username

FROM categorylinks

JOIN page ON page_id = cl_from

WHERE cl_to = 'Members_of_the_Fifteen_Year_Society_of_Wikipedia_editors'

  AND page_namespace = 2

  AND EXISTS (SELECT 1

              FROM revision_userindex

              JOIN actor_revision ON actor_id = rev_actor

              WHERE actor_name = REPLACE(SUBSTRING_INDEX(page_title, '/', 1), '_', ' ')

                AND rev_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), '%Y%m%d%H%i%s')

              LIMIT 1);