Categories Accessories AXES BIG KNIVES DAGGERS FANTASY PIECES HUNTING KATANAS MACES MOVIE SWORDS POCKET KNIVES SHIELDS SWORD SETS SWORDS WALL PLAQUES DROP SHIP CLEARANCE Advance Search   Use keywords to find the product you are looking for. Advanced Search Specials Jaguar - Black on Black Lockback Folder Pocket Knife $4.95 $2.95 Latest products Jaguar Black Eagle Lockback Pocket Knife $3.95 $2.95 Shop by Price Under $10.00 From $10.00 to $25.00 From $25.00 to $50.00 From $50.00 to $100.00 $100.00 and above HUNTING Hunting Knives HUNTING 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '24' [TEP STOP]