Untitled query #88908

SQL

select
    user1.user_id as user_id,
    logging1.log_timestamp as log_timestamp,
    actor1.actor_name as actor_name,
    logging1.log_action as log_action,
    comment1.comment_text as comment_text,
    logging1.log_params as log_params
  
  from logging_logindex as logging1
  
  inner join actor_logging as actor1
    on actor1.actor_id = logging1.log_actor
  inner join comment_logging as comment1
    on comment1.comment_id = logging1.log_comment_id
  inner join user as user1
    on user1.user_name = replace(logging1.log_title, '_', ' ')
  
  where logging1.log_timestamp > '2024'
  and logging1.log_type = 'block'
  
  -- searching for both unblocks *and* new blocks:
  -- if there is no unblock action (ie., because the block was time-limited), then
  -- searching for unblock actions alone could potentially return an unblock summary
  -- from a potential *different future block* (which could be for an unrelated reason).
  -- therefore, if there's a `block` event before an `unblock` event, we know to filter
  -- that unblock event out.
  and logging1.log_action regexp '^(un)?block$'
SQL

Checking query status...
