| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | United Kingdom | 61464 | 14th November 2023 – 9th November 2026 | 1802 | 711 | 0 | 3142 | 5085 |
| 2 | USA | 25595 | 14th November 2023 – 9th November 2026 | 818 | 182 | 2 | 860 | 2423 |
| 3 | France | 12431 | 14th November 2023 – 9th November 2026 | 272 | 126 | 1 | 555 | 1044 |
| 4 | Switzerland | 9697 | 14th November 2023 – 8th November 2026 | 79 | 43 | 1 | 311 | 1127 |
| 5 | Spain | 8829 | 15th November 2023 – 8th November 2026 | 92 | 76 | 0 | 459 | 928 |
| 6 | Italy | 4924 | 16th November 2023 – 8th November 2026 | 120 | 59 | 0 | 189 | 380 |
| 7 | South Africa | 3688 | 16th November 2023 – 5th November 2026 | 12 | 35 | 0 | 128 | 401 |
| 8 | Canada | 3363 | 16th November 2023 – 1st November 2026 | 67 | 21 | 3 | 110 | 283 |
| 9 | Germany | 3190 | 16th November 2023 – 27th October 2026 | 120 | 48 | 0 | 103 | 225 |
| 10 | Austria | 2659 | 16th November 2023 – 24th October 2026 | 76 | 26 | 0 | 105 | 226 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 31561 | 23rd September 2026 | 21:36:28 UTC | remus | climb | Cloud Inversion | crag_name | |
|
Before
None
After
The Roaches
|
|||||||
| 31562 | 23rd September 2026 | 21:36:28 UTC | remus | climb | Cloud Inversion | crag_id | |
|
Before
None
After
105
|
|||||||
| 31563 | 23rd September 2026 | 21:36:28 UTC | remus | climb | Cloud Inversion | climb_type_name | |
|
Before
None
After
Boulder problem
|
|||||||
| 31564 | 23rd September 2026 | 21:36:28 UTC | remus | climb | Cloud Inversion | grade | |
|
Before
None
After
7C+
|
|||||||
| 31565 | 23rd September 2026 | 21:36:28 UTC | remus | climb | Cloud Inversion | climb_type | |
|
Before
None
After
2
|
|||||||
| 31566 | 23rd September 2026 | 21:36:28 UTC | remus | climb | Cloud Inversion | grade_id | |
|
Before
None
After
36
|
|||||||
| 31567 | 23rd September 2026 | 21:36:28 UTC | remus | climb | Cloud Inversion | climb_name | |
|
Before
None
After
Cloud Inversion
|
|||||||
| 31568 | 23rd September 2026 | 11:14:04 UTC | remus | list | Approximate Grades to Review | list_description_pretty | |
|
Before
<p>Climbs carrying the Approximate Grade meta flag that are not projects. Each should be checked: either the grade is genuinely a rough guess (keep the flag), or no ascentionist has ever offered a grade and it should be switched to the Ungraded flag instead, which hides the grade from readers.</p>
After
<p>Climbs carrying the Approximate Grade meta flag that are not projects. Check whether applying the <code>Ungraded</code> meta data is appropriate for each.</p>
|
|||||||
| 31569 | 23rd September 2026 | 11:14:04 UTC | remus | list | Approximate Grades to Review | list_description | |
|
Before
Climbs carrying the Approximate Grade meta flag that are not projects. Each should be checked: either the grade is genuinely a rough guess (keep the flag), or no ascentionist has ever offered a grade and it should be switched to the Ungraded flag instead, which hides the grade from readers.
After
Climbs carrying the Approximate Grade meta flag that are not projects. Check whether applying the `Ungraded` meta data is appropriate for each.
Diff
--- before
|
|||||||
| 31570 | 23rd September 2026 | 11:13:10 UTC | remus | list | Approximate Grades to Review | list_description_pretty | |
|
Before
None
After
<p>Climbs carrying the Approximate Grade meta flag that are not projects. Each should be checked: either the grade is genuinely a rough guess (keep the flag), or no ascentionist has ever offered a grade and it should be switched to the Ungraded flag instead, which hides the grade from readers.</p>
|
|||||||
| 31571 | 23rd September 2026 | 11:13:10 UTC | remus | list | Approximate Grades to Review | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
,ct.climb_type as "Type"
,case
when coalesce(cr2.crag_id, cr.crag_id) is not null
then '<a href="/crag/' || coalesce(cr2.crag_id, cr.crag_id) || '">' || coalesce(cr2.crag_name, cr.crag_name) || '</a>'
else null
end as "Crag"
,(
select count(*)
from ascents a
where a.climb_id = c.climb_id
and a.deleted_on is null
) as "Ascents"
,case
when exists (
select 1
from climb_meta ung
where ung.climb_id = c.climb_id
and ung.climb_meta_key_id = 41
) then 'Yes'
else null
end as "Ungraded"
from
climbs c
inner join climb_meta approx
on approx.climb_id = c.climb_id
and approx.climb_meta_key_id = 42
inner join climb_types ct
on c.climb_type_id = ct.climb_type_id
left join grades g
on c.grade_id = g.grade_id
left join crags cr
on c.crag_id = cr.crag_id
left join crags cr2
on cr.group_crag_id = cr2.crag_id
where
c.deleted_on is null
and not exists (
select 1
from climb_meta proj
where proj.climb_id = c.climb_id
and proj.climb_meta_key_id = 20
)
order by
ct.climb_type
,g.order_on desc
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
,ct.climb_type as "Type"
,case
when coalesce(cr2.crag_id, cr.crag_id) is not null
then '<a href="/crag/' || coalesce(cr2.crag_id, cr.crag_id) || '">' || coalesce(cr2.crag_name, cr.crag_name) || '</a>'
else null
end as "Crag"
,(
select count(*)
from ascents a
where a.climb_id = c.climb_id
and a.deleted_on is null
) as "Ascents"
,case
when exists (
select 1
from climb_meta ung
where ung.climb_id = c.climb_id
and ung.climb_meta_key_id = 41
) then 'Yes'
else null
end as "Ungraded"
from
climbs c
inner join climb_meta approx
on approx.climb_id = c.climb_id
and approx.climb_meta_key_id = 42
inner join climb_types ct
on c.climb_type_id = ct.climb_type_id
left join grades g
on c.grade_id = g.grade_id
left join crags cr
on c.crag_id = cr.crag_id
left join crags cr2
on cr.group_crag_id = cr2.crag_id
where
c.deleted_on is null
and not exists (
select 1
from climb_meta proj
where proj.climb_id = c.climb_id
and proj.climb_meta_key_id = 20
)
order by
ct.climb_type
,g.order_on desc
,c.climb_name
Diff
--- before
|
|||||||
| 31572 | 23rd September 2026 | 11:11:44 UTC | remus | list | Approximate Grades to Review | list_type_name | |
|
Before
None
After
Admin
|
|||||||
| 31573 | 23rd September 2026 | 11:11:44 UTC | remus | list | Approximate Grades to Review | list_type_id | |
|
Before
None
After
6
|
|||||||
| 31574 | 23rd September 2026 | 11:11:44 UTC | remus | list | Approximate Grades to Review | list_definition | |
|
Before
None
After
select
'<a href="/climb/' || c.climb_id || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
,ct.climb_type as "Type"
,case
when coalesce(cr2.crag_id, cr.crag_id) is not null
then '<a href="/crag/' || coalesce(cr2.crag_id, cr.crag_id) || '">' || coalesce(cr2.crag_name, cr.crag_name) || '</a>'
else null
end as "Crag"
,(
select count(*)
from ascents a
where a.climb_id = c.climb_id
and a.deleted_on is null
) as "Ascents"
,case
when exists (
select 1
from climb_meta ung
where ung.climb_id = c.climb_id
and ung.climb_meta_key_id = 41
) then 'Yes'
else null
end as "Ungraded"
from
climbs c
inner join climb_meta approx
on approx.climb_id = c.climb_id
and approx.climb_meta_key_id = 42
inner join climb_types ct
on c.climb_type_id = ct.climb_type_id
left join grades g
on c.grade_id = g.grade_id
left join crags cr
on c.crag_id = cr.crag_id
left join crags cr2
on cr.group_crag_id = cr2.crag_id
where
c.deleted_on is null
and not exists (
select 1
from climb_meta proj
where proj.climb_id = c.climb_id
and proj.climb_meta_key_id = 20
)
order by
ct.climb_type
,g.order_on desc
,c.climb_name
Diff
--- before
|
|||||||
| 31575 | 23rd September 2026 | 11:11:44 UTC | remus | list | Approximate Grades to Review | list_description | |
|
Before
None
After
Climbs carrying the Approximate Grade meta flag that are not projects. Each should be checked: either the grade is genuinely a rough guess (keep the flag), or no ascentionist has ever offered a grade and it should be switched to the Ungraded flag instead, which hides the grade from readers.
Diff
--- before
|
|||||||
| 31576 | 23rd September 2026 | 11:11:44 UTC | remus | list | Approximate Grades to Review | list_name | |
|
Before
None
After
Approximate Grades to Review
|
|||||||
| 31577 | 23rd September 2026 | 11:08:34 UTC | remus | climb | Death Grip | Ungraded | |
|
Before
None
After
1
|
|||||||
| 31578 | 23rd September 2026 | 11:08:06 UTC | remus | climb | Pneuma | Ungraded | |
|
Before
None
After
1
|
|||||||
| 31579 | 23rd September 2026 | 11:07:37 UTC | remus | ascent | Charles Albert's ascent of Charlatan | ascent_dt_end | |
|
Before
2026-03-29
After
2026-04-01
|
|||||||
| 31580 | 23rd September 2026 | 11:07:37 UTC | remus | ascent | Charles Albert's ascent of Charlatan | ascent_dt_start | |
|
Before
None
After
2026-03-01
|
|||||||