Main Homepage » Catalog Homepage » Clothing » 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 (14)
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-> (14)
Videos / DVDs (11)
Healing Products (2)
What's New? more
Rattan Rings
Rattan Rings
$20.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
Tank Top - Women's $20.00

Available Options:
Size:
This product was added to our catalog on Friday 14 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 = '4' and opa.orders_id = opb.orders_id and opb.products_id != '4' 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]