14.50€ 9.50€

V/A Sampler - New World Order 2CD (Lim999)
[2CD2007]

2CD in a 6-panel digipak is limited of 999 copies.
***special and exclusive unreleased material***

Tracklist:

1-01. The Sounds Of Earth - Viral Expression (8:18)
1-02. False Mirror - Inner Sargasso (5:55)
1-03. Maya Nadir - Fingertip Trip (4:28)
1-04. Moon - Kyle Of Lockalah (8:53)
1-05. Thomas Nöla Et Son Orchestre - John Singleton Copley (2:50)
1-06. Tonal Y Nagual - Nimnon Soleil (3:44)
1-07. A Challenge Of Honour - Mother Earth (7:36)
1-08. Nebelkorona - Auf Flügeln Des Windes (9:23)
1-09. My Asphyxia - Todesstrafe (3:27)
1-10. Galaxia Obscura - Demolition Ideals (4:26)
1-11. Phragments - Towards A New Horizon (5:11)
1-12. Alison Project, The - After The Cut (7:32)
2-01. Institution D.O.L. - Just Cause (4:03)
2-02. Flutwacht - New Law (4:32)
2-03. Noisewerrrrk - Dystopia (3:45)
2-04. Izanami's Labour Pains - Yasukuni Jinja Shall Burn (4:05)
2-05. SKM-ETR - Spreading The Disease (4:48)
2-06. Invisible Front - 50°18'48.16N - 18°41'20.09E (6:46)
2-07. Atrox - The Giants Buddhas Of Bamiyan (7:25)
2-08. Kreuzer - Faith, Death And Aggression (4:31)
2-09. Brachial Palsy - Accidental Error (5:56)
2-10. Atomtrakt - Im Schein Des Untergangs (9:11)
2-11. Sky Burial - Last Breaths Of A Dying God (6:57)
2-12. Camisole - Bonechamber V1 (4:05)
2-13. Erik Ursich - Sospeso (4:34)

Genre: Industrial, Modern Classical, Neofolk, Noise, Ambient, Experimental

Status: Only 6. copies available!
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 = '1573' and opa.orders_id = opb.orders_id and opb.products_id != '1573' 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]