13.50€

BloodSoil -Endtimes CD (Lim270)
[CD2016]

CD in jewel case is limited to 270 copies.
Info: After four years BloodSoil comes back. Endtimes: 6 anthems conforming a new manifesto against the Modern World, a soundtrack for the dark times we must face as civilization.


Tracklist:
01. Endtimes 4:29
02. The March 8:43
03. Resistance 5:29
04. Social Dissolution 8:43
05. Collapse 4:20
06. The Hidden Truth 11:06


Genre: Dark Ambient, Martial Industrial
Like: Striider, Legionarii, Tsidmz, Seuchensturm, Das Brandopfer

Status: Only 2. copies !

SOUND FILE:
-https://www.youtube.com/watch?v=RgyOmMHR5RE
-https://www.youtube.com/watch?v=_iE-Nwr8owY
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 = '602422' and opa.orders_id = opb.orders_id and opb.products_id != '602422' 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]