Untitled query #87957

SQL

SELECT 
    actor.actor_name AS user
FROM actor
INNER JOIN 
    (
        SELECT ug_user
        FROM user_groups
        WHERE ug_group = 'image-reviewer'
        AND ug_user NOT IN (
            SELECT ug_user
            FROM user_groups
            WHERE ug_group = 'sysop'
        )
    ) AS reviewers ON actor.actor_user = reviewers.ug_user
WHERE actor.actor_user NOT IN (
    SELECT DISTINCT rc_actor
    FROM recentchanges
    JOIN comment ON recentchanges.rc_comment_id = comment.comment_id
    WHERE rc_namespace = 6
    AND rc_timestamp >= '20240701000000'
    AND (
        comment.comment_text LIKE '%icense review%' 
        OR comment.comment_text LIKE '%LR passed%'
        OR comment.comment_text LIKE '%: passed%'
    )
)
ORDER BY user ASC;
SQL

Checking query status...
