Untitled query #88829

SQL

select
  */*,
  date_format(log_timestamp, "%Y-%m-%d %H:%i:%s") as timestamp*/


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

-- test
inner join user on user_name = replace(log_title, '_', ' ')
left join block_target on bt_user = user_id
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
where str_to_date(log_timestamp, "%Y%m%d%H%i%s") > '2020-01-01 00:00:00'


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



/*order by log_timestamp desc*/
limit 1000 ;
SQL

Checking query status...
