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]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	29.99	0	29.99	65446-DEFAULT-l.jpg	29.99	65446-DEFAULT-m.jpg	30CAL BULLET 110GR HP	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	30cal Bullet 110gr Hp	Varminter Bullets are designed specifically for rapid expansion and instant kills on larger varmints and small game. Varminter bullets have thin jackets to enhance expansion but with sufficient strength to be fired at the highest muzzle velocities in the cartridges for which they are intended. The shapes of bullets in this classification include hollow point (HP), spitzer pointed flat base (SPT), and semi-pointed (SMP). Bullets labeled as Blitz are designed for medium velocity (under 3600 fps). Hornet bullets are designed to expand reliably in the 2500 to 2800 fps velocity range, although they can be loaded in cartridges generating up to 3500 fps muzzle velocity. At 223 Remington velocities, the Hornet will be an explosive "Blitz" style Varminter.	[empty string]	N	29.99	29.99	[empty string]	65446-DEFAULT-s.jpg	[empty string]	1000	2110	63775	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/30cal-bullet-110gr-hp-63775	1
2	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	53.99	0	53.99	65455-DEFAULT-l.jpg	53.99	65455-DEFAULT-m.jpg	30CAL BULLET 168GR HPBT MATCH	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	30cal Bullet 168gr Hpbt Match	MatchKing Bullets are Sierra's pre-eminent target bullets. The driving motivation for the design of each MatchKing bullet is accuracy. These bullets have very thin jackets drawn to an exacting concentricity standard of 0.0003 in maximum variation, and their weight is held to within -+0.3 grain. All MatchKing have a hollow point design with a very small meplat for high ballistic coefficient. The majority of these bullets have a boat tail shape to further minimize drag and improve ballistic coefficient. Although some of these bullets have been used for hunting, Sierra recommends them only for target shooting.	[empty string]	N	53.99	53.99	[empty string]	65455-DEFAULT-s.jpg	[empty string]	1000	2200	63786	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/30cal-bullet-168gr-hpbt-match-63786	1
3	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	45.99	0	45.99	65493-DEFAULT-l.jpg	45.99	65493-DEFAULT-m.jpg	45CAL PISTOL BULLET 185GR JHP	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	45cal Pistol Bullet 185gr Jhp	Sports Master bullets are primarily for hunting. Bullets intended for use in revolvers and rifles with tubular magazines have a cannelure to facilitate roll crimping. Sports Master bullets are available in JHP, JHC, or JSP styles.	[empty string]	N	45.99	45.99	[empty string]	65493-DEFAULT-s.jpg	[empty string]	1000	8800	63820	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/45cal-pistol-bullet-185gr-jhp-63820	1
4	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	0	159.99	0	159.99	[empty string]	159.99	[empty string]	22CAL .224 BULLETS 69GR HPBT 500CT	N	16 TOM	[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]	SO	[empty string]	[empty string]	[empty string]	13	150-to-200	0.00	[empty string]	22cal .224 Bullets 69gr Hpbt 500ct	[empty string]	[empty string]	N	159.99	159.99	[empty string]	[empty string]	[empty string]	1000	1380C	353024	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-224-bullets-69gr-hpbt-500ct-353024	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter