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	BLACK/CHARCOAL	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Accessories	BLACK/CHARCOAL\|NULL\|NULL	0	22.99	0	22.99	[empty string]	22.99	[empty string]	CONTACT PADDLE GLOVE	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	NOT ONLINE	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Contact Paddle Glove	[empty string]	[empty string]	N	22.99	22.99	M,S	[empty string]	[empty string]	1000	GL1431001	140658	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	stohlquist/contact-paddle-glove-140658	1
2	BLACK/CHARCOAL	STOHLQUIST	Stohlquist	FOOTWEAR	Footwear>Leisure and Casual	BLACK/CHARCOAL\|NULL\|NULL	0	15.99	0	15.99	[empty string]	15.99	[empty string]	MENS SEABOARD WATERSHOE	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Seaboard Watershoe - Men`s	<p>FEATURES:<br /> -2mm upper<br /> -High grip PVC-free, Octo-Sole provides excellent traction on wet surfaces<br /> -Super soft 5mm EVA insole for lasting comfort<br /> -Nylon mesh panels for ventilation and drainage<br /> -Toe and heel bumpers for added protection on rocky shores<br /> -Pull loop at heel allows for quick and easy entry<br /> -Lightweight and compressible for easy packing<br /> -Breathable and fast drying toe-zone<br /> -Non-markign outsoles</p>	[empty string]	N	15.99	15.99	5	[empty string]	[empty string]	1000	FM113010	155013	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	stohlquist/mens-seaboard-watershoe-155013	1
3	BLACK/BLUE	STOHLQUIST	Stohlquist	FOOTWEAR	Footwear>Leisure and Casual	BLACK/BLUE\|NULL\|NULL	0	15.99	0	15.99	[empty string]	15.99	[empty string]	WMS SEABOARD WATERSHOE	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	WOMENS	ACTIVE	NOT ONLINE	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Seaboard Watershoe - Women`s	<p>FEATURES:<br /> -2mm upper<br /> -High grip PVC-free, Octo-Sole provides excellent traction on wet surfaces<br /> -Super soft 5mm EVA insole for lasting comfort<br /> -Nylon mesh panels for ventilation and drainage<br /> -Toe and heel bumpers for added protection on rocky shores<br /> -Pull loop at heel allows for quick and easy entry<br /> -Lightweight and compressible for easy packing<br /> -Breathable and fast drying toe-zone<br /> -Non-markign outsoles</p>	[empty string]	N	15.99	15.99	5,6	[empty string]	[empty string]	1000	FW0260101	155014	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	stohlquist/wms-seaboard-watershoe-155014	1
4	PURPLE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PURPLE\|NULL\|NULL	1	99.99	0	99.99	102031-DEFAULT-l.jpg	99.99	102031-DEFAULT-m.jpg	WMS FLO PURPLE PFD PADDLERS	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	NOT ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	FLO	<p>High performance economical equivalent of our Cruiser vest featuring 400x200 denier ripstop outer shell and soft 200D inner liner. High back flotation fitscomfortably above the seat backs found in today’s sit-on-top kayaks.</p> <p>Features the <strong>Stohlquist Fit System</strong> with Graded Sizing for personalized fit and ultimate comfort.</p>	[empty string]	N	99.99	99.99	XS/SM,MED/LG	102031-DEFAULT-s.jpg	[empty string]	1000	FLO	249573	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/flo-249573	1
5	SUN/GRAY	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SUN/GRAY\|NULL\|NULL	1	89.99	0	89.99	102036-DEFAULT-l.jpg	89.99	102036-DEFAULT-m.jpg	WMS MISTY PFD SUN/GRAY	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	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	MISTY	<p>Along with our Graded Sizing, the Misty features a thin back design offering more coverage and ensuring compatibility with any seat back style. The Misty is great for use with boats that feature a higher seat back, but are right at home in a touring boat with sprayskirt. Along with providing a great fit, the Misty also features multiple pockets that will hold a beverage, your sunglasses, and other small items.</p> <p> </p>	[empty string]	N	89.99	89.99	S,M,L	102036-DEFAULT-s.jpg	[empty string]	1000	MISTY	260163	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/misty-260163	1
6	BLUE/BLACK	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLUE/BLACK\|NULL\|NULL	1	89.99	0	89.99	102038-DEFAULT-l.jpg	89.99	102038-DEFAULT-m.jpg	MNS COASTER PFD ROYAL BLUE/ BLACK	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	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	COASTER	<p>The Coaster is designed to have a slightly larger footprint, which helps to distribute flotation over a wider area. The result is a thinner profile that provides more mobility and comfort, while reducing interference with today's taller seat backs. Along with providing a great fit, the Coaster also features multiple pockets that will hold a beverage, your sunglasses, and other small items.</p> <p> </p>	[empty string]	N	89.99	89.99	L	102038-DEFAULT-s.jpg	[empty string]	1000	COASTER	260164	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/coaster-260164	1
7	PACIFICBLUE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PACIFICBLUE\|NULL\|NULL	1	69.99	0	69.99	102061-DEFAULT-l.jpg	69.99	102061-DEFAULT-m.jpg	MNS OSFA PFD VEST	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	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	OSFA	<p>The OSFA (One Size Fits All) is a terrific jacket for those looking for a simple, great fitting jacket for recreational paddling. Highly adjustable, it’s a perfect vest to share with family and friends</p>	[empty string]	N	69.99	69.99	OSFA	102061-DEFAULT-s.jpg	[empty string]	1000	QF134310UN	292716	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/osfa-292716	1
8	SAILBLUE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SAILBLUE\|NULL\|NULL	1	69.99	0	69.99	102063-DEFAULT-l.jpg	69.99	102063-DEFAULT-m.jpg	WMS MELODY OSFA PFD VEST	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	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	MELODY	<p>The Melody is a comfortable option for women looking for a simple, great fitting jacket for recreational paddling. The multi-fit size is highly adjustable; it’s a perfect vest to share with family and friends.</p>	[empty string]	N	69.99	69.99	OSFA	102063-DEFAULT-s.jpg	[empty string]	1000	MELODY	292717	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/melody-292717	1
9	KHAKI	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	KHAKI\|NULL\|NULL	1	99.99	0	99.99	102065-DEFAULT-l.jpg	99.99	102065-DEFAULT-m.jpg	PISEAS FISHING VEST	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	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	PISEAS	<p>Large “drawbridge” front pockets act as fold-down work surfaces when opened. Pockets feature hook & loop strips, for attaching fly patches or other fishing accessories. Other features include anchor points, lash tab, and D-ring for net attachment.</p>	[empty string]	N	99.99	99.99	S/M	102065-DEFAULT-s.jpg	[empty string]	1000	PISEAS	292718	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/piseas-292718	1
10	TURQUOISE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	TURQUOISE\|NULL\|NULL	1	109.99	0	109.99	102054-DEFAULT-l.jpg	109.99	102054-DEFAULT-m.jpg	WMS GLIDE PFD	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	[empty string]	[empty string]	[empty string]	12	100-to-150	0.00	[empty string]	GLIDE	<p>Soft foam and Graded Sizing! The Glide features a thin back design offering more coverage and ensuring compatibility with any seat back style. The Glide is perfect for use with boats that feature a higher seat back, but are right at home in a touring boat with sprayskirt. The Glide is designed to have a slightly larger footprint, which helps to distribute flotation over a wider area. The result is a thinner profile that provides more mobility and comfort, while reducing interference with today's taller seat backs</p>	[empty string]	N	109.99	109.99	PLUS,XS/SM	102054-DEFAULT-s.jpg	[empty string]	1000	GLIDE	342147	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/glide-342147	1
11	BLK/GRY	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLK/GRY\|NULL\|NULL	1	39.99	0	39.99	102055-DEFAULT-l.jpg	39.99	102055-DEFAULT-m.jpg	WMS BROOK PFD	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	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	BROOK	<p>The Brook lifejacket is a comfortable and stylish option for designed for women. Its the perfect PFD for recreational paddling or boating.</p> <p>Features the <strong>Stohlquist Fit System</strong> with Graded Sizing for personalized fit and ultimate comfort.</p>	[empty string]	N	39.99	39.99	XS/SM,PLUS	102055-DEFAULT-s.jpg	[empty string]	1000	BROOK	342148	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/brook-342148	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter