Main Homepage » Catalog Homepage » Training knives (all styles) » My Account  |  Cart Contents  |  Checkout   
Products
Beat the crap out of Cancer (1)
Blue Guns (11)
Books (2)
Clothing (21)
Grip Tape (1)
hardwood weapons (13)
KIL SWAG (2)
KIL Tournament (1)
MMA/Boxing gear (3)
Specials and one offs (8)
Training knives (all styles) (13)
Rattan (19)
Bags (5)
Protective Gear-> (13)
Weapons-> (15)
Videos / DVDs (11)
Healing Products (2)
What's New? more
Thai Machete
Thai Machete
$49.99
Information
Process
Philosophy
Endorsements
Multimedia
Links
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
Basic Trainer 2.0 $25.00

This is the classic double sided trainer shape. We have added beveled edges for a slick realistic look.

Current Reviews: 2
This product was added to our catalog on Friday 18 November, 2005.
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 = '62' and opa.orders_id = opb.orders_id and opb.products_id != '62' 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

[TEP STOP]