session-waypoints.sql

select sys.name, sys.x, sys.y, sys.z
from stwalkerster_ed_explore.waypoint w
  inner join stwalkerster_ed_explore.trip t on t.id = w.trip
  inner join stwalkerster_ed_explore.session s on s.trip = t.id
  inner join stwalkerster_ed_explore.waypoint nwp on s.nextwaypoint = nwp.id
  inner join stwalkerster_ed_explore.system sys on w.system = sys.id
where w.sequence >= nwp.sequence
  and w.special in ('v','a')
  and s.id = %d
order by w.sequence