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]	DAIWA	Daiwa	HUNTING	Hunting	[empty string]	1	199.99	1	59.99	33727-DEFAULT-l.jpg	199.99	33727-DEFAULT-m.jpg	DAIWA QZ ULTRALIGHT SPIN REEL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1412	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Daiwa QZ Ultralight Spinning Reel	<p>The unique 750 Size has many different applications for serious trout, panfish and ice fisherman. The Light Body is strong yet balances well with delicate, ultra-light rod bends. The operation is smooth with 6 Ball Bearings throughout the small reel. The Aluminum Spool is stiff and well-suited for 4 and 6 pound mono or 6 and 8 pound braided line. A smart, yet functional Premium Cork Handle Knob assures a firm grip and an easy, comfortable crank. The Aluminum Folding Handle makes the reel easy to pack, transport or store. The 5 to 1 gear ratio is balanced for both lure and bait fishing. The affordable reel has many higher end features. When a 500 is too small and a 1000 to large, reach for Daiwa.</p><p><strong>SPECIFICATIONS</strong></p><ul><li>SKU 043178590508</li><li>BRAND Daiwa</li><li>STYLE QZ750</li><li>CONDITION New</li><li>HAND Ambidextrous</li></ul>	[empty string]	Y	59.99	59.99	[empty string]	33727-DEFAULT-s.jpg	[empty string]	1000	1000	QZ750	131710	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	daiwa/daiwa-qz-ultralight-spinning-reel-131710	QZ750	0
2	[empty string]	HAVALON	Havalon	HUNTING	Hunting	[empty string]	1	12.99	0	14.99	370-DEFAULT-l.jpg	12.99	370-DEFAULT-m.jpg	HAVALON X60A KNIFE	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4442	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	22	10-to-15	0.00	[empty string]	Havalon Replacement Blades	<p>At 20% thicker and 30% stronger than our #60XT blade, we've improved our cutting edge sharpness with the #60A blade. Whether you're skinning, quartering or field dressing, the #60A is able to withstand heavy use and resist breakage, and is the ideal choice for any serious hunter looking for both strength and precision.</p><ul><li>Stainless Steel</li><li>2 3/4" length</li><li>Box of one dozen</li><li>Fits all Piranta-style knives</li><li>Individually foil wrapped</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	14.99	14.99	[empty string]	370-DEFAULT-s.jpg	[empty string]	1000	1000	X60A	137560	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	havalon/havalon-replacement-blades-137560	X60A	0
3	[empty string]	HAVALON	Havalon	HUNTING	Hunting	[empty string]	1	79.99	0	84.99	4903-DEFAULT-l.jpg	79.99	4903-DEFAULT-m.jpg	HAVALON TALON HUNT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4442	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Havalon Talon Hunt Interchangeable Fixed Blade Kit with Four Blades and Nylon Roll Pack	<p> </p><ul><li><strong>Type:</strong> Skinning/Gutting</li><li><strong>Blade Material:</strong> AUS-8 Stainless Steel</li><li><strong>No. of Blades:</strong> 4</li><li><strong>Manufacturer Part Number:</strong> XTC-TH</li></ul>	[empty string]	N	84.99	84.99	[empty string]	4903-DEFAULT-s.jpg	[empty string]	1000	1000	XTC-TH	137564	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	havalon/havalon-talon-hunt-interchangeable-fixed-blade-kit-with-four-blades-and-nylon-roll-pack-137564	XTC-TH	0
4	[empty string]	SCENT LOK	Scent Lok	HUNTING	Hunting	[empty string]	1	199.99	0	199.99	8295-DEFAULT-l.jpg	199.99	8295-DEFAULT-m.jpg	SCENT LOK OZ 5K BAG IQ COMBO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1471	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	ScentLok Oz Chamber 5K Combo Kit	<p>Go beyond just containing gear and actively freshen it anywhere! The OZ Chamber 5K by ScentLok is equipped to destroy odors with the power of ozone. The included RadialIQ is intelligently designed to emit just the right amount of ozone to fill the bag and destroy odors throughout. The result, a storage bag that provides fresher and healthier gear.image</p><p><strong>Specifications for ScentLok OZ Chamber 5K Combo Kit:</strong></p><ul><li>Manufacturer: ScentLok</li><li>Application: Home</li><li>Color: Black</li><li>Dimensions: 26 x 14 x 14 in</li></ul><p><strong>Features of ScentLok OZ Chamber 5K Combo Kit:</strong></p><ul><li>The new Radial IQ features a one button design that runs for 30 minutes, the ideal ozone output and run time to actively refresh your gear</li><li>Extremely durable 600D PVC backed polyester fabric</li><li>Reinforced 2in grab straps for hauling heavy loads</li><li>Removable, adjustable shoulder strap for comfortable, convenient carrying</li><li>Bag includes a dedicated pocket to suspend the Radial IQ, allowing ozone to fill the whole bag</li></ul>	[empty string]	N	199.99	199.99	[empty string]	8295-DEFAULT-s.jpg	[empty string]	1000	1000	4153661-090	207988	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	scent-lok/scentlok-oz-chamber-5k-combo-kit-207988	4153661-090	0
5	[empty string]	SCENT LOK	Scent Lok	HUNTING	Hunting	[empty string]	1	299.99	0	299.99	8296-DEFAULT-l.jpg	299.99	8296-DEFAULT-m.jpg	SCENT LOK OZ 8K BAG IQ COMBO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1471	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	ScentLok Oz Rolling Chamber 8K Combo Kit	<p>Storing your hunting clothing in a OZ storage container is a vital step for success in the field. Our products are constantly adsorbing odors and contaminants in the air that surrounds them. Keeping your gear in the OZRolling Chamber 8K allows the new Radial IQ ozone generator to destroy lingering odors and keep them from contaminating your gear.image</p><p><strong>Specifications for ScentLok OZ Rolling Chamber 8K Combo Kit:</strong></p><ul><li>Manufacturer: ScentLok</li><li>Application: Home</li><li>Color: Black</li></ul><p><strong>Features of ScentLok OZ Rolling Chamber 8K Combo Kit:</strong></p><ul><li>The ultimate traveling odor destroying storage solution</li><li>The new Radial IQ features a one button design that runs for 30 minutes, the ideal ozone output and run time to actively refresh your gear</li><li>Extendable handle & durable wheels for easy transport</li><li>Extremely durable 600D PVC backed polyester fabric</li><li>Reinforced 2in grab straps for hauling heavy loads</li><li>Removable, adjustable shoulder strap for comfortable, convenient carrying</li><li>Bag includes a dedicated pocket to suspend the Radial IQ, allowing ozone to fill the whole bag</li></ul>	[empty string]	N	299.99	299.99	[empty string]	8296-DEFAULT-s.jpg	[empty string]	1000	1000	4153761-090	207989	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	scent-lok/scentlok-oz-rolling-chamber-8k-combo-kit-207989	4153761-090	0
6	[empty string]	TACTACAM	Tactacam	HUNTING	Hunting	[empty string]	1	329.99	1	199.99	15441-DEFAULT-l.jpg	329.99	15441-DEFAULT-m.jpg	TACTACAM 6.0	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4631	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	150-to-200	0.00	[empty string]	Tactacam 6.0 Ultra HD Camera	<p>The Tactacam 6.0 was made with the modern-day sportsman in mind. The #1 Point of View camera on the market features 8x zoom which brings your subject closer than ever. New image stabilization technology takes the "shock" out and lets you capture crystal clear footage in 4k 60fps. The sleek, waterproof design features a screen, generates WI-FI, and is remote compatible.</p><p>Tactacam is designed for you using the best electronics available. Easy to use; 1 touch operation with vibration indication allows for easy camera operation. This small video camera was built with an ultra-high-quality lens and low-light sensor. Instead of using a fisheye lens, which pushes the images away, Tactacam uses a unique lens design, providing a view similar to what we see with the human eye. Tactacam 6.0 now features an improved 8x zoom to bring your target closer than ever!</p><p>All this is what makes the Tactacam 6.0 the best action camera on the market.</p><p><strong>Included in Box:</strong></p><ul><li>Tactacam 6.0 POV action camera</li><li>Battery</li><li>USB cable with charging wall adapter</li><li>User manual</li></ul><p><strong>SPECIFICATIONS</strong>:</p><ul><li>8x zoom brings your subject closer than ever</li><li>Newly integrated touch screen display</li><li>Image stabilization</li><li>Capture crystal clear footage in 4k-60fps</li><li>One touch operation with vibration indication</li><li>Sleek, waterproof design (up to 30ft)</li><li>Ultra-high quality lens, providing a similar to human-eye view</li><li>Low-light sensor</li><li>Tactacam remote compatible</li><li>Wi-Fi connection to your smartphone via Tactacam App</li><li>ENHANCED FEATURES - Auto Focus , loop recording , time-lapse and moveable red dot option</li><li>NOTE: since the Tactacam 6.0 has a new sleek design, your older (5.0) mounts will not fit. However, the remote and batteries from the older models will fit the 6.0.</li></ul>	[empty string]	Y	199.99	199.99	[empty string]	15441-DEFAULT-s.jpg	[empty string]	1000	1000	C-FB-6	208669	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	tactacam/tactacam-6-0-ultra-hd-camera-208669	C-FB-6	0
7	[empty string]	TACTACAM	Tactacam	HUNTING	Hunting	[empty string]	1	34.99	1	29.99	2645-DEFAULT-l.jpg	34.99	2645-DEFAULT-m.jpg	TACTACAM	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4631	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Tactacam Dual Battery Charger	<p>Dual Battery Charger for Tactacam 5.0, 4.0 and Solo Camera batteries. Compatible with Battery Model: LBAT-3-4</p>	[empty string]	Y	29.99	29.99	[empty string]	2645-DEFAULT-s.jpg	[empty string]	1000	1000	CH-EX-LBAT	208670	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	tactacam/tactacam-dual-battery-charger-208670	CH-EX-LBAT	0
8	[empty string]	TACTACAM	Tactacam	HUNTING	Hunting	[empty string]	1	29.99	0	29.99	15440-DEFAULT-l.jpg	29.99	15440-DEFAULT-m.jpg	TACTACAM ANTENNA	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4631	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	26	25-to-50	0.00	[empty string]	Tactacam Reveal X Antenna	<p>Increase cell reception for your trail camera with the Tactacam Reveal Extended Range Antenna. With a 6.5' cord, this antenna can be set up more than 6' from your trail camera. The Tactacam Extended Range Antenna requires no external power.</p><p> </p>	[empty string]	N	29.99	29.99	[empty string]	15440-DEFAULT-s.jpg	[empty string]	1000	1000	EXTR-V1	208672	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	tactacam/tactacam-reveal-x-antenna-208672	EXTR-V1	0
9	[empty string]	TACTACAM	Tactacam	HUNTING	Hunting	[empty string]	1	24.99	0	24.99	12091-DEFAULT-l.jpg	24.99	12091-DEFAULT-m.jpg	TACTACAM 32GB SD CARD	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4631	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	42	20-to-25	0.00	[empty string]	Tactacam 32GB SD Card	<p><strong>Tactacam 32GB SD Card </strong></p>	[empty string]	N	24.99	24.99	[empty string]	12091-DEFAULT-s.jpg	[empty string]	1000	1000	FS32GB	208674	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	tactacam/tactacam-32gb-sd-card-208674	FS32GB	0
10	[empty string]	TACTACAM	Tactacam	HUNTING	Hunting	[empty string]	1	49.99	0	49.99	16949-DEFAULT-l.jpg	49.99	16949-DEFAULT-m.jpg	TACTACAM FISH-i	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4631	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Tactacam Fish-i	<p><strong>DESCRIPTION: </strong></p><p>Screw on interchangeable lenses will modify the viewing angle of your Fish-i. The Fish-I Combo Lens Pack is a set of two lenses: an ultra wide lens and a mini zoom lens to get all the right angles.</p>	[empty string]	N	49.99	49.99	[empty string]	16949-DEFAULT-s.jpg	[empty string]	1000	1000	L-F-COMBO	208676	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	tactacam/tactacam-fish-i-208676	L-F-COMBO	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

array
1	Hunting
2	%scent%lok%
3	%kuhl%
4	%warne%
5	%hobo%bags%
6	%kusa%
7	%daiwa%
8	%havalon%
9	%tactacam%

Filter By

Sort By

Items Per Page

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Daiwa Qz Ultralight Spinning Reel

Havalon Replacement Blades

Havalon Talon Hunt Interchangeable Fixed Blade Kit With Four Blades And Nylon Roll Pack

Scentlok Oz Chamber 5k Combo Kit

Scentlok Oz Rolling Chamber 8k Combo Kit

Tactacam 6.0 Ultra Hd Camera

Tactacam Dual Battery Charger

Tactacam Reveal X Antenna

Tactacam 32gb Sd Card

Tactacam Fish- I

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Daiwa Qz Ultralight Spinning Reel

Havalon Replacement Blades

Havalon Talon Hunt Interchangeable Fixed Blade Kit With Four Blades And Nylon Roll Pack

Scentlok Oz Chamber 5k Combo Kit

Scentlok Oz Rolling Chamber 8k Combo Kit

Tactacam 6.0 Ultra Hd Camera

Tactacam Dual Battery Charger

Tactacam Reveal X Antenna

Tactacam 32gb Sd Card

Tactacam Fish- I