Barbarossa Umtrunk & Le Revers Sanglant - L'Age Noir CDr (Lim130

Split profi CDr (73 min.) jewel case is limited 130 hand-numbered copies.
Info: fantastic split album from this two great france dark ambient artists - Tip !


01-Barbarossa Umtrunk - WOLFEN
02-Barbarossa Umtrunk - Fallen Moons
03-Barbarossa Umtrunk - Winter's Reign
04-Barbarossa Umtrunk - Ecoterrorist
05-Barbarossa Umtrunk - La Derniere Doctrine
06-Le Revers Sanglant - Pour en finir
07-Le Revers Sanglant - Le Triomphe de la nuit
08-Le Revers Sanglant - L'Ordre noir
09-Le Revers Sanglant - Lucifer
10-Le Revers Sanglant - Mélancolie
11-Le Revers Sanglant - Au commencement
12-Le Revers Sanglant - Melancolie (Barbarossa Umtrunk remix)
13-Barbarossa Umtrunk - Winter's Reign (Nuclear Nation Remix)

Genre: Dark Ambient, Martial, Experiment
Like: Les Joyaux De La Princesse, Striider, Front Sonore, Legionarii, BloodSoil, Karjalan Sissit

- https://soundcloud.com/skullline/barbarossa-umtrunk-le-revers-langlant-lage-noir-preview
- https://www.youtube.com/watch?v=XNtYFrNBsCM
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 = '602135' and opa.orders_id = opb.orders_id and opb.products_id != '602135' 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