Test 2 - Quarry

SQL

USE ckbwiki_p;

SELECT
    actor_name AS Username,
    MAX(rev_timestamp) AS LastEditDate,
    SUM(edits.Count) AS NumberOfEdits,
    GROUP_CONCAT(DISTINCT actor_user_groups.ug_group) AS BotGroups,
    user_registration AS RegistrationDate
FROM actor
JOIN user ON actor_user = user_id
LEFT JOIN user_groups AS actor_user_groups ON user_id = actor_user_groups.ug_user
LEFT JOIN (
    SELECT rev_actor, COUNT(*) AS Count
    FROM revision
    GROUP BY rev_actor
) AS edits ON actor_id = edits.rev_actor
WHERE actor_user_groups.ug_group LIKE '%bot%'
GROUP BY Username
HAVING MAX(rev_timestamp) >= DATE_FORMAT(NOW() - INTERVAL 6 MONTH, '%Y%m%d%H%i%s') -- Change '6 MONTH' to the desired activity threshold
ORDER BY LastEditDate DESC;
SQL

Checking query status...
