Untitled query #25465

SQL

use huwiki_p;
select 'rb' as type, rev_user_text, count(rev_id) as cnt
from 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_text
union
SELECT
    'approve' as type,
    log_user_text user,
	count(*) as cnt
FROM
	logging
WHERE
	log_type = 'review'
    AND log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i')
    AND log_timestamp > '20180101000000' and log_timestamp<'20180312000000'
    GROUP BY log_user
SQL

Checking query status...
