BloodSoil - Endtimes CD Wooden Box (Lim30)
[CD Box2016]

Special black wooden box with an Algiz rune encarved on it, CD + bookled + 2 Pins - limited to only 30 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.

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: Single copie !

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 = '602421' and opa.orders_id = opb.orders_id and opb.products_id != '602421' 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