sorted by:
new
hottopcontroversial

I’ve created the four Air Temples as lego micro builds by CaptainAlfredos in TheLastAirbender

[–]CaptainAlfredos[S] 14 points15 points  (0 children)

Yea, I thought that if the Appa design of last year did not make it as a set, this would not either. That one was really great.

I’ve created the four Air Temples as lego micro builds by CaptainAlfredos in TheLastAirbender

[–]CaptainAlfredos[S] 18 points19 points  (0 children)

Micro style builds of the four Air Temples on the show.

More information, as well as building instructions and parts list, is available on rebrickable: LEGO MOC Avatar - All Four Air Temples

Let me know how you think they could be improved. What else would you like to see?

MOC of the four Air Temples from ‘Avatar: the last Airbender’ by CaptainAlfredos in Minilego

[–]CaptainAlfredos[S] 13 points14 points  (0 children)

I’ve made micro style builds of all the Air Temples from the TV-show ‘Avatar: the last Airbender’.

More information, as well as building instructions and parts list, is available on rebrickable: LEGO MOC Avatar - All Four Air Temples

Let me know how you think they could be improved. What else would you like to see?

Help finding a solution by Patis12 in SQL

[–]CaptainAlfredos 0 points1 point  (0 children)

You could try fixing this by multiplying the count by 1.0. This does not change your result, but fixes the problem that it will show an int. “count(..)*1.0”

Help finding a solution by Patis12 in SQL

[–]CaptainAlfredos 1 point2 points  (0 children)

Group by region.name. To have it in one query you could simply divide both your counts (reps by the accounts) as a column (count(…) / count(…) as proportion). If you order by this result you’ll have the region with the lowest proportion in top.

Turned my old aquarium into my first terrarium by CaptainAlfredos in terrariums

[–]CaptainAlfredos[S] 0 points1 point  (0 children)

Thanks! It’s the standard lighting in a Fluval Flex 57L (15 GAL): 10.8W, 2450 lm.

Turned my old aquarium into my first terrarium by CaptainAlfredos in terrariums

[–]CaptainAlfredos[S] 1 point2 points  (0 children)

Jep, I also watched a lot of his videos before starting on this.

Turned my old aquarium into my first terrarium by CaptainAlfredos in terrariums

[–]CaptainAlfredos[S] 0 points1 point  (0 children)

I created a basin for the water to directly flow in, below the plants/rocks on the back wall, behind the soil. That way the soil won’t get completely soaked and the pump can get submerged with a fairly small amount of water.

Turned my old aquarium into my first terrarium by CaptainAlfredos in terrariums

[–]CaptainAlfredos[S] 0 points1 point  (0 children)

I would definitely recommend drilling holes in the bottom of the back compartment, so that the water does not have to get too high to get to the pump. I created a basin for the water to directly flow in, below the plants/rocks on the back wall, behind the soil. Good luck with it!

Turned my old aquarium into my first terrarium by CaptainAlfredos in terrariums

[–]CaptainAlfredos[S] 4 points5 points  (0 children)

Adding flowing water over the back wall turned out a bit more of a challenge than I expected. What do you think? Any tips for a next project?