USE zhwiki_p;

SELECT rc_actor, actor_name, actor_user,

    up_value AS `nickname`

FROM (

  SELECT rc_actor, actor_name, actor_user,

      up_value AS `fancysig`

  FROM (

    SELECT rc_actor, actor_name, actor_user

    FROM (

      SELECT DISTINCT rc_actor

      FROM recentchanges

      WHERE rc_namespace = 4 OR rc_namespace % 2 = 1

      ORDER BY rc_timestamp DESC

    ) temp1

    LEFT JOIN actor ON rc_actor = actor_id

    WHERE actor_user IS NOT NULL

  ) temp2

  LEFT JOIN user_properties  ON actor_user = up_user AND up_property = 'fancysig'

  WHERE up_value IS NOT NULL

) temp3

LEFT JOIN user_properties AS up1 ON actor_user = up_user AND up_property = 'nickname'

WHERE up1.up_value IS NOT NULL AND up1.up_value != ''