Change Log | Climbing History

	Date	Time	User	Type	Name	Attribute
1	4th January 2025	18:12:48	remus	-	-	generate_meta
Before insert into climber_meta (climber_id, value, display_value, climber_meta_key_id) select c.climber_id ,'/list/18/strongest-female-boulderers' ,'Strongest Female 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 = true and g.order_on >= 40 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not c.climber_id = 634 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/18/strongest-female-boulderers' ,'Strongest Female 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 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 = true and g.order_on >= 40 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not c.climber_id = 634 group by c.climber_name ,g.grade ,c.climber_id
2	4th January 2025	18:12:48	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 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 = true and g.order_on >= 40 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not c.climber_id = 634 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.gender = true and g.order_on >= 40 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not c.climber_id = 634 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 @@ -16,6 +16,7 @@ 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`
3	30th August 2024	06:46:06	remus	-	-	list_type_name
Before `Misc.` After `Bouldering`
4	30th August 2024	06:46:06	remus	-	-	list_type_id
Before `5` After `1`
5	10th April 2024	05:58:18	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>', ', ') 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 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 = true and g.order_on >= 40 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not c.climber_id = 634 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 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 = true and g.order_on >= 40 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful and not c.climber_id = 634 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,7 +1,7 @@ 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>', ', ') as Climbs + ,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`
6	5th May 2023	13:02:02	remus	-	-	-
Before `None` After `None`
7	5th May 2023	12:58:41	remus	-	-	-
Before `None` After `None`
8	27th February 2023	08:40:01	remus	-	-	-
Before `None` After `None`
9	27th February 2023	08:39:56	remus	-	-	-
Before `None` After `None`
10	27th February 2023	08:24:28	remus	-	-	-
Before `None` After `None`
11	27th February 2023	07:59:24	remus	-	-	-
Before `None` After `None`
12	27th February 2023	07:59:22	remus	-	-	-
Before `None` After `None`
13	27th February 2023	07:59:18	remus	-	-	-
Before `None` After `None`
14	27th February 2023	07:59:14	remus	-	-	-
Before `None` After `None`
15	27th February 2023	07:59:12	remus	-	-	-
Before `None` After `None`
16	27th February 2023	07:59:07	remus	-	-	-
Before `None` After `None`
17	27th February 2023	07:58:14	remus	-	-	-
Before `None` After `None`
18	27th February 2023	07:58:10	remus	-	-	-
Before `None` After `None`
19	27th February 2023	07:57:56	remus	-	-	-
Before `None` After `None`
20	27th February 2023	07:57:04	remus	-	-	-
Before `None` After `None`

Before

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

select
        c.climber_id
		,'/list/18/strongest-female-boulderers'
		,'Strongest Female 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 = true
        and g.order_on >= 40
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
        and not c.climber_id = 634
            
    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/18/strongest-female-boulderers'
		,'Strongest Female 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
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 = true
        and g.order_on >= 40
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
        and not c.climber_id = 634
            
    group by
        c.climber_name
        ,g.grade
       ,c.climber_id

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
            
    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 = true
        and g.order_on >= 40
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
        and not c.climber_id = 634
            
    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.gender = true
        and g.order_on >= 40
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
        and not c.climber_id = 634
            
    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

@@ -16,6 +16,7 @@

         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

Before

Misc.

After

Bouldering

Before

5

After

1

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>', ', ') 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
            
    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 = true
        and g.order_on >= 40
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
        and not c.climber_id = 634
            
    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
            
    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 = true
        and g.order_on >= 40
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_successful
        and not c.climber_id = 634
            
    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,7 +1,7 @@

 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>', ', ') as Climbs
+        ,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

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Before

None

After

None

Change Log for Strongest Female Boulderers

Overview

27

20th Oct 2022

4th Jan 2025

Log

Page 1 >