SELECT
  competition.name,
  swimsession.start_date,
  discipline,
  heat_number,
  lane,
  first_name,
  last_name,
  entry_time

FROM competitions_heat
  JOIN competitions_swimevent AS swimevent ON competitions_heat.event_id = swimevent.id
  JOIN competitions_swimstyle AS swimstyle ON swimevent.style_id = swimstyle.id
  JOIN competitions_swimsession AS swimsession ON swimevent.session_id = swimsession.id
  JOIN competitions_swimresult AS swimresult ON competitions_heat.id = swimresult.heat_id
  JOIN core_competition AS competition ON swimevent.imported_from_id = competition.id
  JOIN core_athlete athlete on swimresult.athlete_id = athlete.id
WHERE competition.id = 207
ORDER BY swimsession.start_date, heat_number