STRYDWOLF - Weltstorm CD (2nd 2013)

Profi CDr 2nd edition 15track (44min) in jewel case limited to 100 copies.
Info: Re-edition from Demo 2008 new remastered !!!
-- "Where any view of Money Exists, Art can not be carried on, but War only" (William Blake)---


01. Interlude
02. Dienstbaarheid
03. We are The Red Army
04. Standing Strong
05. Barendsnood
06. Wilhelmus pt II
07. De Watergeus vaart
08. Afscheid
09. Aan alle Fronten
10. Drie Kamaraden
11. Magna Frisia
12. Opstand
13. Ik had een Kamaraad
14. Badenweiler Marsch
15. Overgave

Genre: Dark Ambient, Martial, Volkmusic
Like: Das Brandopfer, Striider, Legoinarii, BloodSoil, Gabe Unruh

- http://youtu.be/T7DRUtjAqvU
- https://soundcloud.com/skullline/strydwolf-afscheid-2013
Reviews (1)
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 = '601718' and opa.orders_id = opb.orders_id and opb.products_id != '601718' 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