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]	15	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	20	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,S,M	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	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	11	100-to-150	0.00	[empty string]	Quilt Lined Washed Duck Bib	[empty string]	[empty string]	N	119.99	119.99	2X,XL,M,L	[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
4	BLACK	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Outerwear>Bottoms	BLACK\|NULL\|NULL	1	119.99	0	119.99	96373-DEFAULT-l.jpg	119.99	96373-DEFAULT-m.jpg	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	QUILT LINED WASHED DUCK BIB - BIG AND TALL SIZES	<p>Made to hold their own through cold, wind and light rain, these bibs are hard-working. They're made with Carhartt's heavyweight cotton duck and lined with lightweight 3M Thinsulate insulation for exceptional warmth. Reinforced kick panels lend long-lasting durability, and they are engineered for high warmth in severely cold conditions. </p> <p> </p> <ul> <li>Heavyweight, 12-Ounce 100% ring-spun washed cotton duck</li> <li>80g 3M Thinsulate featherless insulation through the legs for warmth without the weight</li> <li>Carhartt-strong, triple-stitched main seams</li> <li>Adjustable elastic suspenders with webbing slider for comfort and personalized fit</li> <li>Side button closure with stretch panel for more precise fit</li> <li>Zipper fly</li> <li>Multi-compartment bib pocket with zip closure for electronics</li> <li>Two front ledge pockets; Reinforced back pockets</li> <li>Updated longer double front to cover entire knee; Openings for adding knee pads and cleaning out debris</li> <li>Ankle-to-knee leg zips for easy on and off</li> <li>Reinforced Cordura kick panels around cuffs add durability</li> </ul>	[empty string]	N	119.99	119.99	MT,2XT,XLT	96373-DEFAULT-s.jpg	[empty string]	1000	104031 BT	340159	OUTERWEAR	BOTTOMS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/quilt-lined-washed-duck-bib-big-and-tall-sizes-340159	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	17	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,2X,L	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	14	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	2XT,LT,XLT,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,BLK,PY	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Outerwear>Bottoms	SUB\|NULL\|NULL,BLK\|NULL\|NULL,PY\|NULL\|NULL	1	339	0	339	97120-DEFAULT-l.jpg	339	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	26	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	339	339	L,2X,3X,M,XL	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	BLK,PY,SUB	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Outerwear>Bottoms	BLK\|NULL\|NULL,PY\|NULL\|NULL,SUB\|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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	32	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	XL,L,M,2X	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]	9	50-to-100	0.00	[empty string]	Pinch Point Pant	[empty string]	[empty string]	N	69.99	69.99	M,L,4X,XL	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