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	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
2	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
3	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
4	[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
5	[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
6	[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
7	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
8	[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
9	GREEN,SILVER,ARMY_DIGI_CAMO,BLACK,ORANGE	COBRA TEC	Cobra Tec	HUNTING	Hunting	GREEN\|NULL\|NULL,SILVER\|NULL\|NULL,ARMY_DIGI_CAMO\|NULL\|NULL,BLACK\|NULL\|NULL,ORANGE\|NULL\|NULL	1	89.99	1	67.99	3715-DEFAULT-l.jpg	89.99	3715-DEFAULT-m.jpg	COBRATEC SMALL CTK-1	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]	25	50-to-100	0.00	[empty string]	Cobratec Small Ctk-1 \| Multiple Color Options	<p>The CTK-1 is one of the best out the front knife (OTF) for general use and a great choice as your everyday carry. The handle is designed from high-grade aluminum alloy and features a D2 steel blade.</p><p>The knife is ambidextrous as the pocket clip can be switched to either side of the handle, depending on your preference.</p><p>This OTF knife features a pocket clip, a glass breaker for emergencies and includes a nylon sheath. All CobraTec OTF knives are backed by our LIFETIME WARRANTY.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>4.5 ounces</li><li>Dual Action OTF</li><li>2.75 inch D2 Steel Blade</li><li>4.25 inch high-grade Aluminum Alloy handle</li><li>7 inches in total length with glass breaker</li></ul>	[empty string]	N	67.99	89.99	[empty string]	3715-DEFAULT-s.jpg	[empty string]	1000	1000	CTK1	129718	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-small-ctk-1-multiple-color-options-129718	CTK1	0
10	[empty string]	COBRA TEC	Cobra Tec	HUNTING	Hunting	[empty string]	1	179.99	0	179.99	12628-DEFAULT-l.jpg	179.99	12628-DEFAULT-m.jpg	COBRATEC GENTLEMENS BLUE	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 Gentlemen's 2.80" OTF Drop Point Plain	<p>The CobraTec Gentlemen's knife is an out-the-front, or OTF, style knife that is perfect for the more discerning gentleman. The handle is constructed from 6061-T6 aviation grade aluminum and features an anodized finish. The Gentlemen's OTF knife's parts are CNC machined for a very precise fit which delivers silky smooth operation. With a blade made from high quality 154CM steel, the blade features a perfect balance of toughness, hardness, and resistance to corrosion. A pocket clip makes it easy to slip into a pocket for everyday carrying and a nylon sheath offers a reliable storage option for the knife while traveling.</p><p><strong>Specifications and Features:</strong></p><ul><li>CobraTec Item Number: GENTBLUCM154DNS</li><li>Out-the-Front (OTF) Knife</li><li>Designed for Right Handed Operation</li><li>2.8" Drop Point Blade</li><li>Plain Edge</li><li>6061-T6 Aviation Aluminum Handle</li><li>154CM Steel Blade</li><li>Pocket Clip</li><li>Handle Length: 4"</li><li>Overall Length: 6.8"</li><li>Weight: 2.5 oz</li><li>Anodized Handle Finish</li><li>Color: Blue</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	179.99	179.99	[empty string]	12628-DEFAULT-s.jpg	[empty string]	1000	1000	GENTBLUCM154DNS	129721	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cobra-tec/cobratec-knives-gentlemen-s-2-80-otf-drop-point-plain-129721	GENTBLUCM154DNS	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