'Given a username, return an URL path.'

def resolve_unclaimed(self):

    rec = self.db.one(u'\n                                                SELECT    platform,    user_name\n                                                        FROM    elsewhere\n                                                    WHERE    participant    =    %s\n                                ', (self.username,))
    return (rec and (u'/on/%s/%s/' % (rec.platform, rec.user_name)))
