Change Log for The Big Five

Overview

Total Changes

9

First Change

17th Aug 2024

Last Change

17th Aug 2024

Log

Date Time User Type Name Attribute
1 17th August 2024 07:24:09 remus - - generate_meta
Before
insert into climb_meta (climb_id, value, display_value, climb_meta_key_id) select c.climb_id ,'/list/38/the-big-five' ,'The Big Five' ,15 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 (3334, 3332, 3330, 3333, 3331)
After
insert into climb_meta (climb_id, value, display_value, climb_meta_key_id) select c.climb_id ,'/list/38/the-big-five' ,'The Big Five' ,15 from climbs c where c.climb_id in (3334, 3332, 3330, 3333, 3331)
2 17th August 2024 07:19:43 remus - - generate_meta
Before
insert into climber_meta (climb_id, value, display_value, climb_meta_key_id) select c.climb_id ,'/list/38/the-big-five' ,'The Big Five' ,15 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 (3334, 3332, 3330, 3333, 3331)
After
insert into climb_meta (climb_id, value, display_value, climb_meta_key_id) select c.climb_id ,'/list/38/the-big-five' ,'The Big Five' ,15 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 (3334, 3332, 3330, 3333, 3331)
3 17th August 2024 07:17:34 remus - - generate_meta
Before
None
After
insert into climber_meta (climb_id, value, display_value, climb_meta_key_id) select c.climb_id ,'/list/38/the-big-five' ,'The Big Five' ,15 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 (3334, 3332, 3330, 3333, 3331)
4 17th August 2024 07:00:53 remus - - list_description
Before
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau).
After
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.
Diff
--- before

+++ after

@@ -1 +1 @@

-The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau).
+The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.
5 17th August 2024 07:00:53 remus - - list_description_pretty
Before
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau">Fontainebleau</a>.</p>
After
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p>
6 17th August 2024 06:59:10 remus - - list_description
Before
None
After
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau).
Diff
--- before

+++ after

@@ -1 +1 @@

-
+The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau).
7 17th August 2024 06:59:10 remus - - list_definition
Before
None
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 (3334, 3332, 3330, 3333, 3331)
Diff
--- before

+++ after

@@ -1 +1,22 @@

-
+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
+ 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 (3334, 3332, 3330, 3333, 3331)
8 17th August 2024 06:59:10 remus - - list_description_pretty
Before
None
After
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau">Fontainebleau</a>.</p>
9 17th August 2024 06:59:10 remus - - list_name
Before
None
After
The Big Five

Page 1