Invalid query : select franchise, ttName, ttCity as city, tttID, sum(gsPassYards) as PassYards, sum(gsRushYards) as RushYards, sum(gsPassYards)+sum(gsRushYards) as TotalYards from standings, game_stats where gslUID = 1 AND gslUID = ttlUID AND franchise = gsfranchise AND ttsUID = gsSeason AND gPlayoff = 1 group by gsfranchise order by avgyds desc, ttCity asc