Untitled query #48959

SQL

use fiwiki_p;
SELECT 
	l1.log_title,
    a1.actor_name,
    floor(l1.log_timestamp/1000000) 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
FROM 
	logging_userindex as l1,
    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>8603067 
    AND l1.log_timestamp>20170023061016
    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>20170023061016
    AND l2.log_id>8603067
    AND REPLACE(l1.log_title, "_", " ")=a2.actor_name
    AND a2.actor_id=l2.log_actor
GROUP BY l1.log_actor
SQL

Checking query status...
