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	4	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>Pistols	[empty string]	1	355	0	355	55696-DEFAULT-l.jpg	355	55696-DEFAULT-m.jpg	RSA BERSA THUNDER 380 PLUS 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	4	350-to-400	0.00	[empty string]	Thunder Plus - 380 Acp - Dbl - 3.5`` Bbl -15 Rds - Matte Black	<p>SPECIFICATIONS:<br /> -Model: Thunder Plus<br /> -Item Number: THUN380PM15<br /> -Type: Semi-Auto Pistol<br /> -Action: Double / Single Action<br /> -Finish: Matte Blue<br /> -Frame: Alloy Frame<br /> -Grips: Black Plastic<br /> -Weight: 23 oz.<br /> -Caliber: 380 ACP<br /> -Capacity: 15+1<br /> -Rounds: 15<br /> -Barrel: 3.5``<br /> -Overall Length: 6.625``<br /> -Sights: Fixed<br /> -Safety: 2 Position Slide Mounted</p>	[empty string]	N	355	355	[empty string]	55696-DEFAULT-s.jpg	[empty string]	1000	THUN380PM15	21896	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-bersa-thunder-380-plus-380acp-pistol-21896	1
3	[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
4	[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]	3	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
5	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	385	0	385	54246-DEFAULT-l.jpg	385	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	385	385	[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
6	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	57415-DEFAULT-l.jpg	295	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	295	295	[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
7	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	93282-DEFAULT-l.jpg	295	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	11	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	295	295	[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
8	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	310	0	310	64803-DEFAULT-l.jpg	310	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	310	310	[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
9	[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]	24	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
10	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	56106-DEFAULT-l.jpg	295	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	5	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	295	295	[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
11	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	310	0	310	97946-DEFAULT-l.jpg	310	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	310	310	[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
12	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	1	49.99	0	49.99	88526-DEFAULT-l.jpg	49.99	88526-DEFAULT-m.jpg	BERSA 9MM CARRY MAG 8RD	N	11 JJ	9MM	[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]	Bersa 9mm Carry Mag 8rd	[empty string]	[empty string]	N	49.99	49.99	[empty string]	88526-DEFAULT-s.jpg	[empty string]	1000	BP9CCMAG	318139	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/bersa-9mm-carry-mag-8rd-318139	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter