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 ('30821')) 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 '%EarProtection' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('EarProtection' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+EarProtection' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"EarProtection"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"EarProtection"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"EarProtection"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"EarProtection"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+EarProtection' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='EarProtection',`category_4` ='EarProtection') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'EarProtection,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('EarProtection', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Ear Protection

Refine Search

  GO
 
Brand

Howard Leight by Honeywell(21)

3M(18)

Moldex(9)

MSA(1)

Jackson Safety*(1)

BodyGear(1)

Boardwalk(1)

 
Color(s)

Yellow(10)

Orange(5)

Random Color Patterns(4)

Orange/Blue(3)

Coral(3)

Green(3)

Bright Green(3)

Magenta/Yellow(3)

Yellow/Red(2)

Black/Gray(2)

Purple/Bright Green(2)

Blue(2)

Beige; Black(1)

Black/Red(1)

Gray/Black(1)

Black; Red(1)

Black(1)

Green/White(1)

Blue/White(1)

Green/Black(1)

Blue/Yellow(1)

 
Quantity

200 per box(9)

1 each(7)

100 per box(2)

10 per carton(2)

10 per box(1)

30 per box(1)

 
Manufacturer Part Number

310-1103(1)

3101101(1)

311-1101(1)

311-1250(1)

311-1252(1)

310-1060(1)

310-1001(1)

6845(1)

6800(1)

6900(1)

1100(1)

1110(1)

3121201(1)

312-1219(1)

10061272(1)

X3A(1)

1010924(1)

DPAS30R(1)

QB2HYG(1)

H6F/V(1)

H10A(1)

312-1250(1)

312-1252(1)

322-2000(1)

340-4004(1)

6654(1)

6645(1)

LL1D(1)

LL1(1)

LL30(1)

LPF1(1)

LPF1D(1)

FUS30SHP(1)

FUS30HP(1)

13256(1)

1013461(1)

1013941(1)

1030110(1)

LPF30(1)

LT30(1)

6400(1)

67210(1)

6405(1)

6604(1)

6644(1)

SMF30(1)

QD30(1)

MAX1(1)

MAX1D(1)

MAX30(1)

QD1(1)

00038(1)

 
Country of Origin

US(32)

MX(10)

CN(4)

TW(3)

BR(2)

PL(1)

 
Material(s)

Polyurethane Foam(9)

Foam(8)

PVC(5)

Polyurethane(5)

Molded Rubberized Foam(4)

Metal/Plastic(3)

Steel/Foam/ABS Plastic/PVC(2)

ABS(2)

Foam/Plastic(2)

Molded Rubberized Foam/Plastic(2)

Foam;Plastic(1)

Plastic/Metal(1)

TPE(1)

Elastomeric Polymer(1)

PVC/EPDM/Polypropylene(1)

ABS/Polyurethane(1)

CMT Polymer(1)

Polyurethane Foam; Brass(1)

PVC Foam(1)

Polyurethane Foam With Encased Metal Ball(1)

 
Shape

Bullet(10)

T(7)

Cylinder(6)

Flanged(6)

Tapered(6)

Bell(5)

Supra-Aural Pod(1)

Band with Pod(1)

Multi-Flange(1)

 
For Use With

MSA Hard Hats(1)

MP3 Players, Mobile Phones, Personal Audio Devices(1)

 
Weight

0.87 lbs(1)

12.8 oz(1)

0.438(1)

0.633(1)

12 oz(1)

16 oz(1)

0.45 lbs.(1)

 
Style

Over-The-Head(4)

Headband(2)

Two-Piece Hard Hat(1)

Over the Head(1)

Folding Over-The-Head(1)

 
Size Group

One Size Fits All(26)

Regular(7)

One Size Fits Most(6)

Small(2)

Large(1)

 
Noise Reduction Rate (NRR)

33 dB(15)

29 dB(8)

30 dB(6)

32 dB(6)

27 dB(5)

25 dB(4)

28 dB(2)

21 dB(2)

26 dB(2)

27(1)

23 dB(1)

 
Noise Protection

Yes(2)

 
Corded/Cordless

Corded(19)

Cordless(16)

Uncorded(7)

Banded(1)

 
Ear Cushion Material

Foam(5)

Vinyl Covered Foam(1)

Liquid, Foam-Filled(1)

Foam-Filled(1)

Soft Foam(1)

 
 
 

© 2019-2020 Office Outfitters, All Rights Reserved