| 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 |
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||
| 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
|
|||||||