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	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	PRIMOS	Primos	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	1	5.99	0	5.99	3527-DEFAULT-l.jpg	5.99	3527-DEFAULT-m.jpg	LIMB HANGER TURKEY DIAPHRAGM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	12	5-to-10	0.00	[empty string]	Limb Hanger	<p>The Primos Limb Hanger is one of Primos' Original Series mouth calls. This call is constructed out of two thin prophylactic reeds creating a sensitive call that’s easy to use. With a little practice, you can reproduce clear notes or raspy calls. This one is great for beginners and pros alike.</p>	[empty string]	N	5.99	5.99	[empty string]	3527-DEFAULT-s.jpg	[empty string]	1000	102	56960	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	primos/limb-hanger-turkey-diaphragm-56960	1
2	[empty string]	PRIMOS	Primos	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	1	7.99	0	7.99	58224-DEFAULT-l.jpg	7.99	58224-DEFAULT-m.jpg	TRUE DOUBLE II TURKEY DIAPHRAGM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	True Double Ii	<p>The True Double II is part of Primos' Piggy Back series meaning it has a stacked double frame with one thin prophylactic reed in the top frame and two prophylactic reeds in the bottom frame. Both frames are separated by 1/16", which doesn`t allow the reeds to stick together. The True Double II has a slightly higher pitch than the True Double. The True Double II makes raspy yelps, clucks, cuts, and cackles.</p>	[empty string]	N	7.99	7.99	[empty string]	58224-DEFAULT-s.jpg	[empty string]	1000	110	56963	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	primos/true-double-ii-turkey-diaphragm-56963	1
3	[empty string]	PRIMOS	Primos	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	1	0	0	5.99	3532-DEFAULT-l.jpg	0	3532-DEFAULT-m.jpg	DIAMOND CUTTER TURKEY DIAPHRAGM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	5-to-10	0.00	[empty string]	Diamond Cutter	<p>A super loud cutter call, the Diamond Cutter is part of our Diamond Cut Series. Two reeds are made of a super-thin prophylactic material. The third reed is an ultra-thin latex material with an inverted diamond cut making this call the perfect raspy cutting, single frame call. The Diamond Cutter produces raspy yelps, clucks, cuts, and cackles. It also makes great gobbler kee-kee runs.</p>	[empty string]	N	5.99	5.99	[empty string]	3532-DEFAULT-s.jpg	[empty string]	1000	114	56965	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	primos/diamond-cutter-turkey-diaphragm-56965	1
4	[empty string]	PRIMOS	Primos	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	1	0	0	5.99	3534-DEFAULT-l.jpg	0	3534-DEFAULT-m.jpg	SONIC DOME TRIPLE W/BAT CUT DIAPHRAGM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	Sonic Dome - Triple - Bat Cut	<p>Simple and dependable – you're gonna love the way this call works. The Sonic Dome Series has been designed so the call is automatically positioned correctly in your mouth. The dome creates its own chamber for an incredibly consistent sound. Finally, a mouth call for everyone. These calls will do it all.</p>	[empty string]	N	5.99	5.99	[empty string]	3534-DEFAULT-s.jpg	[empty string]	1000	1175	56969	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	primos/sonic-dome-triple-w-bat-cut-diaphragm-56969	1
5	[empty string]	QUAKER BOY	QUAKER BOY	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	1	0	0	4.19	85378-DEFAULT-l.jpg	0	85378-DEFAULT-m.jpg	OLD BOSS HEN DIAPHRAM CALL	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	8	5-AND-under	0.00	[empty string]	Old Boss Hen Diaphram Call	[empty string]	[empty string]	N	4.19	4.19	[empty string]	85378-DEFAULT-s.jpg	[empty string]	1000	11109	57741	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	quaker-boy/old-boss-hen-diaphram-call-57741	1
6	[empty string]	CANE CREEK CALLS	Cane Creek Calls	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	CANE CUTTER DIAPHRAM TURKEY CALL	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2010	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	5-to-10	0.00	[empty string]	Cane Cutter Diaphram Turkey Call	[empty string]	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	M-12	115571	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	cane-creek-calls/cane-cutter-diaphram-turkey-call-115571	1
7	[empty string]	CANE CREEK CALLS	Cane Creek Calls	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	TUFF MAN DIAPHRAM TURKEY CALL	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2010	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	5-to-10	0.00	[empty string]	Tuff Man Diaphram Turkey Call	[empty string]	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	M-16	115575	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	cane-creek-calls/tuff-man-diaphram-turkey-call-115575	1
8	[empty string]	CANE CREEK CALLS	Cane Creek Calls	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	THE EDGE DIAPHRAM TURKEY CALL	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2011	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	9	5-to-10	0.00	[empty string]	The Edge Diaphram Turkey Call	[empty string]	[empty string]	N	5.99	5.99	DIAPHRAM	[empty string]	[empty string]	1000	M-19	129508	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	cane-creek-calls/the-edge-diaphram-turkey-call-129508	1
9	[empty string]	CANE CREEK CALLS	Cane Creek Calls	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	LOST POULT DIAPHRAM TURKEY CALL	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2011	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	10	5-to-10	0.00	[empty string]	Lost Poult Diaphram Turkey Call	[empty string]	[empty string]	N	5.99	5.99	DIAPHRAM	[empty string]	[empty string]	1000	M-14	130087	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	cane-creek-calls/lost-poult-diaphram-turkey-call-130087	1
10	TURKEY	PRIMOS	Primos	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	TURKEY\|NULL\|NULL	0	12.99	0	12.99	[empty string]	12.99	[empty string]	HOOK HUNTER SERIES LONG HOOK DIAPHRAM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2012	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	9	10-to-15	0.00	[empty string]	Long Hooks With Upper Cut	<p>The Primos Hook Hunter Series mouth calls produce incredibly real and unique pitches that even the wisest ole' tom can't resist. Custom designed by combining 100+ years of experience by passionate, determined turkey hunters with premium gauge reeds and precision hand made cuts. You'll be hooked by how effortless these calls are to use; he'll be hooked when you speak his language.</p>	[empty string]	N	12.99	12.99	DIAPHRAM	[empty string]	[empty string]	1000	1246	140896	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	primos/hook-hunter-series-long-hook-diaphram-140896	1
11	YELLOW	CANE CREEK CALLS	Cane Creek Calls	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	YELLOW\|NULL\|NULL	0	5.99	0	5.99	[empty string]	5.99	[empty string]	DEAD END DIAPHRAM TURKEY CALL	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2013	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Dead End Diaphram Turkey Call	[empty string]	[empty string]	N	5.99	5.99	DIAPHRAM	[empty string]	[empty string]	1000	M-11	161815	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	cane-creek-calls/dead-end-diaphram-turkey-call-161815	1
12	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	27.99	0	27.99	[empty string]	27.99	[empty string]	SIGNATURE SERIES PRO PACK DIAPHRAM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2015	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Signature Series - Pro Pack	FEATURES:<br/> -This trio of diaphragms includes the Hunter Wallis Signature Series, the Josh Grossenbacher Signature Series and the Matt Morrett Signature series style of reed designs.<BR/> -The Hunter Wallis Signature Series triple-reed W-Cut style call was designed by Turkey Calling Champion Hunter Wallis. This call features a heavy top reed over two thinner reeds. It has a notch in the middle reed making for easier transitions from clear to raspy notes. A great call for woods and calling stages.<BR/> -The Josh Grossenbacher Signature Series call is a triple-reed V-Series style call framed in thin red tape, with all reeds stretched to a tighter tension. The unique V-notched top reed and short-notched under-reed allow for tones ranging from raspy to clear, while the heavier latex gives the option of incredible volume and distance. -The Matt Morrett Signature Series call provides a mix of two reeds of prophylactic and one light latex top reed with a special ``snake tongue`` cut. With this combo the call is very easy to achieve great rasp and high-end calling.<BR/> -Movie buffs will want to view the company`s first full-length turkey hunting DVD, ``Turkey Time,`` included with this three pak. Join Zink`s Z-Unit Team of professional hunters as they travel the country in search of challenging longbeards.<BR/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	27.99	27.99	[empty string]	[empty string]	[empty string]	1000	334	245428	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	zink-calls/signature-series-pro-pack-diaphram-245428	1
13	[empty string]	HUNTERS SPECIALTIES	Hunters Specialties	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	11.99	0	11.99	[empty string]	11.99	[empty string]	UNDERTAKER FC TURKEY DIAPHRAM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	CLOSEOUT	[empty string]	SELL THRU	NOT ONLINE	[empty string]	[empty string]	12	10-to-15	0.00	[empty string]	Undertaker - Ut-fc - Fang Cut	FEATURES:<BR/> -Premium aluminum frame call custom fits to the user`s mouth while Infinity Latex produces consistent tones.<BR/> -Black tape with red reed accent.<BR/> -Includes Diaphragm Call Clip<BR/> -UT-FC features three thin reeds with The Fang cut for deep and raspy yelps, cutts and purrs. <BR/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i><br>	[empty string]	N	11.99	11.99	[empty string]	[empty string]	[empty string]	1000	UT-2	265026	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	hunters-specialties/undertaker-fc-turkey-diaphram-265026	1
14	[empty string]	HUNTERS SPECIALTIES	Hunters Specialties	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	11.99	0	11.99	[empty string]	11.99	[empty string]	UNDERTAKER SC TURKEY DIAPHRAM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	CLOSEOUT	[empty string]	SELL THRU	NOT ONLINE	[empty string]	[empty string]	17	10-to-15	0.00	[empty string]	Undertaker - Ut-sc - Sickle Cut	FEATURES:<BR/> -Premium aluminum frame call custom fits to the user`s mouth while Infinity Latex produces consistent tones.<BR/> -Black tape with red reed accent.<BR/> -Includes Diaphragm Call Clip<BR/> -UT-SC features three thin reeds with Sickle cut for raspy kee-kees, clucks, cutts and purrs.<BR/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i><br>	[empty string]	N	11.99	11.99	[empty string]	[empty string]	[empty string]	1000	UT-4	265028	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	hunters-specialties/undertaker-sc-turkey-diaphram-265028	1
15	[empty string]	LYNCH MOB CALLS	Lynch Mob Calls	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	0	11.99	0	11.99	[empty string]	11.99	[empty string]	GHOST 3 TURKEY DIAPHRAM CALL	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	[empty string]	BOTH	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Ghost 3 Turkey Diaphram Call	[empty string]	[empty string]	N	11.99	11.99	[empty string]	[empty string]	[empty string]	1000	T604	266359	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	lynch-mob-calls/ghost-3-turkey-diaphram-call-266359	1
16	[empty string]	HUNTERS SPECIALTIES	Hunters Specialties	HUNTING	Hunting>Game Calls>Turkey>Mouth Calls	[empty string]	1	5.99	0	5.99	85318-DEFAULT-l.jpg	5.99	85318-DEFAULT-m.jpg	PREMIUM FLEX CUTTIN 2.5 DIAPHRAM	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Premium Flex Cuttin 2.5 Diaphram	[empty string]	[empty string]	N	5.99	5.99	[empty string]	85318-DEFAULT-s.jpg	[empty string]	1000	05904	352948	TURKEY	MOUTH CALLS	EMPTY	0	0	0	GAME CALLS	[empty string]	hunters-specialties/premium-flex-cuttin-2-5-diaphram-352948	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts202 ORDER BY sortposition asc

Hunting

Sort By:

Items per page:

Filter