9.50€

Striider - Runes and Ruins CDr (Lim100)
[CDr2013]

CD 11track comes in jewel case is handnumbered and limited to 100 copies!

Info: third album from one-man project Striider. Striider is Jornt from The Netherlands" very nice military ambient , with drums and martial hymns at the best :))
*** this is the "last" album of STRIIDER ! ***


Tracklist:

01 - Intro
02 - Berlin III
03 - Valkyrja
04 - Nerobefehl
05 - Landjahr (feat. Strydwolf)
06 - Paris I
07 - Berlin IV
08 - Germanium Imperium
09 - Sturmalarm!
10 - For Folk og Fedreland
11 - Outro


Genre: Dark Ambient, Militaryambient, Martial
Like: Das Brandopfer, Arditi, Ryr, Seuchensturm, Les Joyaux de la Princesse
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 = '601815' and opa.orders_id = opb.orders_id and opb.products_id != '601815' 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]