Skip to content

Instantly share code, notes, and snippets.

@stwalkerster
Created December 19, 2016 13:20
Show Gist options
  • Save stwalkerster/6c0792714db813486fb0fee18c60b330 to your computer and use it in GitHub Desktop.
Save stwalkerster/6c0792714db813486fb0fee18c60b330 to your computer and use it in GitHub Desktop.
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