12.00€

STRYDWOLF - Dunkle Wälder CD (Lim350)
[CD2011]

CD with 8 page color and songbookled in clear jewel case , is hand-numbered and limited total 500 (this 350) copies.
Info: 16 track only powerful and romantic Neofolk ...like Darkwood, Backworld, Forseti or Sol Invictus - GREAT :)
with guest appearances of ART ABSCONs and KUNSTGERECHT

Attention - comes in 3. different editions:
- normal CD limited Lim 350 (this)
- CD+sticker Lim100
- 2CD Woodenbox Lim50 (sold out)

Tracklist:

01. Intro
02. In die ewigen Waelder
03. Dunkle Waelder
04. Im Nebel
05. Natur und Krieg (with Art Abscons)
06. Night cometh on! (with Ewan Burke - Kunstgerecht)
07. Winter come back
08. Verirrung
09. Schwarzen Wald
10. Weisse Wolken (with Femke)
11. Sturmes Weckruf
12. Der Jäger Abschied
13. Wanderlied
14. Friezenliet
15. Waldsang
16. Frühlingsglaube

Genre: Neofolk, Acoustic, Military Pop, Neoclassic
Like: Darkwood , Forseti, Sonne Hagal, Of the Wand and the Moon, Fire & Ice, Sol Invictus
Reviews (4)
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 = '600231' and opa.orders_id = opb.orders_id and opb.products_id != '600231' 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

[TEP STOP]