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	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	223	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Outerwear>Bottoms	223\|NULL\|NULL	1	359.99	1	349.99	99319-DEFAULT-l.jpg	359.99	99319-DEFAULT-m.jpg	BE:1 FORTRESS BIB RT ESCAPE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	14	300-to-350	0.00	[empty string]	Gamechanger Heavyweight Jacket	FEATURES:<br/> -ScentLok Carbon Alloy technology<br/> -Moisture wicking treated<br/> -Removable hood with magnet closures<br/> -Single hand cinch hood adjusters<br/> -Two chest pockets for gear storage<br/> -Two large waist pockets<br/> -One hand hood cinch adjuster<br/> -Hidden zipper when hood is removed<br/> -Safety harness access opening<br/> -Sleeve zippers with gussets<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	349.99	359.99	L,M,XL,3X	99319-DEFAULT-s.jpg	[empty string]	1000	1030724	324867	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	scentlok/be-1-fortress-bib-rt-escape-324867	1
2	EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Outerwear>Bottoms	EDGE\|NULL\|NULL	1	169.99	0	169.99	86155-DEFAULT-l.jpg	169.99	86155-DEFAULT-m.jpg	FOREFRONT PANT	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	Forefront Pant	<p>The Forefront system strikes the perfect balance between being feature-rich and action-ready. It comes equipped with our exclusive Precip-X technology, which dramatically repels water and other liquids to help you stay in the field longer. Last but not least, we’ve added our unmatched Carbon Alloy technology for maximum odor adsorption to help you in your quest for success.</p> <p> </p> <ul> <li>Carbon Alloy<sup> </sup>technology for maximum odor adsorption & scent control</li> <li>Precip-X<sup> </sup>technology repels water, mud, blood & other liquids</li> <li>Micro tricot outer fabric for deadly quiet mobility</li> <li>Micro-fleece inner liner keeps you warm </li> <li>Side waistband elastic provides a custom & secure fit</li> <li>Rear waistband grips help keep clothing in place</li> <li>Eight pocket design, including 2 side seam pockets provide additional gear storage  </li> <li>Articulated knees improve mobility in the field  </li> <li>18” leg zippers for easy dressing over boots</li> </ul>	[empty string]	N	169.99	169.99	XL,L,M,S	86155-DEFAULT-s.jpg	[empty string]	1000	1021020	335163	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	scentlok/forefront-pant-335163	1
3	BLACK	MOBILE WARMING	Mobile Warming	CLOTHING	Clothing>Mens>Outerwear>Bottoms	BLACK\|NULL\|NULL	1	159.99	0	159.99	99830-DEFAULT-l.jpg	159.99	99830-DEFAULT-m.jpg	M PRIMER PANT	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	9	150-to-200	0.00	[empty string]	PRIMER PANT - MEN'S	<p>The Bluetooth-enabled Primer men's heated baselayer pant is designed for the outdoor enthusiast. From skiing, hunting, hiking to running or just working outdoors, the Primer pant complements your outerwear. The Primer Pant is made from a four-way stretch anti-odor polyester-spandex blend that provides a comfortable next-to-skin feel. Flat-lock seams, moisture-wicking mesh liner, and side-stretch panels conform to your body and allow for maximum body movement.</p> <p> </p> <ul> <li>Stretch Polyester Fabric</li> <li>Chafe-free Flat-Lock Seams</li> <li>Antibacterial & Anti-Static</li> <li>4 Selectable Heat Settings</li> <li>Bluetooth 4.0 Wireless Control</li> <li>Integrated Touch Control Button</li> <li>Tri-Zone Heat Elements</li> <li>Powerful Rechargeable Lithium-Ion Battery</li> </ul> <p> </p> <ul> <li>88% Polyester, 12% Spandex</li> <li>Up to 10 Hours of Heat Per Charge</li> <li>Battery Rating: 7.4v, 2200mAh</li> <li>Charge Time: 3.5hrs <p> </p> </li> <li>Includes:</li> <li>Primer Heated Pant</li> <li>1  7.4volt Lithium-Ion Battery</li> <li>1  AC Battery Charger</li> </ul>	[empty string]	N	159.99	159.99	M,L,XL,2X	99830-DEFAULT-s.jpg	[empty string]	1000	MWMP0901	339146	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	mobile-warming/primer-pant-men-s-339146	1
4	BLACK	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Outerwear>Bottoms	BLACK\|NULL\|NULL	0	119.99	0	119.99	[empty string]	119.99	[empty string]	QUILT LINED WASHED DUCK BIB	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Quilt Lined Washed Duck Bib	[empty string]	[empty string]	N	119.99	119.99	2X	[empty string]	[empty string]	1000	104031	340158	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/quilt-lined-washed-duck-bib-340158	1
5	BLACK	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Outerwear>Bottoms	BLACK\|NULL\|NULL	1	199.99	0	199.99	96397-DEFAULT-l.jpg	199.99	96397-DEFAULT-m.jpg	YUKON INSULATED BIB	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	16	150-to-200	0.00	[empty string]	YUKON INSULATED BIB	<p>Engineered for extremely cold conditions.</p> <p> </p> <ul> <li>6.5-ounce, 500-denier Cordura nylon shell</li> <li>150g 3M Thinsulate insulation for warmth without the weight</li> <li>3M Scotchlite Carbon Black reflective taping on center back and double front</li> <li>Wind Fighter technology tames the wind</li> <li>Rain Defender durable water repellent (DWR) keeps you dry and moving in light rain</li> <li>Adjustable elastic suspenders for a personalized fit; Low profile buckle closure; Two-way zip front</li> <li>Double-layer knees with openings for adding knee pads and cleaning out debris; Ankle-to-thigh leg zippers with storm flaps and snap closures</li> <li>Bar tacks at vital stress points</li> <li>3M reflective Carhartt patch on secure chest pocket</li> <li>Ledge hand pockets; Front cargo pockets with hook-and-loop closure</li> <li>Back pockets with hook-and-loop closure; Multiple utility pockets; Right-leg hammer loop</li> </ul>	[empty string]	N	199.99	199.99	XL,L,2X	96397-DEFAULT-s.jpg	[empty string]	1000	104461	340160	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/yukon-insulated-bib-340160	1
6	BLACK	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Outerwear>Bottoms	BLACK\|NULL\|NULL	1	219.99	0	219.99	96400-DEFAULT-l.jpg	219.99	96400-DEFAULT-m.jpg	YUKON INSULATED BIB	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	8	200-to-250	0.00	[empty string]	YUKON INSULATED BIB - BIG AND TALL SIZES	<p>Engineered for extremely cold conditions. </p> <ul> <li>6.5-ounce, 500-denier Cordura nylon shell</li> <li>150g 3M Thinsulate insulation for warmth without the weight</li> <li>3M Scotchlite Carbon Black reflective taping on center back and double front</li> <li>Wind Fighter technology tames the wind</li> <li>Rain Defender durable water repellent (DWR) keeps you dry and moving in light rain</li> <li>Adjustable elastic suspenders for a personalized fit; Low profile buckle closure; Two-way zip front</li> <li>Double-layer knees with openings for adding knee pads and cleaning out debris; Ankle-to-thigh leg zippers with storm flaps and snap closures</li> <li>Bar tacks at vital stress points</li> <li>3M reflective Carhartt patch on secure chest pocket</li> <li>Ledge hand pockets; Front cargo pockets with hook-and-loop closure</li> <li>Back pockets with hook-and-loop closure; Multiple utility pockets; Right-leg hammer loop</li> </ul>	[empty string]	N	219.99	219.99	XLT,2XT,3X	96400-DEFAULT-s.jpg	[empty string]	1000	104461 BTS	340163	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/yukon-insulated-bib-big-and-tall-sizes-340163	1
7	SUB,PY,BLK	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Outerwear>Bottoms	SUB\|NULL\|NULL,PY\|NULL\|NULL,BLK\|NULL\|NULL	1	329	0	329	97120-DEFAULT-l.jpg	329	97120-DEFAULT-m.jpg	DEW POINT JACKET	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	42	300-to-350	0.00	[empty string]	DEW POINT JACKET	<p>Sitka's 3-layer GORE-TEX Dew Point Jacket offers lightweight waterproof protection for volatile weather. Minimalist construction features include 20-denier nylon ripstop face with soft GORE C-KNIT backer technology for breathable comfort and packability, pit zips for expelling heat, micro-taped seams to reduce weight and zippered pockets that are accessible while wearing a pack belt and Mountain Optics Harness.</p> <p> </p> <p> </p> <ul> <li> <p><strong>GORE-TEX</strong> waterproof/breathable fabric helps you stay comfortable and focused.</p> </li> <li> <p><strong>Fabric:</strong> GORE-TEX 3-layer, 20-denier fabric with ripstop nylon face</p> </li> <li> <p><strong>Soft, Packable GORE C-KNIT</strong> backer technology for comfort and packability.</p> </li> <li> <p><strong>Cut</strong> to accommodate added layers for changing conditions.</p> </li> <li> <p><strong>Integrated Drop-Away</strong> adjustable hood deploys when you need it.</p> </li> <li> <p><strong>YKK Pit Zips</strong> expel heat on uphill slogs.</p> </li> <li> <p><strong>Streamlined</strong> design for long-lasting performance.</p> </li> <li> <p><strong>Zippered Pockets</strong> allow access while wearing a pack belt.</p> </li> <li> <p><strong>Micro-Taped Seams</strong> for weather protection with minimal bulk.</p> </li> <li> <p><strong>Adjustable</strong> hem and cuffs.</p> </li> <li> <p><strong>Weight:</strong> 12.5 oz.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	329	329	L,XL,2X,M,3X	97120-DEFAULT-s.jpg	[empty string]	1000	50254	344001	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/dew-point-jacket-344001	1
8	PY,SUB,BLK	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Outerwear>Bottoms	PY\|NULL\|NULL,SUB\|NULL\|NULL,BLK\|NULL\|NULL	1	309	0	309	97121-DEFAULT-l.jpg	309	97121-DEFAULT-m.jpg	DEW POINT PANT	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	40	300-to-350	0.00	[empty string]	Dew Point Pant	<p>Sitka's 3-layer GORE-TEX Dew Point Pant offers waterproof protection when you’re three days in and the clouds turn black. Minimally featured—including micro-taped seams and zero pockets—it’s made from a 20-denier nylon ripstop face with GORE C-KNIT backer technology for easy movement and packability in the mountains. Two-way side zips offer easy on/off and venting; the articulated fit won’t tug when you’re navigating rough country or hiking in the rain.</p> <p> </p> <p> </p> <ul> <li> <p><strong>GORE-TEX</strong> waterproof/breathable fabric helps you stay comfortable and focused.</p> </li> <li> <p><strong>Fabric:</strong> GORE-TEX 3-layer, 20-denier fabric with ripstop nylon face</p> </li> <li> <p><strong>Soft,</strong> packable GORE C-KNIT backer technology provides comfort and packability</p> </li> <li> <p><strong>YKK 7/8-Length Side Zips </strong>vent for expelling heat and easy on/off with boots on.</p> </li> <li> <p><strong>Streamlined</strong> designs for long-last performance.</p> </li> <li> <p><strong>Micro-Taped Seams</strong> for weather protection with minimal bulk.</p> </li> <li> <p><strong>Adjustable</strong> nylon web belt.</p> </li> <li> <p><strong>Weight:</strong> 10.5 oz.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	309	309	L,XL,2X,M	97121-DEFAULT-s.jpg	[empty string]	1000	50255	344002	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/dew-point-pant-344002	1
9	RE	GAMEHIDE	Gamehide	CLOTHING	Clothing>Mens>Outerwear>Bottoms	RE\|NULL\|NULL	1	69.99	0	69.99	99355-DEFAULT-l.jpg	69.99	99355-DEFAULT-m.jpg	PINCH POINT PANT	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Pinch Point Pant	[empty string]	[empty string]	N	69.99	69.99	M,4X,L,XL,2X	99355-DEFAULT-s.jpg	[empty string]	1000	GHP	376089	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	gamehide/pinch-point-pant-376089	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts616 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Filter