Change Log | Climbing History

	Date	Time	User	Type	Name	Attribute
1	23rd November 2024	07:25:19	remus	-	-	list_definition
Before select '<a href="/climb/' \|\| cast(c.climb_id as varchar) \|\| '">' \|\| c.climb_name \|\| '</a>' as "Climb" ,g.grade as "Grade" ,ct.climb_type as "Climb Type" ,cm.value as Notes from climb_meta cm inner join climbs c on cm.climb_id = c.climb_id and cm.climb_meta_key_id = 17 and c.deleted_on is null inner join grades g on c.grade_id = g.grade_id inner join climb_types ct on c.climb_type = ct.climb_type_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null order by ct.climb_type ,g.order_on ,order_dt(a.ascent_dt_start, a.ascent_dt_end) After `select '<a href="/climb/' \|\| cast(c.climb_id as varchar) \|\| '">' \|\| c.climb_name \|\| '</a>' as "Climb" ,g.grade as "Grade" ,ct.climb_type as "Climb Type" ,cm.value as Notes from climb_meta cm inner join climbs c on cm.climb_id = c.climb_id and cm.climb_meta_key_id = 17 and c.deleted_on is null inner join grades g on c.grade_id = g.grade_id inner join climb_types ct on c.climb_type = ct.climb_type_id order by ct.climb_type ,g.order_on ,c.insert_dt` Diff `--- before +++ after @@ -14,12 +14,8 @@ on c.grade_id = g.grade_id inner join climb_types ct on c.climb_type = ct.climb_type_id - left join ascents a - on a.climb_id = c.climb_id - and a.fa = true - and a.deleted_on is null order by ct.climb_type ,g.order_on - ,order_dt(a.ascent_dt_start, a.ascent_dt_end) + ,c.insert_dt`
2	23rd November 2024	07:23:15	remus	-	-	list_definition
Before select '<a href="/climb/' \|\| cast(c.climb_id as varchar) \|\| '">' \|\| c.climb_name \|\| '</a>' as "Climb" ,g.grade as "Grade" ,ct.climb_type as "Climb Type" from climb_meta cm inner join climbs c on cm.climb_id = c.climb_id and cm.climb_meta_key_id = 17 and c.deleted_on is null inner join grades g on c.grade_id = g.grade_id inner join climb_types ct on c.climb_type = ct.climb_type_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null order by ct.climb_type ,g.order_on ,order_dt(a.ascent_dt_start, a.ascent_dt_end) After select '<a href="/climb/' \|\| cast(c.climb_id as varchar) \|\| '">' \|\| c.climb_name \|\| '</a>' as "Climb" ,g.grade as "Grade" ,ct.climb_type as "Climb Type" ,cm.value as Notes from climb_meta cm inner join climbs c on cm.climb_id = c.climb_id and cm.climb_meta_key_id = 17 and c.deleted_on is null inner join grades g on c.grade_id = g.grade_id inner join climb_types ct on c.climb_type = ct.climb_type_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null order by ct.climb_type ,g.order_on ,order_dt(a.ascent_dt_start, a.ascent_dt_end) Diff `--- before +++ after @@ -2,6 +2,7 @@ '<a href="/climb/' \|\| cast(c.climb_id as varchar) \|\| '">' \|\| c.climb_name \|\| '</a>' as "Climb" ,g.grade as "Grade" ,ct.climb_type as "Climb Type" + ,cm.value as Notes from climb_meta cm`
3	21st July 2024	06:52:23	remus	-	-	list_description_pretty
Before `<p>In the rock climbing, chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.</p> <p>This is a list of some routes that have been chipped. These routes have been chipped in the sense they have had holds created.</p>` After `<p>In rock climbing <em>chipping</em> is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.</p> <p>This is a list of some routes that have been chipped. These routes have been chipped in the sense they have had holds created.</p>`
4	21st July 2024	06:52:23	remus	-	-	list_description
Before `In the rock climbing, chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb. This is a list of some routes that have been chipped. These routes have been chipped in the sense they have had holds created.` After `In rock climbing chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb. This is a list of some routes that have been chipped. These routes have been chipped in the sense they have had holds created.` Diff --- before +++ after @@ -1,3 +1,3 @@ -In the rock climbing, chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb. +In rock climbing chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb. This is a list of some routes that have been chipped. These routes have been chipped in the sense they have had holds created.
5	30th May 2023	08:28:49	remus	-	-	-
Before `None` After `None`
6	30th May 2023	07:21:15	remus	-	-	-
Before `None` After `None`
7	30th May 2023	07:19:33	remus	-	-	-
Before `None` After `None`
8	30th May 2023	07:07:01	remus	-	-	-
Before `None` After `None`

Before

select
	'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
	,g.grade as "Grade"
	,ct.climb_type as "Climb Type"
	,cm.value as Notes
	
from
	climb_meta cm
	inner join climbs c
		on cm.climb_id = c.climb_id
		and cm.climb_meta_key_id = 17
		and c.deleted_on is null
	inner join grades g
		on c.grade_id = g.grade_id
	inner join climb_types ct
		on c.climb_type = ct.climb_type_id
	left join ascents a
		on a.climb_id = c.climb_id
		and a.fa = true
		and a.deleted_on is null
		
order by
	ct.climb_type
	,g.order_on
	,order_dt(a.ascent_dt_start, a.ascent_dt_end)

After

select
	'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
	,g.grade as "Grade"
	,ct.climb_type as "Climb Type"
	,cm.value as Notes
	
from
	climb_meta cm
	inner join climbs c
		on cm.climb_id = c.climb_id
		and cm.climb_meta_key_id = 17
		and c.deleted_on is null
	inner join grades g
		on c.grade_id = g.grade_id
	inner join climb_types ct
		on c.climb_type = ct.climb_type_id
		
order by
	ct.climb_type
	,g.order_on
	,c.insert_dt

Diff

--- before

+++ after

@@ -14,12 +14,8 @@

 		on c.grade_id = g.grade_id
 	inner join climb_types ct
 		on c.climb_type = ct.climb_type_id
-	left join ascents a
-		on a.climb_id = c.climb_id
-		and a.fa = true
-		and a.deleted_on is null
 		
 order by
 	ct.climb_type
 	,g.order_on
-	,order_dt(a.ascent_dt_start, a.ascent_dt_end)
+	,c.insert_dt

Before

select
	'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
	,g.grade as "Grade"
	,ct.climb_type as "Climb Type"
	
from
	climb_meta cm
	inner join climbs c
		on cm.climb_id = c.climb_id
		and cm.climb_meta_key_id = 17
		and c.deleted_on is null
	inner join grades g
		on c.grade_id = g.grade_id
	inner join climb_types ct
		on c.climb_type = ct.climb_type_id
	left join ascents a
		on a.climb_id = c.climb_id
		and a.fa = true
		and a.deleted_on is null
		
order by
	ct.climb_type
	,g.order_on
	,order_dt(a.ascent_dt_start, a.ascent_dt_end)

After

select
	'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
	,g.grade as "Grade"
	,ct.climb_type as "Climb Type"
	,cm.value as Notes
	
from
	climb_meta cm
	inner join climbs c
		on cm.climb_id = c.climb_id
		and cm.climb_meta_key_id = 17
		and c.deleted_on is null
	inner join grades g
		on c.grade_id = g.grade_id
	inner join climb_types ct
		on c.climb_type = ct.climb_type_id
	left join ascents a
		on a.climb_id = c.climb_id
		and a.fa = true
		and a.deleted_on is null
		
order by
	ct.climb_type
	,g.order_on
	,order_dt(a.ascent_dt_start, a.ascent_dt_end)

Diff

--- before

+++ after

@@ -2,6 +2,7 @@

 	'<a href="/climb/' || cast(c.climb_id as varchar) || '">' || c.climb_name || '</a>' as "Climb"
 	,g.grade as "Grade"
 	,ct.climb_type as "Climb Type"
+	,cm.value as Notes
 	
 from
 	climb_meta cm

Before

<p>In the rock climbing, chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.</p>
<p>This is a list of some routes that have been chipped. These routes  have been chipped in the sense they have had holds created.</p>

After

<p>In rock climbing <em>chipping</em> is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.</p>
<p>This is a list of some routes that have been chipped. These routes  have been chipped in the sense they have had holds created.</p>

Before

In the rock climbing, chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.

This is a list of some routes that have been chipped. These routes  have been chipped in the sense they have had holds created.

After

In rock climbing *chipping* is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.

This is a list of some routes that have been chipped. These routes  have been chipped in the sense they have had holds created.

Diff

--- before

+++ after

@@ -1,3 +1,3 @@

-In the rock climbing, chipping is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.
+In rock climbing *chipping* is the practice of artificially modifying a climb. In practice this can mean a lot of things, from a wobbly, existing hold being removed and then re-attached with glue to preserve the character of a climb to full-scale manufacture of routes by drilling holds in blank rock for large sections of the climb.
 
 This is a list of some routes that have been chipped. These routes  have been chipped in the sense they have had holds created.

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Change Log for Examples of Chipped Climbs

Overview

8

30th May 2023

23rd Nov 2024

Log

Page 1