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	TIMBER	DR DUCK	Dr Duck	UNCATEGORIZED	Uncategorized	TIMBER\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	DR DUCK HANDWARMER	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5680	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Dr Duck Handwarmer	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	1000	DDHW-1959T	99278	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dr-duck/dr-duck-handwarmer-99278	DDHW-1959T	0
2	[empty string]	DR DUCK	Dr Duck	UNCATEGORIZED	Uncategorized	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	DR DUCK WADER BAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5680	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Dr Duck Wader Bag	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	1000	DDWB-1947T	99282	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dr-duck/dr-duck-wader-bag-99282	DDWB-1947T	0
3	[empty string]	MR. TWISTER	Mr. Twister	HUNTING	Hunting>Knives>Electric	[empty string]	1	59.99	1	54.99	1497-DEFAULT-l.jpg	59.99	1497-DEFAULT-m.jpg	MR TWISTER MT1208 PIRANHA	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	953	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Mister Twister Piranha Fillet Knife	<ul><li>Heavy-duty stainless-steel blade fillets fish quickly and easily</li><li>High torque and speed to handle the tough scales and skins of many saltwater fish</li><li>Durable, expandable power cord</li></ul><p>You must be 18 years old to purchase this product.</p><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	Y	54.99	54.99	[empty string]	1497-DEFAULT-s.jpg	[empty string]	1000	1000	MT1208	184220	EMPTY	EMPTY	EMPTY	0	0	0	KNIVES	mr-twister/mister-twister-piranha-fillet-knife-184220	MT1208	0
4	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	9.99	0	9.99	8483-DEFAULT-l.jpg	9.99	8483-DEFAULT-m.jpg	TINKS W5106 SCENT REEL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	5-to-10	0.00	[empty string]	Tink's Scent Reel	<p>The new Tink's Scent Reel dispersal system enables you to maximize the effectiveness of your favorite Tink's lures and scents. Tink's Scent Reel is a retractable, compact and easy-to-use device that will put an abundant amount of scent in the woods with less mess.</p><p>Slide the lock switch to unlock the reservoir cap and fill with 1-ounce of your favorite Tink's lure. Replace the cap and lock. A leak-proof o-ring ensures you won't lose a drop. When you reach your hunt location, simply pull the hanging loop to unwind the wick to the desired length, up to 10", and hang. When the hunt is over, turn the reel to wind in the wick.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>10" Retractable Wick</li><li>Convenient, Durable & Rugged Design</li><li>Reflective Strip To Quickly Locate</li><li>Leak-Proof O-Ring System</li><li>Size: 2.5 Inches</li></ul>	[empty string]	N	9.99	9.99	[empty string]	8483-DEFAULT-s.jpg	[empty string]	1000	1000	W5106	236770	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-scent-reel-236770	W5106	0
5	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	14.99	0	19.99	8507-DEFAULT-l.jpg	14.99	8507-DEFAULT-m.jpg	TINKS #69 SCENT BOMB	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Tink's #69 Doe-In-Rut Value Pack 2 Oz.	<p>A great buy for the avid whitetail deer hunter! Featuring a 2-ounce bottle of Tink's #69 Doe-in-Rut Buck Lure and a 1-ounce Scent Bomb. Pour the lure into the included Scent Bomb to soak the wick, then hang for all-day attraction.</p><p>Tink's #69 Doe-In-Rut Buck Lure is 100% natural doe estrous urine collected from live whitetail does during their estrous cycle. Tink's quality controlled formula keeps Tink's #69 Doe-In-Rut Buck Lure at the peak level of performance. Tink's #69 Doe-In-Rut Buck Lure, the standard on which all deer lures are measured, produces great results during the pre-rut and rut.</p>	[empty string]	N	19.99	19.99	[empty string]	8507-DEFAULT-s.jpg	[empty string]	1000	1000	W5825	236795	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-69-doe-in-rut-value-pack-2-oz-236795	W5825	0
6	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	6.99	0	6.99	8476-DEFAULT-l.jpg	6.99	8476-DEFAULT-m.jpg	TINKS W5841 SCENT BOMB	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	5-to-10	0.00	[empty string]	Tink's Scent Bomb - 3 Pack	<p>Tink's Scent Bombs the most efficient way to disperse scent today. They can be used as yardage markers, works with all cover scents and lures, and hangs in a tree to put more scent into the air.</p>	[empty string]	N	6.99	6.99	[empty string]	8476-DEFAULT-s.jpg	[empty string]	1000	1000	W5841	236796	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-scent-bomb-3-pack-236796	W5841	0
7	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	29.99	0	29.99	8491-DEFAULT-l.jpg	29.99	8491-DEFAULT-m.jpg	TINKS W5886 PEEFUSER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Tink's #69 Doe-In-Rut PeeFuser Scent Diffuser	<p>The Tink's Peefuser converts your favorite Tink's scent into a fine mist that will give deer in the area assurance to enter your hunting location and provide long range attraction for the big buck looking for a doe to breed. Every 2 mintues your hunting location will get a fresh 30 second burst of tantalizing Tink's attraction!</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Scent diffuser converts deer urine to irresistible mist</li><li>Diffuses scent for 30 seconds every 2 minutes while powered on</li><li>PeeFuser .5oz bottle lasts up to 7 hours</li><li>Battery powered (3 - AAA Batteries; not included)</li></ul>	[empty string]	N	29.99	29.99	[empty string]	8491-DEFAULT-s.jpg	[empty string]	1000	1000	W5886	236803	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-69-doe-in-rut-peefuser-scent-diffuser-236803	W5886	0
8	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	9.99	0	9.99	8482-DEFAULT-l.jpg	9.99	8482-DEFAULT-m.jpg	TINKS POWER SCRAPE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	Tink's Power Scrape Mock Scrape Starter 4 Oz.	<p>Tink's Power Scrape is a powerful synthetic buck lure designed for the entire season. Power Scrape can be used on natural or mock scrapes to condition deer to frequently return to your stand location. This revolutionary formula is designed to capitalize on a buck's curiosity in the early season and their drive for territorial dominance during the breeding season.</p><p>Use this 4-ounce bottle of Scrape Starter to start a new mock scrape or challenge bucks by applying to an existing scrape.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Conditions buck to revisit particular scrapes</li><li>Formulated to smell like an invader buck</li><li>Use on natural or mock scrapes</li><li>Size: 4 Ounce</li><li>Scent: Power Scrape Starter</li></ul>	[empty string]	N	9.99	9.99	[empty string]	8482-DEFAULT-s.jpg	[empty string]	1000	1000	W5950	236809	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-power-scrape-mock-scrape-starter-4-oz-236809	W5950	0
9	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	16.99	1	14.99	8475-DEFAULT-l.jpg	16.99	8475-DEFAULT-m.jpg	TINKS W6106 SMOKIN STICKS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	16	10-to-15	0.00	[empty string]	Tink's Smokin' Stick Synthetic Doe Estrous 6 Sticks	<p>Tink's Smokin' Sticks are formulated to cover human scent and to attract game. When properly used, sticks will smoke for approximately 2 hours and the scent will stick to everything it comes into contact with.</p>	[empty string]	Y	14.99	14.99	[empty string]	8475-DEFAULT-s.jpg	[empty string]	1000	1000	W6106	236820	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-smokin-stick-synthetic-doe-estrous-6-sticks-236820	W6106	0
10	[empty string]	TINKS	Tinks	HUNTING	Hunting>Scent Elimination	[empty string]	1	9.99	0	9.99	12586-DEFAULT-l.jpg	9.99	12586-DEFAULT-m.jpg	TINKS #69 SCENT PODS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	5-to-10	0.00	[empty string]	Tink's #69 Scent Pods 3 Pack	<p>No bottles to open, no scents to pour, no getting doe pee all over your hands and clothes. The Tink's Scent Pods are individually packaged and preloaded with America's #1 Buck Lure, Tink's #69 Doe-In-Rut. The unique pod design allows you to peel and hang virtually anywhere. Just pull the tab and Tink's #69 Doe-In-Rut soaks the felt pad. Then hang the pod and the alluring scent will disperse downwind for up to eight hours.</p><ul><li>Pull, Hang, Hunt</li><li>No spills, no mess</li><li>Tink's #69 Doe-In-Rut scent disperses naturally with air movement for up to eight hours</li><li>Comes in a 3 pack</li></ul>	[empty string]	N	9.99	9.99	[empty string]	12586-DEFAULT-s.jpg	[empty string]	1000	1000	W6354	236832	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	tinks/tink-s-69-scent-pods-3-pack-236832	W6354	0

CACHED

false

EXECUTIONTIME

1

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc