| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | USA | 1526 | 20th November 2025 – 4th November 2026 | 48 | 20 | 0 | 88 | 98 |
| 2 | Australia | 767 | 27th September 2025 – 29th June 2026 | 6 | 38 | 0 | 61 | 33 |
| 3 | United Kingdom | 625 | 19th November 2025 – 4th November 2026 | 34 | 14 | 0 | 24 | 49 |
| 4 | Switzerland | 308 | 24th January 2026 – 4th November 2026 | 6 | 3 | 0 | 14 | 38 |
| 5 | France | 300 | 6th January 2026 – 4th November 2026 | 15 | 3 | 0 | 12 | 34 |
| 6 | Austria | 210 | 12th November 2025 – 22nd June 2026 | 5 | 2 | 0 | 8 | 22 |
| 7 | Italy | 163 | 18th November 2025 – 2nd November 2026 | 9 | 3 | 0 | 12 | 12 |
| 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 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1521 | 16th May 2026 | 13:46:09 UTC | ben_sandi | crag | Entrechaux | latitude | |
|
Before
None
After
44.235089
|
|||||||
| 1522 | 16th May 2026 | 13:42:52 UTC | ben_sandi | 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>
|
|||||||
| 1523 | 16th May 2026 | 13:42:52 UTC | ben_sandi | 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
|
|||||||
| 1524 | 16th May 2026 | 13:40:24 UTC | ben_sandi | 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>
|
|||||||
| 1525 | 16th May 2026 | 13:40:24 UTC | ben_sandi | 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
|
|||||||
| 1526 | 16th May 2026 | 13:39:14 UTC | ben_sandi | 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="https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">https://climbing-history.org/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>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>
|
|||||||
| 1527 | 16th May 2026 | 13:39:14 UTC | ben_sandi | 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
|
|||||||
| 1528 | 16th May 2026 | 13:38:52 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_description_pretty | |
|
Before
<p>This is a list of crags that have no location coordinates OR country meta.</p>
<p>We also have: <a href="https://climbing-history.org/list/106/crags-without-coordinates" rel="noopener noreferrer">https://climbing-history.org/list/106/crags-without-coordinates</a></p>
After
<p>This is a list of crags that have no location coordinates OR country meta.</p>
<p>We also have: <a href="/list/106/crags-without-coordinates" rel="noopener noreferrer">/list/106/crags-without-coordinates</a></p>
|
|||||||
| 1529 | 16th May 2026 | 13:38:52 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_description | |
|
Before
This is a list of crags that have no location coordinates OR country meta.
We also have: [https://climbing-history.org/list/106/crags-without-coordinates](https://climbing-history.org/list/106/crags-without-coordinates)
After
This is a list of crags that have no location coordinates OR country meta.
We also have: [/list/106/crags-without-coordinates](/list/106/crags-without-coordinates)
Diff
--- before
|
|||||||
| 1530 | 16th May 2026 | 13:38:20 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_description_pretty | |
|
Before
<p>This is a list of crags that have no location coordinates OR country meta.</p>
After
<p>This is a list of crags that have no location coordinates OR country meta.</p>
<p>We also have: <a href="https://climbing-history.org/list/106/crags-without-coordinates" rel="noopener noreferrer">https://climbing-history.org/list/106/crags-without-coordinates</a></p>
|
|||||||
| 1531 | 16th May 2026 | 13:38:20 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_description | |
|
Before
This is a list of crags that have no location coordinates OR country meta.
After
This is a list of crags that have no location coordinates OR country meta.
We also have: [https://climbing-history.org/list/106/crags-without-coordinates](https://climbing-history.org/list/106/crags-without-coordinates)
Diff
--- before
|
|||||||
| 1532 | 16th May 2026 | 13:37:40 UTC | ben_sandi | list | Crags Without Coordinates | list_description_pretty | |
|
Before
<p>This is a list of crags that have no location coordinates. </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:
<a href="https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta" rel="noopener noreferrer">https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta</a></p>
|
|||||||
| 1533 | 16th May 2026 | 13:37:40 UTC | ben_sandi | list | Crags Without Coordinates | list_description | |
|
Before
This is a list of crags that have no location coordinates.
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:
[https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta](https://climbing-history.org/list/115/crags-without-coordinates-or-country-meta)
Diff
--- before
|
|||||||
| 1534 | 16th May 2026 | 13:34:38 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_type_name | |
|
Before
None
After
Admin
|
|||||||
| 1535 | 16th May 2026 | 13:34:38 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_type_id | |
|
Before
None
After
6
|
|||||||
| 1536 | 16th May 2026 | 13:34:38 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_description_pretty | |
|
Before
None
After
<p>This is a list of crags that have no location coordinates OR country meta.</p>
|
|||||||
| 1537 | 16th May 2026 | 13:34:38 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_definition | |
|
Before
None
After
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
and not exists (
select
1
from
crag_meta cm_country
where
cm_country.crag_id = c.crag_id
and cm_country.crag_meta_key_id = 6
)
order by
coalesce(cc.cnt_climbs, 0) desc
,c.crag_name
Diff
--- before
|
|||||||
| 1538 | 16th May 2026 | 13:34:38 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_description | |
|
Before
None
After
This is a list of crags that have no location coordinates OR country meta.
Diff
--- before
|
|||||||
| 1539 | 16th May 2026 | 13:34:38 UTC | ben_sandi | list | Crags Without Coordinates OR Country Meta | list_name | |
|
Before
None
After
Crags Without Coordinates OR Country Meta
|
|||||||
| 1540 | 16th May 2026 | 13:33:27 UTC | ben_sandi | 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
and not exists (
select
1
from
crag_meta cm_country
where
cm_country.crag_id = c.crag_id
and cm_country.crag_meta_key_id = 6
)
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
,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
Diff
--- before
|
|||||||