Main Homepage » Catalog Homepage » Blue Guns » 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
Glock 19/23/32 $45.95

Glock 19/23/32 - Train safe! Practice with what you carry. Find the gun that fits your holster

This product was added to our catalog on Friday 10 December, 2010.
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 = '135' and opa.orders_id = opb.orders_id and opb.products_id != '135' 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]