Stance

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	Vintage Purple	NEFF	NEFF	MENS	MENS &GT; TOPS &GT; T-SHIRTS	31.99	0	31.99	26880-DEFAULT-l.jpg	31	26880-DEFAULT-m.jpg	Pigment Peek Ss Pocket 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]	10	25-to-50	0.00	[empty string]	Neff Pigment Peek Pocket T-Shirt	<p>With various graphics popping out the front pocket, the Pigment Peek Pocket Tee has peeking perks that won't pick your pocket! Comes in vibrant colors great for summer.</p> <p>- Regular fit<br /> - Crew neckline<br /> - Left chest pocket<br /> - Printed inside label<br /> - 100% Cotton</p>	[empty string]	N	32	32	Small,Large,X-Large,XX-Large	26880-DEFAULT-s.jpg	2	1000	19P29009	384376	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	neff/neff-pigment-peek-pocket-tshirt-384376	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; HATS	21.99	0	21.99	26387-DEFAULT-l.jpg	21	26387-DEFAULT-m.jpg	Usa Eagle Patch Trucker Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	[empty string]	27	20-to-25	0.00	[empty string]	Never Summer USA Eagle Patch Trucker Hat	<p>Never Summer USA Eagle Patch Trucker Hat</p>	<p>Never Summer Snow Trucker Hat</p>	N	22	22	[empty string]	26387-DEFAULT-s.jpg	3	1000	HTUSAADJ	345711	HATS	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-usa-eagle-patch-trucker-hat-345711	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Purple/Lilac/Black	NEFF	NEFF	MENS	MENS &GT; TOPS &GT; T-SHIRTS	33.99	0	33.99	26881-DEFAULT-l.jpg	33	26881-DEFAULT-m.jpg	Aloha Girl Ss Wash 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]	20	25-to-50	0.00	[empty string]	Neff Aloha Wash Short Sleeve T-Shirt	<p>Aloha! Say Hello to the Hula with the Aloha Girl Wash Tee by Neff. Throw on that Hula skirt and get movin'!</p> <p>- Comfortable crew neckline<br /> - Allover wash<br /> - Regular fit<br /> - Screen printed back of Hula Girl under the moon <br /> - 100% Cotton</p>	[empty string]	N	34	34	Small,Medium,Large,X-Large,XX-Large	26881-DEFAULT-s.jpg	3	1000	19P29001	384377	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	neff/neff-aloha-wash-short-sleeve-tshirt-384377	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	VON ZIPPER	VON ZIPPER	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	159.99	0	159.99	25980-DEFAULT-l.jpg	159	25980-DEFAULT-m.jpg	Suplex Trt/Wl Brz 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]	3	150-to-200	0.00	[empty string]	VonZipper Suplex Sunglasses, Tortoise Gloss/Wildlife Bronze Polarized	<p><strong>Story: </strong>It starts out with a warm embrace from behind, but then, the real action begins. The next thing you know you're dazed and confused wondering what just happened. Pin it to win it in the Suplex.</p> <p><strong>Specs: </strong>VonZipper Suplex polarized sunglasses are handmade in Italy; the frame is crafted from nylon grilamid for maximum flexibility and held together with corrosion free Pop N' Lock cam hinges. The base 8 spherical impact resistant polycarbonate polarized lenses will protect your eyes with 100% UV protection.</p> <p><strong>RGNS System: </strong>Here’s where the rubber hits the road. If you wanna RIP, have lots of GRIP, with NO SLIP, our RGNS system features rubber nose pads and temple tips.</p>	[empty string]	N	160	160	[empty string]	25980-DEFAULT-s.jpg	4	1000	SMPFTSUP-PTB	345444	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	von-zipper/vonzipper-suplex-sunglasses-tortoise-gloss-wildlife-bronze-polarized-345444	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	MENS	MENS &GT; SHOES &GT; SKATE SHOES	69.99	0	69.99	26791-DEFAULT-l.jpg	69	26791-DEFAULT-m.jpg	Comfycush Old Skool Black/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]	BLK/WHT	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	70	50-to-100	0.00	[empty string]	Vans ComfyCush Old Skool Skate Shoe	<p>Vans has reinvigorated the classic Old Skool by introducing ComfyCush: a new softer, cushiony outsole that gives the ComfyCush Old Skool a first-class fit that feels like walking on a cloud. Newly constructed canvas and suede uppers house simplified one-piece interiors with added arch support and new moisture-wicking lining throughout, resulting in a lightweight experience that assures you’ll Keep It Comfy at all times.</p>	[empty string]	N	70	70	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	26791-DEFAULT-s.jpg	6	1000	VN0A3WMAVNE	383081	SKATE SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-comfycush-old-skool-skate-shoe-383081	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	34.99	0	34.99	26035-DEFAULT-l.jpg	34	26035-DEFAULT-m.jpg	Poseur 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]	OH at 200	[empty string]	30	25-to-50	0.00	[empty string]	Dot Dash Poseur Sunglasses, Black Satin/Grey	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <p><strong>Vintage Collection</strong> ~ Playfully intelligent reflections of the past.</p> <h5>Specs</h5> <ul> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Pin Hinge</li> </ul> </form>	[empty string]	N	35	35	[empty string]	26035-DEFAULT-s.jpg	7	1000	DSVTNPOS-BPP	283406	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	dot-dash/dot-dash-poseur-sunglasses-black-satin-grey-283406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

NEFF Neff Pigment Peek Pocket T- Shirt $32.00 | view details

NEVER SUMMER Never Summer Usa Eagle Patch Trucker Hat $22.00 | view details

NEFF Neff Aloha Wash Short Sleeve T- Shirt $34.00 | view details

VON ZIPPER Vonzipper Suplex Sunglasses, Tortoise Gloss/Wildlife Bronze Polarized $160.00 | view details

VANS Vans Comfycush Old Skool Skate Shoe $70.00 | view details

DOT DASH Dot Dash Poseur Sunglasses, Black Satin/Grey $35.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	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]	146	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	50	1000	20-48053	377109	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-sunset-cove-377109	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
2	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	5.99	0	5.99	25580-DEFAULT-l.jpg	5	25580-DEFAULT-m.jpg	Pinkini Tinted Spf 15 Lip Balm	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	238	5-and-under	0.00	[empty string]	Sun Bum SPF 15 Tinted Lip Balm, Pinktini	<p>We’re not really into cosmetics but a lot of our girls wanted a little color with their lip protection so we created a collection using subtle and natural tones for them.</p> <p>Quick tip...careful when you twist up the lip balm.  We made 'em super moisturizing which is great for your lips but not as great for being able to twist it back down.</p>	[empty string]	Y	5.99	5.99	[empty string]	25580-DEFAULT-s.jpg	408	1000	20-48055	377111	EMPTY	EMPTY	EMPTY	1	5.99	3.99	EMPTY	sun-bum/sun-bum-spf-15-tinted-lip-balm-pinktini-377111	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1
3	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	3.99	0	3.99	25582-DEFAULT-l.jpg	3	25582-DEFAULT-m.jpg	Groove Berry Coco Lip Balm - Non Spf	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	139	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	455	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]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNSCREEN AND SKINCARE	15.99	0	15.99	13952-DEFAULT-l.jpg	15	13952-DEFAULT-m.jpg	Spf 30 Spray Sunscreen	N	[empty string]	[empty string]	[empty string]	[empty string]	200	ALWAYS IN	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	0	15-to-20	0.00	[empty string]	Sun Bum SPF 30 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]	13952-DEFAULT-s.jpg	2	1000	20-42030	271637	SUNSCREEN AND SKINCARE	EMPTY	EMPTY	0	0	0	EMPTY	sun-bum/sun-bum-spf-30-spray-sunscreen-6-oz-271637	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	168.99	0	168.99	27182-DEFAULT-l.jpg	168	27182-DEFAULT-m.jpg	Isabela Tort/Grey 580p	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Costa Del Mar Isabela Sunglasses, Tortoise/Gray Polarized 580P	<h4>580P</h4> <h5>POLYCARBONATE (+TRIVEX IN RX)</h5> <p>LIGHTWEIGHT, IMPACT-RESISTANT</p> <ul> <li>POLYCARBONATE & TRIVEX ARE YOUR LIGHTEST AND MOST DURABLE LENS MATERIAL OPTIONS</li> <li>C-WALL® IS A MOLECULAR BOND WHICH IS SCRATCH-RESISTANT</li> </ul> <ul> <li>FRAME SPECIFICATIONS:</li> <li>1. Frame Width: 127mm</li> <li>2. Bridge Width: 17.2mm</li> <li>3. Lens Width: 63.2mm</li> <li>4. Lens Height: 39.5mm</li> <li>5. Temple Arm Length: 124mm</li> </ul>	[empty string]	N	169	169	[empty string]	27182-DEFAULT-s.jpg	2	1000	IB 10 OGP	371190	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	costa-del-mar/costa-del-mar-isabela-sunglasses-tortoise-gray-polarized-580p-371190	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2
6	[empty string]	VON ZIPPER	VON ZIPPER	WOMENS	WOMENS &GT; ACCESSORIES &GT; SUNGLASSES	159.99	0	159.99	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	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	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]	2

CACHED

false

EXECUTIONTIME

SQL

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

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

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

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

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

COSTA DEL MAR Costa Del Mar Isabela Sunglasses, Tortoise/Gray Polarized 580p $169.00 | view details

VON ZIPPER Vonzipper Palooka Sunglasses, Tortoise Satin/Wildlife Vintage Grey Polarized $160.00 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Smoke	RVCA	RVCA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; SHORTS	39.99	0	39.99	26899-DEFAULT-l.jpg	39	26899-DEFAULT-m.jpg	Boys Weekday Stretch Chino Short	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	RVCA Weekday Boy's Stretch Shorts	<p>The boy's rvca weekday stretch short delivers clean, school day lines, matched with off-hours stretch. Bringing together unbound function and timeless design, the boys stretch short features slash pocketing at the front and welt pockets at the back.</p>	[empty string]	N	40	40	23,24,25,26,27,28	26899-DEFAULT-s.jpg	2	1000	B240TRWD	383251	EMPTY	SHORTS	EMPTY	0	0	0	EMPTY	rvca/rvca-weekday-boys-stretch-shorts-383251	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	7.99	0	7.99	25946-DEFAULT-l.jpg	7	25946-DEFAULT-m.jpg	Neoprene Classic Black Retainer	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 Neoprene Sunglasses Retainer	<p>Neoprene Classic. Neoprene retainers have long been the best option in the business. Costa neoprenes slide onto frame arms and grip tight. And their wide design makes them comfortable when glasses are on, or hanging around your neck.  <strong>End-to-End Measurement: </strong>16"</p>	[empty string]	N	7.99	7.99	[empty string]	25946-DEFAULT-s.jpg	11	1000	CR11	364623	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-neoprene-sunglasses-retainer-364623	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Multi	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26807-DEFAULT-l.jpg	59	26807-DEFAULT-m.jpg	Sun Dream Tali Set	N	GIRLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	Billabong Girls' Sun Dream Tali Bikini Set	<p>Pick a bikini in full bloom or mix and clash with this reversible bikini set. The girls bikini features a top that reverses from striped to floral print, and a matching floral print bikini bottom. Both top and bottom are rimmed with strappy details for a modern look.</p>	[empty string]	N	59.95	59.95	5,7,8,10,12,14	26807-DEFAULT-s.jpg	12	1000	Y213TBSU	387572	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-girls-sun-dream-tali-bikini-set-387572	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	64.99	0	64.99	25697-DEFAULT-l.jpg	64	25697-DEFAULT-m.jpg	Old Skool 92 Pro Black/White/Red	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	BLK/WHT	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	176	50-to-100	0.00	[empty string]	Vans Old Skool Pro Skate Shoe, Black/White	<p>The Old Skool Pro, a Vans classic upgraded for enhanced performance, features sturdy canvas and suede uppers, single-wrap foxing tape, UltraCush HD sockliners to keep the foot close to the board while providing the highest level of impact cushioning, and Vans original waffle outsoles made of a rubber that offers grip and support. The Old Skool Pro also includes DURACAP reinforcement rubber underlays in high wear areas for unrivaled durability.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	65	65	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13	25697-DEFAULT-s.jpg	30	1000	VN000ZD4Y28	316186	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-old-skool-pro-skate-shoe-black-white-316186	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Rock	BILLABONG	BILLABONG	KIDS	KIDS &GT; BOYS &GT; TOPS &GT; T-SHIRTS	17.99	0	17.99	26957-DEFAULT-l.jpg	17	26957-DEFAULT-m.jpg	Boys Spinner Ss Pocket Tee	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	COTTON	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	14	15-to-20	0.00	[empty string]	Billabong Spinner Boy's Short Sleeve T-Shirt	<p>Re-spin a classic striped tee with a dose of printed lines and a minimalist Billabong logo. Designed with a classic fit, the boys short sleeve pocket tee features a stripe print across the chest and small wave logo print at the pocket. Made from 100% cotton, the boys pocket tee is finished with a printed label for tag-free comfort.</p> <p>The nuts and bolts</p> <ul> <li> <p>Boys pocket t-shirt.</p> </li> <li>Stripe print across chest and small wave logo above chest pocket.</li> <li>Crew neck.</li> <li>Short sleeves.</li> <li>Side seam flag label.</li> <li>Printed neck label.</li> <li>Material: 26/1, 160g jersey. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	17.95	17.95	Small,Medium,Large	26957-DEFAULT-s.jpg	57	1000	B433TBSP	382406	TOPS	T-SHIRTS	EMPTY	0	0	0	EMPTY	billabong/billabong-spinner-boys-short-sleeve-tshirt-382406	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Golden Glow	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; SWIM	59.99	0	59.99	26810-DEFAULT-l.jpg	59	26810-DEFAULT-m.jpg	Sun Dream Tank Set	N	GIRLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	Billabong Sun Dream Tank Set	<p>Billabong Sun Dream Tank Set</p>	[empty string]	N	59.95	59.95	7,8,10,12,14	26810-DEFAULT-s.jpg	79	1000	Y219TBSU	387578	SWIM	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-sun-dream-tank-set-387578	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

RVCA Rvca Weekday Boy's Stretch Shorts $40.00 | view details

COSTA DEL MAR Costa Del Mar Neoprene Sunglasses Retainer $7.99 | view details

BILLABONG Billabong Girls ' Sun Dream Tali Bikini Set $59.95 | view details

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

BILLABONG Billabong Spinner Boy's Short Sleeve T- Shirt $17.95 | view details

BILLABONG Billabong Sun Dream Tank Set $59.95 | 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	Multi	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; KIDS SOCKS	9.99	0	9.99	25786-DEFAULT-l.jpg	9	25786-DEFAULT-m.jpg	Boy's Desert Dinos Sock	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Stance Desert Dinos Boys Kids Crew Sock	<p>Every boy loves dinosaurs. Inspire their inner paleontologist with Stance's Desert Dinos Boys.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	10	10	Large	25786-DEFAULT-s.jpg	3	1000	B526D18DES	380115	KIDS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-desert-dinos-boys-kids-crew-sock-380115	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Navy/Black	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	69.99	0	69.99	26892-DEFAULT-l.jpg	69	26892-DEFAULT-m.jpg	Punua Womens Sandals	N	WOMENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	34	50-to-100	0.00	[empty string]	Olukai Punua Women's Sandal	<p>In Hawaiian, punua means “young bird” and “fledgling.” The sporty, water-resistant and ultra-comfortable Punua features three colors on its outsole, inspired by tide pools. With a lower profile for a modern and clean look and feel, we encourage you to put on this sandal and get busy doing the outdoor activities you love the most.</p> <p>FEATURES<br /> Custom printed lining logo and molded strap logo</p>	[empty string]	N	70	70	5,6,7,8,9,10,11	26892-DEFAULT-s.jpg	10	1000	20377	382210	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	olukai/olukai-punua-womens-sandal-382210	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	CHAR/PEW,Sahara/Bubbly,Black/Silver	OLUKAI	OLUKAI	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; WOMEN'S SANDALS	84.99	0	84.99	26891-DEFAULT-l.jpg	84	26891-DEFAULT-m.jpg	Kaekae Womens Sandals	N	WOMENS	IMPORTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	64	50-to-100	0.00	[empty string]	Olukai Kaekae Women's Sandal	<p>When you can go from the mountains to the beach to an urban metropolis in the same day, it’s clear that diversity reigns supreme on O‘ahu. With this in mind, we crafted the simple and sophisticated Kaekae, a gorgeous combo of rich, full-grain and shiny, metallic leathers.</p> <p>FEATURES<br /> Embossed upper logos and laser details on the footbed.???????</p> <h1> </h1> <p> </p>	[empty string]	N	85	85	5,6,7,8,9,10,11	26891-DEFAULT-s.jpg	18	1000	20374	382207	WOMENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	olukai/olukai-kaekae-womens-sandal-382207	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	69.99	0	69.99	26623-DEFAULT-l.jpg	69	26623-DEFAULT-m.jpg	Gs Chukka Taupe Shaved Suede/Canvas	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]	SPRING	[empty string]	[empty string]	[empty string]	22	50-to-100	0.00	[empty string]	Globe GS Chukka Skate Shoe, Taupe	<p>Mid-top progression of the GS shoe</p> <p>+ Shockbed™ insole</p> <p>+ Globe's Super-V outsole</p> <p>+ Curved collar</p> <p>+ Shaved suede / Canvas</p>	[empty string]	N	70	70	8.5,9,9.5,10,10.5,11,11.5,12,13	26623-DEFAULT-s.jpg	20	1000	GBGSCHUKKA-19524	383558	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	globe/globe-gs-chukka-skate-shoe-taupe-383558	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	64.99	0	64.99	27133-DEFAULT-l.jpg	64	27133-DEFAULT-m.jpg	Old Skool (Chambray) True Navy/True Wht	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]	71	50-to-100	0.00	[empty string]	Vans Chambray Old Skool Skate Shoe, True Canvas Navy/True White	<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	65	65	4.5,5.5,6,7,8,8.5,9,9.5,10,10.5,11,11.5,12,13	27133-DEFAULT-s.jpg	21	1000	VN0A38G1VIO	383093	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-chambray-old-skool-skate-shoe-true-canvas-navy-true-white-383093	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Teal	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25812-DEFAULT-l.jpg	13	25812-DEFAULT-m.jpg	Women's Sir Harold Sock	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	16	10-to-15	0.00	[empty string]	Stance Sir Harold Women's Tomboy Light Crew Sock	<p>Our Sir Harold gives you all the style, comfort and companionship you need. With its unique design and hedgehog graphic you'll never take another step alone with Sir Harold.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Cushioning</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Small,Medium	25812-DEFAULT-s.jpg	22	1000	W525D18SIR	380518	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-sir-harold-womens-tomboy-light-crew-sock-380518	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

STANCE Stance Desert Dinos Boys Kids Crew Sock $10.00 | view details

OLUKAI Olukai Punua Women's Sandal $70.00 | view details

OLUKAI Olukai Kaekae Women's Sandal $85.00 | view details

GLOBE Globe Gs Chukka Skate Shoe, Taupe $70.00 | view details

VANS Vans Chambray Old Skool Skate Shoe, True Canvas Navy/True White $65.00 | view details

STANCE Stance Sir Harold Women's Tomboy Light Crew Sock $14.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]	SHAKE JUNT	SHAKE JUNT	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	12.99	0	12.99	26920-DEFAULT-l.jpg	12	26920-DEFAULT-m.jpg	Zion Wright Pro Griptape	N	[empty string]	[empty string]	[empty string]	[empty string]	6	[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]	21	10-to-15	0.00	[empty string]	Shake Junt Zion Wright Pro Griptape	<p>Zion Wright Pro Model Grip</p>	[empty string]	N	13	13	[empty string]	26920-DEFAULT-s.jpg	4	1000	02-06-0146	391218	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	shake-junt/shake-junt-zion-wright-pro-griptape-391218	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	198.99	0	198.99	26314-DEFAULT-l.jpg	198	26314-DEFAULT-m.jpg	Battle Axe 40 Chill Bird 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]	5	150-to-200	0.00	[empty string]	Landyachtz Battle Axe 40 Chill Bird Complete Longboard, 40"	<p style="margin-left:0px; margin-right:0px; text-align:left">Despite the aggressive name, this board can be pretty dang chill. For those who want to casually cruise around town, <em>and</em> 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> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 40.25” I W: 9” I WB: 29.5” </p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong><strong>Artist:</strong> </strong>llllr</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck Material:</strong> 7 Ply Canadian Maple, 1 Bamboo middle ply<br /> <strong>Concave:</strong> Low<br /> <strong>Flex:</strong> Medium<br /> <strong>Profile:</strong> Rocker<br /> <strong>Grip:</strong> Black Adhesive with Vertical Die Cut and Printed Logo<br /> <strong>Features:</strong> 100% Canadian Maple, bamboo Core,  Drop Thru Mounting, Rocker, Low Concave, Clear Spray on Grip<br /> <strong>Setup:</strong> Bear Grizzly GR852, 70mm Hawgs Clear Red 78a, Bear Spaceball Bearings</p>	[empty string]	N	199	199	40IN	26314-DEFAULT-s.jpg	6	1000	CP-FRBA40	369743	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	landyachtz/landyachtz-battle-axe-40-chill-bird-complete-longboard-40-369743	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	234.99	0	234.99	26313-DEFAULT-l.jpg	234	26313-DEFAULT-m.jpg	Switch 35 Tiger 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]	1	200-to-250	0.00	[empty string]	Landyachtz Switch 35 Tiger Complete Longboard, 35"	<p style="margin-left:0px; margin-right:0px; text-align:left">There is nothing like the feeling of a stable board under your feet. It’s pretty amazing how much fun you can have when your gear is up to the task. The Switch has been in our line for nearly 10 years for just that reason. We’ve always said that the Switch is a board that teaches you the basics but also allows you to progress your skating. It’s a staple for anyone looking to test the waters of freeriding, but it won't hold you back either. Available in 2 sizes.</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist</strong>: Andreas Preis</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 35” I W: 9.5” I WB: 27”</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck Material:</strong> 9 Ply Canadian Maple<br /> <strong>Concave:</strong> Deep<br /> <strong>Flex:</strong> Low<br /> <strong>Profile:</strong> Drop Down<br /> <strong>Features:</strong> Drop Down, Symmetrical, Deep Concave, 100% Canadian Maple<br /> <strong>Setup:</strong> Bear Grizzly GR852, 70mm Hawgs Brown/White Stoneground, Bear Spaceball Bearings</p>	[empty string]	N	235	235	35IN	26313-DEFAULT-s.jpg	20	1000	CP-DHSW35	369742	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switch-35-tiger-complete-longboard-35-369742	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	244.99	0	244.99	27049-DEFAULT-l.jpg	244	27049-DEFAULT-m.jpg	Switchblade 40 Faded 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	200-to-250	0.00	[empty string]	Landyachtz Switchblade 40 Faded Complete Longboard, 40"	<p> </p> <p>Designed to rally big mountain terrain and conquer World Cup podiums, the Switchblade has proven itself equally adept at getting you to the grocery store and ripping down your local hill safely. The mellow drops, long wheelbase and low ride height combine to offer a drifty, confidence-inspiring feel perfect for riders looking to up their freeride game. </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>Drop Thru</li> <li>Made In Canada</li> <li>Symmetrical</li> </ul>	[empty string]	N	245	245	40IN	27049-DEFAULT-s.jpg	31	1000	119-DHSB40FD	386934	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switchblade-40-faded-complete-longboard-40-386934	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	SKATEBOARDS	SKATEBOARDS &GT; COMPLETE SKATEBOARDS	129.99	0	129.99	26425-DEFAULT-l.jpg	129	26425-DEFAULT-m.jpg	Nickel Ripple 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]	1	100-to-150	0.00	[empty string]	Penny Skateboards Ripple Complete Nickel Skateboard, 27"	<p>Continuing Penny's history of partnering with like-minded artists, brands, and creators, we are excited to collaborate with Oceanside, California surfer/artist Mitchell King. Mitch's art uses a color palette heavily inspired by the natural world and incorporates repetition of shape, giving the illusion of visual movement. The 27" Ripple features Mitch's signature circular pattern with blues, tans, and burnt orange in a striking centered graphic. Blue/Raw trucks and grey wheels complete this work of art.</p> <ul> <li>27" Plastic Deck</li> <li>4-inch aluminum trucks with powder-coated finish</li> <li>59mm, 83A wheels for a smooth ride</li> <li>83A color-coded cushions</li> <li>Color-coded high tensile deck bolts</li> <li>Quality Color-coded Abec 7 stainless steel bearings</li> </ul>	[empty string]	N	129.99	129.99	27IN	26425-DEFAULT-s.jpg	34	1000	PNYCOMP27430	374204	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	penny/penny-skateboards-ripple-complete-nickel-skateboard-27-374204	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	179.99	0	179.99	26319-DEFAULT-l.jpg	179	26319-DEFAULT-m.jpg	Bamboo Chief Eyes 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]	1	150-to-200	0.00	[empty string]	Landyachtz Bamboo Chief Eyes Complete Longboard, 36"	<p style="margin-left:0px; margin-right:0px; text-align:left">There’s something about cruising on a traditional pintail that just rubs me the right way. The Chief has a unique, Bamboo/Maple construction and rockered shape that makes it incredibly fun to ride. Skate like no one’s watching. But please don’t do anything illegal or stupid because now-a-days, someone’s always watching, you know, Big Brother...</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist:</strong> Giga Kobidze</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 36” I W: 8.75” I WB: 26.5”</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Deck Material:</strong> Canadian Maple / Bamboo<br /> <strong>Concave:</strong> Low<br /> <strong>Flex:</strong> Medium<br /> <strong>Profile:</strong> Rocker<br /> <strong>Features:</strong> Wheel wells, Rocker, Bamboo, Spray on Clear Grip, Low Concave<br /> <strong>Setup:</strong> Bear Grizzly GR852, 63mm Fatty Hawgs Orange/Yellow Swirl 78a, 1/8” Soft Riser, Bear Spaceball Bearings</p>	[empty string]	N	179.99	179.99	36IN	26319-DEFAULT-s.jpg	54	1000	CP-FRBCHF	378818	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-bamboo-chief-eyes-complete-longboard-36-378818	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SHAKE JUNT Shake Junt Zion Wright Pro Griptape $13.00 | view details

LANDYACHTZ Landyachtz Battle Axe 40 Chill Bird Complete Longboard, 40 " $199.00 | view details

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

LANDYACHTZ Landyachtz Switchblade 40 Faded Complete Longboard, 40 " $245.00 | view details

PENNY Penny Skateboards Ripple Complete Nickel Skateboard, 27 " $129.99 | view details

LANDYACHTZ Landyachtz Bamboo Chief Eyes Complete Longboard, 36 " $179.99 | view details

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	5.99	0	5.99	6184-DEFAULT-l.jpg	5	6184-DEFAULT-m.jpg	Stainless Steel Fin Screws 12pk Only	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	23	5-to-10	0.00	[empty string]	FCS Stainless Steel Fin Screws - 12 Pack	<p>12 pack of stainless steel grub screws for FCS fin boxes.</p>	<p>FCS Fin Screws - 12 Pack</p>	N	5.98	5.98	[empty string]	6184-DEFAULT-s.jpg	7	1000	10112	211568	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-stainless-steel-fin-screws-12-pack-211568	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	GOPRO	GoPro	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	19.99	0	19.99	19776-DEFAULT-l.jpg	19	19776-DEFAULT-m.jpg	Surf Mounts	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]	8	15-to-20	0.00	[empty string]	GoPro Surf Mounts	<p>Mount your GoPro to surfboards, kayaks, SUPs, boat decks and other gear where maximum holding strength is needed. Includes an FCS compatible male plug to mount your GoPro using an FCS center fin socket.</p> <ul> <li>Perfect for surfboards, kayaks, SUPs, boat decks and more</li> <li>Ideal for activities where maximum holding strength is needed</li> <li>Includes FCS compatible plug for mounting to FCS center fin socket</li> <li>Includes adhesive anchors and camera tethers for enhanced security<br />  </li> </ul>	[empty string]	N	19.99	19.99	[empty string]	19776-DEFAULT-s.jpg	14	1000	ASURF-001	279381	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	gopro/gopro-surf-mounts-279381	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	59.99	0	59.99	20226-DEFAULT-l.jpg	59	20226-DEFAULT-m.jpg	Poncho Gry Chamois Changing Towel	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	FCS Chamois Poncho	<p>Make changing in public places cozy and easy. Quick dry material.</p>	[empty string]	N	60	60	One Size	20226-DEFAULT-s.jpg	34	1000	11027	281042	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-chamois-poncho-281042	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ZINKA	ZINKA	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	2.99	0	2.99	2772-DEFAULT-l.jpg	2	2772-DEFAULT-m.jpg	Lip Balm Spf 30	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]	[empty string]	[empty string]	13	5-and-under	0.00	[empty string]	Zinka SPF 30 Lip Balm, Clear	<p>Smooth and moisturizing our formula is enhanced with Aloe Vera and keeps your lips soft and safe from the sun.</p> <h3>Ingredients</h3> <p><strong>Active Ingredients</strong></p> <p>Octinoxate (7.50%)<br /> Octocrylene (10.0%)<br /> Octisalate (5.0%)<br /> Oxbenzone (5.0%)</p> <p><strong>Other Ingredients</strong><strong>:</strong></p> <p>Ozokerite, Mineral Oil, Petrolatum, Microcrystalline Wax,  Ceresin, Flavor, Caprylic/Capric Triglyceride, Copernicia Cerifera (Carnauba) Wax, Titanium Dioxide (CI77891), Tocopheryl Acetate, Stearic Acid, Aloe Barbadensis Leaf Extract, Aluminum Hydroxide</p>	[empty string]	N	2.99	2.99	[empty string]	2772-DEFAULT-s.jpg	37	1000	BALM	200870	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	zinka/zinka-spf-30-lip-balm-clear-200870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Grey	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES	20.99	0	20.99	4597-DEFAULT-l.jpg	20	4597-DEFAULT-m.jpg	Wet Bucket Surf Hat	N	MENS	[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]	OH at 200	[empty string]	9	20-to-25	0.00	[empty string]	FCS Wet Bucket Amphibious Surf Hat	<p>Designed to stay secure in the surf and provide protection against sun and elements.</p>	[empty string]	N	20.98	20.98	Small,Large,X-Large,Large/X-Large	4597-DEFAULT-s.jpg	60	1000	2924	219541	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-wet-bucket-amphibious-surf-hat-219541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Medieval Blue	QUIKSILVER	QUIKSILVER	SURF SHOP	SURF SHOP &GT; LYCRA &GT; SHORT SLEEVE LYCRA &GT; MEN'S	29.99	0	29.99	26668-DEFAULT-l.jpg	29	26668-DEFAULT-m.jpg	Always There Ss Rashguard	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]	6	25-to-50	0.00	[empty string]	Quiksilver Always There Short Sleeve UPF 50 Rashguard	<ul> <li><strong>Recycled Fabric:</strong> Stretch polyester blend fabric</li> <li><strong>Fit:</strong> Snug fit</li> <li>UPF 50+ sun protection</li> <li>Chlorine-resistant properties</li> <li>Moisture-wicking properties</li> </ul> <p>Composition</p> <ul> <li> <p>92% Polyester, 8% Elastane</p> </li> </ul>	[empty string]	N	30	30	Small,Medium,Large,X-Large,XX-Large	26668-DEFAULT-s.jpg	75	1000	EQYWR03142	391054	SHORT SLEEVE LYCRA	MENS	EMPTY	0	0	0	LYCRA	quiksilver/quiksilver-always-there-short-sleeve-upf-50-rashguard-391054	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Stainless Steel Fin Screws - 12 Pack $5.98 | view details

GoPro Gopro Surf Mounts $19.99 | view details

FCS Fcs Chamois Poncho $60.00 | view details

ZINKA Zinka Spf 30 Lip Balm, Clear $2.99 | view details

FCS Fcs Wet Bucket Amphibious Surf Hat $20.98 | view details

QUIKSILVER Quiksilver Always There Short Sleeve Upf 50 Rashguard $30.00 | view details

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	469.99	0	469.99	26373-DEFAULT-l.jpg	469	26373-DEFAULT-m.jpg	Onyx	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	4	450-to-500	0.00	[empty string]	Never Summer Onyx Women's Snowboard, 2018	<p>Never Summer Onyx Women's Snowboard, 2018</p>	[empty string]	N	469.99	469.99	140,143,149	26373-DEFAULT-s.jpg	13	1000	ONYX-H	358744	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-onyx-womens-snowboard-2018-358744	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Black,Grey	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	27.99	0	27.99	25642-DEFAULT-l.jpg	27	25642-DEFAULT-m.jpg	Retro Mountain Snapback 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]	2019	[empty string]	[empty string]	[empty string]	25	25-to-50	0.00	[empty string]	Never Summer Retro Mountain Snapback Hat	<p>Never Summer Retro Mountain Snapback Hat</p>	[empty string]	N	28	28	One Size	25642-DEFAULT-s.jpg	13	1000	HTRETROADJ	374869	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-retro-mountain-snapback-hat-374869	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Chub	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	25541-DEFAULT-l.jpg	19	25541-DEFAULT-m.jpg	Chub 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]	SMU	SU17	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Chub	<h6><em>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</em></h6>	[empty string]	N	19.99	19.99	[empty string]	25541-DEFAULT-s.jpg	13	1000	FSH-SL-CHUB	382012	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-chub-382012	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Amethyst	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	59.99	0	59.99	25857-DEFAULT-l.jpg	59	25857-DEFAULT-m.jpg	Boot Locker 69l	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	50-to-100	0.00	[empty string]	Dakine Boot Locker 69L, Snowboard and Ski Boot Bag	<p>There is no simpler solution to keeping your whole winter kit together and ready to go. The Boot Locker offers tons of volume up top for jackets, extra layers, spare gloves and a helmet, while the tarp-lined bottom compartment is great at keeping your boots warm and dry on the way up the mountain and separate from everything else on the way down.</p>	[empty string]	N	60	60	[empty string]	25857-DEFAULT-s.jpg	18	1000	08300480-I	373447	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-boot-locker-69l-snowboard-and-ski-boot-bag-373447	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Green	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	7.99	0	7.99	25840-DEFAULT-l.jpg	7	25840-DEFAULT-m.jpg	Triangle Scraper	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]	2018	[empty string]	[empty string]	[empty string]	14	5-to-10	0.00	[empty string]	Dakine Triangle Scraper	<p>The Triangle Scraper gives you more options in sharpened edges, pointed corners, and angles to hold and apply pressure from. There's a notched corner that's perfect for skimming leftover wax off the edges of your ski or snowboard, and a hole punched in another corner that lets you rig the scraper up to a keyring or lanyard. Sling it over a nail in the garage, your rearview mirror, or around your neck if really want to keep it close at hand.</p>	[empty string]	N	8	8	[empty string]	25840-DEFAULT-s.jpg	26	1000	10001585	357731	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-triangle-scraper-357731	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	26372-DEFAULT-l.jpg	289	26372-DEFAULT-m.jpg	Bantam	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	3	250-to-300	0.00	[empty string]	Never Summer Bantam Kids Snowboard, 2018	<p>Never Summer Bantam Kids Snowboard, 2018</p>	[empty string]	N	289.99	289.99	136,142	26372-DEFAULT-s.jpg	45	1000	BANTAM-H	358731	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-bantam-kids-snowboard-2018-358731	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Onyx Women's Snowboard, 2018 $469.99 | view details

NEVER SUMMER Never Summer Retro Mountain Snapback Hat $28.00 | view details

FISHMASKS Fishmasks Single Layer Neck Gaiter, Chub $19.99 | view details

DAKINE Dakine Boot Locker 69l, Snowboard And Ski Boot Bag $60.00 | view details

DAKINE Dakine Triangle Scraper $8.00 | view details

NEVER SUMMER Never Summer Bantam Kids Snowboard, 2018 $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	[empty string]	PENNY	PENNY	ACCESSORIES	ACCESSORIES &GT; HATS	19.99	0	19.99	26413-DEFAULT-l.jpg	19	26413-DEFAULT-m.jpg	Org/Grn 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]	21	15-to-20	0.00	[empty string]	Penny Skateboards Snapback Hat, Orange/Green	<p>Penny Skateboards Snapback Hat, Orange/Green</p>	[empty string]	N	19.99	19.99	One Size	26413-DEFAULT-s.jpg	1	1000	PNYH0005	338627	EMPTY	EMPTY	EMPTY	0	0	0	HATS	penny/penny-skateboards-snapback-hat-orange-green-338627	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Denim	RVCA	RVCA	ACCESSORIES	ACCESSORIES &GT; HATS	25.99	0	25.99	25643-DEFAULT-l.jpg	25	25643-DEFAULT-m.jpg	Va All The Way 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]	SMU	FA18	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	RVCA VA All The Way Trucker Hat	<p>For RVCA, it's about today, tomorrow and life as the big picture. It is about inspiring our generation, providing something of substance and culture and above all doing it with integrity and as a united family, a close knit community.</p> <ul> </ul>	[empty string]	N	26	26	One Size	25643-DEFAULT-s.jpg	2	1000	MAHWPRVO	373625	EMPTY	EMPTY	EMPTY	0	0	0	HATS	rvca/rvca-va-all-the-way-trucker-hat-373625	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Water Camo Amethyst	FISHMASKS	FISHMASKS	ACCESSORIES	ACCESSORIES &GT; FACEMASKS	19.99	0	19.99	25551-DEFAULT-l.jpg	19	25551-DEFAULT-m.jpg	Water Camo Amethyst Single Layer	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]	SMU	SU17	[empty string]	[empty string]	[empty string]	24	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Water Camo Amethyst	<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]	25551-DEFAULT-s.jpg	2	1000	F1129	382029	EMPTY	EMPTY	EMPTY	0	0	0	FACEMASKS	fishmasks/fishmasks-single-layer-neck-gaiter-water-camo-amethyst-382029	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	COSTA DEL MAR	COSTA DEL MAR	ACCESSORIES	ACCESSORIES &GT; HATS	24.99	0	24.99	25961-DEFAULT-l.jpg	24	25961-DEFAULT-m.jpg	Neoprene Costa Text Hat Gray	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]	19	20-to-25	0.00	[empty string]	Costa Del Mar Neoprene Performance Hat, Gray	<ul> <li>Regular Fit</li> <li>100% Performance Polyester</li> <li>Neoprene "COSTA" Applique</li> <li>Embroidered Logo on Left Temple</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	25961-DEFAULT-s.jpg	3	1000	HA 77G	371557	EMPTY	EMPTY	EMPTY	0	0	0	HATS	costa-del-mar/costa-del-mar-neoprene-performance-hat-gray-371557	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Off White	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25801-DEFAULT-l.jpg	13	25801-DEFAULT-m.jpg	Women's Journey To Venus Sock	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	2	10-to-15	0.00	[empty string]	Stance Journey to Venus Women's Classic Crew Sock	<p>Leave the men on Mars as you slide into your next spacewalk with style. Welcome to a world of interplanetary chic with Journey To Venus.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Cushioning</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Small	25801-DEFAULT-s.jpg	5	1000	W525D18JOU	380520	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-journey-to-venus-womens-classic-crew-sock-380520	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ELECTRIC	ELECTRIC	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	99.99	0	99.99	27211-DEFAULT-l.jpg	99	27211-DEFAULT-m.jpg	Knoxville Mat Blk/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]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Electric Knoxville Sunglasses, Matte Black/Grey	<p>Raised right. Born and bred with hard lines, timeless design traits and Italian quality.</p> <ul> <li>Frame: 6 base mold injected grilamid frame with a 3 barrel hinge.</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>Available in anti-reflection, hydrophobic, and oleophobic performance lens coatings.</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: 47h - 139w - 157l</li> <li>Weight: 26 grams</li> </ul>	[empty string]	N	100	100	[empty string]	27211-DEFAULT-s.jpg	6	1000	EE09001020	312469	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	electric/electric-knoxville-sunglasses-matte-black-grey-312469	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]