Users with at least 1000 edits

SQL

USE itwiki_p;

SELECT *
FROM user
WHERE user_editcount > 1000
	AND user_id NOT IN (SELECT ug_user from user_groups WHERE ug_group = 'bot')
    AND user_id NOT IN (SELECT ipb_user FROM ipblocks WHERE ipb_user != 0)

#SELECT
#	revactor_actor,
#	MAX(revactor_timestamp)
#FROM revision_actor_temp
#WHERE revactor_actor IN
#(
#    SELECT actor_id
#    FROM actor
#    WHERE actor_user IN
#    (
#        SELECT user_id
#        FROM user
#        WHERE user_editcount > 1000 AND user_id NOT IN (SELECT ug_user from user_groups WHERE ug_group = 'bot')
#    )
#)
#GROUP BY revactor_actor;
SQL

Checking query status...
