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
Syphilic- Toylets "R" Us CD
Syphilic- Toylets "R" Us CD
$10.00
Search
 

Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
TERRORIZER MAGAZINE (UK)- 1 Year Subscription (13 ISSUES)
[ZINE]
$49.00

USA AND CANADA ONLY!!!!!! Terrorizer and SEVARED RECORDS are proud to be able to make you a subscription offer you just can't refuse - 13 issues for just $49, saving you over $70 on bookstore prices! Why go to all the trouble of walking all the way to the shops to get your monthly feast of extreme metal goodness from Terrorizer when, from the comfort of your armchair, you can order your copies from us directly and have them delivered through your door before the magazine hits the shops, and even better you can save a load of money! A subscription will include all magazines published over twelve months (13 issues) and Fear Candy cover-mount CDs. All this for just $49! (USA and Canada only.) Please allow 28 days for your order to be processed. Delivery of your magazine is dependent on your local postal service. Orders outside Europe may take two weeks **PLEASE NOTE orders will come from Terrorizer Magazine, not from Sevared Records as all orders are forwarded to them to process, thanks!!!

This product was added to our catalog on Wednesday 23 February, 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 = '7997' and opa.orders_id = opb.orders_id and opb.products_id != '7997' 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]