Untitled query #48959

SQL

use fiwiki_p;
SELECT 
	l1.log_title,
    a1.actor_name,
    l1.log_timestamp,
    l1.log_params, 
    count(distinct(l1.log_id)) as c1,
    count(distinct(l2.log_id)) as c2    
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>10603067 
    AND l1.log_timestamp>20200023061016
    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>20200023061016
    AND l1.log_id>10603067
    AND l1.log_title=a2.actor_name
    AND a2.actor_id=l2.log_actor
GROUP BY l1.log_title
SQL

Checking query status...
