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	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
2	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
3	[empty string]	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	[empty string]	1	189.99	0	199.99	1972-DEFAULT-l.jpg	189.99	1972-DEFAULT-m.jpg	DAKOTA DECOY MALLARD FLOATER 12PK FLOCKED HEADS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	67	150-to-200	0.00	[empty string]	Dakota Decoy X-Treme Mallard Decoys - 12 Pack Flocked Heads	<p>Here in the heart of Central Flyway, we are blessed with season long bunches of mallards. From our state hatched birds in October to the latest migrating flocks in December, they seem to never end! We took our time on our mallards and have designed unquestionably the most life like duck decoy on the market.</p><p>The first thing you will notice is the most life like, hand painted finish ever put on a hunting decoy. Our drakes go through a 24 step painting process, and our hens go through a 16 step painting process. This attention to detail is evident the minute you lay eyes on these decoys!</p><p>Upon further inspection you will notice the 6 different head styles in each dozen. These multiple heads come attached to the decoy, but will spin a full 360 degrees, to give your spread the most realistic look ever achieved with decoys.</p><p>These decoys are manufactured out of the same 60/40 blend of high and low density polyethylene that has been proven extra tough on our goose decoys. We are able to attain the most durable paint possible, to give you years of trouble free use. The decoys are slightly oversized, measuring 16" in length. They have a weighted keel designed with the hunter in mind. We've added a cleat to the front of the keel to lengthen or shorten lines to the desired depth of water.</p><p>The decoys are packaged in dozen packs with 7 drakes with 4 unique head styles, and 5 hens with 2 head styles. One look at these and you'll agree... duck hunting will never be the same!</p>	[empty string]	N	199.99	199.99	[empty string]	1972-DEFAULT-s.jpg	[empty string]	1000	1000	12120	131737	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-x-treme-mallard-decoys-12-pack-flocked-heads-131737	12120	0
4	[empty string]	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	[empty string]	1	299.99	1	269.99	2253-DEFAULT-l.jpg	299.99	2253-DEFAULT-m.jpg	DAKOTA DECOY FULLY FLOCKED WHITEFRONT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	250-to-300	0.00	[empty string]	Dakota Decoy X-Treme Speck Whitefront Flocked 6 Pack	<p>Dakota Decoy Whitefront decoys are by far the most realist Speck decoys available. Our Speck decoys will bring the much expanding speck population to a halt! These decoys are built Dakota Tuff and will be the envy of all speck hunters. The decoys are a one-piece decoy for ease of hunting. The heads are molded into the body, so once you attach the base, these are truly a one piece, TANK! Our specks are constructed with our EVA blend soft material to insure they will withstand everyday abuse hunters deliver to their decoys. Decoys come in 6 packs, which include 3 feeders, 2 actives and 1 sentry. The flocking on the fully flocked decoys will help with hunters worst nightmare...Moisture! Flocked decoys look better when wet. You will not get the wet shine that painted decoys suffer. </p><p><strong>SPECIFICATIONS</strong></p><ul><li>Weight - 20 lbs</li><li>Dimensions - 24.0 x 21.0 x 17.0 inches</li></ul><p> </p><p> </p><p> </p><p> </p><p> </p>	[empty string]	Y	269.99	269.99	[empty string]	2253-DEFAULT-s.jpg	[empty string]	1000	1000	12285	131750	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-x-treme-speck-whitefront-flocked-6-pack-131750	12285	0
5	[empty string]	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	[empty string]	1	139.99	0	139.99	13584-DEFAULT-l.jpg	139.99	13584-DEFAULT-m.jpg	DAKOTA DECOY LESSER DECOY BAG	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Dakota Decoy Lesser Decoy Bag	<p>Dakota 12 slot lesser bag zipper top 12 individual slots to haul and protect your dakota decoy lesser floaters full bodies. Bag dimensions: 36l x 28w x 24h, slots - 9.5 x 9 x 23 built tough of heavy duty PVC!</p>	[empty string]	N	139.99	139.99	[empty string]	13584-DEFAULT-s.jpg	[empty string]	1000	1000	12500	131753	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-lesser-decoy-bag-131753	12500	0
6	[empty string]	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	[empty string]	1	99.99	0	119.99	964-DEFAULT-l.jpg	99.99	964-DEFAULT-m.jpg	DAKOTA DECOY PINTAIL FLOATER 6 PACK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	33	100-to-150	0.00	[empty string]	Dakota Decoy X-Treme Pintail Decoys 6 Pack	<p>Dakota Decoy introduces our newest member of our growing family our X-Treme Pintails!</p><p>The new pintails have detail never before seen on hunting decoys. These decoys will fool even the wariest of ducks. We've carved the fine feather detail of both the drake and hen and then proceeded to paint them to the high standards you have become accustom to from Dakota Decoy.</p><p>The decoys are constructed of our special blend of polyethylene making them virtually indestructible.</p><p>The Pintails are packaged in 6 packs with 3 drakes and 3 hens. All heads turn 360 degrees giving your spread a custom look! Decoys feature a 21" fiberglass stake to get up above the vegetation. All backed by the best paint warranty in the business....if it falls or flakes off, we replace! </p><p><strong>FEATURES</strong></p><ul><li>Fine feather detail</li><li>Painted to the highest of standards</li><li>Virtually indestructible</li><li>6 Pack</li></ul><p> </p><p> </p>	[empty string]	N	119.99	119.99	[empty string]	964-DEFAULT-s.jpg	[empty string]	1000	1000	13700	131754	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-x-treme-pintail-decoys-6-pack-131754	13700	0
7	[empty string]	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	[empty string]	1	39.99	0	44.99	4185-DEFAULT-l.jpg	39.99	4185-DEFAULT-m.jpg	DAKOTA REPLACEMENT DRAKE HEADS 7PK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	159	25-to-50	0.00	[empty string]	Dakota Decoy 7 Pack X-Treme Mallard Flocked Replacement Heads	<p>The Dakota Decoy X-Treme Mallard Flocked Replacement Heads let you spend your time making memories and not replacing your decoy heads. It will also help revive your decoy spread and have those mallards flocking back into your hole. </p><p><strong>FEATURES</strong></p><ul><li>Weight 2.0 lbs</li><li>Dimensions 8.0 8.0 4.0 in</li><li>2 tall heads</li><li>3 curved heads</li><li>1 short head </li><li>1 sleeper head</li></ul><p> </p>	[empty string]	N	44.99	44.99	[empty string]	4185-DEFAULT-s.jpg	[empty string]	1000	1000	16000	131755	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-7-pack-x-treme-mallard-flocked-replacement-heads-131755	16000	0
8	[empty string]	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	[empty string]	1	99.99	0	109.99	4872-DEFAULT-l.jpg	99.99	4872-DEFAULT-m.jpg	DAKOTA DECOY X-TREME GADWALL	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	17	100-to-150	0.00	[empty string]	Dakota Decoy X-treme Gadwall 6 Pack	<p>Dakota Decoy is proud to introduce their all new X-Treme Gadwall. The decoys feature the most realistic paint scheme ever seen on a Gadwall decoy. They are slightly oversized, and come in 4 unique body postures. They are packaged in 6 packs with 1 upright drake, 2 resting drakes, 1 upright hen and 2 relaxed hens. They have a weighted keel to hold them down in the windiest conditions. They feature the toughness you have learned to expect with all DD decoys! When conditions get tough... add the most "ducky" looking Gadwall available to your spread!</p><p><strong>SPECIFICATIONS: </strong></p><ul><li>Weight 11.0 lbs</li><li>Dimensions 20.0 17.0 13.0 in</li></ul>	[empty string]	N	109.99	109.99	[empty string]	4872-DEFAULT-s.jpg	[empty string]	1000	1000	17500-2	131760	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-x-treme-gadwall-6-pack-131760	17500-2	0
9	SNOW	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	SNOW\|NULL\|NULL	1	89.99	1	64.99	316-DEFAULT-l.jpg	89.99	316-DEFAULT-m.jpg	DAKOTA DECOY X-TREME SOCKS CLOSEOUT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	14	50-to-100	0.00	[empty string]	Dakota Decoy X-Treme Snap Lock Snow & Blue Goose Socks	<p><strong>BLUE GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Blue Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28" stake to keep the socks above the corn stalks. #19100</p><p><strong>SNOW GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Snow Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28" stake to keep the socks above the corn stalks. #18100</p><p><strong>NO ASSEMBLY REQUIRED!!! OPEN AND HUNT!!!</strong></p>	[empty string]	Y	64.99	64.99	[empty string]	316-DEFAULT-s.jpg	[empty string]	1000	1000	18100	131763	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-x-treme-snap-lock-snow-blue-goose-socks-131763	18100	0
10	BLUE	DAKOTA DECOY	Dakota Decoy	HUNTING	Hunting	BLUE\|NULL\|NULL	1	89.99	1	64.99	4134-DEFAULT-l.jpg	89.99	4134-DEFAULT-m.jpg	DAKOTA DECOY X-TREME SOCKS CLOSEOUT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	Dakota Decoy X-Treme Snap Lock Snow & Blue Goose Socks	<p><strong>BLUE GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Blue Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28" stake to keep the socks above the corn stalks. #19100</p><p><strong>SNOW GOOSE SOCKS 12 PACK</strong></p><p>Dakota Decoy is proud to announce our new X-Treme Snap Lock Snow Goose Wind Socks. These decoys feature a one piece collapsible system that offers the fastest setup and tear down times on the market. The decoys store flat taking up less room and feature a wind vane system which offers the best movement in low wind conditions. The X-treme wind socks also feature a full spine system which holds the sock open in no wind conditions and have a 28" stake to keep the socks above the corn stalks. #18100</p><p><strong>NO ASSEMBLY REQUIRED!!! OPEN AND HUNT!!!</strong></p>	[empty string]	Y	64.99	64.99	[empty string]	4134-DEFAULT-s.jpg	[empty string]	1000	1000	19100	131765	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakota-decoy/dakota-decoy-x-treme-snap-lock-snow-blue-goose-socks-131765	19100	0

CACHED

false

EXECUTIONTIME

SQL

SELECT top 10 style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage , CASE WHEN isNull(max(weighted_search),0) = 1 THEN 900000000 ELSE 0 END as weighted_search FROM web_all_products WHERE 1=1 --AND pictureid is not null and ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS