Untitled query #88871

SQL

select *
from (
  select * from logging_userindex
  
  inner join comment_logging on comment_id = log_comment_id
  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
  
  where log_timestamp > '2024'
  and bl_id is null
  and log_type = 'block'
  and log_action regexp '^(re)?block$'
  and log_params not like '%noautoblock%' 
  and convert(comment_text using utf8) regexp 'spam|promo|advert'
  order by log_timestamp desc
) as query1/*
inner join (
  
) as query2 on */
SQL

Checking query status...
