RUKKANOR - Desireth CD (Lim300)

CD 10 track (39min) in jewel case clear tray and 4 page bookled is handnumbered and limited to 300 copies.
Info: Rukkanor is Robert Marciniak also mastermind with Marcin Bachtiak by Cold Fusion...
After the album "Decarah" 2012 is this "Desireth" orchestral bombast neoclassic anthems master album "the last" and the best album from Robert !
* available in special edition Box limited to 40 copies *


01. The Awakening of the King 3:39
02. Desireth 3:30
03. Down the Drain 3:47
04. Crown for the Prince 4:30
05. Welcome Home 4:39
06. Black Dream Brother of Death 3:26
07. The Light of the Future 4:04
08. The Final Trace 3:24
09. The Future is Behind us 4:03
10. A Farewell (No Happy Ending) 3:52

Genre: Neoclassic, Orchestral Bombast, Martial
Like: L'Effet C'Est Moi, Wappenbund, Puissance, Argheid, Ante Bellum

- https://www.youtube.com/watch?v=550h3GTH6rQ
- https://www.youtube.com/watch?v=DMY8osbjC8s
- https://soundcloud.com/skullline/rukkanor-desireth-2015
- http://www.lastfm.de/music/RUKKANOR/Desireth
Reviews (1)
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 = '602261' and opa.orders_id = opb.orders_id and opb.products_id != '602261' 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