| 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 | ||
|---|---|---|---|---|---|---|---|
| 2461 | 2nd May 2026 | 20:52:30 UTC | baz9 | climb | Free Your Mind | crag_location_breadcrumb_pretty | |
|
Before
None
After
<a href="/crags/location/Germany" class="text-muted">Germany</a> / <a href="/crags/location/Germany/Niedersachsen" class="text-muted">Niedersachsen</a>
|
|||||||
| 2462 | 2nd May 2026 | 20:51:09 UTC | baz9 | list | More Climbs that have existing crags? | list_type_name | |
|
Before
None
After
Admin
|
|||||||
| 2463 | 2nd May 2026 | 20:51:09 UTC | baz9 | list | More Climbs that have existing crags? | list_type_id | |
|
Before
None
After
6
|
|||||||
| 2464 | 2nd May 2026 | 20:51:09 UTC | baz9 | list | More Climbs that have existing crags? | list_description | |
|
Before
None
After
temporary
Diff
--- before
|
|||||||
| 2465 | 2nd May 2026 | 20:51:09 UTC | baz9 | list | More Climbs that have existing crags? | list_definition | |
|
Before
None
After
select
'<a href="' ||
substring(c.eight_a_nu_url from '^(.+)/sectors/') ||
'">' ||
initcap(replace(split_part(c.eight_a_nu_url, '/', 7), '-', ' ')) ||
'</a>' as "8a.nu Crag"
,count(*) as "Climbs Missing"
,string_agg(
'<a href="' || c.url || '">' || c.climb_name || '</a>',
', ' order by c.climb_name
) as "Climbs"
,string_agg(
distinct '<a href="' || cr.url || '">' || cr.crag_name || '</a>',
', ' order by '<a href="' || cr.url || '">' || cr.crag_name || '</a>'
) filter (where cr.crag_id is not null) as "Matching Site Crag"
from
climbs c
left join crags cr
on cr.deleted_on is null
and cr.group_crag_id is null
and cr.eight_a_nu_url = substring(c.eight_a_nu_url from '^(.+)/sectors/')
where
c.deleted_on is null
and c.crag_id is null
and c.eight_a_nu_url is not null
and split_part(c.eight_a_nu_url, '/', 7) not like 'unknown-crag%'
group by
substring(c.eight_a_nu_url from '^(.+)/sectors/')
,split_part(c.eight_a_nu_url, '/', 7)
having
count(cr.crag_id) > 0
order by
count(*) desc
,"8a.nu Crag"
Diff
--- before
|
|||||||
| 2466 | 2nd May 2026 | 20:51:09 UTC | baz9 | list | More Climbs that have existing crags? | list_description_pretty | |
|
Before
None
After
<p>temporary</p>
|
|||||||
| 2467 | 2nd May 2026 | 20:51:09 UTC | baz9 | list | More Climbs that have existing crags? | list_name | |
|
Before
None
After
More Climbs that have existing crags?
|
|||||||
| 2468 | 2nd May 2026 | 19:10:59 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | suggested_grade_id | |
|
Before
None
After
40
|
|||||||
| 2469 | 2nd May 2026 | 19:10:43 UTC | baz9 | media | https://www.instagram.com/reel/DX2J8vqupT8/ | url | |
|
Before
None
After
https://www.instagram.com/reel/DX2J8vqupT8/
|
|||||||
| 2470 | 2nd May 2026 | 19:10:43 UTC | baz9 | media | https://www.instagram.com/reel/DX2J8vqupT8/ | missing_right_to_reproduce | |
|
Before
None
After
false
|
|||||||
| 2471 | 2nd May 2026 | 19:10:42 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | ascent_dt_end | |
|
Before
None
After
2026-05-02
|
|||||||
| 2472 | 2nd May 2026 | 19:10:42 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | ascent_type_id | |
|
Before
None
After
2
|
|||||||
| 2473 | 2nd May 2026 | 19:10:42 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | climber_id | |
|
Before
None
After
1202
|
|||||||
| 2474 | 2nd May 2026 | 19:10:42 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | climb_id | |
|
Before
None
After
5187
|
|||||||
| 2475 | 2nd May 2026 | 19:10:42 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 2476 | 2nd May 2026 | 19:10:42 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | notes | |
|
Before
None
After
### References
[1] [https://www.instagram.com/reel/DX2J8vqupT8/](https://www.instagram.com/reel/DX2J8vqupT8/)
Diff
--- before
|
|||||||
| 2477 | 2nd May 2026 | 19:10:42 UTC | baz9 | ascent | Yannick Flohé's ascent of Brain Rot | notes_pretty | |
|
Before
None
After
<h3>References</h3>
<p>[1] <a href="https://www.instagram.com/reel/DX2J8vqupT8/" rel="noopener noreferrer">https://www.instagram.com/reel/DX2J8vqupT8/</a></p>
|
|||||||
| 2478 | 2nd May 2026 | 15:30:12 UTC | baz9 | climber | Marco Müller | youtube_url | |
|
Before
https://www.youtube.com/@MarcoMullerClimbing
After
https://youtube.com/@marcomuller-f8d
|
|||||||
| 2479 | 2nd May 2026 | 13:56:08 UTC | baz9 | media | https://www.instagram.com/p/DHJpp85sYVU/ | missing_right_to_reproduce | |
|
Before
None
After
false
|
|||||||
| 2480 | 2nd May 2026 | 13:56:08 UTC | baz9 | media | https://www.instagram.com/p/DHJpp85sYVU/ | url | |
|
Before
None
After
https://www.instagram.com/p/DHJpp85sYVU/
|
|||||||