Change Log for Hard Rock

Overview

Total Changes

66

First Change

27th Jul 2024

Last Change

31st Jul 2024

Log

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

Page 1 >