Untitled query #83864

SQL

SELECT COUNT(DISTINCT log_title) AS count
FROM logging
WHERE log_namespace = 0
  AND log_type = 'delete'
  AND YEAR(log_timestamp) = 2014
  AND log_title IN (
    SELECT log_title
    FROM logging
    JOIN actor ON log_actor = actor_id
    WHERE log_namespace = 0
      AND log_type = 'create'
      AND actor_name REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$'
  )
  AND log_title NOT IN (
    SELECT page_title
    FROM page
    WHERE page_namespace = 0
);


SELECT COUNT(DISTINCT log_title) AS count
FROM logging
WHERE log_namespace = 0
  AND log_type = 'delete'
  AND YEAR(log_timestamp) = 2014
    AND log_title NOT IN (
    SELECT page_title
    FROM page
    WHERE page_namespace = 0
);
SQL

Checking query status...
