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]	STICKY HOLSTERS	Sticky Holsters	SHOOTING	Shooting	[empty string]	1	42.99	0	42.99	16979-DEFAULT-l.jpg	42.99	16979-DEFAULT-m.jpg	STICKY BELLY BAND LG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4838	.STICKYBELLYBAND	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Sticky Holsters BBSM Belly Band (Multiple Sizes)	<p>Sticky Holsters Belly band offers a level of comfort, versatility and concealment that is unmatched. Our modular belly band works in conjunction with a Sticky Holster. This allows the user to place the holster and gun in any location. Our belly band is made with an industrial strength plush elastic that ensure both comfort and strength. The band has three patches of "STICKY" material to ensure the band stays in place without constant adjustments or movement. The band also includes four built-in accessory pockets. The smaller two are perfect for an extra magazine or folding knife. The larger one fits a wallet, phone, ID's, passport and other important items. Since there is no built in holster, this band can also be used as a travel band to hide important documents, and is great for securing items while working out.</p><p> </p>	[empty string]	N	42.99	42.99	S,M,L	16979-DEFAULT-s.jpg	[empty string]	1000	1000	STICKY BELLY BAND	78502	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sticky-holsters/sticky-holsters-bbsm-belly-band-multiple-sizes-78502	STICKY BELLY BAND	0
2	[empty string]	STICKY HOLSTERS	Sticky Holsters	SHOOTING	Shooting	[empty string]	1	32.99	1	19.99	16974-DEFAULT-l.jpg	32.99	16974-DEFAULT-m.jpg	STICKY GUARD HER BELT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4838	.STICKYGUARDHERBELT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	15-to-20	0.00	[empty string]	Sticky Holsters Guard Her Black Elastic Garter (Multiple Sizes)	<p>The Sticky Guard-Her-Belt is an improved design over other garter style holsters. Our modular designed Guard-Her-Belt works in conjunction with a Sticky Holster providing versatility and stability. We used an extremely comfortable soft plush, industrial strength elastic. The plush is on both sides to eliminate any chaffing or discomfort. The "STICKY" patches on the inside remove the need for any additional clips or straps to hold it in place. The Guard-Her-Belt also includes two accessory pouches for an additional magazine or knife.</p><p> </p>	[empty string]	Y	19.99	19.99	M,S,L	16974-DEFAULT-s.jpg	[empty string]	1000	1000	STICKY GUARD HER BELT	78503	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sticky-holsters/sticky-holsters-guard-her-black-elastic-garter-multiple-sizes-78503	STICKY GUARD HER BELT	0
3	[empty string]	BIG SHOT	Big Shot	SHOOTING	Shooting	[empty string]	1	199.99	0	199.99	27885-DEFAULT-l.jpg	199.99	27885-DEFAULT-m.jpg	BIG SHOT TARGET TITAN 10X	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4545	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	150-to-200	0.00	[empty string]	Big Shot Target Titan 10x	<p>The Titan 10x HD is the first 10-sided target designed for the fastest crossbow in the world. The TENpoint 505. It's amazing Twist and Pull feature offers maximum stopping power and minimum pulling effort. BIGshot's new HS Foam Formula offers maximum value and durability. Designed with 10 purpose driven shooting faces, the BIGshot Titan 10X HD includes over 150 aiming points! The 10X HD's Ample 17 X 17 size offers plenty of shooting surface for those longer test shots for crossbows , Plus the unique tree stand mode allows you to easily practice from an elevated platform to give you that realistic hunting scenario.</p>	[empty string]	N	199.99	199.99	[empty string]	27885-DEFAULT-s.jpg	[empty string]	1000	1000	BH-10X	124593	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	big-shot/big-shot-target-titan-10x-124593	BH-10X	0
4	[empty string]	BIG SHOT	Big Shot	SHOOTING	Shooting	[empty string]	1	189.99	0	189.99	27886-DEFAULT-l.jpg	189.99	27886-DEFAULT-m.jpg	BIG SHOT TARGET KINETIC 650	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4545	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	Big Shot Target Kinetic 650 - High Energy	<p>BIGshot's innovative answer for high-kinetic, high-speed crossbows continues with extreme stopping power! This high strength target utilizes the signature Iron Man stuffing with a 5 stage multi layered aramid core that stops heavy hitting bolts in their tracks. IRON MAN Kinetic 650 is rated at 650 FPS / 250 FP KE.</p><ul><li>High Compression</li><li>Easiest Pulling Target</li><li>High Tech Aramid Core</li><li>Long Lasting</li><li>95 shooting points</li><li>Field Point Only Target</li><li>For Compound or Crossbows</li><li>20H x 20W x 13D</li></ul>	[empty string]	N	189.99	189.99	[empty string]	27886-DEFAULT-s.jpg	[empty string]	1000	1000	IM20X	124598	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	big-shot/big-shot-target-kinetic-650-high-energy-124598	IM20X	0
5	[empty string]	COJO	Cojo	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	32051-DEFAULT-l.jpg	29.99	32051-DEFAULT-m.jpg	COJO MFG COJO2301	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4356	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	25-to-50	0.00	[empty string]	COJO Magnetic Gun Mount - Mount Anywhere!	<p>?<strong>FACILE INSTALLATION -</strong> we have constructed our gun magnet with two grommeted mounting holes to securely screw it in. With an easy installation, you can conveniently shift it from other vehicles. Moreover, 2 screws are enough to support the weight of your pistol and at the same time keep the sleekness of your vehicle interior.<br />?<strong>PATENTED DESIGN -</strong> US Patent# 9,528,794B2 With the competition of gun magnets in the market we have patented a unique design that's crafted for vehicular use. Our V-shape design will not only carry a gun but hold an extra mag so as to not leave you in a vulnerable position if you run out of ammo. We have patented this since we believe that our design has a potential not only for vehicles but for tactical advantages too!<br />?<strong>ENHANCED STRENGTH</strong> - made from the highest grade rare earth magnets, our product is made from strong permanent magnets categorized as rare-earth elements. This means that it produces the strongest magnetic field than other types of magnets and will definitely safely and securely hold your revolver or any pistol that you wish to keep in your car regardless of shakes and vibrations.<br />?<strong>STORAGE SOLUTIONS -</strong> It's a tactical storage solution compressed in a V-Shaped compact magnetic field! A Pistol magnet that can plant your pistol and pistol magazines in a place that you can easily access while maintaining a low profile! This is not your regular vehicle holster. It's a car gun magnet that can be discreetly placed in your car or truck.<br />?<strong>VERSATILE-</strong> Notwithstanding the fact that we specifically designed this for vehicular use, this magnet gun holder model can still be widely used in different places and for different firearms. With its V-shaped design, you can have a wide variety of options to place your gun in any angles in comparison with our counterparts.</p><p>WE ARE NOT THE CHEAPEST FOR A REASON!! The CoJo Gun Magnet is the only gun magnet on the market made that works for hunting situations and vehicle applications. With its patented V-shaped design, the magnet can hold shotguns,rifles, and pistols at an upright position without the worry of a possible accidental gun discharge. Not only can it help prevent a gun from falling over while hunting, it can also contain a gun anywhere to provide the user with fast, convenient, safe access in that time of need. CoJo Gun Magnet simply provides the user with more options for gun placement. It can be mounted in deer stands, duck blinds, home, offices, vehicles, UTV's and boats. A unique feature about the CoJo Gun Magnet is that it has a loop on each side of the magnet, which provides it with the ability to be mounted with a strap and wrapped around a tree while hunting in flooded timber, or can even be used as a tool belt around the waist. The belt loops can also be used to strap the magnet in ladderstands, climbing stands. The use of this product are simply on the bounds of imagination. DONT BE FOOLED BY COPYCATS OF THIS PRODUCT WE ARE A PATENTED PRODUCT.</p>	[empty string]	N	29.99	29.99	[empty string]	32051-DEFAULT-s.jpg	[empty string]	1000	1000	COJO2301	129868	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cojo/cojo-magnetic-gun-mount-mount-anywhere-129868	COJO2301	0
6	[empty string]	CVA	Cva	SHOOTING	Shooting	[empty string]	1	14.99	0	14.99	26088-DEFAULT-l.jpg	14.99	26088-DEFAULT-m.jpg	CVA POWDER FUNNEL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	70	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	19	10-to-15	0.00	[empty string]	CVA Powder Funnel Top for Pyrodex Cans	<p><strong>Filling flasks and powerd measures with Pyrodex just got easier with this can-top funnel from CVA.</strong></p><p><strong>Specifications and Features:</strong></p><ul><li>Snaps to top of Pyrodex can</li><li>Positive snap stopper prevents spillage</li></ul>	[empty string]	N	14.99	14.99	[empty string]	26088-DEFAULT-s.jpg	[empty string]	1000	1000	AC1385	130234	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cva/cva-powder-funnel-top-for-pyrodex-cans-130234	AC1385	0
7	[empty string]	CVA	Cva	SHOOTING	Shooting	[empty string]	1	7.99	0	7.99	6323-DEFAULT-l.jpg	7.99	6323-DEFAULT-m.jpg	CVA AC1407 STRAIGHT LINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	70	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	CVA Straight Line Capper	<p>All brass rectangular tube eliminates problems with tipped or jammed caps. Holds fifteen #11 caps.</p>	[empty string]	N	7.99	7.99	[empty string]	6323-DEFAULT-s.jpg	[empty string]	1000	1000	AC1407	130236	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cva/cva-straight-line-capper-130236	AC1407	0
8	[empty string]	CVA	Cva	SHOOTING	Shooting	[empty string]	1	5.99	0	5.99	7949-DEFAULT-l.jpg	5.99	7949-DEFAULT-m.jpg	CVA AC1431A DELUXE BULLET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	70	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	5-to-10	0.00	[empty string]	CVA Synthetic Bullet Starter	<p>Designed to get the bullet started and can be used with .32 to .58 caliber rifles or pistols.</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>Manufacturer Part Number</td><td>AC1431A </td></tr></table>	[empty string]	N	5.99	5.99	[empty string]	7949-DEFAULT-s.jpg	[empty string]	1000	1000	AC1431A	130239	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cva/cva-synthetic-bullet-starter-130239	AC1431A	0
9	[empty string]	CVA	Cva	SHOOTING	Shooting	[empty string]	1	19.99	0	19.99	6325-DEFAULT-l.jpg	19.99	6325-DEFAULT-m.jpg	CVA AC1473 FIBERGLASS RAMROD	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	70	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	CVA .50 Caliber Fiberglass Ramrod	<p>Flexibility to bend without breaking. Three foot length for you to custom fit. 11/32" diameter. 10-32 threads.</p>	[empty string]	N	19.99	19.99	[empty string]	6325-DEFAULT-s.jpg	[empty string]	1000	1000	AC1473	130251	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cva/cva-50-caliber-fiberglass-ramrod-130251	AC1473	0
10	[empty string]	CVA	Cva	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	26090-DEFAULT-l.jpg	29.99	26090-DEFAULT-m.jpg	CVA AC1550AT POWERBELT 50 CAL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	70	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	43	25-to-50	0.00	[empty string]	CVA .50 Caliber 250 Grain PowerBelt AeroLite Aerotip Bullet 15 Pack	<p>PowerBelt AeroLite Bullets borrow many of the PowerBelt Platinum's technical advantages, such as its plating technology, fluted gas check, and aggressive taper. However, the AeroLite bullet itself is completely different on the inside, being specifically designed to deliver optimal performance when used with standard (100 grain) propellant charges, the charge used by most hunters.</p><p>The AeroLite has a much larger hollow point cavity than either the Platinum or Copper PowerBelts. This larger cavity maximizes expansion capability while eliminating weight from the core of the bullet, allowing the bullet to be substantially longer than standard projectiles of similar weight. A longer bullet length produces more stability in flight and therefore, greater accuracy. A super-hard polycarbonate AeroTip fills the void of the oversized hollow point and serves to both optimize aerodynamics in flight and control expansion on impact.</p><p>All of these AeroLite technologies are fine-tuned to perform best at "standard charge velocities" (1800 FPS or less on impact) providing "magnum performance" without the "magnum recoil". This does not mean, however, that magnum charges can never be used with AeroLites. In hunting situations where long-range shots are the norm, Aerolites may indeed be the best choice, even with a 150 grain load.</p><p><strong>Specifications and Features:</strong></p><ul><li>.50 caliber</li><li>250 grain</li><li>Polymer tip</li><li>Fluted gas check</li><li>Package of 15</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]	26090-DEFAULT-s.jpg	[empty string]	1000	1000	AC1550AT	130259	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cva/cva-50-caliber-250-grain-powerbelt-aerolite-aerotip-bullet-15-pack-130259	AC1550AT	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 ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS