Tewiki: #TTSD24 edits count, user-wise

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 "%TTSD24%"
and rev_timestamp>="20241024000000"
and rev_timestamp<="20241101000000"
-- and rev_timestamp like "20210830%"
group by rev_actor
order by count(rev_actor) desc

SQL

Checking query status...