Ion.RangeSlider - test











Date from - to
Distance in km
Altimeters in meters
Show on map
Google Maps
gran fondo bike tour stage race multi-day event others          Road bike MTB
1599 granfondos / events selected

selectVanaf - -- SELECT * FROM `EN_Cyclokalender` WHERE datumtocht >= '2019-11-18' AND datumtocht <= '2020-12-31' AND actueleTocht = 'Y' AND lat > -99 and lat < 99 AND cycloId in (SELECT DISTINCT cycloId FROM `EN_Cyclokalender_kmhm` where km >= 0 AND km <= 9999 AND hm >= 0 AND hm <= 99999 AND jaar >= 2019) AND fiets = 'Road' AND lokaal = 'N' AND categorie in ('Gran fondo', 'Sportive', 'Stage race', 'Tour', 'Cycling trip', 'Ultra', 'Time trial', 'Gravel', '24 hour', 'Retro race', 'Charity', '?') ORDER BY `datumtocht`, `titel` ASC limit 99999


© C Y C L O C A L E N D A R (2014 - 2019)