remus

Badges

OG100 Contributions1,000 Contributions10,000 Contributions100,000 Contributions10 Posts100 Posts

Contributions

Posts

1 Day

631

7 Days

1848

4 Weeks

6668

All Time

165611

Current Streak

54

Longest Streak

181

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 74 21st February 2026 10th February 2025
3 https://www.instagram.com/p/DSTP2Z8ANtI/ media 72 1st April 2026 16th December 2025
4 Hard Rock list 67 19th August 2025 27th July 2024
5 https://www.instagram.com/p/DGD2HHVM4yn/ media 65 21st February 2026 14th February 2025
6 Remus Knowles climber 56 8th April 2026 30th March 2024
7 https://www.instagram.com/p/DVi7bJmjNhO/ media 55 16th March 2026 6th March 2026
8 Will Stanhope climber 51 6th May 2026 24th January 2021
9 https://open.spotify.com/episode/0cHKL3jWvp8A4QcZ1LS0YM media 51 6th October 2024 10th April 2024
10 https://www.instagram.com/p/BcX-gR8llwj/ media 48 23rd January 2026 24th January 2024

Recent Contributions

Date Time User Type Name Attribute
1 14th May 2026 20:42:44 UTC remus list Extreme Rock list_description_pretty
Before
None
After
<p>Climbs featured in Ken Wilson's classic <em>Extreme Rock</em>, drawn from the Climb Features metadata on the library items in the <a href="/library/collection/1/extreme-rock" rel="noopener noreferrer">Extreme Rock collection</a>.</p>
2 14th May 2026 20:42:44 UTC remus list Extreme Rock list_definition
Before
select c.climb_uuid as row_uuid ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name" ,g.grade as "Grade" ,'<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" ,( select count(*) from ascents a3 inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id where a3.climb_id = c.climb_id and a3.deleted_on is null and ast.ascent_successful ) as "# Ascents" from library_collection_items lci inner join library_item_meta lim on lci.library_item_id = lim.library_item_id and lim.library_item_meta_key_id = 8 inner join climbs c on lim.value::int = c.climb_id inner join grades g on c.grade_id = g.grade_id inner join crags cr on c.crag_id = cr.crag_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id where lci.library_collection_id = 1 and c.deleted_on is null order by g.order_on desc ,c.climb_name
After
select c.climb_uuid as row_uuid ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name" ,g.grade as "Grade" ,'<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" ,( select count(*) from ascents a3 inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id where a3.climb_id = c.climb_id and a3.deleted_on is null and ast.ascent_successful ) as "# Ascents" from library_collection_items lci inner join library_item_meta lim on lci.library_item_id = lim.library_item_id and lim.library_item_meta_key_id = 8 inner join climbs c on lim.value::int = c.climb_id inner join grades g on c.grade_id = g.grade_id inner join crags cr on c.crag_id = cr.crag_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id where lci.library_collection_id = 1 and c.deleted_on is null order by g.order_on desc ,c.climb_name
Diff
--- before

+++ after

@@ -1,41 +1,41 @@

-select
- c.climb_uuid as row_uuid
- ,'' || c.climb_name || '' as "Name"
- ,g.grade as "Grade"
- ,'' || cr.crag_name || '' as "Crag"
- ,'' || cl.climber_name || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
- ,(
- select count(*)
- from ascents a3
- inner join ascent_styles ast
- on a3.ascent_style_id = ast.ascent_style_id
- where a3.climb_id = c.climb_id
- and a3.deleted_on is null
- and ast.ascent_successful
- ) as "# Ascents"
-
-from
- library_collection_items lci
- inner join library_item_meta lim
- on lci.library_item_id = lim.library_item_id
- and lim.library_item_meta_key_id = 8
- inner join climbs c
- on lim.value::int = c.climb_id
- inner join grades g
- on c.grade_id = g.grade_id
- inner join crags cr
- on c.crag_id = cr.crag_id
- left join ascents a
- on a.climb_id = c.climb_id
- and a.fa = true
- and a.deleted_on is null
- left join climbers cl
- on a.climber_id = cl.climber_id
-
-where
- lci.library_collection_id = 1
- and c.deleted_on is null
-
-order by
- g.order_on desc
+select
+ c.climb_uuid as row_uuid
+ ,'' || c.climb_name || '' as "Name"
+ ,g.grade as "Grade"
+ ,'' || cr.crag_name || '' as "Crag"
+ ,'' || cl.climber_name || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+ ,(
+ select count(*)
+ from ascents a3
+ inner join ascent_styles ast
+ on a3.ascent_style_id = ast.ascent_style_id
+ where a3.climb_id = c.climb_id
+ and a3.deleted_on is null
+ and ast.ascent_successful
+ ) as "# Ascents"
+
+from
+ library_collection_items lci
+ inner join library_item_meta lim
+ on lci.library_item_id = lim.library_item_id
+ and lim.library_item_meta_key_id = 8
+ inner join climbs c
+ on lim.value::int = c.climb_id
+ inner join grades g
+ on c.grade_id = g.grade_id
+ inner join crags cr
+ on c.crag_id = cr.crag_id
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+
+where
+ lci.library_collection_id = 1
+ and c.deleted_on is null
+
+order by
+ g.order_on desc
,c.climb_name
3 14th May 2026 20:27:55 UTC remus ascent Pete Whillance's ascent of The Run of the Arrow Ascent #
Before
None
After
1
4 14th May 2026 20:27:54 UTC remus ascent Pete Whillance's ascent of The Run of the Arrow climber_id
Before
None
After
764
5 14th May 2026 20:27:54 UTC remus ascent Pete Whillance's ascent of The Run of the Arrow ascent_type_id
Before
None
After
5
6 14th May 2026 20:27:54 UTC remus ascent Pete Whillance's ascent of The Run of the Arrow ascent_style_id
Before
None
After
7
7 14th May 2026 20:27:54 UTC remus ascent Pete Whillance's ascent of The Run of the Arrow ascent_dt_end
Before
None
After
1982-07-24
8 14th May 2026 20:27:54 UTC remus ascent Pete Whillance's ascent of The Run of the Arrow ascent_dt_start
Before
None
After
1982-07-24
9 14th May 2026 20:27:54 UTC remus ascent Pete Whillance's ascent of The Run of the Arrow climb_id
Before
None
After
4890
10 14th May 2026 20:27:33 UTC remus climb The Run of the Arrow Pitches
Before
None
After
3
11 14th May 2026 20:27:25 UTC remus climb The Run of the Arrow Website
Before
None
After
https://routes.smc.org.uk/route/17719
12 14th May 2026 20:26:57 UTC remus ascent Rab Anderson's ascent of The Naked Ape Ascent #
Before
None
After
1
13 14th May 2026 20:26:56 UTC remus ascent Rab Anderson's ascent of The Naked Ape ascent_style_id
Before
None
After
7
14 14th May 2026 20:26:56 UTC remus ascent Rab Anderson's ascent of The Naked Ape ascent_type_id
Before
None
After
5
15 14th May 2026 20:26:56 UTC remus ascent Rab Anderson's ascent of The Naked Ape ascent_dt_start
Before
None
After
1982-08-01
16 14th May 2026 20:26:56 UTC remus ascent Rab Anderson's ascent of The Naked Ape climber_id
Before
None
After
1725
17 14th May 2026 20:26:56 UTC remus ascent Rab Anderson's ascent of The Naked Ape climb_id
Before
None
After
4893
18 14th May 2026 20:26:56 UTC remus ascent Rab Anderson's ascent of The Naked Ape ascent_dt_end
Before
None
After
1982-08-01
19 14th May 2026 20:26:45 UTC remus ascent Murray Hamilton's ascent of The Naked Ape Ascent #
Before
None
After
1
20 14th May 2026 20:26:44 UTC remus ascent Murray Hamilton's ascent of The Naked Ape climb_id
Before
None
After
4893

Page 1 >