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

​