| 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 | 576 | 19th November 2025 – 8th July 2026 | 33 | 14 | 0 | 22 | 43 |
| 4 | France | 264 | 6th January 2026 – 28th June 2026 | 14 | 3 | 0 | 12 | 31 |
| 5 | Switzerland | 257 | 24th January 2026 – 10th July 2026 | 6 | 3 | 0 | 12 | 33 |
| 6 | Austria | 210 | 12th November 2025 – 22nd June 2026 | 5 | 2 | 0 | 8 | 22 |
| 7 | Italy | 129 | 18th November 2025 – 29th May 2026 | 9 | 3 | 0 | 11 | 10 |
| 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 | ||
|---|---|---|---|---|---|---|---|
| 1581 | 15th May 2026 | 20:03:38 UTC | baz9 | list | Dodgy Crags | list_description | |
|
Before
Finds climbs linked by meta that should usually mean they are at the same crag, including `Free Version of`, `Aid Version of`, `Trad Version of`, `Sport Version of`, `DWS Version of`, `Low Start To`, `Sit Start To`, `Stand Start To`, `Extension Of`, and `Variation Of`, but where the climbs are assigned to different crags or one of them has no crag set.
After
Finds climbs linked by meta that should usually mean they are at the same crag, but where the climbs are assigned to different crags or one of them has no crag set.
Meta used: `Free Version of`, `Aid Version of`, `Trad Version of`, `Sport Version of`, `DWS Version of`, `Low Start To`, `Sit Start To`, `Stand Start To`, `Extension Of`, and `Variation Of`,
Diff
--- before
|
|||||||
| 1582 | 15th May 2026 | 20:02:58 UTC | baz9 | climb | Trieste Low | crag_id | |
|
Before
None
After
5170
|
|||||||
| 1583 | 15th May 2026 | 20:02:58 UTC | baz9 | climb | Trieste Low | crag_name | |
|
Before
None
After
Clear Creek Canyon
|
|||||||
| 1584 | 15th May 2026 | 20:02:58 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb | |
|
Before
None
After
United States / Colorado / Jefferson County
|
|||||||
| 1585 | 15th May 2026 | 20:02:58 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb_pretty | |
|
Before
None
After
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Colorado" class="text-muted">Colorado</a> / <a href="/crags/location/United States/Colorado/Jefferson County" class="text-muted">Jefferson County</a>
|
|||||||
| 1586 | 15th May 2026 | 20:02:34 UTC | baz9 | climb | Trieste Low | crag_id | |
|
Before
4228
After
None
|
|||||||
| 1587 | 15th May 2026 | 20:02:34 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb | |
|
Before
United States / Nevada / Clark County
After
None
|
|||||||
| 1588 | 15th May 2026 | 20:02:34 UTC | baz9 | climb | Trieste Low | crag_name | |
|
Before
First Creek Canyon
After
None
|
|||||||
| 1589 | 15th May 2026 | 20:02:34 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb_pretty | |
|
Before
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Nevada" class="text-muted">Nevada</a> / <a href="/crags/location/United States/Nevada/Clark County" class="text-muted">Clark County</a>
After
None
|
|||||||
| 1590 | 15th May 2026 | 20:02:14 UTC | baz9 | list | Dodgy Crags | list_definition | |
|
Before
with related_climbs as (
select distinct
cm.climb_id as source_climb_id
,cmk.key as relation_type
,cm.value::integer as related_climb_id
from
climb_meta cm
inner join climb_meta_keys cmk
on cm.climb_meta_key_id = cmk.climb_meta_key_id
where
cmk.key in (
'Free Version of'
,'Aid Version of'
,'Trad Version of'
,'Sport Version of'
,'DWS Version of'
,'Low Start To'
,'Sit Start To'
,'Stand Start To'
,'Extension Of'
,'Variation Of'
)
)
select
rc.relation_type
,c1.climb_id as climb_id
,c1.climb_name as climb_name
,c1.crag_id as climb_crag_id
,c2.climb_id as related_climb_id
,c2.climb_name as related_climb_name
,c2.crag_id as related_climb_crag_id
from
related_climbs rc
inner join climbs c1
on rc.source_climb_id = c1.climb_id
inner join climbs c2
on rc.related_climb_id = c2.climb_id
where
c1.crag_id is distinct from c2.crag_id
order by
rc.relation_type
,c1.climb_name
,c2.climb_name
After
with related_climbs as (
select distinct
cm.climb_id as source_climb_id
,cmk.key as relation_type
,cm.value::integer as related_climb_id
from
climb_meta cm
inner join climb_meta_keys cmk
on cm.climb_meta_key_id = cmk.climb_meta_key_id
where
cmk.key in (
'Free Version of'
,'Aid Version of'
,'Trad Version of'
,'Sport Version of'
,'DWS Version of'
,'Low Start To'
,'Sit Start To'
,'Stand Start To'
,'Extension Of'
,'Variation Of'
)
)
select
rc.relation_type
,'<a href="/climb/'
|| c1.climb_id::varchar
|| '">'
|| c1.climb_name
|| '</a>' as climb
,coalesce(cr1_group.crag_name, cr1.crag_name) as climb_crag
,'<a href="/climb/'
|| c2.climb_id::varchar
|| '">'
|| c2.climb_name
|| '</a>' as related_climb
,coalesce(cr2_group.crag_name, cr2.crag_name) as related_climb_crag
from
related_climbs rc
inner join climbs c1
on rc.source_climb_id = c1.climb_id
inner join climbs c2
on rc.related_climb_id = c2.climb_id
left join crags cr1
on c1.crag_id = cr1.crag_id
left join crags cr1_group
on cr1.group_crag_id = cr1_group.crag_id
left join crags cr2
on c2.crag_id = cr2.crag_id
left join crags cr2_group
on cr2.group_crag_id = cr2_group.crag_id
where
c1.deleted_on is null
and c2.deleted_on is null
and coalesce(cr1.group_crag_id, c1.crag_id)
is distinct from coalesce(cr2.group_crag_id, c2.crag_id)
order by
rc.relation_type
,c1.climb_name
,c2.climb_name;
Diff
--- before
|
|||||||
| 1591 | 15th May 2026 | 19:54:36 UTC | baz9 | climb | Trieste Low | crag_name | |
|
Before
None
After
First Creek Canyon
|
|||||||
| 1592 | 15th May 2026 | 19:54:36 UTC | baz9 | climb | Trieste Low | crag_id | |
|
Before
None
After
4228
|
|||||||
| 1593 | 15th May 2026 | 19:54:36 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb_pretty | |
|
Before
None
After
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Nevada" class="text-muted">Nevada</a> / <a href="/crags/location/United States/Nevada/Clark County" class="text-muted">Clark County</a>
|
|||||||
| 1594 | 15th May 2026 | 19:54:36 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb | |
|
Before
None
After
United States / Nevada / Clark County
|
|||||||
| 1595 | 15th May 2026 | 19:54:24 UTC | baz9 | climb | Trieste Low | crag_name | |
|
Before
First Creek Canyon
After
None
|
|||||||
| 1596 | 15th May 2026 | 19:54:24 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb | |
|
Before
United States / Nevada / Clark County
After
None
|
|||||||
| 1597 | 15th May 2026 | 19:54:24 UTC | baz9 | climb | Trieste Low | crag_id | |
|
Before
4228
After
None
|
|||||||
| 1598 | 15th May 2026 | 19:54:24 UTC | baz9 | climb | Trieste Low | crag_location_breadcrumb_pretty | |
|
Before
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Nevada" class="text-muted">Nevada</a> / <a href="/crags/location/United States/Nevada/Clark County" class="text-muted">Clark County</a>
After
None
|
|||||||
| 1599 | 15th May 2026 | 19:53:41 UTC | baz9 | list | Dodgy Crags | list_name | |
|
Before
None
After
Dodgy Crags
|
|||||||
| 1600 | 15th May 2026 | 19:53:41 UTC | baz9 | list | Dodgy Crags | list_type_name | |
|
Before
None
After
Admin
|
|||||||