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	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]	15	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
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 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 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
3	[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]	10	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
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]	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]	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]	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]	8	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
6	[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]	4	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
7	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]	ICE	[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
8	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]	ICE	[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:

Close

Filter By

Filter