baz9

Badges

100 Contributions1,000 Contributions10 Posts

Contributions

Posts

1 Day

0

7 Days

0

4 Weeks

194

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
1181 16th May 2026 14:10:48 UTC baz9 media https://www.instagram.com/p/DYZsWOLABiS/ dt_pretty
Before
None
After
1182 16th May 2026 14:10:48 UTC baz9 media https://www.instagram.com/p/DYZsWOLABiS/ missing_right_to_reproduce
Before
None
After
false
1183 16th May 2026 14:10:48 UTC baz9 media https://www.instagram.com/p/DYZsWOLABiS/ url
Before
None
After
https://www.instagram.com/p/DYZsWOLABiS/
1184 16th May 2026 14:10:47 UTC baz9 ascent Noah Wheeler's ascent of Burden of Dreams notes_pretty
Before
<h3>References</h3> <p>[1] Noah got very close on his second session <a href="https://www.instagram.com/reel/DRkVMNOgFvV/" rel="noopener noreferrer">https://www.instagram.com/reel/DRkVMNOgFvV/</a></p> <p>[2] <a href="https://tensionclimbing.com/blogs/blog/reflections-from-finland" rel="noopener noreferrer">https://tensionclimbing.com/blogs/blog/reflections-from-finland</a></p> <p>[3] Vlog from Noah's second trip with <a href="/climber/1202/yannick-flohé" rel="noopener noreferrer">Yannick Flohé</a> <a href="https://www.youtube.com/watch?v=wJ0yC74D33s" rel="noopener noreferrer">https://www.youtube.com/watch?v=wJ0yC74D33s</a></p> <p>[4] Footage from a close go <a href="https://www.instagram.com/reel/DYNn5YNsM1g/" rel="noopener noreferrer">https://www.instagram.com/reel/DYNn5YNsM1g/</a></p> <p>[5] Another agonisingly close attempt with a small dab <a href="https://www.instagram.com/p/DYU4ue7oHik/" rel="noopener noreferrer">https://www.instagram.com/p/DYU4ue7oHik/</a></p>
After
<h3>References</h3> <p>[1] Send Post! <a href="https://www.instagram.com/p/DYZsWOLABiS/" rel="noopener noreferrer">https://www.instagram.com/p/DYZsWOLABiS/</a></p> <p>[2] Noah got very close on his second session <a href="https://www.instagram.com/reel/DRkVMNOgFvV/" rel="noopener noreferrer">https://www.instagram.com/reel/DRkVMNOgFvV/</a></p> <p>[3] <a href="https://tensionclimbing.com/blogs/blog/reflections-from-finland" rel="noopener noreferrer">https://tensionclimbing.com/blogs/blog/reflections-from-finland</a></p> <p>[4] Vlog from Noah's second trip with <a href="/climber/1202/yannick-flohé" rel="noopener noreferrer">Yannick Flohé</a> <a href="https://www.youtube.com/watch?v=wJ0yC74D33s" rel="noopener noreferrer">https://www.youtube.com/watch?v=wJ0yC74D33s</a></p> <p>[5] Footage from a close go <a href="https://www.instagram.com/reel/DYNn5YNsM1g/" rel="noopener noreferrer">https://www.instagram.com/reel/DYNn5YNsM1g/</a></p> <p>[6] Another agonisingly close attempt with a small dab <a href="https://www.instagram.com/p/DYU4ue7oHik/" rel="noopener noreferrer">https://www.instagram.com/p/DYU4ue7oHik/</a></p>
1185 16th May 2026 14:10:47 UTC baz9 ascent Noah Wheeler's ascent of Burden of Dreams notes
Before
### References [1] Noah got very close on his second session [https://www.instagram.com/reel/DRkVMNOgFvV/](https://www.instagram.com/reel/DRkVMNOgFvV/) [2] [https://tensionclimbing.com/blogs/blog/reflections-from-finland](https://tensionclimbing.com/blogs/blog/reflections-from-finland) [3] Vlog from Noah's second trip with [Yannick Flohé](/climber/1202/yannick-flohé) [https://www.youtube.com/watch?v=wJ0yC74D33s](https://www.youtube.com/watch?v=wJ0yC74D33s) [4] Footage from a close go [https://www.instagram.com/reel/DYNn5YNsM1g/](https://www.instagram.com/reel/DYNn5YNsM1g/) [5] Another agonisingly close attempt with a small dab [https://www.instagram.com/p/DYU4ue7oHik/](https://www.instagram.com/p/DYU4ue7oHik/)
After
### References [1] Send Post! [https://www.instagram.com/p/DYZsWOLABiS/](https://www.instagram.com/p/DYZsWOLABiS/) [2] Noah got very close on his second session [https://www.instagram.com/reel/DRkVMNOgFvV/](https://www.instagram.com/reel/DRkVMNOgFvV/) [3] [https://tensionclimbing.com/blogs/blog/reflections-from-finland](https://tensionclimbing.com/blogs/blog/reflections-from-finland) [4] Vlog from Noah's second trip with [Yannick Flohé](/climber/1202/yannick-flohé) [https://www.youtube.com/watch?v=wJ0yC74D33s](https://www.youtube.com/watch?v=wJ0yC74D33s) [5] Footage from a close go [https://www.instagram.com/reel/DYNn5YNsM1g/](https://www.instagram.com/reel/DYNn5YNsM1g/) [6] Another agonisingly close attempt with a small dab [https://www.instagram.com/p/DYU4ue7oHik/](https://www.instagram.com/p/DYU4ue7oHik/)
Diff
--- before

+++ after

@@ -1,12 +1,14 @@

### References

-[1] Noah got very close on his second session [https://www.instagram.com/reel/DRkVMNOgFvV/](https://www.instagram.com/reel/DRkVMNOgFvV/)
+[1] Send Post! [https://www.instagram.com/p/DYZsWOLABiS/](https://www.instagram.com/p/DYZsWOLABiS/)

-[2] [https://tensionclimbing.com/blogs/blog/reflections-from-finland](https://tensionclimbing.com/blogs/blog/reflections-from-finland)
+[2] Noah got very close on his second session [https://www.instagram.com/reel/DRkVMNOgFvV/](https://www.instagram.com/reel/DRkVMNOgFvV/)

-[3] Vlog from Noah's second trip with [Yannick Flohé](/climber/1202/yannick-flohé) [https://www.youtube.com/watch?v=wJ0yC74D33s](https://www.youtube.com/watch?v=wJ0yC74D33s)
+[3] [https://tensionclimbing.com/blogs/blog/reflections-from-finland](https://tensionclimbing.com/blogs/blog/reflections-from-finland)

-[4]
+[4] Vlog from Noah's second trip with [Yannick Flohé](/climber/1202/yannick-flohé) [https://www.youtube.com/watch?v=wJ0yC74D33s](https://www.youtube.com/watch?v=wJ0yC74D33s)
+
+[5]
Footage from a close go [https://www.instagram.com/reel/DYNn5YNsM1g/](https://www.instagram.com/reel/DYNn5YNsM1g/)

-[5] Another agonisingly close attempt with a small dab [https://www.instagram.com/p/DYU4ue7oHik/](https://www.instagram.com/p/DYU4ue7oHik/)
+[6] Another agonisingly close attempt with a small dab [https://www.instagram.com/p/DYU4ue7oHik/](https://www.instagram.com/p/DYU4ue7oHik/)
1186 16th May 2026 14:04:16 UTC baz9 list Crags Without Coordinates list_description_pretty
Before
<p>This is a list of crags that have no location coordinates. </p> <p>Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. Here we have added a broad 'country' meta. </p> <p>There is another list of crags without Coordinates OR Country meta, here: <a href="/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">/list/115/crags-without-coordinates-or-country-meta</a></p>
After
<p>This is a list of crags that have no location coordinates. </p> <p>Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. In those cases we have added a broad 'country' meta. </p> <p>Here is another list of crags without Coordinates OR Country meta: <a href="/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">/list/115/crags-without-coordinates-or-country-meta</a></p>
1187 16th May 2026 14:04:16 UTC baz9 list Crags Without Coordinates list_description
Before
This is a list of crags that have no location coordinates. Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. Here we have added a broad 'country' meta. There is another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
After
This is a list of crags that have no location coordinates. Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. In those cases we have added a broad 'country' meta. Here is another list of crags without Coordinates OR Country meta: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
Diff
--- before

+++ after

@@ -1,5 +1,5 @@

This is a list of crags that have no location coordinates.

-Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. Here we have added a broad 'country' meta.
+Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. In those cases we have added a broad 'country' meta.

-There is another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
+Here is another list of crags without Coordinates OR Country meta: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
1188 16th May 2026 14:03:48 UTC baz9 list Crags Without Coordinates list_description
Before
This is a list of crags that have no location coordinates. Some crags in this list have secret locations so we have added a broad 'country' meta. I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
After
This is a list of crags that have no location coordinates. Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. Here we have added a broad 'country' meta. There is another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
Diff
--- before

+++ after

@@ -1,5 +1,5 @@

This is a list of crags that have no location coordinates.

-Some crags in this list have secret locations so we have added a broad 'country' meta.
+Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. Here we have added a broad 'country' meta.

-I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
+There is another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
1189 16th May 2026 14:03:48 UTC baz9 list Crags Without Coordinates list_description_pretty
Before
<p>This is a list of crags that have no location coordinates. </p> <p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p> <p>I have created another list of crags without Coordinates OR Country meta, here: <a href="/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">/list/115/crags-without-coordinates-or-country-meta</a></p>
After
<p>This is a list of crags that have no location coordinates. </p> <p>Although we would prefer to have all crags tagged with coordinates, some crags have secret locations. Here we have added a broad 'country' meta. </p> <p>There is another list of crags without Coordinates OR Country meta, here: <a href="/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">/list/115/crags-without-coordinates-or-country-meta</a></p>
1190 16th May 2026 14:01:45 UTC baz9 list Crags Without Coordinates list_definition
Before
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,country.country as "Country Meta" ,coalesce(cc.cnt_climbs, 0) as Climbs ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" ,case when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>' else null end as "theCrag" ,case when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>' else null end as "27crags" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id left join ( select cm.crag_id ,max(co.name) as country from crag_meta cm inner join crag_meta_keys cmk on cm.crag_meta_key_id = cmk.crag_meta_key_id inner join countries co on cm.value = co.country_id::varchar where cmk.key = 'Country' group by cm.crag_id ) country on country.crag_id = c.crag_id left join ( select cm.crag_id ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url ,max( case when cm.value ilike '%27crags.com%' or cm.value ilike '%thetopo.com%' then cm.value end ) as crags27_url from crag_meta cm where cm.crag_meta_key_id = 1 group by cm.crag_id ) w on w.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
After
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,country.country as "Country Meta" ,coalesce(cc.cnt_climbs, 0) as Climbs ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id left join ( select cm.crag_id ,max(co.name) as country from crag_meta cm inner join crag_meta_keys cmk on cm.crag_meta_key_id = cmk.crag_meta_key_id inner join countries co on cm.value = co.country_id::varchar where cmk.key = 'Country' group by cm.crag_id ) country on country.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
Diff
--- before

+++ after

@@ -10,14 +10,6 @@

when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>'
else null
end as "8a.nu"
- ,case
- when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>'
- else null
- end as "theCrag"
- ,case
- when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>'
- else null
- end as "27crags"

from
crags c
@@ -55,28 +47,6 @@

cm.crag_id
) country
on country.crag_id = c.crag_id
- left join (
- select
- cm.crag_id
- ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
- ,max(
- case
- when cm.value ilike '%27crags.com%'
- or cm.value ilike '%thetopo.com%'
- then cm.value
- end
- ) as crags27_url
-
- from
- crag_meta cm
-
- where
- cm.crag_meta_key_id = 1
-
- group by
- cm.crag_id
- ) w
- on w.crag_id = c.crag_id

where
c.deleted_on is null
@@ -86,5 +56,4 @@


order by
coalesce(cc.cnt_climbs, 0) desc
- ,c.crag_name
-
+ ,c.crag_name
1191 16th May 2026 14:00:26 UTC baz9 crag Green Lane Website
Before
None
After
test.com
1192 16th May 2026 13:58:11 UTC baz9 list Crags Without Coordinates list_definition
Before
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,coalesce(cc.cnt_climbs, 0) as Climbs ,country.country as Country ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" ,case when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>' else null end as "theCrag" ,case when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>' else null end as "27crags" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id left join ( select cm.crag_id ,max(co.name) as country from crag_meta cm inner join crag_meta_keys cmk on cm.crag_meta_key_id = cmk.crag_meta_key_id inner join countries co on cm.value = co.country_id::varchar where cmk.key = 'Country' group by cm.crag_id ) country on country.crag_id = c.crag_id left join ( select cm.crag_id ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url ,max( case when cm.value ilike '%27crags.com%' or cm.value ilike '%thetopo.com%' then cm.value end ) as crags27_url from crag_meta cm where cm.crag_meta_key_id = 1 group by cm.crag_id ) w on w.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
After
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,country.country as "Country Meta" ,coalesce(cc.cnt_climbs, 0) as Climbs ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" ,case when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>' else null end as "theCrag" ,case when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>' else null end as "27crags" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id left join ( select cm.crag_id ,max(co.name) as country from crag_meta cm inner join crag_meta_keys cmk on cm.crag_meta_key_id = cmk.crag_meta_key_id inner join countries co on cm.value = co.country_id::varchar where cmk.key = 'Country' group by cm.crag_id ) country on country.crag_id = c.crag_id left join ( select cm.crag_id ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url ,max( case when cm.value ilike '%27crags.com%' or cm.value ilike '%thetopo.com%' then cm.value end ) as crags27_url from crag_meta cm where cm.crag_meta_key_id = 1 group by cm.crag_id ) w on w.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
Diff
--- before

+++ after

@@ -1,7 +1,7 @@

select
'<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag
+ ,country.country as "Country Meta"
,coalesce(cc.cnt_climbs, 0) as Climbs
- ,country.country as Country
,case
when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>'
else null
@@ -86,4 +86,5 @@


order by
coalesce(cc.cnt_climbs, 0) desc
- ,c.crag_name
+ ,c.crag_name
+
1193 16th May 2026 13:56:08 UTC baz9 list Crags Without Coordinates list_definition
Before
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,coalesce(cc.cnt_climbs, 0) as Climbs ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" ,case when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>' else null end as "theCrag" ,case when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>' else null end as "27crags" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id left join ( select cm.crag_id ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url ,max( case when cm.value ilike '%27crags.com%' or cm.value ilike '%thetopo.com%' then cm.value end ) as crags27_url from crag_meta cm where cm.crag_meta_key_id = 1 group by cm.crag_id ) w on w.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
After
select '<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag ,coalesce(cc.cnt_climbs, 0) as Climbs ,country.country as Country ,case when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>' else null end as UKC ,case when c.eight_a_nu_url is not null then '<a href="' || c.eight_a_nu_url || '">8a.nu</a>' else null end as "8a.nu" ,case when w.thecrag_url is not null then '<a href="' || w.thecrag_url || '">theCrag</a>' else null end as "theCrag" ,case when w.crags27_url is not null then '<a href="' || w.crags27_url || '">27crags</a>' else null end as "27crags" from crags c left join ( select cl.crag_id ,count(*) as cnt_climbs from climbs cl where cl.deleted_on is null group by cl.crag_id ) cc on cc.crag_id = c.crag_id left join ( select cm.crag_id ,max(co.name) as country from crag_meta cm inner join crag_meta_keys cmk on cm.crag_meta_key_id = cmk.crag_meta_key_id inner join countries co on cm.value = co.country_id::varchar where cmk.key = 'Country' group by cm.crag_id ) country on country.crag_id = c.crag_id left join ( select cm.crag_id ,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url ,max( case when cm.value ilike '%27crags.com%' or cm.value ilike '%thetopo.com%' then cm.value end ) as crags27_url from crag_meta cm where cm.crag_meta_key_id = 1 group by cm.crag_id ) w on w.crag_id = c.crag_id where c.deleted_on is null and c.group_crag_id is null and c.latitude is null and c.longitude is null order by coalesce(cc.cnt_climbs, 0) desc ,c.crag_name
Diff
--- before

+++ after

@@ -1,6 +1,7 @@

select
'<a href="' || c.url || '">' || c.crag_name || '</a>' as Crag
,coalesce(cc.cnt_climbs, 0) as Climbs
+ ,country.country as Country
,case
when c.ukc_url is not null then '<a href="' || c.ukc_url || '">UKC</a>'
else null
@@ -38,6 +39,25 @@

left join (
select
cm.crag_id
+ ,max(co.name) as country
+
+ from
+ crag_meta cm
+ inner join crag_meta_keys cmk
+ on cm.crag_meta_key_id = cmk.crag_meta_key_id
+ inner join countries co
+ on cm.value = co.country_id::varchar
+
+ where
+ cmk.key = 'Country'
+
+ group by
+ cm.crag_id
+ ) country
+ on country.crag_id = c.crag_id
+ left join (
+ select
+ cm.crag_id
,max(case when cm.value ilike '%thecrag.com%' then cm.value end) as thecrag_url
,max(
case
1194 16th May 2026 13:46:09 UTC baz9 crag Entrechaux latitude
Before
None
After
44.235089
1195 16th May 2026 13:46:09 UTC baz9 crag Entrechaux longitude
Before
None
After
5.142661
1196 16th May 2026 13:42:52 UTC baz9 list Crags Without Coordinates list_description_pretty
Before
<p>This is a list of crags that have no location coordinates. </p> <p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p> <p>I have created another list of crags without Coordinates OR Country meta, here: </p> <table> <thead> <tr> <th>crag</th> <th>climbs</th> <th>ukc</th> <th>8a.nu</th> <th>theCrag</th> <th>27crags</th> </tr> </thead> <tbody> <tr> <td><a href="/crag/34273/entrechaux" rel="noopener noreferrer">Entrechaux</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/entrechaux-21022" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34283/grotti" rel="noopener noreferrer">Grotti</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/grotti-18041" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34293/jogasaki" rel="noopener noreferrer">Jogasaki</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/jogasaki-27229/" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34297/mill-creek-ut-moab-area" rel="noopener noreferrer">Mill Creek Ut Moab Area</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/mill_creek_ut_moab_area-30314" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34339/öreg-lyuk" rel="noopener noreferrer">Öreg-lyuk</a></td> <td>1</td> <td>None</td> <td><a href="https://www.8a.nu/crags/bouldering/hungary/oereg-lyuk/routes" rel="noopener noreferrer">8a.nu</a></td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34306/riverside-guangxi" rel="noopener noreferrer">Riverside Guangxi</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/riverside_guangxi-18521" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34279/secret-spot" rel="noopener noreferrer">Secret Spot</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/secret_spot-29113" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34292/silver-lake" rel="noopener noreferrer">Silver Lake</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/silver_lake-31107" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/1580/staple-edge-quarry-ruspidge-west-quarry" rel="noopener noreferrer">Staple Edge Quarry Ruspidge West Quarry</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/staple_edge_quarry_ruspidge_west_quarry-1580" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/881/third-sister-to-zulu-zawn" rel="noopener noreferrer">Third Sister To Zulu Zawn</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/third_sister_to_zulu_zawn-881" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34296/thompsons-point" rel="noopener noreferrer">Thompsons Point</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/thompsons_point-3462" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/26482/uig-sea-cliffs-north---crowlista" rel="noopener noreferrer">Uig Sea Cliffs North - Crowlista</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/uig_sea_cliffs_north_-_crowlista-26482" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/512/zawn-kellys-area" rel="noopener noreferrer">Zawn Kellys Area</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/zawn_kellys_area-512" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> </tbody> </table>
After
<p>This is a list of crags that have no location coordinates. </p> <p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p> <p>I have created another list of crags without Coordinates OR Country meta, here: <a href="/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">/list/115/crags-without-coordinates-or-country-meta</a></p>
1197 16th May 2026 13:42:52 UTC baz9 list Crags Without Coordinates list_description
Before
This is a list of crags that have no location coordinates. Some crags in this list have secret locations so we have added a broad 'country' meta. I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
After
This is a list of crags that have no location coordinates. Some crags in this list have secret locations so we have added a broad 'country' meta. I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
Diff
--- before

+++ after

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


Some crags in this list have secret locations so we have added a broad 'country' meta.

-I have created another list of crags without Coordinates OR Country meta, here:
-
-[/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
+I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
1198 16th May 2026 13:40:24 UTC baz9 list Crags Without Coordinates list_description
Before
This is a list of crags that have no location coordinates. Some crags in this list have secret locations so we have added a broad 'country' meta. I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
After
This is a list of crags that have no location coordinates. Some crags in this list have secret locations so we have added a broad 'country' meta. I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
Diff
--- before

+++ after

@@ -3,4 +3,5 @@

Some crags in this list have secret locations so we have added a broad 'country' meta.

I have created another list of crags without Coordinates OR Country meta, here:
+
[/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
1199 16th May 2026 13:40:24 UTC baz9 list Crags Without Coordinates list_description_pretty
Before
<p>This is a list of crags that have no location coordinates. </p> <p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p> <p>I have created another list of crags without Coordinates OR Country meta, here: crag | climbs | ukc | 8a.nu | theCrag | 27crags ---- | ------ | --- | ----- | ------- | ------- <a href="/crag/34273/entrechaux" rel="noopener noreferrer">Entrechaux</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/entrechaux-21022" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/34283/grotti" rel="noopener noreferrer">Grotti</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/grotti-18041" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/34293/jogasaki" rel="noopener noreferrer">Jogasaki</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/jogasaki-27229/" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/34297/mill-creek-ut-moab-area" rel="noopener noreferrer">Mill Creek Ut Moab Area</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/mill_creek_ut_moab_area-30314" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/34339/öreg-lyuk" rel="noopener noreferrer">Öreg-lyuk</a> | 1 | None | <a href="https://www.8a.nu/crags/bouldering/hungary/oereg-lyuk/routes" rel="noopener noreferrer">8a.nu</a> | None | None <a href="/crag/34306/riverside-guangxi" rel="noopener noreferrer">Riverside Guangxi</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/riverside_guangxi-18521" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/34279/secret-spot" rel="noopener noreferrer">Secret Spot</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/secret_spot-29113" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/34292/silver-lake" rel="noopener noreferrer">Silver Lake</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/silver_lake-31107" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/1580/staple-edge-quarry-ruspidge-west-quarry" rel="noopener noreferrer">Staple Edge Quarry Ruspidge West Quarry</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/staple_edge_quarry_ruspidge_west_quarry-1580" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/881/third-sister-to-zulu-zawn" rel="noopener noreferrer">Third Sister To Zulu Zawn</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/third_sister_to_zulu_zawn-881" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/34296/thompsons-point" rel="noopener noreferrer">Thompsons Point</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/thompsons_point-3462" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/26482/uig-sea-cliffs-north---crowlista" rel="noopener noreferrer">Uig Sea Cliffs North - Crowlista</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/uig_sea_cliffs_north_-_crowlista-26482" rel="noopener noreferrer">UKC</a> | None | None | None <a href="/crag/512/zawn-kellys-area" rel="noopener noreferrer">Zawn Kellys Area</a> | 1 | <a href="https://www.ukclimbing.com/logbook/crags/zawn_kellys_area-512" rel="noopener noreferrer">UKC</a> | None | None | None</p>
After
<p>This is a list of crags that have no location coordinates. </p> <p>Some crags in this list have secret locations so we have added a broad 'country' meta. </p> <p>I have created another list of crags without Coordinates OR Country meta, here: </p> <table> <thead> <tr> <th>crag</th> <th>climbs</th> <th>ukc</th> <th>8a.nu</th> <th>theCrag</th> <th>27crags</th> </tr> </thead> <tbody> <tr> <td><a href="/crag/34273/entrechaux" rel="noopener noreferrer">Entrechaux</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/entrechaux-21022" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34283/grotti" rel="noopener noreferrer">Grotti</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/grotti-18041" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34293/jogasaki" rel="noopener noreferrer">Jogasaki</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/jogasaki-27229/" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34297/mill-creek-ut-moab-area" rel="noopener noreferrer">Mill Creek Ut Moab Area</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/mill_creek_ut_moab_area-30314" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34339/öreg-lyuk" rel="noopener noreferrer">Öreg-lyuk</a></td> <td>1</td> <td>None</td> <td><a href="https://www.8a.nu/crags/bouldering/hungary/oereg-lyuk/routes" rel="noopener noreferrer">8a.nu</a></td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34306/riverside-guangxi" rel="noopener noreferrer">Riverside Guangxi</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/riverside_guangxi-18521" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34279/secret-spot" rel="noopener noreferrer">Secret Spot</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/secret_spot-29113" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34292/silver-lake" rel="noopener noreferrer">Silver Lake</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/silver_lake-31107" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/1580/staple-edge-quarry-ruspidge-west-quarry" rel="noopener noreferrer">Staple Edge Quarry Ruspidge West Quarry</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/staple_edge_quarry_ruspidge_west_quarry-1580" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/881/third-sister-to-zulu-zawn" rel="noopener noreferrer">Third Sister To Zulu Zawn</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/third_sister_to_zulu_zawn-881" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/34296/thompsons-point" rel="noopener noreferrer">Thompsons Point</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/thompsons_point-3462" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/26482/uig-sea-cliffs-north---crowlista" rel="noopener noreferrer">Uig Sea Cliffs North - Crowlista</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/uig_sea_cliffs_north_-_crowlista-26482" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> <tr> <td><a href="/crag/512/zawn-kellys-area" rel="noopener noreferrer">Zawn Kellys Area</a></td> <td>1</td> <td><a href="https://www.ukclimbing.com/logbook/crags/zawn_kellys_area-512" rel="noopener noreferrer">UKC</a></td> <td>None</td> <td>None</td> <td>None</td> </tr> </tbody> </table>
1200 16th May 2026 13:39:14 UTC baz9 list Crags Without Coordinates list_description
Before
This is a list of crags that have no location coordinates. Some crags in this list have secret locations so we have added a broad 'country' meta. I have created another list of crags without Coordinates OR Country meta, here: [https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta](https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta)
After
This is a list of crags that have no location coordinates. Some crags in this list have secret locations so we have added a broad 'country' meta. I have created another list of crags without Coordinates OR Country meta, here: [/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)
Diff
--- before

+++ after

@@ -3,4 +3,4 @@

Some crags in this list have secret locations so we have added a broad 'country' meta.

I have created another list of crags without Coordinates OR Country meta, here:
-[https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta](https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta)
+[/list/115/crags-without-coordinates-or-country-meta](/list/115/crags-without-coordinates-or-country-meta)

< Page 60 >