Top » Catalog » UNITED UNDERGROUND RECORDS » 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)
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
NO BULLSHIT- Vol. 1-4 Compilation CD on United Underground Rec.
[CD]
$5.00

SPECIAL PRICED first release on United Underground records (a division of Sevared Records) is a compilation of the 1st 4 comp. 7" releases by the sick 80's styled hardcore label NO WAY RECORDS. All 4 of these sick comps had a 1000 copies pressed and are all sold out, and now they all appear on 1 sick CD comp. The amazing artist's featured on this crushing comp are: Career Suicide, Government Warning, Sturng Up, Direct Control, Rabies, Warkrime, Cardiac Arrest, Wasted Time, Life Trap, Citizens Patrol, Anit You, Born Bad, Bad Dirty Hate, Social Circle, Brain Handle, Socialcide, Double Negative, Out Cold, Acid Reflux, Chronic Seizure, Civic Progress, Logic Problem, Violent Arrest and Insomino, all exclusive tracks to this comp, 24 of the sickest 80's styled Hardcore bands out today from around the world, LIMITED TO ONLY 200 COPIES!!! GET YOUR COPY NOW!!!!

Current Reviews: 2
This product was added to our catalog on Saturday 07 January, 2012.
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 = '9095' and opa.orders_id = opb.orders_id and opb.products_id != '9095' 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]