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','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 '%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(24)

3M(24)

Moldex(13)

BodyGear(1)

Jackson Safety*(1)

MSA(1)

 
Color(s)

Yellow(9)

Orange(6)

Random Color Patterns(4)

Magenta/Yellow(3)

Bright Green(3)

Green(3)

Coral(3)

Blue(3)

Orange/Blue(2)

Black(2)

Purple/Bright Green(2)

Black/Gray(2)

Yellow/Red(2)

Beige; Black(1)

Yellow//Black(1)

Yellow/Blue(1)

Red/Black(1)

Hi-Viz Green(1)

Black; Red(1)

Neon Yellow(1)

Yellow/Black(1)

Light Blue/Black(1)

Maroon/Black(1)

Blue/Yellow(1)

Camo(1)

Light Green(1)

Purple(1)

Iridescent(1)

Green/White(1)

Blue/White(1)

Green/Black(1)

Gray/Black(1)

 
Quantity

1 each(11)

200 per box(9)

10 per case(3)

100 per box(2)

30 per box(1)

24 per case(1)

500 per bottle(1)

10 per box(1)

 
Manufacturer Part Number

13256(1)

322-2000(1)

6900(1)

1100(1)

1110(1)

310-1001(1)

310-1060(1)

3101101(1)

310-1103(1)

311-1101(1)

311-1250(1)

311-1252(1)

312-1219(1)

312-1250(1)

312-1252(1)

3303031(1)

6800(1)

3404002(1)

340-4004(1)

391-1004(1)

H10A(1)

H10AHV(1)

H10B(1)

H6F/V(1)

H7A(1)

H9A(1)

X2A(1)

10061272(1)

1010924(1)

DPAS30R(1)

6845(1)

6654(1)

1010927(1)

MAX1(1)

1011601(1)

1013461(1)

1013941(1)

1030110(1)

DPAS30W(1)

FUS30HP(1)

FUS30SHP(1)

LL1(1)

LL1D(1)

LL30(1)

LPF1(1)

LPF1D(1)

LPF30(1)

MAX1D(1)

6645(1)

MAX30(1)

QD1(1)

QD30(1)

SDT30(1)

SMF30(1)

67210(1)

6100(1)

6400(1)

6405(1)

6415(1)

6600(1)

6604(1)

6609(1)

6644(1)

QB2HYG(1)

 
Country of Origin

US(41)

MX(11)

CN(6)

TW(2)

BR(2)

KR(1)

PL(1)

 
Material(s)

Foam(11)

Polyurethane Foam(9)

Molded Rubberized Foam(5)

ABS Plastic(5)

PVC(5)

Polyurethane(5)

Metal/Plastic(3)

Foam/Plastic(2)

Plastic(2)

Steel/Foam/ABS Plastic/PVC(2)

Molded Rubberized Foam/Plastic(2)

CMT Polymer(2)

ABS(2)

PVC Foam(1)

TPE(1)

Plasic/Metal(1)

Foam;Plastic(1)

Elastomeric Polymer(1)

Rubberized Molded Foam/Plastic(1)

ABS/Polyurethane(1)

Steel/Plastic(1)

PVC/EPDM/Polypropylene(1)

 
Shape

Bullet(11)

Flanged(10)

T(6)

Bell(5)

Cylinder(5)

Tapered(5)

Band with Pod(1)

Multi-Flange(1)

Tapered Cylindrical(1)

Supra-Aural Pod(1)

 
For Use With

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

Most Hard Hats(1)

MSA Hard Hats(1)

 
Weight

0.45 lbs.(1)

12 oz(1)

16 oz(1)

.03 lbs(1)

0.633(1)

.88 lbs(1)

0.438(1)

7.80 lbs.(1)

0.55 lbs(1)

10.1 oz(1)

12.8 oz(1)

 
Style

Over-The-Head(6)

Over the Head(3)

Headband(2)

Multiple-position;Over the Head(1)

Helmet(1)

Folding Over-The-Head(1)

Cap-Mounted(1)

Behind-The-Head(1)

Two-Piece Hard Hat(1)

 
Size Group

One Size Fits All(28)

Regular(7)

One Size Fits Most(6)

Small(2)

Large(1)

 
Noise Reduction Rate (NRR)

33 dB(18)

29 dB(10)

27 dB(8)

30 dB(7)

25 dB(7)

32 dB(4)

21 dB(3)

23 dB(2)

26 dB(2)

28 dB(1)

24 dB(1)

27(1)

 
Noise Protection

Yes(2)

 
Corded/Cordless

Corded(22)

Cordless(17)

Uncorded(7)

Banded(1)

 
Ear Cushion Material

Foam(5)

Liquid/Foam(2)

Liquid, Foam-Filled(2)

Soft Foam(1)

SoftCoat(1)

Foam-Filled(1)

Liquid-Filled Foam(1)

Vinyl Covered Foam(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved