Wetsuits

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

All Shoes Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	SUN BUM	SUN BUM	MENS	MENS &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	2	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]
2	Violet	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	15.99	0	15.99	25779-DEFAULT-l.jpg	15	25779-DEFAULT-m.jpg	Habana 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]	58	15-to-20	0.00	[empty string]	Stance Habana Classic Crew Sock	<p>Spice up your wardrobe, Cuban style, with Habana, a sock with the colors and vibes to keep you in a Caribbean state of mind.</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	16	16	Large	25779-DEFAULT-s.jpg	3	1000	M546D18HAB	380091	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-habana-classic-crew-sock-380091	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUNCLOUD	SUNCLOUD	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	49.99	0	49.99	26025-DEFAULT-l.jpg	49	26025-DEFAULT-m.jpg	Milestone 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]	5	25-to-50	0.00	[empty string]	Suncloud Milestone Large Fit Sunglasses, Matte Black/Gray Polarized Poly	<p>The Milestone is the consummate example of multipurpose sunglass perfection. The wrap shape and megol nose pads mark the way to long wearing comfort. Classic design with just enough attitude make the Milestone an easy to wear favorite.</p> <p>Lens width: 65</p> <p>Lens height: 42.5</p> <p>Nose bridge: 17</p> <p>Temple length: 124</p> <p> </p>	[empty string]	N	49.99	49.99	[empty string]	26025-DEFAULT-s.jpg	5	1000	S-MIPPGYMB	358699	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	suncloud/suncloud-milestone-large-fit-sunglasses-matte-black-gray-polarized-poly-358699	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	59.99	0	59.99	25696-DEFAULT-l.jpg	59	25696-DEFAULT-m.jpg	Slip On Pro Black/White/Red	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	252	50-to-100	0.00	[empty string]	Vans Slip-On Pro Skate Shoe, Black/White/Gum	<p>The Slip-On Pro, a Vans classic upgraded for enhanced performance, features suede and canvas uppers, single-wrap foxing tape, UltraCush? HD sockliners to keep the foot close to the board while providing the highest level of impact cushioning, and Vans original waffle outsoles for superior grip and control. The Slip-On Pro also includes Duracap? reinforcement rubber underlays in high wear areas for unrivaled durability.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25696-DEFAULT-s.jpg	6	1000	VN00097M9X1	315153	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-slipon-pro-skate-shoe-black-white-gum-315153	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	G-SHOCK	G-SHOCK	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	129.99	0	129.99	26301-DEFAULT-l.jpg	129	26301-DEFAULT-m.jpg	Gax100 Baby Blue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	G-Shock Analog-Digital Watch, Baby Blue	<p>New to the G-SHOCK G-LIDE lineup of surf watches is the big case GAX100 with an analog Tide Graph, which provides tide information in an intuitive format. The dust colors of these models are similar to those of today's wet suits, surfboards, and other water sports gear. The GAX100CSA-2A comes in pearl blue with a subdued finish. Hour markers and the hands are highlighted with white, which enhances both reading and the overall summertime motif of these models. An analog Tide Graph between 10 and 11 o'clock helps to allow the wearer to surf smarter. Moon Data and temperature measurement also provide information to support your rides.</p> <ul style="margin-left:0px; margin-right:0px"> <li>Shock resistant</li> <li>200m water resistant</li> <li>Magnetic resistant</li> <li>LED light</li> <li>Auto light switch, selectable illumination duration, afterglow</li> <li>Thermometer</li> </ul>	[empty string]	N	130	130	[empty string]	26301-DEFAULT-s.jpg	6	1000	GAX100CSA-2A	381661	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	g-shock/gshock-analogdigital-watch-baby-blue-381661	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ADIDAS	ADIDAS	MENS	MENS &GT; TOPS &GT; T-SHIRTS	27.99	0	27.99	26489-DEFAULT-l.jpg	27	26489-DEFAULT-m.jpg	Solid Shmoo Ss T	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Adidas Solid Schmoo Short Sleeve T-Shirt	<p>This cool crewneck t-shirt celebrates the artistic approach that street-pioneer Mark Gonzales brings to skateboarding. A collaboration between adidas and the Gonz, the tee is built of all-cotton fabric and features a playful Shmoofoil on the front.</p>	[empty string]	N	28	28	Medium,X-Large	26489-DEFAULT-s.jpg	9	1000	DH3900	382251	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	adidas/adidas-solid-schmoo-short-sleeve-tshirt-382251	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

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

STANCE Stance Habana Classic Crew Sock $16.00 | view details

SUNCLOUD Suncloud Milestone Large Fit Sunglasses, Matte Black/Gray Polarized Poly $49.99 | view details

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

G-SHOCK G- Shock Analog- Digital Watch, Baby Blue $130.00 | view details

ADIDAS Adidas Solid Schmoo Short Sleeve T- Shirt $28.00 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

All Shoes Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	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	214	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	819	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	848	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	Red Clay	BILLABONG	BILLABONG	WOMENS	WOMENS &GT; TOPS &GT; CROP TOPS	39.99	0	39.99	26983-DEFAULT-l.jpg	39	26983-DEFAULT-m.jpg	Straight To It Woven Tank	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]	SP19	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Billabong Sincerely Jules Straight To It Crop Top	<p>Coastal candy stripes brings a sun-faded feel to the Straight To It Top. Part of the special edition collection with lifestyle and fashion blogger, Sincerely Jules, the woven crop top is accented with bias cut spaghetti straps and a functional button-down center front.</p> <p>The nuts and bolts</p> <ul> <li>Striped crop top.</li> <li>Adjustable straps.</li> <li>Functional center front placket.</li> <li>Pattern: yarn dye stripes.</li> <li>Material: woven blend.</li> <li><strong>Billabong x Sincerely Jules Collection:</strong> Julie Sariñana’s enthusiasm for travel, style, and life is as infectious as her impeccable taste. A self-starter and dream maker, Julie launched her blog, Sincerely Jules, in 2009. It has since then grown into a fully immersive lifestyle brand, inspiring women around the world to dream, believe, and achieve. Julie’s authenticity shines through in all her creative endeavors, making her deeply passionate, forever curious, and a true inspiration. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	39.95	39.95	Medium,Large	26983-DEFAULT-s.jpg	3	1000	J501TBST	387298	EMPTY	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-sincerely-jules-straight-to-it-crop-top-387298	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Aquifer,Salmon,Inca Gold	ROXY	ROXY	WOMENS	WOMENS &GT; ACCESSORIES &GT; HATS	27.99	0	27.99	26681-DEFAULT-l.jpg	27	26681-DEFAULT-m.jpg	Next Level Dad Hat	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]	SP19	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Roxy Next Level Baseball Hat	<ul> <li><strong>Fabric:</strong> Cotton twill fabric</li> <li><strong>Construction:</strong> Adjustable back closure</li> <li>Embroidery on front</li> <li><strong>Visor/Brim:</strong> Curved visor</li> <li>Circular metal ROXY plaque</li> <li><strong>Size:</strong> OSFM = 22" / 56 cm Ø</li> </ul> <p>Composition</p> <ul> <li> <p>100% Cotton</p> </li> </ul>	[empty string]	N	28	28	[empty string]	26681-DEFAULT-s.jpg	4	1000	ERJHA03542	388757	HATS	EMPTY	EMPTY	0	0	0	EMPTY	roxy/roxy-next-level-baseball-hat-388757	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Fuego	BILLABONG	BILLABONG	WOMENS	WOMENS &GT; DRESSES/ROMPERS	54.99	0	54.99	27156-DEFAULT-l.jpg	54	27156-DEFAULT-m.jpg	Cherry Kisses Dress	Y	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]	39	50-to-100	0.00	[empty string]	Billabong Cherry Kisses Mini Dress	<p>Sweet summer style, ripe for the picking. When carefree days blend into balmy nights, the Cherry Kisses floats between the two, seamlessly, adding a touch of timeless summer romance to the mix.</p> <p>The nuts and bolts</p> <ul> <li>Woven mini dress.</li> <li>Self spaghetti tie tunneled at center front bodice.</li> <li>Smocked back bodice.</li> <li>Woven slub yarn tonal stripe. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	54.95	54.95	X-Small,Small,Medium,Large	27156-DEFAULT-s.jpg	9	1000	JD17UBCH	385568	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-cherry-kisses-mini-dress-385568	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

BILLABONG Billabong Sincerely Jules Straight To It Crop Top $39.95 | view details

ROXY Roxy Next Level Baseball Hat $28.00 | view details

BILLABONG Billabong Cherry Kisses Mini Dress $54.95 | 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	Navy	STANCE	STANCE	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	27119-DEFAULT-l.jpg	14	27119-DEFAULT-m.jpg	Boys Shark Tooth 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]	8	10-to-15	0.00	[empty string]	Stance Shark Tooth Boys Boxer Brief	<p>They never stop moving and have a ferocious appetite. Sounds like someone you know? Put some excitement in his wardrobe with Boys Shark Tooth.</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	Medium,Large	27119-DEFAULT-s.jpg	22	1000	B803A19SHA	383920	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-shark-tooth-boys-boxer-brief-383920	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Assorted	ETHIKA	ETHIKA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	26842-DEFAULT-l.jpg	14	26842-DEFAULT-m.jpg	Boys Native Jaguar Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	Ethika Native Jaguar Boy's Boxer Brief	<ul> <li>The Original - Unmatched Staple Fit</li> <li>No Pull-Down, No Gathering</li> <li>Soft 4-Way Stretch Fabric</li> <li>High-Quality Jacquard Waistband</li> <li>90% Polyester 10% Spandex</li> </ul>	[empty string]	N	15	15	Medium,Large	26842-DEFAULT-s.jpg	25	1000	UBS1373	384624	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	ethika/ethika-native-jaguar-boys-boxer-brief-384624	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	25695-DEFAULT-l.jpg	49	25695-DEFAULT-m.jpg	Slip On Black And White Checker/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	REGULAR	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	246	25-to-50	0.00	[empty string]	Vans Classics Checkerboard Slip-On Skate Shoe, Black/Off-White Checkers	<p>The Classic Slip-On has a low profile, slip-on canvas upper with all-over checker print, elastic side accents, Vans flag label and Vans original Waffle Outsole. </p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25695-DEFAULT-s.jpg	54	1000	VN000EYEBWW	11420	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-classics-checkerboard-slipon-skate-shoe-black-offwhite-checkers-11420	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	12.99	0	12.99	25943-DEFAULT-l.jpg	12	25943-DEFAULT-m.jpg	Adjustable Retainer Costa Blue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	10-to-15	0.00	[empty string]	Costa Del Mar Adjustable Sunglasses Retainer, Blue	<p>The Costa C-Line Adjustable Retainer.</p> <p> </p> <p><strong>Features:</strong></p> <ul> <li>Ultra thin, lightweight coated wire</li> <li>Adjustable Logo bead sliders. Provide a streamlined profile when worn</li> <li>Flat, low profile temple attachments</li> </ul>	<p>Costa Del Mar Adjustable Retainer (Costa Blue)</p>	N	12.95	12.95	[empty string]	25943-DEFAULT-s.jpg	64	1000	CA11	371592	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-adjustable-sunglasses-retainer-blue-371592	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	4943-DEFAULT-l.jpg	49	4943-DEFAULT-m.jpg	Slip- On True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	LOW	[empty string]	[empty string]	[empty string]	SKATE	FALL	[empty string]	[empty string]	[empty string]	211	25-to-50	0.00	[empty string]	Vans Slip-On Skate Shoe, True White	<p>The Classic Slip-On has a low profile, slip-on canvas upper with all-over checker print, elastic side accents, Vans flag label and Vans original Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	4943-DEFAULT-s.jpg	70	1000	VN000EYEW00	233922	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-slipon-skate-shoe-true-white-233922	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	59.99	0	59.99	27132-DEFAULT-l.jpg	59	27132-DEFAULT-m.jpg	Slip On (Chambray) True Navy/True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	NAVY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	71	50-to-100	0.00	[empty string]	Vans Chambray Slip-On Skate Shoe, True Navy/True Navy	<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	60	60	4.5,5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27132-DEFAULT-s.jpg	97	1000	VN0A38F7VIO	383092	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-chambray-slipon-skate-shoe-true-navy-true-navy-383092	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Shark Tooth Boys Boxer Brief $15.00 | view details

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

VANS Vans Classics Checkerboard Slip- On Skate Shoe, Black/Off- White Checkers $50.00 | view details

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

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

VANS Vans Chambray Slip- On Skate Shoe, True Navy/True Navy $60.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]	DVS	DVS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	59.99	0	59.99	26237-DEFAULT-l.jpg	59	26237-DEFAULT-m.jpg	Revival 2 Black/Black Nubuck	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]	[empty string]	[empty string]	[empty string]	[empty string]	25	50-to-100	0.00	[empty string]	DVS Revival 2 Skate Shoe, Black/Black Nubuck	<p>The Revival 2 from DVS is a clean, classic skate shoe. The abrasion resistant rubber cup sole provides enhanced durability with a herringbone tread for maximum grip. The Revival 2 comes in leather uppers with a molded EVA footbed for a comfortable, smooth ride. The iconic blucher toe design along with a reinforced upper and padding, combine to create a shoe that’s never out of style.</p> <ul> <li>Iconic blucher toe design</li> <li>Abrasion resistant rubber cup sole</li> <li>Herringbone tread for maximum grip</li> <li>Leather uppers</li> <li>Molded EVA footbed</li> </ul>	<p>DVS Revival 2 Black/Black Nubuck, 10</p>	N	60	60	8,8.5,9,9.5,10,10.5,11,11.5,12,13	26237-DEFAULT-s.jpg	11	1000	DVF0000261004	362488	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-revival-2-skate-shoe-black-black-nubuck-362488	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	64.99	0	64.99	25707-DEFAULT-l.jpg	64	25707-DEFAULT-m.jpg	Old Skool (Jersey Lace) Black/Port	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK COMBO	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Vans Jersey Lace Old Skool Skate Shoe, Black/Port Royale	<p>The first to bear the iconic side stripe, the Jersey Lace Old Skool is a low top lace-up shoe. It is lined, has padded collars for comfort, re-enforced toecaps to withstand repeated wear, and features the Vans signature waffle outsole for a firmer grip.<br /> 3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	65	65	8	25707-DEFAULT-s.jpg	15	1000	VN0A38G1UNI	378744	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-jersey-lace-old-skool-skate-shoe-black-port-royale-378744	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	eXpresso,Sierra,Dark Brown,Premier Black,Classic Tan/Blue,CBLK,CLMOCHA	RAINBOW	RAINBOW	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	57.99	0	57.99	8625-DEFAULT-l.jpg	57	8625-DEFAULT-m.jpg	Double Layer Leather Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	Z	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	173	50-to-100	0.00	[empty string]	Rainbow Double Layer Leather Men's Sandal	<p>The double layer classic leather sandal offers all the great features found in our single layer leather, but with an added layer of midsole for more arch support. <br /> <br /> • Double Layer Classic Leather <br /> • Double stitched <br /> • Box X Toe Construction <br /> • Bonded Nylon Thread <br /> • Triple Glued <br /> • Non-Slip Bottom Sole <br /> • Original Rainbow Woven Label <br /> <br /> The double layer classic leather sandal offers all the great features found in our single layer leather, but with an added layer of midsole and pin line, which runs from the heel to the front of the arch, for even more comfort and support. </p>	[empty string]	N	57.99	57.99	Small,Medium,Large,X-Large,XX-Large,XXXL	8625-DEFAULT-s.jpg	18	1000	302ALTS	27402	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	rainbow/rainbow-double-layer-leather-mens-sandal-27402	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Navy,Multi	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	11.99	0	11.99	25740-DEFAULT-l.jpg	11	25740-DEFAULT-m.jpg	Kern 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 Kern Classic Crew Sock	<p>With a multi patterned design, you'll swear you've seen in dad's closet, Kern is the casual but classy choice for any outfit, without the dad talk.</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	25740-DEFAULT-s.jpg	28	1000	M556D18KER	380079	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-kern-classic-crew-sock-380079	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Multi	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25758-DEFAULT-l.jpg	13	25758-DEFAULT-m.jpg	Women's Plant Lady Sock	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	22	10-to-15	0.00	[empty string]	Stance Plant Lady Women's Classic Crew Sock	<p>For those who love floral, we give you Plant Lady, a flower print that will keep your day in full bloom.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Cushioning</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	25758-DEFAULT-s.jpg	29	1000	W525D18PLA	380519	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-plant-lady-womens-classic-crew-sock-380519	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Cream	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25772-DEFAULT-l.jpg	13	25772-DEFAULT-m.jpg	Women's Thoughts Sock	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	3	10-to-15	0.00	[empty string]	Stance Thoughts Women's Classic Crew Sock	<p>With an eclectic bunch of cartoon graphics, Thoughts is a daydreamers' delight.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Elastic Arch Support</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Small,Medium	25772-DEFAULT-s.jpg	30	1000	W556D18THO	380532	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-thoughts-womens-classic-crew-sock-380532	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

DVS Dvs Revival 2 Skate Shoe, Black/Black Nubuck $60.00 | view details

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

RAINBOW Rainbow Double Layer Leather Men's Sandal $57.99 | view details

STANCE Stance Kern Classic Crew Sock $12.00 | view details

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

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

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	244.99	0	244.99	26323-DEFAULT-l.jpg	244	26323-DEFAULT-m.jpg	Switchblade 38 Faded 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]	4	200-to-250	0.00	[empty string]	Landyachtz Switchblade 38 Mountain Yellow Fade Complete Longboard, 38"	<p style="margin-left:0px; margin-right:0px; text-align:left"><span style="font-family:inherit; font-size:12px">The trick is to make a stable freeride board that is still alive under your feet. It’s something that board designers have set out to accomplish, round table debates have broken out on the topic and have ended in bloody brawls. We’ve ended those debates with the Switchblades, years of R&D have created a board that is stable but still feels alive under your feet. Here’s why…It’s symmetrical, drop mounted and its fully engineered drop foot platform has these crazy comfortable foot pockets so you never loose your feet. Available in three sizes.</span></p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 38” I W: 9.8” I WB: 29”</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck Material:</strong> 9 Ply Canadian Maple<br /> <strong>Concave:</strong> Deep<br /> <strong>Flex:</strong> Low<br /> <strong>Profile:</strong> Double Drop Down<br /> <strong>Grip:</strong> Black Adhesive with printed Logo<br /> <strong>Features:</strong> Drop Mounted, Drop Down, Symmetrical, Deep Concave, 100% Canadian Maple<br /> <strong>Setup:</strong> Bear Grizzly GR852, 70mm Mini Zombie Hawgs White Stoneground, Bear Spaceball Bearings</p>	[empty string]	N	245	245	38IN	26323-DEFAULT-s.jpg	2	1000	119-DHSB38FD	386935	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switchblade-38-mountain-yellow-fade-complete-longboard-38-386935	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	199.99	0	199.99	26953-DEFAULT-l.jpg	199	26953-DEFAULT-m.jpg	Timeless Palisander Groundswell Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Arbor Timeless 42 Groundswell Complete Longboard, 42"	<p><em>Premium Palisander Wood Finish Ply</em></p> <p>The classic pintail carver, designed for smooth, open-stance skating and maximum push and speed stability.</p> <h4>DECK</h4> <ul> <li>7 Ply Hardrock Maple with a Premium Palisander Wood Finish Ply</li> <li>Wood material comes from sustainable sources of supply</li> <li>Wood by-product is reclaimed for use in other products</li> </ul> <h4>TRUCKS</h4> <ul> <li>Paris Reverse 50° 180mm</li> </ul> <h4>WHEELS</h4> <ul> <li>Arbor Easyrider Series – Outlook</li> <li>Designed for carving and cruising</li> <li>Larger shape increases rolling speed</li> <li>Size: 69mm // Durometer: 78a</li> <li>Contact Patch: 44.0mm // Offset: 2.5mm</li> <li>Momentum Core: Dampens bumpy rides</li> <li>Venice Formula: Soft and grippy</li> </ul> <h4>OTHER COMPONENTS</h4> <ul> <li>ABEC 7 Bearings with Spacers</li> <li>1/8"? Paris Risers</li> <li>Recycled Glass Re-Grit</li> </ul>	[empty string]	N	199.99	199.99	42IN	26953-DEFAULT-s.jpg	10	1000	ARBL42003	393647	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	arbor/arbor-timeless-42-groundswell-complete-longboard-42-393647	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	234.99	0	234.99	27051-DEFAULT-l.jpg	234	27051-DEFAULT-m.jpg	Switch 35 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]	2	200-to-250	0.00	[empty string]	Landyachtz Switch Skull 35 Complete Longboard, 35"	<p> </p> <p>Forwards or backwards, steep freeride spots or cruising your neighbourhood, the Switch is comfortable in any situation. The 35 inch version has a shorter wheelbase perfect for nailing tight lines and perfectly suited to shorter riders.</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	35IN	27051-DEFAULT-s.jpg	12	1000	119-DHSW35SKL	386937	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switch-skull-35-complete-longboard-35-386937	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	Bones	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	34.99	0	34.99	25932-DEFAULT-l.jpg	34	25932-DEFAULT-m.jpg	V4 Annuals Stf 2017 Whl 4- Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Bones STF Annuals V4 Skateboard Wheels	<p>Street Tech Formula™ (STF) is specifically engineered from top quality components to obtain all the best properties necessary for the ultimate in street wheel performance.</p> <p>BONES® WHEELS has created a wheel with a substantially higher rebound for more speed and amazing slide capabilities while maintaining a resistance to flat spotting well beyond any standard wheel. The technology behind STF is proven. The results speak for themselves.</p> <p>Hype is hype, “quality” is for real. Try Street Tech Formula™ wheels on your next setup and see for yourself.</p>	<p>Bones STF Annuals V4 Skateboard Wheel 83b 4 pack (52mm)</p>	N	34.99	34.99	54MM,55MM	25932-DEFAULT-s.jpg	25	1000	BWV4-2017	362177	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-stf-annuals-v4-skateboard-wheels-362177	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD BEARINGS	4.99	0	4.99	725-DEFAULT-l.jpg	4	725-DEFAULT-m.jpg	Speed Cream 1/2 Oz.	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ALWAYS IN	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	WEB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	100	5-and-under	0.00	[empty string]	Bones Speed Cream Lubricant	<p>Bones® Speed Cream® is a high temperature, low viscosity synthetic skate lubricant specially formulated by Bones® to reduce friction, and provide a durable micro film of lubricant to protect against corrosion. We have found this lubricant to be superior to Teflon™ based lubricants in skate environments. Speed Cream R.F. makes your bearings faster and is very long lasting.</p> <p><strong>Contents</strong></p> <p>Bottle of Speed Cream and instructions</p>	[empty string]	N	4.98999977112	4.98999977112	[empty string]	725-DEFAULT-s.jpg	39	1000	BALSLSPDP	36678	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-speed-cream-lubricant-36678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	49	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

LANDYACHTZ Landyachtz Switchblade 38 Mountain Yellow Fade Complete Longboard, 38 " $245.00 | view details

ARBOR Arbor Timeless 42 Groundswell Complete Longboard, 42 " $199.99 | view details

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

Bones Bones Stf Annuals V4 Skateboard Wheels $34.99 | view details

BONES Bones Speed Cream Lubricant $4.99 | 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	[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]	5	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	1	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]
2	[empty string]	FIREWIRE	FIREWIRE	SURF SHOP	SURF SHOP &GT; SURFBOARDS &GT; FUNBOARDS	784.99	0	784.99	26620-DEFAULT-l.jpg	784	26620-DEFAULT-m.jpg	6 ` 10 Addvance Lft W/Futures	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	500-and-over	0.00	[empty string]	Firewire Addvance TimberTEK Surfboard, Futures, 6'10"	<p>The Firewire ADDvance Surfboard was developed in collaboration between Taj’s father Vance Burrow and Nev, the ADDvance offers extreme flotation in TimberTEK.</p> <p>Combining the buoyancy of a longboard with a contemporary outline, the ADDvance Series opens up new possibilities for fun and performance. ADDvance your surfing</p>	[empty string]	N	785	785	6FT10IN	26620-DEFAULT-s.jpg	15	1000	LAV-610-3-3BM	391964	FUNBOARDS	EMPTY	EMPTY	0	0	0	SURFBOARDS	firewire/firewire-addvance-timbertek-surfboard-futures-610-391964	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	119.99	0	119.99	26150-DEFAULT-l.jpg	119	26150-DEFAULT-m.jpg	Fcs Ii Mf Pc Grn/Blk Large Tri Fin	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]	FCS II Mick Fanning Tri-Fins - Large	<p>Mick Fanning's signature FCS II MF fin in premium PC material for controlled powerful surfing.</p> <p><strong>Overview</strong></p> <ul> <li>Mick's fin in premium PC material delivers a dynamic, yet very controlled feel when performing powerful turns.</li> <li>Ideal for power surfers who like to snap hard off the top and carve long roundhouse cutbacks.</li> <li>This fin provides maximum drive and control.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Open face, down-the-line waves, particularly good in point and reef breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for performance shortboards with moderate-to-extreme rocker.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Carver: Find Power. Powerful, drawn-out turns with added hold.</li> </ul>	[empty string]	N	120	120	[empty string]	26150-DEFAULT-s.jpg	19	1000	FMFL-PC02-LG-TS-R	372857	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-mick-fanning-trifins-large-372857	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	104.99	0	104.99	26242-DEFAULT-l.jpg	104	26242-DEFAULT-m.jpg	Hs1 V2 Foil Large 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 HS1 Generation Fins	<p>The HS1 Generation Series, designed by Hayden Cox of Haydenshapes, is a large size Speed Generating fin with a Ride Number of 8.4. The latest in speed generating fins, the Gen Series features a V2 foil for fluidity and a unique blend of uni-directional carbon and fiberglass for a more stable flex pattern. Similar feel to Blackstix, but a bit more subtle for those just transitioning onto foiled fins.</p> <table cellspacing="0" class="specf-table" style="-webkit-text-stroke-width:0px; background-color:#ffffff; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; width:537.6px; word-spacing:0px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> <th style="text-align:left">Center Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.55</td> <td>15.55</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.67</td> <td>4.67</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.57</td> <td>4.57</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]	26242-DEFAULT-s.jpg	29	1000	2487-456-00	341104	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-hs1-generation-fins-341104	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	129.99	0	129.99	6172-DEFAULT-l.jpg	129	6172-DEFAULT-m.jpg	V- 2 Pc Tri- Quad Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	T	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	FCS V2 Performance Core Tri-Quad Fins - Medium	<p>Designed for fast, critical surfing. Suits hollow steep waves, and punchy beach breaks.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for fast, critical surfing.</li> <li>The upright, pivotal side fin template produces quick start-up acceleration and allows for tight turns in the pocket.</li> <li>Based on the FCS Kelly Slater K2.1 template.</li> <li>Tri-Quad (5 fin) set.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li> <p>Hollow steep waves, punchy beach breaks.</p> </li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>All board types.</li> <li>Will fit the FCS II Fin System when used with grub screws and the FCS Infill Kit.</li> </ul>	<p>FCS K2.1 V-2 Performance Core Surfboard Fins - Quad. A great all round performing quad set. A balance of flow and stabilty, combined with response.</p>	N	130	130	[empty string]	6172-DEFAULT-s.jpg	31	1000	1120-156-28-R	257919	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-v2-performance-core-triquad-fins-medium-257919	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	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	33	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

SLOWTIDE Slowtide Painted Sand Beach Towel $39.95 | view details

FIREWIRE Firewire Addvance Timbertek Surfboard, Futures, 6 ' 10 " $785.00 | view details

FCS Fcs Ii Mick Fanning Tri- Fins - Large $120.00 | view details

FUTURE FINS Futures Hs1 Generation Fins $105.00 | view details

FCS Fcs V2 Performance Core Tri- Quad Fins - Medium $130.00 | view details

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

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	509.99	0	509.99	26351-DEFAULT-l.jpg	509	26351-DEFAULT-m.jpg	Aura	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	11	500-and-over	0.00	[empty string]	Never Summer Aura Women's Snowboard, 2019	<p>The Aura features our hard-charging Ripsaw Rocker Camber Profile. This trendsetter has a mid-firm flex, directional shape, Power Grip Sidecut, and enhanced stability with a sleek shape. If you have the need for speed, big beautiful carves, or big mountain riding then surround yourself with the Aura.</p>	[empty string]	N	509.99	509.99	146,148,150,152,157	26351-DEFAULT-s.jpg	14	1000	AURA-I	374756	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-aura-womens-snowboard-2019-374756	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	25.99	0	25.99	25637-DEFAULT-l.jpg	25	25637-DEFAULT-m.jpg	Retro Mountain Trucker Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	32	25-to-50	0.00	[empty string]	Never Summer Retro Mountain Trucker Hat	<p>The Never Summer Retro Mountain Trucker Hat features a bright Never Summer logo on front and an adjustable snapback. </p>	[empty string]	N	26	26	One Size	25637-DEFAULT-s.jpg	14	1000	HTRETROMESH	374870	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-retro-mountain-trucker-hat-374870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	329.99	0	329.99	26371-DEFAULT-l.jpg	329	26371-DEFAULT-m.jpg	Mini Proto Type Two	N	KIDS	[empty string]	[empty string]	[empty string]	[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	300-to-350	0.00	[empty string]	Never Summer Mini Proto Type Two Kids Snowboard, 2019	<p>The Mini Proto is the legendary Proto for kids! The Mini features a twin design, NS SuperLight Core, increased damping, Original Rocker Camber Profile, and Vario Power Grip Sidecut. The Mini Proto is a super stable, mid flex, all mountain twin dominator for kids. Ride anything you see. Own everything you ride.</p>	[empty string]	N	329.99	329.99	137,140	26371-DEFAULT-s.jpg	33	1000	MINIPROTO-I	374757	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-mini-proto-type-two-kids-snowboard-2019-374757	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	569.99	0	569.99	26341-DEFAULT-l.jpg	569	26341-DEFAULT-m.jpg	West	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]	13	500-and-over	0.00	[empty string]	Never Summer West Snowboard, 2019	<p>The West is a different kind of animal. This dynamic snowboard has become one of our most popular models. Our aggressive enhanced Ripsaw Rocker Camber Profile, NS SuperLight Wood Core, and mid flex, makes the West extremely powerful yet agile. Directional performance balanced for freestyle mobility, the West is equally at home ripping quick turns, slashing pow or catching air. Versatility as expansive as the land itself. X - Wide version of the original.</p>	[empty string]	N	569.99	569.99	154,156,159,162	26341-DEFAULT-s.jpg	36	1000	WEST-I	374747	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-west-snowboard-2019-374747	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Steel	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; BINDINGS	7.99	0	7.99	25858-DEFAULT-l.jpg	7	25858-DEFAULT-m.jpg	Binding Hardware	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]	7	5-to-10	0.00	[empty string]	Dakine Snowboard Binding Hardware	<p>This set of industry standard replacement screws and washers is designed to fit most snowboard bindings. The screws come dressed with thread lock to keep them from coming loose. (Which is probably why you needed replacement screws in the first place.) These replacement screws are inexpensive and take up virtually no room in your snowboard kit; but they only work if you buy them before you need em!</p> <ul> <li>8 14mm M6 screws</li> <li>8 countersunk washers</li> <li>Fits most bindings</li> </ul>	[empty string]	N	8	8	[empty string]	25858-DEFAULT-s.jpg	46	1000	10001556-H	357725	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-snowboard-binding-hardware-357725	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Charcoal,Clear,Black,White	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	11.99	0	11.99	25538-DEFAULT-l.jpg	11	25538-DEFAULT-m.jpg	Spike Stomp Pad	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]	SMU	2018	[empty string]	[empty string]	[empty string]	37	10-to-15	0.00	[empty string]	Dakine Spike Stomp Pad	<p>One of the longest running products in our lineup of stomp pads, the Spike Stomp is still the best functioning and one of our best sellers. Why? Because the spikes are taller than most, which makes them more effective even with snow buildup. Pilot creases molded into the stomp let you trim down the overall size, or cut into strips to customize your traction.</p>	[empty string]	N	12	12	[empty string]	25538-DEFAULT-s.jpg	49	1000	10001575-H	357735	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-spike-stomp-pad-357735	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Aura Women's Snowboard, 2019 $509.99 | view details

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

NEVER SUMMER Never Summer Mini Proto Type Two Kids Snowboard, 2019 $329.99 | view details

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

DAKINE Dakine Snowboard Binding Hardware $8.00 | view details

DAKINE Dakine Spike Stomp Pad $12.00 | view details

Accessories

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Army Green,CMS,Dark Pine,MGR,Melindigo,Smoke,SNB,Vintage Black	VOLCOM	VOLCOM	ACCESSORIES	ACCESSORIES &GT; HATS	28.99	0	28.99	26081-DEFAULT-l.jpg	27	26081-DEFAULT-m.jpg	Quarter Fabric Snapback Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	40	25-to-50	0.00	[empty string]	Volcom Quarter Fabric Snapback Hat	<p>The Quarter Fabric is the icon piece your style can't do without.</p>	[empty string]	N	28	28	[empty string]	26081-DEFAULT-s.jpg	5	1000	D5531413	310434	EMPTY	EMPTY	EMPTY	0	0	0	HATS	volcom/volcom-quarter-fabric-snapback-hat-310434	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Pelican	BURTON	BURTON	ACCESSORIES	ACCESSORIES &GT; HATS	29.99	0	29.99	26817-DEFAULT-l.jpg	29	26817-DEFAULT-m.jpg	Mallet Snapback Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Burton Mallet Nylon Hat	<p>A companion that behaves well while traveling, this hat has a soft brim that can be stuffed in a bag.</p> <p>The men's Burton Mallet Nylon Cap is a packable hat you can throw in your bag without stressing. DWR water-resistant coating helps shield your head from the rain, and a snapback closure gives this hat an adjustable fit. This hat has a classic look with a flat visor, a medium profile, and a Burton patch on the front.</p>	[empty string]	N	29.95	29.95	One Size	26817-DEFAULT-s.jpg	5	1000	20768100	383565	EMPTY	EMPTY	EMPTY	0	0	0	HATS	burton/burton-mallet-nylon-hat-383565	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Mint,Black,Navy,MEL	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	15.99	0	15.99	26761-DEFAULT-l.jpg	15	26761-DEFAULT-m.jpg	Neopolitan Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	OH at 200	[empty string]	152	15-to-20	0.00	[empty string]	Stance Neapolitan Butter Blend Crew Sock	<p>Our crack team of designers here at Stance find inspiration in the craziest of places. Because who doesn't love Neapolitan ice cream?</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	16	16	Medium,Large	26761-DEFAULT-s.jpg	6	1000	M556A19NEA	383789	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-neapolitan-butter-blend-crew-sock-383789	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	COSTA DEL MAR	COSTA DEL MAR	ACCESSORIES	ACCESSORIES &GT; HATS	24.99	0	24.99	26228-DEFAULT-l.jpg	24	26228-DEFAULT-m.jpg	Offset Logo Performance Hat Mint	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]	OH at 200	[empty string]	4	20-to-25	0.00	[empty string]	Costa Del Mar Performance Hat, Mint	<p><strong>DESCRIPTION:</strong><br /> The Costa Performance Hat</p> <p><strong>FEATURES:</strong><br /> Regular fit<br /> Pinhole Mesh Back Panels<br /> Enhanced moisture management and is breathable for added comfort in hot conditions</p>	[empty string]	N	24.99	24.99	[empty string]	26228-DEFAULT-s.jpg	8	1000	HA 74MT	371550	EMPTY	EMPTY	EMPTY	0	0	0	HATS	costa-del-mar/costa-del-mar-performance-hat-mint-371550	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Purple Ash	QUIKSILVER	QUIKSILVER	ACCESSORIES	ACCESSORIES &GT; HATS	34.99	0	34.99	27072-DEFAULT-l.jpg	27	27072-DEFAULT-m.jpg	Dice Slicer Snapback Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Quiksilver Dice Slicer Snapback Hat	<p>The nuts and bolts</p> <ul> <li>Polyester cotton blend fabric</li> <li>5-panel unstructured snapback design</li> <li>Label on center front</li> <li>All-over printed fabric</li> <li>Rope detail</li> </ul> <p>Composition</p> <ul> <li> <p>97% Polyester, 3% Elastane</p> </li> </ul>	[empty string]	N	28	28	One Size	27072-DEFAULT-s.jpg	8	1000	AQYHA04315	383369	EMPTY	EMPTY	EMPTY	0	0	0	HATS	quiksilver/quiksilver-dice-slicer-snapback-hat-383369	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Metal Brown	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	25.99	0	25.99	26526-DEFAULT-l.jpg	25	26526-DEFAULT-m.jpg	The Ranger Slim Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	21	25-to-50	0.00	[empty string]	Arcade Ranger Slim Belt, Metal Brown	<p>The Ranger Slim Adventure belt is packed with all the great features of it’s bigger brothers but in a smaller package. This lightweight and low-profile belt is built with elastic stretch webbing for a superior fit and ultimate comfort. A perfect fit and one size fits most come from a micro-adjust buckle. No metal means that airport security becomes a breeze. A minimal buckle and a slimmed down webbing allows this adventure belt to fit through smaller belt loops. Made from quick-drying and machine washable materials mean this tough little Ranger is your ultimate outdoor companion.</p> <ul> <li>One size fits most, up to 40″ (101.6cm)</li> <li>Narrower width for smaller belt loops</li> <li>Travel-Friendly</li> <li>Belt width – 1.25″ (3.17cm)</li> </ul>	[empty string]	N	26	26	[empty string]	26526-DEFAULT-s.jpg	8	1000	A21102-220	384171	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-ranger-slim-belt-metal-brown-384171	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]