Untitled query #76791

SQL

SELECT
    u.user_name AS user_name,
    l.log_timestamp AS date_of_rights
   # MAX(r.rev_timestamp) AS last_edit_date,
    #SUM(CASE WHEN r.rev_timestamp >= DATE_SUB(NOW(), INTERVAL 6 MONTH) THEN 1 ELSE 0 END) AS edit_count_last_6_months
FROM
    user AS u
INNER JOIN
    user_groups AS ug ON u.user_id = ug.ug_user
LEFT JOIN
    logging AS l ON l.log_title = REPLACE(u.user_name, ' ', '_')
                 AND l.log_type = 'rights'
                 AND (
                     l.log_params LIKE '%, sysop'
                     OR l.log_params LIKE '%sysop'
                     OR (
                         l.log_params NOT LIKE '%::oldgroups%sysop%5::newgroups%'
                         AND l.log_params LIKE '%::newgroups%sysop%'
                     )
                 )
LEFT JOIN
    actor AS a ON a.actor_user = u.user_id
LEFT JOIN
    revision_userindex AS r ON r.rev_actor = a.actor_id

WHERE
    ug.ug_group = 'sysop'
GROUP BY
    u.user_name,
    l.log_timestamp;

/*
#show tables;
select * from actor_revision limit 10;
select * from revision_compat limit 10;
select * from revision_userindex limit 10;
*/
SQL

Checking query status...
