Main Homepage » Catalog Homepage » 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 (8)
Training knives (all styles) (13)
Rattan (19)
Bags (5)
Protective Gear-> (13)
Weapons-> (15)
  hardwood weapons
Videos / DVDs (11)
Healing Products (2)
What's New? more
Guitar Bag
Guitar Bag
$60.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
Keychain Kitty or Spade $6.00

Made of durable polypropylene

This product was added to our catalog on Saturday 15 January, 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 = '22' and opa.orders_id = opb.orders_id and opb.products_id != '22' 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]