Simmons' Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH
1	TIMBER	DR DUCK	Dr Duck	UNCATEGORIZED	Uncategorized	TIMBER\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	DR DUCK HANDWARMER	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5680	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Dr Duck Handwarmer	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	1000	DDHW-1959T	99278	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dr-duck/dr-duck-handwarmer-99278	DDHW-1959T	0
2	[empty string]	DR DUCK	Dr Duck	UNCATEGORIZED	Uncategorized	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	DR DUCK WADER BAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5680	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Dr Duck Wader Bag	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	1000	DDWB-1947T	99282	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dr-duck/dr-duck-wader-bag-99282	DDWB-1947T	0
3	REALTREE_EDGE	KNIGHT + HALE GAME C	Knight + Hale Game C	HUNTING	Hunting>Bags>Game Carrier & Waist Pack	REALTREE_EDGE\|NULL\|NULL	1	99.99	0	99.99	3905-DEFAULT-l.jpg	99.99	3905-DEFAULT-m.jpg	KNIGHT+HALE RUN N GUN 200	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	167	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	54	50-to-100	0.00	[empty string]	Knight & Hale Run-N-Gun 200 Turkey Vests	<p>The Run-N-Gun 200 Turkey Vest is super lightweight at 1.5 pounds. It features a 198-cubic-inch backpack that is bladder compatible, 4 zippered pouches, 5 additional pockets, a decoy sling and incorporates a MOLLE system to add on additional pouches. It incorporates a comfortable 6-layer removable seat, too. The Run-N-Gun 200 Turkey Vest is offered in Mossy Oak Obsession, Bottomland, and Realtree Edge.</p><p><strong>FEATURES:</strong></p><ul><li>Super lightweight 1.5 pounds</li><li>10-point adjustment system offers a comfortable fit for any size</li><li>198-cubic-inch backpack that is bladder compatible</li><li>4 zippered pouches</li><li>5 additional pockets</li><li>MOLLE system for even more storage</li></ul>	[empty string]	N	99.99	99.99	[empty string]	3905-DEFAULT-s.jpg	[empty string]	1000	1000	KHT0065	141160	GAME CARRIER & WAIST PACK	EMPTY	EMPTY	0	0	0	EMPTY	knight-hale-game-c/knight-hale-run-n-gun-200-turkey-vests-141160	KHT0065	0
4	OBSESSION	KNIGHT + HALE GAME C	Knight + Hale Game C	HUNTING	Hunting>Bags>Game Carrier & Waist Pack	OBSESSION\|NULL\|NULL	1	99.99	0	99.99	3906-DEFAULT-l.jpg	99.99	3906-DEFAULT-m.jpg	KNIGHT+HALE RUN N GUN 200	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	167	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	112	50-to-100	0.00	[empty string]	Knight & Hale Run-N-Gun 200 Turkey Vests	<p>The Run-N-Gun 200 Turkey Vest is super lightweight at 1.5 pounds. It features a 198-cubic-inch backpack that is bladder compatible, 4 zippered pouches, 5 additional pockets, a decoy sling and incorporates a MOLLE system to add on additional pouches. It incorporates a comfortable 6-layer removable seat, too. The Run-N-Gun 200 Turkey Vest is offered in Mossy Oak Obsession, Bottomland, and Realtree Edge.</p><p><strong>FEATURES:</strong></p><ul><li>Super lightweight 1.5 pounds</li><li>10-point adjustment system offers a comfortable fit for any size</li><li>198-cubic-inch backpack that is bladder compatible</li><li>4 zippered pouches</li><li>5 additional pockets</li><li>MOLLE system for even more storage</li></ul>	[empty string]	N	99.99	99.99	[empty string]	3906-DEFAULT-s.jpg	[empty string]	1000	1000	KHT0066	141161	GAME CARRIER & WAIST PACK	EMPTY	EMPTY	0	0	0	EMPTY	knight-hale-game-c/knight-hale-run-n-gun-200-turkey-vests-141161	KHT0066	0
5	[empty string]	KNIGHT + HALE GAME C	Knight + Hale Game C	CLOTHING	Clothing>Hunting>Outerwear>Men	[empty string]	1	49.99	0	49.99	27880-DEFAULT-l.jpg	49.99	27880-DEFAULT-m.jpg	KNIGHT+HALE SNAKE GAITERS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	167	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	11	25-to-50	0.00	[empty string]	Knight+Hale Realtree Snake Gaiters - OD Green	<ul><li>Lightweight, form-fitting Snake Gaiters are far more comfortable and way less hot than a pair of big, clunky snake boots. Shield covered by a thornproof ballistic nylon.</li><li>Internal polycarbonate shield that protects your ankle and calf 360 degrees.</li><li>The polycarbonate shield is covered by a thornproof ballistic nylon.</li></ul>	[empty string]	N	49.99	49.99	[empty string]	27880-DEFAULT-s.jpg	[empty string]	1000	1000	KHT0094	141164	OUTERWEAR	MEN	EMPTY	0	0	0	HUNTING	knight-hale-game-c/knight-hale-realtree-snake-gaiters-od-green-141164	KHT0094	0
6	BOTTOMLAND	KNIGHT + HALE GAME C	Knight + Hale Game C	HUNTING	Hunting>Bags>Game Carrier & Waist Pack	BOTTOMLAND\|NULL\|NULL	1	99.99	0	99.99	3907-DEFAULT-l.jpg	99.99	3907-DEFAULT-m.jpg	KNIGHT+HALE RUN N GUN 200	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	167	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50	50-to-100	0.00	[empty string]	Knight & Hale Run-N-Gun 200 Turkey Vests	<p>The Run-N-Gun 200 Turkey Vest is super lightweight at 1.5 pounds. It features a 198-cubic-inch backpack that is bladder compatible, 4 zippered pouches, 5 additional pockets, a decoy sling and incorporates a MOLLE system to add on additional pouches. It incorporates a comfortable 6-layer removable seat, too. The Run-N-Gun 200 Turkey Vest is offered in Mossy Oak Obsession, Bottomland, and Realtree Edge.</p><p><strong>FEATURES:</strong></p><ul><li>Super lightweight 1.5 pounds</li><li>10-point adjustment system offers a comfortable fit for any size</li><li>198-cubic-inch backpack that is bladder compatible</li><li>4 zippered pouches</li><li>5 additional pockets</li><li>MOLLE system for even more storage</li></ul>	[empty string]	N	99.99	99.99	[empty string]	3907-DEFAULT-s.jpg	[empty string]	1000	1000	KHT0095	141165	GAME CARRIER & WAIST PACK	EMPTY	EMPTY	0	0	0	EMPTY	knight-hale-game-c/knight-hale-run-n-gun-200-turkey-vests-141165	KHT0095	0
7	[empty string]	KNIGHT + HALE GAME C	Knight + Hale Game C	NEW BUILDS	New Builds	[empty string]	1	59.99	0	59.99	27881-DEFAULT-l.jpg	59.99	27881-DEFAULT-m.jpg	KNIGHT+HALE TURKEY CHEST PACK	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	167	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	1	50-to-100	0.00	[empty string]	Knight+Hale Run N Gun 100 Turkey Chest Pack	<p>The Knight and Hale Run N Gun 100 Turkey Chest Rig is designed for the mobile turkey hunter who relies on speed and stealth to get within range of a wary gobbler. It moves away from the traditional vest design where gear is located along the sides of the torso. Instead, the Chest Rig centrally locates essential gear for fast and easy retrieval. A rigid front hatch flips forward for easy viewing and call retrieval, while strong magnetic snaps keep the hatch quietly and securely closed. The chest rig features an internal striker holder and pot-call pocket. There's plenty of room for locator calls, gloves and a face mask. Four external mesh pockets hold mouth calls and a large zippered pocket is for license, wallet or cell phone. There's also an integrated box call pouch with elastic cinch cord. With fully-adjustable straps with quick release buckles, the Chest Rig will securely hold your gear while it's easy to put on and take off.</p><p><strong>Specifications & Features</strong></p><ul><li>Ultra-compact and lightweight design won't slow down run-and-gun hunters</li><li>Chest rig centrally locates essential gear for fast and easy retrieval</li><li>Fully adjustable straps with quick-release buckles make gearing up and unloading a cinch</li><li>Rigid front hatch flips forward for easy viewing and call retrieval while magnetic snaps keep hatch quietly and securely closed</li><li>Available in Mossy Oak Bottomland camo</li></ul>	[empty string]	N	59.99	59.99	[empty string]	27881-DEFAULT-s.jpg	[empty string]	1000	1000	KHT0103	141167	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	knight-hale-game-c/knight-hale-run-n-gun-100-turkey-chest-pack-141167	KHT0103	0
8	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	9.99	0	9.99	8483-DEFAULT-l.jpg	9.99	8483-DEFAULT-m.jpg	TINKS W5106 SCENT REEL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	5-to-10	0.00	[empty string]	Tink's Scent Reel	<p>The new Tink's Scent Reel dispersal system enables you to maximize the effectiveness of your favorite Tink's lures and scents. Tink's Scent Reel is a retractable, compact and easy-to-use device that will put an abundant amount of scent in the woods with less mess.</p><p>Slide the lock switch to unlock the reservoir cap and fill with 1-ounce of your favorite Tink's lure. Replace the cap and lock. A leak-proof o-ring ensures you won't lose a drop. When you reach your hunt location, simply pull the hanging loop to unwind the wick to the desired length, up to 10", and hang. When the hunt is over, turn the reel to wind in the wick.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>10" Retractable Wick</li><li>Convenient, Durable & Rugged Design</li><li>Reflective Strip To Quickly Locate</li><li>Leak-Proof O-Ring System</li><li>Size: 2.5 Inches</li></ul>	[empty string]	N	9.99	9.99	[empty string]	8483-DEFAULT-s.jpg	[empty string]	1000	1000	W5106	236770	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-scent-reel-236770	W5106	0
9	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	14.99	0	19.99	8507-DEFAULT-l.jpg	14.99	8507-DEFAULT-m.jpg	TINKS #69 SCENT BOMB	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Tink's #69 Doe-In-Rut Value Pack 2 Oz.	<p>A great buy for the avid whitetail deer hunter! Featuring a 2-ounce bottle of Tink's #69 Doe-in-Rut Buck Lure and a 1-ounce Scent Bomb. Pour the lure into the included Scent Bomb to soak the wick, then hang for all-day attraction.</p><p>Tink's #69 Doe-In-Rut Buck Lure is 100% natural doe estrous urine collected from live whitetail does during their estrous cycle. Tink's quality controlled formula keeps Tink's #69 Doe-In-Rut Buck Lure at the peak level of performance. Tink's #69 Doe-In-Rut Buck Lure, the standard on which all deer lures are measured, produces great results during the pre-rut and rut.</p>	[empty string]	N	19.99	19.99	[empty string]	8507-DEFAULT-s.jpg	[empty string]	1000	1000	W5825	236795	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-69-doe-in-rut-value-pack-2-oz-236795	W5825	0
10	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	6.99	0	6.99	8476-DEFAULT-l.jpg	6.99	8476-DEFAULT-m.jpg	TINKS W5841 SCENT BOMB	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	5-to-10	0.00	[empty string]	Tink's Scent Bomb - 3 Pack	<p>Tink's Scent Bombs the most efficient way to disperse scent today. They can be used as yardage markers, works with all cover scents and lures, and hangs in a tree to put more scent into the air.</p>	[empty string]	N	6.99	6.99	[empty string]	8476-DEFAULT-s.jpg	[empty string]	1000	1000	W5841	236796	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-scent-bomb-3-pack-236796	W5841	0

CACHED

false

EXECUTIONTIME

1

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc