baz9

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

0

7 Days

33

4 Weeks

2008

All Time

6029

Current Streak

0

Longest Streak

13

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 Notable Queer Climbers list 41 7th May 2026 23rd March 2026
3 Six Degrees climb 40 13th May 2026 20th November 2025
4 https://www.instagram.com/reel/DKttE1YNfkN/ media 39 9th April 2026 8th April 2026
5 Jordan Cannon climber 36 8th May 2026 23rd March 2026
6 Chuck Odette climber 36 13th May 2026 25th March 2026
7 https://www.instagram.com/reel/DFIq7X8NAIi/ media 36 29th March 2026 29th March 2026
8 Crags Without Coordinates list 32 16th May 2026 7th May 2026
9 https://open.spotify.com/episode/5EREAaZGQcasxpoY6oDXor media 31 6th March 2026 4th February 2026
10 Noah Wheeler's ascent of Burden of Dreams ascent 29 16th May 2026 10th May 2026

Recent Contributions

Date Time User Type Name Attribute
21 27th May 2026 12:39:26 UTC baz9 ascent Aidan Roberts's ascent of The Singularity climb_id
Before
None
After
115
22 26th May 2026 18:05:10 UTC baz9 list The Hardest Sport Climbs in Sweden list_description
Before
None
After
Sport climbs in Sweden graded 8c or harder, ordered hardest first then by date of first ascent.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Sport climbs in Sweden graded 8c or harder, ordered hardest first then by date of first ascent.
23 26th May 2026 18:05:10 UTC baz9 list The Hardest Sport Climbs in Sweden list_description_pretty
Before
None
After
<p>Sport climbs in Sweden graded 8c or harder, ordered hardest first then by date of first ascent.</p>
24 26th May 2026 18:05:10 UTC baz9 list The Hardest Sport Climbs in Sweden list_type_id
Before
None
After
2
25 26th May 2026 18:05:10 UTC baz9 list The Hardest Sport Climbs in Sweden list_name
Before
None
After
The Hardest Sport Climbs in Sweden
26 26th May 2026 18:05:10 UTC baz9 list The Hardest Sport Climbs in Sweden list_definition
Before
None
After
select c.climb_uuid as row_uuid ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name" ,g.grade as "Grade" ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" ,( select count(*) from ascents a3 inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id where a3.climb_id = c.climb_id and a3.deleted_on is null and ast.ascent_successful ) as "# Ascents" from climbs c inner join grades g on c.grade_id = g.grade_id inner join crags cr on c.crag_id = cr.crag_id left join crag_meta cm_country on cr.crag_id = cm_country.crag_id and cm_country.crag_meta_key_id = 6 left join countries co_country on cm_country.value::int = co_country.country_id left join climb_meta cm_project on c.climb_id = cm_project.climb_id and cm_project.climb_meta_key_id = 20 left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id where c.deleted_on is null and c.climb_type = 1 and g.order_on >= 17 and cm_project.value is null and ( cr.location_breadcrumb ilike 'Sweden%' or ( (cr.location_breadcrumb is null or cr.location_breadcrumb = '') and co_country.name = 'Sweden' ) ) order by g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before

+++ after

@@ -1 +1,52 @@

+select
+ c.climb_uuid as row_uuid
+ ,'' || c.climb_name || '' as "Name"
+ ,g.grade as "Grade"
+ ,'' || cl.climber_name || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+ ,(
+ select count(*)
+ from ascents a3
+ inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id
+ where a3.climb_id = c.climb_id
+ and a3.deleted_on is null
+ and ast.ascent_successful
+ ) as "# Ascents"
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ inner join crags cr
+ on c.crag_id = cr.crag_id
+ left join crag_meta cm_country
+ on cr.crag_id = cm_country.crag_id
+ and cm_country.crag_meta_key_id = 6
+ left join countries co_country
+ on cm_country.value::int = co_country.country_id
+ left join climb_meta cm_project
+ on c.climb_id = cm_project.climb_id
+ and cm_project.climb_meta_key_id = 20
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+
+where
+ c.deleted_on is null
+ and c.climb_type = 1
+ and g.order_on >= 17
+ and cm_project.value is null
+ and (
+ cr.location_breadcrumb ilike 'Sweden%'
+ or (
+ (cr.location_breadcrumb is null or cr.location_breadcrumb = '')
+ and co_country.name = 'Sweden'
+ )
+ )
+
+order by
+ g.order_on desc
+ ,order_dt(a.ascent_dt_start, a.ascent_dt_end)

27 26th May 2026 18:05:10 UTC baz9 list The Hardest Sport Climbs in Sweden list_type_name
Before
None
After
Sport Climbing
28 26th May 2026 18:04:06 UTC baz9 list The Hardest Boulder Problems in Sweden list_description_pretty
Before
None
After
<p>Boulder problems in Sweden graded 8B or harder, ordered hardest first then by date of first ascent.</p>
29 26th May 2026 18:04:06 UTC baz9 list The Hardest Boulder Problems in Sweden list_type_id
Before
None
After
1
30 26th May 2026 18:04:06 UTC baz9 list The Hardest Boulder Problems in Sweden list_name
Before
None
After
The Hardest Boulder Problems in Sweden
31 26th May 2026 18:04:06 UTC baz9 list The Hardest Boulder Problems in Sweden list_type_name
Before
None
After
Bouldering
32 26th May 2026 18:04:06 UTC baz9 list The Hardest Boulder Problems in Sweden list_definition
Before
None
After
select c.climb_uuid as row_uuid ,'<a href="/climb/' || c.climb_id::varchar || '">' || c.climb_name || '</a>' as "Name" ,g.grade as "Grade" ,'<a href="/climber/' || cl.climber_id::varchar || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" ,( select count(*) from ascents a3 inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id where a3.climb_id = c.climb_id and a3.deleted_on is null and ast.ascent_successful ) as "# Ascents" from climbs c inner join grades g on c.grade_id = g.grade_id inner join crags cr on c.crag_id = cr.crag_id left join crag_meta cm_country on cr.crag_id = cm_country.crag_id and cm_country.crag_meta_key_id = 6 left join countries co_country on cm_country.value::int = co_country.country_id left join climb_meta cm_project on c.climb_id = cm_project.climb_id and cm_project.climb_meta_key_id = 20 left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id where c.deleted_on is null and c.climb_type = 2 and g.order_on >= 39 and cm_project.value is null and ( cr.location_breadcrumb ilike 'Sweden%' or ( (cr.location_breadcrumb is null or cr.location_breadcrumb = '') and co_country.name = 'Sweden' ) ) order by g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before

+++ after

@@ -1 +1,52 @@

+select
+ c.climb_uuid as row_uuid
+ ,'' || c.climb_name || '' as "Name"
+ ,g.grade as "Grade"
+ ,'' || cl.climber_name || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+ ,(
+ select count(*)
+ from ascents a3
+ inner join ascent_styles ast on a3.ascent_style_id = ast.ascent_style_id
+ where a3.climb_id = c.climb_id
+ and a3.deleted_on is null
+ and ast.ascent_successful
+ ) as "# Ascents"
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ inner join crags cr
+ on c.crag_id = cr.crag_id
+ left join crag_meta cm_country
+ on cr.crag_id = cm_country.crag_id
+ and cm_country.crag_meta_key_id = 6
+ left join countries co_country
+ on cm_country.value::int = co_country.country_id
+ left join climb_meta cm_project
+ on c.climb_id = cm_project.climb_id
+ and cm_project.climb_meta_key_id = 20
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+
+where
+ c.deleted_on is null
+ and c.climb_type = 2
+ and g.order_on >= 39
+ and cm_project.value is null
+ and (
+ cr.location_breadcrumb ilike 'Sweden%'
+ or (
+ (cr.location_breadcrumb is null or cr.location_breadcrumb = '')
+ and co_country.name = 'Sweden'
+ )
+ )
+
+order by
+ g.order_on desc
+ ,order_dt(a.ascent_dt_start, a.ascent_dt_end)

33 26th May 2026 18:04:06 UTC baz9 list The Hardest Boulder Problems in Sweden list_description
Before
None
After
Boulder problems in Sweden graded 8B or harder, ordered hardest first then by date of first ascent.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Boulder problems in Sweden graded 8B or harder, ordered hardest first then by date of first ascent.
34 22nd May 2026 10:17:57 UTC baz9 ascent Katie Lamb's ascent of 130 BPM notes
Before
### References [1] [https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te](https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te) [2] [https://www.instagram.com/p/DYhzlNXG9TQ/](https://www.instagram.com/p/DYhzlNXG9TQ/) [3] [https://www.instagram.com/p/DYiNJhPEWo_/](https://www.instagram.com/p/DYiNJhPEWo_/)
After
### References [1] [https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te](https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te) [2] [https://www.instagram.com/p/DYhzlNXG9TQ/](https://www.instagram.com/p/DYhzlNXG9TQ/) [3] [https://www.instagram.com/p/DYiNJhPEWo_/](https://www.instagram.com/p/DYiNJhPEWo_/) [4] [https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/](https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/)
Diff
--- before

+++ after

@@ -4,4 +4,6 @@


[2] [https://www.instagram.com/p/DYhzlNXG9TQ/](https://www.instagram.com/p/DYhzlNXG9TQ/)

-[3] [https://www.instagram.com/p/DYiNJhPEWo_/](https://www.instagram.com/p/DYiNJhPEWo_/)
+[3] [https://www.instagram.com/p/DYiNJhPEWo_/](https://www.instagram.com/p/DYiNJhPEWo_/)
+
+[4] [https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/](https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/)
35 22nd May 2026 10:17:57 UTC baz9 ascent Katie Lamb's ascent of 130 BPM notes_pretty
Before
<h3>References</h3> <p>[1] <a href="https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te" rel="noopener noreferrer">https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te</a></p> <p>[2] <a href="https://www.instagram.com/p/DYhzlNXG9TQ/" rel="noopener noreferrer">https://www.instagram.com/p/DYhzlNXG9TQ/</a></p> <p>[3] <a href="https://www.instagram.com/p/DYiNJhPEWo_/" rel="noopener noreferrer">https://www.instagram.com/p/DYiNJhPEWo_/</a></p>
After
<h3>References</h3> <p>[1] <a href="https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te" rel="noopener noreferrer">https://open.spotify.com/episode/6rJ0gdBK8sJxJ06S1P68Te</a></p> <p>[2] <a href="https://www.instagram.com/p/DYhzlNXG9TQ/" rel="noopener noreferrer">https://www.instagram.com/p/DYhzlNXG9TQ/</a></p> <p>[3] <a href="https://www.instagram.com/p/DYiNJhPEWo_/" rel="noopener noreferrer">https://www.instagram.com/p/DYiNJhPEWo_/</a></p> <p>[4] <a href="https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/" rel="noopener noreferrer">https://gripped.com/news/katie-lamb-makes-v15-first-ascent-in-yosemite/</a></p>
36 21st May 2026 01:20:14 UTC baz9 ascent Drew Ruana's ascent of Everything Gneiss Sessions (More Than)
Before
None
After
15
37 21st May 2026 01:19:37 UTC baz9 ascent Matt Fultz's ascent of Everything Gneiss notes_pretty
Before
<h3>References</h3> <p>[1] <a href="https://www.youtube.com/watch?v=0JYeNNGb6ns">https://www.youtube.com/watch?v=0JYeNNGb6ns</a></p>
After
<h3>References</h3> <p>[1] <a href="https://www.youtube.com/watch?v=0JYeNNGb6ns" rel="noopener noreferrer">https://www.youtube.com/watch?v=0JYeNNGb6ns</a></p>
38 21st May 2026 01:19:37 UTC baz9 ascent Matt Fultz's ascent of Everything Gneiss suggested_grade_id
Before
None
After
178
39 21st May 2026 01:19:20 UTC baz9 ascent Drew Ruana's ascent of Everything Gneiss suggested_grade_id
Before
None
After
283
40 21st May 2026 01:19:20 UTC baz9 ascent Drew Ruana's ascent of Everything Gneiss notes_pretty
Before
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/p/CoIKr05uwrT/">https://www.instagram.com/p/CoIKr05uwrT/</a></p>
After
<h3>References</h3> <p>[1] <a href="https://www.instagram.com/p/CoIKr05uwrT/" rel="noopener noreferrer">https://www.instagram.com/p/CoIKr05uwrT/</a></p>

< Page 2 >