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]	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
2	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	0	79.99	0	79.99	[empty string]	79.99	[empty string]	ST CROIX PREMIER ICE COMBO PIC28M	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]	17	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	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	PIC28M	66663	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/st-croix-premier-ice-combo-pic28m-66663	1
3	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	0	79.99	0	79.99	[empty string]	79.99	[empty string]	ST CROIX PREMIER ICE COMBO PIC28ML	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]	8	50-to-100	0.00	[empty string]	Premier Ice Combo - 28 Inches - Medium Light	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	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	PIC28ML	122867	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/st-croix-premier-ice-combo-pic28ml-122867	1
4	[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 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]	5	50-to-100	0.00	[empty string]	St Croix Premier Ice Combo Pic24ml	[empty string]	[empty string]	N	74.99	74.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	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]	ICE	[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
6	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]	ICE	[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
7	[empty string]	SHAKESPEARE	Shakespeare	FISHING	Fishing>Combos>Ice	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	UGLY STIK ICE COMBO USGXICE28MCBO	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	ONLINE	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Gx2 Ice Combo - Medium - 28 Inches	<p>Ugly Stik GX2 is the next generation of Ugly Stik that combines the heritage and tradition of the original while maintaining the strength and durability Ugly Stiks are known for. Ugly Stik GX2 rods offer better balance for lighter feel, improved components, and eye catching cosmetics for a more modern look.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	USGXICE28MCBO	259679	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	shakespeare/ugly-stik-ice-combo-usgxice28mcbo-259679	1
8	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	1	29.99	0	29.99	56885-DEFAULT-l.jpg	29.99	56885-DEFAULT-m.jpg	WICKED ICEROD 25	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Wicked Ice Rod - 25 Inches - Light	<p>Sophistication meets style with the Wicked rod. High density Japanese EVA foam delivers all day comfort.</p>	[empty string]	N	29.99	29.99	[empty string]	56885-DEFAULT-s.jpg	[empty string]	1000	NW25L	275654	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/wicked-icerod-25-275654	1
9	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	WICKED ICE ROD 28	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	ONLINE	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Wicked Ice Rod - 28 Inches - Medium	<p>Sophistication meets style with the Wicked rod. High density Japanese EVA foam delivers all day comfort.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	NW28M	275655	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/wicked-ice-rod-28-275655	1
10	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	0	54.99	0	54.99	[empty string]	54.99	[empty string]	WICKED LONGSTEM ICECOMBO	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[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]	Wicked Long Stem Ice Combo - 24 Inches - Ultra Light	<p>Sophistication meets style with the Wicked rod. High density Japanese EVA foam and an ergonomic Evolve real seat delivers all day comfort.</p>	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	NWLC24UL	275657	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/wicked-longstem-icecombo-275657	1
11	[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
12	[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
13	[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
14	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	1	34.99	0	34.99	82557-DEFAULT-l.jpg	34.99	82557-DEFAULT-m.jpg	THERMO ICE COMBO 28M26ML	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	WINTER	[empty string]	2019	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Thermo Ice - 28 Inch - Medium	<p>FEATURES:<br /> -Durable fiberglass blank<br /> -Stainless steel guides with polished inserts<br /> -Evolve cushioned reel seat<br /> -2BB reel with instant anti-reverse<br /> -Aluminum spool<br /> -Lightweight graphite body & rotor<br /> -Soft touch handle knob</p>	[empty string]	N	34.99	34.99	[empty string]	82557-DEFAULT-s.jpg	[empty string]	1000	TIC3-28M	323397	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/thermo-ice-combo-28m26ml-323397	1
15	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	1	44.99	0	44.99	91481-DEFAULT-l.jpg	44.99	91481-DEFAULT-m.jpg	INFRARED ICE COMBO 25L - TITANIUM	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Infrared Ice Combo 25l - Titanium	[empty string]	[empty string]	N	44.99	44.99	[empty string]	91481-DEFAULT-s.jpg	[empty string]	1000	IC3-25LTT	323400	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/infrared-ice-combo-25l-titanium-323400	1
16	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SONICOR ICE COMBO 24 IN UL	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Sonicor Ice Combo 24 In Ul	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	SCC3-24UL	323442	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/sonicor-ice-combo-24-in-ul-323442	1
17	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	1	24.99	0	24.99	82584-DEFAULT-l.jpg	24.99	82584-DEFAULT-m.jpg	HEATWAVE COMBO 24IN UL	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	WINTER	[empty string]	2019	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Heatwave Combo - 24 Inch - Ultra Light	<p>FEATURES:<br /> -Durable fiberglass blank<br /> -Stainless steel guides with polished inserts<br /> -1BB reel<br /> -Lightweight graphite body and rotor<br /> -Contoured handle knob</p>	[empty string]	N	24.99	24.99	[empty string]	82584-DEFAULT-s.jpg	[empty string]	1000	HWC3-24UL	323445	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/heatwave-combo-24in-ul-323445	1
18	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	HEATWAVE COMBO 28IN M	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	WINTER	[empty string]	2019	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	7	20-to-25	0.00	[empty string]	Heatwave Combo - 28 Inch - Medium	<p>FEATURES:<br /> -Durable fiberglass blank<br /> -Stainless steel guides with polished inserts<br /> -1BB reel<br /> -Lightweight graphite body and rotor<br /> -Contoured handle knob</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	HWC3-28M	323447	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/heatwave-combo-28in-m-323447	1
19	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	0	84.99	0	84.99	[empty string]	84.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]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	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	84.99	84.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
20	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	0	84.99	0	84.99	[empty string]	84.99	[empty string]	ST CROIX PREMIER ICE COMBO PIC36MH	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[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]	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	84.99	84.99	[empty string]	[empty string]	[empty string]	1000	PIC36MH	337918	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/st-croix-premier-ice-combo-pic36mh-337918	1
21	[empty string]	13 FISHING	13 Fishing	FISHING	Fishing>Combos>Ice	[empty string]	0	44.99	0	44.99	[empty string]	44.99	[empty string]	INFRARED ICE COMBO 25UL	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	WINTER	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Infrared Ice Combo 25ul	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	IC3-25UL	348829	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	13-fishing/infrared-ice-combo-25ul-348829	1
22	[empty string]	CLAM CORP	CLAM CORP	FISHING	Fishing>Combos>Ice	[empty string]	1	39.99	0	39.99	44347-DEFAULT-l.jpg	39.99	44347-DEFAULT-m.jpg	GENZ SPRING BOBBER 25IN UL COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	WINTER	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Genz Spring Bobber 25in Ul Combo	<	[empty string]	N	39.99	39.99	[empty string]	44347-DEFAULT-s.jpg	[empty string]	1000	16080	350158	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	clam-corp/genz-spring-bobber-25in-ul-combo-350158	1
23	[empty string]	CLAM CORP	CLAM CORP	FISHING	Fishing>Combos>Ice	[empty string]	1	39.99	0	39.99	44347-DEFAULT-l.jpg	39.99	44347-DEFAULT-m.jpg	GENZ SPRING BOBBER 27IN M COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	WINTER	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Genz Spring Bobber 27in M Combo	<	[empty string]	N	39.99	39.99	[empty string]	44347-DEFAULT-s.jpg	[empty string]	1000	16083	350161	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	clam-corp/genz-spring-bobber-27in-m-combo-350161	1
24	27ML,28M,30L	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Ice	27ML\|NULL\|NULL,28M\|NULL\|NULL,30L\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	VERITAS LTD ICE COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	20	50-to-100	0.00	[empty string]	Veritas Ltd Ice Combo	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	AVTILTD-CBO	350865	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	abu-garcia/veritas-ltd-ice-combo-350865	1
25	27L,27ML,24UL,32L	SHAKESPEARE	Shakespeare	FISHING	Fishing>Combos>Ice	27L\|NULL\|NULL,27ML\|NULL\|NULL,24UL\|NULL\|NULL,32L\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	PRESIDENT INLINE ICE COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	51	100-to-150	0.00	[empty string]	President Inline Ice Combo	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	PRESINT COMBO	350867	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	shakespeare/president-inline-ice-combo-350867	1
26	27ML,28M	SHAKESPEARE	Shakespeare	FISHING	Fishing>Combos>Ice	27ML\|NULL\|NULL,28M\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	PRESIDENT FENWICK ELITE TECH ICE COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	President Fenwick Elite Tech Ice Combo	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	PRESP20-ELT COMBO	350868	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	shakespeare/president-fenwick-elite-tech-ice-combo-350868	1
27	36MH,30M,27M	SHAKESPEARE	Shakespeare	FISHING	Fishing>Combos>Ice	36MH\|NULL\|NULL,30M\|NULL\|NULL,27M\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	UGLY STIK ELITE ICE COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	37	25-to-50	0.00	[empty string]	Ugly Stik Elite Ice Combo	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	USELTICE COMBO	350870	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	shakespeare/ugly-stik-elite-ice-combo-350870	1
28	2000	DAIWA	Daiwa	FISHING	Fishing>Combos>Ice	2000\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	TEAM DAIWA ICE PMC 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]	1	25-to-50	0.00	[empty string]	Team Daiwa Ice Pmc Combo	[empty string]	[empty string]	N	49.99	49.99	40MH	[empty string]	[empty string]	1000	CFLT-TDI	354365	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	daiwa/team-daiwa-ice-pmc-combo-354365	1
29	750	DAIWA	Daiwa	FISHING	Fishing>Combos>Ice	750\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	TEAM DAIWA ICE Q PMC 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]	20	50-to-100	0.00	[empty string]	Team Daiwa Ice Q Pmc Combo	[empty string]	[empty string]	N	79.99	79.99	24UL,26L,28L,28M,30UL,28QT	[empty string]	[empty string]	1000	QG-TDIQ	354374	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	daiwa/team-daiwa-ice-q-pmc-combo-354374	1
30	750	DAIWA	Daiwa	FISHING	Fishing>Combos>Ice	750\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	TEAM DAIWA ICE PMC 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]	31	25-to-50	0.00	[empty string]	Team Daiwa Ice Pmc Combo	[empty string]	[empty string]	N	49.99	49.99	28QT,24UL,26L,28L	[empty string]	[empty string]	1000	QR-TDI	354375	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	daiwa/team-daiwa-ice-pmc-combo-354375	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts483 ORDER BY sortposition asc

Fishing

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Brand

Size

Ice Rod Combo Case

Premier Ice Combo - 28 Inches - Medium

Premier Ice Combo - 28 Inches - Medium Light

St Croix Premier Ice Combo Pic24ml

Cherrywood Hd Ice Combo

Berkley Red Ice Combo

Gx2 Ice Combo - Medium - 28 Inches

Wicked Ice Rod - 25 Inches - Light

Wicked Ice Rod - 28 Inches - Medium

Wicked Long Stem Ice Combo - 24 Inches - Ultra Light

Quantum Ice Green Combo

Glacier X Ice Combo - Spinning

Glacier Xti Ice Combo - Spinning

Thermo Ice - 28 Inch - Medium

Infrared Ice Combo 25l - Titanium

Sonicor Ice Combo 24 In Ul

Heatwave Combo - 24 Inch - Ultra Light

Heatwave Combo - 28 Inch - Medium

Premier Ice Combo - 28 Inches - Medium

Premier Ice Combo - 28 Inches - Medium

Infrared Ice Combo 25ul

Genz Spring Bobber 25in Ul Combo

Genz Spring Bobber 27in M Combo

Veritas Ltd Ice Combo