Untitled query #48959

SQL

use fiwiki_p;
SELECT 
	l1.log_title,
    a1.actor_name,
    floor(l1.log_timestamp/10000000000) as year,
    l1.log_params, 
    count(distinct(l1.log_id)) as c1,
    count(distinct(l2.log_id)) as c2,  
    count(distinct(l2.log_page)) as p2,
    count(distinct(concat( floor(l2.log_timestamp/1000000), l2.log_title))) as p3,
/*    group_concat(distinct(a2.actor_name)) */
FROM 
	logging_userindex as l1 
    LEFT JOIN logging as l3 ON 
    	l3.log_title=l1.log_title 
        AND l3.log_namespace=l1.log_namespace 
        AND L3.log_action="rights" 
        AND l3.log_timestamp<l1.log_timestamp
        AND l3.log_params LIKE "%editor%"
        AND l3.log_params LIKE "%autoreview%",
    actor_logging as a1,
    logging_userindex as l2, 
    actor_logging as a2
WHERE 
	l1.log_action="rights"
    AND l1.log_actor=a1.actor_id
    AND l1.log_id>1611895 
    AND l1.log_timestamp>20100023061016
    AND 
    (
		(
			l1.log_params NOT like "%oldgroups%autoreview%newgroups%"
			AND l1.log_params NOT like "%oldgroups%editor%newgroups%"          
    		AND l1.log_params like "%newgroups%autoreview%" 
        )
        OR
      	(
    		l1.log_params NOT like "%oldgroups%autoreview%"
			AND l1.log_params NOT like "%newgroups%oldgroups%editor"           
			AND l1.log_params like "%newgroups%autoreview%oldgroups%" 
        )
    )
    AND l2.log_action IN ('approve-a', 'approve2-a', 'approve-ia', 'approve2-ia')
    AND l2.log_timestamp>20100023061016
    AND l2.log_id>1611895
    AND REPLACE(l1.log_title, "_", " ")=a2.actor_name
    AND a2.actor_id=l2.log_actor
    AND a2.actor_name NOT IN ('Zache')
    AND l3.log_id IS NULL
GROUP BY l1.log_actor, year
SQL

Checking query status...
