| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 17th April 2024 | 06:01:43 | remus | - | - | list_description_pretty | |
|
Before
<p>Some examples of ascents that have taken many sessions.</p>
After
<p>Some examples of ascents that have taken (or are taking) many sessions.</p>
|
|||||||
| 2 | 17th April 2024 | 06:01:43 | remus | - | - | list_description | |
|
Before
Some examples of ascents that have taken many sessions.
After
Some examples of ascents that have taken (or are taking) many sessions.
Diff
--- before
+++ after
@@ -1 +1 @@
-Some examples of ascents that have taken many sessions.
+Some examples of ascents that have taken (or are taking) many sessions.
|
|||||||
| 3 | 17th April 2024 | 06:01:06 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
,'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
when am.ascent_meta_key_id = 8 then '>' || am.value
when am.ascent_meta_key_id = 9 then am.value || ' (approx)'
else ''
end as Sessions
from
ascents a
inner join ascent_meta am
on a.ascent_id = am.ascent_id
and am.ascent_meta_key_id in (5, 8, 9)
and a.deleted_on is null
inner join climbs c
on a.climb_id = c.climb_id
and c.deleted_on is null
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join grades g
on c.grade_id = g.grade_id
where
am.value::int > 50
order by
am.value::int desc
After
select
'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
,case
when asty.ascent_successful = true then '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>'
else '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a> (unfinished)'
end as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
when am.ascent_meta_key_id = 8 then '>' || am.value
when am.ascent_meta_key_id = 9 then am.value || ' (approx)'
else ''
end as Sessions
from
ascents a
inner join ascent_meta am
on a.ascent_id = am.ascent_id
and am.ascent_meta_key_id in (5, 8, 9)
and a.deleted_on is null
inner join climbs c
on a.climb_id = c.climb_id
and c.deleted_on is null
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join grades g
on c.grade_id = g.grade_id
inner join ascent_styles asty
on a.ascent_style_id = asty.ascent_style_id
where
am.value::int > 50
order by
am.value::int desc
Diff
--- before
+++ after
@@ -1,6 +1,9 @@
select
'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
- ,'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
+ ,case
+ when asty.ascent_successful = true then '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>'
+ else '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a> (unfinished)'
+ end as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
@@ -23,6 +26,8 @@
and cl.deleted_on is null
inner join grades g
on c.grade_id = g.grade_id
+ inner join ascent_styles asty
+ on a.ascent_style_id = asty.ascent_style_id
where
am.value::int > 50
|
|||||||
| 4 | 16th April 2024 | 15:20:27 | remus | - | - | list_definition | |
|
Before
select
'< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
when am.ascent_meta_key_id = 8 then '>' || am.value
when am.ascent_meta_key_id = 9 then am.value || ' (approx)'
else ''
end as Sessions
from
ascents a
inner join ascent_meta am
on a.ascent_id = am.ascent_id
and am.ascent_meta_key_id in (5, 8, 9)
and a.deleted_on is null
inner join climbs c
on a.climb_id = c.climb_id
and c.deleted_on is null
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join grades g
on c.grade_id = g.grade_id
where
am.value::int > 50
order by
am.value::int desc
After
select
'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
,'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
when am.ascent_meta_key_id = 8 then '>' || am.value
when am.ascent_meta_key_id = 9 then am.value || ' (approx)'
else ''
end as Sessions
from
ascents a
inner join ascent_meta am
on a.ascent_id = am.ascent_id
and am.ascent_meta_key_id in (5, 8, 9)
and a.deleted_on is null
inner join climbs c
on a.climb_id = c.climb_id
and c.deleted_on is null
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join grades g
on c.grade_id = g.grade_id
where
am.value::int > 50
order by
am.value::int desc
Diff
--- before
+++ after
@@ -1,6 +1,6 @@
select
- '< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
- ,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
+ '<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
+ ,'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
|
|||||||
| 5 | 16th April 2024 | 15:19:27 | remus | - | - | list_definition | |
|
Before
None
After
select
'< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
when am.ascent_meta_key_id = 8 then '>' || am.value
when am.ascent_meta_key_id = 9 then am.value || ' (approx)'
else ''
end as Sessions
from
ascents a
inner join ascent_meta am
on a.ascent_id = am.ascent_id
and am.ascent_meta_key_id in (5, 8, 9)
and a.deleted_on is null
inner join climbs c
on a.climb_id = c.climb_id
and c.deleted_on is null
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join grades g
on c.grade_id = g.grade_id
where
am.value::int > 50
order by
am.value::int desc
Diff
--- before
+++ after
@@ -1 +1,31 @@
-
+select
+ '< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber
+ ,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
+ ,g.grade as Grade
+ ,case
+ when am.ascent_meta_key_id = 5 then am.value
+ when am.ascent_meta_key_id = 8 then '>' || am.value
+ when am.ascent_meta_key_id = 9 then am.value || ' (approx)'
+ else ''
+ end as Sessions
+
+from
+ ascents a
+ inner join ascent_meta am
+ on a.ascent_id = am.ascent_id
+ and am.ascent_meta_key_id in (5, 8, 9)
+ and a.deleted_on is null
+ inner join climbs c
+ on a.climb_id = c.climb_id
+ and c.deleted_on is null
+ inner join climbers cl
+ on a.climber_id = cl.climber_id
+ and cl.deleted_on is null
+ inner join grades g
+ on c.grade_id = g.grade_id
+
+where
+ am.value::int > 50
+
+order by
+ am.value::int desc
|
|||||||
| 6 | 16th April 2024 | 15:19:27 | remus | - | - | list_description_pretty | |
|
Before
None
After
<p>Some examples of ascents that have taken many sessions.</p>
|
|||||||
| 7 | 16th April 2024 | 15:19:27 | remus | - | - | list_description | |
|
Before
None
After
Some examples of ascents that have taken many sessions.
Diff
--- before
+++ after
@@ -1 +1 @@
-
+Some examples of ascents that have taken many sessions.
|
|||||||
| 8 | 16th April 2024 | 15:19:27 | remus | - | - | list_name | |
|
Before
None
After
Long Projects
|
|||||||