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	BLUE_RASPBERRY	GENESIS	Genesis	ARCHERY	Archery	BLUE_RASPBERRY\|NULL\|NULL	1	159.99	0	159.99	29119-DEFAULT-l.jpg	159.99	29119-DEFAULT-m.jpg	MATHEWS GENESIS BOW	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Mathews Genesis Bow - Youth Left Hand	<p>The Genesis System eliminates let-off on light draw weight bows (where its unnecessary) so there are no specific draw length requirements. The result is a bow that fits virtually everyone (15 to 30) and that a young person cant outgrow. A Genesis bow, set at 20lbs. (it's adjustable from 10 to 20 lbs), stores and releases energy comparable to that of a 35lb. recurve! Plus, with zero let-off, it has the 'holding weight' necessary to 'pull the string from your finger,' making it easy to shoot.</p><ul><li>Color: Blue</li><li>Weight (pounds): 2.95</li><li>Dexterity: Left Hand</li><li>IBO Speed (FPS): 137-170</li><li>Brace Height (inches): 7.625</li><li>Axle to Axle or Overall Length (inches): 35.5</li><li>Peak Draw Weight (lbs): 20</li><li>Draw Length Range (inches): Up to 30</li><li>Preset Draw Length (inches): No Specific</li><li>Let Off (percent): 0</li></ul>	[empty string]	N	159.99	159.99	LH	29119-DEFAULT-s.jpg	[empty string]	1000	1000	10471	182383	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-youth-left-hand-182383	10471	0
2	BLUE	GENESIS	Genesis	ARCHERY	Archery	BLUE\|NULL\|NULL	1	219.99	0	219.99	9473-DEFAULT-l.jpg	219.99	9473-DEFAULT-m.jpg	MATHEWS GENESIS KIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Mathews Genesis Bow Kit	<p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and "zero let-off" design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows.</p><p><em>Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p>	[empty string]	N	219.99	219.99	LH	9473-DEFAULT-s.jpg	[empty string]	1000	1000	10925	182386	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-kit-182386	10925	0
3	RED	GENESIS	Genesis	ARCHERY	Archery	RED\|NULL\|NULL	1	219.99	0	219.99	9472-DEFAULT-l.jpg	219.99	9472-DEFAULT-m.jpg	MATHEWS GENESIS KIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Mathews Genesis Bow Kit	<p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and "zero let-off" design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows.</p><p><em>Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p>	[empty string]	N	219.99	219.99	LH	9472-DEFAULT-s.jpg	[empty string]	1000	1000	10929	182388	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-kit-182388	10929	0
4	RED	GENESIS	Genesis	ARCHERY	Archery	RED\|NULL\|NULL	1	219.99	0	219.99	8907-DEFAULT-l.jpg	219.99	8907-DEFAULT-m.jpg	MATHEWS GENESIS KIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	Mathews Genesis Bow Kit	<p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and "zero let-off" design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows.</p><p><em>Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p>	[empty string]	N	219.99	219.99	RH	8907-DEFAULT-s.jpg	[empty string]	1000	1000	10930	182389	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-kit-182389	10930	0
5	PURPLE	GENESIS	Genesis	ARCHERY	Archery	PURPLE\|NULL\|NULL	1	219.99	0	219.99	20455-DEFAULT-l.jpg	219.99	20455-DEFAULT-m.jpg	MATHEWS GENESIS KIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Mathews Genesis Bow Kit	<p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and "zero let-off" design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows.</p><p><em>Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p>	[empty string]	N	219.99	219.99	RH	20455-DEFAULT-s.jpg	[empty string]	1000	1000	10932	182390	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-kit-182390	10932	0
6	ORANGE	GENESIS	Genesis	ARCHERY	Archery	ORANGE\|NULL\|NULL	1	219.99	0	219.99	8910-DEFAULT-l.jpg	219.99	8910-DEFAULT-m.jpg	MATHEWS GENESIS KIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Mathews Genesis Bow Kit	<p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and "zero let-off" design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows.</p><p><em>Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p>	[empty string]	N	219.99	219.99	RH	8910-DEFAULT-s.jpg	[empty string]	1000	1000	11419	182392	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-kit-182392	11419	0
7	BLACK	GENESIS	Genesis	ARCHERY	Archery	BLACK\|NULL\|NULL	1	219.99	0	219.99	8909-DEFAULT-l.jpg	219.99	8909-DEFAULT-m.jpg	MATHEWS GENESIS KIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	Mathews Genesis Bow Kit	<p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and "zero let-off" design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows.</p><p><em>Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p>	[empty string]	N	219.99	219.99	RH	8909-DEFAULT-s.jpg	[empty string]	1000	1000	12240	182401	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-kit-182401	12240	0
8	AMBUSH	GENESIS	Genesis	ARCHERY	Archery	AMBUSH\|NULL\|NULL	1	219.99	0	219.99	20444-DEFAULT-l.jpg	219.99	20444-DEFAULT-m.jpg	MATHEWS GENESIS KIT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Mathews Genesis Bow Kit	<p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and "zero let-off" design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows.</p><p><em>Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p>	[empty string]	N	219.99	219.99	LH	20444-DEFAULT-s.jpg	[empty string]	1000	1000	12295	182403	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	genesis/mathews-genesis-bow-kit-182403	12295	0
9	[empty string]	REDLINE	Redline	ARCHERY	Archery	[empty string]	1	24.99	0	24.99	35929-DEFAULT-l.jpg	24.99	35929-DEFAULT-m.jpg	REDLINE RL HITCH QUICK DICSONNECT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	20-to-25	0.00	[empty string]	Redline Hitch Quick Dicsonnect	<p>Hitch Stabilizer Quick Disconnect</p><ul><li>Straight Quick disconnect</li><li>Fast removal of Stabilizer from bow</li><li>Clean flush fit to stabilizer</li><li>Includes matching barrel nut</li><li>Weight: 4.8 oz.</li></ul>	[empty string]	N	24.99	24.99	[empty string]	35929-DEFAULT-s.jpg	[empty string]	1000	1000	RL-HQD-24	254179	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	redline/redline-hitch-quick-dicsonnect-254179	RL-HQD-24	0
10	[empty string]	REDLINE	Redline	ARCHERY	Archery	[empty string]	1	99.99	0	99.99	38286-DEFAULT-l.jpg	99.99	38286-DEFAULT-m.jpg	REDLINE ANVIL QUIVER	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Redline Anvil 6 Arrow Quiver - Black	<ul><li>6-arrow capacity</li><li>Aluminum construction</li><li>Total weight: 12.8 oz</li><li>Total length: 18</li><li>Retractable tree hanger loop</li><li>Quick detach bracket</li><li>Two 6-arrow clasps (one adjustable/removable, holds small and standard arrow diameters)</li><li>Soft touch quiver hood with broadhead cut foam insert</li><li>Ambidextrous design</li></ul>	[empty string]	N	99.99	99.99	[empty string]	38286-DEFAULT-s.jpg	[empty string]	1000	1000	RL-ANVILQV-24	255029	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	redline/redline-anvil-6-arrow-quiver-black-255029	RL-ANVILQV-24	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 ? ) GROUP BY STYLE_ID

SQLPARAMETERS

array
1	Archery
2	%genesis%
3	%tipton%
4	%rambo%
5	%rhino1%
6	%redline%

Filter By

Sort By

Item # RL-ANVILQV-24 $99.99

0 Reviews

Sign in

Archery

Archery

Availability

Brand

PRICE

Mathews Genesis Bow - Youth Left Hand

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Redline Hitch Quick Dicsonnect

Redline Anvil 6 Arrow Quiver - Black

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Archery

Archery

Availability

Brand

PRICE

Mathews Genesis Bow - Youth Left Hand

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Mathews Genesis Bow Kit

Redline Hitch Quick Dicsonnect

Redline Anvil 6 Arrow Quiver - Black