Activity - Most page moves by non-page movers in the last 91 days

SQL

SELECT actor_name AS `Editor`, COUNT(*) as '#PageMoves'
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        WHERE log_timestamp > date_add(now(), interval -91 day)
        AND log_type = 'move'
        AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor
AND NOT EXISTS (SELECT 1 FROM user_groups WHERE actor_user=ug_user AND ug_group in ( 'sysop', 'extendedmover', 'bot' ))
GROUP BY `Editor`
ORDER BY `#PageMoves` DESC
limit 20;

SQL

Checking query status...