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	27.99	0	27.99	65400-DEFAULT-l.jpg	27.99	65400-DEFAULT-m.jpg	22CAL BULLET 55GR SBT	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]	14	25-to-50	0.00	[empty string]	22cal Bullet 55gr Sbt	The Sierra GameKing bullets are designed for hunting at long ranges. GameKing bullets feature a boat tail design to bring hunters the ballistic advantage of match bullets. The streamlined tapered base of the boat tail bullet greatly reduces drag, which results in higher retained velocity, greater striking energy, a flatter trajectory, and less wind drift.	[empty string]	N	27.99	27.99	[empty string]	65400-DEFAULT-s.jpg	[empty string]	1000	1365	63725	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-55gr-sbt-63725	1
2	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	27.99	0	27.99	65404-DEFAULT-l.jpg	27.99	65404-DEFAULT-m.jpg	22CAL BULLET 69GR 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]	21	25-to-50	0.00	[empty string]	22cal Bullet 69gr 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	27.99	27.99	[empty string]	65404-DEFAULT-s.jpg	[empty string]	1000	1380	63727	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-69gr-hpbt-match-63727	1
3	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	29.99	0	29.99	65401-DEFAULT-l.jpg	29.99	65401-DEFAULT-m.jpg	22CAL BULLET 55GR HPBT	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]	4	25-to-50	0.00	[empty string]	22cal Bullet 55gr Hpbt	The Sierra GameKing bullets are designed for hunting at long ranges. GameKing bullets feature a boat tail design to bring hunters the ballistic advantage of match bullets. The streamlined tapered base of the boat tail bullet greatly reduces drag, which results in higher retained velocity, greater striking energy, a flatter trajectory, and less wind drift.	[empty string]	N	29.99	29.99	[empty string]	65401-DEFAULT-s.jpg	[empty string]	1000	1390	63729	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-55gr-hpbt-63729	1
4	[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]	9	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
5	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	0	35.99	0	35.99	[empty string]	35.99	[empty string]	303CAL BULLET 125GR SPT	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]	303cal Bullet 125gr Spt	Sierra Pro-Hunter bullets have a traditional, flat base design. All these bullets have medium to heavy weights in each caliber, and they are designed for a combination of penetration and expansion in medium and heavy game animals for their calibers.	[empty string]	N	35.99	35.99	[empty string]	[empty string]	[empty string]	1000	2305	63790	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/303cal-bullet-125gr-spt-63790	1
6	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	0	33.99	0	33.99	[empty string]	33.99	[empty string]	10MM PISTOL BULLET 180GR 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]	4	25-to-50	0.00	[empty string]	10mm Pistol Bullet 180gr Jhp	[empty string]	[empty string]	N	33.99	33.99	[empty string]	[empty string]	[empty string]	1000	8460	63814	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/10mm-pistol-bullet-180gr-jhp-63814	1
7	[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]	21	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
8	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	24.99	0	24.99	65395-DEFAULT-l.jpg	24.99	65395-DEFAULT-m.jpg	22CAL BULLET 52GR HPBTM	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]	3	20-to-25	0.00	[empty string]	22cal Bullet 52gr Hpbtm	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	24.99	24.99	[empty string]	65395-DEFAULT-s.jpg	[empty string]	1000	1410	66075	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/22cal-bullet-52gr-hpbtm-66075	1
9	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	1	52.99	0	52.99	65501-DEFAULT-l.jpg	52.99	65501-DEFAULT-m.jpg	30CAL BULLET 175GR MATCHKING	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	30cal Bullet 175gr Matchking	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	52.99	52.99	[empty string]	65501-DEFAULT-s.jpg	[empty string]	1000	2275	117508	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/30cal-bullet-175gr-matchking-117508	1
10	[empty string]	SIERRA BULLETS	Sierra Bullets	FIREARMS	Firearms>Reloading>Bullets	[empty string]	0	239.99	0	239.99	[empty string]	239.99	[empty string]	30CAL .308 BULLETS 125GR 500CT	N	16 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	30cal .308 Bullets 125gr 500ct	[empty string]	[empty string]	N	239.99	239.99	[empty string]	[empty string]	[empty string]	1000	2275C	352268	EMPTY	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	sierra-bullets/30cal-308-bullets-125gr-500ct-352268	1
11	[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]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	1	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