| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 61 | 27th July 2024 | 11:50:27 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a> ' || g.grade as "Climb"
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end), ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as "First Ascent"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.climb_id
and a.deleted_on is null
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
c.climb_id in (3637, 3648, 3647)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end), ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) || ')' as "First Ascent"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.climb_id
and a.deleted_on is null
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
c.climb_id in (3637, 3648, 3647)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -1,7 +1,8 @@
select
- '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a> ' || g.grade as "Climb"
+ '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
+ ,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
- ,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end), ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as "First Ascent"
+ ,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end), ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) || ')' as "First Ascent"
from
climbs c
|
|||||||
| 62 | 27th July 2024 | 11:49:04 | remus | - | - | list_description_pretty | |
|
Before
None
After
<p>Hard Rock is a coffee table book compiled by <a href="/climber/1012/ken-wilson">Ken Wilson</a> with individual articles from many notable climbers discussing high quality trad routes across Great Britain.</p>
<p>First published in 1974, it has since had several reprints.</p>
|
|||||||
| 63 | 27th July 2024 | 11:49:04 | remus | - | - | list_description | |
|
Before
None
After
Hard Rock is a coffee table book compiled by [Ken Wilson](/climber/1012/ken-wilson) with individual articles from many notable climbers discussing high quality trad routes across Great Britain.
First published in 1974, it has since had several reprints.
Diff
--- before
+++ after
@@ -1 +1,3 @@
-
+Hard Rock is a coffee table book compiled by [Ken Wilson](/climber/1012/ken-wilson) with individual articles from many notable climbers discussing high quality trad routes across Great Britain.
+
+First published in 1974, it has since had several reprints.
|
|||||||
| 64 | 27th July 2024 | 11:49:04 | remus | - | - | list_name | |
|
Before
None
After
Hard Rock
|
|||||||
| 65 | 27th July 2024 | 11:49:04 | remus | - | - | list_definition | |
|
Before
None
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a> ' || g.grade as "Climb"
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end), ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as "First Ascent"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.climb_id
and a.deleted_on is null
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
c.climb_id in (3637, 3648, 3647)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -1 +1,30 @@
-
+select
+ '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a> ' || g.grade as "Climb"
+ ,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
+ ,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end), ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as "First Ascent"
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ left join crags cr
+ on c.ukc_crag_id = cr.crag_id
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.deleted_on is null
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+ and cl.deleted_on is null
+
+where
+ c.climb_id in (3637, 3648, 3647)
+
+group by
+ c.climb_id
+ ,c.climb_name
+ ,cr.crag_id
+ ,cr.crag_name
+ ,g.grade
+
+order by
+ c.climb_name
|
|||||||
| 66 | 27th July 2024 | 11:49:04 | remus | - | - | public | |
|
Before
true
After
false
|
|||||||