Outerwear

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	CARVE	CARVE	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	49.99	0	49.99	26020-DEFAULT-l.jpg	49	26020-DEFAULT-m.jpg	Matrix Mat Blk/Clr Blu Iridium	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]	Carve Matrix Sunglasses, Matte Black/Blue Iridium Polarized	<p>The Barracuda polarized iridium lens are an exceptional pair of sunglasses. The Barracuda sunglasses have a 5 barrel stainless steel hinge, a polycarbonate frame and metal badging! The Barracuda is a modern twist on a classic pair of sunglasses. The Barracuda comes in a variety of lens and frame colours. The Volley sunglasses not only look great, but also have 100% UV protection.</p>	[empty string]	N	49.99	49.99	[empty string]	26020-DEFAULT-s.jpg	1	1000	3040	362964	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	carve/carve-matrix-sunglasses-matte-black-blue-iridium-polarized-362964	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	24.99	0	24.99	27205-DEFAULT-l.jpg	24	27205-DEFAULT-m.jpg	Futureman Blk Gloss/Vintage	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]	SP18	[empty string]	[empty string]	[empty string]	16	20-to-25	0.00	[empty string]	Dot Dash Futureman Sunglasses, Black Gloss/Vintage Grey	<p>Dot Dash Futureman Sunglasses, Black Gloss/Vintage Grey</p>	[empty string]	N	25	25	[empty string]	27205-DEFAULT-s.jpg	1	1000	DSLRLFUT-BKV	371174	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-futureman-sunglasses-black-gloss-vintage-grey-371174	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DC	DC	MENS	MENS &GT; SHOES &GT; SKATE SHOES	99.99	0	99.99	27023-DEFAULT-l.jpg	99	27023-DEFAULT-m.jpg	Vandium Se Grey/Grey/Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BLK COMBO	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	33	50-to-100	0.00	[empty string]	DC Vandium SE Skate Shoes, Grey/Grey/Black	<p>The nuts and bolts</p> <ul> <li>Leather, nubuck, suede or textile upper [depending on colorway]</li> <li>Molded TPR eyelet</li> <li>Molded TPR tongue logo</li> <li>Mesh lining</li> <li>OrthoLite® footbed provides cushioning</li> <li>UniLite™ midsole</li> <li>Impact-A™ technology features a polyurethane airbag to provide superior cushioning and impact protection</li> <li>Dynamic Grip Technology (DGT) rubber outsole with 3 different rubber durometers <p> </p> </li> </ul>	[empty string]	N	100	100	9,9.5,10,10.5,11,11.5,12	27023-DEFAULT-s.jpg	1	1000	ADYS200067-XSSK	382981	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-vandium-se-skate-shoes-grey-grey-black-382981	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ELECTRIC	ELECTRIC	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	27221-DEFAULT-l.jpg	149	27221-DEFAULT-m.jpg	Tech One Matte Blk/Gry Pol	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Electric Tech One Sunglasses, Matte Black/Grey Polarized	<p>The Tech One was purpose-built for all day adventures. The re-engineered wrap-around design, with its smooth, angular features provides crucial glare reduction in sun, snow, and surf alike.</p> <ul> <li>Frame: 8 base mold injected grilamid frame with a 5 barrel hinge.</li> <li>Optics: 8 base melanin infused polycarbonate lenses. 100% UV protection. Up to 98% blue light protection.</li> <li>Available in polarized polycarbonate lenses. 99.9% Premium glare reduction, relaxed/soothing eye feeling, true color perception, and scratch resistance.</li> <li>Visual Light Transmitted (VLT): 10%. Optimal lens for daily use. Increased clarity and depth perception while providing visual comfort.</li> <li>Includes microfiber cleaning bag.</li> <li>Designed in California. Made in Italy.</li> <li>Lifetime warranty</li> <li>Measurement: 45h - 142w - 165l</li> <li>Weight: 28 grams</li> </ul>	[empty string]	N	150	150	[empty string]	27221-DEFAULT-s.jpg	3	1000	EE11601042	314472	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	electric/electric-tech-one-sunglasses-matte-black-grey-polarized-314472	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	MENS	MENS &GT; ACCESSORIES &GT; SOCKS	13.99	0	13.99	25773-DEFAULT-l.jpg	13	25773-DEFAULT-m.jpg	No Vacancy 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]	OH at 200	[empty string]	4	10-to-15	0.00	[empty string]	Stance No Vacancy Classic Crew Sock	<p>No Vacancy, no problem! Vacation is about being flexible and making best of your terrible planning skills. Our No Vacancy was designed for those who can go with the flow.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Large	25773-DEFAULT-s.jpg	3	1000	M556D17NOV	361331	SOCKS	EMPTY	EMPTY	0	0	0	EMPTY	stance/stance-no-vacancy-classic-crew-sock-361331	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	THRASHER	THRASHER	MENS	MENS &GT; ACCESSORIES &GT; HATS	25.99	0	25.99	26934-DEFAULT-l.jpg	25	26934-DEFAULT-m.jpg	China Banks Snapback	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]	Thrasher China Banks Snapback Hat	<p>Embroidered logo with adjustable snapback. 100% cotton.</p>	[empty string]	N	25.99	25.99	One Size	26934-DEFAULT-s.jpg	3	1000	3131376	393666	HATS	EMPTY	EMPTY	0	0	0	EMPTY	thrasher/thrasher-china-banks-snapback-hat-393666	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

CARVE Carve Matrix Sunglasses, Matte Black/Blue Iridium Polarized $49.99 | view details

DOT DASH Dot Dash Futureman Sunglasses, Black Gloss/Vintage Grey $25.00 | view details

DC Dc Vandium Se Skate Shoes, Grey/Grey/Black $100.00 | view details

ELECTRIC Electric Tech One Sunglasses, Matte Black/Grey Polarized $150.00 | view details

STANCE Stance No Vacancy Classic Crew Sock $14.00 | view details

THRASHER Thrasher China Banks Snapback Hat $25.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	282	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	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	664	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	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	864	1000	20-48057	377113	EMPTY	EMPTY	EMPTY	1	3.99	2.99	EMPTY	sun-bum/sun-bum-cocobalm-lip-balm-groove-berry-377113	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
4	[empty string]	DOT DASH	DOT DASH	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	29.99	0	29.99	26042-DEFAULT-l.jpg	29	26042-DEFAULT-m.jpg	Kerfuffle Crystal/Blue 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]	[empty string]	[empty string]	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Dot Dash Kerfuffle Sunglasses, Crystal/Light Blue Chrome	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	30	30	[empty string]	26042-DEFAULT-s.jpg	2	1000	DSVTFKER-CRX	314323	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-kerfuffle-sunglasses-crystal-light-blue-chrome-314323	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	WOMENS	WOMENS &GT; ACCESSORIES &GT; WATCHES	99.99	0	99.99	25688-DEFAULT-l.jpg	99	25688-DEFAULT-m.jpg	Base Tide Punk Pink Resin	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	50-to-100	0.00	[empty string]	Nixon Base Tide 38mm Watch, Punk Pink Resin	<p>Simplified tide telling inspired by simpler times. The Base Tide slides 21st century tech into retro design and mod colors.</p>	<p>Nixon Unisex The Base Tide Punk Pink Resin One Size</p>	N	100	100	[empty string]	25688-DEFAULT-s.jpg	6	1000	A11042688	360992	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-base-tide-38mm-watch-punk-pink-resin-360992	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Black Pebble	BILLABONG	BILLABONG	WOMENS	WOMENS &GT; SWIM &GT; BIKINI TOPS	49.99	0	49.99	27000-DEFAULT-l.jpg	49	27000-DEFAULT-m.jpg	True That Tank	N	WOMENS	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]	13	25-to-50	0.00	[empty string]	Billabong True That Tank Bikini Top	<p>Timeless black and white polka dots bring vintage design to your modern bikini. Featuring a print that rounds out your essential bikini wardrobe, the True That Tank bikini top delivers a sporty racerback cut, trimmed with rings at the straps.</p> <p>The nuts and bolts</p> <ul> <li>Polka dot bikini top.</li> <li>Racerback cropped tank fit.</li> <li>Ring detail at straps.</li> <li>Removable soft padding.</li> <li>Pattern: dot print.</li> <li>Material: polyamide and elastane blend. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	49.95	49.95	Small,Medium,Large,X-Large	27000-DEFAULT-s.jpg	7	1000	XT33TBTR	387524	EMPTY	EMPTY	EMPTY	0	0	0	SWIM	billabong/billabong-true-that-tank-bikini-top-387524	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

DOT DASH Dot Dash Kerfuffle Sunglasses, Crystal/Light Blue Chrome $30.00 | view details

NIXON Nixon Base Tide 38mm Watch, Punk Pink Resin $100.00 | view details

BILLABONG Billabong True That Tank Bikini Top $49.95 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25939-DEFAULT-l.jpg	8	25939-DEFAULT-m.jpg	Fathom Cord	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]	2	5-to-10	0.00	[empty string]	Costa Del Mar Fathom Cord Sunglasses Holder	<p>FATHOM CORD. Marine-grade, soft nylon retainer designed specifically to fit Fathom and all styles, especially those with co-injected temples.  <strong>End-to-End Measurement: </strong>28"</p>	[empty string]	N	8.99	8.99	[empty string]	25939-DEFAULT-s.jpg	12	1000	CF11	349328	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-fathom-cord-sunglasses-holder-349328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	VANS	VANS	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]	192	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	13	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]
3	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	59.99	0	59.99	26790-DEFAULT-l.jpg	59	26790-DEFAULT-m.jpg	Comfycush Slip On True White/True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	WHITE	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	72	50-to-100	0.00	[empty string]	Vans ComfyCush Slip-On Skate Shoe	<p>Vans has reinvigorated the classic Slip-On by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Slip-On a first-class fit that feels like walking on a cloud. Newly constructed canvas uppers house simplified one-piece interiors with added arch support and new moisture-wicking lining throughout, resulting in a lightweight experience that assures you’ll Keep It Comfy at all times.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26790-DEFAULT-s.jpg	19	1000	VN0A3WMDVNG	383079	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-comfycush-slipon-skate-shoe-383079	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Golden Glow	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26810-DEFAULT-l.jpg	59	26810-DEFAULT-m.jpg	Sun Dream Tank Set	N	GIRLS	[empty string]	[empty string]	[empty string]	[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]	12	50-to-100	0.00	[empty string]	Billabong Sun Dream Tank Set	<p>Billabong Sun Dream Tank Set</p>	[empty string]	N	59.95	59.95	7,8,10,12,14	26810-DEFAULT-s.jpg	27	1000	Y219TBSU	387578	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-sun-dream-tank-set-387578	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Assorted	ETHIKA	ETHIKA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	26844-DEFAULT-l.jpg	14	26844-DEFAULT-m.jpg	Boys Greetings From Ethika 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]	7	10-to-15	0.00	[empty string]	Ethika Greetings From Ethika 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,Medium,Large	26844-DEFAULT-s.jpg	30	1000	UBS1411	384626	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	ethika/ethika-greetings-from-ethika-boys-boxer-brief-384626	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	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	48	1000	VN000EE3W00	233920	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

COSTA DEL MAR Costa Del Mar Fathom Cord Sunglasses Holder $8.99 | view details

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

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

BILLABONG Billabong Sun Dream Tank Set $59.95 | view details

ETHIKA Ethika Greetings From Ethika Boy's Boxer Brief $15.00 | view details

VANS Vans Authentic Skate Shoe, True White $50.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/Silver,Brown/Gum,GUB,ALB,Black/Brown,Grey/Black,VBR,Grey/White,KS2,KTO,Grey/Light Blue,LGB,NAY,Tan/Black/Tan	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	54.99	0	54.99	25620-DEFAULT-l.jpg	54	25620-DEFAULT-m.jpg	Fanning Mens Sandal	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]	H16	[empty string]	OH at 200	[empty string]	1190	50-to-100	0.00	[empty string]	Reef Fanning Men's Sandal	<p>This is the sandal of legendary three-time world champ and perennial pro surfing powerhouse, Mick Fanning the ultimate athletic sandal of comfortable water-friendly synthetic nubuck upper. Mick relies on the contoured injection molded EVA footbed with anatomical arch support and full 360-degree heel airbag enclosed in soft poly for good reason. And in the fun department, it also features a bottle opener built into the footbed to open your “soda” after a surf or hanging at the pool. Reef Icon Herringbone rubber outsole. The sandals of a champion.</p>	[empty string]	N	55	55	6,7,8,9,10,11,12,13,14,15	25620-DEFAULT-s.jpg	6	1000	2026	335585	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-fanning-mens-sandal-335585	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Gold,Teal	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S 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	6	1000	W515C18JUD	380517	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	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]
3	Pink,Blue	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25763-DEFAULT-l.jpg	13	25763-DEFAULT-m.jpg	Dazed Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	SU18	[empty string]	OH at 200	[empty string]	13	10-to-15	0.00	[empty string]	Stance Dazed Classic Crew Sock	<p>Dazed from the Sun Dazed collection encompasses a place that often promotes well-being and relaxation. Combine positive energy, warmth of water, a little sunshine and you'll be in a "Sundazed" state of mind.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	<p>Stance Caged Socks (White, Medium)</p>	N	14	14	Large	25763-DEFAULT-s.jpg	7	1000	M556A18DAZ	368942	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-dazed-classic-crew-sock-368942	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ES	ES	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	64.99	0	64.99	26614-DEFAULT-l.jpg	64	26614-DEFAULT-m.jpg	Square Three Bone	N	MENS	ENTER NEW	[empty string]	ENTER NEW	ENTER NEW	ENTER NEW	ENTER NEW	CURRENT	ENTER NEW	AVAILABLE	ENTER NEW	ENTER NEW	ENTER NEW	ENTER NEW	WHITE	ENTER NEW	SPRING	ENTER NEW	[empty string]	[empty string]	49	50-to-100	0.00	[empty string]	ES Square Three Skate Shoe, Bone	<p>The SQUARE THREE is perfection when it comes to skate shoes. With the style details of the Square 1 and Square 2 blended together this shoe has quickly become a éS team rider (and employee) favorite! Simple yet effective in pushing your skating and style above and beyond.</p>	[empty string]	N	65	65	7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	26614-DEFAULT-s.jpg	8	1000	5101000159-282	383526	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	es/es-square-three-skate-shoe-bone-383526	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Bronze Brown	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	54.99	0	54.99	2989-DEFAULT-l.jpg	54	2989-DEFAULT-m.jpg	Leather Smoothy Sandal	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]	TOP 25	DISCONTINUED	[empty string]	WEEKLY	[empty string]	OH at 200	[empty string]	155	50-to-100	0.00	[empty string]	Reef Leather Smoothy Men's Sandal	<p>Everyone knows that the Reef Smoothy sandal is a time-honored Reef favorite. The Leather Smoothy sandal, however, it a classed-up version of this classic.  The leather smoothy is a great men's sandal for afternoon surf sessions to sunset cruises. The footbed and upper are premium full grain leather with comfortable Reef polyester lining. The leather smoothy has the same classic Smoothy shape as the original, with leather. Reef-Flex triple density EVA construction with anatomical arch support. These sandals are highly abrasion resistant, molded Reef rubber non-marking outsole.</p>	[empty string]	N	55	55	7,8,9,10,11,12,13,14	2989-DEFAULT-s.jpg	10	1000	232	26738	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-leather-smoothy-mens-sandal-26738	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	114.99	0	114.99	25704-DEFAULT-l.jpg	114	25704-DEFAULT-m.jpg	Ultrarange Hi Mte Dachshund/Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BROWN	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	16	100-to-150	0.00	[empty string]	Vans UltraRange Hi MTE Shoe, Dachshund/Black	<p>A new addition to the Vans family, the athlete-inspired UltraRange Hi MTE is a versatile shoe with additions designed for the elements. Featuring a brand new UltraCush Lite midsole compound offering the ultimate in comfort and cushioning, plus a sock-fit bootie construction with seamless internals to reduce weight, rubbing, and hotspots, the UltraRange Hi MTE provides a clean aesthetic that will get you there. It also includes leather and synthetic uppers with MTE details, warm linings, water-based inks and glues, and durable co-molded rubber reverse waffle lug outsoles to reduce glue and improve finishing.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	115	115	8,8.5,9,9.5,10.5,11,12,13	25704-DEFAULT-s.jpg	11	1000	VN0A3ZD1FW6	379638	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-ultrarange-hi-mte-shoe-dachshund-black-379638	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

REEF Reef Fanning Men's Sandal $55.00 | view details

STANCE Stance Judge Me Women's Classic Crew Sock $14.00 | view details

STANCE Stance Dazed Classic Crew Sock $14.00 | view details

ES Es Square Three Skate Shoe, Bone $65.00 | view details

REEF Reef Leather Smoothy Men's Sandal $55.00 | view details

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

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD BEARINGS	63.99	0	63.99	4162-DEFAULT-l.jpg	63	4162-DEFAULT-m.jpg	Super Swiss 6 Ball Bearing 8- 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]	WEB	[empty string]	ACTIVE	[empty string]	UPDATE	[empty string]	[empty string]	[empty string]	39	50-to-100	0.00	[empty string]	Bones Super Swiss 6 Skateboard Bearings	<p style="margin-left:0px; margin-right:0px; text-align:left">This unique design features six larger diameter balls instead of the seven balls used in most 608 bearings. The advantage of this design is higher speed, greater strength and durability. Made in Switzerland.</p> <div class="product-tabs-content" id="product_tabs_description_contents" style="-webkit-text-stroke-width:0px; background:#ffffff; color:#666666; font-family:"Lucida Grande",Verdana,sans-serif; font-size:14px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; margin-bottom:0px; margin-left:0px; margin-right:0px; margin-top:0px; orphans:2; overflow:auto; padding:0px 25px 35px; text-align:left; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; word-spacing:0px"> <div class="std" style="margin-bottom:0px; margin-left:0px; margin-right:0px; margin-top:0px; padding:0px"> <p style="margin-left:0px; margin-right:0px"><strong>Features</strong></p> <ul style="margin-left:0px; margin-right:0px"> <li>Single, non-contact, removable rubber shield allows for easy cleaning and less friction.</li> <li>High speed nylon ball retainer for greater strength and speed.</li> <li>Pre-lubricated with Speed Cream® racing lubricant</li> <li>Skate Rated™ clearances, tolerances, materials and lubricant provide the best performance and durability possible.</li> </ul> <p style="margin-left:0px; margin-right:0px"><strong>Contents</strong></p> <ul style="margin-left:0px; margin-right:0px"> <li>Set of 8 bearings</li> <li>4 bearing spacers</li> <li>Instructions</li> <li>Sticker</li> </ul> <p style="margin-left:0px; margin-right:0px">Bones Swiss Bearings have the best reputation in the skateboard industry and have had this honor since 1981, due to their performance and quality. Everyone who rides Swiss knows how fast they are and	[empty string]	N	63.95	63.95	[empty string]	4162-DEFAULT-s.jpg	7	1000	6501036	36676	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-super-swiss-6-skateboard-bearings-36676	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	69.99	0	69.99	26739-DEFAULT-l.jpg	69	26739-DEFAULT-m.jpg	Kendall End Of The World Reissue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Santa Cruz Kendall End of the World Re-Issue Skateboard Deck, 10" x 29.7"	<p>Straight from the archives comes new Santa Cruz Re-Issues! Santa Cruz Skateboards is proud to release four new reissues! For the first time since it's original production, Jeff Kendall's "End of the World” graphic is back on its original shape and in a new, never before printed colorway. A must have for any fan of the 80’s. Hang this baby on your wall or set up a one of a kind skateboard. Either way, you won't be disappointed.</p>	[empty string]	N	69.99	69.99	10.0	26739-DEFAULT-s.jpg	14	1000	11115418	391904	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-kendall-end-of-the-world-reissue-skateboard-deck-10-x-297-391904	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	SKATEBOARDS	SKATEBOARDS &GT; VIDEO AND AUDIO	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	42	1000	BCGC	252213	EMPTY	EMPTY	EMPTY	0	0	0	VIDEO AND AUDIO	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]
4	[empty string]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	69.99	0	69.99	26738-DEFAULT-l.jpg	69	26738-DEFAULT-m.jpg	Obrien Purgatory Reissue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Santa Cruz Obrien Purgatory Re-Issue Skateboard Deck, 9.85" x 30"	<p>9.85" x 30"</p> <p>Straight from the archives comes new Santa Cruz Re-Issues! Santa Cruz Skateboards is proud to release four new reissues! For the first time since it's original production, Corey O'Brian's "Purgatory” graphic is back on its original shape and in a new, never before printed colorway. A must have for any fan of the 80’s. Hang this baby on your wall or set up a one of a kind skateboard. Either way, you won't be disappointed.</p>	[empty string]	N	69.99	69.99	9.8	26738-DEFAULT-s.jpg	49	1000	11115417	391903	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-obrien-purgatory-reissue-skateboard-deck-985-x-30-391903	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GLOBE	GLOBE	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	154.99	0	154.99	27042-DEFAULT-l.jpg	154	27042-DEFAULT-m.jpg	Blazer Xl Sun Flower 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	150-to-200	0.00	[empty string]	Globe Blazer XL Complete Cruiser Skateboard, Sun Flower, 36.25"	<p>+ Long legnth Resin-8 hard rock maple diamond-tail cruiser </p> <p>+ Built-in bottle opener</p> <p>+ 36.25" x 9.75" x 21.5" WB</p> <p>+ Mellow concave with kick tail</p> <p>+ 6.0" Tensor Alloy trucks</p> <p>+ 62mm 78a wheels</p> <p>+ White oak top fly</p> <p>+ Clear broadcast griptape</p> <p>+ Artist series by Niya Niya Studio</p>	[empty string]	N	154.99	154.99	36.25IN	27042-DEFAULT-s.jpg	54	1000	10525288SUNFLWR	383800	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	globe/globe-blazer-xl-complete-cruiser-skateboard-sun-flower-3625-383800	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD BEARINGS	124.99	0	124.99	4166-DEFAULT-l.jpg	124	4166-DEFAULT-m.jpg	Ceramic Swiss Bearings	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TOP SELLERS	[empty string]	WEB	[empty string]	ACTIVE	[empty string]	UPDATE	[empty string]	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	Bones Ceramic Swiss Skateboard Bearings	<p>Bones Swiss Ceramics are in a class by themselves. If you want the best there is, this is it. The ceramic balls are much lighter, harder, stronger, waterproof, and longer lasting than the finest steel balls. Made in Switzerland.</p> <p><strong>Features</strong></p> <ul> <li>Accelerate faster.</li> <li>Roll faster and farther.</li> <li>Resist dirt and moisture better.</li> <li>Help to repair injuries to your races caused by dirt.</li> <li>1 non-contact, removable rubber shields allow easy cleaning.</li> <li>High speed nylon ball retainer for greater strength and speed.</li> <li>Skate Rated™ clearances, tolerances, materials and lubricant provide the best performance and durability possible.</li> </ul> <p><strong>Contents</strong></p> <ul> <li>Set of 8 bearings</li> <li>4 bearing spacers</li> <li>Instructions</li> <li>Sticker</li> </ul> <p>Bones Swiss Bearings have the best reputation in the skateboard industry and have had this honor since 1981, due to their performance and quality. Everyone who rides Swiss knows how fast they are and how long they last. Testimonials reveal them lasting several times longer than low cost bearings. Skaters who use Bones Swiss do so because they want the very best equipment they can get and know the difference between ordinary and exceptional. Our team is a who’s who of top skaters and we are proud to be associated with each one of them.</p>	[empty string]	N	124.989997864	124.989997864	[empty string]	4166-DEFAULT-s.jpg	57	1000	BSLWBC88	36675	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-ceramic-swiss-skateboard-bearings-36675	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

BONES Bones Super Swiss 6 Skateboard Bearings $63.95 | view details

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

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

SANTA CRUZ Santa Cruz Obrien Purgatory Re- Issue Skateboard Deck, 9.85 " X 30 " $69.99 | view details

GLOBE Globe Blazer Xl Complete Cruiser Skateboard, Sun Flower, 36.25 " $154.99 | view details

BONES Bones Ceramic Swiss Skateboard Bearings $124.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	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; BODYBOARDING	29.99	0	29.99	20306-DEFAULT-l.jpg	29	20306-DEFAULT-m.jpg	Body Surfer Handboard	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]	8	25-to-50	0.00	[empty string]	Hydro Body Surfer Handboard	<p>Heavy duty design & wrist strap.</p>	[empty string]	N	29.99	29.99	One Size	20306-DEFAULT-s.jpg	1	1000	79002	280712	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hydro/hydro-body-surfer-handboard-280712	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	104.99	0	104.99	26249-DEFAULT-l.jpg	104	26249-DEFAULT-m.jpg	Hs2 V2 Foil Medium Thruster	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Futures HS2 Hayden Shapes Generation Series Tri-Fins	<p>The HS2 Generation Series, designed by Hayden Cox of Haydenshapes, is a medium size Speed Generating fin with a Ride Number of 8.3. The latest in speed generating fins, the Gen Series features a V2 foil for fluidity and a unique blend of uni-directional carbon and fiberglass for a more stable flex pattern. Similar feel to Blackstix, but a bit more subtle for those just transitioning onto foiled fins.</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>14.54</td> <td>14.54</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.45</td> <td>4.45</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>V2</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	105	105	[empty string]	26249-DEFAULT-s.jpg	6	1000	2486-435-00	341105	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-hs2-hayden-shapes-generation-series-trifins-341105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; LEASHES	38.99	0	38.99	13542-DEFAULT-l.jpg	34	13542-DEFAULT-m.jpg	Sup Regular Ankle Leash - Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	25-to-50	0.00	[empty string]	FCS Essential SUP Ankle Leash, Black	<p>Day-to-day performance and ?reliability in a wide range of conditions.</p>	[empty string]	N	34.98	34.98	10FT	13542-DEFAULT-s.jpg	8	1000	2033-BLK	270978	SUP ACCESSORIES	LEASHES	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-essential-sup-ankle-leash-black-270978	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	119.99	0	119.99	26275-DEFAULT-l.jpg	119	26275-DEFAULT-m.jpg	F6 Honeycomb Quad Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Futures F6 Honeycomb Thruster Fins	<p>The F6 Honeycomb is a medium size Balanced fin with a Ride Number of 5.3. This set is a scaled up version of our popular F4 template. The F6 Honeycomb's subtle flex pattern creates the perfect amount of drive and the slightly refined tip provides for additional release off of the top. A great go-to set for medium sized surfers.</p> <div class="panel-group pdt-detail-panel" id="accordion" style="box-sizing:border-box; margin-bottom:20px"> <div class="each-panel-pdt panel panel-default" style="border-bottom:1px solid #dddddd; border-image:initial; border-left:none; border-radius:0px; border-right:none; border-top:none; box-shadow:none; box-sizing:border-box; margin-bottom:0px; margin-top:0px !important"> <div class="collapse in panel-collapse" id="collapse2" style="box-sizing:border-box; display:block"> <div class="panel-body" style="border-top:1px solid #dddddd; box-sizing:border-box; padding:17px 0px !important"> <div class="specification" style="box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-weight:normal; line-height:25px"> <table cellspacing="0" class="specf-table" style="background-color:transparent; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; width:537.6px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> <th style="text-align:left">Center Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.12</td> <td>15.12</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.56</td> <td>4.56</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.35</td> <td>4.35</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table> </div> </div> </div> </div> </div>	[empty string]	N	120	120	[empty string]	26275-DEFAULT-s.jpg	22	1000	1165-130-40	376929	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-f6-honeycomb-thruster-fins-376929	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[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	23	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]
6	[empty string]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	159.99	0	159.99	26246-DEFAULT-l.jpg	159	26246-DEFAULT-m.jpg	Firewire 5 Fin Honeycomb/Carbon 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	150-to-200	0.00	[empty string]	Futures Firewire 5-Fin	<p>For 2018 we have updated the Firewire 5-fin. The template features a carbon fiber base for stiffness and ample drive, while the tip of the fins feature honeycomb and unidirectional carbon fiber, for a lively response out of your turns. These fins are designed to complement the Gamma, Sci-Fi, Omni, Cymatic, and other high-performance models. Grab your set today and take your Firewire to the next level.</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> <th style="text-align:left">Rear Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.70</td> <td>14.90</td> <td>12.85</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.90</td> <td>4.60</td> <td>4.35</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.50</td> <td>4.40</td> <td>4.10</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> <td>SYMM</td> </tr> </tbody> </table>	[empty string]	N	160	160	[empty string]	26246-DEFAULT-s.jpg	29	1000	1017-465-50	381598	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-firewire-5fin-381598	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

HYDRO Hydro Body Surfer Handboard $29.99 | view details

FUTURE FINS Futures Hs2 Hayden Shapes Generation Series Tri- Fins $105.00 | view details

FCS Fcs Essential Sup Ankle Leash, Black $34.98 | view details

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

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

FUTURE FINS Futures Firewire 5- Fin $160.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	DOTBLUECAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26201-DEFAULT-l.jpg	19	26201-DEFAULT-m.jpg	Dot Blue Camo Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	42	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Dot Camo Blue	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	<p>Fishmasks Single Layer Neck Gaiter - Lightweight, Fishing Protection From Sun, Wind And Moisture - Made In USA - UPF 50+ Moisture-Wicking Fabric - Dot Camo Blue</p>	N	19.99	19.99	[empty string]	26201-DEFAULT-s.jpg	1	1000	FSH-SL-DOTBLUECAMO	359384	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-dot-camo-blue-359384	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	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	3	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]
3	[empty string]	ELECTRIC	ELECTRIC	SNOWBOARDING	SNOWBOARDING &GT; GOGGLES	159.99	0	159.99	25969-DEFAULT-l.jpg	159	25969-DEFAULT-m.jpg	Egg Dark Side Tort/Jet Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Electric Egg Ski/Snowboard Goggles, Dark Side Tort/Jet Black	<p>Electric Egg Ski / Snowboard Goggles, Dark Side Tort/Jet Black</p>	[empty string]	N	160	160	[empty string]	25969-DEFAULT-s.jpg	57	1000	EG2418203-JBLK	374595	EMPTY	EMPTY	EMPTY	0	0	0	GOGGLES	electric/electric-egg-ski-snowboard-goggles-dark-side-tort-jet-black-374595	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	469.99	0	469.99	26373-DEFAULT-l.jpg	469	26373-DEFAULT-m.jpg	Onyx	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	4	450-to-500	0.00	[empty string]	Never Summer Onyx Women's Snowboard, 2018	<p>Never Summer Onyx Women's Snowboard, 2018</p>	[empty string]	N	469.99	469.99	140,143,149	26373-DEFAULT-s.jpg	68	1000	ONYX-H	358744	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-onyx-womens-snowboard-2018-358744	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	569.99	0	569.99	26375-DEFAULT-l.jpg	569	26375-DEFAULT-m.jpg	Big Gun	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	3	500-and-over	0.00	[empty string]	Never Summer Big Gun Snowboard, 2019	<p>Thrill Seeker / Carve Type: Colossal // The Big Gun was made big for the biggest style. 19mm of big taper with huge surface area, the Big Gun is stabilization. But here’s the hook...the Big Gun is as responsive as your short board! Built big but ridden nimble. When you’re gunning for ocean motion the size matters.</p>	[empty string]	N	569.99	569.99	169,174	26375-DEFAULT-s.jpg	77	1000	BIGGUN-I	374708	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-big-gun-snowboard-2019-374708	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	469.99	0	469.99	26350-DEFAULT-l.jpg	469	26350-DEFAULT-m.jpg	Infinity	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]	4	450-to-500	0.00	[empty string]	Never Summer Infintiy Snowboard, 2019	<p>Infinitely proven worldwide by riders of all levels. The award winning, mid flex, time tested Infinity is perfect for any condition. Carbon VXR Laminate Technology provides power and an agile response to the ends of board while keeping torsional control. Furnished with Original Rocker Camber Profile, the Infinity is an all terrain deck that excels on hardpack, powder, and park. Take your riding to Infinity and beyond.</p>	[empty string]	N	469.99	469.99	149,151,154	26350-DEFAULT-s.jpg	80	1000	INFINITY-I	374754	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-infintiy-snowboard-2019-374754	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

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

ELECTRIC Electric Egg Ski/Snowboard Goggles, Dark Side Tort/Jet Black $160.00 | view details

NEVER SUMMER Never Summer Onyx Women's Snowboard, 2018 $469.99 | view details

NEVER SUMMER Never Summer Big Gun Snowboard, 2019 $569.99 | view details

NEVER SUMMER Never Summer Infintiy Snowboard, 2019 $469.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	HMEDGRY,Black,NORG,COBALT,CYN,Red,Blue Heather,Red Heather,BLK2	NEVER SUMMER	NEVER SUMMER	ACCESSORIES	ACCESSORIES &GT; BEANIES	22.99	0	22.99	26397-DEFAULT-l.jpg	22	26397-DEFAULT-m.jpg	Solid Regular Beanie	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]	2015	[empty string]	[empty string]	[empty string]	49	20-to-25	0.00	[empty string]	Never Summer Solid Beanie	<p>Keep your brain nice and toasty while you're reppin' your favorite snowboard brand. Featuring a black eagle clip tag at the brim, the Never Summer Solid beanie is a modern classic that goes with everything.</p>	<p>Never Summer Solid Beanie (Salt/Pepper)</p>	N	22.99	22.99	[empty string]	26397-DEFAULT-s.jpg	1	1000	BNSOLID	280185	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-solid-beanie-280185	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	59.99	0	59.99	25679-DEFAULT-l.jpg	59	25679-DEFAULT-m.jpg	Time Teller P Corp Mat Blk/Wht	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]	Nixon Time Teller P Corp 40mm Watch, Matte Black/White	<p>A bold mash-up between two Nixon Icons, the Time Teller P Corp is easy to wear and hard to ignore. Durable and lightweight the Time Teller P Corp is waterproof up to 100m and features larger numerical indices and printed seconds track, which perfectly pops against the matte finish.</p>	[empty string]	N	60	60	[empty string]	25679-DEFAULT-s.jpg	1	1000	A12482493	375190	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-time-teller-p-corp-40mm-watch-matte-black-white-375190	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Pink,Baby Blue	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	11.99	0	11.99	25768-DEFAULT-l.jpg	11	25768-DEFAULT-m.jpg	Women's Uncommon Dip Crew Sock	N	WOMENS	[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]	17	10-to-15	0.00	[empty string]	Stance Uncommon Dip Women's Classic Crew Sock	<p>Your clothes are a canvas. Accentuate your color palate and bring some life to your look in our premium Uncommon Dip Crew.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Elastic Arch Support</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	Small,Medium	25768-DEFAULT-s.jpg	1	1000	W556D18UNC	380534	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-uncommon-dip-womens-classic-crew-sock-380534	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	27.99	0	27.99	26040-DEFAULT-l.jpg	27	26040-DEFAULT-m.jpg	Lads Blk Clear/Gry	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	TOP 25	[empty string]	[empty string]	UPDATE	[empty string]	OH at 200	[empty string]	20	25-to-50	0.00	[empty string]	Dot Dash Lads Sunglasses, Black Clear/Grey Polarized	<h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Base-6 Polycarbonate Lens</li> <li>Polycarbonate Frame</li> <li>Integrated Pin Hinge</li> </ul>	[empty string]	N	28	28	[empty string]	26040-DEFAULT-s.jpg	2	1000	DSVTFLAD-BKG	274683	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-lads-sunglasses-black-clear-grey-polarized-274683	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	99.99	0	99.99	25660-DEFAULT-l.jpg	99	25660-DEFAULT-m.jpg	Base Tide Rasta	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]	7	50-to-100	0.00	[empty string]	Nixon Base Tide 38mm Watch, Rasta	<p>Simplified tide telling inspired by simpler times. The Base Tide slides 21st century tech into retro design and mod colors.</p>	<p>Nixon Unisex The Base Tide Rasta One Size</p>	N	100	100	[empty string]	25660-DEFAULT-s.jpg	2	1000	A11041114	375187	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-base-tide-38mm-watch-rasta-375187	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Dark Grey,Black	SALTY CREW	SALTY CREW	ACCESSORIES	ACCESSORIES &GT; HATS	25.99	0	25.99	26735-DEFAULT-l.jpg	25	26735-DEFAULT-m.jpg	Frenzy Retro Trucker	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]	FA19	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Salty Crew Frenzy Retro Trucker Hat	<p>Retro trucker hat. </p> <p>Structured trucker hat with woven damask patch</p> <p>47% cotton / 25% polyester / 28% nylon</p> <p>Snap back closure</p>	[empty string]	N	26	26	One Size	26735-DEFAULT-s.jpg	2	1000	35035151	383302	EMPTY	EMPTY	EMPTY	0	0	0	HATS	salty-crew/salty-crew-frenzy-retro-trucker-hat-383302	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]