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	[empty string]	SPORTSMAN`S VIEW	Sportsman`s View	HUNTING	Hunting	[empty string]	1	19.99	0	19.99	8261-DEFAULT-l.jpg	19.99	8261-DEFAULT-m.jpg	WISE EYE LONG RANGE ANTENNA	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2050	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	WiseEye Long Range Antenna	<p>Wise Eye Long Range Antenna </p><p>To help you get reception even in bad cellular areas</p>	[empty string]	N	19.99	19.99	[empty string]	8261-DEFAULT-s.jpg	[empty string]	1000	1000	WELONGRANT-1	190295	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sportsman-s-view/wiseeye-long-range-antenna-190295	WELONGRANT-1	0
2	[empty string]	SPORTSMAN`S VIEW	Sportsman`s View	HUNTING	Hunting	[empty string]	1	14.99	0	14.99	8262-DEFAULT-l.jpg	14.99	8262-DEFAULT-m.jpg	WISE EYE 12V BATTERY CABLE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2050	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	WiseEye 12V Battery Terminal Connector	<p>Connect your Smart Cam to the terminals of a 12V external battery.</p>	[empty string]	N	14.99	14.99	[empty string]	8262-DEFAULT-s.jpg	[empty string]	1000	1000	WETERMCON-1	190297	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sportsman-s-view/wiseeye-12v-battery-terminal-connector-190297	WETERMCON-1	0
3	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	34.99	0	34.99	24082-DEFAULT-l.jpg	34.99	24082-DEFAULT-m.jpg	ZINK CALL 2044 DUCK CALL	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Zink Power Hen PH-2 Polycarbonate Mallard Call In Mossy Oak Shadow Grass Blades	<p>The PH-2 takes the proven duck killing sounds that the Power Hen is known for in a double reed design that will not squeak or crack at the top end. This call is very user friendly and the sound is pure duck, making this the call for the serious waterfowl hunter. Great for close in calling or late season call shy ducks.</p><p> </p>	[empty string]	N	34.99	34.99	[empty string]	24082-DEFAULT-s.jpg	[empty string]	1000	1000	2044	224696	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-power-hen-ph-2-polycarbonate-mallard-call-in-mossy-oak-shadow-grass-blades-224696	2044	0
4	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	11.99	0	12.99	10753-DEFAULT-l.jpg	11.99	10753-DEFAULT-m.jpg	ZINK SIGNATURE SERIES V NOTCH	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Zink Signature Series \| V Notch	<p><strong>DESCRIPTION:</strong></p><p>The Zink Signature Series V-Notch is stretched to a tight tension with heavy latex, the V-notched top reed and short-notched lower reed create a full range of turkey sounds. Whether you want loud, raspy volume or clear, quiet coaxing, the Josh Grossenbacher Signature does it all and then some.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>V-notch cut triple reed</li><li>Tight tension</li><li>Short-notched lower reed</li><li>Great range from raspy to clear</li><li>Heavy latex for far-reaching, loud sounds</li><li>Custom built by hand</li></ul>	[empty string]	N	12.99	12.99	[empty string]	10753-DEFAULT-s.jpg	[empty string]	1000	1000	229	224698	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-signature-series-v-notch-224698	229	0
5	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	11.99	0	12.99	10754-DEFAULT-l.jpg	11.99	10754-DEFAULT-m.jpg	ZINK SIGNATURE SERIES BATWING	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	10-to-15	0.00	[empty string]	Zink Signature Series \| Batwing	<p><strong>DESCRIPTION:</strong></p><p>The Zink Signature Series Batwing diaphragm turkey call features a triple reed with a heavy top batwing cut reed laid over two thinner reeds. A notch in the middle reed makes for easy transitions from clear to raspy calls for a great range of sounds. Whether you're taking the stage or the woods, the Signature Series Batwing has everything you need.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Batwing cut triple reed</li><li>Notched middle reed for extra rasp</li><li>Great for the woods or the stage</li><li>Custom built by hand</li></ul>	[empty string]	N	12.99	12.99	[empty string]	10754-DEFAULT-s.jpg	[empty string]	1000	1000	230	224699	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-signature-series-batwing-224699	230	0
6	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	11.99	0	11.99	10755-DEFAULT-l.jpg	11.99	10755-DEFAULT-m.jpg	ZINK SIGNATURE SERIES SNAKE T	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Zink Signature Series \| Snake T	<p><strong>DESCRIPTION:</strong></p><p>The Signature Series Snake Tongue turkey call is extra raspy for a full range of irresistible calls. The Signature Series Snake Tongue uses three reeds, with a unique snake-tongue meticulously cut into the top latex reed and two lower prophylactic layers below. It's all turkey.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Snake-tongue cut triple reed</li><li>Full range of raspy calling</li><li>Custom built by hand</li></ul>	[empty string]	N	11.99	11.99	[empty string]	10755-DEFAULT-s.jpg	[empty string]	1000	1000	231	224700	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-signature-series-snake-t-224700	231	0
7	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	99.99	0	109.99	1451-DEFAULT-l.jpg	99.99	1451-DEFAULT-m.jpg	ZINK 306 TURKEY CALL	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Zink Wicked Series Cherry Slate Turkey Call	<p><br /><strong>DESCRIPTION:</strong></p><p>The "Wicked Series" is the only custom friction call on the market today that is constructed with impregnated wood. With the impregnation of acrylic into the Brazilian cherry pan it allows the call to be completely weatherproof and the sound quality is unmatched. Combining this to the key features it is a one-of-a-kind, custom friction call. Along with the striker conditioner, no-slip grip ring and the one-of-a kind built in "Sweet-Spot" for soft calling, the Wicked-Series calls are unmatched. </p>	[empty string]	N	109.99	109.99	[empty string]	1451-DEFAULT-s.jpg	[empty string]	1000	1000	306	224703	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-wicked-series-cherry-slate-turkey-call-224703	306	0
8	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	99.99	0	99.99	1450-DEFAULT-l.jpg	99.99	1450-DEFAULT-m.jpg	ZINK 307 TURKEY CALL	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Zink Wicked Series Cherry Crystal Turkey Call	<p> </p><p>The Wicked Series is the only custom friction call on the market today that is constructed with impregnated wood. With the impregnation of acrylic into the Brazilian Cherry pan, it allows the call to be completely weatherproof and the sound quality is unmatched. Combining this with the key features and it is a one-of-a-kind call. We discovered this material on the waterfowl side of our company and realized that it is a home run for not only durability, but sound quality as well. Along with the striker conditioner, no-slip grip ring and the one-of-a kind built-in "Sweet-Spot" for soft calling, the Wicked Series calls are unmatched. Both the Wicked Crystal and Wicked Slate call packs come included with the Turkey Time University instructional DVD.</p>	[empty string]	N	99.99	99.99	[empty string]	1450-DEFAULT-s.jpg	[empty string]	1000	1000	307	224704	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-wicked-series-cherry-crystal-turkey-call-224704	307	0
9	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	12.99	0	12.99	4238-DEFAULT-l.jpg	12.99	4238-DEFAULT-m.jpg	ZINK 312 TURKEY CALL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	Zink Lucky Lady	<p> </p><p>Produce a full range of turkey sounds with incredible realism. The Lucky Lady features a triple reed framed in thin, white tape. The V-style cut integrates notches in both the middle and upper reeds. Stretched to a tight tension, these small details will make a big difference in your calling.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>V-notch cut triple reed</li><li>Tight tension</li><li>Notches in middle and upper reeds</li><li>Custom built by hand</li><li>Easy to use</li></ul>	[empty string]	N	12.99	12.99	[empty string]	4238-DEFAULT-s.jpg	[empty string]	1000	1000	312	224707	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-lucky-lady-224707	312	0
10	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	34.99	0	34.99	11866-DEFAULT-l.jpg	34.99	11866-DEFAULT-m.jpg	ZINK MOUTH CALL TRIPLE PACK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Zink Mouth Call \| Triple Pack	<p><strong>DESCRIPTION: </strong></p><p>This trio of diaphragms includes the Lucky Lady, Wicked Lady, and the X-Lady style of reed designs. A triple reed, the Lucky Lady features strategically placed notches in both the middle and upper reeds, allowing for a wide range of sounds. The Wicked Lady's unique W-shaped cut and set-back twin reeds produce fantastic yelps and whines, as well as toned-down clucks and purrs. An altered heavy latex upper reed, combined with two thinner reeds, gives the X-Lady a one-of-a-kind sound, while keeping it user-friendly for callers of all skill levels.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Color: Red/White</li><li>Species: Turkey</li><li>Number of Reeds: 8</li><li>Call Type: Diaphragm</li></ul>	[empty string]	N	34.99	34.99	[empty string]	11866-DEFAULT-s.jpg	[empty string]	1000	1000	317	224711	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-mouth-call-triple-pack-224711	317	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	%surelock%
3	%zink%calls%
4	%donovan%
5	%bowtech%
6	%colt%mfg%co%inc%
7	%sportsman%s%view%
8	%ghostblind%
9	%case%sons%cutlery%

Filter By

Sort By

Item # 317 $34.99

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Wiseeye Long Range Antenna

Wiseeye 12v Battery Terminal Connector

Zink Power Hen Ph- 2 Polycarbonate Mallard Call In Mossy Oak Shadow Grass Blades

Zink Signature Series | V Notch

Zink Signature Series | Batwing

Zink Signature Series | Snake T

Zink Wicked Series Cherry Slate Turkey Call

Zink Wicked Series Cherry Crystal Turkey Call

Zink Lucky Lady

Zink Mouth Call | Triple Pack

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Wiseeye Long Range Antenna

Wiseeye 12v Battery Terminal Connector

Zink Power Hen Ph- 2 Polycarbonate Mallard Call In Mossy Oak Shadow Grass Blades

Zink Signature Series | V Notch

Zink Signature Series | Batwing

Zink Signature Series | Snake T

Zink Wicked Series Cherry Slate Turkey Call

Zink Wicked Series Cherry Crystal Turkey Call

Zink Lucky Lady

Zink Mouth Call | Triple Pack