(An Untitled Masterwork)
ActivePublic
Actions

Authored by stwalkerster on Aug 18 2017, 12:57 PM.

Tags

None

Referenced Files

	F29149:
	Aug 18 2017, 12:57 PM

Subscribers

None

	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

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

(An Untitled Masterwork)ActivePublicActions