Hagshadow Distribution
      
  Home » Catalog » Compact Discs » O » NF G My Account  |  Cart Contents  |  Checkout   
Categories
Compact Discs->
  0-9
  A
  B
  C
  D
  E
  F
  G
  H
  I
  J
  K
  L
  M
  N
  O
  P
  Q
  R
  S
  T
  U
  V
  V/A
  W
  X
  Y
  Z
Vinyl->
DVD & Video
Shirts
Magazines & Books
Miscellaneous
Label
New Titles more
V/A - Hated Perversions cd
V/A - Hated Perversions cd
£9.00
Search Items
 

Advanced Search
Ostara - Immaculate Destruction 2CD
[NF G]
£10.00

Richard Leviathan founded OSTARA in 1999 after having worked and toured with DEATH IN JUNE in the late 1990s. The band has been making a name for itself ever since the release of their first album, 'Secret Homeland' in 2000. The second album, 'Kingdom Gone' (2002) broke new ground with songs like 'Bavaria', 'The Trees March North' and 'Overworld' becoming instant favourites among their growing number of fans. In 2003, Leviathan recruited guitarist and composer, Stu Mason for the recording of 'Ultima Thule', an album that placed the band more firmly in the Gothic scene. Now, in 2005, comes the most definitive release to date: 'Immaculate Destruction', a profound and visionary work delivered with a perfect blend of passion, aggression and intimacy. Esoteric, Poetic, Apocalyptic but consistently inventive and contemporary, OSTARA has achieved a unique fusion of lyrical complexity and musical accessibility with songs that appeal to the head and the heart. The album features new band members including Dave Renwick (formerly of BRONSKI BEAT and THE COMMUNARDS). A highly polished and professional production gives 'Immaculate Destruction' a cutting edge sound that will win OSTARA many more admirers. Released in a deluxe double CD limited edition with exclusive material. (Trisol)

Reviews
1104 - The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok

select p.products_id, p.products_image from orders_products opa, orders_products opb, customers ca, customers cb, orders o, products p where opa.products_id = '600' and ca.customers_id = cb.customers_id and opb.products_id != '600' 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]