Dive

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	NIXON	NIXON	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	99.99	0	99.99	25656-DEFAULT-l.jpg	99	25656-DEFAULT-m.jpg	Time Teller All Black/Dark Blue	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	50-to-100	0.00	[empty string]	Nixon Time Teller 37mm Watch, All Black/Dark Blue	<p>Clean lines cut through cloudy philosophy, while its simple, high concept design keeps things precise.</p>	[empty string]	N	100	100	[empty string]	25656-DEFAULT-s.jpg	3	1000	A0452668	376187	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-time-teller-37mm-watch-all-black-dark-blue-376187	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Natural,Black	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	26767-DEFAULT-l.jpg	13	26767-DEFAULT-m.jpg	Nambung Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	17	10-to-15	0.00	[empty string]	Stance Nambung Butter Blend Crew Sock	<p>Not just another walk in the park, the stripes of Nambung offer traditional southwestern style in an offset striped motif.</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	26767-DEFAULT-s.jpg	4	1000	M556A19NAM	383808	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-nambung-butter-blend-crew-sock-383808	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	9.99	0	9.99	26203-DEFAULT-l.jpg	9	26203-DEFAULT-m.jpg	Halyard Wire Retainer Red/Blue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Costa Del Mar Haylard Wire Retainer, Red/Blue	<p><strong>DESCRIPTION:</strong><br /> Halyard Wire Retainer.</p> <p><strong>FEATURES</strong><br /> Ultra-Thin<br /> Lightweight Wire<br /> Heavy Duty Grip</p> <p>End-to-End Measurement: 20"</p>	[empty string]	N	9.99	9.99	[empty string]	26203-DEFAULT-s.jpg	5	1000	HY27	363723	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	costa-del-mar/costa-del-mar-haylard-wire-retainer-red-blue-363723	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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/Khaki	ARCADE	ARCADE	MENS	MENS &GT; ACCESSORIES	25.99	0	25.99	25914-DEFAULT-l.jpg	25	25914-DEFAULT-m.jpg	The Blackwood Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Arcade Blackwood Belt, Black/Khaki	<p>The Arcade Blackwood is a lightweight, low-profile belt built for outdoor adventures. Elastic stretch webbing gives you a superior fit and ultimate comfort. A micro-adjust belt buckle gives this Adventure belt one size fits all sizing. No metal means airport security becomes a breeze. Made with machine washable materials, just leave the belt in your jeans through the wash and dry cycles.</p> <ul> <li>One size fits most, up to 40″ (101.6cm)</li> <li>Travel-Friendly</li> <li>Washer/Dryer safe</li> <li>Belt width – 1.5″ (3.81cm)</li> </ul>	[empty string]	N	26	26	[empty string]	25914-DEFAULT-s.jpg	5	1000	A11301-81	373342	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-blackwood-belt-black-khaki-373342	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Khaki,Indigo,Dark Ozone,Dark Olive,Chino,Hazel,Sage	BILLABONG	BILLABONG	MENS	MENS &GT; BOTTOMS &GT; SHORTS	54.99	0	54.99	26090-DEFAULT-l.jpg	54	26090-DEFAULT-m.jpg	New Order X Overdye Sub 19 ` Walkshort	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	SU18	[empty string]	[empty string]	[empty string]	147	50-to-100	0.00	[empty string]	Billabong New Order X Overdye Submersibles Shorts	<p>A modern hybrid short with a well-worn fade. The over-dyed New Order X combines Billabong boardshort technology with vintage chino short design. Constructed with recycled PCX stretch fabric, this pair is built to perform equally well in the water as they do on land.</p> <p>The nuts and bolts</p> <ul> <li> <p>Hybrid shorts / boardshorts.</p> </li> <li>Chino styling.</li> <li>PCX recycled stretch fabric with over-dyed finish.</li> <li>Cotton stretch blend combines the breathable softness of cotton with the performance of polyester.</li> <li>Micro Repel water repellent coating keeps fabric light and quick drying.</li> <li>Side pockets.</li> <li>Back welt pockets with zippered closure at right pocket</li> <li>Mesh pocket bags.</li> <li>External die cut heat transfer label above back right pocket.</li> <li>Welded logo on bottom left leg hem.</li> <li>Zip/button closure.</li> <li>Mid Length - Core Fit: 19 inch outseam.</li> <li>Material: cotton blend recycler stretch fabric.</li> </ul>	[empty string]	N	54.95	54.95	28,29,30,31,32,33,34,36,38,40	26090-DEFAULT-s.jpg	9	1000	M209NBNO	364877	SHORTS	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-new-order-x-overdye-submersibles-shorts-364877	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	SUN BUM	SUN BUM	MENS	MENS &GT; ACCESSORIES &GT; SUNSCREEN AND SKINCARE	17.99	0	17.99	25587-DEFAULT-l.jpg	17	25587-DEFAULT-m.jpg	Mineral Spf 30 Spray	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]	168	15-to-20	0.00	[empty string]	Sun Bum Mineral SPF 30 Sunscreen Lip Balm	<p>Some of us like to go as au naturel as possible, so we’re really proud to introduce our new zinc-based Mineral collection for your lounging and earth loving pleasure. Broad spectrum, zinc based Mineral Sunscreen Lip Balm SPF 30 is made of safe minerals to protect from UVA/UVB rays and moisturize lips. With soothing shea butter and vitamin e, provides excellent physical protection from the sun, wind and cold.</p>	[empty string]	N	17.99	17.99	[empty string]	25587-DEFAULT-s.jpg	13	1000	20-62230	377102	SUNSCREEN AND SKINCARE	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-mineral-spf-30-sunscreen-lip-balm-377102	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

NIXON Nixon Time Teller 37mm Watch, All Black/Dark Blue $100.00 | view details

STANCE Stance Nambung Butter Blend Crew Sock $14.00 | view details

COSTA DEL MAR Costa Del Mar Haylard Wire Retainer, Red/Blue $9.99 | view details

ARCADE Arcade Blackwood Belt, Black/Khaki $26.00 | view details

BILLABONG Billabong New Order X Overdye Submersibles Shorts $54.95 | view details

SUN BUM Sun Bum Mineral Spf 30 Sunscreen Lip Balm $17.99 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	139	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	23	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	25578-DEFAULT-l.jpg	5	25578-DEFAULT-m.jpg	Sunset Cove Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	146	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sunset Cove	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25578-DEFAULT-s.jpg	278	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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	554	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]	NIXON	NIXON	WOMENS	WOMENS &GT; 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	3	1000	A1236001	375182	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	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]	2
5	Aquifer,Salmon,Inca Gold	ROXY	ROXY	WOMENS	WOMENS &GT; ACCESSORIES &GT; HATS	27.99	0	27.99	26681-DEFAULT-l.jpg	27	26681-DEFAULT-m.jpg	Next Level Dad Hat	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]	SP19	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Roxy Next Level Baseball Hat	<ul> <li><strong>Fabric:</strong> Cotton twill fabric</li> <li><strong>Construction:</strong> Adjustable back closure</li> <li>Embroidery on front</li> <li><strong>Visor/Brim:</strong> Curved visor</li> <li>Circular metal ROXY plaque</li> <li><strong>Size:</strong> OSFM = 22" / 56 cm Ø</li> </ul> <p>Composition</p> <ul> <li> <p>100% Cotton</p> </li> </ul>	[empty string]	N	28	28	[empty string]	26681-DEFAULT-s.jpg	8	1000	ERJHA03542	388757	HATS	EMPTY	EMPTY	0	0	0	EMPTY	roxy/roxy-next-level-baseball-hat-388757	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
6	[empty string]	G-SHOCK	G-SHOCK	WOMENS	WOMENS &GT; ACCESSORIES &GT; WATCHES	149.99	0	149.99	26295-DEFAULT-l.jpg	149	26295-DEFAULT-m.jpg	Ga710gb Black Gold	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	G-Shock Analog-Digital Watch, Black/Gold	<p>From G-SHOCK, the watch brand that is constantly setting new standards for timekeeping toughness, come new models with garish coloring. The base model is the GA-700, which uses original resin molding technology that makes it possible to form analog hands, dial, and hour markers of resin that shines like metal. This lineup is available in a choice of three colors (blue, silver, gold) that create the image of the accessories or fashion items worn by b-boys. The black and blue, and black and silver models have a half-matte finish for a look that is totally cool. The black and gold model has an overall shiny finish for a tough and energetic look.</p> <ul style="margin-left:0px; margin-right:0px"> <li>Case / bezel material: Resin</li> <li>Resin Band</li> <li>Shock Resistant</li> <li>Mineral Glass</li> <li>200-meter water resistance</li> <li>LED light (Super illuminator)</li> </ul>	[empty string]	N	150	150	[empty string]	26295-DEFAULT-s.jpg	11	1000	GA710GB-1A	379768	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	g-shock/gshock-analogdigital-watch-black-gold-379768	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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, Sunset Cove $5.99 $3.99 | view details

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

NIXON Nixon The Rival 38mm Watch, All Black $125.00 | view details

ROXY Roxy Next Level Baseball Hat $28.00 | view details

G-SHOCK G- Shock Analog- Digital Watch, Black/Gold $150.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	Multi	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	26769-DEFAULT-l.jpg	13	26769-DEFAULT-m.jpg	Boy's Grateful Sock	N	BOYS	[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]	SP19	[empty string]	[empty string]	[empty string]	46	10-to-15	0.00	[empty string]	Stance Grateful Dead Kids Crew Sock	<p>For those who've only just recently embarked on that long, strange journey ahead, make their first few steps as comfortable and stylish as possible. They'll be forever Grateful.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Small,Medium,Large	26769-DEFAULT-s.jpg	2	1000	K545A19GRA	383812	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-grateful-dead-kids-crew-sock-383812	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Fog Blue/Multi	ARCADE	ARCADE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	17.99	0	17.99	25902-DEFAULT-l.jpg	17	25902-DEFAULT-m.jpg	The Rambler Youth Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	15-to-20	0.00	[empty string]	Arcade Rambler Youth Belt	<p>Everything Arcade is known for in a kid-sized package, meet the Arcade Rambler LTD  youth adventure belt. A fully adjustable minimal buckle is perfect for growing kids and smaller belt loops. Elastic stretch webbing means your kiddo stays comfortable all day and their pants stay where they’re supposed to. Made from machine friendly and quick drying materials means clean up is a breeze for messy kids. Sized for kids ages 4-12.</p> <ul> <li>Kid-friendly</li> <li>Machine washable</li> <li>Travel-Friendly</li> <li>Belt width – 1.25″ (3.17cm)</li> <li>Fits up to 32″/81.3cm</li> </ul>	[empty string]	N	18	18	[empty string]	25902-DEFAULT-s.jpg	42	1000	Y14300-94	384917	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	arcade/arcade-rambler-youth-belt-384917	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	25770-DEFAULT-l.jpg	9	25770-DEFAULT-m.jpg	Boy's Palm Breeze 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]	OH at 200	[empty string]	8	5-to-10	0.00	[empty string]	Stance Palm Breeze Boys Kids Classic Crew Sock	<p>They want a beach day. Bring the beach to them with the island vibes of Palm Breeze 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	25770-DEFAULT-s.jpg	52	1000	B526D18PAL	380123	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-palm-breeze-boys-kids-classic-crew-sock-380123	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	55	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	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	54.99	0	54.99	25714-DEFAULT-l.jpg	54	25714-DEFAULT-m.jpg	Slip- On Pro Checkerboard Black/Wh	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]	35	50-to-100	0.00	[empty string]	Vans Slip-On Pro Skate Shoe, Checkerboard Black/White	<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	55	55	4,4.5,5,5.5,6.5,7.5,8,8.5,9.5,10,10.5,11,11.5,12,13	25714-DEFAULT-s.jpg	68	1000	VN0A347VAPK	378486	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-slipon-pro-skate-shoe-checkerboard-black-white-378486	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	74.99	0	74.99	25715-DEFAULT-l.jpg	74	25715-DEFAULT-m.jpg	Authentic Uc (Made For The Makers) Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLACK	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	32	50-to-100	0.00	[empty string]	Vans Made For The Makers Old Skool UC Shoe, Black	<p>The Made For The Makers collection features tough shoes for tough jobs, and the creative communities around them. Whether you're an artist, surfboard shaper, barber, or tattoo artist, Made For The Makers was built for maximum comfort so you can do what you love all day. With vulcanized lugged outsoles, the Old Skool UC also includes 8 oz Vansguard canvas and suede uppers to repel liquids and dirt, contoured drop-in UltraCush sockliners for long-lasting comfort, and padded collars for support and flexibility.</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	4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,10.5,11,12,13	25715-DEFAULT-s.jpg	76	1000	VN0A3MU8QBX	366078	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-made-for-the-makers-old-skool-uc-shoe-black-366078	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Grateful Dead Kids Crew Sock $14.00 | view details

ARCADE Arcade Rambler Youth Belt $18.00 | view details

STANCE Stance Palm Breeze Boys Kids Classic Crew Sock $10.00 | view details

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

VANS Vans Slip- On Pro Skate Shoe, Checkerboard Black/White $55.00 | view details

VANS Vans Made For The Makers Old Skool Uc Shoe, Black $75.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]	DC	DC	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	74.99	0	74.99	26607-DEFAULT-l.jpg	74	26607-DEFAULT-m.jpg	Net Se 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]	BLK/WHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	DC Court Graffik SE Skate Shoes, Black/Black/White	<p>The nuts and bolts</p> <ul> <li>Leather or textile upper materials</li> <li>Lightweight mesh tongue</li> <li>Foam padded tongue and collar for added comfort and support</li> <li>Ventilation holes for breathability</li> <li>DC's trademarked Pill Pattern tread</li> <li>Cupsole construction</li> </ul>	[empty string]	N	75	75	9,9.5,10,10.5,11,11.5,12,13	26607-DEFAULT-s.jpg	5	1000	302297-XKKW	382988	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-court-graffik-se-skate-shoes-black-black-white-382988	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	69.99	0	69.99	26791-DEFAULT-l.jpg	69	26791-DEFAULT-m.jpg	Comfycush Old Skool Black/True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	70	50-to-100	0.00	[empty string]	Vans ComfyCush Old Skool Skate Shoe	<p>Vans has reinvigorated the classic Old Skool by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Old Skool a first-class fit that feels like walking on a cloud. Newly constructed canvas and suede uppers house simplified one-piece interiors with added arch support and new moisture-wicking lining throughout, resulting in a lightweight experience that assures you’ll Keep It Comfy at all times.</p>	[empty string]	N	70	70	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	26791-DEFAULT-s.jpg	7	1000	VN0A3WMAVNE	383081	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-comfycush-old-skool-skate-shoe-383081	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Maroon	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25797-DEFAULT-l.jpg	13	25797-DEFAULT-m.jpg	Haena 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]	37	10-to-15	0.00	[empty string]	Stance Haena Classic Crew Sock	<p>Lounging in a hammock with an ocean breeze at your back sound good? Bring the beach to you with Stance's Haena, a warm design that can't help but mellow your mind.</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	25797-DEFAULT-s.jpg	11	1000	M556D18HAE	380087	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-haena-classic-crew-sock-380087	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	eXpresso,Sierra,Dark Brown,Premier Black,Classic Tan/Blue,CTAN/BRN,CBLK,CLMOCHA	RAINBOW	RAINBOW	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	57.99	0	57.99	8625-DEFAULT-l.jpg	57	8625-DEFAULT-m.jpg	Double Layer Leather Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	Z	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	185	50-to-100	0.00	[empty string]	Rainbow Double Layer Leather Men's Sandal	<p>The double layer classic leather sandal offers all the great features found in our single layer leather, but with an added layer of midsole for more arch support. <br /> <br /> • Double Layer Classic Leather <br /> • Double stitched <br /> • Box X Toe Construction <br /> • Bonded Nylon Thread <br /> • Triple Glued <br /> • Non-Slip Bottom Sole <br /> • Original Rainbow Woven Label <br /> <br /> The double layer classic leather sandal offers all the great features found in our single layer leather, but with an added layer of midsole and pin line, which runs from the heel to the front of the arch, for even more comfort and support. </p>	[empty string]	N	57.99	57.99	Small,Medium,Large,X-Large,XX-Large,XXXL	8625-DEFAULT-s.jpg	15	1000	302ALTS	27402	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	rainbow/rainbow-double-layer-leather-mens-sandal-27402	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	17.99	0	17.99	25827-DEFAULT-l.jpg	17	25827-DEFAULT-m.jpg	Danlu 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]	SU18	[empty string]	OH at 200	[empty string]	2	15-to-20	0.00	[empty string]	Stance Dan Lu Classic Crew Sock	<p>Our Danlu allows you to push longer and stronger with the support of a skate sock designed by skaters for skaters.</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	18	18	Medium,Large	25827-DEFAULT-s.jpg	17	1000	M556A18DAN	369556	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-dan-lu-classic-crew-sock-369556	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Multi	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	18	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

DC Dc Court Graffik Se Skate Shoes, Black/Black/White $75.00 | view details

VANS Vans Comfycush Old Skool Skate Shoe $70.00 | view details

STANCE Stance Haena Classic Crew Sock $14.00 | view details

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

STANCE Stance Dan Lu Classic Crew Sock $18.00 | view details

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

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	9.99	0	9.99	11005-DEFAULT-l.jpg	9	11005-DEFAULT-m.jpg	Hardcore Bushings For 2 Trucks	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]	77	5-to-10	0.00	[empty string]	Bones Hardcore Skateboard Bushings	<p>With <strong>BONES Bushings™</strong>, you will notice a number of positive improvements in the performance of your trucks.</p> <ul> <li>There is no break-in period. Just put them in, adjust and skate.</li> <li>Your trucks will be more responsive.</li> <li>Increased truck performance</li> <li>Improves your skating experience.</li> <li>Your turns will be smooth and positive, not floppy or rigid.</li> <li>3 Hardnesses: Hard Bushing: 96A, Medium Bushing: 91A, Soft Bushing: 81A</li> </ul> <p>When you turn a normal truck, the hanger web puts pressure on one side of each bushing (top and bottom). This squeezes that side and pushes the other side of each bushing away from the kingpin. We call this a single action bushing because only one side of the bushing works for you at a time.</p> <p>The HardCore insert in the center of BONES bushings connects the two sides of each bushing together by bonding them to the HardCore insert. When the hanger web squeezes one side of a HardCore bushing, that side of the bushing reacts just like a normal bushing, but the chemical bond between the HardCore and the cushion keep the bushing from being squeezed out the other side. It actually increases the resistance to turning because it is held in place by the HardCore insert. This means basically that BOTH sides of the BONES HardCore Bushing are resisting your turning force. That’s why we call BONES Bushings the first double action truck bushings.</p>	[empty string]	N	9.99	9.99	Soft White,Medium White,Hard White,Soft Black,Medium Black,Hard Black	11005-DEFAULT-s.jpg	3	1000	TCPHB2	258055	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	bones/bones-hardcore-skateboard-bushings-258055	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	Bones	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	34.99	0	34.99	25932-DEFAULT-l.jpg	34	25932-DEFAULT-m.jpg	V4 Annuals Stf 2017 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]	2	25-to-50	0.00	[empty string]	Bones STF Annuals V4 Skateboard Wheels	<p>Street Tech Formula™ (STF) is specifically engineered from top quality components to obtain all the best properties necessary for the ultimate in street wheel performance.</p> <p>BONES® WHEELS has created a wheel with a substantially higher rebound for more speed and amazing slide capabilities while maintaining a resistance to flat spotting well beyond any standard wheel. The technology behind STF is proven. The results speak for themselves.</p> <p>Hype is hype, “quality” is for real. Try Street Tech Formula™ wheels on your next setup and see for yourself.</p>	<p>Bones STF Annuals V4 Skateboard Wheel 83b 4 pack (52mm)</p>	N	34.99	34.99	54MM,55MM	25932-DEFAULT-s.jpg	12	1000	BWV4-2017	362177	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-stf-annuals-v4-skateboard-wheels-362177	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SKULLCANDY	SKULLCANDY	SKATEBOARDS	SKATEBOARDS &GT; VIDEO AND AUDIO	24.99	0	24.99	21947-DEFAULT-l.jpg	24	21947-DEFAULT-m.jpg	Ink ` D Mic ` D 2.0 Pnk/Blk Headphones	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	20-to-25	0.00	[empty string]	SKULLCANDY INK ' D 2.0 MIC'D EAR BUD HEADPHONE, Pink/Black	<p>Ink'd earbuds with mic let you manage calls and music thanks to an inline microphone and remote with call and track control. Quality ear gels create a noise isolating fit so your music stays in, and everything else stays out.</p> <ul> </ul>	[empty string]	N	24.99	24.99	[empty string]	21947-DEFAULT-s.jpg	61	1000	S2IKDY-133	285043	EMPTY	EMPTY	EMPTY	0	0	0	VIDEO AND AUDIO	skullcandy/skullcandy-ink-d-20-micd-ear-bud-headphone-pink-black-285043	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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]	6	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	92	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]
5	[empty string]	SHAKE JUNT	SHAKE JUNT	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	5.99	0	5.99	26923-DEFAULT-l.jpg	5	26923-DEFAULT-m.jpg	Tf 1 ` Phillips 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]	23	5-to-10	0.00	[empty string]	Shake Junt T-Funk Pro Bolts, 1"	<p>Shake Junt Signature Bolts come with TWO colored bolts, SIX black bolts.  Made out of high quality, top secret material. Will not break! #1 Homie Approved!  Guaranteed to make you land your tricks... BOLTS!</p>	[empty string]	N	5.99	5.99	[empty string]	26923-DEFAULT-s.jpg	95	1000	02-05-0060	391221	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	shake-junt/shake-junt-tfunk-pro-bolts-1-391221	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	244.99	0	244.99	27049-DEFAULT-l.jpg	244	27049-DEFAULT-m.jpg	Switchblade 40 Faded Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	Landyachtz Switchblade 40 Faded Complete Longboard, 40"	<p> </p> <p>Designed to rally big mountain terrain and conquer World Cup podiums, the Switchblade has proven itself equally adept at getting you to the grocery store and ripping down your local hill safely. The mellow drops, long wheelbase and low ride height combine to offer a drifty, confidence-inspiring feel perfect for riders looking to up their freeride game. </p> <p>No slop, all control. Don’t accept anything less than the perfect complete.</p> <ul> <li>100% Canadian Maple</li> <li>Deep Concave</li> <li>Drop Down</li> <li>Drop Thru</li> <li>Made In Canada</li> <li>Symmetrical</li> </ul>	[empty string]	N	245	245	40IN	27049-DEFAULT-s.jpg	111	1000	119-DHSB40FD	386934	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switchblade-40-faded-complete-longboard-40-386934	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

BONES Bones Hardcore Skateboard Bushings $9.99 | view details

Bones Bones Stf Annuals V4 Skateboard Wheels $34.99 | view details

SKULLCANDY Skullcandy Ink ' D 2.0 Mic ' D Ear Bud Headphone, Pink/Black $24.99 | view details

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

SHAKE JUNT Shake Junt T- Funk Pro Bolts, 1 " $5.99 | view details

LANDYACHTZ Landyachtz Switchblade 40 Faded Complete Longboard, 40 " $245.00 | view details

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Coastal Blue,CEM,White,Black	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	34.99	0	34.99	26572-DEFAULT-l.jpg	34	26572-DEFAULT-m.jpg	All Day Wave 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]	OH at 200	[empty string]	71	25-to-50	0.00	[empty string]	Billabong All Day Wave Short Sleeve Rashguard	<p>Bring together the fit of your favorite surf tee and the silk smooth feel of quick-dry, silk touch fabric. This short sleeve t-shirt fit rashguard delivers all day sun protection and clean, t-shirt lines for a relaxed take on the traditional rashguard.</p> <ul> <li>T-shirt fit rashguard / wetshirt.</li> <li>Short sleeves.</li> <li>Logo prints.</li> <li>Crew neck. 50 + UPF sun protection.</li> <li>Loose Fit: Relaxed fit surf shirt with maximum sun protection for long beach days.</li> <li>Material: 6oz silk touch fabric.</li> </ul>	[empty string]	N	34.95	34.95	Small,Medium,Large,X-Large,XX-Large	26572-DEFAULT-s.jpg	13	1000	MR07TBWL	382759	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	billabong/billabong-all-day-wave-short-sleeve-rashguard-382759	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	39.99	0	39.99	27105-DEFAULT-l.jpg	39	27105-DEFAULT-m.jpg	Painted Sand Towel	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Slowtide Painted Sand Beach Towel	<p>In collaboration with renowned photographer, Clark Little, we introduce the Painted Sand 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>34" x 62"</li> <li>500 grams (Lightweight)</li> <li>Hanging loop</li> <li>Imported</li> </ul>	[empty string]	N	39.95	39.95	[empty string]	27105-DEFAULT-s.jpg	21	1000	ST192	386673	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-painted-sand-beach-towel-386673	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Coal,White,Red,Cobalt	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	31.99	0	31.99	26076-DEFAULT-l.jpg	31	26076-DEFAULT-m.jpg	8 ` 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]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	FCS Regular Essential Leash - 8'	<p>Day-to-day performance and ?reliability in a wide range of conditions.</p>	[empty string]	N	32	32	[empty string]	26076-DEFAULT-s.jpg	22	1000	2020-08F	374707	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-regular-essential-leash-8-374707	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	66.99	0	66.99	26120-DEFAULT-l.jpg	66	26120-DEFAULT-m.jpg	Tech 2 Fin Black/Green - Small	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	1	50-to-100	0.00	[empty string]	Hydro Tech 2 Fins - Black/Green - Small	<p><strong>SIZE:</strong> SMALL</p> <ul> <li> <p>Super soft silicone for unsurpassed comfort.</p> </li> <li> <p>V Rail Design for maximum speed and traction.</p> </li> <li> <p>Ergonomic foot cavity for ultimate fit.</p> </li> <li> <p>Non-slip tread.</p> </li> <li> <p>Central vortex drainage for sand and water.</p> </li> <li> <p>Perfect for bodyboarding and surf swimming.</p> </li> </ul>	[empty string]	N	67	67	[empty string]	26120-DEFAULT-s.jpg	35	1000	TTWO-BLG-SMF	348412	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	hydro/hydro-tech-2-fins-black-green-small-348412	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Pewter,Vintage Blue	VOLCOM	VOLCOM	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; MEN'S	39.99	0	39.99	26941-DEFAULT-l.jpg	39	26941-DEFAULT-m.jpg	Lido Heather Ls 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]	19	25-to-50	0.00	[empty string]	Volcom Lido Heather Long Sleeve Rashguard	<p>When you're living fast sometimes you need a little proteciton. The Lido Heather long sleeve rash guard keeps you covered down to the wrist to keep the elements and 30+ UV rays off you.<br /> <br /> Loose fit rash guard<br /> Hybrid jersey fabric<br /> 30+ UV protection</p>	[empty string]	N	40	40	Small,Medium,Large,X-Large,XX-Large	26941-DEFAULT-s.jpg	37	1000	N0311901	383490	LONG SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	volcom/volcom-lido-heather-long-sleeve-rashguard-383490	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FIREWIRE	FIREWIRE	SURF SHOP	SURF SHOP &GT; SURFBOARDS &GT; LONGBOARDS	784.99	0	784.99	26618-DEFAULT-l.jpg	784	26618-DEFAULT-m.jpg	6 ` 6 Greedy Beaver Tt 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]	1	500-and-over	0.00	[empty string]	Firewire Greedy Beaver TimberTEK Surfboard, FCS II, 6'6"	<p>The Greedy Beaver has a real shortboard feel with a compressed longboard outline, a true crossover board with midlength retro glide and shortboard maneuverability. Put it on rail while engaging the single to double concave, step on the rounded pin and it surfs like a shortboard in the pocket. Or take advantage of the single to double concave and large planing surface to trim effortlessly over dead sections. The beveled rail reduces the overall thickness, adding performance including rapid direction changes.</p> <p>Raise your wave count every session with the paddle power of the Greedy Beaver while turning on a dime as you thread your way through the pack.</p>	[empty string]	N	785	785	6FT6IN	26618-DEFAULT-s.jpg	41	1000	TGBV-606-3-4PW	391962	LONGBOARDS	EMPTY	EMPTY	0	0	0	SURFBOARDS	firewire/firewire-greedy-beaver-timbertek-surfboard-fcs-ii-66-391962	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 All Day Wave Short Sleeve Rashguard $34.95 | view details

SLOWTIDE Slowtide Painted Sand Beach Towel $39.95 | view details

FCS Fcs Regular Essential Leash - 8 ' $32.00 | view details

HYDRO Hydro Tech 2 Fins - Black/Green - Small $67.00 | view details

VOLCOM Volcom Lido Heather Long Sleeve Rashguard $40.00 | view details

FIREWIRE Firewire Greedy Beaver Timbertek Surfboard, Fcs Ii, 6 ' 6 " $785.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	STONE	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	29.99	0	29.99	26193-DEFAULT-l.jpg	29	26193-DEFAULT-m.jpg	Stone Convertible Balaclava	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]	12	25-to-50	0.00	[empty string]	Fishmasks Convertible Ballerclava Balaclava, Stone	<p>Fishmasks Convertible Ballerclava Balaclava, Stone</p>	[empty string]	N	29.99	29.99	[empty string]	26193-DEFAULT-s.jpg	8	1000	FSH-CONV-STONE	359415	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-convertible-ballerclava-balaclava-stone-359415	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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/White,Heather Grey	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	27.99	0	27.99	25638-DEFAULT-l.jpg	27	25638-DEFAULT-m.jpg	Corporate Silicon 2 Flexfit 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]	96	25-to-50	0.00	[empty string]	Never Summer Corporate Silicon 2 Flexfit Hat	<p>The Never Summer Corporate Silicon 2 Flexfit Hat features a silicone Never Summer logo at front.</p>	[empty string]	N	28	28	Small/Medium,Large/X-Large	25638-DEFAULT-s.jpg	20	1000	HTCORP2FF	374864	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-corporate-silicon-2-flexfit-hat-374864	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Roach	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25544-DEFAULT-l.jpg	19	25544-DEFAULT-m.jpg	Roach 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]	3	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Roach	<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]	25544-DEFAULT-s.jpg	48	1000	FSH-SL-ROACH	382015	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-roach-382015	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	509.99	0	509.99	26355-DEFAULT-l.jpg	509	26355-DEFAULT-m.jpg	Aura	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]	7	500-and-over	0.00	[empty string]	Never Summer Aura Women's Snowboard, 2018	<p>Never Summer Aura Women's Snowboard, 2018</p>	[empty string]	N	509.99	509.99	143,150,152,155,157	26355-DEFAULT-s.jpg	50	1000	AURA-H	358752	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-aura-womens-snowboard-2018-358752	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	19.99	0	19.99	11573-DEFAULT-l.jpg	19	11573-DEFAULT-m.jpg	20 ` Tie Down Single Strap	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	M	[empty string]	[empty string]	[empty string]	WEB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Dakine Tie Down Strap - 20'	<p>The Dakine 20' Tie Down Strap makes car roof rack transportation a cinch. These are offered as a 20-foot single strap. The Tie Down Strap features the secure tightening of heavy-duty 1-3/8-inch cam buckles with a neoprene housing.</p>	[empty string]	N	19.99	19.99	[empty string]	11573-DEFAULT-s.jpg	56	1000	08840555	263994	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-tie-down-strap-20-263994	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ELECTRIC	ELECTRIC	SNOWBOARDING	SNOWBOARDING &GT; GOGGLES	159.99	0	159.99	25969-DEFAULT-l.jpg	159	25969-DEFAULT-m.jpg	Egg Dark Side Tort/Jet 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]	2019	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Electric Egg Ski/Snowboard Goggles, Dark Side Tort/Jet Black	<p>Electric Egg Ski / Snowboard Goggles, Dark Side Tort/Jet Black</p>	[empty string]	N	160	160	[empty string]	25969-DEFAULT-s.jpg	67	1000	EG2418203-JBLK	374595	EMPTY	EMPTY	EMPTY	0	0	0	GOGGLES	electric/electric-egg-ski-snowboard-goggles-dark-side-tort-jet-black-374595	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

FISHMASKS Fishmasks Convertible Ballerclava Balaclava, Stone $29.99 | view details

NEVER SUMMER Never Summer Corporate Silicon 2 Flexfit Hat $28.00 | view details

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

NEVER SUMMER Never Summer Aura Women's Snowboard, 2018 $509.99 | view details

DAKINE Dakine Tie Down Strap - 20 ' $19.99 | view details

ELECTRIC Electric Egg Ski/Snowboard Goggles, Dark Side Tort/Jet Black $160.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	Al Agnew Fish	FISHMASKS	FISHMASKS	ACCESSORIES	ACCESSORIES &GT; FACEMASKS	19.99	0	19.99	26186-DEFAULT-l.jpg	19	26186-DEFAULT-m.jpg	Aa Fish 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]	[empty string]	SU17	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter - Al Agnew Collection, Underwater Rainbow	<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]	26186-DEFAULT-s.jpg	1	1000	FHS-SL-AAFISH	363361	EMPTY	EMPTY	EMPTY	0	0	0	FACEMASKS	fishmasks/fishmasks-single-layer-neck-gaiter-al-agnew-collection-underwater-rainbow-363361	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	27216-DEFAULT-l.jpg	149	27216-DEFAULT-m.jpg	Knoxville Xl Mat Blk/Ohm P Brz	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 Knoxville XL Sunglasses, Matte Black/Bronze Polarized	<p>Respecting the original Knoxville, we've scaled up the sizing to create a frame that offers more coverage and a larger look while maintaining clean, classic lines and uncompromised fit.</p> <ul> <li>Frame: 6 base mold injected grilamid frame with a 5 barrel hinge.</li> <li>Optics: 6 base melanin infused polycarbonate lenses. 100% UV protection. Up to 98% blue light protection.</li> <li>Available in polarized polycarbonate lenses. 99.9% Premium glare reduction, relaxed/soothing eye feeling, true color perception, and scratch resistance.</li> <li>Available in anti-reflection, hydrophobic, and oleophobic performance lens coatings.</li> <li>Visual Light Transmitted (VLT): 10%. Optimal lens for daily use. Increased clarity and depth perception while providing visual comfort.</li> <li>Includes microfiber cleaning bag.</li> <li>Designed in California. Made in Italy.</li> <li>Lifetime warranty</li> <li>Measurement: 50h - 144w - 158l</li> <li>Weight: 33 grams</li> </ul>	[empty string]	N	150	150	[empty string]	27216-DEFAULT-s.jpg	1	1000	EE11201043	374336	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-knoxville-xl-sunglasses-matte-black-bronze-polarized-374336	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Ducky/Black	NEFF	NEFF	ACCESSORIES	ACCESSORIES &GT; SOCKS	5.99	0	5.99	26882-DEFAULT-l.jpg	5	26882-DEFAULT-m.jpg	Daily Jacquard Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	4	5-to-10	0.00	[empty string]	Neff Daily Jacquard Crew Sock	<p>The Daily Jacquard Sock. Made with a specially formulated material for ultimate comfort and breath-ability. Choose from one of our #FOREVERFUN prints that will make you want to roll up your pant leg and show a little sock.</p> <p>- Small loop french terry on footbed<br /> - Contrast heel and toe<br /> - Embroidered smile logo at outside ankle</p>	[empty string]	N	6	6	One Size	26882-DEFAULT-s.jpg	4	1000	18F16006	384378	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	neff/neff-daily-jacquard-crew-sock-384378	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey,Black	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; HATS	21.99	0	21.99	25867-DEFAULT-l.jpg	21	25867-DEFAULT-m.jpg	Ride And Seek Wool Shanpback Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Dakine Ride and Seek Ballcap, Fitted Hat	<p>Trucker style meets winter warmth, so you can kick it après with Dakine style. It features a wool-blend build with a structured, six-panel shape.</p>	[empty string]	N	22	22	One Size	25867-DEFAULT-s.jpg	9	1000	10002101-I	373180	EMPTY	EMPTY	EMPTY	0	0	0	HATS	dakine/dakine-ride-and-seek-ballcap-fitted-hat-373180	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25791-DEFAULT-l.jpg	13	25791-DEFAULT-m.jpg	Predator Legends Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Stance Predator Legends Classic Crew Sock	<p>Don't be scared, Stance is here to give you Predator Legends, a sock that brings monsters out of your closet and into your wardrobe.</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	Large	25791-DEFAULT-s.jpg	9	1000	M556D18PRL	380102	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-predator-legends-classic-crew-sock-380102	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Sand	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25787-DEFAULT-l.jpg	13	25787-DEFAULT-m.jpg	Women's Leiday 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]	26	10-to-15	0.00	[empty string]	Stance Leiday Women's 200 Needle Crew Sock	<p>With a casual look, stitched in hula girl logo and "Leiday" inscribed on the back this pair will keep your style singing Monday through Friday.</p> <p>FEATURES</p> <ul> <li>Ultra Lite Cushion</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	25787-DEFAULT-s.jpg	9	1000	W515D18LEI	380512	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-leiday-womens-200-needle-crew-sock-380512	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]