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]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	19.99	0	19.99	87807-DEFAULT-l.jpg	19.99	87807-DEFAULT-m.jpg	PMAG 20 ROUND 7.62X51 308 MAGAZINE	N	16 TOM	308 WIN	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Pmag 20 Round 7.62x51 308 Magazine	[empty string]	[empty string]	N	19.99	19.99	[empty string]	87807-DEFAULT-s.jpg	[empty string]	1000	MAG291BLK	242154	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-20-round-7-62x51-308-magazine-242154	1
2	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	14.99	0	14.99	87584-DEFAULT-l.jpg	14.99	87584-DEFAULT-m.jpg	PMAG 30ROUND AR/M4 MAG	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2015	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	26	10-to-15	0.00	[empty string]	Pmag 30round Ar/m4 Mag	[empty string]	[empty string]	N	14.99	14.99	[empty string]	87584-DEFAULT-s.jpg	[empty string]	1000	MAG557-BLK	254396	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-30round-ar-m4-mag-254396	1
3	FDE,BLK	MAGPUL INDUSTRIES	Magpul Industries	OPTICS	Optics>Sights	FDE\|NULL\|NULL,BLK\|NULL\|NULL	1	39.99	0	39.99	87573-DEFAULT-l.jpg	39.99	87573-DEFAULT-m.jpg	MBUS FRONTFLIP SIGHT	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2015	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	29	25-to-50	0.00	[empty string]	Mbus Frontflip Sight	[empty string]	[empty string]	N	39.99	39.99	[empty string]	87573-DEFAULT-s.jpg	[empty string]	1000	MAG247	260271	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	magpul-industries/mbus-frontflip-sight-260271	1
4	GRY,BLK,FDE	MAGPUL INDUSTRIES	Magpul Industries	OPTICS	Optics>Sights	GRY\|NULL\|NULL,BLK\|NULL\|NULL,FDE\|NULL\|NULL	1	55.99	0	55.99	88421-DEFAULT-l.jpg	55.99	88421-DEFAULT-m.jpg	MBUS REAR TFLIP SIGHT	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2015	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	Mbus Rear Tflip Sight	[empty string]	[empty string]	N	55.99	55.99	[empty string]	88421-DEFAULT-s.jpg	[empty string]	1000	MAG248	260272	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	magpul-industries/mbus-rear-tflip-sight-260272	1
5	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	129.99	0	129.99	88762-DEFAULT-l.jpg	129.99	88762-DEFAULT-m.jpg	PMAG 60RND MAGAZINE	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Pmag 60rnd Magazine	[empty string]	[empty string]	N	129.99	129.99	[empty string]	88762-DEFAULT-s.jpg	[empty string]	1000	MAG576-BLK	263405	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-60rnd-magazine-263405	1
6	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	12.99	0	12.99	88477-DEFAULT-l.jpg	12.99	88477-DEFAULT-m.jpg	PMAG 30ROUND AR/M4 MAG GEN M2	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2015	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	227	10-to-15	0.00	[empty string]	Pmag 30round Ar/m4 Mag Gen M2	[empty string]	[empty string]	N	12.99	12.99	[empty string]	88477-DEFAULT-s.jpg	[empty string]	1000	MAG571-BLK	266180	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-30round-ar-m4-mag-gen-m2-266180	1
7	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	OPTICS	Optics>Sights	[empty string]	1	99.99	0	99.99	88418-DEFAULT-l.jpg	99.99	88418-DEFAULT-m.jpg	MBUS PRO OFFSET REAR SIGHT	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	50-to-100	0.00	[empty string]	Mbus Pro Offset Rear Sight	[empty string]	[empty string]	N	99.99	99.99	[empty string]	88418-DEFAULT-s.jpg	[empty string]	1000	MAG526-BLK	266560	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	magpul-industries/mbus-pro-offset-rear-sight-266560	1
8	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	15.99	0	15.99	88791-DEFAULT-l.jpg	15.99	88791-DEFAULT-m.jpg	PMAG GLOCK 17 17RND	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	21	15-to-20	0.00	[empty string]	Pmag Glock 17 17rnd	[empty string]	[empty string]	N	15.99	15.99	[empty string]	88791-DEFAULT-s.jpg	[empty string]	1000	MAG546-BLK	269800	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-glock-17-17rnd-269800	1
9	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	15.99	0	15.99	87554-DEFAULT-l.jpg	15.99	87554-DEFAULT-m.jpg	PMAG GLOCK 19 15RND	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Pmag Glock 19 15rnd	[empty string]	[empty string]	N	15.99	15.99	[empty string]	87554-DEFAULT-s.jpg	[empty string]	1000	MAG550-BLK	269801	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-glock-19-15rnd-269801	1
10	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	OPTICS	Optics>Sights	[empty string]	1	81.99	0	81.99	88314-DEFAULT-l.jpg	81.99	88314-DEFAULT-m.jpg	MBUS PRO OFFSET FRONT SIGHT	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Mbus Pro Offset Front Sight	[empty string]	[empty string]	N	81.99	81.99	[empty string]	88314-DEFAULT-s.jpg	[empty string]	1000	MAG525-BLK	269803	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	magpul-industries/mbus-pro-offset-front-sight-269803	1
11	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	18.99	0	18.99	88317-DEFAULT-l.jpg	18.99	88317-DEFAULT-m.jpg	PMAG 40 ROUND MAGAZINE	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	58	15-to-20	0.00	[empty string]	Pmag 40 Round Magazine	[empty string]	[empty string]	N	18.99	18.99	[empty string]	88317-DEFAULT-s.jpg	[empty string]	1000	MAG233-BLK	270588	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-40-round-magazine-270588	1
12	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	18.99	0	18.99	88425-DEFAULT-l.jpg	18.99	88425-DEFAULT-m.jpg	PMAG 00ROUND M3 7.62	N	16 TOM	7.62 MM	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	97	15-to-20	0.00	[empty string]	Pmag 00round M3 7.62	[empty string]	[empty string]	N	18.99	18.99	[empty string]	88425-DEFAULT-s.jpg	[empty string]	1000	MAG290-BLK	278717	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-00round-m3-7-62-278717	1
13	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	17.99	0	17.99	88473-DEFAULT-l.jpg	17.99	88473-DEFAULT-m.jpg	PMAG M3 5.56 30RND WITH WINDOW	N	16 TOM	5.56 MM	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	11	15-to-20	0.00	[empty string]	Pmag M3 5.56 30rnd With Window	[empty string]	[empty string]	N	17.99	17.99	[empty string]	88473-DEFAULT-s.jpg	[empty string]	1000	MAG556-BLK	282240	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-m3-5-56-30rnd-with-window-282240	1
14	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	OPTICS	Optics>Sights	[empty string]	1	104.99	0	104.99	88479-DEFAULT-l.jpg	104.99	88479-DEFAULT-m.jpg	MBUS PRO REAR SIGHT	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]	2017	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	15	100-to-150	0.00	[empty string]	Mbus Pro Rear Sight	[empty string]	[empty string]	N	104.99	104.99	[empty string]	88479-DEFAULT-s.jpg	[empty string]	1000	MAG276-BLK	285180	EMPTY	EMPTY	EMPTY	0	0	0	SIGHTS	[empty string]	magpul-industries/mbus-pro-rear-sight-285180	1
15	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	16.99	0	16.99	88427-DEFAULT-l.jpg	16.99	88427-DEFAULT-m.jpg	AK/AKM 30RND MAGAZINE 7.62X39	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]	2018	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	49	15-to-20	0.00	[empty string]	Ak/akm 30rnd Magazine 7.62x39	[empty string]	[empty string]	N	16.99	16.99	[empty string]	88427-DEFAULT-s.jpg	[empty string]	1000	MAG572-BLK	311471	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/ak-akm-30rnd-magazine-7-62x39-311471	1
16	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	14.99	0	14.99	88905-DEFAULT-l.jpg	14.99	88905-DEFAULT-m.jpg	PMAG 30ROUND AR/M4 MAG MCT	N	16 TOM	[empty string]	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	Pmag 30round Ar/m4 Mag Mct	[empty string]	[empty string]	N	14.99	14.99	[empty string]	88905-DEFAULT-s.jpg	[empty string]	1000	MAG557-MCT	326771	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-30round-ar-m4-mag-mct-326771	1
17	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	21.99	0	21.99	87403-DEFAULT-l.jpg	21.99	87403-DEFAULT-m.jpg	PMAG GLOCK GLP 9X19 27 ROUND	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]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	18	20-to-25	0.00	[empty string]	Pmag Glock Glp 9x19 27 Round	[empty string]	[empty string]	N	21.99	21.99	[empty string]	87403-DEFAULT-s.jpg	[empty string]	1000	MAG662BLK	332416	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-glock-glp-9x19-27-round-332416	1
18	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	19.99	0	19.99	88764-DEFAULT-l.jpg	19.99	88764-DEFAULT-m.jpg	PMAG GLOCK GL9 9MM 21 ROUND	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]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	15-to-20	0.00	[empty string]	Pmag Glock Gl9 9mm 21 Round	[empty string]	[empty string]	N	19.99	19.99	[empty string]	88764-DEFAULT-s.jpg	[empty string]	1000	MAG661-BLK	340755	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-glock-gl9-9mm-21-round-340755	1
19	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	19.99	0	19.99	88937-DEFAULT-l.jpg	19.99	88937-DEFAULT-m.jpg	PMAG 30ROUND GEN M3 5.56 W/WINDOW	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]	ACTIVE	[empty string]	[empty string]	[empty string]	224	15-to-20	0.00	[empty string]	Pmag 30round Gen M3 5.56 W/window	[empty string]	[empty string]	N	19.99	19.99	[empty string]	88937-DEFAULT-s.jpg	[empty string]	1000	MAG575-BLK	346205	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-30round-gen-m3-5-56-w-window-346205	1
20	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	19.99	0	19.99	87409-DEFAULT-l.jpg	19.99	87409-DEFAULT-m.jpg	PMAG 30 ROUND AR 300 BLACK OUT	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]	ACTIVE	[empty string]	[empty string]	[empty string]	3	15-to-20	0.00	[empty string]	Pmag 30 Round Ar 300 Black Out	[empty string]	[empty string]	N	19.99	19.99	[empty string]	87409-DEFAULT-s.jpg	[empty string]	1000	MAG800	346212	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-30-round-ar-300-black-out-346212	1
21	[empty string]	MAGPUL INDUSTRIES	Magpul Industries	FIREARMS	Firearms>Magazines	[empty string]	1	17.99	0	17.99	87560-DEFAULT-l.jpg	17.99	87560-DEFAULT-m.jpg	PMAG M3 5.56 30RND WITH WINDOW COY TAN	N	16 TOM	5.56 MM	[empty string]	[empty string]	ARP	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	SO	[empty string]	[empty string]	[empty string]	3	15-to-20	0.00	[empty string]	Pmag M3 5.56 30rnd With Window Coy Tan	[empty string]	[empty string]	N	17.99	17.99	[empty string]	87560-DEFAULT-s.jpg	[empty string]	1000	MAG556-MCT	349938	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	magpul-industries/pmag-m3-5-56-30rnd-with-window-coy-tan-349938	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter

Filter By

Price

Categories

Brand

Pmag 20 Round 7.62x51 308 Magazine

Pmag 30round Ar/M4 Mag

Mbus Frontflip Sight

Mbus Rear Tflip Sight

Pmag 60rnd Magazine

Pmag 30round Ar/M4 Mag Gen M2

Mbus Pro Offset Rear Sight

Pmag Glock 17 17rnd

Pmag Glock 19 15rnd

Mbus Pro Offset Front Sight

Pmag 40 Round Magazine

Pmag 00round M3 7.62

Pmag M3 5.56 30rnd With Window

Mbus Pro Rear Sight

Ak/Akm 30rnd Magazine 7.62x39

Pmag 30round Ar/M4 Mag Mct

Pmag Glock Glp 9x19 27 Round

Pmag Glock Gl9 9mm 21 Round

Pmag 30round Gen M3 5.56 W/Window

Pmag 30 Round Ar 300 Black Out

Pmag M3 5.56 30rnd With Window Coy Tan