SET @actor_id = (

    SELECT actor_id

    FROM user

    LEFT JOIN actor ON user_id = actor_user

    WHERE user_name = '銀河市長'

    LIMIT 1

);

SELECT @actor_id;

​

SELECT rc1.rc_timestamp, rc1.rc_title, rc1.rc_this_oldid, rc1.rc_actor, rc2.rc_actor

FROM recentchanges AS rc1

LEFT JOIN recentchanges AS rc2

    ON rc2.rc_type = 0

    AND rc2.rc_actor = @actor_id

    AND rc1.rc_cur_id = rc2.rc_cur_id

WHERE rc1.rc_type = 1

    AND rc1.rc_namespace = 0

    AND rc1.rc_patrolled != 2

    AND rc2.rc_actor IS NOT NULL

    AND rc1.rc_actor != @actor_id

GROUP BY rc1.rc_cur_id