Fixtures 2017/18

NEW: Click on a team name in the fixture list to see that team's stats.

Welcome to the fixture list for Hanney B. This fixture list is generated automatically from the grid and matches are subject to rearrangement.

Print friendly version

Error in query: SELECT fixture_grid.week AS week, DATE_FORMAT(DATE_ADD(fixture_grid.week, INTERVAL home_team.date_offset DAY), '%d-%b-%y') AS scheduled, CASE DAYOFWEEK(DATE_ADD(fixture_grid.week, INTERVAL home_team.date_offset DAY)) WHEN 2 THEN 'Mon' WHEN 3 THEN 'Tue' WHEN 4 THEN 'Wed' WHEN 5 THEN 'Thu' WHEN 6 THEN 'Fri' END AS day, IF( = 'Hanney B','H','A') AS venue, IF( = 'Hanney B',, AS opponent FROM FIXTURE_GRID AS fixture_grid INNER JOIN TEAM AS home_team ON fixture_grid.home = home_team.number INNER JOIN TEAM AS away_team ON fixture_grid.away = away_team.number WHERE ( = 'Hanney B' OR = 'Hanney B') AND home_team.division = AND away_team.division = ORDER BY DATE_ADD(fixture_grid.week, INTERVAL home_team.date_offset DAY). You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND away_team.division = ORDER BY DATE_ADD(fixture_grid.week, INTERVAL home_' at line 17