Járőrstat visszaállításokkal

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 > '20180101000000' and rev_timestamp<'20180312000000'
group by rev_user_text
union
SELECT
    log_user_text user,
	count(*) as cnd
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
)
group by rev_user_text

SQL

Checking query status...