| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 14th October 2024 | 12:36:21 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date"
,coalesce(a.notes_pretty,'') as "Notes"
from
ascents a
inner join climbs c
on a.climb_id = c.climb_id
inner join grades g
on c.grade_id = g.grade_id
inner join climbers cl
on a.climber_id = cl.climber_id
where
c.climb_type = 1
and a.ascent_style_id in (2,3)
and g.order_on >= 14
and a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and a.exclude_reason is null
and c.exclude_reason is null
and cl.exclude_reason is null
and cl.nationality = 'GB'
and not a.ascent_type_id = 6
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
,g.order_on desc
After
select
'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date"
,coalesce(a.notes_pretty,'') as "Notes"
from
ascents a
inner join climbs c
on a.climb_id = c.climb_id
inner join grades g
on c.grade_id = g.grade_id
inner join climbers cl
on a.climber_id = cl.climber_id
where
c.climb_type = 1
and a.ascent_style_id in (2,3)
and g.order_on >= 14
and a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and a.exclude_reason is null
and c.exclude_reason is null
and cl.exclude_reason is null
and cl.country_id = 1
and not a.ascent_type_id = 6
order by
order_dt(a.ascent_dt_start, a.ascent_dt_end)
,g.order_on desc
Diff
--- before
|
|||||||
| 2 | 30th August 2024 | 06:45:21 | remus | - | - | list_type_name | |
|
Before
Misc.
After
Nationality
|
|||||||
| 3 | 30th August 2024 | 06:45:21 | remus | - | - | list_type_id | |
|
Before
5
After
4
|
|||||||
| 4 | 8th May 2024 | 10:09:14 | remus | - | - | list_description_pretty | |
|
Before
<p>A list of hard flash or onsight ascents by British men and women a.k.a The Steve McClure list. Focus is on ascents in the UK, but not exclusively so.</p>
After
<p>A list of hard flash or onsight ascents by British men and women. Focus is on ascents in the UK, but not exclusively so.</p>
|
|||||||
| 5 | 8th May 2024 | 10:09:14 | remus | - | - | list_description | |
|
Before
A list of hard flash or onsight ascents by British men and women a.k.a The Steve McClure list. Focus is on ascents in the UK, but not exclusively so.
After
A list of hard flash or onsight ascents by British men and women. Focus is on ascents in the UK, but not exclusively so.
Diff
--- before
|
|||||||
| 6 | 23rd April 2023 | 16:50:09 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 7 | 23rd April 2023 | 16:39:43 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 8 | 11th June 2022 | 09:51:54 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 9 | 19th October 2021 | 17:17:48 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 10 | 18th June 2021 | 06:36:00 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 11 | 18th June 2021 | 06:34:44 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||
| 12 | 18th June 2021 | 06:33:40 | remus | - | - | - | |
|
Before
None
After
None
|
|||||||