Top » Catalog » DVD / VIDEOS » DVD 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)
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
Depravity Savage- Merancang Neraka CD on Extreme Souls Prod.
Depravity Savage- Merancang Neraka CD on Extreme Souls Prod.
$11.00
Search
 

Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
SEVARED RECORDS- 1st Annual Brutality Reigns Festival DVD
[DVD]
$12.00

Sevared Records is very proud to announce the release of the 1st official DVD of the 1st official annual Sevared Records "Brutality Reigns" Festival 2011!!! This 2 day festival was recorded in high definition video (3 separate HD cameras) and incredible audio!! This DVD will change how you look at festival dvds!! Featuring: Short Bus Pile Up, Visceral Disgorge, Animals Killing People, The Gurchick Tree, Abnormality, Scaphism, Pig Rectum, Malformed, etc.. and behind the scenes footage, and tons more!! Fucking SICK, AND ONLY THE BEGINNING!!! STRICTLY LIMITED TO 1000 COPIES!!! DON'T MISS THIS MONUMENT TO BRUTALITY!!!!!!!!!!!!!!

Current Reviews: 1
This product was added to our catalog on Thursday 01 December, 2011.
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 = '8978' and opa.orders_id = opb.orders_id and opb.products_id != '8978' 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]