| 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 | ||
|---|---|---|---|---|---|---|---|
| 30581 | 21st January 2025 | 07:42:01 | remus | ascent | Magnus Midtbø's ascent of Blood Redemption | notes | |
|
Before
FA
After
None
Diff
--- before
|
|||||||
| 30582 | 21st January 2025 | 07:42:01 | remus | ascent | Magnus Midtbø's ascent of Blood Redemption | notes_pretty | |
|
Before
<p>FA</p>
After
None
|
|||||||
| 30583 | 21st January 2025 | 07:41:55 | remus | ascent | Magnus Midtbø's ascent of Blood Redemption | Ascent # | |
|
Before
None
After
1
|
|||||||
| 30584 | 21st January 2025 | 06:48:47 | remus | list | Strong Norwegian Sport Climbers | list_name | |
|
Before
Strong Norwegian Male Sport Climbers
After
Strong Norwegian Sport Climbers
|
|||||||
| 30585 | 21st January 2025 | 06:48:47 | remus | list | Strong Norwegian Sport Climbers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/50/strong-norwegian-male-sport-climbers
,'Strong Norwegian Male Sport Climbers - #' || 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
and cl.climb_type_id = ha.climb_type
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 1
and c.gender = false
and c.country_id = 5
and cl.grade_id >= 17
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not a.ascent_type_id = 6
group by
c.climber_name
,g.grade
,c.climber_id
After
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/50/strong-norwegian-sport-climbers
,'Strong Norwegian Sport Climbers - #' || 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
and cl.climb_type_id = ha.climb_type
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 1
and c.country_id = 5
and cl.grade_id >= 19
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not a.ascent_type_id = 6
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 30586 | 21st January 2025 | 06:48:47 | remus | list | Strong Norwegian Sport Climbers | list_description_pretty | |
|
Before
<p>The best Norwegian male sport climbers.</p>
<p>This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
After
<p>The best Norwegian sport climbers.</p>
<p>This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
|
|||||||
| 30587 | 21st January 2025 | 06:48:47 | remus | list | Strong Norwegian Sport Climbers | list_definition | |
|
Before
select
'<a href="/climber/' || cast(c.climber_id as varchar) || '">' || c.climber_name || '</a>' as Climber
,g.grade as Grade
,string_agg('<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs
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
and cl.climb_type_id = ha.climb_type
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 1
and c.gender = false
and c.country_id = 5
and cl.grade_id >= 17
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not a.ascent_type_id = 6
group by
c.climber_name
,g.grade
,c.climber_id
order by
g.grade desc
,count(*) desc
,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))
After
select
'<a href="/climber/' || cast(c.climber_id as varchar) || '">' || c.climber_name || '</a>' as Climber
,g.grade as Grade
,string_agg('<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs
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
and cl.climb_type_id = ha.climb_type
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 1
and c.country_id = 5
and cl.grade_id >= 19
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not a.ascent_type_id = 6
group by
c.climber_name
,g.grade
,c.climber_id
order by
g.grade desc
,count(*) desc
,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))
Diff
--- before
|
|||||||
| 30588 | 21st January 2025 | 06:48:47 | remus | list | Strong Norwegian Sport Climbers | list_description | |
|
Before
The best Norwegian male sport climbers.
This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
After
The best Norwegian sport climbers.
This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Diff
--- before
|
|||||||
| 30589 | 21st January 2025 | 06:46:32 | remus | list | Strong Norwegian Boulderers | list_description | |
|
Before
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.
After
The best Norwegian boulderers.
This list aims to list any 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
|
|||||||
| 30590 | 21st January 2025 | 06:46:32 | remus | list | Strong Norwegian Boulderers | list_description_pretty | |
|
Before
<p>The best Norwegian male boulderers.</p>
<p>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.</p>
After
<p>The best Norwegian boulderers.</p>
<p>This list aims to list any 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.</p>
|
|||||||
| 30591 | 21st January 2025 | 06:46:32 | remus | list | Strong Norwegian Boulderers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/49/strongest-norwegian-boulderers'
,'Strong Norwegian 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
After
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/49/strongest-norwegian-boulderers'
,'Strong Norwegian 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.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
|
|||||||
| 30592 | 21st January 2025 | 06:46:32 | remus | list | Strong Norwegian Boulderers | list_definition | |
|
Before
select
'<a href="/climber/' || cast(c.climber_id as varchar) || '">' || c.climber_name || '</a>' as Climber
,g.grade as Grade
,string_agg('<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs
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
and cl.climb_type_id = ha.climb_type
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
order by
g.grade desc
,count(*) desc
,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))
After
select
'<a href="/climber/' || cast(c.climber_id as varchar) || '">' || c.climber_name || '</a>' as Climber
,g.grade as Grade
,string_agg('<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs
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
and cl.climb_type_id = ha.climb_type
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.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
order by
g.grade desc
,count(*) desc
,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))
Diff
--- before
|
|||||||
| 30593 | 20th January 2025 | 22:03:53 | remus | climber | Jarle Risa | instagram_url | |
|
Before
None
After
https://www.instagram.com/jarlerisa/
|
|||||||
| 30594 | 20th January 2025 | 21:47:06 | remus | climber | Jarle Risa | eight_a_nu_url | |
|
Before
None
After
https://www.8a.nu/user/jarle-risa/sportclimbing
|
|||||||
| 30595 | 20th January 2025 | 21:35:24 | remus | list | Strong Norwegian Sport Climbers | generate_meta | |
|
Before
None
After
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/50/strong-norwegian-male-sport-climbers
,'Strong Norwegian Male Sport Climbers - #' || 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
and cl.climb_type_id = ha.climb_type
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 1
and c.gender = false
and c.country_id = 5
and cl.grade_id >= 17
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not a.ascent_type_id = 6
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 30596 | 20th January 2025 | 21:34:38 | remus | list | Strong Norwegian Boulderers | generate_meta | |
|
Before
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
After
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/49/strongest-norwegian-boulderers'
,'Strong Norwegian 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
|
|||||||
| 30597 | 20th January 2025 | 21:33:55 | remus | list | Strong Norwegian Sport Climbers | list_description | |
|
Before
None
After
The best Norwegian male sport climbers.
This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Diff
--- before
|
|||||||
| 30598 | 20th January 2025 | 21:33:55 | remus | list | Strong Norwegian Sport Climbers | list_type_id | |
|
Before
None
After
4
|
|||||||
| 30599 | 20th January 2025 | 21:33:55 | remus | list | Strong Norwegian Sport Climbers | hidden | |
|
Before
false
After
true
|
|||||||
| 30600 | 20th January 2025 | 21:33:55 | remus | list | Strong Norwegian Sport Climbers | list_description_pretty | |
|
Before
None
After
<p>The best Norwegian male sport climbers.</p>
<p>This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
|
|||||||