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	BLACK	BOSS MANUFACTURING	Boss Manufacturing	CLOTHING	Clothing>Casual>Headwear & Gloves	BLACK\|NULL\|NULL	1	12.99	0	12.99	5758-DEFAULT-l.jpg	12.99	5758-DEFAULT-m.jpg	BOSS GUARD FLEECE INSULATED GL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1168	4143..BOSSGUARDFLEECEINSULATEDGL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Boss Guard Fleece Insulated Gloves	<ul><li>Double Stitching For Durability</li><li>Fleece Insulation For Cold Weather</li><li>Grain Leather Goatskin Palm And Finger Tips</li><li>Shirred Elastic Wrist</li><li>Spandex Back For A Comfortable Fit</li></ul>	[empty string]	N	12.99	12.99	L	5758-DEFAULT-s.jpg	[empty string]	1000	1000	4143	71496	HEADWEAR & GLOVES	EMPTY	EMPTY	0	0	0	EMPTY	boss-manufacturing/boss-guard-fleece-insulated-gloves-71496	4143	0
2	[empty string]	SECURITY EQUIPMENT C	Security Equipment C	UNCATEGORIZED	Uncategorized	[empty string]	1	9.99	0	9.99	32099-DEFAULT-l.jpg	9.99	32099-DEFAULT-m.jpg	SABRE DEFENSE KR14CAMO02	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	275	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Sabre KR14CAMO02 Pepper Spray OC Pepper UV Dye Effective Distance 10 ft 0.54 oz Realtree Edge Includes Key Ring	<p>Maximum strength formula Pepper Spray provides protection at a safe distance against multiple threats, UV marking dye aids in suspect identification. Featuring a 10-foot range; 25 bursts in a powerful stream delivery to reduce wind blowback; key ring makes pepper spray easy to take on the go while the locking top safety helps prevent accidental discharge; Realtree Edge camo design is greatly appealing for any outdoor enthusiast. Packaging includes link to free training video in addition to publicly available safety tips.</p>	[empty string]	N	9.99	9.99	[empty string]	32099-DEFAULT-s.jpg	[empty string]	1000	1000	KR14CAMO02	155897	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	security-equipment-c/sabre-kr14camo02-pepper-spray-oc-pepper-uv-dye-effective-distance-10-ft-0-54-oz-realtree-edge-includes-key-ring-155897	KR14CAMO02	0
3	[empty string]	SECURITY EQUIPMENT C	Security Equipment C	UNCATEGORIZED	Uncategorized	[empty string]	1	14.99	0	14.99	32100-DEFAULT-l.jpg	14.99	32100-DEFAULT-m.jpg	SABRE DEFENSE SEMT01	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	275	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	Sabre SEMT01 Safe Escape 3-in-1 Automotive Tool Mint Polymer Distance 10 ft Features Glass Breaker/Pepper Gel/Seat Belt Cutter	<p>Sabre's Safe Escape 3-in-1 Auto Tool cuts through malfunctioning seat belts in seconds without worry of injury. Its durable, stainless steel tip punctures window glass for a speedy escape. The gel has a range of 10 feet for protection at a safer distance. Deploys 25 bursts per canister providing protection against multiple targets. A snap clip allows for effortless attachment to keys or bag and quick detachment when you need it most.</p>	[empty string]	N	14.99	14.99	[empty string]	32100-DEFAULT-s.jpg	[empty string]	1000	1000	SEMT01	155924	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	security-equipment-c/sabre-semt01-safe-escape-3-in-1-automotive-tool-mint-polymer-distance-10-ft-features-glass-breaker-pepper-gel-seat-belt-cutter-155924	SEMT01	0
4	BLUE_RASPBERRY	GENESIS	Genesis	ARCHERY	Archery>Compound Bow	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
5	BLUE	GENESIS	Genesis	ARCHERY	Archery>Compound Bow	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
6	RED	GENESIS	Genesis	ARCHERY	Archery>Compound Bow	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
7	RED	GENESIS	Genesis	ARCHERY	Archery>Compound Bow	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
8	PURPLE	GENESIS	Genesis	ARCHERY	Archery>Compound Bow	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
9	ORANGE	GENESIS	Genesis	ARCHERY	Archery>Compound Bow	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
10	BLACK	GENESIS	Genesis	ARCHERY	Archery>Compound Bow	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc