Total count of English Wikipedia revision deletions

SQL

SELECT
	COUNT(*) AS "Total",
    -- entries which don't have a revision ID
    COUNT(IF(
      `log_params` LIKE "artimestamp%"
     	OR `log_params` LIKE "fileid%"
     	OR `log_params` LIKE "archive%"
     	OR `log_params` LIKE "oldimage%"
     	OR `log_params` LIKE "filearchive%"
    , 1, NULL)) AS `unusable`,
    -- entries which have a revision ID, but where one can't determine if the revision was hidden or shown
    COUNT(IF(`log_params` LIKE "oldid%", 1, NULL)) AS `really old`,
    -- entries which aren't serialized and instead use line breaks as delimiters
    COUNT(IF(`log_params` LIKE "revision%", 1, NULL)) AS `old-ish`,
    -- entries which are PHP serialize()d
    COUNT(IF(`log_params` LIKE "a:4%", 1, NULL)) AS `serialized`
FROM `logging_logindex`
WHERE `log_type` = "delete" AND `log_action` = "revision"
SQL

Checking query status...
