| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 30th August 2024 | 06:47:05 | remus | - | - | list_type_name | |
|
Before
Misc.
After
Trad Climbing
|
|||||||
| 2 | 30th August 2024 | 06:47:05 | remus | - | - | list_type_id | |
|
Before
5
After
3
|
|||||||
| 3 | 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>
|
|||||||
| 4 | 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
+ '<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)
|
|||||||
| 5 | 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.
|
|||||||
| 6 | 4th December 2023 | 07:22:02 | remus | - | - | list_name | |
|
Before
None
After
The Hardest Trad Routes in the World
|
|||||||