baz9

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

28

7 Days

100

4 Weeks

1048

All Time

3476

Current Streak

1

Longest Streak

8

Top Contributions

Name Type # Changes Last Updated First Updated
1 https://www.instagram.com/p/DLG3qSwxRoF/ media 39 9th 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 https://open.spotify.com/episode/5EREAaZGQcasxpoY6oDXor media 31 6th March 2026 4th February 2026
5 Chuck Odette climber 28 26th March 2026 25th March 2026
6 https://open.spotify.com/episode/5NHG7EfwMMQnphpUyAIm2Z media 28 27th March 2026 27th March 2026
7 Oldest Ascents (with date ranges) list 28 24th March 2026 23rd March 2026
8 Six Degrees climb 27 20th February 2026 20th November 2025
9 https://www.instagram.com/p/DWehdjziOMe/ media 27 29th March 2026 29th March 2026
10 Hamish McArthur climber 26 26th April 2026 25th March 2026

Recent Contributions

Date Time User Type Name Attribute
821 8th April 2026 23:02:03 UTC baz9 ascent Jordan Cannon's ascent of The Nose climb_id
Before
None
After
990
822 8th April 2026 23:02:03 UTC baz9 ascent Jordan Cannon's ascent of The Nose notes
Before
None
After
As part of the [El Cap Triple](/list/90/el-cap-triple) in under 24 hours. ### References [1] [https://www.climbing.com/news/el-capitan-speed-climb-el-cap-triple-climbed-2025/](https://www.climbing.com/news/el-capitan-speed-climb-el-cap-triple-climbed-2025/) [2] [https://www.instagram.com/p/DLG3qSwxRoF/](https://www.instagram.com/p/DLG3qSwxRoF/) [3] [https://www.instagram.com/reel/DKttE1YNfkN/](https://www.instagram.com/reel/DKttE1YNfkN/)
Diff
--- before

+++ after

@@ -1 +1,9 @@

-
+As part of the [El Cap Triple](/list/90/el-cap-triple) in under 24 hours.
+
+### References
+
+[1] [https://www.climbing.com/news/el-capitan-speed-climb-el-cap-triple-climbed-2025/](https://www.climbing.com/news/el-capitan-speed-climb-el-cap-triple-climbed-2025/)
+
+[2] [https://www.instagram.com/p/DLG3qSwxRoF/](https://www.instagram.com/p/DLG3qSwxRoF/)
+
+[3] [https://www.instagram.com/reel/DKttE1YNfkN/](https://www.instagram.com/reel/DKttE1YNfkN/)
823 8th April 2026 23:02:03 UTC baz9 ascent Jordan Cannon's ascent of The Nose climber_id
Before
None
After
1299
824 8th April 2026 22:57:42 UTC baz9 climber Michael Vaill notes_pretty
Before
<p>Michael is most known for his quick ascents of big walls in Yosemite </p>
After
<p>Michael is most known for his quick ascents of big walls in Yosemite.</p>
825 8th April 2026 22:57:42 UTC baz9 climber Michael Vaill notes
Before
Michael is most known for his quick ascents of big walls in Yosemite
After
Michael is most known for his quick ascents of big walls in Yosemite.
Diff
--- before

+++ after

@@ -1 +1 @@

-Michael is most known for his quick ascents of big walls in Yosemite
+Michael is most known for his quick ascents of big walls in Yosemite.
826 8th April 2026 22:55:01 UTC baz9 climber Michael Vaill notes
Before
None
After
Michael is most known for his quick ascents of big walls in Yosemite
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Michael is most known for his quick ascents of big walls in Yosemite
827 8th April 2026 22:55:01 UTC baz9 climber Michael Vaill notes_pretty
Before
None
After
<p>Michael is most known for his quick ascents of big walls in Yosemite </p>
828 8th April 2026 22:50:39 UTC baz9 climber Jordan Cannon Climbing Partner
Before
None
After
3868
829 8th April 2026 17:27:26 UTC baz9 list Quickest Ascents of Hard Boulder Problems list_definition
Before
None
After
with eight_c_plus_cutoff as ( select g.order_on from grades g where g.climb_type_id = 2 and g.grade = '8C+' ), session_meta as ( select a.ascent_id ,min( case when amk.key = 'Sessions' and am.value ~ '^[0-9]+$' and am.value::integer < 6 then am.value::integer when amk.key = 'Sessions (Approx)' and am.value ~ '^[0-9]+$' and am.value::integer < 6 then am.value::integer when amk.key = 'Sessions (Less Than)' and am.value ~ '^[0-9]+$' and am.value::integer <= 6 then am.value::integer - 1 else null end ) as sessions_sort ,string_agg( case when amk.key = 'Sessions' and am.value ~ '^[0-9]+$' and am.value::integer < 6 then amk.key || ': ' || am.value when amk.key = 'Sessions (Approx)' and am.value ~ '^[0-9]+$' and am.value::integer < 6 then amk.key || ': ' || am.value when amk.key = 'Sessions (Less Than)' and am.value ~ '^[0-9]+$' and am.value::integer <= 6 then amk.key || ': ' || am.value else null end ,', ' order by amk.key, am.value ) as session_meta from ascents a inner join ascent_meta am on a.ascent_id = am.ascent_id inner join ascent_meta_keys amk on am.ascent_meta_key_id = amk.ascent_meta_key_id where amk.key in ('Sessions', 'Sessions (Approx)', 'Sessions (Less Than)') group by a.ascent_id ) select a.ascent_id ,a.ascent_dt_start ,a.ascent_dt_end ,cl.climber_id ,cl.climber_name ,c.climb_id ,c.climb_name ,g.grade ,sm.session_meta ,sm.sessions_sort from ascents a inner join session_meta sm on a.ascent_id = sm.ascent_id inner join climbs c on a.climb_id = c.climb_id inner join climbers cl on a.climber_id = cl.climber_id inner join grades g on c.grade_id = g.grade_id inner join ascent_styles ast on a.ascent_style_id = ast.ascent_style_id where sm.sessions_sort is not null and c.climb_type_id = 2 and ast.ascent_successful = true and a.deleted_on is null and a.exclude_reason is null and c.deleted_on is null and c.exclude_reason is null and cl.deleted_on is null and cl.exclude_reason is null and g.order_on >= ( select ecc.order_on from eight_c_plus_cutoff ecc ) order by sm.sessions_sort ,g.order_on desc ,a.ascent_dt_start
Diff
--- before

+++ after

@@ -1 +1,114 @@

+with eight_c_plus_cutoff as (
+ select
+ g.order_on
+
+ from
+ grades g
+
+ where
+ g.climb_type_id = 2
+ and g.grade = '8C+'
+),
+
+session_meta as (
+ select
+ a.ascent_id
+ ,min(
+ case
+ when amk.key = 'Sessions'
+ and am.value ~ '^[0-9]+$'
+ and am.value::integer < 6
+ then am.value::integer
+ when amk.key = 'Sessions (Approx)'
+ and am.value ~ '^[0-9]+$'
+ and am.value::integer < 6
+ then am.value::integer
+ when amk.key = 'Sessions (Less Than)'
+ and am.value ~ '^[0-9]+$'
+ and am.value::integer <= 6
+ then am.value::integer - 1
+ else null
+ end
+ ) as sessions_sort
+ ,string_agg(
+ case
+ when amk.key = 'Sessions'
+ and am.value ~ '^[0-9]+$'
+ and am.value::integer < 6
+ then amk.key || ': ' || am.value
+ when amk.key = 'Sessions (Approx)'
+ and am.value ~ '^[0-9]+$'
+ and am.value::integer < 6
+ then amk.key || ': ' || am.value
+ when amk.key = 'Sessions (Less Than)'
+ and am.value ~ '^[0-9]+$'
+ and am.value::integer <= 6
+ then amk.key || ': ' || am.value
+ else null
+ end
+ ,', '
+ order by amk.key, am.value
+ ) as session_meta
+
+ from
+ ascents a
+ inner join ascent_meta am
+ on a.ascent_id = am.ascent_id
+ inner join ascent_meta_keys amk
+ on am.ascent_meta_key_id = amk.ascent_meta_key_id
+
+ where
+ amk.key in ('Sessions', 'Sessions (Approx)', 'Sessions (Less Than)')
+
+ group by
+ a.ascent_id
+)
+
+select
+ a.ascent_id
+ ,a.ascent_dt_start
+ ,a.ascent_dt_end
+ ,cl.climber_id
+ ,cl.climber_name
+ ,c.climb_id
+ ,c.climb_name
+ ,g.grade
+ ,sm.session_meta
+ ,sm.sessions_sort
+
+from
+ ascents a
+ inner join session_meta sm
+ on a.ascent_id = sm.ascent_id
+ inner join climbs c
+ on a.climb_id = c.climb_id
+ inner join climbers cl
+ on a.climber_id = cl.climber_id
+ inner join grades g
+ on c.grade_id = g.grade_id
+ inner join ascent_styles ast
+ on a.ascent_style_id = ast.ascent_style_id
+
+where
+ sm.sessions_sort is not null
+ and c.climb_type_id = 2
+ and ast.ascent_successful = true
+ and a.deleted_on is null
+ and a.exclude_reason is null
+ and c.deleted_on is null
+ and c.exclude_reason is null
+ and cl.deleted_on is null
+ and cl.exclude_reason is null
+ and g.order_on >= (
+ select
+ ecc.order_on
+
+ from
+ eight_c_plus_cutoff ecc
+ )
+
+order by
+ sm.sessions_sort
+ ,g.order_on desc
+ ,a.ascent_dt_start

830 8th April 2026 17:27:26 UTC baz9 list Quickest Ascents of Hard Boulder Problems list_name
Before
None
After
Quickest Ascents of Hard Boulder Problems
831 8th April 2026 17:27:26 UTC baz9 list Quickest Ascents of Hard Boulder Problems list_description
Before
None
After
Ascents of boulders 8C+ or harder, in 5 sessions or less.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Ascents of boulders 8C+ or harder, in 5 sessions or less.
832 8th April 2026 17:27:26 UTC baz9 list Quickest Ascents of Hard Boulder Problems list_description_pretty
Before
None
After
<p>Ascents of boulders 8C+ or harder, in 5 sessions or less.</p>
833 8th April 2026 17:27:26 UTC baz9 list Quickest Ascents of Hard Boulder Problems list_type_name
Before
None
After
Bouldering
834 8th April 2026 17:27:26 UTC baz9 list Quickest Ascents of Hard Boulder Problems list_type_id
Before
None
After
1
835 8th April 2026 13:53:01 UTC baz9 ascent Hamish McArthur's ascent of No One Mourns the Wicked Time
Before
None
After
02:17:00
836 8th April 2026 12:16:52 UTC baz9 ascent Jakob Schubert's ascent of Duality of Man ascent_dt_start
Before
None
After
2026-01-01
837 8th April 2026 12:16:52 UTC baz9 ascent Jakob Schubert's ascent of Duality of Man ascent_dt_end
Before
None
After
2027-01-01
838 8th April 2026 12:16:52 UTC baz9 ascent Jakob Schubert's ascent of Duality of Man climber_id
Before
None
After
494
839 8th April 2026 12:16:52 UTC baz9 ascent Jakob Schubert's ascent of Duality of Man climb_id
Before
None
After
5175
840 8th April 2026 12:16:52 UTC baz9 ascent Jakob Schubert's ascent of Duality of Man ascent_style_id
Before
None
After
5

< Page 42 >