Main Homepage » Catalog Homepage » Videos / DVDs » My Account  |  Cart Contents  |  Checkout   
Beat the crap out of Cancer (1)
Blue Guns (11)
Books (2)
Clothing (21)
Grip Tape (1)
hardwood weapons (14)
KIL Tournament (1)
MMA/Boxing gear (3)
Specials and one offs (7)
Training knives (all styles) (14)
Rattan (18)
Bags (5)
Protective Gear-> (13)
Weapons-> (13)
Videos / DVDs (11)
Healing Products (2)
What's New? more
Trainer Batangas Balisong
Trainer Batangas Balisong
Shipping & Returns
Contact Us
A Brief History of Filipino Martial Arts
1962 Tech Sequence
An Interview with The Dog Brothers
Kali - Means To Scrape
KMTS - News
Benny the Jet's Fight Night $30.00

Get Ready for three rough and tumble matches between the legendary Benny ?The Jet? Urquidez and three great champions: Tamashiro, Suzuki, and Sprague Bonus Features: This DVD includes a great collection of bonus features: * Benny ?The Jet? on Discovery Channel; * Benny fights against Adam Urquidez, Naito, * Dana Goodson, and Howard Jackson. Special commentary and footage of Benny vs. Jackie Chan in ?Wheels On Meals? and ?Dragons Forever?. Additional special features by Benny himself on ?How to Wrap your Hands?, ?Kickboxing Basics? and ?What is Kickboxing?? If you are a fan of Benny, you want this DVD! If you do not know about Benny "The Jet" Urquidez, then you definitely want this DVD! Why? This DVD will show you why. Approximately 97 minutes

This product was added to our catalog on Friday 27 August, 2010.
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 = '116' and opa.orders_id = opb.orders_id and opb.products_id != '116' 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 6