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]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	MINI WATER FILTRATION SYSTEM BLUE	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]	2	20-to-25	0.00	[empty string]	Mini Water Filtration System - Blue	<p>Sawyer`s most popular filter just got smaller and lighter. The Mini weighs just 2 ounces and filters up to 100,000 gallons! What`s special about Sawyer filters is they filter to 0.1 micron, exceeding EPA and NSF recommendations. Did we mention you can drink directly from the Mini, attach it to Sawyer Squeeze Pouches, use inline on a hydration pack, or attach it to the top of almost any bottled water? How about that for versatility? And like all Sawyer Filters; they are backflushable almost indefinitely. That means no expensive cartridges to replace, ever.<br />  </p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	SP128	177477	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/mini-water-filtration-system-blue-177477	1
2	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	WATER BOTTLE FILTRATION SYSTEM	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	25-to-50	0.00	[empty string]	Personal Water Filteration Bottle	<p>The Personal Water Bottle With Filter weighs in at just 5.5 ounces, but this durable BPA free water bottle can deliver clean water as fast as you can drink it. Use the included filter with the bottle, on a hydration pack, or as an ultra light filter option.</p>	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	SP140	177478	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/water-bottle-filtration-system-177478	1
3	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	FAST FILL ADAPTERS FOR HYDRATION PACKS	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]	11	5-to-10	0.00	[empty string]	Fast Fill Adapters For Hydration Packs	<p>The Fast Fill Hydration Pack Adapters allow you to fill your hydration pack reservoir directly from your screw on/off filter without removing it from your backpack.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	SP115	177479	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/fast-fill-adapters-for-hydration-packs-177479	1
4	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	INLINE ADAPTERS FOR SCREW ON FILTERS	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]	8	5-to-10	0.00	[empty string]	Inline Hydration Pack Adapters	The Inline Hydration Pack Adapter turns your Sawyer screw on/off filter into an inline filtration system for your hydration pack. Compatible with the Sawyer Squeeze Filter and the All in One Filter.<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	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	SP110	177480	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/inline-adapters-for-screw-on-filters-177480	1
5	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	0	10.49	0	10.49	[empty string]	10.49	[empty string]	PICARIDIN INSECT 9OZ SPRAY	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]	11	10-to-15	0.00	[empty string]	Picaridin Insect Repellant - 6 Oz	<p>Highly effective at deterring a wide array of insects including mosquitoes and ticks, Sawyer’s 20% Picaridin insect repellent is more effective at repelling biting flies than Deet. Safe for use on the whole family, the non-greasy Picaridin offers all day protection, has a pleasant low citrus odor, and won’t damage plastics or synthetic coatings.</p>	[empty string]	N	10.49	10.49	[empty string]	[empty string]	[empty string]	1000	SP576	177497	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/picaridin-insect-9oz-spray-177497	1
6	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	1	10.99	0	10.99	77316-DEFAULT-l.jpg	10.99	77316-DEFAULT-m.jpg	MAXI-DEET 100% 4OZ CONTINOUS SPRAY	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	ONLINE	[empty string]	[empty string]	76	10-to-15	0.00	[empty string]	Maxi-deet Topical Insect Repellent - 4 Oz	<p>Offering Deet in its purest form, Sawyer Maxi-Deet is ideal for defending yourself from mosquitoes, chiggers, fleas, gnats, and ticks in areas of extreme bug density. With its high potency, Maxi-Deet gives you more control on how much you apply and requires fewer re-applications (compared to other lower-dosage Deet aerosol sprays).</p>	[empty string]	N	10.99	10.99	[empty string]	77316-DEFAULT-s.jpg	[empty string]	1000	SP714	321293	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/maxi-deet-100-4oz-continous-spray-321293	1
7	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	1	6.99	0	6.99	86247-DEFAULT-l.jpg	6.99	86247-DEFAULT-m.jpg	FAMILY INSECT REPELLENT 4OZ LOTION	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	5-to-10	0.00	[empty string]	Family Insect Repellent 4oz Lotion	[empty string]	[empty string]	N	6.99	6.99	[empty string]	86247-DEFAULT-s.jpg	[empty string]	1000	SP520	336850	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/family-insect-repellent-4oz-lotion-336850	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter