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	MOSSYOAK_COUNTRY	FIELDLINE	Fieldline	UNCATEGORIZED	Uncategorized	MOSSYOAK_COUNTRY\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	FIELDLINE MATADOR BACKPACK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	100	.FIELDLINEMATADORBACKPACK	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Fieldline Matador Backpack	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	1000	FCB037	73573	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fieldline/fieldline-matador-backpack-73573	FCB037	0
2	REALTREE_EDGE	FIELDLINE	Fieldline	UNCATEGORIZED	Uncategorized	REALTREE_EDGE\|NULL\|NULL	0	54.99	0	54.99	[empty string]	54.99	[empty string]	FIELDLINE RIDGE TRACKER BACKPA	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	100	.FIELDLINERIDGETRACKERBACKPA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Fieldline Ridge Tracker Backpa	[empty string]	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	1000	FCB054	73574	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fieldline/fieldline-ridge-tracker-backpa-73574	FCB054	0
3	BLACK	FIELDLINE	Fieldline	HUNTING	Hunting>Bags>Tactical	BLACK\|NULL\|NULL	1	49.99	1	29.99	9556-DEFAULT-l.jpg	49.99	9556-DEFAULT-m.jpg	FIELDLINE ALPHA OPS DAY PACK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	100	.FIELDLINEALPHAOPSDAYPACK	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Fieldline Alpha Ops Day Pack	<p><strong>DESCRIPTION:</strong></p><p>The Fieldline Alpha OPS daypack was designed for concealment and the tactically minded. Given the unique requirements of modern operators, the Alpha Ops has a built-in gear organizer, digital media pouch, integrated headset port and a fleece-lined sunglass pouch.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>- Hydration compatible pouch</li><li>- Velcro name-tape and patch holders</li><li>- Front panel with multiple MOLLE attachment points</li><li>- Heavy duty padded handle</li><li>- Dimensions: 17.25 (H) x 12.5 (W) x 6.5(D)</li><li>- Storage Capacity (Volume): 1,400 cu. in.</li></ul>	[empty string]	Y	29.99	29.99	[empty string]	9556-DEFAULT-s.jpg	[empty string]	1000	1000	TPB002	73575	TACTICAL	EMPTY	EMPTY	0	0	0	EMPTY	fieldline/fieldline-alpha-ops-day-pack-73575	TPB002	0
4	EDGE	HOYT USA	Hoyt Usa	ARCHERY	Archery>Compound Bow	EDGE\|NULL\|NULL	1	699.99	0	699.99	6296-DEFAULT-l.jpg	699.99	6296-DEFAULT-m.jpg	HOYT TORREX XT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Hoyt Torrex Xt	[empty string]	[empty string]	N	699.99	699.99	60LBS	6296-DEFAULT-s.jpg	[empty string]	1000	1000	1049214	107898	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-torrex-xt-107898	1049214	0
5	WLDR	HOYT USA	Hoyt Usa	ARCHERY	Archery>Accessories>Quivers	WLDR\|NULL\|NULL	1	169.99	0	189.99	37334-DEFAULT-l.jpg	169.99	37334-DEFAULT-m.jpg	HOYT QUIVER 6 ARW SUPERLITE DG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Hoyt Superlite Quiver - 6 Arrow	<ul><li>In-Line Accessory brings your quiver closer to the bow riser for optimal balance and accuracy</li><li>Features adjustable mounting positions to allow the quiver to get as close to your bow as possible</li><li>When paired with Hoyt's Integrate Arrow Rest and Picatinny Sight Mount, your quiver can be insanely close to your bow riser for the most balanced rig you've ever had</li><li>Lightweight construction and carbon materials make this quiver tough and ready for all you can throw at it</li><li>Fits small and standard diameter arrow shafts like 4MM, 5MM, 6MM, or 6.5MM shafting</li><li>Move this quiver system vertically and horizontally</li><li>Double gripper for plenty of support on your arrows</li><li>Quick detach for those hunters who would remove their quiver in the tree</li></ul>	[empty string]	N	189.99	189.99	6	37334-DEFAULT-s.jpg	[empty string]	1000	1000	1057572	107900	QUIVERS	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-superlite-quiver-6-arrow-107900	1057572	0
6	BOURBON	HOYT USA	Hoyt Usa	ARCHERY	Archery>Compound Bow	BOURBON\|NULL\|NULL	1	1599.99	1	1349.99	18230-DEFAULT-l.jpg	1599.99	18230-DEFAULT-m.jpg	HOYT CARBON RX-7 29/70	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Hoyt Carbon Rx-7 29/70	<p>The absolute flagship of bows. Hollow carbon construction delivers the highest strength-to-weight ratio in our lineup and features the In-Line System.</p><ul><li>342 FPS (ATA)</li><li>30" Axle-to-Axle</li><li>6 " Brace height</li><li>3.9 Pounds</li><li>25-30" Draw length</li><li>30-80# Draw weight</li></ul><p> </p>	[empty string]	Y	1349.99	1349.99	29/70	18230-DEFAULT-s.jpg	[empty string]	1000	1000	1064228	107902	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-carbon-rx-7-29-70-107902	1064228	0
7	KUIU_VERDE	HOYT USA	Hoyt Usa	ARCHERY	Archery>Accessories>Quivers	KUIU_VERDE\|NULL\|NULL	1	169.99	0	169.99	39953-DEFAULT-l.jpg	169.99	39953-DEFAULT-m.jpg	HOYT QUIVER 6 ARW SUPERLITE DG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Hoyt Superlite Quiver - 6 Arrow	<ul><li>In-Line Accessory brings your quiver closer to the bow riser for optimal balance and accuracy</li><li>Features adjustable mounting positions to allow the quiver to get as close to your bow as possible</li><li>When paired with Hoyt's Integrate Arrow Rest and Picatinny Sight Mount, your quiver can be insanely close to your bow riser for the most balanced rig you've ever had</li><li>Lightweight construction and carbon materials make this quiver tough and ready for all you can throw at it</li><li>Fits small and standard diameter arrow shafts like 4MM, 5MM, 6MM, or 6.5MM shafting</li><li>Move this quiver system vertically and horizontally</li><li>Double gripper for plenty of support on your arrows</li><li>Quick detach for those hunters who would remove their quiver in the tree</li></ul>	[empty string]	N	169.99	169.99	6	39953-DEFAULT-s.jpg	[empty string]	1000	1000	1157005	107906	QUIVERS	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-superlite-quiver-6-arrow-107906	1157005	0
8	SUBALPINE	HOYT USA	Hoyt Usa	ARCHERY	Archery>Accessories>Stabilizers	SUBALPINE\|NULL\|NULL	1	89.99	0	89.99	34868-DEFAULT-l.jpg	89.99	34868-DEFAULT-m.jpg	HOYT PRO SERIES STABILIZER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Hoyt Carbon Pro Series 6" Stabilizer	<p>Hoyt Pro Series Stabilizers are designed to work in harmony with your Hoyt bow by adding stability and balance to your rig without adding unnecessary bulk and weight. On top of that, Pro Series Stabilizers are designed to crush vibration on the shot, making your bow even quieter and smoother.</p>	[empty string]	N	89.99	89.99	6	34868-DEFAULT-s.jpg	[empty string]	1000	1000	1157072	107907	STABILIZERS	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-carbon-pro-series-6-stabilizer-107907	1157072	0
9	EDGE	HOYT USA	Hoyt Usa	ARCHERY	Archery>Compound Bow	EDGE\|NULL\|NULL	1	1149.99	1	979.99	18234-DEFAULT-l.jpg	1149.99	18234-DEFAULT-m.jpg	HOYT VTM 31 RH 29/70	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Hoyt Vtm 31 Rh 29/70	[empty string]	[empty string]	Y	979.99	979.99	[empty string]	18234-DEFAULT-s.jpg	[empty string]	1000	1000	1165086	107911	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-vtm-31-rh-29-70-107911	1165086	0
10	WILDERNESS	HOYT USA	Hoyt Usa	ARCHERY	Archery>Compound Bow	WILDERNESS\|NULL\|NULL	1	1249.99	1	1149.99	21344-DEFAULT-l.jpg	1249.99	21344-DEFAULT-m.jpg	HOYT VTM 34 RH 30/70	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Hoyt Vtm 34 Rh 30/70	<p>Stable, able and ready to put meat on the table. VTM 34 gives you a longer, more forgiving riser without the bulk. Compatible with In-Line accessories.</p><ul><li>334 FPS (ATA)</li><li>33 " Axle-to-Axle</li><li>6 " Brace height</li><li>4.8 Pounds</li><li>26-31" Draw length</li><li>30-80# Draw weight</li></ul><p> </p>	[empty string]	Y	1149.99	1149.99	[empty string]	21344-DEFAULT-s.jpg	[empty string]	1000	1000	1165251	107912	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-vtm-34-rh-30-70-107912	1165251	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc