| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 41 | 29th July 2024 | 15:03:43 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666, 3435)
group by
c.climb_id
|
|||||||
| 42 | 29th July 2024 | 15:02:50 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,cr.location_breadcrumb_pretty as "Location"
,string_agg('<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a> (' || pretty_dt(a.ascent_dt_start, a.ascent_dt_end) || ')', ', ' order by order_dt(a.ascent_dt_start, a.ascent_dt_end)) as "First Ascent"
from
climbs c
inner join grades g
on c.grade_id = g.grade_id
left join crags cr
on c.ukc_crag_id = cr.crag_id
left join ascents a
on a.climb_id = c.climb_id
and a.deleted_on is null
and a.fa = true
left join climbers cl
on a.climber_id = cl.climber_id
and cl.deleted_on is null
where
c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047, 3666)
group by
c.climb_id
|
|||||||
| 43 | 29th July 2024 | 14:59:21 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662, 3047)
group by
c.climb_id
|
|||||||
| 44 | 28th July 2024 | 20:48: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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649, 3662)
group by
c.climb_id
|
|||||||
| 45 | 27th July 2024 | 18:31:41 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633, 2649)
group by
c.climb_id
|
|||||||
| 46 | 27th July 2024 | 18:30:04 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3633)
group by
c.climb_id
|
|||||||
| 47 | 27th July 2024 | 18:28:04 | 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, 3360)
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)
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, 3360)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660)
group by
c.climb_id
|
|||||||
| 48 | 27th July 2024 | 18:27:34 | 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)
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, 3360)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3360)
group by
c.climb_id
|
|||||||
| 49 | 27th July 2024 | 18:19:38 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659)
group by
c.climb_id
|
|||||||
| 50 | 27th July 2024 | 18:18:16 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658)
group by
c.climb_id
|
|||||||
| 51 | 27th July 2024 | 18:11: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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657)
group by
c.climb_id
|
|||||||
| 52 | 27th July 2024 | 18:09:04 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656)
group by
c.climb_id
|
|||||||
| 53 | 27th July 2024 | 18:06:25 | 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)
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)
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)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653, 3654, 3655)
group by
c.climb_id
|
|||||||
| 54 | 27th July 2024 | 17:47:24 | 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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
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)
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
@@ -2,6 +2,7 @@
'<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
@@ -29,4 +30,5 @@
,g.grade
order by
- c.climb_name
+ cr.location_breadcrumb
+ ,c.climb_name
|
|||||||
| 55 | 27th July 2024 | 17:45: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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -19,7 +19,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650,3651)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650, 3651, 3652, 3653)
group by
c.climb_id
|
|||||||
| 56 | 27th July 2024 | 17:33: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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -19,7 +19,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649, 3650)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650,3651)
group by
c.climb_id
|
|||||||
| 57 | 27th July 2024 | 12:21:37 | 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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -19,7 +19,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647, 3649)
+ c.climb_id in (3637, 3648, 3647, 3649, 3650)
group by
c.climb_id
|
|||||||
| 58 | 27th July 2024 | 12:20: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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -19,7 +19,7 @@
and cl.deleted_on is null
where
- c.climb_id in (3637, 3648, 3647)
+ c.climb_id in (3637, 3648, 3647, 3649)
group by
c.climb_id
|
|||||||
| 59 | 27th July 2024 | 11:52:08 | 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"
,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
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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
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"
,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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -13,6 +13,7 @@
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
|
|||||||
| 60 | 27th July 2024 | 11:51:35 | remus | - | - | list_definition | |
|
Before
select
'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as "Climb"
,g.grade
,'<a href="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as "Crag"
,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
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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
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"
,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
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)
group by
c.climb_id
,c.climb_name
,cr.crag_id
,cr.crag_name
,g.grade
order by
c.climb_name
Diff
--- before
+++ after
@@ -2,7 +2,7 @@
'<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"
- ,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"
+ ,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
|
|||||||