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]	DOGTRA	Dogtra	UNCATEGORIZED	Uncategorized	[empty string]	1	179.99	0	249.99	40416-DEFAULT-l.jpg	179.99	40416-DEFAULT-m.jpg	DOGTRA TRAINING	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2128	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	Dogtra 1900s Remote Training System	<p><span style="font-size:18px;">Dogtra has committed over 20 years to crafting dog training e-collars, perfecting the precise fit-and-finish, intuitive design, and accountable performance. The Dogtra 1900S e-collar exemplifies this dedication, providing an ultimate dog training tool that is durable, dependable, and designed for the most demanding conditions. This high-output e-collar is the unit of choice for serious amateurs and award-winning professional trainers in pet obedience, hunting, competition trials, and K-9 training.</span></p> <p><span style="font-size:18px;"><strong>Key Features:</strong></span></p> <ul> <li><span style="font-size:18px;">3/4-Mile Range: The 1900S e-collar offers an extended range, making it ideal for various training environments.</span></li> <li><span style="font-size:18px;">Fully Waterproof: The durable design ensures the collar remains functional even in wet conditions.</span></li> <li><span style="font-size:18px;">Unique Modern Receiver Design: The collar strap wraps around the receiver and your dog’s neck for enhanced comfort and a seamless appearance.</span></li> <li><span style="font-size:18px;">Low-High Stimulation Levels: With 0-127 levels, the wide range of stimulation fits any dog’s personality, <strong><em>from mild to the most stubborn.</em></strong></span></li> <li><span style="font-size:18px;">Patented Rheostat Dial: Allows for gradual and precise stimulation control, displayed on the illuminated LCD screen on the handheld transmitter.</span></li> </ul> <p><span style="font-size:18px;"><strong>Ideal For:</strong></span></p> <ul> <li><span style="font-size:18px;">Pet obedience training</span></li> <li><span style="font-size:18px;">Hunting</span></li> <li><span style="font-size:18px;">Competition trials</span></li> <li><span style="font-size:18px;">K-9 training</span></li> </ul> <p><span style="font-size:18px;"><strong>Product Benefits:</strong></span></p> <ul> <li><span style="font-size:18px;">Durable and Dependable: Crafted to withstand the most demanding conditions.</span></li> <li><span style="font-size:18px;">Enhanced Comfort: Designed with your dog’s comfort in mind, ensuring a seamless fit.</span></li> <li><span style="font-size:18px;">Wide Range of Stimulation: Accommodates all dog personalities, providing low to high stimulation levels.</span></li> <li><span style="font-size:18px;">Precise Control: The Rheostat Dial offers gradual and precise control over stimulation levels.</span></li> </ul>	[empty string]	N	249.99	249.99	[empty string]	40416-DEFAULT-s.jpg	[empty string]	1000	1000	1900S	99142	TRAINING	EMPTY	EMPTY	0	0	0	EMPTY	dogtra/dogtra-1900s-remote-training-system-99142	1900s	0
2	[empty string]	DOGTRA	Dogtra	HUNTING	Hunting>Dogs>Training	[empty string]	1	299.99	0	299.99	13116-DEFAULT-l.jpg	299.99	13116-DEFAULT-m.jpg	DOGTRA 1900S HANDSFREE PLUS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2128	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	Dogtra 1900s Handsfree Plus Training System	<p><strong>DESCRIPTION</strong>:</p> <p>The Dogtra 1900S HANDSFREE PLUS combines our most versatile 1900S e-collar with a compact Dogtra HANDSFREE SQUARE, which allows you to control a transmitter remotely. The new HANDSFREE SQUARE features allow users to add up to 14 SQUARES delivering a diverse range of training scenarios.</p> <p>Each SQUARE can be paired to different functions (Nick, Constant, or HPP Vibration) and allows many users to quickly access any feature, at any time within 33 feet of the transmitter. This versatile system allows for multiple users to engage in the training process simply by pairing additional HANDSFREE SQUARES. This hands-free system is great for a family household or a trainer working hands on with a client.</p> <p>With comfort and safety in mind, the -mile range 1900S HANDSFREE PLUS is IPX9K waterproof certified making it durable and reliable for demanding training conditions. In addition to the easy hands-free access, the 1900S HANDSFREE PLUS also offers 127 stimulation levels to choose from for accurate control, HPP (High Performance Pager) vibration, and an ergonomic receiver shaped to the dog's neck.</p> <ul> <li>HANDSFREE SQUARE for Remote Control</li> <li>Expandable up to 14 HANDSFREE SQUARES</li> <li>3/4-Mile Range</li> <li>IPX9K Waterproof Certified</li> <li>High Output Receiver</li> <li>127 Stimulation Levels/Rheostat Dial/LCD Screen</li> <li>Nick/Constant Stimulation & HPP (High Performance Pager) Vibration</li> </ul>	[empty string]	N	299.99	299.99	[empty string]	13116-DEFAULT-s.jpg	[empty string]	1000	1000	1900SHFPLUS	99143	TRAINING	EMPTY	EMPTY	0	0	0	EMPTY	dogtra/dogtra-1900s-handsfree-plus-training-system-99143	1900SHFPLUS	0
3	[empty string]	DOGTRA	Dogtra	HUNTING	Hunting>Dogs>Training	[empty string]	1	429.99	0	429.99	13117-DEFAULT-l.jpg	429.99	13117-DEFAULT-m.jpg	DOGTRA PATHFINDER 2	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2128	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	400-to-450	0.00	[empty string]	Dogtra Pathfinder SE	<p>Tracking and Training in one system!</p><p>New features include: GPS Connector E-Collar Function button, Pager Vibration, LED Locate Light and a new PATHFINDER2 app with more features.</p><p>Explore more with you dogs on all outdoor activities from hiking to hunting with the newest GPS Dog Tracking and Training System. The new Dogtra PATHFINDER2 is a complete GPS tracking and training system featuring a newly redesigned FREE real time tracking and training app, tracking up to 21 dogs within a 9-mile range.* The new PATHFINDER2 system features the latest in dog tracking collars equipped with E-Collar training functions now including a LED Locate Light and Pager Vibration. The new GPS Connector is designed with a new E-Collar Function button for quicker response.</p><p>The PATHFINDER2 works with a FREE app based dog tracking system with no monthly subscription required, allowing users to track and train their dogs straight from their phone featuring offline maps access with no signal required. The app allows users to: share locations, create custom fences, customize activity modes and access e-collar training features, battery saving sleep mode, lost collar lock, a lost GPS Connector locator and more. Smart watch users can now track their dogs from their watch with quick access to the extended PATHFINDER2 dog tracking app that is available for Apple Watch Series 5 and Galaxy Watch4 and above. The Dogtra PATHFINDER2 App requires the Dogtra PATHFINDER2 system to operate. Range may vary depending on the surroundings.</p><p>PATHFINDER2 App Phone Requirements: iOS 12.1 or Android 6.0 and above and devices must include Bluetooth 5.0 and up.</p><p>New PATHFINDER2 System Features:</p><p>New GPS Connector with E-Collar Function Button<br />New GPS Receiver with Pager Vibration & LED Locate Light<br />New Receiver Lock Mode<br />New Sleep Mode<br />New E-Collar Functions: Pager Vibration & LED Locate Light<br />New USB 5V Charger<br />New PATHFINDER2 System is only compatible with the PATHFINDER2 Series Systems</p><p>New PATHFINDER2 App Features:</p><p>New FREE PATHFINDER2 App with updated user interface<br />New Smart Watch compatibility:<br /> Now available on Samsung Galaxy Watch4 Series<br /> Apple Watch Series 5 and above<br />Free maps powered by MapBox<br />New Fence Modes:<br /> E-Fence ( NEW)<br /> Geo-Fence<br /> Mobile-Fence</p><p>PATHFINDER2 App is only compatible with the PATHFINDER2 Series</p><p>Compatibility:<br />App: PATHFINDER2<br />Systems: PATHFINDER2 Receiver, PATHFINDER2 TRX Receiver, PATHFINDER2 GPS Connector</p><p>Not Compatible With:<br />Apps: PATHFINDER APP<br />Systems: PATHFINDER, PATHFINDER SE, PATHFINDER TRX, PATHFINDER MINI, PATHFINDER GPS Connector</p><p> </p>	[empty string]	N	429.99	429.99	[empty string]	13117-DEFAULT-s.jpg	[empty string]	1000	1000	PATHFINDERSE	99154	TRAINING	EMPTY	EMPTY	0	0	0	EMPTY	dogtra/dogtra-pathfinder-se-99154	PATHFINDERSE	0
4	[empty string]	AGUILA	Aguila	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	9.99	1	8.99	28155-DEFAULT-l.jpg	9.99	28155-DEFAULT-m.jpg	AGUILA 1B220268 AMMUNITION	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	22LR	[empty string]	3038	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	Aguila Subsonic Rimfire 22 LR 38 Grain Hollow Point \| 50 Rounds	<p>The Subsonic loads deliver accuracy and impact with a whisper. It may be a quiet round, but these loads are highly effective at taking down small game with precision and reliability. Specifications: 22 LR/38 gr/Hollow Point (HP)/50 Per Box/20 Cs</p><ul><li>Brand Aguila</li><li>Category Rimfire Rounds</li><li>Series Rimfire</li><li>Model Subsonic</li><li>Caliber 22 LR</li><li>Rounds Per Box 50</li><li>Casing Material Brass</li><li>Muzzle Energy 89 ft lbs</li><li>Muzzle Velocity 1024 fps</li><li>Application Target Shooting</li><li>Boxes Per Case 20</li><li>Bullet Type Hollow Point</li><li>Bullet Weight 38 gr</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	Y	8.99	8.99	[empty string]	28155-DEFAULT-s.jpg	[empty string]	1000	1000	1B223633	115826	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	aguila/aguila-subsonic-rimfire-22-lr-38-grain-hollow-point-50-rounds-115826	1B223633	0
5	[empty string]	AGUILA	Aguila	NEW BUILDS	New Builds	[empty string]	1	33.99	0	33.99	40124-DEFAULT-l.jpg	33.99	40124-DEFAULT-m.jpg	AGUILA 1E252110 AMMUNITION	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	25ACP	[empty string]	3038	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Aguila .25 ACP 50 Grain Full Metal Jacket \| 50 Rounds	<p>Aguila Ammunition, founded in 1961, is dedicated to the development and manufacturing of self-defense, recreational, hunting, law enforcement, and military ammunition. Aguila Ammunition meets SAAMI as well as CIP standards. Aguilla's Centerfire ammo makes use of Non-Corr Priming to guarantee reliable ignition in any weather condition.</p><p><br /><strong>SPECIFICATIONS:</strong></p><ul><li>Mfg Item Num: 1E252110 </li><li>Category: CENTERFIRE HANDGUN ROUNDS </li><li>Caliber :25 Automatic Colt Pistol (ACP)</li><li>Bullet Type :Full Metal Jacket</li><li>Bullet Weight :50 GR</li><li>Muzzle Energy :63 ft lbs</li><li>Muzzle Velocity :755 fps</li><li>Rounds Per Box :50</li><li>Boxes Per Case :20</li><li>Application :Performance/Protection</li><li>Casing Material :Brass</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	N	33.99	33.99	[empty string]	40124-DEFAULT-s.jpg	[empty string]	1000	1000	1E252110	115863	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	aguila/aguila-25-acp-50-grain-full-metal-jacket-50-rounds-115863	1E252110	0
6	[empty string]	AGUILA	Aguila	UNCATEGORIZED	Uncategorized	[empty string]	0	25.99	0	39.99	[empty string]	25.99	[empty string]	AGUILA AMMUNITION	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	32ACP	[empty string]	3038	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Aguila Ammunition	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	1000	1E322110	115867	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	aguila/aguila-ammunition-115867	1E322110	0
7	[empty string]	AGUILA	Aguila	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	29.99	0	29.99	7063-DEFAULT-l.jpg	29.99	7063-DEFAULT-m.jpg	AGUILA 1E762110 AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7.62X51	[empty string]	3038	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Aguila 7.62x51mm Nato 150 Grain FMJBT \| 20 Rounds	<p>A focus on accuracy makes this a perfect round for target and tactical applications. We added a boat tail to this short-action round to deliver even more precision. Aim with confidence with a round that's a favorite with military snipers and law enforcement sharpshooters.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Aguila</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 7.62x51mm NATO</li><li>Model Rifle</li><li>Bullet Weight 150 gr</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Application Target,Tactical</li><li>Boxes Per Case 25</li><li>Bullet Type Full Metal Jacket Boat-Tail (FMJBT)</li><li>Muzzle Energy 2519 ft lbs</li><li>Muzzle Velocity 2750 fps</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	N	29.99	29.99	[empty string]	7063-DEFAULT-s.jpg	[empty string]	1000	1000	1E762110	115874	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	aguila/aguila-7-62x51mm-nato-150-grain-fmjbt-20-rounds-115874	1E762110	0
8	[empty string]	AGUILA	Aguila	SHOOTING	Shooting>Ammo>Handgun	[empty string]	1	19.99	0	19.99	26374-DEFAULT-l.jpg	19.99	26374-DEFAULT-m.jpg	AGUILA AMMUNITION	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	380ACP	[empty string]	3038	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Aguila Ammunition 380 ACP 50 Rounds 95 Grain Full Metal Jacket	<ul><li>Manufacturer: Aguila Ammunition</li><li>Cartridge: .380 ACP</li><li>Number of Rounds: 50</li><li>Bullet Type: Full Metal Jacket (FMJ)</li><li>Bullet Weight: 95 grain</li><li>Cartridge Case Material: Brass</li><li>Muzzle Velocity: 945 ft/s</li><li>Muzzle Energy: 188 ft-lbs</li><li>Application: Target Shooting</li><li>Package Type: Box</li><li>Included Accessories: None</li><li>Primer Style: Centerfire</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	N	19.99	19.99	[empty string]	26374-DEFAULT-s.jpg	[empty string]	1000	1000	64042000312	115893	HANDGUN	EMPTY	EMPTY	0	0	0	EMPTY	aguila/aguila-ammunition-380-acp-50-rounds-95-grain-full-metal-jacket-115893	64042000312	0
9	[empty string]	OKUMA	Okuma	UNCATEGORIZED	Uncategorized	[empty string]	0	74.99	0	74.99	[empty string]	74.99	[empty string]	OKUMA SLV45 FLY REEL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3748	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Okuma Slv45 Fly Reel	[empty string]	[empty string]	N	74.99	74.99	[empty string]	[empty string]	[empty string]	1000	1000	SLV45	148900	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	okuma/okuma-slv45-fly-reel-148900	SLV45	0
10	[empty string]	MAUSER	Mauser	UNCATEGORIZED	Uncategorized	[empty string]	0	1599.99	0	1599.99	[empty string]	1599.99	[empty string]	LIEMKE MERLIN13	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2168	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Liemke Merlin13	[empty string]	[empty string]	N	1599.99	1599.99	[empty string]	[empty string]	[empty string]	1000	1000	80409021	183109	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mauser/liemke-merlin13-183109	80409021	0

CACHED

false

EXECUTIONTIME

102

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 ( 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