12.00€

IN SCHERBEN - Dagaz CD Lim300 (2012)
[CD2012]

CD 15track (68min) comes in beautiful red wine colored cover with 4 page bookled, white tray and limited to 300 handnumbered copies.
Info: "The best of 5 years IN SCHERBEN"
This collection is a summary of the first two albums (Erlenkönige 2008 & Ostrakon 2009) including 3 bonus tracks !
Artwork by Willem Witte (Strydwolf).
*FANTASTIC NEOFOLK IN THE STYLE OF FORSETI*


Tracklist:

01. Scherbenlied
02. Abendrot
03. Lebwohl
04. Ernte
05. Ein letztes mal
06. Aus der Winterwüste
07. Sturm und Sterben
08. Runentraum
09. Heimweh
10. Theatrum Europaeum Introitus (Deutsch Südost)
11. Epilog
12. Thurs
13. Kriegslied
14. Natur und Sehnsucht
15. Ragende Berge


Genre: Neofolk, Acoustic, Apocalyptic Pop
Like: Forseti, Of the Wand and the Moon, Sonne Hagal, Jännerwein, Leger des Heils

SOUND FILE:
- http://youtu.be/vfgJxiWUdP8
- http://www.youtube.com/watch?v=Mn5LjwVtca4
- http://www.youtube.com/watch?v=ueeRzjtsw9s
- http://www.youtube.com/watch?v=Nd_iUrZab6I
- http://www.youtube.com/watch?v=qd-QC8MUgPU
- http://www.youtube.com/watch?v=MsATbr2v8g8
- http://www.youtube.com/watch?v=5eU1jl2Oqms
Reviews (3)
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 = '601249' and opa.orders_id = opb.orders_id and opb.products_id != '601249' 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]