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]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	34.99	0	39.99	8380-DEFAULT-l.jpg	34.99	8380-DEFAULT-m.jpg	HUNTER SAFETY SYSTEM	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Hunter Safety System HSS Carabiner - 2 pack	<p>The Hunter Safety System HSS Carabiners are made of high-tensile-strength aluminum, with a strength rating of 5,600 lbs. with the screwgate in its locked position. Ideal for use as replacements for the steel carabiners that come with HSS Lineman's Climbing Straps, Life Lines, Quick-Connect Straps, and Rope-Style Tree Straps. 2 pack.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Manufacturer model #: HSS-2CAR.</li><li>Made of high-tensile-strength aluminum</li><li>Strength rating of 5,600 lbs.</li><li>Screwgate in its locked position</li></ul>	[empty string]	N	39.99	39.99	[empty string]	8380-DEFAULT-s.jpg	[empty string]	1000	1000	HSS-2CAR	139374	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-system-hss-carabiner-2-pack-139374	HSS-2CAR	0
2	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	29.99	0	39.99	8381-DEFAULT-l.jpg	29.99	8381-DEFAULT-m.jpg	HUNTER SAFETY SYSTEM LCR	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Hunter Safety System Lineman's Climbing Rope	<p>The Hunter Safety System Lineman's Climbing Rope is a 9' long Rope Style Treestrap that replaces your current tree strap and serves as an effective LifeLine for climbing style tree stands.</p><p>The Rope Style Treestrap makes climbing easier and safer, keeping you attached at all times during both the climb and the hunt. The rope is 2 1/2' longer than HHS standard tree strap. It can accommodate most trees as well as front or back facing climbing tree stands and allows for easy 360 shooting from nearly any angle. You simply loop the Rope Style Treestrap around the tree above your stand location and let the excess rope hang free. The easy-to-adjust Prussik Knot allows for additional maneuverability in your treestand.</p><p><strong>Features</strong></p><ul><li>Carabiner</li><li>Easy-to-Adjust Prussik Knot</li><li>9' long to use on almost every tree</li></ul>	[empty string]	N	39.99	39.99	[empty string]	8381-DEFAULT-s.jpg	[empty string]	1000	1000	LCR	139392	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-system-lineman-s-climbing-rope-139392	LCR	0
3	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	49.99	1	39.99	145-DEFAULT-l.jpg	49.99	145-DEFAULT-m.jpg	HUNTER SAFETY LIFELINE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Hunter Safety HSS- Lifeline	<p>86% of treestand accidents occur while ascending or descending the tree or getting into or out of the stand. Stay attached to the tree from the ground to the stand, during the hunt and back again with a properly installed HSS-LIFELINE .</p><ul><li>Once properly installed, our HSS-LIFELINE keeps you connected from the ground to the stand and back again</li><li>Attach tether to carabiner and slide the Prusik knot up to ascend and slide it back down when descending</li><li>All Lifelines accommodate stands up to 30 feet</li></ul>	[empty string]	Y	39.99	39.99	[empty string]	145-DEFAULT-s.jpg	[empty string]	1000	1000	LLS+	139394	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-hss-lifeline-139394	LLS+	0
4	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	59.99	0	59.99	146-DEFAULT-l.jpg	59.99	146-DEFAULT-m.jpg	HUNTER SAFETY LIFELINE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Hunter Safety Tandem Lifeline	<p>As you know, the most dangerous time in the field is getting into and out of the stand. The HSS-LIFELINE is the simplest way to stay attached to the tree from the ground to the stand, during the hunt and back again</p><ul><li>Allows you and a companion to remain attached to the same LifeLine</li><li>Great for children, spouses or cameramen</li><li>Simply strap to the tree when hanging the stand, tie it off at the base of the tree and leave it there for the season</li><li>Attach tether to carabiner and slide the Prusik knot up to ascend and slide it back down when leaving</li><li>All Lifelines accommodate stands up to 30 feet</li></ul>	[empty string]	N	59.99	59.99	[empty string]	146-DEFAULT-s.jpg	[empty string]	1000	1000	LLS2C+	139395	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-tandem-lifeline-139395	LLS2C+	0
5	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	134.99	1	119.99	1289-DEFAULT-l.jpg	134.99	1289-DEFAULT-m.jpg	HUNTER SAFETY LIFELINE 3 PACK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Hunter Safety Lifeline 3 Pack	<p>The HSS-REFLECTIVE LIFELINE 3-Pack is perfect for hunters with multiple stand locations and setups -- at a 17% savings!</p><p>86% of treestand accidents occur while ascending or descending the tree or getting into or out of the stand. Stay attached to the tree from the ground to the stand, during the hunt and back again with a properly installed HSS-REFLECTIVE LIFELINE . The HSS-REFLECTIVE LIFELINE features reflective material that "lights up" with the slightest flashlight beam to locate your stand in low-light conditions. All HSS-LIFELINEs come with our HSS-RECON carabiner and our new HSS-COWBELL sound dampeners (Patent Number US D759784 S). Once properly installed, our HSS-REFLECTIVE LIFELINE keeps you connected from the ground to the stand and back again.</p><ul><li>Reflective material that "lights up" with the slightest flashlight beam</li><li>HSS-COWBELL sound dampener eliminates rattles and clangs (Patent Number US D759784 S)</li><li>Accommodate stands up to 30 feet</li><li>Each Reflective LifeLine comes complete with Recon carabiner</li></ul>	[empty string]	Y	119.99	119.99	[empty string]	1289-DEFAULT-s.jpg	[empty string]	1000	1000	LLS3+	139396	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-lifeline-3-pack-139396	LLS3+	0
6	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	21.99	0	29.99	132-DEFAULT-l.jpg	21.99	132-DEFAULT-m.jpg	HUNTER SAFETY QUICK CONNECT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Hunter Safety Quick-Connect Treestrap	<p>Quick-Connect Tree Straps are the answer to attaching your harness to the tree quickly, quietly and safely. Designed to be left through the duration of most states deer seasons, the Quick-Connect Strap provides a fast silent connection at hunting height. Simply install the Quick Connect Strap at the proper height the first time you hunt and leave it in the tree. Heavy duty locking carabiner with web strap stays on the tree and allows instant attachment of the harness tether when you climb to the proper height. Quick-Connect Tree Strap offers convenience and stealth in your favorite locations. To maintain connection with the tree from the time you leave the ground until your return to the ground, we recommend this product to be used in conjunction with our Lifeline System.</p>	[empty string]	N	29.99	29.99	[empty string]	132-DEFAULT-s.jpg	[empty string]	1000	1000	QCS	139397	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-quick-connect-treestrap-139397	QCS	0
7	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	29.99	0	29.99	135-DEFAULT-l.jpg	29.99	135-DEFAULT-m.jpg	HUNTER SAFETY ROPE TREE STRAP	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Hunter Safety Rope Style Treestrap	<p>Anytime you can combinesafety with ease of use, speed and silence while in a treestand, you ve uppedyour chances at taking that big buck. Hunter Safety System s new Rope-StyleTree Strap makes attaching your harness to the tree as quick, quiet and easy asit can get. Need a bit more room to get away from the tree? No problem here. TheHSS Rope Style Tree Strap allows the hunter the ability to adjust the distancehe/she needs to be away from the tree to maintain maximum safety and freedom ofmovement.<br></p>	[empty string]	N	29.99	29.99	[empty string]	135-DEFAULT-s.jpg	[empty string]	1000	1000	RSTS	139399	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-rope-style-treestrap-139399	RSTS	0
8	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	1	79.99	0	79.99	16976-DEFAULT-l.jpg	79.99	16976-DEFAULT-m.jpg	HUNTER SAFETY SYSTEM SHADOW	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Hunter Safety System Shadow	<p>The Realtree Reversible Hunter Safety System is the original answer to cross-season safety, carrying you through any weather, any hunting regulations and any game you may pursue. The Realtree Reversible meets hunter orange requirements in all states and features a range of adjustability that assures a perfect fit over bulky winter hunting gear. Same great list of features you find in all HSS harnesses, with the added advantage of cross-season wear. The Realtree reversible features new and improved Saddle-Style leg straps that distribute weight evenly across the body and legs, eliminating unnecessary pressure to the crotch area. This fast, secure system eliminates the need for dangling straps and weave through buckles that flap as you walk and interfere with the bow string at that critical moment. Includes new Suspension Relief technology* Now a standard on all Hunter Safety System harnesses, suspension relief technology brings an added measure of safety in the event of a fall. *Suspension Relief Technology utilizes the HSS deer drag to relieve leg and chest pressure during recovery. By redesigning the deer drag strap included with every HSS harness, it now doubles as an added safety device. In the event of a fall, the strap is clipped to the lower D-ring on the back of the harness. To recover, the hunter places one foot in the loop on the end of the drag strap and stands up. This action immediately relieves pressure & weight from the legs and chest eliminating circulatory and suspension distress to the hunter. Chest and waist straps adjust to accommodate the following: S/M = 100-175 lbs. (32 -44 torso) L/XL = 175-250 lbs (42 -56 torso) 2X/3X = 300 lbs (48 -60 torso) Warranty: 300 lbs maximum weight limit</p>	[empty string]	N	79.99	79.99	[empty string]	16976-DEFAULT-s.jpg	[empty string]	1000	1000	SHADOWOSFM	139400	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-system-shadow-139400	SHADOWOSFM	0
9	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	0	119.99	1	109.99	[empty string]	119.99	[empty string]	HUNTER SAFETY SYSTEM HARNESS	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Hunter Safety System Harness Ultralite	<p><br />The HSS-ULTRA-LITE is the lightest, most flexible harness to hit the market.<br />The HSS-ULTRA-LITE features a mesh upper body, providing a comfortable, snug fit and without sacrificing movement. HSS 1.25" upper-body webbing, tether and waist buckle continues to provide the strength you expect from HSS without the added weight and bulk.</p><ul><li>- ElimiShield Hunt Scent Control Technology</li><li>- Heat fused into the fabric and good for the life of the harness.</li><li>- Trim design gives a snug fit without compromising movement</li><li>- 1.25" upper-body webbing, shock absorbing tether and waist buckle reduces weight and bulk</li><li>- Patented HSS design eliminates dangerous dangling straps and weave-through buckles</li><li>- Includes a secure, mesh cell phone pocket</li><li>- Realtree X-Tra Camouflage</li></ul><p><br /><strong>Includes:</strong></p><ul><li>- Hunter Safety System Pro-Series harness</li><li>- Adjustable tree strap</li><li>- Suspension relief strap / deer drag</li><li>- Economy lineman's climbing strap (carabiners not required)</li><li>- Instructional DVD</li><li>- Safe-use instructions</li></ul>	[empty string]	Y	109.99	109.99	L/XL	[empty string]	[empty string]	1000	1000	UL-RL/XL	139403	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-system-harness-ultralite-139403	UL-RL/XL	0
10	[empty string]	HUNTER SAFETY SYSTEM	Hunter Safety System	HUNTING	Hunting	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	HUNTER SAFETY SYSTEM HARNESS	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1698	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Hunter Safety System Harness Ultralite	<p><br />The HSS-ULTRA-LITE is the lightest, most flexible harness to hit the market.<br />The HSS-ULTRA-LITE features a mesh upper body, providing a comfortable, snug fit and without sacrificing movement. HSS 1.25" upper-body webbing, tether and waist buckle continues to provide the strength you expect from HSS without the added weight and bulk.</p><ul><li>- ElimiShield Hunt Scent Control Technology</li><li>- Heat fused into the fabric and good for the life of the harness.</li><li>- Trim design gives a snug fit without compromising movement</li><li>- 1.25" upper-body webbing, shock absorbing tether and waist buckle reduces weight and bulk</li><li>- Patented HSS design eliminates dangerous dangling straps and weave-through buckles</li><li>- Includes a secure, mesh cell phone pocket</li><li>- Realtree X-Tra Camouflage</li></ul><p><br /><strong>Includes:</strong></p><ul><li>- Hunter Safety System Pro-Series harness</li><li>- Adjustable tree strap</li><li>- Suspension relief strap / deer drag</li><li>- Economy lineman's climbing strap (carabiners not required)</li><li>- Instructional DVD</li><li>- Safe-use instructions</li></ul>	[empty string]	N	119.99	119.99	SM/MD	[empty string]	[empty string]	1000	1000	UL-RS/M	139404	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunter-safety-system/hunter-safety-system-harness-ultralite-139404	UL-RS/M	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