climbing_activities_view (view)

✎ View and edit SQL

This data as json

0 records

CREATE VIEW climbing_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, activities.moving_time AS moving_time, activities.avg_hr AS avg_hr, activities.max_hr AS max_hr, activities.calories AS calories, activities.ascent AS ascent, activities.descent AS descent, climbing_activities.total_routes AS total_routes, 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 
FROM climbing_activities JOIN activities ON activities.activity_id = climbing_activities.activity_id ORDER BY activities.start_time DESC;