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 Silver Folder Lockback Pocket Knife $3.95 $2.95 Latest products Silver Folder 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 BIG KNIVES BIG KNIVES 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 = '32' [TEP STOP]