| 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_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>
|
|||||||
| 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
+ '<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)
|
|||||||
| 8 | 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).
|
|||||||
| 9 | 17th August 2024 | 06:59:10 | remus | - | - | list_name | |
|
Before
None
After
The Big Five
|
|||||||