TSIDMZ (Boris Nad) - Sailing to Itaca MCD (Lim88)

TSIDMZ "Thulesehnsucht In Der Maschinenzeit"
3" Mini CDr in jewel case, limited to 88 numbered copies.
Info: This compilation with Texts by "Boris Nad", with exclusive and unreleased material, colaboration tracks with La Derniere Attaque & Sonnenkind, Stefania Domizia, Corazzata Valdemone and L'Effet C'Est Moi
*comes with different CD label pictures*


01. TSIDMZ - Itaca
02. Suverana Vanguard - 25 Days of Gods
03. TSIDMZ - War Song (God of War) feat. La Derniere Attaque & Sonnenkind
04. TSIDMZ - Itaca (live 07/09/2013) feat. Stefania Domizia, CorazzataValdemone and L'Effet C'Est Moi

Genre: Ritual Industrial, Dark Ambient, Martial
Like: Arditi, Barbarossa Umtrunk, Das Brandopfer, BloodSoil, Striider, Legionarii, Beutewaffen

- https://www.youtube.com/watch?v=15elaSFHUuU
Reviews (1)
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 = '602004' and opa.orders_id = opb.orders_id and opb.products_id != '602004' 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