Change Log for The Yorkshire Triple Crown

Overview

Total Changes

8

First Change

7th Apr 2024

Last Change

17th Aug 2024

Log

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
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).
3 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>
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
'' || c.climb_name || '' as Climb
+ ,g.grade as Grade
,'' || cr.crag_name || '' as Crag
,'' || cl.climber_name || ', ' || 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_name
Before
None
After
The Yorkshire Triple Crown
6 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>
7 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
+ '' || c.climb_name || '' as Climb
+ ,'' || cr.crag_name || '' as Crag
+ ,'' || cl.climber_name || ', ' || 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)
8 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).

Page 1