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	STEEL_DAWN	BROWNING	Browning	SHOOTING	Shooting	STEEL_DAWN\|NULL\|NULL	1	10999.99	0	10999.99	6102-DEFAULT-l.jpg	10999.99	6102-DEFAULT-m.jpg	BROWNING PP65T PLATINUM PLUS SALE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	PP65T..BROWNINGPP65TPLATINUMPLUS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Browning Platinum Series Plus 65 Gun Fire Safe	<p>The PP65 is the largest safe in the Platinum Plus line -- built tall and extra wide. The cavernous interior is capable of holding up to 65 long guns with space left over for handguns, jewelry, cameras, laptops, documents and other important items. The extra tall dimension of the PP65 (66" of internal vertical space) gives you enough interior space to store extra long firearms, even a .50 caliber long range rifle. And you can rest easy knowing that your valuables are under protection of the finest security and fire protection in the gun safe industry.</p><p>To accommodate 65 guns, you need a big safe and the PP65 delivers with wider and taller dimensions than you normally find. However, the safe extends into your room only 27" and hugs the wall, allowing you to place the safe in any number of locations in your house without blocking off interior space. And given the elegant and clean stylings of the Platinum Plus safes, the PP65 will add style to any room instead of merely taking up space in a corner.</p><p><strong>Security:</strong></p><ul><li>7-Gauge Steel Body (3/16")</li><li>1-11/16" Thick Duo-Formed Door with full 10-Gauge inner plate</li><li>Uni-Force Locking System</li><li>OmniBarrier Lock Protection System</li><li>Pry-Stop Corner Bolts</li><li>1-1/2" diameter chromed locking bolts on all four sides of the door (top/sides/bottom)</li><li>UL Residential Security Container (RSC) Burglary Classification</li><li>Lifetime Warranty against Break-In, Attempted Break-In, and Fire</li><li>Made in the USA</li></ul><p><strong>Lock:</strong></p><ul><li>S&G Mechanical, S&G Top Lit Electronic or SecuRam ScanLogic Biometric locks are available</li></ul><p><strong>Thermablock Fire Protection:</strong></p><ul><li>Fire protection at 1750 F for 120 minutes</li></ul><p><strong>Apperance:</strong></p><ul><li>Automotive-grade gloss finish in your choice of color or rugged textured finish</li><li>Pinstriping and your choice of graphic</li><li>Five-spoke handle in your choice of finish</li><li>Grade VI Cedar Interior</li></ul><p><strong>Convenince/Storage:</strong></p><ul><li>Premium DPX Storage System with Quick Access Barrel Rack and Scope Saver</li><li>New High Capacity Barrel Rack</li><li>Axis Adjustable Shelving with Pistol Rack</li><li>Interior LED light package</li><li>Elevated floor protects gun stocks</li><li>Electrical Outlet</li><li>Jewelry Box with Drawer and multipurpose Insert and File Box</li></ul><p> </p>	[empty string]	N	10999.99	10999.99	[empty string]	6102-DEFAULT-s.jpg	[empty string]	1000	1000	PP65T	71589	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	browning/browning-platinum-series-plus-65-gun-fire-safe-71589	PP65T	0
2	GLOSS_BLACK_DIALLOCK	BROWNING	Browning	SHOOTING	Shooting	GLOSS_BLACK_DIALLOCK\|NULL\|NULL	1	3699.99	0	3699.99	1500-DEFAULT-l.jpg	3699.99	1500-DEFAULT-m.jpg	BROWNING SILVER SERIES SR33	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	SR33..BROWNINGSILVERSERIESSR33	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Browning Silver Series SR33 Gloss Black E Lock	<p><strong>For more information about custom orders, purchase information, and delivery please call store for details 318-282-2688 or 800-726-9930, Delivery Map in images, prices and distance may vary</strong></p><p>Amazing value, custom design.</p><p>SiIver safes are the base of the Browning ProSteel Custom Collection line-up. These safes share the same number of options as the Medallion and Platinum Plus safes, with a few feature changes that make their price more attractive. The SR33 is the smallest safe in the Silver line. The trim interior securely houses up to 33 long guns while the Axis interior opens up extra room for jewelry, pistols, documents and other important items that you won't fit into another brand of safe. The overall size of the SR33 makes it the ideal safe if you don't have a lot of extra room, or you want to store a portions of your firearms in a bedroom closet or other location separate from your primary firearm storage. Given the elegant and clean styling of the Silver safes, this safe will add style to any room along with peace of mind.</p><ul><li>Gun Capacity / Config 33 total (13/26+7)</li><li>Body Thickness 11 Gauge</li><li>Bolts 16 (10 Active)</li><li>Cubic Feet 27</li><li>Fire Rating 100 Minute / 1680 </li><li>Overall Weight 730 lbs 0 oz</li><li>Dimensions 60x31x25.5</li><li>Handle Type 5-spoke</li><li>Door Type 1 5/16" Duo-Formed</li><li>Scene / Graphics Raised Metallic Logo, Pinstriping and Silk-Screened Scene</li><li>Lock System Force Deflector</li><li>Safe Security Rating UL RSC Tool Attack</li><li>Interior Color Beige Fabric</li><li>Locking Bolt Sides 4 Sides (Top, Bottom, Left, Right)</li></ul><p>Fire Rating: 100 Minute/1680 <br />Security: 11 Gauge<br />Capacity: 33 Total (13/26+7)<br />Customization: 30 Options<br /></p>	[empty string]	N	3699.99	3699.99	[empty string]	1500-DEFAULT-s.jpg	[empty string]	1000	1000	SR33	71590	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	browning/browning-silver-series-sr33-gloss-black-e-lock-71590	SR33	0
3	BLACK_BLACKCHROME,GLOSS_BLACK	BROWNING	Browning	SHOOTING	Shooting	BLACK_BLACKCHROME\|NULL\|NULL,GLOSS_BLACK\|NULL\|NULL	1	5499.99	0	5499.99	4874-DEFAULT-l.jpg	5499.99	4874-DEFAULT-m.jpg	BROWNING SILVER SERIES SR49TD	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	SR49TD..BROWNINGSILVERSERIESSR49TD	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	Browning Silver Series SR49TD Gloss Black Dial Lock	[empty string]	[empty string]	N	5499.99	5499.99	[empty string]	4874-DEFAULT-s.jpg	[empty string]	1000	1000	SR49TD	71592	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	browning/browning-silver-series-sr49td-gloss-black-dial-lock-71592	SR49TD	0
4	CRIMSON_FADE_TWO_TON,GLOSS_BLACK,BLK_CHARCOAL	BROWNING	Browning	SHOOTING	Shooting	CRIMSON_FADE_TWO_TON\|NULL\|NULL,GLOSS_BLACK\|NULL\|NULL,BLK_CHARCOAL\|NULL\|NULL	1	7499.99	1	6299.99	2712-DEFAULT-l.jpg	7499.99	2712-DEFAULT-m.jpg	BROWNING SILVER SERIES SR65T	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	SR65T..BROWNINGSILVERSERIESSR65T	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	Browning Silver - 65 Tall Extra Wide Several Options In-Store (We Do Custom Orders)	<p><strong>For more information about custom orders, purchase information, and delivery please call store for details 318-282-2688 or 800-726-9930, Delivery Map in images, prices and distance may vary</strong></p><p>Strike it rich with a Silver safe.</p><p>For the best mix of security, fire protection, custom appearance and affordability, a Silver safe should be on your radar. The SR65T is the largest safe in the Silver line, ready to fit 65 long guns into its cavernous interior. The extra tall height (66" of internal vertical space) provides adequate interior space to store extra long firearms, even longer barreled heavy caliber precision rifles as well as additional Axis shelves for more valuables. The SR65T to be wider like a bureau instead of the more common "boxy" refrigerator shape of other safes (25.5" exterior depth). This allows you to place the safe in any number of locations in your house without blocking off interior space. The elegant and clean stylings of the Silver safes add style to any room.</p><p>Fire Rating: 100 Minute/1680 <br />Security: 11 Gauge<br />Capacity: 65 Total (39/52+13)<br />Customization: 30 Options</p><ul><li>Gun Capacity / Config 65 total (39/52+13)</li><li>Body Thickness 11 Gauge</li><li>Bolts 16 (10 Active)</li><li>Cubic Feet 59</li><li>Fire Rating 100 Minute / 1680 </li><li>Overall Weight 1275 lbs 0 oz</li><li>Dimensions 72x56x25.5</li><li>Handle Type 5-Spoke</li><li>Door Type 1 5/16" Duo-Formed</li><li>Scene / Graphics Raised Metallic Logo, Pin Striping and Silk-Screened Scene</li><li>Lock System Force Deflector</li><li>Safe Security Rating UL RSC Tool Attack</li><li>Locking Bolt Sides 4</li></ul>	[empty string]	N	6299.99	7499.99	[empty string]	2712-DEFAULT-s.jpg	[empty string]	1000	1000	SR65T	71593	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	browning/browning-silver-65-tall-extra-wide-several-options-in-store-we-do-custom-orders-71593	SR65T	0
5	[empty string]	ATLAS TRAP CO. INC.	Atlas Trap Co. Inc.	SHOOTING	Shooting	[empty string]	1	99.99	0	99.99	27562-DEFAULT-l.jpg	99.99	27562-DEFAULT-m.jpg	ATLAS TRAP TLT MODEL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4304	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Atlas Trap Tilting Base	<p>Equally tilt trap left or right 30 degrees for curling targets. Compatible with Patriot, AT50 and AT250.</p>	[empty string]	N	99.99	99.99	[empty string]	27562-DEFAULT-s.jpg	[empty string]	1000	1000	TLT	117704	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	atlas-trap-co-inc/atlas-trap-tilting-base-117704	TLT	0
6	[empty string]	ATLAS TRAP CO. INC.	Atlas Trap Co. Inc.	SHOOTING	Shooting	[empty string]	1	219.99	0	249.99	29107-DEFAULT-l.jpg	219.99	29107-DEFAULT-m.jpg	ATLAS TRAP WC2 CART	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4304	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	Atlas Trap 2-Wheel Cart	<ul><li>Pneumatic rubber tires with ball-bearing wheels</li><li>Battery box to accommodate Group 27 or 29 size deep-cycle marine battery</li><li>Heavy-duty steel frame</li><li>Pin-type hitch compatible</li><li>Compatible with Patriot, AT50 and AT250</li><li>Please note: NOT compatible with Recreational TRI-AXIS Base</li></ul>	[empty string]	N	249.99	249.99	[empty string]	29107-DEFAULT-s.jpg	[empty string]	1000	1000	WC2	117708	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	atlas-trap-co-inc/atlas-trap-2-wheel-cart-117708	WC2	0
7	[empty string]	BERGARA	Bergara	SHOOTING	Shooting	[empty string]	1	34.99	1	29.99	4777-DEFAULT-l.jpg	34.99	4777-DEFAULT-m.jpg	BERGARA AICS MAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Bergara Rifles Ba0015 B14 A1cs 308 Win;6.5 Creedmoor 3 Detachable	<p>Bergara 3 round Short action Aics patterned Magazine. Will not work with 6.5 PRC</p><p><strong>SPECIFICATIONS:</strong></p><ul><li><strong>Caliber:</strong> 308 Win;6.5 Creedmoor</li><li><strong>Capacity:</strong> 3</li><li><strong>Finish:</strong> Black</li><li><strong>Model:</strong> B14</li><li><strong>Material:</strong> Polymer</li><li><strong>Model Fit:</strong> B-14</li><li><strong>Brand Fit:</strong> Bergara</li><li><strong>Capacity:</strong> 3</li><li><strong>Manufacturer Part Number:</strong> BA0015</li></ul>	[empty string]	Y	29.99	29.99	[empty string]	4777-DEFAULT-s.jpg	[empty string]	1000	1000	BA0015	193183	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bergara/bergara-rifles-ba0015-b14-a1cs-308-win-6-5-creedmoor-3-detachable-193183	BA0015	0
8	[empty string]	LBE UNLIMITED	Lbe Unlimited	SHOOTING	Shooting	[empty string]	1	24.99	0	24.99	11413-DEFAULT-l.jpg	24.99	11413-DEFAULT-m.jpg	LBE UNLIMITED LBTOOL-AKSKS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5873	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	LBE Unlimited TOOL-AKSKS Wind and Elevation Tool for Ak/SKS	<table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Model</td><td>Sight Adjustment Tool</td></tr><tr><td>Manufacturer Part Number</td><td>TOOL-AKSKS </td></tr></table>	[empty string]	N	24.99	24.99	[empty string]	11413-DEFAULT-s.jpg	[empty string]	1000	1000	LBTOOL-AKSKS	200699	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lbe-unlimited/lbe-unlimited-tool-aksks-wind-and-elevation-tool-for-ak-sks-200699	LBTOOL-AKSKS	0
9	[empty string]	BROWNING	Browning	SHOOTING	Shooting	[empty string]	1	79.99	0	79.99	14029-DEFAULT-l.jpg	79.99	14029-DEFAULT-m.jpg	BROWNING MAGAZINE ABOLT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Browning 112022034 OEM Black Detachable 3rd 300 WSM for Browning A-Bolt, A-Bolt II	<p>Factory replacement magazine for Browning A-Bolt rifles.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Caliber</td><td>300 WSM</td></tr><tr><td>Capacity</td><td>3rd</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Model</td><td>OEM</td></tr><tr><td>Material</td><td>Steel with Polymer Base Pad</td></tr><tr><td>Type</td><td>Detachable</td></tr><tr><td>Model Fit</td><td>A-Bolt</td></tr><tr><td>Brand Fit</td><td>Browning</td></tr><tr><td>Capacity</td><td>3rd</td></tr><tr><td>Manufacturer Part Number</td><td>112022034 </td></tr></table>	[empty string]	N	79.99	79.99	[empty string]	14029-DEFAULT-s.jpg	[empty string]	1000	1000	02361417949	225758	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	browning/browning-112022034-oem-black-detachable-3rd-300-wsm-for-browning-a-bolt-a-bolt-ii-225758	02361417949	0
10	[empty string]	BROWNING	Browning	SHOOTING	Shooting	[empty string]	1	84.99	0	84.99	14017-DEFAULT-l.jpg	84.99	14017-DEFAULT-m.jpg	BROWNING 112022016 MAGAZINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Browning OEM Black Detachable 4rd 7mm-08 Rem for Browning A-Bolt, A-Bolt II	<p>Factory replacement magazine for Browning A-Bolt rifles.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Caliber</td><td>7mm-08 Rem</td></tr><tr><td>Capacity</td><td>4rd</td></tr><tr><td>Finish</td><td>Black</td></tr><tr><td>Model</td><td>OEM</td></tr><tr><td>Material</td><td>Steel with Polymer Base Pad</td></tr><tr><td>Type</td><td>Detachable</td></tr><tr><td>Model Fit</td><td>A-Bolt</td></tr><tr><td>Brand Fit</td><td>Browning</td></tr><tr><td>Capacity</td><td>4rd</td></tr><tr><td>Manufacturer Part Number</td><td>112022016 </td></tr></table>	[empty string]	N	84.99	84.99	[empty string]	14017-DEFAULT-s.jpg	[empty string]	1000	1000	112022016	225772	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	browning/browning-oem-black-detachable-4rd-7mm-08-rem-for-browning-a-bolt-a-bolt-ii-225772	112022016	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