baz9

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

0

7 Days

0

4 Weeks

66

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
2421 2nd May 2026 21:53:33 UTC baz9 climb Hump of Trouble crag_name
Before
None
After
Medlow Bath
2422 2nd May 2026 21:53:33 UTC baz9 climb Hump of Trouble crag_location_breadcrumb
Before
None
After
Australia / New South Wales / Blue Mountains City Council
2423 2nd May 2026 21:48:26 UTC baz9 crag Medlow Bath Website
Before
None
After
https://www.thecrag.com/en/climbing/australia/blue-mountains/medlow-bath
2424 2nd May 2026 21:47:24 UTC baz9 crag Medlow Bath eight_a_nu_url
Before
None
After
https://www.8a.nu/crags/sportclimbing/australia/meldow-bath
Diff
--- before

+++ after

@@ -1 +1 @@

-
+https://www.8a.nu/crags/sportclimbing/australia/meldow-bath
2425 2nd May 2026 21:46:54 UTC baz9 crag Medlow Bath ukc_url
Before
None
After
https://www.ukclimbing.com/logbook/crags/medlow_bath-11146/
2426 2nd May 2026 21:46:22 UTC baz9 crag Medlow Bath crag_name
Before
None
After
Medlow Bath
2427 2nd May 2026 21:46:22 UTC baz9 crag Medlow Bath latitude
Before
None
After
-33.669424
2428 2nd May 2026 21:46:22 UTC baz9 crag Medlow Bath longitude
Before
None
After
150.308713
2429 2nd May 2026 21:46:22 UTC baz9 crag Medlow Bath rock_type_id
Before
None
After
12
2430 2nd May 2026 21:38:35 UTC baz9 list Crags to be created from TheCrag list_type_name
Before
None
After
Admin
2431 2nd May 2026 21:38:35 UTC baz9 list Crags to be created from TheCrag list_definition
Before
None
After
with website_meta as ( select cm.climb_id ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url from climb_meta cm where cm.climb_meta_key_id = 30 group by cm.climb_id ) select '<a href="' || regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', '') || '">' || initcap(replace(split_part( regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', ''), '/', array_length(string_to_array(regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', ''), '/'), 1) ), '-', ' ')) || '</a>' as "theCrag Crag" ,count(*) as "Climbs Missing" ,string_agg( '<a href="' || c.url || '">' || c.climb_name || '</a>', ', ' order by c.climb_name ) as "Climbs" from climbs c inner join website_meta w on w.climb_id = c.climb_id where c.deleted_on is null and c.crag_id is null and w.thecrag_url is not null group by regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', '') order by count(*) desc ,"theCrag Crag"
Diff
--- before

+++ after

@@ -1 +1,47 @@

-
+with website_meta as (
+ select
+ cm.climb_id
+ ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
+
+ from
+ climb_meta cm
+
+ where
+ cm.climb_meta_key_id = 30
+
+ group by
+ cm.climb_id
+)
+
+select
+ '<a href="' ||
+ regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', '') ||
+ '">' ||
+ initcap(replace(split_part(
+ regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', ''),
+ '/',
+ array_length(string_to_array(regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', ''), '/'), 1)
+ ), '-', ' ')) ||
+ '</a>' as "theCrag Crag"
+ ,count(*) as "Climbs Missing"
+ ,string_agg(
+ '<a href="' || c.url || '">' || c.climb_name || '</a>',
+ ', ' order by c.climb_name
+ ) as "Climbs"
+
+from
+ climbs c
+ inner join website_meta w
+ on w.climb_id = c.climb_id
+
+where
+ c.deleted_on is null
+ and c.crag_id is null
+ and w.thecrag_url is not null
+
+group by
+ regexp_replace(w.thecrag_url, '/route(?:/[^/?#]+)?/?(?:\\?.*)?$', '')
+
+order by
+ count(*) desc
+ ,"theCrag Crag"
2432 2nd May 2026 21:38:35 UTC baz9 list Crags to be created from TheCrag list_description_pretty
Before
None
After
<p>Similar idea to <a href="https://climbing-history.org/list/96/crags-to-create" rel="noopener noreferrer">https://climbing-history.org/list/96/crags-to-create</a> but for TheCrag</p>
2433 2nd May 2026 21:38:35 UTC baz9 list Crags to be created from TheCrag list_type_id
Before
None
After
6
2434 2nd May 2026 21:38:35 UTC baz9 list Crags to be created from TheCrag list_name
Before
None
After
Crags to be created from TheCrag
2435 2nd May 2026 21:38:35 UTC baz9 list Crags to be created from TheCrag list_description
Before
None
After
Similar idea to [https://climbing-history.org/list/96/crags-to-create](https://climbing-history.org/list/96/crags-to-create) but for TheCrag
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Similar idea to [https://climbing-history.org/list/96/crags-to-create](https://climbing-history.org/list/96/crags-to-create) but for TheCrag
2436 2nd May 2026 21:35:50 UTC baz9 climb Blood Diamond Website
Before
None
After
https://www.thecrag.com/en/climbing/italy/route/5465355648
2437 2nd May 2026 21:28:50 UTC baz9 climb Asklepios crag_location_breadcrumb
Before
None
After
Australia / Victoria
2438 2nd May 2026 21:28:50 UTC baz9 climb Asklepios crag_location_breadcrumb_pretty
Before
None
After
<a href="/crags/location/Australia" class="text-muted">Australia</a> / <a href="/crags/location/Australia/Victoria" class="text-muted">Victoria</a>
2439 2nd May 2026 21:28:50 UTC baz9 climb Asklepios crag_name
Before
None
After
Mount Stapylton Amphitheatre
2440 2nd May 2026 21:28:50 UTC baz9 climb Asklepios crag_id
Before
None
After
10427

< Page 122 >