12.00€ 10.50€

ART ABSCONS / GABE UNRUH - Split CD (2nd Lim500)
[CD2012]

This 2nd 16 track split CD (79min) comes with 4-page picture bookled and is limited of 500 hand-numbered copies.
Second edition from the CDr 2010 limited to 100 copies.
Info: Art Abscons with fantastic melodram martial pop and Gabe-Unruh with great Deutsch-Pop make this split releases wonderful.
*** With great remix from Strydwolf and ZR19.84. ***

Tracklist:

01. Art Absons - Tochter Feuer
02. Art Absons - Killing Time
03. Art Absons - Rose of Picardy (alternative Fassung)
04. Art Absons - Wolfseinsamkeit
05. Art Absons - Somnium 1 ( GU remix)
06. Art Absons - Überall Himmel Überall Hülle
07. Art Absons - Schrecken und Schönheit (feat. Kunstgerecht)
08. Art Absons - Somnium 1 (GU minusremix)
09. Gabe-Unruh - Gedankenpolizei
10. Gabe-Unruh - Das Pendel
11. Gabe-Unruh - Ausgangssperre
12. Gabe-Unruh - Elektrogravitationsflugkreisel
13. Gabe-Unruh - Gedankenpolizei (Strydwolf III Chormix)
14. Gabe-Unruh - Elektrogravitationsflugkreisel (Art Abscons remix)
15. Gabe-Unruh - Singt eisern (ZR19.84 remix)
16. Gabe-Unruh - Gedankenpolizei (Strydwolf rmx)


Genre: Melodram-Deutsch-Pop, Martial, Ambient, Neoclassic
Like: Leger des Heils, Schattenspiel, Exemtum, Waffenruhe, Heiliges Licht

SOUND FILE:
- http://www.youtube.com/watch?v=WXpnH15XBlw
- http://www.youtube.com/watch?v=X95eSku89mk
- http://www.youtube.com/watch?v=bOi_KVZgSNc
- http://www.youtube.com/watch?v=2DCtMjyQHX0
- http://www.youtube.com/watch?v=l9vUnMbGnJ0
- http://www.youtube.com/watch?v=QvlIjp3id-w
Reviews (2)
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 = '601208' and opa.orders_id = opb.orders_id and opb.products_id != '601208' 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]