SELECT divisions.division_id AS divisions_division_id, divisions.name AS divisions_name, divisions.mixed_ladies_gents AS divisions_mixed_ladies_gents, divisions.comments AS divisions_comments
FROM divisions
| DIVISIONS_DIVISION_ID | DIVISIONS_NAME | DIVISIONS_MIXED_LADIES_GENTS | DIVISIONS_COMMENTS |
|---|---|---|---|
| 2 | Mixed Division 1 | 0 | |
| 3 | Mens Division 1 | 2 | |
| 4 | Ladies Division | 1 | |
| 6 | Cup | 3 | |
| 7 | Mixed Division 2 | 0 | |
| 8 | Mens Division 2 | 2 | |
| 9 | Vets Division | 0 |