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	INSIGNIA	Insignia	UNCATEGORIZED	Uncategorized	BLACK\|NULL\|NULL	0	9.99	0	9.99	[empty string]	9.99	[empty string]	INSIGNIACRISSCROSSSANDALS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5208	.INSIGNIACRISSCROSSSANDALS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Insigniacrisscrosssandals	[empty string]	[empty string]	N	9.99	9.99	5.5	[empty string]	[empty string]	1000	1000	CAL-21	74455	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	insignia/insigniacrisscrosssandals-74455	CAL-21	0
2	OPTIFADE_SUBALPINE	SITKA	Sitka	UNCATEGORIZED	Uncategorized	OPTIFADE_SUBALPINE\|NULL\|NULL	1	79	0	79	19525-DEFAULT-l.jpg	79	19525-DEFAULT-m.jpg	SITKA MNS CORE LT WT BOTTOM	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKAGRINDSTONEWORKVEST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	6	50-to-100	0.00	[empty string]	Sitka Men's Core Light Weight Bottom	<p>With a gusseted no-bunch crotch and low-profile elastic waistband, the CORE Lightweight Bottom provides just enough warmth for when temps dip and dial up animal activity. Featuring permanent Polygiene Odor Control technology to neutralize odor by stopping the growth of odor-causing bacteria and fungi. The CORE Lightweight Series is the next-to-skin layering foundation for SITKA Systems, actively moving moisture away from the skin while keeping the hunter dry and comfortable.</p>	[empty string]	N	79	79	M,L,XL,2X	19525-DEFAULT-s.jpg	[empty string]	1000	1000	10063	77707	EMPTY	MEN	EMPTY	0	0	0	HUNTING	sitka/sitka-men-s-core-light-weight-bottom-77707	10063	0
3	ELEVATED_II,OPTIFADE_SUBALPINE,PYRITE	SITKA	Sitka	UNCATEGORIZED	Uncategorized	ELEVATED_II\|NULL\|NULL,OPTIFADE_SUBALPINE\|NULL\|NULL,PYRITE\|NULL\|NULL	1	79.99	1	79	4828-DEFAULT-l.jpg	79.99	4828-DEFAULT-m.jpg	SITKA MNS CORE LS LIGHTWEIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKACORELSLIGHTWEIGHTCREW	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	53	50-to-100	0.00	[empty string]	Sitka Core Long Sleeve Lightweight Crew -10064	<p class="left">Built from the same moisture-wicking fabric as the Core Lightweight Hoody, our Core Lightweight Crew LS makes for a solid base layer. Whether used as a standalone piece during hot weather or layered into your system, the Core Lightweight Crew will perform across all seasons regardless of the pursuit.</p><p><strong>SPECFICATIONS:</strong></p><ul><li>GORE OPTIFADE Concealment Elevated II is designed for whitetail hunters in an elevated position.</li><li>Weight: 5.1 oz. // Size L</li><li>Fabric: Quick-Dry, Lightweight Comfort Stretch Knit (100% Polyester).</li><li>Polygiene Odor Control Technology safely neutralizes odor caused from sweat.</li><li>Imported</li></ul>	[empty string]	Y	79	79	M,L,XL,2X,3X	4828-DEFAULT-s.jpg	[empty string]	1000	1000	10064	77708	SHIRTS	MEN	EMPTY	0	0	0	HUNTING	sitka/sitka-core-long-sleeve-lightweight-crew-10064-77708	10064	0
4	ELEVATED_II,OPTIFADE_SUBALPINE	SITKA	Sitka	CLOTHING	Clothing>Hunting>Shirts>Men	ELEVATED_II\|NULL\|NULL,OPTIFADE_SUBALPINE\|NULL\|NULL	1	69.99	0	69.99	9729-DEFAULT-l.jpg	69.99	9729-DEFAULT-m.jpg	SITKA MNS CORE LIGHTWEIGHT CRE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKACORELIGHTWEIGHTCREW	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	11	50-to-100	0.00	[empty string]	Sitka Core Lightweight Crew - 10065	<p>With short sleeves and a low-profile crewneck, the CORE Lightweight Crew SS is the next-to-skin layering foundation for all seasons. Featuring permanent Polygiene Odor Control Technology to neutralize odor by stopping the growth of bacteria and fungi. The CORE Lightweight Series works hard to keep odor at bay while actively moving moisture away from the skin.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>GORE OPTIFADE Concealment Open Country is scientifically optimized for engagement ranges of 50 yards and beyond at ground level in rocky terrain above the timber line.</li><li>Weight: 4.1 oz. // Size: L</li><li>Fabric: Quick-Dry, Lightweight Comfort Stretch Knit (100% Polyester).</li><li>Drop-Tail Design: Quick-dry, comfort stretch lightweight knit.</li><li>Low-Profile Flatlock Seam Construction: Keep odor at bay while moving moisture away.</li><li>Polygiene Odor Control Technology safely neutralizes odor caused from sweat.</li><li>Imported</li></ul>	[empty string]	N	69.99	69.99	L,M,XL	9729-DEFAULT-s.jpg	[empty string]	1000	1000	10065	77709	SHIRTS	MEN	EMPTY	0	0	0	HUNTING	sitka/sitka-core-lightweight-crew-10065-77709	10065	0
5	ELEVATED_II,SITKA_BLACK,WATERFOWL_TIMBER,COVERT,OPTIFADE_SUBALPINE	SITKA	Sitka	CLOTHING	Clothing>Hunting>Outerwear>Men	ELEVATED_II\|NULL\|NULL,SITKA_BLACK\|NULL\|NULL,WATERFOWL_TIMBER\|NULL\|NULL,COVERT\|NULL\|NULL,OPTIFADE_SUBALPINE\|NULL\|NULL	1	129.99	0	129.99	7192-DEFAULT-l.jpg	129.99	7192-DEFAULT-m.jpg	SITKA MNS CORE LIGHTWEIGHT HOO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKACORELIGHTWEIGHTHOODY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	72	100-to-150	0.00	[empty string]	Sitka Men's Core Lightweight Hoody - 10066	<p>The Core Lightweight Hoody was designed to be more than a base layer. This meticulous design features the same superior moisture-wicking fabric as our CORE Lightweight Crew. A deep center chest zipper allows for dumping heat, and a form-fitting, ultra-light hood with a built-in face mask provides instant concealment in the moment of truth</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Weight: 6.6 oz. // Size: L</li><li>Body and Hood Fabric: Quick-Dry, Lightweight Comfort Stretch Knit (100% Polyester)</li><li>Facemask Fabric: Quick-Dry, Lightweight Stretch Mesh (88% Polyester/12% Elastane)</li><li>Polygiene Odor Control Technology safely neutralizes odor caused from sweat.</li><li>Stretch Thumb Loops: Shed layers with ease without compromising your foundational layer.</li><li>Built-In Ultra Breathable Mesh Face Mask: Conceal your face on the move and increase your success rate.</li><li>Imported</li></ul>	[empty string]	N	129.99	129.99	XL,2X,L,M,3X	7192-DEFAULT-s.jpg	[empty string]	1000	1000	10066	77710	OUTERWEAR	MEN	EMPTY	0	0	0	HUNTING	sitka/sitka-men-s-core-lightweight-hoody-10066-77710	10066	0
6	ELEVATED_II	SITKA	Sitka	CLOTHING	Clothing>Hunting>Base Layer>Men	ELEVATED_II\|NULL\|NULL	1	99.99	0	99.99	4835-DEFAULT-l.jpg	99.99	4835-DEFAULT-m.jpg	SITKA MNS CORE MID WT BOTTOM O	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKACOREMIDWTBOTTOMOPTIF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	7	50-to-100	0.00	[empty string]	Sitka Core Mid Weight Bottom Optifade - 10067	<p>The CORE Midweight Bottom offers the perfect weight and quick-drying fleece insulation for optimal warmth without overheating the hunter. This bottom is the base of a foundation as the conditions cool from mid-season to beyond.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>GORE OPTIFADE Concealment Elevated II is designed for whitetail hunters in an elevated position.</li><li>Fabric: Quick-Dry, Midweight Comfort Stretch Fleece (96% Polyester/4% Elastane).</li><li>Weight: 6.9 oz. // Size: L</li><li>Quick-dry, Comfort Stretch Lightweight Knit: Stay warm when the temperatures dip.</li><li>Polygiene Odor Control Technology safely neutralizes odor caused from sweat.</li></ul>	[empty string]	N	99.99	99.99	M,L,2X,XL	4835-DEFAULT-s.jpg	[empty string]	1000	1000	10067	77711	EMPTY	MEN	EMPTY	0	0	0	HUNTING	sitka/sitka-core-mid-weight-bottom-optifade-10067-77711	10067	0
7	PYRITE,OPTIFADE_SUBALPINE,WATERFOWL_TIMBER,ELEVATED_II,COYOTE,WATERFOWL_MARSH,WOODSMOKE	SITKA	Sitka	UNCATEGORIZED	Uncategorized	PYRITE\|NULL\|NULL,OPTIFADE_SUBALPINE\|NULL\|NULL,WATERFOWL_TIMBER\|NULL\|NULL,ELEVATED_II\|NULL\|NULL,COYOTE\|NULL\|NULL,WATERFOWL_MARSH\|NULL\|NULL,WOODSMOKE\|NULL\|NULL	1	99.99	0	99.99	3474-DEFAULT-l.jpg	99.99	3474-DEFAULT-m.jpg	SITKA MNS CORE MID WT ZIP T PU	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKACOREMIDWTZIPTPULLOV	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	96	50-to-100	0.00	[empty string]	Sitka Men's Core Midweight Zip-T Pullovers - 10068	<p>The CORE Midweight Zip-T features quick-drying comfort stretch mid-weight fleece and a high-zippered neck to keep your active body temperature regulated as the thermometer rises or plummets. Permanent Polygiene Odor Control Technology and a low-profile flatlock seam construction make this a versatile next-to-skin layer for a wide range of conditions and activity levels.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>GORE OPTIFADE Concealment Waterfowl Marsh is designed for layout and blind hunting in the marsh, standing crops, and cut stubble fields.</li><li>Weight: 10 oz. // Size: L</li><li>Fabric: Quick-Dry, Midweight Comfort Stretch Fleece (96% Polyester/4% Elastane).</li><li>Polygiene Odor Control Technology safely neutralizes odor caused from sweat.</li><li>Imported</li></ul>	[empty string]	N	99.99	99.99	XL,2X,L,M,3X	3474-DEFAULT-s.jpg	[empty string]	1000	1000	10068	77712	OUTERWEAR	MEN	EMPTY	0	0	0	HUNTING	sitka/sitka-men-s-core-midweight-zip-t-pullovers-10068-77712	10068	0
8	ELEVATED_II	SITKA	Sitka	CLOTHING	Clothing>Hunting>Outerwear>Men	ELEVATED_II\|NULL\|NULL	1	169.99	0	169.99	8469-DEFAULT-l.jpg	169.99	8469-DEFAULT-m.jpg	SITKA MNS MERINO HW 1/2 ZIP PO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKAMERINOHW1-2ZIPPO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	6	150-to-200	0.00	[empty string]	Sitka Merino Heavyweight 1/2 Zip Pullover - 10074	<p>The Merino Heavyweight Half-Zip is a great solution for a foundational baselayer when the mercury drops. Built with a premium 17.5-micron Merino wool face printed with GORE OPTIFADE concealment and backed with a soft polyester interior, this half-zip delivers concealment, odor control, and core warmth for mid to late seasons pursuits up and down the flyways.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>GORE OPTIFADE Concealment Waterfowl Timber is optimized for engagement distances of 10 to 40 yards in the darker environments of flooded timber.</li><li>Materials: 290-Gram 59% 17.5 Micron Merino / 6% Nylon Core-Spun Face Blend / 35% Polyester Interior for natural odor resistance and durability.</li><li>Imported</li></ul>	[empty string]	N	169.99	169.99	XL,M	8469-DEFAULT-s.jpg	[empty string]	1000	1000	10074	77714	OUTERWEAR	MEN	EMPTY	0	0	0	HUNTING	sitka/sitka-merino-heavyweight-1-2-zip-pullover-10074-77714	10074	0
9	ELEVATED_II,WATERFOWL MARSH	SITKA	Sitka	CLOTHING	Clothing>Hunting>Shirts>Women	ELEVATED_II\|NULL\|NULL,WATERFOWL MARSH\|NULL\|NULL	1	79.99	0	79.99	8526-DEFAULT-l.jpg	79.99	8526-DEFAULT-m.jpg	SITKA WMS CORE LIGHTWEIGHT LS CREW	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKAWMSCORELIGHTWEIGHTLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25	50-to-100	0.00	[empty string]	Sitka Women's Core Lightweight Crew LS - 10076	<p>The newly upgraded long sleeve and low-profile crewneck CORE Lightweight Crew Long Sleeve provides exceptional moisture management. This minimal top keeps you concealed when worn as an outerlayer in warm temps and provides critical comfort and moisture-wicking throughout the rest of the season. The stretch thumb loops keep sleeves in place when layering under jackets. The CORE Lightweight Series is the next-to-skin foundation for high-exertion hunts and a perfect layer to regulate body temperature.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>GORE OPTIFADE Concealment Elevated II is designed for whitetail hunters in an elevated position.</li><li>Weight: 3.8 oz. // Size: M</li><li>Fabric: Quick-Dry, Lightweight Comfort Stretch Knit (100% Polyester).</li><li>Stretch Thumb Loops: Shed layers with ease without compromising the rest of your system.</li><li>Polygiene Odor Control Technology safely neutralizes odor caused from sweat.</li><li>Imported</li></ul>	[empty string]	N	79.99	79.99	M,L,XL,S	8526-DEFAULT-s.jpg	[empty string]	1000	1000	10076	77715	SHIRTS	WOMEN	EMPTY	0	0	0	HUNTING	sitka/sitka-women-s-core-lightweight-crew-ls-10076-77715	10076	0
10	SITKA_BLACK	SITKA	Sitka	UNCATEGORIZED	Uncategorized	SITKA_BLACK\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SITKA MNS ICON SS LOGO T SHIRT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3083	.SITKAICONSSLOGOTSHIRT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Sitka Mns Icon Ss Logo T Shirt	[empty string]	[empty string]	N	29.99	29.99	2X	[empty string]	[empty string]	1000	1000	20177	77717	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sitka/sitka-mns-icon-ss-logo-t-shirt-77717	20177	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc