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]	BROWNELLS INC	Brownells Inc	SHOOTING	Shooting	[empty string]	1	349.99	0	349.99	1991-DEFAULT-l.jpg	349.99	1991-DEFAULT-m.jpg	GEISSELE 05160 TRIGGER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	39	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	300-to-350	0.00	[empty string]	Super Semi-Automatic Enhanced Trigger	<p>Non-adjustable drop-in trigger built on the chassis of the Super Semi-Automatic trigger, this finely tuned version provides enhanced trigger control and weapon accuracy while maintaining the reliability of our combat-proven two-stage trigger. Reduced 1st and 2nd stage break.</p>	[empty string]	N	349.99	349.99	[empty string]	1991-DEFAULT-s.jpg	[empty string]	1000	1000	05160	91865	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	brownells-inc/super-semi-automatic-enhanced-trigger-91865	05160	0
4	[empty string]	BROWNELLS INC	Brownells Inc	SHOOTING	Shooting	[empty string]	1	349.99	0	349.99	1995-DEFAULT-l.jpg	349.99	1995-DEFAULT-m.jpg	GEISSELE 05167 TRIGGER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	39	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	300-to-350	0.00	[empty string]	Super Dynamic Enhanced Trigger	<p>Non adjustable, drop-in trigger. Reduced 1st and second stage pull weights. Ideal for use in precision Squad Designated Marksman type rifles.</p>	[empty string]	N	349.99	349.99	[empty string]	1995-DEFAULT-s.jpg	[empty string]	1000	1000	05167	91867	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	brownells-inc/super-dynamic-enhanced-trigger-91867	05167	0
5	[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
6	[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
7	[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
8	[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
9	[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
10	[empty string]	CVA	Cva	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	26091-DEFAULT-l.jpg	29.99	26091-DEFAULT-m.jpg	CVA AC1553AT 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]	7	25-to-50	0.00	[empty string]	CVA .50 Caliber 270 Grain PowerBelt Platinum Aerotip Bullets 15 Pack	<p>PowerBelt Platinum AeroTip Bullets utilizes an advanced plating technology, a more aggressive bullet shape and a fluted gas check design that combine to make the Platinum Series the best performing high velocity Powerbelt ever. PowerBelt Platinums are plated using a proprietary process that creates a smoother, more universal surface reduces the standard deviation between shots. This plating results in reduced resistance as the bullet travels down the bore, producing faster, more consistent velocities to improve both trajectory and accuracy.</p><p>PowerBelt Platinums also deliver an improved ballistic coefficient by utilizing a more aggressive bullet taper design. Not only does the new taper provide for a more aerodynamic flight, it also helps control the rate of expansion, regardless of powder charge or bullet velocity on impact. This makes the Platinum the perfect all around choice for use with magnum loads (110-150 grain powder equivalent). Also, the Platinum's larger diameter, fluted gas check fits more tightly than that of a standard PowerBelt, and is reinforced to better withstand magnum pressures, improving both velocity and accuracy.</p><p><strong>Specifications and Features:</strong></p><ul><li>.50 caliber</li><li>270 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]	26091-DEFAULT-s.jpg	[empty string]	1000	1000	AC1553AT	130261	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cva/cva-50-caliber-270-grain-powerbelt-platinum-aerotip-bullets-15-pack-130261	AC1553AT	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