We are still in the process of updating and adding new items to the store. If you don't see what you are looking for, check back in a day or so, or give us a shout by using the feedback link.

	APPAREL [165] ASP \| Blackhawk \| Cold Steel \| Hatch \| HWI \| Ka-Bar \| Kershaw \| Original SWAT \| Safariland \| Schrade \| Spyderco Knives
	Books & Videos [16] BLACKHAWK \| Cold Steel \| Garrett Detectors \| Spyderco Knives \| United Cutlery
	Catalogs & Accessories [11] ASP \| Spyderco Knives
	Eyewear [164] Blackhawk \| Body Glove Eyewear \| Bolle \| Field & Stream Eyewear \| Gargoyles \| Howard Leight \| Nite-Ize \| Serengeti Eyewear \| Uncle Mike's
	Footwear [98] Blackhawk \| Original SWAT
	Gifts [131] 3-IN-ONE \| Fisher Space Pens \| Fury Sporting Cutlery \| Lava \| Maxpedition \| Mustang Knives \| Nite-Ize \| Ogon Designs \| Spot Shot \| Tactical Operations Products \| Tool Logic \| Ultimaswiss \| WD-40 \| Word-Lock \| X-14
	Kitchen Cutlery [106] Al Mar \| Boker \| Buck \| Cold Steel \| DMT \| Fury \| Kanetsune \| Kershaw \| Ontario \| Smith's Sharpener \| Timberline Knives
	Knives [3520] 888 Triple Eight Professional \| A.O.W. \| Al Mar \| ASP \| Bear Cutlery \| Becker \| Blackhawk \| Boker \| Buck Knives \| Byrd \| Camillus Knives \| Case \| Coast \| Cold Steel \| Colonial Knife \| Columbia River Knife & Tool \| Condor Tool & Knife \| Dark Ops \| Fury \| GenPro \| Gerber \| Hogue \| Ka-Bar \| Kanetsune \| Kershaw \| Leatherman \| Master Cutlery \| Maxpedition \| Muela of Spain \| Mustang \| Nite-Ize \| Ontario \| Pro-Tech \| Schrade \| Seber Design Group \| Sentry Solutions \| Smith & Wesson \| SOG \| Spyderco Knives \| Timberline Knives \| Tops Knives \| Uncle Mike's \| Underwater Kinetics \| United Cutlery \| Vtech \| Wenger \| Winchester
	Law Enforcement [18343] Alta Tactical \| ASP \| B-Square \| Bianchi \| Blackhawk \| Break Free \| Butler Creek \| Code Red Headsets \| Cold Steel \| Command Arms Accessories \| Condor Tool & Knife \| Damascus Gloves \| Defense Tech \| Fobus Holster \| Forensics Source \| Fury \| Garrett \| Gear And Bag \| Hatch \| Hoppe's \| Howard Leight \| HWI \| Insight \| Ka-Bar \| Maxpedition \| Monadnock \| Nite-Ize \| NovaTac \| OtterBox \| Peerless \| Pelican Products \| Sabre \| Safariland \| Smith & Wesson \| Streamlight \| Tactical Operations Products \| Texsport \| Tornado \| Uncle Mike's \| Underwater Kinetics \| United Cutlery \| Zak Tools
	Lighters [305] Brunton \| Primus \| Windmill \| Zippo
	Lighting [1058] ASP \| Blackhawk \| Brunton \| Coast \| Command Arms Accessories \| Energizer \| Essential Gear \| Fenix Flashlights \| Fury \| Gerber \| Glo-Toob Lighting \| Hellfighter Lights \| ICON Flashlights \| Insight \| Leatherman \| MagLite \| Maxpedition \| Mustang \| Nite-Ize \| NovaTac \| Pelican Products \| Photon Micro-Lights \| Princeton Tec \| QuiqLite \| Safariland \| Smith & Wesson \| Streamlight \| SwissTech \| Tac-Com Batteries \| Tactical Operations Products \| TerraLUX \| Texsport \| Tool Logic \| Tornado \| Underwater Kinetics
	Optics [91] Alpen \| Brunton \| Bushnell \| Celestron \| Countersniper Optics \| Insight \| Mustang \| Night Owl Optics
	Outdoor [335] Blackhawk \| Brunton \| Bushnell \| Essential Gear \| Fury \| Hatch \| Highgear \| Kershaw \| Marksman \| Master Lock \| Maxpedition \| Mustang \| New Balance \| Nite-Ize \| OtterBox \| Pelican Products \| Primus \| Riot Gear \| Sport Brella \| Suunto \| Texsport \| Tops Knives \| Underwater Kinetics \| Word-Lock \| Zippo
	Pens [186] Browning \| Cold Steel \| Columbia River Knife & Tool \| Fisher Space Pens \| Fury \| Mil-Tac \| Nite-Ize \| Schrade \| Smith & Wesson \| Spyderco \| Timberline Knives \| Ultimaswiss \| Wagner \| Zippo
	Sharpeners [230] AccuSharp \| Boker \| Buck \| Byrd \| Columbia River Knife & Tool \| DMT \| Fury \| Gatco Sharpeners \| Gerber \| Kershaw \| Lansky \| Schrade \| Smith & Wesson \| Smith's Sharpener \| SOG \| Spyderco \| United Cutlery
	Sicssors [17] Buck \| Clauss \| Condor Tool & Knife \| Fury \| Gerber \| Kershaw \| SOG
	Swords [95] Cold Steel \| Condor Tool & Knife \| Fury \| Master Cutlery \| United Cutlery \| Valiant Armoury
	Tools [349] Blackhawk \| Boker \| Buck \| Byrd \| Coast \| Cold Steel \| Colonial Knife \| Columbia River Knife & Tool \| Condor Tool & Knife \| Dakota Watches \| Fury \| Gerber \| Highgear \| Kershaw \| Leatherman \| Master Cutlery \| Mustang \| Nite-Ize \| Schrade \| SOG \| SwissTech \| Tool Logic \| Tops Knives \| Ultimaswiss \| United Cutlery \| Wenger \| Winchester
	Watches [143] Carbon 14 Watches \| Dakota Watches \| Freestyle \| Fury \| Highgear \| New Balance \| Origo \| Stryker Watch \| Truglo Watch Company \| Wenger

Table './castleen_com_-_store/SC_products' is marked as crashed and should be repaired

SELECT t1.*, t3.thumbnail FROM SC_products t1 LEFT JOIN SC_product_list_item t2 ON t1.productID=t2.productID LEFT JOIN SC_product_pictures t3 ON t1.default_picture=t3.photoID WHERE t1.enabled=1 AND t1.categoryID != 1 AND t2.list_id='specialoffers' ORDER BY t2.priority ASC