STRYDWOLF - Lieder von Traum und Tod 2CD (Lim50)

2CD SET: 28 track (90min.) CD + exclusive bonus CDr "Die letzten Goten" it's limited to 50 hand-numbered copies.

Info: The fourth album by the Dutch Willem W. stands out by the excellent artwork by Rainer Langer (German painter), and the beautiful and varied neofolk with a lot of romantic, power and emotion.
In collaboration of brilliant guest musicians like Niemandsvater, Stefania Domizia, Kentin Jivek, the mixture of the album is excellent!
Fantastic Neofolk meets Military Pop :-)

Attention - comes in 3. different editions: - normal CD limited Lim425
- CD + CDR Lim50
(this) - CD + CDR + MCDR sticker Lim25



01. Intro
02. Auf dem Friedhof
03. Wonne der Sturmnacht
04. Lebenslauf
05. Träumende Seele (& Niemandsvater)
06. Morgenrood
07. Kriegerseele
08. Nur im Traum (& Stefania Domizia)
09. Ontwaakt!
10. Träume nur
11. Mondnacht (& Kentin Jivek)
12. Überal
13. Zwarte lage vlakten (Album Version)
14. Der Adler
15. Eens
16. Das verlorne Land
17. Wenn der Lenz erwacht
18. Blauer Himmel
19. Noch stehen nur die Eiche

bonus CDr "Die letzten Goten" :

01. Die letzten Goten
02. Todesgesang (with Niemandsvater)
03. Âldfaars erf
04. Ús âlde Toer
05. Forfleine dreamen
06. De ferdronken Seeman
07. Thors Hammerwurf
08. Reise in die Nacht - (with Stefania Domizia)
09. Odins Wort

Genre: Neofolk, Military Pop, Acoustic
Like: Derniere Volonte, Darkwood, In Scherben, Sol Invictus, Death in June


- https://www.youtube.com/watch?v=uALwlYkVIPI
- https://www.youtube.com/watch?v=8vN4faFzCHM
- https://www.youtube.com/watch?v=gIJHdtC08eQ
- https://www.youtube.com/watch?v=z_8zin66_VE

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'usr_ud04_237_5.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '602018' and opa.orders_id = opb.orders_id and opb.products_id != '602018' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6