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	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]	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[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
2	[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]	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[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 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
3	[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]	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[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]	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
4	[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]	ADULT SIGNATURE	[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	8	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
5	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	0	38.99	0	38.99	[empty string]	38.99	[empty string]	KAHR 30CAR 15RD MAGAZINE	N	11 JJ	30 CARBINE	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[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 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]	[empty string]	[empty string]	1000	MC3015	138427	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-30car-15rd-magazine-138427	1
6	[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]	ADULT SIGNATURE	[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
7	[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]	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[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 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
8	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Pistols	[empty string]	1	820	0	820	65331-DEFAULT-l.jpg	820	65331-DEFAULT-m.jpg	1911 A1 #80 WOOD GRIP S/A PISTOL	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	8	500-or-more	0.00	[empty string]	1911 A1 GI SPEC - 45 ACP - SAO - 7 RDS - WOOD GRIP	<ul> <li>Item: Auto-Ordnance 1911 A1 GI Spec</li> <li>Item Number 1911BKOW</li> <li>Caliber: 45 ACP</li> <li>Action: SAO</li> <li>Capacity: 7</li> <li>Barrel Length: 5"</li> <li>OAL: 8.50"</li> <li>Frame: Black Matte Carbon Sttel</li> <li>Adjustable Sight</li> <li>Grips: Checkered Wood with Integrated US Logo</li> <li>Safety: Thumb / Grip / Firing Pin</li> </ul>	[empty string]	N	820	820	[empty string]	65331-DEFAULT-s.jpg	[empty string]	1000	1911BKOW	301411	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kahr-arms/1911-a1-gi-spec-45-acp-sao-7-rds-wood-grip-301411	1
9	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Pistols	[empty string]	1	1360	0	1360	88559-DEFAULT-l.jpg	1360	88559-DEFAULT-m.jpg	1911 A1 CASE HARDENED 45ACP S/A PISTOL	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	1	500-or-more	0.00	[empty string]	1911 A1 Case Hardened 45acp S/a Pistol	[empty string]	[empty string]	N	1360	1360	[empty string]	88559-DEFAULT-s.jpg	[empty string]	1000	1911GCH	315922	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kahr-arms/1911-a1-case-hardened-45acp-s-a-pistol-315922	1
10	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	0	48.99	0	48.99	[empty string]	48.99	[empty string]	KAHR 30CAR 30RD MAGAZINE	N	11 JJ	30 CARBINE	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Kahr 30car 30rd Magazine	[empty string]	[empty string]	N	48.99	48.99	[empty string]	[empty string]	[empty string]	1000	MC3030	315926	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-30car-30rd-magazine-315926	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter