remus

Badges

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

Contributions

Posts

1 Day

44

7 Days

696

4 Weeks

9640

All Time

230130

Current Streak

242

Longest Streak

242

Contributions Map

Contributions by Country

Country Contributions Between Climbers Crags Summits Climbs Ascents
1 United Kingdom 61686 14th November 2023 – 16th November 2026 1806 712 0 3145 5097
2 USA 26491 14th November 2023 – 18th November 2026 819 183 165 866 2440
3 France 12612 14th November 2023 – 16th November 2026 273 126 23 557 1049
4 Switzerland 10085 14th November 2023 – 18th November 2026 81 46 52 312 1129
5 Spain 9025 15th November 2023 – 18th November 2026 93 76 10 464 941
6 Italy 5250 16th November 2023 – 18th November 2026 120 59 30 200 394
7 Canada 4062 16th November 2023 – 14th November 2026 67 22 147 111 286
8 South Africa 3696 16th November 2023 – 11th November 2026 12 35 2 128 402
9 Germany 3330 16th November 2023 – 17th November 2026 121 49 1 106 236
10 Austria 2792 16th November 2023 – 16th November 2026 76 26 25 105 227

Recent Contributions

Date Time User Type Name Attribute
57781 23rd June 2026 05:33:14 UTC remus list The Big Five list_description_pretty
Before
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart" rel="noopener noreferrer">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau" rel="noopener noreferrer">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p> <p>Originally <em>The Big Four</em> before <a href="/climber/249/tyler-landman" rel="noopener noreferrer">Tyler Landman</a> decided to try tick them all and add <a href="/climb/3334/atrésie" rel="noopener noreferrer">Atrésie</a> (8A) into the mix:</p> <blockquote> <p>On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html</a></p>
After
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart" rel="noopener noreferrer">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau" rel="noopener noreferrer">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p> <p>Originally <em>The Big Four</em> before <a href="/climber/249/tyler-landman" rel="noopener noreferrer">Tyler Landman</a> decided to try tick them all and add <a href="/climb/3334/atrésie" rel="noopener noreferrer">Atrésie</a> (8A) into the mix in March 2009:</p> <blockquote> <p>On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html</a></p>
57782 23rd June 2026 05:33:14 UTC remus list The Big Five list_description
Before
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style. Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix: > On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1] ### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html)
After
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style. Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix in March 2009: > On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1] ### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html)
Diff
--- before

+++ after

@@ -1,6 +1,6 @@

The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.

-Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix:
+Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix in March 2009:

> On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]
57783 22nd June 2026 22:51:18 UTC remus media https://www.instagram.com/reel/DZ4HUndOmOF/ missing_right_to_reproduce
Before
None
After
false
57784 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/
57785 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>
57786 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/)
57787 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>
57788 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
57789 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>
57790 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/)
57791 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>
57792 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/)
57793 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
- ,'<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"
+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)

-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)
-
57794 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
,'<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"
+ ,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
57795 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
- ,'<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
+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)

-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)
-
57796 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
- ,'<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
+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)

-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)
-
57797 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>
57798 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)
57799 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>
57800 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)

< Page 2890 >