Untitled query #58544

SQL

SELECT actor_name, COUNT(rev_timestamp) AS antal  FROM revision JOIN comment ON rev_comment_id=comment_id JOIN actor ON rev_actor=actor_id WHERE 
rev_timestamp > '20230701000000'
AND comment_text LIKE '%[[Project:AWB|AWB]]%'
GROUP BY actor_name
ORDER BY antal DESC

/*
SELECT actor_name, COUNT(*) AS antal, MAX(rc_timestamp) AS senast FROM recentchanges JOIN comment on rc_comment_id=comment_id JOIN actor ON rc_actor=actor_id WHERE
comment_text LIKE '%AWB]]%'
GROUP BY actor_name
ORDER BY senast DESC
*/
/*
SELECT CONCAT('[[:Kategori:',log_title,']]') AS kategori, log_timestamp AS raderingstid, actor_name FROM logging JOIN actor ON log_actor=actor_id JOIN comment ON log_comment_id=comment_id WHERE 
*/
/*
SELECT CONCAT('{{mall|',log_title,'}}') AS mall, log_timestamp AS raderingstid FROM logging JOIN actor ON log_actor=actor_id JOIN comment ON log_comment_id=comment_id WHERE 
log_type = 'delete'
AND log_action = 'delete'
AND log_title LIKE '%stub%'
AND log_namespace = 10
AND log_timestamp > '20230801T000000Z'
ORDER BY log_timestamp DESC
*/
SQL

Checking query status...
