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	DRAKE	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	DRAKE\|NULL\|NULL	1	149.9	0	159.99	36871-DEFAULT-l.jpg	149.9	36871-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	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	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]	36871-DEFAULT-s.jpg	[empty string]	1000	1000	40009	132814	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-edge-duck-call-132814	40009	0
5	BROWN_PEARL	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	BROWN_PEARL\|NULL\|NULL	1	149.99	0	159.99	36307-DEFAULT-l.jpg	149.99	36307-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	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	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]	36307-DEFAULT-s.jpg	[empty string]	1000	1000	65641	132829	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-edge-duck-call-132829	65641	0
6	BLACK_CHERRY_PEARL	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	BLACK_CHERRY_PEARL\|NULL\|NULL	1	159.99	0	159.99	36852-DEFAULT-l.jpg	159.99	36852-DEFAULT-m.jpg	ELITE DOUBLE 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]	1	150-to-200	0.00	[empty string]	Elite Double Reed Murder Duck Call	<p>NEW DESIGN!! Now available in double reed! 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 double reed with tremendous volume and tonal range. You will quickly understand how this call got its name! </p><p> </p>	[empty string]	N	159.99	159.99	[empty string]	36852-DEFAULT-s.jpg	[empty string]	1000	1000	16445	242062	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-double-reed-murder-duck-call-242062	16445	0
7	GREEN_ORANGE	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	GREEN_ORANGE\|NULL\|NULL	1	159.99	0	159.99	36853-DEFAULT-l.jpg	159.99	36853-DEFAULT-m.jpg	ELITE DOUBLE 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]	3	150-to-200	0.00	[empty string]	Elite Double Reed Murder Duck Call	<p>NEW DESIGN!! Now available in double reed! 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 double reed with tremendous volume and tonal range. You will quickly understand how this call got its name! </p><p> </p>	[empty string]	N	159.99	159.99	[empty string]	36853-DEFAULT-s.jpg	[empty string]	1000	1000	16446	242063	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-double-reed-murder-duck-call-242063	16446	0
8	RED_PEARL_BLACK	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	RED_PEARL_BLACK\|NULL\|NULL	1	159.99	0	159.99	36727-DEFAULT-l.jpg	159.99	36727-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]	3	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]	36727-DEFAULT-s.jpg	[empty string]	1000	1000	46370	242064	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-edge-duck-call-242064	46370	0
9	DRAKE	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	DRAKE\|NULL\|NULL	1	159.99	0	159.99	36787-DEFAULT-l.jpg	159.99	36787-DEFAULT-m.jpg	ELITE CACHE DR	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5785	.ELITECACHE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Elite Cache Double Reed (CDR)	<p>New for 2023!! The newest addition to the Elite Calls line-up is the "CDR" (Cache Double Reed). This double reed version of the original "Cache" model call is nothing short of incredible! It has the sound and handling of a single reed call, combined with the user friendliness of a double reed. This call combines a raspy tone with the natural, whiney sounds of a mallard hen! With a solid, mid-range volume, this call allows you to easily transition from aggressive calling to quiet, finishing sounds.</p>	[empty string]	N	159.99	159.99	[empty string]	36787-DEFAULT-s.jpg	[empty string]	1000	1000	81107	242065	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-cache-double-reed-cdr-242065	81107	0
10	BROWN_PEARL_BLACK	ELITE DUCK CALLS	Elite Duck Calls	HUNTING	Hunting	BROWN_PEARL_BLACK\|NULL\|NULL	1	159.99	0	159.99	36793-DEFAULT-l.jpg	159.99	36793-DEFAULT-m.jpg	ELITE CACHE DR	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5785	.ELITECACHE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Elite Cache Double Reed (CDR)	<p>New for 2023!! The newest addition to the Elite Calls line-up is the "CDR" (Cache Double Reed). This double reed version of the original "Cache" model call is nothing short of incredible! It has the sound and handling of a single reed call, combined with the user friendliness of a double reed. This call combines a raspy tone with the natural, whiney sounds of a mallard hen! With a solid, mid-range volume, this call allows you to easily transition from aggressive calling to quiet, finishing sounds.</p>	[empty string]	N	159.99	159.99	[empty string]	36793-DEFAULT-s.jpg	[empty string]	1000	1000	81110	242067	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	elite-duck-calls/elite-cache-double-reed-cdr-242067	81110	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 ? ) GROUP BY STYLE_ID

SQLPARAMETERS

array
1	Hunting
2	%novix%
3	%beretta%
4	%elite%duck%calls%
5	%ams%
6	%tristar%

Filter By

Sort By

Item # 81110 $159.99

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Elite Freak Duck Call

Elite Edge Duck Call

Elite Murder Duck Call

Elite Edge Duck Call

Elite Edge Duck Call

Elite Double Reed Murder Duck Call

Elite Double Reed Murder Duck Call

Elite Edge Duck Call

Elite Cache Double Reed (Cdr)

Elite Cache Double Reed (Cdr)

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Elite Freak Duck Call

Elite Edge Duck Call

Elite Murder Duck Call

Elite Edge Duck Call

Elite Edge Duck Call

Elite Double Reed Murder Duck Call

Elite Double Reed Murder Duck Call

Elite Edge Duck Call

Elite Cache Double Reed (Cdr)

Elite Cache Double Reed (Cdr)