Top » Catalog » Advanced Search » Search Results  |  My Account  |  Cart Contents  |  Checkout | 
Categories
300 Movie (8)
Accessories (192)
Airsoft & Gas Guns (81)
Anime Video Game arms & armor (36)
Apparel (65)
Archery (54)
Arsenal Replicas (50)
Cameras & Optics (82)
Camping (85)
Car Audio & Video (65)
Chainmail  (33)
Clocks (11)
Closeouts
Collectibles and Gifts (135)
Computer Parts & Accessories (19)
Conchos (35)
Contacts (80)
Cookware (170)
Costumes (15)
Decor (119)
Decorative Art Tiles (20)
Dolls & Fairies (71)
Dragon Stuff (88)
Drinkware (33)
DVD’s (1)
Electronics (33)
Fitness Equipment (273)
Flatware (1)
Fountains (28)
Game Room Products (84)
Giftware (85)
GPS Navigation (2)
Health & Beauty (68)
HELLBOY (2)
Helmets & Shields (52)
Home Electronics (114)
Home/Office (35)
Hot Sauce! (12)
Housewares (15)
Jewelry (226)
Kitchen Accessories (21)
Knights Suits of Armor (9)
Knives (1956)
Knives/Multi-Tools (267)
Knuckle Buckles (90)
LED/Flashlights (54)
Lighters (34)
Lingerie (1116)
Lock Pick Items (58)
Luggage (75)
Martial arts (144)
Match Sets (104)
Medieval Apparel (114)
Medieval Figurines (6)
Miscellaneous (63)
MONTHLY SPECIALS (117)
Motorcycle (45)
Movie/Fantasy Masks (12)
Musical Instruments (4)
Native American (53)
Natures Gifts candles (26)
Office Products (5)
Pet Products (7)
Pewter Bracelets (4)
Pewter Pendants (92)
Picnic/Travel Sets (6)
Poker Supplies (67)
Police supplies (62)
Portable Electronics (60)
Purses (166)
Radar Detectors (24)
razor (9)
Real Insects Resin Displays (47)
Renaissance fair (3)
Robes (10)
Scale Models (34)
Self Defense (54)
Sharpeners (3)
Skull & Skeleton Items (126)
Smoking-Tobacco products (9)
Special Promotion 25%off (1)
Spiritual (33)
Sports/Recreational (70)
Stands & Displays (59)
Swords (1162)
Telephones (12)
Throwing Weapons (101)
Tools (15)
Toys & Games (32)
Umbrellas (24)
Watches/Timepieces (1)
Water Filters (8)
Weapons (98)
Zippos & Lighters (180)
What's New? more
DOUBLE Ceramic & Tungsten Knife Sharpener
DOUBLE Ceramic & Tungsten Knife Sharpener
$29.81
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Printable Catalog
Gift Voucher FAQ
Site Map
Bestsellers
01.CLASSIC STAINLESS BOWIE HARDWOOD HANDLE CUSTOM SHEATH
02.15 INCH BLACK 440 STEEL SURVIVAL HUNTING KNIFE & SHEATH
03.2GB DIGITAL MP4 PLAYER
04.Maxam 7pc Restaurant Style Cutlery Set. Features polypropylene h
05.FULL 12 INCH UZUMAKI NARUTO METAL KUNAI KNIFE-RED
06.LOCKBACK KNIFE W/HONED BLADE
07.THE 300 COLLECTION KING LEONIDAS SPARTAN HELMET PENDANT
08.MILITARY POLICE BLACK DOUBLE LOCK HANDCUFFS & KEYS
Products meeting the search criteria Products meeting the search criteria
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join specials_retail_prices s on p.products_id = s.products_id, products_de' at line 1

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), left join specials_retail_prices s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%spartan%' or p.products_model like '%spartan%' or m.manufacturers_name like '%spartan%' or pd.products_description like '%spartan%') )

[TEP STOP]