SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 23 AND a.sex ='Male' ORDER BY a.time
SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 23 AND a.sex ='Female' ORDER BY a.time
SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 32 AND a.sex ='Male' ORDER BY a.time
SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 32 AND a.sex ='Female' ORDER BY a.time
SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 24 AND a.sex ='Male' ORDER BY a.time
SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 24 AND a.sex ='Female' ORDER BY a.time
SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 31 AND a.sex ='Male' ORDER BY a.time
SELECT a.*, c.id as category_id, c.title AS category_title FROM #__comprofiler_racedata AS a LEFT JOIN #__categories AS c ON c.id = a.catid WHERE a.raceyear = 0 AND a.catid = 31 AND a.sex ='Female' ORDER BY a.time

Racers List

All | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 0
Print Certificates

42km Full Marathon

Male
Female

42km Tricycle Marathon

Male
Female

21km Half Marathon

Male
Female

21km Wheelchair Marathon

Male
Female
Find us on twitter

Our 2016 Sponsors & Partners