| 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 | ||
|---|---|---|---|---|---|---|---|
| 34981 | 4th January 2025 | 18:14:35 | remus | list | Strongest Female 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
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 = true
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))
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.gender = true
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
|
|||||||
| 34982 | 4th January 2025 | 18:14:35 | remus | list | Strongest Female Sport Climbers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/16/strongest-female-sport-climbers'
,'Strongest Female 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
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 = true
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
After
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/16/strongest-female-sport-climbers'
,'Strongest Female 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 = true
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
|
|||||||
| 34983 | 4th January 2025 | 18:14:21 | remus | list | Strongest Male Sport Climbers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/15/strongest-male-sport-climbers'
,'Strongest 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
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 cl.grade_id >= 21
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/15/strongest-male-sport-climbers'
,'Strongest 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 cl.grade_id >= 21
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
|
|||||||
| 34984 | 4th January 2025 | 18:14:21 | remus | list | Strongest Male 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
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 cl.grade_id >= 21
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.gender = false
and cl.grade_id >= 21
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
|
|||||||
| 34985 | 4th January 2025 | 18:13:02 | remus | list | Hardest Boulder Problem Flashers | 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_first_go_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 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
and ast.ascent_style_id in (2,3)
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_first_go_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 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
and ast.ascent_style_id in (2,3)
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
|
|||||||
| 34986 | 4th January 2025 | 18:12:48 | remus | list | Strongest Female Boulderers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/18/strongest-female-boulderers'
,'Strongest Female 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 = true
and g.order_on >= 40
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not c.climber_id = 634
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/18/strongest-female-boulderers'
,'Strongest Female 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
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 = true
and g.order_on >= 40
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not c.climber_id = 634
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 34987 | 4th January 2025 | 18:12:48 | remus | list | Strongest Female 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
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 = true
and g.order_on >= 40
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not c.climber_id = 634
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.gender = true
and g.order_on >= 40
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and not c.climber_id = 634
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
|
|||||||
| 34988 | 4th January 2025 | 18:12:14 | remus | list | Strongest Male Boulderers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/17/strong-british-male-boulderers'
,'Strongest 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 g.order_on >= 42
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/17/strong-british-male-boulderers'
,'Strongest 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
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 g.order_on >= 42
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
|
|||||||
| 34989 | 4th January 2025 | 18:11:56 | remus | list | Strongest Male 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
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 g.order_on >= 42
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.gender = false
and g.order_on >= 42
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
|
|||||||
| 34990 | 4th January 2025 | 18:11:09 | remus | list | Strong British Male 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
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 = 1
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.gender = false
and c.country_id = 1
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
|
|||||||
| 34991 | 4th January 2025 | 18:02:09 | remus | climb | Mind to Motion | kaya_url | |
|
Before
None
After
https://kaya-app.kayaclimb.com/climb/Mind-to-Motion-8B-RMNP-274567
|
|||||||
| 34992 | 4th January 2025 | 18:00:38 | remus | climb | Perpetual Motion | mountain_project_url | |
|
Before
None
After
https://www.mountainproject.com/route/113992568/perpetual-motion
|
|||||||
| 34993 | 4th January 2025 | 17:51:49 | remus | climb | Vodni Svet | climb_name | |
|
Before
Water World
After
Vodni Svet
|
|||||||
| 34994 | 4th January 2025 | 17:50:21 | remus | crag | Mišja Peč | crag_name | |
|
Before
Misja Pec
After
Mišja Peč
|
|||||||
| 34995 | 4th January 2025 | 17:49:56 | remus | climb | Vicious Circle | ukc_url | |
|
Before
None
After
https://www.ukclimbing.com/logbook/crags/misja_pec-3547/vicious_circle-752619
|
|||||||
| 34996 | 4th January 2025 | 17:46:19 | remus | climb | Strelovod | eight_a_nu_url | |
|
Before
None
After
https://www.8a.nu/crags/sportclimbing/slovenia/misja-pec-ogmfd/sectors/unknown-sector/routes/strelovod/
|
|||||||
| 34997 | 4th January 2025 | 17:45:55 | remus | climb | Histerija | eight_a_nu_url | |
|
Before
None
After
https://www.8a.nu/crags/sportclimbing/slovenia/misja-pec-ogmfd/sectors/unknown-sector-9f025/routes/histerija/
|
|||||||
| 34998 | 4th January 2025 | 17:44:37 | remus | media | /file/84998eb6-c8f3-a112-8d9b-7629ede1d173/Screenshot_2025_01_04_at_17.39.23.png | attribution_climber_id | |
|
Before
None
After
501
|
|||||||
| 34999 | 4th January 2025 | 17:44:37 | remus | media | /file/84998eb6-c8f3-a112-8d9b-7629ede1d173/Screenshot_2025_01_04_at_17.39.23.png | url | |
|
Before
None
After
/file/84998eb6-c8f3-a112-8d9b-7629ede1d173/Screenshot_2025_01_04_at_17.39.23.png
|
|||||||
| 35000 | 4th January 2025 | 17:44:37 | remus | media | /file/84998eb6-c8f3-a112-8d9b-7629ede1d173/Screenshot_2025_01_04_at_17.39.23.png | embed_code | |
|
Before
None
After
<img src="/file/84998eb6-c8f3-a112-8d9b-7629ede1d173/Screenshot_2025_01_04_at_17.39.23.png" class="img-fluid">
|
|||||||