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]	WALTHER	Walther	FIREARMS	Firearms>Pistols	[empty string]	1	385	0	425	54671-DEFAULT-l.jpg	385	54671-DEFAULT-m.jpg	PK380 380ACP 3.66IN BLACK	N	11 JJ	380 AUTO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WALTHER ARMS	CARL WALTHER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	1	400-to-450	0.00	[empty string]	Pk380 - 380 Acp - Dbl - 8 Rds - Black	<p>SPECIFICATIONS:<br /> -Model: PK 380 BLACK<br /> -Item Number: 5050308<br /> -Caliber: .380 ACP<br /> -Finish Color: Cerakote Black<br /> -Barrel Length: 3.66``<br /> -Trigger Pull: DA: 11/SA: 4 lbs<br /> -Trigger Travel: DA: 0.4<br /> -Capacity: 8 rds<br /> -Overall Length: 6.5``<br /> -Height: 5.2``<br /> -Width: 1.2``<br /> -Safety: Manual + 1 Auto<br /> -Weight (mag empty): 18 oz</p>	[empty string]	N	425	425	[empty string]	54671-DEFAULT-s.jpg	[empty string]	1000	5050308	159726	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	walther/pk380-380acp-3-66in-black-159726	1
2	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Pistols	[empty string]	1	425	0	480	54387-DEFAULT-l.jpg	425	54387-DEFAULT-m.jpg	PK380 380ACP 3.66IN NICKEL	N	11 JJ	380 AUTO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WALTHER ARMS	CARL WALTHER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	1	450-to-500	0.00	[empty string]	Pk380 - 380 Acp - Dbl - 8 Rds - Nickel	<p>SPECIFICATIONS:<br /> -Model: PK380<br /> -Item Number: 5050309<br /> -Caliber: .380 ACP<br /> -Finish Color: Nickel<br /> -Barrel Length: 3.66``<br /> -Trigger Pull DA: 11/SA: 4 lbs<br /> -Trigger Travel DA: 0.4<br /> -Capacity: 8 rds<br /> -Overall Length: 6.5``<br /> -Height: 5.2``<br /> -Width: 1.2``<br /> -Safety: Manual + 1 Auto<br /> -Weight (mag empty) 18 oz</p>	[empty string]	N	480	480	[empty string]	54387-DEFAULT-s.jpg	[empty string]	1000	5050309	159727	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	walther/pk380-380acp-3-66in-nickel-159727	1
3	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Magazines	[empty string]	1	44.99	0	44.99	70577-DEFAULT-l.jpg	44.99	70577-DEFAULT-m.jpg	PPQ 9MM 15RND MAGAZINE	N	11 JJ	9MM LUGER	[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]	7	25-to-50	0.00	[empty string]	Ppq 9mm 15rnd Magazine	This magazine fits Walther PPQ M1 Classic firearms that are chambered in 9mm. The capacity is 10 rounds.	[empty string]	N	44.99	44.99	[empty string]	70577-DEFAULT-s.jpg	[empty string]	1000	2796422	159740	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	walther/ppq-9mm-15rnd-magazine-159740	1
4	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Magazines	[empty string]	0	44.99	0	44.99	[empty string]	44.99	[empty string]	PPQ 40SW 12RND MAGAZINE	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]	17	25-to-50	0.00	[empty string]	Ppq 40sw 12rnd Magazine	This magazine fits Walther's PPQ and has an anti-friction coating. It is available in flat bottom or extended fits.	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	2796431	159742	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	walther/ppq-40sw-12rnd-magazine-159742	1
5	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Magazines	[empty string]	0	44.99	0	44.99	[empty string]	44.99	[empty string]	PPQ M2 40SW 11RND MAGAZINE	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]	20	25-to-50	0.00	[empty string]	Ppq M2 40sw 11rnd Magazine	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	2796686	159745	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	walther/ppq-m2-40sw-11rnd-magazine-159745	1
6	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Magazines	[empty string]	1	38.99	0	38.99	70616-DEFAULT-l.jpg	38.99	70616-DEFAULT-m.jpg	COLT 1911 22LR 12RND	N	11 JJ	22 LR	[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]	10	25-to-50	0.00	[empty string]	Colt 1911 22lr 12rnd	This magazine fits Colt 1911 tactical rimfire firearms sold by Walther that are chambered in 22 LR and has a capacity of 12 rounds.	[empty string]	N	38.99	38.99	[empty string]	70616-DEFAULT-s.jpg	[empty string]	1000	517602	159761	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	walther/colt-1911-22lr-12rnd-159761	1
7	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Magazines	[empty string]	1	38.99	0	38.99	71602-DEFAULT-l.jpg	38.99	71602-DEFAULT-m.jpg	CCP 9MM 8 RND MAGAZINE	N	11 JJ	9MM LUGER	[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]	Ccp 9mm 8 Rnd Magazine	This magazine fits Walther CCP firearms that are chambered in 9mm and has a capacity of 8 rounds.	[empty string]	N	38.99	38.99	[empty string]	71602-DEFAULT-s.jpg	[empty string]	1000	50860002	247645	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	walther/ccp-9mm-8-rnd-magazine-247645	1
8	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Pistols	[empty string]	1	380	0	425	54539-DEFAULT-l.jpg	380	54539-DEFAULT-m.jpg	PPS M2 9MM 8RD SEMI PISTOL	N	11 JJ	9MM X 19	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WALTHER ARMS	CARL WALTHER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	4	400-to-450	0.00	[empty string]	Pps M2 - 9mm - Semi Auto - 6/7/8 Rds -	<p>SPECIFICATIONS:<br /> -Model: PPS M2 9mm<br /> -Item Number: 2805961<br /> -Caliber: 9mm<br /> -Finish Color: Tenifer Black<br /> -Barrel Length: 3.18``<br /> -Trigger Pull: 6.1 lbs<br /> -Trigger Travel: 0.2``<br /> -Capacity: 6/7/8 rds<br /> -Overall Length: 6.3``<br /> -Height: 4.4/4.9/5.3``<br /> -Width: 1``<br /> -Weight (mag empty): 21.1 oz</p>	[empty string]	N	425	425	[empty string]	54539-DEFAULT-s.jpg	[empty string]	1000	2805961	269270	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	walther/pps-m2-9mm-8rd-semi-pistol-269270	1
9	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Rifles	[empty string]	1	425	0	425	80037-DEFAULT-l.jpg	425	80037-DEFAULT-m.jpg	HAMMERLI TAC R1 22LR BLACK SEMI RIFLE	N	11 JJ	22 LR	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	HAMMERLI ARMS	UMAREX	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	2	400-to-450	0.00	[empty string]	Hammerli Tac R1 - 22 Lr - 20+1 Rds - Matte Black - 5 Postion	<p> SPECIFICATIONS:</p> <p>-Model: Walther Arms Hammerli Tac R1</p> <p>-Item Number: 5760500</p> <p>-Caliber: 22 LR</p> <p>-Stock Finish: Black</p> <p>-Action: Semi-Auto</p> <p>-Sights: Flip Up Front & Rear</p> <p>-Capacity: 20+1</p> <p>-Grips: Black Polymer</p> <p>-Hand: Right</p> <p>-Metal Finish: Matte Black</p> <p>-Barrel Length: 16.10"</p> <p>-OAL: 35.83"</p> <p>-Receiver Material: Aluminum</p> <p>-Safety: Ambidextrous</p> <p>-Stock Description: 5 Position</p> <p>-Stock Finish: Black Synthetic</p> <p>-Weight: 5.62 LBS</p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p>	[empty string]	N	425	425	[empty string]	80037-DEFAULT-s.jpg	[empty string]	1000	5760500	325101	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	walther/hammerli-tac-r1-22lr-black-semi-rifle-325101	1
10	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Pistols	[empty string]	1	480	0	480	81521-DEFAULT-l.jpg	480	81521-DEFAULT-m.jpg	CCP M2 380ACP BLACK 8 RND	N	11 JJ	380 AUTO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WALTHER ARMS	CARL WALTHER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	9	450-to-500	0.00	[empty string]	Ccp M2 - 380 Acp - Sao - 8+1 Rds - 3 Dot	<p> SPECIFICATIONS:</p> <p>-Model: Walther Arms CCP M2</p> <p>-Item Number: 5082500</p> <p>-Caliber: 380 ACP</p> <p>-Frame Finish: Black Cerakote</p> <p>-Capacity: 8+1 </p> <p>-Action: SAO</p> <p>-Slide Description: Black Cerakote</p> <p>-Frame Material: Polymer</p> <p>-Grips: Black Polymer</p> <p>-Barrel Length: 3.54"</p> <p>-OAL: 6.41"</p> <p>-Safety: Manual</p> <p>-Sight: 3 Dot</p> <p>-Sight Style: Adjustable</p> <p> </p>	[empty string]	N	480	480	[empty string]	81521-DEFAULT-s.jpg	[empty string]	1000	5082500	326797	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	walther/ccp-m2-380acp-black-8-rnd-326797	1
11	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Magazines	[empty string]	1	38.99	0	38.99	86268-DEFAULT-l.jpg	38.99	86268-DEFAULT-m.jpg	TAC R1C 22LR 30RND MAGAZINE	N	11 JJ	22 LR	[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]	Tac R1c 22lr 30rnd Magazine	[empty string]	[empty string]	N	38.99	38.99	[empty string]	86268-DEFAULT-s.jpg	[empty string]	1000	576630	326920	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	walther/tac-r1c-22lr-30rnd-magazine-326920	1
12	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Magazines	[empty string]	1	38.99	0	38.99	86267-DEFAULT-l.jpg	38.99	86267-DEFAULT-m.jpg	TAC R1C 22LR 20RND MAGAZINE	N	11 JJ	22 LR	[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]	10	25-to-50	0.00	[empty string]	Tac R1c 22lr 20rnd Magazine	[empty string]	[empty string]	N	38.99	38.99	[empty string]	86267-DEFAULT-s.jpg	[empty string]	1000	576620	339602	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	walther/tac-r1c-22lr-20rnd-magazine-339602	1
13	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Pistols	[empty string]	0	660	0	660	[empty string]	660	[empty string]	PDP COMPACT 4IN 15 RND 9MM BLACK	N	11 JJ	9MM X 19	4IN	[empty string]	[empty string]	[empty string]	[empty string]	WALTHER ARMS	CARL WALTHER	[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]	Pdp Compact 4in 15 Rnd 9mm Black	[empty string]	[empty string]	N	660	660	[empty string]	[empty string]	[empty string]	1000	2851229	349282	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	walther/pdp-compact-4in-15-rnd-9mm-black-349282	1
14	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Pistols	[empty string]	0	660	0	660	[empty string]	660	[empty string]	PDP OR 4.5IN 18 RND 9MM BLACK	N	11 JJ	9MM X 19	4.5IN	[empty string]	[empty string]	[empty string]	[empty string]	WALTHER ARMS	CARL WALTHER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	7	500-or-more	0.00	[empty string]	Pdp Or 4.5in 18 Rnd 9mm Black	[empty string]	[empty string]	N	660	660	[empty string]	[empty string]	[empty string]	1000	2842475	349284	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	walther/pdp-or-4-5in-18-rnd-9mm-black-349284	1
15	[empty string]	WALTHER	Walther	FIREARMS	Firearms>Pistols	[empty string]	0	660	0	660	[empty string]	660	[empty string]	PDP FULL SIZE 5IN 18 RND 9MM BLACK	N	11 JJ	9MM X 19	5IN	[empty string]	[empty string]	[empty string]	[empty string]	WALTHER ARMS	CARL WALTHER	[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]	Pdp Full Size 5in 18 Rnd 9mm Black	[empty string]	[empty string]	N	660	660	[empty string]	[empty string]	[empty string]	1000	2844001	355109	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	walther/pdp-full-size-5in-18-rnd-9mm-black-355109	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter