Tops

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

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	Coastal Blue	BILLABONG	BILLABONG	MENS	MENS &GT; TOPS &GT; T-SHIRTS	26.99	0	26.99	26974-DEFAULT-l.jpg	26	26974-DEFAULT-m.jpg	Parasol Ss T	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]	16	25-to-50	0.00	[empty string]	Billabong Parasol Tee	<p>A little groovy and little gritty, the Parasol Tee delivers a vintage print and Wave Wash. Treated with an overdye and heavy enzyme wash, the men’s short sleeve features a vintage look, finished with graphic prints at the chest and back. Made from premium cotton jersey, the custom t-shirt features a printed neck label for comfort.</p> <p>The nuts and bolts</p> <ul> <li>Mens short sleeve t-shirt.</li> <li>Wave Washed: overdyed with heavy enzyme wash.</li> <li>Graphic prints at chest and back.</li> <li>Crew neck.</li> <li>Short sleeves.</li> <li>Side seam flag label.</li> <li>Printed neck label.</li> <li>Premium fit: relaxed in the shoulders, body, and sleeves, offering a classic, comfortable fit.</li> <li>Material: 26/1, 170g jersey. <p> </p> </li> </ul> <h2> </h2> <h2> </h2>	[empty string]	N	26.95	26.95	Medium,Large,X-Large	26974-DEFAULT-s.jpg	3	1000	MT13TBPA	382785	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-parasol-tee-382785	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DOT DASH	DOT DASH	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	27.99	0	27.99	27200-DEFAULT-l.jpg	27	27200-DEFAULT-m.jpg	Portal Blk/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]	UPDATE	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Dot Dash Portal Sunglasses, Black/Grey Polarized	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>Polarized Lens</li> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	28	28	[empty string]	27200-DEFAULT-s.jpg	4	1000	DSLRFPOR-BKG	283112	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-portal-sunglasses-black-grey-polarized-283112	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	G-SHOCK	G-SHOCK	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	129.99	0	129.99	26300-DEFAULT-l.jpg	129	26300-DEFAULT-m.jpg	Ga700 Black/Rose Gold	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	100-to-150	0.00	[empty string]	G-Shock Analog-Digital Watch, Black/Rose Gold	<p>The iconic front button GA710 is available in an all new black and rose gold colorway. The shiny stainless steel front button on the GA710B-1A4 creates a look that is distinctive and accessory-like. Basic matte black coloring is offset by the rose gold accents of the buckles, hour markers, hour and minute hands, dials, and bezel lettering to add a distinctive touch of brilliant elegance. Features include stopwatch, countdown timer and alarm.</p> <ul style="margin-left:0px; margin-right:0px"> <li>Shock resistant</li> <li>200m water resistant</li> <li>LED light (Super illuminator)</li> <li>Selectable illumination duration (1.5 seconds or 3 seconds), afterglow</li> <li>World time</li> <li>31 time zones (48 cities + coordinated universal time), daylight saving on/off</li> </ul>	[empty string]	N	130	130	[empty string]	26300-DEFAULT-s.jpg	6	1000	GA710B-1A4	381658	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	g-shock/gshock-analogdigital-watch-black-rose-gold-381658	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	26012-DEFAULT-l.jpg	149	26012-DEFAULT-m.jpg	Rocky Soft Matte Blk/Happy Brz Pol Grn	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]	SP16	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Spy Rocky Sunglasses, Soft Matte Black/Happy Bronze Polar with Green Spectra	<p>Inspired by the iconic western mountain range, the Rocky takes high performance in a solid, aggressive frame to places others just can’t reach. With the detail- and mood-boosting Happy Lens™, the Rocky features a virtually indestructible Grilamid® construction, 100% UV protection, and small temple openings for a leash.</p> <ul> <li>Happy Lens™ enhances color and contrast, increases clarity, and improves mood and alertness</li> <li>Available with Trident™ polarization that eliminates reflective light</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>8x4-base polycarbonate toric lenses for optical superiority</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Small openings on each temple for easy leash attachment</li> <li>High-quality pin hinges</li> <li>Frame measures 64-15-130</li> </ul>	[empty string]	N	150	150	[empty string]	26012-DEFAULT-s.jpg	7	1000	673248973861	344510	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-rocky-sunglasses-soft-matte-black-happy-bronze-polar-with-green-spectra-344510	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPY	SPY	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	109.99	0	109.99	26011-DEFAULT-l.jpg	109	26011-DEFAULT-m.jpg	Discord Whitewall Hap Gry Grn Red Spc	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]	3	100-to-150	0.00	[empty string]	Spy Discord Sunglasses, Whitewall/Happy Gray Green with Red Spectra	<p>As big and bold as the era and music that inspired it, a little dissension goes a long way in this large-scale, ’80s-inspired piece. Available with the Happy Lens™ and Trident™ polarization, the Discord is constructed from virtually indestructible Grilamid® and features sturdy 5-barrel hinges, 6-base polycarbonate ARC® lenses, and 100% UV protection.</p> <ul> <li>Available with the color and contrast enhancing Happy Lens™ and Trident™ polarization</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>6-base polycarbonate ARC® lenses for increased optical performance</li> <li>Smooth and sturdy 5-barrel hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 57-17-145</li> </ul>	[empty string]	N	110	110	[empty string]	26011-DEFAULT-s.jpg	7	1000	673119209365	359702	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-discord-sunglasses-whitewall-happy-gray-green-with-red-spectra-359702	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; SHOES &GT; SKATE SHOES	49.99	0	49.99	25695-DEFAULT-l.jpg	49	25695-DEFAULT-m.jpg	Slip On Black And White Checker/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	REGULAR	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	248	25-to-50	0.00	[empty string]	Vans Classics Checkerboard Slip-On Skate Shoe, Black/Off-White Checkers	<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	25695-DEFAULT-s.jpg	8	1000	VN000EYEBWW	11420	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-classics-checkerboard-slipon-skate-shoe-black-offwhite-checkers-11420	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

BILLABONG Billabong Parasol Tee $26.95 | view details

DOT DASH Dot Dash Portal Sunglasses, Black/Grey Polarized $28.00 | view details

G-SHOCK G- Shock Analog- Digital Watch, Black/Rose Gold $130.00 | view details

SPY Spy Rocky Sunglasses, Soft Matte Black/Happy Bronze Polar With Green Spectra $150.00 | view details

SPY Spy Discord Sunglasses, Whitewall/Happy Gray Green With Red Spectra $110.00 | view details

VANS Vans Classics Checkerboard Slip- On Skate Shoe, Black/Off- White Checkers $50.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

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	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	271	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
2	[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	333	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
3	[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	909	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
4	[empty string]	NIXON	NIXON	WOMENS	WOMENS &GT; ACCESSORIES &GT; WATCHES	124.99	0	124.99	25662-DEFAULT-l.jpg	124	25662-DEFAULT-m.jpg	The Rival White/Charcoal	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	100-to-150	0.00	[empty string]	Nixon The Rival 38mm Watch, White/Charcoal	<p>For those who charge hard in and out of the water, the Rival is the go-to in the lineup. Featuring a high-contrast digital display wrapped in a bold bezel, free-swing band with a textured pattern to channel water, water resistant pushers, and 550 pre-programmed tide locations, the Rival never backs away from a challenge.</p>	[empty string]	N	125	125	[empty string]	25662-DEFAULT-s.jpg	2	1000	A12362015	375186	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-the-rival-38mm-watch-white-charcoal-375186	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	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	4	1000	CA11	371592	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	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]	2
6	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	17.99	0	17.99	25588-DEFAULT-l.jpg	17	25588-DEFAULT-m.jpg	Mineral Spf 30 Tinted 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]	138	15-to-20	0.00	[empty string]	Sun Bum Mineral SPF 30 Tinted Sunscreen Face Lotion, 1.7 oz.	<p>Some of us like to go as au naturel as possible, so we’re really proud to introduce our new zinc-based Mineral collection for your lounging and earth loving pleasure. Lightweight, silky, SPF 30 Mineral Tinted Sunscreen Face Lotion glides on like butter and provides a chemical free sunscreen and primer with a matte finish.</p>	[empty string]	N	17.99	17.99	[empty string]	25588-DEFAULT-s.jpg	4	1000	20-62330	377105	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-mineral-spf-30-tinted-sunscreen-face-lotion-17-oz-377105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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, Sunset Cove $5.99 $3.99 | view details

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

NIXON Nixon The Rival 38mm Watch, White/Charcoal $125.00 | view details

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

SUN BUM Sun Bum Mineral Spf 30 Tinted Sunscreen Face Lotion, 1.7 Oz. $17.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	64.99	0	64.99	27133-DEFAULT-l.jpg	64	27133-DEFAULT-m.jpg	Old Skool (Chambray) True Navy/True Wht	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]	NAVY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	73	50-to-100	0.00	[empty string]	Vans Chambray Old Skool Skate Shoe, True Canvas Navy/True White	<p>The Chambray Classic Slip-On features sturdy low profile textile and canvas uppers, padded collars, elastic side accents, and signature rubber waffle outsoles.</p> <p>SIZE DISPLAYED IN DROP DOWN IS BOYS/MENS<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	4.5,5.5,6,7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27133-DEFAULT-s.jpg	14	1000	VN0A38G1VIO	383093	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-chambray-old-skool-skate-shoe-true-canvas-navy-true-white-383093	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	KIDS	KIDS &GT; GIRLS &GT; SHOES	59.99	0	59.99	26790-DEFAULT-l.jpg	59	26790-DEFAULT-m.jpg	Comfycush Slip On True White/True White	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]	WHITE	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	72	50-to-100	0.00	[empty string]	Vans ComfyCush Slip-On Skate Shoe	<p>Vans has reinvigorated the classic Slip-On by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Slip-On a first-class fit that feels like walking on a cloud. Newly constructed canvas uppers house simplified one-piece interiors with added arch support and new moisture-wicking lining throughout, resulting in a lightweight experience that assures you’ll Keep It Comfy at all times.</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	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	26790-DEFAULT-s.jpg	89	1000	VN0A3WMDVNG	383079	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-comfycush-slipon-skate-shoe-383079	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Multi	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26807-DEFAULT-l.jpg	59	26807-DEFAULT-m.jpg	Sun Dream Tali Set	N	GIRLS	[empty string]	[empty string]	[empty string]	[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]	12	50-to-100	0.00	[empty string]	Billabong Girls' Sun Dream Tali Bikini Set	<p>Pick a bikini in full bloom or mix and clash with this reversible bikini set. The girls bikini features a top that reverses from striped to floral print, and a matching floral print bikini bottom. Both top and bottom are rimmed with strappy details for a modern look.</p>	[empty string]	N	59.95	59.95	5,7,8,10,12,14	26807-DEFAULT-s.jpg	91	1000	Y213TBSU	387572	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-girls-sun-dream-tali-bikini-set-387572	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Multi	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	9.99	0	9.99	25786-DEFAULT-l.jpg	9	25786-DEFAULT-m.jpg	Boy's Desert Dinos Sock	N	BOYS	[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]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Stance Desert Dinos Boys Kids Crew Sock	<p>Every boy loves dinosaurs. Inspire their inner paleontologist with Stance's Desert Dinos Boys.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Elastic 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	10	10	Large	25786-DEFAULT-s.jpg	98	1000	B526D18DES	380115	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-desert-dinos-boys-kids-crew-sock-380115	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Blue,Yellow	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25938-DEFAULT-l.jpg	8	25938-DEFAULT-m.jpg	C- Mono Retainer	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]	11	5-to-10	0.00	[empty string]	Costa Del Mar C-Mono Sunglasses Retainer	<p>Costa C-Mono™ Retainer. High tenacity monofilament. Sleek and ultra lightweight. Flat, low profile temple attachments.  <strong>End-to-End Measurement: </strong>20"</p>	[empty string]	N	8.99	8.99	[empty string]	25938-DEFAULT-s.jpg	108	1000	CM46	364615	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-cmono-sunglasses-retainer-364615	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Anchors	REEF	REEF	KIDS	KIDS &GT; GIRLS &GT; SANDALS	23.99	0	23.99	26671-DEFAULT-l.jpg	23	26671-DEFAULT-m.jpg	Kids Ahi Boys Sandal	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]	[empty string]	[empty string]	[empty string]	[empty string]	35	20-to-25	0.00	[empty string]	Reef Ahi Kids Sandal	<p>Slap time to nap time. Specifically designed for the kid who goes hard and has a good time. Many whimsical style prints to choose from, the Kids Ahi sandals feature synthetic strap with soft polyester lining, durable high-density EVA outsole for the grom who doesn't stop.</p> <ul> <li>Synthetic strap</li> <li>Webbing lining</li> <li>Printed EVA footbed</li> <li>High density EVA outsole</li> </ul>	[empty string]	N	24	24	13/1,2/3,4/5,6/7	26671-DEFAULT-s.jpg	155	1000	A3VBL	382325	SANDALS	EMPTY	EMPTY	0	0	0	GIRLS	reef/reef-ahi-kids-sandal-382325	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Chambray Old Skool Skate Shoe, True Canvas Navy/True White $65.00 | view details

VANS Vans Comfycush Slip- On Skate Shoe $60.00 | view details

BILLABONG Billabong Girls ' Sun Dream Tali Bikini Set $59.95 | view details

STANCE Stance Desert Dinos Boys Kids Crew Sock $10.00 | view details

COSTA DEL MAR Costa Del Mar C- Mono Sunglasses Retainer $8.99 | view details

REEF Reef Ahi Kids Sandal $24.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	Black	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	19.99	0	19.99	25741-DEFAULT-l.jpg	19	25741-DEFAULT-m.jpg	1972 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]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Stance 1972 Tour Pink Floyd Classic Crew Sock	<p>David Gilmour, Roger Waters, Rick Wright, Nick Mason. Celebrate the legendary Pink Floyd and their 1972 tour of Dark Side of the Moon with 1972 Tour. See you on the dark side of the moon!</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	25741-DEFAULT-s.jpg	9	1000	M556D18TOU	380180	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-1972-tour-pink-floyd-classic-crew-sock-380180	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Pink,Blue	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25763-DEFAULT-l.jpg	13	25763-DEFAULT-m.jpg	Dazed Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	SU18	[empty string]	OH at 200	[empty string]	13	10-to-15	0.00	[empty string]	Stance Dazed Classic Crew Sock	<p>Dazed from the Sun Dazed collection encompasses a place that often promotes well-being and relaxation. Combine positive energy, warmth of water, a little sunshine and you'll be in a "Sundazed" state of mind.</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>	<p>Stance Caged Socks (White, Medium)</p>	N	14	14	Large	25763-DEFAULT-s.jpg	16	1000	M556A18DAZ	368942	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-dazed-classic-crew-sock-368942	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25809-DEFAULT-l.jpg	13	25809-DEFAULT-m.jpg	Off My Wave Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	OH at 200	[empty string]	22	10-to-15	0.00	[empty string]	Stance Off My Wave Classic Crew Sock	<p>Locals only man! The Off My Wave sends a message loud and clear to those trying to snake in on your good times in the water and out.</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	25809-DEFAULT-s.jpg	16	1000	M556C18OMW	370516	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-off-my-wave-classic-crew-sock-370516	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Blue	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	15.99	0	15.99	25789-DEFAULT-l.jpg	15	25789-DEFAULT-m.jpg	Women's Animals Sock	N	WOMENS	[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]	12	15-to-20	0.00	[empty string]	Stance Animals Pink Floyd Women's Crew Sock	<p>Celebrate "Dogs", "Sheep" and "Pigs on the Wing" with Animals. Designed in honor of Pink Floyd's legendary album Animals this sock's sleek look is an instant classic for your sock stable.</p> <p>FEATURES</p> <ul> <li>Ultra Lite Cushion</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	16	16	Small,Medium	25789-DEFAULT-s.jpg	16	1000	W515D18ANI	380493	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-animals-pink-floyd-womens-crew-sock-380493	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Black/Shadow,Kona/Kona,Dark Java/Ray,Black/Black,BLUHAW/BLK,MUST/MUST,Dark Wood/Dark Wood,Stormy Blue/Black,Clay/Black,Husk/Clay,DKSHAD/DKSHAD,Stone/Stone,FOG/FOG,DPSTDPTHS/CHAR	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	64.99	0	64.99	6780-DEFAULT-l.jpg	64	6780-DEFAULT-m.jpg	Ohana	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]	[empty string]	[empty string]	OH at 200	[empty string]	409	25-to-50	0.00	[empty string]	OluKai Ohana Leather Sandal	<h3>FEATURES:</h3> <p>Laser-etched footbed logo and embroidered hook logo on the toe post overlay.</p> <h3>UPPER:</h3> <p>Water-resistant synthetic straps with ultra soft, quick-drying jersey knit lining and a soft nylon toe post.</p> <h3>FOOTBED:</h3> <p>Compression molded, EVA midsole with brushed drop-in ICEVA footbed provides anatomical fit for sustained comfort.</p> <h3>OUTSOLE:</h3> <p>Non-marking rubber outsole with coral reef lug design for added grip.</p>	[empty string]	N	45.99	65	7,8,9,10,11,12,13,14,15	6780-DEFAULT-s.jpg	25	1000	10110	238336	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	olukai/olukai-ohana-leather-sandal-238336	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DC	DC	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	99.99	0	99.99	26601-DEFAULT-l.jpg	99	26601-DEFAULT-m.jpg	Kalis S Black/White/Red	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]	SPRING	[empty string]	[empty string]	[empty string]	19	50-to-100	0.00	[empty string]	DC Kalis S Skate Shoes, Black/White/Red	<ul> <li>SUPER SUEDE™, nubuck, leather or textile upper [depending on colorway]</li> <li>Bootie construction for secure fit</li> <li>Molded TPR logo</li> <li>Mesh lining</li> <li>OrthoLite® footbed provides cushioning</li> <li>UniLite™ midsole for lightweight comfort and support</li> <li>Absorption abrasion resistant sticky rubber outsole</li> <li>DC's trademarked Pill Pattern tread <p> </p> </li> </ul>	[empty string]	N	100	100	8,8.5,9,9.5,10,10.5,11,11.5,12,13	26601-DEFAULT-s.jpg	32	1000	ADYS100470-XKWR	382974	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-kalis-s-skate-shoes-black-white-red-382974	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

STANCE Stance 1972 Tour Pink Floyd Classic Crew Sock $20.00 | view details

STANCE Stance Dazed Classic Crew Sock $14.00 | view details

STANCE Stance Off My Wave Classic Crew Sock $14.00 | view details

STANCE Stance Animals Pink Floyd Women's Crew Sock $16.00 | view details

OLUKAI Olukai Ohana Leather Sandal $45.99 to $65.00 | view details

DC Dc Kalis S Skate Shoes, Black/White/Red $100.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]	SECTOR 9	SECTOR 9	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	209.99	0	209.99	25564-DEFAULT-l.jpg	209	25564-DEFAULT-m.jpg	Fractal Cl 36in 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]	SMU	[empty string]	[empty string]	[empty string]	[empty string]	35	200-to-250	0.00	[empty string]	Sector 9 Fractal Complete Longboard, 36"	<p>Rides on 9" Gullwing Sidewinder II's with 69mm 78A Sector 9 top shelf wheels with PDP Abec 5 bearings The length of the Fractal is great for those looking for a longer wheelbase for cruising, but still want to do tight turns This board has the feel of a longboard, but produces tighter carves and lines than one would think 8 ply maple with CNC drop through mounting.</p> <ul> <li>Rides on 9" Gullwing Sidewinder II's with 69mm 78A Sector 9 top shelf wheels with PDP Abec 5 bearings</li> <li>The length of the Fractal is great for those looking for a longer wheelbase for cruising, but still want to do tight turns</li> <li>This board has the feel of a longboard, but produces tighter carves and lines than one would think</li> <li>8 ply maple with CNC drop through mounting</li> </ul>	[empty string]	N	209.99	209.99	36IN	25564-DEFAULT-s.jpg	6	1000	SF124-C	292986	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	sector-9/sector-9-fractal-complete-longboard-36-292986	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	69.99	0	69.99	26740-DEFAULT-l.jpg	69	26740-DEFAULT-m.jpg	Slasher Reissue	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	50-to-100	0.00	[empty string]	Santa Cruz Slasher Re-Issue Skateboard Deck, 10" x 31"	<p>Straight from the archives comes new Santa Cruz Re-Issues! Santa Cruz Skateboards is proud to release four new reissues! For the first time since it's original production, Jim Phillips' iconic "Slasher” graphic is back on its original shape and in a new, never before printed colorway. A must have for any fan of the 80’s. Hang this baby on your wall or set up a one of a kind skateboard. Either way, you won't be disappointed.</p>	[empty string]	N	69.99	69.99	10.1	26740-DEFAULT-s.jpg	8	1000	11115419	391905	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-slasher-reissue-skateboard-deck-10-x-31-391905	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	198.99	0	198.99	26314-DEFAULT-l.jpg	198	26314-DEFAULT-m.jpg	Battle Axe 40 Chill Bird 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]	5	150-to-200	0.00	[empty string]	Landyachtz Battle Axe 40 Chill Bird Complete Longboard, 40"	<p style="margin-left:0px; margin-right:0px; text-align:left">Despite the aggressive name, this board can be pretty dang chill. For those who want to casually cruise around town, <em>and</em> those who want to fulfill their dreams by carving up the streets like wild animals. The perfect combo of drop through truck mounting, rocker, and a little bit of flex make it easy and comfortable to ride. One of our most popular boards of all time.</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 40.25” I W: 9” I WB: 29.5” </p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong><strong>Artist:</strong> </strong>llllr</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck Material:</strong> 7 Ply Canadian Maple, 1 Bamboo middle ply<br /> <strong>Concave:</strong> Low<br /> <strong>Flex:</strong> Medium<br /> <strong>Profile:</strong> Rocker<br /> <strong>Grip:</strong> Black Adhesive with Vertical Die Cut and Printed Logo<br /> <strong>Features:</strong> 100% Canadian Maple, bamboo Core,  Drop Thru Mounting, Rocker, Low Concave, Clear Spray on Grip<br /> <strong>Setup:</strong> Bear Grizzly GR852, 70mm Hawgs Clear Red 78a, Bear Spaceball Bearings</p>	[empty string]	N	199	199	40IN	26314-DEFAULT-s.jpg	20	1000	CP-FRBA40	369743	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	landyachtz/landyachtz-battle-axe-40-chill-bird-complete-longboard-40-369743	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	28	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]
5	[empty string]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	129.99	0	129.99	26425-DEFAULT-l.jpg	129	26425-DEFAULT-m.jpg	Nickel Ripple 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]	1	100-to-150	0.00	[empty string]	Penny Skateboards Ripple Complete Nickel Skateboard, 27"	<p>Continuing Penny's history of partnering with like-minded artists, brands, and creators, we are excited to collaborate with Oceanside, California surfer/artist Mitchell King. Mitch's art uses a color palette heavily inspired by the natural world and incorporates repetition of shape, giving the illusion of visual movement. The 27" Ripple features Mitch's signature circular pattern with blues, tans, and burnt orange in a striking centered graphic. Blue/Raw trucks and grey wheels complete this work of art.</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	129.99	129.99	27IN	26425-DEFAULT-s.jpg	36	1000	PNYCOMP27430	374204	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-ripple-complete-nickel-skateboard-27-374204	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	34.99	0	34.99	25934-DEFAULT-l.jpg	34	25934-DEFAULT-m.jpg	Deathbox Spf 81b 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]	12	25-to-50	0.00	[empty string]	Bones Deathbox SPF 81b Skateboard Wheels	<p>Skatepark Formula™ (SPF) is very high quality urethane specifically formulated to resist flatspotting on slick or smooth surfaces while maintaining a higher rebound for a quicker response and a faster roll.</p> <p>Skatepark Formula™ has a high resistance to abrasion while not compromising hardness and slide ability. Simply put… Skatepark Formula wheels grip better on slick surfaces, are almost impossible to flatspot, and are the fastest, longest lasting wheel on the market today.</p> <p>You won’t find our Skatepark Formula from any other wheel supplier so get a set and find out for yourself what the word on SPF is all about.</p>	[empty string]	N	34.99	34.99	54MM,55MM,56MM,60MM	25934-DEFAULT-s.jpg	48	1000	WSCABS02	376340	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-deathbox-spf-81b-skateboard-wheels-376340	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SECTOR 9 Sector 9 Fractal Complete Longboard, 36 " $209.99 | view details

SANTA CRUZ Santa Cruz Slasher Re- Issue Skateboard Deck, 10 " X 31 " $69.99 | view details

LANDYACHTZ Landyachtz Battle Axe 40 Chill Bird Complete Longboard, 40 " $199.00 | view details

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

PENNY Penny Skateboards Ripple Complete Nickel Skateboard, 27 " $129.99 | view details

BONES Bones Deathbox Spf 81b Skateboard Wheels $34.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	129.99	0	129.99	6172-DEFAULT-l.jpg	129	6172-DEFAULT-m.jpg	V- 2 Pc Tri- Quad Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	T	[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]	FCS V2 Performance Core Tri-Quad Fins - Medium	<p>Designed for fast, critical surfing. Suits hollow steep waves, and punchy beach breaks.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for fast, critical surfing.</li> <li>The upright, pivotal side fin template produces quick start-up acceleration and allows for tight turns in the pocket.</li> <li>Based on the FCS Kelly Slater K2.1 template.</li> <li>Tri-Quad (5 fin) set.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li> <p>Hollow steep waves, punchy beach breaks.</p> </li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>All board types.</li> <li>Will fit the FCS II Fin System when used with grub screws and the FCS Infill Kit.</li> </ul>	<p>FCS K2.1 V-2 Performance Core Surfboard Fins - Quad. A great all round performing quad set. A balance of flow and stabilty, combined with response.</p>	N	130	130	[empty string]	6172-DEFAULT-s.jpg	11	1000	1120-156-28-R	257919	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-v2-performance-core-triquad-fins-medium-257919	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VERTRA	VERTRA	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	22.99	0	22.99	2773-DEFAULT-l.jpg	22	2773-DEFAULT-m.jpg	Shane Dorian Face Stick Kona Gold	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]	3	20-to-25	0.00	[empty string]	Vetra Face Stick SD SPF 38, Kona Gold – Shane Dorian’s Signature Tint, .39 OZ	<p>The Kona Gold is Shane Dorian’s Signature stick and provides the ultimate Broad Spectrum protection against skin aging UVA rays and skin burning UVB rays. An infusion of beige and yellow tints were color matched to his skin tone. Shane was personally involved in every stage of the development of this product – From research and development, color selection and even the choice of a light, citrus fragrance, which reminded him of the fruit trees in his back yard in Kailua, Kona, Hawaii. Water Resistant (80 minutes). Broad Spectrum. Non-Greasy application. Designed, formulated and manufactured to the highest sunscreen and cosmetic industry standards.</p>	[empty string]	N	23	23	[empty string]	2773-DEFAULT-s.jpg	27	1000	V.PX.004.202.NS	235210	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	vertra/vetra-face-stick-sd-spf-38-kona-gold-shane-dorians-signature-tint-39-oz-235210	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Navy,White,Black	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; MEN'S	39.99	0	39.99	26973-DEFAULT-l.jpg	39	26973-DEFAULT-m.jpg	Union Wave Pf Ls	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]	OH at 200	[empty string]	53	25-to-50	0.00	[empty string]	Billabong Union Wave Performance Fit Long Sleeve Rashguard	<p>Bring together a modern Billabong logo and core long sleeve rashguard. The performance fit Union rashguard delivers UPF 50+ sun protection with ergonomic seams and a silky smooth fabric.</p> <p>The nuts and bolts</p> <ul> <li>Mens long sleeve rashguard.</li> <li>Traditional mock neck.</li> <li>Silky-smooth feel.</li> <li>Billabong logo at center chest and sleeve.</li> <li>50+ UPF sun protection.</li> <li>B-Lock super flex stitch.</li> <li>Material: 6 oz silk touch fabric. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	39.95	39.95	Small,Medium,Large,X-Large,XX-Large	26973-DEFAULT-s.jpg	32	1000	MR62TBUN	382776	LONG SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	billabong/billabong-union-wave-performance-fit-long-sleeve-rashguard-382776	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	104.99	0	104.99	26249-DEFAULT-l.jpg	104	26249-DEFAULT-m.jpg	Hs2 V2 Foil Medium Thruster	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]	Futures HS2 Hayden Shapes Generation Series Tri-Fins	<p>The HS2 Generation Series, designed by Hayden Cox of Haydenshapes, is a medium size Speed Generating fin with a Ride Number of 8.3. The latest in speed generating fins, the Gen Series features a V2 foil for fluidity and a unique blend of uni-directional carbon and fiberglass for a more stable flex pattern. Similar feel to Blackstix, but a bit more subtle for those just transitioning onto foiled fins.</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> </tr> <tr> <td style="width:134.4px">Area</td> <td>14.54</td> <td>14.54</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.45</td> <td>4.45</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.45</td> <td>4.45</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>V2</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	105	105	[empty string]	26249-DEFAULT-s.jpg	33	1000	2486-435-00	341105	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-hs2-hayden-shapes-generation-series-trifins-341105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Irons Black,GRNT,Carbon,Resin,CBN/PNK,Scout	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	23.99	0	23.99	25886-DEFAULT-l.jpg	23	25886-DEFAULT-m.jpg	5 ` Pro Comp Leash	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]	21	20-to-25	0.00	[empty string]	Dakine Procomp 5' X 3/16" Surf Leash	<p>The Procomp surf leash offers the maximum strength possible with minimal resistance for up to shoulder high surf. This everyday leash will keep your board safely attached with the least drag possible thanks to the strong 3/16-inch urethane Dura-Cord. Dakine's longtime history innovating surf leashes is apparent in the use of marine grade stainless steel swivels, a 1.5-inch molded neoprene cuff, and Opti-Flex leash ends which combine for a super efficient, comfortable and durable leash. The Procomp is offered in both 5- and 6-foot lengths.</p> <ul> <li>Up to a shoulder high intended use</li> <li>3/16" (5MM) highest quality urethane Dura-Cord for maximum strength</li> <li>1.5" (40MM) molded neoprene ankle cuff</li> <li>Posi-Lock hook & loop closure</li> <li>Redesigned molded Opti-Flex leash ends for maximum durability</li> </ul>	[empty string]	N	24	24	[empty string]	25886-DEFAULT-s.jpg	34	1000	10001100	350989	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dakine/dakine-procomp-5-x-3-16-surf-leash-350989	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DORSAL	DORSAL	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	25.99	0	25.99	26063-DEFAULT-l.jpg	25	26063-DEFAULT-m.jpg	Aero Sup Surf Rack Pads 28 Inch Long - 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]	OH at 200	[empty string]	63	25-to-50	0.00	[empty string]	Dorsal Aero Roof Rack Pads for Car - Kayak, SUP, Snowboard, Surf - 28"	<p><strong>Are You Looking For An Effective And Efficient Way To Convey Surfboards, Snowboards and most Kayaks, As Well As Stand-Up Paddle Boards</strong></p> <p><strong>Start Using the Dakine Thule and Yakima Wide Flat bar Compatible Dorsal SUP Rack Pads Set, Armed With Essential Features That Make This Product Apart From The Rest.</strong></p> <ul> <li> <ul> <li> <p><strong>Easy Convey Of Surfboards, Kayaks, As Well As Stand-Up Paddle Boards</strong> This 28 inch (Dakine Style) Dorsal SUP Rack Pads set offer an effective way to convey surf boards, snowboards, kayaks, as well as stand-up paddle boards.</p> </li> <li> <p><strong>Fits Aero</strong> (Flat Bar) 5.5" - 8.0" [ 14-20cm ] bar circumference. For Square or Round Bar See Dorsal's Round Bar Pads (see diagram).</p> </li> <li> <p><strong>Reliable Material For Longer Life</strong> - This rack pads set is integrated with top grade EVA foam and is secured by a weather proof nylon sleeve. It comes with pads that will secure a kayak or board from your cars cross bars. This is also perfect for bigger surfboard roof rack transport in a smooth aerodynamic style. This is wide enough to transport surfboard with care.</p> </li> <li> <p><strong>Securing Your Surf Boards</strong> - Keep your surf board secure and safe for the next journey with the amazing and state of the art Dorsal Origin Car Surf Kayak SUP Rack Pads; which is made of with durable 600D polyester material. Top of the bar is padded for sleek fit. It comes with heavy duty velcro, 28 inches long pad as well as it fits a lot of factory auto car racks.</p> </li> </ul> </li> </ul>	[empty string]	N	25.94	25.94	[empty string]	26063-DEFAULT-s.jpg	41	1000	DORSAL-ORIGIN-BW-RACK-PAD	368237	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dorsal/dorsal-aero-roof-rack-pads-for-car-kayak-sup-snowboard-surf-28-368237	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 V2 Performance Core Tri- Quad Fins - Medium $130.00 | view details

VERTRA Vetra Face Stick Sd Spf 38, Kona Gold – Shane Dorian ’ S Signature Tint,.39 Oz $23.00 | view details

BILLABONG Billabong Union Wave Performance Fit Long Sleeve Rashguard $39.95 | view details

FUTURE FINS Futures Hs2 Hayden Shapes Generation Series Tri- Fins $105.00 | view details

DAKINE Dakine Procomp 5 ' X 3/16 " Surf Leash $24.00 | view details

DORSAL Dorsal Aero Roof Rack Pads For Car - Kayak, Sup, Snowboard, Surf - 28 " $25.94 | 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	WATER	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26183-DEFAULT-l.jpg	19	26183-DEFAULT-m.jpg	Water Single Layer Neck Gaiter	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]	SP17	[empty string]	OH at 200	[empty string]	78	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Water	<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</p>	N	19.99	19.99	[empty string]	26183-DEFAULT-s.jpg	5	1000	FSH-SL-WATER	359382	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-water-359382	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GOPRO	GoPro	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	19.99	0	19.99	19776-DEFAULT-l.jpg	19	19776-DEFAULT-m.jpg	Surf Mounts	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]	8	15-to-20	0.00	[empty string]	GoPro Surf Mounts	<p>Mount your GoPro to surfboards, kayaks, SUPs, boat decks and other gear where maximum holding strength is needed. Includes an FCS compatible male plug to mount your GoPro using an FCS center fin socket.</p> <ul> <li>Perfect for surfboards, kayaks, SUPs, boat decks and more</li> <li>Ideal for activities where maximum holding strength is needed</li> <li>Includes FCS compatible plug for mounting to FCS center fin socket</li> <li>Includes adhesive anchors and camera tethers for enhanced security<br />  </li> </ul>	[empty string]	N	19.99	19.99	[empty string]	19776-DEFAULT-s.jpg	7	1000	ASURF-001	279381	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	gopro/gopro-surf-mounts-279381	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	509.99	0	509.99	26345-DEFAULT-l.jpg	509	26345-DEFAULT-m.jpg	Wmns Proto Type Two	N	WOMENS	[empty string]	[empty string]	[empty string]	[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]	11	500-and-over	0.00	[empty string]	Never Summer Proto Type Two Women's Snowboard, 2019	<p>The Women’s Proto Type Two is the perfect all around asymmetrical twin. It features a new progressive shape, deeper heelside sidecut, Ripsaw Rocker Camber Profile and a perfect mid flex. It’s the most versatile board you’ll ever ride. Pop in and out of the park, carve the steeps and maneuver through trees like you’re riding three different boards. The Women’s Proto is exactly your type.</p>	[empty string]	N	509.99	509.99	145,148,151	26345-DEFAULT-s.jpg	20	1000	WPROTO2-I	374755	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-proto-type-two-womens-snowboard-2019-374755	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	519.99	0	519.99	26356-DEFAULT-l.jpg	519	26356-DEFAULT-m.jpg	Warlock X	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	500-and-over	0.00	[empty string]	Never Summer Warlock X Snowboard, 2019	<p>The true twin Warlock features our Original Rocker Camber Profile, a powerful flex pattern, and incredible park performance. Additional carbon was added outside the bindings to provide insane lift off and perfect landings. Soft flex between the feet and torsionally rigid nose and tail make for pinpoint turning and amazing pressability. Add to that the Warlock’s playful, forgiving feel and the result is freestyle wizardry. X - Wide version of the original.</p>	[empty string]	N	519.99	519.99	153,159	26356-DEFAULT-s.jpg	32	1000	WARLOCKX-I	374741	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-warlock-x-snowboard-2019-374741	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	569.99	0	569.99	26375-DEFAULT-l.jpg	569	26375-DEFAULT-m.jpg	Big Gun	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]	3	500-and-over	0.00	[empty string]	Never Summer Big Gun Snowboard, 2019	<p>Thrill Seeker / Carve Type: Colossal // The Big Gun was made big for the biggest style. 19mm of big taper with huge surface area, the Big Gun is stabilization. But here’s the hook...the Big Gun is as responsive as your short board! Built big but ridden nimble. When you’re gunning for ocean motion the size matters.</p>	[empty string]	N	569.99	569.99	169,174	26375-DEFAULT-s.jpg	41	1000	BIGGUN-I	374708	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-big-gun-snowboard-2019-374708	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	SNOWBOARDING	SNOWBOARDING &GT; GOGGLES	159.99	0	159.99	25969-DEFAULT-l.jpg	159	25969-DEFAULT-m.jpg	Egg Dark Side Tort/Jet Black	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]	3	150-to-200	0.00	[empty string]	Electric Egg Ski/Snowboard Goggles, Dark Side Tort/Jet Black	<p>Electric Egg Ski / Snowboard Goggles, Dark Side Tort/Jet Black</p>	[empty string]	N	160	160	[empty string]	25969-DEFAULT-s.jpg	51	1000	EG2418203-JBLK	374595	EMPTY	EMPTY	EMPTY	0	0	0	GOGGLES	electric/electric-egg-ski-snowboard-goggles-dark-side-tort-jet-black-374595	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

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

GoPro Gopro Surf Mounts $19.99 | view details

NEVER SUMMER Never Summer Proto Type Two Women's Snowboard, 2019 $509.99 | view details

NEVER SUMMER Never Summer Warlock X Snowboard, 2019 $519.99 | view details

NEVER SUMMER Never Summer Big Gun Snowboard, 2019 $569.99 | view details

ELECTRIC Electric Egg Ski/Snowboard Goggles, Dark Side Tort/Jet Black $160.00 | 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	[empty string]	COSTA DEL MAR	COSTA DEL MAR	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	8.99	0	8.99	26205-DEFAULT-l.jpg	8	26205-DEFAULT-m.jpg	C- Mono Retainer Green	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]	37	5-to-10	0.00	[empty string]	Costa Del Mar C-Mono Sunglasses Holder, Green	<p><strong>DESCRIPTION:</strong><br /> Costa C-Mono Retainer.</p> <p><strong>FEATURES</strong><br /> High-Tenacity Monofilament.<br /> Sleek<br /> Ultra-lightweight<br /> Flat, Low-Profile Temple Attachments<br /> End-to-End Measurement: 20"<br />  </p>	[empty string]	N	8.99	8.99	[empty string]	26205-DEFAULT-s.jpg	2	1000	CM17	386614	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	costa-del-mar/costa-del-mar-cmono-sunglasses-holder-green-386614	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Chub	FISHMASKS	FISHMASKS	ACCESSORIES	ACCESSORIES &GT; FACEMASKS	19.99	0	19.99	25541-DEFAULT-l.jpg	19	25541-DEFAULT-m.jpg	Chub Single Layer Neck Gaiter	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]	SMU	SU17	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Chub	<h6><em>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</em></h6>	[empty string]	N	19.99	19.99	[empty string]	25541-DEFAULT-s.jpg	3	1000	FSH-SL-CHUB	382012	EMPTY	EMPTY	EMPTY	0	0	0	FACEMASKS	fishmasks/fishmasks-single-layer-neck-gaiter-chub-382012	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	26779-DEFAULT-l.jpg	13	26779-DEFAULT-m.jpg	Dipped 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]	34	10-to-15	0.00	[empty string]	Stance Dipped Classic Crew Sock	<p>Making sure you stay Dipped and fresh to death in monochromatic checker print and palm trees. One-up!</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	26779-DEFAULT-s.jpg	3	1000	M556A19DPP	383788	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-dipped-classic-crew-sock-383788	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	ACCESSORIES	ACCESSORIES	9.99	0	9.99	26216-DEFAULT-l.jpg	9	26216-DEFAULT-m.jpg	Halyard Wire Retainer Silv/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]	36	5-to-10	0.00	[empty string]	Costa Del Mar Haylard Wire Retainer, Silver/Blue	<p><strong>DESCRIPTION:</strong><br /> Halyard Wire Retainer.</p> <p><strong>FEATURES</strong><br /> Ultra-Thin<br /> Lightweight Wire<br /> Heavy Duty Grip<br /> End-to-End Measurement: 20"</p>	[empty string]	N	9.99	9.99	[empty string]	26216-DEFAULT-s.jpg	8	1000	HY18	363722	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	costa-del-mar/costa-del-mar-haylard-wire-retainer-silver-blue-363722	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Black,Grey	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; HATS	31.99	0	31.99	26828-DEFAULT-l.jpg	31	26828-DEFAULT-m.jpg	No Zone Safari 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]	10	25-to-50	0.00	[empty string]	Dakine No Zone Boonie Hat	<p>Flat water or surf, you need to create your own shade on the water. Our wide-brim No Zone Hat delivers sun coverage in a ventilated water-friendly design. An adjustable chinstrap defies the wind, while foam brim inserts keep it afloat should it get away.</p>	[empty string]	N	32	32	One Size	26828-DEFAULT-s.jpg	8	1000	10002458-I	383603	EMPTY	EMPTY	EMPTY	0	0	0	HATS	dakine/dakine-no-zone-boonie-hat-383603	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUN BUM	SUN BUM	ACCESSORIES	ACCESSORIES &GT; HAIR CARE	14.99	0	14.99	27126-DEFAULT-l.jpg	14	27126-DEFAULT-m.jpg	Anti- Frizz Mist Spray	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]	28	10-to-15	0.00	[empty string]	Sun Bum Protecting / Anti-Frizz Oil Mist, 3 oz.	<p>We don't like frizz (who does?), so we love this super lightweight oil mist that uses Kukui Nut Oil and Tamanu Oil to help keep the humidity (and frizz) at bay.</p> <p>Our Protecting Anti-Frizz Oil Mist delivers a lightweight blend of Kukui Nut Oil and Tamanu Oil that helps protect hair against humidity and frizz, and boosts hair's natural shine. The fine misting spray is perfect for all hair types, from fine to thick. Absorbs quickly to help smooth hair, making your hair feel soft and look healthy.</p> <p>Cruelty Free, Vegan, Gluten Free, Color Safe, Paraben Free, Phthalate Free, UV-Protecting, Product of USA</p>	[empty string]	N	14.99	14.99	[empty string]	27126-DEFAULT-s.jpg	11	1000	80-41370	394947	EMPTY	EMPTY	EMPTY	0	0	0	HAIR CARE	sun-bum/sun-bum-protecting--antifrizz-oil-mist-3-oz-394947	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]