block list idea draft testing prototype

[ messing around with a {{database report}} version of this in my sandbox at https://en.wikipedia.org/wiki/User:A_smart_kitten/sandbox3 ]

SQL

use enwiki_p;
select DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') as 'timestamp', actor_name, log_action, user_name, user_editcount, comment_text, log_params
from logging
inner join user on REPLACE(log_title, '_', ' ') = user_name
inner join actor on log_actor = actor_id
inner join comment on log_comment_id = comment_id
where log_type = 'block'		/* get block logs only */ 
and user_editcount >= 100		/* filter to users with 100 edits or more */
order by log_timestamp desc		/* most recent blocks first */
limit 100;

SQL

Checking query status...