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','out_of_stock') 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(31)

ergodyne(25)

DuPont(17)

MCR Safety(8)

Boardwalk(7)

KleenGuard*(6)

3M(3)

Anchor Brand(2)

Creativity Street(1)

Honeywell(1)

 
Color(s)

White(48)

Lime(15)

Orange(13)

Blue(9)

Yellow(4)

Fluorescent Lime w/Silver Stripe(3)

Denim Blue(3)

White/Blue(2)

Orange/Silver(1)

Lime Green/Silver(1)

Assorted;Assorted Bright Color Design(1)

Bright Orange/Lime;Silver Reflective Strips(1)

 
Manufacturer Part Number

90002XL(1)

38941(1)

44323(1)

44317(1)

44316(1)

44314(1)

44305(1)

44304(1)

44303(1)

42528(1)

42526(1)

38939(1)

44325(1)

38938(1)

23610(1)

KVS218TH(1)

22027(1)

22025(1)

22023(1)

22019(1)

22017(1)

22015(1)

22013(1)

44324(1)

44333(1)

21069(1)

48975(1)

4520BLKXL(1)

4520BLKM(1)

58537(1)

58535(1)

58505(1)

58504(1)

49116(1)

49004(1)

48977(1)

48976(1)

45356(1)

44334(1)

45355(1)

45096(1)

45095(1)

45094(1)

45005(1)

45004(1)

45003(1)

44445(1)

44336(1)

44335(1)

21125(1)

21067(1)

90102XL(1)

CL2LCXL(1)

TY120SXL(1)

TY120SL(1)

TY120S3XL(1)

TY120S2XL(1)

NG120SL(1)

VCL2SLXL2(1)

VCL2SLXL(1)

VCL2SLL(1)

V201R(1)

CL2LCM(1)

TY122SL(1)

CL2LCL(1)

9378TE(1)

5207(1)

0032XXL(1)

00036(1)

00035(1)

00032XL(1)

00032S(1)

00032M(1)

00032L(1)

TY122S2XL(1)

TY122SXL(1)

21065(1)

20967(1)

21063(1)

21057(1)

21055(1)

21045(1)

21025(1)

20979(1)

20977(1)

20975(1)

20973(1)

20969(1)

20965(1)

TY125S2XL(1)

20963(1)

20040(1)

TY500S(1)

TY212SM(1)

TY212SL(1)

TY127SXL(1)

TY127SL(1)

TY127S3XL(1)

TY127S2XL(1)

TY125SL(1)

4520BLKXXL(1)

 
Country of Origin

CN(40)

ID(25)

MX(19)

VN(17)

 
Material(s)

Polyester(19)

High-Density Polyethylene(16)

Polyester Mesh(15)

Polypropylene(6)

Breathable Microporous Film Laminate(6)

Microporous Film Laminate(6)

SMS-Based Material(6)

MICROFORCE* Barrier SMS Fabric(6)

Film Laminate(3)

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

PVC/Polyester(2)

Kevlar(2)

Microporous Film Laminate; SMS(2)

Breathable, patented MICROFORCE* barrier SMS fabric(2)

Vinyl(1)

Microporous Film Laminate/Polypropylene(1)

 
Size Group

2X-Large(19)

X-Large(16)

Large(15)

3X-Large(8)

Large/X-Large(5)

One Size Fits All(5)

2XL/3XL(4)

S/M(4)

L/XL(4)

Medium(4)

4XL/5XL(3)

4X-Large(3)

Standard(2)

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

XXL(1)

Small(1)

Small/Medium(1)

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

18 in.(1)

XX-Large(1)

 
Suggested Use

Food Handling; Maintenance(5)

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

Safety & Visibility(4)

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

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

Surface Prep Areas; Paint Application Areas(3)

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(3)

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

Wind Blade Manufacturing; Maintenance; General Manufacturing(2)

Manufacturing; Cleaning; Handling Liquids(2)

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

Maintenance; Manufacturing(2)

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

Fuel Depots/Stations;Maintenance;Manufacturing(2)

Welding(1)

Cut Protection(1)

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

Hospitals;Laboratories;Maintenance;Manufacturing(1)

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

Food Processing; General Maintenance; Manufacturing(1)

Labs; Pesticide Spraying; Manufacturing(1)

Fiberglass Manufacturing(1)

 
Washable

Yes(39)

No(21)

 
Apparel Type

Coverall(46)

Vest(34)

Coveralls(10)

Coat(3)

Protective Sleeve(3)

Rainsuit(1)

Raincoat(1)

Artist Smock(1)

Sleeve(1)

Lab Coat(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved