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]	TRU BALL	Tru Ball	ARCHERY	Archery	[empty string]	1	139.99	0	139.99	24663-DEFAULT-l.jpg	139.99	24663-DEFAULT-m.jpg	TRU BALL TRV3-BK RAVE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	618	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	TRU Ball Rave 3 Finger Caliper Head In Black \| TRV3-BK	<p>The Rave is easy to load with a pinch the jaw closed to the D-loop feature, simply grasp the jaw between your fore-finger and thumb to close onto the D-loop. The Rave has an individual trigger travel adjustment screw with a lock, and an individual trigger sensitivity adjustment screw with a lock. This trigger adjustment system allows for light to heavy trigger feels. A multi-positional thumb barrel and teardrop allows for customization of thumb placement. </p><p>- All aluminum body creates an extremely light-weight handle with an ultra-quiet release mechanism<br />- Comfortable, ergonomic three finger handle (same as Blade 3 Medium)<br />- Adjustable trigger sensitivity from light to heavy<br />- Individual travel and sensitivity adjustment screws with locks<br />- Multi-positional thumb barrel and teardrop<br />- Easy to load, quick and easy to close by pinching onto d-loop<br />- Built in lanyard secures release to your wrist<br />- 3 finger medium handle release</p><p> </p>	[empty string]	N	139.99	139.99	[empty string]	24663-DEFAULT-s.jpg	[empty string]	1000	1000	TRV3-BK	162377	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	tru-ball/tru-ball-rave-3-finger-caliper-head-in-black-trv3-bk-162377	TRV3-BK	0
2	[empty string]	TRUGLO INC	Truglo Inc	ARCHERY	Archery	[empty string]	1	14.99	0	14.99	4571-DEFAULT-l.jpg	14.99	4571-DEFAULT-m.jpg	TRU GLO TG09G FIBER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Tru Glo Replacement Fiber	[empty string]	[empty string]	N	14.99	14.99	[empty string]	4571-DEFAULT-s.jpg	[empty string]	1000	1000	TG09G	162410	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	truglo-inc/tru-glo-replacement-fiber-162410	TG09G	0
3	[empty string]	TRUGLO INC	Truglo Inc	ARCHERY	Archery	[empty string]	1	89.99	0	89.99	4613-DEFAULT-l.jpg	89.99	4613-DEFAULT-m.jpg	TRU GLO NITRUS RELEASE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Tru Glo Nitrus Release	<ul><li>Quiet, fast and accurate</li><li>Breakthrough stainless steel dual-jaw design</li><li>Smooth, micro-adjustable trigger pull with a crisp feel</li><li>No unwanted trigger travel</li><li>Precision stainless steel wear free jaws</li></ul>	[empty string]	N	89.99	89.99	[empty string]	4613-DEFAULT-s.jpg	[empty string]	1000	1000	TG2550MBB	162438	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	truglo-inc/tru-glo-nitrus-release-162438	TG2550MBB	0
4	[empty string]	TRUGLO INC	Truglo Inc	ARCHERY	Archery	[empty string]	1	99.99	0	99.99	4612-DEFAULT-l.jpg	99.99	4612-DEFAULT-m.jpg	TRU GLO VEROS 5	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Tru Glo Veros 5 Pin Bow Sight	<ul><li>Lightweight carbon composite and aluminum construction</li><li>Transfers less vibration</li><li>Extra long fibers for maximum brightness</li><li>Universal, right hand and left handed use</li><li>Durable and long lasting</li></ul>	[empty string]	N	99.99	99.99	[empty string]	4612-DEFAULT-s.jpg	[empty string]	1000	1000	TG5105B	162456	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	truglo-inc/tru-glo-veros-5-pin-bow-sight-162456	TG5105B	0
5	[empty string]	TRUGLO INC	Truglo Inc	ARCHERY	Archery	[empty string]	1	199.99	0	199.99	4603-DEFAULT-l.jpg	199.99	4603-DEFAULT-m.jpg	TRU GLO TG8514BLC CROSSBOW	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Truglo TG8514BLC OPTI-Speed Crossbow Scope 1-4x 24mm Obj Wide FOV 30mm Tube Black Finish Illuminated BDC	<p><strong>Attributes</strong></p><ul><li><strong>Magnification:</strong> 1-4x</li><li><strong>Objective:</strong> 24mm</li><li><strong>Field of View:</strong> Wide</li><li><strong>Tube Diameter:</strong> 30mm</li><li><strong>Finish:</strong> Black</li><li><strong>Reticle:</strong> Illuminated BDC</li><li><strong>Adj Size:</strong> .50 MOA</li><li><strong>Proofs:</strong> Waterproof, Fogproof</li><li><strong>Optic Coating:</strong> Fully Coated</li><li><strong>Manufacturer Part Number:</strong> TG8514BLC </li></ul>	[empty string]	N	199.99	199.99	[empty string]	4603-DEFAULT-s.jpg	[empty string]	1000	1000	TG8514BLC	162490	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	truglo-inc/truglo-tg8514blc-opti-speed-crossbow-scope-1-4x-24mm-obj-wide-fov-30mm-tube-black-finish-illuminated-bdc-162490	TG8514BLC	0
6	BLACK	CBE	Cbe	ARCHERY	Archery	BLACK\|NULL\|NULL	1	99.99	0	99.99	13620-DEFAULT-l.jpg	99.99	13620-DEFAULT-m.jpg	CBE ADAPT QUIVER	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4813	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	CBE Quivers Adapt Quiver 5 Arrow Black	<p>Adapt to your surroundings with this ultra-versatile and compact 5 arrow quiver.</p><p>With massive vertical and horizontal adjustment options, the CBE Adapt allows the hunter to create custom & compact containment. The rear facing arrow ensures quick access while the dovetail mount and hood loop allows for easy removal and storage. At just 9.5 ounces, the CBE Adapt features a lightweight yet sturdy design with full containment for both fixed and mechanical broadheads.</p><ul><li>- 5 Arrow Gripper With One Rear Facing Arrow For Quick Access</li><li>- Dovetail Mount With Nearly 1" Of Additional Horizontal Adjustment; Spacers Included For Even Greater Adjustment</li><li>- 7.5" Of Vertical Adjustment</li><li>- Weighs Just 9.5 Oz. With Machined Aluminum Frame</li><li>- Brackets (Included) Allow Mounting to Either Sight or Riser</li><li>- Easily Remove & Hang With Dovetail Mount &amp; Attached Hood Loop</li><li>- Accommodates Fixed & Mechanical Broadheads and All Arrow Diameters</li></ul>	[empty string]	N	99.99	99.99	[empty string]	13620-DEFAULT-s.jpg	[empty string]	1000	1000	CBE-AC-AD	228782	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cbe/cbe-quivers-adapt-quiver-5-arrow-black-228782	CBE-AC-AD	0
7	[empty string]	CBE	Cbe	ARCHERY	Archery	[empty string]	1	49.99	0	59.99	16602-DEFAULT-l.jpg	49.99	16602-DEFAULT-m.jpg	CBE BRIDGE-LOCK CONVERSION	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4813	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Cbe Bridge-lock Conversion	<p>The CBE Bridge-Lock Technology Conversion Bar fits securely into Mathews Bridge-Lock equipped bows and is designed to recenter the windage adjustment for the ideal range of movement with CBE sights. The lightweight aluminum dovetail bar is easy to install with only a couple screws and will fit on any CBE Dovetail sight including the CBE Engage, TEK Hybrid Pro, CX5 and NEW Trek Pro.</p><p>With this conversion bar you can now attach CBE sights to your Mathews Bridge Lock equipped bow.</p>	[empty string]	N	59.99	59.99	[empty string]	16602-DEFAULT-s.jpg	[empty string]	1000	1000	CBE-AC-BLD	228783	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cbe/cbe-bridge-lock-conversion-228783	CBE-AC-BLD	0
8	[empty string]	CBE	Cbe	ARCHERY	Archery	[empty string]	1	49.99	0	49.99	16599-DEFAULT-l.jpg	49.99	16599-DEFAULT-m.jpg	CBE PICATINNY SIGHT ADAPTER	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4813	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Cbe Picatinny Sight Adapter	<p>The CBE Picatinny Mount Adapter is a simple to use, mounting accessory that accommodates any front Picatinny style sight mounts. Made from lightweight, machined aluminum, the Picatinny Mount Adapter provides 1st axis adjustment and is compatible with the CBE Trek Pro, Trek, Engage Hybrid, Engage Micro & CX5.</p><ul><li>Simple Accessory-Mounting Platform For Front Picatinny Style Sight Mounts</li><li>Provides 1st Axis Adjustment</li><li>Ambidextrous - Can Be Used For Both Right & Left-Handed Shooters</li><li>Compatible With The Following CBE Sights: Trek Pro, Trek, Engage Hybrid, Engage Micro & CX-5</li><li>Lightweight, Machined Aluminum Construction</li></ul>	[empty string]	N	49.99	49.99	[empty string]	16599-DEFAULT-s.jpg	[empty string]	1000	1000	CBE-AC-PMA	228784	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cbe/cbe-picatinny-sight-adapter-228784	CBE-AC-PMA	0
9	[empty string]	CBE	Cbe	ARCHERY	Archery	[empty string]	1	44.99	0	44.99	4771-DEFAULT-l.jpg	44.99	4771-DEFAULT-m.jpg	CBE CBE-AC-TC5 TACTIC 5	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4813	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	CBE Tactic 5 Quiver	<ul><li>Ultra-light, compact design</li><li>Vertically adjustable to get the perfect fit</li><li>Accepts both fixed and mechanical broad heads</li><li>Unique clamping design, cam locking lever mechanism locks quiver securely and allows for easy one hand removal and attachment</li><li>Mounts directly to sight</li><li>5 Arrow Quiver</li></ul>	[empty string]	N	44.99	44.99	[empty string]	4771-DEFAULT-s.jpg	[empty string]	1000	1000	CBE-AC-TC5	228785	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cbe/cbe-tactic-5-quiver-228785	CBE-AC-TC5	0
10	[empty string]	CBE	Cbe	ARCHERY	Archery	[empty string]	1	79.99	0	79.99	1555-DEFAULT-l.jpg	79.99	1555-DEFAULT-m.jpg	CBE CBE-AC-TX11 TORX	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4813	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	CBE Torx Hunting Stabilizer 11"	<p>High Mod Light Weight Carbon<br />Doinker A-Bomb included<br />2 oz of Black Nitride stainless steel weights included on each stabilizer<br />Increased stability of your bow<br />Vibration reducing design</p>	[empty string]	N	79.99	79.99	[empty string]	1555-DEFAULT-s.jpg	[empty string]	1000	1000	CBE-AC-TX11	228786	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cbe/cbe-torx-hunting-stabilizer-11-228786	CBE-AC-TX11	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 ? ) GROUP BY STYLE_ID

SQLPARAMETERS

array
1	Archery
2	%tru%
3	%cyclops%
4	%tekto%
5	%pro%mag%
6	%nanuk%
7	%cbe%

Filter By

Sort By

Item # CBE-AC-TX11 $79.99

0 Reviews

Sign in

Archery

Archery

Availability

Brand

PRICE

Tru Ball Rave 3 Finger Caliper Head In Black | Trv3- Bk

Tru Glo Replacement Fiber

Tru Glo Nitrus Release

Tru Glo Veros 5 Pin Bow Sight

Truglo Tg8514blc Opti- Speed Crossbow Scope 1- 4x 24mm Obj Wide Fov 30mm Tube Black Finish Illuminated Bdc

Cbe Quivers Adapt Quiver 5 Arrow Black

Cbe Bridge- Lock Conversion

Cbe Picatinny Sight Adapter

Cbe Tactic 5 Quiver

Cbe Torx Hunting Stabilizer 11 "

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Archery

Archery

Availability

Brand

PRICE

Tru Ball Rave 3 Finger Caliper Head In Black | Trv3- Bk

Tru Glo Replacement Fiber

Tru Glo Nitrus Release

Tru Glo Veros 5 Pin Bow Sight

Truglo Tg8514blc Opti- Speed Crossbow Scope 1- 4x 24mm Obj Wide Fov 30mm Tube Black Finish Illuminated Bdc

Cbe Quivers Adapt Quiver 5 Arrow Black

Cbe Bridge- Lock Conversion

Cbe Picatinny Sight Adapter

Cbe Tactic 5 Quiver

Cbe Torx Hunting Stabilizer 11 "