Sunglasses

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	[empty string]	DOT DASH	DOT DASH	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	27.99	0	27.99	26040-DEFAULT-l.jpg	27	26040-DEFAULT-m.jpg	Lads Blk Clear/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]	UPDATE	[empty string]	OH at 200	[empty string]	20	25-to-50	0.00	[empty string]	Dot Dash Lads Sunglasses, Black Clear/Grey Polarized	<h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Base-6 Polycarbonate Lens</li> <li>Polycarbonate Frame</li> <li>Integrated Pin Hinge</li> </ul>	[empty string]	N	28	28	[empty string]	26040-DEFAULT-s.jpg	4	1000	DSVTFLAD-BKG	274683	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-lads-sunglasses-black-clear-grey-polarized-274683	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VON ZIPPER	VON ZIPPER	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	109.99	0	109.99	25984-DEFAULT-l.jpg	109	25984-DEFAULT-m.jpg	Maxis Blk Gloss/Vint Gry	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Von Zipper Maxis Sunglasses, Black Gloss/Vintage Grey	<p><strong>Story: </strong>A full-blown eyewear expedition where getting there is all the fun. Get out there and be somebody! Take that first step and take it to the top in the Maxis.</p> <p><strong>Specs:</strong> 100% UV protection. Oversized light weight design. Base 6 spherical lens. Impact resistant polycarbonate lens. Nylon grilamid frame. Stainless steel optical hinges. Made in Italy.</p>	[empty string]	N	110	110	[empty string]	25984-DEFAULT-s.jpg	6	1000	SMSFJMAX-BKV	357981	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	von-zipper/von-zipper-maxis-sunglasses-black-gloss-vintage-grey-357981	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	VANS	VANS	MENS	MENS &GT; SHOES &GT; SKATE SHOES	79.99	0	79.99	27129-DEFAULT-l.jpg	79	27129-DEFAULT-m.jpg	Berle Pro Black/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]	BLACK	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	28	50-to-100	0.00	[empty string]	Vans Berle Pro Skate Shoe, Black/Black/White	<p>The Berle Pro was created with the idea that less is more when it comes to pushing the boundaries of skate progression. Featuring WaffleControl technology, the Berle Pro decreases the number of individual parts separating the foot from the board to deliver next level control, responsiveness, and built-in cushioning. The Berle Pro also includes sturdy canvas and suede uppers, DURACAP reinforcement rubber underlays in high wear areas for unrivaled durability, LuxLiner comfort-enhanced liners, and Vans original waffle outsoles made of a rubber that offers grip and support.</p> <p> </p>	[empty string]	N	80	80	7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27129-DEFAULT-s.jpg	6	1000	VN0A3WKXB8C	383046	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-berle-pro-skate-shoe-black-black-white-383046	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Ether Blue	RVCA	RVCA	MENS	MENS &GT; TOPS &GT; TANK TOPS	26.99	0	26.99	26729-DEFAULT-l.jpg	26	26729-DEFAULT-m.jpg	Ptc Pigment Tank Top	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SLIM	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	RVCA PTC Pigment Tank	<p>WASHED AND WORN, THE RVCA PTC PIGMENT TANK TOP OFFERS A BROKEN-IN QUALITY TO YOUR ESSENTIAL SOLID POCKET TANK. MADE FROM PREMIUM COTTON JERSEY WITH A PIGMENT DYE, THE SOLID T-SHIRT TAKES ON A VINTAGE LOOK AND FEEL, TOPPED WITH TONAL RVCA EMBROIDERY AT THE CHEST POCKET.</p>	[empty string]	N	27	27	Small	26729-DEFAULT-s.jpg	6	1000	M497TRPT	391159	TANK TOPS	EMPTY	EMPTY	0	0	0	TOPS	rvca/rvca-ptc-pigment-tank-391159	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	PENNY	PENNY	MENS	MENS &GT; ACCESSORIES &GT; BACKPACKS	44.99	0	44.99	26421-DEFAULT-l.jpg	44	26421-DEFAULT-m.jpg	Rainbow Bridge Pouch Backpack	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Penny Skataboards Rainbow Bridge Backpack	<p>Easily carry your 22" or 27" Penny with the Rainbow Bridge Backpack. Our specially designed tail pocket makes this backpack the ideal board holder for when your Penny isn't under your feet. Our backpacks also feature a padded laptop sleeve and external pocket for keeping your smaller things organized. The perfect backpack for school days or your next big adventure.</p> <ul> <li>External zippered pull out pouch that supports both 22" & 27" Penny Skateboards.</li> <li>Padded laptop compartment suitable for 15" & below.</li> <li>Padded Tablet sleeve</li> <li>Phone pocket</li> <li>Multiple external & internal pockets</li> <li>Mesh side drink bottle holders</li> <li>Bag Size: 44 cm x 32cm x 14cm</li> <li>Bag Capacity: 20L</li> <li>Durable 600D Polyester Construction</li> </ul>	[empty string]	N	45	45	[empty string]	26421-DEFAULT-s.jpg	8	1000	PNYA013	374215	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skataboards-rainbow-bridge-backpack-374215	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; HATS	25.99	0	25.99	25637-DEFAULT-l.jpg	25	25637-DEFAULT-m.jpg	Retro Mountain Trucker Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	32	25-to-50	0.00	[empty string]	Never Summer Retro Mountain Trucker Hat	<p>The Never Summer Retro Mountain Trucker Hat features a bright Never Summer logo on front and an adjustable snapback. </p>	[empty string]	N	26	26	One Size	25637-DEFAULT-s.jpg	8	1000	HTRETROMESH	374870	HATS	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-retro-mountain-trucker-hat-374870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

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

VON ZIPPER Von Zipper Maxis Sunglasses, Black Gloss/Vintage Grey $110.00 | view details

VANS Vans Berle Pro Skate Shoe, Black/Black/White $80.00 | view details

RVCA Rvca Ptc Pigment Tank $27.00 | view details

PENNY Penny Skataboards Rainbow Bridge Backpack $45.00 | view details

NEVER SUMMER Never Summer Retro Mountain Trucker Hat $26.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

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	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	116	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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	193	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	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	299	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
4	[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	1	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]	2
5	[empty string]	STANCE	STANCE	WOMENS	WOMENS &GT; ACCESSORIES &GT; SOCKS	11.99	0	11.99	25729-DEFAULT-l.jpg	11	25729-DEFAULT-m.jpg	The Fourth Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	53	10-to-15	0.00	[empty string]	Stance The Fourth Classic Crew Sock	<p>Stance is proud to debut a sock as American as apple pie. And while The Fourth's good looks come compliments of Old Glory, its features are decidedly unique. Premium combed cotton, an elastic arch band, and mesh vents keep your feet feeling free.</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	12	12	Medium,Large	25729-DEFAULT-s.jpg	3	1000	M310BTHE-RED	293788	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-the-fourth-classic-crew-sock-293788	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Fuego	BILLABONG	BILLABONG	WOMENS	WOMENS &GT; DRESSES/ROMPERS	49.99	0	49.99	27157-DEFAULT-l.jpg	49	27157-DEFAULT-m.jpg	Follow The Sun Romper	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]	SU19	[empty string]	[empty string]	[empty string]	30	25-to-50	0.00	[empty string]	Billabong Follow The Sun Romper	<p>Flounces have more fun. Ditch structured silhouettes in favor of a flirty one-shoulder neckline, topped with a wide ruffle flounce. The Follow The Sun romper takes the non-traditional silhouette from day to night with a soft rib knit, elastic and tie at the waist and pockets at the front.</p> <p>The nuts and bolts</p> <ul> <li>Rib knit romper.</li> <li>One shoulder ruffle detail.</li> <li>Elastic at natural waist.</li> <li>Front pockets.</li> <li>Scalloped leg. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	49.95	49.95	X-Small,Small,Medium,Large	27157-DEFAULT-s.jpg	4	1000	JN10UBFO	385606	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-follow-the-sun-romper-385606	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

SUN BUM Sun Bum 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 Cocobalm Lip Balm, Groove Berry $3.99 $2.99 | view details

STANCE Stance The Fourth Classic Crew Sock $12.00 | view details

BILLABONG Billabong Follow The Sun Romper $49.95 | 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	Multi	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	27173-DEFAULT-l.jpg	59	27173-DEFAULT-m.jpg	Night Bloom Tali	N	[empty string]	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]	16	50-to-100	0.00	[empty string]	Billabong Night Bloom Tali Girl's Bikini Set	<p>Sunbathing in moon beams and daydreams, the Billabong Night Bloom Tali Set delivers a reversible 2-in-1 style. The mixed print girls bikini features a reversible crossback top for a functional fit (times two)! The bottoms mix up prints with a floral bottom, trimmed with contrast side tabs.</p> <p>The nuts and bolts</p> <ul> <li>Girls reversible bikini set.</li> <li>Reversible top.</li> <li>Tali top that criss crosses at center back and ties for adjustability.</li> <li>Basic tab side pant with contrast print at sides.</li> <li>Pattern: floral print reverses to dot print at top <p> </p> </li> </ul>	[empty string]	N	59.95	59.95	5,7,8,10,12,14	27173-DEFAULT-s.jpg	21	1000	Y214UBNI	385877	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-night-bloom-tali-girls-bikini-set-385877	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	26	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]
3	Multi	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	9.99	0	9.99	25786-DEFAULT-l.jpg	9	25786-DEFAULT-m.jpg	Boy's Desert Dinos 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]	1	5-to-10	0.00	[empty string]	Stance Desert Dinos Boys Kids Crew Sock	<p>Every boy loves dinosaurs. Inspire their inner paleontologist with Stance's Desert Dinos 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	Large	25786-DEFAULT-s.jpg	27	1000	B526D18DES	380115	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-desert-dinos-boys-kids-crew-sock-380115	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Pomegranate	VOLCOM	VOLCOM	KIDS	KIDS &GT; BOYS &GT; TOPS &GT; T-SHIRTS	17.99	0	17.99	27139-DEFAULT-l.jpg	17	27139-DEFAULT-m.jpg	Boys Volcom Panic Ss Tee	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	23	15-to-20	0.00	[empty string]	Volcom Boys Panic Short Sleeve T-Shirt	<p>Sneak a peek at the Volcom Panic Short Sleeve. This basic fit tee has a unique Volcom screen print and its crafted with a heavy weight ring spun cotton fabric.<br /> <br /> Basic fit<br /> Soft hand screen print<br /> Crew neck with contrast interior neck tape<br /> Screen printed neck label</p> <p>100% COTTON</p>	[empty string]	N	18	18	Small,Medium,Large,X-Large	27139-DEFAULT-s.jpg	33	1000	C3511910	383551	TOPS	T-SHIRTS	EMPTY	0	0	0	EMPTY	volcom/volcom-boys-panic-short-sleeve-tshirt-383551	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Royal,Charcoal	BILLABONG	BILLABONG	KIDS	KIDS &GT; BOYS	29.99	0	29.99	26959-DEFAULT-l.jpg	29	26959-DEFAULT-m.jpg	Rotor Pf Ss	N	BOYS	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]	24	25-to-50	0.00	[empty string]	Billabong Rotor Performance Fit Boy's Short Sleeve Rashguard	<p>Round out your performance surf kit with the Rotor Short Sleeve Rashguard for boys. The performance fit Rotor boys rashguard delivers UPF 50+ sun protection with ergonomic seams, custom logo prints and a silky smooth fabric.</p> <p>The nuts and bolts</p> <ul> <li>Boys short sleeve rashguard.</li> <li>Traditional mock neck.</li> <li>Silky-smooth feel.</li> <li>Billabong logo at center chest and sleeve.</li> <li>50+ UPF sun protection.</li> <li>B-Lock super flex stitch.</li> <li>Material: 6 oz silk touch fabric. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	29.95	29.95	2,4,6,8,10,12	26959-DEFAULT-s.jpg	45	1000	BR10TBRO	382429	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-rotor-performance-fit-boys-short-sleeve-rashguard-382429	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	27118-DEFAULT-l.jpg	14	27118-DEFAULT-m.jpg	Boys Neon Tropics Bb Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	Stance Neon Tropics Boys Boxer Brief	<p>Bright, colorful graphics contrasting an all-black background, Boys Neon Tropics is sure to signify his vibrant personality.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief</li> <li>3.5' Inseam Length</li> <li>Feather-Seam™ Construction</li> <li>Exposed Elastic Core-flex™ Waistband</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash Cold</li> <li>Tumble Dry Low</li> </ul>	[empty string]	N	15	15	Small,Medium,Large	27118-DEFAULT-s.jpg	56	1000	B803A19NEN	383919	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-neon-tropics-boys-boxer-brief-383919	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

BILLABONG Billabong Night Bloom Tali Girl's Bikini Set $59.95 | view details

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

STANCE Stance Desert Dinos Boys Kids Crew Sock $10.00 | view details

VOLCOM Volcom Boys Panic Short Sleeve T- Shirt $18.00 | view details

BILLABONG Billabong Rotor Performance Fit Boy's Short Sleeve Rashguard $29.95 | view details

STANCE Stance Neon Tropics Boys Boxer Brief $15.00 | view details

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Violet	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	15.99	0	15.99	25779-DEFAULT-l.jpg	15	25779-DEFAULT-m.jpg	Habana Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	58	15-to-20	0.00	[empty string]	Stance Habana Classic Crew Sock	<p>Spice up your wardrobe, Cuban style, with Habana, a sock with the colors and vibes to keep you in a Caribbean state of mind.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	16	16	Large	25779-DEFAULT-s.jpg	9	1000	M546D18HAB	380091	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-habana-classic-crew-sock-380091	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Premier Black,Classic Mocha	RAINBOW	RAINBOW	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	57.99	0	57.99	19001-DEFAULT-l.jpg	57	19001-DEFAULT-m.jpg	Dbl Layer Wmn Narrow Leather Sandal	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	3	50-to-100	0.00	[empty string]	Rainbow Double Layer Women's Narrow Leather Sandal	<p>If any sandal says Rainbow, this is it! This is the Rainbow Sandals staple, the one your kid stole from you because they wanted to be cool – and you still haven’t gotten it back yet. This is the Flag Ship! <br /> <br /> • Single Layer Arch <br /> • Premier Nubuck 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 premier leather sandal is made with top grade nubuck leather; the top sole is embossed with the Rainbow logo. The strap, also nubuck 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. <br />  </p>	[empty string]	N	57.99	57.99	Small,Large	19001-DEFAULT-s.jpg	16	1000	302ALTSN-WMN	27423	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	rainbow/rainbow-double-layer-womens-narrow-leather-sandal-27423	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	HEY DUDE	HEY DUDE	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	59.99	0	59.99	27043-DEFAULT-l.jpg	59	27043-DEFAULT-m.jpg	Wally Stretch Iron	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]	34	50-to-100	0.00	[empty string]	Hey Dude Wally Stretch Shoe, Iron	<p>When you're stuck in the middle seat, at least your feet will have room to stretch out.</p> <p>Designed to be your favorite shoe for all occasions, Wally embodies the Hey Dude lifestyle by combining your passion for comfort, quality, and fashion. This unique combination allows you to attack each day as a new adventure with the confidence your feet won’t be the reason to slow down. Constructed with leading-edge technology, like the Flex & Fold system, Wally easily is one of the most comfortable and versatile shoes on the market.</p> <p><br /> <strong>SHOE SPECS:</strong></p> <ul> <li><strong>Sizing Tip:</strong> <strong>If you usually wear half sizes, we suggest choosing the next size up for best fit</strong></li> <li>Flex & Fold Technology</li> <li>Ultra-Light outsole</li> <li>Stretch upper</li> <li>Soft oxford cloth lining</li> <li>Memory foam insole</li> <li>Machine washable (cold)</li> <li>5.5 oz. total weight</li> </ul>	[empty string]	N	59.95	59.95	8,9,10,11,12,13,14	27043-DEFAULT-s.jpg	18	1000	150203910	384713	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	hey-dude/hey-dude-wally-stretch-shoe-iron-384713	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Multi	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25758-DEFAULT-l.jpg	13	25758-DEFAULT-m.jpg	Women's Plant Lady 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]	OH at 200	[empty string]	22	10-to-15	0.00	[empty string]	Stance Plant Lady Women's Classic Crew Sock	<p>For those who love floral, we give you Plant Lady, a flower print that will keep your day in full bloom.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Cushioning</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	25758-DEFAULT-s.jpg	20	1000	W525D18PLA	380519	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-plant-lady-womens-classic-crew-sock-380519	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Natural,Brown	RAINBOW	RAINBOW	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	41.99	0	41.99	2983-DEFAULT-l.jpg	41	2983-DEFAULT-m.jpg	Hemp Sandal	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	27	25-to-50	0.00	[empty string]	Rainbow Single Layer Hemp Top and Strap Women's Sandal	<p>Hemp, a plant whose strong fibers are used to make this naturally durable fabric is one of our most laid back sandals. Slip a pair on and you’ll be what’s hempinin’</p> <p> </p> <p>• Natural Hemp Top Sole</p> <p>• Single Layer Arch</p> <p>• Hemp Strap</p> <p>• Bonded Nylon Thread</p> <p>• Box X Toe Construction</p> <p>• Triple Glued</p> <p>• Non-Slip Bottom Sole</p> <p>• Original Rainbow Woven Label</p> <p> </p> <p>This sandal features a hemp top sole and strap. Both are double stitched with bonded nylon thread, only the best materials are used to guarantee the thread won’t fray or pull out.</p> <p> </p> <p>The structure is our famous single layer midsole with an arch support and a durable box X stitch pattern at the nylon toe piece.</p> <p> </p> <p>The bottom sole is our non-slip Rainbow bottom. The sandal is finished off with the Original Woven label on the right strap.</p> <p> </p>	[empty string]	N	41.99	41.99	Small,Medium,Large,X-Large,11	2983-DEFAULT-s.jpg	22	1000	301AHTS-WMN	190420	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	rainbow/rainbow-single-layer-hemp-top-and-strap-womens-sandal-190420	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Blue,Violet	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25728-DEFAULT-l.jpg	13	25728-DEFAULT-m.jpg	Check Me Out Socks	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	56	10-to-15	0.00	[empty string]	Stance Check Me Out Classic Crew Socks	<p>Everyone loves checkers. Add a little to your wardrobe with Stance's Check Me Out, a classic checkered design that fits with any style.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25728-DEFAULT-s.jpg	31	1000	M556D18CHE	380205	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-check-me-out-classic-crew-socks-380205	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

STANCE Stance Habana Classic Crew Sock $16.00 | view details

RAINBOW Rainbow Double Layer Women's Narrow Leather Sandal $57.99 | view details

HEY DUDE Hey Dude Wally Stretch Shoe, Iron $59.95 | view details

STANCE Stance Plant Lady Women's Classic Crew Sock $14.00 | view details

RAINBOW Rainbow Single Layer Hemp Top And Strap Women's Sandal $41.99 | view details

STANCE Stance Check Me Out Classic Crew Socks $14.00 | view details

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; LONGBOARD DECKS	109.99	0	109.99	26955-DEFAULT-l.jpg	109	26955-DEFAULT-m.jpg	Axis 40 Photo Deck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Arbor Axis 40 Photo Longboard Deck, 40"	<p>A snowboard-inspired drop-through for easy around town cruising, relaxed commutes, and mellow downhill.</p> <p> </p>	[empty string]	N	109.95	109.95	[empty string]	26955-DEFAULT-s.jpg	3	1000	ARBDL40003	393654	LONGBOARD DECKS	EMPTY	EMPTY	0	0	0	LONGBOARDS	arbor/arbor-axis-40-photo-longboard-deck-40-393654	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	10	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]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	179.99	0	179.99	26954-DEFAULT-l.jpg	179	26954-DEFAULT-m.jpg	Zeppelin Flagship Red Gum 18 Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Arbor Zeppelin Flagship Complete Longboard, 32"	<p>A performance mid-length drop-through shape for an exceptional carving experience and float through your turns.</p> <h4>DECK</h4> <ul> <li>7 Ply Hardrock Maple with a Premium Red Gum Wood Finish Ply</li> <li>Wood material comes from sustainable sources of supply</li> <li>Wood by-product is reclaimed for use in other products</li> </ul> <h4>TRUCKS</h4> <ul> <li>Paris Reverse 50° 180mm</li> </ul> <h4>TRUCKS</h4> <ul> <li>Arbor Easyrider Series - Mosh</li> <li>Perfect mix between quick acceleration and roll speed</li> <li>Good for cruising and carving on all size boards</li> <li>Size: 65mm // Durometer: 78a</li> <li>Contact Patch: 36.0mm // Offset: 0.0mm</li> <li>Momentum Core: Dampens bumpy rides</li> <li>Venice Formula: Soft and grippy</li> </ul> <h4>OTHER COMPONENTS</h4> <ul> <li>ABEC 7 Bearings with Spacers</li> <li>Recycled Glass Re-Grit</li> </ul>	[empty string]	N	179.95	179.95	32IN	26954-DEFAULT-s.jpg	53	1000	ARBL32002	393648	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	arbor/arbor-zeppelin-flagship-complete-longboard-32-393648	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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]	9	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	59	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]
5	[empty string]	MADNESS	MADNESS	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	54.99	0	54.99	27055-DEFAULT-l.jpg	54	27055-DEFAULT-m.jpg	Kreiner Expanded R7 8.25 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 Expanded Clay R7 Skateboard Deck, 8.25"	<p>MADNESS Expanded Clay 8.25 R7 Skateboard Deck<br /> <em>Resin-7 Canadian Maple Construction </em><br /> <em>Width: 8.25" / Length: 32.1" / Wheelbase: 14.25"</em><br /> Medium Concave / Steep Kick</p>	[empty string]	N	54.99	54.99	8.25	27055-DEFAULT-s.jpg	62	1000	10076021	392540	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	madness/madness-expanded-clay-r7-skateboard-deck-825-392540	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	26744-DEFAULT-l.jpg	39	26744-DEFAULT-m.jpg	F4 99 Overlay Radials Pnk/Blu Whl 4- 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]	[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, 54mm	<p>Spitfire Formula Four 99D Overlay Pink/Blue Mashup Skateboard Wheels, 54mm</p>	[empty string]	N	39.99	39.99	54MM	26744-DEFAULT-s.jpg	72	1000	2111019054	391808	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-pink-blue-mashup-skateboard-wheels-54mm-391808	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

ARBOR Arbor Axis 40 Photo Longboard Deck, 40 " $109.95 | view details

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

ARBOR Arbor Zeppelin Flagship Complete Longboard, 32 " $179.95 | view details

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

MADNESS Madness Expanded Clay R7 Skateboard Deck, 8.25 " $54.99 | view details

SPITFIRE Spitfire Formula Four 99d Overlay Pink/Blue Mashup Skateboard Wheels, 54mm $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	Vintage Blue,Charcoal Heather	VOLCOM	VOLCOM	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	34.99	0	34.99	26940-DEFAULT-l.jpg	34	26940-DEFAULT-m.jpg	Lido Heather Ss Surf Tee	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]	42	25-to-50	0.00	[empty string]	Volcom Lido Heather Short Sleeve Rashguard	<p>If tight fitting clothing isn't your cup of tea the Lido Heather short sleeve rash guard steps up. Made of hybrid jersey fabric, the fit comes off as more of a t-shirt but still offers the protection you need. <br /> <br /> Loose fit rash guard<br /> Hybrid jersey fabric<br /> 30+ UV protection</p>	[empty string]	N	35	35	Small,Medium,Large,X-Large,XX-Large	26940-DEFAULT-s.jpg	14	1000	N0111901	383488	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	volcom/volcom-lido-heather-short-sleeve-rashguard-383488	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	46.99	0	46.99	4570-DEFAULT-l.jpg	46	4570-DEFAULT-m.jpg	Double Soft Racks Cam Lock	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	FCS Cam Lock Soft Racks Double	<p>Simple and strong, the FCS Cam Lock system will efficiently strap your boards down.</p>	[empty string]	N	46.98	46.98	[empty string]	4570-DEFAULT-s.jpg	18	1000	1900-553-00B	210621	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-cam-lock-soft-racks-double-210621	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	119.99	0	119.99	26275-DEFAULT-l.jpg	119	26275-DEFAULT-m.jpg	F6 Honeycomb Quad Set	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 F6 Honeycomb Thruster Fins	<p>The F6 Honeycomb is a medium size Balanced fin with a Ride Number of 5.3. This set is a scaled up version of our popular F4 template. The F6 Honeycomb's subtle flex pattern creates the perfect amount of drive and the slightly refined tip provides for additional release off of the top. A great go-to set for medium sized surfers.</p> <div class="panel-group pdt-detail-panel" id="accordion" style="box-sizing:border-box; margin-bottom:20px"> <div class="each-panel-pdt panel panel-default" style="border-bottom:1px solid #dddddd; border-image:initial; border-left:none; border-radius:0px; border-right:none; border-top:none; box-shadow:none; box-sizing:border-box; margin-bottom:0px; margin-top:0px !important"> <div class="collapse in panel-collapse" id="collapse2" style="box-sizing:border-box; display:block"> <div class="panel-body" style="border-top:1px solid #dddddd; box-sizing:border-box; padding:17px 0px !important"> <div class="specification" style="box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-weight:normal; line-height:25px"> <table cellspacing="0" class="specf-table" style="background-color:transparent; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; width:537.6px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> <th style="text-align:left">Center Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.12</td> <td>15.12</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.56</td> <td>4.56</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.35</td> <td>4.35</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table> </div> </div> </div> </div> </div>	[empty string]	N	120	120	[empty string]	26275-DEFAULT-s.jpg	29	1000	1165-130-40	376929	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-f6-honeycomb-thruster-fins-376929	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Coal,White,Cobalt	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	27.99	0	27.99	25627-DEFAULT-l.jpg	27	25627-DEFAULT-m.jpg	6 ` Reg 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]	OH at 200	[empty string]	9	25-to-50	0.00	[empty string]	FCS Regular Essential Leash - 6'	<p>Day-to-day performance and ?reliability in a wide range of conditions.</p>	[empty string]	N	28	28	[empty string]	25627-DEFAULT-s.jpg	40	1000	2020-06F	374704	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-regular-essential-leash-6-374704	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	59.99	0	59.99	6193-DEFAULT-l.jpg	59	6193-DEFAULT-m.jpg	Changing Towel Poncho Black	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]	3	50-to-100	0.00	[empty string]	FCS Poncho	<p>Make changing in public places cozy and easy. </p>	[empty string]	N	60	60	[empty string]	6193-DEFAULT-s.jpg	41	1000	11021	257944	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-poncho-257944	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Irons Black,GRNT,Carbon,Resin,CBN/PNK,Scout	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	23.99	0	23.99	25886-DEFAULT-l.jpg	23	25886-DEFAULT-m.jpg	5 ` Pro Comp 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]	22	20-to-25	0.00	[empty string]	Dakine Procomp 5' X 3/16" Surf Leash	<p>The Procomp surf leash offers the maximum strength possible with minimal resistance for up to shoulder high surf. This everyday leash will keep your board safely attached with the least drag possible thanks to the strong 3/16-inch urethane Dura-Cord. Dakine's longtime history innovating surf leashes is apparent in the use of marine grade stainless steel swivels, a 1.5-inch molded neoprene cuff, and Opti-Flex leash ends which combine for a super efficient, comfortable and durable leash. The Procomp is offered in both 5- and 6-foot lengths.</p> <ul> <li>Up to a shoulder high intended use</li> <li>3/16" (5MM) highest quality urethane Dura-Cord for maximum strength</li> <li>1.5" (40MM) molded neoprene ankle cuff</li> <li>Posi-Lock hook & loop closure</li> <li>Redesigned molded Opti-Flex leash ends for maximum durability</li> </ul>	[empty string]	N	24	24	[empty string]	25886-DEFAULT-s.jpg	43	1000	10001100	350989	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dakine/dakine-procomp-5-x-3-16-surf-leash-350989	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

VOLCOM Volcom Lido Heather Short Sleeve Rashguard $35.00 | view details

FCS Fcs Cam Lock Soft Racks Double $46.98 | view details

FUTURE FINS Futures F6 Honeycomb Thruster Fins $120.00 | view details

FCS Fcs Regular Essential Leash - 6 ' $28.00 | view details

FCS Fcs Poncho $60.00 | view details

DAKINE Dakine Procomp 5 ' X 3/16 " Surf Leash $24.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	Black	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; MEN'S OUTERWEAR &GT; JACKETS	91.99	0	91.99	26082-DEFAULT-l.jpg	91	26082-DEFAULT-m.jpg	Corporate Zip Soft Shell Jacket	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	50-to-100	0.00	[empty string]	Never Summer Corporate Zip Soft Shell Jacket	<p>Never Summer Corporate Zip Soft Shell Jacket</p>	[empty string]	N	89.99	91.99	X-Large,XX-Large	26082-DEFAULT-s.jpg	3	1000	ZIPCORPSS	374781	MENS OUTERWEAR	JACKETS	EMPTY	0	0	0	OUTERWEAR	never-summer/never-summer-corporate-zip-soft-shell-jacket-374781	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Carbon/Black	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	59.99	0	59.99	25534-DEFAULT-l.jpg	59	25534-DEFAULT-m.jpg	Boot Locker 69l	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FBA FILLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	SMU	2018	[empty string]	OH at 200	[empty string]	2	50-to-100	0.00	[empty string]	Dakine Boot Locker 69L, Snowboard and Ski Boot Bag, Carbon	<p>There is no simpler solution to keeping your whole winter kit together and ready to go. The Boot Locker offers tons of volume up top for jackets, extra layers, spare gloves and a helmet, while the tarp-lined bottom compartment is great at keeping your boots warm and dry on the way up the mountain and separate from everything else on the way down.</p>	[empty string]	N	60	60	[empty string]	25534-DEFAULT-s.jpg	12	1000	08300480-BC	346884	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-boot-locker-69l-snowboard-and-ski-boot-bag-carbon-346884	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Churn	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25549-DEFAULT-l.jpg	19	25549-DEFAULT-m.jpg	Churn 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]	24	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Churn	<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]	25549-DEFAULT-s.jpg	17	1000	F1132	382027	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-churn-382027	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Cream,Alloy	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	11.99	0	11.99	25834-DEFAULT-l.jpg	11	25834-DEFAULT-m.jpg	Pyramid Stud	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	46	10-to-15	0.00	[empty string]	Dakine Pyramid Studs Stone Stomp Pad	<p>Studs and stomp pads aren't always necessary, but when you need them, you want to know they're going to work. Our Pyramid Studs are perfect for giving you reliable footing with your free foot, without taking up a ton of space on your board. The sturdy plated aluminum features a simple peel and stick adhesive backing, so you can personalize your setup. Each pack of 9 is available in a black, brass, or chrome finish.</p>	[empty string]	N	12	12	[empty string]	25834-DEFAULT-s.jpg	18	1000	10001555-H	357739	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-pyramid-studs-stone-stomp-pad-357739	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	529.99	0	529.99	26346-DEFAULT-l.jpg	529	26346-DEFAULT-m.jpg	Shaper Twin	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	8	500-and-over	0.00	[empty string]	Never Summer Shaper Twin Snowboard, 2019	<p>Introducing the newest member of the Shaper Series...the Fusion Rocker Camber SHAPER TWIN. Born a mutant, with 10mm of taper, a centered stance, premier switch ride-ability, and insane park performance the Shaper Twin is dominating the Freestyle Twin Category. A balanced and exceptional performance in every terrain ventured. In the tail we built Ripsaw Rocker Camber so you get trench digging edge hold, snap out of turns, and huge pop. In the nose we placed Original Rocker Camber for insane float and a surfy feel. It’s a nuclear fusion of profiles. We’ve dedicated the 153CC Shaper Twin to Chris Corning who says #BestBoardEverBuilt LT - Narrower version of the original.</p>	[empty string]	N	529.99	529.99	151,156,159,161	26346-DEFAULT-s.jpg	22	1000	SHAPER-I	374689	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-shaper-twin-snowboard-2019-374689	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VON ZIPPER	VON ZIPPER	SNOWBOARDING	SNOWBOARDING &GT; GOGGLES	59.99	0	59.99	25982-DEFAULT-l.jpg	59	25982-DEFAULT-m.jpg	Encore White Satin/Blackout	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Von Zipper Encore Ski/Snowboard Goggle, White Satin/Wildlife Blackout	<p><strong>Story:</strong> Just when you thought your on-snow performance couldn’t get any better, the encore goggle is a final act that plays to a standing ovation. You’ll cheer for more in this medium-sized frame made of thermo-poly urethane that brings down the house by remaining flexible in all conditions. Cries of bravo are had for the dual layered, anti-fog cylindrical lens that outdoes itself by offering a wide field of peripheral vision. The tri-density face foam generates hoots and hollers of comfort and moisture wicking that will leave you amazed well after the house lights come on. Do it one more time and take a bow in this winter time show closer.</p> <p><strong>Specifications:</strong> <br /> / Rimless Frame Design <br /> / Helmet Compatible <br /> / Exceptional Peripheral Vision <br /> / Thermo-Polyurethane Injection Molded Frame <br /> / Cylindrical Polycarbonate Dual Lens <br /> / 100% UV Protection <br /> / Glaricade Anti-Fog And Hard Coated Lens <br /> / Polar Fleece Lined, Triple Density Facefoam <br /> / Dual Adjustable Strap</p> <p><strong>Also in the box:</strong> <br /> / Dual Sleeve Microfiber Bag</p>	[empty string]	N	60	60	[empty string]	25982-DEFAULT-s.jpg	24	1000	GMSNQENC-WBO	374541	EMPTY	EMPTY	EMPTY	0	0	0	GOGGLES	von-zipper/von-zipper-encore-ski-snowboard-goggle-white-satin-wildlife-blackout-374541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Corporate Zip Soft Shell Jacket $89.99 to $91.99 | view details

DAKINE Dakine Boot Locker 69l, Snowboard And Ski Boot Bag, Carbon $60.00 | view details

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

DAKINE Dakine Pyramid Studs Stone Stomp Pad $12.00 | view details

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

VON ZIPPER Von Zipper Encore Ski/Snowboard Goggle, White Satin/Wildlife Blackout $60.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	DOTBLUECAMO	FISHMASKS	FISHMASKS	ACCESSORIES	ACCESSORIES &GT; FACEMASKS	19.99	0	19.99	26201-DEFAULT-l.jpg	19	26201-DEFAULT-m.jpg	Dot Blue Camo Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	42	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Dot Camo Blue	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	<p>Fishmasks Single Layer Neck Gaiter - Lightweight, Fishing Protection From Sun, Wind And Moisture - Made In USA - UPF 50+ Moisture-Wicking Fabric - Dot Camo Blue</p>	N	19.99	19.99	[empty string]	26201-DEFAULT-s.jpg	1	1000	FSH-SL-DOTBLUECAMO	359384	EMPTY	EMPTY	EMPTY	0	0	0	FACEMASKS	fishmasks/fishmasks-single-layer-neck-gaiter-dot-camo-blue-359384	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Silverton,Coral Reef,Melbourne,Waimea,NIGHTFLOWER,PASTEL,THUNDERDOT	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; PURSES	14.99	0	14.99	25841-DEFAULT-l.jpg	14	25841-DEFAULT-m.jpg	Wmns Jive Cross Body Purse	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]	51	10-to-15	0.00	[empty string]	Dakine Jive Women's Handbag	<p>Our popular Jive purse is made to go wherever you go. The wide crossbody strap fits comfortably and securely holds the purse close to your body, while the mid-volume capacity is just the right size to hold all your essential - not too bulky and not too small. An interior zippered pocket holds smaller loose items. The Jive comes in an array of colors and patterns to match your personality.</p>	[empty string]	N	15	15	[empty string]	25841-DEFAULT-s.jpg	2	1000	08220095-I	372511	EMPTY	EMPTY	EMPTY	0	0	0	PURSES	dakine/dakine-jive-womens-handbag-372511	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	3	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]
4	Black Heather	QUIKSILVER	QUIKSILVER	ACCESSORIES	ACCESSORIES &GT; HATS	34.99	0	34.99	26656-DEFAULT-l.jpg	27	26656-DEFAULT-m.jpg	Sidestay Flexfit 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	25-to-50	0.00	[empty string]	Quiksilver Sidestay Flexfit® Hat	<ul> <li>Flexfit® X-Fit</li> <li>6 panel Flexfit® design</li> <li>Suiting fabrics</li> <li>Offset Quiksilver embroidery on front</li> </ul> <p>Composition</p> <ul> <li> <p>81% Polyester, 17% Viscose, 2% Elastane / 87% Acrylic, 11% Wool, 2% Elastane</p> </li> </ul>	[empty string]	N	28	28	Small/Medium,Large/X-Large	26656-DEFAULT-s.jpg	3	1000	AQYHA04121	383366	EMPTY	EMPTY	EMPTY	0	0	0	HATS	quiksilver/quiksilver-sidestay-flexfit-hat-383366	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Navy,Black	BILLABONG	BILLABONG	ACCESSORIES	ACCESSORIES &GT; HATS	29.99	0	29.99	26565-DEFAULT-l.jpg	29	26565-DEFAULT-m.jpg	Plateau Snapback Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Billabong Plateau Snapback Hat	<p>Cut to clean lines with this glassed-off snap back hat. Made form cotton twill, the 6-panel snap back keeps a modern, minimalist aesthetic with a semi-flat bill and print-bordered Die Cut logo patch at the front.</p> <ul> <li>Twill snapback hat.</li> <li>6 panel design.</li> <li>Snap back.</li> <li>Slightly curved bill.</li> <li>Printed patch or woven label at front.</li> <li>Flag label at back.</li> <li>Adjustable size.</li> </ul>	[empty string]	N	29.95	29.95	[empty string]	26565-DEFAULT-s.jpg	4	1000	MAHWTBPL	382708	EMPTY	EMPTY	EMPTY	0	0	0	HATS	billabong/billabong-plateau-snapback-hat-382708	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	25662-DEFAULT-l.jpg	124	25662-DEFAULT-m.jpg	The Rival White/Charcoal	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Nixon The Rival 38mm Watch, White/Charcoal	<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]	25662-DEFAULT-s.jpg	7	1000	A12362015	375186	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-the-rival-38mm-watch-white-charcoal-375186	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]