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	DKGRN	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	DKGRN\|NULL\|NULL	1	38	0	38	105885-DEFAULT-l.jpg	38	105885-DEFAULT-m.jpg	LARGE MOUTH BASS GYOTAKU REMPA TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Largemouth Bass Gyotaku Rempa Trucker Hat in Eco Dark Gree	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.<br /> <br /> • Made with recycled Repreve fabric, a Mid-Pro crown, and soft<br /> sweat-wicking sweatband.<br /> • Laser cut ventilation.<br /> • Velcro closure</p>	[empty string]	N	38	38	ONE SZ FITS ALL	105885-DEFAULT-s.jpg	[empty string]	1000	LM39137	385655	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/largemouth-bass-gyotaku-rempa-trucker-hat-in-eco-dark-gree-385655	1
2	TAN/BLK	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	TAN/BLK\|NULL\|NULL	1	38	0	38	105917-DEFAULT-l.jpg	38	105917-DEFAULT-m.jpg	WALLEYE GYOTAKU ROADIE SNAPBACK	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Walleye Gyotaku Roadie Trucker Hat in Heather Tan/Black	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>5-panel deep structured crown, slightly curved visor.</li> <li>Breathable mesh with snapback closure.</li> </ul>	[empty string]	N	38	38	ONE SZ FITS ALL	105917-DEFAULT-s.jpg	[empty string]	1000	WE1133	385658	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/walleye-gyotaku-roadie-trucker-hat-in-heather-tan-black-385658	1
3	BLK/BLK	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	BLK/BLK\|NULL\|NULL	1	35	0	35	105909-DEFAULT-l.jpg	35	105909-DEFAULT-m.jpg	SUNSET BASS DASHBOARD SNAPBACK TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Sunset Bass Dashboard Trucker Hat in Black/Black	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Cotton canvas, not stiff as a board.</li> <li>Super soft mesh, adjustable with snapback closure.</li> </ul>	[empty string]	N	35	35	ONE SZ FITS ALL	105909-DEFAULT-s.jpg	[empty string]	1000	SBA0402	385660	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/sunset-bass-dashboard-trucker-hat-in-black-black-385660	1
4	CML/NVY/WHT	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	CML/NVY/WHT\|NULL\|NULL	1	38	0	38	105858-DEFAULT-l.jpg	38	105858-DEFAULT-m.jpg	SUNSET BASS MID PRO SNAPBACK TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Sunset Bass Mid-Pro Trucker Hat in Camel/Navy/White	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Cotton canvas, not stiff as a board.</li> <li>Super soft mesh, adjustable with snapback closure.</li> </ul>	[empty string]	N	38	38	ONE SZ FITS ALL	105858-DEFAULT-s.jpg	[empty string]	1000	SBA0969	385661	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/sunset-bass-mid-pro-trucker-hat-in-camel-navy-white-385661	1
5	NVY	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	NVY\|NULL\|NULL	1	38	0	38	105855-DEFAULT-l.jpg	38	105855-DEFAULT-m.jpg	SX DUNGEON MESHY TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	SX Dungeon Meshy Trucker Hat in Navy	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.<br /> <br /> • All mesh, 6 - panel Mid-Pro provides ultimate breathability.<br /> • Crown features 2 layers of mesh keeping the hat's shape.<br /> • Snapback closure.</p>	[empty string]	N	38	38	ONE SZ FITS ALL	105855-DEFAULT-s.jpg	[empty string]	1000	SX4123	385663	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/sx-dungeon-meshy-trucker-hat-in-navy-385663	1
6	GREEN	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	GREEN\|NULL\|NULL	1	35	0	35	105907-DEFAULT-l.jpg	35	105907-DEFAULT-m.jpg	BLK AND WHT OLD FAVORITE SNAPBACK	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	B&W Fly Old Favorite Trucker Hat in Green	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Cotton canvas, not stiff as a board. </li> <li>Super soft mesh, adjustable with snapback closure</li> </ul>	[empty string]	N	35	35	ONE SZ FITS ALL	105907-DEFAULT-s.jpg	[empty string]	1000	BY0251	385665	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/b-w-fly-old-favorite-trucker-hat-in-green-385665	1
7	MBLU/CML/BRN	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	MBLU/CML/BRN\|NULL\|NULL	1	38	0	38	105860-DEFAULT-l.jpg	38	105860-DEFAULT-m.jpg	STREAMER FLY SNAPBACK TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Streamer Fly Mid-Pro Trucker Hat in Marine Blue/Camel/Brown	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Mid-profile structured crown, slightly curved visor.</li> <li>Breathable mesh with snapback closure.</li> </ul>	[empty string]	N	38	38	ONE SZ FITS ALL	105860-DEFAULT-s.jpg	[empty string]	1000	SF0942	385669	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/streamer-fly-mid-pro-trucker-hat-in-marine-blue-camel-brown-385669	1
8	CML	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	CML\|NULL\|NULL	1	35	0	35	105905-DEFAULT-l.jpg	35	105905-DEFAULT-m.jpg	SPINNER LURE DASHBOARD TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Spinner Lure Dashboard Hat in Camel	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Cotton canvas, not stiff as a board.</li> <li>Super soft mesh, adjustable with snapback closure</li> </ul>	[empty string]	N	35	35	ONE SZ FITS ALL	105905-DEFAULT-s.jpg	[empty string]	1000	SRL0349	385670	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/spinner-lure-dashboard-hat-in-camel-385670	1
9	DKGRN/WHT	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	DKGRN/WHT\|NULL\|NULL	1	38	0	38	105861-DEFAULT-l.jpg	38	105861-DEFAULT-m.jpg	MINNOW MID PRO TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Minnow Lure Mid-Pro Trucker Hat in Melange Dark Green/White	<p>One fish, two fish, red fish... catch a fish with this minnow fish! Hand-drawn using mixed media.</p> <ul> <li>Mid-profile structured crown, slightly curved visor.</li> <li>Adjustable with a fabric buckle back closure.</li> </ul>	[empty string]	N	38	38	ONE SZ FITS ALL	105861-DEFAULT-s.jpg	[empty string]	1000	MW3483	385671	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/minnow-lure-mid-pro-trucker-hat-in-melange-dark-green-white-385671	1
10	COPPER	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	COPPER\|NULL\|NULL	1	38	0	38	105854-DEFAULT-l.jpg	38	105854-DEFAULT-m.jpg	YETI ROADIE TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Yeti Roadie Trucker Hat in Copper Slub/Black	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>5-panel deep structured crown, slightly curved visor.</li> <li>Breathable mesh with snapback closure.</li> </ul>	[empty string]	N	38	38	ONE SZ FITS ALL	105854-DEFAULT-s.jpg	[empty string]	1000	YT1177	385672	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/yeti-roadie-trucker-hat-in-copper-slub-black-385672	1
11	KHAKI	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	KHAKI\|NULL\|NULL	1	35	0	35	105908-DEFAULT-l.jpg	35	105908-DEFAULT-m.jpg	YETI DASHBOARD TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Yeti Dashboard Trucker Hat in Khaki/Grey	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Cotton canvas, not stiff as a board.</li> <li>Super soft mesh, adjustable with snapback closure</li> </ul>	[empty string]	N	35	35	ONE SZ FITS ALL	105908-DEFAULT-s.jpg	[empty string]	1000	YT0470	385673	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/yeti-dashboard-trucker-hat-in-khaki-grey-385673	1
12	BLACK	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	BLACK\|NULL\|NULL	1	39	0	39	105849-DEFAULT-l.jpg	39	105849-DEFAULT-m.jpg	BEAR REMPA TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Bear Rempa Trucker Hat in Black	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.<br /> <br /> • Made with recycled Repreve fabric, a Mid-Pro crown, and soft<br /> sweat-wicking sweatband.<br /> • Laser cut ventilation.<br /> • Velcro closure</p>	[empty string]	N	39	39	ONE SZ FITS ALL	105849-DEFAULT-s.jpg	[empty string]	1000	BR3901	385675	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/bear-rempa-trucker-hat-in-black-385675	1
13	GRY	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	GRY\|NULL\|NULL	1	35	0	35	105857-DEFAULT-l.jpg	35	105857-DEFAULT-m.jpg	LOON OLD FAVORITE SNAPBACK	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Loon Old Favorite Trucker Hat in Grey Greaser	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Cotton canvas, not stiff as a board. </li> <li>Super soft mesh, adjustable with snapback closure</li> </ul>	[empty string]	N	35	35	ONE SZ FITS ALL	105857-DEFAULT-s.jpg	[empty string]	1000	LO0271	385676	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/loon-old-favorite-trucker-hat-in-grey-greaser-385676	1
14	SLB/BLK	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	SLB/BLK\|NULL\|NULL	1	38	0	38	105847-DEFAULT-l.jpg	38	105847-DEFAULT-m.jpg	PIER ROADIE TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Pier Roadie Trucker Hat in Copper Slub/Black	<p>Aren't you more relaxed just looking at this hat? Photographed, then hand-drawn using mixed media.</p> <p>?This awesome hat has a relaxed and comforting fit for all sized noggins.  Great for everyday wear, as well as any and all crazy adventures.  This hat will stand out in any crowd.</p> <ul> <li>5-panel deep structured crown, slightly curved visor.</li> <li>Breathable mesh with snapback closure</li> </ul>	[empty string]	N	38	38	ONE SZ FITS ALL	105847-DEFAULT-s.jpg	[empty string]	1000	PR1177	385679	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/pier-roadie-trucker-hat-in-copper-slub-black-385679	1
15	CAMEL	AISLING	Aisling	CLOTHING	Clothing>Mens>Accessories>Hats	CAMEL\|NULL\|NULL	1	35	0	35	105853-DEFAULT-l.jpg	35	105853-DEFAULT-m.jpg	PIER DASHBOARD BUCKLE BACK	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Pier Dashboard Hat in Camel	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.</p> <ul> <li>Cotton canvas, not stiff as a board.</li> <li>Adjustable with fabric buckle back</li> </ul>	[empty string]	N	35	35	ONE SZ FITS ALL	105853-DEFAULT-s.jpg	[empty string]	1000	PR0349	385680	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	aisling/pier-dashboard-hat-in-camel-385680	1
16	GRY/SALM/DGRY	AISLING	Aisling	CLOTHING	Clothing>Women	GRY/SALM/DGRY\|NULL\|NULL	1	38	0	38	105852-DEFAULT-l.jpg	38	105852-DEFAULT-m.jpg	YOUBETCHA MID PRO TRUCKER	N	6.1 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2023	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Youbetcha Mid-Pro Trucker Hat in Light Grey/Salmon/Dark Grey	<p>This awesome hat has a relaxed and comforting fit for all sized noggins. Great for everyday wear, as well as any and all crazy adventures. This hat will stand out in any crowd.<br /> <br /> • Mid-profile structured crown, slightly curved visor.<br /> • Breathable mesh with snapback closure.</p>	[empty string]	N	38	38	ONE SZ FITS ALL	105852-DEFAULT-s.jpg	[empty string]	1000	YBO9123	385813	EMPTY	HATS	EMPTY	0	0	0	WOMEN	[empty string]	aisling/youbetcha-mid-pro-trucker-hat-in-light-grey-salmon-dark-grey-385813	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter