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]	ENERGIZER	Energizer	HUNTING	Hunting	[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	EMPTY	energizer/rayovac-max-lantern-battery-6v-alkaline-132852	529-1	0
2	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting	[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
3	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting	[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
4	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting	[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
5	[empty string]	ENERGIZER	Energizer	HUNTING	Hunting	[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
6	[empty string]	WICKED TRE GEAR	Wicked Tre Gear	HUNTING	Hunting	[empty string]	1	39.99	1	29.99	859-DEFAULT-l.jpg	39.99	859-DEFAULT-m.jpg	WICKED TOUGH HAND SAW	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4279	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Wicked Tough Hand Saw	<p>The toughest hand saw on Earth. Our Wicked Tough hand saw features a cast aluminum handle and hardened locking hardware along with our Wicked high carbon steel blade. All backed by our Lifetime Warranty.</p><ul><li>Rugged cast aluminum handle construction</li><li>Wicked high carbon steel blade - taper ground, heavy gauge resists bending and breaking</li><li>Comfortable non-slip rubber over-mold grip design is ergonomically designed to fit your hand</li><li>Fail Safe Blade Lock Design with hardened steel lock-pin and hardware - NO PLASTIC to break</li><li>Lifetime Warranty, excludes blade</li><li>Closed Length: 8.25in. - Blade Length: 7.0 in.</li><li>Weight: 0.50 lbs.</li><li>Available with black or yellow grip</li><li>Designed, Engineered, 100% Quality Assured & Packaged in the USA. Manufactured in China.</li><li>Assembled in the USA w/ US and Global Parts</li></ul>	[empty string]	Y	29.99	29.99	[empty string]	859-DEFAULT-s.jpg	[empty string]	1000	1000	WTG001	164778	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	wicked-tre-gear/wicked-tough-hand-saw-164778	WTG001	0
7	[empty string]	SPORTSMAN`S VIEW	Sportsman`s View	HUNTING	Hunting	[empty string]	1	19.99	0	19.99	8261-DEFAULT-l.jpg	19.99	8261-DEFAULT-m.jpg	WISE EYE LONG RANGE ANTENNA	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2050	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	WiseEye Long Range Antenna	<p>Wise Eye Long Range Antenna </p><p>To help you get reception even in bad cellular areas</p>	[empty string]	N	19.99	19.99	[empty string]	8261-DEFAULT-s.jpg	[empty string]	1000	1000	WELONGRANT-1	190295	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sportsman-s-view/wiseeye-long-range-antenna-190295	WELONGRANT-1	0
8	[empty string]	SPORTSMAN`S VIEW	Sportsman`s View	HUNTING	Hunting	[empty string]	1	14.99	0	14.99	8262-DEFAULT-l.jpg	14.99	8262-DEFAULT-m.jpg	WISE EYE 12V BATTERY CABLE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2050	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	WiseEye 12V Battery Terminal Connector	<p>Connect your Smart Cam to the terminals of a 12V external battery.</p>	[empty string]	N	14.99	14.99	[empty string]	8262-DEFAULT-s.jpg	[empty string]	1000	1000	WETERMCON-1	190297	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sportsman-s-view/wiseeye-12v-battery-terminal-connector-190297	WETERMCON-1	0
9	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	34.99	0	34.99	24082-DEFAULT-l.jpg	34.99	24082-DEFAULT-m.jpg	ZINK CALL 2044 DUCK CALL	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Zink Power Hen PH-2 Polycarbonate Mallard Call In Mossy Oak Shadow Grass Blades	<p>The PH-2 takes the proven duck killing sounds that the Power Hen is known for in a double reed design that will not squeak or crack at the top end. This call is very user friendly and the sound is pure duck, making this the call for the serious waterfowl hunter. Great for close in calling or late season call shy ducks.</p><p> </p>	[empty string]	N	34.99	34.99	[empty string]	24082-DEFAULT-s.jpg	[empty string]	1000	1000	2044	224696	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-power-hen-ph-2-polycarbonate-mallard-call-in-mossy-oak-shadow-grass-blades-224696	2044	0
10	[empty string]	ZINK CALLS	Zink Calls	HUNTING	Hunting	[empty string]	1	11.99	0	12.99	10753-DEFAULT-l.jpg	11.99	10753-DEFAULT-m.jpg	ZINK SIGNATURE SERIES V NOTCH	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2383	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Zink Signature Series \| V Notch	<p><strong>DESCRIPTION:</strong></p><p>The Zink Signature Series V-Notch is stretched to a tight tension with heavy latex, the V-notched top reed and short-notched lower reed create a full range of turkey sounds. Whether you want loud, raspy volume or clear, quiet coaxing, the Josh Grossenbacher Signature does it all and then some.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>V-notch cut triple reed</li><li>Tight tension</li><li>Short-notched lower reed</li><li>Great range from raspy to clear</li><li>Heavy latex for far-reaching, loud sounds</li><li>Custom built by hand</li></ul>	[empty string]	N	12.99	12.99	[empty string]	10753-DEFAULT-s.jpg	[empty string]	1000	1000	229	224698	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	zink-calls/zink-signature-series-v-notch-224698	229	0

CACHED

false

EXECUTIONTIME

SQL

SELECT top 10 style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage , CASE WHEN isNull(max(weighted_search),0) = 1 THEN 900000000 ELSE 0 END as weighted_search FROM web_all_products WHERE 1=1 --AND pictureid is not null and ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS