fiwiki flaggedrevision approves

SQL

use fiwiki_p;

SELECT 
	l1_c, sb_c, ac
FROM
	(
	SELECT 
		floor(log_timestamp/10000000000) as d, 
    	sum(1) as l1_c
	FROM 
		logging_userindex
	WHERE 
		log_user_text='SeulojaBot' 
		AND log_action IN('approve', 'approve2') 
	    AND log_type='review' 
	GROUP BY d
    ) AS L1,
    (
	SELECT 
		floor(log_timestamp/10000000000) as d, 
    	sum(1) as sb_c
	FROM 
		logging_userindex
	WHERE 
		log_user_text!='SeulojaBot' 
		AND log_action IN('approve', 'approve2') 
	    AND log_type='review' 
	GROUP BY d
    ) AS L2,
    (
	SELECT 
		floor(log_timestamp/10000000000) as d, 
    	sum(1) as ac
	FROM 
		logging_userindex
	WHERE 
		log_action IN('approve-a', 'approve2-a') 
	    AND log_type='review' 
	GROUP BY d
    ) AS A1
WHERE
	L1.d=L2.d
    AND L1.d=A1.d
SQL

Checking query status...
