Top » Catalog » CDs » R » CD My Account  |  Cart Contents  |  Checkout   
Categories
SEVARED RECORDS RELEASES (193)
CD SALE Until 12/31/15 (189)
OFFICIAL DISTRIBUTED RELEASES (261)
UNITED UNDERGROUND RECORDS (4)
CDs-> (3056)
  A (224)
  B (185)
  C (228)
  D (346)
  E (150)
  F (108)
  G (145)
  H (132)
  I (151)
  J (21)
  K (49)
  L (58)
  M (191)
  N (134)
  O (69)
  P (174)
  Q
  R (102)
  S (278)
  T (132)
  U (41)
  V (76)
  W-Z (62)
FREE CDS With Orders!
GOREGIASTIC RECORDS CD SALE!!! (15)
T-SHIRTS / HATS (245)
DVD / VIDEOS (14)
JEWEL CASES (Non-USA Customers) (1)
POSTERS (17)
ZINES / BOOKS (10)
CASSETTES (5)
PATCHES (3)
VINYL (109)
PINS (4)
STICKERS (12)
What's New? more
A Good Day For Killing- Dementia Of The Killers MCD on Sick Chai
A Good Day For Killing- Dementia Of The Killers MCD on Sick Chai
$10.00
Search
 

Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
REPULSIVE DISSECTION- Cut Open The Aberration CD on Sevared Rec.
[CD]
$10.00

Highly anticipated Debut Full Length CD of Crushing Brutal Ultra-Guttural Tech. Death Metal. Featuring members of Infected Dissaray (on Unique Leader), Soils Of Fate, Kraanium & Vomitous! 11 Ultra Brutal tracks. Imagine a mix between Disgorge (US w/ Matti Way on vox) and Demilich! Fucking sick!!!! Don't miss out!

Current Reviews: 1
This product was added to our catalog on Monday 05 October, 2009.
Reviews
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '5481' and opa.orders_id = opb.orders_id and opb.products_id != '5481' 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 9

[TEP STOP]