WPWPTE upto-the-minute stats

Fork of WPWPTE upto-the-minute stats by KINNERA ARAVIND

This query is marked as a draft This query has been published by KINNERA ARAVIND.

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 "%WPWPTE%"
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...