Early gaming - experiment

SQL

SET
  STATEMENT max_statement_time = 60 FOR
SELECT
	actor_id,
  	COUNT(*) AS edit_count,
	SUM(LENGTH(TRIM(REGEXP_REPLACE(comment_text, '/\\* .* \\*/ *', ''))) > 0) AS non_empty_count
FROM recentchanges_userindex AS recentchanges
INNER JOIN comment_recentchanges AS comment ON recentchanges.rc_comment_id = comment.comment_id
INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
INNER JOIN user ON actor.actor_user = user.user_id
WHERE
TRUE
AND rc_source IN ('mw.edit')
AND rc_bot = 0
AND actor_user IS NOT NULL
AND user_registration >= "20220201000000" 
GROUP BY actor_id
HAVING edit_count < 500 AND edit_count > 5 AND non_empty_count / edit_count >= 0.95
SQL

Checking query status...
