| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 4th January 2025 | 18:16:58 | 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.country_id = 2
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
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.country_id = 2
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
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
|
|||||||
| 2 | 4th January 2025 | 18:16:58 | remus | - | - | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/40/strong-american-boulderers'
,'Strong American 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.country_id = 2
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
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/40/strong-american-boulderers'
,'Strong American 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.country_id = 2
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
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 3 | 14th October 2024 | 12:38:14 | remus | - | - | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/40/strong-american-boulderers'
,'Strong American 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.nationality = 'US'
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
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/40/strong-american-boulderers'
,'Strong American 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.country_id = 2
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
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 4 | 14th October 2024 | 12:38:14 | 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.nationality = 'US'
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
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.country_id = 2
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
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
@@ -22,7 +22,7 @@
and c.deleted_on is null
and cl.deleted_on is null
and cl.climb_type = 2
- and c.nationality = 'US'
+ and c.country_id = 2
and g.order_on >= 40
and c.exclude_reason is null
and cl.exclude_reason is null
|
|||||||
| 5 | 23rd September 2024 | 16:45:56 | remus | - | - | list_name | |
|
Before
Strong American Boulderers
After
Strong North American Boulderers
|
|||||||
| 6 | 23rd September 2024 | 16:45:56 | remus | - | - | list_description | |
|
Before
The best American boulderers.
This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Big thanks to [eric.jerome](/user/50/eric.jerome) for compiling and maintaining this list.
After
The best North American boulderers.
This list aims to list any North American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Big thanks to [eric.jerome](/user/50/eric.jerome) for compiling and maintaining this list.
Diff
--- before
+++ after
@@ -1,5 +1,5 @@
-The best American boulderers.
+The best North American boulderers.
-This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
+This list aims to list any North American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Big thanks to [eric.jerome](/user/50/eric.jerome) for compiling and maintaining this list.
|
|||||||
| 7 | 23rd September 2024 | 16:45:56 | remus | - | - | list_description_pretty | |
|
Before
<p>The best American boulderers.</p>
<p>This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
<p>Big thanks to <a href="/user/50/eric.jerome">eric.jerome</a> for compiling and maintaining this list.</p>
After
<p>The best North American boulderers.</p>
<p>This list aims to list any North American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
<p>Big thanks to <a href="/user/50/eric.jerome">eric.jerome</a> for compiling and maintaining this list.</p>
|
|||||||
| 8 | 23rd September 2024 | 05:37:36 | remus | - | - | generate_meta | |
|
Before
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/3/strong-british-male-boulderers'
,'Strong British Male 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.nationality = 'US'
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
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/40/strong-american-boulderers'
,'Strong American 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.nationality = 'US'
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
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 9 | 22nd September 2024 | 08:11:01 | remus | - | - | list_description | |
|
Before
The best American boulderers.
This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
After
The best American boulderers.
This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Big thanks to [eric.jerome](/user/50/eric.jerome) for compiling and maintaining this list.
Diff
--- before
+++ after
@@ -1,3 +1,5 @@
The best American boulderers.
-This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
+This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
+
+Big thanks to [eric.jerome](/user/50/eric.jerome) for compiling and maintaining this list.
|
|||||||
| 10 | 22nd September 2024 | 08:11:01 | remus | - | - | list_description_pretty | |
|
Before
<p>The best American boulderers.</p>
<p>This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
After
<p>The best American boulderers.</p>
<p>This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
<p>Big thanks to <a href="/user/50/eric.jerome">eric.jerome</a> for compiling and maintaining this list.</p>
|
|||||||
| 11 | 22nd September 2024 | 08:09:35 | remus | - | - | generate_meta | |
|
Before
None
After
insert into
climber_meta (climber_id, value, display_value, climber_meta_key_id)
select
c.climber_id
,'/list/3/strong-british-male-boulderers'
,'Strong British Male 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.nationality = 'US'
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
group by
c.climber_name
,g.grade
,c.climber_id
|
|||||||
| 12 | 22nd September 2024 | 08:09:35 | remus | - | - | list_description_pretty | |
|
Before
None
After
<p>The best American boulderers.</p>
<p>This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
|
|||||||
| 13 | 22nd September 2024 | 08:09:35 | 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 = 2
and c.nationality = 'US'
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
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,40 @@
-
+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.nationality = 'US'
+ 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
+
+ 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))
|
|||||||
| 14 | 22nd September 2024 | 08:09:35 | remus | - | - | list_description | |
|
Before
None
After
The best American boulderers.
This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
Diff
--- before
+++ after
@@ -1 +1,3 @@
-
+The best American boulderers.
+
+This list aims to list any American boulderer who has climbed 8B+ or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.
|
|||||||
| 15 | 22nd September 2024 | 08:09:35 | remus | - | - | list_name | |
|
Before
None
After
Strong American Boulderers
|
|||||||
| 16 | 22nd September 2024 | 08:09:35 | remus | - | - | list_type_name | |
|
Before
None
After
Nationality
|
|||||||
| 17 | 22nd September 2024 | 08:09:35 | remus | - | - | list_type_id | |
|
Before
None
After
4
|
|||||||