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]	1	79.99	0	79.99	108005-DEFAULT-l.jpg	79.99	108005-DEFAULT-m.jpg	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]	15	50-to-100	0.00	[empty string]	Premier Ice Series Combo 28" w-pic 500 Reel Medium	<ul> <li>Sensitive solid carbon blank</li> <li>Sea Guide reel seat </li> <li>Lightweight stainless steel guides</li> <li>PIC 500 reel with 2 ball bearings, aluminum spool, soft touch handle knob, aluminum folding arm and special grease for cold temps.</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	108005-DEFAULT-s.jpg	[empty string]	1000	PIC28M	66663	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/premier-ice-series-combo-28-w-pic-500-reel-medium-66663	1
2	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	1	79.99	0	79.99	108006-DEFAULT-l.jpg	79.99	108006-DEFAULT-m.jpg	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]	14	50-to-100	0.00	[empty string]	Premier Ice Series Combo 28" w-pic 500 Reel Medium-Light	<ul> <li>Sensitive solid carbon blank</li> <li>Sea Guide reel seat </li> <li>Lightweight stainless steel guides</li> <li>PIC 500 reel with 2 ball bearings, aluminum spool, soft touch handle knob, aluminum folding arm and special grease for cold temps.</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	108006-DEFAULT-s.jpg	[empty string]	1000	PIC28ML	122867	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/premier-ice-series-combo-28-w-pic-500-reel-medium-light-122867	1
3	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	1	74.99	0	74.99	108008-DEFAULT-l.jpg	74.99	108008-DEFAULT-m.jpg	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]	10	50-to-100	0.00	[empty string]	Premier Ice Series Combo 24 " W- Pic 500 Reel Medium-Light	<ul> <li>Sensitive solid carbon blank</li> <li>Sea Guide reel seat </li> <li>Lightweight stainless steel guides</li> <li>PIC 500 reel with 2 ball bearings, aluminum spool, soft touch handle knob, aluminum folding arm and special grease for cold temps.</li> </ul>	[empty string]	N	74.99	74.99	[empty string]	108008-DEFAULT-s.jpg	[empty string]	1000	PIC24ML	138975	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/premier-ice-series-combo-24-w-pic-500-reel-medium-light-138975	1
4	[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	[empty string]	[empty string]	[empty string]	7	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
5	[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]	ONLINE CLOSEOUT	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Quantum Ice Green Combo	[empty string]	[empty string]	N	19.99	19.99	28M.NS4,24L.NS4,24ML.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
6	[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]	ONLINE CLOSEOUT	PROP 65	[empty string]	[empty string]	10	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
7	[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]	ONLINE CLOSEOUT	PROP 65	[empty string]	[empty string]	2	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
8	[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]	9	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
9	[empty string]	ST. CROIX	St. Croix	FISHING	Fishing>Combos>Ice	[empty string]	1	84.99	0	84.99	108009-DEFAULT-l.jpg	84.99	108009-DEFAULT-m.jpg	ST CROIX PREMIER ICE COMBO PIC36MH	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]	4	50-to-100	0.00	[empty string]	Premier Ice Series Combo 36 " W- Pic 500 Reel Medium-Heavy	<ul> <li>Sensitive solid carbon blank</li> <li>Sea Guide reel seat </li> <li>Lightweight stainless steel guides</li> <li>PIC 500 reel with 2 ball bearings, aluminum spool, soft touch handle knob, aluminum folding arm and special grease for cold temps.</li> </ul>	[empty string]	N	84.99	84.99	[empty string]	108009-DEFAULT-s.jpg	[empty string]	1000	PIC36MH	337918	ICE	EMPTY	EMPTY	0	0	0	COMBOS	[empty string]	st-croix/premier-ice-series-combo-36-w-pic-500-reel-medium-heavy-337918	1
10	24UL,27ML,32L	SHAKESPEARE	Shakespeare	FISHING	Fishing>Combos>Ice	24UL\|NULL\|NULL,27ML\|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]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	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
11	30M	SHAKESPEARE	Shakespeare	FISHING	Fishing>Combos>Ice	30M\|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]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts483 ORDER BY sortposition asc

Fishing

Sort By:

Items per page:

Filter