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]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	DUNGAREE FLANNEL LINED	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]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Washed Duck Dungaree / Flannel Lined - Men`s - Moss	Lined with 100% cotton flannel, the Washed Duck Dungaree is a great piece to have on when taking on the cold weather in greater comfort.<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	49.99	49.99	42,44,34,38,40,36	[empty string]	[empty string]	1000	B111MOS	12525	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/dungaree-flannel-lined-12525	1
2	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	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]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Washed Duck Work Dungaree - Men`s - Brown	<p>When your daily routine takes you from the barn to the back 40, our 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> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-12-ounce, 100% cotton ringspun washed duck canvas</p> <p> </p> <p>-Our roomiest cut with a generous fit through the seat and thigh and a straight leg opening</p> <p> </p> <p>-Heavy-hauling reinforced back pockets for hand tools and more</p> <p> </p> <p>-Multiple tool and utility pockets with left-leg hammer loop</p> <p> </p> <p>-Model height: 6`2"; Chest size: 40.5"; Wearing size 32 x 32</p> <p> </p> <p>-Imported</p> <p> </p>	[empty string]	N	39.99	39.99	42,36,32,34,40,38,44	[empty string]	[empty string]	1000	B11BRN	12528	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/dungaree-washed-duck-12528	1
3	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	RELAXED FIT FLANNEL JEAN	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]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	17	25-to-50	0.00	[empty string]	Relaxed Fit Jean - Straight Leg / Flannel Lined - Men`s - Dark Stone	<p>This relaxed fit jean is constructed of 100% cotton denim, featuring a straight leg and lined for warmth at the work site with 100% cotton flannel.</p>	[empty string]	N	39.99	39.99	44,42,46,36,40,34,48	[empty string]	[empty string]	1000	B172DST	12539	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/relaxed-fit-flannel-jean-12539	1
4	DPS	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	DPS\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	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]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Washed Denim Work Dungaree - Men`s - Deepstone	The Washed Denim Work Dungaree is built tough for your long days on the job. The Dungaree sits at the natural waist and offers a full seat and thigh, so you will stay comfortable no matter how much stretching, bending and lifting you do in a days work.<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	39.99	39.99	36,46,48,40,34,44	[empty string]	[empty string]	1000	B13DPS	100119	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/washed-denium-dungaree-100119	1
5	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]	4	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,30	[empty string]	[empty string]	1000	B28DPS	113740	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/denium-work-short-113740	1
6	DST	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Bottoms	DST\|NULL\|NULL	0	64.99	1	59.99	[empty string]	64.99	[empty string]	DENIUM BIB OVERALL	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]	CLARE ONLY	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Washed Denim Bib Overall - Dark Stone	Carhartt`s washed denim bib overall is garment washed for comfort. Made of 11.75-ounce, 100% cotton denim, it features multiple tool and utility pockets, hammer loop and adjustable suspenders. Back pockets are reinforced for durability.	[empty string]	N	59.99	64.99	34,36,38,46,48	[empty string]	[empty string]	1000	R07DST	118800	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/denium-bib-overall-118800	1
7	SUBA	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Bottoms	SUBA\|NULL\|NULL	0	199	0	199	[empty string]	199	[empty string]	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Mountain Pant	<p>The mountain pant is Sitka`s most versatile hunting pant and a foundational piece to any SITKA hunting system. </p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Articulated Patterning:  The Mountain pant offers an articulated fit with tapered legs and a fully gusseted crotch for maximum range of motion with minimal bulk to   reduce friction and noise.</p> <p> </p> <p>-Removable Knee Pads:  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> <p> </p> <p>-Durable Water Repellent Finish:  The DWR finish resists light precipitation and prevents the face fabric from wetting out. </p> <p> </p>	[empty string]	N	199	199	38	[empty string]	[empty string]	1000	50104	270664	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/mountain-pant-270664	1
8	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	78	25-to-50	0.00	[empty string]	Rugged Flex Rigby Dungaree	[empty string]	[empty string]	N	44.99	44.99	34,36,38,32,42,44,40	[empty string]	[empty string]	1000	102291	322713	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/rugged-flex-rigby-dungaree-322713	1
9	EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	EDGE\|NULL\|NULL	1	159.99	0	159.99	86155-DEFAULT-l.jpg	159.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]	2020	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Forefront Pant	[empty string]	[empty string]	N	159.99	159.99	S	86155-DEFAULT-s.jpg	[empty string]	1000	1021020	335163	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	scentlok/forefront-pant-335163	1
10	EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	EDGE\|NULL\|NULL	0	179.99	1	169.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]	2020	[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	169.99	179.99	2XT,3X,LT	[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
11	FIRMA,GREY,TOBC	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	FIRMA\|NULL\|NULL,GREY\|NULL\|NULL,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]	20	50-to-100	0.00	[empty string]	Camber Original Pant	[empty string]	[empty string]	N	79.95	79.95	38,42,34,36,40,35,33,30	[empty string]	[empty string]	1000	E37	341832	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/camber-original-pant-341832	1
12	EDG	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	EDG\|NULL\|NULL	1	129.99	1	119.99	86426-DEFAULT-l.jpg	129.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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Savanna Aero Crosshair Pant	[empty string]	[empty string]	N	119.99	129.99	2X,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
13	TOBCO	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	TOBCO\|NULL\|NULL	0	59.95	0	59.95	[empty string]	59.95	[empty string]	JACKSON CHINO 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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Jackson Chino Short	[empty string]	[empty string]	N	59.95	59.95	31,38,30,32,33,36	[empty string]	[empty string]	1000	B77	349913	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/jackson-chino-short-349913	1
14	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]	42	50-to-100	0.00	[empty string]	Homestead Chino Pant	[empty string]	[empty string]	N	54.95	54.95	36,38,40,32,34,30,33,42,31,35	[empty string]	[empty string]	1000	E27	349915	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/homestead-chino-pant-349915	1
15	KHAK	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	KHAK\|NULL\|NULL	0	60	0	60	[empty string]	60	[empty string]	TETON SHORT CLASSIC FIT	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]	4	50-to-100	0.00	[empty string]	Teton Short Classic Fit	[empty string]	[empty string]	N	60	60	31,32,33	[empty string]	[empty string]	1000	H74	350170	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/teton-short-classic-fit-350170	1
16	COAL	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	COAL\|NULL\|NULL	0	99.95	0	99.95	[empty string]	99.95	[empty string]	WATERROCK 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]	10	50-to-100	0.00	[empty string]	Waterrock Pant	[empty string]	[empty string]	N	99.95	99.95	38,31,34,35,36,32	[empty string]	[empty string]	1000	C56	350177	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/waterrock-pant-350177	1
17	COAL	MTNKHAK	Mtnkhak	CLOTHING	Clothing>Mens>Bottoms	COAL\|NULL\|NULL	0	84.95	0	84.95	[empty string]	84.95	[empty string]	WATERROCK SHORT CLASSIC FIT	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]	4	50-to-100	0.00	[empty string]	Waterrock Short Classic Fit	[empty string]	[empty string]	N	84.95	84.95	31,32,33	[empty string]	[empty string]	1000	J33	350180	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/waterrock-short-classic-fit-350180	1
18	DNA	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	DNA\|NULL\|NULL	0	149.99	1	139.99	[empty string]	149.99	[empty string]	WINDBRACE FLEECE PANT	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	37	100-to-150	0.00	[empty string]	Windbrace Fleece Pant	[empty string]	[empty string]	N	139.99	149.99	L,XL,2X,M,S,3X	[empty string]	[empty string]	1000	1022920	352630	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	scentlok/windbrace-fleece-pant-352630	1
19	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]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	19	50-to-100	0.00	[empty string]	Miter Denim Jean	[empty string]	[empty string]	N	79.95	79.95	34,38,36,40,35,32,33	[empty string]	[empty string]	1000	I74	356019	BOTTOMS	EMPTY	EMPTY	0	0	0	MENS	[empty string]	mtnkhak/miter-denim-jean-356019	1
20	225	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Bottoms	225\|NULL\|NULL	0	389.99	1	379.99	[empty string]	389.99	[empty string]	BE1 DIVERGENT PANT	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[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	379.99	389.99	2X,M,XL,3X	[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

SQL

SELECT * FROM GetALLProducts597 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Filter

Filter By

Price

Bottoms

Brand

Size

Washed Duck Dungaree/Flannel Lined - Men's - Moss

Washed Duck Work Dungaree - Men's - Brown

Relaxed Fit Jean - Straight Leg/Flannel Lined - Men's - Dark Stone

Washed Denim Work Dungaree - Men's - Deepstone

Denim Work Short - Men's - Deepstone

Washed Denim Bib Overall - Dark Stone

Mountain Pant

Rugged Flex Rigby Dungaree

Forefront Pant

Forefront Pant Big And Tall

Camber Original Pant

Savanna Aero Crosshair Pant

Jackson Chino Short

Homestead Chino Pant

Teton Short Classic Fit

Waterrock Pant

Waterrock Short Classic Fit

Windbrace Fleece Pant

Miter Denim Jean

Be1 Divergent Pant