Authored By

	stwalkerster
	Aug 18 2017, 12:57 PM

Size

552 B

Referenced Files

None

Subscribers

None

View Options

	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

File Metadata