| 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 | ||
|---|---|---|---|---|---|---|---|
| 2381 | 4th May 2026 | 01:21:40 UTC | baz9 | climb | Morphine | crag_id | |
|
Before
None
After
34231
|
|||||||
| 2382 | 4th May 2026 | 01:21:40 UTC | baz9 | climb | Morphine | crag_name | |
|
Before
None
After
221
|
|||||||
| 2383 | 4th May 2026 | 01:21:28 UTC | baz9 | climb | Cradle to the Grave | crag_name | |
|
Before
None
After
221
|
|||||||
| 2384 | 4th May 2026 | 01:21:28 UTC | baz9 | climb | Cradle to the Grave | crag_id | |
|
Before
None
After
34231
|
|||||||
| 2385 | 4th May 2026 | 01:21:10 UTC | baz9 | climb | Afterlife | crag_id | |
|
Before
None
After
34231
|
|||||||
| 2386 | 4th May 2026 | 01:21:10 UTC | baz9 | climb | Afterlife | crag_name | |
|
Before
None
After
221
|
|||||||
| 2387 | 4th May 2026 | 01:20:51 UTC | baz9 | crag | 221 | eight_a_nu_url | |
|
Before
None
After
https://www.8a.nu/crags/bouldering/united-states/221
Diff
--- before
|
|||||||
| 2388 | 4th May 2026 | 01:20:38 UTC | baz9 | crag | 221 | Website | |
|
Before
None
After
https://kaya-app.kayaclimb.com/location/221-14492844
|
|||||||
| 2389 | 4th May 2026 | 01:20:23 UTC | baz9 | crag | 221 | crag_name | |
|
Before
None
After
221
|
|||||||
| 2390 | 4th May 2026 | 01:15:40 UTC | baz9 | crag | Vat Burn | longitude | |
|
Before
None
After
-2.9558
|
|||||||
| 2391 | 4th May 2026 | 01:15:40 UTC | baz9 | crag | Vat Burn | latitude | |
|
Before
None
After
57.0874
|
|||||||
| 2392 | 3rd May 2026 | 18:10:33 UTC | baz9 | list | Climbs Without a Crag | list_definition | |
|
Before
select
'<a href="' || c.url || '">' || c.climb_name || '</a>' as Climb
,g.grade || ' ' || ct.climb_type as Grade
,case
when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
,case when c.eight_a_nu_url is not null then
'<a href="' ||
substring(c.eight_a_nu_url from '^(.+)/sectors/') ||
'">' ||
initcap(replace(split_part(c.eight_a_nu_url, '/', 7), '-', ' ')) ||
'</a>'
else null
end as "8a.nu Crag"
,case when c.eight_a_nu_url is not null then
'<a href="' ||
substring(c.eight_a_nu_url from '^(.+)/sectors/') ||
'/routes?sector=' ||
split_part(c.eight_a_nu_url, '/', 9) ||
'">' ||
initcap(replace(split_part(c.eight_a_nu_url, '/', 9), '-', ' ')) ||
'</a>'
else null
end as "8a.nu Sector"
,case
when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">thecrag.com</a>'
else null
end as "theCrag"
,case
when w.mountain_project_url is not null then '<a href="' || w.mountain_project_url || '">Mountain Project</a>'
else null
end as "Mountain Project"
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
left join (
select
cm.climb_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(case when cm.value ilike '%mountainproject.com%' then cm.value end) as mountain_project_url
from
climb_meta cm
where
cm.climb_meta_key_id = 30
group by
cm.climb_id
) w
on w.climb_id = c.climb_id
where
c.deleted_on is null
and c.crag_id is null
order by
c.climb_name
After
select
'<a href="' || c.url || '">' || c.climb_name || '</a>' as Climb
,g.grade || ' ' || ct.climb_type as Grade
,case
when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
,case
when c.eight_a_nu_url is not null then
'<a href="' ||
substring(c.eight_a_nu_url from '^(.+)/sectors/') ||
'">' ||
initcap(replace(split_part(c.eight_a_nu_url, '/', 7), '-', ' ')) ||
'</a>'
else null
end as "8a.nu Crag"
,case
when c.eight_a_nu_url is not null then
'<a href="' ||
substring(c.eight_a_nu_url from '^(.+)/sectors/') ||
'/routes?sector=' ||
split_part(c.eight_a_nu_url, '/', 9) ||
'">' ||
initcap(replace(split_part(c.eight_a_nu_url, '/', 9), '-', ' ')) ||
'</a>'
else null
end as "8a.nu Sector"
,case
when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">thecrag.com</a>'
else null
end as "theCrag"
,case
when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
else null
end as "27crags"
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
left join (
select
cm.climb_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(
case
when cm.value ilike '%27crags.com%'
or cm.value ilike '%thetopo.com%'
then cm.value
end
) as crags27_url
from
climb_meta cm
where
cm.climb_meta_key_id = 30
group by
cm.climb_id
) w
on w.climb_id = c.climb_id
where
c.deleted_on is null
and c.crag_id is null
order by
c.climb_name
Diff
--- before
|
|||||||
| 2393 | 2nd May 2026 | 22:16:40 UTC | baz9 | ascent | Nalle Hukkataival's ascent of Wave Swoop | notes | |
|
Before
### References
[1] [1] [https://youtu.be/pj02Dk4zayU?t=340](https://youtu.be/pj02Dk4zayU?t=340)
After
### References
[1] [https://youtu.be/pj02Dk4zayU?t=340](https://youtu.be/pj02Dk4zayU?t=340)
Diff
--- before
|
|||||||
| 2394 | 2nd May 2026 | 22:16:40 UTC | baz9 | ascent | Nalle Hukkataival's ascent of Wave Swoop | notes_pretty | |
|
Before
<h3>References</h3>
<p>[1] [1] <a href="https://youtu.be/pj02Dk4zayU?t=340">https://youtu.be/pj02Dk4zayU?t=340</a></p>
After
<h3>References</h3>
<p>[1] <a href="https://youtu.be/pj02Dk4zayU?t=340" rel="noopener noreferrer">https://youtu.be/pj02Dk4zayU?t=340</a></p>
|
|||||||
| 2395 | 2nd May 2026 | 22:14:58 UTC | baz9 | climb | Wave Swoop | crag_id | |
|
Before
None
After
34225
|
|||||||
| 2396 | 2nd May 2026 | 22:14:58 UTC | baz9 | climb | Wave Swoop | crag_name | |
|
Before
None
After
Mount Fox
|
|||||||
| 2397 | 2nd May 2026 | 22:14:58 UTC | baz9 | climb | Wave Swoop | crag_location_breadcrumb | |
|
Before
None
After
Australia / Victoria
|
|||||||
| 2398 | 2nd May 2026 | 22:14:58 UTC | baz9 | climb | Wave Swoop | crag_location_breadcrumb_pretty | |
|
Before
None
After
<a href="/crags/location/Australia" class="text-muted">Australia</a> / <a href="/crags/location/Australia/Victoria" class="text-muted">Victoria</a>
|
|||||||
| 2399 | 2nd May 2026 | 22:14:51 UTC | baz9 | climb | Owning the Weather | crag_location_breadcrumb_pretty | |
|
Before
None
After
<a href="/crags/location/Australia" class="text-muted">Australia</a> / <a href="/crags/location/Australia/Victoria" class="text-muted">Victoria</a>
|
|||||||
| 2400 | 2nd May 2026 | 22:14:51 UTC | baz9 | climb | Owning the Weather | crag_name | |
|
Before
None
After
Mount Fox
|
|||||||