A Challenge Of Honour – HAVAMAL III - Materialschlacht LP Lim52

LP comes as brown vinyl on gatefold poster cover in a superlimited edition of 52 copies only.
Info: The ultra-rare pre-ACOH CDR "Blood Under The Ice" + the only 4 songs of the never released side-project "Saloth Sar" + a unreleased "Materialschlacht" Single for the first time on LP-vinyl !


A1. Blood Under The Ice - Replace The Skin
A2. Blood Under The Ice - This Morrow
A3. Blood Under The Ice - Die Kriegserklärung
A4. Blood Under The Ice - Eisen, Stahl & Kugelregen
A5. Materialschlacht - Halfway To Lhasa
B1. Saloth Sar - We Are The Childeren
B2. Saloth Sar - Stand Up Tall
B3. Saloth Sar - Our Bloody Valentine
B4. Saloth Sar - War Is Peace
B5. Materialschlacht - Drepung Monastery

Genre: Martial Industrial, Symphonic, Dark Ambient, Classical, Bombastic
Like: Wappenbund, Cold Fusion, Leger des Heils, Derniere Volonte

Status: Only 2. copies available!
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 = '602418' and opa.orders_id = opb.orders_id and opb.products_id != '602418' 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