SELECT CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', u.user_name) AS 'User', COUNT(rc.rc_id) AS 'Edits in past 30 days', u.user_editcount AS 'Total edit count', TIMESTAMP(u.user_registration) AS 'Registered'

FROM user u

INNER JOIN actor a ON a.actor_user = u.user_id

INNER JOIN recentchanges_userindex rc ON rc.rc_actor = a.actor_id AND rc.rc_timestamp >= DATE_SUB(NOW(), INTERVAL 30 DAY)

WHERE u.user_registration <= DATE_SUB(NOW(), INTERVAL 1 YEAR)

AND u.user_editcount >= 500

AND u.user_id NOT IN (

    SELECT ug.ug_user

    FROM user_groups ug

    WHERE ug_group = 'bot'

)

GROUP BY u.user_id

HAVING COUNT(rc.rc_id) >= 30

ORDER BY u.user_name