Change Log for Fast 9a+s

Overview

Total Changes

12

First Change

28th Mar 2025

Last Change

30th Mar 2025

Log

Date Time User Type Name Attribute
1 30th March 2025 20:57:32 remus - - list_definition
Before
select cl.climber_name as "Climber", c.climb_name as "Climb", coalesce(am.value::int, 1) as "Attempts" from ascents a inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null left join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id = 6 where a.deleted_on is null and (am is not null or a.ascent_style_id in (2,3)) and c.grade_id = 20 order by 3;
After
select cl.climber_name as "Climber", c.climb_name as "Climb", coalesce(am.value::int, 1) as "Attempts" from ascents a inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null left join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id = 6 where a.deleted_on is null and (am is not null or a.ascent_style_id in (2,3)) and c.grade_id = 20 order by "Attempts";
Diff
--- before

+++ after

@@ -14,4 +14,4 @@

a.deleted_on is null
and (am is not null or a.ascent_style_id in (2,3))
and c.grade_id = 20
-order by 3;
+order by "Attempts";
2 30th March 2025 20:55:45 remus - - list_definition
Before
with src as ( select 'Adam Ondra' as "Climber" ,'Super Crackinette' as "Climb" ,'1' as "Attempts" union all select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 ) select * from src order by "Attempts"
After
select cl.climber_name as "Climber", c.climb_name as "Climb", coalesce(am.value::int, 1) as "Attempts" from ascents a inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null left join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id = 6 where a.deleted_on is null and (am is not null or a.ascent_style_id in (2,3)) and c.grade_id = 20 order by 3;
Diff
--- before

+++ after

@@ -1,38 +1,17 @@

-with src as (
- select
- 'Adam Ondra' as "Climber"
- ,'Super Crackinette' as "Climb"
- ,'1' as "Attempts"
-
- union all
-
- select
- cl.climber_name as "Climber"
- ,c.climb_name as "Climb"
- ,am.value as "Attempts"
-
- 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 = 6
-
- where
- c.grade_id = 20
-)
select
- *
-
+ cl.climber_name as "Climber",
+ c.climb_name as "Climb",
+ coalesce(am.value::int, 1) as "Attempts"
from
- src
-
-order by
- "Attempts"
-
+ ascents a
+ inner join climbs c on a.climb_id = c.climb_id
+ and c.deleted_on is null
+ inner join climbers cl on a.climber_id = cl.climber_id
+ and cl.deleted_on is null
+ left join ascent_meta am on a.ascent_id = am.ascent_id
+ and am.ascent_meta_key_id = 6
+where
+ a.deleted_on is null
+ and (am is not null or a.ascent_style_id in (2,3))
+ and c.grade_id = 20
+order by 3;
3 28th March 2025 12:26:27 ben - - list_definition
Before
with src as ( select 'Adam Ondra' as "Climber" ,'Super Crackinette' as "Climb" ,'1' as "Attempts" union all select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 ), existing as ( select * from src order by "Attempts" ) SELECT column_name, data_type, character_maximum_length, is_nullable, column_default FROM information_schema.columns WHERE table_name = 'ascents';
After
with src as ( select 'Adam Ondra' as "Climber" ,'Super Crackinette' as "Climb" ,'1' as "Attempts" union all select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 ) select * from src order by "Attempts"
Diff
--- before

+++ after

@@ -26,8 +26,7 @@


where
c.grade_id = 20
-),
-existing as (
+)
select
*

@@ -36,14 +35,4 @@


order by
"Attempts"
-)
-SELECT
- column_name,
- data_type,
- character_maximum_length,
- is_nullable,
- column_default
-FROM
- information_schema.columns
-WHERE
- table_name = 'ascents';
+
4 28th March 2025 12:26:06 ben - - list_definition
Before
with src as ( select 'Adam Ondra' as "Climber" ,'Super Crackinette' as "Climb" ,'1' as "Attempts" union all select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 ) select * from src order by "Attempts"
After
with src as ( select 'Adam Ondra' as "Climber" ,'Super Crackinette' as "Climb" ,'1' as "Attempts" union all select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 ), existing as ( select * from src order by "Attempts" ) SELECT column_name, data_type, character_maximum_length, is_nullable, column_default FROM information_schema.columns WHERE table_name = 'ascents';
Diff
--- before

+++ after

@@ -26,8 +26,8 @@


where
c.grade_id = 20
-)
-
+),
+existing as (
select
*

@@ -35,4 +35,15 @@

src

order by
- "Attempts"
+ "Attempts"
+)
+SELECT
+ column_name,
+ data_type,
+ character_maximum_length,
+ is_nullable,
+ column_default
+FROM
+ information_schema.columns
+WHERE
+ table_name = 'ascents';
5 28th March 2025 12:13:47 remus - - list_definition
Before
select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 order by am.value::int
After
with src as ( select 'Adam Ondra' as "Climber" ,'Super Crackinette' as "Climb" ,'1' as "Attempts" union all select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 ) select * from src order by "Attempts"
Diff
--- before

+++ after

@@ -1,23 +1,38 @@

+with src as (
+ select
+ 'Adam Ondra' as "Climber"
+ ,'Super Crackinette' as "Climb"
+ ,'1' as "Attempts"
+
+ union all
+
+ select
+ cl.climber_name as "Climber"
+ ,c.climb_name as "Climb"
+ ,am.value as "Attempts"
+
+ 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 = 6
+
+ where
+ c.grade_id = 20
+)
+
select
- cl.climber_name as "Climber"
- ,c.climb_name as "Climb"
- ,am.value as "Attempts"
+ *

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 = 6
-
-where
- c.grade_id = 20
+ src

-order by
- am.value::int
+order by
+ "Attempts"
6 28th March 2025 11:20:24 remus - - list_type_id
Before
None
After
2
7 28th March 2025 11:20:24 remus - - list_name
Before
None
After
Fast 9a+s
8 28th March 2025 11:20:24 remus - - list_type_name
Before
None
After
Sport Climbing
9 28th March 2025 11:20:24 remus - - list_description
Before
None
After
Fast ascents of 9a+ sport routes.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Fast ascents of 9a+ sport routes.
10 28th March 2025 11:20:24 remus - - list_definition
Before
None
After
select cl.climber_name as "Climber" ,c.climb_name as "Climb" ,am.value as "Attempts" 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 = 6 where c.grade_id = 20 order by am.value::int
Diff
--- before

+++ after

@@ -1 +1,23 @@

-
+select
+ cl.climber_name as "Climber"
+ ,c.climb_name as "Climb"
+ ,am.value as "Attempts"
+
+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 = 6
+
+where
+ c.grade_id = 20
+
+order by
+ am.value::int
11 28th March 2025 11:20:24 remus - - list_description_pretty
Before
None
After
<p>Fast ascents of 9a+ sport routes.</p>
12 28th March 2025 11:20:24 remus - - hidden
Before
false
After
true

Page 1