Adidas

Mens

Boardshorts Pants and Jeans Shorts Boxers/Briefs

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

Gloves Jackets

All Shoes 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	Black/Silver,Brown/Gum,GUB,ALB,Black/Brown,Grey/Black,VBR,Grey/White,KS2,KTO,Grey/Light Blue,LGB,NAY,Tan/Black/Tan	REEF	REEF	MENS	MENS &GT; SANDALS &GT; WATER FRIENDLY SANDALS	54.99	0	54.99	25620-DEFAULT-l.jpg	54	25620-DEFAULT-m.jpg	Fanning Mens Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	H16	[empty string]	OH at 200	[empty string]	1147	50-to-100	0.00	[empty string]	Reef Fanning Men's Sandal	<p>This is the sandal of legendary three-time world champ and perennial pro surfing powerhouse, Mick Fanning the ultimate athletic sandal of comfortable water-friendly synthetic nubuck upper. Mick relies on the contoured injection molded EVA footbed with anatomical arch support and full 360-degree heel airbag enclosed in soft poly for good reason. And in the fun department, it also features a bottle opener built into the footbed to open your “soda” after a surf or hanging at the pool. Reef Icon Herringbone rubber outsole. The sandals of a champion.</p>	[empty string]	N	55	55	6,7,8,9,10,11,12,13,14,15	25620-DEFAULT-s.jpg	2	1000	2026	335585	WATER FRIENDLY SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-fanning-mens-sandal-335585	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	SPY	SPY	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	119.99	0	119.99	26007-DEFAULT-l.jpg	119	26007-DEFAULT-m.jpg	Dirty Mo Soft Matte Blk/Happy 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]	5	100-to-150	0.00	[empty string]	Spy Dirty Mo Sunglasses, Soft Matte Black/Happy Gray Green	<p>The original and iconic Dale Jr.-designed eyewear, the Dirty Mo is for those who know how to race and play to win. This midsized wrap features a chiseled surface, bold details, and the Happy Lens™, the lens that lets in the good and keeps out the bad. Also available with Trident™ polarization.</p> <ul> <li>Available with the color and contrast enhancing Happy Lens™ and Trident™ polarization</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>8-base polycarbonate ARC® lenses for increased optical performance</li> <li>High-quality, long-lasting pin hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 61-17-121</li> </ul>	[empty string]	N	120	120	[empty string]	26007-DEFAULT-s.jpg	3	1000	670937219863	330023	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-dirty-mo-sunglasses-soft-matte-black-happy-gray-green-330023	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Black,Grey	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; HATS	21.99	0	21.99	26394-DEFAULT-l.jpg	21	26394-DEFAULT-m.jpg	Nvr Smr Square 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]	62	20-to-25	0.00	[empty string]	Never Summer NVR SMR Square Patch Trucker Hat	<p>Never Summer NVR SMR Square Patch Trucker Hat</p>	<p>Never Summer Eagle Patch 110 Snapback Hat (Black/Lime)</p>	N	21.99	21.99	[empty string]	26394-DEFAULT-s.jpg	4	1000	HTSQRADJ	345710	HATS	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-nvr-smr-square-patch-trucker-hat-345710	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	19.99	0	19.99	25672-DEFAULT-l.jpg	19	25672-DEFAULT-m.jpg	Showoff Bi- Fold Wallet, Brown	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	15-to-20	0.00	[empty string]	Nixon Showoff Bi-Fold Wallet, Brown	<p>A collection tailored to the worldly and wise, these are the essentials of those who know.</p>	[empty string]	N	20	20	[empty string]	25672-DEFAULT-s.jpg	5	1000	C015-400	324981	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-showoff-bifold-wallet-brown-324981	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SPY	SPY	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	159.99	0	159.99	26006-DEFAULT-l.jpg	159	26006-DEFAULT-m.jpg	Discord Matte Blk/Happy Brz W 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]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	Spy Discord Sunglasses, Matte Black/Happy Bronze Polar with Blue Spectra	<p>As big and bold as the era and music that inspired it, a little dissension goes a long way in this large-scale, ’80s-inspired piece. Available with the Happy Lens™ and Trident™ polarization, the Discord is constructed from virtually indestructible Grilamid® and features sturdy 5-barrel hinges, 6-base polycarbonate ARC® lenses, and 100% UV protection.</p> <ul> <li>Available with the color and contrast enhancing Happy Lens™ and Trident™ polarization</li> <li>Constructed from virtually indestructible Grilamid®</li> <li>6-base polycarbonate ARC® lenses for increased optical performance</li> <li>Smooth and sturdy 5-barrel hinges</li> <li>100% UV protection reduces eye fatigue and long-term sun damage</li> <li>Frame measures 57-17-145</li> </ul>	[empty string]	N	160	160	[empty string]	26006-DEFAULT-s.jpg	6	1000	673119374280	313052	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	spy/spy-discord-sunglasses-matte-black-happy-bronze-polar-with-blue-spectra-313052	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Black,Grey	NEVER SUMMER	NEVER SUMMER	MENS	MENS &GT; ACCESSORIES &GT; HATS	21.99	0	21.99	26398-DEFAULT-l.jpg	21	26398-DEFAULT-m.jpg	Bolts 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]	67	20-to-25	0.00	[empty string]	Never Summer Bolts Trucker Hat	<p>Never Summer Bolts Trucker Hat</p>	<p>Never Summer Ice Axe Patch Flex Fit Trucker Hat</p>	N	21.99	21.99	[empty string]	26398-DEFAULT-s.jpg	6	1000	HTBOLTSADJ	345708	HATS	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-bolts-trucker-hat-345708	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

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

SPY Spy Dirty Mo Sunglasses, Soft Matte Black/Happy Gray Green $120.00 | view details

NEVER SUMMER Never Summer Nvr Smr Square Patch Trucker Hat $21.99 | view details

NIXON Nixon Showoff Bi- Fold Wallet, Brown $20.00 | view details

SPY Spy Discord Sunglasses, Matte Black/Happy Bronze Polar With Blue Spectra $160.00 | view details

NEVER SUMMER Never Summer Bolts Trucker Hat $21.99 | view details

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

All Shoes 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	535	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	971	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	979	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	Moon Blue	ARCADE	ARCADE	WOMENS	WOMENS &GT; ACCESSORIES	29.99	0	29.99	25925-DEFAULT-l.jpg	29	25925-DEFAULT-m.jpg	The Guide Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Arcade Guide Belt, Moon Blue	<p>The Arcade Guide belt is incredibly tough, incredibly comfortable and built for long days and hard jobs. The Arcade Guide belt is built with heavy-duty elastic tech webbing to provide you with a burly stretch that is scuff resistant and durable. We paired this burly stretch tech webbing with an updated non-slip buckle that is backed by reinforced stitching. Speaking of the buckle we trimmed the size to drop the overall weight of the belt to give you a highly functioning comfortable belt. The Arcade Guide belt is available as one size fits most belt.</p> <ul> <li>One size fits most, up to 40″ (101.6cm)</li> <li>Tech Stretch Webbing</li> <li>Non-slip Buckle</li> <li>Belt Width – 1.5″ (3.81cm)</li> </ul>	[empty string]	N	30	30	[empty string]	25925-DEFAULT-s.jpg	5	1000	U33001-66	373381	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-guide-belt-moon-blue-373381	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Whisper White	RVCA	RVCA	WOMENS	WOMENS &GT; TOPS &GT; T-SHIRTS	26.99	0	26.99	27088-DEFAULT-l.jpg	26	27088-DEFAULT-m.jpg	Widow Cropped Tee	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]	14	25-to-50	0.00	[empty string]	RVCA Widow Knotted T-Shirt	<p>A FRESHLY PICKED POCKET TEE, THE RVCA WIDOW KNOTTED T-SHIRT BALANCES A STAPLE SOLID TEE WITH A TIE-FRONT CUT AND SMALL PRINT. CROPPED AND CUSTOMIZED WITH THE CENTER FRONT TIE, THE WOMENS SHORT SLEEVE TEE FEATURES A SMALL PRINT AT THE CHEST POCKET. MADE FROM A SOFT, PREMIUM JERSEY, THE CROPPED TEE IS FINISHED WITH A PRINTED INNER NECK LABEL FOR COMFORT.</p> <ul> <li>WOMENS POCKET T-SHIRT</li> <li>KNOTTED DETAIL AT CENTER FRONT HEM</li> <li>SLIGHTLY CROPPED</li> <li>SCREEN PRINT AT CHEST POCKET</li> <li>ENZYME WASH WITH SILICONE SOFTENER</li> <li>PREMIUM COTTON JERSEY <p> </p> </li> </ul> <p>MATERIALS</p> <ul> <li> <p>100% COTTON</p> </li> </ul>	[empty string]	N	27	27	Small,Medium	27088-DEFAULT-s.jpg	6	1000	W438TRWI	386367	T-SHIRTS	EMPTY	EMPTY	0	0	0	TOPS	rvca/rvca-widow-knotted-tshirt-386367	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Red Clay	BILLABONG	BILLABONG	WOMENS	WOMENS &GT; TOPS &GT; CROP TOPS	39.99	0	39.99	26983-DEFAULT-l.jpg	39	26983-DEFAULT-m.jpg	Straight To It Woven Tank	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]	6	25-to-50	0.00	[empty string]	Billabong Sincerely Jules Straight To It Crop Top	<p>Coastal candy stripes brings a sun-faded feel to the Straight To It Top. Part of the special edition collection with lifestyle and fashion blogger, Sincerely Jules, the woven crop top is accented with bias cut spaghetti straps and a functional button-down center front.</p> <p>The nuts and bolts</p> <ul> <li>Striped crop top.</li> <li>Adjustable straps.</li> <li>Functional center front placket.</li> <li>Pattern: yarn dye stripes.</li> <li>Material: woven blend.</li> <li><strong>Billabong x Sincerely Jules Collection:</strong> Julie Sariñana’s enthusiasm for travel, style, and life is as infectious as her impeccable taste. A self-starter and dream maker, Julie launched her blog, Sincerely Jules, in 2009. It has since then grown into a fully immersive lifestyle brand, inspiring women around the world to dream, believe, and achieve. Julie’s authenticity shines through in all her creative endeavors, making her deeply passionate, forever curious, and a true inspiration. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	39.95	39.95	Medium,Large	26983-DEFAULT-s.jpg	9	1000	J501TBST	387298	EMPTY	EMPTY	EMPTY	0	0	0	TOPS	billabong/billabong-sincerely-jules-straight-to-it-crop-top-387298	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

ARCADE Arcade Guide Belt, Moon Blue $30.00 | view details

RVCA Rvca Widow Knotted T- Shirt $27.00 | view details

BILLABONG Billabong Sincerely Jules Straight To It Crop Top $39.95 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	Assorted	ETHIKA	ETHIKA	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOXERS/BRIEFS	14.99	0	14.99	26842-DEFAULT-l.jpg	14	26842-DEFAULT-m.jpg	Boys Native Jaguar Boxer Brief	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	Ethika Native Jaguar Boy's Boxer Brief	<ul> <li>The Original - Unmatched Staple Fit</li> <li>No Pull-Down, No Gathering</li> <li>Soft 4-Way Stretch Fabric</li> <li>High-Quality Jacquard Waistband</li> <li>90% Polyester 10% Spandex</li> </ul>	[empty string]	N	15	15	Medium,Large	26842-DEFAULT-s.jpg	1	1000	UBS1373	384624	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	ethika/ethika-native-jaguar-boys-boxer-brief-384624	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Blue	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	13.99	0	13.99	25816-DEFAULT-l.jpg	13	25816-DEFAULT-m.jpg	Boy's Captain America Sock	N	BOYS	[empty string]	[empty string]	[empty string]	[empty string]	RESTRICTED	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	21	10-to-15	0.00	[empty string]	Stance Captain America Kids Marvel Comics 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	Small,Medium,Large	25816-DEFAULT-s.jpg	5	1000	B515D18CAP	380148	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-captain-america-kids-marvel-comics-crew-sock-380148	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Indigo	VOLCOM	VOLCOM	KIDS	KIDS &GT; BOYS &GT; BOTTOMS &GT; BOARDSHORTS	37.99	0	37.99	27138-DEFAULT-l.jpg	37	27138-DEFAULT-m.jpg	Lido Liney Mod	N	BOYS	IMPORTED	[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]	[empty string]	[empty string]	19	25-to-50	0.00	[empty string]	Volcom Boys Lido Liney Mod Boardshorts	<p>Stripe up for spring in the Lido Liney Mod boardshort. This vibrant style features our easy to use Cinch Fly Technology plus a convenient side pocket with VELCRO¬Æ.<br /> <br /> 18-inch outseam boardshort<br /> Signature Volcom Stone label<br /> Side pocket with VELCRO¬Æ<br /> Cinch fly technology.<br /> Little Youth has 13.5-inch outseam and adjustable waist</p> <p>93% POLYESTER / 7% ELASTANE CONTAINS RECYCLED POLYESTER</p>	[empty string]	N	38	38	22,23,24,25,26,27,28	27138-DEFAULT-s.jpg	22	1000	C0811931	383544	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	volcom/volcom-boys-lido-liney-mod-boardshorts-383544	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Cool Wip	BILLABONG	BILLABONG	KIDS	KIDS &GT; GIRLS &GT; DRESSES	39.99	0	39.99	27174-DEFAULT-l.jpg	39	27174-DEFAULT-m.jpg	Summer Road Girls Romper	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]	SU19	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Billabong Summer Road Girl's Romper	<p>Let playful lines lead you in the right direction. Printed with 80’s-inspired palm trees, the girls knit romper keeps the pool party vibes going strong with a ruffled neckline and tie-top straps. The knit romper is finished with elastic at the waist.</p> <p>The nuts and bolts</p> <ul> <li>Girls palm print romper.</li> <li>Ruffle around neckline.</li> <li>Front pockets.</li> <li>Tie straps.</li> <li>Elastic at waist.</li> <li>Soft knit.</li> <li>Pattern: palm trees print. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	39.95	39.95	X-Small,Small,Medium,Large	27174-DEFAULT-s.jpg	29	1000	GN03UBSU	385956	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	billabong/billabong-summer-road-girls-romper-385956	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	7.99	0	7.99	26780-DEFAULT-l.jpg	7	26780-DEFAULT-m.jpg	Dripper Crew Sock	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]	4	5-to-10	0.00	[empty string]	Stance Dripper Kids Crew Sock	<p>They spill things enough. The Dripper Crew is the right kind of melt without the clean up.</p> <p>FEATURES</p> <ul> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	8	8	Large	26780-DEFAULT-s.jpg	35	1000	K545A19DRC	383816	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-dripper-kids-crew-sock-383816	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	89.99	0	89.99	25706-DEFAULT-l.jpg	89	25706-DEFAULT-m.jpg	Sk8- Hi Mte Cumin/Slate Green	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	TAN	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Vans Sk8-Hi MTE Shoe, Cumin/Slate Green	<p>The Sk8-Hi MTE revamps the legendary Vans high top with additions designed for the elements. Premium weather-resistant leather uppers, warm textile linings, and a heat retention layer between sockliner and outsole keep feet warm and dry while the newly-constructed vulcanized lug outsole takes advantage of 20 years of snow boot history for maximum traction. The Sk8-Hi MTE also features re-enforced toecaps to withstand repeated wear and padded collars for support and flexibility.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	90	90	8.5	25706-DEFAULT-s.jpg	42	1000	VN0A33TXUQ8	378443	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-sk8hi-mte-shoe-cumin-slate-green-378443	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

ETHIKA Ethika Native Jaguar Boy's Boxer Brief $15.00 | view details

STANCE Stance Captain America Kids Marvel Comics Crew Sock $14.00 | view details

VOLCOM Volcom Boys Lido Liney Mod Boardshorts $38.00 | view details

BILLABONG Billabong Summer Road Girl's Romper $39.95 | view details

STANCE Stance Dripper Kids Crew Sock $8.00 | view details

VANS Vans Sk8- Hi Mte Shoe, Cumin/Slate Green $90.00 | view details

Footwear

Kids Sandals

Kids Shoes

Kids Socks

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	DC	DC	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	99.99	0	99.99	26601-DEFAULT-l.jpg	99	26601-DEFAULT-m.jpg	Kalis S Black/White/Red	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BLK COMBO	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	19	50-to-100	0.00	[empty string]	DC Kalis S Skate Shoes, Black/White/Red	<ul> <li>SUPER SUEDE™, nubuck, leather or textile upper [depending on colorway]</li> <li>Bootie construction for secure fit</li> <li>Molded TPR logo</li> <li>Mesh lining</li> <li>OrthoLite® footbed provides cushioning</li> <li>UniLite™ midsole for lightweight comfort and support</li> <li>Absorption abrasion resistant sticky rubber outsole</li> <li>DC's trademarked Pill Pattern tread <p> </p> </li> </ul>	[empty string]	N	100	100	8,8.5,9,9.5,10,10.5,11,11.5,12,13	26601-DEFAULT-s.jpg	3	1000	ADYS100470-XKWR	382974	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dc/dc-kalis-s-skate-shoes-black-white-red-382974	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	VANS	VANS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; WOMEN'S SHOES	89.99	0	89.99	25721-DEFAULT-l.jpg	89	25721-DEFAULT-m.jpg	Sk8- Hi Mte Pewter/Asphalt	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	HOLIDAY	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Vans Sk8-Hi MTE Shoe, Pewter/Asphalt	<p>The Sk8-Hi MTE revamps the legendary Vans high top with additions designed for the elements. Premium weather-resistant leather uppers, warm linings, and a heat retention layer between sockliner and outsole keep feet warm and dry while the newly-constructed vulcanized lug outsole takes advantage of 20 years of snow boot history for maximum traction. The Sk8-Hi MTE also features heel pull tabs, re-enforced toecaps to withstand repeated wear, and padded collars for support and flexibility.<br />  </p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	90	90	10.5,13	25721-DEFAULT-s.jpg	11	1000	VN0A33TXUQB	378446	WOMENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	vans/vans-sk8hi-mte-shoe-pewter-asphalt-378446	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Brown,BTA,DGG,VBR,GBL	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	33.99	0	33.99	3031-DEFAULT-l.jpg	33	3031-DEFAULT-m.jpg	Phantom Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	DISCONTINUED	[empty string]	WEEKLY	[empty string]	[empty string]	[empty string]	19	25-to-50	0.00	[empty string]	Reef Phantom Men's Sandal	<p>The Phantoms sandals were made for long weekends. If you're a person who can pack unlimited fun into three days than you need an athletic sandal that can keep up. That's the Reef Phantom guy's sandal. It features a soft, comfortable, water-friendly synthetic nubuck upper with air mesh lining, and a contoured injection molded EVA footbed and outsole with anatomical arch support. In the water and out, these sandals are durable with fantastic grip to keep you on your feet all weekend long.</p>	[empty string]	N	33.99	33.99	8,9,10,13,15	3031-DEFAULT-s.jpg	22	1000	2476	26732	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-phantom-mens-sandal-26732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	DVS	DVS	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	69.99	0	69.99	27035-DEFAULT-l.jpg	69	27035-DEFAULT-m.jpg	Comanche White/Charcoal Nubuck	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	GREY	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	51	50-to-100	0.00	[empty string]	DVS Comanche Skate Shoe, White/Charcoal	<p>The Comanche from DVS is a heritage skate shoe that offers unmatched comfort and durability.  This men’s skate shoe features a durable rubber cupsole construction with reinforced ollie area, leather upper, heavy-duty collar and tongue padding for extra protection, as well as a high impact EVA midsole.  You need to lace up a pair of the Comanche to truly feel the comfort and support of this timeless skate shoe. </p> <ul> <li>Leather & nubuck upper materials</li> <li>Molded TPR heel cap with core logo</li> <li>High impact insole & midsole unit</li> <li>Durable cupsole construction</li> <li>Reinforced ollie area for durability</li> <li>High density collar & tongue padding for support</li> <li>Open-cell breathable mesh tongue</li> </ul>	[empty string]	N	70	70	9,9.5,10,10.5,11,11.5,12,13	27035-DEFAULT-s.jpg	23	1000	DVF0000029114	383541	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	dvs/dvs-comanche-skate-shoe-white-charcoal-383541	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	Cream	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; WOMEN'S SOCKS	13.99	0	13.99	25772-DEFAULT-l.jpg	13	25772-DEFAULT-m.jpg	Women's Thoughts 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]	3	10-to-15	0.00	[empty string]	Stance Thoughts Women's Classic Crew Sock	<p>With an eclectic bunch of cartoon graphics, Thoughts is a daydreamers' delight.</p> <p>FEATURES</p> <ul> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Elastic Arch Support</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Small,Medium	25772-DEFAULT-s.jpg	26	1000	W556D18THO	380532	WOMENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-thoughts-womens-classic-crew-sock-380532	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Grey	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25819-DEFAULT-l.jpg	13	25819-DEFAULT-m.jpg	Pilot Peak Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	RESTRICTED	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STAR WARS	[empty string]	H18	[empty string]	OH at 200	[empty string]	19	10-to-15	0.00	[empty string]	Stance Pilot Peak Classic Crew Sock	<p>A sock that looks like it could hike the Tetons to the Sierras, Pilot Peak is a world traveler. Take on your next adventure in style with Stance’s Pilot Peak</p> <h4>FEATURES</h4> <ul> <li>Athletic Ribbed</li> <li>Elastic Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure <ul> </ul> </li> </ul> <h4>PRODUCT CARE</h4> <ul> <li>Machine wash at 40°c</li> <li>Avoid bleaching or ironing</li> <li>Socks will last longer if you keep them out of the dryer</li> <li>47% combed cotton, 29% polyester, 22% nylon, 3% elastane</li> </ul>	[empty string]	N	14	14	Medium,Large	25819-DEFAULT-s.jpg	27	1000	M546D18PIL	380084	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-pilot-peak-classic-crew-sock-380084	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

DC Dc Kalis S Skate Shoes, Black/White/Red $100.00 | view details

VANS Vans Sk8- Hi Mte Shoe, Pewter/Asphalt $90.00 | view details

REEF Reef Phantom Men's Sandal $33.99 | view details

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

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

STANCE Stance Pilot Peak Classic 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]	LANDYACHTZ	LANDYACHTZ	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; COMPLETE LONGBOARDS	234.99	0	234.99	27052-DEFAULT-l.jpg	234	27052-DEFAULT-m.jpg	Switch 40 Skull Complete	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Landyachtz Switch Skull 40 Complete Longboard, 40"	<p>Forwards or backwards, steep freeride spots or cruising your neighbourhood, the Switch is comfortable in any situation. The 40 inch version has ample standing platform perfect for taller riders or anyone who prefers a wider stance.</p> <p>We design our trucks and wheels to fit perfectly with each individual deck. We work tirelessly to ensure these elements come together to provide the best control and performance for your board.</p> <p>No slop, all control. Don’t accept anything less than the perfect complete.</p> <ul> <li>100% Canadian Maple</li> <li>Deep Concave</li> <li>Drop Down</li> <li>Symmetrical</li> </ul>	[empty string]	N	235	235	40IN	27052-DEFAULT-s.jpg	7	1000	119-DHSW40SKL	386938	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-switch-skull-40-complete-longboard-40-386938	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	KRUX	KRUX	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD TRUCKS	19.99	0	19.99	26866-DEFAULT-l.jpg	19	26866-DEFAULT-m.jpg	White Dlk 8.0 Standard Truck	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	15-to-20	0.00	[empty string]	Krux DLK Standard Skateboard Trucks, White	<p>Extra Fresh! New "Marbs" Krux Trucks are here and ready to shred! Each set of the "Marbs" trucks features the Krux Downlow Kingpin (DLK). Designed to prevent any snags or hang ups during grinds and perfect for smiths and feebles. Truly the smoothest grind. Krux Lows are great for tech shredders and makes flip tricks easier. Perfect for ledges, rails and any other street terrain too. Krux Lows are great for tech shredders and makes flip tricks easier. Perfect for ledges, rails and any other street terrain too. Available in black and white.</p>	[empty string]	N	19.99	19.99	8.0	26866-DEFAULT-s.jpg	16	1000	33132350-80	387668	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD TRUCKS	krux/krux-dlk-standard-skateboard-trucks-white-387668	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD WHEELS	34.99	0	34.99	25935-DEFAULT-l.jpg	34	25935-DEFAULT-m.jpg	Earth Rollers V1 Stf Whl 4- Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Bones Earth Rollers V1 STF Skateboard Wheels	<p>Street Tech Formula™ (STF) is specifically engineered from top quality components to obtain all the best properties necessary for the ultimate in street wheel performance.</p> <p>BONES® WHEELS has created a wheel with a substantially higher rebound for more speed and amazing slide capabilities while maintaining a resistance to flat spotting well beyond any standard wheel. The technology behind STF is proven. The results speak for themselves.</p> <p>Hype is hype, “quality” is for real. Try Street Tech Formula™ wheels on your next setup and see for yourself.</p>	[empty string]	N	34.99	34.99	53MM,54MM	25935-DEFAULT-s.jpg	50	1000	WSCATER	382870	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD WHEELS	bones/bones-earth-rollers-v1-stf-skateboard-wheels-382870	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	SKULLCANDY	SKULLCANDY	SKATEBOARDS	SKATEBOARDS &GT; VIDEO AND AUDIO	24.99	0	24.99	21947-DEFAULT-l.jpg	24	21947-DEFAULT-m.jpg	Ink ` D Mic ` D 2.0 Pnk/Blk Headphones	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	SKULLCANDY INK ' D 2.0 MIC'D EAR BUD HEADPHONE, Pink/Black	<p>Ink'd earbuds with mic let you manage calls and music thanks to an inline microphone and remote with call and track control. Quality ear gels create a noise isolating fit so your music stays in, and everything else stays out.</p> <ul> </ul>	[empty string]	N	24.99	24.99	[empty string]	21947-DEFAULT-s.jpg	62	1000	S2IKDY-133	285043	EMPTY	EMPTY	EMPTY	0	0	0	VIDEO AND AUDIO	skullcandy/skullcandy-ink-d-20-micd-ear-bud-headphone-pink-black-285043	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	TRIPLE EIGHT	TRIPLE EIGHT	SKATEBOARDS	SKATEBOARDS &GT; PROTECTIVE GEAR &GT; PADS	18.99	0	18.99	20261-DEFAULT-l.jpg	18	20261-DEFAULT-m.jpg	Wrist Savers	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]	37	15-to-20	0.00	[empty string]	Triple Eight Wristsaver Wrist Guards	<p>Our Wristsavers let you skate hard and fall harder. You’ll take comfort in their snug, stretchy fit, plus shock-absorbing EVA foam tucked between impact-resistant ABS splints on front and back.</p> <ul> <li>Tough, 4-way stretch nylon mesh provides a snug fit</li> <li>High-density, impact-resistant molded ABS splints on front and back for support</li> <li>Shock absorbing EVA foam secured between support splints and wrist for cushioning</li> </ul>	[empty string]	N	18.99	18.99	JR,Small,Medium,Large	20261-DEFAULT-s.jpg	95	1000	T8WS	248054	PADS	EMPTY	EMPTY	0	0	0	PROTECTIVE GEAR	triple-eight/triple-eight-wristsaver-wrist-guards-248054	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	102	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

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

KRUX Krux Dlk Standard Skateboard Trucks, White $19.99 | view details

BONES Bones Earth Rollers V1 Stf Skateboard Wheels $34.99 | view details

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

TRIPLE EIGHT Triple Eight Wristsaver Wrist Guards $18.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	Black Pebble,Sage	BILLABONG	BILLABONG	SURF SHOP	SURF SHOP &GT; LYCRA &GT; LONG SLEEVE LYCRA &GT; WOMEN'S	49.99	0	49.99	26979-DEFAULT-l.jpg	49	26979-DEFAULT-m.jpg	Sol Searcher Ls Rg	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SU19	[empty string]	[empty string]	[empty string]	30	25-to-50	0.00	[empty string]	Billabong Sol Searcher Long Sleeve Women's Rashguard	<p>Step into the sunshine while stepping out of a classic in this custom essential. Made for active days under the sun, the long sleeve rashguard for women upgrades the classic with a logo screen print and a retro 1/4 zip at the mock neck. The fitted swim shirt features UPF 50+ protection against harmful rays.</p> <p>The nuts and bolts</p> <ul> <li>Women’s long sleeve rashguard.</li> <li>Mock neck with 1/4 zip detail.</li> <li>Screen print at chest and sleeve.</li> <li>UPF 50.</li> <li>Solid.</li> <li>Material: polyamide/elastane blend. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	49.95	49.95	Small,Medium,Large,X-Large	26979-DEFAULT-s.jpg	23	1000	XR02TBSO	385791	LONG SLEEVE LYCRA	WOMENS	EMPTY	0	0	0	LYCRA	billabong/billabong-sol-searcher-long-sleeve-womens-rashguard-385791	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; STAND UP PADDLE &GT; SUP ACCESSORIES &GT; LEASHES	36.99	0	36.99	13504-DEFAULT-l.jpg	36	13504-DEFAULT-m.jpg	Adj Sup Race Comp Calf Leash	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	DS - OK FREE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	4	25-to-50	0.00	[empty string]	FCS Adjustable SUP Race Competition Leash	<p>Designed in conjunction with Hawaiian waterman Sam Pa'e, the FCS SUP Racing Leash is designed with a long adjustable rail saver strap which eliminates drag by keeping the leash out of the water at all times. Ideal for flat water and open ocean boards, this unique leash provides freedom of movement and can be attached to the nose or tail of the board.</p>	[empty string]	N	36.98	36.98	[empty string]	13504-DEFAULT-s.jpg	27	1000	2040-BLK-ADJ	270984	SUP ACCESSORIES	LEASHES	EMPTY	0	0	0	STAND UP PADDLE	fcs/fcs-adjustable-sup-race-competition-leash-270984	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	46.99	0	46.99	4570-DEFAULT-l.jpg	46	4570-DEFAULT-m.jpg	Double Soft Racks Cam Lock	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]	8	25-to-50	0.00	[empty string]	FCS Cam Lock Soft Racks Double	<p>Simple and strong, the FCS Cam Lock system will efficiently strap your boards down.</p>	[empty string]	N	46.98	46.98	[empty string]	4570-DEFAULT-s.jpg	31	1000	1900-553-00B	210621	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-cam-lock-soft-racks-double-210621	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; TRACTION	39.99	0	39.99	26166-DEFAULT-l.jpg	39	26166-DEFAULT-m.jpg	Fcs T- 2 Black/Charcoal Traction	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	FCS T-2 Traction Pad - Black/Charcoal	<p>2 piece traction, designed to suit hybrid boards.</p> <p><strong>Overview</strong></p> <p>The new FCS Traction marries considered design with performance features and superior materials.</p> <p><strong>Features</strong></p> <ul> <li>2 piece pad</li> <li>Double diamond groove</li> <li>Coffin arch bar</li> <li>Hail tail kick</li> <li>Sanded surfaces for enhanced grip</li> <li>Ultra thin sensitivity</li> <li>Perforated for extra resistance</li> </ul>	<p>FCS T-c Black/Charcoal Surfboard Traction Pad</p>	N	40	40	[empty string]	26166-DEFAULT-s.jpg	32	1000	26821	344823	TRACTION	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-t2-traction-pad-black-charcoal-344823	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	DAKINE	DAKINE	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; CAR RACKS	19.99	0	19.99	11573-DEFAULT-l.jpg	19	11573-DEFAULT-m.jpg	20 ` Tie Down Single Strap	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	M	[empty string]	[empty string]	[empty string]	WEB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Dakine Tie Down Strap - 20'	<p>The Dakine 20' Tie Down Strap makes car roof rack transportation a cinch. These are offered as a 20-foot single strap. The Tie Down Strap features the secure tightening of heavy-duty 1-3/8-inch cam buckles with a neoprene housing.</p>	[empty string]	N	19.99	19.99	[empty string]	11573-DEFAULT-s.jpg	34	1000	08840555	263994	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	dakine/dakine-tie-down-strap-20-263994	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	109.99	0	109.99	26127-DEFAULT-l.jpg	109	26127-DEFAULT-m.jpg	Fcs Ii Performer Pc Carbon Teal Med Tri	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	100-to-150	0.00	[empty string]	FCS II Performer PC Carbon Tri Fins - Medium	<p>Balance of speed, flow and response. Suitable for all conditions.</p> <p><strong>Overview</strong></p> <ul> <li>Designed for a balance of speed, flow & response.</li> <li>Well proportioned template with Inside Foil Technology (IFT).</li> <li>Ideal for surfers who want a reliable ‘All Round’ fin delivering a combination of speed and maneuverability with flow between turns.</li> <li>New Linear Flex: 3D Twist and roll action delivers a smoother feel.</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>A wide range of conditions from beach breaks to point breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Recommended for all board types.</li> </ul>	[empty string]	N	110	110	[empty string]	26127-DEFAULT-s.jpg	40	1000	FPER-CC02-MD-TS-R	358791	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-performer-pc-carbon-tri-fins-medium-358791	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

BILLABONG Billabong Sol Searcher Long Sleeve Women's Rashguard $49.95 | view details

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

FCS Fcs Cam Lock Soft Racks Double $46.98 | view details

FCS Fcs T- 2 Traction Pad - Black/Charcoal $40.00 | view details

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

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

Snowboarding

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	12.99	0	12.99	25853-DEFAULT-l.jpg	12	25853-DEFAULT-m.jpg	Supertune Base Cleaner	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	T	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Dakine Supertune Base Cleaner	<p>Supertune Base Cleaner is our citrus based degreaser. After warm spring rides or some unfortunate encounters with dirt/rocks/mud in the occasional tree well, this cleaner is the best way to remove the dirt and grime that cake the bottom of your skis or snowboard. Use it with a rag to clean your base, then do a regular hot wax treatment. It's also great on that layer of dust that accumulated in your garage over the summer.</p>	[empty string]	N	13	13	[empty string]	25853-DEFAULT-s.jpg	1	1000	10001564-H	357734	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-supertune-base-cleaner-357734	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Maroon,Navy	THRASHER	THRASHER	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR	22.99	0	22.99	26465-DEFAULT-l.jpg	22	26465-DEFAULT-m.jpg	Patch Beanie	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	20-to-25	0.00	[empty string]	Thrasher Patch Beanie	<p>Embroidered patch on a 100% acrylic beanie.</p>	[empty string]	N	22.99	22.99	[empty string]	26465-DEFAULT-s.jpg	4	1000	3131335	321051	EMPTY	EMPTY	EMPTY	0	0	0	OUTERWEAR	thrasher/thrasher-patch-beanie-321051	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	Black,Melon,Ride	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	11.99	0	11.99	25837-DEFAULT-l.jpg	11	25837-DEFAULT-m.jpg	Modular Mat	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]	18	10-to-15	0.00	[empty string]	Dakine Modular Mat Stomp Pad	<p>Made of durable injection-molded urethane, the Modular Mat has a raised scraper bar in the center, to clear snow off your boot before you strap back in. And the three configurable pieces lets you customize the look and feel of your mat.</p>	[empty string]	N	12	12	[empty string]	25837-DEFAULT-s.jpg	6	1000	10001578-H	357737	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dakine/dakine-modular-mat-stomp-pad-357737	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Camo,Dark Grey Heather,Royal	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; ACCESSORIES	27.99	0	27.99	25641-DEFAULT-l.jpg	27	25641-DEFAULT-m.jpg	Bullet Eagle Patch Snapback Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	80	25-to-50	0.00	[empty string]	Never Summer Bullet Eagle Patch Snapback Hat	<p>Never Summer Bullet Eagle Patch Snapback Hat</p>	[empty string]	N	28	28	One Size	25641-DEFAULT-s.jpg	6	1000	HTBUEAGADJ	374862	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-bullet-eagle-patch-snapback-hat-374862	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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,Charcoal	BC	BC	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR	17.99	0	17.99	25634-DEFAULT-l.jpg	17	25634-DEFAULT-m.jpg	Paleolithic Visor Beanie	N	MENS	[empty string]	[empty string]	HIGH MARGIN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BC	H17	[empty string]	[empty string]	[empty string]	1815	15-to-20	0.00	[empty string]	BC Surf Paleolithic Visor Beanie	<p>This winter look great and stay warm in the BC Surf Paleolithic Visor Beanie!</p>	[empty string]	N	17.99	17.99	One Size	25634-DEFAULT-s.jpg	13	1000	BCVSR	362932	EMPTY	EMPTY	EMPTY	0	0	0	OUTERWEAR	bc/bc-surf-paleolithic-visor-beanie-362932	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Ginger,Scout	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	84.99	0	84.99	25892-DEFAULT-l.jpg	84	25892-DEFAULT-m.jpg	Mission Pro 18l Backpack	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Dakine Mission Pro 18L Snowboard and Ski Backpack	<p>Sized for resort laps, the Mission Pro 18L stows your shovel and probe for powder days at the hill. There's room for skins and spare gloves, plus a fleece-lined pocket for goggles or sunglasses. It's hydration compatible with an insulated sleeve in the shoulder strap, and you can strap on your board or skis for boot pack missions beyond the boundary.</p> <ul> <li>Vertical snowboard carry</li> <li>Diagonal ski carry</li> <li>DK Impact Spine Protector compatible (sold separately)</li> <li>Fleece lined goggle pocket</li> <li>Snow tool/shovel pocket</li> </ul>	[empty string]	N	85	85	[empty string]	25892-DEFAULT-s.jpg	42	1000	10002063-I	373173	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-mission-pro-18l-snowboard-and-ski-backpack-373173	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

DAKINE Dakine Supertune Base Cleaner $13.00 | view details

THRASHER Thrasher Patch Beanie $22.99 | view details

DAKINE Dakine Modular Mat Stomp Pad $12.00 | view details

NEVER SUMMER Never Summer Bullet Eagle Patch Snapback Hat $28.00 | view details

BC Bc Surf Paleolithic Visor Beanie $17.99 | view details

DAKINE Dakine Mission Pro 18l Snowboard And Ski Backpack $85.00 | 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]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	124.99	0	124.99	18286-DEFAULT-l.jpg	124	18286-DEFAULT-m.jpg	The Unit Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	UPDATE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Nixon The Unit 44mm Watch, Black	<p>Packing a lot into a little, the Unit is a heavy hitter.</p>	[empty string]	N	125	125	[empty string]	18286-DEFAULT-s.jpg	1	1000	A197000	260730	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-the-unit-44mm-watch-black-260730	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	99.99	0	99.99	25684-DEFAULT-l.jpg	99	25684-DEFAULT-m.jpg	Base Tide Blue Resin	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Nixon Base Tide 38mm Watch, Blue Resin	<p>Simplified tide telling inspired by simpler times. The Base Tide slides 21st century tech into retro design and mod colors.</p>	<p>New Nixon Base Tide Digital Watch Blue Resin</p>	N	100	100	[empty string]	25684-DEFAULT-s.jpg	2	1000	A11042556	350544	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-base-tide-38mm-watch-blue-resin-350544	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Gold,Teal	STANCE	STANCE	ACCESSORIES	ACCESSORIES &GT; SOCKS	13.99	0	13.99	25767-DEFAULT-l.jpg	13	25767-DEFAULT-m.jpg	Women's Judge Me Sock	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP PRICING	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	H18	[empty string]	OH at 200	[empty string]	46	10-to-15	0.00	[empty string]	Stance Judge Me Women's Classic Crew Sock	<p>From the pace makers who've supported Stance since the beginner to the fans we have today, we are proud of each one of you who backs the brand. We created the Judge Me for those who want to show where their alliance lies.</p> <p>FEATURES</p> <ul> <li>Ultra Lite Cushion</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	[empty string]	N	14	14	Small,Medium	25767-DEFAULT-s.jpg	6	1000	W515C18JUD	380517	EMPTY	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-judge-me-womens-classic-crew-sock-380517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Charcoal	DAKINE	DAKINE	ACCESSORIES	ACCESSORIES &GT; HATS	27.99	0	27.99	25864-DEFAULT-l.jpg	27	25864-DEFAULT-m.jpg	Victor Earflap 7 Panel 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]	2018	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Dakine Victor Cuffed Earflap Hat	<p>The Dakine Victor hat is the ideal winter cap. This fitted, wool blend, 7-panel hat features flip down earflaps for added warmth. The complete package harkens back to a simpler time marked by quality, long-lasting goods.</p>	[empty string]	N	28	28	Small/Medium,Large/X-Large	25864-DEFAULT-s.jpg	7	1000	10001530-H	356504	EMPTY	EMPTY	EMPTY	0	0	0	HATS	dakine/dakine-victor-cuffed-earflap-hat-356504	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	OAKLEY	OAKLEY	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	182.99	0	182.99	26005-DEFAULT-l.jpg	182	26005-DEFAULT-m.jpg	Holbrook Woodgrain/Prizm Polar	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]	SU16	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Oakley Holbrook Sunglasses, Woodgrain/Prizm Daily Polarized	<p>We gave O Matter™ frame material the visual texture of woodgrain, bringing the artisan look of fine craftsmanship to the performance of Prizm™ Daily lenses that enhance details and make colors more vivid.</p>	[empty string]	N	183	183	[empty string]	26005-DEFAULT-s.jpg	10	1000	OO9102-B7	345829	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	oakley/oakley-holbrook-sunglasses-woodgrain-prizm-daily-polarized-345829	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Beach Glass,Rosa,Auburn,Seaspray	BILLABONG	BILLABONG	ACCESSORIES	ACCESSORIES &GT; BAGS	24.99	0	24.99	26977-DEFAULT-l.jpg	24	26977-DEFAULT-m.jpg	Surfs Up Hip Pack	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SU19	[empty string]	[empty string]	[empty string]	38	20-to-25	0.00	[empty string]	Billabong Surfs Up Waist Pack	<p>A bag for the beach bum. Fanny pack, bum bag or hip pouch, whatever you want to call it the Surfs Up delivers hands-free storage for your essentials, so you can wander on without worrying about where you set your bag down.</p> <p>The nuts and bolts</p> <ul> <li>Women’s hip pouch.</li> <li>Adjustable webbed belt with metal hardware.</li> <li>Zipper closure.</li> <li>Metal logo trim.</li> <li>Printed.</li> <li>Washed canvas.</li> <li>Dimensions: 8.75 x 3.75 x 1 inches.</li> <li>Capacity: 1 liter. <p> </p> </li> </ul> <h2> </h2>	[empty string]	N	24.95	24.95	O/S	26977-DEFAULT-s.jpg	11	1000	JATVTBSU	385552	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	billabong/billabong-surfs-up-waist-pack-385552	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]