Dot Dash Aperture Sunglasses, Metallic Navy Satin/Silver Flash

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]	ELECTRIC	ELECTRIC	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	79.99	0	79.99	27222-DEFAULT-l.jpg	79	27222-DEFAULT-m.jpg	Swingarm Mat 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]	[empty string]	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Electric Swingarm Sunglasses, Matte Black/Grey	<p>The Swingarm is lightweight and heavy duty. Purpose built around the innovative double action hinge system, offering uncompromising fit and function.</p> <ul> <li>Frame: 6 base mold injected grilamid frame with an innovative double action hinge system.</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: 49h - 140w - 161l</li> <li>Weight: 29 grams</li> </ul>	[empty string]	N	80	80	[empty string]	27222-DEFAULT-s.jpg	1	1000	EE12901020	312350	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	electric/electric-swingarm-sunglasses-matte-black-grey-312350	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	59.99	0	59.99	25673-DEFAULT-l.jpg	59	25673-DEFAULT-m.jpg	Time Teller Corp Mat Wht/Blk	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]	Nixon Time Teller P Corp 40mm Watch, Matte White/Black	<p>A bold mash-up between two Nixon Icons, the Time Teller P Corp is easy to wear and hard to ignore. Durable and lightweight the Time Teller P Corp is waterproof up to 100m and features larger numerical indices and printed seconds track, which perfectly pops against the matte finish.</p>	[empty string]	N	60	60	[empty string]	25673-DEFAULT-s.jpg	2	1000	A12483009	375192	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-time-teller-p-corp-40mm-watch-matte-white-black-375192	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	DOT DASH	DOT DASH	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	39.99	0	39.99	26036-DEFAULT-l.jpg	39	26036-DEFAULT-m.jpg	Buford T Gloss Gold/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]	18	25-to-50	0.00	[empty string]	Dot Dash Buford T Sunglasses, Black Satin/Blue Flash	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <p><strong>Metal Shop</strong> <strong>Collection</strong> ~ Raise your goblet of rock; it’ll blow your back teeth out.</p> <h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Base-8 Polycarbonate Lens</li> <li>Metal Frame</li> <li>Hardened 3 Barrel Metal Hinge</li> </ul> </form>	[empty string]	N	40	40	[empty string]	26036-DEFAULT-s.jpg	3	1000	DSMSFBUF-GGN	274618	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-buford-t-sunglasses-black-satin-blue-flash-274618	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Charcoal Heather,GVN,Indigo,MDB,MRB,Navy Heather,RBR,Sand,SNV	VOLCOM	VOLCOM	MENS	MENS &GT; ACCESSORIES &GT; HATS	28.99	0	28.99	25646-DEFAULT-l.jpg	27	25646-DEFAULT-m.jpg	Full Stone Heather Flex Fit	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]	72	25-to-50	0.00	[empty string]	Volcom Full Stone Heather Xfit Hat	<p>The Full Stone Heather XFit isn't made like anything else. So you know it's going to outlast everything else.</p>	[empty string]	N	28	28	Small/Medium,Large/X-Large	25646-DEFAULT-s.jpg	3	1000	D5511588	319230	HATS	EMPTY	EMPTY	0	0	0	EMPTY	volcom/volcom-full-stone-heather-xfit-hat-319230	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ALP,BN4,CNB,CRL,Cascade Blue,Lavender,RVCA Black	RVCA	RVCA	MENS	MENS &GT; BOTTOMS &GT; BOARDSHORTS	49.99	0	49.99	26703-DEFAULT-l.jpg	49	26703-DEFAULT-m.jpg	Gerrard 17 ` Elastic Volley Short	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]	93	25-to-50	0.00	[empty string]	RVCA Tom Gerrard Elastic Boardshort, 17"	<p>AN ESSENTIAL BOARDSHORT, THE RVCA TOM GERRARD ELASTIC 17" TRUNK IS BACKED BY GLOBALLY RECOGNIZED STREET ARTIST TOM GERRARD, AKA “AEON.” PART OF THE ARTIST NETWORK PROGRAM, THE MENS ELASTIC WAIST TRUNKS ARE CUT WITH A SHORTENED 17 INCH OUTSEAM AND FINISHED WITH CUSTOM EMBROIDERY AT THE LEFT LEG. SIDE SEAM POCKETS AND A ZIPPERED BACK POCKET DELIVER BEACH TO STREET FUNCTION.</p>	[empty string]	N	50	50	Small,Medium,Large,X-Large	26703-DEFAULT-s.jpg	3	1000	M170TRGE	383204	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	rvca/rvca-tom-gerrard-elastic-boardshort-17-383204	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	4	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

ELECTRIC Electric Swingarm Sunglasses, Matte Black/Grey $80.00 | view details

NIXON Nixon Time Teller P Corp 40mm Watch, Matte White/Black $60.00 | view details

DOT DASH Dot Dash Buford T Sunglasses, Black Satin/Blue Flash $40.00 | view details

VOLCOM Volcom Full Stone Heather Xfit Hat $28.00 | view details

RVCA Rvca Tom Gerrard Elastic Boardshort, 17 " $50.00 | view details

DOT DASH Dot Dash Plimsoul Sunglasses, Black Satin/Grey Polarized $38.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]	129	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	129	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	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	839	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	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]	137	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	975	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
4	[empty string]	OAKLEY	OAKLEY	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	182.99	0	182.99	26002-DEFAULT-l.jpg	182	26002-DEFAULT-m.jpg	Holbrook Xl Woodgrain W/Prizm Tngstn Po	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	150-to-200	0.00	[empty string]	Oakley Holbrook XL Sunglasses, Woodgrain/Prizm Tungsten Polarized	<p>The look of Holbrook™, from its iconic style to keyhole bridge and metal rivets, has been scaled up to fit larger faces. Even with enhanced sizing for larger faces, it stays comfortable with lightweight O Matter™ frame material. Pure Plutonite® lenses filter out 100% of all UV while XYZ Optics® maintains clarity at every angle of view.</p>	<p>Oakley Holbrook XL Polarized Sunglasses, Woodgrain/PRIZM Tungsten,OS</p>	N	183	183	[empty string]	26002-DEFAULT-s.jpg	1	1000	OO9417-0659	372747	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	oakley/oakley-holbrook-xl-sunglasses-woodgrain-prizm-tungsten-polarized-372747	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VANS	VANS	WOMENS	WOMENS &GT; SHOES &GT; SKATE SHOES	64.99	0	64.99	25707-DEFAULT-l.jpg	64	25707-DEFAULT-m.jpg	Old Skool (Jersey Lace) Black/Port	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK COMBO	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Vans Jersey Lace Old Skool Skate Shoe, Black/Port Royale	<p>The first to bear the iconic side stripe, the Jersey Lace Old Skool is a low top lace-up shoe. It is lined, has padded collars for comfort, re-enforced toecaps to withstand repeated wear, and features the Vans signature waffle outsole for a firmer grip.<br /> 3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	65	65	8	25707-DEFAULT-s.jpg	1	1000	VN0A38G1UNI	378744	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-jersey-lace-old-skool-skate-shoe-black-port-royale-378744	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
6	Blue,Violet	STANCE	STANCE	WOMENS	WOMENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	25728-DEFAULT-l.jpg	13	25728-DEFAULT-m.jpg	Check Me Out Socks	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]	53	10-to-15	0.00	[empty string]	Stance Check Me Out Classic Crew Socks	<p>Everyone loves checkers. Add a little to your wardrobe with Stance's Check Me Out, a classic checkered design that fits with any style.</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	25728-DEFAULT-s.jpg	3	1000	M556D18CHE	380205	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-check-me-out-classic-crew-socks-380205	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Cocobalm Lip Balm, Groove Berry $3.99 $2.99 | view details

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

OAKLEY Oakley Holbrook Xl Sunglasses, Woodgrain/Prizm Tungsten Polarized $183.00 | view details

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

STANCE Stance Check Me Out Classic Crew Socks $14.00 | 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	Pomegranate	VOLCOM	VOLCOM	KIDS	KIDS &GT; BOYS &GT; TOPS &GT; T-SHIRTS	17.99	0	17.99	27139-DEFAULT-l.jpg	17	27139-DEFAULT-m.jpg	Boys Volcom Panic Ss Tee	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]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	23	15-to-20	0.00	[empty string]	Volcom Boys Panic Short Sleeve T-Shirt	<p>Sneak a peek at the Volcom Panic Short Sleeve. This basic fit tee has a unique Volcom screen print and its crafted with a heavy weight ring spun cotton fabric.<br /> <br /> Basic fit<br /> Soft hand screen print<br /> Crew neck with contrast interior neck tape<br /> Screen printed neck label</p> <p>100% COTTON</p>	[empty string]	N	18	18	Small,Medium,Large,X-Large	27139-DEFAULT-s.jpg	3	1000	C3511910	383551	TOPS	T-SHIRTS	EMPTY	0	0	0	EMPTY	volcom/volcom-boys-panic-short-sleeve-tshirt-383551	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	25715-DEFAULT-l.jpg	74	25715-DEFAULT-m.jpg	Authentic Uc (Made For The Makers) Black	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]	BLACK	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	32	50-to-100	0.00	[empty string]	Vans Made For The Makers Old Skool UC Shoe, Black	<p>The Made For The Makers collection features tough shoes for tough jobs, and the creative communities around them. Whether you're an artist, surfboard shaper, barber, or tattoo artist, Made For The Makers was built for maximum comfort so you can do what you love all day. With vulcanized lugged outsoles, the Old Skool UC also includes 8 oz Vansguard canvas and suede uppers to repel liquids and dirt, contoured drop-in UltraCush sockliners for long-lasting comfort, and padded collars for support and flexibility.</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	4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,10.5,11,12,13	25715-DEFAULT-s.jpg	19	1000	VN0A3MU8QBX	366078	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-made-for-the-makers-old-skool-uc-shoe-black-366078	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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]	71	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	36	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]
4	Multi	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	27172-DEFAULT-l.jpg	59	27172-DEFAULT-m.jpg	Night Bloom Hi Neck	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]	22	50-to-100	0.00	[empty string]	Billabong Night Bloom High Neck Girl's Bikini Set	<p>Sunbathing in moon beams and daydreams, the Billabong Night Bloom High Neck Set delivers a reversible 2-in-1 style. The mixed print girls bikini features a reversible halter neck top with ties at the neck and center back. The bottoms feature a floral print, trimmed with a contrast print waistband and tunneled ties at the sides.</p> <p>The nuts and bolts</p> <ul> <li>Girls reversible bikini set.</li> <li>Reversible top.</li> <li>High neck top with ties at neck and center back for adjustability.</li> <li>Open tunnel tie side pant with contrast print waistband.</li> <li>Pattern: floral print reverses to dot print at top. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	59.95	59.95	4,6X,7,8,10,12,14	27172-DEFAULT-s.jpg	47	1000	Y213UBNI	385876	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-night-bloom-high-neck-girls-bikini-set-385876	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	27118-DEFAULT-l.jpg	14	27118-DEFAULT-m.jpg	Boys Neon Tropics Bb Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	Stance Neon Tropics Boys Boxer Brief	<p>Bright, colorful graphics contrasting an all-black background, Boys Neon Tropics is sure to signify his vibrant personality.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief</li> <li>3.5' Inseam Length</li> <li>Feather-Seam™ Construction</li> <li>Exposed Elastic Core-flex™ Waistband</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash Cold</li> <li>Tumble Dry Low</li> </ul>	[empty string]	N	15	15	Small,Medium,Large	27118-DEFAULT-s.jpg	59	1000	B803A19NEN	383919	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-neon-tropics-boys-boxer-brief-383919	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	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	61	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VOLCOM Volcom Boys Panic Short Sleeve T- Shirt $18.00 | view details

VANS Vans Made For The Makers Old Skool Uc Shoe, Black $75.00 | view details

VANS Vans Chambray Old Skool Skate Shoe, True Canvas Navy/True White $65.00 | view details

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

STANCE Stance Neon Tropics Boys Boxer Brief $15.00 | view details

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

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	79.99	0	79.99	26786-DEFAULT-l.jpg	79	26786-DEFAULT-m.jpg	Berle Pro Rumba 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]	BRIGHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	66	50-to-100	0.00	[empty string]	Vans Berle Pro Skate Shoe	<p>Global Skate Team rider Elijah Berle’s first-ever signature shoe - the Berle Pro – pushes the boundaries of skate progression with breakthrough WaffleControl technology, and the deceptively simple silhouette is packed with only the necessary tools for its sole purpose, skateboarding: Duracap-reinforced uppers, new medial gum rubber enhancements for extended toe durability, and LuxLiner for a snug overall fit.</p>	[empty string]	N	80	80	7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26786-DEFAULT-s.jpg	3	1000	VN0A3WKX9D0	383047	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-berle-pro-skate-shoe-383047	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Black/Dark Shadow,Trench Blue/Trench Blue	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	99.99	0	99.99	26889-DEFAULT-l.jpg	99	26889-DEFAULT-m.jpg	Alapa Li Mens Shoe	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	50-to-100	0.00	[empty string]	Olukai Alapa Li Men's Sneakers	<p>From walking the slopes of Diamond Head at dawn to sunset swims, the people of Hawai‘i pride themselves on their active lifestyle. We created the sporty, lightweight ?Alapa Li to mirror that sentiment. It’s a shoe that will comfortably take you from a surf session, to the office, to the gym, even pau hana—all in one day.</p> <p>FEATURES<br /> Our patented Drop-In Heel® design offers both a shoe and slide functionality, embossed and embroidered logos and elastic laces for easy on/off function.</p>	[empty string]	N	100	100	8,8.5,9,9.5,10,10.5,11,11.5,12,13	26889-DEFAULT-s.jpg	5	1000	10395	382201	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	olukai/olukai-alapa-li-mens-sneakers-382201	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Blue	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	11.99	0	11.99	25735-DEFAULT-l.jpg	11	25735-DEFAULT-m.jpg	Shasta 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]	H18	[empty string]	[empty string]	[empty string]	33	10-to-15	0.00	[empty string]	Stance Shasta Classic Crew Sock	<p>Put some spirit in your style with Stance's Shasta. With its classic tribal print and crisp appearance, you'll be rain dancing with each step.</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	12	12	Medium,Large	25735-DEFAULT-s.jpg	6	1000	M556D18SHA	380081	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-shasta-classic-crew-sock-380081	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Neon Pink,Teal,Violet	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	9.99	0	9.99	25733-DEFAULT-l.jpg	9	25733-DEFAULT-m.jpg	Icon 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]	21	5-to-10	0.00	[empty string]	Stance Icon Classic Crew Sock	<p>The Icon Classic Crew maintains Stance's top-shelf comfort in a classic, plain look for those days you feel like going a little more low-key.</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	10	10	Medium,Large	25733-DEFAULT-s.jpg	9	1000	M311D14ICO	380198	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-icon-classic-crew-sock-380198	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DC	DC	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	109.99	0	109.99	27019-DEFAULT-l.jpg	109	27019-DEFAULT-m.jpg	Kalis S Manolo 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]	28	100-to-150	0.00	[empty string]	DC Kalis S Manolo Skate Shoes, White	<p>The nuts and bolts</p> <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	110	110	8,9,9.5,10,10.5,11,11.5,12	27019-DEFAULT-s.jpg	13	1000	ADYS100483-WHT	382975	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-kalis-s-manolo-skate-shoes-white-382975	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	eXpresso,Sierra,Black,Sierra/eXpresso,EXSB,Dark Brown	RAINBOW	RAINBOW	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	54.99	0	54.99	22131-DEFAULT-l.jpg	54	22131-DEFAULT-m.jpg	Flirty Braidy Single Layer Wmn	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]	SPRING	[empty string]	OH at 200	[empty string]	80	50-to-100	0.00	[empty string]	Rainbow Flirty Braidy Single Layer Premier Leather Women's Sandal	<p>The Flirty Braidy was the hottest addition to the 2012 product line – the ladies absolutely loved it and it is back for round two this year. <br /> <br /> <br /> • Single Layer Arch Support <br /> • Premier Nubuck Leather <br /> • Braided Outer Strap <br /> • Stitched Trim Inside Strap <br /> • Wrapped Leather Toe Piece <br /> • Bonded Nylon Thread <br /> • Double Stitched <br /> • Rainbow Logo Embossed Topsole <br /> • Original Rainbow Woven Label <br /> <br /> The Flirty Braidy is our single layer midsole with arch support, which sits on a non-slip Rainbow bottom, with a Twist! <br /> <br /> The premier leather top is made from the highest quality nubuck leather, and is embossed with our Rainbow logo. <br /> <br /> The narrow strap has an asymmetrical design featuring a braid on the outside straps and top stitched leather trim on the inside straps. The toe piece is our new V style construction and is wrapped with soft leather for comfort. The right sandal proudly displays the Original Rainbow woven label. <br /> <br /> The straps are double stitched using bonded nylon thread for durability. The non-slip Rainbow bottom finishes the new addition.<br />  </p>	[empty string]	N	54.99	54.99	Small,Medium,Large,X-Large	22131-DEFAULT-s.jpg	20	1000	301ALTSB	279047	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	rainbow/rainbow-flirty-braidy-single-layer-premier-leather-womens-sandal-279047	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Berle Pro Skate Shoe $80.00 | view details

OLUKAI Olukai Alapa Li Men's Sneakers $100.00 | view details

STANCE Stance Shasta Classic Crew Sock $12.00 | view details

STANCE Stance Icon Classic Crew Sock $10.00 | view details

DC Dc Kalis S Manolo Skate Shoes, White $110.00 | view details

RAINBOW Rainbow Flirty Braidy Single Layer Premier Leather Women's Sandal $54.99 | 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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD BEARINGS	124.99	0	124.99	4166-DEFAULT-l.jpg	124	4166-DEFAULT-m.jpg	Ceramic Swiss Bearings	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TOP SELLERS	[empty string]	WEB	[empty string]	ACTIVE	[empty string]	UPDATE	[empty string]	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	Bones Ceramic Swiss Skateboard Bearings	<p>Bones Swiss Ceramics are in a class by themselves. If you want the best there is, this is it. The ceramic balls are much lighter, harder, stronger, waterproof, and longer lasting than the finest steel balls. Made in Switzerland.</p> <p><strong>Features</strong></p> <ul> <li>Accelerate faster.</li> <li>Roll faster and farther.</li> <li>Resist dirt and moisture better.</li> <li>Help to repair injuries to your races caused by dirt.</li> <li>1 non-contact, removable rubber shields allow easy cleaning.</li> <li>High speed nylon ball retainer for greater strength and speed.</li> <li>Skate Rated™ clearances, tolerances, materials and lubricant provide the best performance and durability possible.</li> </ul> <p><strong>Contents</strong></p> <ul> <li>Set of 8 bearings</li> <li>4 bearing spacers</li> <li>Instructions</li> <li>Sticker</li> </ul> <p>Bones Swiss Bearings have the best reputation in the skateboard industry and have had this honor since 1981, due to their performance and quality. Everyone who rides Swiss knows how fast they are and how long they last. Testimonials reveal them lasting several times longer than low cost bearings. Skaters who use Bones Swiss do so because they want the very best equipment they can get and know the difference between ordinary and exceptional. Our team is a who’s who of top skaters and we are proud to be associated with each one of them.</p>	[empty string]	N	124.989997864	124.989997864	[empty string]	4166-DEFAULT-s.jpg	9	1000	BSLWBC88	36675	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-ceramic-swiss-skateboard-bearings-36675	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GOLDCOAST	GOLDCOAST	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	189.99	0	189.99	25559-DEFAULT-l.jpg	189	25559-DEFAULT-m.jpg	Lume Drop Thru 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]	36	150-to-200	0.00	[empty string]	Goldcoast Lume Drop-Thru Complete Longboard Skateboard	<p>The Lume Drop Through is a smaller, more portable board for cruising, commuting, or crushing some hills. The 7-ply Canadian Maple deck has our Power Slide™ mounting system which doesn’t require you to disassemble your trucks to mount them. The deck also has our “W” concave for a responsive and comfortable pocket for your feet to sit in. Mounted on the Lume are the newly designed Century C80 Reverse Pivot Trucks, which set a new standard for precision in a cast aluminum truck. To those are mounted the Shred Boots 70mm center set wheels and Rolleroids Bearings to keep you riding longer.</p>	[empty string]	N	189.99	189.99	N/A	25559-DEFAULT-s.jpg	12	1000	COM-LUME	373615	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	goldcoast/goldcoast-lume-dropthru-complete-longboard-skateboard-373615	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; 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	13	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]
4	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	179.99	0	179.99	26319-DEFAULT-l.jpg	179	26319-DEFAULT-m.jpg	Bamboo Chief Eyes 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 Bamboo Chief Eyes Complete Longboard, 36"	<p style="margin-left:0px; margin-right:0px; text-align:left">There’s something about cruising on a traditional pintail that just rubs me the right way. The Chief has a unique, Bamboo/Maple construction and rockered shape that makes it incredibly fun to ride. Skate like no one’s watching. But please don’t do anything illegal or stupid because now-a-days, someone’s always watching, you know, Big Brother...</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist:</strong> Giga Kobidze</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 36” I W: 8.75” I WB: 26.5”</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, Low Concave<br /> <strong>Setup:</strong> Bear Grizzly GR852, 63mm Fatty Hawgs Orange/Yellow Swirl 78a, 1/8” Soft Riser, Bear Spaceball Bearings</p>	[empty string]	N	179.99	179.99	36IN	26319-DEFAULT-s.jpg	16	1000	CP-FRBCHF	378818	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-bamboo-chief-eyes-complete-longboard-36-378818	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	234.99	0	234.99	27052-DEFAULT-l.jpg	234	27052-DEFAULT-m.jpg	Switch 40 Skull Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Landyachtz Switch Skull 40 Complete Longboard, 40"	<p>Forwards or backwards, steep freeride spots or cruising your neighbourhood, the Switch is comfortable in any situation. The 40 inch version has ample standing platform perfect for taller riders or anyone who prefers a wider stance.</p> <p>We design our trucks and wheels to fit perfectly with each individual deck. We work tirelessly to ensure these elements come together to provide the best control and performance for your board.</p> <p>No slop, all control. Don’t accept anything less than the perfect complete.</p> <ul> <li>100% Canadian Maple</li> <li>Deep Concave</li> <li>Drop Down</li> <li>Symmetrical</li> </ul>	[empty string]	N	235	235	40IN	27052-DEFAULT-s.jpg	24	1000	119-DHSW40SKL	386938	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switch-skull-40-complete-longboard-40-386938	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	69.99	0	69.99	26739-DEFAULT-l.jpg	69	26739-DEFAULT-m.jpg	Kendall End Of The World 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]	2	50-to-100	0.00	[empty string]	Santa Cruz Kendall End of the World Re-Issue Skateboard Deck, 10" x 29.7"	<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, Jeff Kendall's "End of the World” 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.0	26739-DEFAULT-s.jpg	33	1000	11115418	391904	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-kendall-end-of-the-world-reissue-skateboard-deck-10-x-297-391904	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

BONES Bones Ceramic Swiss Skateboard Bearings $124.99 | view details

GOLDCOAST Goldcoast Lume Drop- Thru Complete Longboard Skateboard $189.99 | view details

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

LANDYACHTZ Landyachtz Bamboo Chief Eyes Complete Longboard, 36 " $179.99 | view details

LANDYACHTZ Landyachtz Switch Skull 40 Complete Longboard, 40 " $235.00 | view details

SANTA CRUZ Santa Cruz Kendall End Of The World Re- Issue Skateboard Deck, 10 " X 29.7 " $69.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	Pewter,Vintage Blue	VOLCOM	VOLCOM	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; MEN'S	39.99	0	39.99	26941-DEFAULT-l.jpg	39	26941-DEFAULT-m.jpg	Lido Heather Ls Surf 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]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	19	25-to-50	0.00	[empty string]	Volcom Lido Heather Long Sleeve Rashguard	<p>When you're living fast sometimes you need a little proteciton. The Lido Heather long sleeve rash guard keeps you covered down to the wrist to keep the elements and 30+ UV rays off you.<br /> <br /> Loose fit rash guard<br /> Hybrid jersey fabric<br /> 30+ UV protection</p>	[empty string]	N	40	40	Small,Medium,Large,X-Large,XX-Large	26941-DEFAULT-s.jpg	4	1000	N0311901	383490	LONG SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	volcom/volcom-lido-heather-long-sleeve-rashguard-383490	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	104.99	0	104.99	26238-DEFAULT-l.jpg	104	26238-DEFAULT-m.jpg	F8 Blackstix 3.0 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]	1	100-to-150	0.00	[empty string]	Futures F8 Blackstix Tri-Fins	<p>The F8 Blackstix is a large size Speed Generating fin wth a Ride Number of 9.4. Featuring a neutral template this is the largest set in the Blackstix lineup. The Blackstix construction and V2 foil are ideal for building speed in smaller waves.</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>15.90</td> <td>15.90</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.64</td> <td>4.64</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.47</td> <td>4.47</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]	26238-DEFAULT-s.jpg	22	1000	4575-421-00	325200	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-f8-blackstix-trifins-325200	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	55.99	0	55.99	26262-DEFAULT-l.jpg	55	26262-DEFAULT-m.jpg	F4/Qd2 3.75 ` Quad Set - Thermotech	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]	Futures Thermotech F4 Fins	<p>Thermotech fins do not have the traditional plastic feel of a composite fin. Instead they have a consistent flex that creates drive and release through turns. Thermotech fins come with the Futures Truss Base, making them lighter and stronger.</p> <div class="panel-group pdt-detail-panel" id="accordion" style="box-sizing:border-box; margin-bottom:20px"> <div class="each-panel-pdt panel panel-default" style="border-bottom:1px solid #dddddd; border-image:initial; border-left:none; border-radius:0px; border-right:none; border-top:none; box-shadow:none; box-sizing:border-box; margin-bottom:0px; margin-top:0px !important"> <div class="collapse in panel-collapse" id="collapse2" style="box-sizing:border-box; display:block"> <div class="panel-body" style="border-top:1px solid #dddddd; box-sizing:border-box; padding:17px 0px !important"> <div class="specification" style="box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-weight:normal; line-height:25px"> <table cellspacing="0" class="specf-table" style="background-color:transparent; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; width:537.6px"> <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.22</td> <td>14.22</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.37</td> <td>4.37</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.22</td> <td>4.22</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table> </div> </div> </div> </div> </div>	[empty string]	N	56	56	[empty string]	26262-DEFAULT-s.jpg	25	1000	3140-304-47	304419	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-thermotech-f4-fins-304419	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Coal	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	33.99	0	33.99	26075-DEFAULT-l.jpg	33	26075-DEFAULT-m.jpg	9 ` Reg Ankle Essential 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]	3	25-to-50	0.00	[empty string]	FCS Longboard Ankle Essential Leash - 9'	<p>Day-to day performance and ?reliability in a wide range of conditions.</p>	[empty string]	N	34	34	[empty string]	26075-DEFAULT-s.jpg	43	1000	2020-09F	374715	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-longboard-ankle-essential-leash-9-374715	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Coal,Cobalt,Fluro Green	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	29.99	0	29.99	26074-DEFAULT-l.jpg	29	26074-DEFAULT-m.jpg	7 ` Reg Essential 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]	8	25-to-50	0.00	[empty string]	FCS Regular Essential Leash - 7'	<p>Day-to-day performance and ?reliability in a wide range of conditions.</p>	[empty string]	N	30	30	[empty string]	26074-DEFAULT-s.jpg	53	1000	2020-07F	374705	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-regular-essential-leash-7-374705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	39.99	0	39.99	27105-DEFAULT-l.jpg	39	27105-DEFAULT-m.jpg	Painted Sand 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]	8	25-to-50	0.00	[empty string]	Slowtide Painted Sand Beach Towel	<p>In collaboration with renowned photographer, Clark Little, we introduce the Painted Sand Towel.</p> <p>Slowtide partners with artists, photographers, designers, and brands to create unique prints for the towels, all while maintaining premium quality. Equipped with a hanging loop feature and made from 100% sustainably sourced cotton, you are guaranteed the best drying experience.</p> <p><strong>Features</strong></p> <ul> <li>For all bodies of water</li> <li>100% super soft & absorbent cotton velour</li> <li>Reactive dye that helps prevent fading</li> <li>One-sided print</li> <li>34" x 62"</li> <li>500 grams (Lightweight)</li> <li>Hanging loop</li> <li>Imported</li> </ul>	[empty string]	N	39.95	39.95	[empty string]	27105-DEFAULT-s.jpg	59	1000	ST192	386673	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-painted-sand-beach-towel-386673	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

VOLCOM Volcom Lido Heather Long Sleeve Rashguard $40.00 | view details

FUTURE FINS Futures F8 Blackstix Tri- Fins $105.00 | view details

FUTURE FINS Futures Thermotech F4 Fins $56.00 | view details

FCS Fcs Longboard Ankle Essential Leash - 9 ' $34.00 | view details

FCS Fcs Regular Essential Leash - 7 ' $30.00 | view details

SLOWTIDE Slowtide Painted Sand Beach Towel $39.95 | 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	Black/Colorado,Grey/Colorado,Dark Grey Heather	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	29.99	0	29.99	25640-DEFAULT-l.jpg	29	25640-DEFAULT-m.jpg	Colorado Cropped Eagle 210 Flex Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	DESTINATION	[empty string]	2013	[empty string]	[empty string]	[empty string]	139	25-to-50	0.00	[empty string]	Never Summer Colorado Cropped Eagle 210 Flexfit Hat	<p>Never Summer Colorado Cropped Eagle 210 Flexfit Hat</p>	[empty string]	N	29.99	29.99	Small/Medium,Large/X-Large	25640-DEFAULT-s.jpg	18	1000	HTCOCROP210	290041	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-colorado-cropped-eagle-210-flexfit-hat-290041	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	BLK/GUM	VANS	VANS	SNOWBOARDING	SNOWBOARDING &GT; BOOTS	189.99	0	189.99	25570-DEFAULT-l.jpg	189	25570-DEFAULT-m.jpg	Mens Hi- Standard Og Ltd Boot	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	2019	[empty string]	OH at 200	[empty string]	26	150-to-200	0.00	[empty string]	Vans x BC Hi-Standard OG LTD Snowboard Boot, Black/Gum, 2019	<p>The Hi-Standard OG Snowboard Boot is the best-selling Vans boot of all time, and continues to be the standard-bearer for classic style and modern performance. The comfort and familiar feel of traditional lace-up closure gains additional support from key features like our Instep Lace Lockout and Internal Web Harness. With its new V1 Waffle Lug outsole and iconic sidestripe, the timeless Vans style speaks for itself.</p>	[empty string]	N	189.95	189.95	7,7.5,8,8.5,10.5,11,11.5,12	25570-DEFAULT-s.jpg	22	1000	VN0A3TFJREJ	373170	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	vans/vans-x-bc-histandard-og-ltd-snowboard-boot-black-gum-2019-373170	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Water Camo Amethyst	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25551-DEFAULT-l.jpg	19	25551-DEFAULT-m.jpg	Water Camo Amethyst Single Layer	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]	SMU	SU17	[empty string]	[empty string]	[empty string]	24	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Water Camo Amethyst	<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>	[empty string]	N	19.99	19.99	[empty string]	25551-DEFAULT-s.jpg	31	1000	F1129	382029	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-water-camo-amethyst-382029	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Green	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	7.99	0	7.99	25840-DEFAULT-l.jpg	7	25840-DEFAULT-m.jpg	Triangle Scraper	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]	2018	[empty string]	[empty string]	[empty string]	14	5-to-10	0.00	[empty string]	Dakine Triangle Scraper	<p>The Triangle Scraper gives you more options in sharpened edges, pointed corners, and angles to hold and apply pressure from. There's a notched corner that's perfect for skimming leftover wax off the edges of your ski or snowboard, and a hole punched in another corner that lets you rig the scraper up to a keyring or lanyard. Sling it over a nail in the garage, your rearview mirror, or around your neck if really want to keep it close at hand.</p>	[empty string]	N	8	8	[empty string]	25840-DEFAULT-s.jpg	36	1000	10001585	357731	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-triangle-scraper-357731	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Aqua	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	29.99	0	29.99	26194-DEFAULT-l.jpg	29	26194-DEFAULT-m.jpg	Aqua Convertible Balaclava	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	24	25-to-50	0.00	[empty string]	Fishmasks Convertible Ballerclava Balaclava, Aqua	<p>Fishmasks Convertible Ballerclava Balaclava, Aqua</p>	[empty string]	N	29.99	29.99	[empty string]	26194-DEFAULT-s.jpg	45	1000	FSH-CONV-AQUA	359542	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-convertible-ballerclava-balaclava-aqua-359542	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	289.99	0	289.99	26361-DEFAULT-l.jpg	289	26361-DEFAULT-m.jpg	Starlet	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]	2019	[empty string]	[empty string]	[empty string]	5	250-to-300	0.00	[empty string]	Never Summer Starlet Kids Snowboard, 2019	<p>This is THE board for your little rock star. It features our playful and forgiving Original Rocker Camber Profile for quick progression to the next level. The Starlet also has Vario Power Grip Sidecut and our Freestyle Damping System for an effortless ride and a famous style. Whether you’re learning to shred or you’re a snowboarding superstar, reach for the Starlet.</p>	[empty string]	N	289.99	289.99	125,130,136	26361-DEFAULT-s.jpg	46	1000	STARLET-I	374759	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-starlet-kids-snowboard-2019-374759	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Colorado Cropped Eagle 210 Flexfit Hat $29.99 | view details

VANS Vans X Bc Hi- Standard Og Ltd Snowboard Boot, Black/Gum, 2019 $189.95 | view details

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

DAKINE Dakine Triangle Scraper $8.00 | view details

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

NEVER SUMMER Never Summer Starlet Kids Snowboard, 2019 $289.99 | view details

Accessories

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	ELECTRIC	ELECTRIC	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	119.99	0	119.99	25967-DEFAULT-l.jpg	119	25967-DEFAULT-m.jpg	Knoxville Xl Darkside Tort/Ohm Gry	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Electric Knoxville XL Sunglasses, Darkside Tort/Grey	<p>Electric Knoxville XL Sunglasses, Darkside Tort/Grey</p>	[empty string]	N	120	120	[empty string]	25967-DEFAULT-s.jpg	2	1000	EE11262320	360979	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-knoxville-xl-sunglasses-darkside-tort-grey-360979	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Tan,Black	RVCA	RVCA	ACCESSORIES	ACCESSORIES &GT; WALLETS	23.99	0	23.99	26898-DEFAULT-l.jpg	23	26898-DEFAULT-m.jpg	Leather Magic Wallet	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]	13	20-to-25	0.00	[empty string]	RVCA Leather Magic Wallet	<p>Holding it all together without losing minimalist design, the rvca leather magic wallet offers a top shelf version of the slim wallet. The interior keeps your goods secure with elastic bands and credit card slots.</p>	[empty string]	N	24	24	One Size	26898-DEFAULT-s.jpg	3	1000	MAWASRML	383248	EMPTY	EMPTY	EMPTY	0	0	0	WALLETS	rvca/rvca-leather-magic-wallet-383248	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Violet	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	11.99	0	11.99	25814-DEFAULT-l.jpg	11	25814-DEFAULT-m.jpg	Fashion Icon 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]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Stance Fashion Icon Classic Light Weight Crew Sock	<p>An elevated take on one of our classics, the Fashion Icon can be dressed up or dressed down, and is suited for any occasion.</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	12	12	Large	25814-DEFAULT-s.jpg	5	1000	M546A18FAS	370604	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-fashion-icon-classic-light-weight-crew-sock-370604	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Maroon	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25797-DEFAULT-l.jpg	13	25797-DEFAULT-m.jpg	Haena 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]	H18	[empty string]	OH at 200	[empty string]	36	10-to-15	0.00	[empty string]	Stance Haena Classic Crew Sock	<p>Lounging in a hammock with an ocean breeze at your back sound good? Bring the beach to you with Stance's Haena, a warm design that can't help but mellow your 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>	[empty string]	N	14	14	Medium,Large	25797-DEFAULT-s.jpg	5	1000	M556D18HAE	380087	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-haena-classic-crew-sock-380087	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	11.99	0	11.99	25804-DEFAULT-l.jpg	11	25804-DEFAULT-m.jpg	Leckey 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]	19	10-to-15	0.00	[empty string]	Stance Leckey Classic Crew Sock	<p>Leckey features too may comforts to name. Don't believe us? Scroll that sweet product knowledge below.</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 Laretto Socks (Grey, Medium)</p>	N	12	12	Medium,Large	25804-DEFAULT-s.jpg	6	1000	M556A18LEC	368939	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-leckey-classic-crew-sock-368939	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Black,White	SANTA CRUZ	SANTA CRUZ	ACCESSORIES	ACCESSORIES &GT; SOCKS	9.99	0	9.99	26912-DEFAULT-l.jpg	9	26912-DEFAULT-m.jpg	Wall Hand Mens Tall Socks	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]	15	5-to-10	0.00	[empty string]	Santa Cruz Wall Hand Tall Socks	<p>Crew sock with allover digital print repeat logo pattern of Jim Phillips Screaming Wall Hand, Santa Cruz Opus Dot on top exterior leg opening, contrast toe and arch support ribbing.</p>	[empty string]	N	9.99	9.99	One Size	26912-DEFAULT-s.jpg	6	1000	44642595	392445	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	santa-cruz/santa-cruz-wall-hand-tall-socks-392445	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]