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]	3	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	CAMP ESSENTIALS	[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	CAMP ESSENTIALS	[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	CAMP ESSENTIALS	[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	CAMP ESSENTIALS	[empty string]	sawyer/inline-adapters-for-screw-on-filters-177480	1
5	[empty string]	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	LIFESTRAW CARBON REPLACEMENT	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]	5	5-to-10	0.00	[empty string]	Lifestraw Carbon Filter Replacement - 2 Pack	<p>The Lifestraw Carbon Filter Replacement is compatible with LifeStraw Go, LifeStraw Steel, LifeStraw Universal, LifeStraw Play.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	LSCARB410	274322	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-carbon-replacement-274322	1
6	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	64.99	0	64.99	93957-DEFAULT-l.jpg	64.99	93957-DEFAULT-m.jpg	TRAILSHOT MICROFILTER	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]	1	50-to-100	0.00	[empty string]	Trailshot Microfilter	Clean water all day—without the weight. That’s the advantage the TrailShot Microfilter provides. Designed to hide in stash pockets and deploy quickly, this tiny water filter lets you drink directly from sources along the trail for instant hydration, and fill your vessels with clean water. Easy one-handed operation filters one liter in a mere 60 seconds, so you can get back on the trail quickly and moving again. At just 142 g (5 oz.), the TrailShot water filter is the ultimate filter for fast-paced, high-mileage adventurers, like trail runners, hikers, fast-packers and mountain bikers.	[empty string]	N	64.99	64.99	[empty string]	93957-DEFAULT-s.jpg	[empty string]	1000	09385	282805	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/trailshot-microfilter-282805	1
7	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	37.99	0	37.99	[empty string]	37.99	[empty string]	PLATYPUS BIG ZIP EVO 2.0L	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]	3	25-to-50	0.00	[empty string]	Platypus Big Zip Evo 2.0l	[empty string]	[empty string]	N	37.99	37.99	[empty string]	[empty string]	[empty string]	1000	10858	312696	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/platypus-big-zip-evo-2-0l-312696	1
8	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	PLATYPUS BIG ZIP EVO 3.0L	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	25-to-50	0.00	[empty string]	Platypus Big Zip Evo 3.0l	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	10857	312697	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/platypus-big-zip-evo-3-0l-312697	1
9	DKTEAL,GREY	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	DKTEAL\|NULL\|NULL,GREY\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	LIFESTRAW GO LARGE VOLUME 1L	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]	Lifestraw 2-stage Replacement Filter	<p>The Lifestraw 2-Stage Replacement Filter isnbsp;compatible with LifeStraw Go and LifeStraw Universal.</p>	[empty string]	N	44.99	44.99	1L	[empty string]	[empty string]	1000	LSG1LT	345070	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-go-large-volume-1l-345070	1
10	BLUE	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	BLUE\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	LIFESTRAW GO STAINLESS STEEL 24OZ	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]	Lifestraw 2-stage Replacement Filter	<p>The Lifestraw 2-Stage Replacement Filter isnbsp;compatible with LifeStraw Go and LifeStraw Universal.</p>	[empty string]	N	69.99	69.99	24OZ	[empty string]	[empty string]	1000	LSGOSS	345071	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-go-stainless-steel-24oz-345071	1
11	[empty string]	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	UNIVERSAL WATER FILTER	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]	3	25-to-50	0.00	[empty string]	Universal Water Filter	[empty string]	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	LSUN02FK01	345076	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/universal-water-filter-345076	1
12	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	149.99	0	149.99	93979-DEFAULT-l.jpg	149.99	93979-DEFAULT-m.jpg	TRAIL BASE WATER FILTER KIT 4L	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	100-to-150	0.00	[empty string]	Trail Base Water Filter Kit 4l	To meet the needs of multi-activity backcountry adventurers, MSR set out to engineer the most versatile water filter ever. The Trail Base microfilter kit features modular components that allow it to be used as a gravity system at camp, a pocket-sized filter on the trail, or a fast-and-light reservoir when you need to carry clean water with you. Whether you’re hiking, biking or basecamping, the Trail Base water filter kit offers incredible flexibility and options, making it a great filter that truly adapts to your adventure and the filtration task at hand.	[empty string]	N	149.99	149.99	[empty string]	93979-DEFAULT-s.jpg	[empty string]	1000	10943	348085	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/trail-base-water-filter-kit-4l-348085	1
13	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	39.99	0	39.99	93981-DEFAULT-l.jpg	39.99	93981-DEFAULT-m.jpg	EMERGENCY HOME WATER FILTER 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]	12	25-to-50	0.00	[empty string]	Emergency Home Water Filter System	This home water filtration system is perfect for anyone building emergency kits in preparation for compromised municipal water systems, disasters and boil orders. Utilizing MSR`s Thru-Link microfilter and the included adapters, it threads easily onto standard home spigots, providing safe water fast. Protected in sealed packaging for long-term storage, it’s there when you need it and out of mind when you don’t—far easier than storing weeks’ worth of bottled water. This rugged filter uses two-stage filtration to remove harmful pathogens and has been proven, used by the U.S. military for more than a decade.	[empty string]	N	39.99	39.99	[empty string]	93981-DEFAULT-s.jpg	[empty string]	1000	13237	348104	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/emergency-home-water-filter-system-348104	1
14	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	4.99	0	4.99	93983-DEFAULT-l.jpg	4.99	93983-DEFAULT-m.jpg	BITE VALVE COVER	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]	5	5-AND-under	0.00	[empty string]	Bite Valve Cover	Whether you set down your pack on the muddy trail or in the snow, protect what goes into your mouth from dirt and debris while slowing down the freezing process with the updated Platypus Bite Valve Cover. The new shape ensures your cover stays closed and it fits with all Platypus hydration system bite valves.	[empty string]	N	4.99	4.99	[empty string]	93983-DEFAULT-s.jpg	[empty string]	1000	11008	353521	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/bite-valve-cover-353521	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts288 ORDER BY sortposition asc

Camping

Sort By:

Items per page:

Filter