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