Untitled query #88906

SQL

select *
  
  from ( 
    select
      *,
      row_number() over (partition by user_id order by logging2.log_timestamp desc) as row_number
    
    from logging_userindex as logging2
    
    inner join actor_logging as actor2
      on actor2.actor_id = logging2.log_actor
    inner join comment_logging as comment2
      on comment2.comment_id = logging2.log_comment_id
    inner join user as user2
      on user2.user_name = replace(logging2.log_title, '_', ' ')
    left join block_target as block_target2
      on block_target2.bt_user = user2.user_id
    left join block as block2
      on block2.bl_target = block_target2.bt_id
    
    where logging2.log_timestamp > '2024'
    and block2.bl_id is null
    and logging2.log_type = 'block'
    and logging2.log_action regexp '^(re)?block$'
    and logging2.log_params not like '%noautoblock%'
    and convert(comment2.comment_text using utf8) regexp 'spam|promo|advert'
  ) as query3
  
  where query3.row_number = 1
  order by query3.log_timestamp desc;
SQL

Checking query status...
