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	GREEN	ALLEN	Allen	SHOOTING	Shooting	GREEN\|NULL\|NULL	1	14.99	0	14.99	30964-DEFAULT-l.jpg	14.99	30964-DEFAULT-m.jpg	ALLEN 20550 SHELL CARRIER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	20550.20550	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Allen Deluxe Buttstock Shell Holder & Accessory Pouch \| Black/Olive Green	<p>The Adjustable Buttstock Shell Holder attaches to the buttstock of any rifle with an adjustable hook and loop strap system. Individual shell loops hold 5 cartridges, and a zippered pocket holds other accessories, like clips, hearing protection, or hunting aids. Soft plush fabric covers the cheek piece for comfort during shooting.</p><p><strong>Specifications</strong></p><ul><li><strong>Type:</strong> Shell Holder</li><li><strong>Color:</strong> Black</li><li><strong>Material:</strong> Cordura</li><li><strong>Size:</strong> Holds 5 Cartridges</li><li><strong>Model:</strong> Buttstock Shell Holder</li><li><strong>Finish:</strong> Textured</li><li><strong>Model Fit:</strong> Rifle</li><li><strong>Mount Type:</strong> Buttstock</li><li><strong>Manufacturer Part Number:</strong> 20550</li></ul>	[empty string]	N	14.99	14.99	[empty string]	30964-DEFAULT-s.jpg	[empty string]	1000	1000	20550	70432	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	allen/allen-deluxe-buttstock-shell-holder-accessory-pouch-black-olive-green-70432	20550	0
2	[empty string]	BOB ALLEN	Bob Allen	SHOOTING	Shooting	[empty string]	1	14.99	0	14.99	10327-DEFAULT-l.jpg	14.99	10327-DEFAULT-m.jpg	BOB ALLEN BA650 SHOTGUN CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Boyt Harness 16504 Classic Olive Green w/Khaki Panels 600D Nylon 48" Shotgun	[empty string]	[empty string]	N	14.99	14.99	48	10327-DEFAULT-s.jpg	[empty string]	1000	1000	16504	91027	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/boyt-harness-16504-classic-olive-green-w-khaki-panels-600d-nylon-48-shotgun-91027	16504	0
3	[empty string]	BOB ALLEN	Bob Allen	SHOOTING	Shooting	[empty string]	1	14.99	0	14.99	10328-DEFAULT-l.jpg	14.99	10328-DEFAULT-m.jpg	BOB ALLEN BA650 SHOTGUN CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Boyt Harness 16504 Classic Olive Green w/Khaki Panels 600D Nylon 48" Shotgun	[empty string]	[empty string]	N	14.99	14.99	52	10328-DEFAULT-s.jpg	[empty string]	1000	1000	16505	91028	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/boyt-harness-16504-classic-olive-green-w-khaki-panels-600d-nylon-48-shotgun-91028	16505	0
4	[empty string]	BOB ALLEN	Bob Allen	SHOOTING	Shooting	[empty string]	1	129.99	0	149.99	1607-DEFAULT-l.jpg	129.99	1607-DEFAULT-m.jpg	BOB ALLEN H52SG LONG GUN	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Boyt Single Long Gun Case	<ul><li>Internal dimensions: 52"" x 11.5"" x 4.5""</li><li>External dimensions: 53.5"" x 14"" x 5""</li><li>Weight: 13.5 lbs.</li><li>Made in the USA</li><li>Water resistant & dust proof O-ring full length gasket</li><li>Padlock compatible</li><li>All steel powder coated draw latches</li><li>Steel hinge pins</li><li>Fully stackable</li><li>4-Draw latches</li><li>Collapsible, comfort grip handle</li><li>Carry handle</li><li>No wheels</li><li>Egg crate foam (not customizable)</li><li>Compact dimensions meets most standard airline luggage/TSA requirements</li></ul>	[empty string]	N	149.99	149.99	[empty string]	1607-DEFAULT-s.jpg	[empty string]	1000	1000	40156	91032	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/boyt-single-long-gun-case-91032	40156	0
5	[empty string]	BOB ALLEN	Bob Allen	SHOOTING	Shooting	[empty string]	1	199.99	0	219.99	1606-DEFAULT-l.jpg	199.99	1606-DEFAULT-m.jpg	BOB ALLEN H51 LONG GUN	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	Boyt Double Long Gun Case 51x15x6	<p>Boyt Harness Company's hard-sided travel cases are designed and engineered to meet or exceed law enforcement, military and airline standards. These tough H-Series cases are made in the U.S.A using a high-impact, custom-formulated resin and sold with a lifetime warranty.</p><p><strong>H-Series Features:</strong></p><ul><li>Made in the USA</li><li>Water resistant & dust proof O-ring full length gasket</li><li>Constructed of high 120D no break polypropylene</li><li>Padlock compatible</li><li>Stainless steel ball bearing wheels</li><li>Pressure relief valve</li><li>Collapsible, comfort grip handles</li><li>All steel powder coated draw latches</li><li>Steel hinge pins</li><li>Fully Stackable</li><li>Limited lifetime warranty</li><li>Internal dimensions: 51" x 15" x 6"</li><li>External dimensions: 53.5" x 17.25" x 7"</li><li>Meets most standard airline luggage/TSA requirements</li></ul>	[empty string]	N	219.99	219.99	[empty string]	1606-DEFAULT-s.jpg	[empty string]	1000	1000	H51	91039	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/boyt-double-long-gun-case-51x15x6-91039	H51	0
6	[empty string]	BOB ALLEN	Bob Allen	SHOOTING	Shooting	[empty string]	1	14.99	0	14.99	6661-DEFAULT-l.jpg	14.99	6661-DEFAULT-m.jpg	BOB ALLEN PISTOL CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Boyt Harness 79012 Tactical Handgun Case Polyester Black 7.75" x 5.5" x 1.25"	<table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Type</td><td>Handgun Case</td></tr><tr><td>Color</td><td>Black</td></tr><tr><td>Dimensions</td><td>7.75" x 5.50" x 1.25"</td></tr><tr><td>Material</td><td>Polyester</td></tr><tr><td>Hardware</td><td>Full Length Zipper</td></tr><tr><td>Proofs</td><td>Water Resistant</td></tr><tr><td>Padding</td><td>Foam</td></tr><tr><td>Guns Held</td><td>Handgun</td></tr><tr><td>Manufacturer Part Number</td><td>79012 </td></tr></table>	[empty string]	N	14.99	14.99	[empty string]	6661-DEFAULT-s.jpg	[empty string]	1000	1000	MAXOP7	91041	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/boyt-harness-79012-tactical-handgun-case-polyester-black-7-75-x-5-5-x-1-25-91041	MAXOP7	0
7	BLACK	ALLEN	Allen	SHOOTING	Shooting	BLACK\|NULL\|NULL	1	159.99	0	159.99	20545-DEFAULT-l.jpg	159.99	20545-DEFAULT-m.jpg	ALLEN 10834 TAC SIX UNIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Allen Tac-Six 55" Lockable 2-Firearm Unit Tactical Case \| Laser Cut Molle Front \| Black	<p>The Tac-Six 55 Unit 2-Gun Tactical Case features an all-weather, durable 600D polyester tactical case with spacious storage to help keep your tactical rifle and accessories organized. Double compartments comfortably store your tactical rifles while the gun case is lockable for additional security when not in use. Whether you are at the range or on the move, the laser cut MOLLE system enables you to attach and customize for the accessories you need most. Stay organized and discover Tac-Six gear to fit your lifestyle.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Color</td><td>Black</td></tr><tr><td>Material</td><td>600D Polyester</td></tr><tr><td>Hardware</td><td>Double Zipper</td></tr><tr><td>Lockable</td><td>Yes</td></tr><tr><td>Padding</td><td>Yes</td></tr><tr><td>Guns Held</td><td>2 Rifles</td></tr><tr><td>Manufacturer Part Number</td><td>10834 </td></tr></table>	[empty string]	N	159.99	159.99	55	20545-DEFAULT-s.jpg	[empty string]	1000	1000	10834	116012	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	allen/allen-tac-six-55-lockable-2-firearm-unit-tactical-case-laser-cut-molle-front-black-116012	10834	0
8	ATACS_IX	ALLEN	Allen	SHOOTING	Shooting	ATACS_IX\|NULL\|NULL	1	99.99	0	119.99	30828-DEFAULT-l.jpg	99.99	30828-DEFAULT-m.jpg	ALLEN TACTICAL CASE	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Allen Velocity Tactical Rifle Cases	<p>The velocity tactical rifle case from Allen tactical fits tactical firearms up to 42"" or 55"" in length. The two extra large front pockets have stretch slots inside that can be used to organize gear and mags. The third front pocket is 15"" x 6"" and padded, designed to fit suppressors or other accessories that need extra protection. The Endura exterior fabric is durable and will stand up to use and abuse, and the inside of the case features dual-density heavy duty padding. Includes heavy-duty web handles with a padded handle grip and a removable, adjustable shoulder sling with a shoulder pad and metal hardware.</p><ul><li>Dual-density heavy-duty padding and heavy-duty lining</li><li>Extra-long front pocket accommodates suppressors and other accessories</li><li>Padded zip-close pockets and quick-release buckle closure</li><li>Stretch slots organize gear and mags inside pockets</li><li>Lockable zippers</li></ul><p><strong>ATTRIBUTES:</strong></p><ul><li><strong>Type:</strong> Rifle Case</li><li><strong>Color:</strong> ATAC-IX</li><li><strong>Dimensions:</strong> 55"</li><li><strong>Hardware:</strong> Full Length Zipper</li><li><strong>Lockable:</strong> Yes</li><li><strong>Padding:</strong> Yes</li><li><strong>Guns Held:</strong> 1 Rifle</li><li><strong>Manufacturer Part Number:</strong> 10938</li></ul>	[empty string]	N	119.99	119.99	55	30828-DEFAULT-s.jpg	[empty string]	1000	1000	10938	116020	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	allen/allen-velocity-tactical-rifle-cases-116020	10938	0
9	OD_GREEN	ALLEN	Allen	SHOOTING	Shooting	OD_GREEN\|NULL\|NULL	1	99.99	0	119.99	30878-DEFAULT-l.jpg	99.99	30878-DEFAULT-m.jpg	ALLEN 10954 GARRISON 55	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Allen Tac Six Garrison Case 55" - OD Green	<p>The Garrison rifle case in OD Green is the ultimate 55-inch performance soft rifle case. Features heavy-duty foam, reinforced stitching, and oversized pockets for all your gear. The interior of the case is made from 600 Denier Polyester along with an adjustable strap to keep your rifle stable while in the case. With its longer length, it is the perfect case for longer precision rifles and the heavy-duty stitching will hold all your gear securely.</p><p><strong>Specifications </strong></p><ul><li><strong>Color:</strong> OD Green</li><li><strong>Material:</strong> 600D Polyester</li><li><strong>Hardware:</strong> Adjustable/Removable Shoulder Strap</li><li><strong>Lockable:</strong> Yes</li><li><strong>Padding:</strong> Foam</li><li><strong>Guns Held:</strong> Rifle</li><li><strong>Manufacturer Part Number:</strong> 10954</li></ul>	[empty string]	N	119.99	119.99	55	30878-DEFAULT-s.jpg	[empty string]	1000	1000	10954	116022	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	allen/allen-tac-six-garrison-case-55-od-green-116022	10954	0
10	[empty string]	ALLEN	Allen	SHOOTING	Shooting	[empty string]	1	9.99	0	9.99	4946-DEFAULT-l.jpg	9.99	4946-DEFAULT-m.jpg	ALLEN 122 SHOTGUN SLEEVE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Allen Fleece Gun Sock 52" \| Camo	<p><strong>Attributes</strong></p><ul><li><strong>Color:</strong> Camo</li><li><strong>Dimensions:</strong> 52"</li><li><strong>Material:</strong> Fleece</li><li><strong>Guns Held:</strong> Shotgun</li><li><strong>Manufacturer Part Number:</strong> 122 </li></ul>	[empty string]	N	9.99	9.99	[empty string]	4946-DEFAULT-s.jpg	[empty string]	1000	1000	122	116023	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	allen/allen-fleece-gun-sock-52-camo-116023	122	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

array
1	Shooting
2	%xop%
3	%hunt%chef%
4	%casey%
5	%sun%optics%usa%
6	%hevishot%
7	%allen%
8	%wheeler%

Filter By

Sort By

Item # 122 $9.99

0 Reviews

Sign in

Shooting

Shooting

Availability

Brand

PRICE

Allen Deluxe Buttstock Shell Holder & Accessory Pouch | Black/Olive Green

Boyt Harness 16504 Classic Olive Green W/Khaki Panels 600d Nylon 48 " Shotgun

Boyt Harness 16504 Classic Olive Green W/Khaki Panels 600d Nylon 48 " Shotgun

Boyt Single Long Gun Case

Boyt Double Long Gun Case 51x15x6

Boyt Harness 79012 Tactical Handgun Case Polyester Black 7.75 " X 5.5 " X 1.25 "

Allen Tac- Six 55 " Lockable 2- Firearm Unit Tactical Case | Laser Cut Molle Front | Black

Allen Velocity Tactical Rifle Cases

Allen Tac Six Garrison Case 55 "- Od Green

Allen Fleece Gun Sock 52 " | Camo

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Shooting

Shooting

Availability

Brand

PRICE

Allen Deluxe Buttstock Shell Holder & Accessory Pouch | Black/Olive Green

Boyt Harness 16504 Classic Olive Green W/Khaki Panels 600d Nylon 48 " Shotgun

Boyt Harness 16504 Classic Olive Green W/Khaki Panels 600d Nylon 48 " Shotgun

Boyt Single Long Gun Case

Boyt Double Long Gun Case 51x15x6

Boyt Harness 79012 Tactical Handgun Case Polyester Black 7.75 " X 5.5 " X 1.25 "

Allen Tac- Six 55 " Lockable 2- Firearm Unit Tactical Case | Laser Cut Molle Front | Black

Allen Velocity Tactical Rifle Cases

Allen Tac Six Garrison Case 55 "- Od Green

Allen Fleece Gun Sock 52 " | Camo