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	710	0	770	86927-DEFAULT-l.jpg	710	86927-DEFAULT-m.jpg	ROSSI M92 44MAG 20IN LEVER RIFLE	N	11 JJ	44 MAG	20IN	[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]	Rossi M92 44mag 20in Lever Rifle	[empty string]	[empty string]	N	770	770	[empty string]	86927-DEFAULT-s.jpg	[empty string]	1000	920442093	296986	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-m92-44mag-20in-lever-rifle-296986	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	1	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	1	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	10	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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	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]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	31	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	8	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]	1	665	0	715	86840-DEFAULT-l.jpg	665	86840-DEFAULT-m.jpg	ROSSI M92 45LC 16IN LEVER RIFLE	N	11 JJ	45 COLT	16IN	[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]	Rossi M92 45lc 16in Lever Rifle	[empty string]	[empty string]	N	715	715	[empty string]	86840-DEFAULT-s.jpg	[empty string]	1000	920451613	337658	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/rossi-m92-45lc-16in-lever-rifle-337658	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	2	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>Shotguns	[empty string]	0	165	0	185	[empty string]	165	[empty string]	ROSSI TUFFY 410GA 18.5IN TAN 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 Tan Syn	[empty string]	[empty string]	N	185	185	[empty string]	[empty string]	[empty string]	1000	SSP1-TAN	342292	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	braztech-intl-lc/rossi-tuffy-410ga-18-5in-tan-syn-342292	1
12	[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	9	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
13	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	0	295	0	315	[empty string]	295	[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
14	[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	2	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
15	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Rifles	[empty string]	1	695	0	755	86553-DEFAULT-l.jpg	695	86553-DEFAULT-m.jpg	CIRCUIT JUDGE TACT GREEN 45LC 410GA 18.5IN	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	COMBINATION	1	500-or-more	0.00	[empty string]	Circuit Judge Tact Green 45lc 410ga 18.5in	[empty string]	[empty string]	N	755	755	[empty string]	86553-DEFAULT-s.jpg	[empty string]	1000	SCJT4510B	346144	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	braztech-intl-lc/circuit-judge-tact-green-45lc-410ga-18-5in-346144	1
16	[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]	[empty string]	[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
17	[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]	8	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
18	[empty string]	BRAZTECH INTL LC	Braztech Intl Lc	FIREARMS	Firearms>Shotguns	[empty string]	1	185	0	185	88034-DEFAULT-l.jpg	185	88034-DEFAULT-m.jpg	ROSSI TUFFY 410GA 18.5IN GRAY 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 Gray Syn	[empty string]	[empty string]	N	185	185	[empty string]	88034-DEFAULT-s.jpg	[empty string]	1000	SSP1-GRAY	356608	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	braztech-intl-lc/rossi-tuffy-410ga-18-5in-gray-syn-356608	1

CACHED

false

EXECUTIONTIME

1

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter