Close
- Multimedia
- Around the League
SELECT DISTINCT(divisions.id) as division_id,
conferences.id as conf_id, shortname, divisname, conference_name as conf_name
FROM divisions, conferences, conferences_divisions
WHERE conferences.id = conferences_divisions.conference_id
AND divisions.id = conferences_divisions.division_id
AND conferences_divisions.season_id = '234'
ORDER BY divisions.sort_order,