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]	DEAD RINGER	Dead Ringer	SHOOTING	Shooting	[empty string]	1	124.99	0	124.99	5266-DEFAULT-l.jpg	124.99	5266-DEFAULT-m.jpg	DEAD RINGER DR4357 GUN SIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4094	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Dead Ringer Sight \| S&W M&P \| Green \| DR4357	<p>Dead Ringer DR4357 Snake Eyes S&W M&P Front/Rear Tritium Night Grn/Grn - When faced with self-defense or close quarters situations, it is paramount that one be able to acquire the target as quickly as possible. Snake Eyes' design lends itself to the natural shooting position, while allowing quick target acquisition with minimal learning curve. Even in low-light conditions, the tritium front and rear sights glow continuously. Additionally, Snake Eyes are manufactured with 100% military grade metals, making it both durable and reliable. Product features white paint on the front sight only. Rear sight is a press fit application and should be done by a professional gunsmith to avoid potential harm to slide or sight.</p>	[empty string]	N	124.99	124.99	[empty string]	5266-DEFAULT-s.jpg	[empty string]	1000	1000	DR4357	132048	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dead-ringer/dead-ringer-sight-s-w-m-p-green-dr4357-132048	DR4357	0
2	[empty string]	DEAD RINGER	Dead Ringer	SHOOTING	Shooting	[empty string]	1	124.99	0	124.99	5265-DEFAULT-l.jpg	124.99	5265-DEFAULT-m.jpg	DEAD RINGER DR4418 GUN SIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4094	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Dead Ringer Sight \| S&W Shield \| Green \| DR4418	<p>Dead Ringer DR4418 Snake Eyes S&W Shield Tritium Front/Rear Grn/Grn - When faced with self-defense or close quarters situations, it is paramount that one be able to acquire the target as quickly as possible. Snake Eyes' design lends itself to the natural shooting position, while allowing quick target acquisition with minimal learning curve. Even in low-light conditions, the tritium front and rear sights glow continuously. Additionally, Snake Eyes are manufactured with 100% military grade metals, making it both durable and reliable. Product features white paint on the front sight only. Rear sight is a press fit application and should be done by a professional gunsmith to avoid potential harm to slide or sight.</p>	[empty string]	N	124.99	124.99	[empty string]	5265-DEFAULT-s.jpg	[empty string]	1000	1000	DR4418	132049	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dead-ringer/dead-ringer-sight-s-w-shield-green-dr4418-132049	DR4418	0
3	[empty string]	DEAD RINGER	Dead Ringer	SHOOTING	Shooting	[empty string]	1	124.99	0	124.99	5264-DEFAULT-l.jpg	124.99	5264-DEFAULT-m.jpg	DEAD RINGER DR4449 GUN SIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4094	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Dead Ringer DR4449 Gun Sight	<p>DeadRinger DR4449 Snake Eyes Tritium Front/Rear Ruger SR9/SR40/SR45 Green/Orange - The design of Dead Ringer's Snake Eyes pistol sights lends itself to the natural shooting position while allowing quick target acquisition with minimal learning curve. Snake Eyes is more than just a 3-dot sight set; the white dot front and ghost ring rear with Lexan light pipes glow even in low-light conditions. Snake Eyes sights are manufactured with 100% military grade metals, making them both durable and reliable. This front and rear sight combo fits Ruger SR9/SR40/SR45 handguns. Note: Rear Sight is a press fit application and should be done by a professional gun smith to avoid potential harm to slide or sight.</p><p><strong>SPECIFICATIONS</strong></p><p><br />Mfg Item Num: DR4449<br />Supplier SKU: 93782<br />Category: GUN SIGHTS<br />Type: Tritium Front/Rear<br />Frame Material: Metal<br />Frame Color: Black<br />Firearm Fit: Ruger SR9/SR40/SR45<br />Style: 3 Dot/Ghost Ring<br />Front Material: Metal<br />Rear Material: Metal<br />Front Color: Green/Orange</p><p> </p><p> </p><p> </p>	[empty string]	N	124.99	124.99	[empty string]	5264-DEFAULT-s.jpg	[empty string]	1000	1000	DR4449	132050	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dead-ringer/dead-ringer-dr4449-gun-sight-132050	DR4449	0
4	[empty string]	DEAD RINGER	Dead Ringer	SHOOTING	Shooting	[empty string]	1	59.99	1	19.99	5263-DEFAULT-l.jpg	59.99	5263-DEFAULT-m.jpg	DEAD RINGER DR4552 GUN SIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4094	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	15-to-20	0.00	[empty string]	Dead Ringer Gun Sight For Glock \| DR4552	<ul><li>Type: Tritium Front</li><li>Material: Metal</li><li>Frame Color: Black</li><li>Firearm Type: Glock</li><li>Style: Fixed</li><li>Front Material: Metal</li><li>Fiber Optic Color: Green</li></ul>	[empty string]	Y	19.99	19.99	[empty string]	5263-DEFAULT-s.jpg	[empty string]	1000	1000	DR4552	132053	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dead-ringer/dead-ringer-gun-sight-for-glock-dr4552-132053	DR4552	0
5	[empty string]	HUNTERS SPECIALTIES	Hunters Specialties	SHOOTING	Shooting	[empty string]	1	3.99	0	3.99	22835-DEFAULT-l.jpg	3.99	22835-DEFAULT-m.jpg	HUNTERS SPECIALTIES 00687	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	143	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	5-and-under	0.00	[empty string]	Hunters Specialties Butt Stock Rifle Shell Holder Elastic Black	<p>With nearly 40 years of producing serious hunting tools under their belt, Hunters Specialties continues to manufacture innovative gear that will make you more efficient, more effective, and, ultimately, more successful.</p><p>This elastic sleeve slides over the buttstock of your rifle for easy access to 9 additional rifle cartridges. A great addition to your hunting gear.</p><p><strong>Specifications and Features:</strong></p><ul><li>Slides over Butt Stock</li><li>9 Rifle Cartride Loops</li><li>Elastic</li><li>Black</li></ul><p> </p>	[empty string]	N	3.99	3.99	[empty string]	22835-DEFAULT-s.jpg	[empty string]	1000	1000	00687	139420	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hunters-specialties/hunters-specialties-butt-stock-rifle-shell-holder-elastic-black-139420	00687	0
6	[empty string]	LASER AIM	Laser Aim	SHOOTING	Shooting	[empty string]	1	209.99	0	209.99	11332-DEFAULT-l.jpg	209.99	11332-DEFAULT-m.jpg	AIMSHOT KTMASTERRED	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	92	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Aimshot KTMASTERRED Master Rifle Laser Boresighter Kit Multiple Brass	<p><strong>DESCRIPTION:</strong></p><p>This kit includes 223 red laser bore sight and all 16 arbors for a full kit. You will be able to bore sight most standard SAAMI calibers with this kit. It comes in two zippered pouches, the two AAA batteries will power the red laser for hours.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand AimShot</li><li>Category Bore Sight Kits</li><li>Caliber Multi-Caliber</li><li>Model Master Kit</li><li>Material Brass</li><li>Style Kit</li><li>Battery AAA</li><li>Quantity 15 Studs</li></ul>	[empty string]	N	209.99	209.99	[empty string]	11332-DEFAULT-s.jpg	[empty string]	1000	1000	KTMASTERRED	200546	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	laser-aim/aimshot-ktmasterred-master-rifle-laser-boresighter-kit-multiple-brass-200546	KTMASTERRED	0
7	[empty string]	LASER AIM	Laser Aim	SHOOTING	Shooting	[empty string]	1	249.99	0	249.99	944-DEFAULT-l.jpg	249.99	944-DEFAULT-m.jpg	AIMSHOT TZ980IR LASER/LIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	92	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Aimshot TZ980-IR Infrared Adjustable Beam Wireless Light	<p>This is the infrared (IR) CREE LED version of the TZ980 lights. In order to use the IR LED TZ980, you MUST have night vision gear. The light beam is invisible to the naked eye. For varmint hunting this is ideal as the animals can not see the light at all, but with night vision gear they will be lit up full daylight! All TZ lights are sold as a full kit. Everything you need is included with the package. TZ980 Infrared LED light, picatinny rail mount, quick release mount, wireless remote pressure switch, and batteries (2 CR123A for the light, 1 CR1632 for the remote). Also included is an adapter when using the two CR123A batteries.</p><ul><li>Lumens: 400</li><li>Lens: Tempered Glass</li><li>Battery: 2 CR123A (included)</li><li>Battery Life (high): 1.5+ hours continuous</li><li>Battery Life (low): 20+ hours continuous</li><li>Weight (w/ battery): 10.2 oz</li><li>Construction: aluminum alloy w/ rubber grip</li><li>Finish: Matte Black</li><li>Water Proof: yes</li><li>Warranty: 5 Year Limited</li></ul>	[empty string]	N	249.99	249.99	[empty string]	944-DEFAULT-s.jpg	[empty string]	1000	1000	TZ980IR	200555	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	laser-aim/aimshot-tz980-ir-infrared-adjustable-beam-wireless-light-200555	TZ980IR	0
8	[empty string]	LASER AIMING SYSTEMS	Laser Aiming Systems	SHOOTING	Shooting	[empty string]	0	149.99	1	49.99	[empty string]	149.99	[empty string]	VIRIDIAN HS1 LASER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4423	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Viridian HS1 AR Platform Handstop \| Black Polymer With Red Laser	[empty string]	[empty string]	Y	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	1000	9120036	200559	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	laser-aiming-systems/viridian-hs1-ar-platform-handstop-black-polymer-with-red-laser-200559	9120036	0
9	[empty string]	LASER AIMING SYSTEMS	Laser Aiming Systems	SHOOTING	Shooting	[empty string]	0	219.99	0	219.99	[empty string]	219.99	[empty string]	VIRIDIAN R5-238/938 LASER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4423	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Viridian R5-238/938 Laser	<p>It's the ultimate targeting system for your Sig P238/938! You get the all-conditions visible Viridian Green laser sighting system, Instant-On Enhanced Combat Readiness activation, and an ECR enabled hybrid holster. No fumbling with buttons in critical situations. When you draw, it's on. </p>	[empty string]	N	219.99	219.99	[empty string]	[empty string]	[empty string]	1000	1000	R5-238/938	200565	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	laser-aiming-systems/viridian-r5-238-938-laser-200565	R5-238/938	0
10	[empty string]	LASER AIMING SYSTEMS	Laser Aiming Systems	SHOOTING	Shooting	[empty string]	1	219.99	0	219.99	749-DEFAULT-l.jpg	219.99	749-DEFAULT-m.jpg	VIRIDIAN R5-G43 LASER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4423	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Viridian R5-G43 Laser	<p>It's the ultimate targeting system for your Glock 43! You get the all-conditions visible Viridian Green laser sighting system, Instant-On Enhanced Combat Readiness activation, and an ECR enabled hybrid holster. No fumbling with buttons in critical situations. When you draw, it's on. </p>	[empty string]	N	219.99	219.99	[empty string]	749-DEFAULT-s.jpg	[empty string]	1000	1000	R5-G43	200568	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	laser-aiming-systems/viridian-r5-g43-laser-200568	R5-G43	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