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
Intense Hammer Rage- Deathchunkgoregrind CD on Fresh Blood
Intense Hammer Rage- Deathchunkgoregrind CD on Fresh Blood
$10.00
Search
 

Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Datura- Durman Video PRO-DVDR on Coyote Records
[DVD]
$14.00

the 1st and only official DVD from this amazing Ultra Brutal Death Metal band from Russia, includes incredible footage from the following: Live In Kirovsk (27.01.2007): 01 - Hypertrophic Sodom 02 - Stench And Madness 03 - Blessed Are The Sick (Cover) 04 - Wrere The Fuck Are You From 05 - Carnivorous Ways (Cover) 06 - Dark Harmonists 07 - Cap Of A Golden Cunt 08 - Cause Of Death (Cover) Noise Fest - Live In Kramatorsk (summer '05): 01 - Supertzar 02 - Operation Saturn Live In Dneprodym (autumn 2005): 01 - Supertzar 02 - Operation Saturn 03 - Godzilnik 04 - Bent Within Live In Uzhgorod (spring 2006): 01 - Operation Saturn 02 - Bent Within 03 - Torn Into Enthrallment (Cover) Interview by Lewis (Moscow'05) Interview with Bredor (spring'99) Official Videoclip "Supertzar" and more, A MUST!!!

This product was added to our catalog on Thursday 18 August, 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 = '8623' and opa.orders_id = opb.orders_id and opb.products_id != '8623' 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]