select a.Rank_a AS Rank,
a.Rank_a - b.Rank_a AS RankDif,
a.Members_a AS Members,
CASE WHEN x.SubTeamName IS NULL THEN x.SubTeamTag ELSE x.SubTeamName AS SubTeamName,
a.Members_a - b.Members_a AS MemberDif,
a.Keys_a AS `Keys`,
a.Keys_a - b.Keys_a KeyDif,
a.Clicks_a AS Clicks,
a.Clicks_a - b.Clicks_a AS ClickDif from
-- Query voor stats vandaag
(select a.Rank Rank_a, a.StatID StatID_a, a.SubTeamID SubTeamID_a, a.Members Members_a, a.`Keys` Keys_a, a.Clicks Clicks_a from wp2_subteamstats a, (select t.StatID from wp2_stats t order by t.StatID DESC LIMIT 0,1) b
where a.StatID = b.StatID) a,
-- Query voor de stats van gisteren, om de vergelijking en vooruitgang te berekenen
(select a.Rank Rank_a, a.StatID StatID_a, a.SubTeamID SubTeamID_a, a.Members Members_a, a.`Keys` Keys_a, a.Clicks Clicks_a from wp2_subteamstats a, (select t.StatID from wp2_stats t order by t.StatID DESC LIMIT 1,1) b
where a.StatID = b.StatID) b, wp2_subteams x
where a.SubTeamID_a = b.SubTeamID_a AND x.SubTeamID = a.SubTeamID_a AND x.SubTeamID = b.SubTeamID_a ORDER BY a.Rank_a ASC