ben_sandi

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

62

7 Days

76

4 Weeks

113

All Time

6752

Current Streak

1

Longest Streak

13

Contributions Map

Contributions by Country

Country Contributions Between Climbers Crags Summits Climbs Ascents
1 USA 1526 20th November 2025 – 4th November 2026 48 20 0 88 98
2 Australia 767 27th September 2025 – 29th June 2026 6 38 0 61 33
3 United Kingdom 625 19th November 2025 – 4th November 2026 34 14 0 24 49
4 Switzerland 308 24th January 2026 – 4th November 2026 6 3 0 14 38
5 France 300 6th January 2026 – 4th November 2026 15 3 0 12 34
6 Austria 210 12th November 2025 – 22nd June 2026 5 2 0 8 22
7 Italy 163 18th November 2025 – 2nd November 2026 9 3 0 12 12
8 Pakistan 118 11th April 2026 – 26th April 2026 0 0 0 1 7
9 Spain 105 20th February 2026 – 16th May 2026 5 0 0 10 11
10 Germany 103 3rd February 2026 – 26th June 2026 7 0 0 7 10

Recent Contributions

Date Time User Type Name Attribute
1481 16th May 2026 21:39:52 UTC ben_sandi media https://www.youtube.com/watch?v=N4RzWMgdAgU missing_right_to_reproduce
Before
None
After
false
1482 16th May 2026 21:39:52 UTC ben_sandi media https://www.youtube.com/watch?v=N4RzWMgdAgU url
Before
None
After
https://www.youtube.com/watch?v=N4RzWMgdAgU
1483 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule ascent_dt_end
Before
None
After
2018-05-19
1484 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule ascent_dt_start
Before
None
After
2018-05-19
1485 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule ascent_type_id
Before
None
After
1
1486 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://publications.americanalpineclub.org/articles/13201215104/Foula-Nebbifjeld-Ultima-Thule" rel="noopener noreferrer">https://publications.americanalpineclub.org/articles/13201215104/Foula-Nebbifjeld-Ultima-Thule</a></p> <p>[2] <a href="https://www.youtube.com/watch?v=N4RzWMgdAgU" rel="noopener noreferrer">https://www.youtube.com/watch?v=N4RzWMgdAgU</a></p> <p>[3] <a href="https://gripped.com/news/watch-first-ascent-up-wild-shetland-islands-wall/" rel="noopener noreferrer">https://gripped.com/news/watch-first-ascent-up-wild-shetland-islands-wall/</a></p> <p>[4] <a href="https://davemacleod.blogspot.com/2018/05/ultima-thule.html" rel="noopener noreferrer">https://davemacleod.blogspot.com/2018/05/ultima-thule.html</a></p>
1487 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule notes
Before
None
After
### References [1] [https://publications.americanalpineclub.org/articles/13201215104/Foula-Nebbifjeld-Ultima-Thule](https://publications.americanalpineclub.org/articles/13201215104/Foula-Nebbifjeld-Ultima-Thule) [2] [https://www.youtube.com/watch?v=N4RzWMgdAgU](https://www.youtube.com/watch?v=N4RzWMgdAgU) [3] [https://gripped.com/news/watch-first-ascent-up-wild-shetland-islands-wall/](https://gripped.com/news/watch-first-ascent-up-wild-shetland-islands-wall/) [4] [https://davemacleod.blogspot.com/2018/05/ultima-thule.html](https://davemacleod.blogspot.com/2018/05/ultima-thule.html)
Diff
--- before

+++ after

@@ -1 +1,9 @@

-
+### References
+
+[1] [https://publications.americanalpineclub.org/articles/13201215104/Foula-Nebbifjeld-Ultima-Thule](https://publications.americanalpineclub.org/articles/13201215104/Foula-Nebbifjeld-Ultima-Thule)
+
+[2] [https://www.youtube.com/watch?v=N4RzWMgdAgU](https://www.youtube.com/watch?v=N4RzWMgdAgU)
+
+[3] [https://gripped.com/news/watch-first-ascent-up-wild-shetland-islands-wall/](https://gripped.com/news/watch-first-ascent-up-wild-shetland-islands-wall/)
+
+[4] [https://davemacleod.blogspot.com/2018/05/ultima-thule.html](https://davemacleod.blogspot.com/2018/05/ultima-thule.html)
1488 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule ascent_style_id
Before
None
After
1
1489 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule climb_id
Before
None
After
7705
1490 16th May 2026 21:39:52 UTC ben_sandi ascent Dave MacLeod's ascent of Ultima Thule climber_id
Before
None
After
146
1491 16th May 2026 21:36:57 UTC ben_sandi crag Nebbifield notes_pretty
Before
None
After
<p>A huge 290m sea cliff on Foula, one of Britain’s most remote inhabited islands, in Shetland.</p> <h3>References</h3> <p>[1] <a href="https://www.powell-pressburger.org/Reviews/37_Edge/FoulaHigh.html" rel="noopener noreferrer">https://www.powell-pressburger.org/Reviews/37_Edge/FoulaHigh.html</a></p>
1492 16th May 2026 21:36:57 UTC ben_sandi crag Nebbifield notes
Before
None
After
A huge 290m sea cliff on Foula, one of Britain’s most remote inhabited islands, in Shetland. ### References [1] [https://www.powell-pressburger.org/Reviews/37_Edge/FoulaHigh.html](https://www.powell-pressburger.org/Reviews/37_Edge/FoulaHigh.html)
Diff
--- before

+++ after

@@ -1 +1,5 @@

-
+A huge 290m sea cliff on Foula, one of Britain’s most remote inhabited islands, in Shetland.
+
+### References
+
+[1] [https://www.powell-pressburger.org/Reviews/37_Edge/FoulaHigh.html](https://www.powell-pressburger.org/Reviews/37_Edge/FoulaHigh.html)
1493 16th May 2026 21:32:50 UTC ben_sandi crag Nebbifield longitude
Before
None
After
-2.110353
1494 16th May 2026 21:32:50 UTC ben_sandi crag Nebbifield latitude
Before
None
After
60.14372
1495 16th May 2026 21:30:58 UTC ben_sandi climb Ultima Thule crag_id
Before
None
After
34389
1496 16th May 2026 21:30:58 UTC ben_sandi climb Ultima Thule ukc_url
Before
None
After
https://www.ukclimbing.com/logbook/crags/nebbifield-11782/ultima_thule-488539
1497 16th May 2026 21:30:58 UTC ben_sandi climb Ultima Thule climb_type
Before
None
After
3
1498 16th May 2026 21:30:58 UTC ben_sandi climb Ultima Thule grade_id
Before
None
After
60
1499 16th May 2026 21:30:58 UTC ben_sandi climb Ultima Thule climb_name
Before
None
After
Ultima Thule
1500 16th May 2026 14:28:26 UTC ben_sandi list Crags Without Coordinates OR Country Meta list_definition
Before
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,coalesce(cc.cnt_climbs, 0) as Climbs ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" ,case when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>' else null end as "theCrag" ,case when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>' else null end as "27crags" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id left join ( select cm.crag_id ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url ,max( case when cm.value ilike '%27crags.com%' or cm.value ilike '%thetopo.com%' then cm.value end ) as crags27_url from crag_meta cm where cm.crag_meta_key_id = 1 group by cm.crag_id ) w on w.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null and not exists ( select 1 from crag_meta cm_country where cm_country.crag_id = c.crag_id and cm_country.crag_meta_key_id = 6 ) order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
After
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,coalesce(cc.cnt_climbs, 0) as Climbs ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null and not exists ( select 1 from crag_meta cm_country where cm_country.crag_id = c.crag_id and cm_country.crag_meta_key_id = 6 ) order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
Diff
--- before

+++ after

@@ -9,14 +9,6 @@

when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
- ,case
- when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>'
- else null
- end as "theCrag"
- ,case
- when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
- else null
- end as "27crags"

from
crags c
@@ -35,28 +27,6 @@

cl.crag_id
) cc
on cc.crag_id = c.crag_id
- left join (
- select
- cm.crag_id
- ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
- ,max(
- case
- when cm.value ilike '%27crags.com%'
- or cm.value ilike '%thetopo.com%'
- then cm.value
- end
- ) as crags27_url
-
- from
- crag_meta cm
-
- where
- cm.crag_meta_key_id = 1
-
- group by
- cm.crag_id
- ) w
- on w.crag_id = c.crag_id

where
c.deleted_on is null
@@ -77,4 +47,5 @@


order by
coalesce(cc.cnt_climbs, 0) desc
- ,c.crag_name
+ ,c.crag_name
+

< Page 75 >