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

Currently Filtered by

Category

Respirator Cartridges And Filters

Refine Search

  GO
 
Brand

3M(7)

 
Manufacturer Part Number

2097(1)

5N11(1)

6001(1)

6003(1)

60921(1)

60926(1)

7093(1)

 
Country of Origin

US(6)

CA(1)

 
For Use With

MMM6100;MMM6200;MMM6300(4)

3M 5000 Series Respirators; 3M 6000 Series Cartridges(1)

3M Half/Full Facepieces 6000, 7000 Series; 3M FF-400(1)

3M Respirators 5000 Series;3M Cartridges 6000 Series with 3M Adapter 502;3M Facepieces 6000 Series;3M Facepieces 7000 Series(1)

 
Rating

P100(3)

P95(2)

N95(1)

 
Filter Type

Particulate(2)

Cartridge(2)

Organic Vapor(1)

Gas/Vapor(1)

Filter(1)

 
Filtration For

Certain Organic Vapors;Other Gases(2)

Non-Oil Based Particulates;Oil Based Particulates;Fumes(1)

Non-Oil Based Particulates(1)

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

Acid Gases; Organic Vapors; Non-Oil Based Particulates; Oil Based Particulates(1)

Non-Oil Based Particulates;Oil Based Particulates(1)

 
 
 

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