| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 30th August 2024 | 06:46:14 | remus | - | - | list_type_id | |
|
Before
5
After
1
|
|||||||
| 2 | 30th August 2024 | 06:46:14 | remus | - | - | list_type_name | |
|
Before
Misc.
After
Bouldering
|
|||||||
| 3 | 23rd July 2024 | 15:00:36 | remus | - | - | list_definition | |
|
Before
select
pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
,'<a href="/climber/' || cast(cl.climber_id as varchar) || '">' || cl.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
from
ascents a
inner join climbs c
on a.climb_id = c.climb_id
inner join climbers cl
on a.climber_id = cl.climber_id
inner join grades g
on c.grade_id = g.grade_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and a.ascent_style_id = 2
and c.climb_type = 2
and g.order_on >= 39
order by
order_dt(ascent_dt_start, ascent_dt_end)
After
select
pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
,'<a href="/climber/' || cast(cl.climber_id as varchar) || '">' || cl.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
from
ascents a
inner join climbs c
on a.climb_id = c.climb_id
inner join climbers cl
on a.climber_id = cl.climber_id
inner join grades g
on c.grade_id = g.grade_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and a.ascent_style_id = 2
and c.climb_type = 2
and g.order_on >= 39
order by
order_dt(ascent_dt_start, ascent_dt_end)
,cl.climber_name
,c.climb_name
Diff
--- before
|
|||||||
| 4 | 20th July 2024 | 19:12:03 | remus | - | - | list_description | |
|
Before
All flashes of boulder problems 8B+ or above.
After
All flashes of boulder problems 8B or above.
Diff
--- before
|
|||||||
| 5 | 20th July 2024 | 19:12:03 | remus | - | - | list_definition | |
|
Before
select
pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
,'<a href="/climber/' || cast(cl.climber_id as varchar) || '">' || cl.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
from
ascents a
inner join climbs c
on a.climb_id = c.climb_id
inner join climbers cl
on a.climber_id = cl.climber_id
inner join grades g
on c.grade_id = g.grade_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and a.ascent_style_id = 2
and c.climb_type = 2
and g.order_on >= 40
order by
order_dt(ascent_dt_start, ascent_dt_end)
After
select
pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
,'<a href="/climber/' || cast(cl.climber_id as varchar) || '">' || cl.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
,g.grade as "Grade"
from
ascents a
inner join climbs c
on a.climb_id = c.climb_id
inner join climbers cl
on a.climber_id = cl.climber_id
inner join grades g
on c.grade_id = g.grade_id
where
a.deleted_on is null
and c.deleted_on is null
and cl.deleted_on is null
and a.ascent_style_id = 2
and c.climb_type = 2
and g.order_on >= 39
order by
order_dt(ascent_dt_start, ascent_dt_end)
Diff
--- before
|
|||||||
| 6 | 20th July 2024 | 19:12:03 | remus | - | - | list_description_pretty | |
|
Before
<p>All flashes of boulder problems 8B+ or above.</p>
After
<p>All flashes of boulder problems 8B or above.</p>
|
|||||||