Untitled query #64139

SQL

/*select actor_name, rev_id from actor
inner join revision on rev_actor=actor_name
left join comment on rev_comment_id=comment_id
where rev_timestamp > 20220425000000
and comment_text like "% ([[User:Ingenuity/AntiVandal|AV]])"*/

select actor_name, COUNT(select * from revision left join comment on rev_comment_id=comment_id where rev_timestamp > 20220425000000 and comment_text like "% ([[User:Ingenuity/AntiVandal|AV]])") from actor order by COUNT(select * from revision left join comment on rev_comment_id=comment_id where rev_timestamp > 20220425000000 and comment_text like "% ([[User:Ingenuity/AntiVandal|AV]])") desc limit 5
SQL

Checking query status...
