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	GREEN	MENDOTA	Mendota	HUNTING	Hunting	GREEN\|NULL\|NULL	1	19.99	0	19.99	525-DEFAULT-l.jpg	19.99	525-DEFAULT-m.jpg	MENDOTA 016 SNAP LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	.MENDOTA016SNAPLEAD	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Snap Lead (1/2"x4')	<p>Premium, strong (1/2" x 4 feet) solid braid UV coated polypropylene rope, leather sleeves, and a heavy gauge brass snap. Available in Camouflage and Green</p>	[empty string]	N	19.99	19.99	[empty string]	525-DEFAULT-s.jpg	[empty string]	1000	1000	016	75806	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-snap-lead-1-2-x4-75806	016	0
2	GREEN	MENDOTA	Mendota	HUNTING	Hunting	GREEN\|NULL\|NULL	1	16.99	0	16.99	522-DEFAULT-l.jpg	16.99	522-DEFAULT-m.jpg	MENDOTA 019 TRAFFIC LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	.MENDOTA019TRAFFICLEAD	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Traffic Leash - Large 1/2 Inch	<p>Traffic Lead -A short 1.5 foot handled snap lead for situations where you need your dog close at all times.</p><ul><li>Soft on the hands with its "Broken in Feel" easy to use and pliable enough to fit in your coat pocket</li><li>Brass, satin nickel or black metallic hardware and oil tanned leather splices</li><li>Made of waterproof, vibrant, long-lasting multi-filament polypropylene rope.</li><li>Matches Mendota's Double Braid Collars</li><li>Machine washable, air dry only.</li><li>Handmade in the U.S.A.</li><li>100% satisfaction guarantee</li><li>Shipping Weight 4 oz.</li><li>Package size: 4"x5"x1.5" </li></ul><p>We also have 4' and 6' foot available:</p><ul><li>Small Snap Leash: 3/8"" x 4' and 3/8"" x 6' (for dogs under 50 pounds)</li><li>Large Snap Leash: 1/2"" x 4' and 1/2"" x 6'</li><li>Traffic Lead: 1/2"" x 16""</li></ul>	[empty string]	N	16.99	16.99	[empty string]	522-DEFAULT-s.jpg	[empty string]	1000	1000	019	75807	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-traffic-leash-large-1-2-inch-75807	019	0
3	DAGGER_NOT_SERRATED	COBRA TEC	Cobra Tec	HUNTING	Hunting	DAGGER_NOT_SERRATED\|NULL\|NULL	1	69.99	0	69.99	3565-DEFAULT-l.jpg	69.99	3565-DEFAULT-m.jpg	COBRATEC LIGHTWEIGHT BLACK	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	CobraTec Black Lightweight Knives	<p>CobraTec Knives would like to introduce to you our Lightweight Black OTF (out the front) knife. With a great feel and excellent action, it's suited for everyday usage.</p><p>This knife features a pocket clip and a nylon sheath. All CobraTec Knives are backed by our LIFETIME WARRANTY.</p><ul><li>4.20 ounces</li><li>Dual Action OTF</li><li>3.25 inch D2 Steel Blade</li><li>4.5 inch high-grade aluminum alloy handle</li><li>7.75 inches in total length</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	69.99	69.99	[empty string]	3565-DEFAULT-s.jpg	[empty string]	1000	1000	BCTLWDAGNS	129708	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-black-lightweight-knives-129708	BCTLWDAGNS	0
4	BLACK	COBRA TEC	Cobra Tec	HUNTING	Hunting	BLACK\|NULL\|NULL	1	69.99	0	69.99	3564-DEFAULT-l.jpg	69.99	3564-DEFAULT-m.jpg	COBRATEC LIGHTWEIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	CobraTec Black Lightweight Knives	<p>CobraTec Knives would like to introduce to you our Lightweight Black OTF (out the front) knife. With a great feel and excellent action, it's suited for everyday usage.</p><p>This knife features a pocket clip and a nylon sheath. All CobraTec Knives are backed by our LIFETIME WARRANTY.</p><ul><li>4.20 ounces</li><li>Dual Action OTF</li><li>3.25 inch D2 Steel Blade</li><li>4.5 inch high-grade aluminum alloy handle</li><li>7.75 inches in total length</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	69.99	69.99	[empty string]	3564-DEFAULT-s.jpg	[empty string]	1000	1000	BCTLWDNS	129709	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-black-lightweight-knives-129709	BCTLWDNS	0
5	BLACK	COBRA TEC	Cobra Tec	HUNTING	Hunting	BLACK\|NULL\|NULL	1	79.99	0	79.99	12624-DEFAULT-l.jpg	79.99	12624-DEFAULT-m.jpg	COBRATEC LIGHTWEIGHT TANTO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	CobraTec Knives Lightweight Black Out The Front	<p>CobraTec Knives Lightweight Black OTF (out the front) knife has a high grade aluminum alloy handle with great feel, excellent action and loaded with a high quality D2 Steel blade that is suited for everyday usage.</p><p>This knife features a pocket clip and a nylon sheath. All CobraTec Knives are backed by our <a href="https://cobratecknives.com/pages/lifetime-warranty">LIFETIME WARRANTY</a>.</p><ul><li>4.20 ounces?</li><li>Dual Action OTF?</li><li>3.25 inch D2 Steel Blade?</li><li>4.5 inch high-grade aluminum alloy handle?</li><li>7.75 inches in total length?</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	79.99	79.99	[empty string]	12624-DEFAULT-s.jpg	[empty string]	1000	1000	BCTLWTNS	129710	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-knives-lightweight-black-out-the-front-129710	BCTLWTNS	0
6	[empty string]	COBRA TEC	Cobra Tec	HUNTING	Hunting	[empty string]	1	49.99	0	49.99	12627-DEFAULT-l.jpg	49.99	12627-DEFAULT-m.jpg	COBRATEC BLK QUICK STRIKE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Cobratec Black Quick Strike Hidden Release	<p>CobraTec hidden release automatic knife comes with G-10 scales, knurled rubberized grip and a black stonewashed 440 stainless steel blade. The hidden release button is hidden inside the handle. This automatic folding knife can also be used as a thumb assist.</p><ul><li>Hidden release switch</li><li>G-10 handle with knurled rubberized grip</li><li>Pocket clip</li><li>Right hand carry</li><li>Weighs 3.8 Ounces</li><li>Blade 3.25 inches</li><li>Handle 4.50 inches</li><li>Overall Length 7.75 inches</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	49.99	49.99	[empty string]	12627-DEFAULT-s.jpg	[empty string]	1000	1000	BLKHRQS	129712	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-black-quick-strike-hidden-release-129712	BLKHRQS	0
7	[empty string]	COBRA TEC	Cobra Tec	HUNTING	Hunting	[empty string]	1	69.99	0	69.99	37413-DEFAULT-l.jpg	69.99	37413-DEFAULT-m.jpg	COBRATEC CALI 928 PURPLE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	CobraTec Knives California 928SB - OTF Drop Point - D2 & Purple Anodized Aluminum - Includes Pocket Clip/Pouch	<p>CobraTec California 928TB handle and internal parts are all CNC machined to offer a precision fit that allows for a very smooth operation. The knife comes standard with a stonewashed D2 steel blade and anodized aluminum handle. Includes pocket clip and pouch.</p><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	69.99	69.99	[empty string]	37413-DEFAULT-s.jpg	[empty string]	1000	1000	CALI928SBPURDNS	129714	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-knives-california-928sb-otf-drop-point-d2-purple-anodized-aluminum-includes-pocket-clip-pouch-129714	CALI928SBPURDNS	0
8	[empty string]	COBRA TEC	Cobra Tec	HUNTING	Hunting	[empty string]	1	199.99	0	199.99	12635-DEFAULT-l.jpg	199.99	12635-DEFAULT-m.jpg	COBRATEC CALI CARBON FIBER 777	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Cobratec Cali Carbon Fiber 777	<p>CobraTec would like to introduce you to our Carbon Fiber OTF 777. The handle is made of 6061-T6 and is Anodized black on one side and has carbon fiber on the other side. Both the handle and internal parts are all CNC machined to offer a precision fit that allows for a very smooth operation.</p><p>This OTF comes standard with a 154CM steel blade and pocket clip. CobraTec knives are backed by a LIFETIME WARRANTY.</p><p><strong>Specifications:</strong></p><ul><li>Weight: 2.6 oz</li><li>Blade Length: 1.99"</li><li>Handle Length: 3.25"</li><li>Total Length: 5.25"</li><li>Anodized Handle</li><li>Pocket Clip</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	199.99	199.99	[empty string]	12635-DEFAULT-s.jpg	[empty string]	1000	1000	CCF777DNS	129715	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-cali-carbon-fiber-777-129715	CCF777DNS	0
9	CARBON_FIBER	COBRA TEC	Cobra Tec	HUNTING	Hunting	CARBON_FIBER\|NULL\|NULL	1	69.99	0	69.99	8452-DEFAULT-l.jpg	69.99	8452-DEFAULT-m.jpg	COBRATEC LIGHTWEIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	50-to-100	0.00	[empty string]	Cobratec Lightweight Knives	<p>CobraTec Knives would like to introduce to you our Lightweight OTF (out the front) knife. With a great feel and excellent action, it's suited for everyday usage.</p><p>This knife features a pocket clip and a nylon sheath. All CobraTec Knives are backed by our LIFETIME WARRANTY.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>4.20 ounces</li><li>Dual Action OTF</li><li>3.25 inch D2 Steel Blade</li><li>4.5 inch high-grade aluminum alloy handle</li><li>7.75 inches in total length</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	69.99	69.99	[empty string]	8452-DEFAULT-s.jpg	[empty string]	1000	1000	CFCTLWDNS	129716	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-lightweight-knives-129716	CFCTLWDNS	0
10	[empty string]	COBRA TEC	Cobra Tec	HUNTING	Hunting	[empty string]	1	249.99	1	188.99	12626-DEFAULT-l.jpg	249.99	12626-DEFAULT-m.jpg	COBRATEC ENFORCER BLK	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5379	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	CobraTec Knives CTEBLKM390DNS Large Enforcer Black	<p>CobraTec introduces you to our Enforcer. The handle is made of 6061-T6 with a textured design that provides a secure grip. The handle and all internal parts are CNC machined to offer a precision fit and to allow very smooth operation.<br />The Enforcer comes with a M390 drop not serrated blade. M390 is considered one of the best PREMIUM all around blade steels. It offers excellent edge retention, corrosion resistant and durability. This is one of the best everyday carry OTF knives you will find. Backed by our Lifetime Warranty.</p><ul><li>Weight: 3.5 oz</li><li>Blade Length: 3.25"</li><li>Handle Length: 4.75"</li><li>Total Length: 8.25"</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	Y	188.99	188.99	[empty string]	12626-DEFAULT-s.jpg	[empty string]	1000	1000	CTEBLKM390DNS	129717	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-knives-cteblkm390dns-large-enforcer-black-129717	CTEBLKM390DNS	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