Untitled query #76791

SQL

SELECT
    u.user_name AS user_name,
    (
        SELECT log_timestamp
        FROM logging
        WHERE log_title = REPLACE(u.user_name, ' ', '_')
        AND log_type = 'rights'
        AND (
            log_params LIKE '%, sysop'
            OR log_params LIKE '%sysop'
            OR (
                log_params NOT LIKE '%::oldgroups%sysop%5::newgroups%'
                AND log_params LIKE '%::newgroups%sysop%'
            )
        )
        LIMIT 1
    ) AS Date_of_Rights,
    (
        SELECT MAX(rev_timestamp)
        FROM revision_userindex
        WHERE rev_actor = a.actor_id
    ) AS last_edit_date,
    (
        SELECT COUNT(*)
        FROM revision_userindex
        WHERE rev_actor = a.actor_id
            AND rev_timestamp >= DATE_SUB(NOW(), INTERVAL 6 MONTH)
    ) AS edit_count_last_6_months,
    (
        SELECT COUNT(*)
        FROM logging
        WHERE log_actor = a.actor_id
            AND log_type IN ('block', 'delete', 'merge', 'protect', 'rights')
            AND log_timestamp >= DATE_SUB(NOW(), INTERVAL 6 MONTH)
    ) AS admin_actions_last_6_months,
    (
        SELECT COUNT(*)
        FROM logging
        WHERE log_actor = a.actor_id
            AND log_type IN ('block', 'delete', 'merge', 'protect', 'rights')
            AND log_timestamp >= DATE_SUB(NOW(), INTERVAL 30 DAY)
    ) AS admin_actions_last_30_days
FROM
    user AS u
INNER JOIN
    user_groups AS ug ON u.user_id = ug.ug_user
INNER JOIN
    actor AS a ON u.user_id = a.actor_user
WHERE
    ug.ug_group = 'sysop';
SQL

Checking query status...
