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 user.user_name, COUNT(logging.log_id) AS number_of_blocks FROM logging JOIN user ON logging.log_title=user.user_name WHERE logging.log_namespace=2 AND user.user_id=250642 AND logging.log_type='block' AND logging.log_action='block' GROUP BY user.user_name;
-- AND logging.log_title='Matthiasb'

SQL

Checking query status...