Autoreviewer edits

SQL

use ruwiki_p;
SELECT (prepat <> "no") AND (pat <> "auto") as bad, B.*
FROM
(SELECT CASE WHEN rev_parent_id = 0 THEN "new"
    	 WHEN f1.fr_timestamp IS NULL THEN "no"
         ELSE "yes"
    END as prepat,
    CASE WHEN f2.fr_flags IS NULL THEN "no"
    	 WHEN f2.fr_flags LIKE "%auto%" THEN "auto"
         ELSE "manual"
    END as pat,
#    rev_timestamp-f1.fr_timestamp as delta,
    user_name, rev_id, rev_timestamp, page_title
FROM
(SELECT log_title, MAX(log_timestamp) as time
 FROM logging
 WHERE (log_type = "rights") AND (log_action = "rights")
           AND ((log_params LIKE "%newgroups%autoeditor%") OR (log_params LIKE "%\n%autoeditor%"))
 GROUP BY log_title) as A
INNER JOIN user
ON A.log_title = user_name
INNER JOIN user_groups
ON (user_id = ug_user) AND (ug_group = "autoeditor")
INNER JOIN actor
ON (user_id = actor_user)
INNER JOIN revision
 ON (rev_actor = actor_id) AND (rev_timestamp > "20191121") AND (rev_timestamp > time)
INNER JOIN page
ON (rev_page = page_id) AND (page_namespace IN (0, 6, 10, 14, 100, 828))
LEFT JOIN flaggedrevs as f1
ON (rev_parent_id = f1.fr_rev_id) AND (rev_timestamp > f1.fr_timestamp)
LEFT JOIN flaggedrevs as f2
ON (rev_id = f2.fr_rev_id)) as B
SQL

Checking query status...
