Brixton Oath III Snapback Hat, Black/Copper

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	Navy/White,Black/Green,Red/White	THRASHER	THRASHER	MENS	MENS &GT; ACCESSORIES &GT; HATS	19.99	0	19.99	26453-DEFAULT-l.jpg	19	26453-DEFAULT-m.jpg	Skate Goat Emb Mesh Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	21	15-to-20	0.00	[empty string]	Thrasher Skate Goat Embroidered Trucker Hat	<p>Adjustable, embroidered Thrasher Skategoat logo mesh cap. One size fits most.</p>	[empty string]	N	19.99	19.99	[empty string]	26453-DEFAULT-s.jpg	2	1000	3130089CLR	323556	HATS	EMPTY	EMPTY	0	0	0	EMPTY	thrasher/thrasher-skate-goat-embroidered-trucker-hat-323556	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	ELECTRIC	ELECTRIC	MENS	MENS &GT; ACCESSORIES &GT; SUNGLASSES	119.99	0	119.99	27233-DEFAULT-l.jpg	119	27233-DEFAULT-m.jpg	Swingarm Xl Matte Blk/Ohm Gry Polar	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Electric Swingarm XL Sunglasses, Matte Black/Grey Polarized	<p>The same comfortable and clean look you love, scaled up for a larger fit and better coverage. Lightweight and heavy duty, this purpose built frame now offers even more uncompromising fit and function.</p> <ul> <li>Frame: 6 base mold injected grilamid frame with an innovative double action hinge system.</li> <li>Optics: 6 base melanin infused polycarbonate lenses. 100% UV protection. Up to 98% blue light protection.</li> <li>Available in polarized polycarbonate lenses. 99.9% Premium glare reduction, relaxed/soothing eye feeling, true color perception, and scratch resistance.</li> <li>Visual Light Transmitted (VLT): 10%. Optimal lens for daily use. Increased clarity and depth perception while providing visual comfort.</li> <li>Includes microfiber cleaning bag.</li> <li>Designed in California. Made in Italy.</li> <li>Lifetime warranty</li> <li>Measurement: 52h - 145w&sbquo; 162l</li> <li>Weight: 30 grams</li> </ul>	[empty string]	N	120	120	[empty string]	27233-DEFAULT-s.jpg	2	1000	EE15901042	349648	SUNGLASSES	EMPTY	EMPTY	0	0	0	EMPTY	electric/electric-swingarm-xl-sunglasses-matte-black-grey-polarized-349648	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	White	QUIKSILVER	QUIKSILVER	MENS	MENS &GT; ACCESSORIES &GT; HATS	29.99	0	29.99	26660-DEFAULT-l.jpg	23	26660-DEFAULT-m.jpg	Starkness Hat	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP19	[empty string]	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Quiksilver Starkness Snapback Hat	<ul> <li>Cotton twill fabric</li> <li>6-panel crown</li> <li>Curved brim</li> <li>HD woven label patch on front</li> <li>Adjustable plastic closure</li> </ul> <p>Composition</p> <ul> <li> <p>100% Cotton</p> </li> </ul>	[empty string]	N	24	24	[empty string]	26660-DEFAULT-s.jpg	9	1000	AQYHA04308	390955	HATS	EMPTY	EMPTY	0	0	0	EMPTY	quiksilver/quiksilver-starkness-snapback-hat-390955	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BYRD	BYRD	MENS	MENS &GT; ACCESSORIES &GT; HAIR CARE	21.99	0	21.99	26820-DEFAULT-l.jpg	21	26820-DEFAULT-m.jpg	Clay Pomade 3 Oz	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	9	20-to-25	0.00	[empty string]	Byrd Clay Hair Pomade, 3.35 oz.	<p>The Sea BYRD formula is a unique clay wax blend designed to sculpt just about any hairstyle with epic control. Bentonite Clay and Beeswax provide strong, workable hold while Diatomaceous Earth lends a natural matte finish that doesn't look dry or dull. A versatile pomade that adds volume to fine hair and stands up to thick, unruly hair.</p>	[empty string]	N	22	22	[empty string]	26820-DEFAULT-s.jpg	10	1000	SPA02	391155	HAIR CARE	EMPTY	EMPTY	0	0	0	EMPTY	byrd/byrd-clay-hair-pomade-335-oz-391155	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Tan,Black	RVCA	RVCA	MENS	MENS &GT; ACCESSORIES &GT; WALLETS	23.99	0	23.99	26898-DEFAULT-l.jpg	23	26898-DEFAULT-m.jpg	Leather Magic Wallet	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]	13	20-to-25	0.00	[empty string]	RVCA Leather Magic Wallet	<p>Holding it all together without losing minimalist design, the rvca leather magic wallet offers a top shelf version of the slim wallet. The interior keeps your goods secure with elastic bands and credit card slots.</p>	[empty string]	N	24	24	One Size	26898-DEFAULT-s.jpg	11	1000	MAWASRML	383248	WALLETS	EMPTY	EMPTY	0	0	0	EMPTY	rvca/rvca-leather-magic-wallet-383248	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	NIXON	NIXON	MENS	MENS &GT; ACCESSORIES &GT; WATCHES	124.99	0	124.99	25661-DEFAULT-l.jpg	124	25661-DEFAULT-m.jpg	Time Teller Bb Silver/Hawk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	5	100-to-150	0.00	[empty string]	Nixon Time Teller 37mm, Powell Peralta - Tony Hawk, Silver/Hawk	<p> </p> <p>Clean lines cut through cloudy philosophy, while its simple, high concept design keeps things precise.</p>	[empty string]	N	125	125	[empty string]	25661-DEFAULT-s.jpg	12	1000	A0452840	360542	WATCHES	EMPTY	EMPTY	0	0	0	EMPTY	nixon/nixon-time-teller-37mm-powell-peralta-tony-hawk-silver-hawk-360542	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM firstQuery ORDER BY sortBy

THRASHER Thrasher Skate Goat Embroidered Trucker Hat $19.99 | view details

ELECTRIC Electric Swingarm Xl Sunglasses, Matte Black/Grey Polarized $120.00 | view details

QUIKSILVER Quiksilver Starkness Snapback Hat $24.00 | view details

BYRD Byrd Clay Hair Pomade, 3.35 Oz. $22.00 | view details

RVCA Rvca Leather Magic Wallet $24.00 | view details

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

Womens

Pants Shorts

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

Bikini Bottoms Bikini Tops Lycra and Rashguards View All >>

Gloves

Boots Skate Shoes

Leather Sandals Rubber Sandals Water Friendly Sandals

Backpacks Bags Beanies Hair Care Hats Jewelry View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9	querySort
1	[empty string]	SUN BUM	SUN BUM	WOMENS	WOMENS &GT; ACCESSORIES	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	12	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
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	65	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	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	465	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
4	Multi	VOLCOM	VOLCOM	WOMENS	WOMENS &GT; TOPS &GT; HOODIES AND SWEATSHIRTS	59.99	0	59.99	26945-DEFAULT-l.jpg	59	26945-DEFAULT-m.jpg	Daze Go By Sweater	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]	17	50-to-100	0.00	[empty string]	Volcom Daze Go By Sweater	<p>Crafted with a soft acrylic fabric, the Daze Go By Sweater is cute and cozy crew neck style. Features a relaxed fit with dolman sleeves and a wide rib neckline, hem and cuffs. Model is wearing size small.<br /> <br /> This items runs short, please consider ordering a size up for a more oversized fit. <br /> <br /> Dolman crew neck sweater with wide rib neckline, hem, and cuffs<br /> Metal badge at front hem<br /> Length is 19 from shoulder to hem</p>	[empty string]	N	59.5	59.5	X-Small,Small,Medium,Large	26945-DEFAULT-s.jpg	1	1000	B0711901	389313	HOODIES AND SWEATSHIRTS	EMPTY	EMPTY	0	0	0	TOPS	volcom/volcom-daze-go-by-sweater-389313	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Medieval Blue	ROXY	ROXY	WOMENS	WOMENS &GT; DRESSES/ROMPERS	39.99	0	39.99	27082-DEFAULT-l.jpg	39	27082-DEFAULT-m.jpg	Chill Love Knit Romper	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]	18	25-to-50	0.00	[empty string]	Roxy Chill Love Strappy Romper	<p>The nuts and bolts</p> <ul> <li>Heavyweight cotton rib knit fabric [240 g/m2]</li> <li>Short length</li> <li>Thin adjustable straps</li> <li>4 button closure on front</li> </ul> <p>Composition</p> <ul> <li> <p>95% Viscose, 5% Elastane</p> </li> </ul>	[empty string]	N	40	40	Small,Medium,Large	27082-DEFAULT-s.jpg	2	1000	ERJX603142	388976	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	roxy/roxy-chill-love-strappy-romper-388976	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Natural,Brown	RAINBOW	RAINBOW	WOMENS	WOMENS &GT; SANDALS	41.99	0	41.99	2983-DEFAULT-l.jpg	41	2983-DEFAULT-m.jpg	Hemp Sandal	N	WOMENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	27	25-to-50	0.00	[empty string]	Rainbow Single Layer Hemp Top and Strap Women's Sandal	<p>Hemp, a plant whose strong fibers are used to make this naturally durable fabric is one of our most laid back sandals. Slip a pair on and you’ll be what’s hempinin’</p> <p> </p> <p>• Natural Hemp Top Sole</p> <p>• Single Layer Arch</p> <p>• Hemp Strap</p> <p>• Bonded Nylon Thread</p> <p>• Box X Toe Construction</p> <p>• Triple Glued</p> <p>• Non-Slip Bottom Sole</p> <p>• Original Rainbow Woven Label</p> <p> </p> <p>This sandal features a hemp top sole and strap. Both are double stitched with bonded nylon thread, only the best materials are used to guarantee the thread won’t fray or pull out.</p> <p> </p> <p>The structure is our famous single layer midsole with an arch support and a durable box X stitch pattern at the nylon toe piece.</p> <p> </p> <p>The bottom sole is our non-slip Rainbow bottom. The sandal is finished off with the Original Woven label on the right strap.</p> <p> </p>	[empty string]	N	41.99	41.99	Small,Medium,Large,X-Large,11	2983-DEFAULT-s.jpg	5	1000	301AHTS-WMN	190420	EMPTY	EMPTY	EMPTY	0	0	0	SANDALS	rainbow/rainbow-single-layer-hemp-top-and-strap-womens-sandal-190420	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Cocobalm Lip Balm, Groove Berry $3.99 $2.99 | view details

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

VOLCOM Volcom Daze Go By Sweater $59.50 | view details

ROXY Roxy Chill Love Strappy Romper $40.00 | view details

RAINBOW Rainbow Single Layer Hemp Top And Strap Women's Sandal $41.99 | view details

Kids

Bottoms Tops Accessories Sandals Shoes

Accessories Bottoms Dresses Sandals Shoes View All >>

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	25.00,50.00,75.00,100.00,125.00,150.00,500.00,1000.00,300.00	BC	BC	KIDS	KIDS	999.99	0	999.99	3037-DEFAULT-l.jpg	999	3037-DEFAULT-m.jpg	Bc Surf Sport In- Store Gift Card	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	FREE	[empty string]	[empty string]	[empty string]	TOP SELLERS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	108	20-to-25	0.00	[empty string]	BC Surf & Sport Gift Card - In-Store or Online use	<p>BC Surf & Sport Gift Card - In-Store or Online use</p>	[empty string]	N	25	1000	[empty string]	3037-DEFAULT-s.jpg	2	1000	BCGC	252213	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bc/bc-surf-sport-gift-card-instore-or-online-use-252213	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	VANS	VANS	KIDS	KIDS &GT; GIRLS &GT; SHOES	59.99	0	59.99	6509-DEFAULT-l.jpg	59	6509-DEFAULT-m.jpg	Old Skool Black	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	ZERO ITEM	[empty string]	CURRENT	[empty string]	AVAILABLE	[empty string]	MEDIUM	[empty string]	[empty string]	[empty string]	SKATE	SPRING	8 - LAST SPRING	[empty string]	[empty string]	192	50-to-100	0.00	[empty string]	Vans Old Skool Skate Shoe, Black/White	<p>The Old Skool, Vans classic skate shoe and the first to bare the iconic side stripe, has a low-top lace-up silhouette with a durable suede and canvas upper with padded tongue and lining and Vans signature Waffle Outsole.</p> <p>3.5 Boys = 5.0 Women<br /> 4.0 Boys = 5.5 Women<br /> 4.5 Boys = 6.0 Women<br /> 5.0 Boys = 6.5 Women<br /> 5.5 Boys = 7.0 Women<br /> 6.0 Boys = 7.5 Women<br /> 6.5 Men = 8.0 Women<br /> 7.0 Men = 8.5 Women<br /> 7.5 Men = 9.0 Women<br /> 8.0 Men = 9.5 Women<br /> 8.5 Men = 10.0 Women<br /> 9.0 Men = 10.5 Women<br /> 9.5 Men = 11.0 Women<br /> 10.0 Men = 11.5 Women<br /> 10.5 Men = 12.0 Women<br /> 11.0 Men = 12.5 Women<br /> 11.5 Men = 13.0 Women<br /> 12.0 Men = 13.5 Women<br /> 13.0 Men = 14.5 Women</p>	[empty string]	N	60	60	3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12,13,14	6509-DEFAULT-s.jpg	17	1000	VN000D3HY28	248351	SHOES	EMPTY	EMPTY	0	0	0	GIRLS	vans/vans-old-skool-skate-shoe-black-white-248351	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
3	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	40	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]
4	Black	STANCE	STANCE	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	9.99	0	9.99	25798-DEFAULT-l.jpg	9	25798-DEFAULT-m.jpg	Boy's Check Me Out 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]	9	5-to-10	0.00	[empty string]	Stance Check Me Out Boys Kids Classic Crew Sock	<p>Checkered print will never go out of style. Pass the torch with Check Me Out 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	Medium,Large	25798-DEFAULT-s.jpg	42	1000	B526D18CHE	380125	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	stance/stance-check-me-out-boys-kids-classic-crew-sock-380125	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	COSTA DEL MAR	COSTA DEL MAR	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	8.99	0	8.99	25941-DEFAULT-l.jpg	8	25941-DEFAULT-m.jpg	Costa C- Line Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	1	5-to-10	0.00	[empty string]	Costa Del Mar C-Line Sunglasses Retainer, Black	<p>Costa C-Line™ Retainer. Ultra-thin sunglass retainer. Lightweight. <strong>End-to-End Measurement: </strong>20"</p>	[empty string]	N	8.99	8.99	[empty string]	25941-DEFAULT-s.jpg	51	1000	CE11	349327	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	costa-del-mar/costa-del-mar-cline-sunglasses-retainer-black-349327	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	Black	NEVER SUMMER	NEVER SUMMER	KIDS	KIDS &GT; GIRLS &GT; ACCESSORIES	24.99	0	24.99	26381-DEFAULT-l.jpg	24	26381-DEFAULT-m.jpg	Yth Bullet Eagle Pactch Snapback Hat	N	BOYS	[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]	21	20-to-25	0.00	[empty string]	Never Summer Bullet Eagle Patch Youth Snapback Hat	<p>Never Summer Bullet Eagle Patch Youth Snapback Hat</p>	<p>FCS Dayrunner Sup Adjustable 9'6'-11'6"</p>	N	24.99	24.99	One Size	26381-DEFAULT-s.jpg	87	1000	BHTBUEAGAD	374863	EMPTY	EMPTY	EMPTY	0	0	0	GIRLS	never-summer/never-summer-bullet-eagle-patch-youth-snapback-hat-374863	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

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

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

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

STANCE Stance Check Me Out Boys Kids Classic Crew Sock $10.00 | view details

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

NEVER SUMMER Never Summer Bullet Eagle Patch Youth Snapback Hat $24.99 | 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]	SUPRA	SUPRA	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	74.99	0	74.99	26931-DEFAULT-l.jpg	74	26931-DEFAULT-m.jpg	Hammer Vtg Black/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]	28	50-to-100	0.00	[empty string]	Supra Hammer VTG Skate Shoe	<p>The hammer vtg is jim greco’s newest pro model. This vintage inspired skate shoe uses the same last as the greco, giving it a slim and classic shape. The upper consists of a premium suede vamp/collar/heel with a breathable canvas quarter. The design has references that tie back to the hammer franchise and overlays are detailed by premium french binding. The hammer vtg uses a rubber toe cap and sit atop a brand new vulcanized outsole utilizing dual-layered herringbone tread for ultimate board feel and long lasting durability. The shoe also features the brand new super comfort insole for peak impact protection and all day comfort.</p>	[empty string]	N	75	75	8,8.5,9,9.5,10,10.5,11,12	26931-DEFAULT-s.jpg	11	1000	06123-002	384709	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	supra/supra-hammer-vtg-skate-shoe-384709	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	13.99	0	13.99	25831-DEFAULT-l.jpg	13	25831-DEFAULT-m.jpg	Harambe Gorilla Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	FA18	[empty string]	OH at 200	[empty string]	5	10-to-15	0.00	[empty string]	Stance Gorilla Classic Crew Sock	<p>Pay respect to the king of the jungle, ruler of the evolution, and a gorilla that we still miss, Harambe.</p> <p>FEATURES</p> <ul> <li>Athletic Ribbed</li> <li>Terry Loop In Forefoot, Heel, And Toe For Medium Cushion</li> <li>Arch Support</li> <li>Reinforced Heel & Toe</li> <li>Seamless Toe Closure</li> </ul> <p>PRODUCT CARE</p> <ul> <li>Machine Wash in 40 °C / 104 °F.</li> <li>Avoid Bleaching or Ironing the socks.</li> <li>Socks will last longer if you keep them out of the dryer.</li> </ul>	<p>Stance "Wu-Tang Patch V2" Classic Crew Socks (Black) Men's Hip Hop Print Sock Medium (Black, Medium)</p>	N	14	14	Medium,Large	25831-DEFAULT-s.jpg	23	1000	M556C18GOR	370572	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-gorilla-classic-crew-sock-370572	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Bronze Brown,Chocolate	REEF	REEF	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	59.99	0	59.99	19569-DEFAULT-l.jpg	59	19569-DEFAULT-m.jpg	Draftsmen Leather Sandal	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FA16	[empty string]	OH at 200	[empty string]	187	50-to-100	0.00	[empty string]	Reef Draftsmen Leather Men's Sandal	<p>Style for the beach and beyond. You can get away with sandals at that classy dinner spot if they're the right sandals. These men's leather sandals are perfect for beach weddings. Who wears shoes on the beach? Reef Draftsmen sandals feature full grain premium leather footbed and upper, a “Blind Stich” strap construction that allows stitch-free strap, and a comfort EVA midsole that's highly abrasion resistant, so you can keep wearing them to nice eateries and save them for next wedding season. These sandals also feature molded Reef rubber outsole and secret weapon of the TQT (that's “Thirst Quenching Technology”) hidden bottle opener, to make sure it's a good party.</p>	[empty string]	N	59.99	59.99	7,8,9,10,11,12,13,14	19569-DEFAULT-s.jpg	25	1000	2611	272233	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	reef/reef-draftsmen-leather-mens-sandal-272233	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	Charcoal Weave,Natural Weave,Blackout	SANUK	SANUK	FOOTWEAR	FOOTWEAR &GT; SANDALS &GT; MEN'S SANDALS	35.99	0	35.99	25624-DEFAULT-l.jpg	35	25624-DEFAULT-m.jpg	Yogi 4 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]	[empty string]	[empty string]	OH at 200	[empty string]	84	25-to-50	0.00	[empty string]	Sanuk Yogi 4 Men's Sandals	<p>One, Two, Three, and to the Yogi 4. Extra comfy sandals are knockin at your door.</p>	[empty string]	N	36	36	8,9,10,11,12	25624-DEFAULT-s.jpg	35	1000	SMS10966	331663	MENS SANDALS	EMPTY	EMPTY	0	0	0	SANDALS	sanuk/sanuk-yogi-4-mens-sandals-331663	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	HEY DUDE	HEY DUDE	FOOTWEAR	FOOTWEAR &GT; SHOES &GT; MEN'S SHOES	59.99	0	59.99	27043-DEFAULT-l.jpg	59	27043-DEFAULT-m.jpg	Wally Stretch Iron	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]	48	50-to-100	0.00	[empty string]	Hey Dude Wally Stretch Shoe, Iron	<p>When you're stuck in the middle seat, at least your feet will have room to stretch out.</p> <p>Designed to be your favorite shoe for all occasions, Wally embodies the Hey Dude lifestyle by combining your passion for comfort, quality, and fashion. This unique combination allows you to attack each day as a new adventure with the confidence your feet won’t be the reason to slow down. Constructed with leading-edge technology, like the Flex & Fold system, Wally easily is one of the most comfortable and versatile shoes on the market.</p> <p><br /> <strong>SHOE SPECS:</strong></p> <ul> <li><strong>Sizing Tip:</strong> <strong>If you usually wear half sizes, we suggest choosing the next size up for best fit</strong></li> <li>Flex & Fold Technology</li> <li>Ultra-Light outsole</li> <li>Stretch upper</li> <li>Soft oxford cloth lining</li> <li>Memory foam insole</li> <li>Machine washable (cold)</li> <li>5.5 oz. total weight</li> </ul>	[empty string]	N	59.95	59.95	8,9,10,11,12,13,14	27043-DEFAULT-s.jpg	38	1000	150203910	384713	MENS SHOES	EMPTY	EMPTY	0	0	0	SHOES	hey-dude/hey-dude-wally-stretch-shoe-iron-384713	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	STANCE	STANCE	FOOTWEAR	FOOTWEAR &GT; SOCKS &GT; MEN'S SOCKS	15.99	0	15.99	25777-DEFAULT-l.jpg	15	25777-DEFAULT-m.jpg	World Champ Sock	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	REGULAR	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	31	15-to-20	0.00	[empty string]	Stance JJF World Champ John John Florence Crew Sock	<p>The 2017 World Tour was winding down and Stance Punk & Poet John John Florence was yet again in contention for professional surfing’s highest honor. Red flags reading, “Go John John!” were strewn across the Islands in support of JJF as he set out to capture back-to-back world titles at the 2017 Pipe Masters. For our latest collaboration, we’ve included the same flag design in honor of the hometown hero who became the first Hawaiian since Andy Irons to win two consecutive titles on the World Championship Tour.</p> <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	16	16	Large	25777-DEFAULT-s.jpg	39	1000	M558A18WOR	375171	MENS SOCKS	EMPTY	EMPTY	0	0	0	SOCKS	stance/stance-jjf-world-champ-john-john-florence-crew-sock-375171	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

SUPRA Supra Hammer Vtg Skate Shoe $75.00 | view details

STANCE Stance Gorilla Classic Crew Sock $14.00 | view details

REEF Reef Draftsmen Leather Men's Sandal $59.99 | view details

SANUK Sanuk Yogi 4 Men's Sandals $36.00 | view details

HEY DUDE Hey Dude Wally Stretch Shoe, Iron $59.95 | view details

STANCE Stance Jjf World Champ John John Florence Crew Sock $16.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]	SANTA CRUZ	SANTA CRUZ	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD DECKS	69.99	0	69.99	26738-DEFAULT-l.jpg	69	26738-DEFAULT-m.jpg	Obrien Purgatory Reissue	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Santa Cruz Obrien Purgatory Re-Issue Skateboard Deck, 9.85" x 30"	<p>9.85" x 30"</p> <p>Straight from the archives comes new Santa Cruz Re-Issues! Santa Cruz Skateboards is proud to release four new reissues! For the first time since it's original production, Corey O'Brian's "Purgatory” graphic is back on its original shape and in a new, never before printed colorway. A must have for any fan of the 80’s. Hang this baby on your wall or set up a one of a kind skateboard. Either way, you won't be disappointed.</p>	[empty string]	N	69.99	69.99	9.8	26738-DEFAULT-s.jpg	4	1000	11115417	391903	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD DECKS	santa-cruz/santa-cruz-obrien-purgatory-reissue-skateboard-deck-985-x-30-391903	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	Yellow,Orange	PENNY	PENNY	SKATEBOARDS	SKATEBOARDS &GT; PARTS AND ACCESSORIES	4.99	0	4.99	26418-DEFAULT-l.jpg	4	26418-DEFAULT-m.jpg	Colored Hardware	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	5-and-under	0.00	[empty string]	Penny Skateboards Gumball Colored Skateboard Hardware, 1.125"	<p>Gumball bolts are Nickel-plated, high tesile deck bolts, dipped in a range of colours to create a world of colour combinations.</p>	[empty string]	N	4.99	4.99	[empty string]	26418-DEFAULT-s.jpg	5	1000	PHW	286331	EMPTY	EMPTY	EMPTY	0	0	0	PARTS AND ACCESSORIES	penny/penny-skateboards-gumball-colored-skateboard-hardware-1125-286331	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	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	6	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]
4	[empty string]	ARBOR	ARBOR	SKATEBOARDS	SKATEBOARDS &GT; LONGBOARDS &GT; LONGBOARD DECKS	109.99	0	109.99	26955-DEFAULT-l.jpg	109	26955-DEFAULT-m.jpg	Axis 40 Photo Deck	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Arbor Axis 40 Photo Longboard Deck, 40"	<p>A snowboard-inspired drop-through for easy around town cruising, relaxed commutes, and mellow downhill.</p> <p> </p>	[empty string]	N	109.95	109.95	[empty string]	26955-DEFAULT-s.jpg	7	1000	ARBDL40003	393654	LONGBOARD DECKS	EMPTY	EMPTY	0	0	0	LONGBOARDS	arbor/arbor-axis-40-photo-longboard-deck-40-393654	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	BONES	BONES	SKATEBOARDS	SKATEBOARDS &GT; SKATEBOARD BEARINGS	29.99	0	29.99	4165-DEFAULT-l.jpg	29	4165-DEFAULT-m.jpg	Super Reds Bearing 8- Pk	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	73	25-to-50	0.00	[empty string]	Bones Super Reds Skateboard Bearings	<p>Super REDS® are designed from the ground up to be the best bearing on the market at this price point. What Super REDS® are not is a REDS® bearing with just better super finishing (surface polishing). Super REDS® are a superior quality bearing, using higher quality steel races, better quality and grade balls, and a superior surface finish. The result is a bearing that is as fast as REDS® but quieter, smoother, and longer lasting. Super REDS® use a black shield and laser engraving to differentiate themselves from original REDS®.</p> <p><strong>Features</strong></p> <ul> <li>Features Higher quality steel races, better quality and grade balls, and a superior surface finish.</li> <li>Single, non-contact, removable rubber shield for easy cleaning and less friction.</li> <li>High speed nylon ball retainer for greater strength and speed.</li> <li>Pre-lubricated with Speed Cream™ racing lubricant</li> <li>Skate Rated™ clearances, tolerances, materials and lubricant provide the best performance and durability possible.</li> </ul> <p><strong>Contents</strong></p> <ul> <li>Set of 8 bearings</li> <li>Instructions</li> <li>Sticker</li> </ul>	[empty string]	N	29.95	29.95	[empty string]	4165-DEFAULT-s.jpg	21	1000	BBSR	246314	EMPTY	EMPTY	EMPTY	0	0	0	SKATEBOARD BEARINGS	bones/bones-super-reds-skateboard-bearings-246314	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	188.99	0	188.99	26316-DEFAULT-l.jpg	188	26316-DEFAULT-m.jpg	Bamboo Pinner Handstand 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 Pinner Handstand Complete Longboard, 44"	<p style="margin-left:0px; margin-right:0px; text-align:left">For long cruises or short rides, nothing compares to a big pintail board. The Pinner stands out from the crowd with bamboo/maple construction and a rockered shape providing a comfortable and flexy hammock for your feet.</p> <p style="margin-left:0px; margin-right:0px; text-align:left">Can you imagine what boards would have been like if there were designed for our hands instead of our feet? Maybe the grip tape would be softer and smooth to the touch. Maybe there would be specific grooves just for our fingers to sit in. Luckily, the art of skating on your hands never really took off and boards have been designed for our feet instead. But we would still like to pay homage to the few, the proud, the hand boarders.</p> <p style="margin-left:0px; margin-right:0px; text-align:left"><strong>Artist:</strong> Grace Garcia</p> <p style="margin-left:0px; margin-right:0px; text-align:left">L: 44” I W: 9.5” I WB: 32”</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, Medium Concave<br /> <strong>Setup:</strong> Bear Grizzly GR852, 70mm Stone Ground Hawgs Mocha Swirl 78a, ¼” Riser, Bear Spaceball Bearings</p>	[empty string]	N	189	189	44IN	26316-DEFAULT-s.jpg	21	1000	CP-FRBPIN	369746	EMPTY	EMPTY	EMPTY	0	0	0	LONGBOARDS	landyachtz/landyachtz-pinner-handstand-complete-longboard-44-369746	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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

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

PENNY Penny Skateboards Gumball Colored Skateboard Hardware, 1.125 " $4.99 | view details

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

ARBOR Arbor Axis 40 Photo Longboard Deck, 40 " $109.95 | view details

BONES Bones Super Reds Skateboard Bearings $29.95 | view details

LANDYACHTZ Landyachtz Pinner Handstand Complete Longboard, 44 " $189.00 | view details

Surf Shop

Funboards Longboards Shortboards Soft Tops/Beginner

Board Bags Car Racks Fins Leashes Traction

Fins Leashes

SUP Accessories

Accessories Bags Fins

Short Sleeve Lycra Long Sleeve Lycra

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTBY	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; BOARD BAGS	57.99	0	57.99	26174-DEFAULT-l.jpg	57	26174-DEFAULT-m.jpg	Stretch Fun Board 8 ` 0 ` Teal Bag	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	50-to-100	0.00	[empty string]	FCS Stretch Fun Board Cover - Teal - 8'	<p>Lightweight protection for your board from wax, scratches, dust and UV light.</p> <p><strong>Overview</strong></p> <p>Ideal for additional protection in travel covers, keeping wax of car seats, or when storing your boards.</p> <p> </p> <p><strong>Features</strong></p> <ul> <li>High quality, thick weave material</li> <li>Durable 600D polyester nose protector</li> <li>Note: not designed to protect boards during extended travel</li> </ul>	[empty string]	N	58	58	[empty string]	26174-DEFAULT-s.jpg	1	1000	BST-080-FB-TEL	358936	EMPTY	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-stretch-fun-board-cover-teal-8-358936	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	FCS	FCS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	119.99	0	119.99	26111-DEFAULT-l.jpg	119	26111-DEFAULT-m.jpg	Fcsii Perf Neo Glass Med Tri- Quad Fins	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DROP SHIP ITEM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	100-to-150	0.00	[empty string]	FCS II Performer Neo Glass Tri-Quad 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>Tri-Quad (5 fin) set</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> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Performer: Find Balance. A balance of speed, flow & response.</li> </ul>	<p>FCS II Performer Neo Glass Medium Tri-Quad Fins</p>	N	120	120	[empty string]	26111-DEFAULT-s.jpg	4	1000	FPER-NG01-MD-FS-R	334606	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-performer-neo-glass-triquad-fins-medium-334606	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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; FINS	119.99	0	119.99	26171-DEFAULT-l.jpg	119	26171-DEFAULT-m.jpg	Fcs Ii Js Pc Medium Tri Retail Fins	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]	FCS II JS Tri-Fins - Medium	<p>Jason Stevenson's 'JS' shaper fin. Delivers exceptional flow and drive.</p> <p><strong>Overview</strong></p> <ul> <li>The FCS II JS fin was designed by world renowned shaper Jason Stevenson (JS Surfboards), and delivers a smooth ride with an emphasis on flow and drive.</li> <li>“What I like about this fin is just the speed and flow that it has, then if you want to push it a little harder it has the release too. To put it simply, it’s just really reliable”. Jason Stevenson</li> </ul> <p> </p> <p><strong>Ideal Conditions</strong></p> <ul> <li>Open face, down-the-line waves, particularly good in point and reef breaks.</li> </ul> <p> </p> <p><strong>Board Types</strong></p> <ul> <li>Designed to fit the FCS II Fin System.</li> <li>Performance boards with deep concaves and moderate-to-extreme rocker.</li> </ul> <p> </p> <p><strong>Fin Family</strong></p> <ul> <li>Carver: Find Power. Powerful, drawn-out turns with added hold.</li> </ul>	[empty string]	N	120	120	[empty string]	26171-DEFAULT-s.jpg	13	1000	FJSM-PC01-MD-TS-R	358894	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	fcs/fcs-ii-js-trifins-medium-358894	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Jute/Teal	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	104.99	0	104.99	26245-DEFAULT-l.jpg	104	26245-DEFAULT-m.jpg	Vf Rasta Hc Keel Fin Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	2	100-to-150	0.00	[empty string]	Futures Rasta Keel Fins	<p>The Rasta Keel was designed by free-surfing icon Dave Rastovich, as he made his own refinements to the classic keel design. Incorporating a layer of natural fiber jute there is an undeniable organic aesthetic, while increasing the stability of the base and leading edge. Rasta is known for riding alternative boards and this is his go-to fin for down the line speed in any twin fin.</p> <table cellspacing="0" class="specf-table" style="-webkit-text-stroke-width:0px; background-color:#ffffff; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:start; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; width:537.6px; word-spacing:0px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>24.59</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.77</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>6.87</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>V1</td> </tr> </tbody> </table>	[empty string]	N	105	105	[empty string]	26245-DEFAULT-s.jpg	16	1000	1525-942-20	364036	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-rasta-keel-fins-364036	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	FUTURE FINS	FUTURE FINS	SURF SHOP	SURF SHOP &GT; SURF ACCESSORIES &GT; FINS	119.99	0	119.99	26275-DEFAULT-l.jpg	119	26275-DEFAULT-m.jpg	F6 Honeycomb Quad Set	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Futures F6 Honeycomb Thruster Fins	<p>The F6 Honeycomb is a medium size Balanced fin with a Ride Number of 5.3. This set is a scaled up version of our popular F4 template. The F6 Honeycomb's subtle flex pattern creates the perfect amount of drive and the slightly refined tip provides for additional release off of the top. A great go-to set for medium sized surfers.</p> <div class="panel-group pdt-detail-panel" id="accordion" style="box-sizing:border-box; margin-bottom:20px"> <div class="each-panel-pdt panel panel-default" style="border-bottom:1px solid #dddddd; border-image:initial; border-left:none; border-radius:0px; border-right:none; border-top:none; box-shadow:none; box-sizing:border-box; margin-bottom:0px; margin-top:0px !important"> <div class="collapse in panel-collapse" id="collapse2" style="box-sizing:border-box; display:block"> <div class="panel-body" style="border-top:1px solid #dddddd; box-sizing:border-box; padding:17px 0px !important"> <div class="specification" style="box-sizing:border-box; color:#020202; font-family:Futura,sans-serif; font-size:15px; font-weight:normal; line-height:25px"> <table cellspacing="0" class="specf-table" style="background-color:transparent; border-collapse:collapse; border-spacing:0px; box-sizing:border-box; width:537.6px"> <tbody> <tr> <th> </th> <th style="text-align:left">Side Fins</th> <th style="text-align:left">Center Fin</th> </tr> <tr> <td style="width:134.4px">Area</td> <td>15.12</td> <td>15.12</td> </tr> <tr> <td style="width:134.4px">Height</td> <td>4.56</td> <td>4.56</td> </tr> <tr> <td style="width:134.4px">Base</td> <td>4.35</td> <td>4.35</td> </tr> <tr> <td style="width:134.4px">Foil</td> <td>FLAT</td> <td>SYMM</td> </tr> </tbody> </table> </div> </div> </div> </div> </div>	[empty string]	N	120	120	[empty string]	26275-DEFAULT-s.jpg	18	1000	1165-130-40	376929	FINS	EMPTY	EMPTY	0	0	0	SURF ACCESSORIES	future-fins/futures-f6-honeycomb-thruster-fins-376929	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
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	24	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 Stretch Fun Board Cover - Teal - 8 ' $58.00 | view details

FCS Fcs Ii Performer Neo Glass Tri- Quad Fins - Medium $120.00 | view details

FCS Fcs Ii Js Tri- Fins - Medium $120.00 | view details

FUTURE FINS Futures Rasta Keel Fins $105.00 | view details

FUTURE FINS Futures F6 Honeycomb Thruster Fins $120.00 | 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	Tamarindo,Scout	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	64.99	0	64.99	25888-DEFAULT-l.jpg	64	25888-DEFAULT-m.jpg	Boot Pack 50l	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Dakine Boot Pack 50L Snowboard and Ski Boot Bag	<p>The 50 liter Boot Pack has several roomy pockets for organizing and protecting your gear in transit. The dedicated helmet and goggle pocket is padded to protect against dings or scratches, and the zippered front cargo pocket is the perfect place to keep gloves, hats, tuning kits or an extra baselayer. The boot compartment stows ski or snowboard boots separately, and with easy access through the zippered rear-entry access panel. Securely transports your entire kit from the gear closet, to the car, to the resort, and back.</p> <ul> <li>Backpanel accessed, tarp lined ski/snowboard boot compartment</li> <li>Large, padded helmet and goggle pocket</li> <li>Zippered front cargo pocket</li> <li>ID patch</li> </ul>	[empty string]	N	65	65	[empty string]	25888-DEFAULT-s.jpg	24	1000	10001455-I	373449	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-boot-pack-50l-snowboard-and-ski-boot-bag-373449	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Carbon	DAKINE	DAKINE	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARD BAGS AND PACKS	89.99	0	89.99	25535-DEFAULT-l.jpg	89	25535-DEFAULT-m.jpg	Tour Bag	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FBA FILLS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMU	SMU	2018	[empty string]	OH at 200	[empty string]	4	50-to-100	0.00	[empty string]	Dakine Tour Snowboard Bag	<p>When weight (and cash) is your highest concern, ditch the wheels but keep the features with the Tour Snowboard Bag. Load up the main compartment with a board, pair of boots, and extra outerwear, then throw essential items like tuning kits in the exterior zippered pocket. 360-degree padding keeps hardgoods protected, while the removable padded shoulder strap and dual end handles make for easy transportation. And the Tour is impressively lightweight—less than 4 pounds. So even when toting a full kit, you won't rack up extra baggage fees. Plus, it packs down tight for easy storage when not in use.</p>	[empty string]	N	90	90	157,175	25535-DEFAULT-s.jpg	26	1000	10001467-C	357207	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARD BAGS AND PACKS	dakine/dakine-tour-snowboard-bag-357207	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	BLUDIGICMO	FISHMASKS	FISHMASKS	SNOWBOARDING	SNOWBOARDING &GT; OUTERWEAR &GT; WOMEN'S OUTERWEAR &GT; FACEMASKS	19.99	0	19.99	26190-DEFAULT-l.jpg	19	26190-DEFAULT-m.jpg	Blue Digi Camo Single Layer Neck Gaiter	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SP17	[empty string]	OH at 200	[empty string]	4	15-to-20	0.00	[empty string]	Fishmasks Single Layer Neck Gaiter, Blue Digi Camo	<p>Tried, tested, and true. Fishmasks Single Layer mask has been the go-to for many of our employees, athletes, and customers for years. A single piece of Phabric stands between you and the elements. Lightweight sun protection, perfect if you run hot or want a thinner option.</p>	<p>Fishmasks Single Layer Neck Gaiter - Lightweight, Fishing Protection From Sun, Wind And Moisture - Made In USA - UPF 50+ Moisture-Wicking Fabric - Blue Digi Camo</p>	N	19.99	19.99	[empty string]	26190-DEFAULT-s.jpg	26	1000	FSH-SL-BLUEDIGICAMO	359390	WOMENS OUTERWEAR	FACEMASKS	EMPTY	0	0	0	OUTERWEAR	fishmasks/fishmasks-single-layer-neck-gaiter-blue-digi-camo-359390	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
4	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	509.99	0	509.99	26360-DEFAULT-l.jpg	509	26360-DEFAULT-m.jpg	Aura X	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]	6	500-and-over	0.00	[empty string]	Never Summer Aura X Women's Snowboard, 2018	<p>Never Summer Aura X Women's Snowboard, 2018</p>	[empty string]	N	509.99	509.99	151,155	26360-DEFAULT-s.jpg	47	1000	AURAX-H	359078	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-aura-x-womens-snowboard-2018-359078	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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]	ELECTRIC	ELECTRIC	SNOWBOARDING	SNOWBOARDING &GT; GOGGLES	159.99	0	159.99	25969-DEFAULT-l.jpg	159	25969-DEFAULT-m.jpg	Egg Dark Side Tort/Jet Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Electric Egg Ski/Snowboard Goggles, Dark Side Tort/Jet Black	<p>Electric Egg Ski / Snowboard Goggles, Dark Side Tort/Jet Black</p>	[empty string]	N	160	160	[empty string]	25969-DEFAULT-s.jpg	52	1000	EG2418203-JBLK	374595	EMPTY	EMPTY	EMPTY	0	0	0	GOGGLES	electric/electric-egg-ski-snowboard-goggles-dark-side-tort-jet-black-374595	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
6	[empty string]	NEVER SUMMER	NEVER SUMMER	SNOWBOARDING	SNOWBOARDING &GT; SNOWBOARDS	529.99	0	529.99	26340-DEFAULT-l.jpg	529	26340-DEFAULT-m.jpg	Instagator	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]	21	500-and-over	0.00	[empty string]	Never Summer Insta/Gator Snowboard, 2019	<p>Snap in and out of turns, spin like a machine, and rail like a train. Size your Gator smaller and improve your OVERALL performance. Amazing nimbility with stability is what 12mm of taper and massive surface area will do for you. All boards ride great in perfect conditions, now ride you can ride great ANYWHERE in ANY CONDITIONS. It’s a new world...adjust your stance width, placement, and angles for ride variations that fit the days mood, conditions, and style. You’d better get a Gator sooner rather than later. LT - Narrower version of the original.</p>	[empty string]	N	529.99	529.99	144,148,151,156,159	26340-DEFAULT-s.jpg	71	1000	INSTAGATOR-I	374737	EMPTY	EMPTY	EMPTY	0	0	0	SNOWBOARDS	never-summer/never-summer-insta-gator-snowboard-2019-374737	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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 Boot Pack 50l Snowboard And Ski Boot Bag $65.00 | view details

DAKINE Dakine Tour Snowboard Bag $90.00 | view details

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

NEVER SUMMER Never Summer Aura X Women's Snowboard, 2018 $509.99 | view details

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

NEVER SUMMER Never Summer Insta/Gator Snowboard, 2019 $529.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]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	149.99	0	149.99	25609-DEFAULT-l.jpg	149	25609-DEFAULT-m.jpg	Regulus All Black	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OH at 200	[empty string]	4	100-to-150	0.00	[empty string]	Nixon Regulus 46mm Watch, All Black	<p>Built to Last</p> <p>100m water-resistant case and pushers, 5-year battery life, and shock-absorbent materials withstand any terrain and condition.</p> <p>Covert Ops</p> <p>Silent mode option and adjustable backlight ensure your missions stay undercover.</p> <p>Double Time</p> <p>Dual chronograph functionality keeps track of every aspect of your operations.</p> <p>Strapped</p> <p>An articulated freeswing strap with Nixon’s patented locking looper strap you in for a fit that’s as comfortable as it is secure.</p>	[empty string]	N	150	150	[empty string]	25609-DEFAULT-s.jpg	4	1000	A1180001	372328	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-regulus-46mm-watch-all-black-372328	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
2	[empty string]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	59.99	0	59.99	14679-DEFAULT-l.jpg	59	14679-DEFAULT-m.jpg	Time Teller P Matte Black Surplus	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	R	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	UPDATE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Time Teller P Watch 40mm, Matte Black Surplus	<p>An original Nixon design, a tried and true crowd favorite.</p>	[empty string]	N	60	60	[empty string]	14679-DEFAULT-s.jpg	5	1000	A1191042	266473	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/time-teller-p-watch-40mm-matte-black-surplus-266473	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Red,Blue,Grey,Salt & Pepper,Black Salt & Pepper	NEVER SUMMER	NEVER SUMMER	ACCESSORIES	ACCESSORIES &GT; BEANIES	27.99	0	27.99	26402-DEFAULT-l.jpg	27	26402-DEFAULT-m.jpg	Nvr Smr Pom Beanie	N	MENS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	[empty string]	110	20-to-25	0.00	[empty string]	Never Summer NVR SMR Pom Beanie	<p>Keep warm with Never Summer's NVR SMR Pom beanie.</p>	[empty string]	N	24.99	28	[empty string]	26402-DEFAULT-s.jpg	5	1000	BNNVRSMR	329687	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	never-summer/never-summer-nvr-smr-pom-beanie-329687	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	Heather Beige	ARCADE	ARCADE	ACCESSORIES	ACCESSORIES &GT; BELTS	25.99	0	25.99	26512-DEFAULT-l.jpg	25	26512-DEFAULT-m.jpg	The Ranger Slim Belt	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AVAILABLE	[empty string]	[empty string]	[empty string]	STRETCH	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Arcade Ranger Slim Belt, Heather Beige	<p>The Ranger Slim Adventure belt is packed with all the great features of it’s bigger brothers but in a smaller package. This lightweight and low-profile belt is built with elastic stretch webbing for a superior fit and ultimate comfort. A perfect fit and one size fits most come from a micro-adjust buckle. No metal means that airport security becomes a breeze. A minimal buckle and a slimmed down webbing allows this adventure belt to fit through smaller belt loops. Made from quick-drying and machine washable materials mean this tough little Ranger is your ultimate outdoor companion.</p> <ul> <li>One size fits most, up to 40″ (101.6cm)</li> <li>Narrower width for smaller belt loops</li> <li>Travel-Friendly Belt</li> <li>width – 1.25″ (3.17cm)</li> </ul>	[empty string]	N	26	26	[empty string]	26512-DEFAULT-s.jpg	8	1000	A21102-270	383724	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	arcade/arcade-ranger-slim-belt-heather-beige-383724	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]
5	[empty string]	NIXON	NIXON	ACCESSORIES	ACCESSORIES &GT; WATCHES	149.99	0	149.99	25669-DEFAULT-l.jpg	149	25669-DEFAULT-m.jpg	Sentry Leather Black/Camo/Volt	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]	Nixon Sentry Leather Watch 42mm, Black/Camo/Volt	<p>Nixing the status quo of what you may expect when it comes to classically good-looking timepieces, the Sentry Leather has entered the room and raised the bar.</p>	[empty string]	N	150	150	[empty string]	25669-DEFAULT-s.jpg	10	1000	A1053054	376185	EMPTY	EMPTY	EMPTY	0	0	0	WATCHES	nixon/nixon-sentry-leather-watch-42mm-black-camo-volt-376185	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	ACCESSORIES	ACCESSORIES &GT; SUNGLASSES	27.99	0	27.99	27200-DEFAULT-l.jpg	27	27200-DEFAULT-m.jpg	Portal 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]	UPDATE	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Dot Dash Portal Sunglasses, Black/Grey Polarized	<form action="https://www.dot-shades.com/cart" id="CartIndexForm" method="post"> <ul> <li>Polarized Lens</li> <li>100% UV 400 Protection</li> <li>Polycarbonate Frame</li> <li>Base-6 Polycarbonate Lens</li> <li>Integrated Sport Pin Hinge</li> </ul> </form>	[empty string]	N	28	28	[empty string]	27200-DEFAULT-s.jpg	12	1000	DSLRFPOR-BKG	283112	EMPTY	EMPTY	EMPTY	0	0	0	SUNGLASSES	dot-dash/dot-dash-portal-sunglasses-black-grey-polarized-283112	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]