Simmons' Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	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	SOLD	SORTPOSITION	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH
1	TAN_BROWN	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Men	TAN_BROWN\|NULL\|NULL	1	130	1	69.99	12197-DEFAULT-l.jpg	130	12197-DEFAULT-m.jpg	SPERRY MNS COLD BAY LACE UP BO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYMNSCOLDBAYLACEUPBO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Sperry Men's Cold Bay Duck Boots	<p><strong>DESCRIPTION</strong>:</p><p>The all-in-one, everyday boot with weather-ready technology. It has water resistance, dependable traction and toasty yet lightweight insulation. The whole nine yards. Trust us, your feet will notice the difference.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>Durable stain-and-water-resistant full-grain leather uppers feature a nylon lace</li><li>Fully-lined shaft with 200G of Thinsulate for extra warmth</li><li>Injected foam EVA shell provides protection from the elements</li><li>Razor-Cut Wave-Siping on non-marking rubber outsoles won't scuff floors but gives you sure footing, from boat deck to back deck</li></ul>	[empty string]	Y	69.99	69.99	12,13,9,10,11	12197-DEFAULT-s.jpg	[empty string]	1000	1000	STS19551	78424	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-men-s-cold-bay-duck-boots-78424	STS19551	0
2	BROWN_COFFEE	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Men	BROWN_COFFEE\|NULL\|NULL	1	120	1	84	12203-DEFAULT-l.jpg	120	12203-DEFAULT-m.jpg	SPERRY MNS COLD BAY CHUKKA	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYMNSCOLDBAYCHUKKA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Sperry Men's Cold Bay Chukka	<p><strong>DESCRIPTION</strong>:</p><p>Look no further for the perfect ankle-height boot to wear when the ground is covered in ice and snow. Our best-selling winter duck chukka combines molded Wave-Siping for enhanced traction with a waterproof rubber shell and Thinsulate lining for added warmth.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>Waterproof rubber shell</li><li>Microfleece-lined with 200g Thinsulate for added warmth</li><li>Non-marking rubber lug outsole with Signature Sperry molded Wave-Siping for enhanced traction</li></ul>	[empty string]	Y	84	84	12,10	12203-DEFAULT-s.jpg	[empty string]	1000	1000	STS19556	78425	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-men-s-cold-bay-chukka-78425	STS19556	0
3	CHOCOLATE	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Men	CHOCOLATE\|NULL\|NULL	1	70	1	39.99	15952-DEFAULT-l.jpg	70	15952-DEFAULT-m.jpg	SPERRY MNS MALCOLM SLIP ON	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYMNSMALCOLMSLIPON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Sperry Mens Malcolm Slip On	[empty string]	[empty string]	Y	39.99	39.99	8	15952-DEFAULT-s.jpg	[empty string]	1000	1000	STS24755	78433	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-mens-malcolm-slip-on-78433	STS24755	0
4	TAN_NAVY	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Women	TAN_NAVY\|NULL\|NULL	1	140	1	69.99	17026-DEFAULT-l.jpg	140	17026-DEFAULT-m.jpg	SPERRY WMS MARITIME SNOW BOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYWMSMARITIMESNOWBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Sperry Womens Maritime Snow Boot	[empty string]	[empty string]	Y	69.99	69.99	11	17026-DEFAULT-s.jpg	[empty string]	1000	1000	STS82664	78447	WOMEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-womens-maritime-snow-boot-78447	STS82664	0
5	SAND	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Women	SAND\|NULL\|NULL	1	140	1	69.99	15557-DEFAULT-l.jpg	140	15557-DEFAULT-m.jpg	SPERRY WMS MARITIME SNOW BOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYWMSMARITIMESNOWBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Sperry Womens Maritime Snow Boot	[empty string]	[empty string]	Y	69.99	69.99	10	15557-DEFAULT-s.jpg	[empty string]	1000	1000	STS84000	78450	WOMEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-womens-maritime-snow-boot-78450	STS84000	0
6	TAN	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Women	TAN\|NULL\|NULL	1	160	1	79.99	4236-DEFAULT-l.jpg	160	4236-DEFAULT-m.jpg	SPERRY WMS SALTWATER WOOL BOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYWMSSALTWATERWOOLBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Sperry Women's Saltwater Wool Embossed Duck Boots with Thinsulate	<p><strong>DESCRIPTION</strong>:</p><p class="center">Your favorite boot is now ready for fall with cozy wool to match the classic waterproof rubber duck shell. Land or sea, they're ready to take on adventure -- and elevate your wardrobe with an iconic shoe. Why not look stylish while also living your coziest life?</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>Duck-inspired boot with wool upper</li><li>Water resistant upper and waterproof rubber shell keeps feet dry on rainy days</li><li>Mid-height 6" shaft. Just tall enough</li><li>Barrel tied rawhide laces</li><li>Rust proof eyelets</li><li>Full lined Micro-fleece with Thinsulate for warmth underfoot</li><li>Side zipper for easy on and off allows laces to remain tied</li><li>Wave-Siping non-marking, rubber outsoles won't scuff floors but gives you sure footing, from boat deck to back deck</li></ul>	[empty string]	Y	79.99	79.99	5	4236-DEFAULT-s.jpg	[empty string]	1000	1000	STS84371	78456	WOMEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-women-s-saltwater-wool-embossed-duck-boots-with-thinsulate-78456	STS84371	0
7	IVORY	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Women	IVORY\|NULL\|NULL	1	105	1	54.99	3843-DEFAULT-l.jpg	105	3843-DEFAULT-m.jpg	SPERRY WMS SALTWATER 1 EYE BOO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYWMSSALTWATER1EYEBOO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Sperry Women's Saltwater 1-Eye Duck Boots	<p>Unexpected fall showers are no match for these iconic outfit-makers. Now with lower-profile 1-eye lacing, our classic leather duck boot makes heading out in a downpour look a lot more stylish. Who needs an umbrella?</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>The Saltwater is more than an all-weather boot -- it's an outfitmaking shoe wardrobe icon, now offered in a lower profile 1-eye with faux fur linings for added fun and warmth</li><li>Leather collar with rubber duck shell rawhide lacing with rust proof eyelets for secure fit</li><li>Micro-Fleece lining and non-marking rubber lugged outsole with Wave-Siping provides traction on wet and dry surfaces</li></ul>	[empty string]	Y	54.99	54.99	5,9,10	3843-DEFAULT-s.jpg	[empty string]	1000	1000	STS85834	78460	WOMEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-women-s-saltwater-1-eye-duck-boots-78460	STS85834	0
8	BLACK	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Women	BLACK\|NULL\|NULL	1	70	1	34.99	15946-DEFAULT-l.jpg	70	15946-DEFAULT-m.jpg	SPERRY WMS CAPE MAY SLIPPER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYWMSCAPEMAYSLIPPER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Sperry Womens Cape May Slipper	[empty string]	[empty string]	Y	34.99	34.99	5	15946-DEFAULT-s.jpg	[empty string]	1000	1000	STS87994	78472	WOMEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-womens-cape-may-slipper-78472	STS87994	0
9	TAN_DARK_BROWN	SPERRY	Sperry	CLOTHING	Clothing>Footwear>Women	TAN_DARK_BROWN\|NULL\|NULL	1	108	1	79.99	4232-DEFAULT-l.jpg	108	4232-DEFAULT-m.jpg	SPERRY WMS SALTWATER DUCK BOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4761	.SPERRYWMSSALTWATERDUCKBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Sperry Women's Saltwater Duck Boots	<p>Back, by popular demand! Embrace the elements in duck inspired wet weather boots. With rawhide lacing for a secure fit and Wave-Siping for ultimate wet/dry traction, this versatile boot is ready for storm and sea. Get yours now, before they're gone!</p><ul><li>Duck Inspired Waterproof Boot</li><li>Mid height 6" shaft</li><li>Side Zipper for Easy On and Off</li><li>Barrel Tie Lacing Keeps Laces from Getting Untied</li><li>Rawhide Lacing with Rust Proof Eyelets for Secure Fit</li><li>Micro-Fleeced Lining Provides Warmth Under Foot</li><li>Non-Marking Rubber Lugged Outsole with Wave-Siping for Ultimate Wet/Dry Traction</li><p> </p></ul>	[empty string]	Y	79.99	79.99	5,10	4232-DEFAULT-s.jpg	[empty string]	1000	1000	STS91176	78474	WOMEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	sperry/sperry-women-s-saltwater-duck-boots-78474	STS91176	0
10	[empty string]	AMERISTEP	Ameristep	UNCATEGORIZED	Uncategorized	[empty string]	1	0.99	0	0.99	2211-DEFAULT-l.jpg	0.99	2211-DEFAULT-m.jpg	AMERISTEP T HANDLE WRENCH	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	535	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	5-and-under	0.00	[empty string]	Ameristep T Handle Wrench	[empty string]	[empty string]	N	0.99	0.99	[empty string]	2211-DEFAULT-s.jpg	[empty string]	1000	1000	313	116500	TURKEY	EMPTY	EMPTY	0	0	0	EMPTY	ameristep/ameristep-t-handle-wrench-116500	313	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc