SET SESSION group_concat_max_len = 100000000;

USE itwiki_p;

SET @l = ( SELECT GROUP_CONCAT(TO_BASE64(user_name)) AS u

          FROM user

          RIGHT JOIN page -- Check that a local userpage exists as well

          ON page_namespace = 2

          AND REPLACE(page_title, '_', ' ') = user_name

          AND user_editcount > 200 );

USE commonswiki_p;

SELECT user_name, user_editcount

FROM user

WHERE user_editcount > 100

AND FIND_IN_SET(TO_BASE64(user_name), @l)

AND user_name NOT RLIKE '.*[Bb]ot.*'

AND user_id IN (

  SELECT rev_user

  FROM revision_userindex

  WHERE rev_timestamp > '20170101000000'

  GROUP BY rev_user )

ORDER BY user_editcount DESC;