Top » Catalog » ZINES / BOOKS » ZINE 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
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
Antichrist- Issue 10/2010
[ZINE]
$7.00

Awesome Brutal zine pro printed from the Ukraine, Amazing cover art by Mark Riddick!!! VERY LIMITED!! A4, 48 pages, glossy paper, English language, full colored two-sided layout. Inside - DECREPIDEMIC (Brutal-death metal, Portugal) BONE GNAWER (Kam Lee) (Old-school death metal, USA-Sweden) EVIL ARMY (Old-school thrash metal, USA) TYRANTS BLOOD (Death/thrash/black metal, Canada) COATHANGER ABORTION (Brutal death metal, USA) ARMOUR (Old-school hard'n'heavy, Finland) TIRAN (Old-school thrash/death metal, Russia) SEPTORY (Old-school death metal, Russia) DATURA (Brutal death metal, Ukraina) APOKEFALE (Post-black metal, Russia) ST. MADNESS (Metal/thrash metal, USA) DISHAMMER (Old-school punk/thrash metal, Spain) BLACK SISTER (Old-school thrash metal, Scotland-Hungary) REVOCATION (Metal/death/thrash metal, USA) LESHAK (Folk death metal, Russia) SODOMIZER/HELLKOMMANDER (Speed/death metal, Brazil) VINDICATOR (old-school thrahs metal, USA) + tons of fresh reviews etc...

This product was added to our catalog on Saturday 11 September, 2010.
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 = '7037' and opa.orders_id = opb.orders_id and opb.products_id != '7037' 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]