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]	SAVAGE ARMS INC	Savage Arms Inc	ARCHERY	Archery	[empty string]	1	24.99	0	24.99	2279-DEFAULT-l.jpg	24.99	2279-DEFAULT-m.jpg	SAVAGE 30005 MAGAZINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	272	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Savage 60 Series 10 Round Magazine For .22 LR	<ul><li>Brand Savage Arms</li><li>Category Magazines</li><li>Caliber 22 LR</li><li>Model OEM</li><li>Capacity 10rd</li><li>Color Blued</li><li>Material Steel</li><li>Firearm Fit Savage 64 Series</li><li>Max Capacity 10</li></ul>	[empty string]	N	24.99	24.99	[empty string]	2279-DEFAULT-s.jpg	[empty string]	1000	1000	30005	207902	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	savage-arms-inc/savage-60-series-10-round-magazine-for-22-lr-207902	30005	0
2	[empty string]	HALO NOCKS	Halo Nocks	ARCHERY	Archery	[empty string]	1	34.99	0	34.99	33461-DEFAULT-l.jpg	34.99	33461-DEFAULT-m.jpg	HALO NOCK, MICRO, RED 3PK	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	26	25-to-50	0.00	[empty string]	Halo Nocks Micro \| Red - 3 Pack	<p>With "no-fail" internal components and bowstring activated dependability, Halo Nock provides superior, dependable performance with every shot. Sold in a 3 Pack.</p><p><strong>SIZE GUIDE</strong></p><ul><li>MICRO- Fits micro arrow IDs of .165"-.166"</li><li>FIT- A multi-fit package with bushing adapters to fit most common arrow IDs of .204", .233", and .244"-.246</li></ul><p>Halo Nock provides superior, dependable performance with every shot. Their patent pending design wont accidentally turn on when placing on your bowstring. No matter how hard you push on the nock, it won't activate until it leaves the string. In addition, this innovative design avoids any risk of a "mini-dry fire" that can occur with other lighted nocks that slip forward during release. Halo Nock is refreshingly simple to use and available in a variety of colors and sizes.</p>	[empty string]	N	34.99	34.99	[empty string]	33461-DEFAULT-s.jpg	[empty string]	1000	1000	HN-1503	251968	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	halo-nocks/halo-nocks-micro-red-3-pack-251968	HN-1503	0
3	[empty string]	HALO NOCKS	Halo Nocks	ARCHERY	Archery	[empty string]	1	34.99	0	34.99	33457-DEFAULT-l.jpg	34.99	33457-DEFAULT-m.jpg	HALO NOCKS, UNIVERSAL, RED 3PK	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	16	25-to-50	0.00	[empty string]	Halo Nocks Universal Multi-Fit \| Red - 3 Pack	<p>With "no-fail" internal components and bowstring activated dependability, Halo Nock provides superior, dependable performance with every shot. Sold in a 3 Pack.</p><p><strong>SIZE GUIDE</strong></p><ul><li>MICRO- Fits micro arrow IDs of .165"-.166"</li><li>FIT- A multi-fit package with bushing adapters to fit most common arrow IDs of .204", .233", and .244"-.246</li></ul><p>Halo Nock provides superior, dependable performance with every shot. Their patent pending design wont accidentally turn on when placing on your bowstring. No matter how hard you push on the nock, it won't activate until it leaves the string. In addition, this innovative design avoids any risk of a "mini-dry fire" that can occur with other lighted nocks that slip forward during release. Halo Nock is refreshingly simple to use and available in a variety of colors and sizes.</p>	[empty string]	N	34.99	34.99	[empty string]	33457-DEFAULT-s.jpg	[empty string]	1000	1000	HN-1003	251970	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	halo-nocks/halo-nocks-universal-multi-fit-red-3-pack-251970	HN-1003	0
4	[empty string]	HALO NOCKS	Halo Nocks	ARCHERY	Archery	[empty string]	1	34.99	0	34.99	33459-DEFAULT-l.jpg	34.99	33459-DEFAULT-m.jpg	HALO NOCKS, UNIVERSAL, GREEN, 3PK	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Halo Nocks Universal Multi-Fit \| Green - 3 Pack	<p>With "no-fail" internal components and bowstring activated dependability, Halo Nock provides superior, dependable performance with every shot. Sold in a 3 Pack.</p><p><strong>SIZE GUIDE</strong></p><ul><li>MICRO- Fits micro arrow IDs of .165"-.166"</li><li>FIT- A multi-fit package with bushing adapters to fit most common arrow IDs of .204", .233", and .244"-.246</li></ul><p>Halo Nock provides superior, dependable performance with every shot. Their patent pending design wont accidentally turn on when placing on your bowstring. No matter how hard you push on the nock, it won't activate until it leaves the string. In addition, this innovative design avoids any risk of a "mini-dry fire" that can occur with other lighted nocks that slip forward during release. Halo Nock is refreshingly simple to use and available in a variety of colors and sizes.</p>	[empty string]	N	34.99	34.99	[empty string]	33459-DEFAULT-s.jpg	[empty string]	1000	1000	HN-1013	251971	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	halo-nocks/halo-nocks-universal-multi-fit-green-3-pack-251971	HN-1013	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 ? ) GROUP BY STYLE_ID

SQLPARAMETERS