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	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	[empty string]	1	39.99	0	39.99	95622-DEFAULT-l.jpg	39.99	95622-DEFAULT-m.jpg	DUNGAREE WASHED DUCK	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]	29	25-to-50	0.00	[empty string]	MEN'S WASHED DUCK WORK DUNGAREE - BROWN	<p>When your daily routine takes you from the barn to the back 40, these men's washed duck work pants offer legendary durability to get the job done. A relaxed fit maintains enough room in the seat and thighs for easy movement, while a full selection of utility pockets keeps essentials close at hand.</p> <p> </p> <ul> <li>12-ounce, 100% cotton ringspun washed duck canvas</li> <li>Roomy cut with a generous fit through the seat and thigh and a straight leg opening</li> <li>Heavy-hauling reinforced back pockets for hand tools and more</li> <li>Multiple tool and utility pockets with left-leg hammer loop</li> </ul>	[empty string]	N	39.99	39.99	38,34,36,32,42,40	95622-DEFAULT-s.jpg	[empty string]	1000	B11BRN	12528	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/men-s-washed-duck-work-dungaree-brown-12528	1
2	DPS	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	DPS\|NULL\|NULL	1	39.99	0	39.99	96070-DEFAULT-l.jpg	39.99	96070-DEFAULT-m.jpg	WASHED DENIUM DUNGAREE	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]	23	25-to-50	0.00	[empty string]	MEN'S WASHED DENIM WORK DUNGAREE - DEEPSTONE	<p>Built in Carhartt's roomiest fit, these men's jeans have a full seat and thigh to keep you comfortable on the job. They're made of midweight denim for long-lasting durability. Multiple pockets give you plenty of storage for your tools.</p> <p> </p> <ul> <li>11.75-ounce, 100% cotton ringspun denim</li> <li>Our roomiest cut with a generous fit through the seat and thigh and a straight leg openingStrong sewn-on-seam belt loops</li> <li>Heavy-hauling reinforced back pockets</li> <li>Multiple tool and utility pockets with left-leg hammer loop</li> </ul>	[empty string]	N	39.99	39.99	34,36,32,46,48,40,42,44	96070-DEFAULT-s.jpg	[empty string]	1000	B13DPS	100119	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/men-s-washed-denim-work-dungaree-deepstone-100119	1
3	DPS	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	DPS\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	DENIUM WORK SHORT	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	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Denim Work Short - Men`s - Deepstone	When the weather gets too hot and pants are too uncomfortable, you`ll love the Denim Work Shorts. Made of rugged 11.75 ounce, 100% cotton denim they`re also as durable as they are comfortable.<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	29.99	29.99	44	[empty string]	[empty string]	1000	B28DPS	113740	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/denium-work-short-113740	1
4	SUBA	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Bottoms	SUBA\|NULL\|NULL	1	209	0	209	96578-DEFAULT-l.jpg	209	96578-DEFAULT-m.jpg	MOUNTAIN 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]	13	200-to-250	0.00	[empty string]	MOUNTAIN PANT	<p>Designed to deliver the highest performance in the widest range of conditions from chasing September bugles to the last day of the rifle season. As the name implies, the Mountain Pant will be a staple for multiple seasons and pursuits.</p> <p> </p> <ul> <li> <p><strong>GORE OPTIFADE Concealment Subalpine </strong>is designed for stalking and ambushing ungulates from ground level in tree-covered and vegetated terrain.</p> </li> <li> <p><strong>Fabric:</strong> 4-Way Stretch-Woven Polyester.</p> </li> <li> <p><strong>Durable Water Repellent</strong> finish resists light precipitation and prevents the face fabric from wetting out.</p> </li> <li> <p><strong>Articulated Fit:</strong> Delivers a maximum range of motion with minimal bulk.</p> </li> <li> <p><strong>Removable Knee Pads:</strong> Removable knee pads offer additional protection whether you’re scrambling through talus in the Northern Rockies, picking your way through cactus in the Sonoran Desert, or field dressing an animal.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	209	209	32,36,40,38,34	96578-DEFAULT-s.jpg	[empty string]	1000	50104	270664	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/mountain-pant-270664	1
5	LK5	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Bottoms	LK5\|NULL\|NULL	0	60	0	60	[empty string]	60	[empty string]	MNS ROLLING SUN SHORT	N	6.1 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]	11	50-to-100	0.00	[empty string]	MEN'S ROLLING SUN PACKABLE SHORTS	<p>The light, versatile Men’s Rolling Sun Packable Shorts have the performance features—such as moisture-wicking FlashDry and water-repellency—you need for those long, warm days that you wish would never end.</p> <p> </p> <ul> <li>Standard fit</li> <li>Dobby fabric raises the face fabric from your skin for quicker drying</li> <li>FlashDry materials offer enhanced moisture management to help keep you comfortable</li> <li>Non-PFC DWR finish for added water repellency</li> <li>Internal, flat drawcord at waist for adjustability</li> <li>Zip-fly with a button closure</li> <li>Slash hand pockets</li> <li>Two hook-and-loop-closure back pockets</li> <li>Packs into the secure-zip stowpocket on left thigh</li> <li>Heat transfer logo on left thigh</li> </ul>	[empty string]	N	60	60	34,30,32,38,36	[empty string]	[empty string]	1000	NF0A3T2Q	315266	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-rolling-sun-packable-shorts-315266	1
6	253,O39	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	253\|NULL\|NULL,O39\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	RUGGED FLEX RIGBY DUNGAREE	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]	107	25-to-50	0.00	[empty string]	Rugged Flex Rigby Dungaree	[empty string]	[empty string]	N	44.99	44.99	38,36,34,40,42,32,44	[empty string]	[empty string]	1000	102291	322713	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/rugged-flex-rigby-dungaree-322713	1
7	EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>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	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	scentlok/forefront-pant-335163	1
8	EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	EDGE\|NULL\|NULL	0	179.99	0	179.99	[empty string]	179.99	[empty string]	FOREFRONT PANT BIG AND TALL	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]	6	150-to-200	0.00	[empty string]	Forefront Pant Big And Tall	[empty string]	[empty string]	N	179.99	179.99	2XT,XLT,3X	[empty string]	[empty string]	1000	1021020 BT	335165	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	scentlok/forefront-pant-big-and-tall-335165	1
9	TOBC	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	TOBC\|NULL\|NULL	0	79.95	0	79.95	[empty string]	79.95	[empty string]	CAMBER ORIGINAL 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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	15	50-to-100	0.00	[empty string]	Camber Original Pant	[empty string]	[empty string]	N	79.95	79.95	36,38,40,32,34	[empty string]	[empty string]	1000	E37	341832	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/camber-original-pant-341832	1
10	EDG	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	EDG\|NULL\|NULL	1	139.99	1	129.99	86426-DEFAULT-l.jpg	139.99	86426-DEFAULT-m.jpg	SAVANNA AERO CROSSHAIR 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]	32	100-to-150	0.00	[empty string]	Savanna Aero Crosshair Pant	[empty string]	[empty string]	N	129.99	139.99	2X,ONE SZ FITS ALL,XL,S,M,3X	86426-DEFAULT-s.jpg	[empty string]	1000	1016120	341899	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	scentlok/savanna-aero-crosshair-pant-341899	1
11	8K2,JK3,A9L	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Bottoms	8K2\|NULL\|NULL,JK3\|NULL\|NULL,A9L\|NULL\|NULL	0	50	0	50	[empty string]	50	[empty string]	M WANDER SHORT	N	6.1 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]	15	25-to-50	0.00	[empty string]	MEN'S WANDER SHORT	<p>The Men’s Wander Shorts are stretch-woven and featured for performance. When you’re looking for mobility and comfort on the trail, these sweat-wicking and water-repellent shorts should be one of your first choices.</p> <p> </p> <ul> <li>Standard fit</li> <li>Stretch-woven fabric for increased mobility and durability</li> <li>FlashDry-XD materials offer enhanced moisture management to help keep you comfortable and increased abrasion resistance for extra durability</li> <li>Non-PFC DWR finish for added water repellency</li> <li>Elastic waistband with an internal drawcord makes shorts easy to pull on</li> <li>Concealed-zip pocket at left side seam</li> <li>Drop-in hand pockets</li> <li>Heat transfer logo on left hem</li> </ul>	[empty string]	N	50	50	M,XL,L,2X	[empty string]	[empty string]	1000	NF0A535Q	348248	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-wander-short-348248	1
12	RKHAK	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	RKHAK\|NULL\|NULL	0	54.95	0	54.95	[empty string]	54.95	[empty string]	HOMESTEAD CHINO PANT	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	Homestead Chino Pant	[empty string]	[empty string]	N	54.95	54.95	34,38,35,36,40,32	[empty string]	[empty string]	1000	E27	349915	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/homestead-chino-pant-349915	1
13	JK3,173,ZDL	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Bottoms	JK3\|NULL\|NULL,173\|NULL\|NULL,ZDL\|NULL\|NULL	0	65	0	65	[empty string]	65	[empty string]	M CLASS V BLETED SHORT	N	6.1 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]	19	50-to-100	0.00	[empty string]	MEN'S CLASS V BELTED SHORT	<p>The relaxed-fit Men’s Class V Belted Shorts are made for those bright summer days that never fade. With added stretch and FlashDry-XD technology, the fun is just one ''cannonball!'' away.</p> <p> </p> <ul> <li>Relaxed fit</li> <li>Fabric made with 68% recycled nylon</li> <li>FlashDry-XD materials offer enhanced moisture management to help keep you comfortable and increased abrasion resistance for extra durability</li> <li>Non-PFC DWR finish for added water repellency</li> <li>Woven webbing belt at waist for adjustability with a logo label at one end</li> <li>Faux fly</li> <li>Single-welt, reverse-coil-zip hand pockets</li> <li>Embroidered logo on left hem</li> </ul>	[empty string]	N	65	65	L,XL,2X,M	[empty string]	[empty string]	1000	NF0A55V8	350112	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	north-face/men-s-class-v-belted-short-350112	1
14	KHAK	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	KHAK\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	TETON SHORT CLASSIC FIT	N	6.1 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]	1	50-to-100	0.00	[empty string]	Teton Short Classic Fit	[empty string]	[empty string]	N	59.99	59.99	31	[empty string]	[empty string]	1000	H74	350170	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/teton-short-classic-fit-350170	1
15	DKWH	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	DKWH\|NULL\|NULL	0	79.95	0	79.95	[empty string]	79.95	[empty string]	MITER DENIM JEAN	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]	10	50-to-100	0.00	[empty string]	Miter Denim Jean	[empty string]	[empty string]	N	79.95	79.95	38,34,36,40,33	[empty string]	[empty string]	1000	I74	356019	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/miter-denim-jean-356019	1
16	225	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	225\|NULL\|NULL	0	409.99	1	399.99	[empty string]	409.99	[empty string]	BE1 DIVERGENT 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]	16	350-to-400	0.00	[empty string]	Be1 Divergent Pant	[empty string]	[empty string]	N	399.99	409.99	XL,M,L,3X,2X	[empty string]	[empty string]	1000	1031120	356086	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	scentlok/be1-divergent-pant-356086	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts597 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Filter