Skip navigation.

My pasteblog

This is not my Zettelkasten but a durable .bash_history

SQL WMA age standards

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"

one-page webserver with netcatWMA ageclass data in yml format

Write a comment

You must be logged in to write a comment. If you're not a registered member, please sign up.

December 2009
S M T W T F S
November 2009January 2010
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31