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

Currently Filtered by

Category

Face Mask Respirator

Refine Search

  GO
 
Brand

Moldex(6)

North Safety(4)

Allegro(1)

Gerson(1)

ProGuard(1)

Kimtech(1)

3M(1)

Honeywell Uvex(1)

 
Color

White(1)

 
Size

Medium/Large(5)

One Size Fits All(2)

Small(1)

One size fits most(1)

Medium(1)

 
Recycled

No(1)

 
Packaged Quantity

50 / Box(1)

 
Warranty

Manufacturer's limited warranty.(1)

 
Special Features

Anti-Fog/Hardcoat(1)

 
Application

Respirators; Safety Equipment(1)

 
For Use With

North Safety Respirators(1)

North Safety 5400, 5500, 7600, 7700 Series Facepieces(1)

North Safety Respirator Cartridges/Filters(1)

Uvex Bionic Face Shield Windows(1)

 
Applicable Material

Glass; Metal; Plastic; Plexiglas; Rubber(1)

 
Dirt Types

Bacteria; Dust; Grime; Organic Matter; Soil(1)

 
Chemical Compound

Isopropyl Alcohol(1)

 
Manufacturer Part Number

1001(1)

2600N95(1)

770030M(1)

760008A(1)

7580P100(1)

7506N95(1)

8211(1)

2700N95(1)

2400N95(1)

1501(1)

2315N99(1)

2300N95(1)

2201N95(1)

2200N95(1)

62692(1)

7300B(1)

S8510(1)

 
Country of Origin

US(12)

MX(3)

CN(1)

China(1)

 
Material

Polypropylene(1)

 
Width

5"(1)

 
Color(s)

White(1)

Black/Clear(1)

 
Material(s)

Non-Woven Synthetic Fiber(1)

Paper(1)

Outer: Polyethylene; Inner: BICOSOF* Fabric(1)

Dura-Mesh Shell(1)

Foam(1)

Dura-Mesh/Softspun(1)

Silicone/Polycarbonate(1)

Silicone(1)

Polycarbonate/Foam(1)

 
Length

7"(1)

 
Style

Anti-Fog Visor(1)

 
Protection Type

Dust(1)

Pollen(1)

 
Size Group

One Size Fits All(1)

Regular(1)

 
Number of Plies

1(1)

 
Packaging

Dispenser Box(1)

 
Towel/Wipe Type

Cleaner/Detergent Wet Wipe(1)

 
Number of Towels/Wipes Per Container

100(1)

 
Safety Headgear Accessory Type

Face Shield(1)

 
Adjustability Features

Adjustable Straps(3)

Adjustable Strap(1)

 
Rating

N95(8)

ISO Class 5 or higher(1)

N99(1)

P100(1)

 
Filter Type

Filter(1)

Particulate(1)

 
Respirator Type

Half-Face Mask(9)

Mask(1)

 
Valved

Yes(8)

No(2)

 
Resistance

Non-Oil Based Particles(2)

Non-Oil Based Particulates(2)

Cut Grass; Dirt; Dust; Pollen(1)

Bacteria; Particles(1)

Particulate Aerosols Free of Oil; Solids(1)

Particulates(1)

 
Filtration For

Non-Oil Based Particulates(2)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved