Untitled query #37350

SQL

use ruwiki_p;
SELECT rev_id, rev_timestamp, fr_timestamp, fr_flags
FROM (SELECT rev_id, rev_timestamp
     FROM (SELECT rev_id, rev_parent_id, rev_timestamp
          FROM revision
           WHERE (rev_actor = ANY(SELECT actor_id FROM actor WHERE actor_name = "VladXsmall")) AND (rev_timestamp > "20190901000000")) as A
     INNER JOIN flaggedrevs
     ON (A.rev_parent_id = fr_rev_id) AND (A.rev_timestamp > fr_timestamp)) as B
LEFT JOIN flaggedrevs
ON (B.rev_id = fr_rev_id)
WHERE (fr_flags IS NULL) OR (fr_flags NOT LIKE "%auto%")
SQL

Checking query status...
