Outerwear

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	Gold	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	25813-DEFAULT-l.jpg	13	25813-DEFAULT-m.jpg	Futures 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]	68	10-to-15	0.00	[empty string]	Stance Futures Classic Crew Sock	<p>Don’t let your attire expire. Take your style out of the past and into the future with the sleek and modern design of Stance’s Future.</p> <h4>FEATURES</h4> <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 <ul> </ul> </li> </ul> <h4>PRODUCT CARE</h4> <ul> <li>Machine wash at 40°c</li> <li>Avoid bleaching or ironing</li> <li>Socks will last longer if you keep them out of the dryer</li> <li>77% combed cotton, 19% polyester, 2% nylon, 2% elastane</li> </ul>	[empty string]	N	14	14	Medium,Large	25813-DEFAULT-s.jpg	2	1000	M556D18FUT	380201	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-futures-classic-crew-sock-380201	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Pewter,Black	BILLABONG	BILLABONG	MENS	MENS &GT; BOTTOMS &GT; SHORTS	59.99	0	59.99	26542-DEFAULT-l.jpg	59	26542-DEFAULT-m.jpg	Surftrek Perf Elastic Shorts	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	29	50-to-100	0.00	[empty string]	Billabong Surftrek Perf Elastic Shorts	<p>When it comes to tackling hot and humid conditions, the Surftrek Per Elastic delivers on performance and comfort. Updated with an elastic waist for all-time comfort, the Adventure Division short is constructed from a breathable perforated 4-way stretch fabric, designed to keep your cool in humid conditions and move with you every step of the way. The performance elastic shorts feature a zippered back pocket to secure your essentials and minimal labeling.</p> <ul> <li>Mens elastic waist shorts.</li> <li>Patch pocket with flap at back left.</li> <li>Zip pocket at back right.</li> <li>Wordmark flag label on welt pocket.</li> <li>Wave mark clamp label on left hem.</li> <li>Surf Trek Internal waistband transfer.</li> <li>Short length: 18 inch outseam.</li> <li>Material: 4-way stretch perforated fabric.</li> </ul>	[empty string]	N	59.95	59.95	Small,Medium,Large,X-Large	26542-DEFAULT-s.jpg	2	1000	M219TBSP	382562	SHORTS	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-surftrek-perf-elastic-shorts-382562	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	VANS	VANS	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	3	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]
4	Antique White,CNB,Pavement	RVCA	RVCA	MENS	MENS &GT; TOPS &GT; SHIRTS	54.99	0	54.99	26704-DEFAULT-l.jpg	54	26704-DEFAULT-m.jpg	That ` Ll Do Print Ss Floral Woven	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SLIM	[empty string]	STRETCH	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	68	50-to-100	0.00	[empty string]	RVCA That'll Do Button Up Shirt	<p>THE RVCA THAT'LL DO PRINT BUTTON-UP SHIRT ADDS STRETCH AND SIGNATURE PRINTS TO YOUR SHORT SLEEVE. A COMBINATION OF CLASSIC DESIGN AND FUNCTIONAL STRETCH FABRIC, THE MENS BUTTON-DOWN SHIRT IS FINISHED WITH A RVCA WOVEN LABEL AT THE CHEST POCKET. THE SHORT SLEEVE KEEPS A CLEAN LOOK WITH BUTTON-DOWN COLLAR POINTS AND A TAILORED FIT.</p>	[empty string]	N	55	55	Small,Medium,Large,X-Large	26704-DEFAULT-s.jpg	4	1000	M508TRTP	383208	SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	rvca/rvca-thatll-do-button-up-shirt-383208	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Charcoal Heather,Green Heather,Salt & Pepper,Navy/BL,Burgundy	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; BEANIES	15.99	0	15.99	26403-DEFAULT-l.jpg	15	26403-DEFAULT-m.jpg	Solid Beanie	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	[empty string]	175	15-to-20	0.00	[empty string]	Never Summer Solid Beanie	<p>Keep your brain nice and toasty while you're reppin' your favorite snowboard brand. Featuring a Never Summer clip tag at the brim, the Never Summer Solid beanie is a modern classic that goes with everything.</p>	<p>Never Summer Shoreman 3 Cuff Beanie (Salt and Pepper)</p>	N	15.99	15.99	[empty string]	26403-DEFAULT-s.jpg	5	1000	BNSLD	345721	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-solid-beanie-345721	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Antique White	RVCA	RVCA	MENS	MENS &GT; TOPS &GT; SHIRTS	54.99	0	54.99	26718-DEFAULT-l.jpg	54	26718-DEFAULT-m.jpg	Ficus Floral Ss	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]	5	50-to-100	0.00	[empty string]	RVCA Ficus Floral Button Up Shirt	<p>MICRO FLORALS DELIVER A CUSTOM FEEL TO THE RVCA FICUS FLORAL BUTTON-UP SHIRT. PRINTED WITH AN ALLOVER DESIGN, THE BUTTON-DOWN SHIRT OFFERS A TAILORED LOOK WITH A SLIM FIT AND SMALL WOVEN LABEL AT THE CHEST POCKET. A COTTON AND VISCOSE BLEND WEAVE CREATES A LIGHTWEIGHT FEEL.</p>	[empty string]	N	55	55	Medium,Large	26718-DEFAULT-s.jpg	6	1000	M520TRBF	386173	SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	rvca/rvca-ficus-floral-button-up-shirt-386173	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Futures Classic Crew Sock $14.00 | view details

BILLABONG Billabong Surftrek Perf Elastic Shorts $59.95 | view details

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

RVCA Rvca That ' Ll Do Button Up Shirt $55.00 | view details

NEVER SUMMER Never Summer Solid Beanie $15.99 | view details

RVCA Rvca Ficus Floral Button Up Shirt $55.00 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	270	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	455	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25578-DEFAULT-l.jpg	5	25578-DEFAULT-m.jpg	Sunset Cove Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	147	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sunset Cove	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25578-DEFAULT-s.jpg	807	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]	VON ZIPPER	VON ZIPPER	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	79.99	0	79.99	5818-DEFAULT-l.jpg	79	5818-DEFAULT-m.jpg	Snark 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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	VonZipper Snark Sunglasses, Black Satin/Grey	<p><strong>Story: </strong>Some people put their heads in the sand… we prefer to stick our noses in the air! Especially when we snarkily go hunting for Snarks in Snarkville!!! Go Snark yourself!</p> <p><strong>Specs: </strong>VonZipper Snark sunglasses are handmade in Italy; the frame is crafted from nylon grilamid and held together with stainless steel optical hinges. The base 6 spherical impact resistant polycarbonate lenses will protect your eyes with 100% UV protection.</p>	[empty string]	N	80	80	[empty string]	5818-DEFAULT-s.jpg	1	1000	SMSFCSNA-BKS	240106	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	von-zipper/vonzipper-snark-sunglasses-black-satin-grey-240106	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Sunglow,Waimea,THUNDERDOT,Melbourne,NIGHTFLOWER,PUALINA	DAKINE	DAKINE	WOMENS	WOMENS &GT; ACCESSORIES &GT; BACKPACKS	29.99	0	29.99	25845-DEFAULT-l.jpg	29	25845-DEFAULT-m.jpg	Wmns Cosmo 6.5l Backpack	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]	FA18	[empty string]	[empty string]	[empty string]	46	25-to-50	0.00	[empty string]	Dakine Cosmo 6.5L Women's Backpack	<p>The Cosmo is our lowest volume daypack combining organization and function in a compact and stylish design. This sleek pack will keep you organized on the go thanks to the front pocket with dedicated storage for utensils, keys, cords and your phone. Larger standalone items have a home in the separate main compartment. The popular Cosmo is offered in a wide selection of our most popular colorways.</p>	[empty string]	N	30	30	[empty string]	25845-DEFAULT-s.jpg	1	1000	08210060-I	372499	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-cosmo-65l-womens-backpack-372499	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
6	[empty string]	VERTRA	VERTRA	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNSCREEN AND SKINCARE	22.99	0	22.99	2773-DEFAULT-l.jpg	22	2773-DEFAULT-m.jpg	Shane Dorian Face Stick Kona Gold	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]	3	20-to-25	0.00	[empty string]	Vetra Face Stick SD SPF 38, Kona Gold – Shane Dorian’s Signature Tint, .39 OZ	<p>The Kona Gold is Shane Dorian’s Signature stick and provides the ultimate Broad Spectrum protection against skin aging UVA rays and skin burning UVB rays. An infusion of beige and yellow tints were color matched to his skin tone. Shane was personally involved in every stage of the development of this product – From research and development, color selection and even the choice of a light, citrus fragrance, which reminded him of the fruit trees in his back yard in Kailua, Kona, Hawaii. Water Resistant (80 minutes). Broad Spectrum. Non-Greasy application. Designed, formulated and manufactured to the highest sunscreen and cosmetic industry standards.</p>	[empty string]	N	23	23	[empty string]	2773-DEFAULT-s.jpg	8	1000	V.PX.004.202.NS	235210	SUNSCREEN AND SKINCARE	EMPTY	EMPTY	0	0	0	EMPTY	vertra/vetra-face-stick-sd-spf-38-kona-gold-shane-dorians-signature-tint-39-oz-235210	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

VON ZIPPER Vonzipper Snark Sunglasses, Black Satin/Grey $80.00 | view details

DAKINE Dakine Cosmo 6.5l Women's Backpack $30.00 | view details

VERTRA Vetra Face Stick Sd Spf 38, Kona Gold – Shane Dorian ’ S Signature Tint,.39 Oz $23.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	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; 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	12	1000	VN00097M9X1	315153	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	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]
2	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	69.99	0	69.99	25698-DEFAULT-l.jpg	69	25698-DEFAULT-m.jpg	Sk8 Hi 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]	SPRING	[empty string]	[empty string]	[empty string]	172	50-to-100	0.00	[empty string]	Vans Sk8-Hi Pro Skate Shoe, Black/White	<p>The Sk8-Hi, Vans legendary lace-up high top inspired by the classic Old Skool, has a durable canvas and suede upper, a supportive and padded ankle, and Vans vulcanized 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	70	70	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	25698-DEFAULT-s.jpg	63	1000	VN000VHGY28	304756	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-sk8hi-pro-skate-shoe-black-white-304756	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	4943-DEFAULT-l.jpg	49	4943-DEFAULT-m.jpg	Slip- On True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	LOW	[empty string]	[empty string]	[empty string]	SKATE	FALL	[empty string]	[empty string]	[empty string]	211	25-to-50	0.00	[empty string]	Vans Slip-On Skate Shoe, True White	<p>The Classic Slip-On has a low profile, slip-on canvas upper with all-over checker print, elastic side accents, Vans flag label and Vans original Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	4943-DEFAULT-s.jpg	101	1000	VN000EYEW00	233922	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-slipon-skate-shoe-true-white-233922	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Navy	STANCE	STANCE	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	27119-DEFAULT-l.jpg	14	27119-DEFAULT-m.jpg	Boys Shark Tooth Bb Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Stance Shark Tooth Boys Boxer Brief	<p>They never stop moving and have a ferocious appetite. Sounds like someone you know? Put some excitement in his wardrobe with Boys Shark Tooth.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief</li> <li>3.5'' Inseam Length</li> <li>Feather-Seam™ Construction</li> <li>Exposed Elastic Core-flex™ Waistband</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash Cold</li> <li>Tumble Dry Low</li> </ul>	[empty string]	N	15	15	Medium,Large	27119-DEFAULT-s.jpg	107	1000	B803A19SHA	383920	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-shark-tooth-boys-boxer-brief-383920	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
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	125	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	White	BILLABONG	BILLABONG	KIDS	KIDS &GT; BOYS &GT; TOPS &GT; T-SHIRTS	17.99	0	17.99	26803-DEFAULT-l.jpg	17	26803-DEFAULT-m.jpg	Boys Rotor Ss Tee	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	8	15-to-20	0.00	[empty string]	Billabong Boys' Rotor Tee	<p>Round out your core style with this premium logo tee. A custom take on a boys short sleeve logo tee, the Rotor features seal logo prints at the chest and back, premium jersey fabric, and a printed neck label for comfort.</p>	[empty string]	N	17.95	17.95	Small,Medium,Large,X-Large	26803-DEFAULT-s.jpg	134	1000	B404TBRO	382397	TOPS	T-SHIRTS	EMPTY	0	0	0	EMPTY	billabong/billabong-boys-rotor-tee-382397	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Slip- On Pro Skate Shoe, Black/White/Gum $60.00 | view details

VANS Vans Sk8- Hi Pro Skate Shoe, Black/White $70.00 | view details

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

STANCE Stance Shark Tooth Boys Boxer Brief $15.00 | view details

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

BILLABONG Billabong Boys ' Rotor Tee $17.95 | 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	Black	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; KIDS SOCKS	13.99	0	13.99	25815-DEFAULT-l.jpg	13	25815-DEFAULT-m.jpg	Bones 2 Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	Stance Bones 2 Boys Kids Crew Sock	<p>Whether it's Halloween or 4th of July, Stance's Bones2 are a wardrobe essential. With a classic skeleton design that glows in the dark this sock is a perfect fit for your attire.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25815-DEFAULT-s.jpg	7	1000	M556D18BO2	380074	KIDS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-bones-2-boys-kids-crew-sock-380074	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Stone/Stone,Black/Black	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	119.99	0	119.99	26888-DEFAULT-l.jpg	119	26888-DEFAULT-m.jpg	Inana Mens Shoe	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	22	100-to-150	0.00	[empty string]	Olukai Inana Men's Sneakers	<p>Hawai‘i’s lifeguards often practice a less-is-more lifestyle, training all year to stay fit and healthy. With this in mind, we imagined our new ?Inana shoe to be athletic, functional and downright ruggedly handsome. The streamlined, one-piece mesh upper is paired with a ‘Wet Grip Rubber’ outsole featuring a barnacle-inspired lugged design for exceptional traction in wet and dry environments.</p> <p>FEATURES<br /> Tested and approved by the HLA, our patented Drop-In Heel design offers both a slide and shoe functionality, embroidered logos and a lace toggle for easy on/off function</p>	[empty string]	N	120	120	8,8.5,9,9.5,10.5,11,11.5,12,13,14	26888-DEFAULT-s.jpg	12	1000	10393	382199	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	olukai/olukai-inana-mens-sneakers-382199	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25808-DEFAULT-l.jpg	13	25808-DEFAULT-m.jpg	Bagheera Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	SP18	[empty string]	OH at 200	[empty string]	23	10-to-15	0.00	[empty string]	Stance Bagheera Classic Crew Sock	<p>Bagheera features luxurious combed cotton while deep heel pocket cradle your feet in comfort. Its reinforced heel and toe provide additional durability and to help your feet breathe, the sock sports mesh vents.</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	25808-DEFAULT-s.jpg	16	1000	M556A18BAG	365573	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-bagheera-classic-crew-sock-365573	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Charcoal	SANUK	SANUK	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	44.99	0	44.99	26919-DEFAULT-l.jpg	44	26919-DEFAULT-m.jpg	Yoga Mat 3 Womens Sandals	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]	[empty string]	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Sanuk Yoga Mat 3 Women's Flip Flops	<p>The world’s first women’s flip flop made outta real yoga mat is now next-level Om-azing! Starring all-new arch supports and comfy contoured footbeds, sleek and stretchy straps, and super-flexible outsoles—Yoga Mat 3 blesses your every step with that dreamy, enlightened feeling.</p>	[empty string]	N	45	45	6,7,8,9,10	26919-DEFAULT-s.jpg	23	1000	1099404	392479	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	sanuk/sanuk-yoga-mat-3-womens-flip-flops-392479	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Blue	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	11.99	0	11.99	25806-DEFAULT-l.jpg	11	25806-DEFAULT-m.jpg	Mixed 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]	3	10-to-15	0.00	[empty string]	Stance Mixed Classic Crew Sock	<p>Mix things up with Stance's Mixed, a classic powder blue sock with analogue tape design that's assured to keep your style singing.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	12	12	Medium,Large	25806-DEFAULT-s.jpg	25	1000	M556D18MID	380203	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-mixed-classic-crew-sock-380203	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	114.99	0	114.99	25704-DEFAULT-l.jpg	114	25704-DEFAULT-m.jpg	Ultrarange Hi Mte Dachshund/Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BROWN	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	16	100-to-150	0.00	[empty string]	Vans UltraRange Hi MTE Shoe, Dachshund/Black	<p>A new addition to the Vans family, the athlete-inspired UltraRange Hi MTE is a versatile shoe with additions designed for the elements. Featuring a brand new UltraCush Lite midsole compound offering the ultimate in comfort and cushioning, plus a sock-fit bootie construction with seamless internals to reduce weight, rubbing, and hotspots, the UltraRange Hi MTE provides a clean aesthetic that will get you there. It also includes leather and synthetic uppers with MTE details, warm linings, water-based inks and glues, and durable co-molded rubber reverse waffle lug outsoles to reduce glue and improve finishing.</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	115	115	8,8.5,9,9.5,10.5,11,12,13	25704-DEFAULT-s.jpg	39	1000	VN0A3ZD1FW6	379638	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-ultrarange-hi-mte-shoe-dachshund-black-379638	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Bones 2 Boys Kids Crew Sock $14.00 | view details

OLUKAI Olukai Inana Men's Sneakers $120.00 | view details

STANCE Stance Bagheera Classic Crew Sock $14.00 | view details

SANUK Sanuk Yoga Mat 3 Women's Flip Flops $45.00 | view details

STANCE Stance Mixed Classic Crew Sock $12.00 | view details

VANS Vans Ultrarange Hi Mte Shoe, Dachshund/Black $115.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]	SPITFIRE	SPITFIRE	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	39.99	0	39.99	26746-DEFAULT-l.jpg	39	26746-DEFAULT-m.jpg	F4 99 Conical Fulls Natural Whl	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Spitfire Formula Four 99D Overlay Skateboard Wheels, 54mm	<p>Spitfire Formula Four 99D Overlay Skateboard Wheels, 54mm</p>	[empty string]	N	39.99	39.99	54MM	26746-DEFAULT-s.jpg	9	1000	2111019354	391810	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-skateboard-wheels-54mm-391810	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	199.99	0	199.99	26953-DEFAULT-l.jpg	199	26953-DEFAULT-m.jpg	Timeless Palisander Groundswell Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Arbor Timeless 42 Groundswell Complete Longboard, 42"	<p><em>Premium Palisander Wood Finish Ply</em></p> <p>The classic pintail carver, designed for smooth, open-stance skating and maximum push and speed stability.</p> <h4>DECK</h4> <ul> <li>7 Ply Hardrock Maple with a Premium Palisander Wood Finish Ply</li> <li>Wood material comes from sustainable sources of supply</li> <li>Wood by-product is reclaimed for use in other products</li> </ul> <h4>TRUCKS</h4> <ul> <li>Paris Reverse 50° 180mm</li> </ul> <h4>WHEELS</h4> <ul> <li>Arbor Easyrider Series – Outlook</li> <li>Designed for carving and cruising</li> <li>Larger shape increases rolling speed</li> <li>Size: 69mm // Durometer: 78a</li> <li>Contact Patch: 44.0mm // Offset: 2.5mm</li> <li>Momentum Core: Dampens bumpy rides</li> <li>Venice Formula: Soft and grippy</li> </ul> <h4>OTHER COMPONENTS</h4> <ul> <li>ABEC 7 Bearings with Spacers</li> <li>1/8"? Paris Risers</li> <li>Recycled Glass Re-Grit</li> </ul>	[empty string]	N	199.99	199.99	42IN	26953-DEFAULT-s.jpg	9	1000	ARBL42003	393647	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	arbor/arbor-timeless-42-groundswell-complete-longboard-42-393647	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	SPITFIRE	SPITFIRE	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	39.99	0	39.99	26745-DEFAULT-l.jpg	39	26745-DEFAULT-m.jpg	F4 99 Overlay Classic Fulls Pnk/Blu Whl	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	25-to-50	0.00	[empty string]	Spitfire Formula Four 99D Overlay Pink/Blue Mashup Skateboard Wheels, 53mm	<p>Spitfire Formula Four 99D Overlay Pink/Blue Mashup Skateboard Wheels, 53mm</p>	[empty string]	N	39.99	39.99	53MM	26745-DEFAULT-s.jpg	12	1000	2111019253	391809	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-pink-blue-mashup-skateboard-wheels-53mm-391809	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	139.99	0	139.99	26410-DEFAULT-l.jpg	139	26410-DEFAULT-m.jpg	Nickel Faded Jammin Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Penny Skateboards Faded Jammin Complete Nickel Skateboard, 27"	<p>Penny's Jammin 27" is a vibrant and cheerful board that will always brighten your day! As part of the Painted Fades range, this board's deck fades between green, yellow and red. Cruise around the streets and show of your sense of fun as you make your mark to reveal the decks true yellow colour.</p> <ul> <li>27" Plastic Deck</li> <li>4-inch aluminum trucks with powder-coated finish</li> <li>59mm, 83A wheels for a smooth ride</li> <li>83A color-coded cushions</li> <li>Color-coded high tensile deck bolts</li> <li>Quality Color-coded Abec 7 stainless steel bearings</li> </ul>	[empty string]	N	139.99	139.99	27IN	26410-DEFAULT-s.jpg	42	1000	P27FDJAM-C	341709	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-faded-jammin-complete-nickel-skateboard-27-341709	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	249.99	0	249.99	26320-DEFAULT-l.jpg	249	26320-DEFAULT-m.jpg	Evo 36 Falcon 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 Evo 36 Falcon Complete Longboard, 36"	<p style="margin-left:0px; margin-right:0px; text-align:left">When most people think of Landyachtz they think of the Evo. Designed by Landyachtz co-founder and past DH World Champ Tom Edstrand. The concept from the beginning has been stability and control while at speed. The bi-products of that design are being easy to push and easy to learn on. The Evo has seen a couple minor revisions over the years, none as dramatic as this year, where we’ve shrunken the entire board by 10%, making the Evo 36. Still 9 plies of Canadian maple, the smaller shape makes the classic lighter and more nimble.</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist:</strong> Greg Nicholls</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 36” I W: 9.5” I WB: 27.75”</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> Drop Down<br /> <strong>Grip:</strong> Black Adhesive with printed graphic<br /> <strong>Features:</strong> Drop Down, 100% Canadian Maple, Deep Concave<br /> <strong>Setup:</strong> Bear Grizzly GR845, 76mm Monster Hawgs White 82a, Bear Spaceball Bearings</p>	[empty string]	N	249.99	249.99	36IN	26320-DEFAULT-s.jpg	62	1000	CP-DHEVO36	378819	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-evo-36-falcon-complete-longboard-36-378819	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	70	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

SPITFIRE Spitfire Formula Four 99d Overlay Skateboard Wheels, 54mm $39.99 | view details

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

SPITFIRE Spitfire Formula Four 99d Overlay Pink/Blue Mashup Skateboard Wheels, 53mm $39.99 | view details

PENNY Penny Skateboards Faded Jammin Complete Nickel Skateboard, 27 " $139.99 | view details

LANDYACHTZ Landyachtz Evo 36 Falcon Complete Longboard, 36 " $249.99 | view details

LANDYACHTZ Landyacthz Battle Axe 40 Chill Bird Deck, 40 " $119.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	Medieval Blue	QUIKSILVER	QUIKSILVER	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	29.99	0	29.99	26668-DEFAULT-l.jpg	29	26668-DEFAULT-m.jpg	Always There Ss Rashguard	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]	6	25-to-50	0.00	[empty string]	Quiksilver Always There Short Sleeve UPF 50 Rashguard	<ul> <li><strong>Recycled Fabric:</strong> Stretch polyester blend fabric</li> <li><strong>Fit:</strong> Snug fit</li> <li>UPF 50+ sun protection</li> <li>Chlorine-resistant properties</li> <li>Moisture-wicking properties</li> </ul> <p>Composition</p> <ul> <li> <p>92% Polyester, 8% Elastane</p> </li> </ul>	[empty string]	N	30	30	Small,Medium,Large,X-Large,XX-Large	26668-DEFAULT-s.jpg	5	1000	EQYWR03142	391054	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	quiksilver/quiksilver-always-there-short-sleeve-upf-50-rashguard-391054	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Royal,Black,Charcoal	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	34.99	0	34.99	26571-DEFAULT-l.jpg	34	26571-DEFAULT-m.jpg	All Day Wave Pf Ss	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]	OH at 200	[empty string]	58	25-to-50	0.00	[empty string]	Billabong All Day Wave Performance Fit Short Sleeve Rashguard	<p>Your answer to surfable function and sun-protection. The performance fit All Day delivers UPF 50+ sun protection with ergonomic seams and a silky smooth fabric.</p> <ul> <li>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.</li> </ul>	[empty string]	N	34.95	34.95	Small,Medium,Large,X-Large,XX-Large	26571-DEFAULT-s.jpg	11	1000	MR03TBAL	382755	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	billabong/billabong-all-day-wave-performance-fit-short-sleeve-rashguard-382755	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; DIVE &GT; FINS	66.99	0	66.99	26138-DEFAULT-l.jpg	66	26138-DEFAULT-m.jpg	Tech 2 Fin Ice Blue - Medium/Large	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]	1	50-to-100	0.00	[empty string]	Hydro Tech 2 Swim Fins - Ice Blue - Medium/Large	<ul> <li> <p>Super soft silicone for unsurpassed comfort.</p> </li> <li> <p>V Rail Design for maximum speed and traction.</p> </li> <li> <p>Ergonomic foot cavity for ultimate fit.</p> </li> <li> <p>Non-slip tread.</p> </li> <li> <p>Central vortex drainage for sand and water.</p> </li> <li> <p>Perfect for pool swimming and swim squads.</p> </li> </ul>	<p>Hydro Tech 2 Swim Fins - Ice Blue - Medium Large</p>	N	67	67	[empty string]	26138-DEFAULT-s.jpg	20	1000	7902-IBL-MLF	348430	FINS	EMPTY	EMPTY	0	0	0	EMPTY	hydro/hydro-tech-2-swim-fins-ice-blue-medium-large-348430	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; BAGS	284.99	0	284.99	26161-DEFAULT-l.jpg	284	26161-DEFAULT-m.jpg	14'sup Racing Bag	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	250-to-300	0.00	[empty string]	FCS Racing SUP Cover Bag - 14'	<p>The ultimate in mobility & protection for SUP racing board transportation.</p> <p><strong>Overview</strong></p> <p>Classic and affordable board protection for day-to-day use.</p> <p> </p> <p><strong>Features</strong></p> <ul> <li>Tapered template to accommodate the streamline shape of racing boards.<br />  </li> <li>5mm HD padding<br />  </li> <li>Side handle for easy transport<br />  </li> <li>Airflow System<br />  </li> <li>Padded shoulder strap<br />  </li> <li>Full length zipper path making it easy to insert and remove boards <br />  </li> <li>Reinforced coffin wall construction<br />  </li> <li>Heat reflective silver paneling<br />  </li> <li>8 x Compression cinches<br />  </li> <li>Reinforced nose and tail area</li> </ul>	[empty string]	N	285	285	[empty string]	26161-DEFAULT-s.jpg	24	1000	BRC-140-PB-SLV	299848	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-racing-sup-cover-bag-14-299848	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	74.99	0	74.99	26146-DEFAULT-l.jpg	74	26146-DEFAULT-m.jpg	Fcs Ii Carver Neo Glass Medium Tri - Lrg	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	50-to-100	0.00	[empty string]	FCS II Carver Neo Glass Tri-Fins - Large	<p>Powerful, drawn-out turns. Excels on open face waves.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for powerful, drawn-out turns with added hold.</li> <li>Elongated template with high degree of sweep provides exceptional hold off the bottom and when carving on the open face.</li> <li>Ideal for power surfers who like to push hard against their fins and draw out their turns.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Open face, down-the-line waves, particularly good in point and reef breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for boards with deep concaves and moderate-to-extreme rocker.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Carver: Find Power. Powerful, drawn-out turns with added hold.</li> </ul>	[empty string]	N	75	75	[empty string]	26146-DEFAULT-s.jpg	41	1000	FCAR-NG01-LG-TS-R	321359	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-carver-neo-glass-trifins-large-321359	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Coastal Blue,Navy/Blue,White,Black	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; MEN'S	39.99	0	39.99	26574-DEFAULT-l.jpg	39	26574-DEFAULT-m.jpg	All Day Wave Lf Ls	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]	STRETCH	[empty string]	[empty string]	SU19	[empty string]	OH at 200	[empty string]	83	25-to-50	0.00	[empty string]	Billabong All Day Wave Loose Fit Long Sleeve Rashguard	<p>Bring together the fit of your favorite surf tee and the silk smooth feel of quick-dry, silk touch fabric. This long sleeve rashguard delivers all day sun protection and clean, t-shirt lines for a relaxed take on the traditional rashguard.</p> <ul> <li>T-shirt fit rashguard / wetshirt.</li> <li>Long sleeves.</li> <li>Logo prints.</li> <li>Crew neck.</li> <li>50 + UPF sun protection.</li> <li>Over lock hidden seam.</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	39.95	39.95	Small,Medium,Large,X-Large,XX-Large	26574-DEFAULT-s.jpg	43	1000	MR61TBWL	382775	LONG SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	billabong/billabong-all-day-wave-loose-fit-long-sleeve-rashguard-382775	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

QUIKSILVER Quiksilver Always There Short Sleeve Upf 50 Rashguard $30.00 | view details

BILLABONG Billabong All Day Wave Performance Fit Short Sleeve Rashguard $34.95 | view details

HYDRO Hydro Tech 2 Swim Fins - Ice Blue - Medium/Large $67.00 | view details

FCS Fcs Racing Sup Cover Bag - 14 ' $285.00 | view details

FCS Fcs Ii Carver Neo Glass Tri- Fins - Large $75.00 | view details

BILLABONG Billabong All Day Wave Loose Fit Long Sleeve Rashguard $39.95 | view details

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Zion,Tory	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; GLOVES	39.99	0	39.99	25846-DEFAULT-l.jpg	39	25846-DEFAULT-m.jpg	Wmns Alero Glove	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Dakine Alero Women's Snowboard and Ski Glove	<p>Alero Glove is built to look good and fit comfortably, with plenty of warmth and waterproofing protection for a full day on the mountain. It features a water repellent nylon and poly shell and a DK Dry™ waterproof insert, with 280g high loft synthetic insulation in between. The PU palm is durable, and the faux fur cuff with antler inspired cinch give it a plush and stylish finish. An internal heat pack pocket stashes handwarmers conveniently for extra chilly riding weather.</p>	[empty string]	N	40	40	X-Small,Small,Medium,Large	25846-DEFAULT-s.jpg	4	1000	10000716-I	373609	WOMENS OUTERWEAR	GLOVES	EMPTY	0	0	0	OUTERWEAR	dakine/dakine-alero-womens-snowboard-and-ski-glove-373609	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	WHT/BLK	UNION	UNION	SNOWBOARDING	SNOWBOARDING &GT; BINDINGS	149.99	0	149.99	25569-DEFAULT-l.jpg	149	25569-DEFAULT-m.jpg	Flite Pro Ltd	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]	SMU	SMU	2018	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Union Flite Pro Snowboard Bindings 2018 - Large-White/Black	[empty string]	Union Flite Pro Snowboard Bindings 2018 - Large-White/Black	N	149.95	149.95	Small	25569-DEFAULT-s.jpg	14	1000	173710	365837	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	union/union-flite-pro-snowboard-bindings-2018-largewhite-black-365837	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	519.99	0	519.99	26357-DEFAULT-l.jpg	519	26357-DEFAULT-m.jpg	Peacemaker	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]	1	500-and-over	0.00	[empty string]	Never Summer Peacemaker Snowboard, 2019	<p>The Peacemaker ain’t some sheepherding fan boy pro-model. This true twin six-shooter was created using ride and design input from super-shred Dylan Alito. World famous tattoo artist Bryan Henry hand painted the graphic. A soft mid-section flex gets you locked in on rails and pressing a mile high. The nose and tail we made significantly stiffer for huge launches and incredibly stable landings. The extended contact points will have you hanging low and digging trenches. We added a Blower Stance for when the old dusty trail is covered in POW. The Peacemaker makes certain that you’re always bringing the right board to the shootout. #NotAProModel</p>	[empty string]	N	519.99	519.99	152	26357-DEFAULT-s.jpg	21	1000	PEACEMAKER-I	374675	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-peacemaker-snowboard-2019-374675	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	589.99	0	589.99	26338-DEFAULT-l.jpg	589	26338-DEFAULT-m.jpg	West Bound	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	23	500-and-over	0.00	[empty string]	Never Summer West Bound Snowboard, 2019	<p>If you're good with where you're at snowboarding than don't read this. It's a waste of your time. If you're always striving to be better, this is your only choice. The West Bound, the best board in town. The greatest profile in snowboarding snuck its way out of the Shaper Series and on to the best...on to the West. The West Bound features a new boss shape, a pinch of taper, and the Recluse Web Carbon Layup. A lot's changed in the West. We now float better, carve better, maneuver better, we are better. POP?!? Like an exploding hot air balloon. Like a Crater Lake size stove top popcorn. Find your home in the West. West Bound my friend. X - Wide version of the original.</p>	[empty string]	N	589.99	589.99	157,160,161X	26338-DEFAULT-s.jpg	29	1000	WBOUND-I	390845	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-west-bound-snowboard-2019-390845	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	529.99	0	529.99	26352-DEFAULT-l.jpg	529	26352-DEFAULT-m.jpg	Maverix	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	8	500-and-over	0.00	[empty string]	Never Summer Maverix Snowboard, 2019	<p>While standing on the edge of dawn, the sound of the waves growing louder, we stared out into the vastness. Anticipation ruled the moment. We were anxious as we imagined the approaching exhilaration. That’s when it hit us...Maverix! The perfect snowboard. A super nimble yet cushy ride with incredible responsiveness. Amazing performance and stylized fluidity that crushes all conditions...not just the best conditions. Leave everyone wondering where you found that surfy steez. LT - Narrower version of the original.</p>	[empty string]	N	529.99	529.99	157,160,163	26352-DEFAULT-s.jpg	37	1000	MAVERIX-I	374735	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-maverix-snowboard-2019-374735	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Carbon	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	89.99	0	89.99	25535-DEFAULT-l.jpg	89	25535-DEFAULT-m.jpg	Tour Bag	N	[empty string]	[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]	SMU	SMU	2018	[empty string]	OH at 200	[empty string]	4	50-to-100	0.00	[empty string]	Dakine Tour Snowboard Bag	<p>When weight (and cash) is your highest concern, ditch the wheels but keep the features with the Tour Snowboard Bag. Load up the main compartment with a board, pair of boots, and extra outerwear, then throw essential items like tuning kits in the exterior zippered pocket. 360-degree padding keeps hardgoods protected, while the removable padded shoulder strap and dual end handles make for easy transportation. And the Tour is impressively lightweight—less than 4 pounds. So even when toting a full kit, you won't rack up extra baggage fees. Plus, it packs down tight for easy storage when not in use.</p>	[empty string]	N	90	90	157,175	25535-DEFAULT-s.jpg	43	1000	10001467-C	357207	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-tour-snowboard-bag-357207	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

DAKINE Dakine Alero Women's Snowboard And Ski Glove $40.00 | view details

UNION Union Flite Pro Snowboard Bindings 2018 - Large- White/Black $149.95 | view details

NEVER SUMMER Never Summer Peacemaker Snowboard, 2019 $519.99 | view details

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

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

DAKINE Dakine Tour Snowboard Bag $90.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	Black	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; BOXERS/BRIEFS	29.99	0	29.99	27115-DEFAULT-l.jpg	29	27115-DEFAULT-m.jpg	Merv Bb 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]	12	25-to-50	0.00	[empty string]	Stance Merv Butter Blend Boxer Brief	<p>Meet Merv. A sophisticated boxer brief with an insatiable need to please. Your new BFF.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief with fly</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	30	30	Small,Medium,Large,X-Large	27115-DEFAULT-s.jpg	3	1000	M801A19MER	383887	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-merv-butter-blend-boxer-brief-383887	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Saddle	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WALLETS	29.99	0	29.99	25614-DEFAULT-l.jpg	29	25614-DEFAULT-m.jpg	Coastal Arc Bi- Fold Coin Wallet	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]	17	25-to-50	0.00	[empty string]	Nixon Coastal Arc Bi-Fold Coin Wallet	<p>A collection tailored to the worldly and wise, these are the essentials of those who know.</p>	[empty string]	N	30	30	[empty string]	25614-DEFAULT-s.jpg	4	1000	C2517	371743	EMPTY	EMPTY	EMPTY	0	0	0	WALLETS	nixon/nixon-coastal-arc-bifold-coin-wallet-371743	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	39.99	0	39.99	27201-DEFAULT-l.jpg	39	27201-DEFAULT-m.jpg	Portal Tort/Brz Poly 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]	[empty string]	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Dot Dash Portal Sunglasses, Tortoise Bronze/Grey Polarized	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>Polarized Lens</li> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	40	40	[empty string]	27201-DEFAULT-s.jpg	8	1000	DSLRFPOR-TPP	308341	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-portal-sunglasses-tortoise-bronze-grey-polarized-308341	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Blue,Pink,Brown,Green,Black,Yellow,Flesh,Red,Orange,ARMY,Purple,Teal	ZINKA	ZINKA	ACCESSORIES	ACCESSORIES &GT; SUNSCREEN/SKIN CARE	6.99	0	6.99	20366-DEFAULT-l.jpg	6	20366-DEFAULT-m.jpg	Nosecoat	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	3242	5-to-10	0.00	[empty string]	Zinka Zinc Oxide Sunblock	<p>With 25% Zinc Oxide, our original colored nosecoat is the best total BLOCK available. Visible on your skin, Zinka nosecoat reflects sunlight, blocks out UVA & UVB rays and is water resistant.</p>	[empty string]	N	7.49	7.49	[empty string]	20366-DEFAULT-s.jpg	9	1000	COLORED	200869	EMPTY	EMPTY	EMPTY	0	0	0	SUNSCREEN/SKIN CARE	zinka/zinka-zinc-oxide-sunblock-200869	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Resin,Washed Palm	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; HATS	21.99	0	21.99	25866-DEFAULT-l.jpg	21	25866-DEFAULT-m.jpg	Classic Diamond 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]	FA17	[empty string]	[empty string]	[empty string]	8	20-to-25	0.00	[empty string]	Dakine Classic Diamond Adjustable Trucker Hat	<p>This Dakine Classic Diamond trucker features a structured 5-panel, snapback construction with printed front panels and brim.</p>	[empty string]	N	22	22	[empty string]	25866-DEFAULT-s.jpg	10	1000	10000547-H	356537	EMPTY	EMPTY	EMPTY	0	0	0	HATS	dakine/dakine-classic-diamond-adjustable-trucker-hat-356537	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	29.99	0	29.99	27197-DEFAULT-l.jpg	29	27197-DEFAULT-m.jpg	Gooch Sin 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]	SP18	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Dot Dash Gooch Sunglasses, Metallic Navy Satin/Silver Flash	<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-8 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	30	30	[empty string]	27197-DEFAULT-s.jpg	10	1000	DSLRFGOO-SIV	371180	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-gooch-sunglasses-metallic-navy-satin-silver-flash-371180	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]