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
1901 15th May 2026 21:40:44 UTC ben_sandi crag Crumbly crag_name
Before
None
After
Crumbly
1902 15th May 2026 20:04:31 UTC ben_sandi climb Trieste Low crag_location_breadcrumb_pretty
Before
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Colorado" class="text-muted">Colorado</a> / <a href="/crags/location/United States/Colorado/Jefferson County" class="text-muted">Jefferson County</a>
After
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Nevada" class="text-muted">Nevada</a> / <a href="/crags/location/United States/Nevada/Clark County" class="text-muted">Clark County</a>
1903 15th May 2026 20:04:31 UTC ben_sandi climb Trieste Low crag_location_breadcrumb
Before
United States / Colorado / Jefferson County
After
United States / Nevada / Clark County
1904 15th May 2026 20:04:31 UTC ben_sandi climb Trieste Low crag_name
Before
Clear Creek Canyon
After
First Creek Canyon
1905 15th May 2026 20:04:31 UTC ben_sandi climb Trieste Low crag_id
Before
5170
After
4228
1906 15th May 2026 20:03:38 UTC ben_sandi list Dodgy Crags list_description_pretty
Before
<p>Finds climbs linked by meta that should usually mean they are at the same crag, including <code>Free Version of</code>, <code>Aid Version of</code>, <code>Trad Version of</code>, <code>Sport Version of</code>, <code>DWS Version of</code>, <code>Low Start To</code>, <code>Sit Start To</code>, <code>Stand Start To</code>, <code>Extension Of</code>, and <code>Variation Of</code>, but where the climbs are assigned to different crags or one of them has no crag set.</p>
After
<p>Finds climbs linked by meta that should usually mean they are at the same crag, but where the climbs are assigned to different crags or one of them has no crag set. </p> <p>Meta used: <code>Free Version of</code>, <code>Aid Version of</code>, <code>Trad Version of</code>, <code>Sport Version of</code>, <code>DWS Version of</code>, <code>Low Start To</code>, <code>Sit Start To</code>, <code>Stand Start To</code>, <code>Extension Of</code>, and <code>Variation Of</code>,</p>
1907 15th May 2026 20:03:38 UTC ben_sandi list Dodgy Crags list_description
Before
Finds climbs linked by meta that should usually mean they are at the same crag, including `Free Version of`, `Aid Version of`, `Trad Version of`, `Sport Version of`, `DWS Version of`, `Low Start To`, `Sit Start To`, `Stand Start To`, `Extension Of`, and `Variation Of`, but where the climbs are assigned to different crags or one of them has no crag set.
After
Finds climbs linked by meta that should usually mean they are at the same crag, but where the climbs are assigned to different crags or one of them has no crag set. Meta used: `Free Version of`, `Aid Version of`, `Trad Version of`, `Sport Version of`, `DWS Version of`, `Low Start To`, `Sit Start To`, `Stand Start To`, `Extension Of`, and `Variation Of`,
Diff
--- before

+++ after

@@ -1 +1,3 @@

-Finds climbs linked by meta that should usually mean they are at the same crag, including `Free Version of`, `Aid Version of`, `Trad Version of`, `Sport Version of`, `DWS Version of`, `Low Start To`, `Sit Start To`, `Stand Start To`, `Extension Of`, and `Variation Of`, but where the climbs are assigned to different crags or one of them has no crag set.
+Finds climbs linked by meta that should usually mean they are at the same crag, but where the climbs are assigned to different crags or one of them has no crag set.
+
+Meta used: `Free Version of`, `Aid Version of`, `Trad Version of`, `Sport Version of`, `DWS Version of`, `Low Start To`, `Sit Start To`, `Stand Start To`, `Extension Of`, and `Variation Of`,
1908 15th May 2026 20:02:58 UTC ben_sandi climb Trieste Low crag_location_breadcrumb_pretty
Before
None
After
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Colorado" class="text-muted">Colorado</a> / <a href="/crags/location/United States/Colorado/Jefferson County" class="text-muted">Jefferson County</a>
1909 15th May 2026 20:02:58 UTC ben_sandi climb Trieste Low crag_location_breadcrumb
Before
None
After
United States / Colorado / Jefferson County
1910 15th May 2026 20:02:58 UTC ben_sandi climb Trieste Low crag_name
Before
None
After
Clear Creek Canyon
1911 15th May 2026 20:02:58 UTC ben_sandi climb Trieste Low crag_id
Before
None
After
5170
1912 15th May 2026 20:02:34 UTC ben_sandi climb Trieste Low crag_location_breadcrumb_pretty
Before
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Nevada" class="text-muted">Nevada</a> / <a href="/crags/location/United States/Nevada/Clark County" class="text-muted">Clark County</a>
After
None
1913 15th May 2026 20:02:34 UTC ben_sandi climb Trieste Low crag_location_breadcrumb
Before
United States / Nevada / Clark County
After
None
1914 15th May 2026 20:02:34 UTC ben_sandi climb Trieste Low crag_name
Before
First Creek Canyon
After
None
1915 15th May 2026 20:02:34 UTC ben_sandi climb Trieste Low crag_id
Before
4228
After
None
1916 15th May 2026 20:02:14 UTC ben_sandi list Dodgy Crags list_definition
Before
with related_climbs as ( select distinct cm.climb_id as source_climb_id ,cmk.key as relation_type ,cm.value::integer as related_climb_id from climb_meta cm inner join climb_meta_keys cmk on cm.climb_meta_key_id = cmk.climb_meta_key_id where cmk.key in ( 'Free Version of' ,'Aid Version of' ,'Trad Version of' ,'Sport Version of' ,'DWS Version of' ,'Low Start To' ,'Sit Start To' ,'Stand Start To' ,'Extension Of' ,'Variation Of' ) ) select rc.relation_type ,c1.climb_id as climb_id ,c1.climb_name as climb_name ,c1.crag_id as climb_crag_id ,c2.climb_id as related_climb_id ,c2.climb_name as related_climb_name ,c2.crag_id as related_climb_crag_id from related_climbs rc inner join climbs c1 on rc.source_climb_id = c1.climb_id inner join climbs c2 on rc.related_climb_id = c2.climb_id where c1.crag_id is distinct from c2.crag_id order by rc.relation_type ,c1.climb_name ,c2.climb_name
After
with related_climbs as ( select distinct cm.climb_id as source_climb_id ,cmk.key as relation_type ,cm.value::integer as related_climb_id from climb_meta cm inner join climb_meta_keys cmk on cm.climb_meta_key_id = cmk.climb_meta_key_id where cmk.key in ( 'Free Version of' ,'Aid Version of' ,'Trad Version of' ,'Sport Version of' ,'DWS Version of' ,'Low Start To' ,'Sit Start To' ,'Stand Start To' ,'Extension Of' ,'Variation Of' ) ) select rc.relation_type ,'<a href="/climb/' || c1.climb_id::varchar || '">' || c1.climb_name || '</a>' as climb ,coalesce(cr1_group.crag_name, cr1.crag_name) as climb_crag ,'<a href="/climb/' || c2.climb_id::varchar || '">' || c2.climb_name || '</a>' as related_climb ,coalesce(cr2_group.crag_name, cr2.crag_name) as related_climb_crag from related_climbs rc inner join climbs c1 on rc.source_climb_id = c1.climb_id inner join climbs c2 on rc.related_climb_id = c2.climb_id left join crags cr1 on c1.crag_id = cr1.crag_id left join crags cr1_group on cr1.group_crag_id = cr1_group.crag_id left join crags cr2 on c2.crag_id = cr2.crag_id left join crags cr2_group on cr2.group_crag_id = cr2_group.crag_id where c1.deleted_on is null and c2.deleted_on is null and coalesce(cr1.group_crag_id, c1.crag_id) is distinct from coalesce(cr2.group_crag_id, c2.crag_id) order by rc.relation_type ,c1.climb_name ,c2.climb_name;
Diff
--- before

+++ after

@@ -26,12 +26,18 @@


select
rc.relation_type
- ,c1.climb_id as climb_id
- ,c1.climb_name as climb_name
- ,c1.crag_id as climb_crag_id
- ,c2.climb_id as related_climb_id
- ,c2.climb_name as related_climb_name
- ,c2.crag_id as related_climb_crag_id
+ ,'<a href="/climb/'
+ || c1.climb_id::varchar
+ || '">'
+ || c1.climb_name
+ || '</a>' as climb
+ ,coalesce(cr1_group.crag_name, cr1.crag_name) as climb_crag
+ ,'<a href="/climb/'
+ || c2.climb_id::varchar
+ || '">'
+ || c2.climb_name
+ || '</a>' as related_climb
+ ,coalesce(cr2_group.crag_name, cr2.crag_name) as related_climb_crag

from
related_climbs rc
@@ -39,11 +45,22 @@

on rc.source_climb_id = c1.climb_id
inner join climbs c2
on rc.related_climb_id = c2.climb_id
+ left join crags cr1
+ on c1.crag_id = cr1.crag_id
+ left join crags cr1_group
+ on cr1.group_crag_id = cr1_group.crag_id
+ left join crags cr2
+ on c2.crag_id = cr2.crag_id
+ left join crags cr2_group
+ on cr2.group_crag_id = cr2_group.crag_id

where
- c1.crag_id is distinct from c2.crag_id
+ c1.deleted_on is null
+ and c2.deleted_on is null
+ and coalesce(cr1.group_crag_id, c1.crag_id)
+ is distinct from coalesce(cr2.group_crag_id, c2.crag_id)

order by
rc.relation_type
,c1.climb_name
- ,c2.climb_name
+ ,c2.climb_name;
1917 15th May 2026 19:54:36 UTC ben_sandi climb Trieste Low crag_location_breadcrumb_pretty
Before
None
After
<a href="/crags/location/United States" class="text-muted">United States</a> / <a href="/crags/location/United States/Nevada" class="text-muted">Nevada</a> / <a href="/crags/location/United States/Nevada/Clark County" class="text-muted">Clark County</a>
1918 15th May 2026 19:54:36 UTC ben_sandi climb Trieste Low crag_location_breadcrumb
Before
None
After
United States / Nevada / Clark County
1919 15th May 2026 19:54:36 UTC ben_sandi climb Trieste Low crag_name
Before
None
After
First Creek Canyon
1920 15th May 2026 19:54:36 UTC ben_sandi climb Trieste Low crag_id
Before
None
After
4228

< Page 96 >