Bones Bearings Cleaning Unit

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	Racing Red	DC	DC	MENS	MENS &GT; TOPS &GT; T-SHIRTS	24.99	0	24.99	27025-DEFAULT-l.jpg	24	27025-DEFAULT-m.jpg	Dyed Ss Pocket Crew 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]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	20	20-to-25	0.00	[empty string]	DC Dyed Pocket Tee	<p>The nuts and bolts</p> <ul> <li><strong>Fabric:</strong> Carded lightweight cotton garment-dyed jersey fabric [160 g/m2]</li> <li><strong>Fit:</strong> Comfortable regular fit</li> <li><strong>Neck:</strong> Crew neckline</li> <li>Herringbone back neck tape</li> <li>Matching fabric chest pocket with printed DC logo <p> </p> </li> </ul> <p>Composition</p> <ul> <li> <p>100% Cotton</p> </li> </ul>	[empty string]	N	25	25	Small,Medium,Large,X-Large,XX-Large	27025-DEFAULT-s.jpg	2	1000	EDYKT03442	383394	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	dc/dc-dyed-pocket-tee-383394	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	MENS	MENS &GT; BOTTOMS &GT; BOXERS/BRIEFS	19.99	0	19.99	25630-DEFAULT-l.jpg	19	25630-DEFAULT-m.jpg	Ceremony Boxer Brief	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	SP18	[empty string]	[empty string]	[empty string]	8	15-to-20	0.00	[empty string]	Stance Ceremony Ply Blend Boxer Brief	<p>The Ceremony is a boxer brief designed with a poly blend that is form fitting and extremely light weight. This 7" inseam style offers a supportive modern fit, exposed Core-flex™, and Feather-seam™ panel construction for maximum comfort.</p>	[empty string]	N	20	20	Large	25630-DEFAULT-s.jpg	5	1000	M803A18CER	365959	UNDERWEAR	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-ceremony-ply-blend-boxer-brief-365959	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Orange	BILLABONG	BILLABONG	MENS	MENS &GT; BOTTOMS &GT; BOARDSHORTS	54.99	0	54.99	26960-DEFAULT-l.jpg	54	26960-DEFAULT-m.jpg	73 Stripe Pro 20 ` Boardshort	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Billabong 73 Stripe Pro Boardshorts, 19"	<p>Modern and heritage lines meet in the 73 Stripe Pro. Fusing modern performance-driven technology retro boardshort design and an allover fade stripe print, the 73 Stripe Pro features a 4-way stretch fabric with an engineered fit, finished with binding at the sides seams and scalloped hem. Consciously constructed, the Pro Series boardshort is now made from eco and performance-minded 4-way stretch recycled fabric.</p> <p>The nuts and bolts</p> <ul> <li>Mens striped boardshorts.</li> <li>Billabong Pro Series Performance Boardshort.</li> <li>Signature 73 split binding and scalloped hem.</li> <li>Allover stripe and gradient print.</li> <li>Patch pocket with Hook & Loop closure at side.</li> <li>Performance Fit: engineered to minimize seams and maximize performance.</li> <li>4-Way Pro Stretch Fabric: A high performance fabric made from recycled PET plastic bottles. The perfect combination of performance and comfort.</li> <li>Micro Repel: coats fabric to eliminate saturation & repels water, keeping your boardshorts dryer and lighter, longer.</li> <li>Mid Length: 19 inch outseam.</li> <li>Material: Pro Stretch. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	54.95	54.95	29,30,31,32,33,34,38,40	26960-DEFAULT-s.jpg	5	1000	M127TBST	382520	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-73-stripe-pro-boardshorts-19-382520	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black	STANCE	STANCE	MENS	MENS &GT; BOTTOMS &GT; BOXERS/BRIEFS	24.99	0	24.99	26927-DEFAULT-l.jpg	24	26927-DEFAULT-m.jpg	Greatful Dead Underwear	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	20-to-25	0.00	[empty string]	Stance Grateful Dead Boxer Brief	<p>Turn up the jams in our Grateful Dead. A boxer brief that tributes Jerry, Phil, Bob, Mickey, Bill and every legendary member of the iconic Grateful Dead.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief with fly</li> <li>7'' 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	25	25	Small,Medium,Large,X-Large	26927-DEFAULT-s.jpg	6	1000	M803A19GRA	383899	UNDERWEAR	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-grateful-dead-boxer-brief-383899	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	VON ZIPPER	VON ZIPPER	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	179.99	0	179.99	27273-DEFAULT-l.jpg	179	27273-DEFAULT-m.jpg	Dipstick Blk Satin/Wild Blu Flash Polar +	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	VonZipper Dipstick Sunglasses, Black Satin/Wildlife Blue Flash Polarized+	<p><strong>Story: </strong>A device of measure and special purpose, the Dipstick is a performance piece ensuring lubrication.</p> <p><strong>Specs: </strong>VonZipper Dipstick polarized sunglasses are handmade in Italy; the frame is crafted from nylon grilamid for maximum flexibility and held together with corrosion free Pop N' Lock cam hinges. The base 6 spherical impact resistant polycarbonate polarized lenses will protect your eyes with 100% UV protection.</p> <p><strong>RGNS System: </strong>Here’s where the rubber hits the road. If you wanna RIP, have lots of GRIP, with NO SLIP, our RGNS system features rubber nose pads and temple tips.</p>	[empty string]	N	180	180	[empty string]	27273-DEFAULT-s.jpg	8	1000	SMPF7DIP-PLC	357640	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	von-zipper/vonzipper-dipstick-sunglasses-black-satin-wildlife-blue-flash-polarized-357640	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	179.99	0	179.99	25979-DEFAULT-l.jpg	179	25979-DEFAULT-m.jpg	Suplex Trt Satin/Grn Chrome Polar +	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	VonZipper Suplex Sunglasses, Tortoise Satin/Wildlife Green Flash Polarized+	<p><strong>Story: </strong>It starts out with a warm embrace from behind, but then, the real action begins. The next thing you know you're dazed and confused wondering what just happened. Pin it to win it in the Suplex.</p> <p><strong>Specs: </strong>VonZipper Suplex polarized sunglasses are handmade in Italy; the frame is crafted from nylon grilamid for maximum flexibility and held together with corrosion free Pop N' Lock cam hinges. The base 8 spherical impact resistant polycarbonate polarized lenses will protect your eyes with 100% UV protection.</p> <p><strong>RGNS System: </strong>Here’s where the rubber hits the road. If you wanna RIP, have lots of GRIP, with NO SLIP, our RGNS system features rubber nose pads and temple tips.</p>	[empty string]	N	180	180	[empty string]	25979-DEFAULT-s.jpg	8	1000	SMPFTSUP-PTG	357673	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	von-zipper/vonzipper-suplex-sunglasses-tortoise-satin-wildlife-green-flash-polarized-357673	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Dyed Pocket Tee $25.00 | view details

STANCE Stance Ceremony Ply Blend Boxer Brief $20.00 | view details

BILLABONG Billabong 73 Stripe Pro Boardshorts, 19 " $54.95 | view details

STANCE Stance Grateful Dead Boxer Brief $25.00 | view details

VON ZIPPER Vonzipper Dipstick Sunglasses, Black Satin/Wildlife Blue Flash Polarized + $180.00 | view details

VON ZIPPER Vonzipper Suplex Sunglasses, Tortoise Satin/Wildlife Green Flash Polarized + $180.00 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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]	129	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	163	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	137	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	932	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	139	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	978	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	[empty string]	VANS	VANS	WOMENS	WOMENS &GT; SHOES	114.99	0	114.99	25704-DEFAULT-l.jpg	114	25704-DEFAULT-m.jpg	Ultrarange Hi Mte Dachshund/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]	BROWN	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	14	100-to-150	0.00	[empty string]	Vans UltraRange Hi MTE Shoe, Dachshund/Black	<p>A new addition to the Vans family, the athlete-inspired UltraRange Hi MTE is a versatile shoe with additions designed for the elements. Featuring a brand new UltraCush Lite midsole compound offering the ultimate in comfort and cushioning, plus a sock-fit bootie construction with seamless internals to reduce weight, rubbing, and hotspots, the UltraRange Hi MTE provides a clean aesthetic that will get you there. It also includes leather and synthetic uppers with MTE details, warm linings, water-based inks and glues, and durable co-molded rubber reverse waffle lug outsoles to reduce glue and improve finishing.</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	115	115	8,8.5,9.5,10.5,11,12,13	25704-DEFAULT-s.jpg	4	1000	VN0A3ZD1FW6	379638	EMPTY	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-ultrarange-hi-mte-shoe-dachshund-black-379638	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Pink,Heather Grey,Neon Pink,Royal	STANCE	STANCE	WOMENS	WOMENS &GT; ACCESSORIES &GT; SOCKS	11.99	0	11.99	25724-DEFAULT-l.jpg	11	25724-DEFAULT-m.jpg	Og Sock	N	[empty string]	[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]	182	10-to-15	0.00	[empty string]	Stance OG Classic Crew Sock	<p>Because you were down with Stance before the got Rihanna and Dwade signed on as Punks and Poets we created the OG. These uncommon solids were inspired by those who believed in us first. We wouldn't be here without you.</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>	<p>Stance Men's Notre Dame Athletic Socks White (White, Large)</p>	N	12	12	Medium,Large	25724-DEFAULT-s.jpg	7	1000	M556D17OGG	368530	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-og-classic-crew-sock-368530	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	WOMENS	WOMENS &GT; ACCESSORIES &GT; WATCHES	99.99	0	99.99	25616-DEFAULT-l.jpg	99	25616-DEFAULT-m.jpg	Base Tide Blk/Grn/Nvy	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Nixon Base Tide 38mm Watch, Black/Green/Navy	<p>Simplified tide telling inspired by simpler times. The Base Tide slides 21st century tech into retro design and mod colors.</p> <p>Time, Tide, and a Little More</p> <p>Time, day, date, future tide times, chronograph and countdown timer</p> <hr /> <p>Easy Reading</p> <p>Simplified negative LCD for easy underwater reading.</p> <hr /> <p>Function and Comfort</p> <p>22mm custom injection molded ultra-soft silicone band</p> <hr /> <p>Durable Construction</p> <p>38mm, 100 meter/10 ATM, custom molded polycarbonate case.</p>	[empty string]	N	99.95	99.95	[empty string]	25616-DEFAULT-s.jpg	7	1000	A11042817	374132	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-base-tide-38mm-watch-black-green-navy-374132	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

VANS Vans Ultrarange Hi Mte Shoe, Dachshund/Black $115.00 | view details

STANCE Stance Og Classic Crew Sock $12.00 | view details

NIXON Nixon Base Tide 38mm Watch, Black/Green/Navy $99.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	Black	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	25815-DEFAULT-l.jpg	13	25815-DEFAULT-m.jpg	Bones 2 Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	Stance Bones 2 Boys Kids Crew Sock	<p>Whether it's Halloween or 4th of July, Stance's Bones2 are a wardrobe essential. With a classic skeleton design that glows in the dark this sock is a perfect fit for your attire.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25815-DEFAULT-s.jpg	1	1000	M556D18BO2	380074	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-bones-2-boys-kids-crew-sock-380074	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Assorted	ETHIKA	ETHIKA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	26845-DEFAULT-l.jpg	14	26845-DEFAULT-m.jpg	Boys Walter Allen Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Ethika Ryan Sheckler Walter Allen Boy's Boxer Brief	<ul> <li>The Original - Unmatched Staple Fit</li> <li>No Pull-Down, No Gathering</li> <li>Soft 4-Way Stretch Fabric</li> <li>High-Quality Jacquard Waistband</li> <li>90% Polyester 10% Spandex</li> </ul>	[empty string]	N	15	15	Small	26845-DEFAULT-s.jpg	32	1000	UBS1446	384627	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	ethika/ethika-ryan-sheckler-walter-allen-boys-boxer-brief-384627	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	74.99	0	74.99	25699-DEFAULT-l.jpg	74	25699-DEFAULT-m.jpg	Kyle Walker Pro Black/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	85	50-to-100	0.00	[empty string]	Vans Kyle Walker Pro Skate Shoe, Black/White	<p>The all new Kyle Walker Pro, the introductory signature model from rookie pro Kyle Walker, is made with suede uppers. The UltraCush HD impact sockliners keep the foot close to the board while providing the highest level of impact cushioning, and the revolutionary Wafflecup construction offers the support of a cupsole without sacrificing any of the grip or boardfeel of a traditional vulcanized shoe. The Kyle Walker Pro also features DURACAP upper reinforcement in high wear areas for unrivaled durability.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	75	75	7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25699-DEFAULT-s.jpg	42	1000	VN0A2XSGY28	366350	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-kyle-walker-pro-skate-shoe-black-white-366350	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	25695-DEFAULT-l.jpg	49	25695-DEFAULT-m.jpg	Slip On Black And White Checker/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	REGULAR	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	245	25-to-50	0.00	[empty string]	Vans Classics Checkerboard Slip-On Skate Shoe, Black/Off-White Checkers	<p>The Classic Slip-On has a low profile, slip-on canvas upper with all-over checker print, elastic side accents, Vans flag label and Vans original Waffle Outsole. </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	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25695-DEFAULT-s.jpg	43	1000	VN000EYEBWW	11420	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-classics-checkerboard-slipon-skate-shoe-black-offwhite-checkers-11420	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	49	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]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	59.99	0	59.99	26790-DEFAULT-l.jpg	59	26790-DEFAULT-m.jpg	Comfycush Slip On True White/True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	WHITE	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	69	50-to-100	0.00	[empty string]	Vans ComfyCush Slip-On Skate Shoe	<p>Vans has reinvigorated the classic Slip-On by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Slip-On a first-class fit that feels like walking on a cloud. Newly constructed canvas uppers house simplified one-piece interiors with added arch support and new moisture-wicking lining throughout, resulting in a lightweight experience that assures you’ll Keep It Comfy at all times.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26790-DEFAULT-s.jpg	59	1000	VN0A3WMDVNG	383079	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-comfycush-slipon-skate-shoe-383079	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

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

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

VANS Vans Classics Checkerboard Slip- On Skate Shoe, Black/Off- White Checkers $50.00 | view details

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

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

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Black,Teak/Teak	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	109.99	0	109.99	2602-DEFAULT-l.jpg	109	2602-DEFAULT-m.jpg	Hiapo Leather Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	37	100-to-150	0.00	[empty string]	OluKai Hiapo Leather Sandal	<p>Dignified and respected the Hiapo, our first born, is a true pioneer of tradition craft and detail.</p> <h3>FEATURES:</h3> <p>Moko tattoo artwork, footbed detail, hand-sewn whipstitching with heavyweight thread, embroidered logo, and a comfortable hand-sewn leather toe post.</p> <h3>UPPER:</h3> <p>Full-grain leather with naturally tumbled, marbled, or distressed surface textures and a soft microfiber lining.</p> <h3>FOOTBED:</h3> <p>Compression molded EVA midsole, wrapped in full-grain leather provides anatomically correct contour for a personalized fit, and sustained comfort over time.</p> <h3>OUTSOLE:</h3> <p>Full-grain leather wrapped outsole with non-marking rubber traction pods for enhanced grip and flexibility.</p>	[empty string]	N	109.99	109.99	7,8,9,10,12,13	2602-DEFAULT-s.jpg	5	1000	10101	29788	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	olukai/olukai-hiapo-leather-sandal-29788	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Red	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	15.99	0	15.99	25790-DEFAULT-l.jpg	15	25790-DEFAULT-m.jpg	Santarchy Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	49	15-to-20	0.00	[empty string]	Stance Santarchy Classic Crew Sock	<p>Sometimes Christmas can be chaotic. Celebrate the holidays with a smile in Santarchy, a checker design with skull and bones Santa logo that's sure to tickle your sense of humor through the holidays.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	16	16	Medium,Large	25790-DEFAULT-s.jpg	7	1000	M556D18SAN	380078	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-santarchy-classic-crew-sock-380078	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	DVS	DVS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	26830-DEFAULT-l.jpg	69	26830-DEFAULT-m.jpg	Celsius Charcoal/Grey Nubuck	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	11	50-to-100	0.00	[empty string]	DVS Celcius Skate Shoe, Charcoal/Grey	<p>The Celsius from DVS Shoes is a heritage skate shoe with a classic double cup outsole and a lightweight EVA midsole.  This shoe has a mesh tongue for breathability and the heavy-duty collar and tongue padding provide support and protection.  The Celsius touts a molded eye stay piece that is tough and durable as well as a super comfy molded EVA sock liner. Uppers come in suede, leather, and nubuck combinations.</p> <p>Energy Fit is designed to provide consistent tongue alignment with a lock down fit. Dual Energy gore connects the tongue to the outsole to keep the tongue cinched and straight.</p>	[empty string]	N	70	70	10.5,11,11.5,12,14	26830-DEFAULT-s.jpg	7	1000	DVF0000233034	383537	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-celcius-skate-shoe-charcoal-grey-383537	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25809-DEFAULT-l.jpg	13	25809-DEFAULT-m.jpg	Off My Wave Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	OH at 200	[empty string]	22	10-to-15	0.00	[empty string]	Stance Off My Wave Classic Crew Sock	<p>Locals only man! The Off My Wave sends a message loud and clear to those trying to snake in on your good times in the water and out.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25809-DEFAULT-s.jpg	8	1000	M556C18OMW	370516	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-off-my-wave-classic-crew-sock-370516	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	79.99	0	79.99	27130-DEFAULT-l.jpg	79	27130-DEFAULT-m.jpg	Chima Pro 2 (Perf) Ebony/Port Royale	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]	33	50-to-100	0.00	[empty string]	Vans Chima Pro 2 Skate Shoe, Ebony/Port Royale	<p>Chima Ferguson?s signature Chima Pro 2 in Perf is made with sturdy suede uppers. The UltraCush Lite 3D footbed blends the lightweight and responsive feel of the UltraCush Lite footbed with a dual-density foam, surrounded with a molded heel cup for unsurpassed cushioning, and the Vans original waffle outsoles are made of a rubber that offers grip and support. Featuring DURACAP reinforcement rubber underlays in high wear areas for unrivaled durability, the Chima Pro 2 also includes Pro Vulc Lite construction to deliver the best in boardfeel, flex, and traction.</p>	[empty string]	N	80	80	6.5,7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27130-DEFAULT-s.jpg	9	1000	VN0A3MTIVF0	383049	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-chima-pro-2-skate-shoe-ebony-port-royale-383049	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25746-DEFAULT-l.jpg	13	25746-DEFAULT-m.jpg	Desert Dinos 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]	19	10-to-15	0.00	[empty string]	Stance Desert Dinos Classic Crew Sock	<p>Inside every man hides a boy who loves dinosaurs. Rekindle an old flame with Stance's Desert Dino, a sock for your inner paleontologist.</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	25746-DEFAULT-s.jpg	20	1000	M556D18DES	380101	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-desert-dinos-classic-crew-sock-380101	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

OLUKAI Olukai Hiapo Leather Sandal $109.99 | view details

STANCE Stance Santarchy Classic Crew Sock $16.00 | view details

DVS Dvs Celcius Skate Shoe, Charcoal/Grey $70.00 | view details

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

VANS Vans Chima Pro 2 Skate Shoe, Ebony/Port Royale $80.00 | view details

STANCE Stance Desert Dinos 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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	59.99	0	59.99	26911-DEFAULT-l.jpg	59	26911-DEFAULT-m.jpg	Wall Hand Preisue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Santa Cruz Wall Hand Preisue Skateboard Deck	<p>New Santa Cruz graphics on 80s inspired directional shapes! The Wall Hand graphic comes on a brand new directional shaped board and is designed as the ultimate skate park ripper. Mix it up and throw some SlimeBalls on this shape to make it the perfect cruiser. All SC PreIssue's are made with 100% North American Maple and guaranteed for 120 days against manufacturer defects. Get one of these asap, as they are sure to go quick!</p>	[empty string]	N	59.99	59.99	9.35	26911-DEFAULT-s.jpg	14	1000	11115463	387633	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-wall-hand-preisue-skateboard-deck-387633	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	MADNESS	MADNESS	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	56.99	0	56.99	27054-DEFAULT-l.jpg	56	27054-DEFAULT-m.jpg	Factory R7 8.6 Deck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Madness Factory White R7 Skateboard Deck, 8.625"	<p>MADNESS Factory White 8.625 R7 Skateboard Deck<br /> <em>Resin-7 Canadian Maple Construction </em><br /> Mellow Concave / Steep Kick<br /> 8.625" x 32.3" x 14.375" WB</p>	[empty string]	N	56.99	56.99	8.6	27054-DEFAULT-s.jpg	14	1000	10076014	392539	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	madness/madness-factory-white-r7-skateboard-deck-8625-392539	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Black Rubber,All Black Rubber,Black Glossy w/Green,DC3,United Red Rubber,Neon Fuchisa Glossy,Blue Fade Rubber,Neon Zest,White Rubber,Baja Teal Rubber,Royal Blue Rubber,Carbon Rubber,DC6,Yellow Rubber	TRIPLE EIGHT	TRIPLE EIGHT	SKATEBOARDS	SKATEBOARDS &GT; PROTECTIVE GEAR &GT; HELMETS	44.99	0	44.99	1293-DEFAULT-l.jpg	44	1293-DEFAULT-m.jpg	Brain Saver W/Sweat Saver Liner Helmet	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]	359	25-to-50	0.00	[empty string]	Triple Eight Sweat Saver Helmet	<p>Our classic helmet, protecting skaters for 18 years and counting.</p> <p>With its timeless design, killer color range and our unique rubber finish, the Sweatsaver Helmet is a staple of our helmet collection. And with our stink-free, moisture-wicking Sweatsaver™ Liner inside, it’s a helmet you’ll use for years to come. Sweatsaver™ replacement liners are also sold separately in various colors to customize your helmet.</p>	[empty string]	N	39.99	44.99	X-Small,Small,Medium,Large,X-Large,XX-Large	1293-DEFAULT-s.jpg	30	1000	T8RUB	200121	HELMETS	EMPTY	EMPTY	0	0	0	PROTECTIVE GEAR	triple-eight/triple-eight-sweat-saver-helmet-200121	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	69.99	0	69.99	26739-DEFAULT-l.jpg	69	26739-DEFAULT-m.jpg	Kendall End Of The World Reissue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Santa Cruz Kendall End of the World Re-Issue Skateboard Deck, 10" x 29.7"	<p>Straight from the archives comes new Santa Cruz Re-Issues! Santa Cruz Skateboards is proud to release four new reissues! For the first time since it's original production, Jeff Kendall's "End of the World” graphic is back on its original shape and in a new, never before printed colorway. A must have for any fan of the 80’s. Hang this baby on your wall or set up a one of a kind skateboard. Either way, you won't be disappointed.</p>	[empty string]	N	69.99	69.99	10.0	26739-DEFAULT-s.jpg	35	1000	11115418	391904	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-kendall-end-of-the-world-reissue-skateboard-deck-10-x-297-391904	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD BEARINGS	9.99	0	9.99	21700-DEFAULT-l.jpg	9	21700-DEFAULT-m.jpg	Bearing Cleaning Unit	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	29	5-to-10	0.00	[empty string]	Bones Bearings Cleaning Unit	<div class="std"> <p>Finally, a bearing cleaning unit brought to you by the bearing company by which all quality standards are measured.</p> <p><strong>Features</strong></p> <ul> <li>Made of fluorinated high density polyethylene</li> <li>7 spacers for a good flush in less time</li> <li>Cleans up to 8 bearings at a time</li> <li>Cleans all skate bearings</li> <li>Cleaning solvents not included</li> </ul> <p><strong>Contents</strong></p> <p>A detailed instruction sheet will also be included with the unit to insure easy and proper use.</p> </div>	[empty string]	N	9.99	9.99	[empty string]	21700-DEFAULT-s.jpg	36	1000	ATABCUP	210091	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-bearings-cleaning-unit-210091	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	KRUX	KRUX	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD TRUCKS	24.99	0	24.99	26865-DEFAULT-l.jpg	24	26865-DEFAULT-m.jpg	Black Marbs Dlk 8.25 Standard Truck	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	20-to-25	0.00	[empty string]	Krux Black Marbs DLK Standard Trucks	<p>Extra Fresh! New "Marbs" Krux Trucks are here and ready to shred! Each set of the "Marbs" trucks features the Krux Downlow Kingpin (DLK). Designed to prevent any snags or hang ups during grinds and perfect for smiths and feebles. Truly the smoothest grind. Krux Lows are great for tech shredders and makes flip tricks easier. Perfect for ledges, rails and any other street terrain too. Krux Lows are great for tech shredders and makes flip tricks easier. Perfect for ledges, rails and any other street terrain too.</p>	[empty string]	N	24.99	24.99	8.25	26865-DEFAULT-s.jpg	40	1000	33132344-825	387667	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD TRUCKS	krux/krux-black-marbs-dlk-standard-trucks-387667	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SANTA CRUZ Santa Cruz Wall Hand Preisue Skateboard Deck $59.99 | view details

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

TRIPLE EIGHT Triple Eight Sweat Saver Helmet $39.99 to $44.99 | view details

SANTA CRUZ Santa Cruz Kendall End Of The World Re- Issue Skateboard Deck, 10 " X 29.7 " $69.99 | view details

BONES Bones Bearings Cleaning Unit $9.99 | view details

KRUX Krux Black Marbs Dlk Standard Trucks $24.99 | view details

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	54.99	0	54.99	26124-DEFAULT-l.jpg	54	26124-DEFAULT-m.jpg	Fcs Ii Performer Gf Medium Tri	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	FCS II Performer Glass Flex Tri Fins - Medium	<p>Balance of speed, flow and response. Suitable for all conditions.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for a balance of speed, flow & response.</li> <li>Well proportioned template with Inside Foil Technology (IFT).</li> <li>Ideal for surfers who want a reliable ‘All Round’ fin delivering a combination of speed and maneuverability with flow between turns.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>A wide range of conditions from beach breaks to point breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for all board types.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Performer: Find Balance. A balance of speed, flow & response.</li> </ul>	[empty string]	N	55	55	[empty string]	26124-DEFAULT-s.jpg	20	1000	FPER-GF01-MD-TS-R	305900	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-performer-glass-flex-tri-fins-medium-305900	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	27104-DEFAULT-l.jpg	29	27104-DEFAULT-m.jpg	Steelie 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]	2	25-to-50	0.00	[empty string]	Slowtide Steelie Beach Towel	<p>Slowtide Steelie Beach Towel</p>	[empty string]	N	29.95	29.95	[empty string]	27104-DEFAULT-s.jpg	24	1000	ST191	386672	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-steelie-beach-towel-386672	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	54.99	0	54.99	26139-DEFAULT-l.jpg	54	26139-DEFAULT-m.jpg	Fcs Ii Carver Gf Large Tri Fins	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	FCS II Carver Glass Flex Tri-Fins - Large	<p>Powerful, drawn-out turns. Excels on open face waves.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for powerful, drawn-out turns with added hold.</li> <li>Elongated template with high degree of sweep provides exceptional hold off the bottom and when carving on the open face.</li> <li>Ideal for power surfers who like to push hard against their fins and draw out their turns.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Open face, down-the-line waves, particularly good in point and reef breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for boards with deep concaves and moderate-to-extreme rocker.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Carver: Find Power. Powerful, drawn-out turns with added hold.</li> </ul>	[empty string]	N	55	55	[empty string]	26139-DEFAULT-s.jpg	39	1000	FCAR-GF01-LG-TS-R	305902	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-carver-glass-flex-trifins-large-305902	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	124.99	0	124.99	26141-DEFAULT-l.jpg	124	26141-DEFAULT-m.jpg	Pc- 5 Blue Slice Tri- Quad Retail Fins	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	100-to-150	0.00	[empty string]	FCS PC-5 Tri-Quad Fins - Medium	<p>Lightweight performance tri-quad setup with a responsive flex pattern. PC-5, PC-7 Tri-Quad.</p> <p><strong>Overview</strong></p> <ul> <li>A balance of speed, flow and response in a variety of conditions.</li> <li>Lightweight performance fin with responsive tip flex and hydrodynamic foil on the side fins.</li> <li>Tri-Quad (5 fin) set.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li> <p>A wide range of conditions from beach breaks to point breaks.</p> </li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>All board types.</li> <li>Will fit the FCS II Fin System when used with grub screws and the FCS Infill Kit.</li> </ul>	<p>FCS PC-5 II Two Tab Medium Tri-Quad Fin Set Performance Core - Blue Slice</p>	N	125	125	[empty string]	26141-DEFAULT-s.jpg	43	1000	PC05-135-28-R	347358	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-pc5-triquad-fins-medium-347358	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	48	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]
6	[empty string]	FIREWIRE	FIREWIRE	SURF SHOP	SURF SHOP &GT; SURFBOARDS &GT; SHORTBOARDS	784.99	0	784.99	26616-DEFAULT-l.jpg	784	26616-DEFAULT-m.jpg	5 ` 6 Seaside Helium W/Futures	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 Machado Seaside Surfboard, Futures, 5'6"	<p>HEY ROB, WHAT IS THE SEASIDE..?</p> <p>Just evolving the Go Fish to something new, really. The Go Fish goes fast and feels skatey and loose and I love it, and riding it for a couple years made me want to feel more high performance – more carves, tighter turns. So the Seaside is about refining… less area in the tail, narrowing the tips of the swallow, creating more curve and narrowing the nose. All elements for ripping while the Go Fish stays cruisey and fun.</p> <p>The Seaside is quad only, why?</p> <p>I decided that if i was going to make a quad I would make a quad that’s strictly a quad … Design the concaves and bottom contours around that. I actually redesigned my entire concave setup that I’ve been using on the Moonbeam and Go Fish, and did it with the quad setup in mind so that it all works together.</p> <p>Why name this shape after your home break, Seaside?</p> <p>Naming surfboards might be the hardest thing to do on the planet [laughing]. It’s just the perfect little stick when I surf my home spot, Seaside.</p> <p>Why is the Seaside built in Helium?</p> <p>The first one I made for Tahiti was LFT and I was riding it in 6 foot tubes. But most everyone surfs a shape like the Seaside at beach breaks and little point breaks, so we made it in Helium because it’s really light, very responsive, really flexy with a softer feel and very durable. It’s the best option for a shape like the Seaside in smaller, weaker waves, I think.</p>	[empty string]	N	785	785	5FT6IN	26616-DEFAULT-s.jpg	75	1000	HSEA-506-3-3WH	391298	SHORTBOARDS	EMPTY	EMPTY	0	0	0	SURFBOARDS	firewire/firewire-machado-seaside-surfboard-futures-56-391298	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

FCS Fcs Ii Performer Glass Flex Tri Fins - Medium $55.00 | view details

SLOWTIDE Slowtide Steelie Beach Towel $29.95 | view details

FCS Fcs Ii Carver Glass Flex Tri- Fins - Large $55.00 | view details

FCS Fcs Pc- 5 Tri- Quad Fins - Medium $125.00 | view details

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

FIREWIRE Firewire Machado Seaside Surfboard, Futures, 5 ' 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	BLUECAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26185-DEFAULT-l.jpg	19	26185-DEFAULT-m.jpg	Blue Camo 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]	SP17	[empty string]	[empty string]	[empty string]	19	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Blue Camo	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	<p>Fishmasks Single Layer Neck Gaiter - Lightweight, Fishing Protection From Sun, Wind And Moisture - Made In USA - UPF 50+ Moisture-Wicking Fabric - Blue Camo</p>	N	19.99	19.99	[empty string]	26185-DEFAULT-s.jpg	3	1000	FSH-SL-BLUECAMO	359392	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-blue-camo-359392	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Rubber Colorado,White Rubber Colorado	TRIPLE EIGHT	TRIPLE EIGHT	SNOWBOARDING	SNOWBOARDING &GT; HELMETS	44.99	0	44.99	26178-DEFAULT-l.jpg	44	26178-DEFAULT-m.jpg	Colorado Brainsaver Helmet	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	101	25-to-50	0.00	[empty string]	Triple Eight Brainsaver Snowboard Helmet - Colorado	<p>Our classic skate-style helmet ready to hit the terrain park, with Audio Earflap Pockets so you can add your favorite audio system. </p> <ul> <li>ABS Shell with EPS liner</li> <li>Earflaps enabled for Audio</li> <li>Back Neck Curtain for additional cranium support</li> <li>Padded Chin Strap</li> <li>11 Vents with mesh covers</li> <li>Meets ASTM F2040 & CE EN 1077 safety standards</li> </ul>	[empty string]	N	44.99	44.99	Small,Medium,Large,X-Large	26178-DEFAULT-s.jpg	4	1000	T8RUBCOLO	334517	EMPTY	EMPTY	EMPTY	0	0	0	HELMETS	triple-eight/triple-eight-brainsaver-snowboard-helmet-colorado-334517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	599.99	0	599.99	26358-DEFAULT-l.jpg	599	26358-DEFAULT-m.jpg	Swift	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	5	500-and-over	0.00	[empty string]	Never Summer Swift Snowboard, 2019	<p>The Swift was the inspiration for, and the Godfather of, the Shaper Series. Originally we set out to make the greatest powder board of all time. We succeeded, but it turns out we actually made a board that was incredible everywhere. The Swift features the greatest amount of taper in the Shaper Series, with awesome everywhere performance, in or out of POW. Take the Swift anywhere you want to go.</p>	[empty string]	N	599.99	599.99	148,152,157,162	26358-DEFAULT-s.jpg	17	1000	SWIFT-I	374732	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-swift-snowboard-2019-374732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	HARLAUT	OAKLEY	OAKLEY	SNOWBOARDING	SNOWBOARDING &GT; GOGGLES	159.99	0	159.99	25998-DEFAULT-l.jpg	159	25998-DEFAULT-m.jpg	Lineminer Harlaut Sig/Prizm Blk Ird	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]	2020	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Oakley Line Miner Snow Goggle, Matte Black/Prizm Snow Sapphire Iridium	<p>The Line Miner goggle was created with the purpose of providing the ultimate in peripheral vision, with a cylindrical-style design. We were able to pull the goggle in closer to your face than ever before, allowing for incredible downward and side-to-side periphery. Discreet frame notches at temples provide compatibility with most prescription eyewear.</p>	[empty string]	N	160	160	[empty string]	25998-DEFAULT-s.jpg	29	1000	OO7070-41	375573	EMPTY	EMPTY	EMPTY	0	0	0	GOGGLES	oakley/oakley-line-miner-snow-goggle-matte-black-prizm-snow-sapphire-iridium-375573	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Black,Grey	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	27.99	0	27.99	25642-DEFAULT-l.jpg	27	25642-DEFAULT-m.jpg	Retro Mountain Snapback Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	25	25-to-50	0.00	[empty string]	Never Summer Retro Mountain Snapback Hat	<p>Never Summer Retro Mountain Snapback Hat</p>	[empty string]	N	28	28	One Size	25642-DEFAULT-s.jpg	31	1000	HTRETROADJ	374869	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-retro-mountain-snapback-hat-374869	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Al Agnew Fish	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &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	32	1000	FHS-SL-AAFISH	363361	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

TRIPLE EIGHT Triple Eight Brainsaver Snowboard Helmet - Colorado $44.99 | view details

NEVER SUMMER Never Summer Swift Snowboard, 2019 $599.99 | view details

OAKLEY Oakley Line Miner Snow Goggle, Matte Black/Prizm Snow Sapphire Iridium $160.00 | view details

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

FISHMASKS Fishmasks Single Layer Neck Gaiter - Al Agnew Collection, Underwater Rainbow $19.99 | view details

Accessories

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Heather Grey,Black/Lime	NEVER SUMMER	NEVER SUMMER	ACCESSORIES	ACCESSORIES &GT; HATS	27.99	0	27.99	26393-DEFAULT-l.jpg	27	26393-DEFAULT-m.jpg	Eagle Patch 110 Snapback 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]	2016	[empty string]	[empty string]	[empty string]	36	25-to-50	0.00	[empty string]	Never Summer Eagle Patch 110 Snapback Hat	<p>Never Summer Eagle Patch 110 Snapback Hat</p>	<p>Never Summer Retro Mountain Trucker Hat (Navy)</p>	N	28	28	[empty string]	26393-DEFAULT-s.jpg	3	1000	HTROUND110	329683	EMPTY	EMPTY	EMPTY	0	0	0	HATS	never-summer/never-summer-eagle-patch-110-snapback-hat-329683	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Black,Grey	NEVER SUMMER	NEVER SUMMER	ACCESSORIES	ACCESSORIES &GT; HATS	21.99	0	21.99	26398-DEFAULT-l.jpg	21	26398-DEFAULT-m.jpg	Bolts 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]	2017	[empty string]	[empty string]	[empty string]	64	20-to-25	0.00	[empty string]	Never Summer Bolts Trucker Hat	<p>Never Summer Bolts Trucker Hat</p>	<p>Never Summer Ice Axe Patch Flex Fit Trucker Hat</p>	N	21.99	21.99	[empty string]	26398-DEFAULT-s.jpg	7	1000	HTBOLTSADJ	345708	EMPTY	EMPTY	EMPTY	0	0	0	HATS	never-summer/never-summer-bolts-trucker-hat-345708	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Teal	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25812-DEFAULT-l.jpg	13	25812-DEFAULT-m.jpg	Women's Sir Harold 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]	16	10-to-15	0.00	[empty string]	Stance Sir Harold Women's Tomboy Light Crew Sock	<p>Our Sir Harold gives you all the style, comfort and companionship you need. With its unique design and hedgehog graphic you'll never take another step alone with Sir Harold.</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	25812-DEFAULT-s.jpg	7	1000	W525D18SIR	380518	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-sir-harold-womens-tomboy-light-crew-sock-380518	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	OAKLEY	OAKLEY	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	182.99	0	182.99	26002-DEFAULT-l.jpg	182	26002-DEFAULT-m.jpg	Holbrook Xl Woodgrain W/Prizm Tngstn Po	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	150-to-200	0.00	[empty string]	Oakley Holbrook XL Sunglasses, Woodgrain/Prizm Tungsten Polarized	<p>The look of Holbrook™, from its iconic style to keyhole bridge and metal rivets, has been scaled up to fit larger faces. Even with enhanced sizing for larger faces, it stays comfortable with lightweight O Matter™ frame material. Pure Plutonite® lenses filter out 100% of all UV while XYZ Optics® maintains clarity at every angle of view.</p>	<p>Oakley Holbrook XL Polarized Sunglasses, Woodgrain/PRIZM Tungsten,OS</p>	N	183	183	[empty string]	26002-DEFAULT-s.jpg	9	1000	OO9417-0659	372747	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	oakley/oakley-holbrook-xl-sunglasses-woodgrain-prizm-tungsten-polarized-372747	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	34.99	0	34.99	26035-DEFAULT-l.jpg	34	26035-DEFAULT-m.jpg	Poseur Blk/Gry Polar	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	30	25-to-50	0.00	[empty string]	Dot Dash Poseur Sunglasses, Black Satin/Grey	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <p><strong>Vintage Collection</strong> ~ Playfully intelligent reflections of the past.</p> <h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	35	35	[empty string]	26035-DEFAULT-s.jpg	10	1000	DSVTNPOS-BPP	283406	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-poseur-sunglasses-black-satin-grey-283406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	27215-DEFAULT-l.jpg	149	27215-DEFAULT-m.jpg	Knoxville Xl Mat Blk/Gry Pol	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	100-to-150	0.00	[empty string]	Electric Knoxville XL Sunglasses, Matte Black/Grey 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]	27215-DEFAULT-s.jpg	10	1000	EE11201042	312423	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-knoxville-xl-sunglasses-matte-black-grey-polarized-312423	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Eagle Patch 110 Snapback Hat $28.00 | view details

NEVER SUMMER Never Summer Bolts Trucker Hat $21.99 | view details

STANCE Stance Sir Harold Women's Tomboy Light Crew Sock $14.00 | view details

OAKLEY Oakley Holbrook Xl Sunglasses, Woodgrain/Prizm Tungsten Polarized $183.00 | view details

DOT DASH Dot Dash Poseur Sunglasses, Black Satin/Grey $35.00 | view details

ELECTRIC Electric Knoxville Xl Sunglasses, Matte Black/Grey Polarized $150.00 | view details

Sale Items

Store blog contact us help