Lycra

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

All Shoes Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Gold,Teal	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	25767-DEFAULT-l.jpg	13	25767-DEFAULT-m.jpg	Women's Judge Me 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]	46	10-to-15	0.00	[empty string]	Stance Judge Me Women's Classic Crew Sock	<p>From the pace makers who've supported Stance since the beginner to the fans we have today, we are proud of each one of you who backs the brand. We created the Judge Me for those who want to show where their alliance lies.</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	25767-DEFAULT-s.jpg	1	1000	W515C18JUD	380517	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-judge-me-womens-classic-crew-sock-380517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	WOODGRAIN,Tan,Black	NIXON	NIXON	MENS	MENS &GT; ACCESSORIES &GT; WALLETS	49.99	0	49.99	25671-DEFAULT-l.jpg	49	25671-DEFAULT-m.jpg	Cape Se Leather Wallet	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]	OH at 200	[empty string]	6	25-to-50	0.00	[empty string]	Nixon Cape SE Bi-Fold Wallet	<p>A collection tailored to the worldly and wise, these are the essentials of those who know.</p>	[empty string]	N	50	50	[empty string]	25671-DEFAULT-s.jpg	2	1000	C2629	342929	WALLETS	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-cape-se-bifold-wallet-342929	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Rincon,PINETREES,SEAFORD,Lava Tubes	DAKINE	DAKINE	MENS	MENS &GT; ACCESSORIES &GT; BACKPACKS	69.99	0	69.99	25889-DEFAULT-l.jpg	69	25889-DEFAULT-m.jpg	Mission 25l Backpack	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]	FA18	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Dakine Mission 25L Snowboard and Ski Backpack	<p>Our popular Mission backpack is the ultimate accomplice ready to go everywhere you go. This super organized pack is equally equipped for mountain missions or navigating the daily grind. Features like a padded iPad sleeve and dedicated laptop sleeve as well as a front organizer pocket will keep you sharp, while the fleece-lined sunglass/goggle pocket, vertical board carry straps and stowable waist belt ensure there's still plenty of fun going down.</p> <ul> <li>Price varies by fabric</li> <li>Fits most 15" laptops</li> <li>Padded laptop sleeve</li> <li>Vertical board carry straps</li> <li>Fleece lined padded iPad sleeve</li> </ul>	[empty string]	N	70	70	[empty string]	25889-DEFAULT-s.jpg	2	1000	10000761-I	372424	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-mission-25l-snowboard-and-ski-backpack-372424	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	25745-DEFAULT-l.jpg	13	25745-DEFAULT-m.jpg	Pressed 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]	44	10-to-15	0.00	[empty string]	Stance Pressed Classic Crew Sock	<p>When the days get dull, liven things up with Pressed, a timeless design with a modern twist.</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	25745-DEFAULT-s.jpg	2	1000	M556D18PRE	380089	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-pressed-classic-crew-sock-380089	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	TOY MACHINE	TOY MACHINE	MENS	MENS &GT; ACCESSORIES &GT; HATS	23.99	0	23.99	27128-DEFAULT-l.jpg	23	27128-DEFAULT-m.jpg	Sect Eye Cap	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	20-to-25	0.00	[empty string]	Toy Machine Sect Eye Cap	<p>Toy Machine Sect Eye Cap Black Unstructured Snap Back</p>	[empty string]	N	23.99	23.99	[empty string]	27128-DEFAULT-s.jpg	2	1000	CAPTM0078	394733	HATS	EMPTY	EMPTY	0	0	0	EMPTY	toy-machine/toy-machine-sect-eye-cap-394733	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	26779-DEFAULT-l.jpg	13	26779-DEFAULT-m.jpg	Dipped 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]	35	10-to-15	0.00	[empty string]	Stance Dipped Classic Crew Sock	<p>Making sure you stay Dipped and fresh to death in monochromatic checker print and palm trees. One-up!</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	26779-DEFAULT-s.jpg	3	1000	M556A19DPP	383788	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-dipped-classic-crew-sock-383788	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Judge Me Women's Classic Crew Sock $14.00 | view details

NIXON Nixon Cape Se Bi- Fold Wallet $50.00 | view details

DAKINE Dakine Mission 25l Snowboard And Ski Backpack $70.00 | view details

STANCE Stance Pressed Classic Crew Sock $14.00 | view details

TOY MACHINE Toy Machine Sect Eye Cap $23.99 | view details

STANCE Stance Dipped Classic Crew Sock $14.00 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

All Shoes Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	127	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	163	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25578-DEFAULT-l.jpg	5	25578-DEFAULT-m.jpg	Sunset Cove Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	147	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sunset Cove	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25578-DEFAULT-s.jpg	804	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	Sand	STANCE	STANCE	WOMENS	WOMENS &GT; 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	2	1000	W515D18LEI	380512	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	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]	2
5	Black/Red	ARCADE	ARCADE	WOMENS	WOMENS &GT; ACCESSORIES	25.99	0	25.99	25907-DEFAULT-l.jpg	25	25907-DEFAULT-m.jpg	The Ranger 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]	STRETCH	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Arcade Ranger Belt, Black/Red	<p>Lightweight, low-profile and stretch make the Arcade Ranger the perfect belt for all your adventures. A superior fit and ultimate comfort come from an elastic stretch webbing that is durable and strong. This adventure belt has one size fits all sizing thanks to a micro-adjust belt buckle. No metal, no worries, this belt makes airport security a breeze. Built from machine washable materials means you can leave the belt in your pants on laundry day.</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> <form enctype="multipart/form-data" method="post"> </form>	[empty string]	N	26	26	[empty string]	25907-DEFAULT-s.jpg	2	1000	A11102-16	384912	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-ranger-belt-black-red-384912	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VON ZIPPER	VON ZIPPER	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	159.99	0	159.99	25985-DEFAULT-l.jpg	159	25985-DEFAULT-m.jpg	Lesmore Blk Satin/Wild Silv 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]	2	150-to-200	0.00	[empty string]	Von Zipper Lesmore Sunglasses, Black Satin/Wild Silver Flash Polarized	<p><strong>Story: </strong>Say hello to the Lesmore. As the name invokes, it’s a perfect combo of less and more, meaning you get a frame free of glitz and chock full of things you really need—like a modern silhouette, polycarbonate lenses and an array of colors to make sure you’re kitted out for any adventurous occasion. We like to think the Lesmore is the balance you need for a life dedicated to doing things just a bit different.</p> <p><strong>Specifications:</strong><br /> / Modern fit<br /> / Polarized Lens<br /> / 100% UV protection<br /> / Base 6 spherical lens <br /> / Impact-resistant polycarbonate lens<br /> / Nylon Grilamid frame<br /> / Made in Italy</p>	[empty string]	N	160	160	[empty string]	25985-DEFAULT-s.jpg	5	1000	SMPF5LES-PVC	357632	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	von-zipper/von-zipper-lesmore-sunglasses-black-satin-wild-silver-flash-polarized-357632	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

STANCE Stance Leiday Women's 200 Needle Crew Sock $14.00 | view details

ARCADE Arcade Ranger Belt, Black/Red $26.00 | view details

VON ZIPPER Von Zipper Lesmore Sunglasses, Black Satin/Wild Silver Flash Polarized $160.00 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	64.99	0	64.99	25697-DEFAULT-l.jpg	64	25697-DEFAULT-m.jpg	Old Skool 92 Pro Black/White/Red	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	178	50-to-100	0.00	[empty string]	Vans Old Skool Pro Skate Shoe, Black/White	<p>The Old Skool Pro, a Vans classic upgraded for enhanced performance, features sturdy canvas and suede 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 made of a rubber that offers grip and support. The Old Skool 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	65	65	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	25697-DEFAULT-s.jpg	15	1000	VN000ZD4Y28	316186	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-old-skool-pro-skate-shoe-black-white-316186	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Black	STANCE	STANCE	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	27118-DEFAULT-l.jpg	14	27118-DEFAULT-m.jpg	Boys Neon Tropics Bb Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	Stance Neon Tropics Boys Boxer Brief	<p>Bright, colorful graphics contrasting an all-black background, Boys Neon Tropics is sure to signify his vibrant personality.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief</li> <li>3.5' Inseam Length</li> <li>Feather-Seam™ Construction</li> <li>Exposed Elastic Core-flex™ Waistband</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash Cold</li> <li>Tumble Dry Low</li> </ul>	[empty string]	N	15	15	Small,Medium,Large	27118-DEFAULT-s.jpg	47	1000	B803A19NEN	383919	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-neon-tropics-boys-boxer-brief-383919	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	4929-DEFAULT-l.jpg	49	4929-DEFAULT-m.jpg	Authentic Black/Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	SLIM	[empty string]	[empty string]	BLACK	[empty string]	SUMMER	[empty string]	[empty string]	[empty string]	156	25-to-50	0.00	[empty string]	Vans Authentic Skate Shoe, Black/Black	<p>The Authentic, Vans original and now iconic style, is a simple low top, lace-up with durable canvas upper, metal eyelets, Vans flag label and Vans original Waffle Outsole.</p> <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	4929-DEFAULT-s.jpg	48	1000	VN000EE3BKA	238892	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-authentic-skate-shoe-black-black-238892	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	59.99	0	59.99	6509-DEFAULT-l.jpg	59	6509-DEFAULT-m.jpg	Old Skool Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	MEDIUM	[empty string]	[empty string]	[empty string]	SKATE	SPRING	8 - LAST SPRING	[empty string]	[empty string]	194	50-to-100	0.00	[empty string]	Vans Old Skool Skate Shoe, Black/White	<p>The Old Skool, Vans classic skate shoe and the first to bare the iconic side stripe, has a low-top lace-up silhouette with a durable suede and canvas upper with padded tongue and lining and Vans signature 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	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,14	6509-DEFAULT-s.jpg	51	1000	VN000D3HY28	248351	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-old-skool-skate-shoe-black-white-248351	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25941-DEFAULT-l.jpg	8	25941-DEFAULT-m.jpg	Costa C- Line 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]	OH at 200	[empty string]	1	5-to-10	0.00	[empty string]	Costa Del Mar C-Line Sunglasses Retainer, Black	<p>Costa C-Line™ Retainer. Ultra-thin sunglass retainer. Lightweight. <strong>End-to-End Measurement: </strong>20"</p>	[empty string]	N	8.99	8.99	[empty string]	25941-DEFAULT-s.jpg	68	1000	CE11	349327	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-cline-sunglasses-retainer-black-349327	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Navy	STANCE	STANCE	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	27119-DEFAULT-l.jpg	14	27119-DEFAULT-m.jpg	Boys Shark Tooth Bb Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Stance Shark Tooth Boys Boxer Brief	<p>They never stop moving and have a ferocious appetite. Sounds like someone you know? Put some excitement in his wardrobe with Boys Shark Tooth.</p> <p>FEATURES</p> <ul> <li>Fitted boxer brief</li> <li>3.5'' Inseam Length</li> <li>Feather-Seam™ Construction</li> <li>Exposed Elastic Core-flex™ Waistband</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash Cold</li> <li>Tumble Dry Low</li> </ul>	[empty string]	N	15	15	Medium,Large	27119-DEFAULT-s.jpg	81	1000	B803A19SHA	383920	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-shark-tooth-boys-boxer-brief-383920	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VANS Vans Old Skool Pro Skate Shoe, Black/White $65.00 | view details

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

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

VANS Vans Old Skool Skate Shoe, Black/White $60.00 | view details

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

STANCE Stance Shark Tooth Boys Boxer Brief $15.00 | view details

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Black,Red,White	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25725-DEFAULT-l.jpg	13	25725-DEFAULT-m.jpg	Repeat Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	53	10-to-15	0.00	[empty string]	Stance Repeat Classic Crew Sock	<p>Not to boast, but we think we're great. Rep Stance in style with Repeat, repeat, repeat. Is there an echo in here?</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	Medium,Large	25725-DEFAULT-s.jpg	5	1000	M546D18REP	380169	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-repeat-classic-crew-sock-380169	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,White	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25744-DEFAULT-l.jpg	13	25744-DEFAULT-m.jpg	Barrio 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]	H17	[empty string]	[empty string]	[empty string]	22	10-to-15	0.00	[empty string]	Stance Barrio 2 200 Needle Crew Sock	<p>As iconic as they are original, as functional as they are fashionable, bandanas are simply badass. They also serve as the inspiration for the Barrio 2.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Cushioning</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	25744-DEFAULT-s.jpg	10	1000	M545D17BAR	361350	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-barrio-2-200-needle-crew-sock-361350	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey,Blue	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	11.99	0	11.99	25735-DEFAULT-l.jpg	11	25735-DEFAULT-m.jpg	Shasta 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]	34	10-to-15	0.00	[empty string]	Stance Shasta Classic Crew Sock	<p>Put some spirit in your style with Stance's Shasta. With its classic tribal print and crisp appearance, you'll be rain dancing with each step.</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	12	12	Medium,Large	25735-DEFAULT-s.jpg	14	1000	M556D18SHA	380081	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-shasta-classic-crew-sock-380081	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Navy	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	11.99	0	11.99	25736-DEFAULT-l.jpg	11	25736-DEFAULT-m.jpg	Lyonz 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]	[empty string]	[empty string]	17	10-to-15	0.00	[empty string]	Stance Lyonz Classic Crew Sock	<p>We love a good geometric design, especially in the fall. The Lyonz offers thick acentric lines with pops of diverse color that brings the design full circle.</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	12	12	Medium,Large	25736-DEFAULT-s.jpg	33	1000	M556C18LYO	370581	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-lyonz-classic-crew-sock-370581	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ADIDAS	ADIDAS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	26798-DEFAULT-l.jpg	69	26798-DEFAULT-m.jpg	Busenitz Vulc Dgh Solid Grey/Black/Gum	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]	10	50-to-100	0.00	[empty string]	Adidas Busenitz Vulc Skate Shoe, Grey/Black/Gum	<p>Stay under the radar and in control with this lower-profile edition of the legendary Busenitz shoe. Designed for outstanding board feel and reduced sidewalls, these shoes excel in tough, technical situations. A durable suede upper stands up to whatever the streets throw at you.</p>	[empty string]	N	70	70	8,8.5,9,9.5,10,10.5,11,11.5,12	26798-DEFAULT-s.jpg	37	1000	DB3195	382237	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	adidas/adidas-busenitz-vulc-skate-shoe-grey-black-gum-382237	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	54.99	0	54.99	25705-DEFAULT-l.jpg	54	25705-DEFAULT-m.jpg	Authentic Pro (Suede) 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]	BLK/WHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	42	50-to-100	0.00	[empty string]	Vans Suede Authentic Pro Skate Shoe, Black	<p>The Suede Authentic Pro, a Vans classic upgraded for enhanced performance, features sturdy suede 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 made of a rubber that offers grip and support. The Authentic Pro also includes Pro Vulc Lite construction to deliver the best in boardfeel, flex, and traction, and 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	6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25705-DEFAULT-s.jpg	44	1000	VN0A3479A6O	351161	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-suede-authentic-pro-skate-shoe-black-351161	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Repeat Classic Crew Sock $14.00 | view details

STANCE Stance Barrio 2 200 Needle Crew Sock $14.00 | view details

STANCE Stance Shasta Classic Crew Sock $12.00 | view details

STANCE Stance Lyonz Classic Crew Sock $12.00 | view details

ADIDAS Adidas Busenitz Vulc Skate Shoe, Grey/Black/Gum $70.00 | view details

VANS Vans Suede Authentic Pro Skate Shoe, Black $55.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]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	99.99	0	99.99	26638-DEFAULT-l.jpg	99	26638-DEFAULT-m.jpg	Nickel Rasta 27in Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Penny Nickel Rasta Complete Skateboard, 27"	<p>The Penny Nickel 27" Skateboard is the big brother of the Penny Original 22".</p> <p>For those who appreciate a little extra plastic under your feet, this ticks all the boxes. Featuring our secret plastic formula, this Penny Nickel 27" is matched with Custom 4" yellow and green Penny skateboard trucks, Red 59mm 83A super smooth Penny skate wheels, and Penny Abec7 bearings. Please note, Nickel owners have reported drastic increases in summery vibrations.</p>	[empty string]	N	99.99	99.99	27IN	26638-DEFAULT-s.jpg	1	1000	PNYCOMP27100	391222	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-nickel-rasta-complete-skateboard-27-391222	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	129.99	0	129.99	26312-DEFAULT-l.jpg	129	26312-DEFAULT-m.jpg	Dinghy Owl Embossed Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	100-to-150	0.00	[empty string]	Landyachtz Dinghy Owl Complete Cruiser Skateboard	<p style="margin-left:0px; margin-right:0px; text-align:left">"My life changed the day I bought a Dinghy. I traded in my bus pass for fresh air and a cool breeze. I started exploring the city in a brand new way, no longer enduring a crowded bus filled with people glued to their phones. Getting around used to be a chore, now everything is an adventure. My friends started doing the same thing and now we smile every time we skate past the bus. Life is better on a Dinghy." </p> <p style="margin-left:0px; margin-right:0px; text-align:left">- Sincerely, everyone who rides a Dinghy </p> <p style="margin-left:0px; margin-right:0px; text-align:left"> </p> <p style="margin-left:0px; margin-right:0px; text-align:left">28.5" Length I 8" Width I 14.6" Wheelbase</p> <p style="margin-left:0px; margin-right:0px; text-align:left">100% Canadian Maple</p>	[empty string]	N	129.99	129.99	28.5	26312-DEFAULT-s.jpg	14	1000	CP-UBDYEMB	361117	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-dinghy-owl-complete-cruiser-skateboard-361117	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	KRUX	KRUX	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD TRUCKS	19.99	0	19.99	26866-DEFAULT-l.jpg	19	26866-DEFAULT-m.jpg	White Dlk 8.0 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]	4	15-to-20	0.00	[empty string]	Krux DLK Standard Skateboard Trucks, White	<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. Available in black and white.</p>	[empty string]	N	19.99	19.99	8.0	26866-DEFAULT-s.jpg	16	1000	33132350-80	387668	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD TRUCKS	krux/krux-dlk-standard-skateboard-trucks-white-387668	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	SPITFIRE	SPITFIRE	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	39.99	0	39.99	26743-DEFAULT-l.jpg	39	26743-DEFAULT-m.jpg	F4 99 Overlay Radials Natural Whl 4- Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Spitfire Formula Four 99D Overlay Skateboard Wheels, 53mm	<p>Spitfire Formula Four 99D Overlay Skateboard Wheels, 53mm</p>	[empty string]	N	39.99	39.99	53MM	26743-DEFAULT-s.jpg	16	1000	2111018953	391807	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-skateboard-wheels-53mm-391807	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; 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	22	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]
6	[empty string]	SKULLCANDY	SKULLCANDY	SKATEBOARDS	SKATEBOARDS &GT; VIDEO AND AUDIO	20.99	0	20.99	21949-DEFAULT-l.jpg	20	21949-DEFAULT-m.jpg	Ink ` D Mic ` D 2.0 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]	9	20-to-25	0.00	[empty string]	Skullcandy Ink'd 2.0 Mic'd Ear Bud Headphone, 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	20.99	20.99	[empty string]	21949-DEFAULT-s.jpg	33	1000	S2IKDY-003	285039	EMPTY	EMPTY	EMPTY	0	0	0	VIDEO AND AUDIO	skullcandy/skullcandy-inkd-20-micd-ear-bud-headphone-black-285039	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

PENNY Penny Nickel Rasta Complete Skateboard, 27 " $99.99 | view details

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

KRUX Krux Dlk Standard Skateboard Trucks, White $19.99 | view details

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

BONES Bones Hardcore Skateboard Bushings $9.99 | view details

SKULLCANDY Skullcandy Ink ' D 2.0 Mic ' D Ear Bud Headphone, Black $20.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; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; FINS	24.99	0	24.99	26106-DEFAULT-l.jpg	24	26106-DEFAULT-m.jpg	Fcs Ii Connect Gf 8 `	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]	2	20-to-25	0.00	[empty string]	FCS II Connect GF Longboard Fin - 8"	<p>Versatile, high performance fin. Connect turns and move up and down the board.</p> <p><strong>Overview</strong></p> <ul> <li> <p>Neutral, well balanced template.</p> </li> <li> <p>Versatile, high performance Longboard (LB) fin for all conditions. </p> </li> <li> <p>Offers a combination of drive, speed and response for modern longboarding.</p> </li> <li> <p>Turn and Connect: Seamlessly connect turns and move up and down the board.</p> </li> <li>Based on the FCS Dolphin Longboard template.<br />  </li> <li> <p>2 + 1 Compatible.</p> </li> </ul>	<p>FCS II Connect GF Surfboard Fin 8'</p>	N	25	25	[empty string]	26106-DEFAULT-s.jpg	10	1000	FCON-GF01-LB-80-R	331694	SUP ACCESSORIES	FINS	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-ii-connect-gf-longboard-fin-8-331694	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	53.99	0	53.99	4599-DEFAULT-l.jpg	53	4599-DEFAULT-m.jpg	Sp2 Reef Booties	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	50-to-100	0.00	[empty string]	SP2 REEF BOOTIES	[empty string]	[empty string]	N	53.98	53.98	7,12	4599-DEFAULT-s.jpg	19	1000	3405-323	254291	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/-254291	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; DIVE &GT; FINS	66.99	0	66.99	26138-DEFAULT-l.jpg	66	26138-DEFAULT-m.jpg	Tech 2 Fin Ice Blue - Medium/Large	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	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]	1	50-to-100	0.00	[empty string]	Hydro Tech 2 Swim Fins - Ice Blue - Medium/Large	<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 pool swimming and swim squads.</p> </li> </ul>	<p>Hydro Tech 2 Swim Fins - Ice Blue - Medium Large</p>	N	67	67	[empty string]	26138-DEFAULT-s.jpg	22	1000	7902-IBL-MLF	348430	FINS	EMPTY	EMPTY	0	0	0	EMPTY	hydro/hydro-tech-2-swim-fins-ice-blue-medium-large-348430	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	DORSAL	DORSAL	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	25.99	0	25.99	26064-DEFAULT-l.jpg	25	26064-DEFAULT-m.jpg	Aero Sup Surf Rack Pads 19 Inch Long - 2	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Dorsal Aero Roof Rack Pads - SUP, Snowboard - 20"	<p><strong>Are You Looking For An Effective And Efficient Way To Convey Surfboards As Well As Stand-Up Paddle Boards</strong></p> <p><strong>Start Using The Dakine / Thule or Yakima Style Dorsal SUP Rack Pads Set, That Is Armed With Essential Features That Make This Product Apart From The Rest.</strong></p> <ul> <li> <ul> <li> <p><strong>Easy Convey Of Surfboards As Well As Stand-Up Paddle Boards</strong> The 20 inch (Dakine Style) Dorsal SUP Rack Pads set <em>fit most aero bars with a 5.5 - 8.0" inch circumference</em> (see diagram) and offer an effective way to convey surfboards, as well as stand-up paddle boards.</p> </li> <li> <p><strong>Reliable Material For Longer Life</strong> - This rack pads set is integrated with top grade EVA foam and is secured by a weather proof nylon sleeve. It comes with pads that will secure board from your cars cross bars. The middle positioned closure straps and keep the rack pads secured while using. This is also perfect for bigger surfboard roof rack transport in a smooth aerodynamic style. This is wide enough to transport surfboard with care.</p> </li> <li> <p><strong>Securing Your Surf Boards</strong> - Keep your surf board secure and safe for the next journey with the amazing and state of the art Dorsal Origin Car Surf, SUP Rack Pads; which is made of with durable 600D polyester material. Top of the bar is padded for sleek fit. It comes with heavy duty velcro, 19 inches long pad as well as it fits a lot of factory auto car racks.</p> </li> </ul> </li> </ul>	[empty string]	N	25.94	25.94	[empty string]	26064-DEFAULT-s.jpg	35	1000	DORSAL-RACKPADS-19IN	368239	SUP ACCESSORIES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dorsal/dorsal-aero-roof-rack-pads-sup-snowboard-20-368239	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	89.99	0	89.99	26244-DEFAULT-l.jpg	89	26244-DEFAULT-m.jpg	Jordy Smith Small Tri Fin 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	50-to-100	0.00	[empty string]	Futures Jordy Smith Tri-Fins, Small	<p>The Jordy Small Honeycomb is a small size Balanced fin with a Ride Number of 5.0. It's a scaled down version of Jordy Smith's signature model. This fin's neutral flex pattern combined with additional rake and a thinner tip provides a great blend of hold when on rail and release off of the top. This is an excellent fin for the up-and-coming surfer looking for more performance.</p> <table cellspacing="0" class="specf-table" style="-webkit-text-stroke-width:0px; background-color:#ffffff; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; width:537.6px; word-spacing:0px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> <th style="text-align:left">Center Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>13.98</td> <td>13.98</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.40</td> <td>4.40</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.45</td> <td>4.45</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	90	90	[empty string]	26244-DEFAULT-s.jpg	37	1000	1003-912-00	299541	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-jordy-smith-trifins-small-299541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	24.99	0	24.99	25874-DEFAULT-l.jpg	24	25874-DEFAULT-m.jpg	Baja Tie Down Straps 12'set Of 2	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	Dakine Baja Tie Down Rack Straps	<p>The Dakine Baja Tie Down Straps are heavy-duty straps designed for car roof racks. These straps are sold in sets of two 12-foot straps with 1-3/8 inch cam buckles for secure tightening. The Baja Tie Down Straps also feature a protective neoprene buckle housing.</p> <ul> <li>Heavy duty 1 3/8" [ 35mm ] cam buckle</li> <li>Neoprene buckle housing</li> <li>Carrying bag</li> <li>Set of two straps</li> </ul>	[empty string]	N	25	25	[empty string]	25874-DEFAULT-s.jpg	50	1000	8840560	271110	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dakine/dakine-baja-tie-down-rack-straps-271110	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Connect Gf Longboard Fin - 8 " $25.00 | view details

FCS Sp2 Reef Booties $53.98 | view details

HYDRO Hydro Tech 2 Swim Fins - Ice Blue - Medium/Large $67.00 | view details

DORSAL Dorsal Aero Roof Rack Pads - Sup, Snowboard - 20 " $25.94 | view details

FUTURE FINS Futures Jordy Smith Tri- Fins, Small $90.00 | view details

DAKINE Dakine Baja Tie Down Rack Straps $25.00 | view details

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	199.99	0	199.99	26362-DEFAULT-l.jpg	199	26362-DEFAULT-m.jpg	Shredder	N	KIDS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Never Summer Shredder Kids Snowboard, 2018	<p>Never Summer Shredder Kids Snowboard, 2018</p>	[empty string]	N	199.99	199.99	90,100,110	26362-DEFAULT-s.jpg	1	1000	SHREDDER-H	358732	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-shredder-kids-snowboard-2018-358732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	519.99	0	519.99	26369-DEFAULT-l.jpg	519	26369-DEFAULT-m.jpg	Snowtrooper X	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	5	500-and-over	0.00	[empty string]	Never Summer Snowtrooper X Snowboard, 2019	<p>The Snowtrooper is the all mountain equalizer and a great board for any riding style. It features our Original Rocker Camber Profile for amazing float and playfulness, a mid flex for all mountain versatility, with the supercharged feel of a slightly setback stance. The Trooper synchronizes your ride for the entire mountain. It’s the Swiss Army Knife of snowboards. X - Wide version of the original</p>	[empty string]	N	519.99	519.99	160,164	26369-DEFAULT-s.jpg	2	1000	SNOWTROOPERX-I	374751	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-snowtrooper-x-snowboard-2019-374751	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	509.99	0	509.99	26345-DEFAULT-l.jpg	509	26345-DEFAULT-m.jpg	Wmns Proto Type Two	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	11	500-and-over	0.00	[empty string]	Never Summer Proto Type Two Women's Snowboard, 2019	<p>The Women’s Proto Type Two is the perfect all around asymmetrical twin. It features a new progressive shape, deeper heelside sidecut, Ripsaw Rocker Camber Profile and a perfect mid flex. It’s the most versatile board you’ll ever ride. Pop in and out of the park, carve the steeps and maneuver through trees like you’re riding three different boards. The Women’s Proto is exactly your type.</p>	[empty string]	N	509.99	509.99	145,148,151	26345-DEFAULT-s.jpg	8	1000	WPROTO2-I	374755	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-proto-type-two-womens-snowboard-2019-374755	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	529.99	0	529.99	26352-DEFAULT-l.jpg	529	26352-DEFAULT-m.jpg	Maverix	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	8	500-and-over	0.00	[empty string]	Never Summer Maverix Snowboard, 2019	<p>While standing on the edge of dawn, the sound of the waves growing louder, we stared out into the vastness. Anticipation ruled the moment. We were anxious as we imagined the approaching exhilaration. That’s when it hit us...Maverix! The perfect snowboard. A super nimble yet cushy ride with incredible responsiveness. Amazing performance and stylized fluidity that crushes all conditions...not just the best conditions. Leave everyone wondering where you found that surfy steez. LT - Narrower version of the original.</p>	[empty string]	N	529.99	529.99	157,160,163	26352-DEFAULT-s.jpg	10	1000	MAVERIX-I	374735	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-maverix-snowboard-2019-374735	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	WHT/BLK	UNION	UNION	SNOWBOARDING	SNOWBOARDING &GT; BINDINGS	149.99	0	149.99	25569-DEFAULT-l.jpg	149	25569-DEFAULT-m.jpg	Flite Pro Ltd	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]	SMU	SMU	2018	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Union Flite Pro Snowboard Bindings 2018 - Large-White/Black	[empty string]	Union Flite Pro Snowboard Bindings 2018 - Large-White/Black	N	149.95	149.95	Small	25569-DEFAULT-s.jpg	12	1000	173710	365837	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	union/union-flite-pro-snowboard-bindings-2018-largewhite-black-365837	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	519.99	0	519.99	26357-DEFAULT-l.jpg	519	26357-DEFAULT-m.jpg	Peacemaker	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	1	500-and-over	0.00	[empty string]	Never Summer Peacemaker Snowboard, 2019	<p>The Peacemaker ain’t some sheepherding fan boy pro-model. This true twin six-shooter was created using ride and design input from super-shred Dylan Alito. World famous tattoo artist Bryan Henry hand painted the graphic. A soft mid-section flex gets you locked in on rails and pressing a mile high. The nose and tail we made significantly stiffer for huge launches and incredibly stable landings. The extended contact points will have you hanging low and digging trenches. We added a Blower Stance for when the old dusty trail is covered in POW. The Peacemaker makes certain that you’re always bringing the right board to the shootout. #NotAProModel</p>	[empty string]	N	519.99	519.99	152	26357-DEFAULT-s.jpg	30	1000	PEACEMAKER-I	374675	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-peacemaker-snowboard-2019-374675	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Shredder Kids Snowboard, 2018 $199.99 | view details

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

NEVER SUMMER Never Summer Proto Type Two Women's Snowboard, 2019 $509.99 | view details

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

UNION Union Flite Pro Snowboard Bindings 2018 - Large- White/Black $149.95 | view details

NEVER SUMMER Never Summer Peacemaker Snowboard, 2019 $519.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	[empty string]	SUN BUM	SUN BUM	ACCESSORIES	ACCESSORIES &GT; SUNSCREEN/SKIN CARE	14.99	0	14.99	25590-DEFAULT-l.jpg	14	25590-DEFAULT-m.jpg	Mineral 3 Oz Spf 50 Lotion	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]	294	10-to-15	0.00	[empty string]	Sun Bum Mineral SPF 50 Sunscreen Lotion, 3.0 oz.	<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, lightweight and non-greasy, our SPF 50 Mineral Moisturizing Sunscreen Lotion is made of safe minerals to protect skin from UVA/UVB rays.</p>	[empty string]	N	14.99	14.99	[empty string]	25590-DEFAULT-s.jpg	1	1000	20-62350	377104	EMPTY	EMPTY	EMPTY	0	0	0	SUNSCREEN/SKIN CARE	sun-bum/sun-bum-mineral-spf-50-sunscreen-lotion-30-oz-377104	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	31.99	0	31.99	26046-DEFAULT-l.jpg	31	26046-DEFAULT-m.jpg	Sidecar Blk Satin/Gld Chrome	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]	UPDATE	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Dot Dash Sidecar Sunglasses, Black Satin/Gold Chrome	<p><strong>Vintage Collection ~ </strong>Playfully intelligent reflections of the past.</p> <h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Base-6 Polycarbonate Lens</li> <li>Polycarbonate Frame</li> <li>Hardened Steel Hinge</li> </ul>	[empty string]	N	32	32	[empty string]	26046-DEFAULT-s.jpg	3	1000	DSVTFSID-BCM	283085	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-sidecar-sunglasses-black-satin-gold-chrome-283085	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ACCESSORIES	ACCESSORIES &GT; HATS	24.99	0	24.99	25962-DEFAULT-l.jpg	24	25962-DEFAULT-m.jpg	Xl Structured Logo Performace Hat Navy	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]	4	20-to-25	0.00	[empty string]	Costa Del Mar Structured Performance Trucker Hat, Navy	<ul> <li>Pinhole mesh back panels and deeper crown to fit larger sizes.</li> <li>Enhanced moisture management</li> <li>Breathable for added comfort in hot conditions</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	25962-DEFAULT-s.jpg	3	1000	HA 73N	371549	EMPTY	EMPTY	EMPTY	0	0	0	HATS	costa-del-mar/costa-del-mar-structured-performance-trucker-hat-navy-371549	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Green,Blue,Purple	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25730-DEFAULT-l.jpg	13	25730-DEFAULT-m.jpg	Bobby 2 Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	62	10-to-15	0.00	[empty string]	Stance Bobby 2 Classic Crew Sock	<p>Want a classic looking sock that's a cut above the rest? Stance would like you to meet your new bff, Bobby 2, he's friendly on the feet, and always in style, take him with you for any occasion.</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	25730-DEFAULT-s.jpg	3	1000	M556D18BOB	380197	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-bobby-2-classic-crew-sock-380197	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey,Black/White	NEVER SUMMER	NEVER SUMMER	ACCESSORIES	ACCESSORIES &GT; HATS	27.99	0	27.99	26395-DEFAULT-l.jpg	27	26395-DEFAULT-m.jpg	Bullet Eagle 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]	2017	[empty string]	[empty string]	[empty string]	52	25-to-50	0.00	[empty string]	Never Summer Bullet Eagle 110 Snapback Hat	<p>Never Summer Bullet Eagle 110 Snapback Hat</p>	<p>Never Summer Bullet Eagle Patch Adjustable Snapback Hat (Royal Blue)</p>	N	27.99	28	[empty string]	26395-DEFAULT-s.jpg	6	1000	HTBULLET110	345709	EMPTY	EMPTY	EMPTY	0	0	0	HATS	never-summer/never-summer-bullet-eagle-110-snapback-hat-345709	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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/Khaki	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	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]	6	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	7	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

SUN BUM Sun Bum Mineral Spf 50 Sunscreen Lotion, 3.0 Oz. $14.99 | view details

DOT DASH Dot Dash Sidecar Sunglasses, Black Satin/Gold Chrome $32.00 | view details

COSTA DEL MAR Costa Del Mar Structured Performance Trucker Hat, Navy $24.99 | view details

STANCE Stance Bobby 2 Classic Crew Sock $14.00 | view details

NEVER SUMMER Never Summer Bullet Eagle 110 Snapback Hat $27.99 to $28.00 | view details

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

Sale Items

Store blog contact us help

brands

Price

Colors

Sizes