Costa Del Mar C-Mono Sunglasses Retainer

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]	VANS	VANS	MENS	MENS &GT; SHOES &GT; SKATE SHOES	64.99	0	64.99	25711-DEFAULT-l.jpg	64	25711-DEFAULT-m.jpg	Old Skool Pro Blackout	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[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]	60	50-to-100	0.00	[empty string]	Vans Old Skool Pro Skate Shoe, Blackout	<p>The Old Skool Pro, a Vans classic upgraded for enhanced performance, features suede, canvas, and leather 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 Old Skool 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	65	65	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	25711-DEFAULT-s.jpg	2	1000	VN000ZD41OJ	337085	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-old-skool-pro-skate-shoe-blackout-337085	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	THRASHER	THRASHER	MENS	MENS &GT; ACCESSORIES	3.99	0	3.99	26464-DEFAULT-l.jpg	3	26464-DEFAULT-m.jpg	Logo Patch	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-and-under	0.00	[empty string]	Thrasher Logo Patch, Assorted Colors	<p>Thrasher Magazine 2 x 4" twill embroidered patch with iron-on backing. patch color subject to random selection by the mail order dudes</p>	[empty string]	N	3.5	3.5	[empty string]	26464-DEFAULT-s.jpg	5	1000	3130012	294195	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	thrasher/thrasher-logo-patch-assorted-colors-294195	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPY	SPY	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	109.99	0	109.99	26016-DEFAULT-l.jpg	109	26016-DEFAULT-m.jpg	Cyrus Matte Blk/Happy Gry Grn	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Spy Cyrus Sunglasses, Matte Black/Happy Gray Green	<p>With ultra-thick sides and a front that commands attention, there’s nothing quiet about the Cyrus. And with the uplift in mood and energy its Happy Lens™ fosters, the Cyrus is sure to create some joyful noise. Available with Trident™ polarization that eliminates reflective light.</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>6-base polycarbonate ARC® lenses for optical performance</li> <li>Sturdy and smooth 5-barrel hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 58-17-145</li> </ul>	[empty string]	N	110	110	[empty string]	26016-DEFAULT-s.jpg	10	1000	673180374863	308223	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-cyrus-sunglasses-matte-black-happy-gray-green-308223	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VANS	VANS	MENS	MENS &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	10	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]
5	[empty string]	SUN BUM	SUN BUM	MENS	MENS &GT; ACCESSORIES	3.99	0	3.99	25575-DEFAULT-l.jpg	3	25575-DEFAULT-m.jpg	Watermelon Spf 30 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	3548	5-and-under	0.00	[empty string]	Sun Bum SPF 30 Lip Balm, Watermelon	<p>Grab as many as you can because we literally can't keep any of our lip balm flavors in stock. Our smooth SPF 30 sunscreen lip balm with added Aloe and Vitamin E will protect and moisturize your kisser all day long... just try not to lick it off.</p>	[empty string]	N	3.99	3.99	[empty string]	25575-DEFAULT-s.jpg	11	1000	20-46023	357166	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-30-lip-balm-watermelon-357166	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	69.99	0	69.99	26608-DEFAULT-l.jpg	69	26608-DEFAULT-m.jpg	Court Graffik Sq Pewter	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]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	DC Court Graffik Skate Shoes, Pewter	<p>The nuts and bolts</p> <ul> <li>Leather, nubuck, suede upper with split quarter panel</li> <li>Foam padded collar and tongue for comfort and support</li> <li>Cupsole construction</li> <li>Ventilation holes for breathability</li> <li>Lightweight mesh tongue</li> <li>DC's trademarked Pill Pattern tread <p> </p> </li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	26608-DEFAULT-s.jpg	11	1000	ADYS100442-PEW	382989	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-court-graffik-skate-shoes-pewter-382989	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VANS Vans Old Skool Pro Skate Shoe, Blackout $65.00 | view details

THRASHER Thrasher Logo Patch, Assorted Colors $3.50 | view details

SPY Spy Cyrus Sunglasses, Matte Black/Happy Gray Green $110.00 | view details

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

SUN BUM Sun Bum Spf 30 Lip Balm, Watermelon $3.99 | view details

DC Dc Court Graffik Skate Shoes, Pewter $70.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	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	251	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
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	813	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25578-DEFAULT-l.jpg	5	25578-DEFAULT-m.jpg	Sunset Cove Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	147	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sunset Cove	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25578-DEFAULT-s.jpg	847	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	Cool Wip	BILLABONG	BILLABONG	WOMENS	WOMENS &GT; TOPS &GT; T-SHIRTS	29.99	0	29.99	27150-DEFAULT-l.jpg	29	27150-DEFAULT-m.jpg	Stripe Palm Ss T	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]	SU19	[empty string]	[empty string]	[empty string]	33	25-to-50	0.00	[empty string]	Billabong Stipe Palm Short Sleeve T-Shirt	<p>Set your sights on a palm-lined horizon. Featuring a pocket tee cut and slightly oversized fit, the women’s graphic t-shirt is finished with a palm tree print across the chest.</p> <p>The nuts and bolts</p> <ul> <li>Womens graphic t-shirt</li> <li>Pocket tee</li> <li>Short sleeves.</li> <li>Crew neck.</li> <li>Palm trees graphic across chest. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	29.95	29.95	X-Small,Small,Medium,Large	27150-DEFAULT-s.jpg	5	1000	J477UBST	385487	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-stipe-palm-short-sleeve-tshirt-385487	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	15.99	0	15.99	13947-DEFAULT-l.jpg	15	13947-DEFAULT-m.jpg	Spf 15 Lotion 8oz Sunscreen	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH AT 200	[empty string]	0	15-to-20	0.00	[empty string]	Sun Bum SPF 30 Sunscreen Lotion, 8 oz.	<p>This moisturizing sunscreen formula will protect your skin from harmful UVA/UVB rays while enriching your skin with Vitamin E, an antioxidant that helps to neutralize free radicals, which are the main cause of premature skin aging.</p>	[empty string]	N	15.99	15.99	[empty string]	13947-DEFAULT-s.jpg	6	1000	20-40015	271632	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-30-sunscreen-lotion-8-oz-271632	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPY	SPY	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	119.99	0	119.99	26007-DEFAULT-l.jpg	119	26007-DEFAULT-m.jpg	Dirty Mo Soft Matte Blk/Happy 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]	5	100-to-150	0.00	[empty string]	Spy Dirty Mo Sunglasses, Soft Matte Black/Happy Gray Green	<p>The original and iconic Dale Jr.-designed eyewear, the Dirty Mo is for those who know how to race and play to win. This midsized wrap features a chiseled surface, bold details, and the Happy Lens™, the lens that lets in the good and keeps out the bad. Also available with Trident™ polarization.</p> <ul> <li>Available with the color and contrast enhancing Happy Lens™ and Trident™ polarization</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>8-base polycarbonate ARC® lenses for increased optical performance</li> <li>High-quality, long-lasting pin hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 61-17-121</li> </ul>	[empty string]	N	120	120	[empty string]	26007-DEFAULT-s.jpg	10	1000	670937219863	330023	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-dirty-mo-sunglasses-soft-matte-black-happy-gray-green-330023	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 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

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

BILLABONG Billabong Stipe Palm Short Sleeve T- Shirt $29.95 | view details

SUN BUM Sun Bum Spf 30 Sunscreen Lotion, 8 Oz. $15.99 | view details

SPY Spy Dirty Mo Sunglasses, Soft Matte Black/Happy Gray Green $120.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	Blue	STANCE	STANCE	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	27120-DEFAULT-l.jpg	14	27120-DEFAULT-m.jpg	Boys Recess 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]	11	10-to-15	0.00	[empty string]	Stance Recess Boys Boxer Brief	<p>He works hard in school, he deserves some fun. In honor of his favorite class we give you Boys Recess.</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	27120-DEFAULT-s.jpg	12	1000	B803A19REC	383921	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-recess-boys-boxer-brief-383921	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	64.99	0	64.99	27133-DEFAULT-l.jpg	64	27133-DEFAULT-m.jpg	Old Skool (Chambray) True Navy/True Wht	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	NAVY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	73	50-to-100	0.00	[empty string]	Vans Chambray Old Skool Skate Shoe, True Canvas Navy/True White	<p>The Chambray Classic Slip-On features sturdy low profile textile and canvas uppers, padded collars, elastic side accents, and signature rubber waffle outsoles.</p> <p>SIZE DISPLAYED IN DROP DOWN IS BOYS/MENS<br /> 3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	65	65	4.5,5.5,6,7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27133-DEFAULT-s.jpg	34	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]
3	Fog Blue/Multi	ARCADE	ARCADE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	17.99	0	17.99	25902-DEFAULT-l.jpg	17	25902-DEFAULT-m.jpg	The Rambler Youth Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	16	15-to-20	0.00	[empty string]	Arcade Rambler Youth Belt	<p>Everything Arcade is known for in a kid-sized package, meet the Arcade Rambler LTD  youth adventure belt. A fully adjustable minimal buckle is perfect for growing kids and smaller belt loops. Elastic stretch webbing means your kiddo stays comfortable all day and their pants stay where they’re supposed to. Made from machine friendly and quick drying materials means clean up is a breeze for messy kids. Sized for kids ages 4-12.</p> <ul> <li>Kid-friendly</li> <li>Machine washable</li> <li>Travel-Friendly</li> <li>Belt width – 1.25″ (3.17cm)</li> <li>Fits up to 32″/81.3cm</li> </ul>	[empty string]	N	18	18	[empty string]	25902-DEFAULT-s.jpg	39	1000	Y14300-94	384917	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	arcade/arcade-rambler-youth-belt-384917	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	25815-DEFAULT-l.jpg	13	25815-DEFAULT-m.jpg	Bones 2 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]	5	10-to-15	0.00	[empty string]	Stance Bones 2 Boys Kids Crew Sock	<p>Whether it's Halloween or 4th of July, Stance's Bones2 are a wardrobe essential. With a classic skeleton design that glows in the dark this sock is a perfect fit for your attire.</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	25815-DEFAULT-s.jpg	70	1000	M556D18BO2	380074	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-bones-2-boys-kids-crew-sock-380074	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Blue,Yellow	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25938-DEFAULT-l.jpg	8	25938-DEFAULT-m.jpg	C- Mono Retainer	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	11	5-to-10	0.00	[empty string]	Costa Del Mar C-Mono Sunglasses Retainer	<p>Costa C-Mono™ Retainer. High tenacity monofilament. Sleek and ultra lightweight. Flat, low profile temple attachments.  <strong>End-to-End Measurement: </strong>20"</p>	[empty string]	N	8.99	8.99	[empty string]	25938-DEFAULT-s.jpg	73	1000	CM46	364615	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-cmono-sunglasses-retainer-364615	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	7.99	0	7.99	25946-DEFAULT-l.jpg	7	25946-DEFAULT-m.jpg	Neoprene Classic Black Retainer	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	1	5-to-10	0.00	[empty string]	Costa Del Mar Neoprene Sunglasses Retainer	<p>Neoprene Classic. Neoprene retainers have long been the best option in the business. Costa neoprenes slide onto frame arms and grip tight. And their wide design makes them comfortable when glasses are on, or hanging around your neck.  <strong>End-to-End Measurement: </strong>16"</p>	[empty string]	N	7.99	7.99	[empty string]	25946-DEFAULT-s.jpg	92	1000	CR11	364623	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-neoprene-sunglasses-retainer-364623	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Recess Boys Boxer Brief $15.00 | view details

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

ARCADE Arcade Rambler Youth Belt $18.00 | view details

STANCE Stance Bones 2 Boys Kids Crew Sock $14.00 | view details

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

COSTA DEL MAR Costa Del Mar Neoprene Sunglasses Retainer $7.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	[empty string]	SUPRA	SUPRA	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	74.99	0	74.99	26932-DEFAULT-l.jpg	74	26932-DEFAULT-m.jpg	Hammer Vtg White/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	50-to-100	0.00	[empty string]	Supra Hammer VTG Skate Shoe, White/White	<p>The hammer vtg is jim greco’s newest pro model. This vintage inspired skate shoe uses the same last as the greco, giving it a slim and classic shape. The upper consists of a premium suede vamp/collar/heel with a breathable canvas quarter. The design has references that tie back to the hammer franchise and overlays are detailed by premium french binding. The hammer vtg uses a rubber toe cap and sit atop a brand new vulcanized outsole utilizing dual-layered herringbone tread for ultimate board feel and long lasting durability. The shoe also features the brand new super comfort insole for peak impact protection and all day comfort.<br />  </p>	[empty string]	N	75	75	8,8.5,9,9.5,10,10.5,11,12	26932-DEFAULT-s.jpg	3	1000	06123-101	384710	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	supra/supra-hammer-vtg-skate-shoe-white-white-384710	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Violet,Blue,Red	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25796-DEFAULT-l.jpg	13	25796-DEFAULT-m.jpg	Pau 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]	14	10-to-15	0.00	[empty string]	Stance Pau Classic Crew Sock	<p>Mahalo! Take it easy in the tropical paradise inspired Pau.</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	25796-DEFAULT-s.jpg	5	1000	M556C18PAU	370571	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-pau-classic-crew-sock-370571	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Blue	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25743-DEFAULT-l.jpg	13	25743-DEFAULT-m.jpg	Pop Palms 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]	19	10-to-15	0.00	[empty string]	Stance Pop Palms Classic Crew Sock	<p>Soak in the salty air in style with Pop Palm, a classic sock with ocean blue colors, and palm tree designs that will keep your watch on perpetual island time.</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	25743-DEFAULT-s.jpg	9	1000	M556D18POP	380088	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-pop-palms-classic-crew-sock-380088	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,COF	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	59.99	0	59.99	26670-DEFAULT-l.jpg	59	26670-DEFAULT-m.jpg	Ortho- Bounce Coast Womens Sandals	N	WOMENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	90	50-to-100	0.00	[empty string]	Reef Ortho-Bounce Coast Sandal	<p>Walking to the beach has never felt more comfortable, thanks to the Reef Ortho-Bounce Coast Sandal. Trust us when we say you'll love our all new enhanced arch support and optimized heel cupping!</p> <ul> <li>Enhanced arch support and optimized heel cupping deliver anatomical contouring for all day comfort</li> <li>Shock absorbent cushion bounce footbed to reduce impact under every step</li> <li>Eco-One Enhanced Biodegradability footbed</li> <li>Vegan leather detailed straps with padding for comfort</li> <li>Made with PVC Free materials</li> <li>Molded rubber outsole with flex groves for maximum movement and traction</li> </ul>	[empty string]	N	60	60	5,6,7,8,9,10,11	26670-DEFAULT-s.jpg	9	1000	A3VDO	382191	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-orthobounce-coast-sandal-382191	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Orange,Red	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	17.99	0	17.99	25747-DEFAULT-l.jpg	17	25747-DEFAULT-m.jpg	Migos 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]	[empty string]	[empty string]	12	15-to-20	0.00	[empty string]	Stance Migos Anthem Classic Crew Sock	<p>Following the success of last year’s multi-platinum album, Culture, Atlanta, Georgia’s famed trap trio, MIGOS, released their follow-up album, Culture II, which sold millions of records and took the music world by storm. In honor of the trap trio’s latest album, Stance is proud to join members Quavo, Takeoff, and Offset in dropping the new MIGOS collection, featuring three 200-needle color ways. Each sock has a unique design, which draws inspiration from Culture II, and the group’s unique personal style.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Cushioning</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	18	18	Large	25747-DEFAULT-s.jpg	10	1000	M545A18MIG	374325	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-migos-anthem-classic-crew-sock-374325	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	26789-DEFAULT-l.jpg	69	26789-DEFAULT-m.jpg	Comfycush Old Skool Navy/Stv Navy	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]	NAVY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	54	50-to-100	0.00	[empty string]	Vans ComfyCush Old Skool Skate Shoe	<p>Vans has reinvigorated the classic Checker Old Skool by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Checker Old Skool 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>	[empty string]	N	70	70	5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26789-DEFAULT-s.jpg	21	1000	VN0A3WMAVNT	383075	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-comfycush-old-skool-skate-shoe-383075	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SUPRA Supra Hammer Vtg Skate Shoe, White/White $75.00 | view details

STANCE Stance Pau Classic Crew Sock $14.00 | view details

STANCE Stance Pop Palms Classic Crew Sock $14.00 | view details

REEF Reef Ortho- Bounce Coast Sandal $60.00 | view details

STANCE Stance Migos Anthem Classic Crew Sock $18.00 | view details

VANS Vans Comfycush Old Skool Skate Shoe $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]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	128.99	0	128.99	26417-DEFAULT-l.jpg	128	26417-DEFAULT-m.jpg	Nickel Special Ops Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	Penny Skateboards Special Ops Nickel Complete Skateboard, 27"	<p>Stay under the radar with the Special Ops 27" cruiser. Grey digi camo graphic deck and truck wraps will have you rolling stealth wherever your adventure takes you. Like all Penny cruisers, it comes backed by our limited lifetime warranty so you can roll worry free.</p> <ul> <li>27" Plastic Deck</li> <li>4-inch aluminum trucks with powder-coated finish</li> <li>59mm, 83A wheels for a smooth ride</li> <li>83A color-coded cushions</li> <li>Color-coded high tensile deck bolts</li> <li>Quality Color-coded Abec 7 stainless steel bearings</li> </ul>	[empty string]	N	129	129	27IN	26417-DEFAULT-s.jpg	3	1000	PNYCOMP27426	374210	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-special-ops-nickel-complete-skateboard-27-374210	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	CRAILTAP	CRAILTAP	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	12.99	0	12.99	27008-DEFAULT-l.jpg	12	27008-DEFAULT-m.jpg	Multi Color Grip Tape 4- Pack	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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	10-to-15	0.00	[empty string]	Crailtap Multi-Color Griptape 4-Pack	<p>Crailtap has partnered with some of skateboarding's most creative and innovative leaders to develop this multi-colored 4-pack of 10" x 10" grip tape squares. Pimp your ride by cutting the squares any way you'd like and sticking them to your stick! The sure-fire way to hipper than hip grip.</p> <ul> <li>4 x 10" x 10" sheets</li> <li>Die-cut crailtap logo on black sheet</li> <li>Perforated grip to reduce air bubbles</li> <li>Cut & colage & homage</li> </ul> <form action="https://crailstore.com/cart/add" enctype="multipart/form-data" id="addToCart" method="post"> </form>	[empty string]	N	12.99	12.99	[empty string]	27008-DEFAULT-s.jpg	4	1000	CTA325	393708	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	crailtap/crailtap-multicolor-griptape-4pack-393708	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	69.99	0	69.99	26740-DEFAULT-l.jpg	69	26740-DEFAULT-m.jpg	Slasher Reissue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Santa Cruz Slasher Re-Issue Skateboard Deck, 10" x 31"	<p>Straight from the archives comes new Santa Cruz Re-Issues! Santa Cruz Skateboards is proud to release four new reissues! For the first time since it's original production, Jim Phillips' iconic "Slasher” graphic is back on its original shape and in a new, never before printed colorway. A must have for any fan of the 80’s. Hang this baby on your wall or set up a one of a kind skateboard. Either way, you won't be disappointed.</p>	[empty string]	N	69.99	69.99	10.1	26740-DEFAULT-s.jpg	7	1000	11115419	391905	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-slasher-reissue-skateboard-deck-10-x-31-391905	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	188.99	0	188.99	27050-DEFAULT-l.jpg	188	27050-DEFAULT-m.jpg	Battle Axe 38 Fox Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Landyachtz Battle Axe 38 Fox Complete Longboard, 38"	<p>A classic pintail shape and lowered standing platform might be the best combination out there for someone looking to pick up a board for the first time and learn to ride. Get out and explore your city in style with a Battle Axe!  </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>Drop Thru</li> <li>Medium Concave</li> <li>Rocker</li> </ul>	[empty string]	N	189	189	38IN	27050-DEFAULT-s.jpg	8	1000	119-FRBA38FX	386936	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-battle-axe-38-fox-complete-longboard-38-386936	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GLOBE	GLOBE	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	154.99	0	154.99	27037-DEFAULT-l.jpg	154	27037-DEFAULT-m.jpg	Geminon Coconut Reaper 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]	10	150-to-200	0.00	[empty string]	Globe Geminon 35 Complete Longboard, 35"	<p>+ Symmetrical drop-thru cutaway board for cruising, slopes, and beginner to intermediate downhill</p> <p>+ 35" x 9" x 24.75" WB</p> <p>+ Coconut + hard rock maple</p> <p>+ Slight side-to-side concave</p> <p>+ 180mm Slant aluminum reverse kingpin trucks</p> <p>+ 70mm Conical 83a wheels</p> <p>+ Clear broadcast grip</p>	[empty string]	N	154.99	154.99	35IN	27037-DEFAULT-s.jpg	12	1000	10525235COCOREAP	383794	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	globe/globe-geminon-35-complete-longboard-35-383794	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	TRIPLE EIGHT	TRIPLE EIGHT	SKATEBOARDS	SKATEBOARDS &GT; PROTECTIVE GEAR &GT; PADS	59.99	0	59.99	26182-DEFAULT-l.jpg	59	26182-DEFAULT-m.jpg	Bumsavers Protective Shorts	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]	9	50-to-100	0.00	[empty string]	Triple Eight Bumsaver Protective Shorts	<p>Protect your rear, hips and thighs with our Bumsaver padded shorts. Designed to wear discreetly under your clothes, they’re made with a lightweight, breathable, form-fitting mesh fabric for an extra comfy fit. But let’s keep that between us.</p> <ul> <li>Soft, breathable, form-fitting mesh design for greater flexibility & comfort</li> <li>Shock absorbing EVA foam throughout the hip & tailbone areas</li> <li>Removable pads for easy washing</li> </ul>	[empty string]	N	59.99	59.99	X-Small,Small,Medium,Large,X-Large	26182-DEFAULT-s.jpg	30	1000	T8BSS	298679	PADS	EMPTY	EMPTY	0	0	0	PROTECTIVE GEAR	triple-eight/triple-eight-bumsaver-protective-shorts-298679	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

PENNY Penny Skateboards Special Ops Nickel Complete Skateboard, 27 " $129.00 | view details

CRAILTAP Crailtap Multi- Color Griptape 4- Pack $12.99 | view details

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

LANDYACHTZ Landyachtz Battle Axe 38 Fox Complete Longboard, 38 " $189.00 | view details

GLOBE Globe Geminon 35 Complete Longboard, 35 " $154.99 | view details

TRIPLE EIGHT Triple Eight Bumsaver Protective Shorts $59.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]	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	66.99	0	66.99	26120-DEFAULT-l.jpg	66	26120-DEFAULT-m.jpg	Tech 2 Fin Black/Green - Small	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	50-to-100	0.00	[empty string]	Hydro Tech 2 Fins - Black/Green - Small	<p><strong>SIZE:</strong> SMALL</p> <ul> <li> <p>Super soft silicone for unsurpassed comfort.</p> </li> <li> <p>V Rail Design for maximum speed and traction.</p> </li> <li> <p>Ergonomic foot cavity for ultimate fit.</p> </li> <li> <p>Non-slip tread.</p> </li> <li> <p>Central vortex drainage for sand and water.</p> </li> <li> <p>Perfect for bodyboarding and surf swimming.</p> </li> </ul>	[empty string]	N	67	67	[empty string]	26120-DEFAULT-s.jpg	5	1000	TTWO-BLG-SMF	348412	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	hydro/hydro-tech-2-fins-black-green-small-348412	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	27106-DEFAULT-l.jpg	29	27106-DEFAULT-m.jpg	Black Hills Off Wht 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]	5	25-to-50	0.00	[empty string]	Slowtide Black Hills Off White Beach Towel	<p>Itchin’ for an Indian Summer with the crew and the Black Hills towel. An update to a favorite Slowtide 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>30" x 60"</li> <li>460 grams (Lightweight)</li> <li>Hanging loop</li> <li>Imported</li> </ul>	[empty string]	N	29.95	29.95	[empty string]	27106-DEFAULT-s.jpg	5	1000	ST185	386674	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-black-hills-off-white-beach-towel-386674	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Blue	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	39.99	0	39.99	26114-DEFAULT-l.jpg	39	26114-DEFAULT-m.jpg	Body Surfer Pro 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]	1	25-to-50	0.00	[empty string]	Hydro Body Surfer Pro Handboard - Blue	<ul> <li> <p>The ultimate hand surfer with heavy duty hand & wrist strap.</p> </li> </ul>	[empty string]	N	39.99	39.99	One Size	26114-DEFAULT-s.jpg	8	1000	79004	280713	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	hydro/hydro-body-surfer-pro-handboard-blue-280713	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Vintage Blue,Charcoal Heather	VOLCOM	VOLCOM	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	34.99	0	34.99	26940-DEFAULT-l.jpg	34	26940-DEFAULT-m.jpg	Lido Heather Ss 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]	39	25-to-50	0.00	[empty string]	Volcom Lido Heather Short Sleeve Rashguard	<p>If tight fitting clothing isn't your cup of tea the Lido Heather short sleeve rash guard steps up. Made of hybrid jersey fabric, the fit comes off as more of a t-shirt but still offers the protection you need. <br /> <br /> Loose fit rash guard<br /> Hybrid jersey fabric<br /> 30+ UV protection</p>	[empty string]	N	35	35	Small,Medium,Large,X-Large,XX-Large	26940-DEFAULT-s.jpg	8	1000	N0111901	383488	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	volcom/volcom-lido-heather-short-sleeve-rashguard-383488	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; SURF ACCESSORIES &GT; FINS	54.99	0	54.99	26124-DEFAULT-l.jpg	54	26124-DEFAULT-m.jpg	Fcs Ii Performer Gf Medium Tri	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]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	FCS II Performer Glass Flex Tri Fins - Medium	<p>Balance of speed, flow and response. Suitable for all conditions.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for a balance of speed, flow & response.</li> <li>Well proportioned template with Inside Foil Technology (IFT).</li> <li>Ideal for surfers who want a reliable ‘All Round’ fin delivering a combination of speed and maneuverability with flow between turns.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>A wide range of conditions from beach breaks to point breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for all board types.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Performer: Find Balance. A balance of speed, flow & response.</li> </ul>	[empty string]	N	55	55	[empty string]	26124-DEFAULT-s.jpg	12	1000	FPER-GF01-MD-TS-R	305900	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-performer-glass-flex-tri-fins-medium-305900	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; DIVE &GT; FINS	76.99	0	76.99	26336-DEFAULT-l.jpg	76	26336-DEFAULT-m.jpg	Tech 2 Fin White/Green - Large	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[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	50-to-100	0.00	[empty string]	Hydro Tech 2 Fins - White/Green - Large	<ul> <li> <p>Super soft silicone for unsurpassed comfort.</p> </li> <li> <p>V Rail Design for maximum speed and traction.</p> </li> <li> <p>Ergonomic foot cavity for ultimate fit.</p> </li> <li> <p>Non-slip tread.</p> </li> <li> <p>Central vortex drainage for sand and water.</p> </li> <li> <p>Perfect for bodyboarding and surf swimming.</p> </li> </ul>	[empty string]	N	77	77	[empty string]	26336-DEFAULT-s.jpg	12	1000	TTWO-WHG-LGF	348425	FINS	EMPTY	EMPTY	0	0	0	EMPTY	hydro/hydro-tech-2-fins-white-green-large-348425	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

HYDRO Hydro Tech 2 Fins - Black/Green - Small $67.00 | view details

SLOWTIDE Slowtide Black Hills Off White Beach Towel $29.95 | view details

HYDRO Hydro Body Surfer Pro Handboard - Blue $39.99 | view details

VOLCOM Volcom Lido Heather Short Sleeve Rashguard $35.00 | view details

FCS Fcs Ii Performer Glass Flex Tri Fins - Medium $55.00 | view details

HYDRO Hydro Tech 2 Fins - White/Green - Large $77.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	STONE	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	29.99	0	29.99	26193-DEFAULT-l.jpg	29	26193-DEFAULT-m.jpg	Stone Convertible Balaclava	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Fishmasks Convertible Ballerclava Balaclava, Stone	<p>Fishmasks Convertible Ballerclava Balaclava, Stone</p>	[empty string]	N	29.99	29.99	[empty string]	26193-DEFAULT-s.jpg	6	1000	FSH-CONV-STONE	359415	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-convertible-ballerclava-balaclava-stone-359415	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	DORSAL	DORSAL	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	25.99	0	25.99	26063-DEFAULT-l.jpg	25	26063-DEFAULT-m.jpg	Aero Sup Surf Rack Pads 28 Inch Long - 2	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	63	25-to-50	0.00	[empty string]	Dorsal Aero Roof Rack Pads for Car - Kayak, SUP, Snowboard, Surf - 28"	<p><strong>Are You Looking For An Effective And Efficient Way To Convey Surfboards, Snowboards and most Kayaks, As Well As Stand-Up Paddle Boards</strong></p> <p><strong>Start Using the Dakine Thule and Yakima Wide Flat bar Compatible Dorsal SUP Rack Pads Set, Armed With Essential Features That Make This Product Apart From The Rest.</strong></p> <ul> <li> <ul> <li> <p><strong>Easy Convey Of Surfboards, Kayaks, As Well As Stand-Up Paddle Boards</strong> This 28 inch (Dakine Style) Dorsal SUP Rack Pads set offer an effective way to convey surf boards, snowboards, kayaks, as well as stand-up paddle boards.</p> </li> <li> <p><strong>Fits Aero</strong> (Flat Bar) 5.5" - 8.0" [ 14-20cm ] bar circumference. For Square or Round Bar See Dorsal's Round Bar Pads (see diagram).</p> </li> <li> <p><strong>Reliable Material For Longer Life</strong> - This rack pads set is integrated with top grade EVA foam and is secured by a weather proof nylon sleeve. It comes with pads that will secure a kayak or board from your cars cross bars. This is also perfect for bigger surfboard roof rack transport in a smooth aerodynamic style. This is wide enough to transport surfboard with care.</p> </li> <li> <p><strong>Securing Your Surf Boards</strong> - Keep your surf board secure and safe for the next journey with the amazing and state of the art Dorsal Origin Car Surf Kayak SUP Rack Pads; which is made of with durable 600D polyester material. Top of the bar is padded for sleek fit. It comes with heavy duty velcro, 28 inches long pad as well as it fits a lot of factory auto car racks.</p> </li> </ul> </li> </ul>	[empty string]	N	25.94	25.94	[empty string]	26063-DEFAULT-s.jpg	7	1000	DORSAL-ORIGIN-BW-RACK-PAD	368237	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dorsal/dorsal-aero-roof-rack-pads-for-car-kayak-sup-snowboard-surf-28-368237	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	529.99	0	529.99	26352-DEFAULT-l.jpg	529	26352-DEFAULT-m.jpg	Maverix	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	500-and-over	0.00	[empty string]	Never Summer Maverix Snowboard, 2019	<p>While standing on the edge of dawn, the sound of the waves growing louder, we stared out into the vastness. Anticipation ruled the moment. We were anxious as we imagined the approaching exhilaration. That’s when it hit us...Maverix! The perfect snowboard. A super nimble yet cushy ride with incredible responsiveness. Amazing performance and stylized fluidity that crushes all conditions...not just the best conditions. Leave everyone wondering where you found that surfy steez. LT - Narrower version of the original.</p>	[empty string]	N	529.99	529.99	157,160,163	26352-DEFAULT-s.jpg	45	1000	MAVERIX-I	374735	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-maverix-snowboard-2019-374735	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	DOTBLUECAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26201-DEFAULT-l.jpg	19	26201-DEFAULT-m.jpg	Dot Blue Camo Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	42	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Dot Camo Blue	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	<p>Fishmasks Single Layer Neck Gaiter - Lightweight, Fishing Protection From Sun, Wind And Moisture - Made In USA - UPF 50+ Moisture-Wicking Fabric - Dot Camo Blue</p>	N	19.99	19.99	[empty string]	26201-DEFAULT-s.jpg	49	1000	FSH-SL-DOTBLUECAMO	359384	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-dot-camo-blue-359384	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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/White Trees,USA Flag	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	24.99	0	24.99	26382-DEFAULT-l.jpg	24	26382-DEFAULT-m.jpg	Timberline Dl Tube Facemask	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]	15	20-to-25	0.00	[empty string]	Never Summer Timberline Convertible Balacava	<p>Never Summer Timberline Convertible Balacava</p>	<p>Never Summer Timberline Convertible Balacava (Colorado Bells)</p>	N	24.99	24.99	One Size	26382-DEFAULT-s.jpg	54	1000	FMTIMTUBE	374875	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	never-summer/never-summer-timberline-convertible-balacava-374875	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	DIGICAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	29.99	0	29.99	26202-DEFAULT-l.jpg	29	26202-DEFAULT-m.jpg	Digicamo 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]	18	25-to-50	0.00	[empty string]	Fishmasks Convertible Ballerclava Balaclava, Digicamo	<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	29.99	29.99	[empty string]	26202-DEFAULT-s.jpg	55	1000	FSH-CONV-DIGICAMO	359419	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-convertible-ballerclava-balaclava-digicamo-359419	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

DORSAL Dorsal Aero Roof Rack Pads For Car - Kayak, Sup, Snowboard, Surf - 28 " $25.94 | view details

NEVER SUMMER Never Summer Maverix Snowboard, 2019 $529.99 | view details

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

NEVER SUMMER Never Summer Timberline Convertible Balacava $24.99 | view details

FISHMASKS Fishmasks Convertible Ballerclava Balaclava, Digicamo $29.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	Red	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25807-DEFAULT-l.jpg	13	25807-DEFAULT-m.jpg	Boy's Amazing Spiderman Sock	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	RESTRICTED	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	18	10-to-15	0.00	[empty string]	Stance Amazing Spiderman Kids Marvel Comics Crew Sock	<p>Everyone's favorite arachnid, our Amazing Spiderman socks are guaranteed to get your spidey sense tingling. Officially licensed by Marvel and personally-approved by your friendly neighborhood webslinger.</p> <p>FEATURES</p> <ul> <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	14	14	Small,Medium,Large	25807-DEFAULT-s.jpg	3	1000	B515D18AMA	380147	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-amazing-spiderman-kids-marvel-comics-crew-sock-380147	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUNCLOUD	SUNCLOUD	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	49.99	0	49.99	26021-DEFAULT-l.jpg	49	26021-DEFAULT-m.jpg	Rambler Blk Gry Fade/Silv Mirror	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Suncloud Rambler Medium Fit Sunglasses, Black Grey Fade/Silver Mirror	<p>The Rambler sunglasses by Suncloud boast a strong, square profile. The Rambler is a medium-fit, polarized sunglass with style to spare.</p> <p>Lens width: 57</p> <p>Lens height: 45</p> <p>Nose bridge: 19</p> <p>Temple length: 133</p> <p> </p>	[empty string]	N	49.99	49.99	[empty string]	26021-DEFAULT-s.jpg	11	1000	S-RBPPSVMBGY	358678	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	suncloud/suncloud-rambler-medium-fit-sunglasses-black-grey-fade-silver-mirror-358678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPY	SPY	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	109.99	0	109.99	27257-DEFAULT-l.jpg	109	27257-DEFAULT-m.jpg	Mccoy Soft Matte Blk/Happy 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	100-to-150	0.00	[empty string]	Spy McCoy Sunglasses, Soft Matte Black/Happy Gray Green	<p>The McCoy harkens back to the speakeasies and moonshine runners who gave birth to NASCAR. Available with the Happy Lens™ and Trident™ polarization, the McCoy features a virtually indestructible Grilamid® construction.</p> <ul> <li>Available with the Happy Lens™ and Trident™ polarization</li> <li>88 Dale Jr. signature inside print</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>8-base polycarbonate ARC® lenses increase optical performance</li> <li>Sturdy and smooth 5-barrel hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 63-17-120</li> </ul>	[empty string]	N	110	110	[empty string]	27257-DEFAULT-s.jpg	12	1000	673012973863	329961	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	spy/spy-mccoy-sunglasses-soft-matte-black-happy-gray-green-329961	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ELECTRIC	ELECTRIC	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	27212-DEFAULT-l.jpg	149	27212-DEFAULT-m.jpg	Knoxville 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]	2	100-to-150	0.00	[empty string]	Electric Knoxville Sunglasses, Matte Black/Grey Polarized	<p>Raised right. Born and bred with hard lines, timeless design traits and Italian quality.</p> <ul> <li>Frame: 6 base mold injected grilamid frame with a 3 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: 47h - 139w - 157l</li> <li>Weight: 26 grams</li> </ul>	[empty string]	N	150	150	[empty string]	27212-DEFAULT-s.jpg	13	1000	EE09001042	312444	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-knoxville-sunglasses-matte-black-grey-polarized-312444	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Maroon,Navy	THRASHER	THRASHER	ACCESSORIES	ACCESSORIES &GT; BEANIES	22.99	0	22.99	26465-DEFAULT-l.jpg	22	26465-DEFAULT-m.jpg	Patch Beanie	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]	[empty string]	[empty string]	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Thrasher Patch Beanie	<p>Embroidered patch on a 100% acrylic beanie.</p>	[empty string]	N	22.99	22.99	[empty string]	26465-DEFAULT-s.jpg	13	1000	3131335	321051	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	thrasher/thrasher-patch-beanie-321051	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Denim	RVCA	RVCA	ACCESSORIES	ACCESSORIES &GT; HATS	25.99	0	25.99	25643-DEFAULT-l.jpg	25	25643-DEFAULT-m.jpg	Va All The Way Trucker Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	FA18	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	RVCA VA All The Way Trucker Hat	<p>For RVCA, it's about today, tomorrow and life as the big picture. It is about inspiring our generation, providing something of substance and culture and above all doing it with integrity and as a united family, a close knit community.</p> <ul> </ul>	[empty string]	N	26	26	One Size	25643-DEFAULT-s.jpg	13	1000	MAHWPRVO	373625	EMPTY	EMPTY	EMPTY	0	0	0	HATS	rvca/rvca-va-all-the-way-trucker-hat-373625	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Amazing Spiderman Kids Marvel Comics Crew Sock $14.00 | view details

SUNCLOUD Suncloud Rambler Medium Fit Sunglasses, Black Grey Fade/Silver Mirror $49.99 | view details

SPY Spy Mccoy Sunglasses, Soft Matte Black/Happy Gray Green $110.00 | view details

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

THRASHER Thrasher Patch Beanie $22.99 | view details

RVCA Rvca Va All The Way Trucker Hat $26.00 | view details

Sale Items

Store blog contact us help