$eventQuery = <<<STRINGBLOCK

		SELECT
			events.event_key,
			league_affiliations.affiliation_key as league_key,
			sport_affiliations.affiliation_key as sport_key
		FROM
			events,
			affiliations as league_affiliations,
			affiliations_events as league_affiliations_events,
			affiliations as sport_affiliations,
			affiliations_events as sport_affiliations_events
		WHERE
			    league_affiliations.affiliation_key = '$theLeague'
			AND league_affiliations_events.affiliation_id = league_affiliations.id
			AND league_affiliations_events.event_id = events.id
			AND sport_affiliations.affiliation_type = 'sport'
			AND sport_affiliations_events.affiliation_id = sport_affiliations.id
			AND sport_affiliations_events.event_id = events.id
			AND events.start_date_time > '$earliest_date_time' AND events.start_date_time < '$latest_date_time'
		ORDER BY
			sport_affiliations.affiliation_key asc,
			league_affiliations.affiliation_key asc,
			events.start_date_time $theSortOrder
STRINGBLOCK;
		$eventQuery .= $this->model_library->sqlLimit(0, 500);