stats of pseudo-autoreviewed redirects

SQL

  	SELECT distinct log_actor, count(*) as c
	FROM logging_userindex
	JOIN page ON page_title = log_title AND page_namespace = log_namespace
  JOIN user_groups on ug_user=log_actor and ug_group="reviewer"
	WHERE log_timestamp BETWEEN (NOW() - INTERVAL 183 DAY) AND NOW()
	AND 
		((log_type = 'patrol'  AND log_action = 'patrol') OR
		 (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
	AND log_namespace = 0
	group by log_actor
	order by c desc;
select count(*) from user_groups where ug_group="reviewer" and ug_expiry > now();

SQL

Checking query status...