Billabong Sol Searcher Long Sleeve Women's Rashguard

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	Pirate Black,Wood	RVCA	RVCA	MENS	MENS &GT; BOTTOMS &GT; SHORTS	44.99	0	44.99	26698-DEFAULT-l.jpg	44	26698-DEFAULT-m.jpg	Weekend Elastic Short	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	RVCA Weekend Elastic Shorts, 19"	<p>AN UNREFINED ESSENTIAL, THE RVCA WEEKEND ELASTIC 19" SHORT DELIVERS ON COMFORT WITH AN ELASTIC WAIST AND BROKEN-IN FINISH. MADE WITH A FUNCTIONAL STRETCH FABRIC, THE SOLID WALKSHORT IS FINISHED WITH A RAW HEM AND RVCA LABEL AT THE BACK WELT POCKET.</p>	[empty string]	N	45	45	Small,Medium,Large,X-Large	26698-DEFAULT-s.jpg	2	1000	M207TRWE	386071	SHORTS	EMPTY	EMPTY	0	0	0	EMPTY	rvca/rvca-weekend-elastic-shorts-19-386071	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPY	SPY	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	109.99	0	109.99	26011-DEFAULT-l.jpg	109	26011-DEFAULT-m.jpg	Discord Whitewall Hap Gry Grn Red Spc	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Spy Discord Sunglasses, Whitewall/Happy Gray Green with Red Spectra	<p>As big and bold as the era and music that inspired it, a little dissension goes a long way in this large-scale, ’80s-inspired piece. Available with the Happy Lens™ and Trident™ polarization, the Discord is constructed from virtually indestructible Grilamid® and features sturdy 5-barrel hinges, 6-base polycarbonate ARC® lenses, and 100% UV protection.</p> <ul> <li>Available with the color and contrast enhancing Happy Lens™ and Trident™ polarization</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>6-base polycarbonate ARC® lenses for increased optical performance</li> <li>Smooth and sturdy 5-barrel hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 57-17-145</li> </ul>	[empty string]	N	110	110	[empty string]	26011-DEFAULT-s.jpg	3	1000	673119209365	359702	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-discord-sunglasses-whitewall-happy-gray-green-with-red-spectra-359702	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	NIXON	NIXON	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	124.99	0	124.99	25678-DEFAULT-l.jpg	124	25678-DEFAULT-m.jpg	Base Tide Pro Seafoam	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Nixon Base Tide Pro 42mm Watch, Seafoam	<p>The Base Tide Pro delivers a double-overhead dose of durability and functionality. Featuring 500 pre-programmed tides and sunrise/sunset locations inside a tough-as-nails case, the Base Tide Pro is one of the toughest in the lineup.</p>	[empty string]	N	125	125	[empty string]	25678-DEFAULT-s.jpg	5	1000	A1212272	375203	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-base-tide-pro-42mm-watch-seafoam-375203	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	25722-DEFAULT-l.jpg	59	25722-DEFAULT-m.jpg	Old Skool Falcon/True White	N	WOMENS	[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]	HOLIDAY	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Vans Gumsole Old Skool Skate Shoe, Falcon/Boot Lace	<p>The first to bear the iconic side stripe, the Gumsole 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.</p> <p><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	6.5	25722-DEFAULT-s.jpg	7	1000	VN0A38G1UKW	378730	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-gumsole-old-skool-skate-shoe-falcon-boot-lace-378730	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	White	BILLABONG	BILLABONG	MENS	MENS &GT; TOPS &GT; LYCRA AND RASHGUARDS	39.99	0	39.99	26972-DEFAULT-l.jpg	39	26972-DEFAULT-m.jpg	Unity Pf Ls	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Billabong Unity Performance Fit Long Sleeve Rashguard	<p>Minimalist lines and maximum surf and sun protection come together in the Unity Long Sleeve Rashguard. The performance fit rashguard delivers UPF 50+ sun protection with ergonomic seams, custom logo prints and a silky smooth fabric.</p> <p>The nuts and bolts</p> <ul> <li>Mens long sleeve rashguard.</li> <li>Traditional mock neck.</li> <li>Silky-smooth feel.</li> <li>Billabong logo at center chest and sleeve.</li> <li>50+ UPF sun protection.</li> <li>B-Lock super flex stitch.</li> <li>Material: 6 oz silk touch fabric. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	39.95	39.95	Small,Medium,Large,X-Large	26972-DEFAULT-s.jpg	9	1000	MR61TBUY	382774	LYCRA AND RASHGUARDS	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-unity-performance-fit-long-sleeve-rashguard-382774	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	ELECTRIC	ELECTRIC	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	25972-DEFAULT-l.jpg	149	25972-DEFAULT-m.jpg	Dude Mat Trt/Ohm Pol Brn	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 Dude Sunglasses, Matte Tort/Bronze Polarized	<p>Electric Dude Sunglasses, Matte Tort/Bronze Polarized</p>	[empty string]	N	150	150	[empty string]	25972-DEFAULT-s.jpg	10	1000	EE16713943	365740	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	electric/electric-dude-sunglasses-matte-tort-bronze-polarized-365740	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

RVCA Rvca Weekend Elastic Shorts, 19 " $45.00 | view details

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

NIXON Nixon Base Tide Pro 42mm Watch, Seafoam $125.00 | view details

VANS Vans Gumsole Old Skool Skate Shoe, Falcon/Boot Lace $60.00 | view details

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

ELECTRIC Electric Dude Sunglasses, Matte Tort/Bronze Polarized $150.00 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	419	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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	774	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	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	914	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	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25577-DEFAULT-l.jpg	5	25577-DEFAULT-m.jpg	Nude Beach 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]	253	5-to-10	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Nude Beach	<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]	N	5.99	5.99	[empty string]	25577-DEFAULT-s.jpg	1	1000	20-48052	377108	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-nude-beach-377108	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SKULLCANDY	SKULLCANDY	WOMENS	WOMENS &GT; ACCESSORIES &GT; VIDEO AND AUDIO	24.99	0	24.99	21947-DEFAULT-l.jpg	24	21947-DEFAULT-m.jpg	Ink ` D Mic ` D 2.0 Pnk/Blk Headphones	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	20-to-25	0.00	[empty string]	SKULLCANDY INK ' D 2.0 MIC'D EAR BUD HEADPHONE, Pink/Black	<p>Ink'd earbuds with mic let you manage calls and music thanks to an inline microphone and remote with call and track control. Quality ear gels create a noise isolating fit so your music stays in, and everything else stays out.</p> <ul> </ul>	[empty string]	N	24.99	24.99	[empty string]	21947-DEFAULT-s.jpg	2	1000	S2IKDY-133	285043	VIDEO AND AUDIO	EMPTY	EMPTY	0	0	0	EMPTY	skullcandy/skullcandy-ink-d-20-micd-ear-bud-headphone-pink-black-285043	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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]	36	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	3	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, Pinktini $5.99 $3.99 | view details

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

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

SUN BUM Sun Bum Spf 15 Tinted Lip Balm, Nude Beach $5.99 | view details

SKULLCANDY Skullcandy Ink ' D 2.0 Mic ' D Ear Bud Headphone, Pink/Black $24.99 | 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	Grey	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	7.99	0	7.99	25762-DEFAULT-l.jpg	7	25762-DEFAULT-m.jpg	Boy's Checkered Sock	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	24	5-to-10	0.00	[empty string]	Stance Checkered Boys Kids Crew Sock	<p>Sometimes they need simplicity. We back our Stance Checkered Boys with our seal of approval.</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	8	8	Medium,Large	25762-DEFAULT-s.jpg	5	1000	B526D18STA	380138	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-checkered-boys-kids-crew-sock-380138	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Golden Glow	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26810-DEFAULT-l.jpg	59	26810-DEFAULT-m.jpg	Sun Dream Tank Set	N	GIRLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	Billabong Sun Dream Tank Set	<p>Billabong Sun Dream Tank Set</p>	[empty string]	N	59.95	59.95	7,8,10,12,14	26810-DEFAULT-s.jpg	27	1000	Y219TBSU	387578	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-sun-dream-tank-set-387578	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Assorted	ETHIKA	ETHIKA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	26844-DEFAULT-l.jpg	14	26844-DEFAULT-m.jpg	Boys Greetings From Ethika 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 Greetings From Ethika 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	Small,Medium,Large	26844-DEFAULT-s.jpg	48	1000	UBS1411	384626	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	ethika/ethika-greetings-from-ethika-boys-boxer-brief-384626	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Royal,Charcoal	BILLABONG	BILLABONG	KIDS	KIDS &GT; BOYS	29.99	0	29.99	26959-DEFAULT-l.jpg	29	26959-DEFAULT-m.jpg	Rotor Pf Ss	N	BOYS	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]	23	25-to-50	0.00	[empty string]	Billabong Rotor Performance Fit Boy's Short Sleeve Rashguard	<p>Round out your performance surf kit with the Rotor Short Sleeve Rashguard for boys. The performance fit Rotor boys rashguard delivers UPF 50+ sun protection with ergonomic seams, custom logo prints and a silky smooth fabric.</p> <p>The nuts and bolts</p> <ul> <li>Boys short sleeve rashguard.</li> <li>Traditional mock neck.</li> <li>Silky-smooth feel.</li> <li>Billabong logo at center chest and sleeve.</li> <li>50+ UPF sun protection.</li> <li>B-Lock super flex stitch.</li> <li>Material: 6 oz silk touch fabric. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	29.95	29.95	2,4,6,8,10,12	26959-DEFAULT-s.jpg	79	1000	BR10TBRO	382429	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-rotor-performance-fit-boys-short-sleeve-rashguard-382429	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	59.99	0	59.99	26790-DEFAULT-l.jpg	59	26790-DEFAULT-m.jpg	Comfycush Slip On True White/True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	WHITE	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	72	50-to-100	0.00	[empty string]	Vans ComfyCush Slip-On Skate Shoe	<p>Vans has reinvigorated the classic Slip-On by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Slip-On a first-class fit that feels like walking on a cloud. Newly constructed canvas uppers house simplified one-piece interiors with added arch support and new moisture-wicking lining throughout, resulting in a lightweight experience that assures you’ll Keep It Comfy at all times.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26790-DEFAULT-s.jpg	94	1000	VN0A3WMDVNG	383079	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-comfycush-slipon-skate-shoe-383079	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	69.99	0	69.99	26791-DEFAULT-l.jpg	69	26791-DEFAULT-m.jpg	Comfycush Old Skool Black/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]	BLK/WHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	70	50-to-100	0.00	[empty string]	Vans ComfyCush Old Skool Skate Shoe	<p>Vans has reinvigorated the classic Old Skool by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Old Skool a first-class fit that feels like walking on a cloud. Newly constructed canvas and suede 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	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	26791-DEFAULT-s.jpg	107	1000	VN0A3WMAVNE	383081	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-comfycush-old-skool-skate-shoe-383081	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Checkered Boys Kids Crew Sock $8.00 | view details

BILLABONG Billabong Sun Dream Tank Set $59.95 | view details

ETHIKA Ethika Greetings From Ethika Boy's Boxer Brief $15.00 | view details

BILLABONG Billabong Rotor Performance Fit Boy's Short Sleeve Rashguard $29.95 | view details

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

VANS Vans Comfycush Old Skool Skate Shoe $70.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	Platinum,Desert Daze,Off Black,White	BILLABONG	BILLABONG	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	29.99	0	29.99	26578-DEFAULT-l.jpg	29	26578-DEFAULT-m.jpg	Strand Walk Sandal	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]	63	25-to-50	0.00	[empty string]	Billabong Strand Walk Sling Back Sandals	<p>A barely there, barefoot sandals. Clean lines and all-day comfort come together in this minimalist sandal, featuring a sling back and metal wrap detail at the toe post.The vegan leather sandals are topped with a logo print at the heel.</p> <ul> <li>Womens sling back sandals.</li> <li>Vegan leather.</li> <li>Metal wrap at toe post.</li> <li>Thong style straps.</li> <li>Contrast stitching at elastic back.</li> <li>Sandy Construction.</li> </ul>	[empty string]	N	29.95	29.95	6,7,8,9,10	26578-DEFAULT-s.jpg	5	1000	JFOTTBST	385587	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	billabong/billabong-strand-walk-sling-back-sandals-385587	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	10	1000	VN00097M9X1	315153	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-slipon-pro-skate-shoe-black-white-gum-315153	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	White	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	11.99	0	11.99	25804-DEFAULT-l.jpg	11	25804-DEFAULT-m.jpg	Leckey Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	SU18	[empty string]	OH at 200	[empty string]	19	10-to-15	0.00	[empty string]	Stance Leckey Classic Crew Sock	<p>Leckey features too may comforts to name. Don't believe us? Scroll that sweet product knowledge below.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	<p>Stance Laretto Socks (Grey, Medium)</p>	N	12	12	Medium,Large	25804-DEFAULT-s.jpg	16	1000	M556A18LEC	368939	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-leckey-classic-crew-sock-368939	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	GLOBE	GLOBE	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	84.99	0	84.99	26625-DEFAULT-l.jpg	84	26625-DEFAULT-m.jpg	Fusion Charcoal/Highrise	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	63	50-to-100	0.00	[empty string]	Globe Fusion Skate Shoe, Charcoal/Highrise	<p>Rugged, fully padded skate shoe</p> <p>+ Step-in sock liner</p> <p>+ TPR ollie reinforcement</p> <p>+ Globe's S-Trac™ sole pattern</p> <p>+ TPR heel stabilizer</p>	[empty string]	N	85	85	8,8.5,9,9.5,10,10.5,11,11.5,12,13,14	26625-DEFAULT-s.jpg	17	1000	GBFUS-15250	383560	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	globe/globe-fusion-skate-shoe-charcoal-highrise-383560	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DVS	DVS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	27035-DEFAULT-l.jpg	69	27035-DEFAULT-m.jpg	Comanche White/Charcoal Nubuck	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	51	50-to-100	0.00	[empty string]	DVS Comanche Skate Shoe, White/Charcoal	<p>The Comanche from DVS is a heritage skate shoe that offers unmatched comfort and durability.  This men’s skate shoe features a durable rubber cupsole construction with reinforced ollie area, leather upper, heavy-duty collar and tongue padding for extra protection, as well as a high impact EVA midsole.  You need to lace up a pair of the Comanche to truly feel the comfort and support of this timeless skate shoe. </p> <ul> <li>Leather & nubuck upper materials</li> <li>Molded TPR heel cap with core logo</li> <li>High impact insole & midsole unit</li> <li>Durable cupsole construction</li> <li>Reinforced ollie area for durability</li> <li>High density collar & tongue padding for support</li> <li>Open-cell breathable mesh tongue</li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	27035-DEFAULT-s.jpg	22	1000	DVF0000029114	383541	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-comanche-skate-shoe-white-charcoal-383541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	GLOBE	GLOBE	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	94.99	0	94.99	26624-DEFAULT-l.jpg	94	26624-DEFAULT-m.jpg	Sabre Charcoal/Black/Camo	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]	BLK COMBO	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	45	50-to-100	0.00	[empty string]	Globe Sabre Skate Shoe, Charcoal/Black/Camo	<p>The Sabre in Charcoal/Black/Camo is a ultra heavy duty skate style made of action nubuck/synthetic nubuck. It features a step-in sock liner with Nitrocel ™ airbag sole. It has a Globe's S-Trac ™ sole pattern.</p>	[empty string]	N	95	95	9.5,10,10.5,11,11.5,12,13,14	26624-DEFAULT-s.jpg	24	1000	GBSABR-15249	383559	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	globe/globe-sabre-skate-shoe-charcoal-black-camo-383559	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

BILLABONG Billabong Strand Walk Sling Back Sandals $29.95 | view details

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

STANCE Stance Leckey Classic Crew Sock $12.00 | view details

GLOBE Globe Fusion Skate Shoe, Charcoal/Highrise $85.00 | view details

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

GLOBE Globe Sabre Skate Shoe, Charcoal/Black/Camo $95.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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	34.99	0	34.99	25934-DEFAULT-l.jpg	34	25934-DEFAULT-m.jpg	Deathbox Spf 81b Whl 4- Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Bones Deathbox SPF 81b Skateboard Wheels	<p>Skatepark Formula™ (SPF) is very high quality urethane specifically formulated to resist flatspotting on slick or smooth surfaces while maintaining a higher rebound for a quicker response and a faster roll.</p> <p>Skatepark Formula™ has a high resistance to abrasion while not compromising hardness and slide ability. Simply put… Skatepark Formula wheels grip better on slick surfaces, are almost impossible to flatspot, and are the fastest, longest lasting wheel on the market today.</p> <p>You won’t find our Skatepark Formula from any other wheel supplier so get a set and find out for yourself what the word on SPF is all about.</p>	[empty string]	N	34.99	34.99	54MM,55MM,56MM,60MM	25934-DEFAULT-s.jpg	26	1000	WSCABS02	376340	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-deathbox-spf-81b-skateboard-wheels-376340	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	109.99	0	109.99	26427-DEFAULT-l.jpg	109	26427-DEFAULT-m.jpg	Penny Wht/Cop Metallic Fade Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Penny Skateboards White Copper Complete Skateboard, 22"	<p>It's a Penny party! Who say's you only have to rock metallics for a special event? Everyday life should be a special event! Our White Copper 22" Penny Skateboard will be sure to turn heads when you cruise on over to your best friend's birthday party! Or cruise on it during an early sunrise session and watch the way the sun radiates off of the copper and silver metallics! This Penny board will keep you the life of the party!</p> <ul> <li>22" Plastic Deck</li> <li>3-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	109.99	109.99	22IN	26427-DEFAULT-s.jpg	29	1000	P22WCMF-C	354006	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-white-copper-complete-skateboard-22-354006	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	KRUX	KRUX	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD TRUCKS	24.99	0	24.99	26865-DEFAULT-l.jpg	24	26865-DEFAULT-m.jpg	Black Marbs Dlk 8.25 Standard Truck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	20-to-25	0.00	[empty string]	Krux Black Marbs DLK Standard Trucks	<p>Extra Fresh! New "Marbs" Krux Trucks are here and ready to shred! Each set of the "Marbs" trucks features the Krux Downlow Kingpin (DLK). Designed to prevent any snags or hang ups during grinds and perfect for smiths and feebles. Truly the smoothest grind. Krux Lows are great for tech shredders and makes flip tricks easier. Perfect for ledges, rails and any other street terrain too. Krux Lows are great for tech shredders and makes flip tricks easier. Perfect for ledges, rails and any other street terrain too.</p>	[empty string]	N	24.99	24.99	8.25	26865-DEFAULT-s.jpg	29	1000	33132344-825	387667	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD TRUCKS	krux/krux-black-marbs-dlk-standard-trucks-387667	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; LONGBOARD DECKS	118.99	0	118.99	26318-DEFAULT-l.jpg	118	26318-DEFAULT-m.jpg	Battle Axe 40 Chill Bird Deck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Landyacthz Battle Axe 40 Chill Bird Deck, 40"	<p>Despite the aggressive name, this board can be pretty dang chill. For those who want to casually cruise around town, and those who want to fulfill their dreams by carving up the streets like wild animals. The perfect combo of drop through truck mounting, rocker, and a little bit of flex make it easy and comfortable to ride. One of our most popular boards of all time.</p>	[empty string]	N	119	119	40IN	26318-DEFAULT-s.jpg	68	1000	DK-FRBA40	377895	LONGBOARD DECKS	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyacthz-battle-axe-40-chill-bird-deck-40-377895	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	TRIPLE EIGHT	TRIPLE EIGHT	SKATEBOARDS	SKATEBOARDS &GT; PROTECTIVE GEAR &GT; PADS	34.99	0	34.99	18672-DEFAULT-l.jpg	34	18672-DEFAULT-m.jpg	Kp 22 Knee 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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	52	25-to-50	0.00	[empty string]	Triple Eight KP 22 Knee Pads	<p>Designed for those skaters that need more padding, our KP 22 knee pads combine durability, comfort and maximum padding that gets you back up after a fall.</p> <ul> <li>Heavy duty EVA memory foam</li> <li>High–density, impact-resistant cap securely attached with reinforced rivets</li> <li>Neoprene butterfly closure</li> <li>Top elastic and bottom webbed adjustable straps</li> <li>Flat cap design for longevity and stability</li> </ul>	[empty string]	N	34.99	34.99	Small,Medium,Large,X-Large,X-Small,N/A2	18672-DEFAULT-s.jpg	71	1000	T8KP22	239628	PADS	EMPTY	EMPTY	0	0	0	PROTECTIVE GEAR	triple-eight/triple-eight-kp-22-knee-pads-239628	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	SKATEBOARDS	SKATEBOARDS &GT; VIDEO AND AUDIO	999.99	0	999.99	3037-DEFAULT-l.jpg	999	3037-DEFAULT-m.jpg	Bc Surf Sport In- Store Gift Card	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	FREE	[empty string]	[empty string]	[empty string]	TOP SELLERS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	108	20-to-25	0.00	[empty string]	BC Surf & Sport Gift Card - In-Store or Online use	<p>BC Surf & Sport Gift Card - In-Store or Online use</p>	[empty string]	N	25	1000	[empty string]	3037-DEFAULT-s.jpg	87	1000	BCGC	252213	EMPTY	EMPTY	EMPTY	0	0	0	VIDEO AND AUDIO	bc/bc-surf-sport-gift-card-instore-or-online-use-252213	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

BONES Bones Deathbox Spf 81b Skateboard Wheels $34.99 | view details

PENNY Penny Skateboards White Copper Complete Skateboard, 22 " $109.99 | view details

KRUX Krux Black Marbs Dlk Standard Trucks $24.99 | view details

LANDYACHTZ Landyacthz Battle Axe 40 Chill Bird Deck, 40 " $119.00 | view details

TRIPLE EIGHT Triple Eight Kp 22 Knee Pads $34.99 | view details

BC Bc Surf & Sport Gift Card - In- Store Or Online Use $25.00 to $1,000.00 | 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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	89.99	0	89.99	26288-DEFAULT-l.jpg	89	26288-DEFAULT-m.jpg	Fam2 Honeycomb Thruster Fins	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Futures AM2 Honeycomb Thruster Fins	<p>The AM2 Honeycomb, designed by Al Merrick of Channel Island Surfboards, is a large size Balanced fin with a Ride Number of 4.6. Featuring a neutral flex pattern this fin is a more versatile option for bigger surfers. The AM2 Honeycomb fin is designed to perform in a variety of conditions and features a smaller center fin for increased maneuverability.</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.98</td> <td>15.32</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.73</td> <td>4.49</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.64</td> <td>4.63</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	90	90	[empty string]	26288-DEFAULT-s.jpg	12	1000	1160-156-00	369936	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-am2-honeycomb-thruster-fins-369936	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Gunmetal,Mid	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	43.99	0	43.99	25844-DEFAULT-l.jpg	43	25844-DEFAULT-m.jpg	Mens Covert Ss Rashguard	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	FBA FILLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SU16	[empty string]	OH at 200	[empty string]	25	25-to-50	0.00	[empty string]	Dakine Covert Short Sleeve Rashguard	<p>Seamless paddle zones for maximum mobility and comfort. 7.2 oz snug fit surf shirt. UPF 50+ sun protection. Boardshort connector. Welded waist and sleeve hem for low profile/ seamless appearance. Covert low profile seams. Material: Polyester, elastane.</p> <ul> </ul>	[empty string]	N	43.99	43.99	Small,Medium,Large,X-Large,XX-Large	25844-DEFAULT-s.jpg	14	1000	10000390	361897	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	dakine/dakine-covert-short-sleeve-rashguard-361897	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; CAR RACKS	21.99	0	21.99	13193-DEFAULT-l.jpg	21	13193-DEFAULT-m.jpg	Tie Downs W/Cam Locks	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	R	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	1	20-to-25	0.00	[empty string]	FCS Cam Lock Tie Down Straps 13'	<p>Simple and strong, the FCS Cam Lock system will efficiently strap your boards down.</p>	<p>FCS Cam Lock Tie Down Straps 13 foot (PAIR)</p>	N	21.98	21.98	[empty string]	13193-DEFAULT-s.jpg	23	1000	1902-553-00B	210622	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-cam-lock-tie-down-straps-13-210622	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	94.99	0	94.99	26254-DEFAULT-l.jpg	94	26254-DEFAULT-m.jpg	F8 Alpha 5- Fin Set	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]	Future F8 Alpha 5-Fin	<p>Alpha now comes in 5-fin combinations. Molded carbon fiber made in Huntington Beach, California that delivers every bit of performance you’d expect from an upgrade fin at a Balanced Ride Number. Incredibly lightweight & resilient, Alpha is the first of its kind; created using one-of-a-kind materials and new technologies developed by Futures.</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> <th style="text-align:left">Rear Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.90</td> <td>15.90</td> <td>11.67</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.64</td> <td>4.37</td> <td>4.05</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.47</td> <td>4.22</td> <td>3.87</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> <td>SYMM</td> </tr> </tbody> </table>	<p>Future Fins Alpha Five Fin Set 5 fin Surfboard - F8 - 3.75 Rears</p>	N	95	95	[empty string]	26254-DEFAULT-s.jpg	25	1000	3175-324-50	363559	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/future-f8-alpha-5fin-363559	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; FINS	134.99	0	134.99	26126-DEFAULT-l.jpg	134	26126-DEFAULT-m.jpg	Fcs Ii Eric Terrien 8.5 ”	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	100-to-150	0.00	[empty string]	FCS II Eric Terrien SUP Fin - 8.5"	<p>Multi-purpose SUP fin with great turning capabilities and moderate stroke hold.</p> <p><strong>Overview</strong></p> <ul> <li> <p>Eric Terrien Europe's winningest racer was a big fan of the Slater Trout fin but wanted to add better tracking and more strokes per side.</p> </li> <li> <p>The extended bump on the trailing edge does exactly that and Eric and his FCS teammates have won multiple races on this fin.</p> </li> <li> <p>Suited to a variety of conditions from surf to flat water.</p> </li> </ul>	[empty string]	N	135	135	[empty string]	26126-DEFAULT-s.jpg	35	1000	FTER-PCS1-SP-85-R	348088	SUP ACCESSORIES	FINS	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-ii-eric-terrien-sup-fin-85-348088	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	64.99	0	64.99	26267-DEFAULT-l.jpg	64	26267-DEFAULT-m.jpg	Alpha F8 Thruster Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Futures F8 Alpha Thruster Fins	<p>The F8 Alpha is a large size Balanced fin with a Ride Number of 6.5. Alpha's C6 composite material is carbon and air infused making it lighter than Honeycomb. The responsive flex characteristics of C6 combine with the neutral F-Series template to create one of the most exciting new products on the market. All Alpha products are designed and manufactured exclusively in Huntington Beach, Ca USA.</p> <table cellspacing="0" class="specf-table" style="-webkit-text-stroke-width:0px; background-color:#ffffff; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; width:537.6px; word-spacing:0px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> <th style="text-align:left">Center Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.90</td> <td>15.90</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.64</td> <td>4.64</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.47</td> <td>4.47</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	65	65	[empty string]	26267-DEFAULT-s.jpg	39	1000	1175-324-00	349065	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-f8-alpha-thruster-fins-349065	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

FUTURE FINS Futures Am2 Honeycomb Thruster Fins $90.00 | view details

DAKINE Dakine Covert Short Sleeve Rashguard $43.99 | view details

FCS Fcs Cam Lock Tie Down Straps 13 ' $21.98 | view details

Future Fins Future F8 Alpha 5- Fin $95.00 | view details

FCS Fcs Ii Eric Terrien Sup Fin - 8.5 " $135.00 | view details

FUTURE FINS Futures F8 Alpha Thruster Fins $65.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	Chub	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25541-DEFAULT-l.jpg	19	25541-DEFAULT-m.jpg	Chub Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	SU17	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Chub	<h6><em>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option</em></h6>	[empty string]	N	19.99	19.99	[empty string]	25541-DEFAULT-s.jpg	5	1000	FSH-SL-CHUB	382012	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-chub-382012	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	499.99	0	499.99	26364-DEFAULT-l.jpg	499	26364-DEFAULT-m.jpg	Instagator Lt	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	5	450-to-500	0.00	[empty string]	Never Summer Insta/Gator LT Snowboard, 2019	<p>Snap in and out of turns, spin like a machine, and rail like a train. Size your Gator smaller and improve your OVERALL performance. Amazing nimbility with stability is what 12mm of taper and massive surface area will do for you. All boards ride great in perfect conditions, now ride you can ride great ANYWHERE in ANY CONDITIONS. It’s a new world...adjust your stance width, placement, and angles for ride variations that fit the days mood, conditions, and style. You’d better get a Gator sooner rather than later. LT - Narrower version of the original</p>	[empty string]	N	499.99	499.99	142	26364-DEFAULT-s.jpg	11	1000	INSTAGATORLT-I	374736	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-insta-gator-lt-snowboard-2019-374736	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	24.99	0	24.99	25874-DEFAULT-l.jpg	24	25874-DEFAULT-m.jpg	Baja Tie Down Straps 12'set Of 2	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	Dakine Baja Tie Down Rack Straps	<p>The Dakine Baja Tie Down Straps are heavy-duty straps designed for car roof racks. These straps are sold in sets of two 12-foot straps with 1-3/8 inch cam buckles for secure tightening. The Baja Tie Down Straps also feature a protective neoprene buckle housing.</p> <ul> <li>Heavy duty 1 3/8" [ 35mm ] cam buckle</li> <li>Neoprene buckle housing</li> <li>Carrying bag</li> <li>Set of two straps</li> </ul>	[empty string]	N	25	25	[empty string]	25874-DEFAULT-s.jpg	12	1000	8840560	271110	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-baja-tie-down-rack-straps-271110	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	HARLAUT	OAKLEY	OAKLEY	SNOWBOARDING	SNOWBOARDING &GT; GOGGLES	159.99	0	159.99	25998-DEFAULT-l.jpg	159	25998-DEFAULT-m.jpg	Lineminer Harlaut Sig/Prizm Blk Ird	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]	2020	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Oakley Line Miner Snow Goggle, Matte Black/Prizm Snow Sapphire Iridium	<p>The Line Miner goggle was created with the purpose of providing the ultimate in peripheral vision, with a cylindrical-style design. We were able to pull the goggle in closer to your face than ever before, allowing for incredible downward and side-to-side periphery. Discreet frame notches at temples provide compatibility with most prescription eyewear.</p>	[empty string]	N	160	160	[empty string]	25998-DEFAULT-s.jpg	28	1000	OO7070-41	375573	EMPTY	EMPTY	EMPTY	0	0	0	GOGGLES	oakley/oakley-line-miner-snow-goggle-matte-black-prizm-snow-sapphire-iridium-375573	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Green	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	12.99	0	12.99	25880-DEFAULT-l.jpg	12	25880-DEFAULT-m.jpg	Micro Lock	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	Dakine Micro Lock	<p>Our smallest and lightest lock, the Micro Lock is basically a scaled-down version of our Cool Lock. You set your own combination on the 3-digit tumbler lock, making it much easier to remember than a factory-set combo. The 30-inch retractable cable gives you the same peace of mind in securing your snowboard or skis to the roof rack of an SUV or the rack outside the lodge. And it comes in an even more convenient pack-and-carry form factor than its big brother.</p>	[empty string]	N	13	13	[empty string]	25880-DEFAULT-s.jpg	30	1000	10001563-I	373467	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-micro-lock-373467	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; MEN'S OUTERWEAR &GT; JACKETS	71.99	0	71.99	26083-DEFAULT-l.jpg	71	26083-DEFAULT-m.jpg	Eagle Anorak Jacket	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]	22	50-to-100	0.00	[empty string]	Never Summer Eagle Anorak Jacket	<p>Never Summer Eagle Anorak Jacket</p>	[empty string]	N	69.99	71.99	Medium,Large,X-Large,XX-Large	26083-DEFAULT-s.jpg	31	1000	JKEAGAN	374780	MENS OUTERWEAR	JACKETS	EMPTY	0	0	0	OUTERWEAR	never-summer/never-summer-eagle-anorak-jacket-374780	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

NEVER SUMMER Never Summer Insta/Gator Lt Snowboard, 2019 $499.99 | view details

DAKINE Dakine Baja Tie Down Rack Straps $25.00 | view details

OAKLEY Oakley Line Miner Snow Goggle, Matte Black/Prizm Snow Sapphire Iridium $160.00 | view details

DAKINE Dakine Micro Lock $13.00 | view details

NEVER SUMMER Never Summer Eagle Anorak Jacket $69.99 to $71.99 | view details

Accessories

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	PENNY	PENNY	ACCESSORIES	ACCESSORIES &GT; BACKPACKS	44.99	0	44.99	26426-DEFAULT-l.jpg	44	26426-DEFAULT-m.jpg	Penny Pouch Dark Dye Backpack	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Penny Skateboards Dark Dye Backpack	<p>Penny Skateboards Dark Dye Backpack</p>	[empty string]	N	44.99	44.99	[empty string]	26426-DEFAULT-s.jpg	1	1000	PNYA011	365476	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-dark-dye-backpack-365476	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25809-DEFAULT-l.jpg	13	25809-DEFAULT-m.jpg	Off My Wave Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	OH at 200	[empty string]	22	10-to-15	0.00	[empty string]	Stance Off My Wave Classic Crew Sock	<p>Locals only man! The Off My Wave sends a message loud and clear to those trying to snake in on your good times in the water and out.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25809-DEFAULT-s.jpg	2	1000	M556C18OMW	370516	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-off-my-wave-classic-crew-sock-370516	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Black,White	QUIKSILVER	QUIKSILVER	ACCESSORIES	ACCESSORIES &GT; HATS	27.99	0	27.99	26895-DEFAULT-l.jpg	27	26895-DEFAULT-m.jpg	Podium 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]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Quiksilver Podium Trucker Hat	<ul> <li>New Era® 9FIFTY</li> <li>A-frame snapback design</li> <li>5-panel structure with a flat brim</li> <li>Polyester front panels</li> <li>Mesh back</li> <li>High-density screen-print on front</li> <li>Adjustable plastic snap closure</li> <li>100% Polyester</li> </ul>	[empty string]	N	28	28	O/S	26895-DEFAULT-s.jpg	2	1000	AQYHA04332	390960	EMPTY	EMPTY	EMPTY	0	0	0	HATS	quiksilver/quiksilver-podium-trucker-hat-390960	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Charcoal	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	31.99	0	31.99	26521-DEFAULT-l.jpg	31	26521-DEFAULT-m.jpg	The Vision Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Arcade Vision Belt, Charcoal	<p>The Arcade Vision is packed with everything Arcade is known for in an elevated package. Stretchy elastic webbing built to perform at the highest level from the office to the outdoors is paired with a custom buckle that is light as balsa and strong as metal. A hidden adjustment point, unique inlay, and premium trim make this Arcade original the perfect belt to take from the street to the outdoors.</p> <ul> <li>One size fits most, up to 40″ (101.6cm)</li> <li>Custom Capture Buckle</li> <li>Washer/Dryer safe</li> <li>Belt width – 1.5″ (3.81cm)</li> </ul>	[empty string]	N	32	32	[empty string]	26521-DEFAULT-s.jpg	5	1000	A14200-014	383737	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-vision-belt-charcoal-383737	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	24.99	0	24.99	26043-DEFAULT-l.jpg	24	26043-DEFAULT-m.jpg	Kerfuffle Navy	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	18	20-to-25	0.00	[empty string]	Dot Dash Kerfuffle Sunglasses, Navy Satin/Retro Grey	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	25	25	[empty string]	26043-DEFAULT-s.jpg	7	1000	DSVTFKER-NVY	314325	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-kerfuffle-sunglasses-navy-satin-retro-grey-314325	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	169.99	0	169.99	27181-DEFAULT-l.jpg	169	27181-DEFAULT-m.jpg	Tuna Alley Blkout/Gry 580p	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	150-to-200	0.00	[empty string]	Costa Del Mar Tuna Alley Sunglasses, Blackout/Gray Polarized 580P	<h4>580G</h4> <h5>LIGHTWAVE GLASS</h5> <p>SUPERIOR CLARITY & SCRATCH-RESISTANT</p> <ul> <li>GLASS PROVIDES THE BEST CLARITY IN MATERIAL</li> <li>ENCAPSULATED MIRRORS (BETWEEN LAYERS OF GLASS) ARE SCRATCH-PROOF</li> <li>20% THINNER AND 22% LIGHTER THAN AVERAGE POLARIZED GLASS</li> </ul> <ul> <li>FRAME SPECIFICATIONS:</li> <li>1. Frame Width: 132.6mm</li> <li>2. Bridge Width: 13mm</li> <li>3. Lens Width: 61.8mm</li> <li>4. Lens Height: 41.1mm</li> <li>5. Temple Arm Length: 114.8mm</li> </ul>	[empty string]	N	169.99	169.99	[empty string]	27181-DEFAULT-s.jpg	8	1000	TA 01 OGP	302056	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	costa-del-mar/costa-del-mar-tuna-alley-sunglasses-blackout-gray-polarized-580p-302056	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]