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

Currently Filtered by

Category

Respirators

Refine Search

  GO
 
Brand

3M(22)

Moldex(7)

Boardwalk(2)

North Safety(2)

Jackson Safety*(1)

 
Size

One Size Fits All(10)

Medium/Large(8)

Large(5)

Standard(5)

Medium(3)

Small(2)

One size fits most(1)

 
Manufacturer Part Number

00018(1)

8110S(1)

760008A(1)

8577(1)

8516(1)

8515(1)

8511PRO(1)

8511(1)

8271(1)

8247(1)

8233(1)

8211(1)

8210V(1)

8210PLUS(1)

8210(1)

8200(1)

6900(1)

00019(1)

2600N95(1)

64230(1)

2200N95(1)

2200N95HV(1)

2300N95(1)

2315N99(1)

2500N95(1)

2840R95(1)

6800(1)

52P71(1)

53P71(1)

6111PA1A(1)

6291(1)

6311PA1A(1)

6391(1)

770030L(1)

 
Country of Origin

US(29)

CN(3)

MX(2)

 
Material(s)

Advanced Electrostatic Media(5)

Lightweight Thermoplastic Elastomer(5)

Polyester(3)

Thermoplastic Elastomer (TPE)(3)

Dura-Mesh Shell(2)

Foam(1)

Advanced Electret Media(1)

Silicone/Polycarbonate(1)

Silicone(1)

 
For Use With

3M 2000 Series Filters; 3M 7093 P100 Filters; 3M 6000 Series Cartridges; 3M Dual Airline Systems.(2)

3M 6000 Series Cartridges; 3M 2000, 2200, 5000, 7000 Series Filters; 3M Dual Airline Systems(2)

NIOSH-approved 3MOrganic Vapor and P95 Particulate(1)

6311PA1-A(1)

North Safety Respirator Cartridges/Filters(1)

 
Adjustability Features

4-Point Harness(5)

Adjustable Strap(3)

Adjustable Straps(2)

Adjustable straps(2)

Adjustable Noseclip(2)

Nose Clip; Adjustable Strap(1)

Nose Clip(1)

Adjustable Staps(1)

Adjustable Strap;Nose Clip(1)

Adjustable Strap; Nose Clip(1)

Adjustable M-noseclip(1)

 
Respirator Type

Half-Face Mask(30)

Mask(4)

 
Valved

Yes(25)

No(8)

 
Resistance

Non-Oil Based Particles(7)

Non-Oil Based Particulates(4)

Non Oil & Solid Particulate(2)

Organic Vapors(2)

Dust(1)

Particulate Aerosols Free of Oil; Solids(1)

Acid Gases; Organic Vapors(1)

Non-Oil Based Particulates; Nuisance Organic Vapors; Oil(1)

Non-oil based particles(1)

Dust; Non-Oil Based Particulates(1)

 
Rating

N95(18)

P95(4)

P100(4)

Organic Vapor(2)

N99(1)

R95(1)

Unvalved N95(1)

N100(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved