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	PINE	DUCK HEAD	Duck Head	CLOTHING	Clothing	PINE\|NULL\|NULL	1	26.99	1	9.99	10559-DEFAULT-l.jpg	26.99	10559-DEFAULT-m.jpg	DUCK HEAD CIRCLE PATCH TRUCKER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5747	.DUCKHEADCIRCLEPATCHTRUCKER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	5-to-10	0.00	[empty string]	Duck Head Circle Patch Trucker Hats	<p><strong>DETAILS</strong>:</p><ul><li>60% Cotton, 40% Polyester</li><li>Felt Appliqu Embroidered Logo</li><li>Mid-Crown Fit</li><li>Mesh Back</li><li>Iconic Gold Tab Label</li><li>Antique Brass Adjustable Buckle</li></ul>	[empty string]	Y	9.99	9.99	OS	10559-DEFAULT-s.jpg	[empty string]	1000	1000	D41007	73120	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-head/duck-head-circle-patch-trucker-hats-73120	D41007	0
2	SAND,STONE	DUCK HEAD	Duck Head	CLOTHING	Clothing	SAND\|NULL\|NULL,STONE\|NULL\|NULL	1	39.99	1	19.99	18367-DEFAULT-l.jpg	39.99	18367-DEFAULT-m.jpg	DUCK HEAD MNS 9 GOLD SCHOOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5747	.DUCKHEAD9INGOLDSCHOOLSHORT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Duck Head Mens 9" Gold School Shorts	<p>The Duck Head Gold School Short shares every detail with our full-length chino. Same signature button, same drill cloth interior, and same 7.5 oz. cotton twill with a trace of functional stretch. The 9" inseam sits perfectly above the knee making them perfect for summer days in the low country, at the beach, or on the links. </p>	[empty string]	Y	19.99	34.99	40	18367-DEFAULT-s.jpg	[empty string]	1000	1000	D61002	73123	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-head/duck-head-mens-9-gold-school-shorts-73123	D61002	0
3	STONE	DUCK HEAD	Duck Head	CLOTHING	Clothing	STONE\|NULL\|NULL	1	69.99	1	19.99	18372-DEFAULT-l.jpg	69.99	18372-DEFAULT-m.jpg	DUCK HEAD MNS 7 FIELD CANVAS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5747	.DUCKHEAD7INFIELDCANVASSHOR	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Duck Head Mens 7" Field Canvas Shorts	<p>The Duck Head 7" Field Canvas Camp Short is a durable and versatile choice for days on the go. Made from the same high-quality fabric as our bestselling Field Canvas Five-Pocket pants, these shorts are built to last. The performance canvas material is soft and comfortable, with a seven inch inseam that gives you just the right amount of coverage. The moisture-wicking and breathable properties make these shorts ideal for hot, humid conditions. With an old-school aesthetic that never goes out of style, this short is a classic choice for any outdoor enthusiast. Easily transitioning from hitting the trails to lounging around the camp, these shorts are sure to become a go-to in your wardrobe. </p>	[empty string]	Y	19.99	19.99	30	18372-DEFAULT-s.jpg	[empty string]	1000	1000	D61009	73124	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-head/duck-head-mens-7-field-canvas-shorts-73124	D61009	0
4	GUNMETAL	DUCK HEAD	Duck Head	CLOTHING	Clothing	GUNMETAL\|NULL\|NULL	1	59.99	1	49.99	10569-DEFAULT-l.jpg	59.99	10569-DEFAULT-m.jpg	DUCK HEAD MNS FIELD CANVAS 5PK	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5747	.DUCKHEADFIELDCANVAS5PKTPA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Duck Head Five-Pocket Field Canvas Pants	<p>Our 1865-Pocket Chino taps Duck Head's rich 150-year history in both spirit and design. Familiar are the signature details borrowed from our Gold School Chino to include branded buttons, leather patches, and fortifying tacks. The 9.4 oz canvas functions with 2% flex through key stress points while being slightly heavier than our traditional 7.1 oz 1865 Five-Pocket Pinpoint Canvas. A proprietary fabrication assists in regulating the temperature of the wearer by keeping cool in the heat but warm during cooler temperatures. The classic fit mirrors the Gold School Chino and wears perfectly with a boot, shoe, or loafer.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>9.4 oz. Stretch Canvas</li><li>73% Cotton/25% Polyester/2% Spandex</li><li>Garment Washed</li><li>Classic Fit (Not Full, Not Slim)</li><li>Breathable & Moisture Wicking</li><li>Proprietary Fabrication Keeps Wearer Cool in the Heat & Warm in the Cold</li><li>Iconic Gold Label on Coin Pocket</li><li>Nubuck Leather Patch</li><li>Antique Brass Rivet Button</li><li>YKK Zipper</li><li>Duck Head Metal Rivets on Front Pockets</li><li>Drill Cloth Pocketing</li><li>Triple Stitched Seams</li><li>Signature "Z" Stitched Inside Fly</li><li>Machine wash cold with like colors on gentle & tumble dry low. As needed, use a cool iron avoiding embellishment.</li></ul>	[empty string]	Y	49.99	49.99	40	10569-DEFAULT-s.jpg	[empty string]	1000	1000	D91006	73125	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-head/duck-head-five-pocket-field-canvas-pants-73125	D91006	0
5	TOBACCO_BROWN	DUCK HEAD	Duck Head	CLOTHING	Clothing	TOBACCO_BROWN\|NULL\|NULL	1	49.99	0	49.99	10572-DEFAULT-l.jpg	49.99	10572-DEFAULT-m.jpg	DUCK HEAD MNS CORDUROY 5 PKT P	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5747	.DUCKHEADCORDUROY5PKTPANT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Duck Head Holston Corduroy Five-pocket Pants	<p>Our 1865 Corduroy combines our 150 years of producing the foundation of a man's wardrobe with a fabric that has a history nearly as rich. The 1865 Corduroy Five-Pocket Pant features the durability and sophistication of this historic fabric, while holding on to the signature details of Duck Head. The 1865 Corduroy Five-Pocket Pant is the best of both worlds- classic sophistication with rugged durability.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>8.1 oz. Stretch Corduroy</li><li>98% Cotton/2% Spandex</li><li>Garment Washed</li><li>18 Wale</li><li>Classic Fit (Not Full, Not Slim)</li><li>Iconic Gold Label on Coin Pocket</li><li>Nubuck Leather Patch</li><li>Antique Brass Rivet Button</li><li>YKK Zipper</li><li>DH Metal Rivets on Front Pockets</li><li>Drill Cloth Pocketing</li><li>Triple Stitched Seams</li><li>Imported</li><li>Machine wash cold with like colors on gentle & tumble dry low. As needed, use a cool iron avoiding embellishment.</li></ul>	[empty string]	N	49.99	49.99	38	10572-DEFAULT-s.jpg	[empty string]	1000	1000	D91008	73126	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-head/duck-head-holston-corduroy-five-pocket-pants-73126	D91008	0
6	KHAKI	DUCK HEAD	Duck Head	CLOTHING	Clothing	KHAKI\|NULL\|NULL	1	59.99	1	49.99	15613-DEFAULT-l.jpg	59.99	15613-DEFAULT-m.jpg	DUCK HEAD MNS SHORELINE TWILL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5747	.DUCKHEADSHORELINETWILL5PKP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Duck Head Shoreline Twill 5pkp	<p class="center">Duck Head Shoreline Twill 5pkp </p>	[empty string]	Y	49.99	49.99	40	15613-DEFAULT-s.jpg	[empty string]	1000	1000	D91015	73128	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-head/duck-head-shoreline-twill-5pkp-73128	D91015	0
7	TOBACCO_BROWN	DUCK HEAD	Duck Head	CLOTHING	Clothing	TOBACCO_BROWN\|NULL\|NULL	1	64.99	1	49.99	15615-DEFAULT-l.jpg	64.99	15615-DEFAULT-m.jpg	DUCK HEAD MNS CORDUROY 5 PKT P	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5747	.DUCKHEADCORDUROY5PKTPANT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Duck Head Holston Corduroy Five-pocket Pants	<p>Our 1865 Corduroy combines our 150 years of producing the foundation of a man's wardrobe with a fabric that has a history nearly as rich. The 1865 Corduroy Five-Pocket Pant features the durability and sophistication of this historic fabric, while holding on to the signature details of Duck Head. The 1865 Corduroy Five-Pocket Pant is the best of both worlds- classic sophistication with rugged durability.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>8.1 oz. Stretch Corduroy</li><li>98% Cotton/2% Spandex</li><li>Garment Washed</li><li>18 Wale</li><li>Classic Fit (Not Full, Not Slim)</li><li>Iconic Gold Label on Coin Pocket</li><li>Nubuck Leather Patch</li><li>Antique Brass Rivet Button</li><li>YKK Zipper</li><li>DH Metal Rivets on Front Pockets</li><li>Drill Cloth Pocketing</li><li>Triple Stitched Seams</li><li>Imported</li><li>Machine wash cold with like colors on gentle & tumble dry low. As needed, use a cool iron avoiding embellishment.</li></ul>	[empty string]	Y	49.99	49.99	40	15615-DEFAULT-s.jpg	[empty string]	1000	1000	D91019	73129	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	duck-head/duck-head-holston-corduroy-five-pocket-pants-73129	D91019	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts143 ORDER BY sortposition asc