Untitled query #42365

SQL

use dewiki_p;

SELECT t.*, logging_userindex.log_actor, actor_name FROM (
select user_id, 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") LEFT JOIN logging ON user_name=log_title AND log_type="rights" 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_id >= 3283584 group by user_id 
) as t, logging_userindex, actor_logging WHERE log_actor=actor_id AND log_title=replace(user_name, " ", "_") AND log_namespace=2 and log_type="rights" 
LIMIT 1;
SQL

Checking query status...
