Change Log for The Hardest Trad Routes in the World

Overview

Total Changes

6

First Change

4th Dec 2023

Last Change

30th Aug 2024

Log

Date Time User Type Name Attribute
1 30th August 2024 06:47:05 remus - - list_type_id
Before
5
After
3
2 30th August 2024 06:47:05 remus - - list_type_name
Before
Misc.
After
Trad Climbing
3 4th December 2023 07:22:02 remus - - list_name
Before
None
After
The Hardest Trad Routes in the World
4 4th December 2023 07:22:02 remus - - list_description
Before
None
After
A list of all the trad routes E10 or harder that have currently been climbed, including details of the first ascent.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+A list of all the trad routes E10 or harder that have currently been climbed, including details of the first ascent.
5 4th December 2023 07:22:02 remus - - list_definition
Before
None
After
select '<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as Climb ,g.grade as "Grade" ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" from climbs c inner join grades g on c.grade_id = g.grade_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id where c.deleted_on is null and c.climb_type = 3 and g.order_on >= 63 and c.grade_approx = false order by g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before

+++ after

@@ -1 +1,25 @@

-
+select
+ '' || c.climb_name || '' as Climb
+ ,g.grade as "Grade"
+ ,'' || cl.climber_name || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+
+where
+ c.deleted_on is null
+ and c.climb_type = 3
+ and g.order_on >= 63
+ and c.grade_approx = false
+
+order by
+ g.order_on desc
+ ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
6 4th December 2023 07:22:02 remus - - list_description_pretty
Before
None
After
<p>A list of all the trad routes E10 or harder that have currently been climbed, including details of the first ascent.</p>

Page 1