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 @@ '' \|\| c.climb_name \|\| '' 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
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.
4	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>`
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 @@

 	'' || c.climb_name || '' as "Climb"

 	,g.grade as "Grade"

 	,ct.climb_type as "Climb Type"

+	,cm.value as Notes

 	

 from

 	climb_meta cm

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

<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

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