| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 17th August 2024 | 07:25:53 | remus | - | - | generate_meta | |
|
Before
None
After
insert into
climb_meta (climb_id, value, display_value, climb_meta_key_id)
select
c.climb_id
,'/list/30/the-yorkshire-triple-crown'
,'The Yorkshire Triple Crown'
,15
from
climbs c
where
c.climb_id in (319, 744, 1073)
|
|||||||
| 2 | 7th April 2024 | 19:02:44 | remus | - | - | list_description_pretty | |
|
Before
<p>The Yorkshire Triple Crown is three 8a+ routes in Yorkshire on the three big limestone sport crags: <a href="/crag/610/malham-cove">Malham Cove</a>, <a href="/crag/608/kilnsey">Kilnsey</a> and <a href="/crag/605/gordale-scar">Gordale Scar</a>.</p>
After
<p>The Yorkshire Triple Crown is three classic 8a+ routes in Yorkshire on the three big limestone sport crags: <a href="/crag/610/malham-cove">Malham Cove</a>, <a href="/crag/608/kilnsey">Kilnsey</a> and <a href="/crag/605/gordale-scar">Gordale Scar</a>.</p>
|
|||||||
| 3 | 7th April 2024 | 19:02:44 | remus | - | - | list_description | |
|
Before
The Yorkshire Triple Crown is three 8a+ routes in Yorkshire on the three big limestone sport crags: [Malham Cove](/crag/610/malham-cove), [Kilnsey](/crag/608/kilnsey) and [Gordale Scar](/crag/605/gordale-scar).
After
The Yorkshire Triple Crown is three classic 8a+ routes in Yorkshire on the three big limestone sport crags: [Malham Cove](/crag/610/malham-cove), [Kilnsey](/crag/608/kilnsey) and [Gordale Scar](/crag/605/gordale-scar).
Diff
--- before
+++ after
@@ -1 +1 @@
-The Yorkshire Triple Crown is three 8a+ routes in Yorkshire on the three big limestone sport crags: [Malham Cove](/crag/610/malham-cove), [Kilnsey](/crag/608/kilnsey) and [Gordale Scar](/crag/605/gordale-scar).
+The Yorkshire Triple Crown is three classic 8a+ routes in Yorkshire on the three big limestone sport crags: [Malham Cove](/crag/610/malham-cove), [Kilnsey](/crag/608/kilnsey) and [Gordale Scar](/crag/605/gordale-scar).
|
|||||||
| 4 | 7th April 2024 | 19:01:57 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag
,'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
from
climbs c
inner join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = True
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join crags cr
on c.ukc_crag_id = cr.crag_id
where
c.climb_id in (319, 744, 1073)
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,g.grade as Grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag
,'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>, ' || pretty_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
inner join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = True
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join crags cr
on c.ukc_crag_id = cr.crag_id
where
c.climb_id in (319, 744, 1073)
Diff
--- before
+++ after
@@ -1,10 +1,13 @@
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
+ ,g.grade as Grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag
,'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>, ' || pretty_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
inner join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
|
|||||||
| 5 | 7th April 2024 | 18:59:59 | remus | - | - | list_description_pretty | |
|
Before
None
After
<p>The Yorkshire Triple Crown is three 8a+ routes in Yorkshire on the three big limestone sport crags: <a href="/crag/610/malham-cove">Malham Cove</a>, <a href="/crag/608/kilnsey">Kilnsey</a> and <a href="/crag/605/gordale-scar">Gordale Scar</a>.</p>
|
|||||||
| 6 | 7th April 2024 | 18:59:59 | remus | - | - | list_definition | |
|
Before
None
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag
,'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
from
climbs c
inner join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = True
inner join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
inner join crags cr
on c.ukc_crag_id = cr.crag_id
where
c.climb_id in (319, 744, 1073)
Diff
--- before
+++ after
@@ -1 +1,19 @@
-
+select
+ '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
+ ,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag
+ ,'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+
+from
+ climbs c
+ inner join ascents a
+ on c.climb_id = a.climb_id
+ and a.deleted_on is null
+ and a.fa = True
+ inner join climbers cl
+ on a.climber_id = cl.climber_id
+ and cl.deleted_on is null
+ inner join crags cr
+ on c.ukc_crag_id = cr.crag_id
+
+where
+ c.climb_id in (319, 744, 1073)
|
|||||||
| 7 | 7th April 2024 | 18:59:59 | remus | - | - | list_description | |
|
Before
None
After
The Yorkshire Triple Crown is three 8a+ routes in Yorkshire on the three big limestone sport crags: [Malham Cove](/crag/610/malham-cove), [Kilnsey](/crag/608/kilnsey) and [Gordale Scar](/crag/605/gordale-scar).
Diff
--- before
+++ after
@@ -1 +1 @@
-
+The Yorkshire Triple Crown is three 8a+ routes in Yorkshire on the three big limestone sport crags: [Malham Cove](/crag/610/malham-cove), [Kilnsey](/crag/608/kilnsey) and [Gordale Scar](/crag/605/gordale-scar).
|
|||||||
| 8 | 7th April 2024 | 18:59:59 | remus | - | - | list_name | |
|
Before
None
After
The Yorkshire Triple Crown
|
|||||||