Salty Crew Frenzy Retro Trucker Hat

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	[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	5	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]
2	Navy	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	25757-DEFAULT-l.jpg	13	25757-DEFAULT-m.jpg	Chicken Scratch 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]	45	10-to-15	0.00	[empty string]	Stance Chicken Scratch Classic Crew Sock	<p>They say when a Rooster struts in as one's Spirit Animal, the mind, body, and spirit can be on their way to great improvement. Introducing the Chicken Scratch.</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	25757-DEFAULT-s.jpg	5	1000	M556C18CHS	370570	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-chicken-scratch-classic-crew-sock-370570	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Light Blue,White	SALTY CREW	SALTY CREW	MENS	MENS &GT; TOPS &GT; T-SHIRTS	28.99	0	28.99	26734-DEFAULT-l.jpg	28	26734-DEFAULT-m.jpg	El Dorado L/S Tee	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]	COTTON	[empty string]	[empty string]	FA19	[empty string]	[empty string]	[empty string]	30	25-to-50	0.00	[empty string]	Salty Crew El Dorado Long Sleeve T-Shirt	<p>Standard fit long sleeve t-shirt</p> <p>Front, back, and sleeve graphics</p> <p>100% cotton jersey</p>	[empty string]	N	28.5	28.5	Small,Medium,Large,X-Large,XX-Large	26734-DEFAULT-s.jpg	7	1000	20135071	383298	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	salty-crew/salty-crew-el-dorado-long-sleeve-tshirt-383298	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Sky Gray,Stone Wash,White	QUIKSILVER	QUIKSILVER	MENS	MENS &GT; TOPS &GT; T-SHIRTS	27.99	0	27.99	26651-DEFAULT-l.jpg	21	26651-DEFAULT-m.jpg	Mw Logo Ss 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]	18	20-to-25	0.00	[empty string]	Quiksilver MW Logo Tee	<ul> <li>Lightweight ring spun combed cotton jersey</li> <li>Classic, comfortable regular fit</li> <li>Crew neckline</li> </ul> <p>Composition</p> <ul> <li> <p>100% Cotton</p> </li> </ul>	[empty string]	N	22	22	Small,Medium,Large,X-Large,XX-Large	26651-DEFAULT-s.jpg	7	1000	AQYZT05910	383357	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	quiksilver/quiksilver-mw-logo-tee-383357	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DOT DASH	DOT DASH	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	37.99	0	37.99	26052-DEFAULT-l.jpg	37	26052-DEFAULT-m.jpg	Plimsoul Blk Satin/Gry Polarized	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]	18	25-to-50	0.00	[empty string]	Dot Dash Plimsoul Sunglasses, Black Satin/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>Base-6 Polycarbonate Lens</li> <li>Polycarbonate Frame</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	38	38	[empty string]	26052-DEFAULT-s.jpg	8	1000	DSVTFPLI-BSP	312697	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-plimsoul-sunglasses-black-satin-grey-polarized-312697	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; SHOES &GT; SKATE SHOES	74.99	0	74.99	26607-DEFAULT-l.jpg	74	26607-DEFAULT-m.jpg	Net Se Black/Black/White	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/WHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	DC Court Graffik SE Skate Shoes, Black/Black/White	<p>The nuts and bolts</p> <ul> <li>Leather or textile upper materials</li> <li>Lightweight mesh tongue</li> <li>Foam padded tongue and collar for added comfort and support</li> <li>Ventilation holes for breathability</li> <li>DC's trademarked Pill Pattern tread</li> <li>Cupsole construction</li> </ul>	[empty string]	N	75	75	9,9.5,10,10.5,11,11.5,12,13	26607-DEFAULT-s.jpg	9	1000	302297-XKKW	382988	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-court-graffik-se-skate-shoes-black-black-white-382988	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

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

STANCE Stance Chicken Scratch Classic Crew Sock $14.00 | view details

SALTY CREW Salty Crew El Dorado Long Sleeve T- Shirt $28.50 | view details

QUIKSILVER Quiksilver Mw Logo Tee $22.00 | view details

DOT DASH Dot Dash Plimsoul Sunglasses, Black Satin/Grey Polarized $38.00 | view details

DC Dc Court Graffik Se Skate Shoes, Black/Black/White $75.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	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	320	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	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]	141	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	759	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
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]	139	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	807	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	Fog Blue/Multi	ARCADE	ARCADE	WOMENS	WOMENS &GT; ACCESSORIES	25.99	0	25.99	25905-DEFAULT-l.jpg	25	25905-DEFAULT-m.jpg	The Ranger Belt	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]	STRETCH	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	29	25-to-50	0.00	[empty string]	Arcade Ranger Belt, Heather Fog Blue/Multi	<p>Lightweight, low-profile and stretch make the Arcade Ranger LTD the perfect belt for all your adventures. A superior fit and ultimate comfort come from an elastic stretch webbing that is durable and strong. This adventure belt has one size fits all sizing thanks to a micro-adjust belt buckle. No metal, no worries, this belt makes airport security a breeze. Built from machine washable materials means you can leave the belt in your pants on laundry day.</p> <ul> <li>One size fits most, up to 40″ (101.6cm)</li> <li>Travel-Friendly</li> <li>Washer/Dryer safe</li> <li>Belt width – 1.5″ (3.81cm)</li> </ul>	[empty string]	N	26	26	[empty string]	25905-DEFAULT-s.jpg	2	1000	A11102-94	384913	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-ranger-belt-heather-fog-blue-multi-384913	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Black,Amethyst	DAKINE	DAKINE	WOMENS	WOMENS &GT; ACCESSORIES &GT; BEANIES	29.99	0	29.99	25881-DEFAULT-l.jpg	29	25881-DEFAULT-m.jpg	Wmns Tiffany Pom Beanie	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]	5	25-to-50	0.00	[empty string]	Dakine Tiffany Women's Beanie	<p>The light wanes, the temperature drops, but you'll stay cozy in this knit beanie. A wool-blend knit with a full fleece lining warms your dome with pom style.</p>	[empty string]	N	30	30	[empty string]	25881-DEFAULT-s.jpg	4	1000	10002121-I	373183	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-tiffany-womens-beanie-373183	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GOPRO	GoPro	WOMENS	WOMENS &GT; ACCESSORIES &GT; VIDEO AND AUDIO	14.99	0	14.99	23751-DEFAULT-l.jpg	14	23751-DEFAULT-m.jpg	Vented Helmet Strap Mount	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	10-to-15	0.00	[empty string]	GoPro Vented Helmet Strap Mount	<p>Attach your GoPro to a vented bike, ski, kayak or other helmet. </p>	[empty string]	N	14.99	14.99	[empty string]	23751-DEFAULT-s.jpg	5	1000	GVHS30	288612	VIDEO AND AUDIO	EMPTY	EMPTY	0	0	0	EMPTY	gopro/gopro-vented-helmet-strap-mount-288612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Spf 15 Tinted Lip Balm, Sunset Cove $5.99 $3.99 | view details

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

ARCADE Arcade Ranger Belt, Heather Fog Blue/Multi $26.00 | view details

DAKINE Dakine Tiffany Women's Beanie $30.00 | view details

GoPro Gopro Vented Helmet Strap Mount $14.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	15647-DEFAULT-l.jpg	64	15647-DEFAULT-m.jpg	Sk8- Hi Black/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]	103	50-to-100	0.00	[empty string]	Vans Sk8-Hi Skate Shoes, Black/White	<p>The Sk8-Hi, Vans legendary lace-up high top inspired by the classic Old Skool, has a durable canvas and suede upper, a supportive and padded ankle, and Vans vulcanized signature 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	65	65	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	15647-DEFAULT-s.jpg	31	1000	VN000D5IB8C	273656	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-sk8hi-skate-shoes-black-white-273656	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	74.99	0	74.99	25699-DEFAULT-l.jpg	74	25699-DEFAULT-m.jpg	Kyle Walker Pro Black/White	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/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	85	50-to-100	0.00	[empty string]	Vans Kyle Walker Pro Skate Shoe, Black/White	<p>The all new Kyle Walker Pro, the introductory signature model from rookie pro Kyle Walker, is made with suede uppers. The UltraCush HD impact sockliners keep the foot close to the board while providing the highest level of impact cushioning, and the revolutionary Wafflecup construction offers the support of a cupsole without sacrificing any of the grip or boardfeel of a traditional vulcanized shoe. The Kyle Walker Pro also features DURACAP upper reinforcement in high wear areas for unrivaled durability.</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	75	75	7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25699-DEFAULT-s.jpg	39	1000	VN0A2XSGY28	366350	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-kyle-walker-pro-skate-shoe-black-white-366350	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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]	69	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	49	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]
4	Multi	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	27173-DEFAULT-l.jpg	59	27173-DEFAULT-m.jpg	Night Bloom Tali	N	[empty string]	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]	15	50-to-100	0.00	[empty string]	Billabong Night Bloom Tali Girl's Bikini Set	<p>Sunbathing in moon beams and daydreams, the Billabong Night Bloom Tali Set delivers a reversible 2-in-1 style. The mixed print girls bikini features a reversible crossback top for a functional fit (times two)! The bottoms mix up prints with a floral bottom, trimmed with contrast side tabs.</p> <p>The nuts and bolts</p> <ul> <li>Girls reversible bikini set.</li> <li>Reversible top.</li> <li>Tali top that criss crosses at center back and ties for adjustability.</li> <li>Basic tab side pant with contrast print at sides.</li> <li>Pattern: floral print reverses to dot print at top <p> </p> </li> </ul>	[empty string]	N	59.95	59.95	5,7,8,10,12,14	27173-DEFAULT-s.jpg	55	1000	Y214UBNI	385877	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-night-bloom-tali-girls-bikini-set-385877	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Golden Glow	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26810-DEFAULT-l.jpg	59	26810-DEFAULT-m.jpg	Sun Dream Tank 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 Sun Dream Tank Set	<p>Billabong Sun Dream Tank Set</p>	[empty string]	N	59.95	59.95	7,8,10,12,14	26810-DEFAULT-s.jpg	58	1000	Y219TBSU	387578	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-sun-dream-tank-set-387578	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25941-DEFAULT-l.jpg	8	25941-DEFAULT-m.jpg	Costa C- Line 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]	[empty string]	[empty string]	OH at 200	[empty string]	1	5-to-10	0.00	[empty string]	Costa Del Mar C-Line Sunglasses Retainer, Black	<p>Costa C-Line™ Retainer. Ultra-thin sunglass retainer. Lightweight. <strong>End-to-End Measurement: </strong>20"</p>	[empty string]	N	8.99	8.99	[empty string]	25941-DEFAULT-s.jpg	70	1000	CE11	349327	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-cline-sunglasses-retainer-black-349327	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Sk8- Hi Skate Shoes, Black/White $65.00 | view details

VANS Vans Kyle Walker Pro Skate Shoe, Black/White $75.00 | view details

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

BILLABONG Billabong Night Bloom Tali Girl's Bikini Set $59.95 | view details

BILLABONG Billabong Sun Dream Tank Set $59.95 | view details

COSTA DEL MAR Costa Del Mar C- Line Sunglasses Retainer, Black $8.99 | 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	Sand	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25811-DEFAULT-l.jpg	13	25811-DEFAULT-m.jpg	Women's Venusian 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]	33	10-to-15	0.00	[empty string]	Stance Venusian Women's 200 Needle Crew Sock	<p>Take your style into orbit with Venusian, unusual style for any day attire.</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	14	14	Small,Medium	25811-DEFAULT-s.jpg	1	1000	W515D18VEN	380515	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-venusian-womens-200-needle-crew-sock-380515	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Cream	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25772-DEFAULT-l.jpg	13	25772-DEFAULT-m.jpg	Women's Thoughts 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]	3	10-to-15	0.00	[empty string]	Stance Thoughts Women's Classic Crew Sock	<p>With an eclectic bunch of cartoon graphics, Thoughts is a daydreamers' delight.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Elastic Arch Support</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	Small,Medium	25772-DEFAULT-s.jpg	4	1000	W556D18THO	380532	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-thoughts-womens-classic-crew-sock-380532	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	15.99	0	15.99	25824-DEFAULT-l.jpg	15	25824-DEFAULT-m.jpg	Dot Vibes 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]	SP18	[empty string]	OH at 200	[empty string]	18	15-to-20	0.00	[empty string]	Stance Dot Vibes Poler x Stance Crew Sock	<p>Poler Outdoor Stuff is a brand created to bridge the gap between action sports and traditional outdoor activities recognizing that a modern active outdoor lifestyle encompasses them both. We make stuff for the roamers and seekers, gear that is both functional and suited for everyday use in the city as well as your next trip into the world. Introducing Dot Vibes, from our collaboration with Poler Stuff.</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	16	16	Medium,Large	25824-DEFAULT-s.jpg	9	1000	M556A18DOT	365586	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-dot-vibes-poler-x-stance-crew-sock-365586	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DVS	DVS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	27035-DEFAULT-l.jpg	69	27035-DEFAULT-m.jpg	Comanche White/Charcoal Nubuck	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]	52	50-to-100	0.00	[empty string]	DVS Comanche Skate Shoe, White/Charcoal	<p>The Comanche from DVS is a heritage skate shoe that offers unmatched comfort and durability.  This men’s skate shoe features a durable rubber cupsole construction with reinforced ollie area, leather upper, heavy-duty collar and tongue padding for extra protection, as well as a high impact EVA midsole.  You need to lace up a pair of the Comanche to truly feel the comfort and support of this timeless skate shoe. </p> <ul> <li>Leather & nubuck upper materials</li> <li>Molded TPR heel cap with core logo</li> <li>High impact insole & midsole unit</li> <li>Durable cupsole construction</li> <li>Reinforced ollie area for durability</li> <li>High density collar & tongue padding for support</li> <li>Open-cell breathable mesh tongue</li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	27035-DEFAULT-s.jpg	9	1000	DVF0000029114	383541	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-comanche-skate-shoe-white-charcoal-383541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	59.99	0	59.99	25696-DEFAULT-l.jpg	59	25696-DEFAULT-m.jpg	Slip On Pro Black/White/Red	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	248	50-to-100	0.00	[empty string]	Vans Slip-On Pro Skate Shoe, Black/White/Gum	<p>The Slip-On Pro, a Vans classic upgraded for enhanced performance, features suede and canvas uppers, single-wrap foxing tape, UltraCush? HD sockliners to keep the foot close to the board while providing the highest level of impact cushioning, and Vans original waffle outsoles for superior grip and control. The Slip-On Pro also includes Duracap? reinforcement rubber underlays in high wear areas for unrivaled durability.</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	25696-DEFAULT-s.jpg	15	1000	VN00097M9X1	315153	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-slipon-pro-skate-shoe-black-white-gum-315153	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	DKSHAD/DKSHAD,Dark Java/Dark Java,CHR/DKSHAD,Black/Dark Shadow,Trench Blue/Black,Kona/Black,Tan/Tan,Charcoal/Charcoal,SLTBLU/CHAR,DKSHAD/BLK	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	69.99	0	69.99	22684-DEFAULT-l.jpg	69	22684-DEFAULT-m.jpg	Hokua Water 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]	SPRING	[empty string]	OH at 200	[empty string]	187	50-to-100	0.00	[empty string]	OluKai Hokua Sandals	<p>Inspired by the strength of the sea, the Hokua is tough and versatile enough for any ocean adventure, whether sea kayaking or tide-pool hopping. With water-resistant synthetic straps and a rubber outsole featuring a sea urchin lug design for superior traction, we encourage you to get the Hokua a little wet.</p> <h3>FEATURES:</h3> <p>Raised rope-core strap detail with heavyweight deco stitching accents, a welded strap logo and laser-etched footbed detail.</p> <h3>UPPER:</h3> <p>Water-resistant synthetic straps with a quick-drying jersey knit lining, and a soft comfortable 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 featuring a sea urchin lug design and razor siping for added traction.</p>	[empty string]	N	70	70	7,8,9,10,11,12,13,14,15	22684-DEFAULT-s.jpg	16	1000	10161	276395	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	olukai/olukai-hokua-sandals-276395	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Venusian Women's 200 Needle Crew Sock $14.00 | view details

STANCE Stance Thoughts Women's Classic Crew Sock $14.00 | view details

STANCE Stance Dot Vibes Poler X Stance Crew Sock $16.00 | view details

DVS Dvs Comanche Skate Shoe, White/Charcoal $70.00 | view details

VANS Vans Slip- On Pro Skate Shoe, Black/White/Gum $60.00 | view details

OLUKAI Olukai Hokua Sandals $70.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]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	188.99	0	188.99	26316-DEFAULT-l.jpg	188	26316-DEFAULT-m.jpg	Bamboo Pinner Handstand 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	150-to-200	0.00	[empty string]	Landyachtz Pinner Handstand Complete Longboard, 44"	<p style="margin-left:0px; margin-right:0px; text-align:left">For long cruises or short rides, nothing compares to a big pintail board. The Pinner stands out from the crowd with bamboo/maple construction and a rockered shape providing a comfortable and flexy hammock for your feet.</p> <p style="margin-left:0px; margin-right:0px; text-align:left">Can you imagine what boards would have been like if there were designed for our hands instead of our feet? Maybe the grip tape would be softer and smooth to the touch. Maybe there would be specific grooves just for our fingers to sit in. Luckily, the art of skating on your hands never really took off and boards have been designed for our feet instead. But we would still like to pay homage to the few, the proud, the hand boarders.</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist:</strong> Grace Garcia</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 44” I W: 9.5” I WB: 32”</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck Material:</strong> Canadian Maple / Bamboo<br /> <strong>Concave:</strong> Low<br /> <strong>Flex:</strong> Medium<br /> <strong>Profile:</strong> Rocker<br /> <strong>Features:</strong> Wheel wells, Rocker, Bamboo, Spray-On Clear Grip, Medium Concave<br /> <strong>Setup:</strong> Bear Grizzly GR852, 70mm Stone Ground Hawgs Mocha Swirl 78a, ¼” Riser, Bear Spaceball Bearings</p>	[empty string]	N	189	189	44IN	26316-DEFAULT-s.jpg	2	1000	CP-FRBPIN	369746	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-pinner-handstand-complete-longboard-44-369746	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	34.99	0	34.99	25935-DEFAULT-l.jpg	34	25935-DEFAULT-m.jpg	Earth Rollers V1 Stf 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]	3	25-to-50	0.00	[empty string]	Bones Earth Rollers V1 STF Skateboard Wheels	<p>Street Tech Formula™ (STF) is specifically engineered from top quality components to obtain all the best properties necessary for the ultimate in street wheel performance.</p> <p>BONES® WHEELS has created a wheel with a substantially higher rebound for more speed and amazing slide capabilities while maintaining a resistance to flat spotting well beyond any standard wheel. The technology behind STF is proven. The results speak for themselves.</p> <p>Hype is hype, “quality” is for real. Try Street Tech Formula™ wheels on your next setup and see for yourself.</p>	[empty string]	N	34.99	34.99	53MM,54MM	25935-DEFAULT-s.jpg	6	1000	WSCATER	382870	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-earth-rollers-v1-stf-skateboard-wheels-382870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	34.99	0	34.99	25936-DEFAULT-l.jpg	34	25936-DEFAULT-m.jpg	Fernandez Con Amigos 103a 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]	Bones Fernandez Con Amigos 103a Skateboard Wheels	<p>Street Tech Formula™ (STF) is specifically engineered from top quality components to obtain all the best properties necessary for the ultimate in street wheel performance.</p> <p>BONES® WHEELS has created a wheel with a substantially higher rebound for more speed and amazing slide capabilities while maintaining a resistance to flat spotting well beyond any standard wheel. The technology behind STF is proven. The results speak for themselves.</p> <p>Hype is hype, “quality” is for real. Try Street Tech Formula™ wheels on your next setup and see for yourself.</p>	[empty string]	N	34.99	34.99	52MM	25936-DEFAULT-s.jpg	27	1000	WPCAJF003	385188	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-fernandez-con-amigos-103a-skateboard-wheels-385188	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GRIZZLY	GRIZZLY	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	14.99	0	14.99	25560-DEFAULT-l.jpg	14	25560-DEFAULT-m.jpg	Smoke Cut Out Griptape	N	[empty string]	[empty string]	[empty string]	[empty string]	6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	[empty string]	[empty string]	OH at 200	[empty string]	194	10-to-15	0.00	[empty string]	Grizzly Griptape, Smoke Cutout	[empty string]	[empty string]	N	15	15	[empty string]	25560-DEFAULT-s.jpg	37	1000	GMB1601H01	347404	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	grizzly/grizzly-griptape-smoke-cutout-347404	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	OJ	OJ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	36.99	0	36.99	26885-DEFAULT-l.jpg	36	26885-DEFAULT-m.jpg	Figgy Lightning Elite Mix Up 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]	6	25-to-50	0.00	[empty string]	OJ Figgy Lightning Elite Mix Up Universals Skateboard Wheels, 101a	<p>Elite WAY TOO FAST Urethane is here! Flying out the lab to the streets and beyond, Elite Urethane guarantees more speed, a longer lasting roll, and more importantly hands down epic times with your crew. If you're a skateboarder, you seek more speed. If you want more speed you're gonna f$ck with Elite. Figgy's Elite pro wheel comes on OJ's Universal shape. Universal is OJ's lightest shape and features a slimmer profile, medium riding surface, and angled edge for consistent lock on grinds. Art by Todd Bratrud.</p>	[empty string]	N	36.99	36.99	53MM	26885-DEFAULT-s.jpg	67	1000	22222449	387664	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	oj/oj-figgy-lightning-elite-mix-up-universals-skateboard-wheels-101a-387664	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	WELCOME	WELCOME	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	54.99	0	54.99	26947-DEFAULT-l.jpg	54	26947-DEFAULT-m.jpg	Go Darker On Basilisk	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]	Welcome Go Darker on Basilisk Skateboard Deck, 8.8"	<p>8.8 x 32.5</p> <p>14.75 Wheelbase</p> <p>Rides like an 8.38” Popsicle</p> <p>Recommended truck size: 149mm</p> <p>Artwork by Jason Celaya</p>	[empty string]	N	54.99	54.99	8.8	26947-DEFAULT-s.jpg	69	1000	GODABASITLCO	392143	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	welcome/welcome-go-darker-on-basilisk-skateboard-deck-88-392143	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

LANDYACHTZ Landyachtz Pinner Handstand Complete Longboard, 44 " $189.00 | view details

BONES Bones Earth Rollers V1 Stf Skateboard Wheels $34.99 | view details

BONES Bones Fernandez Con Amigos 103a Skateboard Wheels $34.99 | view details

GRIZZLY Grizzly Griptape, Smoke Cutout $15.00 | view details

OJ Oj Figgy Lightning Elite Mix Up Universals Skateboard Wheels, 101a $36.99 | view details

WELCOME Welcome Go Darker On Basilisk Skateboard Deck, 8.8 " $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]	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	24.99	0	24.99	25874-DEFAULT-l.jpg	24	25874-DEFAULT-m.jpg	Baja Tie Down Straps 12'set Of 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]	2	20-to-25	0.00	[empty string]	Dakine Baja Tie Down Rack Straps	<p>The Dakine Baja Tie Down Straps are heavy-duty straps designed for car roof racks. These straps are sold in sets of two 12-foot straps with 1-3/8 inch cam buckles for secure tightening. The Baja Tie Down Straps also feature a protective neoprene buckle housing.</p> <ul> <li>Heavy duty 1 3/8" [ 35mm ] cam buckle</li> <li>Neoprene buckle housing</li> <li>Carrying bag</li> <li>Set of two straps</li> </ul>	[empty string]	N	25	25	[empty string]	25874-DEFAULT-s.jpg	13	1000	8840560	271110	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dakine/dakine-baja-tie-down-rack-straps-271110	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; FINS	24.99	0	24.99	26106-DEFAULT-l.jpg	24	26106-DEFAULT-m.jpg	Fcs Ii Connect Gf 8 `	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	20-to-25	0.00	[empty string]	FCS II Connect GF Longboard Fin - 8"	<p>Versatile, high performance fin. Connect turns and move up and down the board.</p> <p><strong>Overview</strong></p> <ul> <li> <p>Neutral, well balanced template.</p> </li> <li> <p>Versatile, high performance Longboard (LB) fin for all conditions. </p> </li> <li> <p>Offers a combination of drive, speed and response for modern longboarding.</p> </li> <li> <p>Turn and Connect: Seamlessly connect turns and move up and down the board.</p> </li> <li>Based on the FCS Dolphin Longboard template.<br />  </li> <li> <p>2 + 1 Compatible.</p> </li> </ul>	<p>FCS II Connect GF Surfboard Fin 8'</p>	N	25	25	[empty string]	26106-DEFAULT-s.jpg	16	1000	FCON-GF01-LB-80-R	331694	SUP ACCESSORIES	FINS	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-ii-connect-gf-longboard-fin-8-331694	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	124.99	0	124.99	26141-DEFAULT-l.jpg	124	26141-DEFAULT-m.jpg	Pc- 5 Blue Slice Tri- Quad Retail 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]	1	100-to-150	0.00	[empty string]	FCS PC-5 Tri-Quad Fins - Medium	<p>Lightweight performance tri-quad setup with a responsive flex pattern. PC-5, PC-7 Tri-Quad.</p> <p><strong>Overview</strong></p> <ul> <li>A balance of speed, flow and response in a variety of conditions.</li> <li>Lightweight performance fin with responsive tip flex and hydrodynamic foil on the side fins.</li> <li>Tri-Quad (5 fin) set.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li> <p>A wide range of conditions from beach breaks to point 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 PC-5 II Two Tab Medium Tri-Quad Fin Set Performance Core - Blue Slice</p>	N	125	125	[empty string]	26141-DEFAULT-s.jpg	16	1000	PC05-135-28-R	347358	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-pc5-triquad-fins-medium-347358	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; BODYBOARDING	29.99	0	29.99	20306-DEFAULT-l.jpg	29	20306-DEFAULT-m.jpg	Body Surfer Handboard	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]	8	25-to-50	0.00	[empty string]	Hydro Body Surfer Handboard	<p>Heavy duty design & wrist strap.</p>	[empty string]	N	29.99	29.99	One Size	20306-DEFAULT-s.jpg	25	1000	79002	280712	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hydro/hydro-body-surfer-handboard-280712	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; BAGS	284.99	0	284.99	26161-DEFAULT-l.jpg	284	26161-DEFAULT-m.jpg	14'sup Racing Bag	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	250-to-300	0.00	[empty string]	FCS Racing SUP Cover Bag - 14'	<p>The ultimate in mobility & protection for SUP racing board transportation.</p> <p><strong>Overview</strong></p> <p>Classic and affordable board protection for day-to-day use.</p> <p> </p> <p><strong>Features</strong></p> <ul> <li>Tapered template to accommodate the streamline shape of racing boards.<br />  </li> <li>5mm HD padding<br />  </li> <li>Side handle for easy transport<br />  </li> <li>Airflow System<br />  </li> <li>Padded shoulder strap<br />  </li> <li>Full length zipper path making it easy to insert and remove boards <br />  </li> <li>Reinforced coffin wall construction<br />  </li> <li>Heat reflective silver paneling<br />  </li> <li>8 x Compression cinches<br />  </li> <li>Reinforced nose and tail area</li> </ul>	[empty string]	N	285	285	[empty string]	26161-DEFAULT-s.jpg	25	1000	BRC-140-PB-SLV	299848	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-racing-sup-cover-bag-14-299848	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; FINS	134.99	0	134.99	26126-DEFAULT-l.jpg	134	26126-DEFAULT-m.jpg	Fcs Ii Eric Terrien 8.5 ”	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	100-to-150	0.00	[empty string]	FCS II Eric Terrien SUP Fin - 8.5"	<p>Multi-purpose SUP fin with great turning capabilities and moderate stroke hold.</p> <p><strong>Overview</strong></p> <ul> <li> <p>Eric Terrien Europe's winningest racer was a big fan of the Slater Trout fin but wanted to add better tracking and more strokes per side.</p> </li> <li> <p>The extended bump on the trailing edge does exactly that and Eric and his FCS teammates have won multiple races on this fin.</p> </li> <li> <p>Suited to a variety of conditions from surf to flat water.</p> </li> </ul>	[empty string]	N	135	135	[empty string]	26126-DEFAULT-s.jpg	54	1000	FTER-PCS1-SP-85-R	348088	SUP ACCESSORIES	FINS	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-ii-eric-terrien-sup-fin-85-348088	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Baja Tie Down Rack Straps $25.00 | view details

FCS Fcs Ii Connect Gf Longboard Fin - 8 " $25.00 | view details

FCS Fcs Pc- 5 Tri- Quad Fins - Medium $125.00 | view details

HYDRO Hydro Body Surfer Handboard $29.99 | view details

FCS Fcs Racing Sup Cover Bag - 14 ' $285.00 | view details

FCS Fcs Ii Eric Terrien Sup Fin - 8.5 " $135.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	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	529.99	0	529.99	26340-DEFAULT-l.jpg	529	26340-DEFAULT-m.jpg	Instagator	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]	21	500-and-over	0.00	[empty string]	Never Summer Insta/Gator Snowboard, 2019	<p>Snap in and out of turns, spin like a machine, and rail like a train. Size your Gator smaller and improve your OVERALL performance. Amazing nimbility with stability is what 12mm of taper and massive surface area will do for you. All boards ride great in perfect conditions, now ride you can ride great ANYWHERE in ANY CONDITIONS. It’s a new world...adjust your stance width, placement, and angles for ride variations that fit the days mood, conditions, and style. You’d better get a Gator sooner rather than later. LT - Narrower version of the original.</p>	[empty string]	N	529.99	529.99	144,148,151,156,159	26340-DEFAULT-s.jpg	9	1000	INSTAGATOR-I	374737	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-insta-gator-snowboard-2019-374737	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	519.99	0	519.99	26349-DEFAULT-l.jpg	519	26349-DEFAULT-m.jpg	Snowtrooper	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]	2018	[empty string]	[empty string]	[empty string]	4	500-and-over	0.00	[empty string]	Never Summer Snowtrooper Snowboard, 2018	<p>The Snowtrooper is the all mountain equalizer and a great board for any riding style. It features our Original Rocker Camber Profile for amazing float and playfulness, a mid flex for all mountain versatility, with the supercharged feel of a slightly setback stance. The Trooper synchronizes your ride for the entire mountain. It’s the Swiss Army Knife of snowboards. X - Wide version of the original.</p>	[empty string]	N	519.99	519.99	152,156,159	26349-DEFAULT-s.jpg	12	1000	STROOPER-H	358736	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-snowtrooper-snowboard-2018-358736	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DORSAL	DORSAL	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	29.99	0	29.99	26069-DEFAULT-l.jpg	29	26069-DEFAULT-m.jpg	Poncho - Black	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]	26	25-to-50	0.00	[empty string]	Dorsal Changing Robe Surf Poncho	<p>Surf Changing Poncho - Black</p> <ul> <li>The DORSAL Poncho is a plush towel poncho in and out of your wetsuit EASY, COMFORTABLE, and WARM.</li> <li>ONE SIZE FITS ALL - even tall guys like Mike! Other ponchos are short and can still leave you exposed, so we made ours taller. 40 inches (120cm) from top of shoulders to bottom of robe.</li> <li>THICK MICROFIBER is soft on your skin and dries quickly. Machine washable for easy care.</li> <li>ABSORBS WATER - Poncho doubles as a towel to dry yourself after surfing, so you don't need an additional towel .</li> <li>The PERFECT GIFT for that hard-to-please surfer. Whether it's Christmas, a birthday, graduation, or "just because", your surfer will be stoked to receive the Dorsal poncho!</li> </ul>	[empty string]	N	29.85	29.85	[empty string]	26069-DEFAULT-s.jpg	24	1000	DORSAL-PONCHO-BLK	368461	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dorsal/dorsal-changing-robe-surf-poncho-368461	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FPB	OAKLEY	OAKLEY	SNOWBOARDING	SNOWBOARDING &GT; HELMETS	209.99	0	209.99	25997-DEFAULT-l.jpg	209	25997-DEFAULT-m.jpg	Mod 5 Helmet Factory Pilot Blackout	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]	2018	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Oakley MOD5 Factory Pilot Snow Helmet, Matte Black	<p>Big-Mountain brawn, designed for those who demand the highest level of performance. Featuring a hybrid shell construction and our Modular Brim System (MBS), the MOD5 delivers the perfect balance of increased protection and weight savings for technical riding. Part of our premium paint and graphics collection. Click <a href="http://www.oakley.com/helmets" target="_blank">HERE</a> to learn more about the Oakley MOD Helmet.</p> <ul> <li>MBS - Modular Brim System</li> <li>Hybrid Shell Construction</li> <li>Boa® fit system</li> <li>Fidlock® magnetic buckle closure</li> <li>Adjustable Ventilation</li> <li>Removable Comfort Liner</li> <li>Removable Ear Pads</li> <li>Removable Goggle Strap Retainer</li> <li>Helmet Bag Included</li> <li>Premium Paint and Graphics Collection</li> <li>Small (51-55cm) / Medium (55-59cm) / Large (59-63cm)</li> <li>ASTM F2040 and CE EN1077 certifications</li> </ul>	[empty string]	N	210	210	Large	25997-DEFAULT-s.jpg	25	1000	99430FP-02K-H	360544	EMPTY	EMPTY	EMPTY	0	0	0	HELMETS	oakley/oakley-mod5-factory-pilot-snow-helmet-matte-black-360544	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	29	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]
6	Elias Elhardt	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; MEN'S OUTERWEAR &GT; GLOVES	94.99	0	94.99	25878-DEFAULT-l.jpg	94	25878-DEFAULT-m.jpg	Team Baron Mitt	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]	8	50-to-100	0.00	[empty string]	Dakine Team Baron Gore-Tex Mitt Ski and Snowboard Mitten	<p>Team rider Elias Elhardt is a backcountry animal and the Team Baron Mitt is his hand wear of choice. Muted tones and a hand-dyed look share Elhardt's passion for nature, while a waterproof-breathable GORE-TEX liner and Gore Grip technology meet his demands for all-day storm protection and dexterity. Primaloft® insulation and a soft wool liner keep it warm, while a four-way stretch exterior maintain natural movement for buckling bindings and adjusting boots.</p> <ul> <li>INSERT: GORE-TEX + Gore Grip technology / Waterproof and breathable</li> <li>INSULATION: PrimaLoft® [ 230g ]</li> <li>PALM: Durable water repellent leather</li> <li>SHELL: Nylon / Poly with DWR treatment / Durable water repellent leather</li> <li>LINING: 360g Wool</li> </ul>	[empty string]	N	95	95	Small,Medium,Large,X-Large	25878-DEFAULT-s.jpg	48	1000	10002004-I	373451	MENS OUTERWEAR	GLOVES	EMPTY	0	0	0	OUTERWEAR	dakine/dakine-team-baron-goretex-mitt-ski-and-snowboard-mitten-373451	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Insta/Gator Snowboard, 2019 $529.99 | view details

NEVER SUMMER Never Summer Snowtrooper Snowboard, 2018 $519.99 | view details

DORSAL Dorsal Changing Robe Surf Poncho $29.85 | view details

OAKLEY Oakley Mod5 Factory Pilot Snow Helmet, Matte Black $210.00 | view details

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

DAKINE Dakine Team Baron Gore- Tex Mitt Ski And Snowboard Mitten $95.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]	ELECTRIC	ELECTRIC	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	119.99	0	119.99	25968-DEFAULT-l.jpg	119	25968-DEFAULT-m.jpg	Swingarm Mat Blk/Gry Pol	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]	Electric Swingarm Sunglasses, Matte Black/Grey Polarized	<p>Electric Swingarm Sunglasses, Matte Black/Grey Polarized </p>	[empty string]	N	120	120	[empty string]	25968-DEFAULT-s.jpg	1	1000	EE12901042	312349	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-swingarm-sunglasses-matte-black-grey-polarized-312349	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ELECTRIC	ELECTRIC	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	27216-DEFAULT-l.jpg	149	27216-DEFAULT-m.jpg	Knoxville Xl Mat Blk/Ohm P Brz	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]	Electric Knoxville XL Sunglasses, Matte Black/Bronze Polarized	<p>Respecting the original Knoxville, we've scaled up the sizing to create a frame that offers more coverage and a larger look while maintaining clean, classic lines and uncompromised fit.</p> <ul> <li>Frame: 6 base mold injected grilamid frame with a 5 barrel hinge.</li> <li>Optics: 6 base melanin infused polycarbonate lenses. 100% UV protection. Up to 98% blue light protection.</li> <li>Available in polarized polycarbonate lenses. 99.9% Premium glare reduction, relaxed/soothing eye feeling, true color perception, and scratch resistance.</li> <li>Available in anti-reflection, hydrophobic, and oleophobic performance lens coatings.</li> <li>Visual Light Transmitted (VLT): 10%. Optimal lens for daily use. Increased clarity and depth perception while providing visual comfort.</li> <li>Includes microfiber cleaning bag.</li> <li>Designed in California. Made in Italy.</li> <li>Lifetime warranty</li> <li>Measurement: 50h - 144w - 158l</li> <li>Weight: 33 grams</li> </ul>	[empty string]	N	150	150	[empty string]	27216-DEFAULT-s.jpg	1	1000	EE11201043	374336	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-knoxville-xl-sunglasses-matte-black-bronze-polarized-374336	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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/Grey	BONES	BONES	ACCESSORIES	ACCESSORIES &GT; HATS	21.99	0	21.99	25931-DEFAULT-l.jpg	21	25931-DEFAULT-m.jpg	Bw Shades Cap	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]	6	20-to-25	0.00	[empty string]	Bones Wheels BW Shades Cap	<ul> <li>BONES logo embroidery woven front patch</li> <li>100% cotton twill 5 panel unstructured fit</li> <li>Plastic snap back closure</li> <li>BONES logo satin closure label</li> <li>Black/Grey</li> </ul>	[empty string]	N	21.99	21.99	One Size	25931-DEFAULT-s.jpg	2	1000	CHFMBOTX	376339	EMPTY	EMPTY	EMPTY	0	0	0	HATS	bones/bones-wheels-bw-shades-cap-376339	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	OTIS	OTIS	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	229.99	0	229.99	27251-DEFAULT-l.jpg	229	27251-DEFAULT-m.jpg	Crossroads Mat Drk Tort/Brn 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]	2	200-to-250	0.00	[empty string]	Otis Crossroads Women's Sunglasses, Matte Dark Tort/Brown Polar	<p>The Crossroads offers a rounded square frame and slim metal temples to give you a simple yet elegant look. The mixed material combination provides versatility so you can take these smoothly from desolate beaches to busy city streets.</p> <ul> </ul>	[empty string]	N	230	230	[empty string]	27251-DEFAULT-s.jpg	3	1000	19-1802P	357349	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	otis/otis-crossroads-womens-sunglasses-matte-dark-tort-brown-polar-357349	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey,Gunmetal	FCS	FCS	ACCESSORIES	ACCESSORIES &GT; HATS	19.99	0	19.99	26073-DEFAULT-l.jpg	19	26073-DEFAULT-m.jpg	Wet Baseball Cap	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]	12	15-to-20	0.00	[empty string]	FCS Wet Baseball Cap	<p>Designed to stay secure in the surf and provide protection against sun.</p>	<p>FCS Wet Bucket Water Hat - Gunmetal - Large - Surf, SUP, Kayake, Beach, Hiking</p>	N	20	20	Small,Medium,Large	26073-DEFAULT-s.jpg	5	1000	2925	348681	EMPTY	EMPTY	EMPTY	0	0	0	HATS	fcs/fcs-wet-baseball-cap-348681	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SLOWTIDE	SLOWTIDE	ACCESSORIES	ACCESSORIES &GT; BEACH TOWELS	29.99	0	29.99	27104-DEFAULT-l.jpg	29	27104-DEFAULT-m.jpg	Steelie Towel	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]	SP19	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Slowtide Steelie Beach Towel	<p>Slowtide Steelie Beach Towel</p>	[empty string]	N	29.95	29.95	[empty string]	27104-DEFAULT-s.jpg	5	1000	ST191	386672	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	slowtide/slowtide-steelie-beach-towel-386672	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]