Untitled query #58544

SQL

USE wikidatawiki_p;

/*
SELECT rc_title, rc_namespace, rc_timestamp, actor_name, comment_text FROM recentchanges INNER JOIN actor on rc_actor=actor_id INNER JOIN comment ON rc_comment_id=comment_id WHERE
*/
SELECT actor_name, COUNT(*) AS antal FROM recentchanges INNER JOIN actor on rc_actor=actor_id INNER JOIN comment ON rc_comment_id=comment_id WHERE 
rc_timestamp > '20211010000000' AND
rc_namespace = 0 AND
comment_text LIKE '%|sv %'
GROUP BY actor_name
HAVING antal>=5
ORDER BY antal DESC, actor_name
SQL

Checking query status...
