Change Log | Climbing History

	Date	Time	User	Type	Name	Attribute
1	2nd November 2024	08:54:39	remus	-	-	list_definition
Before select '<a href="/climber/' \|\| c.climber_id::varchar \|\| '">' \|\| c.climber_name \|\| '</a>' as Climber ,'<a href="/climb/' \|\| cl.climb_id \|\| '">' \|\| cl.climb_name \|\| '</a>' as Climb ,g.grade as Grade ,ast.ascent_style as "Style" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date" from ascents a inner join climbers c on a.climber_id = c.climber_id inner join climbs cl on a.climb_id = cl.climb_id inner join grades g on cl.grade_id = g.grade_id inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and a.ascent_style_id in (2,3) and g.order_on >= 61 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) After select '<a href="/climber/' \|\| c.climber_id::varchar \|\| '">' \|\| c.climber_name \|\| '</a>' as Climber ,'<a href="/climb/' \|\| cl.climb_id \|\| '">' \|\| cl.climb_name \|\| '</a>' as Climb ,g.grade as Grade ,ast.ascent_style as "Style" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date" from ascents a inner join climbers c on a.climber_id = c.climber_id inner join climbs cl on a.climb_id = cl.climb_id inner join grades g on cl.grade_id = g.grade_id inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id inner join ascent_types aty on a.ascent_type_id = aty.ascent_type_id where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and a.ascent_style_id in (2,3) and g.order_on >= 61 and aty.ascent_type_id in (1,3,5,8,9) order by order_dt(a.ascent_dt_start, a.ascent_dt_end) Diff `--- before +++ after @@ -15,6 +15,8 @@ on cl.grade_id = g.grade_id inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id + inner join ascent_types aty + on a.ascent_type_id = aty.ascent_type_id where a.deleted_on is null @@ -23,6 +25,7 @@ and cl.climb_type = 3 and a.ascent_style_id in (2,3) and g.order_on >= 61 + and aty.ascent_type_id in (1,3,5,8,9) order by order_dt(a.ascent_dt_start, a.ascent_dt_end)`
2	30th August 2024	06:47:40	remus	-	-	list_type_id
Before `5` After `3`
3	30th August 2024	06:47:40	remus	-	-	list_type_name
Before `Misc.` After `Trad Climbing`
4	20th December 2023	14:43:15	remus	-	-	list_definition
Before select c.climber_name as Climber ,cl.climb_name as Climb ,g.grade as Grade ,ast.ascent_style as "Style" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date" from ascents a inner join climbers c on a.climber_id = c.climber_id inner join climbs cl on a.climb_id = cl.climb_id inner join grades g on cl.grade_id = g.grade_id inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and a.ascent_style_id in (2,3) and g.order_on >= 61 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) After select '<a href="/climber/' \|\| c.climber_id::varchar \|\| '">' \|\| c.climber_name \|\| '</a>' as Climber ,'<a href="/climb/' \|\| cl.climb_id \|\| '">' \|\| cl.climb_name \|\| '</a>' as Climb ,g.grade as Grade ,ast.ascent_style as "Style" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date" from ascents a inner join climbers c on a.climber_id = c.climber_id inner join climbs cl on a.climb_id = cl.climb_id inner join grades g on cl.grade_id = g.grade_id inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and a.ascent_style_id in (2,3) and g.order_on >= 61 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) Diff `--- before +++ after @@ -1,6 +1,6 @@ select - c.climber_name as Climber - ,cl.climb_name as Climb + '' \|\| c.climber_name \|\| '' as Climber + ,'' \|\| cl.climb_name \|\| '' as Climb ,g.grade as Grade ,ast.ascent_style as "Style" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"`
5	20th December 2023	13:58:54	remus	-	-	list_name
Before `None` After `Hard Trad Onsights and Flashes`
6	20th December 2023	13:58:54	remus	-	-	list_description_pretty
Before `None` After `<p>A non-definitive list of some hard trad onsights and flashes.</p>`
7	20th December 2023	13:58:54	remus	-	-	list_definition
Before `None` After select c.climber_name as Climber ,cl.climb_name as Climb ,g.grade as Grade ,ast.ascent_style as "Style" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date" from ascents a inner join climbers c on a.climber_id = c.climber_id inner join climbs cl on a.climb_id = cl.climb_id inner join grades g on cl.grade_id = g.grade_id inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and a.ascent_style_id in (2,3) and g.order_on >= 61 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) Diff --- before +++ after @@ -1 +1,28 @@ - +select + c.climber_name as Climber + ,cl.climb_name as Climb + ,g.grade as Grade + ,ast.ascent_style as "Style" + ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date" + +from + ascents a + inner join climbers c + on a.climber_id = c.climber_id + inner join climbs cl + on a.climb_id = cl.climb_id + inner join grades g + on cl.grade_id = g.grade_id + inner join ascent_styles ast + on a.ascent_style_id = ast.ascent_style_id + +where + a.deleted_on is null + and c.deleted_on is null + and cl.deleted_on is null + and cl.climb_type = 3 + and a.ascent_style_id in (2,3) + and g.order_on >= 61 + +order by + order_dt(a.ascent_dt_start, a.ascent_dt_end)
8	20th December 2023	13:58:54	remus	-	-	list_description
Before `None` After `A non-definitive list of some hard trad onsights and flashes.` Diff `--- before +++ after @@ -1 +1 @@ - +A non-definitive list of some hard trad onsights and flashes.`

Before

select
	'<a href="/climber/' || c.climber_id::varchar || '">' || c.climber_name || '</a>' as Climber
	,'<a href="/climb/' || cl.climb_id || '">' || cl.climb_name || '</a>' as Climb
	,g.grade as Grade
	,ast.ascent_style as "Style"
	,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
	
from
	ascents a
	inner join climbers c
		on a.climber_id = c.climber_id
	inner join climbs cl
		on a.climb_id = cl.climb_id
	inner join grades g
		on cl.grade_id = g.grade_id
	inner join ascent_styles ast
		on a.ascent_style_id = ast.ascent_style_id
		
where
	a.deleted_on is null
	and c.deleted_on is null
	and cl.deleted_on is null
	and cl.climb_type = 3
	and a.ascent_style_id in (2,3)
	and g.order_on >= 61
	
order by
	order_dt(a.ascent_dt_start, a.ascent_dt_end)

After

select
	'<a href="/climber/' || c.climber_id::varchar || '">' || c.climber_name || '</a>' as Climber
	,'<a href="/climb/' || cl.climb_id || '">' || cl.climb_name || '</a>' as Climb
	,g.grade as Grade
	,ast.ascent_style as "Style"
	,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
	
from
	ascents a
	inner join climbers c
		on a.climber_id = c.climber_id
	inner join climbs cl
		on a.climb_id = cl.climb_id
	inner join grades g
		on cl.grade_id = g.grade_id
	inner join ascent_styles ast
		on a.ascent_style_id = ast.ascent_style_id
	inner join ascent_types aty
		on a.ascent_type_id = aty.ascent_type_id
		
where
	a.deleted_on is null
	and c.deleted_on is null
	and cl.deleted_on is null
	and cl.climb_type = 3
	and a.ascent_style_id in (2,3)
	and g.order_on >= 61
	and aty.ascent_type_id in (1,3,5,8,9)
	
order by
	order_dt(a.ascent_dt_start, a.ascent_dt_end)

Diff

--- before

+++ after

@@ -15,6 +15,8 @@

 		on cl.grade_id = g.grade_id

 	inner join ascent_styles ast

 		on a.ascent_style_id = ast.ascent_style_id

+	inner join ascent_types aty

+		on a.ascent_type_id = aty.ascent_type_id

 		

 where

 	a.deleted_on is null

@@ -23,6 +25,7 @@

 	and cl.climb_type = 3

 	and a.ascent_style_id in (2,3)

 	and g.order_on >= 61

+	and aty.ascent_type_id in (1,3,5,8,9)

 	

 order by

 	order_dt(a.ascent_dt_start, a.ascent_dt_end)

Before

5

After

3

Before

Misc.

After

Trad Climbing

Before

select
	c.climber_name as Climber
	,cl.climb_name as Climb
	,g.grade as Grade
	,ast.ascent_style as "Style"
	,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
	
from
	ascents a
	inner join climbers c
		on a.climber_id = c.climber_id
	inner join climbs cl
		on a.climb_id = cl.climb_id
	inner join grades g
		on cl.grade_id = g.grade_id
	inner join ascent_styles ast
		on a.ascent_style_id = ast.ascent_style_id
		
where
	a.deleted_on is null
	and c.deleted_on is null
	and cl.deleted_on is null
	and cl.climb_type = 3
	and a.ascent_style_id in (2,3)
	and g.order_on >= 61
	
order by
	order_dt(a.ascent_dt_start, a.ascent_dt_end)

After

select
	'<a href="/climber/' || c.climber_id::varchar || '">' || c.climber_name || '</a>' as Climber
	,'<a href="/climb/' || cl.climb_id || '">' || cl.climb_name || '</a>' as Climb
	,g.grade as Grade
	,ast.ascent_style as "Style"
	,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
	
from
	ascents a
	inner join climbers c
		on a.climber_id = c.climber_id
	inner join climbs cl
		on a.climb_id = cl.climb_id
	inner join grades g
		on cl.grade_id = g.grade_id
	inner join ascent_styles ast
		on a.ascent_style_id = ast.ascent_style_id
		
where
	a.deleted_on is null
	and c.deleted_on is null
	and cl.deleted_on is null
	and cl.climb_type = 3
	and a.ascent_style_id in (2,3)
	and g.order_on >= 61
	
order by
	order_dt(a.ascent_dt_start, a.ascent_dt_end)

Diff

--- before

+++ after

@@ -1,6 +1,6 @@

 select

-	c.climber_name as Climber

-	,cl.climb_name as Climb

+	'' || c.climber_name || '' as Climber

+	,'' || cl.climb_name || '' as Climb

 	,g.grade as Grade

 	,ast.ascent_style as "Style"

 	,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"

Before

None

After

Hard Trad Onsights and Flashes

Before

None

After

<p>A non-definitive list of some hard trad onsights and flashes.</p>

Before

None

After

select
	c.climber_name as Climber
	,cl.climb_name as Climb
	,g.grade as Grade
	,ast.ascent_style as "Style"
	,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
	
from
	ascents a
	inner join climbers c
		on a.climber_id = c.climber_id
	inner join climbs cl
		on a.climb_id = cl.climb_id
	inner join grades g
		on cl.grade_id = g.grade_id
	inner join ascent_styles ast
		on a.ascent_style_id = ast.ascent_style_id
		
where
	a.deleted_on is null
	and c.deleted_on is null
	and cl.deleted_on is null
	and cl.climb_type = 3
	and a.ascent_style_id in (2,3)
	and g.order_on >= 61
	
order by
	order_dt(a.ascent_dt_start, a.ascent_dt_end)

Diff

--- before

+++ after

@@ -1 +1,28 @@

-
+select

+	c.climber_name as Climber

+	,cl.climb_name as Climb

+	,g.grade as Grade

+	,ast.ascent_style as "Style"

+	,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"

+	

+from

+	ascents a

+	inner join climbers c

+		on a.climber_id = c.climber_id

+	inner join climbs cl

+		on a.climb_id = cl.climb_id

+	inner join grades g

+		on cl.grade_id = g.grade_id

+	inner join ascent_styles ast

+		on a.ascent_style_id = ast.ascent_style_id

+		

+where

+	a.deleted_on is null

+	and c.deleted_on is null

+	and cl.deleted_on is null

+	and cl.climb_type = 3

+	and a.ascent_style_id in (2,3)

+	and g.order_on >= 61

+	

+order by

+	order_dt(a.ascent_dt_start, a.ascent_dt_end)

Before

None

After

A non-definitive list of some hard trad onsights and flashes.

Diff

--- before

+++ after

@@ -1 +1 @@

-
+A non-definitive list of some hard trad onsights and flashes.

Change Log for Hard Trad Onsights and Flashes

Overview

8

20th Dec 2023

2nd Nov 2024

Log

Page 1