Change Log for Strong American Female Boulderers

Overview

Total Changes

8

First Change

8th Mar 2025

Last Change

13th Mar 2025

Log

Date Time User Type Name Attribute
1 13th March 2025 07:07:03 remus - - hidden
Before
true
After
false
2 8th March 2025 07:23:29 remus - - list_description
Before
None
After
The best American boulderers. This list aims to list any female American 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

+++ after

@@ -1 +1,3 @@

-
+The best American boulderers.
+
+This list aims to list any female American 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.
3 8th March 2025 07:23:29 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_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 = 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 c.gender = true 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,42 @@

-
+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_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 = 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 c.gender = true
+
+ 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))
4 8th March 2025 07:23:29 remus - - list_description_pretty
Before
None
After
<p>The best American boulderers.</p> <p>This list aims to list any female American 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>
5 8th March 2025 07:23:29 remus - - list_name
Before
None
After
Strong American Female Boulderers
6 8th March 2025 07:23:29 remus - - list_type_id
Before
None
After
4
7 8th March 2025 07:23:29 remus - - list_type_name
Before
None
After
Nationality
8 8th March 2025 07:23:29 remus - - hidden
Before
false
After
true

Page 1