A Challenge Of Honour - HAVAMAL I - The Right Place LP (Lim52)

LP comes as blue vinyl on gatefold poster cover in a superlimited edition of 52 copies only.
Info: The ultra-rare debut CDR of ACOH for the first time on vinyl !


A1. The Right Place
A2. Magadan
A3. Wir Sind Soldaten
A4. We Must Not Fear
A5. Fatherless
A6. The Dragon's Breath
B1. ...Or Hate Him
B2. Bow Belle
B3. Paranoid Theories
B4. Blood And Honour
B5. Defented To The Death
B6. Here We Are Again!!!

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