Untitled query #89047

SQL

select rc_new_len - rc_old_len from recentchanges where rc_this_oldid=1260926855 and rc_type=0;

select
  date_format(rc1.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 rc1.rc_params like '%"added";b:0;%' then 'removed from'
    when rc1.rc_params like '%"added";b:1;%' then 'added to'
    else 'unknown action'
  end as 'cat action',
  concat("Category:", replace(rc1.rc_title, "_", " ")) as 'category',
  rc1.rc_params,
  rc1.rc_namespace,
  rc1.*,
  page.*,
  rc2.*,
  rc2.rc_new_len - rc2.rc_old_len
  
from recentchanges_userindex as rc1

inner join page on rc_cur_id = page_id
inner join actor_recentchanges on actor_id = rc_actor


inner join recentchanges as rc2
  on rc2.rc_this_oldid = rc1.rc_this_oldid
  and rc2.rc_type = 0

where rc1.rc_type = 6
and page_namespace = 3
and rc1.rc_title regexp "^(Requests_for_unblock(_awaiting_response_from_the_blocked_user)?|Unblock_on_hold)$"
and rc2.rc_new_len - rc2.rc_old_len <= -100

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

order by rc1.rc_timestamp desc;
SQL

Checking query status...
