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
3101 1st May 2026 17:10:15 UTC ben_sandi climb Cupcake crag_id
Before
None
After
5374
3102 1st May 2026 17:09:51 UTC ben_sandi climb Chicken Nuggets crag_location_breadcrumb_pretty
Before
None
After
<a href="/crags/location/Canada" class="text-muted">Canada</a> / <a href="/crags/location/Canada/British Columbia" class="text-muted">British Columbia</a> / <a href="/crags/location/Canada/British Columbia/Squamish-Lillooet" class="text-muted">Squamish-Lillooet</a>
3103 1st May 2026 17:09:51 UTC ben_sandi climb Chicken Nuggets crag_location_breadcrumb
Before
None
After
Canada / British Columbia / Squamish-Lillooet
3104 1st May 2026 17:09:51 UTC ben_sandi climb Chicken Nuggets crag_name_prefix
Before
at
After
at the
3105 1st May 2026 17:09:51 UTC ben_sandi climb Chicken Nuggets crag_name
Before
None
After
North Wall Boulders
3106 1st May 2026 17:09:51 UTC ben_sandi climb Chicken Nuggets crag_id
Before
None
After
7644
3107 1st May 2026 17:09:51 UTC ben_sandi climb Chicken Nuggets notes_pretty
Before
<p>Links the crux of <a href="/climb/3480/the-reckoning">The Reckoning</a> into <a href="/climb/6481/big-chicken">Big Chicken</a>.</p>
After
<p>Links the crux of <a href="/climb/3480/the-reckoning" rel="noopener noreferrer">The Reckoning</a> into <a href="/climb/6481/big-chicken" rel="noopener noreferrer">Big Chicken</a>.</p>
3108 1st May 2026 17:09:16 UTC ben_sandi list Temporary List list_type_name
Before
None
After
Admin
3109 1st May 2026 17:09:16 UTC ben_sandi list Temporary List list_type_id
Before
None
After
6
3110 1st May 2026 17:09:16 UTC ben_sandi list Temporary List list_description_pretty
Before
None
After
<p>temp</p>
3111 1st May 2026 17:09:16 UTC ben_sandi list Temporary List list_definition
Before
None
After
with qualifying_meta as ( select cm.climb_id, cm.climb_meta_key_id, linked_climb.url as linked_url, linked_climb.climb_name as linked_climb_name, cr.crag_name from climb_meta cm inner join climbs linked_climb on linked_climb.climb_id = cm.value::int inner join crags cr on cr.crag_id = linked_climb.crag_id where cm.climb_meta_key_id in ( 1, -- Sit Start To 5, -- Low Start To 2, -- Stand Start To 3, -- Extension Of 23, -- Variation Of 4, -- See Also 31, -- Trad Version of 32, -- Sport Version of 33, -- Free Version of 34, -- Aid Version of 36 -- DWS Version of ) and linked_climb.deleted_on is null ) select '<a href="' || c.url || '">' || c.climb_name || '</a>' as Climb ,g.grade || ' ' || ct.climb_type as Grade ,( select string_agg( cmk.key || ' (' || '<a href="' || qm.linked_url || '">' || qm.linked_climb_name || '</a>' || ' - ' || qm.crag_name || ')', '<br>' order by cmk.order_on, qm.linked_climb_name ) from qualifying_meta qm inner join climb_meta_keys cmk on cmk.climb_meta_key_id = qm.climb_meta_key_id where qm.climb_id = c.climb_id ) as Meta from climbs c inner join grades g on c.grade_id = g.grade_id inner join climb_types ct on c.climb_type_id = ct.climb_type_id where c.deleted_on is null and c.crag_id is null and exists ( select 1 from qualifying_meta qm where qm.climb_id = c.climb_id ) order by c.climb_name;
Diff
--- before

+++ after

@@ -1 +1,61 @@

-
+with qualifying_meta as (
+ select
+ cm.climb_id,
+ cm.climb_meta_key_id,
+ linked_climb.url as linked_url,
+ linked_climb.climb_name as linked_climb_name,
+ cr.crag_name
+ from
+ climb_meta cm
+ inner join climbs linked_climb
+ on linked_climb.climb_id = cm.value::int
+ inner join crags cr
+ on cr.crag_id = linked_climb.crag_id
+ where
+ cm.climb_meta_key_id in (
+ 1, -- Sit Start To
+ 5, -- Low Start To
+ 2, -- Stand Start To
+ 3, -- Extension Of
+ 23, -- Variation Of
+ 4, -- See Also
+ 31, -- Trad Version of
+ 32, -- Sport Version of
+ 33, -- Free Version of
+ 34, -- Aid Version of
+ 36 -- DWS Version of
+ )
+ and linked_climb.deleted_on is null
+)
+select
+ '<a href="' || c.url || '">' || c.climb_name || '</a>' as Climb
+ ,g.grade || ' ' || ct.climb_type as Grade
+ ,(
+ select string_agg(
+ cmk.key || ' (' ||
+ '<a href="' || qm.linked_url || '">' || qm.linked_climb_name || '</a>' ||
+ ' - ' || qm.crag_name || ')',
+ '<br>'
+ order by cmk.order_on, qm.linked_climb_name
+ )
+ from qualifying_meta qm
+ inner join climb_meta_keys cmk
+ on cmk.climb_meta_key_id = qm.climb_meta_key_id
+ where qm.climb_id = c.climb_id
+ ) as Meta
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ inner join climb_types ct
+ on c.climb_type_id = ct.climb_type_id
+where
+ c.deleted_on is null
+ and c.crag_id is null
+ and exists (
+ select 1
+ from qualifying_meta qm
+ where qm.climb_id = c.climb_id
+ )
+order by
+ c.climb_name;
3112 1st May 2026 17:09:16 UTC ben_sandi list Temporary List list_description
Before
None
After
temp
Diff
--- before

+++ after

@@ -1 +1 @@

-
+temp
3113 1st May 2026 17:09:16 UTC ben_sandi list Temporary List list_name
Before
None
After
Temporary List
3114 1st May 2026 16:53:56 UTC ben_sandi climb Anaconda crag_location_breadcrumb_pretty
Before
None
After
<a href="/crags/location/Italy" class="text-muted">Italy</a> / <a href="/crags/location/Italy/Piedmont" class="text-muted">Piedmont</a> / <a href="/crags/location/Italy/Piedmont/Province of Cuneo" class="text-muted">Province of Cuneo</a>
3115 1st May 2026 16:53:56 UTC ben_sandi climb Anaconda crag_location_breadcrumb
Before
None
After
Italy / Piedmont / Province of Cuneo
3116 1st May 2026 16:53:56 UTC ben_sandi climb Anaconda crag_name
Before
None
After
Andonno
3117 1st May 2026 16:53:56 UTC ben_sandi climb Anaconda crag_id
Before
None
After
15949
3118 1st May 2026 12:48:47 UTC ben_sandi climb Chocolate Jesus Sit 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/Boulder County" class="text-muted">Boulder County</a>
3119 1st May 2026 12:48:47 UTC ben_sandi climb Chocolate Jesus Sit crag_location_breadcrumb
Before
None
After
United States / Colorado / Boulder County
3120 1st May 2026 12:48:47 UTC ben_sandi climb Chocolate Jesus Sit crag_name
Before
None
After
Wild Basin

< Page 156 >