Thrasher Skategoat Sticker, Assorted Colors

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	Navy,MHT	ONEILL	ONEILL	MENS	MENS &GT; TOPS &GT; T-SHIRTS	21.99	0	21.99	27061-DEFAULT-l.jpg	21	27061-DEFAULT-m.jpg	Dawn Catch 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]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	11	20-to-25	0.00	[empty string]	O'Neill Dawn Catch Short Sleeve T-Shirt	<ul> <li>O'Neill Men's standard tee</li> <li>Standard fit- relaxed through the body and sleeves</li> <li>Cotton heather design</li> <li>Softhand Screenprint</li> <li>50% Cotton, 50% Polyester</li> </ul>	[empty string]	N	22	22	Small,Medium,Large,X-Large,XX-Large	27061-DEFAULT-s.jpg	1	1000	SP9118108	384020	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	oneill/oneill-dawn-catch-short-sleeve-tshirt-384020	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DOT DASH	DOT DASH	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	27.99	0	27.99	26038-DEFAULT-l.jpg	27	26038-DEFAULT-m.jpg	Destro Blk/Satin 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]	TOP 25	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Dot Dash Destro Sunglasses, Black/Grey Polarized	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <h5>Specs</h5> <ul> <li>Polarized Lens</li> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	28	28	[empty string]	26038-DEFAULT-s.jpg	2	1000	DSLRFDES-BKS	274610	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-destro-sunglasses-black-grey-polarized-274610	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Black	STANCE	STANCE	MENS	MENS &GT; BOTTOMS &GT; BOXERS/BRIEFS	34.99	0	34.99	27111-DEFAULT-l.jpg	34	27111-DEFAULT-m.jpg	Night Night Wholester Underwear	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]	11	25-to-50	0.00	[empty string]	Stance Night Night Butter Blend Boxer Brief	<p>Step into exotic floral splendor with Nigh Night. A wholster style underwear designed to keep your goods in pampered luxury.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief with Stance Wholester™ technology</li> <li>6'' Inseam Length</li> <li>Feather-Seam™ Construction</li> <li>Butter Blend™ Fabric</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	35	35	Small,Medium,Large,X-Large	27111-DEFAULT-s.jpg	2	1000	M901A19NIG	383878	UNDERWEAR	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-night-night-butter-blend-boxer-brief-383878	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Summit White,338	HURLEY	HURLEY	MENS	MENS &GT; TOPS &GT; T-SHIRTS	35.99	0	35.99	27046-DEFAULT-l.jpg	35	27046-DEFAULT-m.jpg	Dri Fit Harvey Stripe Ss Knit Crew	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]	40	25-to-50	0.00	[empty string]	Hurley Dri-FIT Harvey Short Sleeve T-Shirt	<p>The Hurley Dri-FIT Harvey Top delivers timeless stripes with sweat-wicking technology designed to keep you cool and comfortable all day long.</p> <ul> </ul>	[empty string]	N	36	36	Small,Medium,Large,X-Large,XX-Large	27046-DEFAULT-s.jpg	4	1000	AR7113	382910	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	hurley/hurley-drifit-harvey-short-sleeve-tshirt-382910	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	8.99	0	8.99	25939-DEFAULT-l.jpg	8	25939-DEFAULT-m.jpg	Fathom Cord	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	5-to-10	0.00	[empty string]	Costa Del Mar Fathom Cord Sunglasses Holder	<p>FATHOM CORD. Marine-grade, soft nylon retainer designed specifically to fit Fathom and all styles, especially those with co-injected temples.  <strong>End-to-End Measurement: </strong>28"</p>	[empty string]	N	8.99	8.99	[empty string]	25939-DEFAULT-s.jpg	5	1000	CF11	349328	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	costa-del-mar/costa-del-mar-fathom-cord-sunglasses-holder-349328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	15.99	0	15.99	26759-DEFAULT-l.jpg	15	26759-DEFAULT-m.jpg	Kevin Lyons Watercolor Sock	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]	OH at 200	[empty string]	2	15-to-20	0.00	[empty string]	Stance Kevin Lyons Watercolor Crew Sock	<p>A Watercolor presentation of pesky pastel monstrosities, finally caught out and about from under your bed. Another fun one from the beautiful mind of legendary illustrator, Kevin Lyons.</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	26759-DEFAULT-s.jpg	5	1000	M556D18KLW	383778	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-kevin-lyons-watercolor-crew-sock-383778	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

ONEILL O ' Neill Dawn Catch Short Sleeve T- Shirt $22.00 | view details

DOT DASH Dot Dash Destro Sunglasses, Black/Grey Polarized $28.00 | view details

STANCE Stance Night Night Butter Blend Boxer Brief $35.00 | view details

HURLEY Hurley Dri- Fit Harvey Short Sleeve T- Shirt $36.00 | view details

COSTA DEL MAR Costa Del Mar Fathom Cord Sunglasses Holder $8.99 | view details

STANCE Stance Kevin Lyons Watercolor Crew Sock $16.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]	137	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	367	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]	139	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	370	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]	129	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sunset Cove	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25578-DEFAULT-s.jpg	458	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	Natural,Yellow	STANCE	STANCE	WOMENS	WOMENS &GT; ACCESSORIES &GT; SOCKS	9.99	0	9.99	26783-DEFAULT-l.jpg	9	26783-DEFAULT-m.jpg	Women's Glowing No Show	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]	28	5-to-10	0.00	[empty string]	Stance Glowing Women's No Show Sock	<p>A real show-stopper of a Super Invisible 2.0. With classic styling in eye-catching color, this style is literally Glowing with confidence.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot and Toe For Cushioning</li> <li>Silicone Gripper For No Heel Slip</li> <li>Ultra Lite Cushion</li> <li>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	10	10	Small,Medium	26783-DEFAULT-s.jpg	1	1000	W145A19GLO	383824	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-glowing-womens-no-show-sock-383824	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Bone	VISSLA	VISSLA	WOMENS	WOMENS &GT; ACCESSORIES &GT; HATS	34.99	0	34.99	26939-DEFAULT-l.jpg	34	26939-DEFAULT-m.jpg	Quiltage 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]	2	25-to-50	0.00	[empty string]	Vissla Quiltage Hat	<p>The Quiltage is a colorful, unstructured 5 Panel hat with adjustable back closure. Featuring woven patch, custom interior taping and flag label at back, the Quiltage shows original artwork by master surf-auteur, Thomas Campbell. <br /> <br /> Made from 65% POLYESTER \| 35% COTTO</p> <ul> </ul>	[empty string]	N	34.95	34.95	[empty string]	26939-DEFAULT-s.jpg	2	1000	MAHTKQUI	389414	HATS	EMPTY	EMPTY	0	0	0	EMPTY	vissla/vissla-quiltage-hat-389414	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Marshmallow,Misty Rose	ROXY	ROXY	WOMENS	WOMENS &GT; TOPS &GT; T-SHIRTS	34.99	0	34.99	27083-DEFAULT-l.jpg	34	27083-DEFAULT-m.jpg	In The Mirrors Tee	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Roxy H and K In The Mirrors Women's Tee	<p>The nuts and bolts</p> <ul> <li>Fabric: Lightweight viscose linen fabric [138g/m2]</li> <li>Fit: Classic, comfortable regular fit</li> <li>Neck: Round neckline</li> <li>Raw-edge on hem</li> <li>Twisted turned-up sleeves</li> <li>Screen print on chest and back</li> </ul> <p>Composition</p> <ul> <li> <p>85% Viscose, 15% Linen</p> </li> </ul>	[empty string]	N	35	35	Small,Medium	27083-DEFAULT-s.jpg	3	1000	ERJZT04391	395394	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	roxy/roxy-h-and-k-in-the-mirrors-womens-tee-395394	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

STANCE Stance Glowing Women's No Show Sock $10.00 | view details

VISSLA Vissla Quiltage Hat $34.95 | view details

ROXY Roxy H And K In The Mirrors Women's Tee $35.00 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Orange	BILLABONG	BILLABONG	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOARDSHORTS	49.99	0	49.99	26802-DEFAULT-l.jpg	49	26802-DEFAULT-m.jpg	Boys 73 Stripe Pro 17 ` Boardshort	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]	STRETCH	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	30	25-to-50	0.00	[empty string]	Billabong Boys' 73 Stripe Pro Boardshorts	<p>Modern and heritage lines meet in the 73 Stripe Pro Boys Boardshort. Fusing modern performance-driven technology retro boardshort design and an allover fade stripe print, the 73 Stripe Pro features a 4-way stretch fabric with an engineered fit, finished with binding at the sides seams and scalloped hem. Consciously constructed, the Pro Series boardshort is now made from eco and performance-minded 4-way stretch recycled fabric.</p>	[empty string]	N	49.95	49.95	22,23,24,25,26,27,28,29	26802-DEFAULT-s.jpg	45	1000	B127TBST	382362	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-boys-73-stripe-pro-boardshorts-382362	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	48	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]
3	Multi	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26808-DEFAULT-l.jpg	59	26808-DEFAULT-m.jpg	Sun Dream Hi Nck Set	N	GIRLS	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]	SPRING	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Billabong Girls' Sun Dream Tali Bikini Set	<p>Pick a bikini in full bloom or mix and clash with this reversible bikini set. The girls bikini features a top that reverses from striped to floral print, and a matching floral print bikini bottom. Both top and bottom are rimmed with strappy details for a modern look.</p>	[empty string]	N	59.95	59.95	4,7,8,10,14	26808-DEFAULT-s.jpg	65	1000	Y214TBSU	387573	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-girls-sun-dream-tali-bikini-set-387573	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Rock	BILLABONG	BILLABONG	KIDS	KIDS &GT; BOYS &GT; TOPS &GT; T-SHIRTS	17.99	0	17.99	26957-DEFAULT-l.jpg	17	26957-DEFAULT-m.jpg	Boys Spinner Ss Pocket Tee	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	14	15-to-20	0.00	[empty string]	Billabong Spinner Boy's Short Sleeve T-Shirt	<p>Re-spin a classic striped tee with a dose of printed lines and a minimalist Billabong logo. Designed with a classic fit, the boys short sleeve pocket tee features a stripe print across the chest and small wave logo print at the pocket. Made from 100% cotton, the boys pocket tee is finished with a printed label for tag-free comfort.</p> <p>The nuts and bolts</p> <ul> <li> <p>Boys pocket t-shirt.</p> </li> <li>Stripe print across chest and small wave logo above chest pocket.</li> <li>Crew neck.</li> <li>Short sleeves.</li> <li>Side seam flag label.</li> <li>Printed neck label.</li> <li>Material: 26/1, 160g jersey. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	17.95	17.95	Small,Medium,Large	26957-DEFAULT-s.jpg	77	1000	B433TBSP	382406	TOPS	T-SHIRTS	EMPTY	0	0	0	EMPTY	billabong/billabong-spinner-boys-short-sleeve-tshirt-382406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Black	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	9.99	0	9.99	25754-DEFAULT-l.jpg	9	25754-DEFAULT-m.jpg	Boy's Back Off 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]	15	5-to-10	0.00	[empty string]	Stance Back Off Boys Kids Crew Sock	<p>Put the little punks in something that fits their unrestrained temperament with Back Off Boys.</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	10	10	Medium,Large	25754-DEFAULT-s.jpg	92	1000	B526D18BAC	380129	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-back-off-boys-kids-crew-sock-380129	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	110	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

BILLABONG Billabong Boys ' 73 Stripe Pro Boardshorts $49.95 | view details

STANCE Stance Checkered Boys Kids Crew Sock $8.00 | view details

BILLABONG Billabong Girls ' Sun Dream Tali Bikini Set $59.95 | view details

BILLABONG Billabong Spinner Boy's Short Sleeve T- Shirt $17.95 | view details

STANCE Stance Back Off Boys Kids Crew Sock $10.00 | view details

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

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	59.99	0	59.99	6509-DEFAULT-l.jpg	59	6509-DEFAULT-m.jpg	Old Skool Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	MEDIUM	[empty string]	[empty string]	[empty string]	SKATE	SPRING	8 - LAST SPRING	[empty string]	[empty string]	198	50-to-100	0.00	[empty string]	Vans Old Skool Skate Shoe, Black/White	<p>The Old Skool, Vans classic skate shoe and the first to bare the iconic side stripe, has a low-top lace-up silhouette with a durable suede and canvas upper with padded tongue and lining and Vans signature Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	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,14	6509-DEFAULT-s.jpg	3	1000	VN000D3HY28	248351	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-old-skool-skate-shoe-black-white-248351	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	74.99	0	74.99	25699-DEFAULT-l.jpg	74	25699-DEFAULT-m.jpg	Kyle Walker Pro Black/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	85	50-to-100	0.00	[empty string]	Vans Kyle Walker Pro Skate Shoe, Black/White	<p>The all new Kyle Walker Pro, the introductory signature model from rookie pro Kyle Walker, is made with suede uppers. The UltraCush HD impact sockliners keep the foot close to the board while providing the highest level of impact cushioning, and the revolutionary Wafflecup construction offers the support of a cupsole without sacrificing any of the grip or boardfeel of a traditional vulcanized shoe. The Kyle Walker Pro also features DURACAP upper reinforcement in high wear areas for unrivaled durability.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	75	75	7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25699-DEFAULT-s.jpg	4	1000	VN0A2XSGY28	366350	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-kyle-walker-pro-skate-shoe-black-white-366350	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	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	7	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]
4	[empty string]	SUPRA	SUPRA	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	74.99	0	74.99	26932-DEFAULT-l.jpg	74	26932-DEFAULT-m.jpg	Hammer Vtg White/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	WHITE	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	29	50-to-100	0.00	[empty string]	Supra Hammer VTG Skate Shoe, White/White	<p>The hammer vtg is jim greco’s newest pro model. This vintage inspired skate shoe uses the same last as the greco, giving it a slim and classic shape. The upper consists of a premium suede vamp/collar/heel with a breathable canvas quarter. The design has references that tie back to the hammer franchise and overlays are detailed by premium french binding. The hammer vtg uses a rubber toe cap and sit atop a brand new vulcanized outsole utilizing dual-layered herringbone tread for ultimate board feel and long lasting durability. The shoe also features the brand new super comfort insole for peak impact protection and all day comfort.<br />  </p>	[empty string]	N	75	75	8,8.5,9,9.5,10,10.5,11,12	26932-DEFAULT-s.jpg	9	1000	06123-101	384710	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	supra/supra-hammer-vtg-skate-shoe-white-white-384710	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	White,Black	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	15.99	0	15.99	25737-DEFAULT-l.jpg	15	25737-DEFAULT-m.jpg	Network Socks	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	58	15-to-20	0.00	[empty string]	Stance Network Classic Crew Sock	<p>Don't get caught in an outdated look. Step into something new with Network, a trendy net design with stitched in flaming palm tree.</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	Medium,Large	25737-DEFAULT-s.jpg	12	1000	M546D18NET	380202	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-network-classic-crew-sock-380202	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DVS	DVS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	26831-DEFAULT-l.jpg	69	26831-DEFAULT-m.jpg	Comanche Black/Reflective/Charcoal	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]	SPRING	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	DVS Comanche Skate Shoe, Black/Reflective/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	11	26831-DEFAULT-s.jpg	18	1000	DVF0000029985	383540	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-comanche-skate-shoe-black-reflective-charcoal-383540	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VANS Vans Old Skool Skate Shoe, Black/White $60.00 | view details

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

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

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

STANCE Stance Network Classic Crew Sock $16.00 | view details

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

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	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	5	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]
2	[empty string]	THRASHER	THRASHER	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	1.99	0	1.99	26438-DEFAULT-l.jpg	1	26438-DEFAULT-m.jpg	Skate And Destroy Large Sticker	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]	106	5-and-under	0.00	[empty string]	Thrasher Skate and Destroy Large Sticker, Assorted Colors	<p>1 Each. Large S.A.D. logo sticker. Measures 3 1/4" tall x 6 1/4" wide. sticker color subject to random selection by the mail order dudes</p>	[empty string]	N	2	2	[empty string]	26438-DEFAULT-s.jpg	15	1000	31310061	240835	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	thrasher/thrasher-skate-and-destroy-large-sticker-assorted-colors-240835	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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.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	21	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]
4	[empty string]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	89.99	0	89.99	27144-DEFAULT-l.jpg	89	27144-DEFAULT-m.jpg	Shakedown 37 ` Crosscut 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]	1	50-to-100	0.00	[empty string]	Arbor Shakedown Crosscut Cruiser Skateboard, 37"	<p>A utilitarian shape that delivers versatility for skating it all: street, park, cruiser runs, and downhill.</p> <h4>DECK</h4> <ul> <li>7 Ply Hardrock Maple</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 Street 169mm</li> </ul> <h4>WHEELS</h4> <ul> <li>Arbor Shakedown Series - Shakedown</li> <li>Centerset hybrid wheel for all types of skating</li> <li>Built for technical and freeride skating</li> <li>Size: 58.0mm // Durometer: 80a</li> <li>Contact Patch: 25.0mm // Offset: 0.0mm</li> <li>All-Terrain Core: Supportive for stability at speed</li> <li>Crosscut Formula: Attacks all terrain</li> </ul> <h4>OTHER COMPONENTS</h4> <ul> <li>ABEC 5 Bearings with Spacers</li> <li>1/8" Hard Risers</li> <li>Die-Cut Griptape</li> </ul>	[empty string]	N	89.95	89.95	37	27144-DEFAULT-s.jpg	26	1000	ARBD37000	399894	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arbor/arbor-shakedown-crosscut-cruiser-skateboard-37-399894	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	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]	3	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	35	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]
6	Black Rubber,All Black Rubber,Black Glossy w/Green,DC3,United Red Rubber,Neon Fuchisa Glossy,Blue Fade Rubber,Neon Zest,White Rubber,Baja Teal Rubber,Royal Blue Rubber,Carbon Rubber,DC6,Yellow Rubber	TRIPLE EIGHT	TRIPLE EIGHT	SKATEBOARDS	SKATEBOARDS &GT; PROTECTIVE GEAR &GT; HELMETS	44.99	0	44.99	1293-DEFAULT-l.jpg	44	1293-DEFAULT-m.jpg	Brain Saver W/Sweat Saver Liner Helmet	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]	359	25-to-50	0.00	[empty string]	Triple Eight Sweat Saver Helmet	<p>Our classic helmet, protecting skaters for 18 years and counting.</p> <p>With its timeless design, killer color range and our unique rubber finish, the Sweatsaver Helmet is a staple of our helmet collection. And with our stink-free, moisture-wicking Sweatsaver™ Liner inside, it’s a helmet you’ll use for years to come. Sweatsaver™ replacement liners are also sold separately in various colors to customize your helmet.</p>	[empty string]	N	39.99	44.99	X-Small,Small,Medium,Large,X-Large,XX-Large	1293-DEFAULT-s.jpg	36	1000	T8RUB	200121	HELMETS	EMPTY	EMPTY	0	0	0	PROTECTIVE GEAR	triple-eight/triple-eight-sweat-saver-helmet-200121	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Switch Skull 35 Complete Longboard, 35 " $235.00 | view details

THRASHER Thrasher Skate And Destroy Large Sticker, Assorted Colors $2.00 | view details

BC Bc Surf & Sport Gift Card - In- Store Or Online Use $25.00 to $1,000.00 | view details

ARBOR Arbor Shakedown Crosscut Cruiser Skateboard, 37 " $89.95 | view details

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

TRIPLE EIGHT Triple Eight Sweat Saver Helmet $39.99 to $44.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]	DORSAL	Dorsal	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	32.99	0	32.99	26067-DEFAULT-l.jpg	32	26067-DEFAULT-m.jpg	Wrap- Rax Soft Rack Pads 19 ` Pair	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	52	25-to-50	0.00	[empty string]	Dorsal Deluxe Wrap-Rax Surf and Snow Soft Roof Rack Pads Straps - 19"	<p>The Dorsal Single 19 inch Surf Wrap-Rax is the perfect choice for those times when you want to safely transport your Surfboards, Longboards, Snowboards to the beach or snow using your vehicle.</p> <p>These soft board racks wraps around the inside of your vehicle and allow you to secure your boards to the roof. The special soft padding and extremely sturdy buckles ensure that your boards will not slip or move around during transit. This system will work on most vehicles, with or without gutters.</p> <ul> <li> <p><strong>Easy Convey of Surfboards, Longboards As Well As Snowboards </strong>This Dorsal Surf and Snow Soft Rack Pads set offers an effective way to convey surf boards, longboards, as well as snowboards.</p> </li> <li> <p><strong>Reliable Material For Longer Life - </strong>This soft rack pads set is integrated with top grade EVA foam and is secured by a weather proof nylon sleeve. It comes with pads and straps that will secure almost any board. The middle positioned closure straps keep the rack pads secured while using. This is also perfect for bigger surfboard roof rack transport in a smooth aerodynamic style. This is wide enough to transport multiple surfboards with care.</p> </li> <li> <p><strong>Securing Your Surf Boards - </strong>Keep your board secure and safe for the next journey with the amazing and state of the art Dorsal Origin Car Surf and Snow Soft Rack Pads; which is made of with durable 600D polyester material. Top of the bar is padded for sleek fit. It comes with hook & look strap, 19 inches long pad as well as it fits a lot of factory auto car racks. Securely holds surfboards, strong secure system ensures easy, safe transportation of boards, even over long distances.</p> </li> <li> <p><strong>This product is not for use when you already have roof racks on your car. See our 19" or 28" roof rack pads and tie down straps if you have bars.</strong></p> </li> </ul> <p> </p>	<p>Dorsal Wrap-Rax Deluxe Soft Rack Pads - For Surfboards Kayaks or SUP</p>	N	32.95	32.95	[empty string]	26067-DEFAULT-s.jpg	6	1000	DORSAL-WRAP-RAX	368245	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dorsal/dorsal-deluxe-wraprax-surf-and-snow-soft-roof-rack-pads-straps-19-368245	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; 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	18	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]
3	Black Heather,White	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; KIDS	31.99	0	31.99	26539-DEFAULT-l.jpg	31	26539-DEFAULT-m.jpg	Boys Rotohand Lf Ls Surf Tee	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	35	25-to-50	0.00	[empty string]	Billabong Rotohand Loose Fit Boys Long Sleeve Rashguard	<p>Round-out your surf travel kit with a quick-drying, custom surf shirt for boys. Update your sun protection with a relaxed, long sleeve t-shirt fit. The UPF 50+ boys wetshirt fits like your favorite tee, but protects and dries like a rashguard.</p> <ul> <li>T-shirt fit boys rashguard / wetshirt.</li> <li>Long sleeves.</li> <li>Logo prints.</li> <li>Crew neck.</li> <li>50 + UPF sun protection.</li> <li>Loose Fit: Relaxed fit surf shirt with maximum sun protection for long beach days.</li> <li>Material: 6oz silk touch fabric.</li> </ul>	[empty string]	N	31.95	31.95	2,4,6,8,10,12,14,16	26539-DEFAULT-s.jpg	23	1000	BR61TBRO	382440	LONG SLEEVE LYCRA	KIDS	EMPTY	0	0	0	LYCRA	billabong/billabong-rotohand-loose-fit-boys-long-sleeve-rashguard-382440	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	30	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]
5	[empty string]	SEX WAX	SEX WAX	SURF SHOP	SURF SHOP	9.99	0	9.99	2777-DEFAULT-l.jpg	9	2777-DEFAULT-m.jpg	Strawberry Scented Candles	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	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]	28	5-to-10	0.00	[empty string]	Sexwax Strawberry Scented Candle	<p>Sexwax Candle fragrances are available in Coconut, Strawberry, or Grape. These candles have lead free wicks and are contained within a 4 ounce clear glass jar. Sexwax Candles will provide a long lasting flame for up to 30 hours or more.</p>	[empty string]	N	9.99	9.99	[empty string]	2777-DEFAULT-s.jpg	33	1000	CDS4	251031	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sex-wax/sexwax-strawberry-scented-candle-251031	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	11.99	0	11.99	8575-DEFAULT-l.jpg	11	8575-DEFAULT-m.jpg	All Tech Putty (1 Tube)	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[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	10-to-15	0.00	[empty string]	FCS All Tech Putty, 1 Tube	<p>FCS All Tech Putty, 1 Tube</p>	[empty string]	N	11.99	11.99	[empty string]	8575-DEFAULT-s.jpg	37	1000	78001	257945	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-all-tech-putty-1-tube-257945	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

Dorsal Dorsal Deluxe Wrap- Rax Surf And Snow Soft Roof Rack Pads Straps - 19 " $32.95 | view details

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

BILLABONG Billabong Rotohand Loose Fit Boys Long Sleeve Rashguard $31.95 | view details

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

SEX WAX Sexwax Strawberry Scented Candle $9.99 | view details

FCS Fcs All Tech Putty, 1 Tube $11.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	Naka	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25542-DEFAULT-l.jpg	19	25542-DEFAULT-m.jpg	Naka 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]	6	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Naka	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	[empty string]	N	19.99	19.99	[empty string]	25542-DEFAULT-s.jpg	4	1000	FSH-SL-NAKA	382013	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-naka-382013	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Ginger,Scout	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	84.99	0	84.99	25892-DEFAULT-l.jpg	84	25892-DEFAULT-m.jpg	Mission Pro 18l Backpack	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]	5	50-to-100	0.00	[empty string]	Dakine Mission Pro 18L Snowboard and Ski Backpack	<p>Sized for resort laps, the Mission Pro 18L stows your shovel and probe for powder days at the hill. There's room for skins and spare gloves, plus a fleece-lined pocket for goggles or sunglasses. It's hydration compatible with an insulated sleeve in the shoulder strap, and you can strap on your board or skis for boot pack missions beyond the boundary.</p> <ul> <li>Vertical snowboard carry</li> <li>Diagonal ski carry</li> <li>DK Impact Spine Protector compatible (sold separately)</li> <li>Fleece lined goggle pocket</li> <li>Snow tool/shovel pocket</li> </ul>	[empty string]	N	85	85	[empty string]	25892-DEFAULT-s.jpg	8	1000	10002063-I	373173	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-mission-pro-18l-snowboard-and-ski-backpack-373173	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Clear,Dk Team,Brew,Evil	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	11.99	0	11.99	25836-DEFAULT-l.jpg	11	25836-DEFAULT-m.jpg	Circle Mat	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]	2018	[empty string]	[empty string]	[empty string]	46	10-to-15	0.00	[empty string]	Stance Circle Mat Stomp Pad	<p>We've updated the classic Circle Mat with new designs for winter 2018. Made of durable injection-molded urethane, with and an easy peel and stick adhesive backing. At just over 4 inches, and with low-profile studs, the mat works great when you need it, and stays out of the way when you don't.</p>	[empty string]	N	12	12	[empty string]	25836-DEFAULT-s.jpg	27	1000	10001576-H	357738	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/stance-circle-mat-stomp-pad-357738	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Dorado Fish	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25546-DEFAULT-l.jpg	19	25546-DEFAULT-m.jpg	Dorado Fish 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]	6	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Dorado	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	[empty string]	N	19.99	19.99	[empty string]	25546-DEFAULT-s.jpg	45	1000	FSH-SL-DORADOFISH	382020	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-dorado-382020	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	BLUDIGCAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	29.99	0	29.99	26197-DEFAULT-l.jpg	29	26197-DEFAULT-m.jpg	Blue Digi Camo Convertible Balaclava	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Fishmasks Convertible Ballerclava Balaclava, Blue Digi Camo	<p>Fishmasks Convertible Ballerclava Balaclava, Blue Digi Camo</p>	[empty string]	N	29.99	29.99	[empty string]	26197-DEFAULT-s.jpg	78	1000	FSH-CONV-BLUEDIGICAMO	359418	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-convertible-ballerclava-balaclava-blue-digi-camo-359418	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Green	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	9.99	0	9.99	25838-DEFAULT-l.jpg	9	25838-DEFAULT-m.jpg	Fidget Tool	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FBA FILLS	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	SMU	SMU	2019	[empty string]	[empty string]	[empty string]	60	5-to-10	0.00	[empty string]	Dakine Fidget Tool	<p>The perfect pocket tool for emergency repairs and adjustments. The Fidget Tool has all the most common bits you'll need for field adjustments, including removable surfboard fins. And it has a built-in keychain ring, so you can keep it right at your side any time you leave home.</p>	[empty string]	N	10	10	[empty string]	25838-DEFAULT-s.jpg	79	1000	10001557-I	373465	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-fidget-tool-373465	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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, Naka $19.99 | view details

DAKINE Dakine Mission Pro 18l Snowboard And Ski Backpack $85.00 | view details

DAKINE Stance Circle Mat Stomp Pad $12.00 | view details

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

FISHMASKS Fishmasks Convertible Ballerclava Balaclava, Blue Digi Camo $29.99 | view details

DAKINE Dakine Fidget Tool $10.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	GRYCOP	BRIXTON	BRIXTON	ACCESSORIES	ACCESSORIES &GT; HATS	29.99	0	29.99	25527-DEFAULT-l.jpg	29	25527-DEFAULT-m.jpg	Oath Iii 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]	SMU	SP16	[empty string]	OH at 200	[empty string]	7	25-to-50	0.00	[empty string]	Brixton Oath III Snapback Hat, Grey/Copper	<p>A six-panel cut-and-sew snapback featuring an embroidered patch and a rigid structured crown.</p>	[empty string]	N	30	30	[empty string]	25527-DEFAULT-s.jpg	3	1000	116-00173	336548	EMPTY	EMPTY	EMPTY	0	0	0	HATS	brixton/brixton-oath-iii-snapback-hat-grey-copper-336548	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Dark Grey,Black	SALTY CREW	SALTY CREW	ACCESSORIES	ACCESSORIES &GT; HATS	25.99	0	25.99	26735-DEFAULT-l.jpg	25	26735-DEFAULT-m.jpg	Frenzy Retro Trucker	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]	FA19	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Salty Crew Frenzy Retro Trucker Hat	<p>Retro trucker hat. </p> <p>Structured trucker hat with woven damask patch</p> <p>47% cotton / 25% polyester / 28% nylon</p> <p>Snap back closure</p>	[empty string]	N	26	26	One Size	26735-DEFAULT-s.jpg	3	1000	35035151	383302	EMPTY	EMPTY	EMPTY	0	0	0	HATS	salty-crew/salty-crew-frenzy-retro-trucker-hat-383302	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	3	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]
4	Black,White	THRASHER	THRASHER	ACCESSORIES	ACCESSORIES	9.99	0	9.99	26443-DEFAULT-l.jpg	9	26443-DEFAULT-m.jpg	Skate And Destroy Beer Goggles Sglasses	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]	17	5-to-10	0.00	[empty string]	Thrasher Skate and Destroy Sunglasses	<p>With a nice price, durable rubberized frames, and UV400 protection, these stylish Skate And Destroy Thrasher Sunglasses may just be the perfect pair of cheap sunnies. • inexpensive + stylish • durable, rubberized frames • UV400 protection</p>	[empty string]	N	9.99	9.99	[empty string]	26443-DEFAULT-s.jpg	4	1000	3138068	289526	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	thrasher/thrasher-skate-and-destroy-sunglasses-289526	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	34.99	0	34.99	26045-DEFAULT-l.jpg	34	26045-DEFAULT-m.jpg	Futureman Blk/Blu Chr Polar	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP18	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Dot Dash Futureman Sunglasses, Black Satin/Blue Flash Polarized	<p>Dot Dash Futureman Sunglasses, Black Satin/Blue Flash Polarized</p>	[empty string]	N	35	35	[empty string]	26045-DEFAULT-s.jpg	5	1000	DSLRLFUT-BPU	371175	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-futureman-sunglasses-black-satin-blue-flash-polarized-371175	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	99.99	0	99.99	27211-DEFAULT-l.jpg	99	27211-DEFAULT-m.jpg	Knoxville 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]	4	50-to-100	0.00	[empty string]	Electric Knoxville Sunglasses, Matte Black/Grey	<p>Raised right. Born and bred with hard lines, timeless design traits and Italian quality.</p> <ul> <li>Frame: 6 base mold injected grilamid frame with a 3 barrel hinge.</li> <li>Optics: 6 base melanin infused polycarbonate lenses. 100% UV protection. Up to 98% blue light protection.</li> <li>Available in polarized polycarbonate lenses. 99.9% Premium glare reduction, relaxed/soothing eye feeling, true color perception, and scratch resistance.</li> <li>Available in anti-reflection, hydrophobic, and oleophobic performance lens coatings.</li> <li>Visual Light Transmitted (VLT): 10%. Optimal lens for daily use. Increased clarity and depth perception while providing visual comfort.</li> <li>Includes microfiber cleaning bag.</li> <li>Designed in California. Made in Italy.</li> <li>Lifetime warranty</li> <li>Measurement: 47h - 139w - 157l</li> <li>Weight: 26 grams</li> </ul>	[empty string]	N	100	100	[empty string]	27211-DEFAULT-s.jpg	7	1000	EE09001020	312469	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-knoxville-sunglasses-matte-black-grey-312469	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]