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]	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	[empty string]	1	19.99	0	19.99	7883-DEFAULT-l.jpg	19.99	7883-DEFAULT-m.jpg	DUCK COMMANDER MALLARD DRAKE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Duck Commander Mallard Drake Double Reed Call \| Plastic Green	<p>The Mallard Drake call is part of the Duck Commander's Specialty Series. The Specialty series not only aid in attracting "off-ducks", but also act as a confidence call when late season ducks get wary of regular calling. The Duck Commander Specialty calls are the most life-like calls on the market. It is made from high-impact plastic and is known as the "Green Stick of Death".</p>	[empty string]	N	19.99	19.99	[empty string]	7883-DEFAULT-s.jpg	[empty string]	1000	1000	DC10025	99487	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-mallard-drake-double-reed-call-plastic-green-99487	DC10025	0
4	[empty string]	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	[empty string]	1	19.99	0	24.99	4905-DEFAULT-l.jpg	19.99	4905-DEFAULT-m.jpg	DUCK COMMANDER DC600	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	20-to-25	0.00	[empty string]	Duck Commander Ole Raspy Double Reed Mallard Hen \| Plastic Black	<p>The Ole Raspy is part of the Classic Series. The Classics are built with the original style and sound that made Duck Commander and Phil Robertson famous. These calls house the friction-fit, double reed system and have proven themselves in the field for over thirty years. It is made from high-impact plastic and is great for beginners.</p><p><strong>SPECIFICATIONS</strong></p><ul><li><strong>Type:</strong> Duck Call</li><li><strong>Species:</strong> Mallard Hen</li><li><strong>Material:</strong> Plastic</li><li><strong>Sound Species:</strong> Ducks</li><li><strong>Electronic:</strong> No</li><li><strong>Battery:</strong> None</li><li><strong>Color:</strong> Black</li><li><strong>Style:</strong> Double Reed</li><li><strong>Manufacturer Part Number:</strong> DC600</li></ul>	[empty string]	N	24.99	24.99	[empty string]	4905-DEFAULT-s.jpg	[empty string]	1000	1000	DC600	99496	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-ole-raspy-double-reed-mallard-hen-plastic-black-99496	DC600	0
5	CANADA_GOOSE	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	CANADA_GOOSE\|NULL\|NULL	1	24.99	0	29.99	2232-DEFAULT-l.jpg	24.99	2232-DEFAULT-m.jpg	DUCK COMMANDER GOOSE CALL	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Duck Commander Goose Calls	<p><strong>CANADA GOOSE CALL</strong></p><p>The Canadian Goose call is made with a short reed to achieve deep, raspy goose sounds.</p><ul><li>Manufacturer: Duck Commander</li><li>Model: Goose Commander</li><li>UPC: 040444513902</li><li>SKU: DCCANG</li><li>Width: 4.3000</li><li>Length: 7.1000</li><li>Height: 2.7000</li><li>Weight: 0.1900</li><li>Calls: Canadian Geese</li><li>Color: Clear</li><li>Hands Free: No</li><li>Material: Polycarbonate</li><li>Sound Species: Canadian Goose</li><li>Species: Geese</li><li>Style: Single Reed</li><li>Type: Goose Call</li></ul><p><strong>SPECKLEBELLY GOOSE CALL</strong></p><p>This Specklebelly Goose call is made with a short reed to achieve deep, raspy goose sounds.</p><ul><li>Manufacturer: Duck Commander</li><li>Model: Goose Commander</li><li>UPC: 040444513896</li><li>SKU: DCSPECK2</li><li>Width: 7.1000</li><li>Length: 13.3000</li><li>Height: 2.7000</li><li>Weight: 0.2000</li><li>Calls: Specklebelly Geese</li><li>Color: Orange</li><li>Hands Free: No</li><li>Material: Polycarbonate</li><li>Sound Species: Specklebelly Goose</li><li>Species: Geese</li><li>Style: Single Reed</li><li>Type: Goose Call</li></ul><p><strong>SNOW GOOSE CALL</strong></p><p>Our Snow Goose call is made with a short reed to achieve deep, raspy goose sounds.<br />A finger groove has been added to the design to keep your hands tight when you quiet down on calling them in. </p><ul><li>Short Reed</li><li>Worn in Guts style</li></ul>	[empty string]	N	29.99	29.99	[empty string]	2232-DEFAULT-s.jpg	[empty string]	1000	1000	DCCANG	99500	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-goose-calls-99500	DCCANG	0
6	[empty string]	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	[empty string]	1	34.99	0	39.99	4080-DEFAULT-l.jpg	34.99	4080-DEFAULT-m.jpg	DUCK COMMANDER CUTDOWN	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Duck Commander Cutdown Timber Call	<p>In 1972, Phil Robertson had a dream of creating duck calls that sounded exactly like a duck. That passion fueled the creation of a line of calls that left a mark on the hunting industry. We're getting back to our roots with the RDC100. The overall design, look, feel, and sound reflects the vintage line of calls that everyone knows and loves. We've made a few improvements to make the call easier to blow and make crisper sounds.</p><p><strong>Item Specifications and Features:</strong></p><ul><li>Duck Commander RDC100</li><li>Realtree Timber</li><li>New and improved design</li><li>Crisp sound creates smooth cadences</li><li>High volume</li><li>Duck Commander signature double-reed, friction-fit system (Jase Robertson Pro Series reed design)</li></ul>	[empty string]	N	39.99	39.99	[empty string]	4080-DEFAULT-s.jpg	[empty string]	1000	1000	DCCDTIMBER	99503	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-cutdown-timber-call-99503	DCCDTIMBER	0
7	[empty string]	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	[empty string]	1	16.99	0	19.99	7885-DEFAULT-l.jpg	16.99	7885-DEFAULT-m.jpg	DUCK COMMANDER GADWALL MAGNUM	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Duck Commander Gadwall Magnum Double Reed Drake \| Smoke Gray Plastic	<p>Duck Commander's Gadwall Drake Call is made of a high impact plastic and perfectly imitates the distinct sound of a Gadwall drake.</p>	[empty string]	N	19.99	19.99	[empty string]	7885-DEFAULT-s.jpg	[empty string]	1000	1000	DCGW2	99512	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-gadwall-magnum-double-reed-drake-smoke-gray-plastic-99512	DCGW2	0
8	[empty string]	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	[empty string]	1	49.99	0	59.99	9560-DEFAULT-l.jpg	49.99	9560-DEFAULT-m.jpg	DUCK COMMANDER PRO SERIES	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	25	50-to-100	0.00	[empty string]	Duck Commander Phil Pro Series Open Call \| Tan Acrylic	<p>Jase Robertson isn't the only one who gets his own call series. For 2021, we proudly introduce two new duck calls under the Phil Robertson Pro Series. Both the wood and acrylic versions are easy to blow, but rough around the edges - just like Phil Robertson. They are raspy, scratchy, and have the "ducky" tone that made Duck Commander famous. From timber to field, the Phil Robertson Pro Series will ring loud and true.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Duck Commander</li><li>Category Game Calls</li><li>Model Phil Pro Series</li><li>Color Tan</li><li>Material Acrylic</li><li>Sounds Rasp</li><li>Call Type Open</li><li>Difficulty Level Easy</li><li>Species Ducks</li></ul>	[empty string]	N	59.99	59.99	[empty string]	9560-DEFAULT-s.jpg	[empty string]	1000	1000	DCPPSAB	99523	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-phil-pro-series-open-call-tan-acrylic-99523	DCPPSAB	0
9	[empty string]	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	[empty string]	1	49.99	0	59.99	9561-DEFAULT-l.jpg	49.99	9561-DEFAULT-m.jpg	DUCK COMMANDER PRO SERIES	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	49	50-to-100	0.00	[empty string]	Duck Commander Phil Pro Series Mallard \| Brown Acrylic Striker w/Wood Handle	<p>Jase Robertson isn't the only one who gets his own call series. For 2021, we proudly introduce two new duck calls under the Phil Robertson Pro Series. Both the wood and acrylic versions are easy to blow, but rough around the edges - just like Phil Robertson. They are raspy, scratchy, and have the "ducky" tone that made Duck Commander famous. From timber to field, the Phil Robertson Pro Series will ring loud and true.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Duck Commander</li><li>Category Game Calls</li><li>Model Phil Pro Series</li><li>Color Brown</li><li>Material Acrylic Striker w / Wood Handle</li><li>Sounds Rasp</li><li>Difficulty Level Easy</li><li>Sound Species Mallard</li><li>Species Ducks</li></ul>	[empty string]	N	59.99	59.99	[empty string]	9561-DEFAULT-s.jpg	[empty string]	1000	1000	DCPPSO	99524	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-phil-pro-series-mallard-brown-acrylic-striker-w-wood-handle-99524	DCPPSO	0
10	CHARTREUSE	DUCK COMMANDER	Duck Commander	HUNTING	Hunting	CHARTREUSE\|NULL\|NULL	1	49.99	0	49.99	2074-DEFAULT-l.jpg	49.99	2074-DEFAULT-m.jpg	DUCK COMMANDER PRO SERIES	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	17	25-to-50	0.00	[empty string]	Duck Commander Jase's Pro-Series Duck Call	<p>For over 40 years of building duck calls, our goal has been really simple -- to sound exactly like a duck. We continue to manipulate parts of the calls to get the sound more "ducky". From the culmination of years of practicing our trade, we bring you the Jase Robertson's PRO Series duck call. Simply put -- this call sounds exactly like a mallard hen, but the unique design of the call has given it two additional qualities. First, it has a piercing high end for open water applications along with a soft, raspy low end for finishing. Second, the call is the easiest blowing call we have ever made. We have combine these qualities into a great looking, laser-etched, Bocote barrel, at an affordable price. As the Duckmen hand-tune each call to perfection, they take one final step -- putting their name on the line by signing the insert card to insure the integrity of the call. We know you will love this one!</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Patented revited double reed</li><li>Mallard hen</li><li>Friction fit</li><li>The easiest blowing, most versatile call we've ever produced</li></ul>	[empty string]	N	49.99	49.99	[empty string]	2074-DEFAULT-s.jpg	[empty string]	1000	1000	DCPROAC	99525	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-commander/duck-commander-jase-s-pro-series-duck-call-99525	DCPROAC	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

array
1	Hunting
2	%g%h%
3	%zev%tec%
4	%sitka%
5	%zebco%
6	%spypoint%
7	%engel%
8	%evolution%
9	%duck%commander%

Filter By

Sort By

Item # DCPROAC $49.99

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Sitka Sling Choke - 40058

Sitka Equinox Turkey Vest - 600050

Duck Commander Mallard Drake Double Reed Call | Plastic Green

Duck Commander Ole Raspy Double Reed Mallard Hen | Plastic Black

Duck Commander Goose Calls

Duck Commander Cutdown Timber Call

Duck Commander Gadwall Magnum Double Reed Drake | Smoke Gray Plastic

Duck Commander Phil Pro Series Open Call | Tan Acrylic

Duck Commander Phil Pro Series Mallard | Brown Acrylic Striker W/Wood Handle

Duck Commander Jase's Pro- Series Duck Call

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Sitka Sling Choke - 40058

Sitka Equinox Turkey Vest - 600050

Duck Commander Mallard Drake Double Reed Call | Plastic Green

Duck Commander Ole Raspy Double Reed Mallard Hen | Plastic Black

Duck Commander Goose Calls

Duck Commander Cutdown Timber Call

Duck Commander Gadwall Magnum Double Reed Drake | Smoke Gray Plastic

Duck Commander Phil Pro Series Open Call | Tan Acrylic

Duck Commander Phil Pro Series Mallard | Brown Acrylic Striker W/Wood Handle

Duck Commander Jase's Pro- Series Duck Call