| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 3rd January 2025 | 18:23:52 | Mattsparksy | - | - | hidden | |
|
Before
true
After
false
|
|||||||
| 2 | 2nd January 2025 | 14:00:04 | Mattsparksy | - | - | public | |
|
Before
false
After
true
|
|||||||
| 3 | 2nd January 2025 | 13:59:57 | Mattsparksy | - | - | public | |
|
Before
true
After
false
|
|||||||
| 4 | 1st January 2025 | 19:47:30 | remus | - | - | list_description_pretty | |
|
Before
None
After
<p>A list of all boulder problems 8B or harder on gritstone, a coarse-grained sandstone primarily found in the Pennines in the UK.</p>
|
|||||||
| 5 | 1st January 2025 | 19:47:30 | remus | - | - | list_definition | |
|
Before
None
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
,g.grade as Grade
,'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
inner join crags cr
on c.ukc_crag_id = cr.crag_id
inner join rock_types rt
on cr.rock_type_id = rt.rock_type_id
left join ascents a
on a.climb_id = c.climb_id
and a.fa = true
and a.deleted_on is null
left join climbers cl
on a.climber_id = cl.climber_id
where
rt.rock_type = 'Gritstone'
and c.climb_type_id = 2
and c.deleted_on is null
and g.order_on >= 39
order by
g.order_on desc
,order_dt(a.ascent_dt_start, a.ascent_dt_end)
Diff
--- before
+++ after
@@ -1 +1,30 @@
-
+select
+ '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb
+ ,g.grade as Grade
+ ,'<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' || ', ' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent"
+
+from
+ climbs c
+ inner join grades g
+ on c.grade_id = g.grade_id
+ inner join crags cr
+ on c.ukc_crag_id = cr.crag_id
+ inner join rock_types rt
+ on cr.rock_type_id = rt.rock_type_id
+ left join ascents a
+ on a.climb_id = c.climb_id
+ and a.fa = true
+ and a.deleted_on is null
+ left join climbers cl
+ on a.climber_id = cl.climber_id
+
+where
+ rt.rock_type = 'Gritstone'
+ and c.climb_type_id = 2
+ and c.deleted_on is null
+ and g.order_on >= 39
+
+order by
+ g.order_on desc
+ ,order_dt(a.ascent_dt_start, a.ascent_dt_end)
+
|
|||||||
| 6 | 1st January 2025 | 19:47:30 | remus | - | - | list_type_name | |
|
Before
None
After
Bouldering
|
|||||||
| 7 | 1st January 2025 | 19:47:30 | remus | - | - | list_name | |
|
Before
None
After
The Hardest Boulder Problems on Gritstone
|
|||||||
| 8 | 1st January 2025 | 19:47:30 | remus | - | - | list_description | |
|
Before
None
After
A list of all boulder problems 8B or harder on gritstone, a coarse-grained sandstone primarily found in the Pennines in the UK.
Diff
--- before
+++ after
@@ -1 +1 @@
-
+A list of all boulder problems 8B or harder on gritstone, a coarse-grained sandstone primarily found in the Pennines in the UK.
|
|||||||
| 9 | 1st January 2025 | 19:47:30 | remus | - | - | list_type_id | |
|
Before
None
After
1
|
|||||||
| 10 | 1st January 2025 | 19:47:30 | remus | - | - | hidden | |
|
Before
false
After
true
|
|||||||