BARBAROSSA UMTRUNK - Tagebuch eines Krieges 2005-2015 CD (Lim300

: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 :-)


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


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