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
2781 2nd May 2026 20:54:16 UTC ben_sandi climb Momento Payaso crag_id
Before
None
After
23778
2782 2nd May 2026 20:53:22 UTC ben_sandi climb Amadeus crag_name
Before
None
After
Sabart
2783 2nd May 2026 20:53:22 UTC ben_sandi climb Amadeus crag_id
Before
None
After
10224
2784 2nd May 2026 20:52:30 UTC ben_sandi climb Free Your Mind crag_location_breadcrumb_pretty
Before
None
After
<a href="/crags/location/Germany" class="text-muted">Germany</a> / <a href="/crags/location/Germany/Niedersachsen" class="text-muted">Niedersachsen</a>
2785 2nd May 2026 20:52:30 UTC ben_sandi climb Free Your Mind crag_location_breadcrumb
Before
None
After
Germany / Niedersachsen
2786 2nd May 2026 20:52:30 UTC ben_sandi climb Free Your Mind crag_name
Before
None
After
Göttinger Wald
2787 2nd May 2026 20:52:30 UTC ben_sandi climb Free Your Mind crag_id
Before
None
After
33895
2788 2nd May 2026 20:51:09 UTC ben_sandi list More Climbs that have existing crags? list_type_name
Before
None
After
Admin
2789 2nd May 2026 20:51:09 UTC ben_sandi list More Climbs that have existing crags? list_type_id
Before
None
After
6
2790 2nd May 2026 20:51:09 UTC ben_sandi list More Climbs that have existing crags? list_description_pretty
Before
None
After
<p>temporary</p>
2791 2nd May 2026 20:51:09 UTC ben_sandi list More Climbs that have existing crags? list_definition
Before
None
After
select '<a href="' || substring(c.eight_a_nu_url from '^(.+)/sectors/') || '">' || initcap(replace(split_part(c.eight_a_nu_url, '/', 7), '-', ' ')) || '</a>' as "8a.nu Crag" ,count(*) as "Climbs Missing" ,string_agg( '<a href="' || c.url || '">' || c.climb_name || '</a>', ', ' order by c.climb_name ) as "Climbs" ,string_agg( distinct '<a href="' || cr.url || '">' || cr.crag_name || '</a>', ', ' order by '<a href="' || cr.url || '">' || cr.crag_name || '</a>' ) filter (where cr.crag_id is not null) as "Matching Site Crag" from climbs c left join crags cr on cr.deleted_on is null and cr.group_crag_id is null and cr.eight_a_nu_url = substring(c.eight_a_nu_url from '^(.+)/sectors/') where c.deleted_on is null and c.crag_id is null and c.eight_a_nu_url is not null and split_part(c.eight_a_nu_url, '/', 7) not like 'unknown-crag%' group by substring(c.eight_a_nu_url from '^(.+)/sectors/') ,split_part(c.eight_a_nu_url, '/', 7) having count(cr.crag_id) > 0 order by count(*) desc ,"8a.nu Crag"
Diff
--- before

+++ after

@@ -1 +1,40 @@

-
+select
+ '<a href="' ||
+ substring(c.eight_a_nu_url from '^(.+)/sectors/') ||
+ '">' ||
+ initcap(replace(split_part(c.eight_a_nu_url, '/', 7), '-', ' ')) ||
+ '</a>' as "8a.nu Crag"
+ ,count(*) as "Climbs Missing"
+ ,string_agg(
+ '<a href="' || c.url || '">' || c.climb_name || '</a>',
+ ', ' order by c.climb_name
+ ) as "Climbs"
+ ,string_agg(
+ distinct '<a href="' || cr.url || '">' || cr.crag_name || '</a>',
+ ', ' order by '<a href="' || cr.url || '">' || cr.crag_name || '</a>'
+ ) filter (where cr.crag_id is not null) as "Matching Site Crag"
+
+from
+ climbs c
+
+ left join crags cr
+ on cr.deleted_on is null
+ and cr.group_crag_id is null
+ and cr.eight_a_nu_url = substring(c.eight_a_nu_url from '^(.+)/sectors/')
+
+where
+ c.deleted_on is null
+ and c.crag_id is null
+ and c.eight_a_nu_url is not null
+ and split_part(c.eight_a_nu_url, '/', 7) not like 'unknown-crag%'
+
+group by
+ substring(c.eight_a_nu_url from '^(.+)/sectors/')
+ ,split_part(c.eight_a_nu_url, '/', 7)
+
+having
+ count(cr.crag_id) > 0
+
+order by
+ count(*) desc
+ ,"8a.nu Crag"
2792 2nd May 2026 20:51:09 UTC ben_sandi list More Climbs that have existing crags? list_description
Before
None
After
temporary
Diff
--- before

+++ after

@@ -1 +1 @@

-
+temporary
2793 2nd May 2026 20:51:09 UTC ben_sandi list More Climbs that have existing crags? list_name
Before
None
After
More Climbs that have existing crags?
2794 2nd May 2026 19:10:59 UTC ben_sandi ascent Yannick Flohé's ascent of Brain Rot suggested_grade_id
Before
None
After
40
2795 2nd May 2026 19:10:43 UTC ben_sandi media https://www.instagram.com/reel/DX2J8vqupT8/ missing_right_to_reproduce
Before
None
After
false
2796 2nd May 2026 19:10:43 UTC ben_sandi media https://www.instagram.com/reel/DX2J8vqupT8/ url
Before
None
After
https://www.instagram.com/reel/DX2J8vqupT8/
2797 2nd May 2026 19:10:42 UTC ben_sandi ascent Yannick Flohé's ascent of Brain Rot ascent_dt_end
Before
None
After
2026-05-02
2798 2nd May 2026 19:10:42 UTC ben_sandi ascent Yannick Flohé's ascent of Brain Rot ascent_type_id
Before
None
After
2
2799 2nd May 2026 19:10:42 UTC ben_sandi ascent Yannick Flohé's ascent of Brain Rot notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/reel/DX2J8vqupT8/" rel="noopener noreferrer">https://www.instagram.com/reel/DX2J8vqupT8/</a></p>
2800 2nd May 2026 19:10:42 UTC ben_sandi ascent Yannick Flohé's ascent of Brain Rot notes
Before
None
After
### References [1] [https://www.instagram.com/reel/DX2J8vqupT8/](https://www.instagram.com/reel/DX2J8vqupT8/)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://www.instagram.com/reel/DX2J8vqupT8/](https://www.instagram.com/reel/DX2J8vqupT8/)

< Page 140 >