dewiki: count block log events for a given user

SQL

USE dewiki_p;

-- SELECT log_title, COUNT(log_title) AS number_of_blocks_and_reblocks FROM logging WHERE log_namespace=2 AND log_title IN ('MisterSynergy','WolfgangRieger') AND log_type='block' AND log_action!='unblock' GROUP BY log_title ORDER BY number_of_blocks_and_reblocks DESC;
SELECT log_id, log_title FROM logging WHERE log_namespace=2 AND log_title IN (SELECT user_name FROM user WHERE user_id IN (1578693, 1578258, 1499521, 497744, 499648, 499483)) AND log_type='block' AND log_action='block';

SQL

Checking query status...