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	28.99	0	28.99	37190-DEFAULT-l.jpg	28.99	37190-DEFAULT-m.jpg	WATERPROOF ULTRALIGHT 7 KIT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	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	28.99	28.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]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	MOLESKIN	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	11	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	5.99	5.99	[empty string]	[empty string]	[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]	0	38.99	0	38.99	[empty string]	38.99	[empty string]	ULTRALIGHT WATERTIGHT 9 KIT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	5	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	38.99	38.99	[empty string]	[empty string]	[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]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SOL THERMAL BIVVY	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	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	29.99	29.99	[empty string]	[empty string]	[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 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	9	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]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	FAMILY MEDICAL KIT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Family First Aid Kit	<p>The Family First Aid Kit includes a comprehensive assortment of medications and tools that will help you with the most common injuries and ailments families face in the outdoors.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	0120-0230	146021	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/family-medical-kit-146021	1
7	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	0	38.99	0	38.99	[empty string]	38.99	[empty string]	MOUNTAIN BACKPACKER MEDICAL KIT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Mountain Backpacker Medical Kit	[empty string]	[empty string]	N	38.99	38.99	[empty string]	[empty string]	[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	39.99	0	39.99	37219-DEFAULT-l.jpg	39.99	37219-DEFAULT-m.jpg	SPORTSMAN 200 MEDICAL KIT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Sportsman Bighorn 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	39.99	39.99	[empty string]	37219-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	28.99	0	28.99	37219-DEFAULT-l.jpg	28.99	37219-DEFAULT-m.jpg	SPORTSMAN 100 MEDICAL KIT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Sportsman Bighorn 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	28.99	28.99	[empty string]	37219-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]	0	74.99	0	74.99	[empty string]	74.99	[empty string]	SPORTSMAN 300 MEDICAL KIT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Sportsman 300 Medical Kit	[empty string]	[empty string]	N	74.99	74.99	[empty string]	[empty string]	[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]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	QUICK CLOT GAUZE 3` X 4`	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Quick Clot Gauze 3` X 4`	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[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
12	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	0	22.99	0	22.99	[empty string]	22.99	[empty string]	SOL EMERGENCY BIVVY XL	N	4 MAIDA	[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]	4	20-to-25	0.00	[empty string]	Sol Emergency Bivvy	<p>The ultralight, ultra-warm full protection shelter! The SOL Emergency Bivvy is made from heat-reflective polyethylene reflecting 90% of your body heat back to you. Fully sealed so that no wind, rain, or snow can get inside.</p>	[empty string]	N	22.99	22.99	[empty string]	[empty string]	[empty string]	1000	0140-1139	352055	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/sol-emergency-bivvy-xl-352055	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts252 ORDER BY sortposition asc

Hunting

Sort By:

Items per page:

Filter