Travel Mapping database update in progress. Some functionality might not work. Please try again in a few minutes if you notice problems.

22 View Associated Routes

Query failed: SELECT COUNT(*) as numDrivers, SUM(cr.clinched) as numClinched, @numUsers := ( SELECT COUNT(DISTINCT traveler) FROM clinchedOverallMileageByRegion ) as numUsers, ROUND(COUNT(*) / @numUsers * 100, 2) as drivenPct, ROUND(SUM(cr.clinched) / @numUsers * 100, 2) as clinchedPct, ROUND(SUM(cr.clinched) / COUNT(*) * 100, 2) as drivenClinchedPct, GROUP_CONCAT(cr.traveler SEPARATOR ', ') as drivers, GROUP_CONCAT(IF(cr.clinched = 1, cr.traveler, null) separator ', ') as clinchers, ROUND(AVG(cr.mileage), 2) as avgMileage, ROUND(r.mileage, 2) as totalMileage, ROUND(avg(cr.mileage) / r.mileage * 100, 2) as mileagePct FROM clinchedRoutes as cr JOIN routes as r ON cr.route = r.root WHERE cr.route = 'ga.ga022concol'

Route Stats