SELECT *, (SELECT strava_segment_effort.athlete_name FROM `strava_segment_effort` WHERE SSE.segment_id = segment_id AND SSE.activity_id = activity_id AND RANK = 1 LIMIT 1) as Rank1Name, (SELECT strava_segment_effort.elapsed_time FROM `strava_segment_effort` WHERE SSE.segment_id = segment_id AND SSE.activity_id = activity_id AND RANK = 1 LIMIT 1) as Rank1Time FROM `strava_segment_effort` SSE WHERE activity_id = '1079571511' AND athlete_id = 2213606 ORDER BY start_date_local DESC
18:10:17 10:46:56 - Invalid query: Unknown column 'strava_segment_effort.athlete_name' in 'field list'
- SELECT *, (SELECT strava_segment_effort.athlete_name
FROM `strava_segment_effort`
WHERE SSE.segment_id = segment_id AND SSE.activity_id = activity_id AND RANK = 1 LIMIT 1) as Rank1Name,
(SELECT strava_segment_effort.elapsed_time
FROM `strava_segment_effort`
WHERE SSE.segment_id = segment_id AND SSE.activity_id = activity_id AND RANK = 1 LIMIT 1) as Rank1Time
FROM `strava_segment_effort` SSE
WHERE activity_id = '1079571511' AND athlete_id = 2213606
ORDER BY start_date_local DESC (strava_lib.php::41)
Invalid query: Unknown column 'strava_segment_effort.athlete_name' in 'field list'