Here-> select teamid, teamname from teams2008 where Teamnameshort = "Chesterfield" and sport="Football" limit 1
Note: All fixtures with a pale yellow background are in progress and are not confirmed results.
KO | Home Team | Score | Away Team | Competition | ||
---|---|---|---|---|---|---|
Tue 20 Dec 22 | 19:45 | Chesterfield | 1 - 3 | Coalville Town | ||