baz9

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

0

7 Days

145

4 Weeks

999

All Time

3553

Current Streak

3

Longest Streak

8

Top Contributions

Name Type # Changes Last Updated First Updated
1 https://www.instagram.com/p/DLG3qSwxRoF/ media 45 26th April 2026 8th April 2026
2 https://www.instagram.com/reel/DKttE1YNfkN/ media 39 9th April 2026 8th April 2026
3 https://www.instagram.com/reel/DFIq7X8NAIi/ media 36 29th March 2026 29th March 2026
4 Jordan Cannon climber 32 27th April 2026 23rd March 2026
5 Notable Queer Climbers list 32 27th April 2026 23rd March 2026
6 https://open.spotify.com/episode/5EREAaZGQcasxpoY6oDXor media 31 6th March 2026 4th February 2026
7 Chuck Odette climber 28 26th March 2026 25th March 2026
8 https://open.spotify.com/episode/5NHG7EfwMMQnphpUyAIm2Z media 28 27th March 2026 27th March 2026
9 Oldest Ascents (with date ranges) list 28 24th March 2026 23rd March 2026
10 Six Degrees climb 27 20th February 2026 20th November 2025

Recent Contributions

Date Time User Type Name Attribute
1761 23rd March 2026 22:32:59 UTC baz9 media https://www.youtube.com/watch?v=gTW0QkAFpOg missing_right_to_reproduce
Before
None
After
false
1762 23rd March 2026 22:32:59 UTC baz9 media https://www.youtube.com/watch?v=gTW0QkAFpOg embed_code
Before
None
After
<div class="video-wrapper"><iframe class="embed-responsive-item" src="https://www.youtube.com/embed/gTW0QkAFpOg" allowfullscreen></iframe></div>
1763 23rd March 2026 22:32:59 UTC baz9 media https://www.youtube.com/watch?v=gTW0QkAFpOg dt_pretty
Before
None
After
1764 23rd March 2026 22:32:58 UTC baz9 ascent Rob Matheson's ascent of The Bells! The Bells! ascent_dt_end
Before
2025-05-01
After
2025-04-24
1765 23rd March 2026 22:32:58 UTC baz9 ascent Rob Matheson's ascent of The Bells! The Bells! ascent_dt_start
Before
2025-04-01
After
2025-04-24
1766 23rd March 2026 22:32:58 UTC baz9 ascent Rob Matheson's ascent of The Bells! The Bells! notes_pretty
Before
<p>Aged a spritely 74!</p> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/04/rob_matheson_repeats_the_bells_the_bells_e7_6b-73955">https://www.ukclimbing.com/news/2025/04/rob_matheson_repeats_the_bells_the_bells_e7_6b-73955</a></p> <p>[2] <a href="https://www.instagram.com/p/DJGsXORo-HA/">https://www.instagram.com/p/DJGsXORo-HA/</a></p> <p>[3] <a href="https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html">https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html</a></p> <p>[4] <a href="https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html">https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html</a></p> <p>[5] <a href="https://www.youtube.com/watch?v=gTW0QkAFpOg">https://www.youtube.com/watch?v=gTW0QkAFpOg</a></p>
After
<p>Aged a spritely 74!</p> <h3>References</h3> <p>[1] <a href="https://www.ukclimbing.com/news/2025/04/rob_matheson_repeats_the_bells_the_bells_e7_6b-73955" rel="noopener noreferrer">https://www.ukclimbing.com/news/2025/04/rob_matheson_repeats_the_bells_the_bells_e7_6b-73955</a></p> <p>[2] <a href="https://www.instagram.com/p/DJGsXORo-HA/" rel="noopener noreferrer">https://www.instagram.com/p/DJGsXORo-HA/</a></p> <p>[3] <a href="https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html" rel="noopener noreferrer">https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html</a></p> <p>[4] <a href="https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html" rel="noopener noreferrer">https://www.planetmountain.com/en/news/interviews/rob-matheson-the-bells-the-bells-interview.html</a></p> <p>[5] <a href="https://www.youtube.com/watch?v=gTW0QkAFpOg" rel="noopener noreferrer">https://www.youtube.com/watch?v=gTW0QkAFpOg</a></p>
1767 23rd March 2026 17:57:54 UTC baz9 list Oldest Ascents list_type_name
Before
Bouldering
After
Misc.
1768 23rd March 2026 17:57:54 UTC baz9 list Oldest Ascents list_type_id
Before
1
After
5
1769 23rd March 2026 17:57:07 UTC baz9 list Oldest Ascents list_type_name
Before
None
After
Bouldering
1770 23rd March 2026 17:57:07 UTC baz9 list Oldest Ascents list_type_id
Before
None
After
1
1771 23rd March 2026 17:57:07 UTC baz9 list Oldest Ascents list_description
Before
None
After
This is a list of the oldest ascents at each grade.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+This is a list of the oldest ascents at each grade.
1772 23rd March 2026 17:57:07 UTC baz9 list Oldest Ascents list_definition
Before
None
After
with climbers_with_dobs as ( select c.climber_id ,c.climber_name ,c.date_of_birth_start as date_of_birth from climbers c where c.deleted_on is null and c.date_of_birth_start = c.date_of_birth_end ), ascents_with_ages as ( select row_number() over ( partition by g.grade_id order by a.ascent_dt_start - c.date_of_birth desc, a.ascent_dt_start asc ) as row_number ,c.climber_id ,c.climber_name ,cl.climb_id ,cl.climb_name ,g.grade_id ,g.grade_system_id ,g.climb_type_id ,g.order_on ,g.grade ,a.ascent_dt_start ,c.date_of_birth ,a.ascent_dt_start - c.date_of_birth as age_in_days_at_ascent ,extract(year from age(a.ascent_dt_start, c.date_of_birth))::integer as age_in_years_at_ascent ,age(a.ascent_dt_start, c.date_of_birth) as age_interval_at_ascent ,a.ascent_id from ascents a inner join climbers_with_dobs c on a.climber_id = c.climber_id and a.deleted_on is null inner join climbs cl on cl.climb_id = a.climb_id and cl.deleted_on is null inner join grades g on cl.grade_id = g.grade_id where a.ascent_dt_start = a.ascent_dt_end ), oldest as ( select * from ascents_with_ages where row_number = 1 ) select o.grade ,'<a href="/climber/' || o.climber_id::varchar || '">' || o.climber_name || '</a>' as "Climber" ,'<a href="/climb/' || o.climb_id::varchar || '">' || o.climb_name || '</a>' as "Climb" ,o.age_in_days_at_ascent as "Age (Days)" ,o.age_in_years_at_ascent || ' years ' || extract(days from o.ascent_dt_start - (o.date_of_birth + make_interval(years => o.age_in_years_at_ascent))) || ' days' as "Age" from oldest o where case when grade_system_id = 1 and order_on >= 13 then 1 when grade_system_id = 2 and order_on >= 60 then 1 when grade_system_id = 3 and order_on >= 37 then 1 else 0 end = 1 and climb_type_id in (1,2,3) order by grade_system_id ,order_on
Diff
--- before

+++ after

@@ -1 +1,82 @@

+with climbers_with_dobs as (
+ select
+ c.climber_id
+ ,c.climber_name
+ ,c.date_of_birth_start as date_of_birth
+
+ from
+ climbers c
+
+ where
+ c.deleted_on is null
+ and c.date_of_birth_start = c.date_of_birth_end
+), ascents_with_ages as (
+ select
+ row_number() over (
+ partition by g.grade_id
+ order by a.ascent_dt_start - c.date_of_birth desc, a.ascent_dt_start asc
+ ) as row_number
+ ,c.climber_id
+ ,c.climber_name
+ ,cl.climb_id
+ ,cl.climb_name
+ ,g.grade_id
+ ,g.grade_system_id
+ ,g.climb_type_id
+ ,g.order_on
+ ,g.grade
+ ,a.ascent_dt_start
+ ,c.date_of_birth
+ ,a.ascent_dt_start - c.date_of_birth as age_in_days_at_ascent
+ ,extract(year from age(a.ascent_dt_start, c.date_of_birth))::integer as age_in_years_at_ascent
+ ,age(a.ascent_dt_start, c.date_of_birth) as age_interval_at_ascent
+ ,a.ascent_id
+
+ from
+ ascents a
+ inner join climbers_with_dobs c
+ on a.climber_id = c.climber_id
+ and a.deleted_on is null
+ inner join climbs cl
+ on cl.climb_id = a.climb_id
+ and cl.deleted_on is null
+ inner join grades g
+ on cl.grade_id = g.grade_id
+
+ where
+ a.ascent_dt_start = a.ascent_dt_end
+
+), oldest as (
+ select
+ *
+
+ from
+ ascents_with_ages
+
+ where
+ row_number = 1
+)
+
+select
+ o.grade
+ ,'' || o.climber_name || '' as "Climber"
+ ,'' || o.climb_name || '' as "Climb"
+ ,o.age_in_days_at_ascent as "Age (Days)"
+ ,o.age_in_years_at_ascent || ' years ' || extract(days from o.ascent_dt_start - (o.date_of_birth + make_interval(years => o.age_in_years_at_ascent))) || ' days' as "Age"
+
+from
+ oldest o
+
+where
+ case
+ when grade_system_id = 1 and order_on >= 13 then 1
+ when grade_system_id = 2 and order_on >= 60 then 1
+ when grade_system_id = 3 and order_on >= 37 then 1
+ else 0
+ end = 1
+ and climb_type_id in (1,2,3)
+
+order by
+ grade_system_id
+ ,order_on

1773 23rd March 2026 17:57:07 UTC baz9 list Oldest Ascents list_description_pretty
Before
None
After
<p>This is a list of the oldest ascents at each grade.</p>
1774 23rd March 2026 17:57:07 UTC baz9 list Oldest Ascents list_name
Before
None
After
Oldest Ascents
1775 23rd March 2026 17:31:55 UTC baz9 climber Jordan Cannon instagram_url
Before
None
After
https://www.instagram.com/cannonjtc/
1776 23rd March 2026 17:31:08 UTC baz9 climber Jordan Cannon notes
Before
None
After
### References [1] [https://www.outsideonline.com/culture/essays-culture/professional-climber-jordan-cannon-comes-out-gay/](https://www.outsideonline.com/culture/essays-culture/professional-climber-jordan-cannon-comes-out-gay/)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://www.outsideonline.com/culture/essays-culture/professional-climber-jordan-cannon-comes-out-gay/](https://www.outsideonline.com/culture/essays-culture/professional-climber-jordan-cannon-comes-out-gay/)
1777 23rd March 2026 17:31:08 UTC baz9 climber Jordan Cannon notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://www.outsideonline.com/culture/essays-culture/professional-climber-jordan-cannon-comes-out-gay/" rel="noopener noreferrer">https://www.outsideonline.com/culture/essays-culture/professional-climber-jordan-cannon-comes-out-gay/</a></p>
1778 23rd March 2026 17:25:50 UTC baz9 list Notable Queer Climbers list_description
Before
This list records selected significant achievements by queer climbers. Work in progress!
After
This list records selected significant achievements by queer climbers (in no particular order). Work in progress!
Diff
--- before

+++ after

@@ -1 +1 @@

-This list records selected significant achievements by queer climbers. Work in progress!
+This list records selected significant achievements by queer climbers (in no particular order). Work in progress!
1779 23rd March 2026 17:25:50 UTC baz9 list Notable Queer Climbers list_description_pretty
Before
<p>This list records selected significant achievements by queer climbers. Work in progress!</p>
After
<p>This list records selected significant achievements by queer climbers (in no particular order). Work in progress!</p>
1780 23rd March 2026 17:17:30 UTC baz9 list Notable Queer Climbers list_description
Before
This list records selected significant achievements by queer climbers. Work in progress! DM baz9x on Discord with any additions.
After
This list records selected significant achievements by queer climbers. Work in progress!
Diff
--- before

+++ after

@@ -1 +1 @@

-This list records selected significant achievements by queer climbers. Work in progress! DM baz9x on Discord with any additions.
+This list records selected significant achievements by queer climbers. Work in progress!

< Page 89 >