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 user_id, user_name FROM user WHERE user_name='Matthiasb';
SELECT log_title, COUNT(log_id) AS number_of_blocks 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' GROUP BY log_title;
-- AND logging.log_title='Matthiasb'

SQL

Checking query status...