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	TIMBER	DR DUCK	Dr Duck	UNCATEGORIZED	Uncategorized	TIMBER\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	DR DUCK HANDWARMER	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5680	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Dr Duck Handwarmer	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	1000	DDHW-1959T	99278	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dr-duck/dr-duck-handwarmer-99278	DDHW-1959T	0
2	[empty string]	DR DUCK	Dr Duck	UNCATEGORIZED	Uncategorized	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	DR DUCK WADER BAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5680	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Dr Duck Wader Bag	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	1000	DDWB-1947T	99282	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dr-duck/dr-duck-wader-bag-99282	DDWB-1947T	0
3	[empty string]	ENERGIZER	Energizer	UNCATEGORIZED	Uncategorized	[empty string]	1	6.99	0	6.99	37368-DEFAULT-l.jpg	6.99	37368-DEFAULT-m.jpg	ENERGIZER 2032BP2 BATTERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4267	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	16	5-to-10	0.00	[empty string]	Energizer 2032BP2 CR2032 Lithium Battery Silver 3.0 V 235 mAh, Qty (2) Single Pack	<p>The Energizer 2032. Used in heart-rate monitors, keyless entry, glucose monitors, toys & games. The Worlds #1 Longest Lasting 2032 Battery! Used in heart-rate monitors, keyless entry, glucose monitors, toys & games. Holds power for up to 10 years in storage. Replacement for: 5004LC, BR2032, DL2032, ECR2032, ST-T15.</p>	[empty string]	N	6.99	6.99	[empty string]	37368-DEFAULT-s.jpg	[empty string]	1000	1000	2032BP2	132847	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	energizer/energizer-2032bp2-cr2032-lithium-battery-silver-3-0-v-235-mah-qty-2-single-pack-132847	2032BP2	0
4	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting>Feeders & Seeders>Accessories	[empty string]	1	16.99	0	17.99	27838-DEFAULT-l.jpg	16.99	27838-DEFAULT-m.jpg	ENERGIZER 529-1 BATTERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4267	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	15-to-20	0.00	[empty string]	Rayovac Max Lantern Battery \| 6v Alkaline	<p>Metal jacket, operating temperature of 0 to 130 deg f. 26,000 mah to 0.8 v.</p>	[empty string]	N	17.99	17.99	[empty string]	27838-DEFAULT-s.jpg	[empty string]	1000	1000	529-1	132852	EMPTY	EMPTY	EMPTY	0	0	0	FEEDERS & SEEDERS	energizer/rayovac-max-lantern-battery-6v-alkaline-132852	529-1	0
5	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting>Cameras>Accessories	[empty string]	1	19.99	0	22.99	10625-DEFAULT-l.jpg	19.99	10625-DEFAULT-m.jpg	ENERGIZER E91LP16 BATTERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4267	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	16	20-to-25	0.00	[empty string]	Rayovac AA Max 1.5 Volts Alkaline	<p><strong>DESCRIPTION:</strong></p><p>The Energizer Max AA batteries are not only long lasting AA batteries they are complete with leak resistance and performance in extreme temperatures. Holds power up to 10 years in storage.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Rayovac</li><li>Category Batteries</li><li>Model AA</li><li>Series Max</li><li>Rechargeable No</li><li>ANSI NEDA 24A</li><li>Chemical Composition Alkaline</li><li>Nominal Voltage 1.5 Volt</li></ul>	[empty string]	N	22.99	22.99	[empty string]	10625-DEFAULT-s.jpg	[empty string]	1000	1000	E91LP16	132859	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	energizer/rayovac-aa-max-1-5-volts-alkaline-132859	E91LP16	0
6	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting>Cameras>Accessories	[empty string]	1	11.99	0	13.99	27837-DEFAULT-l.jpg	11.99	27837-DEFAULT-m.jpg	ENERGIZER E91MP8 BATTERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4267	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	44	10-to-15	0.00	[empty string]	Energizer Max 1.5v Alkaline AA 8 Pack	<p>Energizer Max AA batteries are not only long-lasting AA batteries they are complete with leak resistance and performance in extreme temperatures. Holds power for up to 10 years in storage.</p><p> </p>	[empty string]	N	13.99	13.99	[empty string]	27837-DEFAULT-s.jpg	[empty string]	1000	1000	E91MP8	132860	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	energizer/energizer-max-1-5v-alkaline-aa-8-pack-132860	E91MP8	0
7	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting>Cameras>Accessories	[empty string]	1	9.99	0	9.99	27836-DEFAULT-l.jpg	9.99	27836-DEFAULT-m.jpg	ENERGIZER E92BP BATTERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4267	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	5-to-10	0.00	[empty string]	Rayovac Max 1.5v Alkaline \| AAA 4 Pack	<p><strong>Key Features</strong></p><ul><li>Protects against damaging leaks for up to 2 years after fully used when left in low-drain devices</li><li>Holds power for up to 10 years in storage</li><li>No added mercury or cadmium</li></ul><p>Formulated to provide dependable, long-lasting power. use in toys, audio devices, flashlights, electronic devices, remote control communication devices, smoke detectors and security systems. plastic label jacket. up to 80% capacity remaining after 7 years of storage. 1.5 v, 25 ma continuous drain at rated capacity. operating temperature 0 to 130 deg f. carded.</p>	[empty string]	N	9.99	9.99	[empty string]	27836-DEFAULT-s.jpg	[empty string]	1000	1000	E92BP	132861	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	energizer/rayovac-max-1-5v-alkaline-aaa-4-pack-132861	E92BP	0
8	[empty string]	ENERGIZER	Energizer	UNCATEGORIZED	Uncategorized	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	ENERGIZERE93BP-4 BATTERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4267	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Rayovac Max 1.5v Alkaline C 4 Pack	[empty string]	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	1000	E93BP-4	132864	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	energizer/rayovac-max-1-5v-alkaline-c-4-pack-132864	E93BP-4	0
9	[empty string]	ENERGIZER	Energizer	NEW BUILDS	New Builds	[empty string]	1	29.99	0	31.99	36166-DEFAULT-l.jpg	29.99	36166-DEFAULT-m.jpg	ENERGIZER L91BP8 BATTERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4267	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Energizer Ultimate 1.5v Lithium AA 8 Pack	<ul><li>8-pack of Energizer Ultimate Lithium AA batteries</li><li>Energizer Ultimate Lithium is the Longest-Lasting AA Battery</li><li>Leak-proof construction protects the devices you love (based on standard use)</li><li>Powers your most critical devices -- Ideal for your smart home devices, outdoor surveillance systems, digital cameras, and handheld games</li><li>Holds power up to 25 years in storage for trustworthy backup energy, so you're always prepared</li></ul>	[empty string]	N	31.99	31.99	[empty string]	36166-DEFAULT-s.jpg	[empty string]	1000	1000	L91BP8	132875	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	energizer/energizer-ultimate-1-5v-lithium-aa-8-pack-132875	L91BP8	0
10	[empty string]	TRU BALL	Tru Ball	UNCATEGORIZED	Uncategorized	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	TRU BALL AXCEL ARMORTECH	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	618	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	Tru Ball Axcel Armortech Vision 4 Pin 0.019	[empty string]	[empty string]	N	209.99	209.99	[empty string]	[empty string]	[empty string]	1000	1000	AVAT-N419-BK	162357	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	tru-ball/tru-ball-axcel-armortech-vision-4-pin-0-019-162357	AVAT-N419-BK	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc