SELECT teams.team_id AS teams_team_id, teams.name AS teams_name, teams.home_night AS teams_home_night, teams.home_time AS teams_home_time, teams.comments AS teams_comments, teams.division_id AS teams_division_id, teams.club_id AS teams_club_id, teams.captain_id AS teams_captain_id, teams.cup AS teams_cup
FROM teams
WHERE ? = teams.division_id
| TEAMS_TEAM_ID | TEAMS_NAME | TEAMS_HOME_NIGHT | TEAMS_HOME_TIME | TEAMS_COMMENTS | TEAMS_DIVISION_ID | TEAMS_CLUB_ID | TEAMS_CAPTAIN_ID | TEAMS_CUP |
|---|---|---|---|---|---|---|---|---|
| 80 | Kingsbridge | 3 | 1830 | 6 | 6 | 572 | 1 | |
| 82 | Avon Vale | 4 | 1830 | 6 | 3 | 664 | 1 | |
| 83 | Cary Park | 1 | 1830 | 6 | 2 | 1144 | 1 | |
| 84 | Ivybridge | 3 | 1830 | 6 | 14 | 1072 | 1 | |
| 85 | Newton & Noss | 3 | 1830 | 6 | 5 | 1763 | 1 | |
| 86 | Newton Abbot | 3 | 1000 | 6 | 16 | 935 | 1 | |
| 87 | Torquay A | 4 | 1830 | 6 | 19 | 1773 | 1 | |
| 88 | Torquay B | 2 | 1830 | 6 | 19 | 1773 | 1 | |
| 89 | Totnes A | 1 | 1830 | 6 | 13 | 1337 | 1 | |
| 90 | Totnes B | 6 | 1400 | 6 | 13 | 1537 | 1 | |
| 91 | Totnes C | 4 | 1830 | 6 | 13 | 1337 | 1 |