Hagshadow Distribution

Home » Catalog » Compact Discs » V/A » E-NO

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

Cloama - Death Certificate 7'
£5.00

Search Items

V/A NOISE=NOISE CDR
[E-NO]

£6.00

Click to enlarge

This CDR represents some of the artists who performed live at The NOISE=NOISE Festival at the Foundry London 25.10.2008

Band/track list: Baraclough - Hunter K.T
London Concrete - Combine 23
J.M. Bowers - October
The Noiser - Metapercussions- Deconstruct 1.1
ANTIchildLEAGUE - Bigfatarseoverpopulatedestroy premix 1.
Kayaka - Crackin Breakfast
Skat Injector - Seagulled Catamite
Ryan Jordan - Assisted Breathing

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 = '774' and ca.customers_id = cb.customers_id and opb.products_id != '774' 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]