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 تاريخ_الصلاحية,
         (
        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

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...
