baz9

	Country	Contributions	Between	Climbers	Crags	Climbs	Ascents
1	USA	1507	20th November 2025 – 30th June 2026	47	20	87	97
2	Australia	767	27th September 2025 – 29th June 2026	6	38	61	33
3	United Kingdom	576	19th November 2025 – 8th July 2026	33	14	22	43
4	France	264	6th January 2026 – 28th June 2026	14	3	12	31
5	Switzerland	257	24th January 2026 – 10th July 2026	6	3	12	33
6	Austria	210	12th November 2025 – 22nd June 2026	5	2	8	22
7	Italy	129	18th November 2025 – 29th May 2026	9	3	11	10
8	Pakistan	118	11th April 2026 – 26th April 2026	0	0	1	7
9	Spain	105	20th February 2026 – 16th May 2026	5	0	10	11
10	Germany	103	3rd February 2026 – 26th June 2026	7	0	7	10

	Date	Time	User	Type	Name	Attribute
2241	10th May 2026	23:05:44 UTC	baz9	ascent	Noah Wheeler's ascent of Burden of Dreams	ascent_style_id
Before `None` After `1`
2242	10th May 2026	23:05:44 UTC	baz9	ascent	Noah Wheeler's ascent of Burden of Dreams	ascent_type_id
Before `None` After `2`
2243	10th May 2026	23:05:44 UTC	baz9	ascent	Noah Wheeler's ascent of Burden of Dreams	ascent_dt_start
Before `None` After `2025-01-01`
2244	10th May 2026	23:05:44 UTC	baz9	ascent	Noah Wheeler's ascent of Burden of Dreams	climb_id
Before `None` After `826`
2245	10th May 2026	23:05:44 UTC	baz9	ascent	Noah Wheeler's ascent of Burden of Dreams	ascent_dt_end
Before `None` After `2027-01-01`
2246	10th May 2026	23:05:44 UTC	baz9	ascent	Noah Wheeler's ascent of Burden of Dreams	climber_id
Before `None` After `1346`
2247	10th May 2026	21:21:10 UTC	baz9	crag	Arapiles	Country
Before `None` After `8`
2248	8th May 2026	11:51:09 UTC	baz9	climber	Jordan Cannon	date_of_birth_pretty
Before After `2nd May 1994`
2249	8th May 2026	11:51:09 UTC	baz9	climber	Jordan Cannon	age
Before `None` After `32`
2250	8th May 2026	11:51:09 UTC	baz9	climber	Jordan Cannon	date_of_birth_start
Before `None` After `1994-05-02`
2251	8th May 2026	11:51:09 UTC	baz9	climber	Jordan Cannon	date_of_birth_end
Before `None` After `1994-05-02`
2252	8th May 2026	00:21:53 UTC	baz9	list	Birthdays of Climbers	list_description
Before `Lists the birthdays of each climber on the site. Climbers with non-exact birth dates are excluded.` After `Lists the birthdays of each climber on the site. Climbers without exact birth dates are excluded.` Diff `--- before +++ after @@ -1 +1 @@ -Lists the birthdays of each climber on the site. Climbers with non-exact birth dates are excluded. +Lists the birthdays of each climber on the site. Climbers without exact birth dates are excluded.`
2253	8th May 2026	00:21:53 UTC	baz9	list	Birthdays of Climbers	list_description_pretty
Before `<p>Lists the birthdays of each climber on the site. Climbers with non-exact birth dates are excluded.</p>` After `<p>Lists the birthdays of each climber on the site. Climbers without exact birth dates are excluded.</p>`
2254	7th May 2026	16:29:37 UTC	baz9	list	Birthdays of Climbers	list_description
Before `Lists the birthdays of each climber on the site. Climbers with non exact birth dates are excluded.` After `Lists the birthdays of each climber on the site. Climbers with non-exact birth dates are excluded.` Diff `--- before +++ after @@ -1 +1 @@ -Lists the birthdays of each climber on the site. Climbers with non exact birth dates are excluded. +Lists the birthdays of each climber on the site. Climbers with non-exact birth dates are excluded.`
2255	7th May 2026	16:29:37 UTC	baz9	list	Birthdays of Climbers	list_description_pretty
Before `<p>Lists the birthdays of each climber on the site. Climbers with non exact birth dates are excluded.</p>` After `<p>Lists the birthdays of each climber on the site. Climbers with non-exact birth dates are excluded.</p>`
2256	7th May 2026	16:28:14 UTC	baz9	list	Birthdays of Climbers	list_name
Before `None` After `Birthdays of Climbers`
2257	7th May 2026	16:28:14 UTC	baz9	list	Birthdays of Climbers	list_description
Before `None` After `Lists the birthdays of each climber on the site. Climbers with non exact birth dates are excluded.` Diff `--- before +++ after @@ -1 +1 @@ - +Lists the birthdays of each climber on the site. Climbers with non exact birth dates are excluded.`
2258	7th May 2026	16:28:14 UTC	baz9	list	Birthdays of Climbers	list_definition
Before `None` After with days as ( select gs::date as day_of_year ,to_char(gs::date, 'MM-DD') as month_day from generate_series( date '2000-01-01' ,date '2000-12-31' ,interval '1 day' ) as gs ), climbers_with_exact_dobs as ( select c.climber_id ,c.climber_name ,c.date_of_birth_start::date as date_of_birth ,to_char(c.date_of_birth_start::date, 'MM-DD') as month_day from climbers c where c.deleted_on is null and c.date_of_birth_start is not null and c.date_of_birth_start = c.date_of_birth_end ), climber_ascent_counts as ( select c.climber_id ,count(a.ascent_id) as ascent_count from climbers_with_exact_dobs c left join ascents a on a.climber_id = c.climber_id and a.deleted_on is null group by c.climber_id ), climbers_ranked_by_day as ( select c.month_day ,c.climber_id ,c.climber_name ,coalesce(cac.ascent_count, 0) as ascent_count from climbers_with_exact_dobs c left join climber_ascent_counts cac on c.climber_id = cac.climber_id ) select to_char(d.day_of_year, 'FMDD FMMonth') as "Day" ,string_agg( '<a href="/climber/' \|\| crbd.climber_id::varchar \|\| '">' \|\| crbd.climber_name \|\| '</a>' ,', ' order by crbd.ascent_count desc, crbd.climber_name asc ) as "Climbers" from days d left join climbers_ranked_by_day crbd on d.month_day = crbd.month_day group by d.day_of_year order by extract(month from d.day_of_year) ,extract(day from d.day_of_year) Diff --- before +++ after @@ -1 +1,71 @@ +with days as ( + select + gs::date as day_of_year + ,to_char(gs::date, 'MM-DD') as month_day + + from + generate_series( + date '2000-01-01' + ,date '2000-12-31' + ,interval '1 day' + ) as gs +), climbers_with_exact_dobs as ( + select + c.climber_id + ,c.climber_name + ,c.date_of_birth_start::date as date_of_birth + ,to_char(c.date_of_birth_start::date, 'MM-DD') as month_day + + from + climbers c + + where + c.deleted_on is null + and c.date_of_birth_start is not null + and c.date_of_birth_start = c.date_of_birth_end +), climber_ascent_counts as ( + select + c.climber_id + ,count(a.ascent_id) as ascent_count + + from + climbers_with_exact_dobs c + left join ascents a + on a.climber_id = c.climber_id + and a.deleted_on is null + + group by + c.climber_id +), climbers_ranked_by_day as ( + select + c.month_day + ,c.climber_id + ,c.climber_name + ,coalesce(cac.ascent_count, 0) as ascent_count + + from + climbers_with_exact_dobs c + left join climber_ascent_counts cac + on c.climber_id = cac.climber_id +) + +select + to_char(d.day_of_year, 'FMDD FMMonth') as "Day" + ,string_agg( + '<a href="/climber/' \|\| crbd.climber_id::varchar \|\| '">' \|\| crbd.climber_name \|\| '</a>' + ,', ' + order by crbd.ascent_count desc, crbd.climber_name asc + ) as "Climbers" + +from + days d + left join climbers_ranked_by_day crbd + on d.month_day = crbd.month_day + +group by + d.day_of_year + +order by + extract(month from d.day_of_year) + ,extract(day from d.day_of_year)
2259	7th May 2026	16:28:14 UTC	baz9	list	Birthdays of Climbers	list_description_pretty
Before `None` After `<p>Lists the birthdays of each climber on the site. Climbers with non exact birth dates are excluded.</p>`
2260	7th May 2026	16:28:14 UTC	baz9	list	Birthdays of Climbers	list_type_id
Before `None` After `5`

Badges

Contributions

Posts

0

0

71

6423

0

13

Contributions Map

Contributions by Country

Recent Contributions

< Page 113 >