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]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	670	0	730	86925-DEFAULT-l.jpg	670	86925-DEFAULT-m.jpg	TAURUS ROSSI CIRCUIT JUDGE 45LC 410GA	N	11 JJ	45LC/410	18-1/2IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	TAURUS ARMAS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	DOUBLE ACTION	RIFLE	3	500-or-more	0.00	[empty string]	Taurus Rossi Circuit Judge 45lc 410ga	[empty string]	[empty string]	N	730	730	[empty string]	86925-DEFAULT-s.jpg	[empty string]	1000	SCJ4510	112619	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/taurus-rossi-circuit-judge-45lc-410ga-112619	1
2	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	160	0	185	79748-DEFAULT-l.jpg	160	79748-DEFAULT-m.jpg	ROSSI RB 22LR BOLT RIFLE	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	150-to-200	0.00	[empty string]	Rossi Rb22 - 22 Lr - 10 + 1 Rds - Synthetic	<p> SPECIFICATIONS:</p> <p>-Model: Rossi RB22</p> <p>-Item Number: RB22L1811</p> <p>-Caliber: 22LR</p> <p>-Stock Finsih: Black</p> <p>-Action: Bolt</p> <p>-Sights: Adjusable Fiber Optic</p> <p>-Capacity: 10 + 1</p> <p>-Hand: Right</p> <p>-Metal Finish: Black</p> <p>-Barrel Length: 18"</p> <p>-OAL: 35.50"</p> <p>-Receiver Material: Stainless Steel</p> <p>-Safety: Manual</p> <p>-Stock Description: Fixed Monte Carlo</p> <p>-Stock Finish Group: Black</p> <p>-Stock Material: Synthetic</p> <p>-Weight: 4 lbs</p> <p>-Barrel Description: Free Floating Button - Rifled</p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p>	[empty string]	N	185	185	[empty string]	79748-DEFAULT-s.jpg	[empty string]	1000	RB22L1811	315282	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-rb-22lr-bolt-rifle-315282	1
3	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	155	0	155	83500-DEFAULT-l.jpg	155	83500-DEFAULT-m.jpg	ROSSI RS 22LR BLACK SA RIFLE	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	5	150-to-200	0.00	[empty string]	Rs22 - 22 Lr - Matte Black - Black Synthetic	<p> SPECIFICATIONS:</p> <p>-Model: Rossi RS Series</p> <p>-Item Number: RS22L1811</p> <p>-Caliber: 22LR</p> <p>-Stock: Black Synthetic - Textured Monte Carlo</p> <p>-Barrel Length: 18"</p> <p>-OAL: 36.25"</p> <p>-Capacity: 10+1</p> <p>-Sights: Fiber Optic Front and Rear, adjustable</p> <p>-Weight: 4.1 lbs</p> <p>-Safety: Manual Cross-Bolt</p> <p>-Receiver Finish: Blued</p> <p>-Barrel Description: Free-Floating Button-rifled</p> <p>-Barrel Finish: Blued</p> <p> </p> <p> </p>	[empty string]	N	155	155	[empty string]	83500-DEFAULT-s.jpg	[empty string]	1000	RS22L1811	328057	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-rs-22lr-black-sa-rifle-328057	1
4	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	290	0	310	82960-DEFAULT-l.jpg	290	82960-DEFAULT-m.jpg	ROSSI RS 22 MAG BLACK SA RIFLE	N	11 JJ	22 WMR	21IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	16	300-to-350	0.00	[empty string]	Rs22m - 22 Mag - 10 Rds - Matte Black - Blk Synthic	<p> SPECIFICATIONS:</p> <p>-Model: Rossi RS Series</p> <p>-Item Number: RS22W2111</p> <p>-Caliber: 22 Mag</p> <p>-Action: Semi-Action</p> <p>-Finish: Matte Black</p> <p>-Stock Material: Synthetic</p> <p>-Stock Description: Textered Monte Carlo</p> <p>-Barrel Length: 21"</p> <p>-OAL: 39"</p> <p>-Capactiy: 10+1</p> <p>-Sights: No Sights</p> <p>-Weight: 4.3 lbs</p> <p>-Safety: Manual Cross-Bolt Safety</p> <p>-Features: Picatinny Rail</p>	[empty string]	N	310	310	[empty string]	82960-DEFAULT-s.jpg	[empty string]	1000	RS22W2111	332298	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-rs-22-mag-black-sa-rifle-332298	1
5	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	330	0	360	88817-DEFAULT-l.jpg	330	88817-DEFAULT-m.jpg	ROSSI GALLERY 22LR HARDWOOD SA RIFLE	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	RIFLE	8	350-to-400	0.00	[empty string]	Rossi Gallery 22lr Hardwood Sa Rifle	[empty string]	[empty string]	N	360	360	[empty string]	88817-DEFAULT-s.jpg	[empty string]	1000	RP22181WD	332299	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-gallery-22lr-hardwood-sa-rifle-332299	1
6	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Magazines	[empty string]	1	21.99	0	26.49	91453-DEFAULT-l.jpg	21.99	91453-DEFAULT-m.jpg	RP 22 MAG 10RND MAGAZINE	N	11 JJ	22 MAG	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[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]	Rp 22 Mag 10rnd Magazine	[empty string]	[empty string]	N	26.49	26.49	[empty string]	91453-DEFAULT-s.jpg	[empty string]	1000	358-0018-00	332300	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	braztech-intl-lc/rp-22-mag-10rnd-magazine-332300	1
7	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Magazines	[empty string]	1	18.99	0	23.49	87506-DEFAULT-l.jpg	18.99	87506-DEFAULT-m.jpg	RP 22 LR 10RND MAGAZINE	N	11 JJ	22 LR	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	22	20-to-25	0.00	[empty string]	Rp 22 Lr 10rnd Magazine	[empty string]	[empty string]	N	23.49	23.49	[empty string]	87506-DEFAULT-s.jpg	[empty string]	1000	358-0001-00	332301	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	braztech-intl-lc/rp-22-lr-10rnd-magazine-332301	1
8	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	340	0	365	87507-DEFAULT-l.jpg	340	87507-DEFAULT-m.jpg	ROSSI RIO BRAVO 22LR HARDWOOD LEVER RIFLE	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	LEVER	RIFLE	5	350-to-400	0.00	[empty string]	Rossi Rio Bravo 22lr Hardwood Lever Rifle	[empty string]	[empty string]	N	365	365	[empty string]	87507-DEFAULT-s.jpg	[empty string]	1000	RL22181WD	333617	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-rio-bravo-22lr-hardwood-lever-rifle-333617	1
9	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	0	895	0	895	[empty string]	895	[empty string]	R92 CARBINE 357MAG TRIP BLK LEVER	N	11 JJ	357MAG / 38SPL	16.5 IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	LEVER	RIFLE	1	500-or-more	0.00	[empty string]	R92 Carbine 357mag Trip Blk Lever	[empty string]	[empty string]	N	895	895	[empty string]	[empty string]	[empty string]	1000	923571613-TB	333619	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/r92-carbine-357mag-trip-blk-lever-333619	1
10	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Shotguns	[empty string]	1	170	0	185	87370-DEFAULT-l.jpg	170	87370-DEFAULT-m.jpg	ROSSI TUFFY 410GA 18.5IN BLACK SYN	N	11 JJ	410 GA	18-1/2IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SINGLE SHOT	SHOTGUN	1	150-to-200	0.00	[empty string]	Rossi Tuffy 410ga 18.5in Black Syn	[empty string]	[empty string]	N	185	185	[empty string]	87370-DEFAULT-s.jpg	[empty string]	1000	SSP1-BK	340531	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	braztech-intl-lc/rossi-tuffy-410ga-18-5in-black-syn-340531	1
11	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	295	0	325	91029-DEFAULT-l.jpg	295	91029-DEFAULT-m.jpg	ROSSI RIO BRAVO 22LR SYN LEVER RIFLE	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	LEVER	RIFLE	3	300-to-350	0.00	[empty string]	Rossi Rio Bravo 22lr Syn Lever Rifle	[empty string]	[empty string]	N	325	325	[empty string]	91029-DEFAULT-s.jpg	[empty string]	1000	RL22181SY	342485	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-rio-bravo-22lr-syn-lever-rifle-342485	1
12	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	0	315	0	315	[empty string]	315	[empty string]	ROSSI GALLERY 22LR SYN SA RIFLE	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH INT`L	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	RIFLE	16	300-to-350	0.00	[empty string]	Rossi Gallery 22lr Syn Sa Rifle	[empty string]	[empty string]	N	315	315	[empty string]	[empty string]	[empty string]	1000	RP22181SY	342843	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-gallery-22lr-syn-sa-rifle-342843	1
13	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	670	0	720	85980-DEFAULT-l.jpg	670	85980-DEFAULT-m.jpg	M92 CARBINE 357MAG 20IIN LEVER	N	11 JJ	357MAG / 38SPL	20IN	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH	CBC	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	LEVER	RIFLE	1	500-or-more	0.00	[empty string]	M92 Carbine 357mag 20iin Lever	[empty string]	[empty string]	N	720	720	[empty string]	85980-DEFAULT-s.jpg	[empty string]	1000	923572013	345687	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/m92-carbine-357mag-20iin-lever-345687	1
14	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Magazines	[empty string]	1	21.99	0	26.49	88033-DEFAULT-l.jpg	21.99	88033-DEFAULT-m.jpg	RB22M RB17 5RND MAGAZINE	N	11 JJ	22 MAGNUM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Rb22m Rb17 5rnd Magazine	[empty string]	[empty string]	N	26.49	26.49	[empty string]	88033-DEFAULT-s.jpg	[empty string]	1000	358-0002-00	346844	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	braztech-intl-lc/rb22m-rb17-5rnd-magazine-346844	1
15	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Magazines	[empty string]	1	21.99	0	26.49	87367-DEFAULT-l.jpg	21.99	87367-DEFAULT-m.jpg	RB22 10RND 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]	7	25-to-50	0.00	[empty string]	Rb22 10rnd Magazine	[empty string]	[empty string]	N	26.49	26.49	[empty string]	87367-DEFAULT-s.jpg	[empty string]	1000	358-0003-00	346845	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	braztech-intl-lc/rb22-10rnd-magazine-346845	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter