remus

Badges

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

Contributions

Posts

1 Day

57

7 Days

827

4 Weeks

7337

All Time

193177

Current Streak

195

Longest Streak

195

Contributions Map

Contributions by Country

Country Contributions Between Climbers Crags Summits Climbs Ascents
1 United Kingdom 53143 14th November 2023 – 2nd October 2026 1423 699 0 3072 4895
2 USA 24599 14th November 2023 – 2nd October 2026 795 181 2 848 2358
3 France 12150 14th November 2023 – 2nd October 2026 264 126 1 551 1032
4 Switzerland 9430 14th November 2023 – 29th September 2026 77 43 1 307 1105
5 Spain 8349 15th November 2023 – 26th September 2026 89 74 0 443 896
6 Italy 4632 16th November 2023 – 1st October 2026 118 59 0 184 358
7 South Africa 3656 16th November 2023 – 28th September 2026 12 35 0 128 394
8 Canada 3160 16th November 2023 – 2nd October 2026 63 21 3 108 270
9 Germany 3101 16th November 2023 – 25th September 2026 116 48 0 103 224
10 Austria 2544 16th November 2023 – 30th September 2026 70 26 0 105 224

Recent Contributions

Date Time User Type Name Attribute
60821 23rd November 2025 20:59:07 UTC remus climb Jason's Roof eight_a_nu_url
Before
None
After
https://www.8a.nu/crags/bouldering/united-kingdom/crookrise/sectors/unknown-sector/routes/jasons-roof
60822 23rd November 2025 18:22:55 UTC remus climber Laura Pineau youtube_url
Before
None
After
https://www.youtube.com/@LauraPineau-climber
60823 23rd November 2025 18:19:28 UTC remus media https://www.instagram.com/reel/DRaIPU7CNL8/ missing_right_to_reproduce
Before
None
After
false
60824 23rd November 2025 18:19:28 UTC remus media https://www.instagram.com/reel/DRaIPU7CNL8/ embed_code
Before
None
After
<blockquote class="instagram-media" data-instgrm-permalink="https://www.instagram.com/p/DRaIPU7CNL8/" data-instgrm-version="13" style=" background:#FFF; border:0; border-radius:3px; box-shadow:0 0 1px 0 rgba(0,0,0,0.5),0 1px 10px 0 rgba(0,0,0,0.15); margin: 1px; max-width:540px; min-width:326px; padding:0; width:99.375%; width:-webkit-calc(100% - 2px); width:calc(100% - 2px);"><div style="padding:16px;"> <a href="https://www.instagram.com/p/DRaIPU7CNL8/" style=" background:#FFFFFF; line-height:0; padding:0 0; text-align:center; text-decoration:none; width:100%;" target="_blank"> <div style=" display: flex; flex-direction: row; align-items: center;"> <div style="background-color: #F4F4F4; border-radius: 50%; flex-grow: 0; height: 40px; margin-right: 14px; width: 40px;"></div> <div style="display: flex; flex-direction: column; flex-grow: 1; justify-content: center;"> <div style=" background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; margin-bottom: 6px; width: 100px;"></div> <div style=" background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; width: 60px;"></div></div></div><div style="padding: 19% 0;"></div> <div style="display:block; height:50px; margin:0 auto 12px; width:50px;"><svg width="50px" height="50px" viewBox="0 0 60 60" version="1.1" xmlns="https://www.w3.org/2000/svg" xmlns:xlink="https://www.w3.org/1999/xlink"><g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"><g transform="translate(-511.000000, -20.000000)" fill="#000000"><g><path d="M556.869,30.41 C554.814,30.41 553.148,32.076 553.148,34.131 C553.148,36.186 554.814,37.852 556.869,37.852 C558.924,37.852 560.59,36.186 560.59,34.131 C560.59,32.076 558.924,30.41 556.869,30.41 M541,60.657 C535.114,60.657 530.342,55.887 530.342,50 C530.342,44.114 535.114,39.342 541,39.342 C546.887,39.342 551.658,44.114 551.658,50 C551.658,55.887 546.887,60.657 541,60.657 M541,33.886 C532.1,33.886 524.886,41.1 524.886,50 C524.886,58.899 532.1,66.113 541,66.113 C549.9,66.113 557.115,58.899 557.115,50 C557.115,41.1 549.9,33.886 541,33.886 M565.378,62.101 C565.244,65.022 564.756,66.606 564.346,67.663 C563.803,69.06 563.154,70.057 562.106,71.106 C561.058,72.155 560.06,72.803 558.662,73.347 C557.607,73.757 556.021,74.244 553.102,74.378 C549.944,74.521 548.997,74.552 541,74.552 C533.003,74.552 532.056,74.521 528.898,74.378 C525.979,74.244 524.393,73.757 523.338,73.347 C521.94,72.803 520.942,72.155 519.894,71.106 C518.846,70.057 518.197,69.06 517.654,67.663 C517.244,66.606 516.755,65.022 516.623,62.101 C516.479,58.943 516.448,57.996 516.448,50 C516.448,42.003 516.479,41.056 516.623,37.899 C516.755,34.978 517.244,33.391 517.654,32.338 C518.197,30.938 518.846,29.942 519.894,28.894 C520.942,27.846 521.94,27.196 523.338,26.654 C524.393,26.244 525.979,25.756 528.898,25.623 C532.057,25.479 533.004,25.448 541,25.448 C548.997,25.448 549.943,25.479 553.102,25.623 C556.021,25.756 557.607,26.244 558.662,26.654 C560.06,27.196 561.058,27.846 562.106,28.894 C563.154,29.942 563.803,30.938 564.346,32.338 C564.756,33.391 565.244,34.978 565.378,37.899 C565.522,41.056 565.552,42.003 565.552,50 C565.552,57.996 565.522,58.943 565.378,62.101 M570.82,37.631 C570.674,34.438 570.167,32.258 569.425,30.349 C568.659,28.377 567.633,26.702 565.965,25.035 C564.297,23.368 562.623,22.342 560.652,21.575 C558.743,20.834 556.562,20.326 553.369,20.18 C550.169,20.033 549.148,20 541,20 C532.853,20 531.831,20.033 528.631,20.18 C525.438,20.326 523.257,20.834 521.349,21.575 C519.376,22.342 517.703,23.368 516.035,25.035 C514.368,26.702 513.342,28.377 512.574,30.349 C511.834,32.258 511.326,34.438 511.181,37.631 C511.035,40.831 511,41.851 511,50 C511,58.147 511.035,59.17 511.181,62.369 C511.326,65.562 511.834,67.743 512.574,69.651 C513.342,71.625 514.368,73.296 516.035,74.965 C517.703,76.634 519.376,77.658 521.349,78.425 C523.257,79.167 525.438,79.673 528.631,79.82 C531.831,79.965 532.853,80.001 541,80.001 C549.148,80.001 550.169,79.965 553.369,79.82 C556.562,79.673 558.743,79.167 560.652,78.425 C562.623,77.658 564.297,76.634 565.965,74.965 C567.633,73.296 568.659,71.625 569.425,69.651 C570.167,67.743 570.674,65.562 570.82,62.369 C570.966,59.17 571,58.147 571,50 C571,41.851 570.966,40.831 570.82,37.631"></path></g></g></g></svg></div><div style="padding-top: 8px;"> <div style=" color:#3897f0; font-family:Arial,sans-serif; font-size:14px; font-style:normal; font-weight:550; line-height:18px;"> View this post on Instagram</div></div><div style="padding: 12.5% 0;"></div> <div style="display: flex; flex-direction: row; margin-bottom: 14px; align-items: center;"><div> <div style="background-color: #F4F4F4; border-radius: 50%; height: 12.5px; width: 12.5px; transform: translateX(0px) translateY(7px);"></div> <div style="background-color: #F4F4F4; height: 12.5px; transform: rotate(-45deg) translateX(3px) translateY(1px); width: 12.5px; flex-grow: 0; margin-right: 14px; margin-left: 2px;"></div> <div style="background-color: #F4F4F4; border-radius: 50%; height: 12.5px; width: 12.5px; transform: translateX(9px) translateY(-18px);"></div></div><div style="margin-left: 8px;"> <div style=" background-color: #F4F4F4; border-radius: 50%; flex-grow: 0; height: 20px; width: 20px;"></div> <div style=" width: 0; height: 0; border-top: 2px solid transparent; border-left: 6px solid #f4f4f4; border-bottom: 2px solid transparent; transform: translateX(16px) translateY(-4px) rotate(30deg)"></div></div><div style="margin-left: auto;"> <div style=" width: 0px; border-top: 8px solid #F4F4F4; border-right: 8px solid transparent; transform: translateY(16px);"></div> <div style=" background-color: #F4F4F4; flex-grow: 0; height: 12px; width: 16px; transform: translateY(-4px);"></div> <div style=" width: 0; height: 0; border-top: 8px solid #F4F4F4; border-left: 8px solid transparent; transform: translateY(-4px) translateX(8px);"></div></div></div> <div style="display: flex; flex-direction: column; flex-grow: 1; justify-content: center; margin-bottom: 24px;"> <div style=" background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; margin-bottom: 6px; width: 224px;"></div> <div style=" background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; width: 144px;"></div></div></a><p style=" color:#c9c8cd; font-family:Arial,sans-serif; font-size:14px; line-height:17px; margin-bottom:0; margin-top:8px; overflow:hidden; padding:8px 0 7px; text-align:center; text-overflow:ellipsis; white-space:nowrap;"></p></div></blockquote> <script async src="//www.instagram.com/embed.js"></script>
60825 23rd November 2025 18:19:28 UTC remus media https://www.instagram.com/reel/DRaIPU7CNL8/ url
Before
None
After
https://www.instagram.com/reel/DRaIPU7CNL8/
60826 23rd November 2025 18:19:28 UTC remus media https://www.youtube.com/watch?v=mvsqn80ld2A&t=130 missing_right_to_reproduce
Before
None
After
false
60827 23rd November 2025 18:19:28 UTC remus media https://www.youtube.com/watch?v=mvsqn80ld2A&t=130 embed_code
Before
None
After
<div class="video-wrapper"><iframe class="embed-responsive-item" src="https://www.youtube.com/embed/mvsqn80ld2A?start=130" allowfullscreen></iframe></div>
60828 23rd November 2025 18:19:28 UTC remus media https://www.youtube.com/watch?v=mvsqn80ld2A&t=130 url
Before
None
After
https://www.youtube.com/watch?v=mvsqn80ld2A&t=130
60829 23rd November 2025 18:19:27 UTC remus ascent Charles Albert's ascent of Karma notes
Before
### References [1] [https://youtu.be/mvsqn80ld2A?t=130](https://youtu.be/mvsqn80ld2A?t=130)
After
### References [1] [https://youtu.be/mvsqn80ld2A?t=130](https://youtu.be/mvsqn80ld2A?t=130) [2] A repeat ascent in November 2025 [https://www.instagram.com/reel/DRaIPU7CNL8/](https://www.instagram.com/reel/DRaIPU7CNL8/)
Diff
--- before

+++ after

@@ -1,3 +1,5 @@

### References

-[1] [https://youtu.be/mvsqn80ld2A?t=130](https://youtu.be/mvsqn80ld2A?t=130)
+[1] [https://youtu.be/mvsqn80ld2A?t=130](https://youtu.be/mvsqn80ld2A?t=130)
+
+[2] A repeat ascent in November 2025 [https://www.instagram.com/reel/DRaIPU7CNL8/](https://www.instagram.com/reel/DRaIPU7CNL8/)
60830 23rd November 2025 18:19:27 UTC remus ascent Charles Albert's ascent of Karma notes_pretty
Before
<h3>References</h3> <p>[1] <a href="https://youtu.be/mvsqn80ld2A?t=130">https://youtu.be/mvsqn80ld2A?t=130</a></p>
After
<h3>References</h3> <p>[1] <a href="https://youtu.be/mvsqn80ld2A?t=130">https://youtu.be/mvsqn80ld2A?t=130</a></p> <p>[2] A repeat ascent in November 2025 <a href="https://www.instagram.com/reel/DRaIPU7CNL8/">https://www.instagram.com/reel/DRaIPU7CNL8/</a></p>
60831 23rd November 2025 17:18:06 UTC remus - - list_definition
Before
SELECT '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,count(distinct cl.climb_id) as "Climbs" ,count(*) as "Ascents" ,count(distinct a.climber_id) as "Climbers" ,min(a.ascent_dt_start) as "From" ,min(a.ascent_dt_end) as "To" from crags cr left join climbs cl on cl.ukc_crag_id = cr.crag_id and cl.deleted_on is null left join ascents a on cl.climb_id = a.climb_id and a.deleted_on is null where polygon '( ( -1.5861331919878694, 53.11388763847273 ), ( -1.5884864065373279, 53.150388536552725 ), ( -1.6134682849034903, 53.19428148744248 ), ( -1.5290562849635876, 53.205287852514545 ), ( -1.544556126329212, 53.2574197946206 ), ( -1.568103642468401, 53.33520226783273 ), ( -1.5811607532045002, 53.36004770727865 ), ( -1.5823631657549129, 53.37557360923094 ), ( -1.5926347008194455, 53.40275291044679 ), ( -1.5731640580617352, 53.41980890670479 ), ( -1.566472026733436, 53.45553506127038 ), ( -1.648600498648392, 53.48260815378066 ), ( -1.6825168668990216, 53.50499616619538 ), ( -1.7176731398746767, 53.527391814741975 ), ( -1.7658250946988687, 53.52424613643342 ), ( -1.794415282251208, 53.54826977046318 ), ( -1.8321428437529335, 53.55128150706864 ), ( -1.854256210278237, 53.58545588417286 ), ( -1.9232024136464076, 53.60004812535166 ), ( -1.9843108749483633, 53.57914243383806 ), ( -1.9921209851945605, 53.54825203218482 ), ( -1.9829347359474525, 53.53114480992156 ), ( -2.007723038504338, 53.52737551362961 ), ( -2.018317110721398, 53.48187208963273 ), ( -2.0027205418765845, 53.4756940822123 ), ( -1.9753236184979812, 53.47642383172433 ), ( -1.9349349305687724, 53.45778787378154 ), ( -1.9349699289638806, 53.43844502210524 ), ( -2.0000216486942577, 53.412057982557684 ), ( -1.990916065236462, 53.386451522585475 ), ( -1.9531536160959035, 53.37169771088824 ), ( -1.955781961620005, 53.346067241758675 ), ( -1.9193176872986157, 53.33830091168511 ), ( -1.881561953841441, 53.3103446345398 ), ( -1.8646559155703812, 53.31111846156497 ), ( -1.841243541461779, 53.259010938770956 ), ( -1.8698625978743735, 53.255114178481136 ), ( -1.876361429589366, 53.23878774885006 ), ( -1.8321423388633207, 53.20144807708806 ), ( -1.876352467681187, 53.2139104224145 ), ( -1.9374165985959735, 53.226435911128675 ), ( -1.946575879724179, 53.26526404381502 ), ( -1.9062820897642325, 53.300233371944444 ), ( -1.967496821558143, 53.31186427447784 ), ( -2.0246799912437723, 53.327428208461754 ), ( -2.084720451305145, 53.321183515586455 ), ( -2.0807172871478485, 53.27686180982437 ), ( -2.0806440543234146, 53.253540319063944 ), ( -2.0609971091890884, 53.21624438941427 ), ( -2.1015157975250816, 53.19508567112797 ), ( -2.0977903330356185, 53.17077949621631 ), ( -2.067802311389471, 53.17236990288609 ), ( -2.0442941761009763, 53.141996210356524 ), ( -1.9935072419703204, 53.14437223459166 ), ( -1.9583103430681206, 53.133557260858026 ), ( -1.9557395482235052, 53.091323167931705 ), ( -1.8763746765213796, 53.0467424333695 ), ( -1.7917717818306755, 53.033280324660836 ), ( -1.7214552869256465, 53.034800004819516 ), ( -1.6812277166012848, 53.09994858320934 ), ( -1.5861331919878694, 53.11388763847273 ))' @> point (cr.longitude, cr.latitude) and cr.group_crag_id is null group by cr.crag_id ,cr.crag_name ,cr.longitude order by count(distinct cl.climb_id)
After
SELECT '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,count(distinct cl.climb_id) as "Climbs" ,count(*) as "Ascents" ,count(distinct a.climber_id) as "Climbers" ,min(a.ascent_dt_start) as "From" ,min(a.ascent_dt_end) as "To" from crags cr left join climbs cl on cl.ukc_crag_id = cr.crag_id and cl.deleted_on is null left join ascents a on cl.climb_id = a.climb_id and a.deleted_on is null where polygon '( ( -1.5861331919878694, 53.11388763847273 ), ( -1.5884864065373279, 53.150388536552725 ), ( -1.6134682849034903, 53.19428148744248 ), ( -1.5290562849635876, 53.205287852514545 ), ( -1.544556126329212, 53.2574197946206 ), ( -1.568103642468401, 53.33520226783273 ), ( -1.5811607532045002, 53.36004770727865 ), ( -1.5823631657549129, 53.37557360923094 ), ( -1.5926347008194455, 53.40275291044679 ), ( -1.5731640580617352, 53.41980890670479 ), ( -1.566472026733436, 53.45553506127038 ), ( -1.648600498648392, 53.48260815378066 ), ( -1.6825168668990216, 53.50499616619538 ), ( -1.7176731398746767, 53.527391814741975 ), ( -1.7658250946988687, 53.52424613643342 ), ( -1.794415282251208, 53.54826977046318 ), ( -1.8321428437529335, 53.55128150706864 ), ( -1.854256210278237, 53.58545588417286 ), ( -1.9232024136464076, 53.60004812535166 ), ( -1.9843108749483633, 53.57914243383806 ), ( -1.9921209851945605, 53.54825203218482 ), ( -1.9829347359474525, 53.53114480992156 ), ( -2.007723038504338, 53.52737551362961 ), ( -2.018317110721398, 53.48187208963273 ), ( -2.0027205418765845, 53.4756940822123 ), ( -1.9753236184979812, 53.47642383172433 ), ( -1.9349349305687724, 53.45778787378154 ), ( -1.9349699289638806, 53.43844502210524 ), ( -2.0000216486942577, 53.412057982557684 ), ( -1.990916065236462, 53.386451522585475 ), ( -1.9531536160959035, 53.37169771088824 ), ( -1.955781961620005, 53.346067241758675 ), ( -1.9193176872986157, 53.33830091168511 ), ( -1.881561953841441, 53.3103446345398 ), ( -1.8646559155703812, 53.31111846156497 ), ( -1.841243541461779, 53.259010938770956 ), ( -1.8698625978743735, 53.255114178481136 ), ( -1.876361429589366, 53.23878774885006 ), ( -1.8321423388633207, 53.20144807708806 ), ( -1.876352467681187, 53.2139104224145 ), ( -1.9374165985959735, 53.226435911128675 ), ( -1.946575879724179, 53.26526404381502 ), ( -1.9062820897642325, 53.300233371944444 ), ( -1.967496821558143, 53.31186427447784 ), ( -2.0246799912437723, 53.327428208461754 ), ( -2.084720451305145, 53.321183515586455 ), ( -2.0807172871478485, 53.27686180982437 ), ( -2.0806440543234146, 53.253540319063944 ), ( -2.0609971091890884, 53.21624438941427 ), ( -2.1015157975250816, 53.19508567112797 ), ( -2.0977903330356185, 53.17077949621631 ), ( -2.067802311389471, 53.17236990288609 ), ( -2.0442941761009763, 53.141996210356524 ), ( -1.9935072419703204, 53.14437223459166 ), ( -1.9583103430681206, 53.133557260858026 ), ( -1.9557395482235052, 53.091323167931705 ), ( -1.8763746765213796, 53.0467424333695 ), ( -1.7917717818306755, 53.033280324660836 ), ( -1.7214552869256465, 53.034800004819516 ), ( -1.6812277166012848, 53.09994858320934 ), ( -1.5861331919878694, 53.11388763847273 ))' @> point (cr.longitude, cr.latitude) and cr.group_crag_id is null group by cr.crag_id ,cr.crag_name ,cr.longitude order by count(distinct cl.climb_id) desc
Diff
--- before

+++ after

@@ -269,4 +269,4 @@

,cr.longitude

order by
- count(distinct cl.climb_id)
+ count(distinct cl.climb_id) desc
60832 23rd November 2025 17:17:54 UTC remus - - list_definition
Before
SELECT '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,count(distinct cl.climb_id) as "Climbs" ,count(*) as "Ascents" ,count(distinct a.climber_id) as "Climbers" ,min(a.ascent_dt_start) as "From" ,min(a.ascent_dt_end) as "To" from crags cr left join climbs cl on cl.ukc_crag_id = cr.crag_id and cl.deleted_on is null left join ascents a on cl.climb_id = a.climb_id and a.deleted_on is null where polygon '( ( -1.5861331919878694, 53.11388763847273 ), ( -1.5884864065373279, 53.150388536552725 ), ( -1.6134682849034903, 53.19428148744248 ), ( -1.5290562849635876, 53.205287852514545 ), ( -1.544556126329212, 53.2574197946206 ), ( -1.568103642468401, 53.33520226783273 ), ( -1.5811607532045002, 53.36004770727865 ), ( -1.5823631657549129, 53.37557360923094 ), ( -1.5926347008194455, 53.40275291044679 ), ( -1.5731640580617352, 53.41980890670479 ), ( -1.566472026733436, 53.45553506127038 ), ( -1.648600498648392, 53.48260815378066 ), ( -1.6825168668990216, 53.50499616619538 ), ( -1.7176731398746767, 53.527391814741975 ), ( -1.7658250946988687, 53.52424613643342 ), ( -1.794415282251208, 53.54826977046318 ), ( -1.8321428437529335, 53.55128150706864 ), ( -1.854256210278237, 53.58545588417286 ), ( -1.9232024136464076, 53.60004812535166 ), ( -1.9843108749483633, 53.57914243383806 ), ( -1.9921209851945605, 53.54825203218482 ), ( -1.9829347359474525, 53.53114480992156 ), ( -2.007723038504338, 53.52737551362961 ), ( -2.018317110721398, 53.48187208963273 ), ( -2.0027205418765845, 53.4756940822123 ), ( -1.9753236184979812, 53.47642383172433 ), ( -1.9349349305687724, 53.45778787378154 ), ( -1.9349699289638806, 53.43844502210524 ), ( -2.0000216486942577, 53.412057982557684 ), ( -1.990916065236462, 53.386451522585475 ), ( -1.9531536160959035, 53.37169771088824 ), ( -1.955781961620005, 53.346067241758675 ), ( -1.9193176872986157, 53.33830091168511 ), ( -1.881561953841441, 53.3103446345398 ), ( -1.8646559155703812, 53.31111846156497 ), ( -1.841243541461779, 53.259010938770956 ), ( -1.8698625978743735, 53.255114178481136 ), ( -1.876361429589366, 53.23878774885006 ), ( -1.8321423388633207, 53.20144807708806 ), ( -1.876352467681187, 53.2139104224145 ), ( -1.9374165985959735, 53.226435911128675 ), ( -1.946575879724179, 53.26526404381502 ), ( -1.9062820897642325, 53.300233371944444 ), ( -1.967496821558143, 53.31186427447784 ), ( -2.0246799912437723, 53.327428208461754 ), ( -2.084720451305145, 53.321183515586455 ), ( -2.0807172871478485, 53.27686180982437 ), ( -2.0806440543234146, 53.253540319063944 ), ( -2.0609971091890884, 53.21624438941427 ), ( -2.1015157975250816, 53.19508567112797 ), ( -2.0977903330356185, 53.17077949621631 ), ( -2.067802311389471, 53.17236990288609 ), ( -2.0442941761009763, 53.141996210356524 ), ( -1.9935072419703204, 53.14437223459166 ), ( -1.9583103430681206, 53.133557260858026 ), ( -1.9557395482235052, 53.091323167931705 ), ( -1.8763746765213796, 53.0467424333695 ), ( -1.7917717818306755, 53.033280324660836 ), ( -1.7214552869256465, 53.034800004819516 ), ( -1.6812277166012848, 53.09994858320934 ), ( -1.5861331919878694, 53.11388763847273 ))' @> point (cr.longitude, cr.latitude) and cr.group_crag_id is null group by cr.crag_id ,cr.crag_name ,cr.longitude order by cr.longitude
After
SELECT '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,count(distinct cl.climb_id) as "Climbs" ,count(*) as "Ascents" ,count(distinct a.climber_id) as "Climbers" ,min(a.ascent_dt_start) as "From" ,min(a.ascent_dt_end) as "To" from crags cr left join climbs cl on cl.ukc_crag_id = cr.crag_id and cl.deleted_on is null left join ascents a on cl.climb_id = a.climb_id and a.deleted_on is null where polygon '( ( -1.5861331919878694, 53.11388763847273 ), ( -1.5884864065373279, 53.150388536552725 ), ( -1.6134682849034903, 53.19428148744248 ), ( -1.5290562849635876, 53.205287852514545 ), ( -1.544556126329212, 53.2574197946206 ), ( -1.568103642468401, 53.33520226783273 ), ( -1.5811607532045002, 53.36004770727865 ), ( -1.5823631657549129, 53.37557360923094 ), ( -1.5926347008194455, 53.40275291044679 ), ( -1.5731640580617352, 53.41980890670479 ), ( -1.566472026733436, 53.45553506127038 ), ( -1.648600498648392, 53.48260815378066 ), ( -1.6825168668990216, 53.50499616619538 ), ( -1.7176731398746767, 53.527391814741975 ), ( -1.7658250946988687, 53.52424613643342 ), ( -1.794415282251208, 53.54826977046318 ), ( -1.8321428437529335, 53.55128150706864 ), ( -1.854256210278237, 53.58545588417286 ), ( -1.9232024136464076, 53.60004812535166 ), ( -1.9843108749483633, 53.57914243383806 ), ( -1.9921209851945605, 53.54825203218482 ), ( -1.9829347359474525, 53.53114480992156 ), ( -2.007723038504338, 53.52737551362961 ), ( -2.018317110721398, 53.48187208963273 ), ( -2.0027205418765845, 53.4756940822123 ), ( -1.9753236184979812, 53.47642383172433 ), ( -1.9349349305687724, 53.45778787378154 ), ( -1.9349699289638806, 53.43844502210524 ), ( -2.0000216486942577, 53.412057982557684 ), ( -1.990916065236462, 53.386451522585475 ), ( -1.9531536160959035, 53.37169771088824 ), ( -1.955781961620005, 53.346067241758675 ), ( -1.9193176872986157, 53.33830091168511 ), ( -1.881561953841441, 53.3103446345398 ), ( -1.8646559155703812, 53.31111846156497 ), ( -1.841243541461779, 53.259010938770956 ), ( -1.8698625978743735, 53.255114178481136 ), ( -1.876361429589366, 53.23878774885006 ), ( -1.8321423388633207, 53.20144807708806 ), ( -1.876352467681187, 53.2139104224145 ), ( -1.9374165985959735, 53.226435911128675 ), ( -1.946575879724179, 53.26526404381502 ), ( -1.9062820897642325, 53.300233371944444 ), ( -1.967496821558143, 53.31186427447784 ), ( -2.0246799912437723, 53.327428208461754 ), ( -2.084720451305145, 53.321183515586455 ), ( -2.0807172871478485, 53.27686180982437 ), ( -2.0806440543234146, 53.253540319063944 ), ( -2.0609971091890884, 53.21624438941427 ), ( -2.1015157975250816, 53.19508567112797 ), ( -2.0977903330356185, 53.17077949621631 ), ( -2.067802311389471, 53.17236990288609 ), ( -2.0442941761009763, 53.141996210356524 ), ( -1.9935072419703204, 53.14437223459166 ), ( -1.9583103430681206, 53.133557260858026 ), ( -1.9557395482235052, 53.091323167931705 ), ( -1.8763746765213796, 53.0467424333695 ), ( -1.7917717818306755, 53.033280324660836 ), ( -1.7214552869256465, 53.034800004819516 ), ( -1.6812277166012848, 53.09994858320934 ), ( -1.5861331919878694, 53.11388763847273 ))' @> point (cr.longitude, cr.latitude) and cr.group_crag_id is null group by cr.crag_id ,cr.crag_name ,cr.longitude order by count(distinct cl.climb_id)
Diff
--- before

+++ after

@@ -269,4 +269,4 @@

,cr.longitude

order by
- cr.longitude
+ count(distinct cl.climb_id)
60833 23rd November 2025 17:17:05 UTC remus - - list_definition
Before
SELECT '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,count(distinct cl.climb_id) as "Climbs" ,count(*) as "Ascents" ,count(distinct a.climber_id) as "Climbers" ,min(a.ascent_dt_start) as "From" ,min(a.ascent_dt_end) as "To" from crags cr left join climbs cl on cl.ukc_crag_id = cr.crag_id and cl.deleted_on is null left join ascents a on cl.climb_id = a.climb_id and a.deleted_on is null where polygon '( ( -1.5861331919878694, 53.11388763847273 ), ( -1.5884864065373279, 53.150388536552725 ), ( -1.6134682849034903, 53.19428148744248 ), ( -1.5290562849635876, 53.205287852514545 ), ( -1.544556126329212, 53.2574197946206 ), ( -1.568103642468401, 53.33520226783273 ), ( -1.5811607532045002, 53.36004770727865 ), ( -1.5823631657549129, 53.37557360923094 ), ( -1.5926347008194455, 53.40275291044679 ), ( -1.5731640580617352, 53.41980890670479 ), ( -1.566472026733436, 53.45553506127038 ), ( -1.648600498648392, 53.48260815378066 ), ( -1.6825168668990216, 53.50499616619538 ), ( -1.7176731398746767, 53.527391814741975 ), ( -1.7658250946988687, 53.52424613643342 ), ( -1.794415282251208, 53.54826977046318 ), ( -1.8321428437529335, 53.55128150706864 ), ( -1.854256210278237, 53.58545588417286 ), ( -1.9232024136464076, 53.60004812535166 ), ( -1.9843108749483633, 53.57914243383806 ), ( -1.9921209851945605, 53.54825203218482 ), ( -1.9829347359474525, 53.53114480992156 ), ( -2.007723038504338, 53.52737551362961 ), ( -2.018317110721398, 53.48187208963273 ), ( -2.0027205418765845, 53.4756940822123 ), ( -1.9753236184979812, 53.47642383172433 ), ( -1.9349349305687724, 53.45778787378154 ), ( -1.9349699289638806, 53.43844502210524 ), ( -2.0000216486942577, 53.412057982557684 ), ( -1.990916065236462, 53.386451522585475 ), ( -1.9531536160959035, 53.37169771088824 ), ( -1.955781961620005, 53.346067241758675 ), ( -1.9193176872986157, 53.33830091168511 ), ( -1.881561953841441, 53.3103446345398 ), ( -1.8646559155703812, 53.31111846156497 ), ( -1.841243541461779, 53.259010938770956 ), ( -1.8698625978743735, 53.255114178481136 ), ( -1.876361429589366, 53.23878774885006 ), ( -1.8321423388633207, 53.20144807708806 ), ( -1.876352467681187, 53.2139104224145 ), ( -1.9374165985959735, 53.226435911128675 ), ( -1.946575879724179, 53.26526404381502 ), ( -1.9062820897642325, 53.300233371944444 ), ( -1.967496821558143, 53.31186427447784 ), ( -2.0246799912437723, 53.327428208461754 ), ( -2.084720451305145, 53.321183515586455 ), ( -2.0807172871478485, 53.27686180982437 ), ( -2.0806440543234146, 53.253540319063944 ), ( -2.0609971091890884, 53.21624438941427 ), ( -2.1015157975250816, 53.19508567112797 ), ( -2.0977903330356185, 53.17077949621631 ), ( -2.067802311389471, 53.17236990288609 ), ( -2.0442941761009763, 53.141996210356524 ), ( -1.9935072419703204, 53.14437223459166 ), ( -1.9583103430681206, 53.133557260858026 ), ( -1.9557395482235052, 53.091323167931705 ), ( -1.8763746765213796, 53.0467424333695 ), ( -1.7917717818306755, 53.033280324660836 ), ( -1.7214552869256465, 53.034800004819516 ), ( -1.6812277166012848, 53.09994858320934 ), ( -1.5861331919878694, 53.11388763847273 ))' @> point (cr.longitude, cr.latitude) group by cr.crag_id ,cr.crag_name ,cr.longitude order by cr.longitude
After
SELECT '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,count(distinct cl.climb_id) as "Climbs" ,count(*) as "Ascents" ,count(distinct a.climber_id) as "Climbers" ,min(a.ascent_dt_start) as "From" ,min(a.ascent_dt_end) as "To" from crags cr left join climbs cl on cl.ukc_crag_id = cr.crag_id and cl.deleted_on is null left join ascents a on cl.climb_id = a.climb_id and a.deleted_on is null where polygon '( ( -1.5861331919878694, 53.11388763847273 ), ( -1.5884864065373279, 53.150388536552725 ), ( -1.6134682849034903, 53.19428148744248 ), ( -1.5290562849635876, 53.205287852514545 ), ( -1.544556126329212, 53.2574197946206 ), ( -1.568103642468401, 53.33520226783273 ), ( -1.5811607532045002, 53.36004770727865 ), ( -1.5823631657549129, 53.37557360923094 ), ( -1.5926347008194455, 53.40275291044679 ), ( -1.5731640580617352, 53.41980890670479 ), ( -1.566472026733436, 53.45553506127038 ), ( -1.648600498648392, 53.48260815378066 ), ( -1.6825168668990216, 53.50499616619538 ), ( -1.7176731398746767, 53.527391814741975 ), ( -1.7658250946988687, 53.52424613643342 ), ( -1.794415282251208, 53.54826977046318 ), ( -1.8321428437529335, 53.55128150706864 ), ( -1.854256210278237, 53.58545588417286 ), ( -1.9232024136464076, 53.60004812535166 ), ( -1.9843108749483633, 53.57914243383806 ), ( -1.9921209851945605, 53.54825203218482 ), ( -1.9829347359474525, 53.53114480992156 ), ( -2.007723038504338, 53.52737551362961 ), ( -2.018317110721398, 53.48187208963273 ), ( -2.0027205418765845, 53.4756940822123 ), ( -1.9753236184979812, 53.47642383172433 ), ( -1.9349349305687724, 53.45778787378154 ), ( -1.9349699289638806, 53.43844502210524 ), ( -2.0000216486942577, 53.412057982557684 ), ( -1.990916065236462, 53.386451522585475 ), ( -1.9531536160959035, 53.37169771088824 ), ( -1.955781961620005, 53.346067241758675 ), ( -1.9193176872986157, 53.33830091168511 ), ( -1.881561953841441, 53.3103446345398 ), ( -1.8646559155703812, 53.31111846156497 ), ( -1.841243541461779, 53.259010938770956 ), ( -1.8698625978743735, 53.255114178481136 ), ( -1.876361429589366, 53.23878774885006 ), ( -1.8321423388633207, 53.20144807708806 ), ( -1.876352467681187, 53.2139104224145 ), ( -1.9374165985959735, 53.226435911128675 ), ( -1.946575879724179, 53.26526404381502 ), ( -1.9062820897642325, 53.300233371944444 ), ( -1.967496821558143, 53.31186427447784 ), ( -2.0246799912437723, 53.327428208461754 ), ( -2.084720451305145, 53.321183515586455 ), ( -2.0807172871478485, 53.27686180982437 ), ( -2.0806440543234146, 53.253540319063944 ), ( -2.0609971091890884, 53.21624438941427 ), ( -2.1015157975250816, 53.19508567112797 ), ( -2.0977903330356185, 53.17077949621631 ), ( -2.067802311389471, 53.17236990288609 ), ( -2.0442941761009763, 53.141996210356524 ), ( -1.9935072419703204, 53.14437223459166 ), ( -1.9583103430681206, 53.133557260858026 ), ( -1.9557395482235052, 53.091323167931705 ), ( -1.8763746765213796, 53.0467424333695 ), ( -1.7917717818306755, 53.033280324660836 ), ( -1.7214552869256465, 53.034800004819516 ), ( -1.6812277166012848, 53.09994858320934 ), ( -1.5861331919878694, 53.11388763847273 ))' @> point (cr.longitude, cr.latitude) and cr.group_crag_id is null group by cr.crag_id ,cr.crag_name ,cr.longitude order by cr.longitude
Diff
--- before

+++ after

@@ -261,6 +261,7 @@

-1.5861331919878694,
53.11388763847273
))' @> point (cr.longitude, cr.latitude)
+ and cr.group_crag_id is null

group by
cr.crag_id
60834 23rd November 2025 17:15:15 UTC remus - - list_description_pretty
Before
None
After
<p>This is a list of crags recorded on climbing-history.org which fall within the geographic boundary of the <a href="https://en.wikipedia.org/wiki/Peak_District">Peak District</a> in the UK.</p> <p>Owing to it's location between the metropolitan centers of Manchester and Sheffield it is one of the more accessible areas in the UK and the crags have a consequently long history and popularity.</p>
60835 23rd November 2025 17:15:15 UTC remus - - list_definition
Before
None
After
SELECT '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag" ,count(distinct cl.climb_id) as "Climbs" ,count(*) as "Ascents" ,count(distinct a.climber_id) as "Climbers" ,min(a.ascent_dt_start) as "From" ,min(a.ascent_dt_end) as "To" from crags cr left join climbs cl on cl.ukc_crag_id = cr.crag_id and cl.deleted_on is null left join ascents a on cl.climb_id = a.climb_id and a.deleted_on is null where polygon '( ( -1.5861331919878694, 53.11388763847273 ), ( -1.5884864065373279, 53.150388536552725 ), ( -1.6134682849034903, 53.19428148744248 ), ( -1.5290562849635876, 53.205287852514545 ), ( -1.544556126329212, 53.2574197946206 ), ( -1.568103642468401, 53.33520226783273 ), ( -1.5811607532045002, 53.36004770727865 ), ( -1.5823631657549129, 53.37557360923094 ), ( -1.5926347008194455, 53.40275291044679 ), ( -1.5731640580617352, 53.41980890670479 ), ( -1.566472026733436, 53.45553506127038 ), ( -1.648600498648392, 53.48260815378066 ), ( -1.6825168668990216, 53.50499616619538 ), ( -1.7176731398746767, 53.527391814741975 ), ( -1.7658250946988687, 53.52424613643342 ), ( -1.794415282251208, 53.54826977046318 ), ( -1.8321428437529335, 53.55128150706864 ), ( -1.854256210278237, 53.58545588417286 ), ( -1.9232024136464076, 53.60004812535166 ), ( -1.9843108749483633, 53.57914243383806 ), ( -1.9921209851945605, 53.54825203218482 ), ( -1.9829347359474525, 53.53114480992156 ), ( -2.007723038504338, 53.52737551362961 ), ( -2.018317110721398, 53.48187208963273 ), ( -2.0027205418765845, 53.4756940822123 ), ( -1.9753236184979812, 53.47642383172433 ), ( -1.9349349305687724, 53.45778787378154 ), ( -1.9349699289638806, 53.43844502210524 ), ( -2.0000216486942577, 53.412057982557684 ), ( -1.990916065236462, 53.386451522585475 ), ( -1.9531536160959035, 53.37169771088824 ), ( -1.955781961620005, 53.346067241758675 ), ( -1.9193176872986157, 53.33830091168511 ), ( -1.881561953841441, 53.3103446345398 ), ( -1.8646559155703812, 53.31111846156497 ), ( -1.841243541461779, 53.259010938770956 ), ( -1.8698625978743735, 53.255114178481136 ), ( -1.876361429589366, 53.23878774885006 ), ( -1.8321423388633207, 53.20144807708806 ), ( -1.876352467681187, 53.2139104224145 ), ( -1.9374165985959735, 53.226435911128675 ), ( -1.946575879724179, 53.26526404381502 ), ( -1.9062820897642325, 53.300233371944444 ), ( -1.967496821558143, 53.31186427447784 ), ( -2.0246799912437723, 53.327428208461754 ), ( -2.084720451305145, 53.321183515586455 ), ( -2.0807172871478485, 53.27686180982437 ), ( -2.0806440543234146, 53.253540319063944 ), ( -2.0609971091890884, 53.21624438941427 ), ( -2.1015157975250816, 53.19508567112797 ), ( -2.0977903330356185, 53.17077949621631 ), ( -2.067802311389471, 53.17236990288609 ), ( -2.0442941761009763, 53.141996210356524 ), ( -1.9935072419703204, 53.14437223459166 ), ( -1.9583103430681206, 53.133557260858026 ), ( -1.9557395482235052, 53.091323167931705 ), ( -1.8763746765213796, 53.0467424333695 ), ( -1.7917717818306755, 53.033280324660836 ), ( -1.7214552869256465, 53.034800004819516 ), ( -1.6812277166012848, 53.09994858320934 ), ( -1.5861331919878694, 53.11388763847273 ))' @> point (cr.longitude, cr.latitude) group by cr.crag_id ,cr.crag_name ,cr.longitude order by cr.longitude
Diff
--- before

+++ after

@@ -1 +1,271 @@

-
+SELECT
+ '<a href="/crag/' || cr.crag_id::varchar || '">' || cr.crag_name || '</a>' as "Crag"
+ ,count(distinct cl.climb_id) as "Climbs"
+ ,count(*) as "Ascents"
+ ,count(distinct a.climber_id) as "Climbers"
+ ,min(a.ascent_dt_start) as "From"
+ ,min(a.ascent_dt_end) as "To"
+
+from
+ crags cr
+ left join climbs cl
+ on cl.ukc_crag_id = cr.crag_id
+ and cl.deleted_on is null
+ left join ascents a
+ on cl.climb_id = a.climb_id
+ and a.deleted_on is null
+
+where
+ polygon '(
+ (
+ -1.5861331919878694,
+ 53.11388763847273
+ ),
+ (
+ -1.5884864065373279,
+ 53.150388536552725
+ ),
+ (
+ -1.6134682849034903,
+ 53.19428148744248
+ ),
+ (
+ -1.5290562849635876,
+ 53.205287852514545
+ ),
+ (
+ -1.544556126329212,
+ 53.2574197946206
+ ),
+ (
+ -1.568103642468401,
+ 53.33520226783273
+ ),
+ (
+ -1.5811607532045002,
+ 53.36004770727865
+ ),
+ (
+ -1.5823631657549129,
+ 53.37557360923094
+ ),
+ (
+ -1.5926347008194455,
+ 53.40275291044679
+ ),
+ (
+ -1.5731640580617352,
+ 53.41980890670479
+ ),
+ (
+ -1.566472026733436,
+ 53.45553506127038
+ ),
+ (
+ -1.648600498648392,
+ 53.48260815378066
+ ),
+ (
+ -1.6825168668990216,
+ 53.50499616619538
+ ),
+ (
+ -1.7176731398746767,
+ 53.527391814741975
+ ),
+ (
+ -1.7658250946988687,
+ 53.52424613643342
+ ),
+ (
+ -1.794415282251208,
+ 53.54826977046318
+ ),
+ (
+ -1.8321428437529335,
+ 53.55128150706864
+ ),
+ (
+ -1.854256210278237,
+ 53.58545588417286
+ ),
+ (
+ -1.9232024136464076,
+ 53.60004812535166
+ ),
+ (
+ -1.9843108749483633,
+ 53.57914243383806
+ ),
+ (
+ -1.9921209851945605,
+ 53.54825203218482
+ ),
+ (
+ -1.9829347359474525,
+ 53.53114480992156
+ ),
+ (
+ -2.007723038504338,
+ 53.52737551362961
+ ),
+ (
+ -2.018317110721398,
+ 53.48187208963273
+ ),
+ (
+ -2.0027205418765845,
+ 53.4756940822123
+ ),
+ (
+ -1.9753236184979812,
+ 53.47642383172433
+ ),
+ (
+ -1.9349349305687724,
+ 53.45778787378154
+ ),
+ (
+ -1.9349699289638806,
+ 53.43844502210524
+ ),
+ (
+ -2.0000216486942577,
+ 53.412057982557684
+ ),
+ (
+ -1.990916065236462,
+ 53.386451522585475
+ ),
+ (
+ -1.9531536160959035,
+ 53.37169771088824
+ ),
+ (
+ -1.955781961620005,
+ 53.346067241758675
+ ),
+ (
+ -1.9193176872986157,
+ 53.33830091168511
+ ),
+ (
+ -1.881561953841441,
+ 53.3103446345398
+ ),
+ (
+ -1.8646559155703812,
+ 53.31111846156497
+ ),
+ (
+ -1.841243541461779,
+ 53.259010938770956
+ ),
+ (
+ -1.8698625978743735,
+ 53.255114178481136
+ ),
+ (
+ -1.876361429589366,
+ 53.23878774885006
+ ),
+ (
+ -1.8321423388633207,
+ 53.20144807708806
+ ),
+ (
+ -1.876352467681187,
+ 53.2139104224145
+ ),
+ (
+ -1.9374165985959735,
+ 53.226435911128675
+ ),
+ (
+ -1.946575879724179,
+ 53.26526404381502
+ ),
+ (
+ -1.9062820897642325,
+ 53.300233371944444
+ ),
+ (
+ -1.967496821558143,
+ 53.31186427447784
+ ),
+ (
+ -2.0246799912437723,
+ 53.327428208461754
+ ),
+ (
+ -2.084720451305145,
+ 53.321183515586455
+ ),
+ (
+ -2.0807172871478485,
+ 53.27686180982437
+ ),
+ (
+ -2.0806440543234146,
+ 53.253540319063944
+ ),
+ (
+ -2.0609971091890884,
+ 53.21624438941427
+ ),
+ (
+ -2.1015157975250816,
+ 53.19508567112797
+ ),
+ (
+ -2.0977903330356185,
+ 53.17077949621631
+ ),
+ (
+ -2.067802311389471,
+ 53.17236990288609
+ ),
+ (
+ -2.0442941761009763,
+ 53.141996210356524
+ ),
+ (
+ -1.9935072419703204,
+ 53.14437223459166
+ ),
+ (
+ -1.9583103430681206,
+ 53.133557260858026
+ ),
+ (
+ -1.9557395482235052,
+ 53.091323167931705
+ ),
+ (
+ -1.8763746765213796,
+ 53.0467424333695
+ ),
+ (
+ -1.7917717818306755,
+ 53.033280324660836
+ ),
+ (
+ -1.7214552869256465,
+ 53.034800004819516
+ ),
+ (
+ -1.6812277166012848,
+ 53.09994858320934
+ ),
+ (
+ -1.5861331919878694,
+ 53.11388763847273
+ ))' @> point (cr.longitude, cr.latitude)
+
+group by
+ cr.crag_id
+ ,cr.crag_name
+ ,cr.longitude
+
+order by
+ cr.longitude
60836 23rd November 2025 17:15:15 UTC remus - - list_name
Before
None
After
Peak District
60837 23rd November 2025 17:15:15 UTC remus - - list_description
Before
None
After
This is a list of crags recorded on climbing-history.org which fall within the geographic boundary of the [Peak District](https://en.wikipedia.org/wiki/Peak_District) in the UK. Owing to it's location between the metropolitan centers of Manchester and Sheffield it is one of the more accessible areas in the UK and the crags have a consequently long history and popularity.
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+This is a list of crags recorded on climbing-history.org which fall within the geographic boundary of the [Peak District](https://en.wikipedia.org/wiki/Peak_District) in the UK.
+
+Owing to it's location between the metropolitan centers of Manchester and Sheffield it is one of the more accessible areas in the UK and the crags have a consequently long history and popularity.
60838 23rd November 2025 17:15:15 UTC remus - - list_type_name
Before
None
After
Misc.
60839 23rd November 2025 17:15:15 UTC remus - - list_type_id
Before
None
After
5
60840 23rd November 2025 12:29:21 UTC remus media https://www.youtube.com/watch?v=7HebOKdBDGk&t=314 embed_code
Before
None
After
<div class="video-wrapper"><iframe class="embed-responsive-item" src="https://www.youtube.com/embed/7HebOKdBDGk?start=314" allowfullscreen></iframe></div>

< Page 3042 >