baz9

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

0

7 Days

0

4 Weeks

162

All Time

6423

Current Streak

0

Longest Streak

13

Contributions Map

Contributions by Country

Country Contributions Between Climbers Crags Summits Climbs Ascents
1 USA 1507 20th November 2025 – 30th June 2026 47 20 0 87 97
2 Australia 767 27th September 2025 – 29th June 2026 6 38 0 61 33
3 United Kingdom 576 19th November 2025 – 8th July 2026 33 14 0 22 43
4 France 264 6th January 2026 – 28th June 2026 14 3 0 12 31
5 Switzerland 257 24th January 2026 – 10th July 2026 6 3 0 12 33
6 Austria 210 12th November 2025 – 22nd June 2026 5 2 0 8 22
7 Italy 129 18th November 2025 – 29th May 2026 9 3 0 11 10
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
1601 15th May 2026 19:53:41 UTC baz9 list Dodgy Crags list_description_pretty
Before
None
After
<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>
1602 15th May 2026 19:53:41 UTC baz9 list Dodgy Crags list_type_id
Before
None
After
6
1603 15th May 2026 19:53:41 UTC baz9 list Dodgy Crags list_description
Before
None
After
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.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+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.
1604 15th May 2026 19:53:41 UTC baz9 list Dodgy Crags list_definition
Before
None
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 ,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
Diff
--- before

+++ after

@@ -1 +1,49 @@

-
+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
1605 15th May 2026 19:46:51 UTC baz9 climb Superman SDS crag_location_breadcrumb_pretty
Before
None
After
<a href="/crags/location/United Kingdom" class="text-muted">United Kingdom</a> / <a href="/crags/location/United Kingdom/England" class="text-muted">England</a> / <a href="/crags/location/United Kingdom/England/Buxton" class="text-muted">Buxton</a>
1606 15th May 2026 19:46:51 UTC baz9 climb Superman SDS crag_location_breadcrumb
Before
None
After
United Kingdom / England / Buxton
1607 15th May 2026 19:46:51 UTC baz9 climb Superman SDS crag_id
Before
None
After
8595
1608 15th May 2026 19:46:51 UTC baz9 climb Superman SDS crag_name
Before
None
After
Crag X
1609 15th May 2026 19:46:32 UTC baz9 climb Superman SDS crag_location_breadcrumb
Before
United Kingdom / England / Buxton
After
None
1610 15th May 2026 19:46:32 UTC baz9 climb Superman SDS crag_location_breadcrumb_pretty
Before
<a href="/crags/location/United Kingdom" class="text-muted">United Kingdom</a> / <a href="/crags/location/United Kingdom/England" class="text-muted">England</a> / <a href="/crags/location/United Kingdom/England/Buxton" class="text-muted">Buxton</a>
After
None
1611 15th May 2026 19:46:32 UTC baz9 climb Superman SDS crag_id
Before
8595
After
None
1612 15th May 2026 19:46:32 UTC baz9 climb Superman SDS crag_name
Before
Crag X
After
None
1613 15th May 2026 19:33:38 UTC baz9 crag Bodio Website
Before
None
After
https://climbingaway.fr/en/climbing-areas/bodio
1614 15th May 2026 19:32:44 UTC baz9 crag Sobrio Website
Before
None
After
https://climbingaway.fr/en/climbing-areas/sobrio
1615 15th May 2026 19:32:02 UTC baz9 climb Ninja Skills crag_name
Before
Bodio
After
Sobrio
1616 15th May 2026 19:32:02 UTC baz9 climb Ninja Skills crag_id
Before
34245
After
34363
1617 15th May 2026 19:31:44 UTC baz9 climb Ninja Skills SDS crag_name
Before
Bodio
After
Sobrio
1618 15th May 2026 19:31:44 UTC baz9 climb Ninja Skills SDS crag_id
Before
34245
After
34363
1619 15th May 2026 19:30:37 UTC baz9 crag Sobrio latitude
Before
46.38923
After
46.401207
1620 15th May 2026 19:30:37 UTC baz9 crag Sobrio longitude
Before
8.906541
After
8.908007

< Page 81 >