Untitled query #88829

SQL

select
  count(*)/*,
  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


-- filter down to the block log, and filter out unblock-log-events
where 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 > '20240101000000'


-- try and find users blocked for spam/advertising/promotion
/*and convert(comment_text using utf8) regexp 'spam|promo|advert'*/
and (
  comment_text like '%spam%' collate utf8mb4_unicode_ci
  or comment_text like '%advert%' collate utf8mb4_unicode_ci
  or comment_text like '%promo%' collate utf8mb4_unicode_ci
)



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

Checking query status...
