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	BKWT,DGRBK,BKRY	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; HATS	19.99	0	19.99	26389-DEFAULT-l.jpg	19	26389-DEFAULT-m.jpg	Cropped Outline 210 Flex 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]	2015	[empty string]	[empty string]	[empty string]	53	15-to-20	0.00	[empty string]	Never Summer Cropped Outline 210 Flex Hat	<p>Never Summer Cropped Outline 210 Flex Hat</p>	[empty string]	N	19.99	19.99	Small/Medium,Large/X-Large	26389-DEFAULT-s.jpg	1	1000	HTOUTLINE210	313682	HATS	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-cropped-outline-210-flex-hat-313682	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; HATS	24.99	0	24.99	25955-DEFAULT-l.jpg	24	25955-DEFAULT-m.jpg	Ocearch Blitz Grey Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	6	20-to-25	0.00	[empty string]	Costa Del Mar Ocearch Blitz Adjustable Trucker Hat, Gray	<p>OCEARCH BLITZ TRUCKER HAT. 6-Panel trucker hat with structured cotton front and mesh back panels. Unique shark design patch. Snap back closure for quick release. This hat is the perfect accessory to your shark tracking adventure. Download the OCEARCH Global Shark Tracker from your app store to see where your favorite shark is going next. "Don't fear the fin" Fear a world without them.</p>	[empty string]	N	24.99	24.99	[empty string]	25955-DEFAULT-s.jpg	1	1000	HA 69G	367989	HATS	EMPTY	EMPTY	0	0	0	EMPTY	costa-del-mar/costa-del-mar-ocearch-blitz-adjustable-trucker-hat-gray-367989	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Stone,Black	BILLABONG	BILLABONG	MENS	MENS &GT; ACCESSORIES &GT; HATS	26.99	0	26.99	26563-DEFAULT-l.jpg	26	26563-DEFAULT-m.jpg	Big John Safari Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	22	25-to-50	0.00	[empty string]	Billabong Big John Safari Hat	<p>Providing 360 degree sun protection, the Big John canvas safari hat keeps the adventure alive. Details include a woven label at the front and adjustable chin strap.</p> <ul> <li>Canvas safari hat.</li> <li>Camouflage print.</li> <li>Logo detail at front.</li> <li>Flag label at side seam.</li> <li>Adjustable chin strap.</li> </ul>	[empty string]	N	26.95	26.95	[empty string]	26563-DEFAULT-s.jpg	2	1000	MAHWTBBI	382696	HATS	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-big-john-safari-hat-382696	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Vintage White Heather,Black Heather	VISSLA	VISSLA	MENS	MENS &GT; TOPS &GT; T-SHIRTS	34.99	0	34.99	26936-DEFAULT-l.jpg	34	26936-DEFAULT-m.jpg	Lucid Dreams Ss Pocket Knit Tee	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Vissla Lucid Dreams Short Sleeve T-Shirt	<p>The Lucid Dream is a surfy heathered 30 singles crew with front panel reverse printed screen print. Featuring side seam woven label and Vissla woven label, let's hope you'll be Lucid Dreaming somewhere warm with waves this Spring. Garment Soft Wash. <br /> <br /> Made from 55% COTTON \| 45% POLYESTER</p>	[empty string]	N	34.95	34.95	Small,Medium,Large,X-Large	26936-DEFAULT-s.jpg	3	1000	M905KLDR	383424	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	vissla/vissla-lucid-dreams-short-sleeve-tshirt-383424	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUN BUM	SUN BUM	MENS	MENS &GT; ACCESSORIES &GT; SUNSCREEN AND SKINCARE	5.99	0	5.99	25579-DEFAULT-l.jpg	5	25579-DEFAULT-m.jpg	Sandbar 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]	77	5-to-10	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Sand Bar	<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]	N	5.99	5.99	[empty string]	25579-DEFAULT-s.jpg	4	1000	20-48054	377110	SUNSCREEN AND SKINCARE	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sand-bar-377110	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	124.99	0	124.99	25663-DEFAULT-l.jpg	124	25663-DEFAULT-m.jpg	Base All Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	9	100-to-150	0.00	[empty string]	Nixon Base 38mm Watch, All Black	<p>Retro curves and contours give the Base throw-back appeal with a modern movement for the digital age.</p>	[empty string]	N	125	125	[empty string]	25663-DEFAULT-s.jpg	5	1000	A1107001	350545	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-base-38mm-watch-all-black-350545	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

NEVER SUMMER Never Summer Cropped Outline 210 Flex Hat $19.99 | view details

COSTA DEL MAR Costa Del Mar Ocearch Blitz Adjustable Trucker Hat, Gray $24.99 | view details

BILLABONG Billabong Big John Safari Hat $26.95 | view details

VISSLA Vissla Lucid Dreams Short Sleeve T- Shirt $34.95 | view details

SUN BUM Sun Bum Spf 15 Tinted Lip Balm, Sand Bar $5.99 | view details

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

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	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	131	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
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25578-DEFAULT-l.jpg	5	25578-DEFAULT-m.jpg	Sunset Cove Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	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	918	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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	969	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]	NIXON	NIXON	WOMENS	WOMENS &GT; ACCESSORIES &GT; WATCHES	124.99	0	124.99	25661-DEFAULT-l.jpg	124	25661-DEFAULT-m.jpg	Time Teller Bb Silver/Hawk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	5	100-to-150	0.00	[empty string]	Nixon Time Teller 37mm, Powell Peralta - Tony Hawk, Silver/Hawk	<p> </p> <p>Clean lines cut through cloudy philosophy, while its simple, high concept design keeps things precise.</p>	[empty string]	N	125	125	[empty string]	25661-DEFAULT-s.jpg	2	1000	A0452840	360542	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-time-teller-37mm-powell-peralta-tony-hawk-silver-hawk-360542	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25586-DEFAULT-l.jpg	3	25586-DEFAULT-m.jpg	Mineral Spf 30 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]	19	5-and-under	0.00	[empty string]	Sun Bum SPF 30 Mineral Lip Balm	<p>Some of us like to go as au naturel as possible, so we’re really proud to introduce our new zinc-based Mineral collection for your lounging and earth loving pleasure. Broad spectrum, zinc based Mineral Sunscreen Lip Balm SPF 30 is made of safe minerals to protect from UVA/UVB rays and moisturize lips. With soothing shea butter and vitamin e, provides excellent physical protection from the sun, wind and cold.</p>	[empty string]	N	3.99	3.99	[empty string]	25586-DEFAULT-s.jpg	3	1000	20-62095	377106	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-30-mineral-lip-balm-377106	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Forest,Poseidon Blue,TRU	RVCA	RVCA	WOMENS	WOMENS &GT; SWIM &GT; BIKINI BOTTOMS	37.99	0	37.99	26699-DEFAULT-l.jpg	37	26699-DEFAULT-m.jpg	Solid Medium Loop Side	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]	SU19	[empty string]	[empty string]	[empty string]	27	25-to-50	0.00	[empty string]	RVCA Solid Medium Side Loop Bikini Bottoms	<p>OPEN YOUR SOLID ESSENTIALS TO NEW CUTS AND CREATIVE ACCENTS WITH THE RVCA SOLID MEDIUM SIDE LOOP BIKINI BOTTOMS. AN ANYWEAR SWIM ESSENTIAL, THE SOLID SWIM BOTTOMS OFFSET A STAPLE MID-COVERAGE CUT WITH LOOP STRAP DETAILS AT THE SIDES, OFFERING A CREATIVE LOOK WHILE LETTING YOU MIX AND MATCH WITHOUT RESTRICTIONS.</p>	[empty string]	N	38	38	X-Small,Small,Medium,Large	26699-DEFAULT-s.jpg	4	1000	XB03TRSM	386473	EMPTY	EMPTY	EMPTY	0	0	0	SWIM	rvca/rvca-solid-medium-side-loop-bikini-bottoms-386473	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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, Pinktini $5.99 $3.99 | view details

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

NIXON Nixon Time Teller 37mm, Powell Peralta - Tony Hawk, Silver/Hawk $125.00 | view details

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

RVCA Rvca Solid Medium Side Loop Bikini Bottoms $38.00 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	25695-DEFAULT-l.jpg	49	25695-DEFAULT-m.jpg	Slip On Black And White Checker/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	REGULAR	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	248	25-to-50	0.00	[empty string]	Vans Classics Checkerboard Slip-On Skate Shoe, Black/Off-White Checkers	<p>The Classic Slip-On has a low profile, slip-on canvas upper with all-over checker print, elastic side accents, Vans flag label and Vans original Waffle Outsole. </p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25695-DEFAULT-s.jpg	5	1000	VN000EYEBWW	11420	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-classics-checkerboard-slipon-skate-shoe-black-offwhite-checkers-11420	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Fog Blue/Multi	ARCADE	ARCADE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	17.99	0	17.99	25902-DEFAULT-l.jpg	17	25902-DEFAULT-m.jpg	The Rambler Youth Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	16	15-to-20	0.00	[empty string]	Arcade Rambler Youth Belt	<p>Everything Arcade is known for in a kid-sized package, meet the Arcade Rambler LTD  youth adventure belt. A fully adjustable minimal buckle is perfect for growing kids and smaller belt loops. Elastic stretch webbing means your kiddo stays comfortable all day and their pants stay where they’re supposed to. Made from machine friendly and quick drying materials means clean up is a breeze for messy kids. Sized for kids ages 4-12.</p> <ul> <li>Kid-friendly</li> <li>Machine washable</li> <li>Travel-Friendly</li> <li>Belt width – 1.25″ (3.17cm)</li> <li>Fits up to 32″/81.3cm</li> </ul>	[empty string]	N	18	18	[empty string]	25902-DEFAULT-s.jpg	11	1000	Y14300-94	384917	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	arcade/arcade-rambler-youth-belt-384917	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[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	20	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]
4	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	74.99	0	74.99	25699-DEFAULT-l.jpg	74	25699-DEFAULT-m.jpg	Kyle Walker Pro Black/White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	85	50-to-100	0.00	[empty string]	Vans Kyle Walker Pro Skate Shoe, Black/White	<p>The all new Kyle Walker Pro, the introductory signature model from rookie pro Kyle Walker, is made with suede uppers. The UltraCush HD impact sockliners keep the foot close to the board while providing the highest level of impact cushioning, and the revolutionary Wafflecup construction offers the support of a cupsole without sacrificing any of the grip or boardfeel of a traditional vulcanized shoe. The Kyle Walker Pro also features DURACAP upper reinforcement in high wear areas for unrivaled durability.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	75	75	7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25699-DEFAULT-s.jpg	32	1000	VN0A2XSGY28	366350	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-kyle-walker-pro-skate-shoe-black-white-366350	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[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	38	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]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	89.99	0	89.99	25706-DEFAULT-l.jpg	89	25706-DEFAULT-m.jpg	Sk8- Hi Mte Cumin/Slate Green	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]	TAN	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Vans Sk8-Hi MTE Shoe, Cumin/Slate Green	<p>The Sk8-Hi MTE revamps the legendary Vans high top with additions designed for the elements. Premium weather-resistant leather uppers, warm textile linings, and a heat retention layer between sockliner and outsole keep feet warm and dry while the newly-constructed vulcanized lug outsole takes advantage of 20 years of snow boot history for maximum traction. The Sk8-Hi MTE also features re-enforced toecaps to withstand repeated wear and padded collars for support and flexibility.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	90	90	8.5	25706-DEFAULT-s.jpg	53	1000	VN0A33TXUQ8	378443	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-sk8hi-mte-shoe-cumin-slate-green-378443	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Classics Checkerboard Slip- On Skate Shoe, Black/Off- White Checkers $50.00 | view details

ARCADE Arcade Rambler Youth Belt $18.00 | view details

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

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

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

VANS Vans Sk8- Hi Mte Shoe, Cumin/Slate Green $90.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]	DVS	DVS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	27035-DEFAULT-l.jpg	69	27035-DEFAULT-m.jpg	Comanche White/Charcoal Nubuck	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	51	50-to-100	0.00	[empty string]	DVS Comanche Skate Shoe, White/Charcoal	<p>The Comanche from DVS is a heritage skate shoe that offers unmatched comfort and durability.  This men’s skate shoe features a durable rubber cupsole construction with reinforced ollie area, leather upper, heavy-duty collar and tongue padding for extra protection, as well as a high impact EVA midsole.  You need to lace up a pair of the Comanche to truly feel the comfort and support of this timeless skate shoe. </p> <ul> <li>Leather & nubuck upper materials</li> <li>Molded TPR heel cap with core logo</li> <li>High impact insole & midsole unit</li> <li>Durable cupsole construction</li> <li>Reinforced ollie area for durability</li> <li>High density collar & tongue padding for support</li> <li>Open-cell breathable mesh tongue</li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	27035-DEFAULT-s.jpg	3	1000	DVF0000029114	383541	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-comanche-skate-shoe-white-charcoal-383541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ADIDAS	ADIDAS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	84.99	0	84.99	26948-DEFAULT-l.jpg	84	26948-DEFAULT-m.jpg	Swift Run Ftwr White/Core 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]	WHT/BLK	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	20	50-to-100	0.00	[empty string]	Adidas Swift Run Shoes, White/Black/Grey	<p>The Swift distills elements from '80s running designs and adds a modern feel. These knit shoes are covered with a striking camouflage graphic and are finished with smooth welded details. They come with a supportive, sock-like feel and are built for all-day ease with a cushy midsole.</p>	[empty string]	N	85	85	9,10,10.5,11,11.5,12,13	26948-DEFAULT-s.jpg	10	1000	CQ2116	384798	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	adidas/adidas-swift-run-shoes-white-black-grey-384798	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Grey	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25819-DEFAULT-l.jpg	13	25819-DEFAULT-m.jpg	Pilot Peak Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	RESTRICTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STAR WARS	[empty string]	H18	[empty string]	OH at 200	[empty string]	18	10-to-15	0.00	[empty string]	Stance Pilot Peak Classic Crew Sock	<p>A sock that looks like it could hike the Tetons to the Sierras, Pilot Peak is a world traveler. Take on your next adventure in style with Stance’s Pilot Peak</p> <h4>FEATURES</h4> <ul> <li>Athletic Ribbed</li> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure <ul> </ul> </li> </ul> <h4>PRODUCT CARE</h4> <ul> <li>Machine wash at 40°c</li> <li>Avoid bleaching or ironing</li> <li>Socks will last longer if you keep them out of the dryer</li> <li>47% combed cotton, 29% polyester, 22% nylon, 3% elastane</li> </ul>	[empty string]	N	14	14	Medium,Large	25819-DEFAULT-s.jpg	11	1000	M546D18PIL	380084	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-pilot-peak-classic-crew-sock-380084	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	94.99	0	94.99	26624-DEFAULT-l.jpg	94	26624-DEFAULT-m.jpg	Sabre Charcoal/Black/Camo	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]	45	50-to-100	0.00	[empty string]	Globe Sabre Skate Shoe, Charcoal/Black/Camo	<p>The Sabre in Charcoal/Black/Camo is a ultra heavy duty skate style made of action nubuck/synthetic nubuck. It features a step-in sock liner with Nitrocel ™ airbag sole. It has a Globe's S-Trac ™ sole pattern.</p>	[empty string]	N	95	95	9.5,10,10.5,11,11.5,12,13,14	26624-DEFAULT-s.jpg	13	1000	GBSABR-15249	383559	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	globe/globe-sabre-skate-shoe-charcoal-black-camo-383559	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Charcoal,Black,VKHK	SANUK	SANUK	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	64.99	0	64.99	26916-DEFAULT-l.jpg	64	26916-DEFAULT-m.jpg	Vagabond Tripper Mesh Mens Shoe	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]	18	50-to-100	0.00	[empty string]	Sanuk Vagabond Tripper Mesh Men's Sidewalk Surfers	<p>The al fresco exploring never stops in Vagabond Tripper Mesh. With warm winds and sunsets as your spirit guides, this puppy was built for breathing in the outdoors. Super cush rebounding footbeds inside a durable, sneaker-like rubber outsole with siping-inspired tread pattern for max grippage.</p>	[empty string]	N	65	65	9,10,11,12,13	26916-DEFAULT-s.jpg	13	1000	1091409	392476	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	sanuk/sanuk-vagabond-tripper-mesh-mens-sidewalk-surfers-392476	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Bronze Brown,Chocolate	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	59.99	0	59.99	19569-DEFAULT-l.jpg	59	19569-DEFAULT-m.jpg	Draftsmen Leather 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]	FA16	[empty string]	OH at 200	[empty string]	195	50-to-100	0.00	[empty string]	Reef Draftsmen Leather Men's Sandal	<p>Style for the beach and beyond. You can get away with sandals at that classy dinner spot if they're the right sandals. These men's leather sandals are perfect for beach weddings. Who wears shoes on the beach? Reef Draftsmen sandals feature full grain premium leather footbed and upper, a “Blind Stich” strap construction that allows stitch-free strap, and a comfort EVA midsole that's highly abrasion resistant, so you can keep wearing them to nice eateries and save them for next wedding season. These sandals also feature molded Reef rubber outsole and secret weapon of the TQT (that's “Thirst Quenching Technology”) hidden bottle opener, to make sure it's a good party.</p>	[empty string]	N	59.99	59.99	7,8,9,10,11,12,13,14	19569-DEFAULT-s.jpg	16	1000	2611	272233	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-draftsmen-leather-mens-sandal-272233	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

DVS Dvs Comanche Skate Shoe, White/Charcoal $70.00 | view details

ADIDAS Adidas Swift Run Shoes, White/Black/Grey $85.00 | view details

STANCE Stance Pilot Peak Classic Crew Sock $14.00 | view details

GLOBE Globe Sabre Skate Shoe, Charcoal/Black/Camo $95.00 | view details

SANUK Sanuk Vagabond Tripper Mesh Men's Sidewalk Surfers $65.00 | view details

REEF Reef Draftsmen Leather Men's Sandal $59.99 | 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	17.99	0	17.99	4161-DEFAULT-l.jpg	17	4161-DEFAULT-m.jpg	Reds Bearings 8- Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	WEB	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	711	15-to-20	0.00	[empty string]	Bones Reds Skateboard Bearings 8 Pack	<p>Bones® REDS® are manufactured in China to our Bones Skate Rated™ specifications in a manufacturing facility dedicated to producing the highest quality skate bearings in China. They are inspected twice before being shipped to skaters and offer the greatest combination of performance, durability and low cost in the industry. Because they offer near Bones Swiss performance at a fraction of the cost, they have become the best selling bearings.</p> <p><strong>Features</strong></p> <ul> <li>Single, non-contact, removable rubber shield 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><strong>Contents</strong></p> <ul> <li>Set of 8 bearings</li> <li>Instructions</li> <li>Sticker</li> </ul>	[empty string]	N	17.95	17.95	[empty string]	4161-DEFAULT-s.jpg	12	1000	6501033	36674	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-reds-skateboard-bearings-8-pack-36674	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	21	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]
3	[empty string]	MADNESS	MADNESS	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	54.99	0	54.99	27055-DEFAULT-l.jpg	54	27055-DEFAULT-m.jpg	Kreiner Expanded R7 8.25 Deck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Madness Expanded Clay R7 Skateboard Deck, 8.25"	<p>MADNESS Expanded Clay 8.25 R7 Skateboard Deck<br /> <em>Resin-7 Canadian Maple Construction </em><br /> <em>Width: 8.25" / Length: 32.1" / Wheelbase: 14.25"</em><br /> Medium Concave / Steep Kick</p>	[empty string]	N	54.99	54.99	8.25	27055-DEFAULT-s.jpg	29	1000	10076021	392540	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	madness/madness-expanded-clay-r7-skateboard-deck-825-392540	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	234.99	0	234.99	27051-DEFAULT-l.jpg	234	27051-DEFAULT-m.jpg	Switch 35 Skull 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	200-to-250	0.00	[empty string]	Landyachtz Switch Skull 35 Complete Longboard, 35"	<p> </p> <p>Forwards or backwards, steep freeride spots or cruising your neighbourhood, the Switch is comfortable in any situation. The 35 inch version has a shorter wheelbase perfect for nailing tight lines and perfectly suited to shorter riders.</p> <p>We design our trucks and wheels to fit perfectly with each individual deck. We work tirelessly to ensure these elements come together to provide the best control and performance for your board.</p> <p>No slop, all control. Don’t accept anything less than the perfect complete.</p> <ul> <li>100% Canadian Maple</li> <li>Deep Concave</li> <li>Drop Down</li> <li>Symmetrical</li> </ul>	[empty string]	N	235	235	35IN	27051-DEFAULT-s.jpg	44	1000	119-DHSW35SKL	386937	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switch-skull-35-complete-longboard-35-386937	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SECTOR 9	SECTOR 9	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	199.99	0	199.99	20820-DEFAULT-l.jpg	199	20820-DEFAULT-m.jpg	Lookout Blue Wave Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FBA FILLS	[empty string]	[empty string]	Y	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	[empty string]	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Sector 9 Lookout Blue Wave Complete Longboard, 42"	<p>Lookoutplete by Sector 9. Length: 42". Width: 9.6". Wheel base: 31.5". 5-ply vertically laminated bamboo and camber mold, with drop through truck design and clear grip. 9" Gullwing Charger trucks. 74mm, 78A Center Set Nineball wheels. Abec 5 PDP bearings. 1.5" hardened steel bolts. Imported.</p>	[empty string]	N	199.99	199.99	42IN	20820-DEFAULT-s.jpg	45	1000	BBS125-C	282616	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	sector-9/sector-9-lookout-blue-wave-complete-longboard-42-282616	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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.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	47	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

BONES Bones Reds Skateboard Bearings 8 Pack $17.95 | view details

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

MADNESS Madness Expanded Clay R7 Skateboard Deck, 8.25 " $54.99 | view details

LANDYACHTZ Landyachtz Switch Skull 35 Complete Longboard, 35 " $235.00 | view details

SECTOR 9 Sector 9 Lookout Blue Wave Complete Longboard, 42 " $199.99 | view details

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

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	41.99	0	41.99	13537-DEFAULT-l.jpg	41	13537-DEFAULT-m.jpg	Premium Hard Rack System	Y	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ALWAYS IN	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]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	FCS Premium D-Ring Hard Rack Roof Pads (PAIR) with Straps	<p>FCS Hard Rack Roof Pads (PAIR)FCS Hard Rack Roof Pads (PAIR)</p>	<p>FCS Hard Rack Roof Pads (PAIR)</p>	N	42	42	[empty string]	13537-DEFAULT-s.jpg	13	1000	1910-549-00D	270977	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-premium-dring-hard-rack-roof-pads-pair-with-straps-270977	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	74.99	0	74.99	26153-DEFAULT-l.jpg	74	26153-DEFAULT-m.jpg	Arc Pc Small Tri Fin Set	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]	4	50-to-100	0.00	[empty string]	FCS Arc Tri-Fins - Small	<p>For fast on-rail surfing. Produces exceptional speed and drive down the line.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for radical, progressive surfing.</li> <li>The raked side fins produce exceptional speed and drive.</li> <li>Based on the 'AM' fin template.</li> <li>On the Medium & Large templates a smaller centre fin offers quick release through turns.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Hollow steep waves, punchy beach breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Performance boards with deep concaves and moderate-to-extreme rocker.</li> <li>Will fit the FCS II Fin System when used with grub screws and the FCS Infill Kit.</li> </ul>	[empty string]	N	75	75	[empty string]	26153-DEFAULT-s.jpg	15	1000	1250-155-00-R	298958	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-arc-trifins-small-298958	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	CHURCHILL	CHURCHILL	SURF SHOP	SURF SHOP &GT; BODYBOARDING &GT; LEASHES	15.99	0	15.99	26324-DEFAULT-l.jpg	15	26324-DEFAULT-m.jpg	Bodyboard Fin Tethers (2)	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[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]	10	15-to-20	0.00	[empty string]	Churchill Bodyboard Fin Tethers	<p>The Churchill neoprene ankle tethers fit any swim fins to reduce risk of losing your fins while riding the waves. Set of 2.</p>	[empty string]	N	15.98	15.98	[empty string]	26324-DEFAULT-s.jpg	22	1000	80330	303726	LEASHES	EMPTY	EMPTY	0	0	0	EMPTY	churchill/churchill-bodyboard-fin-tethers-303726	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	74.99	0	74.99	26146-DEFAULT-l.jpg	74	26146-DEFAULT-m.jpg	Fcs Ii Carver Neo Glass Medium Tri - Lrg	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	50-to-100	0.00	[empty string]	FCS II Carver Neo Glass Tri-Fins - Large	<p>Powerful, drawn-out turns. Excels on open face waves.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for powerful, drawn-out turns with added hold.</li> <li>Elongated template with high degree of sweep provides exceptional hold off the bottom and when carving on the open face.</li> <li>Ideal for power surfers who like to push hard against their fins and draw out their turns.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Open face, down-the-line waves, particularly good in point and reef breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for boards with deep concaves and moderate-to-extreme rocker.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Carver: Find Power. Powerful, drawn-out turns with added hold.</li> </ul>	[empty string]	N	75	75	[empty string]	26146-DEFAULT-s.jpg	38	1000	FCAR-NG01-LG-TS-R	321359	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-carver-neo-glass-trifins-large-321359	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	HYDRO	HYDRO	SURF SHOP	SURF SHOP &GT; DIVE &GT; FINS	66.99	0	66.99	26108-DEFAULT-l.jpg	66	26108-DEFAULT-m.jpg	Tech 2 Fin Black/Green - Medium/Large	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	50-to-100	0.00	[empty string]	Hydro Tech 2 Fins - Black/Green - Medium/Large	<p><strong>SIZE: </strong>MEDIUM/LARGE</p> <ul> <li> <p>Super soft silicone for unsurpassed comfort.</p> </li> <li> <p>V Rail Design for maximum speed and traction.</p> </li> <li> <p>Ergonomic foot cavity for ultimate fit.</p> </li> <li> <p>Non-slip tread.</p> </li> <li> <p>Central vortex drainage for sand and water.</p> </li> <li> <p>Perfect for bodyboarding and surf swimming.</p> </li> </ul>	[empty string]	N	67	67	[empty string]	26108-DEFAULT-s.jpg	38	1000	TTWO-BLG-MLF	348414	FINS	EMPTY	EMPTY	0	0	0	EMPTY	hydro/hydro-tech-2-fins-black-green-medium-large-348414	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; SURF ACCESSORIES &GT; FINS	109.99	0	109.99	26127-DEFAULT-l.jpg	109	26127-DEFAULT-m.jpg	Fcs Ii Performer Pc Carbon Teal Med Tri	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	100-to-150	0.00	[empty string]	FCS II Performer PC Carbon Tri Fins - Medium	<p>Balance of speed, flow and response. Suitable for all conditions.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for a balance of speed, flow & response.</li> <li>Well proportioned template with Inside Foil Technology (IFT).</li> <li>Ideal for surfers who want a reliable ‘All Round’ fin delivering a combination of speed and maneuverability with flow between turns.</li> <li>New Linear Flex: 3D Twist and roll action delivers a smoother feel.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>A wide range of conditions from beach breaks to point breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for all board types.</li> </ul>	[empty string]	N	110	110	[empty string]	26127-DEFAULT-s.jpg	45	1000	FPER-CC02-MD-TS-R	358791	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-performer-pc-carbon-tri-fins-medium-358791	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

FCS Fcs Premium D- Ring Hard Rack Roof Pads (Pair) With Straps $42.00 | view details

FCS Fcs Arc Tri- Fins - Small $75.00 | view details

CHURCHILL Churchill Bodyboard Fin Tethers $15.98 | view details

FCS Fcs Ii Carver Neo Glass Tri- Fins - Large $75.00 | view details

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

FCS Fcs Ii Performer Pc Carbon Tri Fins - Medium $110.00 | view details

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	7.99	0	7.99	25855-DEFAULT-l.jpg	7	25855-DEFAULT-m.jpg	Cassette Stomp	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]	2018	[empty string]	[empty string]	[empty string]	21	5-to-10	0.00	[empty string]	Dakine Cassette Snowboard Stomp Pad	<p>Die-cut and printed EVA is lightweight and durable, and embossed to look like an old-school cassette. An ode to snowboarding, because as we all know, there's no better way to express your true feelings than the classic mixtape.</p>	[empty string]	N	8	8	[empty string]	25855-DEFAULT-s.jpg	4	1000	10001588-H	357736	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-cassette-snowboard-stomp-pad-357736	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	BLUDIGCAMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	29.99	0	29.99	26197-DEFAULT-l.jpg	29	26197-DEFAULT-m.jpg	Blue Digi Camo Convertible Balaclava	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Fishmasks Convertible Ballerclava Balaclava, Blue Digi Camo	<p>Fishmasks Convertible Ballerclava Balaclava, Blue Digi Camo</p>	[empty string]	N	29.99	29.99	[empty string]	26197-DEFAULT-s.jpg	6	1000	FSH-CONV-BLUEDIGICAMO	359418	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-convertible-ballerclava-balaclava-blue-digi-camo-359418	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	519.99	0	519.99	26357-DEFAULT-l.jpg	519	26357-DEFAULT-m.jpg	Peacemaker	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	1	500-and-over	0.00	[empty string]	Never Summer Peacemaker Snowboard, 2019	<p>The Peacemaker ain’t some sheepherding fan boy pro-model. This true twin six-shooter was created using ride and design input from super-shred Dylan Alito. World famous tattoo artist Bryan Henry hand painted the graphic. A soft mid-section flex gets you locked in on rails and pressing a mile high. The nose and tail we made significantly stiffer for huge launches and incredibly stable landings. The extended contact points will have you hanging low and digging trenches. We added a Blower Stance for when the old dusty trail is covered in POW. The Peacemaker makes certain that you’re always bringing the right board to the shootout. #NotAProModel</p>	[empty string]	N	519.99	519.99	152	26357-DEFAULT-s.jpg	8	1000	PEACEMAKER-I	374675	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-peacemaker-snowboard-2019-374675	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Black	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	124.99	0	124.99	25862-DEFAULT-l.jpg	124	25862-DEFAULT-m.jpg	Super Tune Tuning Kit	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]	2	100-to-150	0.00	[empty string]	Dakine Super Tune Tuning Kit	<p>With all the elements of our Deluxe Tune, and the addition of our Adjustable Temp Tuning Iron, the Super Tune Kit has everything you'll need for an entire season of ski or snowboard upkeep. From tuning and filing edges, to scraping, repairing, waxing, and polishing bases, it's the perfect kit to keep your ride in peak shredding condition throughout the year.</p>	[empty string]	N	125	125	[empty string]	25862-DEFAULT-s.jpg	22	1000	10001581-I	373471	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-super-tune-tuning-kit-373471	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	51	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]
6	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	879.99	0	879.99	26366-DEFAULT-l.jpg	879	26366-DEFAULT-m.jpg	West X Split W/O Kit	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]	5	500-and-over	0.00	[empty string]	Never Summer West X Split Snowboard w/o Kit, 2019	<p>Driven off the success of our solid West, we were compelled to make this all terrain slayer into a split. Our NS SuperLight Wood Core gives the West Split a very light touring weight with nimble underfoot performance on the descent. The Ripsaw Rocker Camber Profile gives the West Split tremendous uphill traction and tons of pop for hitting all the natural features the backcountry offers. Look no further, the next frontier of split boarding is in the West. X - Wide version of the original</p>	[empty string]	N	879.99	879.99	160,164	26366-DEFAULT-s.jpg	52	1000	WESTSPLITX-I	374762	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-west-x-split-snowboard-w-o-kit-2019-374762	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Cassette Snowboard Stomp Pad $8.00 | view details

FISHMASKS Fishmasks Convertible Ballerclava Balaclava, Blue Digi Camo $29.99 | view details

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

DAKINE Dakine Super Tune Tuning Kit $125.00 | view details

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

NEVER SUMMER Never Summer West X Split Snowboard W/O Kit, 2019 $879.99 | view details

Accessories

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	SUN BUM	SUN BUM	ACCESSORIES	ACCESSORIES &GT; SUNSCREEN/SKIN CARE	9.99	0	9.99	25591-DEFAULT-l.jpg	9	25591-DEFAULT-m.jpg	Baby Bum Monoi Coconut 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]	1	10-to-15	0.00	[empty string]	Sun Bum Baby Bum Natural Monoi Coconut Balm, 3 oz.	<p>Massage, pamper and soothe dry, sensitive skin with our plant based multi-purpose balm. Inspired by the pacific islander’s coveted coconut oils which are infused with tiare flower petals (monoi) to keep baby’s (and mom’s) skin smooth and moisturized. Enjoy. 100% natural.</p>	[empty string]	N	12.99	12.99	[empty string]	25591-DEFAULT-s.jpg	1	1000	30-80020	374467	EMPTY	EMPTY	EMPTY	0	0	0	SUNSCREEN/SKIN CARE	sun-bum/sun-bum-baby-bum-natural-monoi-coconut-balm-3-oz-374467	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	ELECTRIC	ELECTRIC	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	149.99	0	149.99	27231-DEFAULT-l.jpg	149	27231-DEFAULT-m.jpg	Swingarm S Mat 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]	2	100-to-150	0.00	[empty string]	Electric Swingarm Sport Sunglasses, Matte Black/Grey Polarized	<p>Purpose built and foundational. The Swingarm-S expands the iconic model while maintaining uncompromised fit and function.</p> <ul> <li>Frame: 6 base mold injected grilamid frame in feather weight construction with performance grip nose bridge. Innovative double action hinge system.</li> <li>Optics: 6 base melanin infused polycarbonate lenses. 100% UV protection. Up to 98% blue light protection.</li> <li>Available in polarized polycarbonate lenses. 99.9% Premium glare reduction, relaxed/soothing eye feeling, true color perception, and scratch resistance.</li> <li>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: 49h-140w-159l</li> <li>Weight: 28 grams</li> </ul>	[empty string]	N	150	150	[empty string]	27231-DEFAULT-s.jpg	2	1000	EE15201042	345758	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-swingarm-sport-sunglasses-matte-black-grey-polarized-345758	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	31.99	0	31.99	27192-DEFAULT-l.jpg	31	27192-DEFAULT-m.jpg	Fractal Bcm	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]	Dot Dash Fractal Sunglasses, Black/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-8 Polycarbonate Lens</li> <li>Integrated Plastic Sport Hinge</li> <li>Rubber Nose Pads</li> </ul> </form>	[empty string]	N	32	32	[empty string]	27192-DEFAULT-s.jpg	3	1000	DSLRFFRA-BCM	288562	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-fractal-sunglasses-black-chrome-288562	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,White	SANTA CRUZ	SANTA CRUZ	ACCESSORIES	ACCESSORIES &GT; HATS	26.99	0	26.99	26913-DEFAULT-l.jpg	26	26913-DEFAULT-m.jpg	Classic Dot 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]	12	25-to-50	0.00	[empty string]	Santa Cruz Classic Dot Fitted Stretch High Profile Hat	<p>Flexfit 210 Fitted stretch 6 panel hat with front embroidery.</p>	[empty string]	N	26.99	26.99	One Size	26913-DEFAULT-s.jpg	4	1000	44441840	392446	EMPTY	EMPTY	EMPTY	0	0	0	HATS	santa-cruz/santa-cruz-classic-dot-fitted-stretch-high-profile-hat-392446	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	DOT DASH	DOT DASH	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	44.99	0	44.99	27202-DEFAULT-l.jpg	44	27202-DEFAULT-m.jpg	Turbo Blk Satin/Gold 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]	7	25-to-50	0.00	[empty string]	Dot Dash Turbo Sunglasses, Black Satin/Light Gold 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>Base-6 Polycarbonate Lens</li> <li>Polycarbonate Frame</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	45	45	[empty string]	27202-DEFAULT-s.jpg	5	1000	DSLRFTUR-BDP	381102	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-turbo-sunglasses-black-satin-light-gold-polarized-381102	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	99.99	0	99.99	25690-DEFAULT-l.jpg	99	25690-DEFAULT-m.jpg	Time Teller Corp Black/White	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]	Nixon Time Teller Corp 37mm Watch, Black/White	<p>A bold mash-up between two Nixon Icons, the Time Teller Corp is easy to wear and hard to ignore. Durable and reliable the Time Teller Corp is waterproof up to 100m and features larger numerical indices and printed seconds track.</p>	[empty string]	N	100	100	[empty string]	25690-DEFAULT-s.jpg	6	1000	A1247005	381786	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-time-teller-corp-37mm-watch-black-white-381786	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

SUN BUM Sun Bum Baby Bum Natural Monoi Coconut Balm, 3 Oz. $12.99 | view details

ELECTRIC Electric Swingarm Sport Sunglasses, Matte Black/Grey Polarized $150.00 | view details

DOT DASH Dot Dash Fractal Sunglasses, Black/Chrome $32.00 | view details

SANTA CRUZ Santa Cruz Classic Dot Fitted Stretch High Profile Hat $26.99 | view details

DOT DASH Dot Dash Turbo Sunglasses, Black Satin/Light Gold Polarized $45.00 | view details

NIXON Nixon Time Teller Corp 37mm Watch, Black/White $100.00 | view details

Sale Items

Store blog contact us help

brands

Price

Colors

Sizes