Untitled query #39610

SQL

use ruwiki_p;
SELECT fr_flags, log_page, log_namespace, log_timestamp, user_name, ug_group, revid, newtitle
FROM 
( SELECT log_page, log_namespace, log_timestamp, log_actor, substring_index(substring_index(log_params,':',-1),';',1) as revid, newtitle
  FROM
  ( SELECT *, substring_index(substring_index(log_params,'"',4),'"',-1) as newtitle
    FROM logging
    WHERE (log_type="move") AND (log_namespace NOT IN (0, 6, 10, 14, 100, 828)) AND (log_timestamp > "20190101")) as A
  WHERE (newtitle NOT LIKE "%:%") OR (newtitle LIKE "Шаблон:%")) as B
INNER JOIN
(SELECT *
 FROM
  (SELECT log_title, MAX(log_timestamp) as time
 FROM logging
 WHERE (log_type = "rights") AND (log_action = "rights")
           AND ((log_params LIKE "%newgroups%editor%") OR (log_params LIKE "%\n%editor%"))
 GROUP BY log_title) as U
INNER JOIN user
ON U.log_title = user_name
INNER JOIN user_groups
ON (user_id = ug_user) AND ((ug_group = "editor") OR (ug_group = "autoeditor"))
INNER JOIN actor
 ON (user_id = actor_user)) as V
ON (log_actor = actor_id) AND (log_timestamp > time)
INNER JOIN revision
ON (revid = rev_id) AND (rev_deleted = 0)
LEFT JOIN flaggedrevs
ON (fr_rev_id = revid)
SQL

Checking query status...
