Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('30811')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%ClothingProtection' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ClothingProtection' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ClothingProtection' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ClothingProtection"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ClothingProtection"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ClothingProtection"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ClothingProtection"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ClothingProtection' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ClothingProtection',`category_4` ='ClothingProtection') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ClothingProtection,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ClothingProtection', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Clothing Protection

Refine Search

  GO
 
Brand

KleenGuard(58)

DuPont(26)

ergodyne(25)

MCR Safety(12)

Boardwalk(7)

Anchor Brand(6)

3M(4)

KleenGuard*(2)

Honeywell(1)

Chenille Kraft(1)

 
Color(s)

White(76)

Lime(15)

Orange(14)

Blue(13)

Yellow(8)

Denim Blue(4)

Lime Green/Silver(3)

Fluorescent Lime w/Silver Stripe(3)

White/Blue(2)

Bright Orange/Black(1)

Orange/Silver(1)

Assorted;Assorted Bright Color Design(1)

Bright Orange/Lime;Silver Reflective Strips(1)

 
Manufacturer Part Number

44333(1)

44334(1)

44335(1)

44327(1)

44325(1)

44323(1)

44324(1)

44336(1)

44337(1)

45093(1)

45094(1)

45095(1)

45005(1)

45004(1)

44445(1)

45003(1)

44317(1)

44316(1)

23873(1)

36870(1)

38938(1)

23610(1)

KVS218TH(1)

22025(1)

22027(1)

38939(1)

38941(1)

44305(1)

44314(1)

44315(1)

44304(1)

44303(1)

42526(1)

42528(1)

45096(1)

45315(1)

49117(1)

58504(1)

58505(1)

49116(1)

49115(1)

49113(1)

49114(1)

58514(1)

58532(1)

V211R(1)

VCL2SLX3(1)

VCL2SLX4(1)

4520BLKXXL(1)

4520BLKXL(1)

4520BLKL(1)

4520BLKM(1)

49105(1)

49104(1)

46003(1)

46004(1)

46005(1)

45357(1)

45356(1)

45316(1)

45355(1)

46007(1)

46104(1)

49004(1)

49005(1)

49006(1)

49003(1)

46126(1)

46114(1)

46115(1)

22023(1)

22019(1)

IC501BWB(1)

NG120S2XL(1)

NG120S3XL(1)

VCL2SLXL2(1)

VCL2SLXL(1)

V201R(1)

VCL2SLL(1)

NG120S4XL(1)

NG120SL(1)

TY120SL(1)

TY120SM(1)

TY120SXL(1)

TY120S4XL(1)

TY120S3XL(1)

NG120SXL(1)

TY120S2XL(1)

V201(1)

CL2LCXL(1)

9010XL(1)

00032L(1)

00032M(1)

90102XL(1)

9000XL(1)

90003XL(1)

9000L(1)

00032S(1)

00032XL(1)

9378TE(1)

CL2LCL(1)

CL2LCM(1)

5207(1)

0032XXL(1)

00035(1)

00036(1)

TY122S2XL(1)

TY122S3XL(1)

21025(1)

21045(1)

21055(1)

20979(1)

20977(1)

20973(1)

20975(1)

21057(1)

21063(1)

22013(1)

22015(1)

22017(1)

21125(1)

21069(1)

21065(1)

21067(1)

20969(1)

20967(1)

TY127S2XL(1)

TY127S3XL(1)

TY127S4XL(1)

TY125SL(1)

TY125S2XL(1)

TY122SL(1)

TY122SXL(1)

TY127SL(1)

TY127SXL(1)

20963(1)

20965(1)

20040(1)

TY500S(1)

TY212SL(1)

TY212SM(1)

90002XL(1)

 
Country of Origin

CN(58)

MX(33)

ID(25)

VN(25)

YT(1)

 
Material(s)

MICROFORCE* Barrier SMS Fabric(23)

Polyester(21)

High-Density Polyethylene(20)

Polyester Mesh(17)

Microporous Film Laminate(9)

Breathable Microporous Film Laminate(8)

Polypropylene(6)

PVC/Polyester(6)

SMS-Based Material(5)

Spun-Bonded Polypropylene/Breathable Microporous Film Laminate(4)

Breathable, patented MICROFORCE* barrier SMS fabric(3)

Film Laminate(3)

Spunlace Nonwoven Fabric(2)

Microporous Film Laminate/Polypropylene(2)

Kevlar(2)

Microporous Film Laminate; SMS(2)

Vinyl(1)

Tyvek Flashspun Polyethylene(1)

 
Size Group

X-Large(25)

2X-Large(25)

Large(22)

3X-Large(14)

4X-Large(10)

One Size Fits All(8)

Medium(6)

Large/X-Large(5)

S/M(4)

2XL/3XL(4)

L/XL(4)

4XL/5XL(3)

2X-Large/3X-Large(2)

Standard(2)

4X-Large/5X-Large(1)

18 in.(1)

XX-Large(1)

Small/Medium(1)

Small(1)

XXL(1)

One Size Fits Most(1)

 
Suggested Use

Food Service; Laboratories; Liquid, Particle Protection; Maintenance; Manufacturing(5)

Railway; Construction; Utility Workers; Survey Crews(5)

Labs; Pesticide Spraying; Manufacturing(5)

Food Handling; Maintenance(5)

Safety & Visibility(4)

Laboratories; Decontamination Modesty Garment; Remediation; Pesticides; Heavy Dust Environments(4)

Asbestos Abatement and Inspection; Exposure to Radioactive Particles; Lead Abatement; Mold Remediation/Mold Spores; Animal Waste (Solid); Fertilizer Application (Dry/Granular); Pesticide Application (Dry/Granular); Dirt (General); General Industrial Clean-up and Processing; Grease (General); Light-duty Building Cleaning; Machine or Vehicle Maintenance; Coal Dust; Electronics/Ciruit Board Assembly; Fiberglass/Cellulose Insulation Installation; Food Processing; General Industrial Clean-up and Processing; General Powder Handling; Lime Handling; Warehousing; Woodworking; Non-hazardous Aerosols (Sprays); Non-hazardous Liquids; Non-hazardous Solids; Metal particulate (chromium beryllium, and more); Metal Polishing(4)

Animal Research; Emergency Medical Response; Crime Scene Cleanup; Embalming / Forensics; Tank Cleaning; Fiberglass Manufacturing; Liquid Handling; Food Processing(4)

Fuel Depots/Stations; Laboratories; Maintenance; Manufacturing; Pesticide/Herbicide Application(3)

Liquid Handling; Pressure Washing; Maintenance; General Manufacturing(3)

Maintenance; Manufacturing(3)

Fuel Depots/Stations;Maintenance;Manufacturing(3)

Welding(3)

Wind Blade Manufacturing; Maintenance; General Manufacturing(2)

Maintenance; Manufacturing; Pharmaceutical Research(2)

Pharmaceutical Research; Dry Particle Contamination; Aerospace; Maintenance; General Manufacturing(2)

Manufacturing; Cleaning; Handling Liquids(2)

Food Processing; Manufacturing(1)

Decontamination; Heavy Dust Environments; Laboratories; Pesticides; Remediation(1)

Fuel Depots/Stations(1)

Fiberglass Manufacturing(1)

Liquid, Particle Protection; Maintenance; Manufacturing(1)

Biotech; Pharmaceutical; Medical Device Manufacturing; Electronics Industries(1)

Cut Protection(1)

Food Processing; General Maintenance; Manufacturing(1)

Food Service;Laboratories;Maintenance;Manufacturing(1)

Hospitals; Laboratories; Maintenance; Manufacturing(1)

Hospitals;Laboratories;Maintenance;Manufacturing(1)

Fiberglass Manufacuring; Tank Cleaning; Utilities; Liquid Handling; Pressure Washing; Maintenance; General Manufacturing(1)

Fiberglass Manufacturing; Tank Cleaning; Utilities; Liquid Handling; Pressure Washing; Maintenance; General Manufacturing(1)

 
Washable

Yes(50)

No(26)

 
Apparel Type

Coverall(66)

Vest(38)

Coveralls(20)

Rainsuit(4)

Coat(4)

Protective Sleeve(4)

Raincoat(2)

Lab Coat(1)

Sleeve(1)

Artist Smock(1)

Jacket(1)

 
 
 

© 2019-2020 Dependable Office Supply, All Rights Reserved