Here-> select teamid, teamname from teams2008 where Teamnameshort = "Colne" and sport="Football" limit 1
Note: All fixtures with a pale yellow background are in progress and are not confirmed results.