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	E64,E74,E71,E61,E63,E83,E70,E79,E65,E81,E82,E72,E62	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	E64\|NULL\|NULL,E74\|NULL\|NULL,E71\|NULL\|NULL,E61\|NULL\|NULL,E63\|NULL\|NULL,E83\|NULL\|NULL,E70\|NULL\|NULL,E79\|NULL\|NULL,E65\|NULL\|NULL,E81\|NULL\|NULL,E82\|NULL\|NULL,E72\|NULL\|NULL,E62\|NULL\|NULL	1	2.99	0	2.99	93463-DEFAULT-l.jpg	2.99	93463-DEFAULT-m.jpg	WOLFRAM JIG SIZE 4	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	189	5-AND-under	0.00	[empty string]	Wolfram Jig - 4mm	<p><span class=```TextRun`` xml:lang=```EN-US``` style=```margin:`` none=````><span class=```NormalTextRun`` style=```margin:``>Fiskas Wolfram Jigs are made from Tungsten. Fish heavy with smaller lures! Our jigs are designed at a 45 degree</span></span><span class=```TextRun`` xml:lang=```EN-US``` style=```margin:`` none=````><span class=```NormalTextRun`` style=```margin:``> angle for great action and Sticky Sharp Hooks: for the best hook set! You need to reduce jig size when ice fishing and Tungsten Fiskas</span></span><span class=```TextRun`` xml:lang=```EN-US``` style=```margin:`` none=````><span class=```NormalTextRun`` style=```margin:``> Wolfram Jigs to get back down to the fish once you find the school.</span></span></p>	[empty string]	N	2.99	2.99	[empty string]	93463-DEFAULT-s.jpg	[empty string]	1000	E-4	295965	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/wolfram-jig-size-4-295965	1
2	71	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	71\|NULL\|NULL	1	2.89	0	2.89	93462-DEFAULT-l.jpg	2.89	93462-DEFAULT-m.jpg	EPOXY WOLFRAM JIG SIZE 3	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	15	5-AND-under	0.00	[empty string]	Wolfram Jig - 3mm	<p><span class=``TextRun` xml:lang=``EN-US`` style=``margin:` padding:=`` user-select:=`` font-size:=`` font-family:=`` line-height:=`` font-variant-ligatures:=`` none=``><span class=``NormalTextRun` style=``margin:` padding:=`` user-select:=`` background-color:=``>Fiskas Wolfram Jigs are made from Tungsten. Fish heavy with smaller lures! Our jigs are designed at a 45 degree</span></span><span class=``TextRun` xml:lang=``EN-US`` style=``margin:` padding:=`` user-select:=`` font-size:=`` font-family:=`` line-height:=`` font-variant-ligatures:=`` none=``><span class=``NormalTextRun` style=``margin:` padding:=`` user-select:=`` background-color:=``> angle for great action and Sticky Sharp Hooks: for the best hook set! You need to reduce jig size when ice fishing and Tungsten Fiskas</span></span><span class=``TextRun` xml:lang=``EN-US`` style=``margin:` padding:=`` user-select:=`` font-size:=`` font-family:=`` line-height:=`` font-variant-ligatures:=`` none=``><span class=``NormalTextRun` style=``margin:` padding:=`` user-select:=`` background-color:=``> Wolfram Jigs to get back down to the fish once you find the school. </span></span></p>	[empty string]	N	2.89	2.89	[empty string]	93462-DEFAULT-s.jpg	[empty string]	1000	E-3	295966	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/epoxy-wolfram-jig-size-3-295966	1
3	E61,E65,E63,E72	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	E61\|NULL\|NULL,E65\|NULL\|NULL,E63\|NULL\|NULL,E72\|NULL\|NULL	1	3.09	0	3.09	93464-DEFAULT-l.jpg	3.09	93464-DEFAULT-m.jpg	WOLFGRAM JIG GLOW SZ.5	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	49	5-AND-under	0.00	[empty string]	Wolfram Jig - 5mm	<p><span class=```TextRun`` xml:lang=```EN-US``` style=```margin:`` none=````><span class=```NormalTextRun`` style=```margin:``>Fiskas Wolfram Jigs are made from Tungsten. Fish heavy with smaller lures! Our jigs are designed at a 45 degree</span></span><span class=```TextRun`` xml:lang=```EN-US``` style=```margin:`` none=````><span class=```NormalTextRun`` style=```margin:``> angle for great action and Sticky Sharp Hooks: for the best hook set! You need to reduce jig size when ice fishing and Tungsten Fiskas</span></span><span class=```TextRun`` xml:lang=```EN-US``` style=```margin:`` none=````><span class=```NormalTextRun`` style=```margin:``> Wolfram Jigs to get back down to the fish once you find the school.</span></span></p>	[empty string]	N	3.09	3.09	[empty string]	93464-DEFAULT-s.jpg	[empty string]	1000	E-5	295967	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/wolfgram-jig-glow-sz-5-295967	1
4	HP74,HP24,HP31,HP23,HP21,HP18,HP30,HP29	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	HP74\|NULL\|NULL,HP24\|NULL\|NULL,HP31\|NULL\|NULL,HP23\|NULL\|NULL,HP21\|NULL\|NULL,HP18\|NULL\|NULL,HP30\|NULL\|NULL,HP29\|NULL\|NULL	1	2.89	0	2.89	93466-DEFAULT-l.jpg	2.89	93466-DEFAULT-m.jpg	HANDPAINT WOLFRAM JIGS SIZE 4	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	112	5-AND-under	0.00	[empty string]	Handpainted Wolfram Jigs - 4mm	<p>Fiskas Wolfram Jigs are made from Tungsten. Fish heavy with smaller lures! Our jigs are designed at a 45 degree angle for great action and Sticky Sharp Hooks for the best hook set!</p>	[empty string]	N	2.89	2.89	[empty string]	93466-DEFAULT-s.jpg	[empty string]	1000	HP-4 JIG	295971	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/handpaint-wolfram-jigs-size-4-295971	1
5	HP31,HP30,HP29	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	HP31\|NULL\|NULL,HP30\|NULL\|NULL,HP29\|NULL\|NULL	1	2.99	0	2.99	93467-DEFAULT-l.jpg	2.99	93467-DEFAULT-m.jpg	HANDPAINT WOLFRAM JIGS SIZE 5	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	39	5-AND-under	0.00	[empty string]	Handpainted Wolfram Jigs - 5mm	<p>Fiskas Wolfram Jigs are made from Tungsten. Fish heavy with smaller lures! Our jigs are designed at a 45 degree angle for great action and Sticky Sharp Hooks for the best hook set!</p>	[empty string]	N	2.99	2.99	[empty string]	93467-DEFAULT-s.jpg	[empty string]	1000	HP-5	295972	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/handpaint-wolfram-jigs-size-5-295972	1
6	01,05	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	01\|NULL\|NULL,05\|NULL\|NULL	1	2.69	0	2.69	93468-DEFAULT-l.jpg	2.69	93468-DEFAULT-m.jpg	FISKAS BALANCE MINNOW	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	53	5-AND-under	0.00	[empty string]	Fiskas Balance - Minnow	<p>Perch can`t resist the unique action of this Fiskas Balance Jig. Top quality ice fishing lures fish best on the drop. Also Works for walleyes, smallmouth and pike.</p>	[empty string]	N	2.69	2.69	[empty string]	93468-DEFAULT-s.jpg	[empty string]	1000	N46	295976	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/fiskas-balance-minnow-295976	1
7	05,06,10	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	05\|NULL\|NULL,06\|NULL\|NULL,10\|NULL\|NULL	1	2.69	0	2.69	93469-DEFAULT-l.jpg	2.69	93469-DEFAULT-m.jpg	FISKAS BALANCE GRUB	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	42	5-AND-under	0.00	[empty string]	Fiskas Balance - Grub	<p>Unique Fiskas Balances have proven fish catching ability from bluegills and crappies to perch, walleyes, and pike. These large grubs work well tipped with live or plastic baits. Fiskas Balances are made with top quality hooks and paint finishes.</p> <p> </p>	[empty string]	N	2.69	2.69	[empty string]	93469-DEFAULT-s.jpg	[empty string]	1000	N37	295978	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/fiskas-balance-grub-295978	1
8	37,62,07,25,54,35,08	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	37\|NULL\|NULL,62\|NULL\|NULL,07\|NULL\|NULL,25\|NULL\|NULL,54\|NULL\|NULL,35\|NULL\|NULL,08\|NULL\|NULL	1	1.69	0	1.69	93471-DEFAULT-l.jpg	1.69	93471-DEFAULT-m.jpg	MICRO NUGGIES	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	149	5-AND-under	0.00	[empty string]	Micro Nuggies	<p>The design of the Micro-Nuggies tail produces an action that is irresistible to panfish such as slab crappies, big bluegills and schooling perch. C9 is the special scent formula that is impregnated into all Little Atom soft plastic baits.</p>	[empty string]	N	1.69	1.69	[empty string]	93471-DEFAULT-s.jpg	[empty string]	1000	MNG	310540	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/micro-nuggies-310540	1
9	62,26,07,15,08,47,12	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	62\|NULL\|NULL,26\|NULL\|NULL,07\|NULL\|NULL,15\|NULL\|NULL,08\|NULL\|NULL,47\|NULL\|NULL,12\|NULL\|NULL	1	1.69	0	1.69	93473-DEFAULT-l.jpg	1.69	93473-DEFAULT-m.jpg	WEDGEES 1.5 IN	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	132	5-AND-under	0.00	[empty string]	Wedgees - 1.5 Inch	<p>The extreme taper in the tail of the Wedgees produces an action that is irresistible to panfish such as slab crappies, big bluegills and schooling perch. C9 is the special scent formula that is impregnated into all Little Atom soft plastic baits.</p>	[empty string]	N	1.69	1.69	[empty string]	93473-DEFAULT-s.jpg	[empty string]	1000	WDG	310541	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/wedgees-1-5-in-310541	1
10	UV06,UV04,UV02,UV03,UV05,UV08,UV01	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	UV06\|NULL\|NULL,UV04\|NULL\|NULL,UV02\|NULL\|NULL,UV03\|NULL\|NULL,UV05\|NULL\|NULL,UV08\|NULL\|NULL,UV01\|NULL\|NULL	1	2.89	0	2.89	93472-DEFAULT-l.jpg	2.89	93472-DEFAULT-m.jpg	WOLFGRAM JIG 4MM UV	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	76	5-AND-under	0.00	[empty string]	Wolfram Uv Jigs - 4mm	<p>Fiskas UV Series have reflective paint patterns that attract fish. Fish see in UV and even in low sunlight conditions - this can make a big difference! UV is not glow, but in sunlight will flouresce.</p>	[empty string]	N	2.89	2.89	4MM	93472-DEFAULT-s.jpg	[empty string]	1000	UV	310542	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/wolfgram-jig-4mm-uv-310542	1
11	05	YOUR BOBBERS DOWN	Your Bobbers Down	FISHING	Fishing>Specialty>Ice Fishing>Tackle	05\|NULL\|NULL	1	1.99	0	1.99	93470-DEFAULT-l.jpg	1.99	93470-DEFAULT-m.jpg	MICRO GRUB ICE JIG	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[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]	13	5-AND-under	0.00	[empty string]	Micro Grub Ice Jig	[empty string]	[empty string]	N	1.99	1.99	31	93470-DEFAULT-s.jpg	[empty string]	1000	N31	344683	ICE FISHING	TACKLE	EMPTY	0	0	0	SPECIALTY	[empty string]	your-bobbers-down/micro-grub-ice-jig-344683	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

31
4MM

Filter