Untitled query #88944

SQL

select
  date_format(rc_timestamp, '%Y-%m-%d %H:%i:%s') as 'timestamp',
  concat("User talk:", replace(page_title, "_", " ")) as 'user talk page',
  actor_name as 'this person',
  case
    when rc_params like '%"added";b:0;%' then 'removed from'
    when rc_params like '%"added";b:1;%' then 'added to'
    else 'unknown action'
  end as 'cat action',
  concat("Category:", replace(rc_title, "_", " ")) as 'category',
  rc_params
from recentchanges_userindex
inner join page on rc_cur_id = page_id
inner join actor_recentchanges on actor_id = rc_actor
where rc_type = 6
and page_namespace = 3
and rc_title regexp "^(Requests_for_unblock(_awaiting_response_from_the_blocked_user)?|Unblock_on_hold)$"

-- temp for testing
and rc_params like '%"added";b:0;%'

order by rc_timestamp desc;
SQL

Checking query status...
