2024 Userspace G11 deletions by subpage

Deletions in userspace in 2024 that mention "G11", by whether they were the main user page, a subpage, or specifically a /sandbox subpage.

For [[Wikipedia:Username policy/ORGNAME/G11 in sandboxes RFC]].

SQL

SELECT COUNT(*) AS 'total',
       SUM(log_title NOT LIKE '%/%') AS 'base userpage',
       SUM(log_title NOT LIKE '%/%') * 100 / COUNT(*) AS 'base userpage percent',
       SUM(log_title LIKE '%/sandbox') AS 'sandbox',
       SUM(log_title LIKE '%/sandbox') * 100 / COUNT(*) AS 'sandbox percent',
       SUM(log_title LIKE '%/%' AND log_title NOT LIKE '%/sandbox') AS 'other subpage',
       SUM(log_title LIKE '%/%' AND log_title NOT LIKE '%/sandbox') * 100 / COUNT(*) AS 'other subpage percent'
FROM logging
JOIN comment_logging ON comment_id = log_comment_id
WHERE log_type = 'delete'
  AND log_action = 'delete'
  AND log_timestamp >= '2024'
  AND log_namespace = 2 -- user:
  AND (comment_text LIKE '%g11%' OR comment_text LIKE '%G11%')
  AND comment_text NOT LIKE '[[WP:CSD#G8|G8]]: Deleted together with the associated page with reason:%';

SQL

Checking query status...