9.50€

V/A - LA GRANDE GUERRE CD (Lim100)
[CDr2017]

Profi CDr 8 track (69min) only 100 hand-numbered copies.


Tracklist:

01. FFAA - Aurora
02. Hoplites - Verdun '16
03. Schattenspiel - The Seven Letters Of Verdun
04. Corazzata Valdemone - Gorizia
05. Bloodsoil - Sacred War
06. Darmstadt 1313 - La bataille de la Sommes
07. Death Party Organisation - The Death of Jean Jaurès
08. Front Sonore - La Chanson de Craonne (NA Mix)
09. Porta Vittoria - The Man Who Speaks With Eagles
10. Silent Love of Death - The Dust Soldier
11. Strydwolf - Die Soldaten
12. TSIDMZ (ThuleSehnsucht In Der MaschinenZeit) - After WWI
13. Verdún 1916 - Centauro del Norte
14. Dark Loyalty - Faith with Passion
15. DNF - Cataclismo
16. The Dramatic Theory - Angel
17. La Dernière Attaque - Saltar la trinchera


Genre: Martial , Neoclassic, Military Industrial
Reviews
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 = '602410' and opa.orders_id = opb.orders_id and opb.products_id != '602410' 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

[TEP STOP]