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]	SPRINGFIELD INC	Springfield Inc	SHOOTING	Shooting	[empty string]	1	799.99	0	799.99	9546-DEFAULT-l.jpg	799.99	9546-DEFAULT-m.jpg	SPRINGFIELD XDM ELITE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HS PRODUKT	SPRINGFIELD ARMORY	PISTOL	9MM	[empty string]	297	[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]	Springfield XD-M Elite Compact OSP 9mm Luger 3.8" Melonite Barrel \| Black \| Includes Hex Dragonfly	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The XD-M Elite represents the pinnacle of full-size, polymer-framed pistol design. It is built around the META (Match Enhanced Trigger Assembly) trigger for the ultimate performance in a striker-fired firearm. The META trigger sports a flat face, crisp break and integral overtravel stop that combine to deliver the best trigger in a factory polymer-framed pistol. Upgrades like an extended and flared magwell, ambi slide stop and enhanced slide serrations make the Elite a must-have option. The Elite's redesigned slide serrations give you larger and enhanced grasping grooves for even better purchase. The hammer-forged barrel is designed to deliver long life and match-grade accuracy, while its loaded chamber indicator is designed as both a visual and tactile indicator of the pistol's status. Springfield Armor XD-M Elite Compact OSP (Optical Sight Pistol) is EDC-ready. The XD-M Elite Compact OSP is designed for concealed carry, combining impressive capacity and performance with concealable dimensions for ease of carry. The match grade Melonite finished barrel maximizes ballistic performance while remaining compact for concealability, and the compact grip frame houses a double-column stainless steel magazine.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Springfield Armory</li><li>Category Pistols</li><li>Series Elite Compact OSP</li><li>Caliber 9mm Luger</li><li>Barrel Length Range 3" to 3.99"</li><li>Model XD-M</li><li>Capacity 14+1</li><li>Action DAO</li><li>Frame Finish Black</li><li>OAL 6.75"</li><li>Frame Material Polymer</li><li>Hand Right</li><li>Sight Style Contrast</li><li>Slide Finish Black Melonite</li><li>Slide Material Steel</li><li>Slide Description Serrated Black Melonite Steel with Optic Cut</li><li>Magazine Type OEM</li><li>Grips Black Interchangeable Backstrap</li><li>Sight Configuration Fiber Optic Front, U-Dot Rear</li><li>Includes 2 Magazines, Hex Dragonfly Red Dot</li><li>Safety Grip / Firing Pin / Loaded Chamber Indicator / Trigger</li><li>Barrel Description 3.80" Melonite Steel</li><li>Barrel Length 3.80"</li><li>Max Capacity 14</li><li>Weight 29 oz</li><li>Frame Description Polymer Frame w / Picatinny Rail</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	N	799.99	799.99	[empty string]	9546-DEFAULT-s.jpg	[empty string]	1000	1000	XDME9389CBHCOSP	65718	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	springfield-inc/springfield-xd-m-elite-compact-osp-9mm-luger-3-8-melonite-barrel-black-includes-hex-dragonfly-65718	XDME9389CBHCOSP	0
2	[empty string]	BENELLI	Benelli	SHOOTING	Shooting	[empty string]	1	1999.99	0	1999.99	1554-DEFAULT-l.jpg	1999.99	1554-DEFAULT-m.jpg	BENELLI ETHOS SUPER SPORT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BENELLI	BENELLI USA	SHOTGUN	20GA	[empty string]	28	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	0	500-or-more	0.00	[empty string]	Benelli ETHOS SuperSport 20 Gauge 28" Barrel 3" \| Carbon Fiber Nickel-Plated	<ul><li>Action: Semi-Auto</li><li>Gauge: 20ga</li><li>Finish: Carbon Fiber</li><li>Max Shell Length: 3""</li><li>Weight: 5.9 lbs</li><li>Length of Pull (LOP): 14-3/8""</li><li>Magazine Capacity: 4+1</li><li>Barrel Length: 28""</li><li>Overall Length: 49.5""</li><li>Choke: Crio - C, IC, M, IM, F</li><li>Type of Sights: Fiber optic front sight w/ mid-barrel bead</li><li>Stock: Comfort Tech 3</li><li>Handedness: Right Hand</li><li>Drop at Heel: 2-1/4""</li><li>Drop at Comb: 1-1/2""</li><li>Product Type Shotgun</li><li>Item Condition: New</li></ul><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	N	1999.99	1999.99	[empty string]	1554-DEFAULT-s.jpg	[empty string]	1000	1000	10633	66128	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	benelli/benelli-ethos-supersport-20-gauge-28-barrel-3-carbon-fiber-nickel-plated-66128	10633	0
3	[empty string]	TROY	Troy	SHOOTING	Shooting	[empty string]	1	14.99	1	9.99	6398-DEFAULT-l.jpg	14.99	6398-DEFAULT-m.jpg	TROY INDUSTRIES MAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3446	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	218	5-to-10	0.00	[empty string]	Troy Industries BattleMag 30 Round Magazine For AR-15 223 Remington/5.56x45mm/300 AAC Blackout	<p>The Troy Industries Battlemag is an advanced polymer 30-round magazine for AR-15 style firearms in .223 Remington. The polymers used in the magazine are chemical, biological and impact resistant. The feed lips have been reinforced and the mag uses an anti-tilt follower. The mag body features a aggressive scale texture that provides a sure grip but will also extract from magazine pouches easily. The spine of the magazine is designed to prevent over-insertion common with some polymer mags. Functions with all M4, M16, AR-15, HK416, and FN SCAR rifles.</p><p>Shipping Weight 0.342 Pounds</p><p> </p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>AR-15 Parts</td><td>AR-15 Parts</td></tr><tr><td>Caliber</td><td>.223/5.56mm</td></tr><tr><td>Capacity</td><td>30</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Caliber-Gauge</td><td>.223 REM.</td></tr><tr><td>Manufacturer Part Number</td><td>SMAGSIN00BT00</td></tr></table>	[empty string]	Y	9.99	9.99	[empty string]	6398-DEFAULT-s.jpg	[empty string]	1000	1000	01161	162311	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	troy/troy-industries-battlemag-30-round-magazine-for-ar-15-223-remington-5-56x45mm-300-aac-blackout-162311	01161	0
4	[empty string]	TROY	Troy	SHOOTING	Shooting	[empty string]	1	49.99	1	24.99	6468-DEFAULT-l.jpg	49.99	6468-DEFAULT-m.jpg	TROY INDUSTRIES SGASA4L00BT00	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3446	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	20-to-25	0.00	[empty string]	Troy Industries Low Profile Gas Block Pro Grade \| Stainless Steel Black Oxide	<p>Pro Grade stainless steel. Fits all M4 carbines and M16A2, A3 and A4 rifles. Replaces front sight to use 10 inch or longer MRF handguard. Enhanced reliability. Black Oxide finish. .750 inch. 1.2 ounces.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Color</td><td>Black</td></tr><tr><td>Manufacturer Part Number</td><td>SGAS-A4L-OOBT00 </td></tr></table>	[empty string]	Y	24.99	24.99	[empty string]	6468-DEFAULT-s.jpg	[empty string]	1000	1000	SGASA4L00BT00	162324	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	troy/troy-industries-low-profile-gas-block-pro-grade-stainless-steel-black-oxide-162324	SGASA4L00BT00	0
5	[empty string]	TROY	Troy	SHOOTING	Shooting	[empty string]	1	12.99	0	12.99	6471-DEFAULT-l.jpg	12.99	6471-DEFAULT-m.jpg	TROY INDUSTRIES TOOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3446	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Troy Industries Battle Sight Elevation and Windage Adjustment Tool	<p>Easily adjust elevation on Troy front BattleSights and windage on Troy Rear BattleSights.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Color</td><td>Black</td></tr><tr><td>Manufacturer Part Number</td><td>STOO-ADJ-OOOT00 </td></tr></table>	[empty string]	N	12.99	12.99	[empty string]	6471-DEFAULT-s.jpg	[empty string]	1000	1000	ST00ADJ000T00	162334	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	troy/troy-industries-battle-sight-elevation-and-windage-adjustment-tool-162334	ST00ADJ000T00	0
6	[empty string]	SPRINGFIELD INC	Springfield Inc	SHOOTING	Shooting	[empty string]	1	399.99	0	399.99	6475-DEFAULT-l.jpg	399.99	6475-DEFAULT-m.jpg	SHIELD RED DOT GE4688	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	297	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	350-to-400	0.00	[empty string]	Springfield Shield SMSC Micro Red Dot - 4 MOA	<p>Featuring a 4 M.O.A. dot and a light yet sturdy polymer body, the Shield SMSc mini-sight compact is ideal for compact carry guns such as the Hellcat OSP . The optic is powered by a single CR2032 battery and sports a quartz-coated polymer lens for clarity and shock-resistant durability. Comes standard with battery, mounting screws, hex wrench tools, sight adjustment minidial and 1 shim plate.</p>	[empty string]	N	399.99	399.99	[empty string]	6475-DEFAULT-s.jpg	[empty string]	1000	1000	GE4688	190358	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	springfield-inc/springfield-shield-smsc-micro-red-dot-4-moa-190358	GE4688	0
7	[empty string]	SPRINGFIELD INC	Springfield Inc	SHOOTING	Shooting	[empty string]	1	29.99	1	19.99	8772-DEFAULT-l.jpg	29.99	8772-DEFAULT-m.jpg	SPRINGFIELD HELLCAT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	297	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Springfield Hellcat 9mm Luger 11 Round Stainless Magazine	<p><strong>DESCRIPTION:</strong></p><p>This replacement or spare magazine is compatible with your Springfield Armory Hellcat.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Springfield Armory</li><li>Category Magazines</li><li>Caliber 9mm Luger</li><li>Model OEM</li><li>Color Stainless</li><li>Material Stainless Steel</li><li>Capacity 11rd</li><li>Firearm Fit Springfield Hellcat</li><li>Style Detachable</li><li>Max Capacity 11</li></ul>	[empty string]	Y	19.99	19.99	[empty string]	8772-DEFAULT-s.jpg	[empty string]	1000	1000	HC5911	190361	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	springfield-inc/springfield-hellcat-9mm-luger-11-round-stainless-magazine-190361	HC5911	0
8	[empty string]	SPRINGFIELD INC	Springfield Inc	SHOOTING	Shooting	[empty string]	1	39.99	1	29.99	6163-DEFAULT-l.jpg	39.99	6163-DEFAULT-m.jpg	SPRINGFIELD HC5913 MAGAZINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	297	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Springfield Hellcat 9mm 13 Round Extended Magazine	<table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Caliber</td><td>9mm Luger</td></tr><tr><td>Capacity</td><td>13rd</td></tr><tr><td>Finish</td><td>Stainless</td></tr><tr><td>Model</td><td>Hellcat</td></tr><tr><td>Material</td><td>Stainless Steel</td></tr><tr><td>Model Fit</td><td>Hellcat</td></tr><tr><td>Brand Fit</td><td>Springfield</td></tr><tr><td>Capacity</td><td>13rd</td></tr><tr><td>Manufacturer Part Number</td><td>HC5913 </td></tr></table>	[empty string]	Y	29.99	29.99	[empty string]	6163-DEFAULT-s.jpg	[empty string]	1000	1000	HC5913	190362	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	springfield-inc/springfield-hellcat-9mm-13-round-extended-magazine-190362	HC5913	0
9	[empty string]	SPRINGFIELD INC	Springfield Inc	SHOOTING	Shooting	[empty string]	1	39.99	0	39.99	11402-DEFAULT-l.jpg	39.99	11402-DEFAULT-m.jpg	SPRINGFIELD HC5913F MAGAZINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	297	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Springfield Hellcat 9mm 13 Round Magazine Flat Dark Earth Sleeve	<p><strong>DESCRIPTION:</strong></p><p>This replacement or spare magazine is compatible with your Springfield Armory Hellcat. It comes with a flat dark earth sleeve.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Springfield Armory</li><li>Category Magazines</li><li>Caliber 9mm Luger</li><li>Model OEM</li><li>Color Stainless</li><li>Material Stainless Steel</li><li>Capacity 13rd</li><li>Firearm Fit Springfield Hellcat</li><li>Style Detachable with Flat Dark Earth Sleeve</li><li>Max Capacity 13</li></ul>	[empty string]	N	39.99	39.99	[empty string]	11402-DEFAULT-s.jpg	[empty string]	1000	1000	HC5913F	190363	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	springfield-inc/springfield-hellcat-9mm-13-round-magazine-flat-dark-earth-sleeve-190363	HC5913F	0
10	[empty string]	SPRINGFIELD INC	Springfield Inc	SHOOTING	Shooting	[empty string]	1	39.99	0	39.99	11399-DEFAULT-l.jpg	39.99	11399-DEFAULT-m.jpg	SPRINGFIELD HP5915 MAGAZINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	297	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Springfield 15 Round 9mm Magazine For SA-35	[empty string]	[empty string]	N	39.99	39.99	[empty string]	11399-DEFAULT-s.jpg	[empty string]	1000	1000	HP5915	190365	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	springfield-inc/springfield-15-round-9mm-magazine-for-sa-35-190365	HP5915	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