Untitled query #25853

SQL

use huwiki_p;select rev_user_text, sum(cnt) from(select rev_user_text, count(rev_id) as cntfrom revision join tag_summary on rev_id=ts_rev_id where ts_tags='mw-rollback' and rev_timestamp > '20180101000000' and rev_timestamp<'20180312000000'group by rev_user_textunionSELECT    log_user_text user,	count(*) as cntFROM	logging
WHERE
	log_type = 'review'
    AND log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i')
    AND log_timestamp > '20170101000000' and log_timestamp<'20180101000000'
    GROUP BY log_user
) as T
group by rev_user_text
order by sum(cnt) desc
Limit 25;
SQL

Checking query status...
