9.50€

DAS BRANDOPFER - Infernal Pacts CD (2nd Lim50)
[CD2012]

CD 18 track (60min) 2nd, handnumb. & limited to 50 copies.
Info: debut album from the mysterious unknown. here makes beautiful martial und military ambient!
-- second edition with other artwork --


Tracklist:

01. Movement of Protest
02. Einsatzbereitschaft
03. Infernal Pacts
04. Der Nebelwerfer
05. Schwarze Sonne (feat. Strydwolf)
06. Uhrsonne Feuer Adler (Striider edit)
07. Defector
08. Der Totentanz (feat. Strydwolf)
09. Panacea
10. Siegfrieds Funeral
11. Onslaught
12. We Shall Never Surrender
13. Burried in Flowers
14. An die Maschinen
15. Unsere Heimat
16. Steinerene Symbole
17. Einheit
18. One Down One Down


Genre: Martial, Militaryambient, Volkmusic, Neoclassic
Like: Striider, Arditi, Ryr, Bunkertor 1, Kriegsturm, ZR19.84, Im Einsatz, TSIDMZ


SOUND FILE:
- http://www.youtube.com/watch?v=porKOBQwSEw
- http://www.youtube.com/watch?v=B4HzJ8bzpVg&
- http://www.youtube.com/watch?v=_ISZjUjdS44
- http://www.youtube.com/watch?v=iGgt29RQO4Q
- http://www.youtube.com/watch?v=PhuN7Kskcsw
- http://www.youtube.com/watch?v=BQZFEh9Pom8
- http://www.youtube.com/watch?v=UuWMXZG2mtw
- http://www.youtube.com/watch?v=POD6UpZa_P0
Reviews
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 = '601207' and opa.orders_id = opb.orders_id and opb.products_id != '601207' 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]