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]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	305	0	305	64647-DEFAULT-l.jpg	305	64647-DEFAULT-m.jpg	RSA BERSA THUN380MLTCC 380ACP PISTOL	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	3	300-to-350	0.00	[empty string]	THUNDER - 380 ACP - SA/DA - 7 + 1 RDS - MATTE BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: THUN380MLTCC</li> <li>Caliber: 380 acp</li> <li>Action: SA / DA</li> <li>Rounds: 7+1</li> <li>Finish: Matte Black</li> <li>Barrel Length: 3.50"</li> <li>Sights: Contrast</li> </ul>	[empty string]	N	305	305	[empty string]	64647-DEFAULT-s.jpg	[empty string]	1000	THUN380MLTCC	21893	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-380-acp-sa-da-7-1-rds-matte-black-21893	1
2	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	FIRESTORM 95021 CLIP	N	11 JJ	[empty string]	[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]	2	25-to-50	0.00	[empty string]	Firestorm 95021 Clip	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	95021	24841	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/firestorm-95021-clip-24841	1
3	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	299	0	299	69130-DEFAULT-l.jpg	299	69130-DEFAULT-m.jpg	RSA BERSA THUNDER 22 MATTE 22LR 10RD	N	11 JJ	22 LR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	4	250-to-300	0.00	[empty string]	THUNDER - 22 LR - SA/DA - 10 + 1 RDS - MATTE BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Thunder</li> <li>Item Number: THUN380PM15</li> <li>Caliber: 22 LR</li> <li>Action: SA/DA</li> <li>Rounds: 10 + 1</li> <li>Finish: Matte Black</li> <li>Sight: Contrast</li> <li>barrel length: 3.5"</li> </ul>	[empty string]	N	299	299	[empty string]	69130-DEFAULT-s.jpg	[empty string]	1000	T22M	141350	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-22-lr-sa-da-10-1-rds-matte-black-141350	1
4	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	1	42.99	0	42.99	65534-DEFAULT-l.jpg	42.99	65534-DEFAULT-m.jpg	BERSA 380 15RD 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]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Bersa 380 15rd Mag	This magazine has a 15-round 380 ACP capacity, a black metal finish and a flat base. It is compatible with the Bersa Thunder 380 Plus model only.	[empty string]	N	42.99	42.99	[empty string]	65534-DEFAULT-s.jpg	[empty string]	1000	THUN380PM15MAG	143367	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/bersa-380-15rd-mag-143367	1
5	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	1	32.99	0	32.99	69134-DEFAULT-l.jpg	32.99	69134-DEFAULT-m.jpg	THUNDER 22LR 10RD MAG	N	11 JJ	22 LR	[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]	12	25-to-50	0.00	[empty string]	Thunder 22lr 10rd Mag	This is a replacement or extra magazine for Firestorm 22/Thunder 22. It has a matte finish, 10 rounds, and comes with extension.	[empty string]	N	32.99	32.99	[empty string]	69134-DEFAULT-s.jpg	[empty string]	1000	THUN22BLMAG	145424	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/thunder-22lr-10rd-mag-145424	1
6	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	390	0	390	54246-DEFAULT-l.jpg	390	54246-DEFAULT-m.jpg	BERSA THUNDER PLUS 380 380ACP PISTOL	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	2	350-to-400	0.00	[empty string]	Thunder Plus - 380 Acp - Dbl - 15 + 1 Rds - Nickel	<p>SPECIFICATIONS:<br /> -Model: Thunder 380 Plus<br /> -Caliber: .380 ACP<br /> -Action: DA/SA<br /> -Capacity: 15+1<br /> -Barrel Length: 3.5``<br /> -Front Sight: Dovetail<br /> -Rear Sight: Notched-Bar Dovetail<br /> -Finishes: Matte Black, Satin Nickel<br /> -Grips: Rubber<br /> -Construction: Alloy Frame / Steel Slide<br /> -Safety: Integral Locking System, Manual, Firing Pin<br /> -Weight: 20.5000<br /> -Length: 6.6``<br /> -Height: 4.9``<br /> -Width: 1.35``</p>	[empty string]	N	390	390	[empty string]	54246-DEFAULT-s.jpg	[empty string]	1000	THUN380PNKL15	169574	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/bersa-thunder-plus-380-380acp-pistol-169574	1
7	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	299	0	299	57415-DEFAULT-l.jpg	299	57415-DEFAULT-m.jpg	THUNDER 380 DUOTONE 380ACP 8RD	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	7	250-to-300	0.00	[empty string]	Thunder 380 Duolite - 380 Acp - Dbl - 8 Rds	<p>SPECIFICATIONS:<br /> -Model: Thunder 380 Duolite<br /> -Item Number: T380DT8<br /> -Type: Semi-Auto Pistol<br /> -Action: Double / Single Action<br /> -Finish: Duo-Tone<br /> -Frame: Alloy Frame<br /> -Grips: Black Plastic<br /> -Weight: 23 oz.<br /> -Caliber: 380 ACP<br /> -Capacity: 8+1<br /> -Number of Magazines: 1<br /> -Barrel: 3.5``<br /> -Overall Length: 6.6<br /> -Sights: Fixed<br /> -Safety: 2 Position Slide Mounted, Blue Slide with Nickel Frame</p>	[empty string]	N	299	299	[empty string]	57415-DEFAULT-s.jpg	[empty string]	1000	T380DT8	270129	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-380-duotone-380acp-8rd-270129	1
8	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	299	0	299	93282-DEFAULT-l.jpg	299	93282-DEFAULT-m.jpg	RSA THUNDER 380ACP PISTOL S/A	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	6	250-to-300	0.00	[empty string]	THUNDER - 380 ACP - DAO - 8 + 1 RDS - MATTE BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: T380M8</li> <li>Caliber: 380 ACP</li> <li>Capacity: 8 + 1 Rds</li> <li>Action: DAO</li> <li>Sight: Contrast</li> <li>Barrel Length: 3.5"</li> </ul>	[empty string]	N	299	299	[empty string]	93282-DEFAULT-s.jpg	[empty string]	1000	T380M8	273506	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-380-acp-dao-8-1-rds-matte-black-273506	1
9	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	315	0	315	64803-DEFAULT-l.jpg	315	64803-DEFAULT-m.jpg	THUNDER 380 380ACP 8RD NICKEL SEMI PISTO	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	4	300-to-350	0.00	[empty string]	THUNDER - 380 ACP - DAO - 8 + 1 RDS - NICKEL	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: T380NKL8</li> <li>Caliber: 380 ACP</li> <li>Roundss; 8 + 1</li> <li>Action: DAO</li> <li>Finish: Satin Nickel</li> <li>Barrel Length: 3.50"</li> </ul>	[empty string]	N	315	315	[empty string]	64803-DEFAULT-s.jpg	[empty string]	1000	T380NKL8	274182	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-380-acp-dao-8-1-rds-nickel-274182	1
10	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	1	34.99	0	34.99	87141-DEFAULT-l.jpg	34.99	87141-DEFAULT-m.jpg	BERSA 380 EXT FR MAGAZINE 8RD	N	[empty string]	380 ACP	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	BERSA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	Bersa 380 Ext Fr Magazine 8rd	[empty string]	[empty string]	N	34.99	34.99	[empty string]	87141-DEFAULT-s.jpg	[empty string]	1000	THUN380BLMAGFR	310159	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/bersa-380-ext-fr-magazine-8rd-310159	1
11	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	299	0	299	56106-DEFAULT-l.jpg	299	56106-DEFAULT-m.jpg	RSA THUNDER 380ACP R BLUE PISTOL S/A	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	8	250-to-300	0.00	[empty string]	THUNDER - 380 ACP - SA/DA - 8 +1 RDS - MATTE BLACK - ROBIN EGG BLUE	<p>SPECIFICATIONS: </p> <ul> <li>Item: Bersa Thunder Pistol</li> <li>Item Number: T380BLM8</li> <li>Caliber: 380 ACP</li> <li>Capacity: 8 + 1</li> <li>Action: SA/DA</li> <li>Frame Finish: Robin Egg Blue Cerakote</li> <li>Finish: Matte Black</li> <li>Barrel Length: 3.5"</li> <li>Sights: 3-Dot</li> </ul>	[empty string]	N	299	299	[empty string]	56106-DEFAULT-s.jpg	[empty string]	1000	T380BLM8	314764	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/thunder-380-acp-sa-da-8-1-rds-matte-black-robin-egg-blue-314764	1
12	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	315	0	315	97946-DEFAULT-l.jpg	315	97946-DEFAULT-m.jpg	FIRESTORM 380ACP PISTOL S/A	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	TALON DISTRIBUTING	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	2	300-to-350	0.00	[empty string]	FIRESTORM - 380 ACP - 7 + 1 RDS - BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bersa Firestorm</li> <li>Item Number: FS380M</li> <li>Caliber: 380 ACP</li> <li>Rounds: 7 + 1</li> <li>Finish: Black</li> </ul>	[empty string]	N	315	315	[empty string]	97946-DEFAULT-s.jpg	[empty string]	1000	FS380M	314769	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/firestorm-380-acp-7-1-rds-black-314769	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter