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	MANGO,MIDNIGHT,BREEZE	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,MIDNIGHT\|NULL\|NULL,BREEZE\|NULL\|NULL	0	899	0	899	[empty string]	899	[empty string]	KAYAK 10.5 48LB CAPACITY 400LBS	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]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	7	500-or-more	0.00	[empty string]	Aspire 105 - 10 Feet 6 Inches	<p><span style=`color: rgb(13, 26, 42); font-family: proxima-nova, Arial, Helvetica, sans-serif;`>The Aspire is a high-performance sit-inside recreational kayak with endless possibilities. Designed for the beginner to intermediate paddler looking to expand beyond flat-water, the versatile Aspire combines easy handling and maneuverability with unsurpassed stability and features the TruTrak Adjustable Skeg System for straight tracking on longer pursuits. Industry-leading Phase 3 AirPro seat outfitting provides ultimate comfort, adjustability and breathability.</span></p>	[empty string]	N	899	899	[empty string]	[empty string]	[empty string]	1000	ASPIRE 105	156104	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/kayak-10-5-48lb-capacity-400lbs-156104	1
2	GALAXY,BREEZE	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	GALAXY\|NULL\|NULL,BREEZE\|NULL\|NULL	0	999	0	999	[empty string]	999	[empty string]	KAYAK 10.5 48LBS CAPACITY 300LBS	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]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	5	500-or-more	0.00	[empty string]	Pungo 105 - 10 Feet 6 Inches	<p><span style=`font-size: small;`><span style=`color: rgb(13, 26, 42); font-family: proxima-nova, Arial, Helvetica, sans-serif;`>With graceful performance characteristics, enhanced embellishments, and world-class luxury appointments, the Pungo delivers on its reputation and charts a new course for all sit-inside kayaks to come.</span></span></p>	[empty string]	N	999	999	[empty string]	[empty string]	[empty string]	1000	PUNGO 105	309618	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/kayak-10-5-48lbs-capacity-300lbs-309618	1
3	MANGO,GALAXY,BREEZE	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	MANGO\|NULL\|NULL,GALAXY\|NULL\|NULL,BREEZE\|NULL\|NULL	0	999	0	999	[empty string]	999	[empty string]	KAYAK SOT 10.5FT 55LBS CAPACITY 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]	2022	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	12	500-or-more	0.00	[empty string]	Kayak Sot 10.5ft 55lbs Capacity 325lbs	[empty string]	[empty string]	N	999	999	[empty string]	[empty string]	[empty string]	1000	TARPON 105	331615	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/kayak-sot-10-5ft-55lbs-capacity-325lbs-331615	1
4	GALAXY,BREEZE,MANGO	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	GALAXY\|NULL\|NULL,BREEZE\|NULL\|NULL,MANGO\|NULL\|NULL	0	1099	0	1099	[empty string]	1099	[empty string]	KAYAK TARPON 12FT	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	500-or-more	0.00	[empty string]	Kayak Tarpon 12ft	[empty string]	[empty string]	N	1099	1099	[empty string]	[empty string]	[empty string]	1000	TARPON 120	343180	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/kayak-tarpon-12ft-343180	1
5	GALAXY,BREEZE,MANGO	WILDERNESS SYSTEMS	Wilderness Systems	WATERSPORTS	Watersports>Kayaks	GALAXY\|NULL\|NULL,BREEZE\|NULL\|NULL,MANGO\|NULL\|NULL	0	1099	0	1099	[empty string]	1099	[empty string]	KAYAK PUNGO 12.5FT	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	Kayak Pungo 12.5ft	[empty string]	[empty string]	N	1099	1099	[empty string]	[empty string]	[empty string]	1000	PUNGO 125	343182	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	wilderness-systems/kayak-pungo-12-5ft-343182	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter