SQL
AخA
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:%';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.