remus

Contributions

1 Day

160

7 Days

1152

4 Weeks

4518

All Time

110414

Top Contributions

Name Type # Changes Last Updated First Updated
1 https://www.youtube.com/watch?v=kpbCmJGkKHE media 108 14th July 2024 14th July 2024
2 https://www.instagram.com/p/DF5XgLjMdJu/ media 69 23rd April 2025 10th February 2025
3 Hard Rock list 66 31st July 2024 27th July 2024
4 https://www.instagram.com/p/DGD2HHVM4yn/ media 60 23rd April 2025 14th February 2025
5 https://open.spotify.com/episode/0cHKL3jWvp8A4QcZ1LS0YM media 51 6th October 2024 10th April 2024
6 None None 41 18th July 2025 6th March 2025
7 https://www.instagram.com/p/C09aKQQtBaT/ media 39 2nd November 2024 17th December 2023
8 Remus Knowles climber 35 24th May 2025 30th March 2024
9 Aidan Roberts's ascent of Arrival of the Birds ascent 33 9th July 2024 13th December 2023
10 Mountain 32 library item 33 27th June 2025 24th June 2025

Recent Contributions

Date Time User Type Name Attribute
31101 20th January 2025 21:33:55 remus list Strong Norwegian Sport Climbers list_type_id
Before
None
After
4
31102 20th January 2025 21:33:55 remus list Strong Norwegian Sport Climbers hidden
Before
false
After
true
31103 20th January 2025 21:33:55 remus list Strong Norwegian Sport Climbers list_description_pretty
Before
None
After
<p>The best Norwegian male sport climbers.</p> <p>This list aims to list any male Norwegian sport climber who has climbed 8c or harder. It attempts to be definitive in terms of the people included but does not attempt to enumerate every relevant ascent.</p>
31104 20th January 2025 21:33:55 remus list Strong Norwegian Sport Climbers list_type_name
Before
None
After
Nationality
31105 20th January 2025 21:33:55 remus list Strong Norwegian Sport Climbers 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 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 = 1 and c.gender = false and c.country_id = 5 and cl.grade_id >= 17 and c.exclude_reason is null and cl.exclude_reason is null and a.exclude_reason is null and ast.ascent_successful 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,43 @@

-
+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
+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 = 1
+ and c.gender = false
+ and c.country_id = 5
+ and cl.grade_id >= 17
+ and c.exclude_reason is null
+ and cl.exclude_reason is null
+ and a.exclude_reason is null
+ and ast.ascent_successful
+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))
31106 20th January 2025 21:33:55 remus list Strong Norwegian Sport Climbers list_name
Before
None
After
Strong Norwegian Male Sport Climbers
31107 20th January 2025 21:31:52 remus list Strong Norwegian Boulderers list_type_id
Before
1
After
4
31108 20th January 2025 21:31:52 remus list Strong Norwegian Boulderers list_name
Before
Strongest Norwegian Bouldererd
After
Strongest Norwegian Boulderers
31109 20th January 2025 21:31:52 remus list Strong Norwegian Boulderers list_type_name
Before
Bouldering
After
Nationality
31110 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers list_name
Before
None
After
Strongest Norwegian Bouldererd
31111 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers hidden
Before
false
After
true
31112 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers list_type_id
Before
None
After
1
31113 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers list_description_pretty
Before
None
After
<p>The best Norwegian male boulderers.</p> <p>This list aims to list any male Norwegian 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>
31114 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers 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 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.gender = false and c.country_id = 5 and g.order_on >= 39 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,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
+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.gender = false
+ and c.country_id = 5
+ and g.order_on >= 39
+ 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))
31115 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers 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.gender = false and c.country_id = 5 and g.order_on >= 39 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
31116 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers list_description
Before
None
After
The best Norwegian male boulderers. This list aims to list any male Norwegian 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 Norwegian male boulderers.
+
+This list aims to list any male Norwegian 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.
31117 20th January 2025 21:31:28 remus list Strong Norwegian Boulderers list_type_name
Before
None
After
Bouldering
31118 20th January 2025 21:28:14 remus ascent Fred Nicole's ascent of Chakijana ascent_dt_start
Before
2016-01-01
After
2016-10-01
31119 20th January 2025 21:28:14 remus ascent Fred Nicole's ascent of Chakijana notes
Before
None
After
### References [1] [https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands](https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands](https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands)
31120 20th January 2025 21:28:14 remus ascent Fred Nicole's ascent of Chakijana notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands">https://www.8a.nu/news/8b-c-fa-by-fred-nicole-46-in-rocklands</a></p>

< Page 1556 >