JÖRVALLR - Seul CDr (Lim100)

Profi CDr comes in jewel case and is limited to 100 hand.numbered copies.
Info: First debut album from the fantastic neofolk band from france :-)
On because traces of death in june, darkwood, sol invictus or fire + ice !


01. Introduction
02. Last Days
03. Regrets
04. Over the Flames and the Ashes
05. L'Attente
06. The Fire will Burn Again
07. All my Realm
08. Don't Leave me Alone
09. Une Ombre sur la Pierre

Genre: Neofolk, Apocalyptic Pop
Like: Death In June, Darkwood, Sonne Hagal, Forseti, Sol Invictus, Fire + Ice

- http://youtu.be/Vu6Bhi4ODdc
- https://soundcloud.com/skullline/jorvallr-over-the-flames-and-the-ashes
- https://soundcloud.com/skullline/jorvallr-the-fire-will-burn-again
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 = '602137' and opa.orders_id = opb.orders_id and opb.products_id != '602137' 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