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	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPER XSM 2PK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	5	5-AND-under	0.00	[empty string]	Scupper Stoppers - X Small - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1966.0000	51963	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stopper-xsm-2pk-51963	1
2	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPERS SM 2PK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	9	5-AND-under	0.00	[empty string]	Scupper Stoppers - Small - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1960.0000	51991	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stoppers-sm-2pk-51991	1
3	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPER MD 2PK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	15	5-AND-under	0.00	[empty string]	Scupper Stoppers - Medium - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1962.0000	51992	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stopper-md-2pk-51992	1
4	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER STOPPERS LG 2PK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	13	5-AND-under	0.00	[empty string]	Scupper Stoppers - Large - 2 Pack	<p>Scupper Stoppers can be used to plug the scupper holes in the cockpit of your Ocean Kayak. This will help you stay dry while you are paddling.</p> <p> </p> <p>NOTE: Scupper Stoppers are completely round in shape and will not fit oval-shaped scupper holes.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.1964.0000	51993	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-stoppers-lg-2pk-51993	1
5	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	COMFORT PLUS BACKREST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Comfort Plus Seat Back	<p>Extra foam padding provides the comfort and support, while the four-way adjustability provides a custom fit for almost any body type. It is made of durable, UV resistant nylon pack cloth with reinforced stays for durable seat construction. It has reflective logos that illuminate in the dark after exposure to sunlight and solid brass clips with stainless steel springs&sbquo; easy to clip on your kayak.</p> <p> </p> <p>NOTE: KAYAK NOT INCLUDED</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0238	110031	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/comfort-plus-backrest-110031	1
6	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	COMFORT TECH SEAT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Comfort Tech Seat Back	<p>The Comfort Tech Seat Back is an upgrade from Ocean`s Comfort Plus seat with it`s adjustability, more padding and other great features.<br /> <br /> NOTE: KAYAK NOT INCLUDED</p>	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0572	131756	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	ocean-kayak/comfort-tech-seat-131756	1
7	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	COMFORT ZONE BACKREST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	BOTH	ACTIVE	PROP 65	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Comfort Zone Seat Back	<p>A nice comfortable way to spend a day on the water. The Comfort Zone Seat Back is taller for additional back support and the seat padding has more cushion making it a softer ride.<br />  </p>	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0577	146313	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/comfort-zone-backrest-146313	1
8	SEAGLASS	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	SEAGLASS\|NULL\|NULL	1	799.99	0	799.99	92878-DEFAULT-l.jpg	799.99	92878-DEFAULT-m.jpg	KAYAK TANDUM 12FT 57LBS CAP 425LBS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	Kayak Tandum 12ft 57lbs Cap 425lbs	[empty string]	[empty string]	N	799.99	799.99	[empty string]	92878-DEFAULT-s.jpg	[empty string]	1000	MALIBU TWO	254203	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/kayak-tandum-12ft-57lbs-cap-425lbs-254203	1
9	BROWNCAMO	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	BROWNCAMO\|NULL\|NULL	1	949.99	0	949.99	92881-DEFAULT-l.jpg	949.99	92881-DEFAULT-m.jpg	KAYAK ANGLER 13.4FT 56LBS CAP 325LBS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	Prowler 13 Angler - 13 Feet 4 Inches	<p><span style=``font-size:`><span style=``font-family:`>This popular angler kayak combines performance with all of the features every angler needs.</span></span></p>	[empty string]	N	949.99	949.99	[empty string]	92881-DEFAULT-s.jpg	[empty string]	1000	PROWLER 13 ANGLER	260352	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/kayak-angler-13-4ft-56lbs-cap-325lbs-260352	1
10	SEAGLASS	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Kayaks	SEAGLASS\|NULL\|NULL	1	599.99	0	599.99	92903-DEFAULT-l.jpg	599.99	92903-DEFAULT-m.jpg	KAYAK 9.5FT 54LBS CAP 325LBS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Malibu 9.5 - 9 Feet 6 Inches	<p><span style=`font-family: ` gt=``>Have a blast atop Ocean`s Malibu series! It’s all about fun and comfort—and if you like to control your own destiny, we’ve got options. These compact, stackable, easy-to-paddle, straight-tracking solo kayaks will turn heads as you master the waves with ease on their super-stable 9.5’ sit-on-top hull designs. Comfort comes easy on the Malibu, thanks to a newly designed AirGo molded-in seat and seat pad with an adjustable AirComfort backrest. No matter your size enjoy comfortable leg room with calf rests and molded-on foot wells. And don’t forget your beverages! The Malibu 9.5 comes equipped with three cup holders.</span></p>	[empty string]	N	599.99	599.99	[empty string]	92903-DEFAULT-s.jpg	[empty string]	1000	MALIBU 9.5	307113	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	ocean-kayak/kayak-9-5ft-54lbs-cap-325lbs-307113	1
11	[empty string]	OCEAN KAYAK	Ocean Kayak	WATERSPORTS	Watersports>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	SCUPPER VALVES SHORT 2 PACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	5-AND-under	0.00	[empty string]	Scupper Valves Short 2 Pack	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	07.2000.0782	336569	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ocean-kayak/scupper-valves-short-2-pack-336569	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter