Active users on huwiki without right to vote

A quick (under)estimation about the fraction of users who recently edited in huwiki but don’t have the right to vote. Compared to the actual policy (https://hu.wikipedia.org/wiki/Wikip%C3%A9dia:Szavaz%C3%A1s_(ir%C3%A1nyelv)#Szavaz%C3%A1sra_jogosultak), it underestimates the number of users without the right to vote by:
* taking all edits into account, including deleted and non-mainspace ones;
* not excluding bots;
* not counting the number of days the user edited on;
* not taking the registration date into account.

Columns:
* `many`: grouping, whether the users in the given group have had at least 200 edits since registration
* `users`: number of users in the group who had any edit in the last 30 days

SQL

SELECT (user_editcount > 200) AS many, COUNT(DISTINCT user_id) AS users
	FROM recentchanges JOIN actor ON rc_actor = actor_id JOIN user ON user_id = actor_user
	WHERE rc_type IN (0, 1)
	GROUP BY many;

SQL

Checking query status...