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	KHAKI	KUHL	Kuhl	SHOOTING	Shooting>Optics>Binoculars	KHAKI\|NULL\|NULL	1	99.99	0	99.99	987-DEFAULT-l.jpg	99.99	987-DEFAULT-m.jpg	KUHL MNS BURR VEST	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLMNSBURRVEST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	3	50-to-100	0.00	[empty string]	Kuhl Mens Burr Vest- 1042	<p>Style and comfort meet rugged durability. Made from a tough, 100% cotton canvas weave that features K HL's unique dye finish, the BURR Men's Vest gives you the versatility to adapt to changing weather conditions without overheating. Zippered pockets keep your valuables secure.</p>	[empty string]	N	99.99	99.99	2X,M	987-DEFAULT-s.jpg	[empty string]	1000	1000	1042	75124	VESTS	MEN	EMPTY	0	0	0	OPTICS	kuhl/kuhl-mens-burr-vest-1042-75124	1042	0
2	KHAKI	KUHL	Kuhl	CLOTHING	Clothing>Casual>Jackets & Hoodies>Men	KHAKI\|NULL\|NULL	1	139.99	0	139.99	5187-DEFAULT-l.jpg	139.99	5187-DEFAULT-m.jpg	KUHL MNS BURR JACKET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLMNSBURRJACKET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	11	100-to-150	0.00	[empty string]	Kuhl Men's Burr Jacket	<p>Always keep your sights on the next campsite. The BURR Men's Jacket blends technical performance with style to keep you ready for the next adventure. The 100% combed cotton canvas with K HL's exclusive patina finish looks sharp when running around town or getting out of dodge. If you're looking for a jacket with a timeless design and long-lasting construction, you've found it.</p><ul><li>Hand-warming pockets and chest pocket with zipper closure</li><li>Inside security pocket</li><li>Interior locker loop</li><li>Articulated shoulder</li><li>YKK zippers</li></ul>	[empty string]	N	139.99	139.99	L,XL,2X,M	5187-DEFAULT-s.jpg	[empty string]	1000	1000	1052	75125	JACKETS & HOODIES	MEN	EMPTY	0	0	0	EMPTY	kuhl/kuhl-men-s-burr-jacket-75125	1052	0
3	DRIFTWOOD	KUHL	Kuhl	CLOTHING	Clothing>Casual>Jackets & Hoodies>Men	DRIFTWOOD\|NULL\|NULL	1	179.99	1	94.99	18617-DEFAULT-l.jpg	179.99	18617-DEFAULT-m.jpg	KUHL MNS THE ONE HOODY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLMNSTHEONEJACKET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	1	50-to-100	0.00	[empty string]	Kuhl Mns The One Hoody	[empty string]	[empty string]	Y	94.99	94.99	XL	18617-DEFAULT-s.jpg	[empty string]	1000	1000	1146	75131	JACKETS & HOODIES	MEN	EMPTY	0	0	0	EMPTY	kuhl/kuhl-mns-the-one-hoody-75131	1146	0
4	GRAIN	KUHL	Kuhl	CLOTHING	Clothing>Casual>Jackets & Hoodies>Men	GRAIN\|NULL\|NULL	1	179.99	0	179.99	10869-DEFAULT-l.jpg	179.99	10869-DEFAULT-m.jpg	KUHL MNS OUTLAW WAXED JACKET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLOUTLAWWAXEDJACKET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	11	150-to-200	0.00	[empty string]	Kuhl Outlaw Waxed Jacket	<ul><li>Classic style that ages for vintage appeal</li><li>Tough, wax-coated cotton canvas that softens with wear</li><li>Wind and water resistance</li><li>Soft flannel lining provides next-to-skin comfort</li><li>Articulated design for freedom of motion</li><li>Zippered interior security pocket</li><li>Zippered hand pockets</li><li>Two button-down chest pockets</li><li>YKK Zippers throughout</li><li>Lined sleeves provide enhanced comfort and convenience</li></ul>	[empty string]	N	179.99	179.99	XL,2X,L,M	10869-DEFAULT-s.jpg	[empty string]	1000	1000	1184	75134	JACKETS & HOODIES	MEN	EMPTY	0	0	0	EMPTY	kuhl/kuhl-outlaw-waxed-jacket-75134	1184	0
5	ONYX	KUHL	Kuhl	UNCATEGORIZED	Uncategorized	ONYX\|NULL\|NULL	0	99.99	0	179.99	[empty string]	99.99	[empty string]	KUHL MNS REBEL INSULATED JACKET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLOUTLAWWAXEDJACKET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	3	150-to-200	0.00	[empty string]	Kuhl Mns Rebel Insulated Jacke	[empty string]	[empty string]	N	179.99	179.99	L,2X	[empty string]	[empty string]	1000	1000	1187	75135	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	kuhl/kuhl-mns-rebel-insulated-jacke-75135	1187	0
6	GRAIN	KUHL	Kuhl	UNCATEGORIZED	Uncategorized	GRAIN\|NULL\|NULL	1	199.99	1	129.99	800-DEFAULT-l.jpg	199.99	800-DEFAULT-m.jpg	KUHL MNS IMPAKT INSULATED JACK	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLOUTLAWWAXEDJACKET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Kuhl Mns Impakt Insulated Jack	[empty string]	[empty string]	Y	129.99	129.99	M	800-DEFAULT-s.jpg	[empty string]	1000	1000	1198	75136	GUN CLEANING	EMPTY	EMPTY	0	0	0	EMPTY	kuhl/kuhl-mns-impakt-insulated-jack-75136	1198	0
7	RAVEN	KUHL	Kuhl	UNCATEGORIZED	Uncategorized	RAVEN\|NULL\|NULL	1	89.99	0	89.99	18596-DEFAULT-l.jpg	89.99	18596-DEFAULT-m.jpg	KUHL WMS THE ONE JACKET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLWMSTHEONEJACKET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	7	50-to-100	0.00	[empty string]	Kuhl Wms The One Jacket	<p>Windproof yet highly breathable. Warm yet lightweight. Water-resistance with stretch. THE ONE Women's Jacket features K HL's temperature-regulating Aeroknit technology for breathable comfort and performance. Underarm knit gussets provide stretch and release excess heat during high output activity. Our articulated design directly results from comprehensive study of a body in motion. There is only one!</p><p>ATHLETIC FIT</p>	[empty string]	N	89.99	89.99	L,XL,M	18596-DEFAULT-s.jpg	[empty string]	1000	1000	2163	75142	JACKETS & HOODIES	WOMEN	EMPTY	0	0	0	EMPTY	kuhl/kuhl-wms-the-one-jacket-75142	2163	0
8	COPPER,SAGE	KUHL	Kuhl	CLOTHING	Clothing>Casual>Vests>Women	COPPER\|NULL\|NULL,SAGE\|NULL\|NULL	1	149.99	1	99.99	18609-DEFAULT-l.jpg	149.99	18609-DEFAULT-m.jpg	KUHL WMS CELESTE LINED VEST	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLWMSCELESTELINEDVEST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Kuhl Wms Celeste Lined Vest	[empty string]	[empty string]	N	99.99	149.99	L,S,M	18609-DEFAULT-s.jpg	[empty string]	1000	1000	2190	75144	VESTS	WOMEN	EMPTY	0	0	0	EMPTY	kuhl/kuhl-wms-celeste-lined-vest-75144	2190	0
9	GANACHE_COPPER	KUHL	Kuhl	CLOTHING	Clothing>Casual>Jackets & Hoodies>Women	GANACHE_COPPER\|NULL\|NULL	1	199.99	1	99.99	18613-DEFAULT-l.jpg	199.99	18613-DEFAULT-m.jpg	KUHL WMS CELESTE LINED HOODY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHLWMSCELESTELINEDHOODY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	2	50-to-100	0.00	[empty string]	Kuhl Wms Celeste Lined Hoody	[empty string]	[empty string]	Y	99.99	99.99	S,M	18613-DEFAULT-s.jpg	[empty string]	1000	1000	2193	75145	JACKETS & HOODIES	WOMEN	EMPTY	0	0	0	EMPTY	kuhl/kuhl-wms-celeste-lined-hoody-75145	2193	0
10	OATMEAL,MUTINY_BLUE_STEEL,STEEL	KUHL	Kuhl	CLOTHING	Clothing>Casual>Jackets & Hoodies>Men	OATMEAL\|NULL\|NULL,MUTINY_BLUE_STEEL\|NULL\|NULL,STEEL\|NULL\|NULL	1	99.99	0	99.99	5164-DEFAULT-l.jpg	99.99	5164-DEFAULT-m.jpg	KUHL MNS 1/4 ZIP PULLOVER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5513	.KUHL1-4ZIPPULLOVER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	11	50-to-100	0.00	[empty string]	Kuhl Men's Revel 1/4 Zip Pullovers - 3007	<p>Just because you're tough doesn't mean your clothes can't be soft. The REVEL Men's 1/4 Zip Sweater is incredibly soft yet durable. It's made with lightweight KASHMIRA performance fleece that dries quick, wicks away moisture and provides superior warmth. Technical and durable enough to go on any exploration, the design features a 1/4 zip that's functional and stylish. Stay warm and get soft with a ligthweight sweater that's better.</p><ul><li>K HL's exclusive articulated 5-panel sleeves for better range of motion</li><li>Interior locker loop</li><li>Soft hand, fine gauge yarn with a smooth face</li><li>Micro-soft interior collars for warmth and comfort</li><li>Imported</li></ul>	[empty string]	N	99.99	99.99	XL,2X,M,L	5164-DEFAULT-s.jpg	[empty string]	1000	1000	3007	75147	JACKETS & HOODIES	MEN	EMPTY	0	0	0	EMPTY	kuhl/kuhl-men-s-revel-1-4-zip-pullovers-3007-75147	3007	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc