غير نشط-SM

حصر أسماء المستخدمين من حاملي الصلاحيات، الذين لم يساهموا لمدة عام.

SQL

SELECT DISTINCT(actor_name) as ll_actor_name, ug_group AS user_groups,
               (SELECT MAX(rev_timestamp) FROM revision WHERE rev_actor = actor_id) AS last_edit_date
FROM actor_revision
         JOIN user_groups ON actor_user = ug_user
         JOIN user ON actor_user = user.user_id
         LEFT JOIN ipblocks ON actor_user = ipb_user
WHERE ug_group IN ('editor', 'autoreview', 'uploader')
  AND ipb_user IS NULL
  AND actor_id NOT IN (
    SELECT rev_actor
    FROM revision
    WHERE rev_timestamp > DATE_SUB(NOW(), INTERVAL 1 YEAR)
)
GROUP BY actor_name, user_groups

SQL

Checking query status...