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]	SNIDERS TACKLE	Sniders Tackle	FISHING	Fishing>Combos>Ice	[empty string]	0	20	0	20	[empty string]	20	[empty string]	STN ICE POLE COMBO 25IN	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]	DISC	NOT ONLINE	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Stn Ice Pole Combo 25in	[empty string]	[empty string]	N	20	20	[empty string]	[empty string]	[empty string]	1000	81026	65296	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	sniders-tackle/stn-ice-pole-combo-25in-65296	1
2	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	0	0	0	24.99	[empty string]	0	[empty string]	ST CROIX ICE COMBO CASE	N	7.1 RANDY	[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]	1	20-to-25	0.00	[empty string]	Ice Rod Combo Case	St. Croix ice rod case is made of durable nylon canvas and features a handy carrying strap.	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	IRC34	66648	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/st-croix-ice-combo-case-66648	1
3	[empty string]	EAGLE CLAW	Eagle Claw	FISHING	Fishing>Combos>Ice	[empty string]	1	16.99	0	16.99	61473-DEFAULT-l.jpg	16.99	61473-DEFAULT-m.jpg	ICE EAGLE LT SPIN COMBO 24 IN	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	[empty string]	[empty string]	[empty string]	DISC	ONLINE	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Ice Eagle Combo - Spinning - 24 Inches - Light	<p>FEATURES:<br /> -Strong fiberglass blank<br /> -Soft sensitive tip<br /> -Graphite body reel<br /> -Smooth drag</p>	[empty string]	N	16.99	16.99	[empty string]	61473-DEFAULT-s.jpg	[empty string]	1000	IE24L1C	99236	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	eagle-claw/ice-eagle-lt-spin-combo-24-in-99236	1
4	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	0	39.99	0	64.99	[empty string]	39.99	[empty string]	ST CROIX PREMIER ICE COMBO PIC24ML	N	7.1 RANDY	[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	NOT ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	St Croix Premier Ice Combo Pic24ml	[empty string]	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	PIC24ML	138975	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/st-croix-premier-ice-combo-pic24ml-138975	1
5	[empty string]	EAGLE CLAW	Eagle Claw	FISHING	Fishing>Combos>Ice	[empty string]	0	44.99	0	44.99	[empty string]	44.99	[empty string]	COLD SMOKE INLINE ICE COMBO LT.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	[empty string]	[empty string]	[empty string]	DISC	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Cold Smoke Inline Ice Combo - 24 Inches - Light	FEATURES:<br/> -S-Curve graphite is light and sensitive<br/> -Inline ice reel<br/> -4+1 ball bearing<br/> -Smooth Teflon drag<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	ECCSIL24LC	158452	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	eagle-claw/cold-smoke-inline-ice-combo-lt-158452	1
6	[empty string]	EAGLE CLAW	Eagle Claw	FISHING	Fishing>Combos>Ice	[empty string]	1	44.99	0	44.99	33361-DEFAULT-l.jpg	44.99	33361-DEFAULT-m.jpg	COLD SMOKE INLINE ICE COMBO 24IN.UL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	[empty string]	[empty string]	[empty string]	DISC	ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Cold Smoke Inline Ice Combo - 24 Inches - Ultra Light	<p>FEATURES:<br /> -S-Curve graphite is light and sensitive<br /> -Inline ice reel<br /> -4+1 ball bearing<br /> -Smooth Teflon drag</p>	[empty string]	N	44.99	44.99	[empty string]	33361-DEFAULT-s.jpg	[empty string]	1000	ECCSIL24ULC	161980	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	eagle-claw/cold-smoke-inline-ice-combo-24in-ul-161980	1
7	[empty string]	EAGLE CLAW	Eagle Claw	FISHING	Fishing>Combos>Ice	[empty string]	1	44.99	0	44.99	33365-DEFAULT-l.jpg	44.99	33365-DEFAULT-m.jpg	COLD SMOKE INLINE ICE COMBO 28IN.MED.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	[empty string]	[empty string]	[empty string]	DISC	ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Cold Smoke Inline Ice Combo - 28 Inches - Medium	<p>FEATURES:<br /> -S-Curve graphite is light and sensitive<br /> -Inline ice reel<br /> -4+1 ball bearing<br /> -Smooth Teflon drag</p>	[empty string]	N	44.99	44.99	[empty string]	33365-DEFAULT-s.jpg	[empty string]	1000	ECCSIL28MC	161983	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	eagle-claw/cold-smoke-inline-ice-combo-28in-med-161983	1
8	24UL,26ML,30M,27L,24ML	BERKLEY	BERKLEY	FISHING	Fishing>Combos>Ice	24UL\|NULL\|NULL,26ML\|NULL\|NULL,30M\|NULL\|NULL,27L\|NULL\|NULL,24ML\|NULL\|NULL	0	14.99	0	14.99	[empty string]	14.99	[empty string]	ICE 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]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	9	10-to-15	0.00	[empty string]	Cherrywood Hd Ice Combo	<p>The Berkley Cherrywood ICE Combo is ultralight and pre-spooled. </p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	CWIS	173602	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	berkley/ice-combo-173602	1
9	28M	BERKLEY	BERKLEY	FISHING	Fishing>Combos>Ice	28M\|NULL\|NULL	0	14.99	0	14.99	[empty string]	14.99	[empty string]	BERKLEY RED ICE 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]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	Berkley Red Ice Combo	[empty string]	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	FUEL-CBO	173611	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	berkley/berkley-red-ice-combo-173611	1
10	24UL	BERKLEY	BERKLEY	FISHING	Fishing>Combos>Ice	24UL\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	GLACIER ICE COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[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]	1	15-to-20	0.00	[empty string]	Glacier Ice Combo	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	GLA-CBO	173612	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	berkley/glacier-ice-combo-173612	1
11	[empty string]	SHAKESPEARE	Shakespeare	FISHING	Fishing>Combos>Ice	[empty string]	1	24.99	0	24.99	91190-DEFAULT-l.jpg	24.99	91190-DEFAULT-m.jpg	UGLY STIK ICE 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]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Ugly Stik Ice Combo	[empty string]	[empty string]	N	24.99	24.99	[empty string]	91190-DEFAULT-s.jpg	[empty string]	1000	LADYGICE26MLCBO	242086	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	shakespeare/ugly-stik-ice-combo-242086	1
12	[empty string]	BERKLEY	BERKLEY	FISHING	Fishing>Combos>Ice	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	MITCHELL ICE 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]	[empty string]	[empty string]	[empty string]	DISC	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Mitchell Ice Combo	[empty string]	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	MRZICE26ULCBO	276752	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	berkley/mitchell-ice-combo-276752	1
13	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Combos>Ice	[empty string]	1	19.99	0	19.99	90584-DEFAULT-l.jpg	19.99	90584-DEFAULT-m.jpg	QUANTUM ICE GREEN COMBO	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]	8	15-to-20	0.00	[empty string]	Quantum Ice Green Combo	[empty string]	[empty string]	N	19.99	19.99	24L.NS4,28M.NS4,24ML.NS4,26UL.NS4,26ML.NS4	90584-DEFAULT-s.jpg	[empty string]	1000	QIGRUL	303326	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	zebco/quantum-ice-green-combo-303326	1
14	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Combos>Ice	[empty string]	1	29.99	0	29.99	73485-DEFAULT-l.jpg	29.99	73485-DEFAULT-m.jpg	QUANTUM GLACIER X ICE COMBO	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	PROP 65	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Glacier X Ice Combo - Spinning	<p>Glacier X Combos feature a 5sz reel with 3 bearings and Continuous Anti-Reverse clutch and solid carbon rod blank.</p>	[empty string]	N	29.99	29.99	24UL.NS4	73485-DEFAULT-s.jpg	[empty string]	1000	GLX05	303327	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	zebco/quantum-glacier-x-ice-combo-303327	1
15	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Combos>Ice	[empty string]	1	59.99	0	59.99	73487-DEFAULT-l.jpg	59.99	73487-DEFAULT-m.jpg	QUANTUM GLACIER XTI ICE COMBO	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	PROP 65	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Glacier Xti Ice Combo - Spinning	<p>Glacier XTi Combos feature a 5sz reel with 8 bearings, Continuous Anti-Reverse clutch, R·E·D graphite uni-body design and Carbon reel seat.</p>	[empty string]	N	59.99	59.99	24MLDISC	73487-DEFAULT-s.jpg	[empty string]	1000	GLXTI05	303329	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	zebco/quantum-glacier-xti-ice-combo-303329	1
16	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	0	74.99	0	74.99	[empty string]	74.99	[empty string]	ST CROIX PREMIER ICE COMBO PIC36M	N	7.1 RANDY	[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	NOT ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Premier Ice Combo - 28 Inches - Medium	FEATURES:<br/> -Solid carbon blank for extreme sensitivity and durability<br/> -Stainless-steel guides<br/> -Traditional cork handle<br/> -PS250 ice reel with aluminum body and spool, 3 ball bearings and infinite anti-reverse<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	74.99	74.99	[empty string]	[empty string]	[empty string]	1000	PIC36M	337917	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/st-croix-premier-ice-combo-pic36m-337917	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts483 ORDER BY sortposition asc

Fishing

Sort By:

Items per page:

Filter