| 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 | https://www.instagram.com/p/C09aKQQtBaT/ | media | 39 | 2nd November 2024 | 17th December 2023 |
| 7 | None | None | 38 | 17th June 2025 | 6th March 2025 |
| 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 | Aidan Roberts's ascent of Spots of Time | ascent | 32 | 6th October 2024 | 13th December 2023 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 29501 | 4th January 2025 | 18:15:35 | remus | list | Strong British 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 c.country_id = 1
and cl.grade_id >= 35
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 = true
and c.country_id = 1
and cl.grade_id >= 35
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
|
|||||||
| 29502 | 4th January 2025 | 18:15:22 | remus | list | Strong British 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 c.country_id = 1
and cl.grade_id >= 13
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 c.country_id = 1
and cl.grade_id >= 13
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
|
|||||||
| 29503 | 4th January 2025 | 18:15:22 | remus | list | Strong British Female Sport Climbers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/2/strong-british-female-sport-climbers'
,'Strong British 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 c.country_id = 1
and cl.grade_id >= 13
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/2/strong-british-female-sport-climbers'
,'Strong British 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 c.country_id = 1
and cl.grade_id >= 13
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
|
|||||||
| 29504 | 4th January 2025 | 18:15:08 | remus | list | Strong British Male Sport Climbers | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/1/strong-british-male-sport-climbers'
,'Strong British 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 c.country_id = 1
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/1/strong-british-male-sport-climbers'
,'Strong British 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 = 1
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
|
|||||||
| 29505 | 4th January 2025 | 18:15:08 | remus | list | Strong British 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 c.country_id = 1
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.gender = false
and c.country_id = 1
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))
Diff
--- before
|
|||||||
| 29506 | 4th January 2025 | 18:14:50 | remus | list | Strongest Trad 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 = 3
and g.order_on >= 63
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and a.ascent_type_id not in (6,7,11)
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 = 3
and g.order_on >= 63
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful
and a.ascent_type_id not in (6,7,11)
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
|
|||||||
| 29507 | 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
|
|||||||
| 29508 | 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
|
|||||||
| 29509 | 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
|
|||||||
| 29510 | 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
|
|||||||
| 29511 | 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
|
|||||||
| 29512 | 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
|
|||||||
| 29513 | 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
|
|||||||
| 29514 | 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
|
|||||||
| 29515 | 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
|
|||||||
| 29516 | 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
|
|||||||
| 29517 | 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
|
|||||||
| 29518 | 4th January 2025 | 18:00:38 | remus | climb | Perpetual Motion | mountain_project_url | |
|
Before
None
After
https://www.mountainproject.com/route/113992568/perpetual-motion
|
|||||||
| 29519 | 4th January 2025 | 17:51:49 | remus | climb | Vodni Svet | climb_name | |
|
Before
Water World
After
Vodni Svet
|
|||||||
| 29520 | 4th January 2025 | 17:50:21 | remus | crag | Mišja Peč | crag_name | |
|
Before
Misja Pec
After
Mišja Peč
|
|||||||