Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment