Main Homepage » Catalog Homepage » hardwood weapons » 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 (7)
Training knives (all styles) (13)
Rattan (19)
Bags (5)
Protective Gear-> (13)
Weapons-> (15)
Videos / DVDs (11)
Healing Products (2)
What's New? more
3 piece Training Set
3 piece Training Set
$70.00
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
Hardwood Straight Sword $50.00

Available in:

  • Indonesian Hardwood
  • 28" long. These are great for carenza.

    Available Options:
    Type of Wood:
This product was added to our catalog on Saturday 05 February, 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 = '50' and opa.orders_id = opb.orders_id and opb.products_id != '50' 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]