paddle_activities_view (view)
This data as json
0 records
CREATE VIEW paddle_activities_view AS SELECT activities.activity_id AS activity_id, activities.name AS name, activities.description AS description, activities.sport AS sport, 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 , paddle_activities.strokes AS strokes, ROUND(paddle_activities.avg_stroke_distance, 1) AS avg_stroke_distance , activities.avg_cadence AS avg_cadence, activities.max_cadence AS max_cadence, activities.avg_hr AS avg_hr, activities.max_hr AS max_hr, ROUND(activities.calories, 1) AS calories , ROUND(activities.avg_temperature, 1) AS avg_temperature , ROUND(activities.avg_speed, 1) AS avg_speed , ROUND(activities.max_speed, 1) AS max_speed , activities.training_effect AS training_effect, activities.anaerobic_training_effect AS anaerobic_training_effect, "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 paddle_activities JOIN activities ON activities.activity_id = paddle_activities.activity_id ORDER BY activities.start_time DESC;