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	29.99	0	29.99	37190-DEFAULT-l.jpg	29.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]	1	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	29.99	29.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	19.99	0	19.99	30265-DEFAULT-l.jpg	19.99	30265-DEFAULT-m.jpg	WATERPROOF ULTRALIGHT 5 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]	1	15-to-20	0.00	[empty string]	Ultralight And Watertight .5 Medical Kit	<p>The Ultralight / Watertight .5 is designed for use by one person on a 1 to 2 day trip. Ideal for excursions that require an ultralight kit with enough supplies to treat common injuries and enough room to add other first aid and survival items. Packaged in a rugged, yet lightweight silnylon bag with a DryFlex waterproof liner, it will stay dry whatever the elements.</p>	[empty string]	N	19.99	19.99	[empty string]	30265-DEFAULT-s.jpg	[empty string]	1000	0125-0292	959	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/waterproof-ultralight-5-kit-959	1
3	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	6.49	0	6.49	93474-DEFAULT-l.jpg	6.49	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]	8	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	6.49	6.49	[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
4	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	40.99	0	40.99	93475-DEFAULT-l.jpg	40.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]	4	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	40.99	40.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
5	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	14.99	0	14.99	93476-DEFAULT-l.jpg	14.99	93476-DEFAULT-m.jpg	FIRST AID KIT 1.0	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]	1	10-to-15	0.00	[empty string]	Adventure First Aid 1.0	<p>The Adventure First Aid 1.0 Kit is designed for basic first aid essentials. Addressing needs like cuts & scrapes, sprains, insect bites, headaches, muscle aches, and allergic reactions. Highly organized, lightweight, and compact.<br />  </p>	[empty string]	N	14.99	14.99	[empty string]	93476-DEFAULT-s.jpg	[empty string]	1000	0120-0210	114188	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/first-aid-kit-1-0-114188	1
6	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	31.99	0	31.99	93487-DEFAULT-l.jpg	31.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]	9	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	31.99	31.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
7	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	10.99	0	10.99	30282-DEFAULT-l.jpg	10.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]	8	10-to-15	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	10.99	10.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
8	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	31.49	0	31.49	93477-DEFAULT-l.jpg	31.49	93477-DEFAULT-m.jpg	FAMILY 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]	6	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	31.49	31.49	[empty string]	93477-DEFAULT-s.jpg	[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
9	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	4.49	0	4.49	93479-DEFAULT-l.jpg	4.49	93479-DEFAULT-m.jpg	AFTER BITE OUTDOOR	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	5-AND-under	0.00	[empty string]	After Bite - Outdoor	[empty string]	[empty string]	N	4.49	4.49	[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-284317	1
10	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	29.99	0	29.99	93483-DEFAULT-l.jpg	29.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]	4	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	29.99	29.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
11	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	78.99	0	78.99	93484-DEFAULT-l.jpg	78.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]	4	50-to-100	0.00	[empty string]	Sportsman 300 Medical Kit	[empty string]	[empty string]	N	78.99	78.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
12	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	0	130.99	0	130.99	[empty string]	130.99	[empty string]	SPORTSMAN 400 MEDICAL KIT	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]	2022	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Sportsman 400 Medical Kit	[empty string]	[empty string]	N	130.99	130.99	[empty string]	[empty string]	[empty string]	1000	0105-0400	336421	EMPTY	EMPTY	EMPTY	0	0	0	FIRST AID & SURVIVAL	[empty string]	adventure-med-kits/sportsman-400-medical-kit-336421	1
13	[empty string]	ADVENTURE MED KITS	ADVENTURE MED KITS	HUNTING	Hunting>First Aid & Survival	[empty string]	1	32.99	0	32.99	93485-DEFAULT-l.jpg	32.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]	4	25-to-50	0.00	[empty string]	Quick Clot Gauze - 3` X 4`	[empty string]	[empty string]	N	32.99	32.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
14	[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]	7	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

0

SQL

SELECT * FROM GetALLProducts252 ORDER BY sortposition asc

Hunting

Sort By:

Items per page:

Filter