Change Log for First Ascents by British Women

Overview

Total Changes

6

First Change

2nd May 2025

Last Change

2nd May 2025

Log

Date Time User Type Name Attribute
1 2nd May 2025 16:30:33 remus - - list_name
Before
None
After
First Ascents by British Women
2 2nd May 2025 16:30:33 remus - - list_description
Before
None
After
A list of first ascents by British women.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+A list of first ascents by British women.
3 2nd May 2025 16:30:33 remus - - list_definition
Before
None
After
select '<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as "Climber" ,'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb" ,g.grade as "Grade" ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date" from ascents a inner join climbs c on a.climb_id = c.climb_id and a.deleted_on is null and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id = 7 and am.value = '1' inner join grades g on c.grade_id = g.grade_id where cl.gender = true and cl.country_id = 1 order by c.climb_type_id ,g.order_on desc
Diff
--- before

+++ after

@@ -1 +1,29 @@

-
+select
+ '' || cl.climber_name || '' as "Climber"
+ ,'' || c.climb_name || '' as "Climb"
+ ,g.grade as "Grade"
+ ,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
+
+from
+ ascents a
+ inner join climbs c
+ on a.climb_id = c.climb_id
+ and a.deleted_on is null
+ and c.deleted_on is null
+ inner join climbers cl
+ on a.climber_id = cl.climber_id
+ and cl.deleted_on is null
+ inner join ascent_meta am
+ on a.ascent_id = am.ascent_id
+ and am.ascent_meta_key_id = 7
+ and am.value = '1'
+ inner join grades g
+ on c.grade_id = g.grade_id
+
+where
+ cl.gender = true
+ and cl.country_id = 1
+
+order by
+ c.climb_type_id
+ ,g.order_on desc
4 2nd May 2025 16:30:33 remus - - list_description_pretty
Before
None
After
<p>A list of first ascents by British women.</p>
5 2nd May 2025 16:30:33 remus - - list_type_id
Before
None
After
4
6 2nd May 2025 16:30:33 remus - - list_type_name
Before
None
After
Nationality

Page 1