SQL WMA age standards
Thursday, 6. December 2007, 21:09:47
SELECT f.distance, s.open_class_standard, f.type, f.gender, f.age, f.age_factor, SEC_TO_TIME(TIME_TO_SEC(s.open_class_standard)/f.age_factor), f2.age, f2.age_factor, SEC_TO_TIME(TIME_TO_SEC(s.open_class_standard)/f2.age_factor) FROM wma_age_factors f INNER JOIN wma_open_class_standards s ON f.distance=s.distance
INNER JOIN wma_age_factors f2 ON f.distance=f2.distance
WHERE f.age=32 and f2.age=40 AND f.distance LIKE "HM" AND f.gender=1 AND f2.gender=1 AND s.gender=1 and f.type LIKE "road" and f2.type LIKE "road"
INNER JOIN wma_age_factors f2 ON f.distance=f2.distance
WHERE f.age=32 and f2.age=40 AND f.distance LIKE "HM" AND f.gender=1 AND f2.gender=1 AND s.gender=1 and f.type LIKE "road" and f2.type LIKE "road"


