Boys

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	White	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	25780-DEFAULT-l.jpg	13	25780-DEFAULT-m.jpg	Somme 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]	10	10-to-15	0.00	[empty string]	Stance Somme Classic Crew Sock	<p>Stripes can power up any casual look to an entirely new level. Take a step into sophistication with the Somme.</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	25780-DEFAULT-s.jpg	2	1000	M556C18SOM	370590	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-somme-classic-crew-sock-370590	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	G-SHOCK	G-SHOCK	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	99.99	0	99.99	26296-DEFAULT-l.jpg	99	26296-DEFAULT-m.jpg	Dw- 5600 Blue/Pink	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]	G-Shock Digital Watch, Blue/Pink	<p>2018 will mark the 35th year since G-SHOCK first started revolutionizing personal timekeeping back in 1983. These new models are inspired by the '80s street culture that was in vogue at the time the first G-SHOCK hit the scene. The base model is the DW-5600, incorporating the deep coloring and functions that has made the DW-5000 series a favorite the world over. Bold colors that were in style during the '80s create a look that is cool and reserved. Large blocks of different colors are combined for styles that always look great. The SHOCK REGIST logo is featured on the backlight pattern.</p> <ul style="list-style-type:disc; margin-left:24.3375px"> <li>Case / bezel material: Resin</li> <li>Resin Band</li> <li>Shock Resistant</li> <li>Mineral Glass</li> <li>200-meter water resistance</li> </ul>	[empty string]	N	100	100	[empty string]	26296-DEFAULT-s.jpg	2	1000	DW5600TB-4B	379770	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	g-shock/gshock-digital-watch-blue-pink-379770	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Heather Grey,Sand,HGU,DDN	RVCA	RVCA	MENS	MENS &GT; ACCESSORIES &GT; HATS	27.99	0	27.99	26691-DEFAULT-l.jpg	27	26691-DEFAULT-m.jpg	Camps 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]	SP19	[empty string]	[empty string]	[empty string]	58	25-to-50	0.00	[empty string]	RVCA Camps Snapback Hat	<p>PREPARED FOR IT ALL, THE RVCA CAMPS SNAPBACK HAT DELIVERS A SOLID, STRUCTURED SNAPBACK WITH A UTILITARIAN FEEL. MADE FORM A WOOL BLEND AND FINISHED WITH A LEATHER RVCA PATCH, THE MENS HAT DELIVERS A PREMIUM FEEL TO AN EVERYDAY STAPLE.</p>	[empty string]	N	28	28	One Size	26691-DEFAULT-s.jpg	2	1000	MAHWTRCA	383245	HATS	EMPTY	EMPTY	0	0	0	EMPTY	rvca/rvca-camps-snapback-hat-383245	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	CARVE	CARVE	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	59.99	0	59.99	26019-DEFAULT-l.jpg	59	26019-DEFAULT-m.jpg	Vendetta Mat Brn Stripe 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	50-to-100	0.00	[empty string]	Carve Vendetta Sunglasses, Matte Brown Stripe/Polarized	<p>The Vendetta polarized lens are an exceptional pair of sunglasses. The Vendetta sunglasses have a 5 barrel stainless steel hinge, a polycarbonate frame and metal badging! The Vendetta is a modern twist on a classic pair of sunglasses. The Vendetta come in a variety of lens and frame colours. The Vendetta sunglasses not only look great, but also have 100% UV protection. Our eyewear is top quality.</p>	[empty string]	N	59.99	59.99	[empty string]	26019-DEFAULT-s.jpg	3	1000	2450	362965	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	carve/carve-vendetta-sunglasses-matte-brown-stripe-polarized-362965	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Dark Khaki,Grey Heather,Sage,Black Heather,Black	BILLABONG	BILLABONG	MENS	MENS &GT; BOTTOMS &GT; SHORTS	44.99	0	44.99	26544-DEFAULT-l.jpg	44	26544-DEFAULT-m.jpg	Carter Stretch 21 ` Chino Short	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]	119	25-to-50	0.00	[empty string]	Billabong Carter Stretch Shorts	<p>Cut out the static with the utilitarian workwear short, infused with stretch. Designed to make moves, the essential chino workwear short is made from a durable stretch blend twill.</p> <ul> <li>Workwear chino shorts.</li> <li>Front slant pockets.</li> <li>Back welt pockets.</li> <li>Zip and button fly.</li> <li>Regular Length: 21 inch outseam.</li> <li>Material: 8.5 oz stretch twill.</li> </ul>	[empty string]	N	44.95	44.95	28,29,30,31,32,33,34,36,38,40	26544-DEFAULT-s.jpg	4	1000	M236TBCS	382569	SHORTS	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-carter-stretch-shorts-382569	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Grey,Maroon	THRASHER	THRASHER	MENS	MENS &GT; ACCESSORIES &GT; BEANIES	20.99	0	20.99	26469-DEFAULT-l.jpg	20	26469-DEFAULT-m.jpg	Skate And Destroy Fold Beanie	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]	[empty string]	[empty string]	12	20-to-25	0.00	[empty string]	Thrasher Skategoat/Skate and Destroy Beanie	<p>Skate And Destroy logo is visible when worn cuffed, Skategoat logo when rocking it full-length. Get it in black, gray, or maroon.</p>	<p>Thrasher Davis Snapback</p>	N	20.99	20.99	[empty string]	26469-DEFAULT-s.jpg	5	1000	3138069	289521	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	thrasher/thrasher-skategoat-skate-and-destroy-beanie-289521	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Somme Classic Crew Sock $14.00 | view details

G-SHOCK G- Shock Digital Watch, Blue/Pink $100.00 | view details

RVCA Rvca Camps Snapback Hat $28.00 | view details

CARVE Carve Vendetta Sunglasses, Matte Brown Stripe/Polarized $59.99 | view details

BILLABONG Billabong Carter Stretch Shorts $44.95 | view details

THRASHER Thrasher Skategoat/Skate And Destroy Beanie $20.99 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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	258	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	140	5-and-under	0.00	[empty string]	Sun Bum CocoBalm Lip Balm, Groove Berry	<p>These moisturizing and hydrating little beauties have a soothing blend of Coconut Oil and Aloe Vera that make our kissers super smooth and really happy. </p>	[empty string]	Y	3.99	3.99	[empty string]	25582-DEFAULT-s.jpg	334	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	944	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	[empty string]	OTIS	OTIS	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	219.99	0	219.99	27252-DEFAULT-l.jpg	219	27252-DEFAULT-m.jpg	Life On Mars Wood Mat/Brn 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]	1	200-to-250	0.00	[empty string]	Otis Life on Mars Sunglasses, Black/Grey Polar	<p>Life on Mars provides a clean look with all day comfort. Featuring a lightweight swiss grilamid material injected into a subtle rectangular frame, this design is extremely wearable for those who are constantly on the move. </p>	[empty string]	N	220	220	[empty string]	27252-DEFAULT-s.jpg	1	1000	21-1802P	357345	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	otis/otis-life-on-mars-sunglasses-black-grey-polar-357345	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
5	[empty string]	DOT DASH	DOT DASH	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	39.99	0	39.99	27201-DEFAULT-l.jpg	39	27201-DEFAULT-m.jpg	Portal Tort/Brz Poly 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]	9	25-to-50	0.00	[empty string]	Dot Dash Portal Sunglasses, Tortoise Bronze/Grey Polarized	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>Polarized Lens</li> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	40	40	[empty string]	27201-DEFAULT-s.jpg	3	1000	DSLRFPOR-TPP	308341	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-portal-sunglasses-tortoise-bronze-grey-polarized-308341	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUNCLOUD	SUNCLOUD	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	49.99	0	49.99	26028-DEFAULT-l.jpg	49	26028-DEFAULT-m.jpg	Mayor Burn Brn/Brn	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	25-to-50	0.00	[empty string]	Suncloud Mayor Medium Fit Sunglasses, Burnished Brown/Brown Polarized Poly	<p>Be in charge when you don the Mayor. Influential styling and masterful design are only equaled by the comfort and effortless wear of this self-assured style. Sport a classic color or step out in a bright frame color or mirror lens option.</p> <p>Lens width: 57.5</p> <p>Lens height: 41.5</p> <p>Nose bridge: 17</p> <p>Temple length: 134</p> <p> </p>	[empty string]	N	49.99	49.99	[empty string]	26028-DEFAULT-s.jpg	6	1000	S-MAPPBRBR	358681	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	suncloud/suncloud-mayor-medium-fit-sunglasses-burnished-brown-brown-polarized-poly-358681	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

OTIS Otis Life On Mars Sunglasses, Black/Grey Polar $220.00 | view details

DOT DASH Dot Dash Portal Sunglasses, Tortoise Bronze/Grey Polarized $40.00 | view details

SUNCLOUD Suncloud Mayor Medium Fit Sunglasses, Burnished Brown/Brown Polarized Poly $49.99 | 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	Stellar,Sleet,Crystal Blue	QUIKSILVER	QUIKSILVER	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; SHORTS	44.99	0	44.99	27076-DEFAULT-l.jpg	44	27076-DEFAULT-m.jpg	Youth Union Heather Amphibian	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]	STRETCH	[empty string]	[empty string]	H17	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Quiksilver Union Heather Boy's Amphibian Boardshorts, 19"	<p>The nuts and bolts</p> <ul> <li><strong>Recycled Fabric:</strong> Repreve™ traceable, recycled 4-way stretch heather polyester made from plastic bottles</li> <li>DryFlight® water-repellent hydrophobic coating</li> <li><strong>Outseam:</strong> 19" outseam, mid length</li> <li>Classic, comfortable regular fit</li> <li><strong>Waist:</strong> Non-corrosive zip fly</li> <li>Button closure</li> <li><strong>Pockets:</strong> Side-entry pockets</li> <li>Back zip-up pocket</li> </ul> <p>Composition</p> <ul> <li> <p>90% Recycled Polyester, 10% Elastane</p> </li> </ul>	[empty string]	N	45	45	23/10S,24/8,25/10,26/12,28/14,29	27076-DEFAULT-s.jpg	33	1000	EQBWS03279	394831	EMPTY	SHORTS	EMPTY	0	0	0	EMPTY	quiksilver/quiksilver-union-heather-boys-amphibian-boardshorts-19-394831	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	82	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]
3	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	83	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]
4	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	KIDS	KIDS	999.99	0	999.99	3037-DEFAULT-l.jpg	999	3037-DEFAULT-m.jpg	Bc Surf Sport In- Store Gift Card	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	FREE	[empty string]	[empty string]	[empty string]	TOP SELLERS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	108	20-to-25	0.00	[empty string]	BC Surf & Sport Gift Card - In-Store or Online use	<p>BC Surf & Sport Gift Card - In-Store or Online use</p>	[empty string]	N	25	1000	[empty string]	3037-DEFAULT-s.jpg	97	1000	BCGC	252213	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bc/bc-surf-sport-gift-card-instore-or-online-use-252213	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Multi,Seashell	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26806-DEFAULT-l.jpg	59	26806-DEFAULT-m.jpg	Sun Dream 1 Pc	N	GIRLS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	Billabong Girls' Sun Dream One Piece Swim	<p>A sweet one piece with saltwater tendencies. Available in a seaside stripe or freshly cut stems, the girls one piece swimsuit features a retro-style bandeau top with a keyhole and thick hanky tie detail at the chest.</p>	[empty string]	N	59.95	59.95	4,7,8,10,12,14	26806-DEFAULT-s.jpg	103	1000	Y107TBSU	387561	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-girls-sun-dream-one-piece-swim-387561	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Red	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	25807-DEFAULT-l.jpg	13	25807-DEFAULT-m.jpg	Boy's Amazing Spiderman Sock	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	RESTRICTED	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	18	10-to-15	0.00	[empty string]	Stance Amazing Spiderman Kids Marvel Comics Crew Sock	<p>Everyone's favorite arachnid, our Amazing Spiderman socks are guaranteed to get your spidey sense tingling. Officially licensed by Marvel and personally-approved by your friendly neighborhood webslinger.</p> <p>FEATURES</p> <ul> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Small,Medium,Large	25807-DEFAULT-s.jpg	124	1000	B515D18AMA	380147	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-amazing-spiderman-kids-marvel-comics-crew-sock-380147	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

QUIKSILVER Quiksilver Union Heather Boy's Amphibian Boardshorts, 19 " $45.00 | view details

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

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

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

BILLABONG Billabong Girls ' Sun Dream One Piece Swim $59.95 | view details

STANCE Stance Amazing Spiderman Kids Marvel Comics Crew Sock $14.00 | view details

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	49.99	0	49.99	6520-DEFAULT-l.jpg	49	6520-DEFAULT-m.jpg	Authentic True White	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]	[empty string]	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	152	25-to-50	0.00	[empty string]	Vans Authentic Skate Shoe, True White	<p>The Authentic, Vans original and now iconic style, is a simple low top, lace-up with durable canvas upper, metal eyelets, Vans flag label and Vans original Waffle Outsole.</p> <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	6520-DEFAULT-s.jpg	2	1000	VN000EE3W00	233920	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-authentic-skate-shoe-true-white-233920	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	8	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]
3	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	79.99	0	79.99	26786-DEFAULT-l.jpg	79	26786-DEFAULT-m.jpg	Berle Pro Rumba Red	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]	BRIGHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	78	50-to-100	0.00	[empty string]	Vans Berle Pro Skate Shoe	<p>Global Skate Team rider Elijah Berle’s first-ever signature shoe - the Berle Pro – pushes the boundaries of skate progression with breakthrough WaffleControl technology, and the deceptively simple silhouette is packed with only the necessary tools for its sole purpose, skateboarding: Duracap-reinforced uppers, new medial gum rubber enhancements for extended toe durability, and LuxLiner for a snug overall fit.</p>	[empty string]	N	80	80	7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26786-DEFAULT-s.jpg	24	1000	VN0A3WKX9D0	383047	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-berle-pro-skate-shoe-383047	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DC	DC	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	26608-DEFAULT-l.jpg	69	26608-DEFAULT-m.jpg	Court Graffik Sq Pewter	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]	16	50-to-100	0.00	[empty string]	DC Court Graffik Skate Shoes, Pewter	<p>The nuts and bolts</p> <ul> <li>Leather, nubuck, suede upper with split quarter panel</li> <li>Foam padded collar and tongue for comfort and support</li> <li>Cupsole construction</li> <li>Ventilation holes for breathability</li> <li>Lightweight mesh tongue</li> <li>DC's trademarked Pill Pattern tread <p> </p> </li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	26608-DEFAULT-s.jpg	28	1000	ADYS100442-PEW	382989	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-court-graffik-skate-shoes-pewter-382989	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	FOOTWEAR	FOOTWEAR	999.99	0	999.99	3037-DEFAULT-l.jpg	999	3037-DEFAULT-m.jpg	Bc Surf Sport In- Store Gift Card	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	FREE	[empty string]	[empty string]	[empty string]	TOP SELLERS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	108	20-to-25	0.00	[empty string]	BC Surf & Sport Gift Card - In-Store or Online use	<p>BC Surf & Sport Gift Card - In-Store or Online use</p>	[empty string]	N	25	1000	[empty string]	3037-DEFAULT-s.jpg	31	1000	BCGC	252213	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bc/bc-surf-sport-gift-card-instore-or-online-use-252213	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	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]	9	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,10,10.5,11,11.5,12	26798-DEFAULT-s.jpg	34	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

STANCE Stance Desert Dinos Classic Crew Sock $14.00 | view details

VANS Vans Berle Pro Skate Shoe $80.00 | view details

DC Dc Court Graffik Skate Shoes, Pewter $70.00 | view details

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

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

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	199.99	0	199.99	26953-DEFAULT-l.jpg	199	26953-DEFAULT-m.jpg	Timeless Palisander Groundswell 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]	4	150-to-200	0.00	[empty string]	Arbor Timeless 42 Groundswell Complete Longboard, 42"	<p><em>Premium Palisander Wood Finish Ply</em></p> <p>The classic pintail carver, designed for smooth, open-stance skating and maximum push and speed stability.</p> <h4>DECK</h4> <ul> <li>7 Ply Hardrock Maple with a Premium Palisander Wood Finish Ply</li> <li>Wood material comes from sustainable sources of supply</li> <li>Wood by-product is reclaimed for use in other products</li> </ul> <h4>TRUCKS</h4> <ul> <li>Paris Reverse 50° 180mm</li> </ul> <h4>WHEELS</h4> <ul> <li>Arbor Easyrider Series – Outlook</li> <li>Designed for carving and cruising</li> <li>Larger shape increases rolling speed</li> <li>Size: 69mm // Durometer: 78a</li> <li>Contact Patch: 44.0mm // Offset: 2.5mm</li> <li>Momentum Core: Dampens bumpy rides</li> <li>Venice Formula: Soft and grippy</li> </ul> <h4>OTHER COMPONENTS</h4> <ul> <li>ABEC 7 Bearings with Spacers</li> <li>1/8"? Paris Risers</li> <li>Recycled Glass Re-Grit</li> </ul>	[empty string]	N	199.99	199.99	42IN	26953-DEFAULT-s.jpg	1	1000	ARBL42003	393647	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	arbor/arbor-timeless-42-groundswell-complete-longboard-42-393647	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	99.99	0	99.99	26428-DEFAULT-l.jpg	99	26428-DEFAULT-m.jpg	Nickel Battleship 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]	2	50-to-100	0.00	[empty string]	Penny Skateboards Battleship Complete Nickel Skateboard, 27"'	<p>The latest addition to our Classics line, the Battleship 27" combines a muted grey deck and trucks with poppy red wheels for the perfect color combination. Constructed with our secret plastic formula and high quality components, this cruiser will have you rolling for years to come.</p> <ul> <li>27" Plastic Deck</li> <li>4-inch aluminum trucks with powder-coated finish</li> <li>59mm, 83A wheels for a smooth ride</li> <li>83A color-coded cushions</li> <li>Color-coded high tensile deck bolts</li> <li>Quality Color-coded Abec 7 stainless steel bearings</li> </ul>	[empty string]	N	99.99	99.99	27IN	26428-DEFAULT-s.jpg	6	1000	PNYCOMP27417	374622	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-battleship-complete-nickel-skateboard-27-374622	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	SKULLCANDY	SKULLCANDY	SKATEBOARDS	SKATEBOARDS &GT; VIDEO AND AUDIO	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	7	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]
4	[empty string]	GLOBE	GLOBE	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	144.99	0	144.99	27039-DEFAULT-l.jpg	144	27039-DEFAULT-m.jpg	Big Blazer Palm Fish 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]	3	100-to-150	0.00	[empty string]	Globe Big Blazer Complete Cruiser Skateboard, Palm Fish, 32"	<p>+ Medium length Resin-7 hard rock maple diamond tail cruiser</p> <p>+ Built in bottle opener</p> <p>+ White oak top ply </p> <p>+ 32" x 9.125" x 17.75" WB</p> <p>+ Mellow concave with kick tail</p> <p>+ 6.0" Tensor Alloy trucks</p> <p>+ 62mm 78a wheels</p> <p>+ Clear broadcast griptape</p> <p>+ Artist series by Niya Niya Studio</p>	[empty string]	N	144.99	144.99	32IN	27039-DEFAULT-s.jpg	12	1000	10525195PLMFSH	383796	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	globe/globe-big-blazer-complete-cruiser-skateboard-palm-fish-32-383796	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 WHEELS	34.99	0	34.99	26812-DEFAULT-l.jpg	34	26812-DEFAULT-m.jpg	Easy Life Easy Streets 99a 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]	13	25-to-50	0.00	[empty string]	Bones STF Easy Life Skateboard Wheels, 99A	<p>Bones Street Tech Formula powers the legendary Bones STF wheels that roll fast, grip when you need to and slide when you want to, without flat spotting. STF gives you more control to skate with confidence. Bones STF wheels outperform all other wheels, and because they wear so well, they last several times longer than normal wheels, making STF wheels the best for less. Bones STF wheels are available in the original 103A and the new 99A Easy Streets™ for greater roll, control and softer landings on rougher terrain.</p>	[empty string]	N	34.99	34.99	53MM,54MM,55MM	26812-DEFAULT-s.jpg	50	1000	WSCAESCT1	393510	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-stf-easy-life-skateboard-wheels-99a-393510	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	SPITFIRE	SPITFIRE	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	39.99	0	39.99	26746-DEFAULT-l.jpg	39	26746-DEFAULT-m.jpg	F4 99 Conical Fulls Natural Whl	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Spitfire Formula Four 99D Overlay Skateboard Wheels, 54mm	<p>Spitfire Formula Four 99D Overlay Skateboard Wheels, 54mm</p>	[empty string]	N	39.99	39.99	54MM	26746-DEFAULT-s.jpg	66	1000	2111019354	391810	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-skateboard-wheels-54mm-391810	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

ARBOR Arbor Timeless 42 Groundswell Complete Longboard, 42 " $199.99 | view details

PENNY Penny Skateboards Battleship Complete Nickel Skateboard, 27 "' $99.99 | view details

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

GLOBE Globe Big Blazer Complete Cruiser Skateboard, Palm Fish, 32 " $144.99 | view details

BONES Bones Stf Easy Life Skateboard Wheels, 99a $34.99 | view details

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

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Black/Blue,Black/Green,Black/Orange	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; TRACTION	44.99	0	44.99	25871-DEFAULT-l.jpg	44	25871-DEFAULT-m.jpg	John John Florence Pro Pad	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Dakine John John Florence Pro Surf Traction Pad	<p>Dakine is honored to partner with the world's best surfer, John John Florence, to bring you this custom designed traction pad. Triple cut posi-traction was designed for John John's specific dimensions and aggressive riding style, while the five-piece traction design allows for adjustability, whether being used on an everyday thruster or step-up board. The 25mm vertical tail wedge was hand sculpted by John John himself, to provide the perfect shape for his form. The addition of perforated surface allows water to flow through the kick while eliminating drag. All John John Florence products are packaged using sustainable recycled cardboard products with zero plastic – keeping our oceans clean for tomorrow.</p>	[empty string]	N	45	45	[empty string]	25871-DEFAULT-s.jpg	2	1000	10001762	365742	TRACTION	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dakine/dakine-john-john-florence-pro-surf-traction-pad-365742	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	89.99	0	89.99	26288-DEFAULT-l.jpg	89	26288-DEFAULT-m.jpg	Fam2 Honeycomb Thruster Fins	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 AM2 Honeycomb Thruster Fins	<p>The AM2 Honeycomb, designed by Al Merrick of Channel Island Surfboards, is a large size Balanced fin with a Ride Number of 4.6. Featuring a neutral flex pattern this fin is a more versatile option for bigger surfers. The AM2 Honeycomb fin is designed to perform in a variety of conditions and features a smaller center fin for increased maneuverability.</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>15.98</td> <td>15.32</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.73</td> <td>4.49</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.64</td> <td>4.63</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]	26288-DEFAULT-s.jpg	2	1000	1160-156-00	369936	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-am2-honeycomb-thruster-fins-369936	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	64.99	0	64.99	26267-DEFAULT-l.jpg	64	26267-DEFAULT-m.jpg	Alpha F8 Thruster 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 F8 Alpha Thruster Fins	<p>The F8 Alpha is a large size Balanced fin with a Ride Number of 6.5. Alpha's C6 composite material is carbon and air infused making it lighter than Honeycomb. The responsive flex characteristics of C6 combine with the neutral F-Series template to create one of the most exciting new products on the market. All Alpha products are designed and manufactured exclusively in Huntington Beach, Ca USA.</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>15.90</td> <td>15.90</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.64</td> <td>4.64</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.47</td> <td>4.47</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	65	65	[empty string]	26267-DEFAULT-s.jpg	10	1000	1175-324-00	349065	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-f8-alpha-thruster-fins-349065	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black,Coal,White,Red,Cobalt	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; LEASHES	31.99	0	31.99	26076-DEFAULT-l.jpg	31	26076-DEFAULT-m.jpg	8 ` Reg Essential Leash	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	FCS Regular Essential Leash - 8'	<p>Day-to-day performance and ?reliability in a wide range of conditions.</p>	[empty string]	N	32	32	[empty string]	26076-DEFAULT-s.jpg	16	1000	2020-08F	374707	LEASHES	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-regular-essential-leash-8-374707	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	27102-DEFAULT-l.jpg	29	27102-DEFAULT-m.jpg	Valen Off Wht Towel	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Slowtide Valen Off White Beach Towel	<p>Watching that Southern California sun go down from our beach blanket, we’ve got Buddy Holly & Ritchie Valens' tunes playing on the mental radio. An update to a favorite Slowtide towel. </p> <p>Slowtide partners with artists, photographers, designers, and brands to create unique prints for the towels, all while maintaining premium quality. Equipped with a hanging loop feature and made from 100% sustainably sourced cotton, you are guaranteed the best drying experience.</p> <p><strong>Features</strong></p> <ul> <li>For all bodies of water</li> <li>100% super soft & absorbent cotton velour</li> <li>One-sided print</li> <li>60 inches x 30 inches (Single-Sized)</li> <li>460 grams (Lightweight)</li> <li>Hanging loop</li> <li>Imported</li> </ul>	[empty string]	N	29.95	29.95	[empty string]	27102-DEFAULT-s.jpg	16	1000	ST189	386670	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-valen-off-white-beach-towel-386670	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; LEASHES	36.99	0	36.99	13504-DEFAULT-l.jpg	36	13504-DEFAULT-m.jpg	Adj Sup Race Comp Calf Leash	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	4	25-to-50	0.00	[empty string]	FCS Adjustable SUP Race Competition Leash	<p>Designed in conjunction with Hawaiian waterman Sam Pa'e, the FCS SUP Racing Leash is designed with a long adjustable rail saver strap which eliminates drag by keeping the leash out of the water at all times. Ideal for flat water and open ocean boards, this unique leash provides freedom of movement and can be attached to the nose or tail of the board.</p>	[empty string]	N	36.98	36.98	[empty string]	13504-DEFAULT-s.jpg	17	1000	2040-BLK-ADJ	270984	SUP ACCESSORIES	LEASHES	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-adjustable-sup-race-competition-leash-270984	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

DAKINE Dakine John John Florence Pro Surf Traction Pad $45.00 | view details

FUTURE FINS Futures Am2 Honeycomb Thruster Fins $90.00 | view details

FUTURE FINS Futures F8 Alpha Thruster Fins $65.00 | view details

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

SLOWTIDE Slowtide Valen Off White Beach Towel $29.95 | view details

FCS Fcs Adjustable Sup Race Competition Leash $36.98 | view details

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Green	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	14.99	0	14.99	25877-DEFAULT-l.jpg	14	25877-DEFAULT-m.jpg	Cool Lock	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Dakine Cool Lock	<p>This 4-digit cable lock features a 37-inch retractable cable, for convenient pack-and-carry. Secure your snowboard or skis to the roof rack (perfect for making pit stops on your way to the mountain), or to a rack outside the lodge while you break for lunch. You set your own combination, making it a lot easier to remember than a factory-set combo. (Just please don't set it to your anniversary date. Your girlfriend will never forgive you if you forget it.)</p>	[empty string]	N	15	15	[empty string]	25877-DEFAULT-s.jpg	15	1000	10001562-I	373466	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-cool-lock-373466	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DORSAL	DORSAL	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	25.99	0	25.99	26063-DEFAULT-l.jpg	25	26063-DEFAULT-m.jpg	Aero Sup Surf Rack Pads 28 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]	OH at 200	[empty string]	63	25-to-50	0.00	[empty string]	Dorsal Aero Roof Rack Pads for Car - Kayak, SUP, Snowboard, Surf - 28"	<p><strong>Are You Looking For An Effective And Efficient Way To Convey Surfboards, Snowboards and most Kayaks, As Well As Stand-Up Paddle Boards</strong></p> <p><strong>Start Using the Dakine Thule and Yakima Wide Flat bar Compatible Dorsal SUP Rack Pads Set, Armed With Essential Features That Make This Product Apart From The Rest.</strong></p> <ul> <li> <ul> <li> <p><strong>Easy Convey Of Surfboards, Kayaks, As Well As Stand-Up Paddle Boards</strong> This 28 inch (Dakine Style) Dorsal SUP Rack Pads set offer an effective way to convey surf boards, snowboards, kayaks, as well as stand-up paddle boards.</p> </li> <li> <p><strong>Fits Aero</strong> (Flat Bar) 5.5" - 8.0" [ 14-20cm ] bar circumference. For Square or Round Bar See Dorsal's Round Bar Pads (see diagram).</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 a kayak or board from your cars cross bars. 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 Kayak 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, 28 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]	26063-DEFAULT-s.jpg	20	1000	DORSAL-ORIGIN-BW-RACK-PAD	368237	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dorsal/dorsal-aero-roof-rack-pads-for-car-kayak-sup-snowboard-surf-28-368237	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DORSAL	DORSAL	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	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	23	1000	DORSAL-RACKPADS-19IN	368239	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	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]
4	Black	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	19.99	0	19.99	11573-DEFAULT-l.jpg	19	11573-DEFAULT-m.jpg	20 ` Tie Down Single Strap	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	M	[empty string]	[empty string]	[empty string]	WEB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Dakine Tie Down Strap - 20'	<p>The Dakine 20' Tie Down Strap makes car roof rack transportation a cinch. These are offered as a 20-foot single strap. The Tie Down Strap features the secure tightening of heavy-duty 1-3/8-inch cam buckles with a neoprene housing.</p>	[empty string]	N	19.99	19.99	[empty string]	11573-DEFAULT-s.jpg	28	1000	08840555	263994	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-tie-down-strap-20-263994	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Black/White	VANS	VANS	SNOWBOARDING	SNOWBOARDING &GT; BOOTS	189.99	0	189.99	25701-DEFAULT-l.jpg	189	25701-DEFAULT-m.jpg	Mens Hi- Standard Og Boot	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]	OH at 200	[empty string]	5	150-to-200	0.00	[empty string]	Vans Hi-Standard OG Men's Snowboard Boots, Black/White, 2019	<p>The Hi-Standard OG is the best-selling Vans boot of all time, and continues to be the standard-bearer for classic style and modern performance. The comfort and familiar feel of traditional lace-up closure gains additional support from key features like our Instep Lace Lockout and Internal Web Harness. With its new V1 Waffle Lug outsole and iconic sidestripe, the timeless Vans style speaks for itself.</p>	<p>Vans Hi-Standard OG Men's Snowboard Boots, Black/White, 2019 (10 D US)</p>	N	189.95	189.95	7,9.5,10,11.5	25701-DEFAULT-s.jpg	30	1000	VN0A3TFJY28	372789	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	vans/vans-histandard-og-mens-snowboard-boots-black-white-2019-372789	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	30	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

DAKINE Dakine Cool Lock $15.00 | view details

DORSAL Dorsal Aero Roof Rack Pads For Car - Kayak, Sup, Snowboard, Surf - 28 " $25.94 | view details

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

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

VANS Vans Hi- Standard Og Men's Snowboard Boots, Black/White, 2019 $189.95 | view details

NEVER SUMMER Never Summer Snowtrooper X 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	Black/Grus Green	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	25.99	0	25.99	26498-DEFAULT-l.jpg	25	26498-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]	12	25-to-50	0.00	[empty string]	Arcade Ranger Belt, Black/Grus Green	<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>	[empty string]	N	26	26	[empty string]	26498-DEFAULT-s.jpg	2	1000	A11102-071	383696	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-ranger-belt-black-grus-green-383696	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	149.99	0	149.99	25613-DEFAULT-l.jpg	149	25613-DEFAULT-m.jpg	Regulus Multicamo	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]	4	100-to-150	0.00	[empty string]	Nixon Regulus 46mm Watch, Multicamo	<p>Built to Last</p> <p>100m water-resistant case and pushers, 5-year battery life, and shock-absorbent materials withstand any terrain and condition.</p> <hr /> <p>Covert Ops</p> <p>Silent mode option and adjustable backlight ensure your missions stay undercover.</p> <hr /> <p>Double Time</p> <p>Dual chronograph functionality keeps track of every aspect of your operations.</p> <hr /> <p>Strapped</p> <p>An articulated freeswing strap with Nixon’s patented locking looper strap you in for a fit that’s as comfortable as it is secure.</p>	[empty string]	N	150	150	[empty string]	25613-DEFAULT-s.jpg	3	1000	A11802865	374636	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-regulus-46mm-watch-multicamo-374636	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SEX WAX	SEX WAX	ACCESSORIES	ACCESSORIES	9.99	0	9.99	2779-DEFAULT-l.jpg	9	2779-DEFAULT-m.jpg	Grape Scented Candles	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]	18	5-to-10	0.00	[empty string]	Sexwax Grape Scented Candle	<p>Sexwax Candle fragrances are available in Coconut, Strawberry, or Grape. These candles have lead free wicks and are contained within a 4 ounce clear glass jar. Sexwax Candles will provide a long lasting flame for up to 30 hours or more.</p>	[empty string]	N	9.99	9.99	[empty string]	2779-DEFAULT-s.jpg	4	1000	CDG4	251032	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sex-wax/sexwax-grape-scented-candle-251032	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Sunglow,Waimea,THUNDERDOT,Melbourne,NIGHTFLOWER,PUALINA	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; BACKPACKS	29.99	0	29.99	25845-DEFAULT-l.jpg	29	25845-DEFAULT-m.jpg	Wmns Cosmo 6.5l Backpack	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	[empty string]	[empty string]	46	25-to-50	0.00	[empty string]	Dakine Cosmo 6.5L Women's Backpack	<p>The Cosmo is our lowest volume daypack combining organization and function in a compact and stylish design. This sleek pack will keep you organized on the go thanks to the front pocket with dedicated storage for utensils, keys, cords and your phone. Larger standalone items have a home in the separate main compartment. The popular Cosmo is offered in a wide selection of our most popular colorways.</p>	[empty string]	N	30	30	[empty string]	25845-DEFAULT-s.jpg	4	1000	08210060-I	372499	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-cosmo-65l-womens-backpack-372499	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Neon Pink,Teal,Violet	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	9.99	0	9.99	25733-DEFAULT-l.jpg	9	25733-DEFAULT-m.jpg	Icon Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	21	5-to-10	0.00	[empty string]	Stance Icon Classic Crew Sock	<p>The Icon Classic Crew maintains Stance's top-shelf comfort in a classic, plain look for those days you feel like going a little more low-key.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	10	10	Medium,Large	25733-DEFAULT-s.jpg	6	1000	M311D14ICO	380198	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-icon-classic-crew-sock-380198	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	37.99	0	37.99	27189-DEFAULT-l.jpg	37	27189-DEFAULT-m.jpg	Destro 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]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Dot Dash Destro Sunglasses, Tortoise Gloss/Grey Polarized	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>Polarized Lens</li> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	38	38	[empty string]	27189-DEFAULT-s.jpg	7	1000	DSLRFDES-BPP	274611	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-destro-sunglasses-tortoise-gloss-grey-polarized-274611	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]