created/deleted articles by logged-out users

SQL

SELECT
    log_title AS article_title,
    actor_name AS creator_ip,
    rev_timestamp AS creation_date,
    log_timestamp AS deletion_date
FROM
    revision
JOIN
    actor ON revision.rev_actor = actor.actor_id
JOIN
    logging ON logging.log_title = revision.rev_page
WHERE
    actor_name LIKE '%.%'  -- to identify IP addresses
    AND logging.log_type = 'delete'
    AND logging.log_action = 'delete'
    AND revision.rev_parent_id = 0  -- only the first edit (creation)
    AND logging.log_namespace = 0  -- only articles (namespace 0)
ORDER BY
    deletion_date DESC
LIMIT 100;

SQL

Checking query status...