Untitled query #55413

SQL

         SELECT page_namespace, page_title, rev_timestamp
         FROM page
                  LEFT JOIN revision ON rev_page = page_id AND rev_timestamp > DATE_FORMAT(
                         UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 2 DAY, '%Y%m%d%H%i%S')
                  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 user_id
             FROM user
                      JOIN user_groups ON user_id = ug_user
             WHERE ug_group = 'bot'
         ))
         GROUP BY page_id
         HAVING COUNT(actor_id) = 0
 
         UNION
 
         SELECT page_namespace, page_title, rev_timestamp
         FROM page
                  LEFT JOIN revision ON rev_page = page_id AND rev_timestamp > DATE_FORMAT(
                         UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 2 DAY, '%Y%m%d%H%i%S')
                  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 user_id
             FROM user
                      JOIN user_groups ON user_id = ug_user
             WHERE ug_group = 'bot'
         ))
         GROUP BY page_id
         HAVING COUNT(actor_id) = 0
SQL

Checking query status...
