Change Log | Climbing History

	Date	Time	User	Type	Name	Attribute
1	31st May 2025	07:24:07	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 = 3 and c.gender = false and c.country_id = 1 and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_style_id in (2,3) 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 left join climber_meta cm on cm.climber_id = c.climber_id and cm.climber_meta_key_id = 35 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and c.gender = false and (c.country_id = 1 or cm.value::int = 1) and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_style_id in (2,3) 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 @@ -17,6 +17,9 @@ on c.climber_id = ha.climber_id and cl.grade_id = ha.max_grade_id and cl.climb_type_id = ha.climb_type +left join climber_meta cm + on cm.climber_id = c.climber_id + and cm.climber_meta_key_id = 35 where a.deleted_on is null @@ -24,7 +27,7 @@ and cl.deleted_on is null and cl.climb_type = 3 and c.gender = false - and c.country_id = 1 + and (c.country_id = 1 or cm.value::int = 1) and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null`
2	4th January 2025	18:16:35	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 = 3 and c.gender = false and c.country_id = 1 and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_style_id in (2,3) 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 = 3 and c.gender = false and c.country_id = 1 and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_style_id in (2,3) 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 @@ -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	14th October 2024	12:36:43	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 = 3 and c.gender = false and c.nationality = 'GB' and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_style_id in (2,3) 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 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and c.gender = false and c.country_id = 1 and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_style_id in (2,3) 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,7 +23,7 @@ and cl.deleted_on is null and cl.climb_type = 3 and c.gender = false - and c.nationality = 'GB' + and c.country_id = 1 and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null`
4	30th August 2024	06:47:52	remus	-	-	list_type_id
Before `5` After `4`
5	30th August 2024	06:47:52	remus	-	-	list_type_name
Before `Misc.` After `Nationality`
6	4th June 2024	09:56:52	remus	-	-	hidden
Before `false` After `true`
7	4th June 2024	09:55:27	remus	-	-	list_name
Before `None` After `Best British Male Trad Climbers`
8	4th June 2024	09:55:27	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 where a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and cl.climb_type = 3 and c.gender = false and c.nationality = 'GB' and g.order_on >= 60 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_style_id in (2,3) 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,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 + + where + a.deleted_on is null + and c.deleted_on is null + and cl.deleted_on is null + and cl.climb_type = 3 + and c.gender = false + and c.nationality = 'GB' + and g.order_on >= 60 + and c.exclude_reason is null + and cl.exclude_reason is null + and a.exclude_reason is null + and ast.ascent_style_id in (2,3) +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))
9	4th June 2024	09:55:27	remus	-	-	list_description_pretty
Before `None` After `<p>British men who have onsighted or flashed E7 or harder.</p>`
10	4th June 2024	09:55:27	remus	-	-	list_description
Before `None` After `British men who have onsighted or flashed E7 or harder.` Diff `--- before +++ after @@ -1 +1 @@ - +British men who have onsighted or flashed E7 or harder.`

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 = 3
        and c.gender = false
        and c.country_id = 1
        and g.order_on >= 60
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_style_id in (2,3)
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
left join climber_meta cm
			on cm.climber_id = c.climber_id
			and cm.climber_meta_key_id = 35
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 3
        and c.gender = false
        and (c.country_id = 1 or cm.value::int = 1)
        and g.order_on >= 60
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_style_id in (2,3)
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

@@ -17,6 +17,9 @@

             on c.climber_id = ha.climber_id

             and cl.grade_id = ha.max_grade_id

 and cl.climb_type_id = ha.climb_type

+left join climber_meta cm

+			on cm.climber_id = c.climber_id

+			and cm.climber_meta_key_id = 35

             

     where

         a.deleted_on is null

@@ -24,7 +27,7 @@

         and cl.deleted_on is null

         and cl.climb_type = 3

         and c.gender = false

-        and c.country_id = 1

+        and (c.country_id = 1 or cm.value::int = 1)

         and g.order_on >= 60

         and c.exclude_reason is null

         and cl.exclude_reason is null

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 = 3
        and c.gender = false
        and c.country_id = 1
        and g.order_on >= 60
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_style_id in (2,3)
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 = 3
        and c.gender = false
        and c.country_id = 1
        and g.order_on >= 60
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_style_id in (2,3)
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

@@ -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

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 = 3
        and c.gender = false
        and c.nationality = 'GB'
        and g.order_on >= 60
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_style_id in (2,3)
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
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 3
        and c.gender = false
        and c.country_id = 1
        and g.order_on >= 60
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_style_id in (2,3)
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,7 +23,7 @@

         and cl.deleted_on is null

         and cl.climb_type = 3

         and c.gender = false

-        and c.nationality = 'GB'

+        and c.country_id = 1

         and g.order_on >= 60

         and c.exclude_reason is null

         and cl.exclude_reason is null

Before

5

After

4

Before

Misc.

After

Nationality

Before

false

After

true

Before

None

After

Best British Male Trad 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
            
    where
        a.deleted_on is null
        and c.deleted_on is null
        and cl.deleted_on is null
        and cl.climb_type = 3
        and c.gender = false
        and c.nationality = 'GB'
        and g.order_on >= 60
        and c.exclude_reason is null
        and cl.exclude_reason is null
        and a.exclude_reason is null
	and ast.ascent_style_id in (2,3)
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,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

+            

+    where

+        a.deleted_on is null

+        and c.deleted_on is null

+        and cl.deleted_on is null

+        and cl.climb_type = 3

+        and c.gender = false

+        and c.nationality = 'GB'

+        and g.order_on >= 60

+        and c.exclude_reason is null

+        and cl.exclude_reason is null

+        and a.exclude_reason is null

+	and ast.ascent_style_id in (2,3)

+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

None

After

<p>British men who have onsighted or flashed E7 or harder.</p>

Before

None

After

British men who have onsighted or flashed E7 or harder.

Diff

--- before

+++ after

@@ -1 +1 @@

-
+British men who have onsighted or flashed E7 or harder.

Change Log for Best British Male Trad Climbers

Overview

10

4th Jun 2024

31st May 2025

Log

Page 1