V/A Sampler - Passendale 1917 CD (Lim100)

This pro CDr (53min) is limited to 100 handnumbed copies.
Info: Passendale 1917 is an intense album inspired in the feels, the darkness, the cruelty,the blood of the most heroic battle, the Battle of Passendale in the Wolrd War One, when soldiers of all nations lives on the trenches. You can feel the fear and the brave when somebody run directly to the death.
Exclusive compilation with "fantastic" dark ambient and classical martial music.


01. Das Brandopfer - Warte Nicht Handelt
02. Barbarossa Umtrunk - Soleil De Fer
03. TSIDMZ (Thule Sehnsucht In Der Maschinen Zeit) - Paul Von Hindenburg
04. La Derniere Attaque - Living On The Trenches
05. Liturgy Of Confrontation - 1917
06. Striider - A Sea Of Mud
07. Escuadron De La Muerte - Inferno (1917)
08. Beutewaffen - Hell And Horror
09. La Derniere Attaque - The Death Walk On The Field
10. Strydwolf - Ontwaakt
11. Putsch - Liturgy of Confrontation
12. TSIDMZ (Thule Sehnsucht In Der Maschinen Zeit) - Bixschoote

Genre: Military Classic, Dark Ambient, Modern Martial, Bombastic

- http://www.youtube.com/watch?v=Sa2S_HXXneA
- http://www.youtube.com/watch?v=HE-ETHb_YhM
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 = '601440' and opa.orders_id = opb.orders_id and opb.products_id != '601440' 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