| Name | Type | # Changes | Last Updated | First Updated | |
|---|---|---|---|---|---|
| 1 | https://www.youtube.com/watch?v=kpbCmJGkKHE | media | 108 | 14th July 2024 | 14th July 2024 |
| 2 | https://www.instagram.com/p/DF5XgLjMdJu/ | media | 69 | 23rd April 2025 | 10th February 2025 |
| 3 | Hard Rock | list | 66 | 31st July 2024 | 27th July 2024 |
| 4 | https://www.instagram.com/p/DGD2HHVM4yn/ | media | 60 | 23rd April 2025 | 14th February 2025 |
| 5 | https://open.spotify.com/episode/0cHKL3jWvp8A4QcZ1LS0YM | media | 51 | 6th October 2024 | 10th April 2024 |
| 6 | None | None | 41 | 18th July 2025 | 6th March 2025 |
| 7 | https://www.instagram.com/p/C09aKQQtBaT/ | media | 39 | 2nd November 2024 | 17th December 2023 |
| 8 | Remus Knowles | climber | 35 | 24th May 2025 | 30th March 2024 |
| 9 | Aidan Roberts's ascent of Arrival of the Birds | ascent | 33 | 9th July 2024 | 13th December 2023 |
| 10 | Mountain 32 | library item | 33 | 27th June 2025 | 24th June 2025 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 31301 | 20th January 2025 | 21:31:28 | remus | list | Strong Norwegian Boulderers | generate_meta | |
|
Before
None
After
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/3/strong-british-male-boulderers'
,'Strong British Male Boulderers - #' || row_number() over (order by g.grade desc, count(*) desc, min(order_dt(a.ascent_dt_start, a.ascent_dt_end)))::varchar
,27
from
ascents a
inner join ascent_styles ast
on a.ascent_style_id = ast.ascent_style_id
inner join climbers c
on a.climber_id = c.climber_id
inner join climbs cl
on a.climb_id = cl.climb_id
inner join grades g
on cl.grade_id = g.grade_id
inner join hardest_ascent ha
on c.climber_id = ha.climber_id
and cl.grade_id = ha.max_grade_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 2
and c.gender = false
and c.country_id = 5
and g.order_on >= 39
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 31302 | 20th January 2025 | 21:31:28 | remus | list | Strong Norwegian Boulderers | list_description | |
|
Before
None
After
The best Norwegian male boulderers.
This list aims to list any male Norwegian boulderer who has climbed 8B or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Diff
--- before
|
|||||||
| 31303 | 20th January 2025 | 21:31:28 | remus | list | Strong Norwegian Boulderers | list_type_name | |
|
Before
None
After
Bouldering
|
|||||||
| 31304 | 20th January 2025 | 21:28:14 | remus | ascent | Fred Nicole's ascent of Chakijana | ascent_dt_start | |
|
Before
2016-01-01
After
2016-10-01
|
|||||||
| 31305 | 20th January 2025 | 21:28:14 | remus | ascent | Fred Nicole's ascent of Chakijana | notes | |
|
Before
None
After
### References
[1] [https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands](https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands)
Diff
--- before
|
|||||||
| 31306 | 20th January 2025 | 21:28:14 | remus | ascent | Fred Nicole's ascent of Chakijana | notes_pretty | |
|
Before
None
After
<h3>References</h3>
<p>[1] <a href="https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands">https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands</a></p>
|
|||||||
| 31307 | 20th January 2025 | 21:28:14 | remus | ascent | Fred Nicole's ascent of Chakijana | ascent_dt_end | |
|
Before
2017-01-01
After
2016-11-01
|
|||||||
| 31308 | 20th January 2025 | 21:26:56 | remus | ascent | Fred Nicole's ascent of Chakijana | Ascent # | |
|
Before
None
After
1
|
|||||||
| 31309 | 20th January 2025 | 21:26:56 | remus | ascent | Fred Nicole's ascent of Chakijana | ascent_dt_start | |
|
Before
None
After
2016-01-01
|
|||||||
| 31310 | 20th January 2025 | 21:26:56 | remus | ascent | Fred Nicole's ascent of Chakijana | ascent_dt_end | |
|
Before
None
After
2017-01-01
|
|||||||
| 31311 | 20th January 2025 | 21:26:56 | remus | ascent | Fred Nicole's ascent of Chakijana | ascent_type_id | |
|
Before
None
After
2
|
|||||||
| 31312 | 20th January 2025 | 21:26:56 | remus | ascent | Fred Nicole's ascent of Chakijana | climb_id | |
|
Before
None
After
4572
|
|||||||
| 31313 | 20th January 2025 | 21:26:56 | remus | ascent | Fred Nicole's ascent of Chakijana | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 31314 | 20th January 2025 | 21:26:56 | remus | ascent | Fred Nicole's ascent of Chakijana | climber_id | |
|
Before
None
After
526
|
|||||||
| 31315 | 20th January 2025 | 21:26:46 | remus | climb | Chakijana | grade_id | |
|
Before
None
After
41
|
|||||||
| 31316 | 20th January 2025 | 21:26:46 | remus | climb | Chakijana | climb_name | |
|
Before
None
After
Chakijana
|
|||||||
| 31317 | 20th January 2025 | 21:26:46 | remus | climb | Chakijana | ukc_url | |
|
Before
None
After
https://www.ukclimbing.com/logbook/crags/rocklands_western_cape-4048/chakijana-608507
|
|||||||
| 31318 | 20th January 2025 | 21:26:46 | remus | climb | Chakijana | climb_type | |
|
Before
None
After
2
|
|||||||
| 31319 | 20th January 2025 | 21:25:08 | remus | ascent | Rubén Díaz Torres's ascent of Gogoan | Ascent # | |
|
Before
None
After
1
|
|||||||
| 31320 | 20th January 2025 | 21:25:07 | remus | ascent | Rubén Díaz Torres's ascent of Gogoan | ascent_style_id | |
|
Before
None
After
1
|
|||||||