| Name | Type | # Changes | Last Updated | First Updated | |
|---|---|---|---|---|---|
| 1 | https://www.youtube.com/watch?v=kpbCmJGkKHE | media | 108 | 14th July 2024 | 14th July 2024 |
| 2 | https://www.instagram.com/p/DF5XgLjMdJu/ | media | 69 | 23rd April 2025 | 10th February 2025 |
| 3 | Hard Rock | list | 67 | 19th August 2025 | 27th July 2024 |
| 4 | https://www.instagram.com/p/DGD2HHVM4yn/ | media | 60 | 23rd April 2025 | 14th February 2025 |
| 5 | https://open.spotify.com/episode/0cHKL3jWvp8A4QcZ1LS0YM | media | 51 | 6th October 2024 | 10th April 2024 |
| 6 | https://www.instagram.com/p/BcX-gR8llwj/ | media | 48 | 23rd January 2026 | 24th January 2024 |
| 7 | Mountain 132 | library item | 46 | 13th January 2026 | 16th October 2025 |
| 8 | None | None | 46 | 4th October 2025 | 6th March 2025 |
| 9 | https://www.instagram.com/p/C09aKQQtBaT/ | media | 42 | 18th September 2025 | 17th December 2023 |
| 10 | Mountain 131 | library item | 41 | 13th January 2026 | 16th October 2025 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 29th January 2026 | 15:05:51 | remus | list | The Grit List V2 | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/' || replace(lower(c.climb_name), ' ', '-') || '">' || c.climb_name || '</a>' as "Climb"
,'<a href="/crag/' || coalesce(cr2.crag_id, cr.crag_id)::varchar || '/' || replace(lower(coalesce(cr2.crag_name, cr.crag_name)), ' ', '-') || '">' || coalesce(cr2.crag_name, cr.crag_name) || '</a>' as "Crag"
,case
when c.grade_approx then g.grade || ' (approx)'
else
g.grade
end as "Grade"
,case
when g2.grade is not null then '~' || g2.grade || ' ' || lower(ct.climb_type)
else
null
end as "Alternative Grade"
,case
when cm1.value is not null then '✓'
else
null
end as Project
,case
when pretty_dt(a.ascent_dt_start, a.ascent_dt_end) is not null then
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
else
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>'
end as "FA"
,c.notes_pretty as Notes
from
climbs c
inner join crags cr
on c.ukc_crag_id = cr.crag_id
and c.deleted_on is null
left join crags cr2
on cr.group_crag_id = cr2.crag_id
inner join grades g
on c.grade_id = g.grade_id
left join climb_meta cm1
on c.climb_id = cm1.climb_id
and cm1.climb_meta_key_id = 20 -- project
left join climb_meta cm2
on cm2.climb_id = c.climb_id
and cm2.climb_meta_key_id = 9
left join grades g2
on g2.grade_id = cm2.value::int
left join climb_types ct
on g2.climb_type_id = ct.climb_type_id
left join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = true
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
coalesce(cr.rock_type_id, cr2.rock_type_id) = 6 -- grit
and c.climb_type_id = 3 -- trad
and g.order_on >= 60
and not cr.crag_id = 845
order by
case when cm1.climb_id is not null then 1 else 0 end desc -- project
,g.order_on desc
,g2.order_on
After
select
'<a href="/climb/' || c.climb_id::varchar || '/' || replace(lower(c.climb_name), ' ', '-') || '">' || c.climb_name || '</a>' as "Climb"
,'<a href="/crag/' || coalesce(cr2.crag_id, cr.crag_id)::varchar || '/' || replace(lower(coalesce(cr2.crag_name, cr.crag_name)), ' ', '-') || '">' || coalesce(cr2.crag_name, cr.crag_name) || '</a>' as "Crag"
,case
when c.grade_approx then g.grade || ' (approx)'
else
g.grade
end as "Grade"
,case
when g2.grade is not null then '~' || g2.grade || ' ' || lower(ct.climb_type)
else
null
end as "Alternative Grade"
,case
when cm1.value is not null then 'Project'
when pretty_dt(a.ascent_dt_start, a.ascent_dt_end) is not null then
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
else
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>'
end as "FA"
,c.notes_pretty as Notes
from
climbs c
inner join crags cr
on c.ukc_crag_id = cr.crag_id
and c.deleted_on is null
left join crags cr2
on cr.group_crag_id = cr2.crag_id
inner join grades g
on c.grade_id = g.grade_id
left join climb_meta cm1
on c.climb_id = cm1.climb_id
and cm1.climb_meta_key_id = 20 -- project
left join climb_meta cm2
on cm2.climb_id = c.climb_id
and cm2.climb_meta_key_id = 9
left join grades g2
on g2.grade_id = cm2.value::int
left join climb_types ct
on g2.climb_type_id = ct.climb_type_id
left join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = true
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
coalesce(cr.rock_type_id, cr2.rock_type_id) = 6 -- grit
and c.climb_type_id = 3 -- trad
and g.order_on >= 60
and not cr.crag_id = 845
order by
case when cm1.climb_id is not null then 1 else 0 end desc -- project
,g.order_on desc
,g2.order_on
Diff
--- before
|
|||||||
| 2 | 29th January 2026 | 15:04:31 | remus | list | The Grit List V2 | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/' || replace(lower(c.climb_name), ' ', '-') || '">' || c.climb_name || '</a>' as "Name"
,case
when c.grade_approx then g.grade || ' (approx)'
else
g.grade
end as "Grade"
,case
when g2.grade is not null then '~' || g2.grade || ' ' || lower(ct.climb_type)
else
null
end as "Alternative Grade"
,case
when cm1.value is not null then '✓'
else
null
end as Project
,case
when pretty_dt(a.ascent_dt_start, a.ascent_dt_end) is not null then
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
else
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>'
end as "FA"
,c.notes_pretty as Notes
from
climbs c
inner join crags cr
on c.ukc_crag_id = cr.crag_id
and c.deleted_on is null
left join crags cr2
on cr.group_crag_id = cr2.crag_id
inner join grades g
on c.grade_id = g.grade_id
left join climb_meta cm1
on c.climb_id = cm1.climb_id
and cm1.climb_meta_key_id = 20 -- project
left join climb_meta cm2
on cm2.climb_id = c.climb_id
and cm2.climb_meta_key_id = 9
left join grades g2
on g2.grade_id = cm2.value::int
left join climb_types ct
on g2.climb_type_id = ct.climb_type_id
left join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = true
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
coalesce(cr.rock_type_id, cr2.rock_type_id) = 6 -- grit
and c.climb_type_id = 3 -- trad
and g.order_on >= 60
and not cr.crag_id = 845
order by
case when cm1.climb_id is not null then 1 else 0 end desc -- project
,g.order_on desc
,g2.order_on
After
select
'<a href="/climb/' || c.climb_id::varchar || '/' || replace(lower(c.climb_name), ' ', '-') || '">' || c.climb_name || '</a>' as "Climb"
,'<a href="/crag/' || coalesce(cr2.crag_id, cr.crag_id)::varchar || '/' || replace(lower(coalesce(cr2.crag_name, cr.crag_name)), ' ', '-') || '">' || coalesce(cr2.crag_name, cr.crag_name) || '</a>' as "Crag"
,case
when c.grade_approx then g.grade || ' (approx)'
else
g.grade
end as "Grade"
,case
when g2.grade is not null then '~' || g2.grade || ' ' || lower(ct.climb_type)
else
null
end as "Alternative Grade"
,case
when cm1.value is not null then '✓'
else
null
end as Project
,case
when pretty_dt(a.ascent_dt_start, a.ascent_dt_end) is not null then
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
else
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>'
end as "FA"
,c.notes_pretty as Notes
from
climbs c
inner join crags cr
on c.ukc_crag_id = cr.crag_id
and c.deleted_on is null
left join crags cr2
on cr.group_crag_id = cr2.crag_id
inner join grades g
on c.grade_id = g.grade_id
left join climb_meta cm1
on c.climb_id = cm1.climb_id
and cm1.climb_meta_key_id = 20 -- project
left join climb_meta cm2
on cm2.climb_id = c.climb_id
and cm2.climb_meta_key_id = 9
left join grades g2
on g2.grade_id = cm2.value::int
left join climb_types ct
on g2.climb_type_id = ct.climb_type_id
left join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = true
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
coalesce(cr.rock_type_id, cr2.rock_type_id) = 6 -- grit
and c.climb_type_id = 3 -- trad
and g.order_on >= 60
and not cr.crag_id = 845
order by
case when cm1.climb_id is not null then 1 else 0 end desc -- project
,g.order_on desc
,g2.order_on
Diff
--- before
|
|||||||
| 3 | 29th January 2026 | 15:02:14 | remus | list | The Grit List V2 | list_description_pretty | |
|
Before
<p>This is a refreshed version of <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">The Grit List</a>. In the words the list's creator Jonathan Read</p>
<blockquote>
<p>This is a compendium of selected hard grit routes (E5 and above [ed. now E7]) catagorised by difficulty, boldness, tricksomeness and absurdity.</p>
<p>The aim of this list is to provide further information on these routes for the on-sighter (such as crucial or trick gear), and to highlight particularly soft and hard routes within a grade. Also included are relatively new routes that haven't made it into guidebooks yet.</p>
<p>Routes at the top of a catagory listing tend to be a soft touch for the grade, and routes at the bottom of a catagory list outright sandbags! Liberal pinches of salt should be taken daily.</p>
<p>On the harder grades, routes with a recognised toprope French grade have this included, and some have guesstimates just to spice up debate!</p>
</blockquote>
<p>This list is a bit more clinical than the original but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.</p>
<blockquote>
<p>Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html</a></p>
After
<p>This is a refreshed version of <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">The Grit List</a>. In the words the list's creator <a href="/climber/1146/jon-read" rel="noopener noreferrer">Jon Read</a>:</p>
<blockquote>
<p>This is a compendium of selected hard grit routes (E5 and above [ed. now E7]) catagorised by difficulty, boldness, tricksomeness and absurdity.</p>
<p>The aim of this list is to provide further information on these routes for the on-sighter (such as crucial or trick gear), and to highlight particularly soft and hard routes within a grade. Also included are relatively new routes that haven't made it into guidebooks yet.</p>
<p>Routes at the top of a catagory listing tend to be a soft touch for the grade, and routes at the bottom of a catagory list outright sandbags! Liberal pinches of salt should be taken daily.</p>
<p>On the harder grades, routes with a recognised toprope French grade have this included, and some have guesstimates just to spice up debate!</p>
</blockquote>
<p>This list is a bit more clinical than the original but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.</p>
<blockquote>
<p>Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html</a></p>
|
|||||||
| 4 | 29th January 2026 | 15:02:14 | remus | list | The Grit List V2 | list_description | |
|
Before
This is a refreshed version of [The Grit List](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html). In the words the list's creator Jonathan Read
> This is a compendium of selected hard grit routes (E5 and above [ed. now E7]) catagorised by difficulty, boldness, tricksomeness and absurdity.
> The aim of this list is to provide further information on these routes for the on-sighter (such as crucial or trick gear), and to highlight particularly soft and hard routes within a grade. Also included are relatively new routes that haven't made it into guidebooks yet.
> Routes at the top of a catagory listing tend to be a soft touch for the grade, and routes at the bottom of a catagory list outright sandbags! Liberal pinches of salt should be taken daily.
> On the harder grades, routes with a recognised toprope French grade have this included, and some have guesstimates just to spice up debate!
This list is a bit more clinical than the original but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.
> Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...
### References
[1] [https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html)
After
This is a refreshed version of [The Grit List](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html). In the words the list's creator [Jon Read](/climber/1146/jon-read):
> This is a compendium of selected hard grit routes (E5 and above [ed. now E7]) catagorised by difficulty, boldness, tricksomeness and absurdity.
> The aim of this list is to provide further information on these routes for the on-sighter (such as crucial or trick gear), and to highlight particularly soft and hard routes within a grade. Also included are relatively new routes that haven't made it into guidebooks yet.
> Routes at the top of a catagory listing tend to be a soft touch for the grade, and routes at the bottom of a catagory list outright sandbags! Liberal pinches of salt should be taken daily.
> On the harder grades, routes with a recognised toprope French grade have this included, and some have guesstimates just to spice up debate!
This list is a bit more clinical than the original but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.
> Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...
### References
[1] [https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html)
Diff
--- before
|
|||||||
| 5 | 29th January 2026 | 15:00:28 | remus | list | The Grit List V2 | list_description_pretty | |
|
Before
<p>This is a refreshed version of <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">The Grit List</a>. It's a bit more clinical, but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.</p>
<blockquote>
<p>Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html</a></p>
After
<p>This is a refreshed version of <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">The Grit List</a>. In the words the list's creator Jonathan Read</p>
<blockquote>
<p>This is a compendium of selected hard grit routes (E5 and above [ed. now E7]) catagorised by difficulty, boldness, tricksomeness and absurdity.</p>
<p>The aim of this list is to provide further information on these routes for the on-sighter (such as crucial or trick gear), and to highlight particularly soft and hard routes within a grade. Also included are relatively new routes that haven't made it into guidebooks yet.</p>
<p>Routes at the top of a catagory listing tend to be a soft touch for the grade, and routes at the bottom of a catagory list outright sandbags! Liberal pinches of salt should be taken daily.</p>
<p>On the harder grades, routes with a recognised toprope French grade have this included, and some have guesstimates just to spice up debate!</p>
</blockquote>
<p>This list is a bit more clinical than the original but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.</p>
<blockquote>
<p>Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html" rel="noopener noreferrer">https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html</a></p>
|
|||||||
| 6 | 29th January 2026 | 15:00:28 | remus | list | The Grit List V2 | list_description | |
|
Before
This is a refreshed version of [The Grit List](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html). It's a bit more clinical, but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.
> Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...
### References
[1] [https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html)
After
This is a refreshed version of [The Grit List](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html). In the words the list's creator Jonathan Read
> This is a compendium of selected hard grit routes (E5 and above [ed. now E7]) catagorised by difficulty, boldness, tricksomeness and absurdity.
> The aim of this list is to provide further information on these routes for the on-sighter (such as crucial or trick gear), and to highlight particularly soft and hard routes within a grade. Also included are relatively new routes that haven't made it into guidebooks yet.
> Routes at the top of a catagory listing tend to be a soft touch for the grade, and routes at the bottom of a catagory list outright sandbags! Liberal pinches of salt should be taken daily.
> On the harder grades, routes with a recognised toprope French grade have this included, and some have guesstimates just to spice up debate!
This list is a bit more clinical than the original but hopefully it captures some of the same spirit. For practicality this list only includes routes of E7 and up rather the the original list's E5 and up.
> Talent, power, stamina, bottle, technique, squeeky clean boots, 'unusual' gear, frontal lobotomy, belay slave, spotting circus, £1000 worth of Metolius mats. These are some of the requirements for potential suitors of Last Great Problems. Choose your line, spend a life-time getting good enough to do it, and then pull the crucial pebble off. All yours ...
### References
[1] [https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html](https://www.geocities.ws/readza1/climbing/gritlist/gritlist.html)
Diff
--- before
|
|||||||
| 7 | 29th January 2026 | 14:54:36 | remus | list | The Grit List V2 | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/' || replace(lower(c.climb_name), ' ', '-') || '">' || c.climb_name || '</a>' as "Name"
,case
when c.grade_approx then g.grade || ' (approx)'
else
g.grade
end as "Grade"
,case
when g2.grade is not null then '~' || g2.grade || ' ' || lower(ct.climb_type)
else
null
end as "Alternative Grade"
,case
when cm1.value is not null then '✓'
else
null
end as Project
,case
when pretty_dt(a.ascent_dt_start, a.ascent_dt_end) is not null then
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
else
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>'
end as "FA"
,c.notes_pretty as Notes
from
climbs c
inner join crags cr
on c.ukc_crag_id = cr.crag_id
and c.deleted_on is null
left join crags cr2
on cr.group_crag_id = cr2.crag_id
inner join grades g
on c.grade_id = g.grade_id
left join climb_meta cm1
on c.climb_id = cm1.climb_id
and cm1.climb_meta_key_id = 20 -- project
left join climb_meta cm2
on cm2.climb_id = c.climb_id
and cm2.climb_meta_key_id = 9
left join grades g2
on g2.grade_id = cm2.value::int
left join climb_types ct
on g2.climb_type_id = ct.climb_type_id
left join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = true
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
coalesce(cr.rock_type_id, cr2.rock_type_id) = 6 -- grit
and c.climb_type_id = 3 -- trad
and g.order_on >= 60
order by
case when cm1.climb_id is not null then 1 else 0 end desc -- project
,g.order_on desc
,g2.order_on
After
select
'<a href="/climb/' || c.climb_id::varchar || '/' || replace(lower(c.climb_name), ' ', '-') || '">' || c.climb_name || '</a>' as "Name"
,case
when c.grade_approx then g.grade || ' (approx)'
else
g.grade
end as "Grade"
,case
when g2.grade is not null then '~' || g2.grade || ' ' || lower(ct.climb_type)
else
null
end as "Alternative Grade"
,case
when cm1.value is not null then '✓'
else
null
end as Project
,case
when pretty_dt(a.ascent_dt_start, a.ascent_dt_end) is not null then
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>, ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end)
else
'<a href="/climber/' || cl.climber_id::varchar || '/' || replace(lower(cl.climber_name), ' ', '-') || '">' || cl.climber_name || '</a>'
end as "FA"
,c.notes_pretty as Notes
from
climbs c
inner join crags cr
on c.ukc_crag_id = cr.crag_id
and c.deleted_on is null
left join crags cr2
on cr.group_crag_id = cr2.crag_id
inner join grades g
on c.grade_id = g.grade_id
left join climb_meta cm1
on c.climb_id = cm1.climb_id
and cm1.climb_meta_key_id = 20 -- project
left join climb_meta cm2
on cm2.climb_id = c.climb_id
and cm2.climb_meta_key_id = 9
left join grades g2
on g2.grade_id = cm2.value::int
left join climb_types ct
on g2.climb_type_id = ct.climb_type_id
left join ascents a
on c.climb_id = a.climb_id
and a.deleted_on is null
and a.fa = true
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
coalesce(cr.rock_type_id, cr2.rock_type_id) = 6 -- grit
and c.climb_type_id = 3 -- trad
and g.order_on >= 60
and not cr.crag_id = 845
order by
case when cm1.climb_id is not null then 1 else 0 end desc -- project
,g.order_on desc
,g2.order_on
Diff
--- before
|
|||||||
| 8 | 29th January 2026 | 14:41:58 | remus | climber | Ken Nichols | notes | |
|
Before
Prolific and controversial Connecticut and [Shawangunks](/crag/8123/shawangunks) developer, guidebook writer, and staunch traditionalist.
> Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]
### References
[1] [https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849](https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849)
[2] *Climbing* magazine, June/July 1991
[3] [https://www.stopken.org/](https://www.stopken.org/)
After
Prolific and controversial Connecticut and [Shawangunks](/crag/8123/shawangunks) developer, guidebook writer, and staunch traditionalist.
> Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]
### References
[1] [https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849](https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849)
[2] *Climbing* magazine, June/July 1991
[3] [https://web.archive.org/web/20130223061856/http://www.stopken.org/Home.html](https://web.archive.org/web/20130223061856/http://www.stopken.org/Home.html)
Diff
--- before
|
|||||||
| 9 | 29th January 2026 | 14:41:58 | remus | climber | Ken Nichols | notes_pretty | |
|
Before
<p>Prolific and controversial Connecticut and <a href="/crag/8123/shawangunks" rel="noopener noreferrer">Shawangunks</a> developer, guidebook writer, and staunch traditionalist.</p>
<blockquote>
<p>Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849" rel="noopener noreferrer">https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849</a></p>
<p>[2] <em>Climbing</em> magazine, June/July 1991</p>
<p>[3] <a href="https://www.stopken.org/" rel="noopener noreferrer">https://www.stopken.org/</a></p>
After
<p>Prolific and controversial Connecticut and <a href="/crag/8123/shawangunks" rel="noopener noreferrer">Shawangunks</a> developer, guidebook writer, and staunch traditionalist.</p>
<blockquote>
<p>Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849" rel="noopener noreferrer">https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849</a></p>
<p>[2] <em>Climbing</em> magazine, June/July 1991</p>
<p>[3] <a href="https://web.archive.org/web/20130223061856/http://www.stopken.org/Home.html" rel="noopener noreferrer">https://web.archive.org/web/20130223061856/http://www.stopken.org/Home.html</a></p>
|
|||||||
| 10 | 29th January 2026 | 14:41:40 | remus | climber | Ken Nichols | notes_pretty | |
|
Before
<p>Prolific and controversial Connecticut and <a href="/crag/8123/shawangunks" rel="noopener noreferrer">Shawangunks</a> developer, guidebook writer, and staunch traditionalist.</p>
<blockquote>
<p>Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849" rel="noopener noreferrer">https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849</a></p>
<p>[2] <em>Climbing</em> magazine, June/July 1991</p>
After
<p>Prolific and controversial Connecticut and <a href="/crag/8123/shawangunks" rel="noopener noreferrer">Shawangunks</a> developer, guidebook writer, and staunch traditionalist.</p>
<blockquote>
<p>Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]</p>
</blockquote>
<h3>References</h3>
<p>[1] <a href="https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849" rel="noopener noreferrer">https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849</a></p>
<p>[2] <em>Climbing</em> magazine, June/July 1991</p>
<p>[3] <a href="https://www.stopken.org/" rel="noopener noreferrer">https://www.stopken.org/</a></p>
|
|||||||
| 11 | 29th January 2026 | 14:41:40 | remus | climber | Ken Nichols | notes | |
|
Before
Prolific and controversial Connecticut and [Shawangunks](/crag/8123/shawangunks) developer, guidebook writer, and staunch traditionalist.
> Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]
### References
[1] [https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849](https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849)
[2] *Climbing* magazine, June/July 1991
After
Prolific and controversial Connecticut and [Shawangunks](/crag/8123/shawangunks) developer, guidebook writer, and staunch traditionalist.
> Once I chop a route, it will remain chopped, no matter how many times I have to return to keep it that way. Until the bolting stops, apparently the cliffs will have to be destroyed to save them [2]
### References
[1] [https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849](https://www.ukclimbing.com/news/2007/07/us_bolt_chopper_banned_by_judge_from_chopping_bolts-38849)
[2] *Climbing* magazine, June/July 1991
[3] [https://www.stopken.org/](https://www.stopken.org/)
Diff
--- before
|
|||||||
| 12 | 29th January 2026 | 14:40:25 | remus | crag | East Peak | longitude | |
|
Before
None
After
-72.833862
|
|||||||
| 13 | 29th January 2026 | 14:40:25 | remus | crag | East Peak | rock_type | |
|
Before
None
After
Basalt
|
|||||||
| 14 | 29th January 2026 | 14:40:25 | remus | crag | East Peak | rock_type_id | |
|
Before
None
After
1
|
|||||||
| 15 | 29th January 2026 | 14:40:25 | remus | crag | East Peak | latitude | |
|
Before
None
After
41.557034
|
|||||||
| 16 | 29th January 2026 | 14:31:55 | remus | crag | Craig Ddu | latitude | |
|
Before
None
After
53.095607
|
|||||||
| 17 | 29th January 2026 | 14:31:55 | remus | crag | Craig Ddu | longitude | |
|
Before
None
After
-4.064205
|
|||||||
| 18 | 29th January 2026 | 14:30:43 | remus | ascent | Paul Pritchard's ascent of The Bog of the Eternal Stench | Ascent # | |
|
Before
None
After
1
|
|||||||
| 19 | 29th January 2026 | 14:30:42 | remus | ascent | Paul Pritchard's ascent of The Bog of the Eternal Stench | climb_id | |
|
Before
None
After
6965
|
|||||||
| 20 | 29th January 2026 | 14:30:42 | remus | ascent | Paul Pritchard's ascent of The Bog of the Eternal Stench | ascent_dt_end | |
|
Before
None
After
1987-04-29
|
|||||||