Dot Dash Sparklepower Sunglasses, Silver Gloss/Grey Chrome

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

All Shoes Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Charcoal,Grey,Brown,Blackout	SANUK	SANUK	MENS	MENS &GT; SANDALS	54.99	0	54.99	2612-DEFAULT-l.jpg	54	2612-DEFAULT-m.jpg	Vagabond Slipper	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]	ACTIVE	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	84	50-to-100	0.00	[empty string]	Sanuk Vagabond Men's Sidewalk Surfers	<p>Find a smile in the sidewalk surfer that started it all!</p>	[empty string]	N	55	55	7,8,9,10,11,12,13,14	2612-DEFAULT-s.jpg	1	1000	SMF1001	202016	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	sanuk/sanuk-vagabond-mens-sidewalk-surfers-202016	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	DOT DASH	DOT DASH	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	31.99	0	31.99	27192-DEFAULT-l.jpg	31	27192-DEFAULT-m.jpg	Fractal Bcm	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]	8	25-to-50	0.00	[empty string]	Dot Dash Fractal Sunglasses, Black/Chrome	<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 Plastic Sport Hinge</li> <li>Rubber Nose Pads</li> </ul> </form>	[empty string]	N	32	32	[empty string]	27192-DEFAULT-s.jpg	1	1000	DSLRFFRA-BCM	288562	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-fractal-sunglasses-black-chrome-288562	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DVS	DVS	MENS	MENS &GT; SHOES &GT; SKATE SHOES	69.99	0	69.99	27035-DEFAULT-l.jpg	69	27035-DEFAULT-m.jpg	Comanche White/Charcoal Nubuck	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	51	50-to-100	0.00	[empty string]	DVS Comanche Skate Shoe, White/Charcoal	<p>The Comanche from DVS is a heritage skate shoe that offers unmatched comfort and durability.  This men’s skate shoe features a durable rubber cupsole construction with reinforced ollie area, leather upper, heavy-duty collar and tongue padding for extra protection, as well as a high impact EVA midsole.  You need to lace up a pair of the Comanche to truly feel the comfort and support of this timeless skate shoe. </p> <ul> <li>Leather & nubuck upper materials</li> <li>Molded TPR heel cap with core logo</li> <li>High impact insole & midsole unit</li> <li>Durable cupsole construction</li> <li>Reinforced ollie area for durability</li> <li>High density collar & tongue padding for support</li> <li>Open-cell breathable mesh tongue</li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	27035-DEFAULT-s.jpg	1	1000	DVF0000029114	383541	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-comanche-skate-shoe-white-charcoal-383541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black,Sage,MAUVE	COAL	COAL	MENS	MENS &GT; ACCESSORIES &GT; HATS	25.99	0	25.99	26824-DEFAULT-l.jpg	25	26824-DEFAULT-m.jpg	The Bff Adjustable Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	24	25-to-50	0.00	[empty string]	Coal The B.F.F. Strapback Hat	<p>Take a cool stroll through the verdant spring woods with a field guide in hand and The B.F.F. cap featuring your favorite furry (or feathery) friend snug atop your head. Super soft, brushed twill stays comfortable even as the miles fly by, and the low-profile fit has the all the style to stay on-point when you're back in your hood. Sold individually by color.</p>	[empty string]	N	26	26	One Size	26824-DEFAULT-s.jpg	1	1000	24970X	384340	HATS	EMPTY	EMPTY	0	0	0	EMPTY	coal/coal-the-bff-strapback-hat-384340	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Grey,Navy	THRASHER	THRASHER	MENS	MENS &GT; TOPS &GT; HOODIES AND SWEATSHIRTS	60.99	0	60.99	26442-DEFAULT-l.jpg	60	26442-DEFAULT-m.jpg	Flame P/O	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]	40	50-to-100	0.00	[empty string]	Thrasher Flame Logo Pullover Hoodie	<p>Heavyweight, 90% cotton 10% polyester hooded sweatshirt. Features the classic Thrasher flame logo.</p>	[empty string]	N	60.99	60.99	Small,Medium,Large,X-Large	26442-DEFAULT-s.jpg	2	1000	312007	324920	HOODIES AND SWEATSHIRTS	EMPTY	EMPTY	0	0	0	TOPS	thrasher/thrasher-flame-logo-pullover-hoodie-324920	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Dark Royal,LGR,POW,Stone,Black,Blue,Charcoal	BILLABONG	BILLABONG	MENS	MENS &GT; TOPS &GT; SHIRTS	49.99	0	49.99	26556-DEFAULT-l.jpg	49	26556-DEFAULT-m.jpg	All Day Ss Solid Woven	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]	SP19	[empty string]	[empty string]	[empty string]	157	25-to-50	0.00	[empty string]	Billabong All Day Short Sleeve Shirt	<p>A staple, designed to follow your every move. An essential short sleeve button down shirt, the All Day is infused with a mechanical stretch weave, letting you look sharp while feeling relaxed. The men’s button down finds a fresh feel with a textured weave and Billabong flag label at the left chest.</p> <ul> <li>Men’s short sleeve shirt.</li> <li>Mechanical stretch fabric.</li> <li>Textured fabric.</li> <li>Short sleeves.</li> <li>Woven flag label at chest pocket seam.</li> <li>Woven neck label.</li> <li>Button down collar.</li> <li>Material: Charcoal & Light Grey is end on end texture, Maroon is slub oxford, Blue is oxford.</li> </ul>	[empty string]	N	49.95	49.95	Small,Medium,Large,X-Large,XX-Large	26556-DEFAULT-s.jpg	2	1000	M500TBAL	382648	SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-all-day-short-sleeve-shirt-382648	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SANUK Sanuk Vagabond Men's Sidewalk Surfers $55.00 | view details

DOT DASH Dot Dash Fractal Sunglasses, Black/Chrome $32.00 | view details

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

COAL Coal The B.F.F.Strapback Hat $26.00 | view details

THRASHER Thrasher Flame Logo Pullover Hoodie $60.99 | view details

BILLABONG Billabong All Day Short Sleeve Shirt $49.95 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

All Shoes Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	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	85	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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	733	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
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	794	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]	DOT DASH	DOT DASH	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	39.99	0	39.99	27187-DEFAULT-l.jpg	39	27187-DEFAULT-m.jpg	Aperture Tort Bronze 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]	14	25-to-50	0.00	[empty string]	Dot Dash Aperture Sunglasses Tortoise Gloss/Grey Polarized	<p>Locker Room Collection ~ Be on the ball and drop back and punt.</p>	<p>Dot Dash Adult Aperture Sunglasses Gold/Gray Green Polarized Lens</p>	N	40	40	[empty string]	27187-DEFAULT-s.jpg	1	1000	DSLRFAPE-TPP	315172	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-aperture-sunglasses-tortoise-gloss-grey-polarized-315172	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	G-SHOCK	G-SHOCK	WOMENS	WOMENS &GT; ACCESSORIES &GT; WATCHES	99.99	0	99.99	26296-DEFAULT-l.jpg	99	26296-DEFAULT-m.jpg	Dw- 5600 Blue/Pink	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]	G-Shock Digital Watch, Blue/Pink	<p>2018 will mark the 35th year since G-SHOCK first started revolutionizing personal timekeeping back in 1983. These new models are inspired by the '80s street culture that was in vogue at the time the first G-SHOCK hit the scene. The base model is the DW-5600, incorporating the deep coloring and functions that has made the DW-5000 series a favorite the world over. Bold colors that were in style during the '80s create a look that is cool and reserved. Large blocks of different colors are combined for styles that always look great. The SHOCK REGIST logo is featured on the backlight pattern.</p> <ul style="list-style-type:disc; margin-left:24.3375px"> <li>Case / bezel material: Resin</li> <li>Resin Band</li> <li>Shock Resistant</li> <li>Mineral Glass</li> <li>200-meter water resistance</li> </ul>	[empty string]	N	100	100	[empty string]	26296-DEFAULT-s.jpg	5	1000	DW5600TB-4B	379770	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	g-shock/gshock-digital-watch-blue-pink-379770	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Black,Charcoal Heather,Green Heather,Salt & Pepper,Navy/BL,Burgundy	NEVER SUMMER	NEVER SUMMER	WOMENS	WOMENS &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]	176	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	6	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]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

DOT DASH Dot Dash Aperture Sunglasses Tortoise Gloss/Grey Polarized $40.00 | view details

G-SHOCK G- Shock Digital Watch, Blue/Pink $100.00 | view details

NEVER SUMMER Never Summer Solid Beanie $15.99 | 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	Assorted	ETHIKA	ETHIKA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	26845-DEFAULT-l.jpg	14	26845-DEFAULT-m.jpg	Boys Walter Allen 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]	2	10-to-15	0.00	[empty string]	Ethika Ryan Sheckler Walter Allen Boy's Boxer Brief	<ul> <li>The Original - Unmatched Staple Fit</li> <li>No Pull-Down, No Gathering</li> <li>Soft 4-Way Stretch Fabric</li> <li>High-Quality Jacquard Waistband</li> <li>90% Polyester 10% Spandex</li> </ul>	[empty string]	N	15	15	Small	26845-DEFAULT-s.jpg	49	1000	UBS1446	384627	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	ethika/ethika-ryan-sheckler-walter-allen-boys-boxer-brief-384627	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25947-DEFAULT-l.jpg	8	25947-DEFAULT-m.jpg	C- Line Silver Retainer	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	5-to-10	0.00	[empty string]	Costa Del Mar C-Line Sunglasses Retainer, Silver	<p>Costa C-Line™ Retainer. Ultra-thin sunglass retainer. Lightweight. <strong>End-to-End Measurement: </strong>20"</p>	[empty string]	N	8.99	8.99	[empty string]	25947-DEFAULT-s.jpg	62	1000	CE18	364616	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-cline-sunglasses-retainer-silver-364616	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	72	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]
4	Red	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	25807-DEFAULT-l.jpg	13	25807-DEFAULT-m.jpg	Boy's Amazing Spiderman Sock	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	RESTRICTED	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	18	10-to-15	0.00	[empty string]	Stance Amazing Spiderman Kids Marvel Comics Crew Sock	<p>Everyone's favorite arachnid, our Amazing Spiderman socks are guaranteed to get your spidey sense tingling. Officially licensed by Marvel and personally-approved by your friendly neighborhood webslinger.</p> <p>FEATURES</p> <ul> <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	Small,Medium,Large	25807-DEFAULT-s.jpg	74	1000	B515D18AMA	380147	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-amazing-spiderman-kids-marvel-comics-crew-sock-380147	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Anchors	REEF	REEF	KIDS	KIDS &GT; GIRLS &GT; 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]	36	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	89	1000	A3VBL	382325	SANDALS	EMPTY	EMPTY	0	0	0	GIRLS	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]
6	Multi	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26808-DEFAULT-l.jpg	59	26808-DEFAULT-m.jpg	Sun Dream Hi Nck Set	N	GIRLS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Billabong Girls' Sun Dream Tali Bikini Set	<p>Pick a bikini in full bloom or mix and clash with this reversible bikini set. The girls bikini features a top that reverses from striped to floral print, and a matching floral print bikini bottom. Both top and bottom are rimmed with strappy details for a modern look.</p>	[empty string]	N	59.95	59.95	4,7,8,10,14	26808-DEFAULT-s.jpg	104	1000	Y214TBSU	387573	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-girls-sun-dream-tali-bikini-set-387573	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

ETHIKA Ethika Ryan Sheckler Walter Allen Boy's Boxer Brief $15.00 | view details

COSTA DEL MAR Costa Del Mar C- Line Sunglasses Retainer, Silver $8.99 | view details

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

STANCE Stance Amazing Spiderman Kids Marvel Comics Crew Sock $14.00 | view details

REEF Reef Ahi Kids Sandal $24.00 | view details

BILLABONG Billabong Girls ' Sun Dream Tali Bikini Set $59.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	[empty string]	DC	DC	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	26608-DEFAULT-l.jpg	69	26608-DEFAULT-m.jpg	Court Graffik Sq Pewter	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]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	DC Court Graffik Skate Shoes, Pewter	<p>The nuts and bolts</p> <ul> <li>Leather, nubuck, suede upper with split quarter panel</li> <li>Foam padded collar and tongue for comfort and support</li> <li>Cupsole construction</li> <li>Ventilation holes for breathability</li> <li>Lightweight mesh tongue</li> <li>DC's trademarked Pill Pattern tread <p> </p> </li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	26608-DEFAULT-s.jpg	2	1000	ADYS100442-PEW	382989	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-court-graffik-skate-shoes-pewter-382989	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Tan,Sierra,Dark Brown,Premier Black,eXpresso,Classic Tan Brown,Classic Black,Classic Tan/Blue	RAINBOW	RAINBOW	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	53.99	0	53.99	991-DEFAULT-l.jpg	53	991-DEFAULT-m.jpg	Single Layer Leather Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	Z	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	266	50-to-100	5.00	[empty string]	Rainbow Single Layer Men's Leather Sandal	<p>The most famous Rainbow Sandal all dressed up! We kept our traditional single layer leather sandal but used our new classic finished leather and made it fancy!<br /> <br /> • Single Layer Arch<br /> • Classic Finished Leather<br /> • Embossed Rainbow Logo<br /> • Double Stitched<br /> • Nylon Toe Piece<br /> • Box X Toe Construction<br /> • Bonded Nylon Thread<br /> • Triple Glued<br /> • Non Slip Rainbow Bottom<br /> • Original Rainbow Woven Label<br /> <br /> The single layer classic leather sandal is made of top grade leather that has a polished top sole giving it a fresh clean look. It is also embossed with the Rainbow logo. The strap, also classic leather; is double stitched, and the nylon toe piece is secured with a box X stitch, all using bonded nylon thread.<br /> <br /> The single layer midsole and arch support is triple glued for maximum durability to our non-slip Rainbow bottom. We finish it off with the Original Rainbow woven label on the right strap, the mark of a genuine Rainbow Sandal.</p>	[empty string]	N	53.99	53.99	Small,Medium,Large,X-Large,XX-Large,XXXL	991-DEFAULT-s.jpg	3	1000	301ALTS	27328	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	rainbow/rainbow-single-layer-mens-leather-sandal-27328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ADIDAS	ADIDAS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	26949-DEFAULT-l.jpg	69	26949-DEFAULT-m.jpg	Adi Ease Premiere Ash Green/White/Gum	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]	BRIGHT	[empty string]	SUMMER	[empty string]	[empty string]	[empty string]	47	50-to-100	0.00	[empty string]	Adidas Adiease Skate Shoes, Ash Green/White/Gum	<p>On foot or on your board, these shoes combine iconic adidas heritage with tried-and-true skate performance. This version of the all-purpose skate shoes are made of lightweight canvas with clean stitch lines and 3-Stripes accents. The vulcanized outsole is a skater's choice for flexibility and board feel.</p>	[empty string]	N	70	70	6,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26949-DEFAULT-s.jpg	4	1000	DB3097	384808	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	adidas/adidas-adiease-skate-shoes-ash-green-white-gum-384808	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Charcoal,Black,VKHK	SANUK	SANUK	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	64.99	0	64.99	26916-DEFAULT-l.jpg	64	26916-DEFAULT-m.jpg	Vagabond Tripper Mesh Mens Shoe	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]	19	50-to-100	0.00	[empty string]	Sanuk Vagabond Tripper Mesh Men's Sidewalk Surfers	<p>The al fresco exploring never stops in Vagabond Tripper Mesh. With warm winds and sunsets as your spirit guides, this puppy was built for breathing in the outdoors. Super cush rebounding footbeds inside a durable, sneaker-like rubber outsole with siping-inspired tread pattern for max grippage.</p>	[empty string]	N	65	65	9,10,11,12,13	26916-DEFAULT-s.jpg	5	1000	1091409	392476	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	sanuk/sanuk-vagabond-tripper-mesh-mens-sidewalk-surfers-392476	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Neon Pink,Teal,Violet	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	9.99	0	9.99	25733-DEFAULT-l.jpg	9	25733-DEFAULT-m.jpg	Icon 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]	[empty string]	[empty string]	21	5-to-10	0.00	[empty string]	Stance Icon Classic Crew Sock	<p>The Icon Classic Crew maintains Stance's top-shelf comfort in a classic, plain look for those days you feel like going a little more low-key.</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	10	10	Medium,Large	25733-DEFAULT-s.jpg	6	1000	M311D14ICO	380198	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-icon-classic-crew-sock-380198	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	89.99	0	89.99	25721-DEFAULT-l.jpg	89	25721-DEFAULT-m.jpg	Sk8- Hi Mte Pewter/Asphalt	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]	GREY	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Vans Sk8-Hi MTE Shoe, Pewter/Asphalt	<p>The Sk8-Hi MTE revamps the legendary Vans high top with additions designed for the elements. Premium weather-resistant leather uppers, warm linings, and a heat retention layer between sockliner and outsole keep feet warm and dry while the newly-constructed vulcanized lug outsole takes advantage of 20 years of snow boot history for maximum traction. The Sk8-Hi MTE also features heel pull tabs, re-enforced toecaps to withstand repeated wear, and padded collars for support and flexibility.<br />  </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	90	90	10.5,13	25721-DEFAULT-s.jpg	7	1000	VN0A33TXUQB	378446	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-sk8hi-mte-shoe-pewter-asphalt-378446	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

DC Dc Court Graffik Skate Shoes, Pewter $70.00 | view details

RAINBOW Rainbow Single Layer Men's Leather Sandal $53.99 | view details

ADIDAS Adidas Adiease Skate Shoes, Ash Green/White/Gum $70.00 | view details

SANUK Sanuk Vagabond Tripper Mesh Men's Sidewalk Surfers $65.00 | view details

STANCE Stance Icon Classic Crew Sock $10.00 | view details

VANS Vans Sk8- Hi Mte Shoe, Pewter/Asphalt $90.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	26748-DEFAULT-l.jpg	39	26748-DEFAULT-m.jpg	F4 101 Venomous Radial Slims Grn/Blk 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]	10	25-to-50	0.00	[empty string]	Spitfire Formula Four 101 Venomous Slim Skateboard Wheels	<p>Spitfire Formula Four 101 Venomous Slim Skateboard Wheels</p>	[empty string]	N	39.99	39.99	52MM,53MM,54MM	26748-DEFAULT-s.jpg	11	1000	21110185	391812	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-101-venomous-slim-skateboard-wheels-391812	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	139.99	0	139.99	26405-DEFAULT-l.jpg	139	26405-DEFAULT-m.jpg	Nickel Buffy Pink 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]	4	100-to-150	0.00	[empty string]	Penny Skateboards Buffy Complete Nickel Skateboard, 27"	<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>	<p>Penny 27" Buffy Complete Nickel Skateboard - Pink</p>	N	139.99	139.99	27IN	26405-DEFAULT-s.jpg	28	1000	P27BP-C	329311	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-buffy-complete-nickel-skateboard-27-329311	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	198.99	0	198.99	26315-DEFAULT-l.jpg	198	26315-DEFAULT-m.jpg	Battle Axe 35 Chill Bird 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]	9	150-to-200	0.00	[empty string]	Landyachtz Battle Axe 35 Chill Bird Complete Longboard, 35.25"	<p style="margin-left:0px; margin-right:0px; text-align:left">Despite the aggressive name, this board can be pretty dang chill. For those who want to casually cruise around town, <em>and</em> 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> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 35.25” I W: 9” I WB: 24.5”</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong><strong>Artist:</strong> </strong>llllr</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck Material: </strong>Canadian Maple<br /> <strong>Concave:</strong> Low<br /> <strong>Flex:</strong> Medium<br /> <strong>Profile:</strong> Rocker<br /> <strong>Features:</strong> 100% Canadian Maple, bamboo Core,  Drop Thru Mounting, Rocker, Low Concave, Clear Spray on Grip</p>	[empty string]	N	199	199	35IN	26315-DEFAULT-s.jpg	46	1000	118CP-FRBA35CHL	380224	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-battle-axe-35-chill-bird-complete-longboard-3525-380224	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GOPRO	GoPro	SKATEBOARDS	SKATEBOARDS &GT; VIDEO AND AUDIO	19.99	0	19.99	19776-DEFAULT-l.jpg	19	19776-DEFAULT-m.jpg	Surf Mounts	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	15-to-20	0.00	[empty string]	GoPro Surf Mounts	<p>Mount your GoPro to surfboards, kayaks, SUPs, boat decks and other gear where maximum holding strength is needed. Includes an FCS compatible male plug to mount your GoPro using an FCS center fin socket.</p> <ul> <li>Perfect for surfboards, kayaks, SUPs, boat decks and more</li> <li>Ideal for activities where maximum holding strength is needed</li> <li>Includes FCS compatible plug for mounting to FCS center fin socket</li> <li>Includes adhesive anchors and camera tethers for enhanced security<br />  </li> </ul>	[empty string]	N	19.99	19.99	[empty string]	19776-DEFAULT-s.jpg	52	1000	ASURF-001	279381	EMPTY	EMPTY	EMPTY	0	0	0	VIDEO AND AUDIO	gopro/gopro-surf-mounts-279381	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	129.99	0	129.99	26312-DEFAULT-l.jpg	129	26312-DEFAULT-m.jpg	Dinghy Owl Embossed 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	100-to-150	0.00	[empty string]	Landyachtz Dinghy Owl Complete Cruiser Skateboard	<p style="margin-left:0px; margin-right:0px; text-align:left">"My life changed the day I bought a Dinghy. I traded in my bus pass for fresh air and a cool breeze. I started exploring the city in a brand new way, no longer enduring a crowded bus filled with people glued to their phones. Getting around used to be a chore, now everything is an adventure. My friends started doing the same thing and now we smile every time we skate past the bus. Life is better on a Dinghy." </p> <p style="margin-left:0px; margin-right:0px; text-align:left">- Sincerely, everyone who rides a Dinghy </p> <p style="margin-left:0px; margin-right:0px; text-align:left"> </p> <p style="margin-left:0px; margin-right:0px; text-align:left">28.5" Length I 8" Width I 14.6" Wheelbase</p> <p style="margin-left:0px; margin-right:0px; text-align:left">100% Canadian Maple</p>	[empty string]	N	129.99	129.99	28.5	26312-DEFAULT-s.jpg	68	1000	CP-UBDYEMB	361117	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-dinghy-owl-complete-cruiser-skateboard-361117	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	72	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

SPITFIRE Spitfire Formula Four 101 Venomous Slim Skateboard Wheels $39.99 | view details

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

LANDYACHTZ Landyachtz Battle Axe 35 Chill Bird Complete Longboard, 35.25 " $199.00 | view details

GoPro Gopro Surf Mounts $19.99 | view details

LANDYACHTZ Landyachtz Dinghy Owl Complete Cruiser Skateboard $129.99 | view details

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

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	DORSAL	DORSAL	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	25.99	0	25.99	26063-DEFAULT-l.jpg	25	26063-DEFAULT-m.jpg	Aero Sup Surf Rack Pads 28 Inch Long - 2	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	63	25-to-50	0.00	[empty string]	Dorsal Aero Roof Rack Pads for Car - Kayak, SUP, Snowboard, Surf - 28"	<p><strong>Are You Looking For An Effective And Efficient Way To Convey Surfboards, Snowboards and most Kayaks, As Well As Stand-Up Paddle Boards</strong></p> <p><strong>Start Using the Dakine Thule and Yakima Wide Flat bar Compatible Dorsal SUP Rack Pads Set, Armed With Essential Features That Make This Product Apart From The Rest.</strong></p> <ul> <li> <ul> <li> <p><strong>Easy Convey Of Surfboards, Kayaks, As Well As Stand-Up Paddle Boards</strong> This 28 inch (Dakine Style) Dorsal SUP Rack Pads set offer an effective way to convey surf boards, snowboards, kayaks, as well as stand-up paddle boards.</p> </li> <li> <p><strong>Fits Aero</strong> (Flat Bar) 5.5" - 8.0" [ 14-20cm ] bar circumference. For Square or Round Bar See Dorsal's Round Bar Pads (see diagram).</p> </li> <li> <p><strong>Reliable Material For Longer Life</strong> - This rack pads set is integrated with top grade EVA foam and is secured by a weather proof nylon sleeve. It comes with pads that will secure a kayak or board from your cars cross bars. This is also perfect for bigger surfboard roof rack transport in a smooth aerodynamic style. This is wide enough to transport surfboard with care.</p> </li> <li> <p><strong>Securing Your Surf Boards</strong> - Keep your surf board secure and safe for the next journey with the amazing and state of the art Dorsal Origin Car Surf Kayak SUP Rack Pads; which is made of with durable 600D polyester material. Top of the bar is padded for sleek fit. It comes with heavy duty velcro, 28 inches long pad as well as it fits a lot of factory auto car racks.</p> </li> </ul> </li> </ul>	[empty string]	N	25.94	25.94	[empty string]	26063-DEFAULT-s.jpg	17	1000	DORSAL-ORIGIN-BW-RACK-PAD	368237	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dorsal/dorsal-aero-roof-rack-pads-for-car-kayak-sup-snowboard-surf-28-368237	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	27101-DEFAULT-l.jpg	29	27101-DEFAULT-m.jpg	Chatter 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]	3	25-to-50	0.00	[empty string]	Slowtide Chatter Beach Towel	<p>All this chitter-chatter, chitter-chatter, it's got me shattered.</p> <p>Slowtide partners with artists, photographers, designers, and brands to create unique prints for the towels, all while maintaining premium quality. Equipped with a hanging loop feature and made from 100% sustainably sourced cotton, you are guaranteed the best drying experience.</p> <p><strong>Features</strong></p> <ul> <li>For all bodies of water</li> <li>100% super soft & absorbent cotton velour</li> <li>Reactive dye that helps prevent fading</li> <li>One-sided print</li> <li>30" x 60"</li> <li>460 grams (Lightweight)</li> <li>Hanging loop</li> <li>Imported</li> </ul> <p>Slowtide products meet the strict guidelines set by the Oeko-Tex® Standard 100. Made with care and certified for peace of mind.</p> <ul> </ul>	[empty string]	N	29.95	29.95	[empty string]	27101-DEFAULT-s.jpg	18	1000	ST188	386669	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-chatter-beach-towel-386669	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	SURF SHOP	SURF SHOP &GT; SURF 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	19	1000	BCGC	252213	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	bc/bc-surf-sport-gift-card-instore-or-online-use-252213	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Navy,White,Black	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; MEN'S	39.99	0	39.99	26973-DEFAULT-l.jpg	39	26973-DEFAULT-m.jpg	Union Wave Pf Ls	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	54	25-to-50	0.00	[empty string]	Billabong Union Wave Performance Fit Long Sleeve Rashguard	<p>Bring together a modern Billabong logo and core long sleeve rashguard. The performance fit Union rashguard delivers UPF 50+ sun protection with ergonomic seams and a silky smooth fabric.</p> <p>The nuts and bolts</p> <ul> <li>Mens long sleeve rashguard.</li> <li>Traditional mock neck.</li> <li>Silky-smooth feel.</li> <li>Billabong logo at center chest and sleeve.</li> <li>50+ UPF sun protection.</li> <li>B-Lock super flex stitch.</li> <li>Material: 6 oz silk touch fabric. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	39.95	39.95	Small,Medium,Large,X-Large,XX-Large	26973-DEFAULT-s.jpg	22	1000	MR62TBUN	382776	LONG SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	billabong/billabong-union-wave-performance-fit-long-sleeve-rashguard-382776	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; FINS	22.99	0	22.99	26112-DEFAULT-l.jpg	22	26112-DEFAULT-m.jpg	Fcs Ii Connect Gf 7 ”	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]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	FCS II Connect GF Longboard Fin - 7"	<p>Versatile, high performance fin. Connect turns and move up and down the board.</p> <p><strong>Overview</strong></p> <ul> <li> <p>Neutral, well balanced template.</p> </li> <li> <p>Versatile, high performance Longboard (LB) fin for all conditions. </p> </li> <li> <p>Offers a combination of drive, speed and response for modern longboarding.</p> </li> <li> <p>Turn and Connect: Seamlessly connect turns and move up and down the board.</p> </li> <li>Based on the FCS Dolphin Longboard template.<br />  </li> <li> <p>2 + 1 Compatible.</p> </li> </ul>	[empty string]	N	23	23	[empty string]	26112-DEFAULT-s.jpg	26	1000	FCON-GF01-LB-70-R	344853	SUP ACCESSORIES	FINS	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-ii-connect-gf-longboard-fin-7-344853	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Black,Coal	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	33.99	0	33.99	26075-DEFAULT-l.jpg	33	26075-DEFAULT-m.jpg	9 ` Reg Ankle Essential Leash	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	FCS Longboard Ankle Essential Leash - 9'	<p>Day-to day performance and ?reliability in a wide range of conditions.</p>	[empty string]	N	34	34	[empty string]	26075-DEFAULT-s.jpg	35	1000	2020-09F	374715	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-longboard-ankle-essential-leash-9-374715	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

DORSAL Dorsal Aero Roof Rack Pads For Car - Kayak, Sup, Snowboard, Surf - 28 " $25.94 | view details

SLOWTIDE Slowtide Chatter Beach Towel $29.95 | view details

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

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

FCS Fcs Ii Connect Gf Longboard Fin - 7 " $23.00 | view details

FCS Fcs Longboard Ankle Essential Leash - 9 ' $34.00 | view details

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	529.99	0	529.99	26340-DEFAULT-l.jpg	529	26340-DEFAULT-m.jpg	Instagator	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]	21	500-and-over	0.00	[empty string]	Never Summer Insta/Gator Snowboard, 2019	<p>Snap in and out of turns, spin like a machine, and rail like a train. Size your Gator smaller and improve your OVERALL performance. Amazing nimbility with stability is what 12mm of taper and massive surface area will do for you. All boards ride great in perfect conditions, now ride you can ride great ANYWHERE in ANY CONDITIONS. It’s a new world...adjust your stance width, placement, and angles for ride variations that fit the days mood, conditions, and style. You’d better get a Gator sooner rather than later. LT - Narrower version of the original.</p>	[empty string]	N	529.99	529.99	144,148,151,156,159	26340-DEFAULT-s.jpg	3	1000	INSTAGATOR-I	374737	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-insta-gator-snowboard-2019-374737	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	199.99	0	199.99	26362-DEFAULT-l.jpg	199	26362-DEFAULT-m.jpg	Shredder	N	KIDS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Never Summer Shredder Kids Snowboard, 2018	<p>Never Summer Shredder Kids Snowboard, 2018</p>	[empty string]	N	199.99	199.99	90,100,110	26362-DEFAULT-s.jpg	14	1000	SHREDDER-H	358732	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-shredder-kids-snowboard-2018-358732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	26356-DEFAULT-l.jpg	519	26356-DEFAULT-m.jpg	Warlock X	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]	6	500-and-over	0.00	[empty string]	Never Summer Warlock X Snowboard, 2019	<p>The true twin Warlock features our Original Rocker Camber Profile, a powerful flex pattern, and incredible park performance. Additional carbon was added outside the bindings to provide insane lift off and perfect landings. Soft flex between the feet and torsionally rigid nose and tail make for pinpoint turning and amazing pressability. Add to that the Warlock’s playful, forgiving feel and the result is freestyle wizardry. X - Wide version of the original.</p>	[empty string]	N	519.99	519.99	153,159	26356-DEFAULT-s.jpg	25	1000	WARLOCKX-I	374741	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-warlock-x-snowboard-2019-374741	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	199.99	0	199.99	26354-DEFAULT-l.jpg	199	26354-DEFAULT-m.jpg	Shredder	N	KIDS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	10	150-to-200	0.00	[empty string]	Never Summer Shredder Kids Snowboard, 2019	<p>Start your kids off right on a Never Summer. Our Original Rocker Camber Profile coupled with a very soft flex allows your little shredder to easily learn to ride. Starting at 80cm, you get big shred performance in a little shred package.</p>	[empty string]	N	199.99	199.99	80,90,110	26354-DEFAULT-s.jpg	25	1000	SHREDDER-I	374760	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-shredder-kids-snowboard-2019-374760	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,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	35	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]
6	[empty string]	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	12.99	0	12.99	25853-DEFAULT-l.jpg	12	25853-DEFAULT-m.jpg	Supertune Base Cleaner	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	T	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Dakine Supertune Base Cleaner	<p>Supertune Base Cleaner is our citrus based degreaser. After warm spring rides or some unfortunate encounters with dirt/rocks/mud in the occasional tree well, this cleaner is the best way to remove the dirt and grime that cake the bottom of your skis or snowboard. Use it with a rag to clean your base, then do a regular hot wax treatment. It's also great on that layer of dust that accumulated in your garage over the summer.</p>	[empty string]	N	13	13	[empty string]	25853-DEFAULT-s.jpg	47	1000	10001564-H	357734	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-supertune-base-cleaner-357734	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Insta/Gator Snowboard, 2019 $529.99 | view details

NEVER SUMMER Never Summer Shredder Kids Snowboard, 2018 $199.99 | view details

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

NEVER SUMMER Never Summer Shredder Kids Snowboard, 2019 $199.99 | view details

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

DAKINE Dakine Supertune Base Cleaner $13.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	Heather Beige	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	25.99	0	25.99	26512-DEFAULT-l.jpg	25	26512-DEFAULT-m.jpg	The Ranger Slim Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	23	25-to-50	0.00	[empty string]	Arcade Ranger Slim Belt, Heather Beige	<p>The Ranger Slim Adventure belt is packed with all the great features of it’s bigger brothers but in a smaller package. This lightweight and low-profile belt is built with elastic stretch webbing for a superior fit and ultimate comfort. A perfect fit and one size fits most come from a micro-adjust buckle. No metal means that airport security becomes a breeze. A minimal buckle and a slimmed down webbing allows this adventure belt to fit through smaller belt loops. Made from quick-drying and machine washable materials mean this tough little Ranger is your ultimate outdoor companion.</p> <ul> <li>One size fits most, up to 40″ (101.6cm)</li> <li>Narrower width for smaller belt loops</li> <li>Travel-Friendly Belt</li> <li>width – 1.25″ (3.17cm)</li> </ul>	[empty string]	N	26	26	[empty string]	26512-DEFAULT-s.jpg	5	1000	A21102-270	383724	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-ranger-slim-belt-heather-beige-383724	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Grey	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	15.99	0	15.99	26778-DEFAULT-l.jpg	15	26778-DEFAULT-m.jpg	Baker For Life 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]	34	15-to-20	0.00	[empty string]	Stance Baker For Life Crew Sock	<p>From those humble beginnings back in Y2G with the Warner Mob, one thing has always been clear for Andrew Reynolds and the boys.... And that's Baker For Life!</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	16	16	Medium,Large	26778-DEFAULT-s.jpg	5	1000	M556A19BFL	383768	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-baker-for-life-crew-sock-383768	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	White	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	11.99	0	11.99	25829-DEFAULT-l.jpg	11	25829-DEFAULT-m.jpg	Women's Uncommon Mesh Tab Sock	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	Stance Uncommon Mesh Tab Training Women's 360 Sock	<p>We took a minimal color way and added extraordinary technology. Introducing the Uncommon Mesh Tab.</p> <p>FEATURES</p> <ul> <li>80/20 Moisture Wicking Fibers</li> <li>Advanced Moisture Management</li> <li>Breathable Performance Mesh</li> <li>Anatomical Cushioning</li> <li>Seamless Toe Closure</li> <li>FEEL360™ Technology</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	Small,Medium	25829-DEFAULT-s.jpg	6	1000	W258C18UMT	380421	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-uncommon-mesh-tab-training-womens-360-sock-380421	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Chub	FISHMASKS	FISHMASKS	ACCESSORIES	ACCESSORIES &GT; FACEMASKS	19.99	0	19.99	25541-DEFAULT-l.jpg	19	25541-DEFAULT-m.jpg	Chub Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	SU17	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Chub	<h6><em>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option</em></h6>	[empty string]	N	19.99	19.99	[empty string]	25541-DEFAULT-s.jpg	6	1000	FSH-SL-CHUB	382012	EMPTY	EMPTY	EMPTY	0	0	0	FACEMASKS	fishmasks/fishmasks-single-layer-neck-gaiter-chub-382012	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	VON ZIPPER	VON ZIPPER	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	25981-DEFAULT-l.jpg	149	25981-DEFAULT-m.jpg	Pinch Tob Trt/Brz Wldlfe 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	100-to-150	0.00	[empty string]	Von Zipper Pinch Sunglasses, Tobacco Tortoise/Wild Bronze	<p><strong>Story: </strong>Some say that big things come in small packages. Get a grip and give yourself a Pinch, because this modern classic is too good to be true.</p> <p><strong>Specs: </strong>VonZipper Pinch 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	150	150	[empty string]	25981-DEFAULT-s.jpg	7	1000	SMRFAPIN-POB	344463	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	von-zipper/von-zipper-pinch-sunglasses-tobacco-tortoise-wild-bronze-344463	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ACCESSORIES	ACCESSORIES &GT; SUNSCREEN/SKIN CARE	3.99	0	3.99	25575-DEFAULT-l.jpg	3	25575-DEFAULT-m.jpg	Watermelon Spf 30 Lip Balm	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]	2836	5-and-under	0.00	[empty string]	Sun Bum SPF 30 Lip Balm, Watermelon	<p>Grab as many as you can because we literally can't keep any of our lip balm flavors in stock. Our smooth SPF 30 sunscreen lip balm with added Aloe and Vitamin E will protect and moisturize your kisser all day long... just try not to lick it off.</p>	[empty string]	N	3.99	3.99	[empty string]	25575-DEFAULT-s.jpg	7	1000	20-46023	357166	EMPTY	EMPTY	EMPTY	0	0	0	SUNSCREEN/SKIN CARE	sun-bum/sun-bum-spf-30-lip-balm-watermelon-357166	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]