12.00€ 9.50€

KARMA MARATA - Nepal 23 / Ein Abschied CD (Lim300)

CD (79min.) comes in 4-page bookled in white tray and is limited to 300 hand-numbered copies.
Info: after the first split album "and still remain" & first album "Das Sturmläuten", now the second and last album the very exceptionally band from erfurt (ger.) fantastic melodrama pop meets military pop of the extra class. - tip !

* 50 comes in special 2CD set *


01. Vergehen
02. So geh nun fort
03. Lost and forgotten
04. In meinen Augen stirbt die Welt
05. Glanz der leis verfällt
06. Summer ends
07. Red nights in paris
08. Die Flucht
09. Ein schwarzer Tag
10. Our throne in hell
11. Falling down
12. Requiem
13. No days of glory
14. Staub
15. Black roses on dead hills

Genre: Melodram Pop, Millitary Pop, Neoclassic, Martial
Like: Art Abscons, Leger des Heils, Schattenspiel, Strydwolf, Argheid

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