Test 2 - Quarry

SQL

USE ckbwiki_p;

SELECT
    actor_name AS Username,
    MAX(rev_timestamp) AS LastEditDate,
    COUNT(rev_id) AS NumberOfEdits,
    GROUP_CONCAT(DISTINCT user_groups.ug_group) AS BotGroups,
    GROUP_CONCAT(DISTINCT user_rights.ur_right) AS UserRights,
    user_registration AS RegistrationDate
FROM revision
JOIN actor ON actor_id = rev_actor
JOIN user ON actor_user = user_id
LEFT JOIN user_groups ON user_id = user_groups.ug_user
LEFT JOIN user_rights ON user_id = user_rights.ur_user
WHERE actor_user IN (
    SELECT DISTINCT ug_user
    FROM user_groups
    WHERE ug_group LIKE '%bot%'
)
GROUP BY Username
HAVING LastEditDate < DATE_FORMAT(NOW() - INTERVAL 6 MONTH, '%Y%m%d%H%i%s') -- Change '6 MONTH' to the desired inactivity threshold
ORDER BY LastEditDate ASC;
SQL

Checking query status...
