| 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 | ||
|---|---|---|---|---|---|---|---|
| 2781 | 1st May 2026 | 17:09:51 UTC | baz9 | climb | Chicken Nuggets | crag_name | |
|
Before
None
After
North Wall Boulders
|
|||||||
| 2782 | 1st May 2026 | 17:09:16 UTC | baz9 | list | Temporary List | list_definition | |
|
Before
None
After
with qualifying_meta as (
select
cm.climb_id,
cm.climb_meta_key_id,
linked_climb.url as linked_url,
linked_climb.climb_name as linked_climb_name,
cr.crag_name
from
climb_meta cm
inner join climbs linked_climb
on linked_climb.climb_id = cm.value::int
inner join crags cr
on cr.crag_id = linked_climb.crag_id
where
cm.climb_meta_key_id in (
1, -- Sit Start To
5, -- Low Start To
2, -- Stand Start To
3, -- Extension Of
23, -- Variation Of
4, -- See Also
31, -- Trad Version of
32, -- Sport Version of
33, -- Free Version of
34, -- Aid Version of
36 -- DWS Version of
)
and linked_climb.deleted_on is null
)
select
'<a href="' || c.url || '">' || c.climb_name || '</a>' as Climb
,g.grade || ' ' || ct.climb_type as Grade
,(
select string_agg(
cmk.key || ' (' ||
'<a href="' || qm.linked_url || '">' || qm.linked_climb_name || '</a>' ||
' - ' || qm.crag_name || ')',
'<br>'
order by cmk.order_on, qm.linked_climb_name
)
from qualifying_meta qm
inner join climb_meta_keys cmk
on cmk.climb_meta_key_id = qm.climb_meta_key_id
where qm.climb_id = c.climb_id
) as Meta
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
inner join climb_types ct
on c.climb_type_id = ct.climb_type_id
where
c.deleted_on is null
and c.crag_id is null
and exists (
select 1
from qualifying_meta qm
where qm.climb_id = c.climb_id
)
order by
c.climb_name;
Diff
--- before
|
|||||||
| 2783 | 1st May 2026 | 17:09:16 UTC | baz9 | list | Temporary List | list_description_pretty | |
|
Before
None
After
<p>temp</p>
|
|||||||
| 2784 | 1st May 2026 | 17:09:16 UTC | baz9 | list | Temporary List | list_description | |
|
Before
None
After
temp
Diff
--- before
|
|||||||
| 2785 | 1st May 2026 | 17:09:16 UTC | baz9 | list | Temporary List | list_type_id | |
|
Before
None
After
6
|
|||||||
| 2786 | 1st May 2026 | 17:09:16 UTC | baz9 | list | Temporary List | list_type_name | |
|
Before
None
After
Admin
|
|||||||
| 2787 | 1st May 2026 | 17:09:16 UTC | baz9 | list | Temporary List | list_name | |
|
Before
None
After
Temporary List
|
|||||||
| 2788 | 1st May 2026 | 16:53:56 UTC | baz9 | climb | Anaconda | crag_location_breadcrumb_pretty | |
|
Before
None
After
<a href="/crags/location/Italy" class="text-muted">Italy</a> / <a href="/crags/location/Italy/Piedmont" class="text-muted">Piedmont</a> / <a href="/crags/location/Italy/Piedmont/Province of Cuneo" class="text-muted">Province of Cuneo</a>
|
|||||||
| 2789 | 1st May 2026 | 16:53:56 UTC | baz9 | climb | Anaconda | crag_id | |
|
Before
None
After
15949
|
|||||||
| 2790 | 1st May 2026 | 16:53:56 UTC | baz9 | climb | Anaconda | crag_name | |
|
Before
None
After
Andonno
|
|||||||
| 2791 | 1st May 2026 | 16:53:56 UTC | baz9 | climb | Anaconda | crag_location_breadcrumb | |
|
Before
None
After
Italy / Piedmont / Province of Cuneo
|
|||||||
| 2792 | 1st May 2026 | 12:48:47 UTC | baz9 | climb | Chocolate Jesus Sit | crag_location_breadcrumb | |
|
Before
None
After
United States / Colorado / Boulder County
|
|||||||
| 2793 | 1st May 2026 | 12:48:47 UTC | baz9 | climb | Chocolate Jesus Sit | 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/Boulder County" class="text-muted">Boulder County</a>
|
|||||||
| 2794 | 1st May 2026 | 12:48:47 UTC | baz9 | climb | Chocolate Jesus Sit | crag_name | |
|
Before
None
After
Wild Basin
|
|||||||
| 2795 | 1st May 2026 | 12:48:47 UTC | baz9 | climb | Chocolate Jesus Sit | crag_id | |
|
Before
None
After
33998
|
|||||||
| 2796 | 1st May 2026 | 12:47:15 UTC | baz9 | climb | A1 | crag_id | |
|
Before
None
After
21326
|
|||||||
| 2797 | 1st May 2026 | 12:47:15 UTC | baz9 | climb | A1 | crag_name | |
|
Before
None
After
Jessica's
|
|||||||
| 2798 | 1st May 2026 | 12:46:39 UTC | baz9 | climb | A1 | Website | |
|
Before
None
After
https://www.thecrag.com/en/climbing/australia/north-west/jessiccas/route/142290165
|
|||||||
| 2799 | 30th April 2026 | 21:30:33 UTC | baz9 | ascent | Matthew Mendes's ascent of Last Wave Goodbye | suggested_grade_id | |
|
Before
None
After
39
|
|||||||
| 2800 | 30th April 2026 | 21:30:20 UTC | baz9 | media | https://www.instagram.com/reel/DXxUXSrsHHv/ | url | |
|
Before
None
After
https://www.instagram.com/reel/DXxUXSrsHHv/
|
|||||||