Change Log | Climbing History

	Date	Time	User	Type	Name	Attribute
1	3rd February 2025	06:46:21	remus	-	-	hidden
Before `true` After `false`
2	21st January 2025	06:48:47	remus	-	-	list_description_pretty
Before `<p>The best Norwegian male sport climbers.</p> <p>This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>` After `<p>The best Norwegian sport climbers.</p> <p>This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>`
3	21st January 2025	06:48:47	remus	-	-	list_definition
Before select '<a href="/climber/' \|\| cast(c.climber_id as varchar) \|\| '">' \|\| c.climber_name \|\| '</a>' as Climber ,g.grade as Grade ,string_agg('<a href="/climb/' \|\| cast(cl.climb_id as varchar) \|\| '">' \|\| cl.climb_name \|\| '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs from ascents a inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id 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 hardest_ascent ha on c.climber_id = ha.climber_id and cl.grade_id = ha.max_grade_id and cl.climb_type_id = ha.climb_type where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 1 and c.gender = false and c.country_id = 5 and cl.grade_id >= 17 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not a.ascent_type_id = 6 group by c.climber_name ,g.grade ,c.climber_id order by g.grade desc ,count() desc ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end)) After* select '<a href="/climber/' \|\| cast(c.climber_id as varchar) \|\| '">' \|\| c.climber_name \|\| '</a>' as Climber ,g.grade as Grade ,string_agg('<a href="/climb/' \|\| cast(cl.climb_id as varchar) \|\| '">' \|\| cl.climb_name \|\| '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs from ascents a inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id 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 hardest_ascent ha on c.climber_id = ha.climber_id and cl.grade_id = ha.max_grade_id and cl.climb_type_id = ha.climb_type where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 1 and c.country_id = 5 and cl.grade_id >= 19 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not a.ascent_type_id = 6 group by c.climber_name ,g.grade ,c.climber_id order by g.grade desc ,count() desc ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end)) Diff* `--- before +++ after @@ -23,9 +23,8 @@ and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 1 - and c.gender = false and c.country_id = 5 - and cl.grade_id >= 17 + and cl.grade_id >= 19 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null`
4	21st January 2025	06:48:47	remus	-	-	list_description
Before `The best Norwegian male sport climbers. This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.` After `The best Norwegian sport climbers. This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.` Diff --- before +++ after @@ -1,3 +1,3 @@ -The best Norwegian male sport climbers. +The best Norwegian sport climbers. -This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent. +This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
5	21st January 2025	06:48:47	remus	-	-	list_name
Before `Strong Norwegian Male Sport Climbers` After `Strong Norwegian Sport Climbers`
6	21st January 2025	06:48:47	remus	-	-	generate_meta
Before insert into climber_meta (climber_id, value, display_value, climber_meta_key_id) select c.climber_id ,'/list/50/strong-norwegian-male-sport-climbers ,'Strong Norwegian Male Sport Climbers - #' \|\| row_number() over (order by g.grade desc, count() desc, min(order_dt(a.ascent_dt_start, a.ascent_dt_end)))::varchar ,27 from ascents a inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id 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 hardest_ascent ha on c.climber_id = ha.climber_id and cl.grade_id = ha.max_grade_id and cl.climb_type_id = ha.climb_type where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 1 and c.gender = false and c.country_id = 5 and cl.grade_id >= 17 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not a.ascent_type_id = 6 group by c.climber_name ,g.grade ,c.climber_id After* insert into climber_meta (climber_id, value, display_value, climber_meta_key_id) select c.climber_id ,'/list/50/strong-norwegian-sport-climbers ,'Strong Norwegian Sport Climbers - #' \|\| row_number() over (order by g.grade desc, count(*) desc, min(order_dt(a.ascent_dt_start, a.ascent_dt_end)))::varchar ,27 from ascents a inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id 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 hardest_ascent ha on c.climber_id = ha.climber_id and cl.grade_id = ha.max_grade_id and cl.climb_type_id = ha.climb_type where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 1 and c.country_id = 5 and cl.grade_id >= 19 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not a.ascent_type_id = 6 group by c.climber_name ,g.grade ,c.climber_id
7	20th January 2025	21:35:24	remus	-	-	generate_meta
Before `None` After insert into climber_meta (climber_id, value, display_value, climber_meta_key_id) select c.climber_id ,'/list/50/strong-norwegian-male-sport-climbers ,'Strong Norwegian Male Sport Climbers - #' \|\| row_number() over (order by g.grade desc, count(*) desc, min(order_dt(a.ascent_dt_start, a.ascent_dt_end)))::varchar ,27 from ascents a inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id 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 hardest_ascent ha on c.climber_id = ha.climber_id and cl.grade_id = ha.max_grade_id and cl.climb_type_id = ha.climb_type where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 1 and c.gender = false and c.country_id = 5 and cl.grade_id >= 17 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not a.ascent_type_id = 6 group by c.climber_name ,g.grade ,c.climber_id
8	20th January 2025	21:33:55	remus	-	-	list_type_id
Before `None` After `4`
9	20th January 2025	21:33:55	remus	-	-	hidden
Before `false` After `true`
10	20th January 2025	21:33:55	remus	-	-	list_description_pretty
Before `None` After `<p>The best Norwegian male sport climbers.</p> <p>This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>`
11	20th January 2025	21:33:55	remus	-	-	list_type_name
Before `None` After `Nationality`
12	20th January 2025	21:33:55	remus	-	-	list_description
Before `None` After `The best Norwegian male sport climbers. This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.` Diff `--- before +++ after @@ -1 +1,3 @@ - +The best Norwegian male sport climbers. + +This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.`
13	20th January 2025	21:33:55	remus	-	-	list_name
Before `None` After `Strong Norwegian Male Sport Climbers`
14	20th January 2025	21:33:55	remus	-	-	list_definition
Before `None` After select '<a href="/climber/' \|\| cast(c.climber_id as varchar) \|\| '">' \|\| c.climber_name \|\| '</a>' as Climber ,g.grade as Grade ,string_agg('<a href="/climb/' \|\| cast(cl.climb_id as varchar) \|\| '">' \|\| cl.climb_name \|\| '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs from ascents a inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id 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 hardest_ascent ha on c.climber_id = ha.climber_id and cl.grade_id = ha.max_grade_id and cl.climb_type_id = ha.climb_type where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 1 and c.gender = false and c.country_id = 5 and cl.grade_id >= 17 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not a.ascent_type_id = 6 group by c.climber_name ,g.grade ,c.climber_id order by g.grade desc ,count() desc ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end)) Diff* --- before +++ after @@ -1 +1,43 @@ - +select + '' \|\| c.climber_name \|\| '' as Climber + ,g.grade as Grade + ,string_agg('' \|\| cl.climb_name \|\| '', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs + + from + ascents a + inner join ascent_styles ast + on a.ascent_style_id = ast.ascent_style_id + 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 hardest_ascent ha + on c.climber_id = ha.climber_id + and cl.grade_id = ha.max_grade_id +and cl.climb_type_id = ha.climb_type + + where + a.deleted_on is null + and c.deleted_on is null + and cl.deleted_on is null + and cl.climb_type = 1 + and c.gender = false + and c.country_id = 5 + and cl.grade_id >= 17 + and c.exclude_reason is null + and cl.exclude_reason is null + and a.exclude_reason is null + and ast.ascent_successful +and not a.ascent_type_id = 6 + + group by + c.climber_name + ,g.grade + ,c.climber_id + + order by + g.grade desc + ,count(*) desc + ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))

Before

true

After

false

Before

<p>The best Norwegian male sport climbers.</p>
<p>This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>

After

<p>The best Norwegian sport climbers.</p>
<p>This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>

Before

select
        '<a href="/climber/' || cast(c.climber_id as varchar) ||  '">' || c.climber_name || '</a>' as Climber
        ,g.grade as Grade
        ,string_agg('<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs
        
    from
        ascents a
		inner join ascent_styles ast
			on a.ascent_style_id = ast.ascent_style_id
        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 hardest_ascent ha
            on c.climber_id = ha.climber_id
            and cl.grade_id = ha.max_grade_id
and cl.climb_type_id = ha.climb_type
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 1
        and c.gender = false
        and c.country_id = 5
        and cl.grade_id >= 17
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
and not a.ascent_type_id = 6
            
    group by
        c.climber_name
        ,g.grade
        ,c.climber_id
        
    order by
        g.grade desc
        ,count(*) desc
        ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))

After

select
        '<a href="/climber/' || cast(c.climber_id as varchar) ||  '">' || c.climber_name || '</a>' as Climber
        ,g.grade as Grade
        ,string_agg('<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs
        
    from
        ascents a
		inner join ascent_styles ast
			on a.ascent_style_id = ast.ascent_style_id
        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 hardest_ascent ha
            on c.climber_id = ha.climber_id
            and cl.grade_id = ha.max_grade_id
and cl.climb_type_id = ha.climb_type
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 1
        and c.country_id = 5
        and cl.grade_id >= 19
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
and not a.ascent_type_id = 6
            
    group by
        c.climber_name
        ,g.grade
        ,c.climber_id
        
    order by
        g.grade desc
        ,count(*) desc
        ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))

Diff

--- before

+++ after

@@ -23,9 +23,8 @@

         and c.deleted_on is null

         and cl.deleted_on is null

         and cl.climb_type = 1

-        and c.gender = false

         and c.country_id = 5

-        and cl.grade_id >= 17

+        and cl.grade_id >= 19

         and c.exclude_reason is null

         and cl.exclude_reason is null

         and a.exclude_reason is null

Before

The best Norwegian male sport climbers.

This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.

After

The best Norwegian sport climbers.

This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.

Diff

--- before

+++ after

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

-The best Norwegian male sport climbers.

+The best Norwegian sport climbers.

 

-This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
+This list aims to list any Norwegian sport climber who has climbed 9a or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.

Before

Strong Norwegian Male Sport Climbers

After

Strong Norwegian Sport Climbers

Before

insert into
	climber_meta (climber_id, value, display_value, climber_meta_key_id)

select
        c.climber_id
		,'/list/50/strong-norwegian-male-sport-climbers
		,'Strong Norwegian Male Sport Climbers - #' || row_number() over (order by g.grade desc, count(*) desc, min(order_dt(a.ascent_dt_start, a.ascent_dt_end)))::varchar
		,27
        
    from
        ascents a
		inner join ascent_styles ast
			on a.ascent_style_id = ast.ascent_style_id
        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 hardest_ascent ha
            on c.climber_id = ha.climber_id
            and cl.grade_id = ha.max_grade_id
and cl.climb_type_id = ha.climb_type
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 1
        and c.gender = false
        and c.country_id = 5
        and cl.grade_id >= 17
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
		and not a.ascent_type_id = 6
            
    group by
        c.climber_name
        ,g.grade
        ,c.climber_id

After

insert into
	climber_meta (climber_id, value, display_value, climber_meta_key_id)

select
        c.climber_id
		,'/list/50/strong-norwegian-sport-climbers
		,'Strong Norwegian Sport Climbers - #' || row_number() over (order by g.grade desc, count(*) desc, min(order_dt(a.ascent_dt_start, a.ascent_dt_end)))::varchar
		,27
        
    from
        ascents a
		inner join ascent_styles ast
			on a.ascent_style_id = ast.ascent_style_id
        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 hardest_ascent ha
            on c.climber_id = ha.climber_id
            and cl.grade_id = ha.max_grade_id
and cl.climb_type_id = ha.climb_type
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 1
        and c.country_id = 5
        and cl.grade_id >= 19
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
		and not a.ascent_type_id = 6
            
    group by
        c.climber_name
        ,g.grade
        ,c.climber_id

Before

None

After

insert into
	climber_meta (climber_id, value, display_value, climber_meta_key_id)

select
        c.climber_id
		,'/list/50/strong-norwegian-male-sport-climbers
		,'Strong Norwegian Male Sport Climbers - #' || row_number() over (order by g.grade desc, count(*) desc, min(order_dt(a.ascent_dt_start, a.ascent_dt_end)))::varchar
		,27
        
    from
        ascents a
		inner join ascent_styles ast
			on a.ascent_style_id = ast.ascent_style_id
        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 hardest_ascent ha
            on c.climber_id = ha.climber_id
            and cl.grade_id = ha.max_grade_id
and cl.climb_type_id = ha.climb_type
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 1
        and c.gender = false
        and c.country_id = 5
        and cl.grade_id >= 17
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
		and not a.ascent_type_id = 6
            
    group by
        c.climber_name
        ,g.grade
        ,c.climber_id

Before

None

After

4

Before

false

After

true

Before

None

After

<p>The best Norwegian male sport climbers.</p>
<p>This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>

Before

None

After

Nationality

Before

None

After

The best Norwegian male sport climbers.

This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.

Diff

--- before

+++ after

@@ -1 +1,3 @@

-
+The best Norwegian male sport climbers.

+

+This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.

Before

None

After

Strong Norwegian Male Sport Climbers

Before

None

After

select
        '<a href="/climber/' || cast(c.climber_id as varchar) ||  '">' || c.climber_name || '</a>' as Climber
        ,g.grade as Grade
        ,string_agg('<a href="/climb/' || cast(cl.climb_id as varchar) || '">' || cl.climb_name || '</a>', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs
        
    from
        ascents a
		inner join ascent_styles ast
			on a.ascent_style_id = ast.ascent_style_id
        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 hardest_ascent ha
            on c.climber_id = ha.climber_id
            and cl.grade_id = ha.max_grade_id
and cl.climb_type_id = ha.climb_type
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 1
        and c.gender = false
        and c.country_id = 5
        and cl.grade_id >= 17
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
and not a.ascent_type_id = 6
            
    group by
        c.climber_name
        ,g.grade
        ,c.climber_id
        
    order by
        g.grade desc
        ,count(*) desc
        ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))

Diff

--- before

+++ after

@@ -1 +1,43 @@

-
+select

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

+        ,g.grade as Grade

+        ,string_agg('' || cl.climb_name || '', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as Climbs

+        

+    from

+        ascents a

+		inner join ascent_styles ast

+			on a.ascent_style_id = ast.ascent_style_id

+        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 hardest_ascent ha

+            on c.climber_id = ha.climber_id

+            and cl.grade_id = ha.max_grade_id

+and cl.climb_type_id = ha.climb_type

+            

+    where

+        a.deleted_on is null

+        and c.deleted_on is null

+        and cl.deleted_on is null

+        and cl.climb_type = 1

+        and c.gender = false

+        and c.country_id = 5

+        and cl.grade_id >= 17

+        and c.exclude_reason is null

+        and cl.exclude_reason is null

+        and a.exclude_reason is null

+	and ast.ascent_successful

+and not a.ascent_type_id = 6

+            

+    group by

+        c.climber_name

+        ,g.grade

+        ,c.climber_id

+        

+    order by

+        g.grade desc

+        ,count(*) desc

+        ,min(order_dt(a.ascent_dt_start, a.ascent_dt_end))

Change Log for Strong Norwegian Sport Climbers

Overview

14

20th Jan 2025

3rd Feb 2025

Log

Page 1