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]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	32.99	0	32.99	37190-DEFAULT-l.jpg	32.99	37190-DEFAULT-m.jpg	WATERPROOF ULTRALIGHT 7 KIT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Ultralight And Watertight .7 Medical Kit	<p>The Ultralight / Watertight .7 is the kit for adventures where exposure to the elements will be an issue. It is designed for groups of 1 to 2 people with trip durations of 1 to 4 days. This kit features proprietary DryFlex bags for the ultimate in ultralight, waterproof storage. The Inner DryFlex waterproof liners and seam-sealed outer silnylon bags provide multiple layers of protection from the elements.</p>	[empty string]	N	32.99	32.99	[empty string]	37190-DEFAULT-s.jpg	[empty string]	1000	0125-0291	958	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/waterproof-ultralight-7-kit-958	1
2	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	7.99	0	7.99	93474-DEFAULT-l.jpg	7.99	93474-DEFAULT-m.jpg	MOLESKIN	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	17	5-to-10	0.00	[empty string]	Moleskin	<p>Moleskin is the most reliable dressing for blister prevention available. Apply moleskin to problem areas before you begin your outdoor activity or as soon as you feel friction. Blisters will be a thing of the past. <br />  </p>	[empty string]	N	7.99	7.99	[empty string]	93474-DEFAULT-s.jpg	[empty string]	1000	0155-0400	87770	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/moleskin-87770	1
3	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	47.99	0	47.99	93475-DEFAULT-l.jpg	47.99	93475-DEFAULT-m.jpg	ULTRALIGHT WATERTIGHT 9 KIT	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Ultralight And Watertight .9 Medical Kit	<p>The Ultralight / Watertight .9 has been tested, abused, and approved by adventure racers. Two inner DryFlex waterproof liners and seam-sealed outer silnylon bags provide multiple layers of protection from the elements. Designed for one to four people on trips up to four days, this is the kit for adventures where exposure to the elements will be an issue.<br /> <br /> FEATURES:<br /> -Inner DryFlex bags and outer seam-sealed siliconized nylon bag with water-resistant zipper<br /> -Irrigation syringe and wound closure strips to clean and close wounds<br /> -Medications to stop diarrhea and stomach distress<br /> -Mini roll of duct tape (2`` x 26``)<br /> -A wide array of medications to treat pain, inflammation, and common allergies<br /> -Wraps and bandages to immobilize fractures and provide support<br /> -Trauma pad and wide elastic wraps to control life-threatening bleeding<br /> -Stop blisters before they start with die-cut Moleskin plus Skin Tac topical adhesive<br /> -Easy access bandagesprovide fast and easy application and less contamination risk</p>	[empty string]	N	47.99	47.99	[empty string]	93475-DEFAULT-s.jpg	[empty string]	1000	0125-0290	105065	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/ultralight-watertight-9-kit-105065	1
4	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	32.99	0	32.99	93487-DEFAULT-l.jpg	32.99	93487-DEFAULT-m.jpg	SOL THERMAL BIVVY	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Sol Thermal Bivvy	<p>The SOL Thermal Bivvy offers more versatility than traditional emergency sleeping bags. Its metalized non-woven fabric provides waterproof protection from the elements while reflecting 80% of your body`s heat back to you. The bivvy`s extremely durable fabric resists rips and tears and, due to its soft face and aggressive side-venting, it can also be used as a stand-alone sleep system in warmer weather. Ideal for outdoor users looking for an emergency shelter that can become a regular part of their adventure gear.</p>	[empty string]	N	32.99	32.99	[empty string]	93487-DEFAULT-s.jpg	[empty string]	1000	0140-1223	122510	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/sol-thermal-bivvy-122510	1
5	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	9.99	0	9.99	30282-DEFAULT-l.jpg	9.99	30282-DEFAULT-m.jpg	BLISTER MEDIC	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]	2022	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	13	5-to-10	0.00	[empty string]	Blister Medic Kit	<p>The Blister Medic combines the superior protection of Moleskin with the advanced relief of Glacier Gel dressings. Alcohol pads for skin preparation and antiseptic toweletts for wound cleaning make this the total foot care package.<br />  </p>	[empty string]	N	9.99	9.99	[empty string]	30282-DEFAULT-s.jpg	[empty string]	1000	0155-0667	146008	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/blister-medic-146008	1
6	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	4.99	0	4.99	93479-DEFAULT-l.jpg	4.99	93479-DEFAULT-m.jpg	AFTER BITE OUTDOOR 0.5 FL.OZ. GEL	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	16	5-AND-under	0.00	[empty string]	After Bite - Outdoor	[empty string]	[empty string]	N	4.99	4.99	[empty string]	93479-DEFAULT-s.jpg	[empty string]	1000	0006-1560	284317	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/after-bite-outdoor-0-5-fl-oz-gel-284317	1
7	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	47.99	0	47.99	93481-DEFAULT-l.jpg	47.99	93481-DEFAULT-m.jpg	MOUNTAIN BACKPACKER MEDICAL KIT	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Mountain Backpacker Medical Kit	[empty string]	[empty string]	N	47.99	47.99	[empty string]	93481-DEFAULT-s.jpg	[empty string]	1000	0100-1003	299840	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/mountain-backpacker-medical-kit-299840	1
8	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	47.99	0	47.99	93482-DEFAULT-l.jpg	47.99	93482-DEFAULT-m.jpg	SPORTSMAN 200 MEDICAL KIT	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Sportsman 200 Medical Kit	The Bighorn Medical Kit is built for trips up to a week long. From treating common hunting and fishing injuries to serious bleeding injuries, this package will meet all your needs with a wide array of supplies and versatile, detachable field trauma kit. Designed for a group of 1 to 7 sportsman with a trip duration of 1 to 7 days.<br/> <br/> KIT INCLUDES:<br/> Bandage Materials:<br/> -6 Bandage, Adhesive, Fabric, 1`` x 3``<br/> -4 Bandage, Adhesive, Fabric, Knuckle<br/> -1 Bandage, Conforming Gauze, 3``<br/> -2 Dressing, Gauze, Sterile, 2`` x 2``, Package of 2<br/> -2 Dressing, Gauze, Sterile, 4`` x 4``, Package of 2<br/> -2 Dressing, Non-Adherent, Sterile, 3`` x 4``<br/> Bleeding:<br/> -2 Gloves, Nitrile (Pair)<br/> -1 Syringe, Irrigation, 20 cc, 18 Gauge Tip<br/> Blister / Burn:<br/> -1 Moleskin, Pre-Cut and Shaped (14 pieces)<br/> Duct Tape:<br/> -1 Duct Tape, 2`` x 50``<br/> Fracture / Sprain:<br/> -1 Bandage, Triangular<br/> Medical Information:<br/> -1 A Comprehensive Guide to Wilderness and Travel Medicine<br/> Instrument:<br/> -2 Thermometer, Disposable<br/> Medication:<br/> -2 After Bite Wipe<br/> -2 Antihistamine (Diphenhydramine 25 mg)<br/> -1 Aspirin (325 mg), Package of 2<br/> -2 Diotame (Bismuth Subsalicylate), Package of 2<br/> -2 Ibuprofen (200 mg), Package of 2<br/> -1 Instructions, Easy Care Medications<br/> Wound Care:<br/> -4 Antiseptic Wipe<br/> -1 Cotton Tip Applicator, Package of 2<br/> -1 Instructions, Easy Care Wound<br/> -1 Register Your Kit card<br/> -1 Orange 2`` x 2`` Biohazard Label<br/> -1 5`` x 8`` Ziplock Baggie<br/> -1 Povidone Iodine, 3/4 oz<br/> -2 Skin Tac Topical Adhesive Wipes<br/> -1 Syringe, Irrigation, 20 cc, 18 Gauge Tip<br/> -1 Tape, 1/2`` x 10 Yards<br/> -3 Triple Antibiotic Ointment, 1 oz<br/> -1 Wound Closure Strips, 1/4`` x 4``, Package of 10<br/> Field/Trauma Kit:<br/> -1 Bandage, Elastic, Self Adhering, 2``<br/> -2 Dressing, Gauze, Sterile, 4`` x 4``, Package of 2<br/> -2 Gloves, Nitrile (Pair)<br/> -1 Instructions,	[empty string]	N	47.99	47.99	[empty string]	93482-DEFAULT-s.jpg	[empty string]	1000	0105-0200	315351	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/sportsman-200-medical-kit-315351	1
9	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	34.99	0	34.99	93483-DEFAULT-l.jpg	34.99	93483-DEFAULT-m.jpg	SPORTSMAN 100 MEDICAL KIT	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Sportsman 100 Medical Kit	The Bighorn Medical Kit is built for trips up to a week long. From treating common hunting and fishing injuries to serious bleeding injuries, this package will meet all your needs with a wide array of supplies and versatile, detachable field trauma kit. Designed for a group of 1 to 7 sportsman with a trip duration of 1 to 7 days.<br/> <br/> KIT INCLUDES:<br/> Bandage Materials:<br/> -6 Bandage, Adhesive, Fabric, 1`` x 3``<br/> -4 Bandage, Adhesive, Fabric, Knuckle<br/> -1 Bandage, Conforming Gauze, 3``<br/> -2 Dressing, Gauze, Sterile, 2`` x 2``, Package of 2<br/> -2 Dressing, Gauze, Sterile, 4`` x 4``, Package of 2<br/> -2 Dressing, Non-Adherent, Sterile, 3`` x 4``<br/> Bleeding:<br/> -2 Gloves, Nitrile (Pair)<br/> -1 Syringe, Irrigation, 20 cc, 18 Gauge Tip<br/> Blister / Burn:<br/> -1 Moleskin, Pre-Cut and Shaped (14 pieces)<br/> Duct Tape:<br/> -1 Duct Tape, 2`` x 50``<br/> Fracture / Sprain:<br/> -1 Bandage, Triangular<br/> Medical Information:<br/> -1 A Comprehensive Guide to Wilderness and Travel Medicine<br/> Instrument:<br/> -2 Thermometer, Disposable<br/> Medication:<br/> -2 After Bite Wipe<br/> -2 Antihistamine (Diphenhydramine 25 mg)<br/> -1 Aspirin (325 mg), Package of 2<br/> -2 Diotame (Bismuth Subsalicylate), Package of 2<br/> -2 Ibuprofen (200 mg), Package of 2<br/> -1 Instructions, Easy Care Medications<br/> Wound Care:<br/> -4 Antiseptic Wipe<br/> -1 Cotton Tip Applicator, Package of 2<br/> -1 Instructions, Easy Care Wound<br/> -1 Register Your Kit card<br/> -1 Orange 2`` x 2`` Biohazard Label<br/> -1 5`` x 8`` Ziplock Baggie<br/> -1 Povidone Iodine, 3/4 oz<br/> -2 Skin Tac Topical Adhesive Wipes<br/> -1 Syringe, Irrigation, 20 cc, 18 Gauge Tip<br/> -1 Tape, 1/2`` x 10 Yards<br/> -3 Triple Antibiotic Ointment, 1 oz<br/> -1 Wound Closure Strips, 1/4`` x 4``, Package of 10<br/> Field/Trauma Kit:<br/> -1 Bandage, Elastic, Self Adhering, 2``<br/> -2 Dressing, Gauze, Sterile, 4`` x 4``, Package of 2<br/> -2 Gloves, Nitrile (Pair)<br/> -1 Instructions,	[empty string]	N	34.99	34.99	[empty string]	93483-DEFAULT-s.jpg	[empty string]	1000	0105-0100	315352	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/sportsman-100-medical-kit-315352	1
10	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	89.99	0	89.99	93484-DEFAULT-l.jpg	89.99	93484-DEFAULT-m.jpg	SPORTSMAN 300 MEDICAL KIT	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Sportsman 300 Medical Kit	[empty string]	[empty string]	N	89.99	89.99	[empty string]	93484-DEFAULT-s.jpg	[empty string]	1000	0105-0300	336420	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/sportsman-300-medical-kit-336420	1
11	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	149.99	0	149.99	100687-DEFAULT-l.jpg	149.99	100687-DEFAULT-m.jpg	SPORTSMAN 400 MEDICAL KIT	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Sportsman 400	<ul> <li> <h3>Size:11" x 8" x 3"</h3> </li> <li> <h3>Weight:2.5 lb</h3> </li> <li> <h3>Group Size:1 - 10 People</h3> </li> <li>Trip Duration:1 - 14 Days</li> </ul>	[empty string]	N	149.99	149.99	[empty string]	100687-DEFAULT-s.jpg	[empty string]	1000	0105-0400	336421	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/sportsman-400-336421	1
12	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	37.99	0	37.99	93485-DEFAULT-l.jpg	37.99	93485-DEFAULT-m.jpg	QUICK CLOT GAUZE 3` X 4`	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	21	25-to-50	0.00	[empty string]	Quick Clot Gauze - 3` X 4`	[empty string]	[empty string]	N	37.99	37.99	[empty string]	93485-DEFAULT-s.jpg	[empty string]	1000	5020-0026	336423	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/quick-clot-gauze-3-x-4-336423	1
13	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	14.99	0	14.99	93488-DEFAULT-l.jpg	14.99	93488-DEFAULT-m.jpg	HD EMERGENCY BLANKET	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	Hd Emergency Blanket	Use Ben’s Max Formula when the bugs are especially intense or when all-day protection is needed. This is a full strength repellent for maximum protection against tics and all types of biting insects.<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	14.99	14.99	[empty string]	93488-DEFAULT-s.jpg	[empty string]	1000	0140-1225	352053	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/hd-emergency-blanket-352053	1

CACHED

false

EXECUTIONTIME

16

SQL

SELECT * FROM GetALLProducts252 ORDER BY sortposition asc

Hunting

Sort By:

Items per page:

Filter