Change Log for Hard Sport Climbing Onsights by Women

Overview

Total Changes

10

First Change

16th Oct 2024

Last Change

1st Dec 2024

Log

Date Time User Type Name Attribute
1 1st December 2024 16:33:28 remus - - hidden
Before
true
After
false
2 16th October 2024 07:33:44 remus - - list_type_name
Before
Bouldering
After
Sport Climbing
3 16th October 2024 07:33:44 remus - - list_type_id
Before
1
After
2
4 16th October 2024 07:33:24 remus - - list_type_name
Before
None
After
Bouldering
5 16th October 2024 07:33:24 remus - - list_type_id
Before
None
After
1
6 16th October 2024 07:33:24 remus - - hidden
Before
false
After
true
7 16th October 2024 07:33:24 remus - - list_description_pretty
Before
None
After
<p>Onsight ascents by women of sport routes graded 8b+ or harder.</p>
8 16th October 2024 07:33:24 remus - - list_definition
Before
None
After
select '<a href="/climber/' || cast(c.climber_id as varchar) || '">' || c.climber_name || '</a>' as Climber ,'<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>' as Climb ,g.grade as Grade ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date" from ascents a 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 ascent_styles asty on a.ascent_style_id = asty.ascent_style_id where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and c.gender = true and a.exclude_reason is null and c.exclude_reason is null and cl.exclude_reason is null and g.grade_id >= 16 and cl.climb_type = 1 and a.ascent_type_id = 1 and a.ascent_style_id = 3 order by g.grade_id desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before

+++ after

@@ -1 +1,33 @@

-
+select
+ '' || c.climber_name || '' as Climber
+ ,'' || cl.climb_name || '' as Climb
+ ,g.grade as Grade
+ ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date"
+
+from
+ ascents a
+ 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 ascent_styles asty
+ on a.ascent_style_id = asty.ascent_style_id
+
+where
+ a.deleted_on is null
+ and c.deleted_on is null
+ and cl.deleted_on is null
+ and c.gender = true
+ and a.exclude_reason is null
+ and c.exclude_reason is null
+ and cl.exclude_reason is null
+ and g.grade_id >= 16
+ and cl.climb_type = 1
+ and a.ascent_type_id = 1
+ and a.ascent_style_id = 3
+
+order by
+ g.grade_id desc
+ ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
9 16th October 2024 07:33:24 remus - - list_description
Before
None
After
Onsight ascents by women of sport routes graded 8b+ or harder.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Onsight ascents by women of sport routes graded 8b+ or harder.
10 16th October 2024 07:33:24 remus - - list_name
Before
None
After
Hard Sport Climbing Onsights by Women

Page 1