Change Log for Hard Flash or Onsight Ascents by British Climbers

Overview

Total Changes

13

First Change

18th Jun 2021

Last Change

31st May 2025

Log

Date Time User Type Name Attribute
1 31st May 2025 07:23:14 remus - - list_definition
Before
select '<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>' as "Climber" ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb" ,g.grade as "Grade" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date" ,coalesce(a.notes_pretty,'') as "Notes" from ascents a inner join climbs c on a.climb_id = c.climb_id inner join grades g on c.grade_id = g.grade_id inner join climbers cl on a.climber_id = cl.climber_id where c.climb_type = 1 and a.ascent_style_id in (2,3) and g.order_on >= 14 and a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and a.exclude_reason is null and c.exclude_reason is null and cl.exclude_reason is null and cl.country_id = 1 and not a.ascent_type_id = 6 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) ,g.order_on desc
After
select '<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>' as "Climber" ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb" ,g.grade as "Grade" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date" ,coalesce(a.notes_pretty,'') as "Notes" from ascents a inner join climbs c on a.climb_id = c.climb_id inner join grades g on c.grade_id = g.grade_id inner join climbers cl on a.climber_id = cl.climber_id left join climber_meta cm on cm.climber_id = cl.climber_id and cm.climber_meta_key_id = 35 where c.climb_type = 1 and a.ascent_style_id in (2,3) and g.order_on >= 14 and a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and a.exclude_reason is null and c.exclude_reason is null and cl.exclude_reason is null and (cl.country_id = 1 or cm.value::int = 1) and not a.ascent_type_id = 6 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) ,g.order_on desc
Diff
--- before

+++ after

@@ -13,6 +13,9 @@

on c.grade_id = g.grade_id
inner join climbers cl
on a.climber_id = cl.climber_id
+left join climber_meta cm
+ on cm.climber_id = cl.climber_id
+ and cm.climber_meta_key_id = 35

where
c.climb_type = 1
@@ -24,7 +27,7 @@

and a.exclude_reason is null
and c.exclude_reason is null
and cl.exclude_reason is null
- and cl.country_id = 1
+ and (cl.country_id = 1 or cm.value::int = 1)
and not a.ascent_type_id = 6

order by
2 14th October 2024 12:36:21 remus - - list_definition
Before
select '<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>' as "Climber" ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb" ,g.grade as "Grade" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date" ,coalesce(a.notes_pretty,'') as "Notes" from ascents a inner join climbs c on a.climb_id = c.climb_id inner join grades g on c.grade_id = g.grade_id inner join climbers cl on a.climber_id = cl.climber_id where c.climb_type = 1 and a.ascent_style_id in (2,3) and g.order_on >= 14 and a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and a.exclude_reason is null and c.exclude_reason is null and cl.exclude_reason is null and cl.nationality = 'GB' and not a.ascent_type_id = 6 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) ,g.order_on desc
After
select '<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>' as "Climber" ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Climb" ,g.grade as "Grade" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Ascent Date" ,coalesce(a.notes_pretty,'') as "Notes" from ascents a inner join climbs c on a.climb_id = c.climb_id inner join grades g on c.grade_id = g.grade_id inner join climbers cl on a.climber_id = cl.climber_id where c.climb_type = 1 and a.ascent_style_id in (2,3) and g.order_on >= 14 and a.deleted_on is null and c.deleted_on is null and cl.deleted_on is null and a.exclude_reason is null and c.exclude_reason is null and cl.exclude_reason is null and cl.country_id = 1 and not a.ascent_type_id = 6 order by order_dt(a.ascent_dt_start, a.ascent_dt_end) ,g.order_on desc
Diff
--- before

+++ after

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

and a.exclude_reason is null
and c.exclude_reason is null
and cl.exclude_reason is null
- and cl.nationality = 'GB'
+ and cl.country_id = 1
and not a.ascent_type_id = 6

order by
3 30th August 2024 06:45:21 remus - - list_type_name
Before
Misc.
After
Nationality
4 30th August 2024 06:45:21 remus - - list_type_id
Before
5
After
4
5 8th May 2024 10:09:14 remus - - list_description
Before
A list of hard flash or onsight ascents by British men and women a.k.a The Steve McClure list. Focus is on ascents in the UK, but not exclusively so.
After
A list of hard flash or onsight ascents by British men and women. Focus is on ascents in the UK, but not exclusively so.
Diff
--- before

+++ after

@@ -1 +1 @@

-A list of hard flash or onsight ascents by British men and women a.k.a The Steve McClure list. Focus is on ascents in the UK, but not exclusively so.
+A list of hard flash or onsight ascents by British men and women. Focus is on ascents in the UK, but not exclusively so.
6 8th May 2024 10:09:14 remus - - list_description_pretty
Before
<p>A list of hard flash or onsight ascents by British men and women a.k.a The Steve McClure list. Focus is on ascents in the UK, but not exclusively so.</p>
After
<p>A list of hard flash or onsight ascents by British men and women. Focus is on ascents in the UK, but not exclusively so.</p>
7 23rd April 2023 16:50:09 remus - - -
Before
None
After
None
8 23rd April 2023 16:39:43 remus - - -
Before
None
After
None
9 11th June 2022 09:51:54 remus - - -
Before
None
After
None
10 19th October 2021 17:17:48 remus - - -
Before
None
After
None
11 18th June 2021 06:36:00 remus - - -
Before
None
After
None
12 18th June 2021 06:34:44 remus - - -
Before
None
After
None
13 18th June 2021 06:33:40 remus - - -
Before
None
After
None

Page 1