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]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	549.99	0	549.99	2438-DEFAULT-l.jpg	549.99	2438-DEFAULT-m.jpg	TRIJICON 2200006 SCOPE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	TRIJICON MRO (Miniature Rifle Optic) 1x25mm 2.0 MOA \| Lower 1/3 Co-Witness Mount \| 2200006	<p>Get an upper hand in any critical situation using Trijicon's 1x25 MRO Reflex Sight. This compact and lightweight optic, designed for fast and intuitive target acquisitions, will fit rifles, carbines, and shotguns. Its brilliant 2 MOA Red Dot reticle enables you to align with your target instantly and adjust brightness in most lighting conditions. It offers two night vision brightness settings, five daylight settings, and one super-bright setting. The multi-coated optics deliver low image distortion with clear and bright views and feature a canted objective lens that reduces glare, glint, and overall size of the device. To help you compensate for wind and ballistics, the sight offers windage and elevation adjustments of 70 MOA and a 1/2 MOA impact point correction.</p><p>Forged from durable and lightweight 7075-T6 aluminum alloy, the housing will protect the optics from impact, moisture, temperature fluctuations, and even water submersions to 150'. Its hard anodized finish resists scratches and abrasions, and protected windage and elevation turrets maintain zero despite rough handling.</p><p><strong>Optical Performance</strong></p><ul><li>1x magnification</li><li>25mm objective diameter</li><li>Anti-reflection multi-coated optics</li><li>High-quality optical glass and processing produce low-distortion images</li><li>Canted objective lens reduces glare and size of the device</li><li>Unlimited eye relief</li><li>Parallax-free</li></ul><p><strong>Reticle</strong></p><ul><li>2 MOA Red Dot reticle</li><li>Eight brightness settings: two for night vision settings, five daylight settings, and one super-bright setting</li><li>"Off" positions between each intensity for quick repeatability</li></ul><p><strong>Use and Handling</strong></p><ul><li>1/2 MOA impact point correction</li><li>70 MOA windage and elevation adjustment range</li><li>Brightness dial knob is located on top for ambidextrous use</li></ul><p><strong>Construction Details</strong></p><ul><li>7075-T6 forged aluminum housing</li><li>Corrosion- and scratch-resistant hard-anodized housing</li><li>Fully protected turrets maintain zero</li><li>Lower 1/3 co-witness Picatinny mount included</li></ul>	[empty string]	N	549.99	549.99	[empty string]	2438-DEFAULT-s.jpg	[empty string]	1000	1000	2200006	161986	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-mro-miniature-rifle-optic-1x25mm-2-0-moa-lower-1-3-co-witness-mount-2200006-161986	2200006	0
2	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	599.99	0	599.99	2813-DEFAULT-l.jpg	599.99	2813-DEFAULT-m.jpg	TRIJICON SRO2	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[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]	Trijicon SRO2 Sight Adjustable LED 2.5 MOA \| 2500002	<p>The Trijicon Specialized Reflex Optic (SRO ) 2.5 MOA Adjustable LED red dot is the most popular reticle size and can be used in a wide variety of pistol and other shooting applications such as target shooting or plinking.</p><p>The wide field of view and clean, crisp dot makes it easy for users to find and track the dot in both target and competitive shooting applications, helping improve shooting accuracy and speed. Every SRO features both manual and automatic LED brightness modes and a 3-year battery life. The SRO is designed to survive the rigors of slide ride pistols and is engineered for hard use. It shares a similar electronics design with the proven Trijicon RMR .</p><p>Like the RMR the SRO is forged from 7075, T-6 aircraft grade aluminum, making it much more durable than conventional red dot sights. This forged housing protects the lenses and electronics, and it has been tested to survive typical pistol mounted drops.</p><p><strong>Package Includes:</strong></p><ul><li>1 Trijicon Logo Sticker (PR15)</li><li>1 Lenscloth</li><li>#6-32 Flat Head Torx Cap Screws 1/2" Long</li><li>1 Torx Head Key</li><li>1 Manual</li><li>1 Warranty Card</li></ul>	[empty string]	N	599.99	599.99	[empty string]	2813-DEFAULT-s.jpg	[empty string]	1000	1000	2500002	161989	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-sro2-sight-adjustable-led-2-5-moa-2500002-161989	2500002	0
3	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	599.99	0	599.99	17874-DEFAULT-l.jpg	599.99	17874-DEFAULT-m.jpg	TRIJICON 2700004 HURON SCOPE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Trijicon Huron 3-9x40mm With German #4 Crosshair \| HR940-C-2700004	<ul><li>Reticle Type: German #4 Crosshair</li><li>Second Focal Plane</li><li>Magnification: 3-9x</li><li>Objective lens: 40mm</li><li>30mm Tube Diameter</li><li>Eye Relief: 2.5 - 3.7 in</li><li>0.25 MOA Adjustments</li><li>40 MOA Total Adjustment</li><li>Waterproof, Fog Proof, Shockproof</li><li>Weight: 15.8 oz</li><li>Field Of View: 33.8 - 11.3 ft at 100 Yards</li><li>6061-T6 Aluminum</li><li>Black</li><li></li></ul>	[empty string]	N	599.99	599.99	[empty string]	17874-DEFAULT-s.jpg	[empty string]	1000	1000	2700004	161992	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-huron-3-9x40mm-with-german-4-crosshair-hr940-c-2700004-161992	2700004	0
4	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	599.99	0	599.99	9453-DEFAULT-l.jpg	599.99	9453-DEFAULT-m.jpg	TRIJICON RMRCC RED DOT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Trijicon RMRcc 1x6.5 MOA LED \| Black \| 3100002	<p>Split seconds matter. The new Trijicon RMR cc has a thinner, lower-profile design that reduces the risk of snags for a faster and easier draw. Although smaller, the RMRcc keeps all the great features of the Trijicon RMR . Easy-to-use buttons, a common 2032 battery with up to 4 years of illumination, and a wide variety of mounts to fit today's popular concealed carry pistols, the RMRcc is the clear choice in personal defense. </p><p>Shoot more accurately with a single, crisp, clear aiming point superimposed on your target. Once zeroed in, where you see the dot is where your bullet will impact. Your eyes never need to leave the threat which allows you to stay focused on the situation. </p><p>Born from the industry-leading Trijicon RMR, the new RMRcc has the same reliability you expect, designed for concealed carry. The slimmer design fits a variety of pistols providing comfort during everyday carry. Carry confidently with a sight that increases your speed, improves your accuracy, and keeps your focus on the target.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Length x Width x Height: 1.8 in x .95 in x .97 in (45.72mm x 24.13mm x 24.64mm)</li><li>Weight: 1 oz. (28.35g)</li><li>Magnification: 1x</li><li>Reticle Pattern: 6.5 MOA Dot</li><li>Day Reticle Color: Red</li><li>Night Reticle Color: Red</li><li>Bindon Aiming Concept (BAC): No</li><li>Illumination Source: LED</li><li>Illumination Settings: Automatic and 8 Adjustable Settings (2 NV, 6 Visible)</li><li>Power Source: 1 CR2032 Lithium Battery</li><li>Battery Life: Over 4 years of continuous use (when used at 70 F (21 C)) at setting 4 of 8</li><li>Adjustment: 1 Tick = 3 MOA</li><li>Adjustment Range: 150 MOA Total Travel</li><li>Mount: Not included</li><li>Housing Material: 7075-T6 forged aluminum</li><li>Finish: Matte Black</li><li>Submersion Depth: 66 ft. (20m)</li></ul>	[empty string]	N	599.99	599.99	[empty string]	9453-DEFAULT-s.jpg	[empty string]	1000	1000	3100002	161998	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-rmrcc-1x6-5-moa-led-black-3100002-161998	3100002	0
5	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	119.99	0	119.99	20205-DEFAULT-l.jpg	119.99	20205-DEFAULT-m.jpg	TRIJICON NIGHT SIGHT 600227	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Trijicon Bright & Tough Night Sights For Glock Models 20/21/29/30/31/32 \| 600227	<p>Housed in a metal body and cushioned within silicon rubber and features a unique shock- resistant design. Each lamp is capped with a sapphire jewel to help evenly distribute the light while protecting the lamp from solvents and puncture. Contained within aluminum cylinders for additional protection the lamps are mounted on silicon rubber cushions to withstand shock and heavy recoil.</p><p><strong>SPECIFICATIONS & FEATURES</strong></p><ul><li>Gun Make Glock</li><li>Gun Model Glock 20, Glock 21, Glock 29, Glock 30, Glock 31, Glock 32, Glock 36, Glock 37, Glock 40, Glock 41</li><li>Color Black, Green</li><li>Front Sight Color Green w/White Outline</li><li>Rear Sight Color Green w/White Outline</li><li>Fabric/Material Aluminum</li><li>Front Material Tritium/Paint</li><li>Gun Type Pistol</li><li>Attachment/Mount Type Professional installation recommended.</li><li>Front Blade Height 0.15 in</li><li>Rear Blade Height 0.182 in</li><li>Illumination Type Tritium</li><li>Condition New</li></ul>	[empty string]	N	119.99	119.99	[empty string]	20205-DEFAULT-s.jpg	[empty string]	1000	1000	600227	162004	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-bright-tough-night-sights-for-glock-models-20-21-29-30-31-32-600227-162004	600227	0
6	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	169.99	0	169.99	10231-DEFAULT-l.jpg	169.99	10231-DEFAULT-m.jpg	TRIJICON SIGHT HD 600571	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Trijicon HD Night Sight For Sig Sauer \| #8 Front / #8 Rear Orange \| SG101O	<p><em><strong>Fits Sig Sauer models calibrated for 9mm and .357SIG, and pistols that come factory standard with #8 Front/#8 Rear including P225, P226, P228, P239, and P320 (Excluding P938 and P365).</strong></em></p><p>The HD Night Sights were specifically created to address the needs of tactical shooters. The three dot green tritium night sight set's front sight features a taller blade and an aiming point ringed in photoluminescent paint while the rear sight is outlined in black and features a wider U-shaped notch. This unique configuration increases visibility and quickens front sight acquisition -- even in transitional lighting. Additionally, the front surface of the rear sight is steeply hooked to assist in emergency one-handed slide operation. Green tritium lamps are warranted for 12 years from date of manufacture.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Fits Make: Sig Sauer </li><li>Fits Model: P225, P226, P228, P239, and P320 (Excluding P938 & P365).</li><li>Front Lamp Color: Green</li><li>Rear Lamp Color: Green</li><li>Front Paint Color: Orange</li><li>Rear Paint Color: Black</li><li>Front Blade Width: 0.144 in. (3.65mm)</li><li>Front Blade Height: 0.215 in. (5.46mm)</li><li>Overall Front Blade Height: 0.279 in. (7.08mm)</li><li>Rear Notch Style: U-Notch</li><li>Rear Notch Width: 0.169 in. (4.29mm)</li><li>Rear Blade Height: 0.218 in. (5.53mm)</li><li>Overall Rear Height: 0.309 in. (7.84mm)</li></ul><p>Trijicon 3 dot night sight sets are designed and assembled with an optimized combination of strength and safety features. They're constructed from machined steel and cushioned with silicone rubber for enhanced durability and precision. The shock-mounted aluminum illumination cylinder with its sapphire cap is surrounded by a white ring for maximum visibility and unrivaled repeatability.</p><p><strong><em>Note:<br />Professional installation recommended</em></strong></p><ul><li>Extra large front dot provides a bright distinctive aiming picture</li><li>Compatible with SIG Sauer P225, P226, P228 and P239 handguns</li><li>Metal body and silicone rubber cushioning create a shock-resistant design</li><li>Taller front blade increases visibility and accelerates front sight acquisition</li><li>Sapphire lamp cap evenly distributes the light from the tritium phosphor lamp</li><li>Steeply hooked, rear sight, front surface assists in emergency one-handed slide operation</li><li>Wider U-shaped notch on the black outlined rear sight adds to the ease of lining up the sight</li><li>Front aiming point ringed in photo-luminescent for faster target acquisition in low lighting conditions</li><li>Trijicon's proprietary tritium-illumination technology provides the front and rear dots with a brilliant green glow. Tritium night sights are self-illuminating; they do not require batteries</li><li>Made in the USA</li></ul>	[empty string]	N	169.99	169.99	[empty string]	10231-DEFAULT-s.jpg	[empty string]	1000	1000	600571	162010	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-hd-night-sight-for-sig-sauer-8-front-8-rear-orange-sg101o-162010	600571	0
7	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	169.99	0	169.99	4530-DEFAULT-l.jpg	169.99	4530-DEFAULT-m.jpg	TRIJICON SIGHT HD 600573	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Trijicon HD Night Sight Set 3-Dot Tritium For Sig P225,226,228,239,320 \| #8 Front & Rear (Except P938,365) \| 600573	<p>The HD Night Sights were specifically created to address the needs of tactical shooters. They are a self-luminous, three-dot night sight set that features a highly visible photoluminescent paint outline to quicken sight acquisition, along with a "U" notch rear sight that's angled and serrated to reduce glare and aid in front-sight focus. The Tritium gas lamps are contained within protective aluminum cylinders and have additional silicone rubber cushioning. Each Trijicon tritium lamp is capped with a sapphire jewel that helps evenly distribute the light and also acts as an additional layer of protection from puncture and cleaning solvents.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Trijicon</li><li>Category Handgun Sights</li><li>Model HD</li><li>Series Night Sight Set</li><li>Firearm Fit Sig P239</li><li>Rear Color Green with Black Outline</li><li>Style 3-Dot</li><li>Base Configuration #8 Front</li><li>Frame Color Black</li><li>Frame Material Aluminum</li><li>Front Color Green with Yellow Outline</li><li>Front Material Tritium</li><li>Rear Material Tritium</li></ul>	[empty string]	N	169.99	169.99	[empty string]	4530-DEFAULT-s.jpg	[empty string]	1000	1000	600573	162011	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-hd-night-sight-set-3-dot-tritium-for-sig-p225-226-228-239-320-8-front-rear-except-p938-365-600573-162011	600573	0
8	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	119.99	1	69.99	2437-DEFAULT-l.jpg	119.99	2437-DEFAULT-m.jpg	TRIJICON SIGHT B+T 600777	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Trijicon Bright And Tough 3-Dot Night Sights Glock 42 \| GL13	<p>Created to address the needs of tactical shooters, the Bright & Tough Night Sight for Glock 42/ 43 from Trijicon features green tritium lamps with protective and light-shaping sapphire jewels. The lamps do not require batteries to provide illumination for the sight in low-light conditions. The lamps are encapsulated by aluminum cylinders that protect them from abrasions and shock. The metal housing features silicone cushions to offer recoil-resistant performance.</p><p><strong>FEATURES</strong></p><ul><li>INSTANTLY VISIBLE SIGHT PICTURE IN NO-LIGHT OR LOW-LIGHT SITUATIONS</li><li>INCREASED DAYLIGHT DOT VISIBILITY</li><li>ENHANCED PROTECTION FROM HEAVY RECOIL AND HARSH CLEANING SOLVENTS</li><li>EVENLY DISTRIBUTED LIGHT FROM TRITIUM LAMPS</li></ul><p> </p>	[empty string]	Y	69.99	69.99	[empty string]	2437-DEFAULT-s.jpg	[empty string]	1000	1000	600777	162018	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-bright-and-tough-3-dot-night-sights-glock-42-gl13-162018	600777	0
9	YELLOW_FRONT	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	YELLOW_FRONT\|NULL\|NULL	1	149.99	1	129.99	7827-DEFAULT-l.jpg	149.99	7827-DEFAULT-m.jpg	TRIJICON SIGHT HD 600784	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Trijicon HD Night Sights Glock 42/43 \| Yellow \| 600784	<p>The three dot tritium night sight set’s front sight features a taller blade and an aiming point ringed in photoluminescent paint while the rear sight is outlined in black and features a wider U-shaped notch. This unique configuration increases visibility and quickens front sight acquisition even in transitional lighting. The front surface of the rear sight is steeply hooked to assist in emergency one-handed slide operation.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Made in the USA</li><li>Color: Yellow</li><li>For: Glock 42, 43</li><li>Manufacturer Part Number: GL113-C-600784</li></ul>	[empty string]	Y	129.99	129.99	42/43X48	7827-DEFAULT-s.jpg	[empty string]	1000	1000	600784	162020	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-hd-night-sights-glock-42-43-yellow-600784-162020	600784	0
10	[empty string]	TRIJICON INC	Trijicon Inc	SHOOTING	Shooting	[empty string]	1	169.99	0	169.99	11456-DEFAULT-l.jpg	169.99	11456-DEFAULT-m.jpg	TRIJICON SIGHT HD 600840	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	324	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Trijicon HD XR Night Sights For Glock 20/41 \| Yellow \| TRGHDXRY	<p>Designed to meet the needs of law enforcement agencies and civilian shooters alike, the new Trijicon HD XR night sights provide advanced target identification and allow the user to engage targets at longer distances. The front sight post is thinner than the original, giving shooters a larger field of view, which in turn enhances the ability to positively identify targets and make rapid hits if necessary. An excellent option for those that require precise target engagements at unconventional distances.</p><p><strong>Specifications and Features</strong></p><ul><li>Trijicon HD XR Night Sight Set</li><li>Larger field of view</li><li>Enhances ability to make precise hits on target</li><li>Faster follow-up shots</li><li>Yellow outline with Tritium front sight</li><li>Green Tritium rear sight</li><li>Blade width: .122"</li><li>Blade height: .215"</li><li>Rear notch width: .169"</li><li>Rear blade height: .231"</li></ul><p><strong><em>Fits:<br />Glock 20, 21, 29, 30, 36, 40, 41 (including S and SF variants)</em><br /></strong></p>	[empty string]	N	169.99	169.99	[empty string]	11456-DEFAULT-s.jpg	[empty string]	1000	1000	600840	162024	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trijicon-inc/trijicon-hd-xr-night-sights-for-glock-20-41-yellow-trghdxry-162024	600840	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 ? ) GROUP BY STYLE_ID

SQLPARAMETERS