Untitled query #88867

SQL

select
  *


from logging_userindex
inner join comment_logging on comment_id = log_comment_id
inner join actor_logging on actor_id = log_actor

-- test
left join block_target on bt_user_text = replace(log_title, '_', ' ')
left join block on bl_target = bt_id

-- (attempt to) filter out currently-blocked users
where bl_id is null

-- filter down to the block log, and filter out unblock-log-events
and log_type = 'block'
and log_action regexp '^(re)?block$'

-- temporarily while i'm testing this, let's only grab blocks from the start of this year
and log_timestamp > '2024'


-- try and find users blocked for spam/advertising/promotion
and convert(comment_text using utf8) regexp 'spam|promo|advert';
SQL

Checking query status...
