Recently active users with at least 1000 edits

SQL

USE itwiki_p;
SELECT
	revactor_actor,
    actor.actor_name,
    user.user_editcount,
    user.user_registration,
	MAX(revactor_timestamp) AS "Last edit",
	COUNT(revactor_timestamp)
FROM revision_actor_temp
JOIN actor ON actor.actor_id = revision_actor_temp.revactor_actor
JOIN user ON actor.actor_user = user.user_id
WHERE revactor_timestamp BETWEEN 20190701000000 AND 20191231235959
    AND user.user_editcount > 100
    AND user.user_id NOT IN (SELECT ug_user from user_groups WHERE ug_group = 'bot')
    AND user.user_id NOT IN (SELECT ipb_user FROM ipblocks WHERE ipb_user != 0)
GROUP BY revactor_actor;

SQL

Checking query status...