Change Log for Strong British Male Sport Climbers

Overview

Total Changes

23

First Change

30th Sep 2021

Last Change

4th Jan 2025

Log

Date Time User Type Name Attribute
1 4th January 2025 18:15:08 remus - - 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
2 4th January 2025 18:15:08 remus - - 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

+++ after

@@ -16,6 +16,7 @@

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
3 14th October 2024 12:34:26 remus - - 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.nationality = 'GB' 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 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

+++ after

@@ -23,7 +23,7 @@

and cl.deleted_on is null
and cl.climb_type = 1
and c.gender = false
- and c.nationality = 'GB'
+ and c.country_id = 1
and cl.grade_id >= 17
and c.exclude_reason is null
and cl.exclude_reason is null
4 14th October 2024 12:34:26 remus - - 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.nationality = 'GB' 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 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
5 30th August 2024 06:35:56 remus - - list_type_id
Before
5
After
4
6 30th August 2024 06:35:56 remus - - list_type_name
Before
Misc.
After
Nationality
7 10th April 2024 05:55:20 remus - - 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>', ', ') 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.nationality = 'GB' 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 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.nationality = 'GB' 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

+++ after

@@ -1,7 +1,7 @@

select
'' || c.climber_name || '' as Climber
,g.grade as Grade
- ,string_agg('' || cl.climb_name || '', ', ') as Climbs
+ ,string_agg('' || cl.climb_name || '', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs

from
ascents a
8 14th November 2023 17:23:16 remus - - -
Before
None
After
None
9 14th November 2023 17:23:16 remus - - list_description
Before
The best British male sport climbers. This list aims to list any male British 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. test
After
The best British male sport climbers. This list aims to list any male British 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.
10 14th November 2023 17:23:16 remus - - list_description_pretty
Before
<p>The best British male sport climbers.</p> <p>This list aims to list any male British 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> <p>test</p>
After
<p>The best British male sport climbers.</p> <p>This list aims to list any male British 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>
11 14th November 2023 17:23:08 remus - - -
Before
None
After
None
12 14th November 2023 17:23:07 remus - - list_description
Before
The best British male sport climbers. This list aims to list any male British 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 British male sport climbers. This list aims to list any male British 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. test
13 14th November 2023 17:23:07 remus - - list_description_pretty
Before
<p>The best British male sport climbers.</p> <p>This list aims to list any male British 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 British male sport climbers.</p> <p>This list aims to list any male British 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> <p>test</p>
14 5th May 2023 06:57:05 remus - - -
Before
None
After
None
15 5th May 2023 06:56:38 remus - - -
Before
None
After
None
16 5th May 2023 06:40:28 remus - - -
Before
None
After
None
17 20th October 2022 04:45:52 remus - - -
Before
None
After
None
18 11th June 2022 09:49:54 remus - - -
Before
None
After
None
19 1st February 2022 07:50:29 remus - - -
Before
None
After
None
20 1st February 2022 07:49:50 remus - - -
Before
None
After
None

Page 1 >