Accessories

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	Dark Green,Salt & Pepper,Maroon	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; BEANIES	19.99	0	19.99	26399-DEFAULT-l.jpg	19	26399-DEFAULT-m.jpg	Shoreman 3 Cuff 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]	83	15-to-20	0.00	[empty string]	Never Summer Shoreman 3 Cuff Beanie	<p>The Never Summer Shoreman Cuff Beanie is here and it's ready to take over every mountain, mall and campfire that dares to test its patience.</p>	<p>Never Summer Shoreman Cuff Beanie</p>	N	19.99	19.99	[empty string]	26399-DEFAULT-s.jpg	2	1000	BNSHORE3	345722	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-shoreman-3-cuff-beanie-345722	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White	RVCA	RVCA	MENS	MENS &GT; BOTTOMS &GT; BOARDSHORTS	54.99	0	54.99	26711-DEFAULT-l.jpg	54	26711-DEFAULT-m.jpg	Gerrard Dots Trunk	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	RVCA Tom Gerrard Dots Boardshorts, 17"	<p>A CLASSIC BOARDSHORT AND CURATED LIVE SIDE-BY-SIDE IN THE RVCA TOM GERRARD DOTS 17" TRUNK. PART OF THE ARTIST NETWORK PROGRAM, THE MENS BOARDSHORT FEATURES AN ALLOVER PRINT BY GLOBALLY RECOGNIZED STREET ARTIST TOM GERRARD, AKA “AEON.” THE AUSSIE ARTIST’S WORK IS SHOWCASED ON A CLASSIC NON-STRETCH TRUNK, TOPPED WITH A DWR COATING TO KEEP YOUR BOARDSHORTS LIGHTER AND DRIER.</p>	[empty string]	N	55	55	Medium,Large,X-Large	26711-DEFAULT-s.jpg	2	1000	M167TRGE	386060	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	rvca/rvca-tom-gerrard-dots-boardshorts-17-386060	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Shadow	DAKINE	DAKINE	MENS	MENS &GT; OUTERWEAR &GT; GLOVES	19.99	0	19.99	25835-DEFAULT-l.jpg	19	25835-DEFAULT-m.jpg	Storm Liner	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]	41	15-to-20	0.00	[empty string]	Dakine Storm Liner Glove	<p>Like long underwear, but for your hands. Storm Liner is a midweight fleece glove rocking 4 way stretch construction, touchscreen compatibility, and a silicone gripper palm pattern. You'll never regret having a pair close by, whether you wear it under a glove or mitt as an extra layer in cold conditions, or by itself for an early morning walk to the coffee shop or a night by the campfire.</p>	[empty string]	N	20	20	X-Small,Small,Medium,Large,X-Large,XX-Large	25835-DEFAULT-s.jpg	3	1000	10000697-I	373459	GLOVES	EMPTY	EMPTY	0	0	0	OUTERWEAR	dakine/dakine-storm-liner-glove-373459	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	15.99	0	15.99	26755-DEFAULT-l.jpg	15	26755-DEFAULT-m.jpg	Shake Junt Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	OH at 200	[empty string]	44	15-to-20	0.00	[empty string]	Stance SJ Skate Crew Sock	<p>We’ve collaborated with epic skate warehouse Shake Junt to give you a sock that shines in its simplicity. Classic stripes with “Shake Junt” inscription atop an all-black, combed cotton canvas. Effortless style, premium comfort. Skate on.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Elastic Arch Support</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	16	16	Medium,Large	26755-DEFAULT-s.jpg	3	1000	M556A19SJB	383769	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-sj-skate-crew-sock-383769	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Multi	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; 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	7	1000	M556D18MAT	380171	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	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]
6	BN4,CNB,Pirate Black,Surplus Blue	RVCA	RVCA	MENS	MENS &GT; BOTTOMS &GT; SHORTS	59.99	0	59.99	26713-DEFAULT-l.jpg	59	26713-DEFAULT-m.jpg	All Time Coastal Rin	N	MENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	64	50-to-100	0.00	[empty string]	RVCA All Time Rinsed Coastal Hybrid Boardshorts	<p>A BOARDSHORT / SHORT CROSSOVER, THE RVCA ALL TIME RINSED COASTAL HYBRID SHORT IS YOUR ONE-AND-DONE SHORT. DESIGNED TO ENDURE ALL OF LIFE’S TERRAINS, THE ACTIVE-MINDED WALKSHORT IS MADE FROM AN ACID-WASHED COTTON STRETCH BLEND, OFFERING THE LOOK OF A VINTAGE SHORT WITH MODERN FUNCTION. PART OF THE ALL TIME COLLECTION, COMBINING FUNCTION, COMFORT AND STYLE, THE WALKSHORT FEATURES ELASTIC AT THE SIDES OF THE WAIST AND AN INTERNAL DRAWCORD FOR THE PERFECT FIT.</p>	[empty string]	N	60	60	28,Medium,30,X-Large,32,33,34,36,38	26713-DEFAULT-s.jpg	7	1000	M211TRCR	386078	SHORTS	EMPTY	EMPTY	0	0	0	EMPTY	rvca/rvca-all-time-rinsed-coastal-hybrid-boardshorts-386078	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Shoreman 3 Cuff Beanie $19.99 | view details

RVCA Rvca Tom Gerrard Dots Boardshorts, 17 " $55.00 | view details

DAKINE Dakine Storm Liner Glove $20.00 | view details

STANCE Stance Sj Skate Crew Sock $16.00 | view details

STANCE Stance Matal Classic Crew Sock $12.00 | view details

RVCA Rvca All Time Rinsed Coastal Hybrid Boardshorts $60.00 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	396	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	724	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25578-DEFAULT-l.jpg	5	25578-DEFAULT-m.jpg	Sunset Cove Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	147	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sunset Cove	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25578-DEFAULT-s.jpg	781	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	Ivory	DAKINE	DAKINE	WOMENS	WOMENS &GT; ACCESSORIES &GT; BEANIES	29.99	0	29.99	25891-DEFAULT-l.jpg	29	25891-DEFAULT-m.jpg	Wmns Audrey Visor 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]	2018	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Dakine Audrey Women's Visor Beanie	<p>Audrey is a novelty-designed basket knit beanie with a soft visor and decorative button band. It's a unique look that works with your ski or snowboard kit on the mountain just as well as it does with a hoodie and jeans at the skate park. And the full fleece lining gives it a soft finish for a comfortable wear.</p> <ul> <li>Novelty basket knit</li> <li>Full fleece lining</li> <li>Soft visor</li> <li>Classic fit</li> </ul>	[empty string]	N	30	30	[empty string]	25891-DEFAULT-s.jpg	2	1000	10000819-H	356490	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-audrey-womens-visor-beanie-356490	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUNCLOUD	SUNCLOUD	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	49.99	0	49.99	26027-DEFAULT-l.jpg	49	26027-DEFAULT-m.jpg	Mayor Mat Blk/Gry	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Suncloud Mayor Medium Fit Sunglasses, Matte Black/Gray Polarized Poly	<p>Be in charge when you don the Mayor. Influential styling and masterful design are only equaled by the comfort and effortless wear of this self-assured style. Sport a classic color or step out in a bright frame color or mirror lens option.</p> <p>Lens width: 57.5</p> <p>Lens height: 41.5</p> <p>Nose bridge: 17</p> <p>Temple length: 134</p> <p> </p>	[empty string]	N	49.99	49.99	[empty string]	26027-DEFAULT-s.jpg	2	1000	S-MAPPGYMB	358683	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	suncloud/suncloud-mayor-medium-fit-sunglasses-matte-black-gray-polarized-poly-358683	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	RVCA	RVCA	WOMENS	WOMENS &GT; DRESSES/ROMPERS	48.99	0	48.99	27092-DEFAULT-l.jpg	48	27092-DEFAULT-m.jpg	Odyssey Mini Dress	N	WOMENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	RVCA Odyssey Striped Tank Dress	<p>THE RVCA ODYSSEY STRIPED TANK DRESS FEATURES A RELAXED STRUCTURE, MATCHED WITH AN EASY-GOING ATTITUDE. A TAKE ON A MODERN SLIP DRESS, THE WOVEN MINI FEATURES A CUSTOM STRIPE PATTERN, ACCENTED WITH THIN STRAPS THAT TIE AT THE CENTER BACK.</p> <ul> <li>WOVEN MINI DRESS</li> <li>STRAPPY SLIP DRESS SILHOUETTE</li> <li>THIN STRAPS ADJUST WITH A TIE AT THE CENTER BACK</li> <li>YARN DYE COLORBLOCKED PLACEMENT STRIPES</li> <li>V NECKLINE</li> <li>WOVEN POPLIN <p> </p> </li> </ul>	[empty string]	N	49	49	Small,Medium,Large	27092-DEFAULT-s.jpg	2	1000	WD15TROD	386440	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	rvca/rvca-odyssey-striped-tank-dress-386440	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

DAKINE Dakine Audrey Women's Visor Beanie $30.00 | view details

SUNCLOUD Suncloud Mayor Medium Fit Sunglasses, Matte Black/Gray Polarized Poly $49.99 | view details

RVCA Rvca Odyssey Striped Tank Dress $49.00 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	9.99	0	9.99	25949-DEFAULT-l.jpg	9	25949-DEFAULT-m.jpg	Bowline Silicone Retainer Gry/Blu	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]	5	5-to-10	0.00	[empty string]	Costa Del Mar Silicone Sunglasses Retainer, Grey/Blue	<p>Streamlined silicone retainer. Flexible, durable, and lightweight with sliding bead for adjustable tension. <strong>End-to-End Measurement: </strong>19"</p>	[empty string]	N	9.99	9.99	[empty string]	25949-DEFAULT-s.jpg	20	1000	BW98	363720	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-silicone-sunglasses-retainer-grey-blue-363720	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	9.99	0	9.99	25798-DEFAULT-l.jpg	9	25798-DEFAULT-m.jpg	Boy's Check Me Out Sock	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	11	5-to-10	0.00	[empty string]	Stance Check Me Out Boys Kids Classic Crew Sock	<p>Checkered print will never go out of style. Pass the torch with Check Me Out Boys.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	10	10	Medium,Large	25798-DEFAULT-s.jpg	82	1000	B526D18CHE	380125	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-check-me-out-boys-kids-classic-crew-sock-380125	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25939-DEFAULT-l.jpg	8	25939-DEFAULT-m.jpg	Fathom Cord	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	5-to-10	0.00	[empty string]	Costa Del Mar Fathom Cord Sunglasses Holder	<p>FATHOM CORD. Marine-grade, soft nylon retainer designed specifically to fit Fathom and all styles, especially those with co-injected temples.  <strong>End-to-End Measurement: </strong>28"</p>	[empty string]	N	8.99	8.99	[empty string]	25939-DEFAULT-s.jpg	83	1000	CF11	349328	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-fathom-cord-sunglasses-holder-349328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	74.99	0	74.99	25699-DEFAULT-l.jpg	74	25699-DEFAULT-m.jpg	Kyle Walker Pro Black/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	85	50-to-100	0.00	[empty string]	Vans Kyle Walker Pro Skate Shoe, Black/White	<p>The all new Kyle Walker Pro, the introductory signature model from rookie pro Kyle Walker, is made with suede uppers. The UltraCush HD impact sockliners keep the foot close to the board while providing the highest level of impact cushioning, and the revolutionary Wafflecup construction offers the support of a cupsole without sacrificing any of the grip or boardfeel of a traditional vulcanized shoe. The Kyle Walker Pro also features DURACAP upper reinforcement in high wear areas for unrivaled durability.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	75	75	7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25699-DEFAULT-s.jpg	111	1000	VN0A2XSGY28	366350	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-kyle-walker-pro-skate-shoe-black-white-366350	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[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]	110	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	123	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]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; BOYS &GT; SHOES	54.99	0	54.99	27131-DEFAULT-l.jpg	54	27131-DEFAULT-m.jpg	Youth Tnt Adv Prototype (Anti Hero) Army	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BROWN	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	23	50-to-100	0.00	[empty string]	Vans x Anti Hero TNT Advanced Prototype Kids Skate Shoe	<p>This Spring, two of the world?s most iconic skate brands team up again for a unique collection of footwear and apparel that celebrates both brands? storied histories. On The Wire and Off The Wall, the Vans x ANTI HERO TNT Advanced Prototype Youth is a progressive vulcanized skateboarding shoe made with suede uppers and Vans original waffle outsoles utilizing a rubber that offers grip and support. Featuring custom Vans x ANTI HERO details, the TNT Advanced Prototype Youth also includes Pro Vulc Lite construction to deliver the best in boardfeel, flex, and traction.</p>	[empty string]	N	55	55	13,1,2,3,4,5,6	27131-DEFAULT-s.jpg	133	1000	VN0A3TLDVGP	383069	SHOES	EMPTY	EMPTY	0	0	0	EMPTY	vans/vans-x-anti-hero-tnt-advanced-prototype-kids-skate-shoe-383069	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

COSTA DEL MAR Costa Del Mar Silicone Sunglasses Retainer, Grey/Blue $9.99 | view details

STANCE Stance Check Me Out Boys Kids Classic Crew Sock $10.00 | view details

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

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

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

VANS Vans X Anti Hero Tnt Advanced Prototype Kids Skate Shoe $55.00 | view details

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	59.99	0	59.99	25712-DEFAULT-l.jpg	59	25712-DEFAULT-m.jpg	Slip- On Pro Blackout	N	[empty string]	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	56	50-to-100	0.00	[empty string]	Vans Slip-On Pro Skate Shoe, Blackout	<p>The Slip-On Pro, a Vans classic upgraded for enhanced performance, features suede and canvas uppers, single-wrap foxing tape, UltraCush? HD sockliners to keep the foot close to the board while providing the highest level of impact cushioning, and Vans original waffle outsoles for superior grip and control. The Slip-On Pro also includes Duracap? reinforcement rubber underlays in high wear areas for unrivaled durability.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	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	25712-DEFAULT-s.jpg	17	1000	VN00097M1OJ	377975	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-slipon-pro-skate-shoe-blackout-377975	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	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	20	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]
3	Charcoal,Dark Brown,Black,Brindle,Navy	SANUK	SANUK	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	35.99	0	35.99	25623-DEFAULT-l.jpg	35	25623-DEFAULT-m.jpg	Beer Cozy 2 Mens Sandal	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]	OH at 200	[empty string]	112	25-to-50	0.00	[empty string]	Sanuk Beer Cozy 2 Men's Sandal	<p>Light, foamy and refreshing, keep buzzin’ all day in Beer Cozy 2 flip flops. These insanely soft sandals offer thick cuts of squishy sole in a cooler-full of mind-bottling styles. Please enjoy irresponsibly.</p>	[empty string]	N	36	36	8,9,10,11,12,13,14	25623-DEFAULT-s.jpg	23	1000	SMS10868	331661	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	sanuk/sanuk-beer-cozy-2-mens-sandal-331661	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	33	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]
5	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	FOOTWEAR	FOOTWEAR	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	39	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	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	59.99	0	59.99	25722-DEFAULT-l.jpg	59	25722-DEFAULT-m.jpg	Old Skool Falcon/True White	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Vans Gumsole Old Skool Skate Shoe, Falcon/Boot Lace	<p>The first to bear the iconic side stripe, the Gumsole Old Skool is a low top lace-up shoe. It is lined, has padded collars for comfort, re-enforced toecaps to withstand repeated wear, and features the Vans signature waffle outsole for a firmer grip.</p> <p><br /> 3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	6.5	25722-DEFAULT-s.jpg	39	1000	VN0A38G1UKW	378730	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-gumsole-old-skool-skate-shoe-falcon-boot-lace-378730	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VANS Vans Slip- On Pro Skate Shoe, Blackout $60.00 | view details

VANS Vans Sk8- Hi Mte Shoe, Pewter/Asphalt $90.00 | view details

SANUK Sanuk Beer Cozy 2 Men's Sandal $36.00 | view details

STANCE Stance Icon Classic Crew Sock $10.00 | view details

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

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

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	54.99	0	54.99	26321-DEFAULT-l.jpg	54	26321-DEFAULT-m.jpg	Dinghy Gin And Tonic 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]	2	50-to-100	0.00	[empty string]	Landyachtz Dinghy Gin and Tonic Cruiser Skateboard Deck, 28.5"	<p style="margin-left:0px; margin-right:0px; text-align:left">The dinghy has been our go to cruiser for nearly 20 years. Ideal for cruising the neighborhoods, beaches, and campuses of the world.  With our crew of skaters and engineers we’ve been able to design the trucks, wheels and deck together, creating the perfect off the shelf complete. Easy to learn on, and easy to shred if you’ve been skating for years. </p> <p style="margin-left:0px; margin-right:0px; text-align:left">Dave was never able to convince his friends that the bar tender actually put tiny jelly fish and sea horses in his cocktail. It seemed like a little bit like bulls&#t. He did manage to convince them to go to that same bar for a drink this weekend, we'll see what they report on Monday and let you know.</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist: </strong>Nicholas Barome</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 28.5" \| W: 8.5" \| WB: 15"</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck material:</strong> 7 Ply Canadian Maple<br /> <strong>Concave:</strong> Low <br /> <strong>Flex:</strong> Low <br /> <strong>Features:</strong> Boxy Kicktail, Wheel Wells, 100% Canadian Maple, Low Concave <br /> <strong>Setup:</strong> Polar Bear 105, 63mm Fatty Hawgs Grey/White swirl 78a, ¼” risers, Bear Spaceball bearings</p>	[empty string]	N	54.99	54.99	8.0	26321-DEFAULT-s.jpg	15	1000	DK-UBDYGNT	381064	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-dinghy-gin-and-tonic-cruiser-skateboard-deck-285-381064	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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]	8	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	18	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]
3	[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]	8	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	26	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]
4	[empty string]	MADNESS	MADNESS	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	56.99	0	56.99	27054-DEFAULT-l.jpg	56	27054-DEFAULT-m.jpg	Factory R7 8.6 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]	4	50-to-100	0.00	[empty string]	Madness Factory White R7 Skateboard Deck, 8.625"	<p>MADNESS Factory White 8.625 R7 Skateboard Deck<br /> <em>Resin-7 Canadian Maple Construction </em><br /> Mellow Concave / Steep Kick<br /> 8.625" x 32.3" x 14.375" WB</p>	[empty string]	N	56.99	56.99	8.6	27054-DEFAULT-s.jpg	49	1000	10076014	392539	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	madness/madness-factory-white-r7-skateboard-deck-8625-392539	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Yellow,Orange	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	4.99	0	4.99	26418-DEFAULT-l.jpg	4	26418-DEFAULT-m.jpg	Colored Hardware	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	5-and-under	0.00	[empty string]	Penny Skateboards Gumball Colored Skateboard Hardware, 1.125"	<p>Gumball bolts are Nickel-plated, high tesile deck bolts, dipped in a range of colours to create a world of colour combinations.</p>	[empty string]	N	4.99	4.99	[empty string]	26418-DEFAULT-s.jpg	52	1000	PHW	286331	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	penny/penny-skateboards-gumball-colored-skateboard-hardware-1125-286331	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD BEARINGS	59.99	0	59.99	4160-DEFAULT-l.jpg	59	4160-DEFAULT-m.jpg	Swiss Bearing 8 Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WEB	[empty string]	ACTIVE	[empty string]	UPDATE	[empty string]	[empty string]	[empty string]	54	50-to-100	0.00	[empty string]	Bones Swiss Skateboard Bearings	<p>Legendary Original Bones® Swiss Bearings are the optimum combination of Bones Skate Rated™ design and Swiss precision manufacturing creating the standard by which all other bearings are measured. For more than 36 years preferred by the world's top professional skaters. Proven, professional competition-grade speed and durability make Bones Swiss normally last several times as long as ordinary ABEC rated bearings. Made in Switzerland.</p> <p><strong>Features</strong></p> <ul> <li>Single, removable, non-contact rubber shield allows easy cleaning and low friction.</li> <li>High speed nylon ball retainer provides added strength and speed.</li> <li>Pre-lubricated with Speed Cream racing lubricant</li> <li>Skate Rated; clearances, tolerances, materials and lubricant provide the best performance and durability possible.</li> <li>Best selling high end skate bearing in the U.S.A.</li> </ul> <p><strong>Contents</strong></p> <ul> <li>Set of 8 bearings</li> <li>4 bearing spacers</li> <li>Instructions</li> <li>Sticker</li> </ul> <p>Bones Swiss Bearings have the best reputation in the skateboard industry and have had this honor since 1981, due to their performance and quality. Everyone who rides Swiss knows how fast they are and how long they last. Testimonials reveal them lasting several times longer than low cost bearings. Skaters who use Bones Swiss do so because they want the very best equipment they can get and know the difference between ordinary and exceptional. Our team is a who’s who of top skaters and we are proud to be associated with each one of them.</p>	[empty string]	N	59.99	59.99	[empty string]	4160-DEFAULT-s.jpg	76	1000	6501030	36673	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-swiss-skateboard-bearings-36673	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

LANDYACHTZ Landyachtz Dinghy Gin And Tonic Cruiser Skateboard Deck, 28.5 " $54.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

MADNESS Madness Factory White R7 Skateboard Deck, 8.625 " $56.99 | view details

PENNY Penny Skateboards Gumball Colored Skateboard Hardware, 1.125 " $4.99 | view details

BONES Bones Swiss Skateboard Bearings $59.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]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	27100-DEFAULT-l.jpg	29	27100-DEFAULT-m.jpg	Gato 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]	7	25-to-50	0.00	[empty string]	Slowtide Gato Beach Towel	<p>Out on the prowl for some sunshine with the Gato towel. 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>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]	27100-DEFAULT-s.jpg	4	1000	ST187	385253	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-gato-beach-towel-385253	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	20.99	0	20.99	4597-DEFAULT-l.jpg	20	4597-DEFAULT-m.jpg	Wet Bucket Surf Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ALWAYS IN	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	10	20-to-25	0.00	[empty string]	FCS Wet Bucket Amphibious Surf Hat	<p>Designed to stay secure in the surf and provide protection against sun and elements.</p>	[empty string]	N	20.98	20.98	Small,Large,X-Large,Large/X-Large	4597-DEFAULT-s.jpg	32	1000	2924	219541	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-wet-bucket-amphibious-surf-hat-219541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	114.99	0	114.99	26248-DEFAULT-l.jpg	114	26248-DEFAULT-m.jpg	John John 2 Small 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 Fin, Small	<p>The John John (S) Techflex signature fin is a small sized Speed Contolling fin with a Ride Number of 4.0. This template is a scaled down version of the Medium template that JJF rides exclusively. 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>14.10</td> <td>14.10</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.42</td> <td>4.42</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.32</td> <td>4.32</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]	26248-DEFAULT-s.jpg	40	1000	5556-483-00	341101	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-john-john-techflex-fin-small-341101	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DORSAL	DORSAL	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	26069-DEFAULT-l.jpg	29	26069-DEFAULT-m.jpg	Poncho - Black	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]	26	25-to-50	0.00	[empty string]	Dorsal Changing Robe Surf Poncho	<p>Surf Changing Poncho - Black</p> <ul> <li>The DORSAL Poncho is a plush towel poncho in and out of your wetsuit EASY, COMFORTABLE, and WARM.</li> <li>ONE SIZE FITS ALL - even tall guys like Mike! Other ponchos are short and can still leave you exposed, so we made ours taller. 40 inches (120cm) from top of shoulders to bottom of robe.</li> <li>THICK MICROFIBER is soft on your skin and dries quickly. Machine washable for easy care.</li> <li>ABSORBS WATER - Poncho doubles as a towel to dry yourself after surfing, so you don't need an additional towel .</li> <li>The PERFECT GIFT for that hard-to-please surfer. Whether it's Christmas, a birthday, graduation, or "just because", your surfer will be stoked to receive the Dorsal poncho!</li> </ul>	[empty string]	N	29.85	29.85	[empty string]	26069-DEFAULT-s.jpg	42	1000	DORSAL-PONCHO-BLK	368461	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dorsal/dorsal-changing-robe-surf-poncho-368461	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SOFTECH	SOFTECH	SURF SHOP	SURF SHOP &GT; SURFBOARDS &GT; SOFT TOPS/BEGINNER	254.99	0	254.99	26741-DEFAULT-l.jpg	254	26741-DEFAULT-m.jpg	5 ` 0 Flash Eric G Blu Marble W/Fcsii	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Softech Eric Geiselman Flash, FCS II, 5'	<p>The Eric Geiselman Flash will motivate you to surf on any given day due to the uncanny feel and performance similarities between a soft and hard skin board. This is performance with a serious injection of fun.</p>	[empty string]	N	255	255	5FT	26741-DEFAULT-s.jpg	47	1000	FEGII-BUM-050	374850	SOFT TOPS/BEGINNER	EMPTY	EMPTY	0	0	0	SURFBOARDS	softech/softech-eric-geiselman-flash-fcs-ii-5-374850	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	16.99	0	16.99	6185-DEFAULT-l.jpg	16	6185-DEFAULT-m.jpg	Fcs Longboard Fin Converter	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	15-to-20	0.00	[empty string]	FCS Longboard Box Adapter	<p>Convert a single fin box to fit any FCS fin.</p>	[empty string]	N	16.98	16.98	[empty string]	6185-DEFAULT-s.jpg	56	1000	10067	240169	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-longboard-box-adapter-240169	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SLOWTIDE Slowtide Gato Beach Towel $29.95 | view details

FCS Fcs Wet Bucket Amphibious Surf Hat $20.98 | view details

FUTURE FINS Futures John John Techflex Fin, Small $115.00 | view details

DORSAL Dorsal Changing Robe Surf Poncho $29.85 | view details

SOFTECH Softech Eric Geiselman Flash, Fcs Ii, 5 ' $255.00 | view details

FCS Fcs Longboard Box Adapter $16.98 | 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	26342-DEFAULT-l.jpg	569	26342-DEFAULT-m.jpg	West 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]	14	500-and-over	0.00	[empty string]	Never Summer West X 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	157,160,164,168	26342-DEFAULT-s.jpg	4	1000	WESTX-I	374748	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-west-x-snowboard-2019-374748	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Scales	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25545-DEFAULT-l.jpg	19	25545-DEFAULT-m.jpg	Scales Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	SU17	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Scales	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	[empty string]	N	19.99	19.99	[empty string]	25545-DEFAULT-s.jpg	17	1000	FSH-SL-SCALES	382018	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-scales-382018	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	10.99	0	10.99	25870-DEFAULT-l.jpg	10	25870-DEFAULT-m.jpg	Torque Driver	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	9	10-to-15	0.00	[empty string]	Dakine Torque Driver, Snow Tools and Equipment	<p>Our best-selling multi-tool for over 20 years, the Torque Driver comes with all the standard bits you'll need for your skis, snowboard, or surfboard. The stowaway handle makes it a ridiculously convenient tool to throw in with any tuning kit, or keep in your pocket through an entire day on the mountain for quick, on-the-go tweaks to your rig.</p>	[empty string]	N	11	11	[empty string]	25870-DEFAULT-s.jpg	18	1000	10001554-I	373464	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-torque-driver-snow-tools-and-equipment-373464	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	20	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	Black,Carbon	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; MEN'S OUTERWEAR &GT; GLOVES	39.99	0	39.99	25839-DEFAULT-l.jpg	39	25839-DEFAULT-m.jpg	Nova Short Glove	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	25-to-50	0.00	[empty string]	Dakine Nova Short Ski and Snowboard Glove	<p>The Nova Short Glove has all of the durability and functionality of the gauntlet length variation, in the convenient form factor of a cuff length glove. With a water repellent poly shell, 230g synthetic insulation, and a DK Dry™ waterproof insert, it offers plenty of protection to be an everyday wear glove, and the size makes it easy to toss in your bag as a backup set for extended ski or snowboard trips. The water repellent leather palm adds durability where you need it most, so it'll be your go-to glove for many happy seasons of resort riding.</p>	[empty string]	N	40	40	Small,Medium,Large,X-Large	25839-DEFAULT-s.jpg	57	1000	01300330-I	373457	MENS OUTERWEAR	GLOVES	EMPTY	0	0	0	OUTERWEAR	dakine/dakine-nova-short-ski-and-snowboard-glove-373457	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Ginger,Scout	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	84.99	0	84.99	25892-DEFAULT-l.jpg	84	25892-DEFAULT-m.jpg	Mission Pro 18l Backpack	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Dakine Mission Pro 18L Snowboard and Ski Backpack	<p>Sized for resort laps, the Mission Pro 18L stows your shovel and probe for powder days at the hill. There's room for skins and spare gloves, plus a fleece-lined pocket for goggles or sunglasses. It's hydration compatible with an insulated sleeve in the shoulder strap, and you can strap on your board or skis for boot pack missions beyond the boundary.</p> <ul> <li>Vertical snowboard carry</li> <li>Diagonal ski carry</li> <li>DK Impact Spine Protector compatible (sold separately)</li> <li>Fleece lined goggle pocket</li> <li>Snow tool/shovel pocket</li> </ul>	[empty string]	N	85	85	[empty string]	25892-DEFAULT-s.jpg	63	1000	10002063-I	373173	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-mission-pro-18l-snowboard-and-ski-backpack-373173	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

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

DAKINE Dakine Torque Driver, Snow Tools And Equipment $11.00 | view details

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

DAKINE Dakine Nova Short Ski And Snowboard Glove $40.00 | view details

DAKINE Dakine Mission Pro 18l Snowboard And Ski Backpack $85.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	Stone Wash,Thyme	QUIKSILVER	QUIKSILVER	ACCESSORIES	ACCESSORIES &GT; HATS	29.99	0	29.99	26658-DEFAULT-l.jpg	23	26658-DEFAULT-m.jpg	Rig Tender Trucker Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	7	20-to-25	0.00	[empty string]	Quiksilver Rig Tender Trucker Hat	<ul> <li>Cotton twill fabric</li> <li>6-panel low profile crown</li> <li>Curved brim</li> <li>HD woven label patch on center front</li> <li>Adjustable plastic snap closure</li> </ul> <p>Composition</p> <ul> <li> <p>100% Cotton</p> </li> </ul>	[empty string]	N	24	24	One Size	26658-DEFAULT-s.jpg	2	1000	AQYHA04299	383368	EMPTY	EMPTY	EMPTY	0	0	0	HATS	quiksilver/quiksilver-rig-tender-trucker-hat-383368	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ELECTRIC	ELECTRIC	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	25963-DEFAULT-l.jpg	149	25963-DEFAULT-m.jpg	Dude Mat Blk/Ohm Gry 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]	2	100-to-150	0.00	[empty string]	Electric Dude Sunglasses, Matte Black/Grey Polarized	<p>Electric Dude Sunglasses, Matte Black/Grey Polarized</p>	[empty string]	N	150	150	[empty string]	25963-DEFAULT-s.jpg	3	1000	EE16701042	362920	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-dude-sunglasses-matte-black-grey-polarized-362920	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Seaford Pet,Waimea	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; BAGS	34.99	0	34.99	27014-DEFAULT-l.jpg	34	27014-DEFAULT-m.jpg	Revival Travel Kit Md	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Dakine Revival Kit Medium Travel Bag	<p>The Revival Kit is possibly our most functional travel kit. Available in large, medium, and small, the Large option is roomy enough to accommodate full-sized toiletries, and features two small internal pockets, one large interior mesh pocket, and a mesh divider, to keep things in place. This bag also comes with a removable clear plastic pocket for liquids—so you don't have to pull out your entire kit in the TSA line. With its wide-base design and padded exterior walls, Revival is a solid countertop kit, and it features a tuck-away hanger loop, so it transforms to a hanging orientation when you need it.</p> <h3>DETAILS</h3> <ul> <li>Limited Lifetime Warranty</li> <li>Counter top or hanging orientation</li> <li>Two small internal zippered pockets for little items</li> <li>One large internal mesh pocket and divider</li> <li>One large removable clear plastic pocket for liquids (TSA compliant)</li> <li>Elastic daisy chains keep long items handy</li> </ul>	[empty string]	N	35	35	[empty string]	27014-DEFAULT-s.jpg	3	1000	10001813-I	383588	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-revival-kit-medium-travel-bag-383588	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Tofino,Kiki,Breezeway,Coral Reef	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; WALLETS	24.99	0	24.99	25897-DEFAULT-l.jpg	24	25897-DEFAULT-m.jpg	Wmns Clover Tri Fold Wallet	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	[empty string]	[empty string]	8	20-to-25	0.00	[empty string]	Dakine Clover Tri-Fold Women's Wallet	<p>Never dig for change or fumble for your ID again. This women's wallet has an envelope-like design and is sized just right to keep your daily essentials in one place. A windowed ID slot, zip coin pocket and zip smartphone pocket keep everything easy to reach.</p> <ul> <li>Snap closure</li> <li>Multiple credit card slots</li> <li>Interior windowed ID slot</li> <li>Interior zippered coin pocket</li> <li>Exterior zippered pocket fits most smartphones</li> </ul>	[empty string]	N	25	25	[empty string]	25897-DEFAULT-s.jpg	4	1000	10002031-I	372610	EMPTY	EMPTY	EMPTY	0	0	0	WALLETS	dakine/dakine-clover-trifold-womens-wallet-372610	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	24.99	0	24.99	26032-DEFAULT-l.jpg	24	26032-DEFAULT-m.jpg	Gooch Blk/Gry	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TOP 25	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	20-to-25	0.00	[empty string]	Dot Dash Gooch Sunglasses, Black Gloss/Grey	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <p><strong>Locker Room Collection ~ </strong>Be on the ball and drop back and punt.</p> <h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-8 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	25	25	[empty string]	26032-DEFAULT-s.jpg	5	1000	DSLRFGOO-BKG	274615	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-gooch-sunglasses-black-gloss-grey-274615	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	124.99	0	124.99	25659-DEFAULT-l.jpg	124	25659-DEFAULT-m.jpg	The Rival All Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Nixon The Rival 38mm Watch, All Black	<p>For those who charge hard in and out of the water, the Rival is the go-to in the lineup. Featuring a high-contrast digital display wrapped in a bold bezel, free-swing band with a textured pattern to channel water, water resistant pushers, and 550 pre-programmed tide locations, the Rival never backs away from a challenge.</p>	[empty string]	N	125	125	[empty string]	25659-DEFAULT-s.jpg	5	1000	A1236001	375182	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-the-rival-38mm-watch-all-black-375182	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]