Costa Del Mar Adjustable Sunglasses Retainer, Blue

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	THRASHER	THRASHER	MENS	MENS &GT; ACCESSORIES &GT; HATS	19.99	0	19.99	26460-DEFAULT-l.jpg	19	26460-DEFAULT-m.jpg	Logo Embroidered Mesh Cap	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]	20	15-to-20	0.00	[empty string]	Thrasher Logo Embroidered Trucker Hat	<p>Adjustable, embroidered Thrasher magazine logo mesh cap. One size fits most.</p>	[empty string]	N	19.99	19.99	[empty string]	26460-DEFAULT-s.jpg	3	1000	3130004	292770	HATS	EMPTY	EMPTY	0	0	0	EMPTY	thrasher/thrasher-logo-embroidered-trucker-hat-292770	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Grey	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; HATS	27.99	0	27.99	25642-DEFAULT-l.jpg	27	25642-DEFAULT-m.jpg	Retro Mountain 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]	2019	[empty string]	[empty string]	[empty string]	25	25-to-50	0.00	[empty string]	Never Summer Retro Mountain Snapback Hat	<p>Never Summer Retro Mountain Snapback Hat</p>	[empty string]	N	28	28	One Size	25642-DEFAULT-s.jpg	3	1000	HTRETROADJ	374869	HATS	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-retro-mountain-snapback-hat-374869	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Forest Green	THRASHER	THRASHER	MENS	MENS &GT; TOPS &GT; T-SHIRTS	22.99	0	22.99	26476-DEFAULT-l.jpg	22	26476-DEFAULT-m.jpg	Davis S/S 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]	7	20-to-25	0.00	[empty string]	Thrasher Davis Short Sleeve T-Shirt	<p>Continue representing one of skateboarding's original brands with the Forest Green Davis T-Shirt from Thrasher. Rather than the usual flame job style logo of most Thrasher items, this T-Shirt sports a tribal print design throughout the lettering. This is the perfect way to represent Thrasher while continuing to stand out from the crowd.</p>	<p>Thrasher Flame Mag Short Sleeve Tee Shirt, White Xlarge</p>	N	22.99	22.99	Small,Medium,Large,X-Large	26476-DEFAULT-s.jpg	3	1000	311195	377031	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	thrasher/thrasher-davis-short-sleeve-tshirt-377031	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VERTRA	VERTRA	MENS	MENS &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	4	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]
5	Black,Black/Silver,Rose Smoke	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	26762-DEFAULT-l.jpg	13	26762-DEFAULT-m.jpg	Kurt 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]	[empty string]	[empty string]	47	10-to-15	0.00	[empty string]	Stance Kurt Classic Crew Sock	<p>Our friend Kurt couldn't decide between tye-dye and stripes, so we did him a solid. You're welcome.</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	26762-DEFAULT-s.jpg	5	1000	M556A19KUR	383790	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-kurt-classic-crew-sock-383790	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUN BUM	SUN BUM	MENS	MENS &GT; ACCESSORIES	15.99	0	15.99	25584-DEFAULT-l.jpg	15	25584-DEFAULT-m.jpg	Natural Browning Lotion	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]	120	15-to-20	0.00	[empty string]	Sun Bum Natural Browning Lotion, 8.5 oz.	<p>We protect, moisturize and tan our skin with our premium darkening lotion that we developed to accelerate the sun triggered tanning proccess in our skin. Our Natural Browning Lotion gets us that fast, deep tan, without having to spend long hours in the sun. To ensure protection, we always apply an SPF 15 or higher sunscreen 10 minutes before applying our Natural Browning Lotion. Also, heads up that our Natural Browning Lotion is brown in color and all the sweet ingredients that brown your skin can also stain your clothes so if have a wild slather hand, make sure to toss your duds in the wash asap. 250 mL / 8.5 Fl. Oz.</p>	[empty string]	N	15.99	15.99	[empty string]	25584-DEFAULT-s.jpg	7	1000	20-50100	342615	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-natural-browning-lotion-85-oz-342615	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

THRASHER Thrasher Logo Embroidered Trucker Hat $19.99 | view details

NEVER SUMMER Never Summer Retro Mountain Snapback Hat $28.00 | view details

THRASHER Thrasher Davis Short Sleeve T- Shirt $22.99 | view details

VERTRA Vetra Face Stick Sd Spf 38, Kona Gold – Shane Dorian ’ S Signature Tint,.39 Oz $23.00 | view details

STANCE Stance Kurt Classic Crew Sock $14.00 | view details

SUN BUM Sun Bum Natural Browning Lotion, 8.5 Oz. $15.99 | 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	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]	146	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	309	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	362	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	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	390	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	[empty string]	SPY	SPY	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	26012-DEFAULT-l.jpg	149	26012-DEFAULT-m.jpg	Rocky Soft Matte Blk/Happy Brz Pol Grn	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]	SP16	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Spy Rocky Sunglasses, Soft Matte Black/Happy Bronze Polar with Green Spectra	<p>Inspired by the iconic western mountain range, the Rocky takes high performance in a solid, aggressive frame to places others just can’t reach. With the detail- and mood-boosting Happy Lens™, the Rocky features a virtually indestructible Grilamid® construction, 100% UV protection, and small temple openings for a leash.</p> <ul> <li>Happy Lens™ enhances color and contrast, increases clarity, and improves mood and alertness</li> <li>Available with Trident™ polarization that eliminates reflective light</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>8x4-base polycarbonate toric lenses for optical superiority</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Small openings on each temple for easy leash attachment</li> <li>High-quality pin hinges</li> <li>Frame measures 64-15-130</li> </ul>	[empty string]	N	150	150	[empty string]	26012-DEFAULT-s.jpg	7	1000	673248973861	344510	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-rocky-sunglasses-soft-matte-black-happy-bronze-polar-with-green-spectra-344510	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
5	[empty string]	VON ZIPPER	VON ZIPPER	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	159.99	0	159.99	25980-DEFAULT-l.jpg	159	25980-DEFAULT-m.jpg	Suplex Trt/Wl Brz 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]	3	150-to-200	0.00	[empty string]	VonZipper Suplex Sunglasses, Tortoise Gloss/Wildlife Bronze Polarized	<p><strong>Story: </strong>It starts out with a warm embrace from behind, but then, the real action begins. The next thing you know you're dazed and confused wondering what just happened. Pin it to win it in the Suplex.</p> <p><strong>Specs: </strong>VonZipper Suplex polarized sunglasses are handmade in Italy; the frame is crafted from nylon grilamid for maximum flexibility and held together with corrosion free Pop N' Lock cam hinges. The base 8 spherical impact resistant polycarbonate polarized lenses will protect your eyes with 100% UV protection.</p> <p><strong>RGNS System: </strong>Here’s where the rubber hits the road. If you wanna RIP, have lots of GRIP, with NO SLIP, our RGNS system features rubber nose pads and temple tips.</p>	[empty string]	N	160	160	[empty string]	25980-DEFAULT-s.jpg	8	1000	SMPFTSUP-PTB	345444	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	von-zipper/vonzipper-suplex-sunglasses-tortoise-gloss-wildlife-bronze-polarized-345444	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White,Black	STANCE	STANCE	WOMENS	WOMENS &GT; ACCESSORIES &GT; 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	8	1000	M546D18NET	380202	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	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]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

SPY Spy Rocky Sunglasses, Soft Matte Black/Happy Bronze Polar With Green Spectra $150.00 | view details

VON ZIPPER Vonzipper Suplex Sunglasses, Tortoise Gloss/Wildlife Bronze Polarized $160.00 | view details

STANCE Stance Network Classic Crew Sock $16.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	Stellar,Sleet,Crystal Blue	QUIKSILVER	QUIKSILVER	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; SHORTS	44.99	0	44.99	27076-DEFAULT-l.jpg	44	27076-DEFAULT-m.jpg	Youth Union Heather Amphibian	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]	H17	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Quiksilver Union Heather Boy's Amphibian Boardshorts, 19"	<p>The nuts and bolts</p> <ul> <li><strong>Recycled Fabric:</strong> Repreve™ traceable, recycled 4-way stretch heather polyester made from plastic bottles</li> <li>DryFlight® water-repellent hydrophobic coating</li> <li><strong>Outseam:</strong> 19" outseam, mid length</li> <li>Classic, comfortable regular fit</li> <li><strong>Waist:</strong> Non-corrosive zip fly</li> <li>Button closure</li> <li><strong>Pockets:</strong> Side-entry pockets</li> <li>Back zip-up pocket</li> </ul> <p>Composition</p> <ul> <li> <p>90% Recycled Polyester, 10% Elastane</p> </li> </ul>	[empty string]	N	45	45	23/10S,24/8,25/10,26/12,28/14,29	27076-DEFAULT-s.jpg	12	1000	EQBWS03279	394831	EMPTY	SHORTS	EMPTY	0	0	0	EMPTY	quiksilver/quiksilver-union-heather-boys-amphibian-boardshorts-19-394831	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Seattle Blue	RVCA	RVCA	KIDS	KIDS &GT; BOYS &GT; TOPS &GT; T-SHIRTS	17.99	0	17.99	26900-DEFAULT-l.jpg	17	26900-DEFAULT-m.jpg	Boys Motorstripe 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]	7	15-to-20	0.00	[empty string]	RVCA Motorstripe Boy's T-Shirt	<p>Keep a classic moving forward with the rvca motorstripe t-shirt for boys. Made from 100% combed cotton jersey for a classic feel, the boys tee features an updated rvca motors graphic printed at the front and back and a screen printed inner neck label for a comfortable feel.</p>	[empty string]	N	18	18	Small,Medium,Large,X-Large	26900-DEFAULT-s.jpg	42	1000	B401TRMS	383253	TOPS	T-SHIRTS	EMPTY	0	0	0	EMPTY	rvca/rvca-motorstripe-boys-tshirt-383253	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	4075-DEFAULT-l.jpg	49	4075-DEFAULT-m.jpg	Authentic Black/White	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	SLIM	[empty string]	[empty string]	[empty string]	SKATE	FALL	6 - LAST FALL	[empty string]	[empty string]	107	25-to-50	0.00	[empty string]	Vans Authentic Skate Shoe, Black/White	<p>The Authentic, Vans original and now iconic style, is a simple low top, lace-up with durable canvas upper, metal eyelets, Vans flag label and Vans original Waffle Outsole.</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	4075-DEFAULT-s.jpg	46	1000	VN000EE3BLK	238833	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-authentic-skate-shoe-black-white-238833	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	25815-DEFAULT-l.jpg	13	25815-DEFAULT-m.jpg	Bones 2 Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	Stance Bones 2 Boys Kids Crew Sock	<p>Whether it's Halloween or 4th of July, Stance's Bones2 are a wardrobe essential. With a classic skeleton design that glows in the dark this sock is a perfect fit for your attire.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25815-DEFAULT-s.jpg	67	1000	M556D18BO2	380074	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-bones-2-boys-kids-crew-sock-380074	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	59.99	0	59.99	27132-DEFAULT-l.jpg	59	27132-DEFAULT-m.jpg	Slip On (Chambray) True Navy/True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	NAVY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	71	50-to-100	0.00	[empty string]	Vans Chambray Slip-On Skate Shoe, True Navy/True Navy	<p>The Chambray Classic Slip-On features sturdy low profile textile and canvas uppers, padded collars, elastic side accents, and signature rubber waffle outsoles.</p> <p>SIZE DISPLAYED IN DROP DOWN IS BOYS/MENS<br /> 3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	4.5,5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27132-DEFAULT-s.jpg	88	1000	VN0A38F7VIO	383092	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-chambray-slipon-skate-shoe-true-navy-true-navy-383092	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[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	95	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

QUIKSILVER Quiksilver Union Heather Boy's Amphibian Boardshorts, 19 " $45.00 | view details

RVCA Rvca Motorstripe Boy's T- Shirt $18.00 | view details

VANS Vans Authentic Skate Shoe, Black/White $50.00 | view details

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

VANS Vans Chambray Slip- On Skate Shoe, True Navy/True Navy $60.00 | view details

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

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Multi	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	11.99	0	11.99	25742-DEFAULT-l.jpg	11	25742-DEFAULT-m.jpg	Matal Sock	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]	41	10-to-15	0.00	[empty string]	Stance Matal Classic Crew Sock	<p>Stance Matal Classic Crew Sock</p>	[empty string]	N	12	12	Medium,Large	25742-DEFAULT-s.jpg	4	1000	M556D18MAT	380171	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-matal-classic-crew-sock-380171	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Violet,Teal,Primary Red,Neon Pink,NOT,Neon Purple,Black/Silver,MUS,Rose Smoke	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	11.99	0	11.99	25731-DEFAULT-l.jpg	11	25731-DEFAULT-m.jpg	Joven 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]	[empty string]	[empty string]	OH at 200	[empty string]	114	10-to-15	0.00	[empty string]	Stance Joven Classic Crew Sock	<p>Our Uncommon Solids are the staple to every sock drawer. Available in multiple color ways, the Joven sports sophisticated features and are more versatile than a Swiss army knife. Its luxurious combed cotton and deep heel pocket cradle your feet in comfort while its reinforced heel and toe provide additional durability. 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	12	12	Medium,Large	25731-DEFAULT-s.jpg	11	1000	M556C17JOV	356014	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-joven-classic-crew-sock-356014	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Anchors	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; KIDS SANDALS	23.99	0	23.99	26671-DEFAULT-l.jpg	23	26671-DEFAULT-m.jpg	Kids Ahi Boys Sandal	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]	[empty string]	[empty string]	[empty string]	[empty string]	35	20-to-25	0.00	[empty string]	Reef Ahi Kids Sandal	<p>Slap time to nap time. Specifically designed for the kid who goes hard and has a good time. Many whimsical style prints to choose from, the Kids Ahi sandals feature synthetic strap with soft polyester lining, durable high-density EVA outsole for the grom who doesn't stop.</p> <ul> <li>Synthetic strap</li> <li>Webbing lining</li> <li>Printed EVA footbed</li> <li>High density EVA outsole</li> </ul>	[empty string]	N	24	24	13/1,2/3,4/5,6/7	26671-DEFAULT-s.jpg	16	1000	A3VBL	382325	KIDS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-ahi-kids-sandal-382325	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	BR2,Black/Black,Brown	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	29.99	0	29.99	2997-DEFAULT-l.jpg	29	2997-DEFAULT-m.jpg	Sandy Sandal	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	TOP 25	DISCONTINUED	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	283	25-to-50	0.00	[empty string]	Reef Sandy Women's Sandal	<p>On those summer days when the blacktop is scorching, the Reef Sandy sandals will get you to your little piece of beach in style. This is a Reef Classic women's sandal featuring a full-width woven polyester strap for comfort, Reef-Flex triple density construction with anatomical arch support, and a durable, high density EVA outsole.</p>	[empty string]	N	29.99	29.99	5,6,7,9,10,11	2997-DEFAULT-s.jpg	27	1000	1541	26700	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-sandy-womens-sandal-26700	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	19.99	0	19.99	25830-DEFAULT-l.jpg	19	25830-DEFAULT-m.jpg	Chewie Pal Sw Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	RESTRICTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STAR WARS	[empty string]	H17	[empty string]	OH at 200	[empty string]	12	15-to-20	0.00	[empty string]	Stance Chewie Pal Star Wars Crew Sock	<p>It's always good to have a sidekick and throughout the galaxy, there's none better than Chewbacca. Fiercely loyal to Han Solo, Chewie served as his copilot aboard the Millennium Falcon en route to becoming a hero in the Rebel Alliance. “Chewie Pal” celebrates the famous (and our favorite) BFF from the Star Wars saga.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Cushioning</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	20	20	Large	25830-DEFAULT-s.jpg	31	1000	M545D17CHW	363465	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-chewie-pal-star-wars-crew-sock-363465	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25809-DEFAULT-l.jpg	13	25809-DEFAULT-m.jpg	Off My Wave Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	OH at 200	[empty string]	22	10-to-15	0.00	[empty string]	Stance Off My Wave Classic Crew Sock	<p>Locals only man! The Off My Wave sends a message loud and clear to those trying to snake in on your good times in the water and out.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25809-DEFAULT-s.jpg	33	1000	M556C18OMW	370516	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-off-my-wave-classic-crew-sock-370516	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

STANCE Stance Matal Classic Crew Sock $12.00 | view details

STANCE Stance Joven Classic Crew Sock $12.00 | view details

REEF Reef Ahi Kids Sandal $24.00 | view details

REEF Reef Sandy Women's Sandal $29.99 | view details

STANCE Stance Chewie Pal Star Wars Crew Sock $20.00 | view details

STANCE Stance Off My Wave Classic Crew Sock $14.00 | view details

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	129.99	0	129.99	26425-DEFAULT-l.jpg	129	26425-DEFAULT-m.jpg	Nickel Ripple Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Penny Skateboards Ripple Complete Nickel Skateboard, 27"	<p>Continuing Penny's history of partnering with like-minded artists, brands, and creators, we are excited to collaborate with Oceanside, California surfer/artist Mitchell King. Mitch's art uses a color palette heavily inspired by the natural world and incorporates repetition of shape, giving the illusion of visual movement. The 27" Ripple features Mitch's signature circular pattern with blues, tans, and burnt orange in a striking centered graphic. Blue/Raw trucks and grey wheels complete this work of art.</p> <ul> <li>27" Plastic Deck</li> <li>4-inch aluminum trucks with powder-coated finish</li> <li>59mm, 83A wheels for a smooth ride</li> <li>83A color-coded cushions</li> <li>Color-coded high tensile deck bolts</li> <li>Quality Color-coded Abec 7 stainless steel bearings</li> </ul>	[empty string]	N	129.99	129.99	27IN	26425-DEFAULT-s.jpg	7	1000	PNYCOMP27430	374204	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-ripple-complete-nickel-skateboard-27-374204	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	OJ	OJ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	36.99	0	36.99	26885-DEFAULT-l.jpg	36	26885-DEFAULT-m.jpg	Figgy Lightning Elite Mix Up 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]	6	25-to-50	0.00	[empty string]	OJ Figgy Lightning Elite Mix Up Universals Skateboard Wheels, 101a	<p>Elite WAY TOO FAST Urethane is here! Flying out the lab to the streets and beyond, Elite Urethane guarantees more speed, a longer lasting roll, and more importantly hands down epic times with your crew. If you're a skateboarder, you seek more speed. If you want more speed you're gonna f$ck with Elite. Figgy's Elite pro wheel comes on OJ's Universal shape. Universal is OJ's lightest shape and features a slimmer profile, medium riding surface, and angled edge for consistent lock on grinds. Art by Todd Bratrud.</p>	[empty string]	N	36.99	36.99	53MM	26885-DEFAULT-s.jpg	24	1000	22222449	387664	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	oj/oj-figgy-lightning-elite-mix-up-universals-skateboard-wheels-101a-387664	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	27	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]
4	[empty string]	MADNESS	MADNESS	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	56.99	0	56.99	27053-DEFAULT-l.jpg	56	27053-DEFAULT-m.jpg	Pearlson Shape Shift R7 8.38 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]	5	50-to-100	0.00	[empty string]	Madness Shape Shifter Perelson R7 Skateboard Deck, 8.375"	<p>MADNESS Shape Shifter Perelson 8.375 R7 Skateboard Deck<br /> <em>Resin-7 Canadian Maple Construction </em><br /> <em>Width: 8.375" / Length: 32.4" / Wheelbase: 15.0"</em><br /> Medium Concave / Steep Kick</p>	[empty string]	N	56.99	56.99	8.3	27053-DEFAULT-s.jpg	33	1000	10076022	392538	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	madness/madness-shape-shifter-perelson-r7-skateboard-deck-8375-392538	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; 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	57	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]
6	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	188.99	0	188.99	27050-DEFAULT-l.jpg	188	27050-DEFAULT-m.jpg	Battle Axe 38 Fox Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	Landyachtz Battle Axe 38 Fox Complete Longboard, 38"	<p>A classic pintail shape and lowered standing platform might be the best combination out there for someone looking to pick up a board for the first time and learn to ride. Get out and explore your city in style with a Battle Axe!  </p> <p>We design our trucks and wheels to fit perfectly with each individual deck. We work tirelessly to ensure these elements come together to provide the best control and performance for your board.</p> <p>No slop, all control. Don’t accept anything less than the perfect complete.</p> <ul> <li>100% Canadian Maple</li> <li>Drop Thru</li> <li>Medium Concave</li> <li>Rocker</li> </ul>	[empty string]	N	189	189	38IN	27050-DEFAULT-s.jpg	57	1000	119-FRBA38FX	386936	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-battle-axe-38-fox-complete-longboard-38-386936	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

PENNY Penny Skateboards Ripple Complete Nickel Skateboard, 27 " $129.99 | view details

OJ Oj Figgy Lightning Elite Mix Up Universals Skateboard Wheels, 101a $36.99 | view details

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

MADNESS Madness Shape Shifter Perelson R7 Skateboard Deck, 8.375 " $56.99 | view details

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

LANDYACHTZ Landyachtz Battle Axe 38 Fox Complete Longboard, 38 " $189.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	Black/Blue,Black/Green,Black/Orange	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; TRACTION	44.99	0	44.99	25871-DEFAULT-l.jpg	44	25871-DEFAULT-m.jpg	John John Florence Pro Pad	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Dakine John John Florence Pro Surf Traction Pad	<p>Dakine is honored to partner with the world's best surfer, John John Florence, to bring you this custom designed traction pad. Triple cut posi-traction was designed for John John's specific dimensions and aggressive riding style, while the five-piece traction design allows for adjustability, whether being used on an everyday thruster or step-up board. The 25mm vertical tail wedge was hand sculpted by John John himself, to provide the perfect shape for his form. The addition of perforated surface allows water to flow through the kick while eliminating drag. All John John Florence products are packaged using sustainable recycled cardboard products with zero plastic – keeping our oceans clean for tomorrow.</p>	[empty string]	N	45	45	[empty string]	25871-DEFAULT-s.jpg	1	1000	10001762	365742	TRACTION	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dakine/dakine-john-john-florence-pro-surf-traction-pad-365742	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	114.99	0	114.99	26284-DEFAULT-l.jpg	114	26284-DEFAULT-m.jpg	John John 2 Large Techflex Thruster	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Futures John John Techflex Thruster Fins, Large	<p>The John John (L) Techflex signature fin is a large sized Speed Control fin with a Ride Number of 4.0. It's the scaled up version of JJF's medium size weapon of choice. The Techflex construction and flat foil give this fin a stable feel, making it ideal for controlling speed in more powerful waves.</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>16.05</td> <td>16.05</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.71</td> <td>4.71</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.61</td> <td>4.61</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	115	115	[empty string]	26284-DEFAULT-s.jpg	7	1000	5557-485-00	369655	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-john-john-techflex-thruster-fins-large-369655	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; BODYBOARDING	29.99	0	29.99	20306-DEFAULT-l.jpg	29	20306-DEFAULT-m.jpg	Body Surfer Handboard	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	8	25-to-50	0.00	[empty string]	Hydro Body Surfer Handboard	<p>Heavy duty design & wrist strap.</p>	[empty string]	N	29.99	29.99	One Size	20306-DEFAULT-s.jpg	11	1000	79002	280712	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hydro/hydro-body-surfer-handboard-280712	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; SURF ACCESSORIES &GT; TRACTION	41.99	0	41.99	26149-DEFAULT-l.jpg	41	26149-DEFAULT-m.jpg	Kolohe Fade Traction Pad	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	FCS Kolohe Andino Traction Pad - Fade	<p>Kolohe Andino's signature 3 piece pad.</p> <p><strong>Overview</strong></p> <p>Designed and tested in collaboration with the world’s best surfers, the FCS Athlete Series Traction range has rider specific features for the ultimate in performance. </p> <p><strong>Features</strong></p> <ul> <li>3 piece pad</li> <li>Double Diamond Groove</li> <li>High tail kick</li> <li>Sanded surfaces for enhanced grip</li> <li>Ultra-thin sensitivity</li> <li>Perforated for extra resistance</li> <li>?Lock-in directional grooves</li> </ul>	[empty string]	N	42	42	[empty string]	26149-DEFAULT-s.jpg	16	1000	27730	370000	TRACTION	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-kolohe-andino-traction-pad-fade-370000	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	109.99	0	109.99	6171-DEFAULT-l.jpg	109	6171-DEFAULT-m.jpg	V- 2 Quad Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	X	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	FCS V2 Quad Fins - Medium	<p>Designed for fast, critical surfing. Suits hollow steep waves, and punchy beach breaks.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for fast, critical surfing.</li> <li>The upright, pivotal side fin template produces quick start-up acceleration and allows for tight turns in the pocket.</li> <li>Based on the FCS K2.1 template.</li> <li>Quad (4 fin) set.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li> <p>Hollow steep waves, punchy beach breaks.</p> </li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>All board types.</li> <li>Will fit the FCS II Fin System when used with grub screws and the FCS Infill Kit.</li> </ul>	<p>FCS V2 Quad Set Surboard Fins</p>	N	110	110	[empty string]	6171-DEFAULT-s.jpg	19	1000	1120-156-23-R	257918	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-v2-quad-fins-medium-257918	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	27102-DEFAULT-l.jpg	29	27102-DEFAULT-m.jpg	Valen Off Wht Towel	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Slowtide Valen Off White Beach Towel	<p>Watching that Southern California sun go down from our beach blanket, we’ve got Buddy Holly & Ritchie Valens' tunes playing on the mental radio. An update to a favorite Slowtide towel. </p> <p>Slowtide partners with artists, photographers, designers, and brands to create unique prints for the towels, all while maintaining premium quality. Equipped with a hanging loop feature and made from 100% sustainably sourced cotton, you are guaranteed the best drying experience.</p> <p><strong>Features</strong></p> <ul> <li>For all bodies of water</li> <li>100% super soft & absorbent cotton velour</li> <li>One-sided print</li> <li>60 inches x 30 inches (Single-Sized)</li> <li>460 grams (Lightweight)</li> <li>Hanging loop</li> <li>Imported</li> </ul>	[empty string]	N	29.95	29.95	[empty string]	27102-DEFAULT-s.jpg	23	1000	ST189	386670	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-valen-off-white-beach-towel-386670	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 John John Florence Pro Surf Traction Pad $45.00 | view details

FUTURE FINS Futures John John Techflex Thruster Fins, Large $115.00 | view details

HYDRO Hydro Body Surfer Handboard $29.99 | view details

FCS Fcs Kolohe Andino Traction Pad - Fade $42.00 | view details

FCS Fcs V2 Quad Fins - Medium $110.00 | view details

SLOWTIDE Slowtide Valen Off White Beach Towel $29.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	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	569.99	0	569.99	26341-DEFAULT-l.jpg	569	26341-DEFAULT-m.jpg	West	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	13	500-and-over	0.00	[empty string]	Never Summer West Snowboard, 2019	<p>The West is a different kind of animal. This dynamic snowboard has become one of our most popular models. Our aggressive enhanced Ripsaw Rocker Camber Profile, NS SuperLight Wood Core, and mid flex, makes the West extremely powerful yet agile. Directional performance balanced for freestyle mobility, the West is equally at home ripping quick turns, slashing pow or catching air. Versatility as expansive as the land itself. X - Wide version of the original.</p>	[empty string]	N	569.99	569.99	154,156,159,162	26341-DEFAULT-s.jpg	4	1000	WEST-I	374747	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-west-snowboard-2019-374747	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	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	14	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]
3	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	1039.99	0	1039.99	26376-DEFAULT-l.jpg	1039	26376-DEFAULT-m.jpg	Swift Split W/O Kit	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]	2	500-and-over	0.00	[empty string]	Never Summer Swift Split Snowboard w/o Kit, 2019	<p>Now you can have the tightest tree surfing, chunder busting, face shot getting, ass kicking board with the ability to pioneer and access backcountry zones you’ve only dreamed of. Featuring our Fusion Rocker Camber Profile with early rise nose and tapered swallow tail keeps you on top of the deepest fluff or the heaviest spring dumps. Combine this with the stability of massive Carbon X in the mid-section and Vario Power Grip Sidecut, the Swift Split will mow through anything in its path.</p>	[empty string]	N	1039.99	1039.99	162,167	26376-DEFAULT-s.jpg	39	1000	SWIFTSPLIT-I	374763	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-swift-split-snowboard-w-o-kit-2019-374763	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Amethyst	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR	29.99	0	29.99	25881-DEFAULT-l.jpg	29	25881-DEFAULT-m.jpg	Wmns Tiffany Pom Beanie	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Dakine Tiffany Women's Beanie	<p>The light wanes, the temperature drops, but you'll stay cozy in this knit beanie. A wool-blend knit with a full fleece lining warms your dome with pom style.</p>	[empty string]	N	30	30	[empty string]	25881-DEFAULT-s.jpg	64	1000	10002121-I	373183	WOMENS OUTERWEAR	EMPTY	EMPTY	0	0	0	OUTERWEAR	dakine/dakine-tiffany-womens-beanie-373183	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	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	72	1000	BCGC	252213	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	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]
6	WATERCAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26195-DEFAULT-l.jpg	19	26195-DEFAULT-m.jpg	Water Camo Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	20	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Water Camo	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	<p>Fishmasks Single Layer Neck Gaiter - Lightweight, Fishing Protection From Sun, Wind And Moisture - Made In USA - UPF 50+ Moisture-Wicking Fabric - Water Camo</p>	N	19.99	19.99	[empty string]	26195-DEFAULT-s.jpg	92	1000	FSH-SL-WATERCAMO	359383	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-water-camo-359383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

DAKINE Dakine Tour Snowboard Bag $90.00 | view details

NEVER SUMMER Never Summer Swift Split Snowboard W/O Kit, 2019 $1,039.99 | view details

DAKINE Dakine Tiffany Women's Beanie $30.00 | view details

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

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

Accessories

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Black,Red,White	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25725-DEFAULT-l.jpg	13	25725-DEFAULT-m.jpg	Repeat Sock	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]	53	10-to-15	0.00	[empty string]	Stance Repeat Classic Crew Sock	<p>Not to boast, but we think we're great. Rep Stance in style with Repeat, repeat, repeat. Is there an echo in here?</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	14	14	Medium,Large	25725-DEFAULT-s.jpg	2	1000	M546D18REP	380169	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-repeat-classic-crew-sock-380169	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MONBLU/MONBLU	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	37.99	0	37.99	26525-DEFAULT-l.jpg	37	26525-DEFAULT-m.jpg	The Norrland Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	17	25-to-50	0.00	[empty string]	Arcade Norrland Belt, Moon Blue/Moon Blue	<p>The Arcade Norrland is a woven belt built to work hard, fit perfectly and always be comfortable. We wrapped elastic fibers with waxed cotton to give you a strong and secure fit with enough flexibility and performance to keep you operating at the highest level during the daily hustle. The Norrland’s braiding allows for a perfect fit with no awkwardly spaced holes. Top this off with a custom buckle and weatherproof trims you have a belt that is ready to take you from the office to the outdoors.</p> <ul> <li>Available in M, L, XL</li> <li>Waxed Canvas & Elastic Webbing</li> <li>Custom metal alloy buckle</li> <li>Micro-adjustable</li> <li>Belt Width – 1.375″ (3.49cm)</li> </ul>	[empty string]	N	38	38	Medium,Large,X-Large	26525-DEFAULT-s.jpg	2	1000	W44000-420	384170	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-norrland-belt-moon-blue-moon-blue-384170	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ZINKA	ZINKA	ACCESSORIES	ACCESSORIES &GT; SUNSCREEN/SKIN CARE	2.99	0	2.99	2772-DEFAULT-l.jpg	2	2772-DEFAULT-m.jpg	Lip Balm Spf 30	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]	[empty string]	[empty string]	13	5-and-under	0.00	[empty string]	Zinka SPF 30 Lip Balm, Clear	<p>Smooth and moisturizing our formula is enhanced with Aloe Vera and keeps your lips soft and safe from the sun.</p> <h3>Ingredients</h3> <p><strong>Active Ingredients</strong></p> <p>Octinoxate (7.50%)<br /> Octocrylene (10.0%)<br /> Octisalate (5.0%)<br /> Oxbenzone (5.0%)</p> <p><strong>Other Ingredients</strong><strong>:</strong></p> <p>Ozokerite, Mineral Oil, Petrolatum, Microcrystalline Wax,  Ceresin, Flavor, Caprylic/Capric Triglyceride, Copernicia Cerifera (Carnauba) Wax, Titanium Dioxide (CI77891), Tocopheryl Acetate, Stearic Acid, Aloe Barbadensis Leaf Extract, Aluminum Hydroxide</p>	[empty string]	N	2.99	2.99	[empty string]	2772-DEFAULT-s.jpg	3	1000	BALM	200870	EMPTY	EMPTY	EMPTY	0	0	0	SUNSCREEN/SKIN CARE	zinka/zinka-spf-30-lip-balm-clear-200870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPY	SPY	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	99.99	0	99.99	26015-DEFAULT-l.jpg	99	26015-DEFAULT-m.jpg	Frazier Matte Blk/Happy Gry Grn	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Spy Frazier Sunglasses, Matte Black/Happy Gray Green	<p>A one-two punch of tech and style, the Frazier is the undisputed champion of the outdoors. Plus, with its virtually indestructible Grilamid® construction, the Frazier can take it as hard as it gives it. Features include the detail- and mood-boosting Happy Lens™, Hytrel™ rubber nose and temple pads, and 100% UV protection.</p> <ul> <li>Happy Lens™ enhances color and contrast, increases clarity, and improves mood and alertness</li> <li>Available with Trident™ polarization that eliminates reflective light</li> <li>Hytrel™ rubber nose pads and temple tips for a secure fit in the wettest conditions</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>8x4-base toric lenses for superior optical performance</li> <li>High-quality, long-lasting pin hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 59-16-127</li> </ul>	[empty string]	N	100	100	[empty string]	26015-DEFAULT-s.jpg	3	1000	673176374863	308228	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	spy/spy-frazier-sunglasses-matte-black-happy-gray-green-308228	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	SUN BUM	SUN BUM	ACCESSORIES	ACCESSORIES	15.99	0	15.99	13951-DEFAULT-l.jpg	15	13951-DEFAULT-m.jpg	Spf 15 Spray Sunscreen	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	0	15-to-20	0.00	[empty string]	Sun Bum SPF 15 Spray Sunscreen, 6 oz.	<p><strong>Description</strong><br /> This easy to use, ultra sheer/dry touch continuous spray formula will protect your skin from harmful UVA/UVB rays while enriching your skin with Vitamin E, an antioxidant that helps to neutralize free radicals, which are the main cause of premature skin aging.</p> <p><strong>Features</strong><br /> UVA/UVB Broad Spectrum Protection<br /> Water Resistant / 80 Minutes<br /> Made in USA</p> <p><strong>Friendly</strong><br /> Gluten Free / Paraben Free / Oil Free / PABA Free<br /> Reinyl Palmitate Free / Propylene Glycol Free<br /> Cruelty Free / Hypoallergenic</p> <p><strong>Ingredients</strong><br /> Avobenzone 3.00%, Homosalate 15.00%, Octisalate 5.00%, Octocrylene 2.75%, Oxybenzone 6.00%, Acrylates/Dimethicone Copolymer, Acrylates/Octylacrylamide Copolymer, Alcohol Denat, Ascorbyl Palmitate, Cyclopentasiloxane, Dimethicone, Fragrance, Polyester-8, PPG-5-Ceteth-20, Tocopheryl Acetate, Trisiloxane</p>	[empty string]	N	15.99	15.99	[empty string]	13951-DEFAULT-s.jpg	4	1000	20-42015	271636	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-15-spray-sunscreen-6-oz-271636	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	44.99	0	44.99	27202-DEFAULT-l.jpg	44	27202-DEFAULT-m.jpg	Turbo Blk Satin/Gold 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]	7	25-to-50	0.00	[empty string]	Dot Dash Turbo Sunglasses, Black Satin/Light Gold 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>Base-6 Polycarbonate Lens</li> <li>Polycarbonate Frame</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	45	45	[empty string]	27202-DEFAULT-s.jpg	4	1000	DSLRFTUR-BDP	381102	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-turbo-sunglasses-black-satin-light-gold-polarized-381102	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]