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>Magazines	[empty string]	0	0	0	44.99	[empty string]	0	[empty string]	FIRESTORM 32MAG CLIP	N	11 JJ	[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]	[empty string]	DISC	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Firestorm 32mag Clip	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	32MAG	24838	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/firestorm-32mag-clip-24838	1
2	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	0	0	0	49.99	[empty string]	0	[empty string]	FIRESTORM 95121 CLIP	N	11 JJ	[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]	[empty string]	SO	[empty string]	[empty string]	[empty string]	17	25-to-50	0.00	[empty string]	Firestorm 95121 Clip	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	95121	24844	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/firestorm-95121-clip-24844	1
3	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Magazines	[empty string]	1	39.49	0	39.49	65535-DEFAULT-l.jpg	39.49	65535-DEFAULT-m.jpg	BERSA 9MM 13RD MAG	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]	SO	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Bersa 9mm 13rd Mag	Constructed of aluminum, this Bersa magazine is compatible with Thunder and holds up to 13-rounds.	[empty string]	N	39.49	39.49	[empty string]	65535-DEFAULT-s.jpg	[empty string]	1000	THUN9UCM13	139726	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	bersa-guns/bersa-9mm-13rd-mag-139726	1
4	[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 PISTOL S/A	N	11 JJ	380 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	R.S.A.	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	3	250-to-300	0.00	[empty string]	Thunder 380 Matte Lite - 380 Acp - Dbl - 8 +1 Rds	<p>SPECIFICATIONS:<br /> -Model: Thunder 380 Matte Lite<br /> -Item Number: T380M8<br /> -Action: Double/Single<br /> -Finish: Matte Blue<br /> -Frame: Alloy Frame<br /> -Grips: Black Plastic<br /> -Weight: 23 oz.<br /> -Gauge: 380 ACP<br /> -Rounds: 8+1<br /> -Barrel Length: 3.5``<br /> -Overall Length: 6.6``<br /> -Sights: Fixed<br /> -Safety: 2 Position Slide Mounted<br />  </p>	[empty string]	N	295	295	[empty string]	56106-DEFAULT-s.jpg	[empty string]	1000	T380M8	273506	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/rsa-thunder-380acp-pistol-s-a-273506	1
5	[empty string]	BERSA GUNS	Bersa Guns	FIREARMS	Firearms>Pistols	[empty string]	1	315	0	315	85930-DEFAULT-l.jpg	315	85930-DEFAULT-m.jpg	BERSA 9MM COMPACT CARRY BB PISTOL	N	11 JJ	9 X 19MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	R.S.A.	BERSA S.A.	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SO	[empty string]	SEMI AUTO	PISTOL	2	300-to-350	0.00	[empty string]	Bersa 9mm Compact Carry Bb Pistol	[empty string]	[empty string]	N	315	315	[empty string]	85930-DEFAULT-s.jpg	[empty string]	1000	BP9BRZCC	349886	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bersa-guns/bersa-9mm-compact-carry-bb-pistol-349886	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter