There seems to be an issue with TeamIDs 14+15 (Colts, Jags). For some reason the TeamIDs from any games played by the Jaguars both were 15. This made the Jags have too many games in 2016 season and each of their opponents have too few. I then managed to make this problem worse when trying to manually update values and now all of the Jags games are under the Colts ID. These need manually fixed (thinking add a temporary auto-increment key to use as primary key when changing each value manually).
SQL Query Showing the Error (TeamID 14 = Colts)
SELECT *
FROM TeamGame, Teams, Games
WHERE TeamGame.TeamID = Teams.TeamID
AND Teams.TeamID = 14
AND TeamGame.GameID = Games.GameID
AND Games.Date > '2016-04-20'
There seems to be an issue with TeamIDs 14+15 (Colts, Jags). For some reason the TeamIDs from any games played by the Jaguars both were 15. This made the Jags have too many games in 2016 season and each of their opponents have too few. I then managed to make this problem worse when trying to manually update values and now all of the Jags games are under the Colts ID. These need manually fixed (thinking add a temporary auto-increment key to use as primary key when changing each value manually).
SQL Query Showing the Error (TeamID 14 = Colts) SELECT * FROM TeamGame, Teams, Games WHERE TeamGame.TeamID = Teams.TeamID AND Teams.TeamID = 14 AND TeamGame.GameID = Games.GameID AND Games.Date > '2016-04-20'