Change Log | Climbing History

	Date	Time	User	Type	Name	Attribute
1	3rd February 2025	08:15:14	remus	-	-	list_name
Before `Strongest Norwegian Boulderers` After `Strong Norwegian Boulderers`
2	3rd February 2025	06:46:14	remus	-	-	hidden
Before `true` After `false`
3	21st January 2025	06:46:32	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 = 2 and c.gender = false and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful 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 = 2 and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful 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,7 +23,6 @@ and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 2 - and c.gender = false and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null`
4	21st January 2025	06:46:32	remus	-	-	list_description
Before `The best Norwegian male boulderers. This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderers. This list aims to list any Norwegian boulderer who has climbed 8B 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 boulderers. +The best Norwegian boulderers. -This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderer who has climbed 8B 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:46:32	remus	-	-	generate_meta
Before insert into climber_meta (climber_id, value, display_value, climber_meta_key_id) select c.climber_id ,'/list/49/strongest-norwegian-boulderers' ,'Strong Norwegian Male Boulderers - #' \|\| 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 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 2 and c.gender = false and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful 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/49/strongest-norwegian-boulderers' ,'Strong Norwegian Boulderers - #' \|\| 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 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 2 and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful group by c.climber_name ,g.grade ,c.climber_id
6	21st January 2025	06:46:32	remus	-	-	list_description_pretty
Before `<p>The best Norwegian male boulderers.</p> <p>This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderers.</p> <p>This list aims to list any Norwegian boulderer who has climbed 8B or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>`
7	20th January 2025	21:34:38	remus	-	-	generate_meta
Before insert into climber_meta (climber_id, value, display_value, climber_meta_key_id) select c.climber_id ,'/list/3/strong-british-male-boulderers' ,'Strong British Male Boulderers - #' \|\| 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 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 2 and c.gender = false and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful 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/49/strongest-norwegian-boulderers' ,'Strong Norwegian Male Boulderers - #' \|\| 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 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 2 and c.gender = false and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful group by c.climber_name ,g.grade ,c.climber_id
8	20th January 2025	21:31:52	remus	-	-	list_type_name
Before `Bouldering` After `Nationality`
9	20th January 2025	21:31:52	remus	-	-	list_type_id
Before `1` After `4`
10	20th January 2025	21:31:52	remus	-	-	list_name
Before `Strongest Norwegian Bouldererd` After `Strongest Norwegian Boulderers`
11	20th January 2025	21:31:28	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 = 2 and c.gender = false and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful 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,42 @@ - +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 = 2 + and c.gender = false + and c.country_id = 5 + and g.order_on >= 39 + and c.exclude_reason is null + and cl.exclude_reason is null + and a.exclude_reason is null + and ast.ascent_successful + + 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))
12	20th January 2025	21:31:28	remus	-	-	list_description
Before `None` After `The best Norwegian male boulderers. This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderers. + +This list aims to list any male Norwegian boulderer who has climbed 8B 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:31:28	remus	-	-	list_type_id
Before `None` After `1`
14	20th January 2025	21:31:28	remus	-	-	list_type_name
Before `None` After `Bouldering`
15	20th January 2025	21:31:28	remus	-	-	hidden
Before `false` After `true`
16	20th January 2025	21:31:28	remus	-	-	list_name
Before `None` After `Strongest Norwegian Bouldererd`
17	20th January 2025	21:31:28	remus	-	-	generate_meta
Before `None` After insert into climber_meta (climber_id, value, display_value, climber_meta_key_id) select c.climber_id ,'/list/3/strong-british-male-boulderers' ,'Strong British Male Boulderers - #' \|\| 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 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 2 and c.gender = false and c.country_id = 5 and g.order_on >= 39 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful group by c.climber_name ,g.grade ,c.climber_id
18	20th January 2025	21:31:28	remus	-	-	list_description_pretty
Before `None` After `<p>The best Norwegian male boulderers.</p> <p>This list aims to list any male Norwegian boulderer who has climbed 8B or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>`

Before

Strongest Norwegian Boulderers

After

Strong Norwegian Boulderers

Before

true

After

false

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 = 2
        and c.gender = false
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    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 = 2
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    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,7 +23,6 @@

         and c.deleted_on is null

         and cl.deleted_on is null

         and cl.climb_type = 2

-        and c.gender = false

         and c.country_id = 5

         and g.order_on >= 39

         and c.exclude_reason is null

Before

The best Norwegian male boulderers.

This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderers.

This list aims to list any Norwegian boulderer who has climbed 8B 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 boulderers.

+The best Norwegian boulderers.

 

-This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderer who has climbed 8B or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.

Before

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

select
        c.climber_id
		,'/list/49/strongest-norwegian-boulderers'
		,'Strong Norwegian Male Boulderers - #' || 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
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 2
        and c.gender = false
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    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/49/strongest-norwegian-boulderers'
		,'Strong Norwegian Boulderers - #' || 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
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 2
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    group by
        c.climber_name
        ,g.grade
       ,c.climber_id

Before

<p>The best Norwegian male boulderers.</p>
<p>This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderers.</p>
<p>This list aims to list any Norwegian boulderer who has climbed 8B or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>

Before

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

select
        c.climber_id
		,'/list/3/strong-british-male-boulderers'
		,'Strong British Male Boulderers - #' || 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
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 2
        and c.gender = false
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    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/49/strongest-norwegian-boulderers'
		,'Strong Norwegian Male Boulderers - #' || 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
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 2
        and c.gender = false
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    group by
        c.climber_name
        ,g.grade
       ,c.climber_id

Before

Bouldering

After

Nationality

Before

1

After

4

Before

Strongest Norwegian Bouldererd

After

Strongest Norwegian Boulderers

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 = 2
        and c.gender = false
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    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,42 @@

-
+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 = 2

+        and c.gender = false

+        and c.country_id = 5

+        and g.order_on >= 39

+        and c.exclude_reason is null

+        and cl.exclude_reason is null

+        and a.exclude_reason is null

+		and ast.ascent_successful

+            

+    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

None

After

The best Norwegian male boulderers.

This list aims to list any male Norwegian boulderer who has climbed 8B 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 boulderers.

+

+This list aims to list any male Norwegian boulderer who has climbed 8B 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

1

Before

None

After

Bouldering

Before

false

After

true

Before

None

After

Strongest Norwegian Bouldererd

Before

None

After

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

select
        c.climber_id
		,'/list/3/strong-british-male-boulderers'
		,'Strong British Male Boulderers - #' || 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
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 2
        and c.gender = false
        and c.country_id = 5
        and g.order_on >= 39
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
		and ast.ascent_successful
            
    group by
        c.climber_name
        ,g.grade
       ,c.climber_id

Before

None

After

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

Change Log for Strong Norwegian Boulderers

Overview

18

20th Jan 2025

3rd Feb 2025

Log

Page 1