15.50€ 11.00€

V/A Sampler - Instruo Vestri Pro Pugna LP (Lim350)

12" black vinyl, limited of 350 copies.
Info: Cold Spring 15 Year Anniversary Party on 12th November 2005 at the Marquee Club / London.
***new and unreleased tracks and exclusive material***


A. Von Thronstahl - Ein Tag Durch Den Tross (Cornet III) (10:24)
B1. H.E.R.R. - The Baron Of Urga (6:29)
B2. Kriegsfall-U - Spawn Of Worms (3:37)

Genre: Militarypop, Neofolk, Martial, Acoustic

Status: only 5. 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 = '1470' and opa.orders_id = opb.orders_id and opb.products_id != '1470' 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