Recent category changes

SQL

select
	date_format(rc_timestamp, '%Y-%m-%d %H:%i:%s') as timestamp,
    actor_name as user,
    page_title as category_member_title,
    page_namespace as category_member_namespace,
    if(regexp_replace(rc_params, '.*s:5:"added";b:(.);.*', '\\1') = '1', 'added', 'removed') as action,
    rc_title as category_title
from recentchanges

left join actor on actor_id = rc_actor
left join page as category_member on page_id = rc_cur_id

where rc_type = 6
-- add category here, without "Category:" prefix and with underscores, to only show changes to a particular category
-- and rc_title = 'Category_name_here'
order by rc_timestamp desc
limit 100;
SQL

Checking query status...
