SELECT actor_user, actor_name, up2.up_value AS `nickname`

FROM recentchanges

LEFT JOIN actor ON rc_actor = actor_id

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

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

WHERE (rc_namespace = 4 OR rc_namespace % 2 = 1)

    AND rc_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 7 DAY), '%Y%m%d%H%i%s')

    AND actor_user IS NOT NULL

    AND up1.up_value IS NOT NULL

    AND up2.up_value IS NOT NULL

GROUP BY actor_user

ORDER BY rc_timestamp DESC