13.00€

BARBAROSSA UMTRUNK - Tagebuch eines Krieges 2005-2015 CD (Lim300
[CD2016]

:BEST OF: Compilation CD 73 minutes in nice jewel case with 4 page bookled, clear tray, limited & handnumbered copies.
total 300 copies CD 200 copies and 100 copies comes in special edition !
fantastic dark ambient - traditional martial music by (Baron von S) from france in the way to LJDLP.
all tracks new re-mastered and with fantastic atmosphere :-)


Tracklist:

01. Kyffhäuser
02. Le Pays Perdu feat. – Marc-Louis Questin
03. Eldritch Germania
04. Aryana Vaejo
05. Gwer Nemeton feat. – Marc-Louis Questin, Schattenspiel
06. Winter's Reign
07. Vive Le Quebec Libre! feat. – Schattenspiel
08. A la Gloire Du Sacré feat. – Vir Martialis
09. Ungern Khan Le Cavalier Du Vril feat. – TSIDMZ
10. Le Centre Supreme feat. – Schattenspiel
11. The Fourth Political Theory feat. – Alexsandr Duguin, TSIDMZ


Genre: boombastic martial, dark ambient, post-industrial, post-atomic music
Like: Les Joyaux De La Princesse, Karjalan Sissit, Das Brandopfer, Legionarii, Turbund Sturmwerk

SOUND FILE:
-https://www.youtube.com/watch?v=Z99Zzem3Y3M
-https://www.youtube.com/watch?v=5VV9xcoC9ag
-https://www.youtube.com/watch?v=yuFP8U1WAz0
-https://www.youtube.com/watch?v=v5fw4hMGHFA
-https://www.youtube.com/watch?v=xfLRqBJAT_E
-https://www.youtube.com/watch?v=t-8x63NsDDk
-https://www.youtube.com/watch?v=cTjejlAuPic

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