| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | USA | 1507 | 20th November 2025 – 30th June 2026 | 47 | 20 | 0 | 87 | 97 |
| 2 | Australia | 767 | 27th September 2025 – 29th June 2026 | 6 | 38 | 0 | 61 | 33 |
| 3 | United Kingdom | 608 | 19th November 2025 – 26th August 2026 | 34 | 14 | 0 | 23 | 47 |
| 4 | Switzerland | 271 | 24th January 2026 – 28th August 2026 | 6 | 3 | 0 | 12 | 35 |
| 5 | France | 264 | 6th January 2026 – 28th June 2026 | 14 | 3 | 0 | 12 | 31 |
| 6 | Austria | 210 | 12th November 2025 – 22nd June 2026 | 5 | 2 | 0 | 8 | 22 |
| 7 | Italy | 152 | 18th November 2025 – 11th August 2026 | 9 | 3 | 0 | 12 | 11 |
| 8 | Pakistan | 118 | 11th April 2026 – 26th April 2026 | 0 | 0 | 0 | 1 | 7 |
| 9 | Spain | 105 | 20th February 2026 – 16th May 2026 | 5 | 0 | 0 | 10 | 11 |
| 10 | Germany | 103 | 3rd February 2026 – 26th June 2026 | 7 | 0 | 0 | 7 | 10 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 221 | 26th June 2026 | 12:55:21 UTC | baz9 | list | History of 8C+ | list_description | |
|
Before
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders first ascended before 2020 that are:
- Graded 8C+ or higher
- FA suggested 8C/8C+ of harder
- Later revised, but initially suggested 8C+ or higher, indicated by the **Initial Suggested Grade** ascent meta
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
After
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders first ascended before 2020 that are:
- Graded 8C+ or higher
- FA suggested 8C/8C+ of harder
- Later revised, but initially suggested 8C+ or higher, indicated by the **Initial Suggested Grade** ascent meta
List inspired by these articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
Diff
--- before
|
|||||||
| 222 | 26th June 2026 | 12:54:47 UTC | baz9 | ascent | Daniel Woods's ascent of Hypnotized Minds | Initial Suggested Grade | |
|
Before
None
After
41
|
|||||||
| 223 | 26th June 2026 | 12:54:21 UTC | baz9 | list | History of 8C+ | list_description_pretty | |
|
Before
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders, FA'd before 2020, that are:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <em>Initial grade suggestion</em> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
After
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders first ascended before 2020 that are:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C/8C+ of harder</li>
<li>Later revised, but initially suggested 8C+ or higher, indicated by the <strong>Initial Suggested Grade</strong> ascent meta</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
|
|||||||
| 224 | 26th June 2026 | 12:54:21 UTC | baz9 | list | History of 8C+ | list_description | |
|
Before
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders, FA'd before 2020, that are:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by *Initial grade suggestion* meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
After
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders first ascended before 2020 that are:
- Graded 8C+ or higher
- FA suggested 8C/8C+ of harder
- Later revised, but initially suggested 8C+ or higher, indicated by the **Initial Suggested Grade** ascent meta
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
Diff
--- before
|
|||||||
| 225 | 26th June 2026 | 12:52:41 UTC | baz9 | list | History of 8C+ | list_definition | |
|
Before
with grade_cutoff as (
select
g.order_on
from
grades g
where
g.climb_type_id = 2
and g.grade = '8C+'
limit 1
),
first_ascents as (
select
a.ascent_id
,a.climb_id
,a.climber_id
,a.ascent_dt_start
,a.ascent_dt_end
,sg.grade as suggested_grade
,sg.order_on as suggested_order_on
,initial_g.grade as initial_suggested_grade
,initial_g.order_on as initial_suggested_order_on
from
ascents a
left join grades sg
on a.suggested_grade_id = sg.grade_id
and sg.climb_type_id = 2
left join ascent_meta am_initial
on a.ascent_id = am_initial.ascent_id
and am_initial.ascent_meta_key_id = 26
left join grades initial_g
on am_initial.value = initial_g.grade_id::varchar
and initial_g.climb_type_id = 2
where
a.fa = true
and a.deleted_on is null
),
first_ascent_by_climb as (
select
fa.climb_id
,string_agg(
'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>'
,', '
order by cl.climber_name
) as first_ascent
,(array_agg(
pretty_dt(fa.ascent_dt_start, fa.ascent_dt_end)
order by order_dt(fa.ascent_dt_start, fa.ascent_dt_end)
))[1] as date
,min(order_dt(fa.ascent_dt_start, fa.ascent_dt_end)) as date_order
,(array_agg(
fa.suggested_grade
order by fa.suggested_order_on desc nulls last
))[1] as suggested_grade
,max(fa.suggested_order_on) as suggested_order_on
,(array_agg(
fa.initial_suggested_grade
order by fa.initial_suggested_order_on desc nulls last
))[1] as initial_suggested_grade
,max(fa.initial_suggested_order_on) as initial_suggested_order_on
from
first_ascents fa
inner join climbers cl
on fa.climber_id = cl.climber_id
and cl.deleted_on is null
group by
fa.climb_id
)
select
c.climb_uuid as row_uuid
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name"
,g.grade as "Grade"
,fa.first_ascent as "First Ascent"
,case
when fa.initial_suggested_grade is not null
and fa.suggested_grade is not null
and fa.initial_suggested_grade != fa.suggested_grade
then fa.suggested_grade || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.initial_suggested_grade is not null
and fa.initial_suggested_grade != coalesce(fa.suggested_grade, g.grade)
then coalesce(fa.suggested_grade, g.grade) || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.suggested_grade is not null
then fa.suggested_grade
else g.grade
end as "Suggested Grade"
,fa.date as "Date"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
and g.climb_type_id = 2
inner join first_ascent_by_climb fa
on c.climb_id = fa.climb_id
cross join grade_cutoff gc
where
c.deleted_on is null
and c.climb_type = 2
and fa.date_order < 20200101
and (
g.order_on >= gc.order_on
or fa.suggested_order_on >= gc.order_on
or fa.initial_suggested_order_on >= gc.order_on
)
order by
fa.date_order
,greatest(
coalesce(g.order_on, 0)
,coalesce(fa.suggested_order_on, 0)
,coalesce(fa.initial_suggested_order_on, 0)
) desc
,c.climb_name
After
with grade_cutoff as (
select
g.order_on
from
grades g
where
g.climb_type_id = 2
and g.grade = '8C+'
limit 1
),
first_ascents as (
select
a.ascent_id
,a.climb_id
,a.climber_id
,a.ascent_dt_start
,a.ascent_dt_end
,sg.grade as suggested_grade
,sg.order_on as suggested_order_on
,initial_g.grade as initial_suggested_grade
,initial_g.order_on as initial_suggested_order_on
from
ascents a
left join grades sg
on a.suggested_grade_id = sg.grade_id
and sg.climb_type_id = 2
left join ascent_meta am_initial
on a.ascent_id = am_initial.ascent_id
and am_initial.ascent_meta_key_id = 26
left join grades initial_g
on am_initial.value = initial_g.grade_id::varchar
and initial_g.climb_type_id = 2
where
a.fa = true
and a.deleted_on is null
),
first_ascent_by_climb as (
select
fa.climb_id
,string_agg(
'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>'
,', '
order by cl.climber_name
) as first_ascent
,(array_agg(
pretty_dt(fa.ascent_dt_start, fa.ascent_dt_end)
order by order_dt(fa.ascent_dt_start, fa.ascent_dt_end)
))[1] as date
,min(order_dt(fa.ascent_dt_start, fa.ascent_dt_end)) as date_order
,(array_agg(
fa.suggested_grade
order by fa.suggested_order_on desc nulls last
))[1] as suggested_grade
,max(fa.suggested_order_on) as suggested_order_on
,(array_agg(
fa.initial_suggested_grade
order by fa.initial_suggested_order_on desc nulls last
))[1] as initial_suggested_grade
,max(fa.initial_suggested_order_on) as initial_suggested_order_on
from
first_ascents fa
inner join climbers cl
on fa.climber_id = cl.climber_id
and cl.deleted_on is null
group by
fa.climb_id
)
select
c.climb_uuid as row_uuid
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name"
,g.grade as "Grade"
,fa.first_ascent as "First Ascent"
,case
when fa.initial_suggested_grade is not null
and fa.suggested_grade is not null
and fa.initial_suggested_grade != fa.suggested_grade
then fa.suggested_grade || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.initial_suggested_grade is not null
and fa.initial_suggested_grade != coalesce(fa.suggested_grade, g.grade)
then coalesce(fa.suggested_grade, g.grade) || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.suggested_grade is not null
then fa.suggested_grade
else g.grade
end as "Suggested Grade"
,fa.date as "Date"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
and g.climb_type_id = 2
inner join first_ascent_by_climb fa
on c.climb_id = fa.climb_id
cross join grade_cutoff gc
where
c.deleted_on is null
and c.climb_type = 2
and fa.date_order < 20200101
and (
g.order_on >= gc.order_on
or fa.suggested_order_on >= gc.order_on
or fa.initial_suggested_order_on >= gc.order_on
or fa.suggested_grade in ('8C/8C+', '8C/+')
or fa.initial_suggested_grade in ('8C/8C+', '8C/+')
)
order by
fa.date_order
,greatest(
coalesce(g.order_on, 0)
,coalesce(fa.suggested_order_on, 0)
,coalesce(fa.initial_suggested_order_on, 0)
) desc
,c.climb_name
Diff
--- before
|
|||||||
| 226 | 26th June 2026 | 12:49:54 UTC | baz9 | climb | Bokassa's Fridge | Other Name | |
|
Before
None
After
Assassin, Monkey and Man
|
|||||||
| 227 | 26th June 2026 | 12:49:28 UTC | baz9 | climb | Bokassa's Fridge | Other Name | |
|
Before
None
After
Bokassa’s Fridge – Assassin, Monkey and Man
|
|||||||
| 228 | 26th June 2026 | 12:48:29 UTC | baz9 | ascent | Toni Lamprecht's ascent of Bokassa's Fridge | ascent_dt_end | |
|
Before
2006-03-01
After
2009-03-07
|
|||||||
| 229 | 26th June 2026 | 12:44:35 UTC | baz9 | ascent | Daniel Woods's ascent of Hypnotized Minds | Initial Suggested Grade | |
|
Before
None
After
42
|
|||||||
| 230 | 26th June 2026 | 12:41:26 UTC | baz9 | list | History of 8C+ | list_description | |
|
Before
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders, FA'd before 2020, that are:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
After
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders, FA'd before 2020, that are:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by *Initial grade suggestion* meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
Diff
--- before
|
|||||||
| 231 | 26th June 2026 | 12:41:26 UTC | baz9 | list | History of 8C+ | list_description_pretty | |
|
Before
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders, FA'd before 2020, that are:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
After
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders, FA'd before 2020, that are:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <em>Initial grade suggestion</em> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
|
|||||||
| 232 | 26th June 2026 | 12:40:38 UTC | baz9 | list | History of 8C+ | list_definition | |
|
Before
with grade_cutoff as (
select
g.order_on
from
grades g
where
g.climb_type_id = 2
and g.grade = '8C+'
limit 1
),
first_ascents as (
select
a.ascent_id
,a.climb_id
,a.climber_id
,a.ascent_dt_start
,a.ascent_dt_end
,sg.grade as suggested_grade
,sg.order_on as suggested_order_on
,initial_g.grade as initial_suggested_grade
,initial_g.order_on as initial_suggested_order_on
from
ascents a
left join grades sg
on a.suggested_grade_id = sg.grade_id
and sg.climb_type_id = 2
left join ascent_meta am_initial
on a.ascent_id = am_initial.ascent_id
and am_initial.ascent_meta_key_id = 26
left join grades initial_g
on am_initial.value = initial_g.grade_id::varchar
and initial_g.climb_type_id = 2
where
a.fa = true
and a.deleted_on is null
),
first_ascent_by_climb as (
select
fa.climb_id
,string_agg(
'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>'
,', '
order by cl.climber_name
) as first_ascent
,(array_agg(
pretty_dt(fa.ascent_dt_start, fa.ascent_dt_end)
order by order_dt(fa.ascent_dt_start, fa.ascent_dt_end)
))[1] as date
,min(order_dt(fa.ascent_dt_start, fa.ascent_dt_end)) as date_order
,(array_agg(
fa.suggested_grade
order by fa.suggested_order_on desc nulls last
))[1] as suggested_grade
,max(fa.suggested_order_on) as suggested_order_on
,(array_agg(
fa.initial_suggested_grade
order by fa.initial_suggested_order_on desc nulls last
))[1] as initial_suggested_grade
,max(fa.initial_suggested_order_on) as initial_suggested_order_on
from
first_ascents fa
inner join climbers cl
on fa.climber_id = cl.climber_id
and cl.deleted_on is null
group by
fa.climb_id
)
select
c.climb_uuid as row_uuid
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name"
,g.grade as "Grade"
,fa.first_ascent as "First Ascent"
,case
when fa.initial_suggested_grade is not null
and fa.suggested_grade is not null
and fa.initial_suggested_grade != fa.suggested_grade
then fa.suggested_grade || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.initial_suggested_grade is not null
and fa.initial_suggested_grade != coalesce(fa.suggested_grade, g.grade)
then coalesce(fa.suggested_grade, g.grade) || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.suggested_grade is not null
then fa.suggested_grade
else g.grade
end as "FA Grade"
,fa.date as "Date"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
and g.climb_type_id = 2
inner join first_ascent_by_climb fa
on c.climb_id = fa.climb_id
cross join grade_cutoff gc
where
c.deleted_on is null
and c.climb_type = 2
and fa.date_order < 20200101
and (
g.order_on >= gc.order_on
or fa.suggested_order_on >= gc.order_on
or fa.initial_suggested_order_on >= gc.order_on
)
order by
fa.date_order
,greatest(
coalesce(g.order_on, 0)
,coalesce(fa.suggested_order_on, 0)
,coalesce(fa.initial_suggested_order_on, 0)
) desc
,c.climb_name
After
with grade_cutoff as (
select
g.order_on
from
grades g
where
g.climb_type_id = 2
and g.grade = '8C+'
limit 1
),
first_ascents as (
select
a.ascent_id
,a.climb_id
,a.climber_id
,a.ascent_dt_start
,a.ascent_dt_end
,sg.grade as suggested_grade
,sg.order_on as suggested_order_on
,initial_g.grade as initial_suggested_grade
,initial_g.order_on as initial_suggested_order_on
from
ascents a
left join grades sg
on a.suggested_grade_id = sg.grade_id
and sg.climb_type_id = 2
left join ascent_meta am_initial
on a.ascent_id = am_initial.ascent_id
and am_initial.ascent_meta_key_id = 26
left join grades initial_g
on am_initial.value = initial_g.grade_id::varchar
and initial_g.climb_type_id = 2
where
a.fa = true
and a.deleted_on is null
),
first_ascent_by_climb as (
select
fa.climb_id
,string_agg(
'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>'
,', '
order by cl.climber_name
) as first_ascent
,(array_agg(
pretty_dt(fa.ascent_dt_start, fa.ascent_dt_end)
order by order_dt(fa.ascent_dt_start, fa.ascent_dt_end)
))[1] as date
,min(order_dt(fa.ascent_dt_start, fa.ascent_dt_end)) as date_order
,(array_agg(
fa.suggested_grade
order by fa.suggested_order_on desc nulls last
))[1] as suggested_grade
,max(fa.suggested_order_on) as suggested_order_on
,(array_agg(
fa.initial_suggested_grade
order by fa.initial_suggested_order_on desc nulls last
))[1] as initial_suggested_grade
,max(fa.initial_suggested_order_on) as initial_suggested_order_on
from
first_ascents fa
inner join climbers cl
on fa.climber_id = cl.climber_id
and cl.deleted_on is null
group by
fa.climb_id
)
select
c.climb_uuid as row_uuid
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name"
,g.grade as "Grade"
,fa.first_ascent as "First Ascent"
,case
when fa.initial_suggested_grade is not null
and fa.suggested_grade is not null
and fa.initial_suggested_grade != fa.suggested_grade
then fa.suggested_grade || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.initial_suggested_grade is not null
and fa.initial_suggested_grade != coalesce(fa.suggested_grade, g.grade)
then coalesce(fa.suggested_grade, g.grade) || ' ~ Initially suggested ' || fa.initial_suggested_grade
when fa.suggested_grade is not null
then fa.suggested_grade
else g.grade
end as "Suggested Grade"
,fa.date as "Date"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
and g.climb_type_id = 2
inner join first_ascent_by_climb fa
on c.climb_id = fa.climb_id
cross join grade_cutoff gc
where
c.deleted_on is null
and c.climb_type = 2
and fa.date_order < 20200101
and (
g.order_on >= gc.order_on
or fa.suggested_order_on >= gc.order_on
or fa.initial_suggested_order_on >= gc.order_on
)
order by
fa.date_order
,greatest(
coalesce(g.order_on, 0)
,coalesce(fa.suggested_order_on, 0)
,coalesce(fa.initial_suggested_order_on, 0)
) desc
,c.climb_name
Diff
--- before
|
|||||||
| 233 | 26th June 2026 | 12:39:51 UTC | baz9 | list | History of 8C+ | list_description_pretty | |
|
Before
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders with FA before 2020 that are:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
After
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders, FA'd before 2020, that are:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
|
|||||||
| 234 | 26th June 2026 | 12:39:51 UTC | baz9 | list | History of 8C+ | list_description | |
|
Before
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders with FA before 2020 that are:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
After
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders, FA'd before 2020, that are:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
Diff
--- before
|
|||||||
| 235 | 26th June 2026 | 12:39:27 UTC | baz9 | list | History of 8C+ | list_description | |
|
Before
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
After
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders with FA before 2020 that are:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
Diff
--- before
|
|||||||
| 236 | 26th June 2026 | 12:39:27 UTC | baz9 | list | History of 8C+ | list_description_pretty | |
|
Before
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
After
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders with FA before 2020 that are:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
|
|||||||
| 237 | 26th June 2026 | 12:38:48 UTC | baz9 | list | History of 8C+ | list_description | |
|
Before
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by Crank Climbing:
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
After
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by [Crank Climbing](https://crankclimbing.org/):
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
Diff
--- before
|
|||||||
| 238 | 26th June 2026 | 12:38:48 UTC | baz9 | list | History of 8C+ | list_description_pretty | |
|
Before
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by Crank Climbing:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
After
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by <a href="https://crankclimbing.org/" rel="noopener noreferrer">Crank Climbing</a>:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
|
|||||||
| 239 | 26th June 2026 | 12:38:02 UTC | baz9 | list | History of 8C+ | list_description_pretty | |
|
Before
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>This list is heavily based off the following articles by Crank Climbing:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
After
<p>Lists the first boulders graded/suggested at 8C+ or harder.</p>
<p>Includes boulders:</p>
<ul>
<li>Graded 8C+ or higher</li>
<li>FA suggested 8C+ of harder</li>
<li>FA revised grade, but initially suggested 8C+ or harder (indicated by <strong>Initial grade suggestion</strong> meta)</li>
</ul>
<p>List inspired by following articles by Crank Climbing:</p>
<ul>
<li><a href="https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/" rel="noopener noreferrer">https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/</a></li>
<li><a href="https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/" rel="noopener noreferrer">https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/</a></li>
</ul>
|
|||||||
| 240 | 26th June 2026 | 12:38:02 UTC | baz9 | list | History of 8C+ | list_description | |
|
Before
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
This list is heavily based off the following articles by Crank Climbing:
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
After
Lists the first boulders graded/suggested at 8C+ or harder.
Includes boulders:
- Graded 8C+ or higher
- FA suggested 8C+ of harder
- FA revised grade, but initially suggested 8C+ or harder (indicated by **Initial grade suggestion** meta)
List inspired by following articles by Crank Climbing:
- [https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978](https://crankclimbing.org/2020/05/the-history-of-v168c-part-1-from-1978/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-2-2004-2011ish/)
- [https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/](https://crankclimbing.org/2020/06/the-history-of-8cv16-part-3-2011ish/)
Diff
--- before
|
|||||||