Select Map Options
 Show Markers
User:
Region(s):
System(s):

Query failed: SELECT r.region, r.root, r.route, r.systemName, r.banner, r.city, sys.tier, round(r.mileage, 2) AS total, round(COALESCE(cr.mileage, 0), 2) as clinched FROM routes AS r LEFT JOIN clinchedRoutes AS cr ON r.root = cr.route AND traveler = 'michih' LEFT JOIN systems as sys on r.systemName = sys.systemName LEFT JOIN connectedRouteRoots AS crr ON r.root = crr.root LEFT JOIN connectedRoutes as conr on crr.firstRoot = conr.firstRoot OR conr.firstRoot = r.root WHERE r.root IS NULLORDER BY sys.tier, conr.csvOrder, r.rootOrder;

RouteSystem Clinched (miles)Overall (miles)%