USE zhwiki_p;

SELECT user_id, CONCAT('User:', user_name), user_editcount, user_registration

FROM user

WHERE user_editcount >= 200

  AND (user_registration IS NULL

       OR TIMESTAMPDIFF(DAY, user_registration, CURRENT_TIMESTAMP) >= 30)

  AND user_id IN (SELECT rc_user FROM recentchanges WHERE rc_user = user_id)

  AND user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_user = user_id AND ug_group = "bot")