Page MenuHomePhabricator
Paste P149

(An Untitled Masterwork)
ActivePublic

Authored by stwalkerster on Aug 18 2017, 12:57 PM.
SELECT
sys.name,
sys.x,
sys.y,
sys.z
FROM (
SELECT
1 AS rgroup,
system,
number,
trip
FROM stwalkerster_ed_explore.waypoint
WHERE trip = 5 and special = 'v'
UNION ALL
SELECT
2,
w.system,
0,
t.id
FROM stwalkerster_ed_explore.trip t
INNER JOIN stwalkerster_ed_explore.waypoint w on t.to = w.id
WHERE t.id = 5
) wp
INNER JOIN stwalkerster_ed_explore.system sys ON sys.id = wp.system
ORDER BY wp.rgroup, wp.number

Event Timeline

stwalkerster created this object with visibility "Public (No Login Required)".