Untitled query #76796

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', u.user_name) AS 'User', MAX(u.user_editcount) AS 'Edit count', TIMESTAMP(MAX(rc.rc_timestamp)) AS 'Last activity' 
FROM recentchanges_userindex rc
INNER JOIN actor_recentchanges a ON a.actor_id = rc.rc_actor
INNER JOIN user u ON a.actor_user = u.user_id
WHERE rc.rc_timestamp > DATE_SUB(NOW(), INTERVAL 7 DAY)
AND u.user_editcount < 50
AND (
u.user_name LIKE '% (%)'
OR u.user_name LIKE '%_(%)'
)
AND u.user_name NOT LIKE '%(WMF)%'
AND u.user_name NOT LIKE '%(Wiki Ed)%'
GROUP BY u.user_id
ORDER BY MAX(rc.rc_timestamp) DESC
SQL

Checking query status...
