Jay's 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	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Reloading>Reloading Accessories	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	BALLISTIC PRECISION CHRONOGRAPH	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2014	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Ballistic Precision Chronograph	<p>FEATURES:<br /> -The Ballistic Precision Chronograph provides accurate velocity measurements across a wide range of shooting conditions.<br /> -Higher accuracy was achieved by using a high speed 48 MHz processor and by designing a circuit with an advanced data interface that allows each unit to be computer calibrated at the factory after assembly.<br /> -Although technologically advanced, the unit is designed to be simple to operate, displaying velocity in Feet per second or Meters per second on the large built in LCD screen.<br /> -The Chrono can also deliver the shot string velocity data through the 15` foot audio jack cable (included) to an iPhone or iPad.<br /> -A free App is available for download that displays the velocity of each shot on the phone screen and records it with other data identifying the load and environmental conditions. The App also automatically calculates Average Velocity, Standard Deviation, Min, Max and Velocity Spread for the shot string. The data is stored and can be exported via Email or simply recalled for reference at a later date.<br /> -The sunshades are extra wide for better reliability on sunny days and are constructed of a durable synthetic material. Measures from 5 to 9,999 FPS. There is a 1/4-20 threaded insert on bottom of housing for tripod mounting, operates on a 9 Volt battery (not included).</p>	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	720001	178062	RELOADING ACCESSORIES	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	caldwell/ballistic-precision-chronograph-178062	1
2	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Slings	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	MAX GRIP SLIM SLING BLACK	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Max Grip Slim Sling	<p>The Caldwell Max Grip Slim Sling is adjustable from 20" to 41" for full comfort out on the range or the trails. The non-slip ergonomic design is sure to keep your firearm secure while you're out in the wilderness. With quick detach metal sling swivels, the Max Grip Slim Sling is the easiest and quickest way to keep your firearm secure.</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	1131995	347328	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	caldwell/max-grip-slim-sling-347328	1
3	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Slings	[empty string]	0	23.99	0	23.99	[empty string]	23.99	[empty string]	MAX GRIP SLING BLACK	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Max Grip Sling	<p>The Caldwell Max Grip Sling’s ergonomic shape is designed to spread the weight of the firearm for a comfortable carry. The over molded design of the material grips your shoulder so the firearm stays put no matter how strenuous your hike is. The sling is completely sealed to be scent free and not take in any moisture as you hunt through all of the elements. If you want a sling that is going to stay put and be comfortable to carry all day, the Caldwell Max Grip is the sling for you!</p>	[empty string]	N	23.99	23.99	[empty string]	[empty string]	[empty string]	1000	156219	358429	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	caldwell/max-grip-sling-358429	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter