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	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	189.99	0	189.99	11535-DEFAULT-l.jpg	189.99	11535-DEFAULT-m.jpg	HIGHVIEW TREESTANDS SIGHTLINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	55	150-to-200	0.00	[empty string]	Highview Treestands Sightline	<p><strong>SPECIFICATIONS: </strong></p><ul><li>Model #: HDV202</li><li>Stand Height: 15' </li><li>Platform Size: 36" W x 12" D</li><li>Seat Size: 36" W x 14" D</li><li>Weight Capacity: 500LBS.</li><li>Criss Cross Stabilizer Straps</li></ul>	[empty string]	N	189.99	189.99	[empty string]	11535-DEFAULT-s.jpg	[empty string]	1000	1000	HVD202	162288	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/highview-treestands-sightline-162288	HVD202	0
2	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	219.99	0	219.99	16575-DEFAULT-l.jpg	219.99	16575-DEFAULT-m.jpg	HIGHVIEW TREESTANDS MAXGRIP	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Highview Treestands Maxgrip Double Ladderstand	<p><strong>SPECIFICATIONS: </strong></p><ul><li>Model #: HDV207</li><li>Stand Height: 18'</li><li>Platform Size: 36" W x 12" D</li><li>Seat Size: 36" W x 14" D</li><li>Weight Capacity: 500LBS.</li><li>MAXGRIP cable safety system</li></ul>	[empty string]	N	219.99	219.99	[empty string]	16575-DEFAULT-s.jpg	[empty string]	1000	1000	HVD207	162289	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/highview-treestands-maxgrip-double-ladderstand-162289	HVD207	0
3	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	249.99	1	149.99	10735-DEFAULT-l.jpg	249.99	10735-DEFAULT-m.jpg	TROPHY TREESTAND HIGHVIEW SALE CLOSEOUT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	100-to-150	0.00	[empty string]	Trophy Treestand Highview	<p>TWO PERSON LADDERSTAND</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>Stand Height: 18 Feet</li><li>Ladder Sections: 3</li><li>Platform Size: 36" W x 12" D</li><li>Construction: Steel</li><li>Seat Size: 36"W x 14" D</li><li>Weight Capacity: 500 lbs</li><li>Flip-Up Shooting Rest</li><li>RATCHET STRAP & CRISS-CROSS STRAP</li></ul>	[empty string]	Y	149.99	149.99	[empty string]	10735-DEFAULT-s.jpg	[empty string]	1000	1000	TDL202	162291	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestand-highview-162291	TDL202	0
4	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	399.99	0	399.99	10734-DEFAULT-l.jpg	399.99	10734-DEFAULT-m.jpg	TROPHY TREESTAND AMIGO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	47	350-to-400	0.00	[empty string]	Trophy Treestand 16' Amigo Ladder Stand	<p>2 PERSON LADDERSTAND<br /> </p><ul><li>SPECIFICATIONS:</li><li>Stand Height: 16 Feet </li><li>Ladder Sections: 3</li><li>Platform Size: 38" W x 12" D</li><li>Construction: Steel</li><li>Seat Size: 38" W x 17" D</li><li>Backrest: 19" High</li><li>Weight Capacity: 500 lbs</li><li>Flip-Up Shooting Rest</li><li>Jaw Safety System</li></ul>	[empty string]	N	399.99	399.99	[empty string]	10734-DEFAULT-s.jpg	[empty string]	1000	1000	TDL215	162292	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestand-16-amigo-ladder-stand-162292	TDL215	0
5	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	169.99	1	149.99	10733-DEFAULT-l.jpg	169.99	10733-DEFAULT-m.jpg	TROPHY TREESTAND F-15	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	100-to-150	0.00	[empty string]	Trophy Treestand F15	<p><strong>SINGLE PERSON LADDERSTAND</strong></p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Stand Height: 16 Feet</li><li>Ladder Sections: 3</li><li>Platform Size: 19" W x 10" D</li><li>Construction: Steel</li><li>Seat Size: 20" W x 16" D</li><li>Weight Capacity: 300 lbs</li><li>Drawtight Cable System</li></ul>	[empty string]	Y	149.99	149.99	[empty string]	10733-DEFAULT-s.jpg	[empty string]	1000	1000	TL100	162297	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestand-f15-162297	TL100	0
6	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	199.99	1	129.99	7082-DEFAULT-l.jpg	199.99	7082-DEFAULT-m.jpg	TROPHY TREESTAND HORNET SALE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Trophy Treestand Hornet	<p><strong>SINGLE PERSON LADDERSTAND</strong></p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Stand Height: 18 Feet</li><li>Ladder Sections: 3</li><li>Platform Size: 19" W x 10" D</li><li>Construction: Steel</li><li>Seat Size: 19" W x 15" D</li><li>Weight Capacity: 300 lbs</li><li>Drawtight Cable System</li><li>Adjustable Padded Shooting Rail & Padded Armrests</li></ul>	[empty string]	Y	129.99	129.99	[empty string]	7082-DEFAULT-s.jpg	[empty string]	1000	1000	TL102	162298	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestand-hornet-162298	TL102	0
7	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	249.99	0	249.99	7083-DEFAULT-l.jpg	249.99	7083-DEFAULT-m.jpg	TROPHY TREESTAND STRIKE EAGLE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Trophy Treestand Strike Eagle	<p><strong>SINGER PERSON LADDERSTAND</strong></p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Stand Height: 18 Feet</li><li>Ladder Sections: 3</li><li>Platform Size: 17" W x 28" D</li><li>Construction: Steel</li><li>Seat Size: 17" W x 15" D</li><li>Backrest: 14" High</li><li>Weight Capacity: 300 lbs</li><li>Flip-up Seat</li><li>Adjustable Padded Shooting Rail & Padded Armrests</li><li>JAW SAFETY SYSTEM</li></ul>	[empty string]	N	249.99	249.99	[empty string]	7083-DEFAULT-s.jpg	[empty string]	1000	1000	TL104	162299	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestand-strike-eagle-162299	TL104	0
8	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	79.99	1	69.99	4650-DEFAULT-l.jpg	79.99	4650-DEFAULT-m.jpg	TROPHY TREESTAND GLADIATOR SALE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	21	50-to-100	0.00	[empty string]	Trophy Treestands Gladiator Sticks - Ts300	<p><strong>SPECIFICATIONS:</strong></p><ul><li>Stand Height: 20 Feet</li><li>Ladder Sections: 5</li><li>Weight Capacity: 300 lbs</li><li>Stand Weight: 21lbs</li></ul>	[empty string]	Y	69.99	69.99	[empty string]	4650-DEFAULT-s.jpg	[empty string]	1000	1000	TS300	162302	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestands-gladiator-sticks-ts300-162302	TS300	0
9	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	119.99	1	89.99	10737-DEFAULT-l.jpg	119.99	10737-DEFAULT-m.jpg	TROPHY TREESTAND TRICK STICK	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Trophy Treestand Trick Stick	<p><strong>CLIMBING STICK SYSTEM</strong></p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Weight: 4 pounds each</li><li>Dimensions: 32" H x 11" W</li><li>Sections: 4</li><li>Construction: Steel</li><li>Weight Capacity: 300 lbs</li></ul>	[empty string]	Y	89.99	89.99	[empty string]	10737-DEFAULT-s.jpg	[empty string]	1000	1000	TS305	162303	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestand-trick-stick-162303	TS305	0
10	[empty string]	TROPHYT	Trophyt	HUNTING	Hunting	[empty string]	1	599.99	0	599.99	6968-DEFAULT-l.jpg	599.99	6968-DEFAULT-m.jpg	TROPHY TREESTAND SKY FORT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5517	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	13	500-or-more	0.00	[empty string]	Trophy Treestand Sky Fort	<p>Model # TT803</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Seat: 3 flip-up seats</li><li>Construction: Steel</li><li>Height: 12' to shooting rail</li><li>Weight Capacity: 600 lbs</li><li>Roof and 1/2 Blind sold separately</li></ul>	[empty string]	N	599.99	599.99	[empty string]	6968-DEFAULT-s.jpg	[empty string]	1000	1000	TT803	162304	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	trophyt/trophy-treestand-sky-fort-162304	TT803	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts4 ORDER BY sortposition asc