| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 14th October 2024 | 12:36:32 | remus | - | - | list_definition | |
|
Before
select
pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date"
,'<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>' as Climb
,g.grade as Grade
,case when a.fa then '✓' else '' end as "First Ascent"
,'<a href="/climber/' || cast(c.climber_id as varchar) || '">' || c.climber_name || '</a>' as Climber
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 c.nationality = 'GB'
and cl.grade_id >= 62
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful = true
and not a.ascent_type_id = 6
and a.fa = true
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
After
select
pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date"
,'<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>' as Climb
,g.grade as Grade
,case when a.fa then '✓' else '' end as "First Ascent"
,'<a href="/climber/' || cast(c.climber_id as varchar) || '">' || c.climber_name || '</a>' as Climber
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 c.country_id = 1
and cl.grade_id >= 62
and c.exclude_reason is null
and cl.exclude_reason is null
and a.exclude_reason is null
and ast.ascent_successful = true
and not a.ascent_type_id = 6
and a.fa = true
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before
+++ after
@@ -21,7 +21,7 @@
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 3
- and c.nationality = 'GB'
+ and c.country_id = 1
and cl.grade_id >= 62
and c.exclude_reason is null
and cl.exclude_reason is null
|
|||||||
| 2 | 30th August 2024 | 06:45:30 | remus | - | - | list_type_name | |
|
Before
Misc.
After
Nationality
|
|||||||
| 3 | 30th August 2024 | 06:45:30 | remus | - | - | list_type_id | |
|
Before
5
After
4
|
|||||||
| 4 | 23rd April 2023 | 16:50:38 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 5 | 23rd April 2023 | 16:40:42 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 6 | 18th April 2022 | 10:06:26 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 7 | 13th April 2022 | 07:05:18 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||