cycle_activities_view (view)

32 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, sub_sport, distance, avg_hr, max_hr, calories, avg_speed, training_effect, anaerobic_training_effect, heart_rate_zone_one_time, heart_rate_zone_two_time, heart_rate_zone_three_time, heart_rate_zone_four_time, heart_rate_zone_five_time, start_time (date), stop_time (date)

CREATE VIEW cycle_activities_view AS SELECT activities.activity_id AS activity_id, activities.name AS name, activities.description AS description, activities.sub_sport AS sub_sport, activities.start_time AS start_time, activities.stop_time AS stop_time, activities.elapsed_time AS elapsed_time, ROUND(activities.distance, 1) AS distance , cycle_activities.strokes AS strokes, activities.avg_hr AS avg_hr, activities.max_hr AS max_hr, activities.avg_rr AS avg_rr, activities.max_rr AS max_rr, activities.calories AS calories, ROUND(activities.avg_temperature, 1) AS avg_temperature , activities.avg_cadence AS avg_rpms, activities.max_cadence AS max_rpms, ROUND(activities.avg_speed, 1) AS avg_speed , ROUND(activities.max_speed, 1) AS max_speed , cycle_activities.vo2_max AS vo2_max, activities.training_effect AS training_effect, activities.anaerobic_training_effect AS anaerobic_training_effect, activities.hrz_1_time AS heart_rate_zone_one_time, activities.hrz_2_time AS heart_rate_zone_two_time, activities.hrz_3_time AS heart_rate_zone_three_time, activities.hrz_4_time AS heart_rate_zone_four_time, activities.hrz_5_time AS heart_rate_zone_five_time, "http://maps.google.com/?ie=UTF8&q=" || activities.start_lat || "," || activities.start_long || "&z=13" AS start_loc, "http://maps.google.com/?ie=UTF8&q=" || activities.stop_lat || "," || activities.stop_long || "&z=13" AS stop_loc 
FROM cycle_activities JOIN activities ON activities.activity_id = cycle_activities.activity_id ORDER BY activities.start_time DESC;