remus

Badges

OG100 Contributions1,000 Contributions10,000 Contributions100,000 Contributions10 Posts100 Posts

Contributions

Posts

1 Day

44

7 Days

696

4 Weeks

9641

All Time

230131

Current Streak

242

Longest Streak

243

Contributions Map

Contributions by Country

Country Contributions Between Climbers Crags Summits Climbs Ascents
1 United Kingdom 61686 14th November 2023 – 16th November 2026 1806 712 0 3145 5097
2 USA 26491 14th November 2023 – 18th November 2026 819 183 165 866 2440
3 France 12612 14th November 2023 – 16th November 2026 273 126 23 557 1049
4 Switzerland 10085 14th November 2023 – 18th November 2026 81 46 52 312 1129
5 Spain 9025 15th November 2023 – 18th November 2026 93 76 10 464 941
6 Italy 5250 16th November 2023 – 18th November 2026 120 59 30 200 394
7 Canada 4062 16th November 2023 – 14th November 2026 67 22 147 111 286
8 South Africa 3696 16th November 2023 – 11th November 2026 12 35 2 128 402
9 Germany 3330 16th November 2023 – 17th November 2026 121 49 1 106 236
10 Austria 2792 16th November 2023 – 16th November 2026 76 26 25 105 227

Recent Contributions

Date Time User Type Name Attribute
57841 22nd June 2026 21:31:49 UTC remus library item Ty Landman - Fontainebleau library_item_type_id
Before
None
After
1
57842 22nd June 2026 21:31:49 UTC remus library item Ty Landman - Fontainebleau library_item_name
Before
None
After
Ty Landman - Fontainebleau
57843 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk ascent_dt_end
Before
None
After
2009-03-03
57844 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk ascent_dt_start
Before
None
After
2009-03-03
57845 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk ascent_type_id
Before
None
After
2
57846 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182445/http://usa.moonclimbing.com/Elephunk-n-888.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182445/http://usa.moonclimbing.com/Elephunk-n-888.html</a></p>
57847 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk notes
Before
None
After
### References [1] [https://web.archive.org/web/20090306182445/http://usa.moonclimbing.com/Elephunk-n-888.html](https://web.archive.org/web/20090306182445/http://usa.moonclimbing.com/Elephunk-n-888.html)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://web.archive.org/web/20090306182445/http://usa.moonclimbing.com/Elephunk-n-888.html](https://web.archive.org/web/20090306182445/http://usa.moonclimbing.com/Elephunk-n-888.html)
57848 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk ascent_style_id
Before
None
After
1
57849 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk climb_id
Before
None
After
204
57850 22nd June 2026 21:29:18 UTC remus ascent Tyler Landman's ascent of Elephunk climber_id
Before
None
After
249
57851 22nd June 2026 21:28:18 UTC remus ascent Tyler Landman's ascent of Satan i Helvete (assis, pre-December 2013) notes_pretty
Before
<h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html</a></p>
After
<blockquote> <p>I brushed each hold, cleaned my shoes and pulled on. I did not feel particularly solid on the lower moves but when I reached up to the right hand crimp, I got it right first time, no readjusting. I looked out to the edge I was about to leap for. When I had stuck the move the other day, it all happened very quickly and my hand was suddenly on the hold. This time was different. I watched my left hand travel out and onto the edge, feeling my fingers engage with the rock as soon as they landed perfectly on the grip. My feet swung off, this did not happen last time. I kept tension, swinging them right back on. I had a flash-vision of Tim Clifford falling off after the crux and assured myself this would not happen to me. I did the next two moves, climbing with utmost precision and precaution, making sure not to fall off. These moves aren't particularly hard, but after the crux are possible to drop. I moved through them with no problems, letting out a Malcolm Smith style roar upon reaching the top. I had done it. I was not expecting to and was quite surprised. It was at this moment that I realized what was happening. Everything I wanted to climb so far, I had climbed, quickly and smoothly. I had elevated my game to the next level and with no particular effort to do so, it had just happened. I thought about what I'd just done and how far I'd come. It felt good to be on the next level, and I looked back at what it took to get here. Thirteen years of dedication, discipline and determination. Practice really does pay off, and in this moment I was satisfied, aware of my ability to rock climb. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html</a></p>
57852 22nd June 2026 21:28:18 UTC remus ascent Tyler Landman's ascent of Satan i Helvete (assis, pre-December 2013) notes
Before
### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
After
> I brushed each hold, cleaned my shoes and pulled on. I did not feel particularly solid on the lower moves but when I reached up to the right hand crimp, I got it right first time, no readjusting. I looked out to the edge I was about to leap for. When I had stuck the move the other day, it all happened very quickly and my hand was suddenly on the hold. This time was different. I watched my left hand travel out and onto the edge, feeling my fingers engage with the rock as soon as they landed perfectly on the grip. My feet swung off, this did not happen last time. I kept tension, swinging them right back on. I had a flash-vision of Tim Clifford falling off after the crux and assured myself this would not happen to me. I did the next two moves, climbing with utmost precision and precaution, making sure not to fall off. These moves aren't particularly hard, but after the crux are possible to drop. I moved through them with no problems, letting out a Malcolm Smith style roar upon reaching the top. I had done it. I was not expecting to and was quite surprised. It was at this moment that I realized what was happening. Everything I wanted to climb so far, I had climbed, quickly and smoothly. I had elevated my game to the next level and with no particular effort to do so, it had just happened. I thought about what I'd just done and how far I'd come. It felt good to be on the next level, and I looked back at what it took to get here. Thirteen years of dedication, discipline and determination. Practice really does pay off, and in this moment I was satisfied, aware of my ability to rock climb. [1] ### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
Diff
--- before

+++ after

@@ -1,3 +1,5 @@

+> I brushed each hold, cleaned my shoes and pulled on. I did not feel particularly solid on the lower moves but when I reached up to the right hand crimp, I got it right first time, no readjusting. I looked out to the edge I was about to leap for. When I had stuck the move the other day, it all happened very quickly and my hand was suddenly on the hold. This time was different. I watched my left hand travel out and onto the edge, feeling my fingers engage with the rock as soon as they landed perfectly on the grip. My feet swung off, this did not happen last time. I kept tension, swinging them right back on. I had a flash-vision of Tim Clifford falling off after the crux and assured myself this would not happen to me. I did the next two moves, climbing with utmost precision and precaution, making sure not to fall off. These moves aren't particularly hard, but after the crux are possible to drop. I moved through them with no problems, letting out a Malcolm Smith style roar upon reaching the top. I had done it. I was not expecting to and was quite surprised. It was at this moment that I realized what was happening. Everything I wanted to climb so far, I had climbed, quickly and smoothly. I had elevated my game to the next level and with no particular effort to do so, it had just happened. I thought about what I'd just done and how far I'd come. It felt good to be on the next level, and I looked back at what it took to get here. Thirteen years of dedication, discipline and determination. Practice really does pay off, and in this moment I was satisfied, aware of my ability to rock climb. [1]
+
### References

[1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
57853 22nd June 2026 21:27:27 UTC remus ascent Tyler Landman's ascent of Satan i Helvete (assis, pre-December 2013) notes_pretty
Before
None
After
<h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html</a></p>
57854 22nd June 2026 21:27:27 UTC remus ascent Tyler Landman's ascent of Satan i Helvete (assis, pre-December 2013) notes
Before
None
After
### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
Diff
--- before

+++ after

@@ -1 +1,3 @@

-
+### References
+
+[1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
57855 22nd June 2026 21:25:36 UTC remus list The Big Five list_description_pretty
Before
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart" rel="noopener noreferrer">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau" rel="noopener noreferrer">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p> <p>Originally <em>The Big Four</em> before <a href="/climber/249/tyler-landman" rel="noopener noreferrer">Tyler Landman</a> decided to try tick them all and add <a href="/climb/3334/atrésie" rel="noopener noreferrer">Atrésie</a> (8A) into the mix:</p> <blockquote> <p>On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html</a></p>
After
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart" rel="noopener noreferrer">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau" rel="noopener noreferrer">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p> <p>Originally <em>The Big Four</em> before <a href="/climber/249/tyler-landman" rel="noopener noreferrer">Tyler Landman</a> decided to try tick them all and add <a href="/climb/3334/atrésie" rel="noopener noreferrer">Atrésie</a> (8A) into the mix:</p> <blockquote> <p>On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html</a></p>
57856 22nd June 2026 21:25:36 UTC remus list The Big Five list_description
Before
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style. Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix: > On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1] ### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
After
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style. Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix: > On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1] ### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html)
Diff
--- before

+++ after

@@ -6,4 +6,4 @@


### References

-[1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
+[1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/Operation-Big-Five-n-885.html)
57857 22nd June 2026 21:23:22 UTC remus list The Big Five list_description_pretty
Before
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart" rel="noopener noreferrer">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau" rel="noopener noreferrer">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p> <p>Originally <em>The Big Four</em> before <a href="/climber/249/tyler-landman" rel="noopener noreferrer">Tyler Landman</a> decided to tick them and include <a href="/climb/3334/atrésie" rel="noopener noreferrer">Atrésie</a> (8A):</p> <blockquote> <p>On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html</a></p>
After
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart" rel="noopener noreferrer">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau" rel="noopener noreferrer">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p> <p>Originally <em>The Big Four</em> before <a href="/climber/249/tyler-landman" rel="noopener noreferrer">Tyler Landman</a> decided to try tick them all and add <a href="/climb/3334/atrésie" rel="noopener noreferrer">Atrésie</a> (8A) into the mix:</p> <blockquote> <p>On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html</a></p>
57858 22nd June 2026 21:23:22 UTC remus list The Big Five list_description
Before
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style. Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to tick them and include [Atrésie](/climb/3334/atrésie) (8A): > On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1] ### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
After
The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style. Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix: > On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1] ### References [1] [https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html](https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html)
Diff
--- before

+++ after

@@ -1,6 +1,6 @@

The Big Five are five problems in the [Cuvier Rempart](/crag/1900/cuvier-rempart) area of [Fontainebleau](/list/31/fontainebleau). While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.

-Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to tick them and include [Atrésie](/climb/3334/atrésie) (8A):
+Originally *The Big Four* before [Tyler Landman](/climber/249/tyler-landman) decided to try tick them all and add [Atrésie](/climb/3334/atrésie) (8A) into the mix:

> On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]
57859 22nd June 2026 21:22:53 UTC remus list The Big Five list_description_pretty
Before
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p>
After
<p>The Big Five are five problems in the <a href="/crag/1900/cuvier-rempart" rel="noopener noreferrer">Cuvier Rempart</a> area of <a href="/list/31/fontainebleau" rel="noopener noreferrer">Fontainebleau</a>. While the problems were not the hardest around when they were established, they represented a high level and together presented a stern challenge in a modern, powerful style.</p> <p>Originally <em>The Big Four</em> before <a href="/climber/249/tyler-landman" rel="noopener noreferrer">Tyler Landman</a> decided to tick them and include <a href="/climb/3334/atrésie" rel="noopener noreferrer">Atrésie</a> (8A):</p> <blockquote> <p>On the same boulder as Big Golden, to the right a couple feet, is Atrésie, a techincal and slopey 8A. This problem is not considered in the "Big Four", but I had decided to add it in making the "Big Five". My goal was to climb all five problems in a day, having never tried any of them before. [1]</p> </blockquote> <h3>References</h3> <p>[1] <a href="https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html" rel="noopener noreferrer">https://web.archive.org/web/20090306182847/http://usa.moonclimbing.com/The-Next-Level-n-887.html</a></p>
57860 22nd June 2026 21:22:53 UTC remus list The Big Five 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="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag ,'<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 ascents a on c.climb_id = a.climb_id and a.deleted_on is null and a.fa = True inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join crags cr on c.crag_id = cr.crag_id where c.climb_id in (3334, 3332, 3330, 3333, 3331)
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="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag ,'<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 ascents a on c.climb_id = a.climb_id and a.deleted_on is null and a.fa = True inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join crags cr on c.crag_id = cr.crag_id where c.climb_id in (3334, 3332, 3330, 3333, 3331)
Diff
--- before

+++ after

@@ -1,24 +1,24 @@

-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="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag
- ,'<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="/crag/' || cr.crag_id::varchar || '/a">' || cr.crag_name || '</a>' as Crag
+ ,'<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 ascents a
+ on c.climb_id = a.climb_id
+ and a.deleted_on is null
+ and a.fa = True
+ inner join climbers cl
+ on a.climber_id = cl.climber_id
+ and cl.deleted_on is null
+ inner join crags cr
+ on c.crag_id = cr.crag_id
+
+where
+ c.climb_id in (3334, 3332, 3330, 3333, 3331)

-from
- climbs c
- inner join grades g
- on c.grade_id = g.grade_id
- inner join ascents a
- on c.climb_id = a.climb_id
- and a.deleted_on is null
- and a.fa = True
- inner join climbers cl
- on a.climber_id = cl.climber_id
- and cl.deleted_on is null
- inner join crags cr
- on c.crag_id = cr.crag_id
-
-where
- c.climb_id in (3334, 3332, 3330, 3333, 3331)
-

< Page 2893 >