Untitled query #89558

SQL

SELECT 
    user_name, 
    MAX(rev_timestamp) AS 'Last edit'
FROM `user`
JOIN actor
    ON actor_user = user_id
JOIN revision_userindex
    ON rev_id = (
        SELECT rev_id 
        FROM revision_userindex
        WHERE actor_id = rev_actor
        ORDER BY rev_timestamp DESC
        LIMIT 1
    )
JOIN user_groups ug
    ON user_id = ug.ug_user AND ug.ug_group = 'autopatrolled'
WHERE rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 60 DAY, '%Y%m%d%H%i%S')
    AND (
        user_name LIKE '%Bot'
        OR user_name LIKE '%bot'
        OR user_name LIKE '%BOT'
        OR user_name LIKE '%(bot)%'
    )
GROUP BY user_name
ORDER BY MAX(rev_timestamp) DESC
LIMIT 50;
SQL

Checking query status...
