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	VENOM,BROWN_PEARL	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	VENOM\|NULL\|NULL,BROWN_PEARL\|NULL\|NULL	1	149.99	0	159.99	36305-DEFAULT-l.jpg	149.99	36305-DEFAULT-m.jpg	ELITE FREAK DUCK CALL	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5785	.ELITEFREAKDUCKCALL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Elite Freak Duck Call	<p>"The Freak" was designed to take the strengths of various calls and blend them into one "do it all" duck call. With a scratchy, raspy tone, mixed with the whiney, nasally sound of a timber call, the possibilities are endless. It has plenty of back pressure which makes it easy to blow and allows the caller to change tones and sound like many different mallard hens. It has unbelievable volume range. It can get loud enough to break down those "high flyers", but can also get soft enough to finish them into the decoy spread. If there is one word to describe this call is would be VERSATILE. Give it a try, and you will quickly discover how "The Freak" earned its name.</p><p> </p>	[empty string]	N	159.99	159.99	[empty string]	36305-DEFAULT-s.jpg	[empty string]	1000	1000	40006	73178	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-freak-duck-call-73178	40006	0
2	BLACK_CHERRY,VENOM,BLUE_PEARL	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	BLACK_CHERRY\|NULL\|NULL,VENOM\|NULL\|NULL,BLUE_PEARL\|NULL\|NULL	1	149.99	0	159.99	36729-DEFAULT-l.jpg	149.99	36729-DEFAULT-m.jpg	ELITE EDGE DUCK CALL	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5785	.ELITEEDGEDUCKCALL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	150-to-200	0.00	[empty string]	Elite Edge Duck Call	<p>The Elite "Edge" is a double reed call that has a great volume range, combined with ease of operation. The "Edge" has a deeper tone and raspier, ducky sound usually found in single reed calls. With the "Edge", the advantage of a double reed is user-friendliness. The disadvantage is NOTHING!<br /></p>	[empty string]	N	159.99	159.99	[empty string]	36729-DEFAULT-s.jpg	[empty string]	1000	1000	46375	73179	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-edge-duck-call-73179	46375	0
3	BLACK_CHERRY,FLAT_BLACK	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	BLACK_CHERRY\|NULL\|NULL,FLAT_BLACK\|NULL\|NULL	1	149.99	0	149.99	36725-DEFAULT-l.jpg	149.99	36725-DEFAULT-m.jpg	ELITE MURDER DUCK CALL	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5785	.ELITEMURDERDUCKCALL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Elite Murder Duck Call	<p>NEW DESIGN!! We added wide "spit grooves" to combat moisture lock, making this lethal call design even better. Don't let the small size of this call fool you. It is a raspy single reed call with tremendous volume and tonal range. You will quickly understand how this call got its name! <br /></p>	[empty string]	N	149.99	159.99	[empty string]	36725-DEFAULT-s.jpg	[empty string]	1000	1000	46409	73183	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-murder-duck-call-73183	46409	0
4	WATERFOWL_TIMBER,WATERFOWL_MARSH	SITKA	Sitka	HUNTING	Hunting	WATERFOWL_TIMBER\|NULL\|NULL,WATERFOWL_MARSH\|NULL\|NULL	1	159.99	0	159.99	9597-DEFAULT-l.jpg	159.99	9597-DEFAULT-m.jpg	SITKA SLING CHOKE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKASLINGCHOKE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	150-to-200	0.00	[empty string]	Sitka Sling Choke - 40058	<p>The Sling Choke pack offers a minimal design for maximum versatility. At almost 800 cubic inches total internal volume, you can wear it on the front when packing in decoys or blind, or on your back during the hunt. The cross angle strap won't impede shouldering a shotgun, and allows quick access to contents without removal.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Sling Design: Ergonomically designed to be worn front or back, the single strap design stays put even when shouldering a shotgun and swivels from front to back to grab gear on the go without having to set the pack down.</li><li>Fowl Noose System: Eight removable nooses make quick work of your bag limit.</li><li>Beverage Sleeve: Keep your hot or cold beverage easily accessible with the adjustable divider in the main compartment.</li><li>Durable Water Repellent finish resists light precipitation and prevents the face fabric from wetting out.</li><li>Imported</li></ul>	[empty string]	N	159.99	159.99	OS	9597-DEFAULT-s.jpg	[empty string]	1000	1000	40058	77748	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sitka/sitka-sling-choke-40058-77748	40058	0
5	WATERFOWL_TIMBER,OPTIFADE_SUBALPINE	SITKA	Sitka	HUNTING	Hunting	WATERFOWL_TIMBER\|NULL\|NULL,OPTIFADE_SUBALPINE\|NULL\|NULL	1	249.99	0	269.99	18112-DEFAULT-l.jpg	249.99	18112-DEFAULT-m.jpg	SITKA MNS EQUINOX TURKEY VEST	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKAEQUINOXTURKEYVEST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	27	250-to-300	0.00	[empty string]	Sitka Equinox Turkey Vest - 600050	<p>This is no traditional turkey vest. We took a pack-like approach and developed a comfortable and efficient vest based on the movement and organizational needs of run-and-gun turkey hunting. It has ample yet minimalist storage -- including magnetic-closing pockets -- to keep box calls, pot calls, strikers and other tools organized and dry. Adjustable straps create a secure fit; a drop-down seat deploys and cinches back up quickly and securely.</p><p><strong>SPECIFICATIONS: </strong></p><ul><li>75-denier brushed-face polyester woven fabric with durable water repellent finish</li><li>Comfortable, ergonomic fit designed for run-and-gun style hunting</li><li>Adjustable pack strap system offers customizable fit in sizes XS-XXL</li><li>Four compression straps reduce bulk and connect to each other to secure a bird</li><li>Removable dual-density foam seat deploys, cinches back up and stays harnessed tight to the pack when on the run</li><li>Water-resistant molded clamshell pocket with magnetic closure keeps two pot calls dry in divided sleeves; stores three diaphragm calls in easy-access slots</li><li>Water-resistant box call storage pocket provides a snug fit to eliminate unwanted noise</li><li>Right- and left-side pockets store four strikers</li><li>Versatile side pocket stores miscellaneous essentials</li><li>Three internal mesh zippered pockets store tags and other small items</li><li>Large zippered back pocket is hydration bladder compatible</li><li>Removable fowl slip noose designed to carry a bird; clips onto shoulder strap</li><li>Zippered shallow top pocket with key clip</li><li>Open top outside pocket stores rain gear</li><li>Two blaze orange flags on back can be deployed for safety</li><li>Total weight: 44.5 oz.</li></ul>	[empty string]	N	269.99	269.99	OS	18112-DEFAULT-s.jpg	[empty string]	1000	1000	600050	77831	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sitka/sitka-equinox-turkey-vest-600050-77831	600050	0
6	BROWN	BOYT	Boyt	HUNTING	Hunting	BROWN\|NULL\|NULL	1	34.99	0	34.99	13095-DEFAULT-l.jpg	34.99	13095-DEFAULT-m.jpg	BOYT LEATHER LEAD	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Boyt Leather Lead	<p><strong>FEATURES</strong></p><ul><li>Top Grade Leather</li><li>Solid Brass Hardware</li><li>Riveted Handle</li><li>1" Width</li><li>Available sizes - 48", 72"</li></ul><p> </p>	[empty string]	N	34.99	34.99	48	13095-DEFAULT-s.jpg	[empty string]	1000	1000	0D48000	91623	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	boyt/boyt-leather-lead-91623	0D48000	0
7	BLAZE_ORANGE	BOYT	Boyt	HUNTING	Hunting	BLAZE_ORANGE\|NULL\|NULL	1	19.99	0	19.99	37958-DEFAULT-l.jpg	19.99	37958-DEFAULT-m.jpg	BOYT FIREFLEX COLLAR	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Boyt Fireflex Collar	[empty string]	[empty string]	N	19.99	19.99	13/17	37958-DEFAULT-s.jpg	[empty string]	1000	1000	18820	91630	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	boyt/boyt-fireflex-collar-91630	18820	0
8	BLAZE_ORANGE	BOYT	Boyt	HUNTING	Hunting	BLAZE_ORANGE\|NULL\|NULL	1	19.99	0	19.99	13101-DEFAULT-l.jpg	19.99	13101-DEFAULT-m.jpg	BOYT FIREFLEX COLLAR	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Boyt Fireflex Collar	[empty string]	[empty string]	N	19.99	19.99	16/20	13101-DEFAULT-s.jpg	[empty string]	1000	1000	18821	91631	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	boyt/boyt-fireflex-collar-91631	18821	0
9	BLAZE_ORANGE	BOYT	Boyt	HUNTING	Hunting	BLAZE_ORANGE\|NULL\|NULL	1	19.99	0	19.99	13103-DEFAULT-l.jpg	19.99	13103-DEFAULT-m.jpg	BOYT FIREFLEX COLLAR	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Boyt Fireflex Collar	[empty string]	[empty string]	N	19.99	19.99	19/23	13103-DEFAULT-s.jpg	[empty string]	1000	1000	18822	91632	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	boyt/boyt-fireflex-collar-91632	18822	0
10	BLAZE_ORANGE	BOYT	Boyt	HUNTING	Hunting	BLAZE_ORANGE\|NULL\|NULL	1	19.99	0	19.99	13105-DEFAULT-l.jpg	19.99	13105-DEFAULT-m.jpg	BOYT FIREFLEX COLLAR	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Boyt Fireflex Collar	[empty string]	[empty string]	N	19.99	19.99	22/26	13105-DEFAULT-s.jpg	[empty string]	1000	1000	18823	91633	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	boyt/boyt-fireflex-collar-91633	18823	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts4 ORDER BY sortposition asc