| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 2nd November 2024 | 08:54:39 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climber/' || c.climber_id::varchar || '">' || c.climber_name || '</a>' as Climber
,'<a href="/climb/' || cl.climb_id || '">' || cl.climb_name || '</a>' as Climb
,g.grade as Grade
,ast.ascent_style as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "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 ast
on a.ascent_style_id = ast.ascent_style_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 3
and a.ascent_style_id in (2,3)
and g.order_on >= 61
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
After
select
'<a href="/climber/' || c.climber_id::varchar || '">' || c.climber_name || '</a>' as Climber
,'<a href="/climb/' || cl.climb_id || '">' || cl.climb_name || '</a>' as Climb
,g.grade as Grade
,ast.ascent_style as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "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 ast
on a.ascent_style_id = ast.ascent_style_id
inner join ascent_types aty
on a.ascent_type_id = aty.ascent_type_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 3
and a.ascent_style_id in (2,3)
and g.order_on >= 61
and aty.ascent_type_id in (1,3,5,8,9)
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before
+++ after
@@ -15,6 +15,8 @@
on cl.grade_id = g.grade_id
inner join ascent_styles ast
on a.ascent_style_id = ast.ascent_style_id
+ inner join ascent_types aty
+ on a.ascent_type_id = aty.ascent_type_id
where
a.deleted_on is null
@@ -23,6 +25,7 @@
and cl.climb_type = 3
and a.ascent_style_id in (2,3)
and g.order_on >= 61
+ and aty.ascent_type_id in (1,3,5,8,9)
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
|
|||||||
| 2 | 30th August 2024 | 06:47:40 | remus | - | - | list_type_name | |
|
Before
Misc.
After
Trad Climbing
|
|||||||
| 3 | 30th August 2024 | 06:47:40 | remus | - | - | list_type_id | |
|
Before
5
After
3
|
|||||||
| 4 | 20th December 2023 | 14:43:15 | remus | - | - | list_definition | |
|
Before
select
c.climber_name as Climber
,cl.climb_name as Climb
,g.grade as Grade
,ast.ascent_style as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "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 ast
on a.ascent_style_id = ast.ascent_style_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 3
and a.ascent_style_id in (2,3)
and g.order_on >= 61
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
After
select
'<a href="/climber/' || c.climber_id::varchar || '">' || c.climber_name || '</a>' as Climber
,'<a href="/climb/' || cl.climb_id || '">' || cl.climb_name || '</a>' as Climb
,g.grade as Grade
,ast.ascent_style as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "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 ast
on a.ascent_style_id = ast.ascent_style_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 3
and a.ascent_style_id in (2,3)
and g.order_on >= 61
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before
+++ after
@@ -1,6 +1,6 @@
select
- c.climber_name as Climber
- ,cl.climb_name as Climb
+ '<a href="/climber/' || c.climber_id::varchar || '">' || c.climber_name || '</a>' as Climber
+ ,'<a href="/climb/' || cl.climb_id || '">' || cl.climb_name || '</a>' as Climb
,g.grade as Grade
,ast.ascent_style as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
|
|||||||
| 5 | 20th December 2023 | 13:58:54 | remus | - | - | list_description_pretty | |
|
Before
None
After
<p>A non-definitive list of some hard trad onsights and flashes.</p>
|
|||||||
| 6 | 20th December 2023 | 13:58:54 | remus | - | - | list_definition | |
|
Before
None
After
select
c.climber_name as Climber
,cl.climb_name as Climb
,g.grade as Grade
,ast.ascent_style as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "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 ast
on a.ascent_style_id = ast.ascent_style_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 3
and a.ascent_style_id in (2,3)
and g.order_on >= 61
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before
+++ after
@@ -1 +1,28 @@
-
+select
+ c.climber_name as Climber
+ ,cl.climb_name as Climb
+ ,g.grade as Grade
+ ,ast.ascent_style as "Style"
+ ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "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 ast
+ on a.ascent_style_id = ast.ascent_style_id
+
+where
+ a.deleted_on is null
+ and c.deleted_on is null
+ and cl.deleted_on is null
+ and cl.climb_type = 3
+ and a.ascent_style_id in (2,3)
+ and g.order_on >= 61
+
+order by
+ order_dt(a.ascent_dt_start, a.ascent_dt_end)
|
|||||||
| 7 | 20th December 2023 | 13:58:54 | remus | - | - | list_description | |
|
Before
None
After
A non-definitive list of some hard trad onsights and flashes.
Diff
--- before
+++ after
@@ -1 +1 @@
-
+A non-definitive list of some hard trad onsights and flashes.
|
|||||||
| 8 | 20th December 2023 | 13:58:54 | remus | - | - | list_name | |
|
Before
None
After
Hard Trad Onsights and Flashes
|
|||||||