Change Log for Hardest Boulder Problem Flashers

Overview

Total Changes

7

First Change

2nd Nov 2024

Last Change

4th Jan 2025

Log

Date Time User Type Name Attribute
1 4th January 2025 18:13:02 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_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

+++ after

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

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
2 2nd November 2024 09:02:53 remus - - list_type_id
Before
None
After
1
3 2nd November 2024 09:02:53 remus - - list_description_pretty
Before
None
After
<p>Which climbers are the best at flashing hard problems? This list aims to list anyone who has flashed 8B or harder.</p>
4 2nd November 2024 09:02:53 remus - - list_type_name
Before
None
After
Bouldering
5 2nd November 2024 09:02:53 remus - - list_description
Before
None
After
Which climbers are the best at flashing hard problems? This list aims to list anyone who has flashed 8B or harder.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Which climbers are the best at flashing hard problems? This list aims to list anyone who has flashed 8B or harder.
6 2nd November 2024 09:02:53 remus - - list_name
Before
None
After
Hardest Boulder Problem Flashers
7 2nd November 2024 09:02:53 remus - - list_definition
Before
None
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 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

+++ after

@@ -1 +1,40 @@

-
+select
+ '' || c.climber_name || '' as Climber
+ ,g.grade as Grade
+ ,string_agg('' || cl.climb_name || '', ', ' 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))

Page 1