Test 2 - Quarry

SQL

USE ckbwiki_p;

SELECT
    ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS '#',
    Username,
    LastEditDate,
    NumberOfEdits,
    BotGroups,
    RegistrationDate
FROM (
    SELECT
        actor_name AS Username,
        MAX(rev_timestamp) AS LastEditDate,
        COUNT(rev_id) AS NumberOfEdits,
        GROUP_CONCAT(DISTINCT actor_user_groups.ug_group) AS BotGroups,
        user_registration AS RegistrationDate
    FROM revision
    JOIN actor ON actor_id = rev_actor
    JOIN user ON actor_user = user_id
    LEFT JOIN user_groups AS actor_user_groups ON user_id = actor_user_groups.ug_user
    WHERE actor_user_groups.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
) AS subquery;
SQL

Checking query status...
