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]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Spinning	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	GAR VENERATE SPINNING ROD VNRTS662-5	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DISC	NOT ONLINE	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Venerate - Spinning - 6 Feet 6 Inches - Medium	<p>The Venerate series is engineered for anglers looking for spinning rods with the fastest actions with the lightest tips. Constructed from 36 Ton graphite and the highest grade cork handles, this series delivers exceptional comfort and sensitivity. Fast and Extra Fast actions have a Midwest focus and are suitable for a variety of walleye fishing techniques as well as other finesse applications. Other high end refinements include a carbon locking hood design and Titanium alloy guides with Zirconium inserts.</p>	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	VNRTS662-5	260460	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/gar-venerate-spinning-rod-vnrts662-5-260460	1
2	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Spinning	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	GAR VERITAS VTSC69-6	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	PICK-UP ONLY	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Veritas - Casting - 6 Feet 9 Inches - Medium Heavy	<p>Abu Garcia's most renowned rod series now with increased comfort and improved weight and balance. Veritas rods combine a 30 ton construction with Sublayer Armor for uncompromising strength and sensitivity in a lightweight, balanced design. Their Abu designed up locking micro click reel seat design offers secure connection between the rod and reel and the ultimate in comfort.</p>	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	VTSC69-6	292194	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/gar-veritas-vtsc69-6-292194	1
3	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Trolling	[empty string]	0	79.99	0	79.99	[empty string]	79.99	[empty string]	AMBASSADEUR S LINE COUNTER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Ambassadeur S Line Counter	[empty string]	[empty string]	N	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	AMBS-5500LC	322726	TROLLING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/ambassadeur-s-line-counter-322726	1
4	AVERICE29M	ABU GARCIA	Abu Garcia	FISHING	Fishing>Specialty>Ice Fishing>Tackle	AVERICE29M\|NULL\|NULL	1	42.99	0	42.99	89809-DEFAULT-l.jpg	42.99	89809-DEFAULT-m.jpg	VERACITY ICE SPINNING ROD 29IN MED	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	WINTER	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Veracity Ice Spinning Rod 29in Med	[empty string]	[empty string]	N	42.99	42.99	29IN	89809-DEFAULT-s.jpg	[empty string]	1000	AVERICE29M	330718	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	abu-garcia/veracity-ice-spinning-rod-29in-med-330718	1
5	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	1	99.99	0	99.99	53816-DEFAULT-l.jpg	99.99	53816-DEFAULT-m.jpg	MAXPRO30SP/EAG70M BAIT SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Maxpro30sp/eag70m Bait Spin Combo	[empty string]	[empty string]	N	99.99	99.99	[empty string]	53816-DEFAULT-s.jpg	[empty string]	1000	MAX-EAG70MHCBO	338583	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/maxpro30sp-eag70m-bait-spin-combo-338583	1
6	5501,6501,5500,6500	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	5501\|NULL\|NULL,6501\|NULL\|NULL,5500\|NULL\|NULL,6500\|NULL\|NULL	1	69.99	1	59.99	78812-DEFAULT-l.jpg	69.99	78812-DEFAULT-m.jpg	AMBASSADEUR S ROUND REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	25	50-to-100	0.00	[empty string]	Ambassadeur S Round Reel	[empty string]	[empty string]	N	59.99	69.99	[empty string]	78812-DEFAULT-s.jpg	[empty string]	1000	AMBS	340908	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/ambassadeur-s-round-reel-340908	1
7	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	[empty string]	1	99.99	0	99.99	53816-DEFAULT-l.jpg	99.99	53816-DEFAULT-m.jpg	VERITAS WINCH CASTING ROD 70-6 MH	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Veritas Winch Casting Rod 70-6 Mh	[empty string]	[empty string]	N	99.99	99.99	[empty string]	53816-DEFAULT-s.jpg	[empty string]	1000	VTPCW70-6	340916	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-winch-casting-rod-70-6-mh-340916	1
8	767H,737H,705M	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	767H\|NULL\|NULL,737H\|NULL\|NULL,705M\|NULL\|NULL	1	79.99	0	79.99	53816-DEFAULT-l.jpg	79.99	53816-DEFAULT-m.jpg	VENDETTA CASTING ROD 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Vendetta Casting Rod 1pc	[empty string]	[empty string]	N	79.99	79.99	[empty string]	53816-DEFAULT-s.jpg	[empty string]	1000	VDTC	340922	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/vendetta-casting-rod-1pc-340922	1
9	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	1	74.99	0	74.99	78812-DEFAULT-l.jpg	74.99	78812-DEFAULT-m.jpg	MAXX SP 7`0 1PC M SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Maxx Sp 7`0 1pc M Spin Combo	[empty string]	[empty string]	N	74.99	74.99	[empty string]	78812-DEFAULT-s.jpg	[empty string]	1000	MAXXSP60/701MH	341244	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/maxx-sp-7-0-1pc-m-spin-combo-341244	1
10	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Spinning	[empty string]	1	37.99	1	32.99	78812-DEFAULT-l.jpg	37.99	78812-DEFAULT-m.jpg	MAXX SP SPINNING REEL BOX	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	24	25-to-50	0.00	[empty string]	Maxx Sp Spinning Reel Box	[empty string]	[empty string]	N	32.99	37.99	30,40,10,20,5	78812-DEFAULT-s.jpg	[empty string]	1000	MAXXSP	341248	SPINNING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/maxx-sp-spinning-reel-box-341248	1
11	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	1	109.99	0	109.99	78812-DEFAULT-l.jpg	109.99	78812-DEFAULT-m.jpg	MAX PRO 7 MH SPIN COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Max Pro 7 Mh Spin Combo 1pc	[empty string]	[empty string]	N	109.99	109.99	[empty string]	78812-DEFAULT-s.jpg	[empty string]	1000	MAXPRO/701MH	350655	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/max-pro-7-mh-spin-combo-1pc-350655	1
12	ROCKET,ROCKET-L	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	ROCKET\|NULL\|NULL,ROCKET-L\|NULL\|NULL	1	299.99	0	299.99	91765-DEFAULT-l.jpg	299.99	91765-DEFAULT-m.jpg	REVO ROCKET LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	6	250-to-300	0.00	[empty string]	Revo Rocket Low Profile Reel	[empty string]	[empty string]	N	299.99	299.99	10.1:1	91765-DEFAULT-s.jpg	[empty string]	1000	REVO4-ROCKET	353723	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/revo-rocket-low-profile-reel-353723	1
13	RH-40,LH-41	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	RH-40\|NULL\|NULL,LH-41\|NULL\|NULL	0	279.99	0	279.99	[empty string]	279.99	[empty string]	REVO BEAST LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	2	250-to-300	0.00	[empty string]	Revo Beast Low Profile Reel	[empty string]	[empty string]	N	279.99	279.99	7.3:1HS	[empty string]	[empty string]	1000	REVO-BEAST	353724	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/revo-beast-low-profile-reel-353724	1
14	C3,C4	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	C3\|NULL\|NULL,C4\|NULL\|NULL	1	129.99	1	119.99	90562-DEFAULT-l.jpg	129.99	90562-DEFAULT-m.jpg	AMBASSADEUR ROUND REEL CLASSIC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	21	100-to-150	0.00	[empty string]	Ambassadeur Round Reel Classic	[empty string]	[empty string]	N	119.99	129.99	5501-L,6500-HS,6501-HS-L,5500	90562-DEFAULT-s.jpg	[empty string]	1000	C3/C4	353791	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/ambassadeur-round-reel-classic-353791	1
15	MAX4XL,MAX4X	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	MAX4XL\|NULL\|NULL,MAX4X\|NULL\|NULL	0	54.99	0	54.99	[empty string]	54.99	[empty string]	MAX X LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	12	50-to-100	0.00	[empty string]	Max X Low Profile Reel	[empty string]	[empty string]	N	54.99	54.99	6.4:1	[empty string]	[empty string]	1000	MAX4X	353826	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/max-x-low-profile-reel-353826	1
16	X,S	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	X\|NULL\|NULL,S\|NULL\|NULL	1	129.99	1	99.99	91473-DEFAULT-l.jpg	129.99	91473-DEFAULT-m.jpg	REVO LOW PROFILE REEL S/X	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	9	50-to-100	0.00	[empty string]	Revo Low Profile Reel S/x	[empty string]	[empty string]	N	99.99	129.99	6.6:1,6.6:1L,7.3:1HS	91473-DEFAULT-s.jpg	[empty string]	1000	REVO4	353840	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/revo-low-profile-reel-s-x-353840	1
17	ZATA	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	ZATA\|NULL\|NULL	1	169.99	0	169.99	78812-DEFAULT-l.jpg	169.99	78812-DEFAULT-m.jpg	ZATA LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Zata Low Profile Reel	[empty string]	[empty string]	N	169.99	169.99	7.1:1HSL	78812-DEFAULT-s.jpg	[empty string]	1000	ZATA	353868	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/zata-low-profile-reel-353868	1
18	69-6 MH,73-6 MH,70-7 H,76-7 H,70-5 M,610-4 ML,610-6 MH,70-6 MH,73-7 H	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	69-6 MH\|NULL\|NULL,73-6 MH\|NULL\|NULL,70-7 H\|NULL\|NULL,76-7 H\|NULL\|NULL,70-5 M\|NULL\|NULL,610-4 ML\|NULL\|NULL,610-6 MH\|NULL\|NULL,70-6 MH\|NULL\|NULL,73-7 H\|NULL\|NULL	0	119.99	1	99.99	[empty string]	119.99	[empty string]	VERITAS CASTING ROD	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	25	50-to-100	0.00	[empty string]	Veritas Casting Rod	[empty string]	[empty string]	N	99.99	119.99	VTPC	[empty string]	[empty string]	1000	VTPC	356877	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-casting-rod-356877	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter