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 | ||
---|---|---|---|---|---|---|
Sat 14 Oct 23 | 15:00 | Chesterfield | 5 - 0 | Kettering Town | ||
Tue 19 Dec 23 | 19:45 | Long Eaton United | 2 - 0 | Chesterfield | ||