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]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	499.99	0	499.99	67-DEFAULT-l.jpg	499.99	67-DEFAULT-m.jpg	EOTECH 512A65 HOLOSIGHT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	450-to-500	0.00	[empty string]	Eotech 512 Holographic \| 68 MOA Ring With 1 MOA Aiming Dot Reticle \| Black \| 512.A65	<p>The Model 512 is fast becoming the most popular model HWS. This tactical optic is perfect for agencies and individuals that want the best in CQB speed and versatility, without the need for night vision compatibility. The Model 512 features a heads-up design that allows both eyes to be open in order to maintain peripheral vision and depth perception while shooting. The Model 512 runs on cost-effective and easily accessible AA batteries with a long battery life of 600 hours with (2) Alkaline or 1100 hours with (2) Lithium batteries.</p><ul><li>AA Battery model (supports Lithium and Alkaline)</li><li>65 MOA circle with 1 MOA aiming dot reticle pattern</li><li>Includes rugged aluminum hood assembly & knobbed, tool-less mounting bolt</li><li>Interfaces to standard 1 inch Weaver dovetail / Picatinny rail</li></ul><p><strong>SPECIFICATIONS</strong></p><ul><li>Magnification: 1x</li><li>Reticle: 65 MOA Circle with 1 MOA Aiming Dot</li><li>Reticle Color: Red</li><li>Click Adjustment: MOA</li><li>Body Material: Aluminum</li><li>Mount Compatibility: 1" Weaver or Picatinny</li><li>Battery: (2) Lithium or Alkaline AA</li><li>Battery Life: 600 Hours (Alkaline), 1100 Hours (Lithium)</li><li>Length: 5.6"</li><li>Weight: 11.5 oz.</li></ul>	[empty string]	N	499.99	499.99	[empty string]	67-DEFAULT-s.jpg	[empty string]	1000	1000	512A65	132965	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-512-holographic-68-moa-ring-with-1-moa-aiming-dot-reticle-black-512-a65-132965	512A65	0
2	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	609.99	0	645.99	19031-DEFAULT-l.jpg	609.99	19031-DEFAULT-m.jpg	EOTECH EXPS2-0 HOLOSIGHT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Eotech EXPS2-0 HOLOgraphic 68 MOA With One Aiming Dot \| Black	<p>Maximize rail space without sacrificing runtime. The Model EXPS2 allows for co-witnessing of iron sights and has convenient side buttons to add a magnifier. It features an adjustable, locking, quick-detach lever that fits both 1inch Weaver and MIL-STD-1913 rail. 20 brightness settings. 1x123 lithium battery.</p><p><strong>Specifications and Features:</strong></p><ul><li>Reticle is a 65MOA circle with 1 MOA aiming dot</li><li>Single transverse 123 battery to reduce sight length</li><li>Shortened base only requires at most 2 3/4 inch of rail space</li><li>Battery cap and latch are eliminated and replaced with a simple O-ring, tethered cap; better sealing is achieved</li><li>Battery compartment is now separated from the base to allow it to hover over the delta ring of the rifle</li><li>Average battery life at brightness level 12 is roughly 600 hours</li><li>Side buttons with an adjustable, locking, quick detach lever for easy attachment and removal</li><li>Optics: Transmission holography - parallax free</li><li>Magnification: 1x</li><li>Eye Relief: Unlimited</li><li>Length/Width/Height: 3.5"x2.4"x2.8" (91.4X 60.9x71mm)</li><li>Weight: 11.2 oz (317grams)</li><li>Temperature: -40 to 150 F</li><li>Waterproof: Submersible to 10 ft depth</li><li>Sealing: Fogproof internal optics</li><li>Adjustment (per click): 0.5 MOA (1/2" at 100 yds)</li><li>Adjustment Range: +/- 40 MOA travel</li><li>Mount: 1" Weaver or (MIL-STD-1913) rail. Adjustable for width variation</li><li>Return to Zero: Repeatable to within 2 MOA after re-mounting</li><li>Optical Surfaces: Anti-glare coating</li><li>Window Dimensions: 1.20" x 0.85" (30 x 23mm)</li><li>Front Window Material: 1/8" solid glass</li><li>Rear Window Material: Shatter resistant laminate (3/16" thick)</li><li>Field of View (100 yds): 30 yds (28m) at a 4" eye relief</li><li>Brightness Adjustment Range: 146,000:1 brightest to lowest</li><li>Power Source: (1) 123 lithium battery</li><li>Brightness Settings: 20 settings with scrolling feature</li><li>Auto Battery Check Indicator: Flashing reticle upon start-up</li><li>Auto Shut-down: At 8 hrs- programmable to 4 hrs</li></ul>	[empty string]	N	645.99	645.99	[empty string]	19031-DEFAULT-s.jpg	[empty string]	1000	1000	EXPS2-0	132971	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-exps2-0-holographic-68-moa-with-one-aiming-dot-black-132971	EXPS2-0	0
3	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	929.99	0	929.99	20161-DEFAULT-l.jpg	929.99	20161-DEFAULT-m.jpg	EOTECH EXPS32T HOLOGRAPHIC	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	500-or-more	0.00	[empty string]	Model EXPS3 HOLOgraphic 68MOA With Two Aiming Dots Tan	<p>The EOTech EXPS3 Holographic Weapon Sight is smaller and lighter than almost all other competing holographic weapon sights but without sacrificing speed or features. Law enforcement officers, hunters and recreational shooters appreciate the light weight and compact size for carrying convenience on the job, in the woods and at the range. The EXPS3 runs on a single 123 battery and features a 7mm raised base for lower third cowitness on AR style rifles. The single-lithium-battery configuration allows for a more compact footprint and more rail space on your flat top upper. This leaves more room for rear-iron sights, magnifiers, or a night vision mount.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand: Eotech</li><li>Category: Red Dot Sights</li><li>Model: EXPS3-2</li><li>Series: Holographic Weapon Sight</li><li>Finish: Tan</li><li>Magnification: 1x</li><li>Proofs: Water-Resistant, Fogproof</li><li>Reticle: 68 MOA Ring/ Two 1 MOA Dots</li><li>Objective: 30x23mm</li><li>Battery: CR123A Lithium</li><li>Battery Life: 600 hours at setting 12 at room temp.</li><li>Brightness Adjustment: 20 Daylight Settings 10 low brightness settings for Night Vision use</li><li>Adjustment Increments: .5" @ 100 yds</li><li>Dot Size: 1 MOA</li><li>Eye Relief: Unlimited</li><li>Field of View: 30 yds @ 4" Eye Relief</li><li>Length: 3.5"</li><li>Optic Coating: Anti-Reflection</li><li>Weight: 9 oz</li><li>Windage Elevation Adjustment: 40 MOA</li><li>Mount: 1" Weaver or 1913 Picatinny with Quick Detach Lever</li></ul><p> </p>	[empty string]	N	929.99	929.99	[empty string]	20161-DEFAULT-s.jpg	[empty string]	1000	1000	EXPS32T	132977	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/model-exps3-holographic-68moa-with-two-aiming-dots-tan-132977	EXPS32T	0
4	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	899.99	0	899.99	70-DEFAULT-l.jpg	899.99	70-DEFAULT-m.jpg	EOTECH EXPS34 HOLOSIGHT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	EoTech EXPS3-4 HOLOgraphic \| Night Vision Compatible 4MOA Aiming Dots \| Black	<p>The EOTech EXPS3-4 has been developed to optimize the functionality of the holographic weapon sight (HWS). The buttons have been moved from the back to the left side for instant access, allowing a magnifier, night vision or a back up iron sight to fit closely to the HWS body. This new button position allows the user to operate the HWS function switches easier than ever before. The EXPS3-4 is configured with a new ballistic matching reticle image for the M4 carbine. The battle tested circle dot reticle will be offered along with a series of 1 MOA aiming dots that are vertically aligned and calibrated specifically for the ballistic drop of .223 caliber ammunition.</p><p><br /><strong>SPECIFICATIONS & FEATURES</strong></p><ul><li>Finish Matte Black</li><li>Length 3.8 Inches</li><li>Style Reflex</li><li>Weight 11.2 Ounce</li><li>Battery CR123</li><li>Magnification 1</li><li>Adjustment Click Value 1/2 MOA</li><li>Warranty EOTech Prestige 10 Year Warranty</li><li>Reticle 223 Remington Ballistic</li><li>Battery Type CR123A</li><li>Batteries Included Yes</li><li>Reticle Color Red</li><li>Housing Material Aluminum</li><li>Country of Origin United States of America</li></ul>	[empty string]	N	899.99	899.99	[empty string]	70-DEFAULT-s.jpg	[empty string]	1000	1000	EXPS34	132978	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-exps3-4-holographic-night-vision-compatible-4moa-aiming-dots-black-132978	EXPS34	0
5	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	599.99	0	619.99	11334-DEFAULT-l.jpg	599.99	11334-DEFAULT-m.jpg	EOTECH G43 STS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Eotech G43 3X Magnifier \| Black	<p>This is a miniaturized version of our battle-tested G33 Magnifier making it one of the most compact and lightweight magnifiers available. The mount provides fast transitioning from 3X to 1X and the optic offers tool-free vertical and horizontal adjustments with a large field-of-view. The G43 works with all EOTECH HWS models. Includes manual, Switch-to-Side mounting system and case.</p><p><strong>SPECIFICATIONS: </strong></p><ul><li>Brand Eotech</li><li>Category Red Dot Sights</li><li>Series Magnifier</li><li>Magnification 3x</li><li>Model G43</li><li>Color Black Anodized</li><li>Material Aluminum</li><li>Mount Type Picatinny / Weaver</li><li>Field of View 7.5 Degrees</li><li>Eye Relief 2.50"</li><li>Length 3.10"</li><li>Proofs Fog / Water / Weather Resistant</li><li>Height 3.30"</li><li>Includes Switch-to-Side Mounting System / Protective Case</li><li>Width 2.30"</li><li>Weight 11.30 oz</li><li>Features Switch-to-Side Mounting System</li></ul>	[empty string]	N	619.99	619.99	[empty string]	11334-DEFAULT-s.jpg	[empty string]	1000	1000	G43	132980	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-g43-3x-magnifier-black-132980	G43	0
6	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	1019.99	0	1139.99	26926-DEFAULT-l.jpg	1019.99	26926-DEFAULT-m.jpg	EOTECH HHSII HOLO SYSTEM	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	500-or-more	0.00	[empty string]	EOTech HHS II Holographic Weapon Sight and Magnifier Combo	<p>Regardless of the scenario this HHS provides an unparalleled advantage when transitioning from short to long range shooting. The EXPS2-2 offers true 2 eyes open shooting, a transversely mounted lithium 123 battery, 7 mm raised base offering iron sight access, and easy to adjust side buttons. The G33 3x magnifier with switch to side mount provides superior light transmission and the large field of view puts the competition to shame. Both units offer an adjustable, locking, quick detach lever for easy attachment and removal.</p><p><strong>Includes:</strong></p><ul><li>EOTech EXPS2-2 Unit</li><li>EOTech G33 Magnifier Unit</li></ul><p><strong>Specifications and Features:</strong></p><ul><li>3X Magnifier unit with Switch-To-Side mount works will all existing EOTech Units</li><li>65 MOA reticle with two 1 MOA aiming dots</li><li>Single CR123 battery</li><li>Shortened base on 2.75" of rail space</li><li>Tethered Battery Cap with O-Ring Seal</li><li>Average Battery Life at Level 12 Brightness 500-600 Hours</li><li>Both units have the Quick Detach levers for each attachment and removal</li><li>No Night Vision Compatible for Night Vision see the HHS I combo</li></ul><p><strong>Technical Information:</strong></p><ul><li>Holographic Transmission Parallax Free</li><li>Unlimited Eye Relief</li><li>8.1" L x 2.2" W x 2.8" H Combined</li><li>23.1 oz Combined</li><li>Operating Temperature -40 to 150 F</li><li>Submersible to 10 ft depth</li><li>Fog proof internal optics</li><li>0.5 MOA adjustments per click (1/2" at 100 yards)</li><li>+/- 40 MOA of total adjustment</li><li>1" Weaver of MIL-STD-1913 Picatinny rail attachment</li><li>Repeatable to within 2 MOA after re-mounting</li><li>Anti-Glare Coating</li><li>1.20" x 0.85" Window Dimensions</li><li>1/8" Solid Glass on Front Window</li><li>Shatter Resistant Laminate Glass 3/16" on Rear Window</li><li>Field of View at 100 yards is 30 yards across at 4" of eye relief</li><li>146,000:1 Brightest to Lowest Brightness adjustment range</li><li>20 total brightness settings</li><li>Reticle will flash upon start up when the battery is low</li><li>Unit will shut down after 8 hours of runtime and is programmable to 4 hours</li></ul><p><strong>Technical Information:</strong></p><ul><li>Magnifier is Fixed Power 3.25X Magnification</li><li>2.2" of Eye Relief</li><li>7.3 degrees of Field of View</li><li>3.9" Long</li><li>Operating Temperature -40 to 150 F</li><li>Submersible to 33ft</li><li>Fog proof internal optics</li><li>34MM ring with integrated Quick Release Mount</li></ul><p> </p>	[empty string]	N	1139.99	1139.99	[empty string]	26926-DEFAULT-s.jpg	[empty string]	1000	1000	HHSII	132982	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-hhs-ii-holographic-weapon-sight-and-magnifier-combo-132982	HHSII	0
7	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	799.99	1	599.99	20163-DEFAULT-l.jpg	799.99	20163-DEFAULT-m.jpg	EOTECH EXPS2-0GRN GREEN RETICLE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	500-or-more	0.00	[empty string]	Eotech EXPS2 HWS Black Anodized 1x 1 MOA 68 MOA Ring/Green Dot	<p>Accelerated accuracy that takes up just 2.75" of rail space. The EXPS2 HWS features green-reticle technology approximately 5X easier to see than red in daylight and leaves plenty of rail space for adding a magnifier and other attachments. Durable, lower third iron sight co-witness and ergonomic, side-button adjustment all in a rock-solid unit with an adjustable, quick-detach locking lever. Includes manual, battery and case.</p><p><strong>SPECIFICATIONS</strong></p><ul><li>Model: EXPS2-0</li><li>Color: Black</li><li>Night Vision Compatibility: None</li><li>Dimensions: 3.8" L x 2.3" W x 2.9" H</li><li>Weight: 11.2 oz.</li><li>Water Resistant: Submersible to 10 ft.</li><li>Mount: 1" Weaver or MIL-STD-1913 Rail</li><li>Brightness: 20 daylight settings</li><li>Power Source: 1 x 123 Lithium Battery</li></ul><p><strong>Battery Life:</strong><br />Lithium: 600 Continuous Hours at Nominal Setting 12 at Room Temperature</p>	[empty string]	Y	599.99	599.99	[empty string]	20163-DEFAULT-s.jpg	[empty string]	1000	1000	EXPS2-0GRN	132983	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-exps2-hws-black-anodized-1x-1-moa-68-moa-ring-green-dot-132983	EXPS2-0GRN	0
8	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	599.99	0	599.99	68-DEFAULT-l.jpg	599.99	68-DEFAULT-m.jpg	EOTECH XPS2-0	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	Eotech XPS2 HOLOgraphic Weapon Sight \| Black \| XPS2-0	<p>EOTech sights are an excellent choice for anyone who wants to improve hits on target in any situation where fast, accurate shots are necessary. The EOTech Holographic Weapon Sight XPS2 provides you with a compact Weapon Sight ideal for a lightweight AR build, or as a perfect addition to a lightweight hunting rifle. The XPS2 is powered by a single CR123A battery which boasts a 600 hour runtime on a brightness setting of 12. The EOTech XPS2 features unlimited eye relief and is parallax free. The XPS can be used by itself, or in conjunction with an EoTech magnifier (sold separately).</p><p><strong>Specifications and Features:</strong></p><ul><li>EOTech XPS2 Holographic Weapon Sight XPS2-0</li><li>65 MOA circle with 1 MOA aiming dot</li><li>1/2" adjustment per click at 100 yards</li><li>14" adjustment per click at 50 yards</li><li>+/-40 MOA travel adjustment range</li><li>Repeatable to 2 MOA return to zero after remounting</li><li>Parallax-free</li><li>Unlimited eye relief</li><li>20 brightness settings with scrolling feature</li><li>Up to 600 hours continuous use at brightness setting 12</li><li>Non-Night Vision Version</li><li>Shortened base, requires 2-3/4" of rail space</li><li>O-ring, tethered cap</li><li>Anti-glare lens coating</li><li>3/16" thick shatter-resistant laminate rear window</li><li>1/8" solid glass front window</li><li>30 yards field of view at 100 yards</li><li>1.20"x0.85" heads-up-display window</li><li>8 hours automatic shut-down</li><li>Fogproof</li><li>Submersible to 10'</li><li>Non-reflective black with hard-coat finish</li><li>(1) 123 lithium battery</li><li>Overall Length 3.8"</li><li>Overall Width 2.1"</li><li>Overall Height 2.5"</li><li>9.0 oz.</li><li>Black</li></ul>	[empty string]	N	599.99	599.99	[empty string]	68-DEFAULT-s.jpg	[empty string]	1000	1000	XPS2-0	132984	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-xps2-holographic-weapon-sight-black-xps2-0-132984	XPS2-0	0
9	[empty string]	EOTECH	Eotech	SHOOTING	Shooting	[empty string]	1	599.99	0	609.99	19035-DEFAULT-l.jpg	599.99	19035-DEFAULT-m.jpg	EOTECH XPS2300 HOLOSIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2750	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Eotech XPS2-300 Blackout Holographic 65 MOA \| Black \| XPS2-300	<p>If you're looking for a quick, easy to use red dot sight for your favorite AR-15 carbine, EOTech has the answer. Their standard mounting system quickly and easily mounts to any standard 1" Weaver or Picatinny rail, and will rezero withing 2 MOA if removed and remounted. The long 600 hour battery life on a single battery makes sure you are always ready to take the shot of a lifetime.</p><p>Hunters and tactical shooters take note. The XPS2-300 offers a 2-dot ballistic drop reticle that allows the shooter to zero either subsonic or supersonic rounds in the same reticle pattern. Offered in the XPS2 platform, it is the shortest and lightest HWS sight available. Featuring a .300 Blackout custom laser etched hood and waterproof capability up to 10ft, functionality and durability are at the forefront.</p><p><strong>Features:</strong></p><ul><li>1x magnification</li><li>Unlimited eye relief</li><li>3.5"X2"X2.4"</li><li>Weighs 8 ounces</li><li>Waterproof</li><li>Anti-glare coatings</li><li>20 Brightness settings</li></ul><p> </p>	[empty string]	N	609.99	609.99	[empty string]	19035-DEFAULT-s.jpg	[empty string]	1000	1000	XPS2300	132987	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	eotech/eotech-xps2-300-blackout-holographic-65-moa-black-xps2-300-132987	XPS2300	0
10	[empty string]	MUDDY OUTDOORS	Muddy Outdoors	SHOOTING	Shooting	[empty string]	1	249.99	0	249.99	7173-DEFAULT-l.jpg	249.99	7173-DEFAULT-m.jpg	MUDDY RANGEFINDER 1300YD	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3547	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	41	200-to-250	0.00	[empty string]	Muddy Range Finder 1300 HD \| LR1300X	<p> </p><ul><li>1300 Yard Range</li><li>6X Magnification</li><li>26mm Glass Lens</li><li>IP54 Waterproof</li><li>Durable rubber trim.</li><li>Magnesium Aluminum Housing</li><li>Min Range of 0 yards</li><li>Yard / Meter selection</li><li>Scan Mode</li><li>Speed Measuring</li><li>Angle measurement & compensation</li><li>Battery Indicator</li><li>Lanyard</li><li>Carry Case</li><li>Lens Cloth</li><li>Powered by 1 CR2 battery</li></ul>	[empty string]	N	249.99	249.99	[empty string]	7173-DEFAULT-s.jpg	[empty string]	1000	1000	MUD-LR1300X	216606	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	muddy-outdoors/muddy-range-finder-1300-hd-lr1300x-216606	MUD-LR1300X	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 ? ) GROUP BY STYLE_ID

SQLPARAMETERS