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]	CODE BLUE	Code Blue	UNCATEGORIZED	Uncategorized	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	CODE BLUE SCENT DRAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Code Blue Scent Drag	[empty string]	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	1000	70711401036	129782	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	code-blue/code-blue-scent-drag-129782	70711401036	0
2	[empty string]	CODE BLUE	Code Blue	HUNTING	Hunting>Scent Elimination	[empty string]	1	19.99	0	19.99	8090-DEFAULT-l.jpg	19.99	8090-DEFAULT-m.jpg	CODE BLUE GRAVE DIGGER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Code Blue Grave Digger	<ul><li>Soil impregnated with Doe Estrous urine from a single deer</li><li>Shake onto scrapes and mock scrapes for a powerful, long-lasting scent</li><li>Great to use during the rut</li><li>TRS (Time Release Scent) remains active for up to 30 days after application</li><li>Urine collected using the From One Deer to One Bottle process, guaranteeing each bottle contains urine from only one deer</li></ul>	[empty string]	N	19.99	19.99	[empty string]	8090-DEFAULT-s.jpg	[empty string]	1000	1000	70711401367	129785	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	code-blue/code-blue-grave-digger-129785	70711401367	0
3	[empty string]	CODE BLUE	Code Blue	HUNTING	Hunting>Scent Elimination	[empty string]	1	12.99	0	14.99	28359-DEFAULT-l.jpg	12.99	28359-DEFAULT-m.jpg	CODE BLUE OA1001	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	Code Blue Deer Attractant Doe In Estrus Scent 1oz Bottle	<p>When you want pure estrous urine and nothing else, choose Code Blue's Doe Estrous Urine. Featuring Code Blues proprietary From One Deer to One Bottle process, where urine is collected from an individual deer, this product is guaranteed to be 100% pure. A buck can only trail one deer at a time, so with urine collected from a single doe in heat, you'll get unmatched true-to-life effectiveness that rutting bucks cant resist.</p>	[empty string]	N	14.99	14.99	[empty string]	28359-DEFAULT-s.jpg	[empty string]	1000	1000	OA1001	129787	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	code-blue/code-blue-deer-attractant-doe-in-estrus-scent-1oz-bottle-129787	OA1001	0
4	[empty string]	CODE BLUE	Code Blue	HUNTING	Hunting>Scent Elimination	[empty string]	1	14.99	1	12.99	8079-DEFAULT-l.jpg	14.99	8079-DEFAULT-m.jpg	CODE BLUE OA1135	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Code Blue OA1135 Whitetail Scrape Mate Liquid Buck Urine Attractor 1 oz	<p>This unique product increases and promotes activity on mock scrapes or primary scrapes where bucks are marking their territory. Whether early season curiosity or late season territorial infringement, Scrape Mate brings them in. Pour it on a scrape and watch the bucks keep it fresh. Trophy bucks are notoriously nocturnal, but Scrape Mate will help you pattern them - all season long.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Type</td><td>Attractor</td></tr><tr><td>Species</td><td>Whitetail</td></tr><tr><td>Volume</td><td>1 oz</td></tr><tr><td>Quantity</td><td>1</td></tr><tr><td>Scent Type</td><td>Deer</td></tr><tr><td>Dispenser Type</td><td>Liquid</td></tr><tr><td>Scented</td><td>Scented</td></tr><tr><td>Made From</td><td>Buck Urine</td></tr><tr><td>Manufacturer Part Number</td><td>OA1135 </td></tr></table>	[empty string]	Y	12.99	12.99	[empty string]	8079-DEFAULT-s.jpg	[empty string]	1000	1000	OA1135	129799	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	code-blue/code-blue-oa1135-whitetail-scrape-mate-liquid-buck-urine-attractor-1-oz-129799	OA1135	0
5	[empty string]	CODE BLUE	Code Blue	HUNTING	Hunting>Scent Elimination	[empty string]	1	19.99	0	19.99	8082-DEFAULT-l.jpg	19.99	8082-DEFAULT-m.jpg	CODE BLUE OA1226 ESTROUS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Code Blue Screamin' Heat Enhanced Estrous	<ul><li>Pure urine from a single doe in heat enhanced with natural estrous secretions</li><li>Amber glass bottle locks in freshness and potency</li><li>Collected using the From One Deer to One Bottle process, guaranteeing each bottle contains urine from only one deer</li><li>Labeled with the deer's unique registration number</li></ul>	[empty string]	N	19.99	19.99	[empty string]	8082-DEFAULT-s.jpg	[empty string]	1000	1000	OA1226	129801	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	code-blue/code-blue-screamin-heat-enhanced-estrous-129801	OA1226	0
6	[empty string]	CODE BLUE	Code Blue	HUNTING	Hunting>Scent Elimination	[empty string]	1	14.99	0	19.99	8089-DEFAULT-l.jpg	14.99	8089-DEFAULT-m.jpg	CODE BLUE OA1311	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	15-to-20	0.00	[empty string]	Code Blue Scent Elimination Field Spray & Refill	<ul><li>Unscented field spray specially formulated with medical grade nanosilver particles to eliminate human odors</li><li>Easily suppress scents from pets, smoke, exhaust, and your own natural smell</li><li>Safe on skin</li><li>Crafted without harsh chemicals</li></ul>	[empty string]	N	19.99	19.99	[empty string]	8089-DEFAULT-s.jpg	[empty string]	1000	1000	OA1311	129807	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	code-blue/code-blue-scent-elimination-field-spray-refill-129807	OA1311	0
7	[empty string]	CODE BLUE	Code Blue	UNCATEGORIZED	Uncategorized	[empty string]	0	44.99	0	44.99	[empty string]	44.99	[empty string]	CODE BLUE STANDING ESTROUS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Code Blue Standing Estrous	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	1000	OA1339	129817	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	code-blue/code-blue-standing-estrous-129817	OA1339	0
8	[empty string]	CODE BLUE	Code Blue	HUNTING	Hunting>Scent Elimination	[empty string]	1	19.99	0	19.99	28361-DEFAULT-l.jpg	19.99	28361-DEFAULT-m.jpg	CODE BLUE GRAVE DIGGER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	732	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Code Blue Grave Digger 12 oz.	<p><strong>FEATURES</strong></p><ul><li>-Contains soil impregnated w/ Code Blue's buck urine</li><li>-Shake it onto scrapes or mock scrapes.</li><li>-Use all season long as a curiosity or infringement scent</li><li>-Lasts up to 30 days</li><li>-12 oz</li></ul>	[empty string]	N	19.99	19.99	[empty string]	28361-DEFAULT-s.jpg	[empty string]	1000	1000	OA1368	129824	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	code-blue/code-blue-grave-digger-12-oz-129824	OA1368	0
9	[empty string]	TIPTON	Tipton	SHOOTING	Shooting>Accessories>Shooting Rests	[empty string]	1	179.99	0	179.99	22586-DEFAULT-l.jpg	179.99	22586-DEFAULT-m.jpg	TIPTON ULTRA GUN VISE	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1718	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Tipton Ultra Universal Gun Vise \| 110011	<p>Totally modular interchangeable design. Ball and socket articulating clamp pads allow for the pads to adapt to any surface. Dual Clamp Technology rigidly holds any gun shape in place. Rigid steel tube frame structure allows for complete access to your rifle. Fast-Turn knobs for quick clamping. Front and rear clamps are both height and length adjustable. Engineered glass filled nylon construction. Stainless teel reinforcing plates throught the design. Solvent resistant accessory Overall dimensions: 32.5 inches long, 11 inches high, 10.5 inches wide.</p>	[empty string]	N	179.99	179.99	[empty string]	22586-DEFAULT-s.jpg	[empty string]	1000	1000	110011	192240	SHOOTING RESTS	EMPTY	EMPTY	0	0	0	EMPTY	tipton/tipton-ultra-universal-gun-vise-110011-192240	110011	0
10	[empty string]	TIPTON	Tipton	SHOOTING	Shooting>Accessories>Shooting Rests	[empty string]	1	99.99	0	99.99	947-DEFAULT-l.jpg	99.99	947-DEFAULT-m.jpg	TIPTON GUN VISE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1718	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Battenfeld Tipton Gun Vise	<p>The Tipton Best Gun Vise is an extremely adaptable firearm holding system. All three supports are adjustable for positioning on the base via the T-track, and they all offer vertical adjustment. The Rear Clamp Base features two vertically independent adjustable Clamp Blocks, each with a padded jaw that can be positioned at different points from the centerline. With this flexibility, the Rear Clamp Blocks can accommodate practically any stock configuration, style and size of cheek piece, or cast-off.</p><p>The Rear Clamps are utilized by first positioning the firearm in the Vise, adjusting the Forend Support to achieve the desired barrel angle. With the Cam Levers in the disengaged position, rotate the outside Knobs of the Clamp Block Assemblies until the Clamp Pads make contact with the stock. Engaging the Cam Levers will secure the stock. Disengaging the Cam Levers, adjusting the outside Knobs, and reengaging the Cam Levers can regulate the amount of clamping force desired.</p><p>For cleaning most long guns, including bolt-actions, it is usually advisable and desirable that the muzzle of the barrel be lower than the breech. This prevents solvents, oils, and other liquids from running back into the breach area, and allows them to flow out the muzzle and be caught in a waste receptacle. This arrangement can be easily achieved by maneuvering the stock and/or the Rear Clamp Base so that the Pad contacts the stock at different points, either raising or lowering the height of the rear of the rifle. In conjunction with that adjustment, the position of the Forend Support can be raised or lowered to achieve the desired stance. The Grip Support features two leg heights and can be maneuvered along the length of the T-track to support the stock in the area of the pistol grip, usually immediately behind the pistol grip or immediately behind the trigger guard.</p><p>For cleaning break-open shotguns and rifles, or rifles that feature hinged design, such as the AR15, remove the Forend Upper Support from the Forend Base and secure the Upper Support directly to the extreme end of the Base. This positioning will allow the barrel(s) to extend below the height of the bench. Install the Grip Support with the longer leg upright, relatively close to the Forend Support, which will bear the firearm near the hinge. Because the firearm has moved toward one end of the Vise, the Rear Clamp Support can be moved closer to the Grip Support to accommodate the different position of the butt stock.</p><p>A variety of pistols and revolvers can be held in the Best Gun Vise by turning the Rear Clamp Support 180 degrees and using the vertically adjustable clamps to hold the handgun by the grips and thus to position the barrel to rest on either the Grip Support or the Forend Support. Don't be afraid to use your imagination to accommodate the wide variety of pistol designs offered.</p><p>Tipton Best Gun Vise 181181 for Firearms Cleaning, Maintenance, Gunsmithing</p><p> </p>	[empty string]	N	99.99	99.99	[empty string]	947-DEFAULT-s.jpg	[empty string]	1000	1000	181181	192285	SHOOTING RESTS	EMPTY	EMPTY	0	0	0	EMPTY	tipton/battenfeld-tipton-gun-vise-192285	181181	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc