| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 21 | 30th July 2024 | 15:15:14 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762, 3687)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762, 3687)
group by
c.climb_id
|
|||||||
| 22 | 30th July 2024 | 15:14:23 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762)
group by
c.climb_id
|
|||||||
| 23 | 30th July 2024 | 15:13:54 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686)
group by
c.climb_id
|
|||||||
| 24 | 30th July 2024 | 15:13:00 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373)
group by
c.climb_id
|
|||||||
| 25 | 30th July 2024 | 15:11:58 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043)
group by
c.climb_id
|
|||||||
| 26 | 30th July 2024 | 14:38:15 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685)
group by
c.climb_id
|
|||||||
| 27 | 30th July 2024 | 14:36:11 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136)
group by
c.climb_id
|
|||||||
| 28 | 30th July 2024 | 14:34:35 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684)
group by
c.climb_id
|
|||||||
| 29 | 30th July 2024 | 14:32:19 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683)
group by
c.climb_id
|
|||||||
| 30 | 30th July 2024 | 14:29:57 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384)
group by
c.climb_id
|
|||||||
| 31 | 29th July 2024 | 20:05:35 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681)
group by
c.climb_id
|
|||||||
| 32 | 29th July 2024 | 20:03:26 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678, 3679)
group by
c.climb_id
|
|||||||
| 33 | 29th July 2024 | 20:02:14 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677, 3678)
group by
c.climb_id
|
|||||||
| 34 | 29th July 2024 | 20:00:35 | remus | - | - | list_description | |
|
Before
Hard Rock is a coffee table book compiled by [Ken Wilson](/climber/1012/ken-wilson) with individual articles from many notable climbers discussing high quality trad routes across Great Britain.
First published in 1974, it has since had several reprints.
After
Hard Rock is a coffee table book compiled by [Ken Wilson](/climber/1012/ken-wilson) with individual articles from many notable climbers discussing high quality trad routes across Great Britain.
First published in 1974, it has since had several reprints.
### References
[1] [https://www.google.co.uk/books/edition/_/h6rxAAAACAAJ](https://www.google.co.uk/books/edition/_/h6rxAAAACAAJ)
Diff
--- before
+++ after
@@ -1,3 +1,7 @@
Hard Rock is a coffee table book compiled by [Ken Wilson](/climber/1012/ken-wilson) with individual articles from many notable climbers discussing high quality trad routes across Great Britain.
-First published in 1974, it has since had several reprints.
+First published in 1974, it has since had several reprints.
+
+### References
+
+[1] [https://www.google.co.uk/books/edition/_/h6rxAAAACAAJ](https://www.google.co.uk/books/edition/_/h6rxAAAACAAJ)
|
|||||||
| 35 | 29th July 2024 | 20:00:35 | remus | - | - | list_description_pretty | |
|
Before
<p>Hard Rock is a coffee table book compiled by <a href="/climber/1012/ken-wilson">Ken Wilson</a> with individual articles from many notable climbers discussing high quality trad routes across Great Britain.</p>
<p>First published in 1974, it has since had several reprints.</p>
After
<p>Hard Rock is a coffee table book compiled by <a href="/climber/1012/ken-wilson">Ken Wilson</a> with individual articles from many notable climbers discussing high quality trad routes across Great Britain.</p>
<p>First published in 1974, it has since had several reprints.</p>
<h3>References</h3>
<p>[1] <a href="https://www.google.co.uk/books/edition/_/h6rxAAAACAAJ">https://www.google.co.uk/books/edition/_/h6rxAAAACAAJ</a></p>
|
|||||||
| 36 | 29th July 2024 | 19:58:58 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676, 3677)
group by
c.climb_id
|
|||||||
| 37 | 29th July 2024 | 19:52:22 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669, 3674, 3675, 3676)
group by
c.climb_id
|
|||||||
| 38 | 29th July 2024 | 15:14:29 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668, 3669)
group by
c.climb_id
|
|||||||
| 39 | 29th July 2024 | 15:10:50 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667, 3668)
group by
c.climb_id
|
|||||||
| 40 | 29th July 2024 | 15:08:18 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
After
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_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
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.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
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,c.climb_name
Diff
--- before
+++ after
@@ -20,7 +20,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435, 3667)
group by
c.climb_id
|
|||||||