dewiki: count block log events for a given user

SQL

-- 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';

DESCRIBE logging;
SELECT * FROM logging WHERE log_title='Reiner_Stoppok' LIMIT 1;
DESCRIBE logging_userindex;
DESCRIBE logging_logindex;

-- SELECT * FROM logging_userindex WHERE log_namespace=2 AND log_title='WolfgangRieger';
SQL

Checking query status...
