Outlier delete/revision log entries

delete/revision logging table entries that don't conform to a known format.

See also: Historical delete/revision log entries (https://quarry.wmcloud.org/query/77175)

SQL

SELECT
	*
FROM `logging_logindex`
LEFT JOIN `actor_logging` ON `actor_id` = `log_actor`
LEFT JOIN `comment_logging` ON `log_comment_id` = `comment_id`
WHERE
	`log_type` = "delete"
    AND `log_action` = "revision"
    AND NOT `log_params` LIKE "oldid%"
    AND NOT `log_params` LIKE "revision%"
    AND NOT `log_params` LIKE "a:%"
    -- non-conformant
    AND NOT `log_params` LIKE "artimestamp%"
ORDER BY `log_timestamp` ASC
LIMIT 10

-- artimestamp entries do not have revision numbers. Uselss to try and get information from.

SQL

Checking query status...