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	CLEAR	SUNLINE PRODUCTS	Sunline Products	ICE FISHING	Ice Fishing>ICE TACKLE	CLEAR\|NULL\|NULL	1	13.99	0	13.99	93457-DEFAULT-l.jpg	13.99	93457-DEFAULT-m.jpg	FC ICE PREMIUM CLEAR 1 LB.	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	NOT ONLINE	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	FC ICE PREMIUM - CLEAR - 1 LB	<p>100% fluorocarbon designed for ice fishing featuring low memory for better bite detection and easy handling in extreme cold conditions. Formulated with high abrasion resistance to protect against sharp ice edges. Excellent knot strength.</p> <p> </p> <ul> <li>Color: Clear</li> <li>Yards: 100</li> <li>LB Test: 1</li> </ul>	[empty string]	N	13.99	13.99	1LB	93457-DEFAULT-s.jpg	[empty string]	1000	63042330	278743	EMPTY	EMPTY	EMPTY	0	0	0	ICE TACKLE	[empty string]	sunline-products/fc-ice-premium-clear-1-lb-278743	1
2	CLEAR	SUNLINE PRODUCTS	Sunline Products	ICE FISHING	Ice Fishing>ICE TACKLE	CLEAR\|NULL\|NULL	1	13.99	0	13.99	93458-DEFAULT-l.jpg	13.99	93458-DEFAULT-m.jpg	FC ICE PREMIUM CLEAR 2 LB.	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	NOT ONLINE	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	FC ICE PREMIUM - CLEAR - 2 LB	<p>100% fluorocarbon designed for ice fishing featuring low memory for better bite detection and easy handling in extreme cold conditions. Formulated with high abrasion resistance to protect against sharp ice edges. Excellent knot strength.</p> <p> </p> <ul> <li>Color: Clear</li> <li>Yards: 100</li> <li>LB Test: 2</li> </ul>	[empty string]	N	13.99	13.99	2LB	93458-DEFAULT-s.jpg	[empty string]	1000	63042332	278744	EMPTY	EMPTY	EMPTY	0	0	0	ICE TACKLE	[empty string]	sunline-products/fc-ice-premium-clear-2-lb-278744	1
3	GOLD	SUNLINE PRODUCTS	Sunline Products	ICE FISHING	Ice Fishing>ICE TACKLE	GOLD\|NULL\|NULL	1	13.99	0	13.99	93459-DEFAULT-l.jpg	13.99	93459-DEFAULT-m.jpg	FC ICE PREMIUM GOLD 1 LB.	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	NOT ONLINE	[empty string]	[empty string]	16	10-to-15	0.00	[empty string]	FC ICE PREMIUM - GOLD - 1 LB	<p>100% fluorocarbon designed for ice fishing featuring low memory for better bite detection and easy handling in extreme cold conditions. Formulated with high abrasion resistance to protect against sharp ice edges. Excellent knot strength.</p> <p> </p> <ul> <li>Color: Gold</li> <li>Yards: 100</li> <li>LB Test: 1</li> </ul>	[empty string]	N	13.99	13.99	1LB	93459-DEFAULT-s.jpg	[empty string]	1000	63042350	278746	EMPTY	EMPTY	EMPTY	0	0	0	ICE TACKLE	[empty string]	sunline-products/fc-ice-premium-gold-1-lb-278746	1
4	GOLD	SUNLINE PRODUCTS	Sunline Products	ICE FISHING	Ice Fishing>ICE TACKLE	GOLD\|NULL\|NULL	1	13.99	0	13.99	73201-DEFAULT-l.jpg	13.99	73201-DEFAULT-m.jpg	FC ICE PREMIUM GOLD 2 LB.	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	NOT ONLINE	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	FC ICE PREMIUM - GOLD - 2 LB	<p>100% fluorocarbon designed for ice fishing featuring low memory for better bite detection and easy handling in extreme cold conditions. Formulated with high abrasion resistance to protect against sharp ice edges. Excellent knot strength.</p> <p> </p> <ul> <li>Color: Gold</li> <li>Yards: 100</li> <li>LB Test: 2</li> </ul>	[empty string]	N	13.99	13.99	2LB	73201-DEFAULT-s.jpg	[empty string]	1000	63042352	278747	EMPTY	EMPTY	EMPTY	0	0	0	ICE TACKLE	[empty string]	sunline-products/fc-ice-premium-gold-2-lb-278747	1
5	CLEAR	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Fluorocarbon	CLEAR\|NULL\|NULL	1	16.99	0	16.99	63962-DEFAULT-l.jpg	16.99	63962-DEFAULT-m.jpg	SUPER FLUOROCARBON 200YDS	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	152	15-to-20	0.00	[empty string]	Super Fluorocarbon - 200 Yards	<p>FEATURES:<br /> -100% fluorocarbon<br /> -Sunline’s entry level fc product<br /> -Single resin processing 200 yd spool. 660yd and 1200 yd coming soon<br /> -High abrasion resistance and knot strength<br /> -Uniform line diameter</p>	[empty string]	N	16.99	16.99	10,12,14,8,25,16,20	63962-DEFAULT-s.jpg	[empty string]	1000	SUPER FLUOROCARBON	300323	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/super-fluorocarbon-200yds-300323	1
6	CLEAR	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Fluorocarbon	CLEAR\|NULL\|NULL	1	12.49	0	12.49	63964-DEFAULT-l.jpg	12.49	63964-DEFAULT-m.jpg	FC LEADER 50 YD.	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	39	10-to-15	0.00	[empty string]	Fc Leader - 50 Yards	<p>FEATURES:<br /> -Designed specifically for leader and top shot applications<br /> -Uses Sunline`s E3 raw material that makes the perfect balance of tensile, and knot strength combined with stretch for optimum leader performance<br /> -Sunline`s TRP processing for better abraision resistance and improved knot tying<br /> -100% Fluorocarbon with 1.78 specific gravity<br /> -Low water absorption for negligible strength loss under water</p>	[empty string]	N	12.49	12.49	20,12,6,16,10	63964-DEFAULT-s.jpg	[empty string]	1000	FC LEADER	300337	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/fc-leader-50-yd-300337	1
7	NATURAL CLEAR	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Fluorocarbon	NATURAL CLEAR\|NULL\|NULL	1	26.99	1	22.99	63965-DEFAULT-l.jpg	26.99	63965-DEFAULT-m.jpg	SUPER FC SNIPER 200 YD	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	76	20-to-25	0.00	[empty string]	Super Fc Sniper - 200 Yards	<p>FEATURES:<br /> -High abrasion resistanc Uniform line diameter<br /> -Triple resin coating for suppleness<br /> -2lb-5 lb tests are popular with light line anglers<br /> -5lb-7lb tests are popular with finesse bass anglers particularly drop shot and shakey head anglers<br /> -7lb is the best selling size for spinning reels - the pros favor it for its’s combination of strength and how well it performs on spinning reels<br /> -The larger sizes perform well for all baits cast applications</p>	[empty string]	N	22.99	26.99	8,6,10,12,5	63965-DEFAULT-s.jpg	[empty string]	1000	SUPER FC SNIPER 200	300348	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/super-fc-sniper-200-yd-300348	1
8	CLEAR	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Fluorocarbon	CLEAR\|NULL\|NULL	0	45.99	0	45.99	[empty string]	45.99	[empty string]	SUPER FLUOROCARBON 660YDS	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Super Fluorocarbon - 660 Yards	<p>FEATURES:<br /> -100% fluorocarbon<br /> -Sunline’s entry level FC product<br /> -Single resin processing 660 yards<br /> -High abrasion resistance and knot strength<br /> -Uniform line diameter</p>	[empty string]	N	45.99	45.99	16,20,8,12	[empty string]	[empty string]	1000	SUPER FLUOROCARBON 660	304095	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/super-fluorocarbon-660yds-304095	1
9	NATURAL CLEAR	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Fluorocarbon	NATURAL CLEAR\|NULL\|NULL	1	87.99	1	57.99	63967-DEFAULT-l.jpg	87.99	63967-DEFAULT-m.jpg	FC SNIPER 660YDS	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	Fc Sniper 660yds	[empty string]	[empty string]	N	57.99	87.99	7,6,8,16,20	63967-DEFAULT-s.jpg	[empty string]	1000	SUPER FC SNIPER 660	304100	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/fc-sniper-660yds-304100	1
10	VIVIDYELLOW	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Monofilament	VIVIDYELLOW\|NULL\|NULL	0	21.99	0	21.99	[empty string]	21.99	[empty string]	FINE FLOAT II P-ION	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Fine Float Ii - 16 Lb	<p>Fine Float II features P-ion technology incorporated into Sunline`s highly popular, long selling signature floating line. P-ion processing improves surface texture and water repellency for increased and longer lasting performance. The P-ion process extends the life of a line by providing greater protection from molecular bonding on the surface of the line. The already slick surface of Fine Float has now been increased 40% in Fine Float II.  The reduces guide and float friction and even the lightest weight rigs can be cast farther.</p>	[empty string]	N	21.99	21.99	16	[empty string]	[empty string]	1000	FINE FLOAT II P-ION	304106	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/fine-float-ii-p-ion-304106	1
11	DARK GREEN	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Braided	DARK GREEN\|NULL\|NULL	0	10.99	0	10.99	[empty string]	10.99	[empty string]	SIGLON PEX4 165YD	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	62	10-to-15	0.00	[empty string]	Siglon F Monofilament Line	<p>Siglon F is a nylon line featuring resin reinforcement processing for a moisture proof, curl free, strong and shock resistant line.</p> <p>nbsp;</p> <p>-UV resistant processing protects from UV rays and prevents fading or damage<br /> -Great product for panfish, trout and steelhead fishing</p>	[empty string]	N	10.99	10.99	50,10,12,16,40,20,30	[empty string]	[empty string]	1000	SIGLON PEX4	314448	EMPTY	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/siglon-pex4-165yd-314448	1
12	CLEAR	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Fluorocarbon	CLEAR\|NULL\|NULL	1	43.99	1	39.99	92116-DEFAULT-l.jpg	43.99	92116-DEFAULT-m.jpg	SHOOTER FLUOROCARBON LINE 150M	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Shooter Fluorocarbon Line 150m	[empty string]	[empty string]	N	39.99	43.99	16LBS,12LBS,20LBS	92116-DEFAULT-s.jpg	[empty string]	1000	SHOOTER	321843	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/shooter-fluorocarbon-line-150m-321843	1
13	LTGREEN	SUNLINE PRODUCTS	Sunline Products	FISHING	Fishing>Line and Leader>Braided	LTGREEN\|NULL\|NULL	0	42.99	0	42.99	[empty string]	42.99	[empty string]	XPLASMA ASEGAI BRAID LINE	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Xplasma Asegai Braid Line	[empty string]	[empty string]	N	42.99	42.99	12LB,10LB	[empty string]	[empty string]	1000	XPLASMA	329995	EMPTY	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	sunline-products/xplasma-asegai-braid-line-329995	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter