remus

	Country	Contributions	Between	Climbers	Crags	Summits	Climbs	Ascents
1	United Kingdom	49454	14th November 2023 – 25th July 2026	1379	670	0	2970	4668
2	USA	23839	14th November 2023 – 25th July 2026	778	179	2	829	2297
3	France	11592	14th November 2023 – 24th July 2026	258	123	1	534	988
4	Switzerland	8581	14th November 2023 – 25th July 2026	74	40	1	293	1023
5	Spain	8134	15th November 2023 – 20th July 2026	88	73	0	437	874
6	Italy	4165	16th November 2023 – 23rd July 2026	113	56	0	171	324
7	South Africa	3325	16th November 2023 – 26th July 2026	12	35	0	119	364
8	Germany	2992	16th November 2023 – 23rd July 2026	112	47	0	102	220
9	Canada	2957	16th November 2023 – 13th July 2026	61	21	3	104	253
10	Japan	2339	16th November 2023 – 11th June 2026	74	11	0	90	223

	Date	Time	User	Type	Name	Attribute
27161	2nd March 2026	08:21:56 UTC	remus	climb	Gakidō	Website
Before `None` After `https://www.thecrag.com/en/climbing/japan/route/5930819448`
27162	2nd March 2026	08:21:35 UTC	remus	climb	Gakidō	crag_location_breadcrumb_pretty
Before `None` After `<a href="/crags/location/Japan" class="text-muted">Japan</a> / <a href="/crags/location/Japan/Fukushima" class="text-muted">Fukushima</a>`
27163	2nd March 2026	08:21:35 UTC	remus	climb	Gakidō	crag_location_breadcrumb
Before `None` After `Japan / Fukushima`
27164	2nd March 2026	08:21:35 UTC	remus	climb	Gakidō	crag_name
Before `None` After `Chigomaidai`
27165	2nd March 2026	08:21:35 UTC	remus	climb	Gakidō	crag_id
Before `None` After `33849`
27166	2nd March 2026	08:21:20 UTC	remus	climb	Ashuradō	Website
Before `None` After `https://www.thecrag.com/en/climbing/japan/route/8942540916`
27167	2nd March 2026	08:21:05 UTC	remus	climb	Ashuradō	crag_name
Before `None` After `Chigomaidai`
27168	2nd March 2026	08:21:05 UTC	remus	climb	Ashuradō	crag_location_breadcrumb_pretty
Before `None` After `<a href="/crags/location/Japan" class="text-muted">Japan</a> / <a href="/crags/location/Japan/Fukushima" class="text-muted">Fukushima</a>`
27169	2nd March 2026	08:21:05 UTC	remus	climb	Ashuradō	crag_location_breadcrumb
Before `None` After `Japan / Fukushima`
27170	2nd March 2026	08:21:05 UTC	remus	climb	Ashuradō	crag_id
Before `None` After `33849`
27171	2nd March 2026	08:19:02 UTC	remus	crag	Chigomaidai	Other Name
Before `None` After `稚児舞台公園`
27172	2nd March 2026	08:18:45 UTC	remus	crag	Chigomaidai	Other Name
Before `None` After `Chigobutai`
27173	2nd March 2026	08:18:30 UTC	remus	crag	Chigomaidai	thecrag_url
Before `None` After `https://www.thecrag.com/en/climbing/japan/area/5930817060` Diff `--- before +++ after @@ -1 +1 @@ - +https://www.thecrag.com/en/climbing/japan/area/5930817060`
27174	2nd March 2026	08:18:30 UTC	remus	crag	Chigomaidai	eight_a_nu_url
Before `None` After `https://www.8a.nu/crags/bouldering/japan/chigobutai/routes` Diff `--- before +++ after @@ -1 +1 @@ - +https://www.8a.nu/crags/bouldering/japan/chigobutai/routes`
27175	2nd March 2026	08:18:14 UTC	remus	crag	Chigomaidai	latitude
Before `None` After `37.604375`
27176	2nd March 2026	08:18:14 UTC	remus	crag	Chigomaidai	longitude
Before `None` After `140.513002`
27177	2nd March 2026	08:18:14 UTC	remus	crag	Chigomaidai	crag_name
Before `None` After `Chigomaidai`
27178	2nd March 2026	08:12:08 UTC	remus	list	The Hardest Boulder Problems on Gritstone	list_definition
Before select c.climb_uuid as row_uuid, '<a href="/climb/' \|\| c.climb_id::varchar \|\| '/a">' \|\| c.climb_name \|\| '</a>' as Climb ,g.grade as Grade ,'<a href="/climber/' \|\| cl.climber_id::varchar \|\| '/a">' \|\| cl.climber_name \|\| '</a>' \|\| ', ' \|\| pretty_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 inner join crags cr on c.crag_id = cr.crag_id inner join rock_types rt on cr.rock_type_id = rt.rock_type_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id where rt.rock_type = 'Gritstone' and c.climb_type_id = 2 and c.deleted_on is null and g.order_on >= 39 order by g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end) After select c.climb_uuid as row_uuid, '<a href="/climb/' \|\| c.climb_id::varchar \|\| '/a">' \|\| c.climb_name \|\| '</a>' as Climb ,g.grade as Grade ,'<a href="/climber/' \|\| cl.climber_id::varchar \|\| '/a">' \|\| cl.climber_name \|\| '</a>' \|\| ', ' \|\| pretty_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 inner join crags cr on c.crag_id = cr.crag_id inner join rock_types rt on cr.rock_type_id = rt.rock_type_id left join ascents a on a.climb_id = c.climb_id and a.fa = true and a.deleted_on is null left join climbers cl on a.climber_id = cl.climber_id left join climb_meta cm on c.climb_id = cm.climb_id and cm.climb_meta_key_id = 20 -- project where rt.rock_type = 'Gritstone' and c.climb_type_id = 2 and c.deleted_on is null and g.order_on >= 39 and cm.value is null order by g.order_on desc ,order_dt(a.ascent_dt_start, a.ascent_dt_end) Diff --- before +++ after @@ -1,31 +1,35 @@ -select -c.climb_uuid as row_uuid, - '<a href="/climb/' \|\| c.climb_id::varchar \|\| '/a">' \|\| c.climb_name \|\| '</a>' as Climb - ,g.grade as Grade - ,'<a href="/climber/' \|\| cl.climber_id::varchar \|\| '/a">' \|\| cl.climber_name \|\| '</a>' \|\| ', ' \|\| pretty_dt(a.ascent_dt_start, a.ascent_dt_end) as "First Ascent" +select + c.climb_uuid as row_uuid, + '<a href="/climb/' \|\| c.climb_id::varchar \|\| '/a">' \|\| c.climb_name \|\| '</a>' as Climb + ,g.grade as Grade + ,'<a href="/climber/' \|\| cl.climber_id::varchar \|\| '/a">' \|\| cl.climber_name \|\| '</a>' \|\| ', ' \|\| pretty_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 + inner join crags cr + on c.crag_id = cr.crag_id + inner join rock_types rt + on cr.rock_type_id = rt.rock_type_id + left join ascents a + on a.climb_id = c.climb_id + and a.fa = true + and a.deleted_on is null + left join climbers cl + on a.climber_id = cl.climber_id + left join climb_meta cm + on c.climb_id = cm.climb_id + and cm.climb_meta_key_id = 20 -- project + +where + rt.rock_type = 'Gritstone' + and c.climb_type_id = 2 + and c.deleted_on is null + and g.order_on >= 39 + and cm.value is null + +order by + g.order_on desc + ,order_dt(a.ascent_dt_start, a.ascent_dt_end) -from - climbs c - inner join grades g - on c.grade_id = g.grade_id - inner join crags cr - on c.crag_id = cr.crag_id - inner join rock_types rt - on cr.rock_type_id = rt.rock_type_id - left join ascents a - on a.climb_id = c.climb_id - and a.fa = true - and a.deleted_on is null - left join climbers cl - on a.climber_id = cl.climber_id - -where - rt.rock_type = 'Gritstone' - and c.climb_type_id = 2 - and c.deleted_on is null - and g.order_on >= 39 - -order by - g.order_on desc - ,order_dt(a.ascent_dt_start, a.ascent_dt_end) -
27179	1st March 2026	22:09:04 UTC	remus	media	https://www.instagram.com/p/DVFT0T4jbtf/	dt_pretty
Before `None` After
27180	1st March 2026	22:09:04 UTC	remus	media	https://www.instagram.com/p/DVFT0T4jbtf/	url
Before `None` After `https://www.instagram.com/p/DVFT0T4jbtf/`

Badges

Contributions

Posts

66

1123

3184

176326

127

181

Contributions Map

Contributions by Country

Recent Contributions

< Page 1359 >