SQL
AخA
(SELECT 'CSD' AS `type`, COUNT(log_id) AS `count`
FROM logging_userindex
WHERE log_type = 'delete'
AND log_user = 54890
AND log_comment RLIKE "WP:CSD")
UNION
(SELECT 'PROD' AS `type`, COUNT(log_id) AS `count`
FROM logging_userindex
WHERE log_type = 'delete'
AND log_user = 54890
AND log_comment RLIKE "WP:PROD")
UNION
(SELECT 'AfD' AS `type`, COUNT(log_id) AS `count`
FROM logging_userindex
WHERE log_type = 'delete'
AND log_user = 54890
AND log_comment RLIKE "Articles for deletion")
UNION
(SELECT 'TfD' AS `type`, COUNT(log_id) AS `count`
FROM logging_userindex
WHERE log_type = 'delete'
AND log_user = 54890
AND log_comment RLIKE "Templates for discussion")
UNION
(SELECT 'MfD' AS `type`, COUNT(log_id) AS `count`
FROM logging_userindex
WHERE log_type = 'delete'
AND log_user = 54890
AND log_comment RLIKE "Miscellany for deletion")
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.