| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | United Kingdom | 61673 | 14th November 2023 – 16th November 2026 | 1806 | 712 | 0 | 3145 | 5097 |
| 2 | USA | 26469 | 14th November 2023 – 15th November 2026 | 819 | 183 | 165 | 866 | 2438 |
| 3 | France | 12612 | 14th November 2023 – 16th November 2026 | 273 | 126 | 23 | 557 | 1049 |
| 4 | Switzerland | 10049 | 14th November 2023 – 14th November 2026 | 80 | 43 | 52 | 311 | 1128 |
| 5 | Spain | 8996 | 15th November 2023 – 16th November 2026 | 93 | 76 | 10 | 463 | 940 |
| 6 | Italy | 5221 | 16th November 2023 – 16th November 2026 | 120 | 59 | 30 | 199 | 390 |
| 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 | 3315 | 16th November 2023 – 13th November 2026 | 120 | 49 | 1 | 106 | 236 |
| 10 | Austria | 2786 | 16th November 2023 – 11th November 2026 | 76 | 26 | 25 | 105 | 226 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 47721 | 11th August 2026 | 08:47:45 UTC | remus | list | Hard Mantle Boulder Problems | list_type_id | |
|
Before
None
After
1
|
|||||||
| 47722 | 11th August 2026 | 08:47:45 UTC | remus | list | Hard Mantle Boulder Problems | list_definition | |
|
Before
None
After
with grade_cutoff as (
select
g.order_on
from
grades g
where
g.climb_type_id = 2
and g.grade = '7B+'
limit 1
),
first_ascent_by_climb as (
select
a.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(a.ascent_dt_start, a.ascent_dt_end)
order by order_dt(a.ascent_dt_start, a.ascent_dt_end)
))[1] as date
,min(order_dt(a.ascent_dt_start, a.ascent_dt_end)) as date_order
from
ascents a
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
a.fa = true
and a.deleted_on is null
group by
a.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"
,'<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag"
,fa.first_ascent
|| coalesce(', ' || fa.date, '') as "First Ascent"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
and g.climb_type_id = 2
inner join climb_meta cm_mantle
on c.climb_id = cm_mantle.climb_id
and cm_mantle.climb_meta_key_id = 40
left join crags cr
on c.crag_id = cr.crag_id
left 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 g.order_on >= gc.order_on
order by
g.order_on desc
,coalesce(fa.date_order, 99999999)
,c.climb_name
Diff
--- before
|
|||||||
| 47723 | 11th August 2026 | 08:47:45 UTC | remus | list | Hard Mantle Boulder Problems | list_description | |
|
Before
None
After
Boulder problems graded 7B+ or harder where the climbing consists primarily of a mantle move.
Diff
--- before
|
|||||||
| 47724 | 11th August 2026 | 08:47:45 UTC | remus | list | Hard Mantle Boulder Problems | list_name | |
|
Before
None
After
Hard Mantle Boulder Problems
|
|||||||
| 47725 | 11th August 2026 | 08:42:33 UTC | remus | climb | Cloud Gate | Mantle | |
|
Before
None
After
1
|
|||||||
| 47726 | 11th August 2026 | 08:42:29 UTC | remus | climb | Cloud Gate Low | Mantle | |
|
Before
None
After
1
|
|||||||
| 47727 | 11th August 2026 | 08:42:09 UTC | remus | climb | The Beast | Mantle | |
|
Before
None
After
1
|
|||||||
| 47728 | 11th August 2026 | 08:42:05 UTC | remus | ascent | Jon Fullwood's ascent of The Beast | Ascent # | |
|
Before
None
After
1
|
|||||||
| 47729 | 11th August 2026 | 08:42:04 UTC | remus | ascent | Jon Fullwood's ascent of The Beast | ascent_dt_end | |
|
Before
None
After
2007-01-01
|
|||||||
| 47730 | 11th August 2026 | 08:42:04 UTC | remus | ascent | Jon Fullwood's ascent of The Beast | ascent_dt_start | |
|
Before
None
After
2006-01-01
|
|||||||
| 47731 | 11th August 2026 | 08:42:04 UTC | remus | ascent | Jon Fullwood's ascent of The Beast | ascent_type_id | |
|
Before
None
After
2
|
|||||||
| 47732 | 11th August 2026 | 08:42:04 UTC | remus | ascent | Jon Fullwood's ascent of The Beast | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 47733 | 11th August 2026 | 08:42:04 UTC | remus | ascent | Jon Fullwood's ascent of The Beast | climb_id | |
|
Before
None
After
8210
|
|||||||
| 47734 | 11th August 2026 | 08:42:04 UTC | remus | ascent | Jon Fullwood's ascent of The Beast | climber_id | |
|
Before
None
After
1768
|
|||||||
| 47735 | 11th August 2026 | 08:41:47 UTC | remus | climb | The Beast | _default_ascent_type_id | |
|
Before
None
After
2
|
|||||||
| 47736 | 11th August 2026 | 08:41:47 UTC | remus | climb | The Beast | crag_location_breadcrumb_pretty | |
|
Before
None
After
<a href="/crags/location/United Kingdom" class="text-muted">United Kingdom</a> / <a href="/crags/location/United Kingdom/England" class="text-muted">England</a> / <a href="/crags/location/United Kingdom/England/Hope Valley" class="text-muted">Hope Valley</a>
|
|||||||
| 47737 | 11th August 2026 | 08:41:47 UTC | remus | climb | The Beast | crag_location_breadcrumb | |
|
Before
None
After
United Kingdom / England / Hope Valley
|
|||||||
| 47738 | 11th August 2026 | 08:41:47 UTC | remus | climb | The Beast | crag_name_prefix | |
|
Before
None
After
at
|
|||||||
| 47739 | 11th August 2026 | 08:41:47 UTC | remus | climb | The Beast | crag_name | |
|
Before
None
After
Stanage
|
|||||||
| 47740 | 11th August 2026 | 08:41:47 UTC | remus | climb | The Beast | crag_id | |
|
Before
None
After
101
|
|||||||