| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 1 | 31st July 2024 | 19:03:31 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647, 1664)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647, 1664)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
cr.location_breadcrumb
,cr.crag_name
,c.climb_name
Diff
--- before
+++ after
@@ -31,4 +31,5 @@
order by
cr.location_breadcrumb
+ ,cr.crag_name
,c.climb_name
|
|||||||
| 2 | 31st July 2024 | 18:57:46 | remus | - | - | public | |
|
Before
false
After
true
|
|||||||
| 3 | 31st July 2024 | 18:56: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, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647, 1664)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647, 1664)
group by
c.climb_id
|
|||||||
| 4 | 31st July 2024 | 18:55:59 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708, 2647)
group by
c.climb_id
|
|||||||
| 5 | 31st July 2024 | 18:54:53 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707, 3708)
group by
c.climb_id
|
|||||||
| 6 | 31st July 2024 | 18:53:51 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706, 3707)
group by
c.climb_id
|
|||||||
| 7 | 31st July 2024 | 18:52:32 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705, 3706)
group by
c.climb_id
|
|||||||
| 8 | 31st July 2024 | 18:51:02 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366, 3705)
group by
c.climb_id
|
|||||||
| 9 | 31st July 2024 | 18:50: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, 3685, 2043, 1373, 3686, 1762, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704, 1366)
group by
c.climb_id
|
|||||||
| 10 | 31st July 2024 | 18:49:32 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703, 3704)
group by
c.climb_id
|
|||||||
| 11 | 31st July 2024 | 18:47:49 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907, 3703)
group by
c.climb_id
|
|||||||
| 12 | 31st July 2024 | 18:45:46 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702, 2907)
group by
c.climb_id
|
|||||||
| 13 | 31st July 2024 | 18:44: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, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 1384, 3683, 3684, 3136, 3685, 2043, 1373, 3686, 1762, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701, 3702)
group by
c.climb_id
|
|||||||
| 14 | 31st July 2024 | 18:42:51 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697, 3700)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700, 3701)
group by
c.climb_id
|
|||||||
| 15 | 31st July 2024 | 17:30:10 | 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, 3687, 3688, 1371, 3689, 1379, 3690, 3697)
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, 3688, 1371, 3689, 1379, 3690, 3697, 3700)
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, 3687, 3688, 1371, 3689, 1379, 3690, 3697)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697, 3700)
group by
c.climb_id
|
|||||||
| 16 | 31st July 2024 | 06:26:01 | 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, 3687, 3688, 1371, 3689, 1379, 3690)
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, 3688, 1371, 3689, 1379, 3690, 3697)
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, 3687, 3688, 1371, 3689, 1379, 3690)
+ 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, 3688, 1371, 3689, 1379, 3690, 3697)
group by
c.climb_id
|
|||||||
| 17 | 30th July 2024 | 15:21: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, 3687, 3688, 1371, 3689, 1379)
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, 3688, 1371, 3689, 1379, 3690)
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, 3687, 3688, 1371, 3689, 1379)
+ 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, 3688, 1371, 3689, 1379, 3690)
group by
c.climb_id
|
|||||||
| 18 | 30th July 2024 | 15:19:27 | 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, 3687, 3688, 1371)
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, 3688, 1371, 3689, 1379)
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, 3687, 3688, 1371)
+ 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, 3688, 1371, 3689, 1379)
group by
c.climb_id
|
|||||||
| 19 | 30th July 2024 | 15:17:20 | 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, 3687, 3688)
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, 3688, 1371)
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, 3687, 3688)
+ 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, 3688, 1371)
group by
c.climb_id
|
|||||||
| 20 | 30th July 2024 | 15:15:52 | 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, 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
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, 3688)
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, 3687)
+ 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, 3688)
group by
c.climb_id
|
|||||||