Change Log for Projects

Overview

Total Changes

7

First Change

20th Feb 2025

Last Change

20th Feb 2025

Log

Date Time User Type Name Attribute
1 20th February 2025 15:20:56 remus - - list_name
Before
None
After
Projects
2 20th February 2025 15:20:56 remus - - list_description
Before
None
After
This is a list of some projects. Typically these are very hard, public lines that have been tried at least a little by climbers.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+This is a list of some projects. Typically these are very hard, public lines that have been tried at least a little by climbers.
3 20th February 2025 15:20:56 remus - - list_definition
Before
None
After
select '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Name" ,g.grade || ' ' || ct.climb_type as "Approx Grade" ,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag" from climbs c inner join climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 20 inner join climb_types ct on c.climb_type_id = ct.climb_type_id inner join grades g on c.grade_id = g.grade_id left join crags cr on c.ukc_crag_id = cr.crag_id where c.deleted_on is null order by ct.climb_type ,g.order_on desc
Diff
--- before

+++ after

@@ -1 +1,24 @@

-
+select
+ '' || c.climb_name || '' as "Name"
+ ,g.grade || ' ' || ct.climb_type as "Approx Grade"
+ ,'' || cr.crag_name || '' as "Crag"
+
+
+from
+ climbs c
+ inner join climb_meta cm
+ on c.climb_id = cm.climb_id
+ and cm.climb_meta_key_id = 20
+ inner join climb_types ct
+ on c.climb_type_id = ct.climb_type_id
+ inner join grades g
+ on c.grade_id = g.grade_id
+ left join crags cr
+ on c.ukc_crag_id = cr.crag_id
+
+where
+ c.deleted_on is null
+
+order by
+ ct.climb_type
+ ,g.order_on desc
4 20th February 2025 15:20:56 remus - - list_description_pretty
Before
None
After
<p>This is a list of some projects. Typically these are very hard, public lines that have been tried at least a little by climbers.</p>
5 20th February 2025 15:20:56 remus - - hidden
Before
false
After
true
6 20th February 2025 15:20:56 remus - - list_type_id
Before
None
After
5
7 20th February 2025 15:20:56 remus - - list_type_name
Before
None
After
Misc.

Page 1