Hagshadow Distribution

Categories

Compact Discs->
Vinyl->
  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
DVD & Video
Shirts
Magazines & Books
Miscellaneous

Label

New Titles

Henrik Nordvargr Björkk - The Dead Never Sleep CD
£12.00

Search Items

ANTIchildLEAGUE - Big Fat Arse 7'
[pipi pupu]

£5.50

Click to enlarge

THE ULTIMATE PMT 7' RELEASE

Side A: BIG FAT ARSE - devastating noise and vocals in your face similar to Whitehouse
Side B: SHIT BABY - Experimental music with uncompromised sinister poems.
LIMITED EDITION OF 250 COPIES
ALL ELECTRONICS BY G.GIVETOGOD
LYRICS: BIG FAT ARSE G.G, SHIT BABY G G.& PATRICK.L.
MIX/PRODUCTION: PATRICK LEAGAS
COVER ART: SALLY SCHUMACHER
release date: 090909 - ©2009

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