| Country | Contributions | Between | Climbers | Crags | Summits | Climbs | Ascents | |
|---|---|---|---|---|---|---|---|---|
| 1 | United Kingdom | 61429 | 14th November 2023 – 7th November 2026 | 1800 | 711 | 0 | 3142 | 5082 |
| 2 | USA | 25581 | 14th November 2023 – 6th November 2026 | 818 | 182 | 2 | 859 | 2421 |
| 3 | France | 12391 | 14th November 2023 – 4th November 2026 | 272 | 126 | 1 | 553 | 1042 |
| 4 | Switzerland | 9695 | 14th November 2023 – 2nd November 2026 | 79 | 43 | 1 | 311 | 1126 |
| 5 | Spain | 8822 | 15th November 2023 – 4th November 2026 | 92 | 76 | 0 | 459 | 927 |
| 6 | Italy | 4902 | 16th November 2023 – 6th November 2026 | 120 | 59 | 0 | 189 | 377 |
| 7 | South Africa | 3688 | 16th November 2023 – 5th November 2026 | 12 | 35 | 0 | 128 | 401 |
| 8 | Canada | 3363 | 16th November 2023 – 1st November 2026 | 67 | 21 | 3 | 110 | 283 |
| 9 | Germany | 3190 | 16th November 2023 – 27th October 2026 | 120 | 48 | 0 | 103 | 225 |
| 10 | Austria | 2659 | 16th November 2023 – 24th October 2026 | 76 | 26 | 0 | 105 | 226 |
| Date | Time | User | Type | Name | Attribute | ||
|---|---|---|---|---|---|---|---|
| 81561 | 15th January 2026 | 07:16:04 UTC | remus | ascent | Andrea Chelleris's ascent of Victimes del Futur | climber_id | |
|
Before
None
After
2850
|
|||||||
| 81562 | 15th January 2026 | 07:15:16 UTC | remus | ascent | Andrea Chelleris's ascent of Ciudad del Dios | ascent_dt_end | |
|
Before
None
After
2025-12-29
|
|||||||
| 81563 | 15th January 2026 | 07:15:16 UTC | remus | ascent | Andrea Chelleris's ascent of Ciudad del Dios | ascent_dt_start | |
|
Before
None
After
2025-12-29
|
|||||||
| 81564 | 15th January 2026 | 07:15:16 UTC | remus | ascent | Andrea Chelleris's ascent of Ciudad del Dios | ascent_type_id | |
|
Before
None
After
1
|
|||||||
| 81565 | 15th January 2026 | 07:15:16 UTC | remus | ascent | Andrea Chelleris's ascent of Ciudad del Dios | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 81566 | 15th January 2026 | 07:15:16 UTC | remus | ascent | Andrea Chelleris's ascent of Ciudad del Dios | climb_id | |
|
Before
None
After
44
|
|||||||
| 81567 | 15th January 2026 | 07:15:16 UTC | remus | ascent | Andrea Chelleris's ascent of Ciudad del Dios | climber_id | |
|
Before
None
After
2850
|
|||||||
| 81568 | 15th January 2026 | 07:14:41 UTC | remus | ascent | Andrea Chelleris's ascent of La Fabela pa la Enmienda | ascent_dt_end | |
|
Before
None
After
2026-01-03
|
|||||||
| 81569 | 15th January 2026 | 07:14:41 UTC | remus | ascent | Andrea Chelleris's ascent of La Fabela pa la Enmienda | ascent_dt_start | |
|
Before
None
After
2026-01-03
|
|||||||
| 81570 | 15th January 2026 | 07:14:41 UTC | remus | ascent | Andrea Chelleris's ascent of La Fabela pa la Enmienda | ascent_type_id | |
|
Before
None
After
1
|
|||||||
| 81571 | 15th January 2026 | 07:14:41 UTC | remus | ascent | Andrea Chelleris's ascent of La Fabela pa la Enmienda | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 81572 | 15th January 2026 | 07:14:41 UTC | remus | ascent | Andrea Chelleris's ascent of La Fabela pa la Enmienda | climb_id | |
|
Before
None
After
754
|
|||||||
| 81573 | 15th January 2026 | 07:14:41 UTC | remus | ascent | Andrea Chelleris's ascent of La Fabela pa la Enmienda | climber_id | |
|
Before
None
After
2850
|
|||||||
| 81574 | 15th January 2026 | 07:14:19 UTC | remus | ascent | Andrea Chelleris's ascent of Direct Into Your Fabelita | ascent_dt_end | |
|
Before
None
After
2026-01-03
|
|||||||
| 81575 | 15th January 2026 | 07:14:19 UTC | remus | ascent | Andrea Chelleris's ascent of Direct Into Your Fabelita | ascent_dt_start | |
|
Before
None
After
2026-01-03
|
|||||||
| 81576 | 15th January 2026 | 07:14:19 UTC | remus | ascent | Andrea Chelleris's ascent of Direct Into Your Fabelita | ascent_type_id | |
|
Before
None
After
1
|
|||||||
| 81577 | 15th January 2026 | 07:14:19 UTC | remus | ascent | Andrea Chelleris's ascent of Direct Into Your Fabelita | ascent_style_id | |
|
Before
None
After
1
|
|||||||
| 81578 | 15th January 2026 | 07:14:19 UTC | remus | ascent | Andrea Chelleris's ascent of Direct Into Your Fabelita | climb_id | |
|
Before
None
After
6648
|
|||||||
| 81579 | 15th January 2026 | 07:14:19 UTC | remus | ascent | Andrea Chelleris's ascent of Direct Into Your Fabelita | climber_id | |
|
Before
None
After
2850
|
|||||||
| 81580 | 15th January 2026 | 07:12:40 UTC | remus | list | James' List | list_definition | |
|
Before
WITH RECURSIVE months AS (
SELECT DATE_TRUNC('month', DATE '2024-01-01') AS month_start
UNION ALL
SELECT DATE_TRUNC('month', month_start + INTERVAL '1 month')
FROM months
WHERE month_start < DATE_TRUNC('month', CURRENT_DATE)
)
SELECT
date_part('year', month_start)::int as "Year"
,date_part('month', month_start)::int as "Month"
,'<a href="/climber/' || c.climber_id::varchar || '/a">' || c.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cl.climb_id::varchar || '/a">' || cl.climb_name || '</a>' as "Climb"
,g.grade || ' ' || ct.climb_type as "Grade"
,aty.ascent_type || ' (' || ast.ascent_style || ')' as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
FROM
months m
left join ascents a
on m.month_start = date_trunc('month', a.ascent_dt_start)
and a.deleted_on is null
and a.climber_id in (
2850
,2851
,836
,2852
,1152
,517
,369
,894
,2853
,2854
,495
,1004
,173
,942
,2855
,523
,913
,2856
,590
,2857
,637
,2858
,2724
,2859
,2860
,1576
,152
,2861
,1991
,2862
,1912
,2863
,467
,2436
,2864
,676
,1210
,322
,2247
,1537
,2865
,1082
,1201
,1790
,1441
,494
,1097
,1200
,2008
,593
,2217
,992
,831
,881
,686
,778
,1263
,166
,2866
,787
)
left join climbers c
on a.climber_id = c.climber_id
left join climbs cl
on a.climb_id = cl.climb_id
left join grades g
on cl.grade_id = g.grade_id
left join climb_types ct
on cl.climb_type_id = ct.climb_type_id
left join ascent_types aty
on a.ascent_type_id = aty.ascent_type_id
left join ascent_styles ast
on a.ascent_style_id = ast.ascent_style_id
ORDER BY
month_start desc
,order_dt(a.ascent_dt_start, a.ascent_dt_end) desc;
After
WITH RECURSIVE months AS (
SELECT DATE_TRUNC('month', DATE '2024-01-01') AS month_start
UNION ALL
SELECT DATE_TRUNC('month', month_start + INTERVAL '1 month')
FROM months
WHERE month_start < DATE_TRUNC('month', CURRENT_DATE)
)
SELECT
date_part('year', month_start)::int as "Year"
,date_part('month', month_start)::int as "Month"
,'<a href="/climber/' || c.climber_id::varchar || '/a">' || c.climber_name || '</a>' as "Climber"
,'<a href="/climb/' || cl.climb_id::varchar || '/a">' || cl.climb_name || '</a>' as "Climb"
,g.grade || ' ' || ct.climb_type as "Grade"
,aty.ascent_type || ' (' || ast.ascent_style || ')' as "Style"
,pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "Date"
FROM
months m
left join ascents a
on m.month_start = date_trunc('month', a.ascent_dt_start)
and a.deleted_on is null
and a.climber_id in (
2850
,2851
,836
,2852
,1152
,517
,369
,894
,2853
,2854
,495
,1004
,173
,942
,2855
,523
,913
,2856
,590
,2857
,637
,2858
,2724
,2859
,2860
,1576
,152
,2861
,1991
,2862
,1912
,2863
,467
,2436
,2864
,676
,1210
,322
,2247
,1537
,2865
,1082
,1201
,1790
,1441
,494
,1097
,1200
,2008
,593
,2217
,992
,831
,881
,686
,778
,1263
,166
,2866
,787
,1431
,1547
,1798
,1085
,2107
,1457
)
left join climbers c
on a.climber_id = c.climber_id
left join climbs cl
on a.climb_id = cl.climb_id
left join grades g
on cl.grade_id = g.grade_id
left join climb_types ct
on cl.climb_type_id = ct.climb_type_id
left join ascent_types aty
on a.ascent_type_id = aty.ascent_type_id
left join ascent_styles ast
on a.ascent_style_id = ast.ascent_style_id
ORDER BY
month_start desc
,order_dt(a.ascent_dt_start, a.ascent_dt_end) desc;
Diff
--- before
|
|||||||