Accessories

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]	ELECTRIC	ELECTRIC	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	119.99	0	119.99	25973-DEFAULT-l.jpg	119	25973-DEFAULT-m.jpg	Knoxville Darkside Tort/Ohm Grey	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	100-to-150	0.00	[empty string]	Electric Knoxville Sunglasses, Darkside Tort/Grey	<p>Electric Knoxville Sunglasses, Darkside Tort/Grey</p>	[empty string]	N	120	120	[empty string]	25973-DEFAULT-s.jpg	1	1000	EE09062320	358542	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	electric/electric-knoxville-sunglasses-darkside-tort-grey-358542	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White	BILLABONG	BILLABONG	MENS	MENS &GT; TOPS &GT; LYCRA AND RASHGUARDS	39.99	0	39.99	26972-DEFAULT-l.jpg	39	26972-DEFAULT-m.jpg	Unity Pf Ls	N	MENS	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]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Billabong Unity Performance Fit Long Sleeve Rashguard	<p>Minimalist lines and maximum surf and sun protection come together in the Unity Long Sleeve Rashguard. The performance fit rashguard delivers UPF 50+ sun protection with ergonomic seams, custom logo prints and a silky smooth fabric.</p> <p>The nuts and bolts</p> <ul> <li>Mens long sleeve rashguard.</li> <li>Traditional mock neck.</li> <li>Silky-smooth feel.</li> <li>Billabong logo at center chest and sleeve.</li> <li>50+ UPF sun protection.</li> <li>B-Lock super flex stitch.</li> <li>Material: 6 oz silk touch fabric. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	39.95	39.95	Small,Medium,Large,X-Large	26972-DEFAULT-s.jpg	2	1000	MR61TBUY	382774	LYCRA AND RASHGUARDS	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-unity-performance-fit-long-sleeve-rashguard-382774	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	39.99	0	39.99	26036-DEFAULT-l.jpg	39	26036-DEFAULT-m.jpg	Buford T Gloss Gold/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]	[empty string]	[empty string]	[empty string]	UPDATE	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Dot Dash Buford T Sunglasses, Black Satin/Blue Flash	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <p><strong>Metal Shop</strong> <strong>Collection</strong> ~ Raise your goblet of rock; it’ll blow your back teeth out.</p> <h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Base-8 Polycarbonate Lens</li> <li>Metal Frame</li> <li>Hardened 3 Barrel Metal Hinge</li> </ul> </form>	[empty string]	N	40	40	[empty string]	26036-DEFAULT-s.jpg	6	1000	DSMSFBUF-GGN	274618	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-buford-t-sunglasses-black-satin-blue-flash-274618	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	NIXON	NIXON	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	124.99	0	124.99	25662-DEFAULT-l.jpg	124	25662-DEFAULT-m.jpg	The Rival White/Charcoal	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	100-to-150	0.00	[empty string]	Nixon The Rival 38mm Watch, White/Charcoal	<p>For those who charge hard in and out of the water, the Rival is the go-to in the lineup. Featuring a high-contrast digital display wrapped in a bold bezel, free-swing band with a textured pattern to channel water, water resistant pushers, and 550 pre-programmed tide locations, the Rival never backs away from a challenge.</p>	[empty string]	N	125	125	[empty string]	25662-DEFAULT-s.jpg	7	1000	A12362015	375186	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-the-rival-38mm-watch-white-charcoal-375186	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	PENNY	PENNY	MENS	MENS &GT; ACCESSORIES &GT; BACKPACKS	44.99	0	44.99	26426-DEFAULT-l.jpg	44	26426-DEFAULT-m.jpg	Penny Pouch Dark Dye Backpack	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Penny Skateboards Dark Dye Backpack	<p>Penny Skateboards Dark Dye Backpack</p>	[empty string]	N	44.99	44.99	[empty string]	26426-DEFAULT-s.jpg	8	1000	PNYA011	365476	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-dark-dye-backpack-365476	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	DOT DASH	DOT DASH	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	37.99	0	37.99	26052-DEFAULT-l.jpg	37	26052-DEFAULT-m.jpg	Plimsoul Blk Satin/Gry Polarized	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]	18	25-to-50	0.00	[empty string]	Dot Dash Plimsoul Sunglasses, Black Satin/Grey Polarized	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>Polarized Lens</li> <li>100% UV 400 Protection</li> <li>Base-6 Polycarbonate Lens</li> <li>Polycarbonate Frame</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	38	38	[empty string]	26052-DEFAULT-s.jpg	11	1000	DSVTFPLI-BSP	312697	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-plimsoul-sunglasses-black-satin-grey-polarized-312697	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

ELECTRIC Electric Knoxville Sunglasses, Darkside Tort/Grey $120.00 | view details

BILLABONG Billabong Unity Performance Fit Long Sleeve Rashguard $39.95 | view details

DOT DASH Dot Dash Buford T Sunglasses, Black Satin/Blue Flash $40.00 | view details

NIXON Nixon The Rival 38mm Watch, White/Charcoal $125.00 | view details

PENNY Penny Skateboards Dark Dye Backpack $44.99 | view details

DOT DASH Dot Dash Plimsoul Sunglasses, Black Satin/Grey Polarized $38.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	99	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	706	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	849	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	Aquifer	ROXY	ROXY	WOMENS	WOMENS &GT; ACCESSORIES &GT; HATS	21.99	0	21.99	26679-DEFAULT-l.jpg	21	26679-DEFAULT-m.jpg	Extra Innings B Hat	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]	SP19	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Roxy Extra Innings B Baseball Hat	<ul> <li><strong>Fabric:</strong> Cotton twill fabric</li> <li><strong>Construction:</strong> 6-panel "J-shape" construction</li> <li><strong>Visor/Brim:</strong> Curved visor</li> <li>Leather logo patch</li> <li><strong>Size:</strong> OSFM = 22" / 56 cm Ø</li> </ul> <p>Composition</p> <ul> <li> <p>100% Cotton</p> </li> </ul>	[empty string]	N	22	22	[empty string]	26679-DEFAULT-s.jpg	1	1000	ERJHA03540	388756	HATS	EMPTY	EMPTY	0	0	0	EMPTY	roxy/roxy-extra-innings-b-baseball-hat-388756	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	15.99	0	15.99	13954-DEFAULT-l.jpg	15	13954-DEFAULT-m.jpg	Spf 70 Spray Sunscreen	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]	0	15-to-20	0.00	[empty string]	Sun Bum SPF 70 Spray Sunscreen, 6 oz.	<p>This easy to use, ultra sheer/dry touch continuous spray formula will protect your skin from harmful UVA/UVB rays while enriching your skin with Vitamin E, an antioxidant that helps to neutralize free radicals, which are the main cause of premature skin aging.</p>	[empty string]	N	15.99	15.99	[empty string]	13954-DEFAULT-s.jpg	2	1000	20-42070	271639	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-70-spray-sunscreen-6-oz-271639	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
6	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	15.99	0	15.99	13947-DEFAULT-l.jpg	15	13947-DEFAULT-m.jpg	Spf 15 Lotion 8oz Sunscreen	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]	0	15-to-20	0.00	[empty string]	Sun Bum SPF 30 Sunscreen Lotion, 8 oz.	<p>This moisturizing sunscreen formula will protect your skin from harmful UVA/UVB rays while enriching your skin with Vitamin E, an antioxidant that helps to neutralize free radicals, which are the main cause of premature skin aging.</p>	[empty string]	N	15.99	15.99	[empty string]	13947-DEFAULT-s.jpg	3	1000	20-40015	271632	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-30-sunscreen-lotion-8-oz-271632	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

ROXY Roxy Extra Innings B Baseball Hat $22.00 | view details

SUN BUM Sun Bum Spf 70 Spray Sunscreen, 6 Oz. $15.99 | view details

SUN BUM Sun Bum Spf 30 Sunscreen Lotion, 8 Oz. $15.99 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	59.99	0	59.99	27132-DEFAULT-l.jpg	59	27132-DEFAULT-m.jpg	Slip On (Chambray) True Navy/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]	NAVY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	70	50-to-100	0.00	[empty string]	Vans Chambray Slip-On Skate Shoe, True Navy/True Navy	<p>The Chambray Classic Slip-On features sturdy low profile textile and canvas uppers, padded collars, elastic side accents, and signature rubber waffle outsoles.</p> <p>SIZE DISPLAYED IN DROP DOWN IS BOYS/MENS<br /> 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	4.5,5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27132-DEFAULT-s.jpg	10	1000	VN0A38F7VIO	383092	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-chambray-slipon-skate-shoe-true-navy-true-navy-383092	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	9.99	0	9.99	25949-DEFAULT-l.jpg	9	25949-DEFAULT-m.jpg	Bowline Silicone Retainer Gry/Blu	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	5-to-10	0.00	[empty string]	Costa Del Mar Silicone Sunglasses Retainer, Grey/Blue	<p>Streamlined silicone retainer. Flexible, durable, and lightweight with sliding bead for adjustable tension. <strong>End-to-End Measurement: </strong>19"</p>	[empty string]	N	9.99	9.99	[empty string]	25949-DEFAULT-s.jpg	69	1000	BW98	363720	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-silicone-sunglasses-retainer-grey-blue-363720	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; BOYS &GT; SHOES	54.99	0	54.99	27131-DEFAULT-l.jpg	54	27131-DEFAULT-m.jpg	Youth Tnt Adv Prototype (Anti Hero) Army	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BROWN	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	23	50-to-100	0.00	[empty string]	Vans x Anti Hero TNT Advanced Prototype Kids Skate Shoe	<p>This Spring, two of the world?s most iconic skate brands team up again for a unique collection of footwear and apparel that celebrates both brands? storied histories. On The Wire and Off The Wall, the Vans x ANTI HERO TNT Advanced Prototype Youth is a progressive vulcanized skateboarding shoe made with suede uppers and Vans original waffle outsoles utilizing a rubber that offers grip and support. Featuring custom Vans x ANTI HERO details, the TNT Advanced Prototype Youth also includes Pro Vulc Lite construction to deliver the best in boardfeel, flex, and traction.</p>	[empty string]	N	55	55	13,1,2,3,4,5,6	27131-DEFAULT-s.jpg	72	1000	VN0A3TLDVGP	383069	SHOES	EMPTY	EMPTY	0	0	0	EMPTY	vans/vans-x-anti-hero-tnt-advanced-prototype-kids-skate-shoe-383069	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	49.99	0	49.99	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	73	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]
5	Black	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	25815-DEFAULT-l.jpg	13	25815-DEFAULT-m.jpg	Bones 2 Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	Stance Bones 2 Boys Kids Crew Sock	<p>Whether it's Halloween or 4th of July, Stance's Bones2 are a wardrobe essential. With a classic skeleton design that glows in the dark this sock is a perfect fit for your attire.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25815-DEFAULT-s.jpg	79	1000	M556D18BO2	380074	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-bones-2-boys-kids-crew-sock-380074	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[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	80	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]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

VANS Vans Chambray Slip- On Skate Shoe, True Navy/True Navy $60.00 | view details

COSTA DEL MAR Costa Del Mar Silicone Sunglasses Retainer, Grey/Blue $9.99 | view details

VANS Vans X Anti Hero Tnt Advanced Prototype Kids Skate Shoe $55.00 | view details

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

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

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

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Off Black,Sage	BILLABONG	BILLABONG	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	22.99	0	22.99	26978-DEFAULT-l.jpg	22	26978-DEFAULT-m.jpg	Good Waves Sandal	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]	SP19	[empty string]	[empty string]	[empty string]	34	20-to-25	0.00	[empty string]	Billabong Good Waves Eco-Friendly Beach Sandals	<p>Beach sandals that minimize your footprint on the environment. Clean and classic, the Good Waves Eco-friendly sandals are made with recycled Bloom Foam algae and feature a molded strap for comfort. Make comfortable steps towards a better planet.</p> <p>The nuts and bolts</p> <ul> <li>Womens eco-friendly beach sandals.</li> <li>Made with recycled Bloom Foam algae.</li> <li>Molded strap.</li> <li>Thong style straps. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	22.95	22.95	6,7,8,9,10	26978-DEFAULT-s.jpg	4	1000	JFOTTBGO	385585	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	billabong/billabong-good-waves-ecofriendly-beach-sandals-385585	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Black/Dark Shadow,Koa/Espresso	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	84.99	0	84.99	26886-DEFAULT-l.jpg	84	26886-DEFAULT-m.jpg	Kua ` Aina Mens Sandal	N	MENS	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]	[empty string]	[empty string]	[empty string]	[empty string]	13	50-to-100	0.00	[empty string]	Olukai KuaAina Men's Sandals	<p>Inspired by the asymmetrical grid of Hawaiian kalo loi fields, we mimicked the pattern on the Kua?aina outsole for a new level of traction. When Hawai‘i’s geography throws challenging terrain your way, from mud to lava rock to loose scree, the Kua?aina remains sure-footed and comfortable when a casual adventure turns a little more unstable.</p> <p>FEATURES<br /> Heavyweight upper stitching, hand-sewn decorative canoe lashing and embossed logo detail.</p>	[empty string]	N	85	85	8,9,10,11,12,13	26886-DEFAULT-s.jpg	7	1000	10389	382195	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	olukai/olukai-kuaaina-mens-sandals-382195	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	49.99	0	49.99	6520-DEFAULT-l.jpg	49	6520-DEFAULT-m.jpg	Authentic True White	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	152	25-to-50	0.00	[empty string]	Vans Authentic Skate Shoe, True White	<p>The Authentic, Vans original and now iconic style, is a simple low top, lace-up with durable canvas upper, metal eyelets, Vans flag label and Vans original Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	50	50	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	6520-DEFAULT-s.jpg	25	1000	VN000EE3W00	233920	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-authentic-skate-shoe-true-white-233920	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	DC	DC	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	99.99	0	99.99	27022-DEFAULT-l.jpg	99	27022-DEFAULT-m.jpg	Vandium Se Navy/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]	NAVY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	45	50-to-100	0.00	[empty string]	DC Vandium SE Skate Shoes, Navy/White	<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	8,8.5,9,9.5,10,10.5,11,11.5,12,13	27022-DEFAULT-s.jpg	26	1000	ADYS200067-NVW	382980	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-vandium-se-skate-shoes-navy-white-382980	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25780-DEFAULT-l.jpg	13	25780-DEFAULT-m.jpg	Somme Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	Stance Somme Classic Crew Sock	<p>Stripes can power up any casual look to an entirely new level. Take a step into sophistication with the Somme.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Medium,Large	25780-DEFAULT-s.jpg	28	1000	M556C18SOM	370590	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-somme-classic-crew-sock-370590	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	79.99	0	79.99	26787-DEFAULT-l.jpg	79	26787-DEFAULT-m.jpg	Sk8 Hi Pro Bmx (Scotty Cranmer) 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]	WHITE	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	13	50-to-100	0.00	[empty string]	Stance Sk8-Hi Pro Skate Shoe	<p>The Sk8-Hi Pro BMX in Scotty Cranmer?s signature colorway is a Vans classic upgraded for enhanced performance. Featuring sturdy canvas and suede uppers, the Sk8-Hi Pro BMX also includes UltraCush HD sockliners to provide the highest level of impact cushioning, DURACAP reinforcement rubber underlays in high wear areas for unrivaled durability, and the Vans revolutionary Wafflecup BMX construction for unrivaled support and pedalfeel.</p>	[empty string]	N	80	80	8,8.5,9,9.5,10,10.5,11,12	26787-DEFAULT-s.jpg	37	1000	VN0A45JVVGC	383061	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/stance-sk8hi-pro-skate-shoe-383061	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

BILLABONG Billabong Good Waves Eco- Friendly Beach Sandals $22.95 | view details

OLUKAI Olukai Kuaaina Men's Sandals $85.00 | view details

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

DC Dc Vandium Se Skate Shoes, Navy/White $100.00 | view details

STANCE Stance Somme Classic Crew Sock $14.00 | view details

VANS Stance Sk8- Hi Pro Skate Shoe $80.00 | view details

Skateboards

Helmets Pads Slide Gloves

Complete Longboards Longboard Decks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	108.99	0	108.99	26429-DEFAULT-l.jpg	108	26429-DEFAULT-m.jpg	Penny Undulations 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	100-to-150	0.00	[empty string]	Penny Skateboards Undulations Complete Skateboard, 22"	<p>Inspired by the movement of the ocean, the Undulations 22" features blue, white and green waves on a premium white deck. The perfect boardwalk cruiser, this board comes with teal and black trucks and white stoneground wheels.</p> <ul> <li>22" Plastic Deck</li> <li>3-inch aluminum trucks with powder-coated finish</li> <li>59mm, 83A wheels for a smooth ride</li> <li>83A color-coded cushions</li> <li>Color-coded high tensile deck bolts</li> <li>Quality Color-coded Abec 7 stainless steel bearings</li> </ul>	[empty string]	N	109	109	22IN	26429-DEFAULT-s.jpg	5	1000	PNYCOMP22428	374213	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-undulations-complete-skateboard-22-374213	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SHAKE JUNT	SHAKE JUNT	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	12.99	0	12.99	26921-DEFAULT-l.jpg	12	26921-DEFAULT-m.jpg	T- Funk Pro Griptape	N	[empty string]	[empty string]	[empty string]	[empty string]	6	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	21	10-to-15	0.00	[empty string]	Shake Junt T-Funk Pro Griptape	<p>Shake Junt T-Funk Pro Griptape</p>	[empty string]	N	13	13	[empty string]	26921-DEFAULT-s.jpg	7	1000	02-06-0143	391219	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	shake-junt/shake-junt-tfunk-pro-griptape-391219	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPITFIRE	SPITFIRE	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	39.99	0	39.99	26746-DEFAULT-l.jpg	39	26746-DEFAULT-m.jpg	F4 99 Conical Fulls Natural Whl	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Spitfire Formula Four 99D Overlay Skateboard Wheels, 54mm	<p>Spitfire Formula Four 99D Overlay Skateboard Wheels, 54mm</p>	[empty string]	N	39.99	39.99	54MM	26746-DEFAULT-s.jpg	21	1000	2111019354	391810	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	spitfire/spitfire-formula-four-99d-overlay-skateboard-wheels-54mm-391810	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; LONGBOARD DECKS	118.99	0	118.99	26318-DEFAULT-l.jpg	118	26318-DEFAULT-m.jpg	Battle Axe 40 Chill Bird 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]	3	100-to-150	0.00	[empty string]	Landyacthz Battle Axe 40 Chill Bird Deck, 40"	<p>Despite the aggressive name, this board can be pretty dang chill. For those who want to casually cruise around town, and those who want to fulfill their dreams by carving up the streets like wild animals. The perfect combo of drop through truck mounting, rocker, and a little bit of flex make it easy and comfortable to ride. One of our most popular boards of all time.</p>	[empty string]	N	119	119	40IN	26318-DEFAULT-s.jpg	23	1000	DK-FRBA40	377895	LONGBOARD DECKS	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyacthz-battle-axe-40-chill-bird-deck-40-377895	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	144.99	0	144.99	27040-DEFAULT-l.jpg	144	27040-DEFAULT-m.jpg	Big Blazer Rosewood Cow Print Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Globe Big Blazer Complete Cruiser Skateboard, Rosewood/Cowprint, 32"	<p>+ Medium length Resin-7 hard rock maple diamond tail cruiser</p> <p>+ Built in bottle opener</p> <p>+ 32" x 9.125" x 17.75" WB</p> <p>+ Mellow concave with kick tail</p> <p>+ 6.0" Tensor Alloy trucks</p> <p>+ 62mm 78a wheels</p> <p>+ Printed griptape</p>	[empty string]	N	144.99	144.99	32IN	27040-DEFAULT-s.jpg	29	1000	10525195ROSECOW	383798	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	globe/globe-big-blazer-complete-cruiser-skateboard-rosewood-cowprint-32-383798	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	9.99	0	9.99	26909-DEFAULT-l.jpg	9	26909-DEFAULT-m.jpg	Slimline Silver Rails	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	5-to-10	0.00	[empty string]	Santa Cruz Slimline Rails Silver	<p>Slide over and across anything with new "Slimline" rails by Slimeballs and Santa Cruz Skateboards. Out slide the rest at every session! Available in silver and white.</p>	[empty string]	N	9.99	9.99	[empty string]	26909-DEFAULT-s.jpg	40	1000	99992855	387629	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	santa-cruz/santa-cruz-slimline-rails-silver-387629	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

PENNY Penny Skateboards Undulations Complete Skateboard, 22 " $109.00 | view details

SHAKE JUNT Shake Junt T- Funk Pro Griptape $13.00 | view details

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

LANDYACHTZ Landyacthz Battle Axe 40 Chill Bird Deck, 40 " $119.00 | view details

GLOBE Globe Big Blazer Complete Cruiser Skateboard, Rosewood/Cowprint, 32 " $144.99 | view details

SANTA CRUZ Santa Cruz Slimline Rails Silver $9.99 | view details

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	SLOWTIDE	SLOWTIDE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	29.99	0	29.99	27106-DEFAULT-l.jpg	29	27106-DEFAULT-m.jpg	Black Hills Off Wht Towel	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Slowtide Black Hills Off White Beach Towel	<p>Itchin’ for an Indian Summer with the crew and the Black Hills towel. An update to a favorite Slowtide towel.</p> <p>Slowtide partners with artists, photographers, designers, and brands to create unique prints for the towels, all while maintaining premium quality. Equipped with a hanging loop feature and made from 100% sustainably sourced cotton, you are guaranteed the best drying experience.</p> <p><strong>Features</strong></p> <ul> <li>For all bodies of water</li> <li>100% super soft & absorbent cotton velour</li> <li>Reactive dye that helps prevent fading</li> <li>One-sided print</li> <li>30" x 60"</li> <li>460 grams (Lightweight)</li> <li>Hanging loop</li> <li>Imported</li> </ul>	[empty string]	N	29.95	29.95	[empty string]	27106-DEFAULT-s.jpg	13	1000	ST185	386674	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	slowtide/slowtide-black-hills-off-white-beach-towel-386674	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	89.99	0	89.99	26278-DEFAULT-l.jpg	89	26278-DEFAULT-m.jpg	Fk1 Twin Fin Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Futures K1 Twin Fins	<p>The K1 Keel fin is Future's classic Keel Fin design. The Honeycomb core with the classic bamboo inlay give the K1 a medium flex pattern and the big, old-school template generates rail-to-rail speed down the line and provides hold through direction changes. The K1 Keel is the iconic match up with your retro-fish.</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> </tr> <tr> <td style="width:134.4px">Area</td> <td>25.53</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>5.07</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>6.65</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> </tr> </tbody> </table>	[empty string]	N	90	90	[empty string]	26278-DEFAULT-s.jpg	15	1000	1510-132-20	381597	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-k1-twin-fins-381597	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Coastal Blue,Navy/Blue,White,Black	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; MEN'S	39.99	0	39.99	26574-DEFAULT-l.jpg	39	26574-DEFAULT-m.jpg	All Day Wave Lf Ls	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	SU19	[empty string]	OH at 200	[empty string]	83	25-to-50	0.00	[empty string]	Billabong All Day Wave Loose Fit Long Sleeve Rashguard	<p>Bring together the fit of your favorite surf tee and the silk smooth feel of quick-dry, silk touch fabric. This long sleeve rashguard delivers all day sun protection and clean, t-shirt lines for a relaxed take on the traditional rashguard.</p> <ul> <li>T-shirt fit rashguard / wetshirt.</li> <li>Long sleeves.</li> <li>Logo prints.</li> <li>Crew neck.</li> <li>50 + UPF sun protection.</li> <li>Over lock hidden seam.</li> <li>Loose Fit: Relaxed fit surf shirt with maximum sun protection for long beach days.</li> <li>Material: 6oz silk touch fabric.</li> </ul>	[empty string]	N	39.95	39.95	Small,Medium,Large,X-Large,XX-Large	26574-DEFAULT-s.jpg	37	1000	MR61TBWL	382775	LONG SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	billabong/billabong-all-day-wave-loose-fit-long-sleeve-rashguard-382775	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VERTRA	VERTRA	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	22.99	0	22.99	2773-DEFAULT-l.jpg	22	2773-DEFAULT-m.jpg	Shane Dorian Face Stick Kona Gold	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]	3	20-to-25	0.00	[empty string]	Vetra Face Stick SD SPF 38, Kona Gold – Shane Dorian’s Signature Tint, .39 OZ	<p>The Kona Gold is Shane Dorian’s Signature stick and provides the ultimate Broad Spectrum protection against skin aging UVA rays and skin burning UVB rays. An infusion of beige and yellow tints were color matched to his skin tone. Shane was personally involved in every stage of the development of this product – From research and development, color selection and even the choice of a light, citrus fragrance, which reminded him of the fruit trees in his back yard in Kailua, Kona, Hawaii. Water Resistant (80 minutes). Broad Spectrum. Non-Greasy application. Designed, formulated and manufactured to the highest sunscreen and cosmetic industry standards.</p>	[empty string]	N	23	23	[empty string]	2773-DEFAULT-s.jpg	39	1000	V.PX.004.202.NS	235210	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	vertra/vetra-face-stick-sd-spf-38-kona-gold-shane-dorians-signature-tint-39-oz-235210	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Multi	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; KIDS	64.99	0	64.99	26809-DEFAULT-l.jpg	64	26809-DEFAULT-m.jpg	Sun Dream Ls Rg 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]	13	50-to-100	0.00	[empty string]	Billabong Girls' Sun Dream Set Rashguard Set	<p>Add sunshine and water and watch her bloom. Printed with sun-lit florals, the girls long sleeve rashguard bikini set is trimmed with feminine ruffle details at the sides.</p>	[empty string]	N	64.95	64.95	4,5,7,8,10,12	26809-DEFAULT-s.jpg	44	1000	Y215TBSU	387574	LONG SLEEVE LYCRA	KIDS	EMPTY	0	0	0	LYCRA	billabong/billabong-girls-sun-dream-set-rashguard-set-387574	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	59.99	0	59.99	26250-DEFAULT-l.jpg	59	26250-DEFAULT-m.jpg	Hs Quad Rear Pair	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]	Futures HS Quad Rear Fins	<p>The next level in speed generating fins is here with the all new Generation Series. These fins will provide all the speed you need while maintaining an element of control. Sitting one notch below the Blackstix on our Ride Number scale, all Generation Series fins hold Ride Numbers between 9 to 7, for those of you looking for a bit more stability & drive than Blackstix.</p>	[empty string]	N	60	60	[empty string]	26250-DEFAULT-s.jpg	62	1000	2488-410-47	341108	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-hs-quad-rear-fins-341108	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SLOWTIDE Slowtide Black Hills Off White Beach Towel $29.95 | view details

FUTURE FINS Futures K1 Twin Fins $90.00 | view details

BILLABONG Billabong All Day Wave Loose Fit Long Sleeve Rashguard $39.95 | view details

VERTRA Vetra Face Stick Sd Spf 38, Kona Gold – Shane Dorian ’ S Signature Tint,.39 Oz $23.00 | view details

BILLABONG Billabong Girls ' Sun Dream Set Rashguard Set $64.95 | view details

FUTURE FINS Futures Hs Quad Rear Fins $60.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	WATER	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26183-DEFAULT-l.jpg	19	26183-DEFAULT-m.jpg	Water Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	OH at 200	[empty string]	78	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Water	<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 - Water</p>	N	19.99	19.99	[empty string]	26183-DEFAULT-s.jpg	24	1000	FSH-SL-WATER	359382	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-water-359382	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Black/White,Heather Grey	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	27.99	0	27.99	25638-DEFAULT-l.jpg	27	25638-DEFAULT-m.jpg	Corporate Silicon 2 Flexfit 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]	2019	[empty string]	[empty string]	[empty string]	99	25-to-50	0.00	[empty string]	Never Summer Corporate Silicon 2 Flexfit Hat	<p>The Never Summer Corporate Silicon 2 Flexfit Hat features a silicone Never Summer logo at front.</p>	[empty string]	N	28	28	Small/Medium,Large/X-Large	25638-DEFAULT-s.jpg	30	1000	HTCORP2FF	374864	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-corporate-silicon-2-flexfit-hat-374864	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	599.99	0	599.99	26370-DEFAULT-l.jpg	599	26370-DEFAULT-m.jpg	Chairman X	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	1	500-and-over	0.00	[empty string]	Never Summer Chairman X Snowboard, 2019	<p>Bred to be the CEO of Shred this carving machine utilizes a seven contact point sidecut, maximum effective edge, and is handcrafted specifically for Never Summer’s Chairman of the Boards. Our most extensive damping system stabilizes the ends of the board for unmatched high-speed stability and trench digging performance. On the Chairman you carve, you carve…No slide! X - Wide version of the original</p>	[empty string]	N	599.99	599.99	161	26370-DEFAULT-s.jpg	41	1000	CHAIRMANX-I	374753	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-chairman-x-snowboard-2019-374753	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Cream,Alloy	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	11.99	0	11.99	25834-DEFAULT-l.jpg	11	25834-DEFAULT-m.jpg	Pyramid Stud	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]	46	10-to-15	0.00	[empty string]	Dakine Pyramid Studs Stone Stomp Pad	<p>Studs and stomp pads aren't always necessary, but when you need them, you want to know they're going to work. Our Pyramid Studs are perfect for giving you reliable footing with your free foot, without taking up a ton of space on your board. The sturdy plated aluminum features a simple peel and stick adhesive backing, so you can personalize your setup. Each pack of 9 is available in a black, brass, or chrome finish.</p>	[empty string]	N	12	12	[empty string]	25834-DEFAULT-s.jpg	69	1000	10001555-H	357739	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-pyramid-studs-stone-stomp-pad-357739	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	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	78	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]
6	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	289.99	0	289.99	26361-DEFAULT-l.jpg	289	26361-DEFAULT-m.jpg	Starlet	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]	2019	[empty string]	[empty string]	[empty string]	5	250-to-300	0.00	[empty string]	Never Summer Starlet Kids Snowboard, 2019	<p>This is THE board for your little rock star. It features our playful and forgiving Original Rocker Camber Profile for quick progression to the next level. The Starlet also has Vario Power Grip Sidecut and our Freestyle Damping System for an effortless ride and a famous style. Whether you’re learning to shred or you’re a snowboarding superstar, reach for the Starlet.</p>	[empty string]	N	289.99	289.99	125,130,136	26361-DEFAULT-s.jpg	79	1000	STARLET-I	374759	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-starlet-kids-snowboard-2019-374759	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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, Water $19.99 | view details

NEVER SUMMER Never Summer Corporate Silicon 2 Flexfit Hat $28.00 | view details

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

DAKINE Dakine Pyramid Studs Stone Stomp Pad $12.00 | view details

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

NEVER SUMMER Never Summer Starlet Kids Snowboard, 2019 $289.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	Al Agnew Fish	FISHMASKS	FISHMASKS	ACCESSORIES	ACCESSORIES &GT; FACEMASKS	19.99	0	19.99	26186-DEFAULT-l.jpg	19	26186-DEFAULT-m.jpg	Aa Fish Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SU17	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter - Al Agnew Collection, Underwater Rainbow	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	[empty string]	N	19.99	19.99	[empty string]	26186-DEFAULT-s.jpg	1	1000	FHS-SL-AAFISH	363361	EMPTY	EMPTY	EMPTY	0	0	0	FACEMASKS	fishmasks/fishmasks-single-layer-neck-gaiter-al-agnew-collection-underwater-rainbow-363361	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	VON ZIPPER	VON ZIPPER	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	159.99	0	159.99	27268-DEFAULT-l.jpg	159	27268-DEFAULT-m.jpg	Palooka Trt Sat/Gry Wldlfe 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]	5	150-to-200	0.00	[empty string]	VonZipper Palooka Sunglasses, Tortoise Satin/Wildlife Vintage Grey Polarized	<p><strong>Story: </strong>The undisputed champion of the sunglass world. This prizefighter doesn't pull a punch in or out of the ring. Step into the squared circle and knock 'em out in the Palooka...</p> <p><strong>Specs: </strong>100% UV protection. Base 8 spherical lens. RGNS system - molded rubber nose pads. Impact resistant polycarbonate lens. Nylon Grilamid frame. Stainless steel optical hinges. Made in Italy.</p> <p> </p>	[empty string]	N	160	160	[empty string]	27268-DEFAULT-s.jpg	3	1000	SMPFEPAL-PTO	344464	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	von-zipper/vonzipper-palooka-sunglasses-tortoise-satin-wildlife-vintage-grey-polarized-344464	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	G-SHOCK	G-SHOCK	ACCESSORIES	ACCESSORIES &GT; WATCHES	129.99	0	129.99	26290-DEFAULT-l.jpg	129	26290-DEFAULT-m.jpg	Ga700cm Grn Camo	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]	G-Shock Analog-Digital Watch, Green Camo	<p>G-SHOCK is the watch brand that is always finding ways to incorporate world culture icons into exciting new designs, and these new models are themed on the camouflage patterns that are very much a part of today's fashions. The base model is the GA700, whose main feature is its iconic front button. The band is decorated with an authentic camouflage pattern, and the surfaces of the cases and bands are printed using technology that makes it possible to show more printed surfaces than normal, allowing a total of four colors, in addition to the base resin color. The models of this lineup come in one of three standard colors: navy blue, khaki, and gray. Realistic camouflage patterns add a subdued touch to the GA700 for a truly modern design.</p> <ul style="margin-left:0px; margin-right:0px"> <li>Shock Resistant</li> <li>200 Meter Water Resistant</li> <li>Super Illuminator LED Light with Afterglow (selectable illumination duration 1.5 or 3 seconds)</li> <li>World Time</li> <li>31 times zones (48 cities + UTC), daylight saving on/off, home city/world time swapping</li> <li>4 Daily Alarms and 1 Snooze Alarm</li> </ul>	[empty string]	N	130	130	[empty string]	26290-DEFAULT-s.jpg	3	1000	GA700CM-3	379763	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	g-shock/gshock-analogdigital-watch-green-camo-379763	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SEX WAX	SEX WAX	ACCESSORIES	ACCESSORIES	9.99	0	9.99	2779-DEFAULT-l.jpg	9	2779-DEFAULT-m.jpg	Grape Scented Candles	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	18	5-to-10	0.00	[empty string]	Sexwax Grape Scented Candle	<p>Sexwax Candle fragrances are available in Coconut, Strawberry, or Grape. These candles have lead free wicks and are contained within a 4 ounce clear glass jar. Sexwax Candles will provide a long lasting flame for up to 30 hours or more.</p>	[empty string]	N	9.99	9.99	[empty string]	2779-DEFAULT-s.jpg	7	1000	CDG4	251032	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sex-wax/sexwax-grape-scented-candle-251032	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	COSTA DEL MAR	COSTA DEL MAR	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	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	7	1000	CF11	349328	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	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]
6	Resin,Washed Palm	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; HATS	21.99	0	21.99	25866-DEFAULT-l.jpg	21	25866-DEFAULT-m.jpg	Classic Diamond Trucker 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]	FA17	[empty string]	[empty string]	[empty string]	8	20-to-25	0.00	[empty string]	Dakine Classic Diamond Adjustable Trucker Hat	<p>This Dakine Classic Diamond trucker features a structured 5-panel, snapback construction with printed front panels and brim.</p>	[empty string]	N	22	22	[empty string]	25866-DEFAULT-s.jpg	7	1000	10000547-H	356537	EMPTY	EMPTY	EMPTY	0	0	0	HATS	dakine/dakine-classic-diamond-adjustable-trucker-hat-356537	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]