9.50€

GRABSTEIN - The Mixes CD Metal-Box (Lim33)
[CD2012]

black CD (67min) in vinyl look in a nice round metal movie can, 2 insert + photo and banderole, handnumb.,limited to 33 copies hand-numbed copies.
Info: after the last album "Anne Frank" 2008 ..is here a brand new album from Irisch project. this is different styls of industrial..or with martial influences!

Tracklist:

01. Death in the west (feat. Natja Kristy)
02. V2 (Feat. European Kanon)
03. Interzone (feat. Harsh Discipline)
04. U-518 (Feat. European Kanon)
05. The Train (feat. Natja Kristy) Radio Edit
06. V2 (feat. Talakaman)
07. U-518
08. The train (Feat. Natja Kristy) Full version


Genre: Martial Industrial, Dark Ambient, WAR Industrial
Like: Kriegsturm, TSIDMZ, Bunkertor 1 , Nocturne, Hilter, Gabe-Unruh

SOUND FILE:
- http://www.youtube.com/watch?v=wwLLkTIUjwk
- http://www.youtube.com/watch?v=Lug0BM65yp8
- http://www.youtube.com/watch?feature=player_embedded
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 = '601392' and opa.orders_id = opb.orders_id and opb.products_id != '601392' 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]