public static IEnumerable<MyChallenge> GetMyChallenges(string liveId)
{
return CloudWarsDB.Challenges.JoinGetTyped<MyChallenge>(
"DISTINCT Challenge.Id as ChallengeId, p1.Id as FromPlayer, p2.Id as ToPlayer, p1.DisplayName as FromPlayerName, p2.DisplayName as ToPlayerName, p1.Avatar as FromPlayerAvatar, p2.Avatar as ToPlayerAvatar ,p1.Wins as FromPlayerWins, p2.Wins as ToPlayerWins, p1.Losses as FromPlayerLosses, p2.Losses as ToPlayerLosses",
"Inner Join Player p1 on Challenge.Player1 = p1.Id Inner join Player p2 on Challenge.Player2 = p2.Id",
string.Format("p2.LiveId ='{0}'",liveId),
"ORDER By p1.Wins DESC",
new Dictionary<string, object>());
}