SQL
AخA
WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'), (-1, 'Special:'), (0, '(main)'), (1, 'Talk:'), (2, 'User:'), (3, 'User talk:'), (4,
'Wikipedia:'), (5, 'Wikipedia talk:'), (6, ':File:'), (7, 'File talk:'), (8, 'MediaWiki:'), (9, 'MediaWiki talk:'), (10, 'Template:'),
(11, 'Template talk:'), (12, 'Help:'), (13, 'Help talk:'), (14, ':Category:'), (15, 'Category talk:'), (100, 'Portal:'), (101,
'Portal talk:'), (118, 'Draft:'), (119, 'Draft talk:'), (126, 'MOS:'), (127, 'MOS talk:'), (710, 'TimedText:'), (711, 'TimedText talk:'),
(828, 'Module:'), (829, 'Module talk:'))
SELECT DISTINCT ns_s AS 'namespace',
COUNT(*) OVER (PARTITION BY log_namespace) AS 'count',
COUNT(*) OVER (PARTITION BY log_namespace)*100 / COUNT(*) OVER () AS 'percent'
FROM logging
JOIN comment_logging ON comment_id = log_comment_id
LEFT JOIN ns ON ns_n = log_namespace
WHERE log_type = 'delete'
AND log_action = 'delete'
AND log_timestamp >= '2024'
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.