Untitled query #42365

SQL

use dewiki_p;

SELECT * FROM (
select 
	user_name, 
    datediff(now(), str_to_date(user_registration, "%Y%m%d%H%i%S")) as age, 
    user_editcount from user LEFT JOIN user_groups ON user_id=ug_user AND ug_group IN ("editor", "bot") 
    LEFT JOIN user_former_groups ON user_id=ufg_user AND ufg_group IN ("editor", "bot")
where 
	(ufg_user IS NOT NULL OR ug_user IS NOT NULL) 
    AND datediff(now(), str_to_date(user_registration, "%Y%m%d%H%i%S")) < 180  
    and user_editcount > 300 
    and user_editcount > 60 
    and user_id >= 3283584 
group by user_id
)
AS t 
LEFT JOIN (SELECT log_title, log_timestamp, log_params, actor_name FROM logging_userindex, actor_logging WHERE log_actor=actor_id AND  log_namespace=2 AND log_type="rights" AND log_params LIKE "%newgroups%editor%" AND log_params NOT LIKE "%oldgroups%editor%newgroups%" AND log_id > 116487685 GROUP BY log_title) as tt
ON log_title=replace(user_name, " ", "_")
SQL

Checking query status...
