Untitled query #26448

SQL

use huwiki_p;
select rev_user_text, sum(cnt) 
from
(
select 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 > '20180401000000' and rev_timestamp<'20180415000000'
group by rev_user_text
union
SELECT
    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 > '20180401000000' and log_timestamp<'20180415000000'
    GROUP BY log_user
) as T
group by rev_user_text
order by sum(cnt) desc
;
SQL

Checking query status...
