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	GREEN	MENDOTA	Mendota	HUNTING	Hunting	GREEN\|NULL\|NULL	1	19.99	0	19.99	525-DEFAULT-l.jpg	19.99	525-DEFAULT-m.jpg	MENDOTA 016 SNAP LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	.MENDOTA016SNAPLEAD	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Snap Lead (1/2"x4')	<p>Premium, strong (1/2" x 4 feet) solid braid UV coated polypropylene rope, leather sleeves, and a heavy gauge brass snap. Available in Camouflage and Green</p>	[empty string]	N	19.99	19.99	[empty string]	525-DEFAULT-s.jpg	[empty string]	1000	1000	016	75806	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-snap-lead-1-2-x4-75806	016	0
5	GREEN	MENDOTA	Mendota	HUNTING	Hunting	GREEN\|NULL\|NULL	1	16.99	0	16.99	522-DEFAULT-l.jpg	16.99	522-DEFAULT-m.jpg	MENDOTA 019 TRAFFIC LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	.MENDOTA019TRAFFICLEAD	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Traffic Leash - Large 1/2 Inch	<p>Traffic Lead -A short 1.5 foot handled snap lead for situations where you need your dog close at all times.</p><ul><li>Soft on the hands with its "Broken in Feel" easy to use and pliable enough to fit in your coat pocket</li><li>Brass, satin nickel or black metallic hardware and oil tanned leather splices</li><li>Made of waterproof, vibrant, long-lasting multi-filament polypropylene rope.</li><li>Matches Mendota's Double Braid Collars</li><li>Machine washable, air dry only.</li><li>Handmade in the U.S.A.</li><li>100% satisfaction guarantee</li><li>Shipping Weight 4 oz.</li><li>Package size: 4"x5"x1.5" </li></ul><p>We also have 4' and 6' foot available:</p><ul><li>Small Snap Leash: 3/8"" x 4' and 3/8"" x 6' (for dogs under 50 pounds)</li><li>Large Snap Leash: 1/2"" x 4' and 1/2"" x 6'</li><li>Traffic Lead: 1/2"" x 16""</li></ul>	[empty string]	N	16.99	16.99	[empty string]	522-DEFAULT-s.jpg	[empty string]	1000	1000	019	75807	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-traffic-leash-large-1-2-inch-75807	019	0
6	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
7	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
8	CAMO	MENDOTA	Mendota	HUNTING	Hunting	CAMO\|NULL\|NULL	1	16.99	0	16.99	523-DEFAULT-l.jpg	16.99	523-DEFAULT-m.jpg	MENDOTA 025 SMALL SLIP LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Mendota Small Slip Lead (Camo 3/8"x4')	Used for many years by trainers and handlers in field and show, now adapted for everyday use. The british style slip lead is a leash and collar in one design allowing for correction and ease of use. Adjustable leather slide eliminates slipping off, yet releases properly in relaxed position. Solid brass bolt snap is anti-corrosive. Genuine leather accents. Braided polypropylene rope for extreme durability. Water resistant and color fast. Available in 3/8" or 1/2" braided nylon in 4' or 6' lengths.	[empty string]	N	16.99	16.99	[empty string]	523-DEFAULT-s.jpg	[empty string]	1000	1000	025	183281	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-small-slip-lead-camo-3-8-x4-183281	025	0
9	[empty string]	MENDOTA	Mendota	HUNTING	Hunting	[empty string]	1	19.99	0	19.99	4165-DEFAULT-l.jpg	19.99	4165-DEFAULT-m.jpg	MENDOTA 027 SLIP LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Slip Lead (1/2"x4')	<p>Premium, strong 1/2" solid braid multi-filament UV coated polypropylene rope, leather sleeves and brass ring. Used by trainers, field trial and hunting test participants. Leash and slip collar in one allows for correction. Adjustable leather slide keeps "collar" in place. "Broken-in" feel is easy on the hands and allows easy folding to fit in a pocket. (1/2" x 4 Feet)</p>	[empty string]	N	19.99	19.99	[empty string]	4165-DEFAULT-s.jpg	[empty string]	1000	1000	027	183284	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-slip-lead-1-2-x4-183284	027	0
10	CAMO	MENDOTA	Mendota	HUNTING	Hunting	CAMO\|NULL\|NULL	1	19.99	0	19.99	524-DEFAULT-l.jpg	19.99	524-DEFAULT-m.jpg	MENDOTA 029 QUICK LEADS	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Mendota Quick Leads (Camo1/2"x4')	<p>Discover the Mendota Quick Lead, the epitome of quality, durability, and versatility in dog accessories. Crafted by Mendota Products, renowned for their expertly designed pet products, this lead is the perfect accessory for your canine friend. What sets the Mendota Quick Lead apart is its innovative design. It can be used as a 'hands-free' leash, simply slip the leash onto your dog and clip the scissor snap to a belt loop. This feature allows you to multitask on walks, adding an extra level of convenience. Alternatively, you can clip the snap onto your dog and use the slip lead as a handhold loop, or secure the slip lead over a post for an instant tie-out.</p><p> </p><p><strong>FEATURES</strong></p><ul><li>1/2" x 4'</li><li>Strong and durable multi-filament material</li><li>Slip lead and scissor snap combo lead</li><li>Solid brass hardware</li></ul>	[empty string]	N	19.99	19.99	[empty string]	524-DEFAULT-s.jpg	[empty string]	1000	1000	029	183286	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-quick-leads-camo1-2-x4-183286	029	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts4 ORDER BY sortposition asc