Stance Joven Classic Crew Sock

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

Flannels Hoodies and Sweatshirts Jackets Lycra and Rashguards Shirts Tank Tops View All >>

Gloves Jackets

All Shoes Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Black	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; HATS	25.99	0	25.99	25637-DEFAULT-l.jpg	25	25637-DEFAULT-m.jpg	Retro Mountain Trucker Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	25	25-to-50	0.00	[empty string]	Never Summer Retro Mountain Trucker Hat	<p>The Never Summer Retro Mountain Trucker Hat features a bright Never Summer logo on front and an adjustable snapback. </p>	[empty string]	N	26	26	One Size	25637-DEFAULT-s.jpg	2	1000	HTRETROMESH	374870	HATS	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-retro-mountain-trucker-hat-374870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Multi	RVCA	RVCA	MENS	MENS &GT; TOPS &GT; SHIRTS	59.99	0	59.99	26716-DEFAULT-l.jpg	59	26716-DEFAULT-m.jpg	Vaughn Floral Ss	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	RVCA Sage Vaughn Floral Button Up Shirt	<p>THE RVCA SAGE VAUGHN FLORAL BUTTON-UP SHIRT BRINGS A WILD NATURE TO YOUR CLASSIC FLORAL SHIRT. PART OF THE ARTIST NETWORK PROGRAM, THE SPECIAL EDITION BUTTON-DOWN FEATURES CURATED ARTWORK BY SAGE VAUGHN THROUGHOUT. MADE FROM A COTTON AND VISCOSE BLEND, THE SHIRT OFFERS A LIGHTWEIGHT FEEL.</p>	[empty string]	N	60	60	Medium,Large	26716-DEFAULT-s.jpg	2	1000	M501TRVF	386157	SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	rvca/rvca-sage-vaughn-floral-button-up-shirt-386157	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Vintage Purple	NEFF	NEFF	MENS	MENS &GT; TOPS &GT; T-SHIRTS	31.99	0	31.99	26880-DEFAULT-l.jpg	31	26880-DEFAULT-m.jpg	Pigment Peek Ss Pocket Tee	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Neff Pigment Peek Pocket T-Shirt	<p>With various graphics popping out the front pocket, the Pigment Peek Pocket Tee has peeking perks that won't pick your pocket! Comes in vibrant colors great for summer.</p> <p>- Regular fit<br /> - Crew neckline<br /> - Left chest pocket<br /> - Printed inside label<br /> - 100% Cotton</p>	[empty string]	N	32	32	Small,Medium,Large,X-Large,XX-Large	26880-DEFAULT-s.jpg	3	1000	19P29009	384376	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	neff/neff-pigment-peek-pocket-tshirt-384376	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	GLOBE	GLOBE	MENS	MENS &GT; SHOES &GT; SKATE SHOES	94.99	0	94.99	26624-DEFAULT-l.jpg	94	26624-DEFAULT-m.jpg	Sabre Charcoal/Black/Camo	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BLK COMBO	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	45	50-to-100	0.00	[empty string]	Globe Sabre Skate Shoe, Charcoal/Black/Camo	<p>The Sabre in Charcoal/Black/Camo is a ultra heavy duty skate style made of action nubuck/synthetic nubuck. It features a step-in sock liner with Nitrocel ™ airbag sole. It has a Globe's S-Trac ™ sole pattern.</p>	[empty string]	N	95	95	9.5,10,10.5,11,11.5,12,13,14	26624-DEFAULT-s.jpg	5	1000	GBSABR-15249	383559	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	globe/globe-sabre-skate-shoe-charcoal-black-camo-383559	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	SUN BUM	SUN BUM	MENS	MENS &GT; ACCESSORIES	12.99	0	12.99	25573-DEFAULT-l.jpg	12	25573-DEFAULT-m.jpg	Spf 50 Face Lotion	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	0	10-to-15	0.00	[empty string]	Sun Bum SPF 50 Face Lotion, 3 oz.	<p>Designed for daily use, our best-selling face sunscreen is a weightless lotion that quickly absorbs into your skin for easy, invisible protection with a matte finish. Made for the face but works everywhere you want a super sheer look and feel without compromising our strong and trusted coverage.  </p>	[empty string]	N	12.99	12.99	[empty string]	25573-DEFAULT-s.jpg	6	1000	20-45092	379752	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-50-face-lotion-3-oz-379752	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	ELECTRIC	ELECTRIC	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	169.99	0	169.99	25964-DEFAULT-l.jpg	169	25964-DEFAULT-m.jpg	Knoxville S Mat Blk/Gry Polar	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Electric Knoxville S Sunglasses, Matte Black/Grey Polarized	<p>Electric Knoxville S Sunglasses, Matte Black/Grey Polarized</p>	[empty string]	N	170	170	[empty string]	25964-DEFAULT-s.jpg	8	1000	EE15101042	344011	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	electric/electric-knoxville-s-sunglasses-matte-black-grey-polarized-344011	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

NEVER SUMMER Never Summer Retro Mountain Trucker Hat $26.00 | view details

RVCA Rvca Sage Vaughn Floral Button Up Shirt $60.00 | view details

NEFF Neff Pigment Peek Pocket T- Shirt $32.00 | view details

GLOBE Globe Sabre Skate Shoe, Charcoal/Black/Camo $95.00 | view details

SUN BUM Sun Bum Spf 50 Face Lotion, 3 Oz. $12.99 | view details

ELECTRIC Electric Knoxville S Sunglasses, Matte Black/Grey Polarized $170.00 | view details

Womens

Pants Shorts

Crop Tops Hoodies and Sweatshirts Lycra and Rashguards Shirts View All >>

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

All Shoes Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	215	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	693	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25578-DEFAULT-l.jpg	5	25578-DEFAULT-m.jpg	Sunset Cove Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	147	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sunset Cove	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25578-DEFAULT-s.jpg	748	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	Sunset Red	BILLABONG	BILLABONG	WOMENS	WOMENS &GT; TOPS &GT; T-SHIRTS	24.99	0	24.99	26980-DEFAULT-l.jpg	24	26980-DEFAULT-m.jpg	Byron Bay Gday	N	WOMENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Billabong Byron Bay Gday Short Sleeve T-Shirt	<p>Byron is my bae. The throwback crop top features a slightly boxy fit and cropped length, topped with Byron Bay prints at the front and back. The short sleeve t-shirt is made from 100% cotton for a soft feel.</p> <p>The nuts and bolts</p> <ul> <li>Womens graphic t-shirt.</li> <li>Crop tee fit.</li> <li>“Byron Bay GDay” prints at front and back.</li> <li>Short sleeves.</li> <li>Crew neck.</li> <li>Material: cotton jersey. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	24.95	24.95	Small,Medium	26980-DEFAULT-s.jpg	1	1000	J413TBBY	387260	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-byron-bay-gday-short-sleeve-tshirt-387260	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
5	[empty string]	DOT DASH	DOT DASH	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	24.99	0	24.99	26047-DEFAULT-l.jpg	24	26047-DEFAULT-m.jpg	Kerfuffle Tort/Retro Gry	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	13	20-to-25	0.00	[empty string]	Dot Dash Kerfuffle Sunglasses, Tortoise/Grey	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	25	25	[empty string]	26047-DEFAULT-s.jpg	4	1000	DSVT5KER-TOR	349885	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-kerfuffle-sunglasses-tortoise-grey-349885	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
6	[empty string]	SUNCLOUD	SUNCLOUD	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	49.99	0	49.99	26024-DEFAULT-l.jpg	49	26024-DEFAULT-m.jpg	Loveseat Mt Tort Blu Fade/Silv Mirror	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Suncloud Loveseat Medium Fit Sunglasses, MT Tort Blue Fade/Silver Mirror	<p>Go ahead, get cozy with the Loveseat. Charismatic and fun loving medium size, round shape with keyhole nose bridge detail, the Loveseat settles in on trend in four smart colors. Trendy still demands performance; polarized lenses reduce glare and protect from harmful rays. Lightweight nylon frames emphasize color selections.</p> <p>Lens width: 52.5</p> <p>Lens height: 43.8</p> <p>Nose bridge: 18.9</p> <p>Temple length: 130</p> <p> </p>	[empty string]	N	49.99	49.99	[empty string]	26024-DEFAULT-s.jpg	7	1000	S-LOPPSVMBF	358673	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	suncloud/suncloud-loveseat-medium-fit-sunglasses-mt-tort-blue-fade-silver-mirror-358673	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

SELECT *, 1 as querySort FROM firstQuery UNION SELECT *, 2 as querySort FROM getFiller ORDER BY querySort, sortBy

SUN BUM Sun Bum Spf 15 Tinted Lip Balm, Pinktini $5.99 $3.99 | view details

SUN BUM Sun Bum Cocobalm Lip Balm, Groove Berry $3.99 $2.99 | view details

SUN BUM Sun Bum Spf 15 Tinted Lip Balm, Sunset Cove $5.99 $3.99 | view details

BILLABONG Billabong Byron Bay Gday Short Sleeve T- Shirt $24.95 | view details

DOT DASH Dot Dash Kerfuffle Sunglasses, Tortoise/Grey $25.00 | view details

SUNCLOUD Suncloud Loveseat Medium Fit Sunglasses, Mt Tort Blue Fade/Silver Mirror $49.99 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	4929-DEFAULT-l.jpg	49	4929-DEFAULT-m.jpg	Authentic Black/Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	SLIM	[empty string]	[empty string]	BLACK	[empty string]	SUMMER	[empty string]	[empty string]	[empty string]	152	25-to-50	0.00	[empty string]	Vans Authentic Skate Shoe, Black/Black	<p>The Authentic, Vans original and now iconic style, is a simple low top, lace-up with durable canvas upper, metal eyelets, Vans flag label and Vans original Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	4929-DEFAULT-s.jpg	21	1000	VN000EE3BKA	238892	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-authentic-skate-shoe-black-black-238892	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	12.99	0	12.99	25943-DEFAULT-l.jpg	12	25943-DEFAULT-m.jpg	Adjustable Retainer Costa Blue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	10-to-15	0.00	[empty string]	Costa Del Mar Adjustable Sunglasses Retainer, Blue	<p>The Costa C-Line Adjustable Retainer.</p> <p> </p> <p><strong>Features:</strong></p> <ul> <li>Ultra thin, lightweight coated wire</li> <li>Adjustable Logo bead sliders. Provide a streamlined profile when worn</li> <li>Flat, low profile temple attachments</li> </ul>	<p>Costa Del Mar Adjustable Retainer (Costa Blue)</p>	N	12.95	12.95	[empty string]	25943-DEFAULT-s.jpg	25	1000	CA11	371592	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-adjustable-sunglasses-retainer-blue-371592	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Assorted	ETHIKA	ETHIKA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	26842-DEFAULT-l.jpg	14	26842-DEFAULT-m.jpg	Boys Native Jaguar Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	Ethika Native Jaguar Boy's Boxer Brief	<ul> <li>The Original - Unmatched Staple Fit</li> <li>No Pull-Down, No Gathering</li> <li>Soft 4-Way Stretch Fabric</li> <li>High-Quality Jacquard Waistband</li> <li>90% Polyester 10% Spandex</li> </ul>	[empty string]	N	15	15	Medium,Large	26842-DEFAULT-s.jpg	42	1000	UBS1373	384624	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	ethika/ethika-native-jaguar-boys-boxer-brief-384624	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Stealth	BILLABONG	BILLABONG	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOARDSHORTS	49.99	0	49.99	27148-DEFAULT-l.jpg	49	27148-DEFAULT-m.jpg	Sundays Pro	N	BOYS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	38	25-to-50	0.00	[empty string]	Billabong Boys' Sundays Pro Boardshorts	<p>This Boys Sundays printed boardshort will take your curated style to a new level with a 4 way pro stretch performance fabric. Allover print design, patch pocket with hook & loop closure at back right. Micro repel coating. Made with 90% recycled polyester / 10% elastane.</p> <p>The nuts and bolts</p> <ul> <li>Boy’s Performance Boardshorts.</li> <li>Boys 17" fit; Little Boys 13” Fit</li> <li>4 way pro stretch performance fabric.</li> <li>Allover print design</li> <li>Patch pocket with hook & loop closure at back right</li> <li>Micro repel coating.</li> <li>Made with 90% recycled polyester / 10% elastane. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	49.95	49.95	22,23,24,25,26,27,28	27148-DEFAULT-s.jpg	50	1000	B123TBSU	382361	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-boys-sundays-pro-boardshorts-382361	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Stellar,Sleet,Crystal Blue	QUIKSILVER	QUIKSILVER	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; SHORTS	44.99	0	44.99	27076-DEFAULT-l.jpg	44	27076-DEFAULT-m.jpg	Youth Union Heather Amphibian	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	H17	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Quiksilver Union Heather Boy's Amphibian Boardshorts, 19"	<p>The nuts and bolts</p> <ul> <li><strong>Recycled Fabric:</strong> Repreve™ traceable, recycled 4-way stretch heather polyester made from plastic bottles</li> <li>DryFlight® water-repellent hydrophobic coating</li> <li><strong>Outseam:</strong> 19" outseam, mid length</li> <li>Classic, comfortable regular fit</li> <li><strong>Waist:</strong> Non-corrosive zip fly</li> <li>Button closure</li> <li><strong>Pockets:</strong> Side-entry pockets</li> <li>Back zip-up pocket</li> </ul> <p>Composition</p> <ul> <li> <p>90% Recycled Polyester, 10% Elastane</p> </li> </ul>	[empty string]	N	45	45	23/10S,24/8,25/10,26/12,28/14,29	27076-DEFAULT-s.jpg	75	1000	EQBWS03279	394831	EMPTY	SHORTS	EMPTY	0	0	0	EMPTY	quiksilver/quiksilver-union-heather-boys-amphibian-boardshorts-19-394831	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	4943-DEFAULT-l.jpg	49	4943-DEFAULT-m.jpg	Slip- On True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	LOW	[empty string]	[empty string]	[empty string]	SKATE	FALL	[empty string]	[empty string]	[empty string]	212	25-to-50	0.00	[empty string]	Vans Slip-On Skate Shoe, True White	<p>The Classic Slip-On has a low profile, slip-on canvas upper with all-over checker print, elastic side accents, Vans flag label and Vans original Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	4943-DEFAULT-s.jpg	85	1000	VN000EYEW00	233922	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-slipon-skate-shoe-true-white-233922	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VANS Vans Authentic Skate Shoe, Black/Black $50.00 | view details

COSTA DEL MAR Costa Del Mar Adjustable Sunglasses Retainer, Blue $12.95 | view details

ETHIKA Ethika Native Jaguar Boy's Boxer Brief $15.00 | view details

BILLABONG Billabong Boys ' Sundays Pro Boardshorts $49.95 | view details

QUIKSILVER Quiksilver Union Heather Boy's Amphibian Boardshorts, 19 " $45.00 | view details

VANS Vans Slip- On Skate Shoe, True White $50.00 | view details

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	59.99	0	59.99	25719-DEFAULT-l.jpg	59	25719-DEFAULT-m.jpg	Old Skool Hot Sauce/True White	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BRIGHT	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Vans Old Skool Skate Shoe, Hot Sauce/True White	<p>The Old Skool, the Vans classic skate shoe and first to bare the iconic sidestripe, is a low top lace-up featuring sturdy canvas and suede uppers, re-enforced toecaps to withstand repeated wear, padded collars for support and flexibility, and signature rubber waffle outsoles.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	6.5	25719-DEFAULT-s.jpg	5	1000	VN0A38G1UKZ	378733	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-old-skool-skate-shoe-hot-sauce-true-white-378733	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	64.99	0	64.99	25707-DEFAULT-l.jpg	64	25707-DEFAULT-m.jpg	Old Skool (Jersey Lace) Black/Port	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK COMBO	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Vans Jersey Lace Old Skool Skate Shoe, Black/Port Royale	<p>The first to bear the iconic side stripe, the Jersey Lace Old Skool is a low top lace-up shoe. It is lined, has padded collars for comfort, re-enforced toecaps to withstand repeated wear, and features the Vans signature waffle outsole for a firmer grip.<br /> 3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	65	65	8	25707-DEFAULT-s.jpg	13	1000	VN0A38G1UNI	378744	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-jersey-lace-old-skool-skate-shoe-black-port-royale-378744	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	GLOBE	GLOBE	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	84.99	0	84.99	26625-DEFAULT-l.jpg	84	26625-DEFAULT-m.jpg	Fusion Charcoal/Highrise	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	63	50-to-100	0.00	[empty string]	Globe Fusion Skate Shoe, Charcoal/Highrise	<p>Rugged, fully padded skate shoe</p> <p>+ Step-in sock liner</p> <p>+ TPR ollie reinforcement</p> <p>+ Globe's S-Trac™ sole pattern</p> <p>+ TPR heel stabilizer</p>	[empty string]	N	85	85	8,8.5,9,9.5,10,10.5,11,11.5,12,13,14	26625-DEFAULT-s.jpg	16	1000	GBFUS-15250	383560	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	globe/globe-fusion-skate-shoe-charcoal-highrise-383560	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	19.99	0	19.99	25753-DEFAULT-l.jpg	19	25753-DEFAULT-m.jpg	Cash On Tour Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	22	15-to-20	0.00	[empty string]	Stance Cash On Tour Johnny Cash Crew Sock	<p>The original badass of country music, Johnny Cash was larger than life. Celebrate the man in black and walk the line in Stance's Cash on Tour.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	20	20	Medium	25753-DEFAULT-s.jpg	26	1000	M556D18CAS	380181	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-cash-on-tour-johnny-cash-crew-sock-380181	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Bronze Brown,Chocolate	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	59.99	0	59.99	19569-DEFAULT-l.jpg	59	19569-DEFAULT-m.jpg	Draftsmen Leather Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FA16	[empty string]	OH at 200	[empty string]	197	50-to-100	0.00	[empty string]	Reef Draftsmen Leather Men's Sandal	<p>Style for the beach and beyond. You can get away with sandals at that classy dinner spot if they're the right sandals. These men's leather sandals are perfect for beach weddings. Who wears shoes on the beach? Reef Draftsmen sandals feature full grain premium leather footbed and upper, a “Blind Stich” strap construction that allows stitch-free strap, and a comfort EVA midsole that's highly abrasion resistant, so you can keep wearing them to nice eateries and save them for next wedding season. These sandals also feature molded Reef rubber outsole and secret weapon of the TQT (that's “Thirst Quenching Technology”) hidden bottle opener, to make sure it's a good party.</p>	[empty string]	N	59.99	59.99	7,8,9,10,11,12,13,14	19569-DEFAULT-s.jpg	35	1000	2611	272233	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-draftsmen-leather-mens-sandal-272233	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	49.99	0	49.99	4929-DEFAULT-l.jpg	49	4929-DEFAULT-m.jpg	Authentic Black/Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	SLIM	[empty string]	[empty string]	BLACK	[empty string]	SUMMER	[empty string]	[empty string]	[empty string]	152	25-to-50	0.00	[empty string]	Vans Authentic Skate Shoe, Black/Black	<p>The Authentic, Vans original and now iconic style, is a simple low top, lace-up with durable canvas upper, metal eyelets, Vans flag label and Vans original Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	4929-DEFAULT-s.jpg	38	1000	VN000EE3BKA	238892	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-authentic-skate-shoe-black-black-238892	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VANS Vans Old Skool Skate Shoe, Hot Sauce/True White $60.00 | view details

VANS Vans Jersey Lace Old Skool Skate Shoe, Black/Port Royale $65.00 | view details

GLOBE Globe Fusion Skate Shoe, Charcoal/Highrise $85.00 | view details

STANCE Stance Cash On Tour Johnny Cash Crew Sock $20.00 | view details

REEF Reef Draftsmen Leather Men's Sandal $59.99 | view details

VANS Vans Authentic Skate Shoe, Black/Black $50.00 | view details

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	SPITFIRE	SPITFIRE	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	39.99	0	39.99	26743-DEFAULT-l.jpg	39	26743-DEFAULT-m.jpg	F4 99 Overlay Radials Natural Whl 4- Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Spitfire Formula Four 99D Overlay Skateboard Wheels, 53mm	<p>Spitfire Formula Four 99D Overlay Skateboard Wheels, 53mm</p>	[empty string]	N	39.99	39.99	53MM	26743-DEFAULT-s.jpg	5	1000	2111018953	391807	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-skateboard-wheels-53mm-391807	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	179.99	0	179.99	26954-DEFAULT-l.jpg	179	26954-DEFAULT-m.jpg	Zeppelin Flagship Red Gum 18 Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Arbor Zeppelin Flagship Complete Longboard, 32"	<p>A performance mid-length drop-through shape for an exceptional carving experience and float through your turns.</p> <h4>DECK</h4> <ul> <li>7 Ply Hardrock Maple with a Premium Red Gum Wood Finish Ply</li> <li>Wood material comes from sustainable sources of supply</li> <li>Wood by-product is reclaimed for use in other products</li> </ul> <h4>TRUCKS</h4> <ul> <li>Paris Reverse 50° 180mm</li> </ul> <h4>TRUCKS</h4> <ul> <li>Arbor Easyrider Series - Mosh</li> <li>Perfect mix between quick acceleration and roll speed</li> <li>Good for cruising and carving on all size boards</li> <li>Size: 65mm // Durometer: 78a</li> <li>Contact Patch: 36.0mm // Offset: 0.0mm</li> <li>Momentum Core: Dampens bumpy rides</li> <li>Venice Formula: Soft and grippy</li> </ul> <h4>OTHER COMPONENTS</h4> <ul> <li>ABEC 7 Bearings with Spacers</li> <li>Recycled Glass Re-Grit</li> </ul>	[empty string]	N	179.95	179.95	32IN	26954-DEFAULT-s.jpg	10	1000	ARBL32002	393648	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	arbor/arbor-zeppelin-flagship-complete-longboard-32-393648	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	139.99	0	139.99	26410-DEFAULT-l.jpg	139	26410-DEFAULT-m.jpg	Nickel Faded Jammin Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Penny Skateboards Faded Jammin Complete Nickel Skateboard, 27"	<p>Penny's Jammin 27" is a vibrant and cheerful board that will always brighten your day! As part of the Painted Fades range, this board's deck fades between green, yellow and red. Cruise around the streets and show of your sense of fun as you make your mark to reveal the decks true yellow colour.</p> <ul> <li>27" Plastic Deck</li> <li>4-inch aluminum trucks with powder-coated finish</li> <li>59mm, 83A wheels for a smooth ride</li> <li>83A color-coded cushions</li> <li>Color-coded high tensile deck bolts</li> <li>Quality Color-coded Abec 7 stainless steel bearings</li> </ul>	[empty string]	N	139.99	139.99	27IN	26410-DEFAULT-s.jpg	14	1000	P27FDJAM-C	341709	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-faded-jammin-complete-nickel-skateboard-27-341709	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	MADNESS	MADNESS	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	56.99	0	56.99	27054-DEFAULT-l.jpg	56	27054-DEFAULT-m.jpg	Factory R7 8.6 Deck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Madness Factory White R7 Skateboard Deck, 8.625"	<p>MADNESS Factory White 8.625 R7 Skateboard Deck<br /> <em>Resin-7 Canadian Maple Construction </em><br /> Mellow Concave / Steep Kick<br /> 8.625" x 32.3" x 14.375" WB</p>	[empty string]	N	56.99	56.99	8.6	27054-DEFAULT-s.jpg	31	1000	10076014	392539	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	madness/madness-factory-white-r7-skateboard-deck-8625-392539	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	SPITFIRE	SPITFIRE	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	39.99	0	39.99	26745-DEFAULT-l.jpg	39	26745-DEFAULT-m.jpg	F4 99 Overlay Classic Fulls Pnk/Blu Whl	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Spitfire Formula Four 99D Overlay Pink/Blue Mashup Skateboard Wheels, 53mm	<p>Spitfire Formula Four 99D Overlay Pink/Blue Mashup Skateboard Wheels, 53mm</p>	[empty string]	N	39.99	39.99	53MM	26745-DEFAULT-s.jpg	35	1000	2111019253	391809	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-pink-blue-mashup-skateboard-wheels-53mm-391809	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	54.99	0	54.99	26321-DEFAULT-l.jpg	54	26321-DEFAULT-m.jpg	Dinghy Gin And Tonic Deck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Landyachtz Dinghy Gin and Tonic Cruiser Skateboard Deck, 28.5"	<p style="margin-left:0px; margin-right:0px; text-align:left">The dinghy has been our go to cruiser for nearly 20 years. Ideal for cruising the neighborhoods, beaches, and campuses of the world.  With our crew of skaters and engineers we’ve been able to design the trucks, wheels and deck together, creating the perfect off the shelf complete. Easy to learn on, and easy to shred if you’ve been skating for years. </p> <p style="margin-left:0px; margin-right:0px; text-align:left">Dave was never able to convince his friends that the bar tender actually put tiny jelly fish and sea horses in his cocktail. It seemed like a little bit like bulls&#t. He did manage to convince them to go to that same bar for a drink this weekend, we'll see what they report on Monday and let you know.</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist: </strong>Nicholas Barome</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 28.5" \| W: 8.5" \| WB: 15"</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck material:</strong> 7 Ply Canadian Maple<br /> <strong>Concave:</strong> Low <br /> <strong>Flex:</strong> Low <br /> <strong>Features:</strong> Boxy Kicktail, Wheel Wells, 100% Canadian Maple, Low Concave <br /> <strong>Setup:</strong> Polar Bear 105, 63mm Fatty Hawgs Grey/White swirl 78a, ¼” risers, Bear Spaceball bearings</p>	[empty string]	N	54.99	54.99	8.0	26321-DEFAULT-s.jpg	37	1000	DK-UBDYGNT	381064	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-dinghy-gin-and-tonic-cruiser-skateboard-deck-285-381064	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

SPITFIRE Spitfire Formula Four 99d Overlay Skateboard Wheels, 53mm $39.99 | view details

ARBOR Arbor Zeppelin Flagship Complete Longboard, 32 " $179.95 | view details

PENNY Penny Skateboards Faded Jammin Complete Nickel Skateboard, 27 " $139.99 | view details

MADNESS Madness Factory White R7 Skateboard Deck, 8.625 " $56.99 | view details

SPITFIRE Spitfire Formula Four 99d Overlay Pink/Blue Mashup Skateboard Wheels, 53mm $39.99 | view details

LANDYACHTZ Landyachtz Dinghy Gin And Tonic Cruiser Skateboard Deck, 28.5 " $54.99 | view details

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	74.99	0	74.99	26146-DEFAULT-l.jpg	74	26146-DEFAULT-m.jpg	Fcs Ii Carver Neo Glass Medium Tri - Lrg	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	50-to-100	0.00	[empty string]	FCS II Carver Neo Glass Tri-Fins - Large	<p>Powerful, drawn-out turns. Excels on open face waves.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for powerful, drawn-out turns with added hold.</li> <li>Elongated template with high degree of sweep provides exceptional hold off the bottom and when carving on the open face.</li> <li>Ideal for power surfers who like to push hard against their fins and draw out their turns.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Open face, down-the-line waves, particularly good in point and reef breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for boards with deep concaves and moderate-to-extreme rocker.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Carver: Find Power. Powerful, drawn-out turns with added hold.</li> </ul>	[empty string]	N	75	75	[empty string]	26146-DEFAULT-s.jpg	1	1000	FCAR-NG01-LG-TS-R	321359	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-carver-neo-glass-trifins-large-321359	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	119.99	0	119.99	26118-DEFAULT-l.jpg	119	26118-DEFAULT-m.jpg	Fcsii Carver Neo Glass Lg Tri- Quad Fins	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	4	100-to-150	0.00	[empty string]	FCS II Carver Neo Glass Tri-Quad Fins Set - Large	<p>Powerful, drawn-out turns. Excels on open face waves.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for powerful, drawn-out turns with added hold.</li> <li>Elongated template with high degree of sweep provides exceptional hold off the bottom and when carving on the open face.</li> <li>Ideal for power surfers who like to push hard against their fins and draw out their turns.</li> <li>Tri/Quad (5 fin) set</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Open face, down-the-line waves, particularly good in point and reef breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for boards with deep concaves and moderate-to-extreme rocker.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Carver: Find Power. Powerful, drawn-out turns with added hold.</li> </ul>	<p>FCS II Carver Neo Glass Large Tri-Quad Fins Set</p>	N	120	120	[empty string]	26118-DEFAULT-s.jpg	3	1000	FCAR-NG01-LG-FS-R	334611	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-carver-neo-glass-triquad-fins-set-large-334611	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	159.99	0	159.99	26246-DEFAULT-l.jpg	159	26246-DEFAULT-m.jpg	Firewire 5 Fin Honeycomb/Carbon Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Futures Firewire 5-Fin	<p>For 2018 we have updated the Firewire 5-fin. The template features a carbon fiber base for stiffness and ample drive, while the tip of the fins feature honeycomb and unidirectional carbon fiber, for a lively response out of your turns. These fins are designed to complement the Gamma, Sci-Fi, Omni, Cymatic, and other high-performance models. Grab your set today and take your Firewire to the next level.</p> <table cellspacing="0" class="specf-table" style="-webkit-text-stroke-width:0px; background-color:#ffffff; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; width:537.6px; word-spacing:0px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> <th style="text-align:left">Center Fin</th> <th style="text-align:left">Rear Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.70</td> <td>14.90</td> <td>12.85</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.90</td> <td>4.60</td> <td>4.35</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.50</td> <td>4.40</td> <td>4.10</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	160	160	[empty string]	26246-DEFAULT-s.jpg	6	1000	1017-465-50	381598	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-firewire-5fin-381598	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	42.99	0	42.99	4569-DEFAULT-l.jpg	42	4569-DEFAULT-m.jpg	Single Soft Racks Cam Lock	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	1	25-to-50	0.00	[empty string]	FCS Cam Lock Soft Racks Single	<p>Simple and strong, the FCS Cam Lock system will efficiently strap your boards down.</p> <p><strong>Overview</strong></p> <ul> <li>Holds 1-2 surfboards </li> <li>Square non-rolling pads</li> <li>Each pad width 445mm</li> <li>Fits most vehicles</li> <li>Heavy duty 25mm webbing</li> <li>Tough metal buckles</li> <li>Comes packaged in convenient zip storage pouch</li> <li>Contains 2 soft racks (with integrated strap)</li> </ul>	<p>FCS Cam Lock Single Soft Surfboard Racks - (PAIR)</p>	N	42.98	42.98	[empty string]	4569-DEFAULT-s.jpg	34	1000	1901-553-00B	210620	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-cam-lock-soft-racks-single-210620	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	VERTRA	VERTRA	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	22.99	0	22.99	2775-DEFAULT-l.jpg	22	2775-DEFAULT-m.jpg	Shelter Translucent Spf 50 Face Stick	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	6	20-to-25	0.00	[empty string]	Vertra SPF 50 Face Stick Sunblock, Translucent	<p>Lightweight, SPF 50+, foundation based sunscreen for the face. Optimum Broad Spectrum protection against skin damaging UVA rays and skin burning UVB rays. This Translucent formula glides on smoothly and blends evenly into the skin providing superior sun protection. A light ghosting of the skin reassures the user that the product is still active and in place. Water Resistant (80 minutes). Non-Greasy application. Designed, formulated and manufactured to the highest sunscreen and cosmetic industry standards.</p>	[empty string]	N	23	23	[empty string]	2775-DEFAULT-s.jpg	42	1000	V.PX.002.901.NS	235208	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	vertra/vertra-spf-50-face-stick-sunblock-translucent-235208	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Medieval Blue	QUIKSILVER	QUIKSILVER	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	29.99	0	29.99	26668-DEFAULT-l.jpg	29	26668-DEFAULT-m.jpg	Always There Ss Rashguard	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Quiksilver Always There Short Sleeve UPF 50 Rashguard	<ul> <li><strong>Recycled Fabric:</strong> Stretch polyester blend fabric</li> <li><strong>Fit:</strong> Snug fit</li> <li>UPF 50+ sun protection</li> <li>Chlorine-resistant properties</li> <li>Moisture-wicking properties</li> </ul> <p>Composition</p> <ul> <li> <p>92% Polyester, 8% Elastane</p> </li> </ul>	[empty string]	N	30	30	Small,Medium,Large,X-Large,XX-Large	26668-DEFAULT-s.jpg	46	1000	EQYWR03142	391054	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	quiksilver/quiksilver-always-there-short-sleeve-upf-50-rashguard-391054	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

FCS Fcs Ii Carver Neo Glass Tri- Fins - Large $75.00 | view details

FCS Fcs Ii Carver Neo Glass Tri- Quad Fins Set - Large $120.00 | view details

FUTURE FINS Futures Firewire 5- Fin $160.00 | view details

FCS Fcs Cam Lock Soft Racks Single $42.98 | view details

VERTRA Vertra Spf 50 Face Stick Sunblock, Translucent $23.00 | view details

QUIKSILVER Quiksilver Always There Short Sleeve Upf 50 Rashguard $30.00 | view details

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Carbon	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	134.99	0	134.99	25536-DEFAULT-l.jpg	134	25536-DEFAULT-m.jpg	Low Roller Bag	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FBA FILLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	SMU	2019	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Dakine Low Roller Snowboard Bag	<p>The Low Roller is the bag of choice for everything from a weekend trip at a nearby mountain, to a week-long dream trip epic. With 360-degree padding, it comfortably holds one board (or two boards with bindings removed), outerwear, and a removable boot bag in the main compartment. The exterior zippered accessory pocket stows essential items close at hand, keeping your entire kit secure and in one place. The handle pairs with a rolling luggage bag, for easy one-handed towing, while heavy-duty urethane wheels glide easily through airport terminals and parking lots.</p>	[empty string]	N	135	135	157,165,175	25536-DEFAULT-s.jpg	7	1000	10001463-C	357208	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-low-roller-snowboard-bag-357208	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Stencil Palm	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	24.99	0	24.99	25884-DEFAULT-l.jpg	24	25884-DEFAULT-m.jpg	Standard Rack Pads (Set 2)	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	20-to-25	0.00	[empty string]	Dakine Rack Pads 18" Car Rack Pads	<p>The Dakine Rack Pads fit your existing roof rack crossbars to provide padded protection for transporting surfboards. These 18-inch wide rack pads are sold in pairs and feature custom extruded foam covered with durable 600D polyester fabric, a hook and loop closure holds the foam in place.</p> <ul> <li>Set of two rack pads</li> <li>Custom extruded foam fits wide range of crossbars</li> <li>Durable 600D polyester fabric</li> <li>Hook and loop closure</li> </ul>	[empty string]	N	25	25	[empty string]	25884-DEFAULT-s.jpg	16	1000	8840310	220012	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-rack-pads-18-car-rack-pads-220012	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Black	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; MEN'S OUTERWEAR &GT; JACKETS	91.99	0	91.99	26082-DEFAULT-l.jpg	91	26082-DEFAULT-m.jpg	Corporate Zip Soft Shell Jacket	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Never Summer Corporate Zip Soft Shell Jacket	<p>Never Summer Corporate Zip Soft Shell Jacket</p>	[empty string]	N	89.99	91.99	X-Large,XX-Large	26082-DEFAULT-s.jpg	18	1000	ZIPCORPSS	374781	MENS OUTERWEAR	JACKETS	EMPTY	0	0	0	OUTERWEAR	never-summer/never-summer-corporate-zip-soft-shell-jacket-374781	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	124.99	0	124.99	25862-DEFAULT-l.jpg	124	25862-DEFAULT-m.jpg	Super Tune Tuning Kit	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Dakine Super Tune Tuning Kit	<p>With all the elements of our Deluxe Tune, and the addition of our Adjustable Temp Tuning Iron, the Super Tune Kit has everything you'll need for an entire season of ski or snowboard upkeep. From tuning and filing edges, to scraping, repairing, waxing, and polishing bases, it's the perfect kit to keep your ride in peak shredding condition throughout the year.</p>	[empty string]	N	125	125	[empty string]	25862-DEFAULT-s.jpg	34	1000	10001581-I	373471	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-super-tune-tuning-kit-373471	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	STONE	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	29.99	0	29.99	26193-DEFAULT-l.jpg	29	26193-DEFAULT-m.jpg	Stone Convertible Balaclava	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Fishmasks Convertible Ballerclava Balaclava, Stone	<p>Fishmasks Convertible Ballerclava Balaclava, Stone</p>	[empty string]	N	29.99	29.99	[empty string]	26193-DEFAULT-s.jpg	35	1000	FSH-CONV-STONE	359415	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-convertible-ballerclava-balaclava-stone-359415	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	WATERCAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26195-DEFAULT-l.jpg	19	26195-DEFAULT-m.jpg	Water Camo Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	20	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Water Camo	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	<p>Fishmasks Single Layer Neck Gaiter - Lightweight, Fishing Protection From Sun, Wind And Moisture - Made In USA - UPF 50+ Moisture-Wicking Fabric - Water Camo</p>	N	19.99	19.99	[empty string]	26195-DEFAULT-s.jpg	38	1000	FSH-SL-WATERCAMO	359383	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-water-camo-359383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

DAKINE Dakine Low Roller Snowboard Bag $135.00 | view details

DAKINE Dakine Rack Pads 18 " Car Rack Pads $25.00 | view details

NEVER SUMMER Never Summer Corporate Zip Soft Shell Jacket $89.99 to $91.99 | view details

DAKINE Dakine Super Tune Tuning Kit $125.00 | view details

FISHMASKS Fishmasks Convertible Ballerclava Balaclava, Stone $29.99 | view details

FISHMASKS Fishmasks Single Layer Neck Gaiter, Water Camo $19.99 | view details

Accessories

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	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	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Black/Black	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	37.99	0	37.99	26522-DEFAULT-l.jpg	37	26522-DEFAULT-m.jpg	The Norrland Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Arcade Norrland Belt, Black/Black	<p>The Arcade Norrland is a woven belt built to work hard, fit perfectly and always be comfortable. We wrapped elastic fibers with waxed cotton to give you a strong and secure fit with enough flexibility and performance to keep you operating at the highest level during the daily hustle. The Norrland’s braiding allows for a perfect fit with no awkwardly spaced holes. Top this off with a custom buckle and weatherproof trims you have a belt that is ready to take you from the office to the outdoors.</p> <ul> <li>Available in M, L, XL – See the sizing chart below</li> <li>Waxed Canvas & Elastic Webbing</li> <li>Custom metal alloy buckle</li> <li>Micro-adjustable</li> <li>Belt Width – 1.375″ (3.49cm)</li> </ul>	[empty string]	N	38	38	Medium,Large	26522-DEFAULT-s.jpg	1	1000	W44000-002	383738	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-norrland-belt-black-black-383738	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Blue	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	26757-DEFAULT-l.jpg	13	26757-DEFAULT-m.jpg	Alberta Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	48	10-to-15	0.00	[empty string]	Stance Alberta Classic Crew Sock	<p>Keep an eye out for any reptilian inhabitants on your next fan boat cruise across the 'Glade. Like our new friend Alberta here, they're prone to chomp.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	26757-DEFAULT-s.jpg	1	1000	M556A19ALB	383773	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-alberta-classic-crew-sock-383773	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	29.99	0	29.99	26042-DEFAULT-l.jpg	29	26042-DEFAULT-m.jpg	Kerfuffle Crystal/Blue Chrome	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Dot Dash Kerfuffle Sunglasses, Crystal/Light Blue Chrome	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	30	30	[empty string]	26042-DEFAULT-s.jpg	3	1000	DSVTFKER-CRX	314323	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-kerfuffle-sunglasses-crystal-light-blue-chrome-314323	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	SPY	SPY	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	109.99	0	109.99	26009-DEFAULT-l.jpg	109	26009-DEFAULT-m.jpg	Mccoy Soft Mat Blk/Red Fade Hgg Red	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Spy McCoy Sunglasses, Soft Matte Black/Red Fade/Happy Gray Green with Red Flash	<p>Part the 88 Dale Earnhardt Jr. collection, the McCoy harkens back to the speakeasies and moonshine runners who gave birth to NASCAR. Available with the Happy Lens™ and Trident™ polarization, the McCoy features a virtually indestructible Grilamid® construction and 88 Dale Jr. signature inside print.</p> <ul> <li>Available with the Happy Lens™ and Trident™ polarization</li> <li>88 Dale Jr. signature inside print</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>8-base polycarbonate ARC® lenses increase optical performance</li> <li>Sturdy and smooth 5-barrel hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 63-17-120</li> </ul>	[empty string]	N	110	110	[empty string]	26009-DEFAULT-s.jpg	3	1000	673012803673	373870	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	spy/spy-mccoy-sunglasses-soft-matte-black-red-fade-happy-gray-green-with-red-flash-373870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	MONBLU/MONBLU	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	37.99	0	37.99	26525-DEFAULT-l.jpg	37	26525-DEFAULT-m.jpg	The Norrland Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	17	25-to-50	0.00	[empty string]	Arcade Norrland Belt, Moon Blue/Moon Blue	<p>The Arcade Norrland is a woven belt built to work hard, fit perfectly and always be comfortable. We wrapped elastic fibers with waxed cotton to give you a strong and secure fit with enough flexibility and performance to keep you operating at the highest level during the daily hustle. The Norrland’s braiding allows for a perfect fit with no awkwardly spaced holes. Top this off with a custom buckle and weatherproof trims you have a belt that is ready to take you from the office to the outdoors.</p> <ul> <li>Available in M, L, XL</li> <li>Waxed Canvas & Elastic Webbing</li> <li>Custom metal alloy buckle</li> <li>Micro-adjustable</li> <li>Belt Width – 1.375″ (3.49cm)</li> </ul>	[empty string]	N	38	38	Medium,Large,X-Large	26525-DEFAULT-s.jpg	3	1000	W44000-420	384170	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-norrland-belt-moon-blue-moon-blue-384170	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Silver,Black	BILLABONG	BILLABONG	ACCESSORIES	ACCESSORIES &GT; HATS	29.99	0	29.99	26566-DEFAULT-l.jpg	29	26566-DEFAULT-m.jpg	Tech Stretch Flex Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	25	25-to-50	0.00	[empty string]	Billabong Tech Stretch Hat	<p>Your core staple with a modern stretch design. The solid 6-panel hat features a curved bill and heat transfer patch at the front panel.</p> <ul> <li>Stretch twill hat.</li> <li>Heat transfer patch at front.</li> <li>Stretch twill fabric.</li> <li>Custom jacquard sweatband.</li> <li>Curved brim.</li> <li>Fitted size.</li> </ul>	[empty string]	N	29.95	29.95	Small/Medium,Large/X-Large	26566-DEFAULT-s.jpg	4	1000	MAHWTBTE	382718	EMPTY	EMPTY	EMPTY	0	0	0	HATS	billabong/billabong-tech-stretch-hat-382718	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]