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]	HAWKE	Hawke	ARCHERY	Archery	[empty string]	1	109.99	0	109.99	6777-DEFAULT-l.jpg	109.99	6777-DEFAULT-m.jpg	HAWKE HK12211 XBOW SCOPE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3154	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Hawke 3X32 SR IR Xbow Scope	<ul><li>Capped Low-Profile Turrets</li><li>1 Inch Mono-Tube Chassis</li><li>Illumination</li><li>1/2 MOA Low-Profile Fingertip Turrets</li><li>Fixed Parallax At 45 Metres</li><li>11 Layer Fully Multi-Coated Lenses</li><li>High Torque Zoom Ring</li><li>Fast Focus Eyebell</li><li>XB Multi-Line Reticles With Range Finding</li></ul>	[empty string]	N	109.99	109.99	[empty string]	6777-DEFAULT-s.jpg	[empty string]	1000	1000	12211	137665	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hawke/hawke-3x32-sr-ir-xbow-scope-137665	12211	0
2	[empty string]	HAWKE	Hawke	ARCHERY	Archery	[empty string]	1	299.99	0	299.99	15749-DEFAULT-l.jpg	299.99	15749-DEFAULT-m.jpg	HAWKE HK12227 XBOW SCOPE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3154	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Hawke XB30 Compact 2-8x36 SR Crossbow Scope	<p>Scopes designed to withstand the rigours of crossbows with reticle systems guaranteed to make you a better shot!</p><p><strong>SPECIFICATIONS: </strong></p><ul><li>Length: 256mm 10.1"</li><li>Weight: 435g 15.3oz</li><li>Eye relief: 76mm 3"</li><li>Focus/Parallax - Fixed 46m 50yds</li><li>Field of View: 21.9 - 5.5m @100m 65.7 - 16.4ft @100yds</li><li>Exit Pupil: 18-4.5mm 0.71-0.18"</li><li>Chassis 30mm Mono-tube</li><li>Optical System 2-8x</li><li>Objective 36mm</li><li>Illumination Red / Green</li><li>Reticle XB30 Compact SR</li><li>Elevation Increment 1/2 MOA</li><li>Elevation Adjustment Range: 180 MOA</li><li>Windage Increment 1/2 MOA</li><li>Windage Adjustment Range 180 MOA</li><li>Material Aluminum</li><li>Ocular Type Fast Focus</li><li>Lens Coating Fully Multi-Coated - 14 Layers</li><li>Power Selector Style Posi-Grip</li><li>Focal Plane Second Focal Plane (SFP)</li><li>Turret Caps Yes</li><li>Turret Type Low Profile, No-Snag, Fingertip</li></ul>	[empty string]	N	299.99	299.99	[empty string]	15749-DEFAULT-s.jpg	[empty string]	1000	1000	12227	137669	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hawke/hawke-xb30-compact-2-8x36-sr-crossbow-scope-137669	12227	0
3	[empty string]	HAWKE	Hawke	ARCHERY	Archery	[empty string]	1	119.99	1	59.99	23187-DEFAULT-l.jpg	119.99	23187-DEFAULT-m.jpg	HAWKE HK3265 RIFLE SCOPE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3154	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	93	50-to-100	0.00	[empty string]	Hawke 1x32 Crossbow IR Optic \| HK3265	<p>Hawke 1x32 Crossbow IR Waterproof Rifle Scope, SR Reticle carries high performance optics and a fully-floating glass-etched illuminated reticle designed to increase your success in the field. The Hawke Sport Optics 1x32 Crossbow IR Waterproof Rifle Scope, SR Reticle is built around a mono tube design that will hold up to use on crossbows, shotguns, or AR platforms. Unique reticle design allows for 6 aim points when shooting a crossbow. When used on a shotgun for turkey hunting the top cross represents a range finding crosshair. Designed to represent 4" at 40 yards, when the top of the cross is held at the top of the head, as soon as the bottom of the crosshairs no longer extends into feathers, the bird is in range. The wide angle image is bright and crisp, the long eye relief eyebell design allows the scope to quickly 'come up' to the eye. These performance features make the Hawke 1x32 Illuminated Crossbow Scope w/ SR Reticle ideal for use with high recoil turkey loads, or for CQB situations on your AR platform. Originally designed for crossbows, this multi-purpose scope is truly at home in many applications in the shooting sports marketplace.image</p><p>The SR crossbow scope features a red/green illuminated glass etched reticle. The rheostat to adjust brightness has 5 levels on each color. The reticle features illuminated hollow circles with a 2" 'Kill Zone' at the corrospoding distance. Compatible with the Hawke BRC software.</p><p><strong>Specifications for Hawke 1x32 Crossbow IR Rifle Scope, SR Reticle:</strong></p><ul><li>Model: 1x32</li><li>BRC: YES</li><li>Field of View ft @ 1000yards: 95</li><li>Field of View m @ 1000m:</li><li>Eye Relief, inches: 3.7</li><li>Eye Relief, mm: 94</li><li>Length, in: 9.3</li><li>Length, mm: 236</li><li>Weight, oz: 9.4</li><li>Weight, g: 266</li></ul><p><strong>Features of Hawke Sport Optics 1x32 Crossbow IR Rifle Scope, SR Reticle:</strong></p><ul><li>1" Mono tube construction handles the heaviest recoil</li><li>Multi-purpose reticle for crossbow, turkey or CQB use</li><li>Fully multi-coated optical system for maximum light transmission</li><li>1/2 M.O.A. Finger adjustable turrets for easy adjustment</li><li>Designed to withstand the rigors of crossbows, shotguns, or AR platforms</li><li>Supplied with weaver rings and flip up caps</li><li>Waterproof, shockproof and fog proof</li><li>Hawke Worldwide Warranty</li></ul><p><strong>Package Contents:</strong></p><ul><li>Hawke Sport Optics 1x32 Crossbow IR Rifle Scope, SR Reticle</li><li>Weaver Scope Rings</li><li>Flip-up lens caps</li></ul>	[empty string]	Y	59.99	59.99	[empty string]	23187-DEFAULT-s.jpg	[empty string]	1000	1000	HK3265	137743	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hawke/hawke-1x32-crossbow-ir-optic-hk3265-137743	HK3265	0
4	[empty string]	SKB	Skb	ARCHERY	Archery	[empty string]	1	249.99	0	249.99	39139-DEFAULT-l.jpg	249.99	39139-DEFAULT-m.jpg	SKB HUNTER SERIES BOW CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	286	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	SKB Hunter Series Bow Case - Black	<p>The 2SKB-4117 Hunter Series Bow Case is designed to accommodate most of the best selling bows on the market with the quiver attached at an affordable price point.</p><p>The 2SKB-4117 Hunter Series Bow Case features a rigid shaped ABS shell with stylish embossing that actually adds structural support to the lid with an eight point interlocking stacking system. SKB's "Perfect-Match" valance bending system provides a tight and secure fit to prevent dirt, dust and moisture from the interior of the case with lockable draw-bolt metal latches and a comfortable carrying handle and weighs eleven pounds. Features plush lined EPS inserts for maximum impact resistance and new state of the art water-jet cut polyethylene foam arrow system that will accommodate up to a dozen arrows.</p><p><strong>Features</strong></p><ul><li>Rigid ABS shell.</li><li>8-point interlocking stacking system.</li><li>Perfect-Match valance bending system.</li><li>Lockable draw-bolt metal latches.</li><li>Comfortable carrying handle.</li><li>Plush lined EPS inserts.</li><li>Water-jet cut foam arrow system (up to a dozen arrows).</li><li>5 year warranty.</li></ul><p><strong>Specifications:</strong></p><ul><li>Interior Length: 38.75"</li><li>Interior Width: 14.75"</li><li>Interior Depth: 5.13"</li><li>Carton Length: 45.00"</li><li>Carton Width: 19.50"</li><li>Carton Depth: 9.00"</li><li>Product Weight: 10.23 lbs</li><li>Shipping Weight: 13.00 lbs</li></ul>	[empty string]	N	249.99	249.99	[empty string]	39139-DEFAULT-s.jpg	[empty string]	1000	1000	2SKB-4117	157091	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	skb/skb-hunter-series-bow-case-black-157091	2SKB-4117	0
5	[empty string]	SKB	Skb	ARCHERY	Archery	[empty string]	1	299.99	0	299.99	39141-DEFAULT-l.jpg	299.99	39141-DEFAULT-m.jpg	SKB HUNTER SERIES XL BOW CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	286	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	SKB Hunter Series XL Bow Case - Black	<p>The Hunter XL Series 2SKB-4120 Case is the big brother to the popular smaller Hunter Series Bow Case. Accommodates the new wider style bows with the quiver attached and features plush lined EPS interior inserts to provide maximum impact resistance and a water jet cut foam arrow system that holds up to a dozen arrows.</p><p><strong>Features:</strong></p><ul><li>Accommodates wider style bows.</li><li>Plush lined EPS interior inserts.</li><li>Waterjet-cut foam arrow system (up to a dozen arrows).</li><li>Five year warranty.</li></ul><p><strong>Specifications:</strong></p><ul><li>Interior Length: 41.00"</li><li>Interior Width: 16.75"</li><li>Interior Depth: 5.50"</li><li>Carton Length: 45.00"</li><li>Carton Width: 21.00"</li><li>Carton Depth: 9.00"</li><li>Product Weight: 11.54 lbs</li><li>Shipping Weight: 15.00 lbs</li></ul>	[empty string]	N	299.99	299.99	[empty string]	39141-DEFAULT-s.jpg	[empty string]	1000	1000	2SKB-4120	157092	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	skb/skb-hunter-series-xl-bow-case-black-157092	2SKB-4120	0
6	[empty string]	HAWKE	Hawke	ARCHERY	Archery	[empty string]	1	29.99	0	79.99	28003-DEFAULT-l.jpg	29.99	28003-DEFAULT-m.jpg	HAWKE 4X32 SCOPE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	376	50-to-100	0.00	[empty string]	Hawke 4x32 Crossbow Scope	<p>Your scope is a precision instrument that deserves a high level of care. Do not attempt to<br />disassemble or clean the scope internally.<br />Keep the protective lens covers in place when the scope is not in use.<br />The external optical surfaces should be wiped clean occasionally with the lens cloth provided<br />or an optical quality lens paper. Remove any external dirt or sand with high pressure air and a<br />soft brush to avoid scratching the lens finish.<br />Wipe the scope with a damp cloth, then with a dry cloth, then go over the metal section of the<br />scope with a silicone cloth in order to protect the scope against corrosion.<br />Always store the scope in a moisture-free environment. Avoid storing the scope in places such<br />as the passenger compartments of vehicles on hot days as the high temperatures could<br />adversely affect the lubricants and sealants. Never leave the scope where direct sunlight can<br />enter either the objective or the eyepiece lens as damage may result from the concentration<br />(burning effect) of the sun's rays.</p><p><strong><span class="underline">Mounting the scope on your crossbow</span><br /></strong>Support your un-cocked crossbow on a sturdy surface and position a good quality set of rings<br />on the crossbows scope rail. Tighten up the side bolts.<br />Determine the best eye relief. This is achieved when the crossbow is held in your normal<br />shooting position and a full sight picture is viewed without straining or stretching your head<br />or neck. This optimum adjustment may also require the rings to be moved along the scope rail.<br />With the top ring screws still loosened slightly, rotate the scope so that the horizontal<br />crosswire is parallel with the crossbow string and limbs, when viewed through the scope.<br />Next, tighten the top ring screws and double check that the scope hasn't moved from its<br />optimum position.</p><p><strong><br /><span class="underline">Adjusting the ocular lens</span></strong><br />The ocular lens housing has a fine focus adjustment that quickly adjusts to make the reticle as<br />sharp as possible when viewed through the scope.<br />Set the focus of the reticle in similar light conditions and at the approximate range at which<br />you expect to use your scope.<br />Try not to stare at the reticle to get it in focus; it should be sharp the moment you glance<br />through the scope.</p><p><strong><br /><span class="underline">Initially zeroing the scope</span></strong><br />Choose a place to shoot your crossbow with a safe backstop and ensure that no one can step<br />unseen into or in front of the firing line.<br />Initially, place a paper target on the backstop at about 10 yards and take a shot at its center.<br />Remove the dust covers from the windage and elevation turrets of the scope and make a<br />suitable adjustment to the turret to bring the point of impact (POI) closer to the point of aim<br />(POA).<br />For example - if the arrow has landed lower than required; rotate the elevation turret counter<br />clockwise to raise the point of impact. A high impact point requires a clockwise adjustment.<br />Both turrets move the POA a 1/2 minute of angle per click - this is equal to a 1/2 inch at 100<br />yards or a 1/20th of an inch at 10 yards.<br />After achieving an approximate zero at 10 yards, move back to a measured 20 yards and<br />continue adjusting the turrets until the top cross of the reticle and the point of impact are the<br />same. At this range each click equals 1/10th of an inch.<br />When you are happy with the 20 yard zero, replace the turret covers.</p>	[empty string]	N	79.99	79.99	[empty string]	28003-DEFAULT-s.jpg	[empty string]	1000	1000	HK8401	245252	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hawke/hawke-4x32-crossbow-scope-245252	HK8401	0
7	[empty string]	HAWKE	Hawke	ARCHERY	Archery	[empty string]	1	379.99	1	299.99	29346-DEFAULT-l.jpg	379.99	29346-DEFAULT-m.jpg	HAWKE XB30 PRO CROSSBOW SCOPE 1-5X24 SR IR	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Hawke XB30 Pro Crossbow Scope 1-5x24 SR IR	<p>Hawke Sports Optics specifically designed and engineered their 1-5x24 XB30 Pro Crossbow Scope and SR reticle for crossbows using bolts traveling at speeds from 215-450 ft/s for optimum accuracy and ease-of-use. By placing the reticle on the second focal plane, the zoom changes the reticle's sub-tensions with the magnification, which allows you to calibrate the reticle to the bolt's speed for greatly improved shot placement. Multiple illuminated center aiming points provide drop compensation out to 60 yards, with non-illuminated markers on the posts give BDC aiming points from 70-100 yards. The illumination is red with a stepless rheostat to give you complete and precise control of the intensity to match most lighting conditions.</p><p>The objective is intentionally on the small side to maintain a low-profile and to keep the weight down. To offset the smaller objective are anti-reflection fully multi-coated optics that help maximize light transmission, ensuring bright and clear high-contrast images. This maximization of light transmission boosts the scope's low-light performance so you can hunt at dawn and dusk when many game animals amore most active. Capped turrets help guard against accidental adjustments while a fast-focus collar and knurled rheostat allow you to quickly adapt to rapidly changing conditions. Complementing the performance of the scope is a lightweight and durable anodized aluminum housing with a robust 30mm one-piece maintube that is nitrogen-filled and O-ring sealed to be water and fogproof.</p><p><strong>Optical Performance</strong></p><ul><li>1-5x zoom range</li><li>24mm objective lens</li><li>16-layer anti-reflection fully multi-coated optics improves color fidelity, contrast, and overall image brightness</li><li>100-20.9' field of view at 100 yards</li></ul><p><strong>Reticle Details</strong></p><ul><li>SR partially-illuminated modified German style</li><li>Designed for use with bolts traveling 215-450 ft/s</li><li>Reticle is placed on second focal plane, so the sub-tensions change with zoom settings for different speed bolts</li><li>Hollow outer posts with thin inner hairs on horizontal and lower vertical axes</li><li>Upper half of field of view is completely open</li><li>Illuminated center aiming crosses and indicators in hollow posts provide drop compensation from 30 to 100 yards</li><li>4" bracketing at each corresponding distance</li></ul><p><strong>Ballistic specifications at 5x magnification</strong></p><ul><li>Bow speed: 450 ft/s</li><li>Ballistic coefficient: 0.0553</li><li>Zeroed range: 20 yd</li><li>Scope height: 2" (5.1cm)</li></ul><p><strong>Ballistic specifications at 1x magnification</strong></p><ul><li>Bow speed: 215 ft/s</li><li>Ballistic coefficient: 0.0553</li><li>Zeroed range: 20 yd</li><li>Scope height: 2" (5.1cm)</li><li>Glass-etched to resist fading and shifting over time</li></ul><p><strong>Partial illumination:</strong></p><ul><li>Knurled Posi-Grip adjustment collar</li><li>Stepless rheostat enables precise intensity control</li><li>Red illumination: Ideal for low-light conditions</li><li>Runs on one included CR2032 battery</li></ul><p><strong>Use and Handling</strong></p><ul><li>Fast-focus collar</li><li>High-torque zoom mechanism maintains settings under extreme conditions</li><li>1/2 MOA per click impact point correction</li><li>210 MOA windage and elevation adjustment range</li><li>Finger-adjustable, low-profile covered turret caps prevent accidental adjustment</li><li>Fixed parallax set at 50 yards</li><li>Wide 24-4.8mm exit pupil</li><li>Comfortable 3" eye relief</li></ul><p><strong>Construction Details</strong></p><ul><li>Robust one-piece 30mm maintube</li><li>Lightweight and durable aluminum alloy chassis</li><li>Nitrogen-filled for water and fogproof performance</li><li>Anodized aluminum flip-up objective and ocular lens covers</li><li>Length: 10.1 inches</li><li>Weight: 16.5 ounces</li></ul>	[empty string]	Y	299.99	299.99	[empty string]	29346-DEFAULT-s.jpg	[empty string]	1000	1000	12230	249874	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hawke/hawke-xb30-pro-crossbow-scope-1-5x24-sr-ir-249874	12230	0
8	[empty string]	SKB	Skb	ARCHERY	Archery	[empty string]	1	289.99	0	289.99	39137-DEFAULT-l.jpg	289.99	39137-DEFAULT-m.jpg	SKB, iSERIES SHAPED BOW CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	SKB Case iSeries Shaped Bow Case - Black - 41"x17"	<p>Featuring the same waterproof, virtually-indestructible, military-grade construction of all SKB iSeries cases, but with an innovative curved bow shape that reduces weight and provides a more compact footprint. The 3i-4318-PL fits bows up to 41" long and 17" wide and includes hook-and-loop tie-downs for a secure fit, storage below the bow for a dozen arrows, lid storage for a quiver, and two mesh pockets for accessory boxes (SKB part# 3i-0702-1, sold separately) or other gear.</p>	[empty string]	N	289.99	289.99	[empty string]	39137-DEFAULT-s.jpg	[empty string]	1000	1000	3I-4318-PL	251713	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	skb/skb-case-iseries-shaped-bow-case-black-41-x17-251713	3I-4318-PL	0
9	[empty string]	SKB	Skb	ARCHERY	Archery	[empty string]	1	289.99	0	289.99	33134-DEFAULT-l.jpg	289.99	33134-DEFAULT-m.jpg	SKB ISERIES SHAPED BOW CASE TAN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	SKB Case iSeries Shaped Bow Case - Tan 41"x17"	<p>Featuring the same waterproof, virtually-indestructible, military-grade construction of all SKB iSeries cases, but with an innovative curved bow shape that reduces weight and provides a more compact footprint. The 3i-4318-PL fits bows up to 41" long and 17" wide and includes hook-and-loop tie-downs for a secure fit, storage below the bow for a dozen arrows, lid storage for a quiver, and two mesh pockets for accessory boxes (SKB part# 3i-0702-1, sold separately) or other gear.</p><p><strong>Features</strong></p><ul><li>Waterproof, MIL-SPEC construction</li><li>Accepts bows up to 41" long and 17" wide</li><li>4 hook-and-loop straps to secure bow</li><li>Storage for 12 arrows below the bow</li><li>Lid storage for quiver and two accessory boxes (part# 3i-0702-1; sold separately)</li><li>Made in USA</li><li>Unconditional lifetime warranty</li></ul>	[empty string]	N	289.99	289.99	[empty string]	33134-DEFAULT-s.jpg	[empty string]	1000	1000	3I-4318-PL-T	253125	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	skb/skb-case-iseries-shaped-bow-case-tan-41-x17-253125	3I-4318-PL-T	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