| 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
+ '<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)
|
|||||||
| 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
|
|||||||