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	SBA	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Women>Accessories	SBA\|NULL\|NULL	1	59	0	59	96632-DEFAULT-l.jpg	59	96632-DEFAULT-m.jpg	WS JETSTREAM BEANIE	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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	WOMEN'S JETSTREAM BEANIE	<p>Cut from the same fabric as the Jetstream Jacket, the Jetstream WINDSTOPPER Beanie is ideal for charging up steep faces in bitter cold or sitting motionless on a windy ridge. A lofted micro-grid fleece backer delivers warmth, while the GORE-TEX INFINIUM with WINDSTOPPER membrane blocks frosty drafts. A pony tail port keeps things streamlined and a four-way stretch, air permeable band warms the back of your neck and ears without impeding hearing.</p> <p> </p> <ul> <li> <p><strong>GORE WINDSTOPPER:</strong> A full GORE WINDSTOPPER membrane seals out gusts to protect your ears and retain core head warmth.</p> </li> <li> <p><strong>Micro Grid Interior:</strong> Soft fleece interior delivers a higher warmth-to-weight ratio while effectively moving moisture away from the body to wick sweat and dry quickly.</p> </li> <li> <p><strong>Ponytail Port:</strong> Maintain a precision fit.</p> </li> <li> <p><strong>4-Way Stretch Panel:</strong> Elastic panel provides a close and comfortable fit.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	59	59	ONE SZ FITS ALL	96632-DEFAULT-s.jpg	[empty string]	1000	90193	303415	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	sitka-gear/women-s-jetstream-beanie-303415	1
2	259	SIMMS	Simms	CLOTHING	Clothing>Women>Accessories	259\|NULL\|NULL	1	29.99	1	29.95	105064-DEFAULT-l.jpg	29.99	105064-DEFAULT-m.jpg	WALLEYE ICON TRUCKER HAT	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]	9	25-to-50	0.00	[empty string]	Walleye Icon Trucker Hat	<p>57% polyester/43% cotton twill; Back- 100% polyester mesh</p>	[empty string]	N	29.95	29.99	O/S	105064-DEFAULT-s.jpg	[empty string]	1000	12578	317462	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	simms/walleye-icon-trucker-hat-317462	1
3	276,OO3	SIMMS	Simms	CLOTHING	Clothing>Women>Accessories	276\|NULL\|NULL,OO3\|NULL\|NULL	1	29.99	1	29.95	105067-DEFAULT-l.jpg	29.99	105067-DEFAULT-m.jpg	TROUT ICON TRUCKER HAT	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Trout Icon Trucker Hat	<p>Trout Icon Trucker Hat features the iconic trout patch and Simms text with a low-crown fit, mesh back, and adjustable snap closure for the perfect fit.</p>	[empty string]	N	29.95	29.99	O/S	105067-DEFAULT-s.jpg	[empty string]	1000	12226	317506	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	simms/trout-icon-trucker-hat-317506	1
4	LVNR/PUMC,JADE/PUMC	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories	LVNR/PUMC\|NULL\|NULL,JADE/PUMC\|NULL\|NULL	1	42	0	42	104936-DEFAULT-l.jpg	42	104936-DEFAULT-m.jpg	CLEAR CREEK BOONIE	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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	CLEAR CREEK BOONIE	<p>The reversible Clear Creek Boonie  give's you two looks in one. Take one side out for a ramble through the wilderness, then flip it over when you get to the café—both sides feature high performance fabrics that look and feel great. The adjustable cordlock dials in your custom, comfy fit. The chinstrap holds it close when you’re on the move but detaches when it’s time to kick back.The Clear Creek packs completely flat with your travel itinerary.</p> <p> </p> <ul> <li>UPF 50+ Sun Rating</li> <li>3" Crushable Brim</li> <li>Reversible for Two Color Options</li> <li>Packs for Travel</li> <li>Removable Chinstrap</li> <li>Adjustable Sizing</li> <li>Weight: 3.1 ounces/87.9 grams</li> </ul>	[empty string]	N	42	42	M	104936-DEFAULT-s.jpg	[empty string]	1000	S2C11395	365419	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	sunday/clear-creek-boonie-365419	1
5	SAND	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories	SAND\|NULL\|NULL	1	44	0	44	104939-DEFAULT-l.jpg	44	104939-DEFAULT-m.jpg	LATITUDE HAT	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	LATITUDE HAT	<p>Full sun protection in a stylish profile, the Latitude Hat offers remarkably broad coverage with folding Reverse Split Brim technology. Shades stay put front or back with Sunglass Lock feature, and a signature moisture-wicking sweatband makes this hat the perfect companion for any outdoor activity.</p>	[empty string]	N	44	44	M,L,XL	104939-DEFAULT-s.jpg	[empty string]	1000	S2A02609	365424	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	sunday/latitude-hat-365424	1
6	SEA	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories	SEA\|NULL\|NULL	1	36	0	36	104933-DEFAULT-l.jpg	36	104933-DEFAULT-m.jpg	SOL SEEKER HAT	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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	SOL SEEKER HAT	<p>An on-trend floppy brim, a mixed weave color palette, and a hint of detail on the leatherette hatband all add up to one charismatic sun hat. The Sol Seeker has you covered for those long days of summer where sun protection and looking great are essential, from the U-Pick farm to that outdoor concert to the spontaneous hike to a mountain meadow picnic. Packable construction ensures it tags along in a backpack or tote bag. The soft interior sweatband keeps you comfortable and holds an adjustable sizing tie so you can customize the fit. </p> <p> </p> <ul> <li>UPF 50+ Sun Rating</li> <li>3 ½" Brim</li> <li>Breathable Polyester/Paper Braid</li> <li>Packs for Travel</li> <li>Decorative Hatband</li> <li>Comfort Sweatband</li> <li>Internal Adjustable Sizing</li> <li>Avoid Rain/WetConditions</li> <li>Weight: 5.5 ounces/155.9 grams</li> </ul>	[empty string]	N	36	36	L,M	104933-DEFAULT-s.jpg	[empty string]	1000	S2C86496	365426	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	sunday/sol-seeker-hat-365426	1
7	PUMC,HORZN	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories	PUMC\|NULL\|NULL,HORZN\|NULL\|NULL	1	42	0	42	105117-DEFAULT-l.jpg	42	105117-DEFAULT-m.jpg	ULTRA ADVENTURE HAT	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	ULTRA ADVENTURE HAT	<ul> <li>UPF 50+ Sun Rating (includes mesh)</li> <li>3¼" Brim and 6" Neck Cape</li> <li>Sunglass Lock™ Keeps Glasses in Place</li> <li>Wicking Sweatband</li> <li>PFA-free durable water repellent finish</li> <li>Adjustable Sizing</li> <li>bluesign  certified main body fabric, mesh, and sweatband</li> <li>Reverse Split Brim   packs small and flat</li> <li>Weight: 2.6 ounces/73.7 grams</li> </ul>	[empty string]	N	42	42	L/XL,S/M	105117-DEFAULT-s.jpg	[empty string]	1000	S2A01392	365429	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	sunday/ultra-adventure-hat-365429	1
8	LTBLU,ROSE	LEGACY	Legacy	CLOTHING	Clothing>Women>Accessories	LTBLU\|NULL\|NULL,ROSE\|NULL\|NULL	1	21.99	0	21.99	104891-DEFAULT-l.jpg	21.99	104891-DEFAULT-m.jpg	RELAXED TWILL CAP	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]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	20	20-to-25	0.00	[empty string]	Relaxed Twill Cap	[empty string]	[empty string]	N	21.99	21.99	ONE SZ FITS ALL	104891-DEFAULT-s.jpg	[empty string]	1000	14410 JAYS	371171	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	legacy/relaxed-twill-cap-371171	1
9	PORT,TEAL	LAKESHIRT	Lakeshirt	CLOTHING	Clothing>Women>Accessories	PORT\|NULL\|NULL,TEAL\|NULL\|NULL	1	24.99	0	24.99	104892-DEFAULT-l.jpg	24.99	104892-DEFAULT-m.jpg	LOW PRO PIGMENT WASHED TRUCKER	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]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	24	20-to-25	0.00	[empty string]	Low Pro Pigment Washed Trucker	[empty string]	[empty string]	N	24.99	24.99	ONE SZ FITS ALL	104892-DEFAULT-s.jpg	[empty string]	1000	SCOUT MI MAP JAYS	371217	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	lakeshirt/low-pro-pigment-washed-trucker-371217	1
10	221	COLUMBIA SPORTSWEAR	Columbia Sportswear	CLOTHING	Clothing>Women>Accessories	221\|NULL\|NULL	1	30	0	30	104904-DEFAULT-l.jpg	30	104904-DEFAULT-m.jpg	PFG MESH BALL CAP BIG	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	16	25-to-50	0.00	[empty string]	Pfg Mesh Ball Cap Big	[empty string]	[empty string]	N	30	30	ONE SZ FITS ALL	104904-DEFAULT-s.jpg	[empty string]	1000	1887981	374016	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	columbia-sportswear/pfg-mesh-ball-cap-big-374016	1
11	SALT	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories	SALT\|NULL\|NULL	1	44	0	44	104935-DEFAULT-l.jpg	44	104935-DEFAULT-m.jpg	VOYAGE HAT	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	VOYAGE HAT	<p>With a simple, four-panel crown and a broad, round brim, the Voyage Hat is your go-to for fun in the sun. Made from lightweight, bluesign-certified fabric, the strategic crown ventilation, adjustable sizing, and wicking sweatband ensure comfort and a great fit. Plus, the Sunglass Lock helps keep track of those glasses!</p> <p> </p> <ul> <li>UPF 50+ sun rating (mesh not rated)</li> <li>3.25"" (8.5cm) brim</li> <li>Sunglass Lock keeps glasses in place</li> <li>Strategic crown ventilation</li> <li>Adjustable chinstrap</li> <li>Adjustable sizing</li> <li>Floats in water</li> <li>Wicking sweatband</li> <li>bluesign certified main body fabric, mesh and sweatband</li> </ul>	[empty string]	N	44	44	L,M	104935-DEFAULT-s.jpg	[empty string]	1000	S2C02962	376713	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	sunday/voyage-hat-376713	1
12	CREAM	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories	CREAM\|NULL\|NULL	1	39.99	0	39.99	104934-DEFAULT-l.jpg	39.99	104934-DEFAULT-m.jpg	WANDERLUST FEDORA	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	WANDERLUST FEDORA	<p>Ready for sunny adventures far away or close to home, the Wanderlust Fedora is a playful take on a classic style. Offering UPF 50+ sun protection and a decorative, beaded hatband, this hat is made from breathable poly/paper braid. The bluesign-certified sweatband and internal adjustable sizing offer comfort and a custom fit.</p> <p> </p> <ul> <li>UPF 50+ sun rating</li> <li>2.75" (7cm) brim fedora</li> <li>Breathable polyester/paper braid*</li> <li>Decorative beaded hatband</li> <li>Internal adjustable sizing</li> <li>Wicking sweatband</li> <li>bluesign certified sweatband</li> <li>Avoid rain / wet conditions</li> </ul>	[empty string]	N	39.99	39.99	S/M	104934-DEFAULT-s.jpg	[empty string]	1000	S2C27963	376714	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	sunday/wanderlust-fedora-376714	1
13	WOO/BLK,CHI/BLK	LAKESHIRT	Lakeshirt	CLOTHING	Clothing>Women>Accessories	WOO/BLK\|NULL\|NULL,CHI/BLK\|NULL\|NULL	1	25.99	0	25.99	104898-DEFAULT-l.jpg	25.99	104898-DEFAULT-m.jpg	POLO KNIT TRUCKER	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	36	25-to-50	0.00	[empty string]	Polo Knit Trucker	[empty string]	[empty string]	N	25.99	25.99	ONE SZ FITS ALL	104898-DEFAULT-s.jpg	[empty string]	1000	CARSON JAYS PINES	379583	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	lakeshirt/polo-knit-trucker-379583	1
14	FORE,ADOB	LAKESHIRT	Lakeshirt	CLOTHING	Clothing>Women>Accessories	FORE\|NULL\|NULL,ADOB\|NULL\|NULL	1	25.99	0	25.99	104862-DEFAULT-l.jpg	25.99	104862-DEFAULT-m.jpg	PIGMENT WASHED TRUCKER	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]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	38	25-to-50	0.00	[empty string]	Pigment Washed Trucker	[empty string]	[empty string]	N	25.99	25.99	ONE SZ FITS ALL	104862-DEFAULT-s.jpg	[empty string]	1000	SCOUT JAYS PINES	379584	ACCESSORIES	EMPTY	EMPTY	0	0	0	WOMEN	[empty string]	lakeshirt/pigment-washed-trucker-379584	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts604 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Close

Filter By

Size

L
L/XL
M
O/S
OS
S/M
XL

Filter