remus

Badges

OG100 Contributions1,000 Contributions10,000 Contributions100,000 Contributions10 Posts100 Posts

Contributions

Posts

1 Day

232

7 Days

1251

4 Weeks

4623

All Time

172093

Current Streak

93

Longest Streak

181

Contributions Map

Contributions by Country

Country Contributions Between Climbers Crags Summits Climbs Ascents
1 United Kingdom 48515 14th November 2023 – 22nd June 2026 1364 668 0 2950 4604
2 USA 22757 14th November 2023 – 22nd June 2026 766 175 2 779 2178
3 France 11131 14th November 2023 – 22nd June 2026 252 122 1 509 958
4 Switzerland 8051 14th November 2023 – 22nd June 2026 72 39 1 274 966
5 Spain 7679 15th November 2023 – 22nd June 2026 87 73 0 407 831
6 Italy 3815 16th November 2023 – 22nd June 2026 112 55 0 150 288
7 South Africa 2927 16th November 2023 – 17th June 2026 12 34 0 103 327
8 Canada 2846 16th November 2023 – 20th June 2026 61 21 3 102 240
9 Germany 2385 16th November 2023 – 12th June 2026 110 37 0 71 172
10 Japan 2327 16th November 2023 – 11th June 2026 74 11 0 89 222

Recent Contributions

Date Time User Type Name Attribute
1 22nd June 2026 22:51:18 UTC remus media https://www.instagram.com/reel/DZ4HUndOmOF/ url
Before
None
After
https://www.instagram.com/reel/DZ4HUndOmOF/
2 22nd June 2026 22:51:18 UTC remus media https://www.instagram.com/reel/DZ4HUndOmOF/ missing_right_to_reproduce
Before
None
After
false
3 22nd June 2026 22:51:18 UTC remus ascent Ilias Hosain's ascent of Ego Death notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/reel/DZ4HUndOmOF/" rel="noopener noreferrer">https://www.instagram.com/reel/DZ4HUndOmOF/</a></p>
4 22nd June 2026 22:51:18 UTC remus ascent Ilias Hosain's ascent of Ego Death notes
Before
None
After
### References [1] [https://www.instagram.com/reel/DZ4HUndOmOF/](https://www.instagram.com/reel/DZ4HUndOmOF/)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://www.instagram.com/reel/DZ4HUndOmOF/](https://www.instagram.com/reel/DZ4HUndOmOF/)
5 22nd June 2026 22:34:31 UTC remus climb Snake Dike notes_pretty
Before
<p>One of THE classic routes in Yosemite.</p> <h3>References</h3> <p>[1] <a href="https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p" rel="noopener noreferrer">https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p</a></p> <p>[2] <a href="https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/" rel="noopener noreferrer">https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/</a></p>
After
<p>One of THE classic routes in Yosemite. In 2026 the route was subject to much controversy when many bolts were added significantly changing the character of the route.</p> <h3>References</h3> <p>[1] <a href="https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p" rel="noopener noreferrer">https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p</a></p> <p>[2] <a href="https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/" rel="noopener noreferrer">https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/</a></p>
6 22nd June 2026 22:34:31 UTC remus climb Snake Dike notes
Before
One of THE classic routes in Yosemite. ### References [1] [https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p](https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p) [2] [https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/](https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/)
After
One of THE classic routes in Yosemite. In 2026 the route was subject to much controversy when many bolts were added significantly changing the character of the route. ### References [1] [https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p](https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p) [2] [https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/](https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/)
Diff
--- before

+++ after

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

-One of THE classic routes in Yosemite.
+One of THE classic routes in Yosemite. In 2026 the route was subject to much controversy when many bolts were added significantly changing the character of the route.

### References

7 22nd June 2026 22:33:50 UTC remus climb Snake Dike notes_pretty
Before
<p>One of THE classic routes in Yosemite.</p> <h3>References</h3> <p>[1] <a href="https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p" rel="noopener noreferrer">https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p</a></p>
After
<p>One of THE classic routes in Yosemite.</p> <h3>References</h3> <p>[1] <a href="https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p" rel="noopener noreferrer">https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p</a></p> <p>[2] <a href="https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/" rel="noopener noreferrer">https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/</a></p>
8 22nd June 2026 22:33:50 UTC remus climb Snake Dike notes
Before
One of THE classic routes in Yosemite. ### References [1] [https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p](https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p)
After
One of THE classic routes in Yosemite. ### References [1] [https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p](https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p) [2] [https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/](https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/)
Diff
--- before

+++ after

@@ -2,4 +2,6 @@


### References

-[1] [https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p](https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p)
+[1] [https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p](https://www.yosemiteclimbing.org/campaigns/view-campaign/4WGnZYF4LpZvzz9jeYx5C_sNQ_V_LDbYMNOP77mCQJKdVfco0YOSu5j2FO7rF3MLUXGbpSAJPQyV1tGL5xBaSl128_AeUa3p)
+
+[2] [https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/](https://www.climbing.com/community/john-long-responds-to-new-bolts-on-snake-dike/)
9 22nd June 2026 22:33:17 UTC remus ascent Daniel Woods's ascent of Ego Death notes
Before
### References [1] [https://www.instagram.com/reel/DZnAHwrOUIw/](https://www.instagram.com/reel/DZnAHwrOUIw/)
After
### References [1] [https://www.instagram.com/reel/DZnAHwrOUIw/](https://www.instagram.com/reel/DZnAHwrOUIw/) [2] [https://gripped.com/news/daniel-woods-sends-ego-death-suggests-v14/](https://gripped.com/news/daniel-woods-sends-ego-death-suggests-v14/)
Diff
--- before

+++ after

@@ -1,3 +1,5 @@

### References

-[1] [https://www.instagram.com/reel/DZnAHwrOUIw/](https://www.instagram.com/reel/DZnAHwrOUIw/)
+[1] [https://www.instagram.com/reel/DZnAHwrOUIw/](https://www.instagram.com/reel/DZnAHwrOUIw/)
+
+[2] [https://gripped.com/news/daniel-woods-sends-ego-death-suggests-v14/](https://gripped.com/news/daniel-woods-sends-ego-death-suggests-v14/)
10 22nd June 2026 22:33:17 UTC remus ascent Daniel Woods's ascent of Ego Death notes_pretty
Before
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/reel/DZnAHwrOUIw/" rel="noopener noreferrer">https://www.instagram.com/reel/DZnAHwrOUIw/</a></p>
After
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/reel/DZnAHwrOUIw/" rel="noopener noreferrer">https://www.instagram.com/reel/DZnAHwrOUIw/</a></p> <p>[2] <a href="https://gripped.com/news/daniel-woods-sends-ego-death-suggests-v14/" rel="noopener noreferrer">https://gripped.com/news/daniel-woods-sends-ego-death-suggests-v14/</a></p>
11 22nd June 2026 21:51:36 UTC remus list The Hardest Trad Routes in the World (By Physical Difficulty) list_definition
Before
select c.climb_uuid as row_uuid ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as Climb ,g2.grade || ' (' || g.grade || ')' as "Grade" ,string_agg('<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>', ', ' order by cl.climber_name) || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" from climbs c inner join grades g on c.grade_id = g.grade_id inner join climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 9 inner join grades g2 on g2.grade_id = cm.value::int and g2.climb_type_id = 1 left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id left join climb_meta cm2 on cm2.climb_id = c.climb_id and cm2.climb_meta_key_id = 11 -- pitches left join climb_meta cm3 on cm3.climb_id = c.climb_id and cm3.climb_meta_key_id = 20 -- project where c.deleted_on is null and c.climb_type = 3 and g2.order_on >= 15 and c.grade_approx = false and cm2.value is null and cm3.value is null group by c.climb_uuid ,c.climb_id ,c.climb_name ,g.grade ,g.order_on ,a.ascent_dt_start ,a.ascent_dt_end ,g2.grade ,g2.order_on order by g2.order_on desc ,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 ,g2.grade || ' (' || g.grade || ')' as "Grade" ,string_agg('<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>', ', ' order by cl.climber_name) as "First Ascent" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date from climbs c inner join grades g on c.grade_id = g.grade_id inner join climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 9 inner join grades g2 on g2.grade_id = cm.value::int and g2.climb_type_id = 1 left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id left join climb_meta cm2 on cm2.climb_id = c.climb_id and cm2.climb_meta_key_id = 11 -- pitches left join climb_meta cm3 on cm3.climb_id = c.climb_id and cm3.climb_meta_key_id = 20 -- project where c.deleted_on is null and c.climb_type = 3 and g2.order_on >= 15 and c.grade_approx = false and cm2.value is null and cm3.value is null group by c.climb_uuid ,c.climb_id ,c.climb_name ,g.grade ,g.order_on ,a.ascent_dt_start ,a.ascent_dt_end ,g2.grade ,g2.order_on order by g2.order_on desc ,g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before

+++ after

@@ -1,53 +1,54 @@

-select
- c.climb_uuid as row_uuid
- ,'' || c.climb_name || '' as Climb
- ,g2.grade || ' (' || g.grade || ')' as "Grade"
- ,string_agg('' || cl.climber_name || '', ', ' order by cl.climber_name) || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+select
+ c.climb_uuid as row_uuid
+ ,'' || c.climb_name || '' as Climb
+ ,g2.grade || ' (' || g.grade || ')' as "Grade"
+ ,string_agg('' || cl.climber_name || '', ', ' order by cl.climber_name) as "First Ascent"
+,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ inner join climb_meta cm
+ on c.climb_id = cm.climb_id
+ and cm.climb_meta_key_id = 9
+ inner join grades g2
+ on g2.grade_id = cm.value::int
+ and g2.climb_type_id = 1
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+ left join climb_meta cm2
+ on cm2.climb_id = c.climb_id
+ and cm2.climb_meta_key_id = 11 -- pitches
+ left join climb_meta cm3
+ on cm3.climb_id = c.climb_id
+ and cm3.climb_meta_key_id = 20 -- project
+
+where
+ c.deleted_on is null
+ and c.climb_type = 3
+ and g2.order_on >= 15
+ and c.grade_approx = false
+ and cm2.value is null
+ and cm3.value is null
+
+group by
+ c.climb_uuid
+ ,c.climb_id
+ ,c.climb_name
+ ,g.grade
+ ,g.order_on
+ ,a.ascent_dt_start
+ ,a.ascent_dt_end
+ ,g2.grade
+ ,g2.order_on
+
+order by
+ g2.order_on desc
+ ,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
- inner join climb_meta cm
- on c.climb_id = cm.climb_id
- and cm.climb_meta_key_id = 9
- inner join grades g2
- on g2.grade_id = cm.value::int
- and g2.climb_type_id = 1
- left join ascents a
- on a.climb_id = c.climb_id
- and a.fa = true
- and a.deleted_on is null
- left join climbers cl
- on a.climber_id = cl.climber_id
- left join climb_meta cm2
- on cm2.climb_id = c.climb_id
- and cm2.climb_meta_key_id = 11 -- pitches
- left join climb_meta cm3
- on cm3.climb_id = c.climb_id
- and cm3.climb_meta_key_id = 20 -- project
-
-where
- c.deleted_on is null
- and c.climb_type = 3
- and g2.order_on >= 15
- and c.grade_approx = false
- and cm2.value is null
- and cm3.value is null
-
-group by
- c.climb_uuid
- ,c.climb_id
- ,c.climb_name
- ,g.grade
- ,g.order_on
- ,a.ascent_dt_start
- ,a.ascent_dt_end
- ,g2.grade
- ,g2.order_on
-
-order by
- g2.order_on desc
- ,g.order_on desc
- ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
-
12 22nd June 2026 21:51:03 UTC remus list The Hardest Trad 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" ,string_agg('<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>', ', ' order by cl.climber_name) || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" 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 left join climbers cl on a.climber_id = cl.climber_id left join climb_meta cm on cm.climb_id = c.climb_id and cm.climb_meta_key_id = 11 -- pitches where c.deleted_on is null and c.climb_type = 3 and g.order_on >= 63 and c.grade_approx = false and cm.value is null and not exists ( select 1 from climb_meta cm2 where cm2.climb_id = c.climb_id and cm2.climb_meta_key_id = 20 -- Project ) group by c.climb_uuid ,c.climb_id ,c.climb_name ,g.grade ,g.order_on ,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" ,string_agg('<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>', ', ' order by cl.climber_name) as "First Ascent" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date 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 left join climbers cl on a.climber_id = cl.climber_id left join climb_meta cm on cm.climb_id = c.climb_id and cm.climb_meta_key_id = 11 -- pitches where c.deleted_on is null and c.climb_type = 3 and g.order_on >= 63 and c.grade_approx = false and cm.value is null and not exists ( select 1 from climb_meta cm2 where cm2.climb_id = c.climb_id and cm2.climb_meta_key_id = 20 -- Project ) group by c.climb_uuid ,c.climb_id ,c.climb_name ,g.grade ,g.order_on ,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

@@ -2,7 +2,8 @@

c.climb_uuid as row_uuid
,'' || c.climb_name || '' as Climb
,g.grade as "Grade"
- ,string_agg('' || cl.climber_name || '', ', ' order by cl.climber_name) || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+ ,string_agg('' || cl.climber_name || '', ', ' order by cl.climber_name) as "First Ascent"
+,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date

from
climbs c
13 22nd June 2026 21:50:14 UTC remus list The Hardest Sport 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('<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 climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 20 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 = 1 and g.order_on >= 21 and cm.value is null group by 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>' as "First Ascent" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date ,string_agg('<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 climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 20 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 = 1 and g.order_on >= 21 and cm.value is null group by 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,49 +1,50 @@

-select
- c.climb_uuid as row_uuid
- ,'' || c.climb_name || '' as Climb
- ,g.grade as "Grade"
- ,'' || cl.climber_name || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
- ,string_agg('' || cl2.climber_name || '', ', ') as Repeats
+select
+ c.climb_uuid as row_uuid
+ ,'' || c.climb_name || '' as Climb
+ ,g.grade as "Grade"
+ ,'' || cl.climber_name || '' as "First Ascent"
+,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date
+ ,string_agg('' || cl2.climber_name || '', ', ') as Repeats
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ left join climb_meta cm
+ on c.climb_id = cm.climb_id
+ and cm.climb_meta_key_id = 20
+ 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 = 1
+ and g.order_on >= 21
+ and cm.value is null
+
+group by
+ 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 climb_meta cm
- on c.climb_id = cm.climb_id
- and cm.climb_meta_key_id = 20
- 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 = 1
- and g.order_on >= 21
- and cm.value is null
-
-group by
- 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)
-
14 22nd June 2026 21:49:40 UTC remus list The Hardest Boulder Problems 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('<a href="/climber/' || cl2.climber_id::varchar || '">' || cl2.climber_name || '</a>', ', ' order by order_dt(a2.ascent_dt_start, a2.ascent_dt_end)) as Repeats from climbs c inner join grades g on c.grade_id = g.grade_id left join climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 20 left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null 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 = 2 and g.order_on >= 42 and cm.value is null group by 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>' as "First Ascent" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date ,string_agg('<a href="/climber/' || cl2.climber_id::varchar || '">' || cl2.climber_name || '</a>', ', ' order by order_dt(a2.ascent_dt_start, a2.ascent_dt_end)) as Repeats from climbs c inner join grades g on c.grade_id = g.grade_id left join climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 20 left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null 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 = 2 and g.order_on >= 42 and cm.value is null group by 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,48 +1,49 @@

-select
- c.climb_uuid as row_uuid
- ,'' || c.climb_name || '' as Climb
- ,g.grade as "Grade"
- ,'' || cl.climber_name || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
- ,string_agg('' || cl2.climber_name || '', ', ' order by order_dt(a2.ascent_dt_start, a2.ascent_dt_end)) as Repeats
+select
+ c.climb_uuid as row_uuid
+ ,'' || c.climb_name || '' as Climb
+ ,g.grade as "Grade"
+ ,'' || cl.climber_name || '' as "First Ascent"
+,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as Date
+ ,string_agg('' || cl2.climber_name || '', ', ' order by order_dt(a2.ascent_dt_start, a2.ascent_dt_end)) as Repeats
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ left join climb_meta cm
+ on c.climb_id = cm.climb_id
+ and cm.climb_meta_key_id = 20
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ 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 = 2
+ and g.order_on >= 42
+ and cm.value is null
+
+group by
+ 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 climb_meta cm
- on c.climb_id = cm.climb_id
- and cm.climb_meta_key_id = 20
- left join ascents a
- on a.climb_id = c.climb_id
- and a.fa = true
- and a.deleted_on is null
- 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 = 2
- and g.order_on >= 42
- and cm.value is null
-
-group by
- 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)
-
15 22nd June 2026 21:42:25 UTC remus ascent Tyler Landman's ascent of Khéops (assis) notes
Before
None
After
### References [1] [https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Kh%C3%A9ops-Assis-n-883.html](https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Kh%C3%A9ops-Assis-n-883.html)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Kh%C3%A9ops-Assis-n-883.html](https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Kh%C3%A9ops-Assis-n-883.html)
16 22nd June 2026 21:42:25 UTC remus ascent Tyler Landman's ascent of Khéops (assis) notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Kh%C3%A9ops-Assis-n-883.html" rel="noopener noreferrer">https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Kh%C3%A9ops-Assis-n-883.html</a></p>
17 22nd June 2026 21:40:32 UTC remus ascent Tyler Landman's ascent of Partage notes_pretty
Before
<p>Tyler's bionic strength snapped off a hold, a decent nubbin next to the hole.</p> <h3>References</h3> <p>[1] <a href="https://youtu.be/IaxHcntnnIo?t=1119" rel="noopener noreferrer">https://youtu.be/IaxHcntnnIo?t=1119</a></p>
After
<p>Tyler's bionic strength snapped off a hold, a decent nubbin next to the hole.</p> <h3>References</h3> <p>[1] <a href="https://youtu.be/IaxHcntnnIo?t=1119" rel="noopener noreferrer">https://youtu.be/IaxHcntnnIo?t=1119</a></p> <p>[2] <a href="https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Partage-n-884.html" rel="noopener noreferrer">https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Partage-n-884.html</a></p>
18 22nd June 2026 21:40:32 UTC remus ascent Tyler Landman's ascent of Partage notes
Before
Tyler's bionic strength snapped off a hold, a decent nubbin next to the hole. ### References [1] [https://youtu.be/IaxHcntnnIo?t=1119](https://youtu.be/IaxHcntnnIo?t=1119)
After
Tyler's bionic strength snapped off a hold, a decent nubbin next to the hole. ### References [1] [https://youtu.be/IaxHcntnnIo?t=1119](https://youtu.be/IaxHcntnnIo?t=1119) [2] [https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Partage-n-884.html](https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Partage-n-884.html)
Diff
--- before

+++ after

@@ -2,4 +2,6 @@


### References

-[1] [https://youtu.be/IaxHcntnnIo?t=1119](https://youtu.be/IaxHcntnnIo?t=1119)
+[1] [https://youtu.be/IaxHcntnnIo?t=1119](https://youtu.be/IaxHcntnnIo?t=1119)
+
+[2] [https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Partage-n-884.html](https://web.archive.org/web/20090302234334/http://usa.moonclimbing.com/Partage-n-884.html)
19 22nd June 2026 21:37:58 UTC remus climb T-Rex See Also
Before
None
After
7996
20 22nd June 2026 21:37:31 UTC remus ascent Tyler Landman's ascent of Fata Morgana (départ bas) Sessions
Before
None
After
1

Page 1 >