Untitled query #70275

SQL

/* select count(rev_page) as total from revision,comment 
where comment_id=rev_comment_id 
and comment_text like "%WPWPTE%"
and rev_timestamp>="2021070100000";
-- ---
*/select actor_name,count(rev_actor) as countt from revision,comment,actor,page 
where comment_id=rev_comment_id 
                  and rev_actor=actor_id
                  and page_id=rev_page
and comment_text like "%WPWPYO%"
and rev_timestamp>="2022070100000"
and rev_timestamp<="2022103100000"
-- and rev_timestamp like "20210830%"
group by rev_actor
order by count(rev_actor) desc
SQL

Checking query status...
