ben_sandi

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

62

7 Days

76

4 Weeks

113

All Time

6752

Current Streak

1

Longest Streak

13

Contributions Map

Contributions by Country

Country Contributions Between Climbers Crags Summits Climbs Ascents
1 USA 1526 20th November 2025 – 4th November 2026 48 20 0 88 98
2 Australia 767 27th September 2025 – 29th June 2026 6 38 0 61 33
3 United Kingdom 625 19th November 2025 – 4th November 2026 34 14 0 24 49
4 Switzerland 308 24th January 2026 – 4th November 2026 6 3 0 14 38
5 France 300 6th January 2026 – 4th November 2026 15 3 0 12 34
6 Austria 210 12th November 2025 – 22nd June 2026 5 2 0 8 22
7 Italy 163 18th November 2025 – 2nd November 2026 9 3 0 12 12
8 Pakistan 118 11th April 2026 – 26th April 2026 0 0 0 1 7
9 Spain 105 20th February 2026 – 16th May 2026 5 0 0 10 11
10 Germany 103 3rd February 2026 – 26th June 2026 7 0 0 7 10

Recent Contributions

Date Time User Type Name Attribute
3141 30th April 2026 12:04:32 UTC ben_sandi ascent Elias Iagnemma's ascent of Soudain Seul notes
Before
None
After
### References [1] [https://www.instagram.com/reel/DXwTyuWsWHy/](https://www.instagram.com/reel/DXwTyuWsWHy/)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://www.instagram.com/reel/DXwTyuWsWHy/](https://www.instagram.com/reel/DXwTyuWsWHy/)
3142 30th April 2026 12:04:32 UTC ben_sandi ascent Elias Iagnemma's ascent of Soudain Seul ascent_style_id
Before
None
After
5
3143 30th April 2026 12:04:32 UTC ben_sandi ascent Elias Iagnemma's ascent of Soudain Seul climb_id
Before
None
After
849
3144 30th April 2026 12:04:32 UTC ben_sandi ascent Elias Iagnemma's ascent of Soudain Seul climber_id
Before
None
After
913
3145 30th April 2026 11:48:02 UTC ben_sandi climb Six Degrees notes_pretty
Before
None
After
<p>Not to be confused with the <a href="/climb/6440/six-degrees" rel="noopener noreferrer">Six Degrees</a> (project) </p>
3146 30th April 2026 11:48:02 UTC ben_sandi climb Six Degrees notes
Before
None
After
Not to be confused with the [Six Degrees](/climb/6440/six-degrees) (project)
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Not to be confused with the [Six Degrees](/climb/6440/six-degrees) (project)
3147 30th April 2026 11:31:53 UTC ben_sandi climb Six Degrees notes_pretty
Before
<p>The Six Degrees Project is an unclimbed problem in Yosemite. <a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a> has been seriously projecting it since moving to California in 2024, he has made some very promising links.</p> <p>The problem has also been tried by the likes of <a href="/climber/602/nalle-hukkataival" rel="noopener noreferrer">Nalle Hukkataival</a>, <a href="/climber/668/jimmy-webb" rel="noopener noreferrer">Jimmy Webb</a>, <a href="/climber/503/dave-graham" rel="noopener noreferrer">Dave Graham</a>, <a href="/climber/770/carlo-traversi" rel="noopener noreferrer">Carlo Traversi</a> and <a href="/climber/939/keenan-takahashi" rel="noopener noreferrer">Keenan Takahashi</a>.</p> <p><a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a>:</p> <blockquote> <p>A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991" rel="noopener noreferrer">https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991</a></p>
After
<p>The Six Degrees Project is an unclimbed problem in Yosemite. <a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a> has been seriously projecting it since moving to California in 2024, and he has made some very promising links.</p> <p>The problem has also been tried by the likes of <a href="/climber/602/nalle-hukkataival" rel="noopener noreferrer">Nalle Hukkataival</a>, <a href="/climber/668/jimmy-webb" rel="noopener noreferrer">Jimmy Webb</a>, <a href="/climber/503/dave-graham" rel="noopener noreferrer">Dave Graham</a>, <a href="/climber/770/carlo-traversi" rel="noopener noreferrer">Carlo Traversi</a> and <a href="/climber/939/keenan-takahashi" rel="noopener noreferrer">Keenan Takahashi</a>.</p> <p><a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a>:</p> <blockquote> <p>A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991" rel="noopener noreferrer">https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991</a></p>
3148 30th April 2026 11:31:53 UTC ben_sandi climb Six Degrees notes
Before
The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting it since moving to California in 2024, he has made some very promising links. The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi). [Aidan Roberts](/climber/227/aidan-roberts): > A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1] ### References [1] [https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991](https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991)
After
The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting it since moving to California in 2024, and he has made some very promising links. The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi). [Aidan Roberts](/climber/227/aidan-roberts): > A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1] ### References [1] [https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991](https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991)
Diff
--- before

+++ after

@@ -1,4 +1,4 @@

-The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting it since moving to California in 2024, he has made some very promising links.
+The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting it since moving to California in 2024, and he has made some very promising links.

The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi).
3149 30th April 2026 11:31:33 UTC ben_sandi climb Six Degrees notes_pretty
Before
<p>The Six Degrees Project is an unclimbed problem in Yosemite. <a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a> has been seriously projecting the project since moving to California in 2024, he has made some very promising links.</p> <p>The problem has also been tried by the likes of <a href="/climber/602/nalle-hukkataival" rel="noopener noreferrer">Nalle Hukkataival</a>, <a href="/climber/668/jimmy-webb" rel="noopener noreferrer">Jimmy Webb</a>, <a href="/climber/503/dave-graham" rel="noopener noreferrer">Dave Graham</a>, <a href="/climber/770/carlo-traversi" rel="noopener noreferrer">Carlo Traversi</a> and <a href="/climber/939/keenan-takahashi" rel="noopener noreferrer">Keenan Takahashi</a>.</p> <p><a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a>:</p> <blockquote> <p>A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991" rel="noopener noreferrer">https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991</a></p>
After
<p>The Six Degrees Project is an unclimbed problem in Yosemite. <a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a> has been seriously projecting it since moving to California in 2024, he has made some very promising links.</p> <p>The problem has also been tried by the likes of <a href="/climber/602/nalle-hukkataival" rel="noopener noreferrer">Nalle Hukkataival</a>, <a href="/climber/668/jimmy-webb" rel="noopener noreferrer">Jimmy Webb</a>, <a href="/climber/503/dave-graham" rel="noopener noreferrer">Dave Graham</a>, <a href="/climber/770/carlo-traversi" rel="noopener noreferrer">Carlo Traversi</a> and <a href="/climber/939/keenan-takahashi" rel="noopener noreferrer">Keenan Takahashi</a>.</p> <p><a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a>:</p> <blockquote> <p>A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991" rel="noopener noreferrer">https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991</a></p>
3150 30th April 2026 11:31:33 UTC ben_sandi climb Six Degrees notes
Before
The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting the project since moving to California in 2024, he has made some very promising links. The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi). [Aidan Roberts](/climber/227/aidan-roberts): > A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1] ### References [1] [https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991](https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991)
After
The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting it since moving to California in 2024, he has made some very promising links. The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi). [Aidan Roberts](/climber/227/aidan-roberts): > A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1] ### References [1] [https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991](https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991)
Diff
--- before

+++ after

@@ -1,4 +1,4 @@

-The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting the project since moving to California in 2024, he has made some very promising links.
+The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting it since moving to California in 2024, he has made some very promising links.

The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi).
3151 30th April 2026 11:30:38 UTC ben_sandi climb Six Degrees notes_pretty
Before
<p>The Six Degrees Project is an unclimbed problem in Yosemite. <a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a> made promising links of this during his 2024/25 season.</p> <p>The problem has also been tried by the likes of <a href="/climber/602/nalle-hukkataival" rel="noopener noreferrer">Nalle Hukkataival</a>, <a href="/climber/668/jimmy-webb" rel="noopener noreferrer">Jimmy Webb</a>, <a href="/climber/503/dave-graham" rel="noopener noreferrer">Dave Graham</a>, <a href="/climber/770/carlo-traversi" rel="noopener noreferrer">Carlo Traversi</a> and <a href="/climber/939/keenan-takahashi" rel="noopener noreferrer">Keenan Takahashi</a>.</p> <p><a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a>:</p> <blockquote> <p>A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991" rel="noopener noreferrer">https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991</a></p>
After
<p>The Six Degrees Project is an unclimbed problem in Yosemite. <a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a> has been seriously projecting the project since moving to California in 2024, he has made some very promising links.</p> <p>The problem has also been tried by the likes of <a href="/climber/602/nalle-hukkataival" rel="noopener noreferrer">Nalle Hukkataival</a>, <a href="/climber/668/jimmy-webb" rel="noopener noreferrer">Jimmy Webb</a>, <a href="/climber/503/dave-graham" rel="noopener noreferrer">Dave Graham</a>, <a href="/climber/770/carlo-traversi" rel="noopener noreferrer">Carlo Traversi</a> and <a href="/climber/939/keenan-takahashi" rel="noopener noreferrer">Keenan Takahashi</a>.</p> <p><a href="/climber/227/aidan-roberts" rel="noopener noreferrer">Aidan Roberts</a>:</p> <blockquote> <p>A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991" rel="noopener noreferrer">https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991</a></p>
3152 30th April 2026 11:30:38 UTC ben_sandi climb Six Degrees notes
Before
The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) made promising links of this during his 2024/25 season. The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi). [Aidan Roberts](/climber/227/aidan-roberts): > A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1] ### References [1] [https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991](https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991)
After
The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting the project since moving to California in 2024, he has made some very promising links. The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi). [Aidan Roberts](/climber/227/aidan-roberts): > A series of slashed edges trend leftwards up a scooped face. The holds were bad, but the feet were worse. With nothing to offer any opposition, the only options seemingly to contort into some brutally shouldery positions until you can will yourself to fly to the lip. [1] ### References [1] [https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991](https://www.ukclimbing.com/news/2025/06/aidan_roberts_on_a_winter_in_yosemite-73991)
Diff
--- before

+++ after

@@ -1,4 +1,4 @@

-The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) made promising links of this during his 2024/25 season.
+The Six Degrees Project is an unclimbed problem in Yosemite. [Aidan Roberts](/climber/227/aidan-roberts) has been seriously projecting the project since moving to California in 2024, he has made some very promising links.

The problem has also been tried by the likes of [Nalle Hukkataival](/climber/602/nalle-hukkataival), [Jimmy Webb](/climber/668/jimmy-webb), [Dave Graham](/climber/503/dave-graham), [Carlo Traversi](/climber/770/carlo-traversi) and [Keenan Takahashi](/climber/939/keenan-takahashi).
3153 30th April 2026 01:13:31 UTC ben_sandi list The Hardest DWS Routes in the World list_definition
Before
select c.climb_uuid as row_uuid ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb" ,g.grade as "Grade" ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" ,string_agg( distinct '<a href="/climber/' || cl2.climber_id::varchar || '">' || cl2.climber_name || '</a>' ,', ' ) as "Repeats" from climbs c inner join grades g on c.grade_id = g.grade_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null and not a.ascent_style_id = 5 left join climbers cl on a.climber_id = cl.climber_id left join ascents a2 on a2.climb_id = c.climb_id and a2.fa = false and a2.deleted_on is null and not a2.ascent_style_id = 5 left join climbers cl2 on a2.climber_id = cl2.climber_id where c.deleted_on is null and c.climb_type = 4 and g.order_on >= 17 and not exists ( select 1 from climb_meta cm where cm.climb_id = c.climb_id and cm.value = 'Project' ) group by c.climb_uuid ,c.climb_id ,c.climb_name ,cl.climber_id ,cl.climber_name ,g.grade ,g.order_on ,order_dt(a.ascent_dt_start, a.ascent_dt_end) ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) order by g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
After
select c.climb_uuid as row_uuid ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb" ,g.grade as "Grade" ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" ,string_agg( distinct '<a href="/climber/' || cl2.climber_id::varchar || '">' || cl2.climber_name || '</a>' ,', ' ) as "Repeats" from climbs c inner join grades g on c.grade_id = g.grade_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null and not a.ascent_style_id = 5 left join climbers cl on a.climber_id = cl.climber_id left join ascents a2 on a2.climb_id = c.climb_id and a2.fa = false and a2.deleted_on is null and not a2.ascent_style_id = 5 left join climbers cl2 on a2.climber_id = cl2.climber_id where c.deleted_on is null and c.climb_type = 4 and g.order_on >= 17 and not exists ( select 1 from climb_meta cm where cm.climb_id = c.climb_id and cm.value = 'Project' ) group by c.climb_uuid ,c.climb_id ,c.climb_name ,cl.climber_id ,cl.climber_name ,g.grade ,g.order_on ,order_dt(a.ascent_dt_start, a.ascent_dt_end) ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) order by g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before

+++ after

@@ -1,60 +1,60 @@

-select
- c.climb_uuid as row_uuid
- ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb"
- ,g.grade as "Grade"
- ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
- ,string_agg(
- distinct '<a href="/climber/' || cl2.climber_id::varchar || '">' || cl2.climber_name || '</a>'
- ,', '
- ) as "Repeats"
+select
+ c.climb_uuid as row_uuid
+ ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb"
+ ,g.grade as "Grade"
+ ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+ ,string_agg(
+ distinct '<a href="/climber/' || cl2.climber_id::varchar || '">' || cl2.climber_name || '</a>'
+ ,', '
+ ) as "Repeats"
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ and not a.ascent_style_id = 5
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+ left join ascents a2
+ on a2.climb_id = c.climb_id
+ and a2.fa = false
+ and a2.deleted_on is null
+ and not a2.ascent_style_id = 5
+ left join climbers cl2
+ on a2.climber_id = cl2.climber_id
+
+where
+ c.deleted_on is null
+ and c.climb_type = 4
+ and g.order_on >= 17
+ and not exists (
+ select
+ 1
+
+ from
+ climb_meta cm
+
+ where
+ cm.climb_id = c.climb_id
+ and cm.value = 'Project'
+ )
+
+group by
+ c.climb_uuid
+ ,c.climb_id
+ ,c.climb_name
+ ,cl.climber_id
+ ,cl.climber_name
+ ,g.grade
+ ,g.order_on
+ ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
+ ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
+
+order by
+ g.order_on desc
+ ,order_dt(a.ascent_dt_start, a.ascent_dt_end)

-from
- climbs c
- inner join grades g
- on c.grade_id = g.grade_id
- left join ascents a
- on a.climb_id = c.climb_id
- and a.fa = true
- and a.deleted_on is null
- and not a.ascent_style_id = 5
- left join climbers cl
- on a.climber_id = cl.climber_id
- left join ascents a2
- on a2.climb_id = c.climb_id
- and a2.fa = false
- and a2.deleted_on is null
- and not a2.ascent_style_id = 5
- left join climbers cl2
- on a2.climber_id = cl2.climber_id
-
-where
- c.deleted_on is null
- and c.climb_type = 4
- and g.order_on >= 17
- and not exists (
- select
- 1
-
- from
- climb_meta cm
-
- where
- cm.climb_id = c.climb_id
- and cm.value = 'Project'
- )
-
-group by
- c.climb_uuid
- ,c.climb_id
- ,c.climb_name
- ,cl.climber_id
- ,cl.climber_name
- ,g.grade
- ,g.order_on
- ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
- ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
-
-order by
- g.order_on desc
- ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
-
3154 28th April 2026 00:22:25 UTC ben_sandi climber Alex Johnson Climbing Partner
Before
None
After
1469
3155 28th April 2026 00:21:22 UTC ben_sandi ascent Nina Arthaud's ascent of The Swarm suggested_grade_id
Before
None
After
177
3156 28th April 2026 00:21:22 UTC ben_sandi ascent Nina Arthaud's ascent of The Swarm notes_pretty
Before
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/p/DG_I1sXtqMu/">https://www.instagram.com/p/DG_I1sXtqMu/</a></p>
After
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/p/DG_I1sXtqMu/" rel="noopener noreferrer">https://www.instagram.com/p/DG_I1sXtqMu/</a></p>
3157 28th April 2026 00:20:45 UTC ben_sandi ascent Simon Lorenzi's ascent of The Swarm suggested_grade_id
Before
None
After
177
3158 28th April 2026 00:17:34 UTC ben_sandi climber Lor Sabourin notes_pretty
Before
<p>The first out non-binary person to send 5.14 on gear</p>
After
<p>The first out non-binary person to send 5.14 on gear.</p>
3159 28th April 2026 00:17:34 UTC ben_sandi climber Lor Sabourin notes
Before
The first out non-binary person to send 5.14 on gear
After
The first out non-binary person to send 5.14 on gear.
Diff
--- before

+++ after

@@ -1 +1 @@

-The first out non-binary person to send 5.14 on gear
+The first out non-binary person to send 5.14 on gear.
3160 28th April 2026 00:13:24 UTC ben_sandi climber Lor Sabourin notes_pretty
Before
<p>The first out non-binary person to send 5.14</p>
After
<p>The first out non-binary person to send 5.14 on gear</p>

< Page 158 >