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]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	65592-DEFAULT-l.jpg	43.99	65592-DEFAULT-m.jpg	KAHR K9 9MM 7RD MAGAZINE	N	11 JJ	[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]	SO	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Kahr K9 9mm 7rd Magazine	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	65592-DEFAULT-s.jpg	[empty string]	1000	K820	35286	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-k9-9mm-7rd-magazine-35286	1
2	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	47.99	0	47.99	65612-DEFAULT-l.jpg	47.99	65612-DEFAULT-m.jpg	KAHR K920 MAGAZINE	N	11 JJ	[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]	Kahr K920 Magazine	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	47.99	47.99	[empty string]	65612-DEFAULT-s.jpg	[empty string]	1000	K920	35288	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-k920-magazine-35288	1
3	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	47.99	0	47.99	65619-DEFAULT-l.jpg	47.99	65619-DEFAULT-m.jpg	KAHR K920G MAGAZINE	N	11 JJ	[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]	SO	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Kahr K920g Magazine	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	47.99	47.99	[empty string]	65619-DEFAULT-s.jpg	[empty string]	1000	K920G	35289	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-k920g-magazine-35289	1
4	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	65588-DEFAULT-l.jpg	43.99	65588-DEFAULT-m.jpg	KAHR MK720 MAGAZINE	N	11 JJ	[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]	Kahr Mk720 Magazine	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	65588-DEFAULT-s.jpg	[empty string]	1000	MK720	35299	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-mk720-magazine-35299	1
5	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1390	0	1460	43805-DEFAULT-l.jpg	1390	43805-DEFAULT-m.jpg	AUTO-ORDNANCE T1 TOMMY GUN SEMI AUTO	N	11 JJ	45 AUTO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	RIFLE	1	500-or-more	0.00	[empty string]	1927a-1 Deluxe Semi Auto - 45 Acp - Walnut	<p>SPECIFICATIONS:<br /> -Model: T1<br /> -Caliber: .45 ACP<br /> -Barrel: 16.5`` Finned (with compensator 18``)<br /> -Weight: 13 lbs<br /> -Length: 41`` overall<br /> -Sight: Blade front, open rear adjustable<br /> -Stock: Walnut fixed stock and vertical foregrip<br /> -Magazines: One 30 Round Stick Magazine<br /> -Warranty: 1 year</p>	[empty string]	N	1460	1460	[empty string]	43805-DEFAULT-s.jpg	[empty string]	1000	T1	35305	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	kahr-arms/auto-ordnance-t1-tommy-gun-semi-auto-35305	1
6	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	78.99	0	78.99	66472-DEFAULT-l.jpg	78.99	66472-DEFAULT-m.jpg	KAHR AUTO ORD T11 MAGAZINE	N	11 JJ	[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	50-to-100	0.00	[empty string]	Kahr Auto Ord T11 Magazine	Auto Ordnance Mag 45 ACP 30Rd Blue 1927 T11. Replacement magazine.	[empty string]	N	78.99	78.99	[empty string]	66472-DEFAULT-s.jpg	[empty string]	1000	T11	35306	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-auto-ord-t11-magazine-35306	1
7	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	65595-DEFAULT-l.jpg	43.99	65595-DEFAULT-m.jpg	KAHR MK620 MK9 6RD	N	11 JJ	[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]	6	25-to-50	0.00	[empty string]	Kahr Mk620 Mk9 6rd	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	65595-DEFAULT-s.jpg	[empty string]	1000	MK620	84218	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-mk620-mk9-6rd-84218	1
8	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	67434-DEFAULT-l.jpg	43.99	67434-DEFAULT-m.jpg	KAHR P380 380ACP 6RD MAG	N	11 JJ	380 AUTO	[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]	SEMI AUTO	PISTOL	3	25-to-50	0.00	[empty string]	Kahr P380 380acp 6rd Mag	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	67434-DEFAULT-s.jpg	[empty string]	1000	K386	98748	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-p380-380acp-6rd-mag-98748	1
9	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	370	0	370	66473-DEFAULT-l.jpg	370	66473-DEFAULT-m.jpg	KAHR 50RD DRUM 45ACP MAGAZINE	N	11 JJ	45 AUTO	[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]	SO	[empty string]	[empty string]	[empty string]	1	350-to-400	0.00	[empty string]	Kahr 50rd Drum 45acp Magazine	A Thompson is just not a Thompson without the most famous accessory item ever - the drum magazine. The impressive look and feel of the drum magazines are unsurpassable. Each authentic drum is entirely U.S. manufactured to the exact specifications as the originals. The 10 Rd. and 50 Rd. drums have a diameter of 6.75`. The 100 Rd. durm has a diameter of 8.75`. Each drum is shipped with a drum installation device (3rd hand) and a Thompson manual. It works in most full auto models.	[empty string]	N	370	370	[empty string]	66473-DEFAULT-s.jpg	[empty string]	1000	QTMT13KT	101123	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-50rd-drum-45acp-magazine-101123	1
10	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	38.99	0	38.99	69620-DEFAULT-l.jpg	38.99	69620-DEFAULT-m.jpg	KAHR 30CAR 15RD MAGAZINE	N	11 JJ	30 CARBINE	[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	25-to-50	0.00	[empty string]	Kahr 30car 15rd Magazine	You can finally put your collectible USGI magazines away, and use these for every day blasting at the range. These magazines have been manufactured from the ground up with 100% reliability being the primary focus. No corners have been cut to maximize profits at the expense of quality.	[empty string]	N	38.99	38.99	[empty string]	69620-DEFAULT-s.jpg	[empty string]	1000	MC3015	138427	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-30car-15rd-magazine-138427	1
11	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Pistols	[empty string]	1	415	0	420	54255-DEFAULT-l.jpg	415	54255-DEFAULT-m.jpg	KAHR CM9 9MM SEMI AUTO PISTOL	N	11 JJ	9MM LUGER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	KAHR ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	ONLINE	SEMI AUTO	PISTOL	1	400-to-450	0.00	[empty string]	Cm9 - 9 Mm - Dao - 6 + 1 Rds - Stainless Slide	<p>SPECIFICATIONS:<br /> -Model: CM Series<br /> -Item Number: CM9093<br /> -Caliber: 9mm<br /> -Capacity: 6+1<br /> -Operation: Trigger cocking DAO; lock breech; ``Browning - type`` recoil lug; passive striker block; no magazine disconnect<br /> -Barrel: 3.0``, conventional rifling; 1 - 10 right-hand twist<br /> -Length O/A: 5.42``<br /> -Height: 4.0``<br /> -Slide Width: .90``<br /> -Weight: Pistol 14 ounces, Magazine 1.9 ounces<br /> -Grips: Textured polymer<br /> -Sights: Drift adjustable, white bar-dot combat sights<br /> -Finish: Black polymer frame, matte stainless steel slide<br /> -Magazine: 1 - 6 rd flush floorplate</p>	[empty string]	N	420	420	[empty string]	54255-DEFAULT-s.jpg	[empty string]	1000	CM9093	138465	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kahr-arms/kahr-cm9-9mm-semi-auto-pistol-138465	1
12	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	64740-DEFAULT-l.jpg	43.99	64740-DEFAULT-m.jpg	KAHR P45 45ACP 6RD MAGAZINE	N	11 JJ	45 AUTO	[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]	SO	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Kahr P45 45acp 6rd Magazine	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	64740-DEFAULT-s.jpg	[empty string]	1000	K625	166947	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-p45-45acp-6rd-magazine-166947	1
13	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	0	47.99	0	47.99	[empty string]	47.99	[empty string]	KAHR 7RD SS MAG 40SW	N	11 JJ	40 SW	[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]	5	25-to-50	0.00	[empty string]	Kahr 7rd Ss Mag 40sw	This magazine will fit all Kahr 40 S&W models and has a max capacity of 7-rounds.	[empty string]	N	47.99	47.99	[empty string]	[empty string]	[empty string]	1000	K720	260189	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-7rd-ss-mag-40sw-260189	1
14	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	75.99	0	75.99	88558-DEFAULT-l.jpg	75.99	88558-DEFAULT-m.jpg	KAHR AUTO ORD T10 20 RDS 45ACP MAGAZINE	N	11 JJ	[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]	6	50-to-100	0.00	[empty string]	Kahr Auto Ord T10 20 Rds 45acp Magazine	[empty string]	[empty string]	N	75.99	75.99	[empty string]	88558-DEFAULT-s.jpg	[empty string]	1000	T10	300529	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-auto-ord-t10-20-rds-45acp-magazine-300529	1
15	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	48.99	0	48.99	69620-DEFAULT-l.jpg	48.99	69620-DEFAULT-m.jpg	KAHR 30CAR 30RD MAGAZINE	N	11 JJ	30 CARBINE	[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]	2	25-to-50	0.00	[empty string]	Kahr 30car 30rd Magazine	[empty string]	[empty string]	N	48.99	48.99	[empty string]	69620-DEFAULT-s.jpg	[empty string]	1000	MC3030	315926	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-30car-30rd-magazine-315926	1
16	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2450	0	2450	77864-DEFAULT-l.jpg	2450	77864-DEFAULT-m.jpg	AUT-ORD TRUMP TOMMY GUN 45 ACP SA RIFLE	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	RIFLE	1	500-or-more	0.00	[empty string]	Aut-ord Trump Tommy Gun 45 Acp Sa Rifle	[empty string]	[empty string]	N	2450	2450	[empty string]	77864-DEFAULT-s.jpg	[empty string]	1000	T1-14-50DC1	320775	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	kahr-arms/aut-ord-trump-tommy-gun-45-acp-sa-rifle-320775	1
17	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	47.99	0	47.99	88557-DEFAULT-l.jpg	47.99	88557-DEFAULT-m.jpg	KAHR P380 380ACP 7RD MAG	N	11 JJ	380 AUTO	[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]	SO	[empty string]	SEMI AUTO	PISTOL	2	25-to-50	0.00	[empty string]	Kahr P380 380acp 7rd Mag	[empty string]	[empty string]	N	47.99	47.99	[empty string]	88557-DEFAULT-s.jpg	[empty string]	1000	K387	352419	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-p380-380acp-7rd-mag-352419	1
18	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Shotguns	[empty string]	1	670	0	735	85759-DEFAULT-l.jpg	670	85759-DEFAULT-m.jpg	1911A1 45ACP S/A PISTOL	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	SEMI AUTO	PISTOL	2	500-or-more	0.00	[empty string]	1911a1 45acp S/a Pistol	[empty string]	[empty string]	N	735	735	[empty string]	85759-DEFAULT-s.jpg	[empty string]	1000	1911BKO	352483	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	kahr-arms/1911a1-45acp-s-a-pistol-352483	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter