block list idea draft testing prototype

SQL

use enwiki_p;
select log_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 not (												/* filter out ip addresses and ip ranges */
  IS_IPV4(SUBSTRING_INDEX(log_title, "/", 1))			/* (at least for now; it's harder to get the contrib count */
  or IS_IPV6(SUBSTRING_INDEX(log_title, "/", 1))		/* for them so i'm not worrying about them rn) */
)
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...
