Untitled query #55413

SQL

        WITH bots AS (
            SELECT user_id
            FROM user
            JOIN user_groups ON user_id = ug_user
            WHERE ug_group = 'bot'
        )

        SELECT page_namespace, page_title, MAX(rev_timestamp) AS rev_timestamp
        FROM page
                 LEFT JOIN revision ON rev_page = page_id
                 LEFT JOIN actor_revision ON actor_id = rev_actor
        WHERE page_namespace = 118
          AND page_is_redirect = 0
          AND (actor_user IS NULL OR actor_user NOT IN (SELECT * FROM bots))
        GROUP BY page_id
        HAVING MAX(rev_timestamp) < DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')

        UNION

        SELECT page_namespace, page_title, MAX(rev_timestamp) AS rev_timestamp
        FROM page
                 LEFT JOIN revision ON rev_page = page_id
                 LEFT JOIN actor_revision ON actor_id = rev_actor
                 JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title = 'AfC_submission'
        WHERE page_namespace = 2
          AND page_is_redirect = 0
          AND (actor_user IS NULL OR actor_user NOT IN (SELECT * FROM bots))
        GROUP BY page_id
        HAVING MAX(rev_timestamp) < DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')
SQL

Checking query status...
