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

Currently Filtered by

Category

Sorbents

Refine Search

  GO
 
Brand

Boardwalk(13)

SPC(10)

i-Chem(2)

Big D Industries(1)

Fresh Products(1)

 
Special Features

Green - With Grit-For rough, unfinished floors.(2)

Red - With Grit-For rough, unfinished floors.(2)

Green - Grit-Free-For all floors not damaged by oil.(2)

Red - Grit-Free-For all floors not damaged by oil.(2)

Clay Base(1)

Heavyweight Pads(1)

Heavyweight(1)

 
Application

Concrete Floors;Unfinished Floors(6)

Finished Floors; Painted Floors(4)

Concrete Floors; Unfinished Floors(3)

Odor Control(1)

 
Applicable Material

Cement; Concrete; Tile; Wood(9)

Ceramic; Cement; Concrete; Laminates; Vinyl; Wood(4)

 
Dirt Types

Debris; Dust; Soil(8)

Debris; Dirt; Dried Mud; Scuff Marks(4)

Debris; Dust; Scuff Marks; Soil(1)

 
Physical Form

Powder(14)

 
Diameter

3"(2)

 
Manufacturer Part Number

P00530-32(1)

W4COHO(1)

SW46(1)

SPC300(1)

SKAPP(1)

RFP28DP(1)

MRO100(1)

HT303(1)

GP100(1)

ENV300(1)

BM15(1)

614SSEA(1)

W6COHO(1)

W3COHO(1)

P00530-6(1)

SWEEP100(1)

G6COHORED(1)

G6COHO(1)

G3COHORED(1)

G3COHO(1)

A3COHORED(1)

A3COHO(1)

A1COHORED(1)

A1COHO(1)

20515(1)

150(1)

UXT100(1)

 
Country of Origin

US(27)

 
Width

15"(6)

30"(1)

28 1/2"(1)

3"; 15"; 17"(1)

3"(1)

 
Color(s)

Gray(6)

White(4)

Industrial Camouflage(1)

Gray/Yellow(1)

 
Length

19 in(4)

150 ft(2)

300 ft(1)

19"; 12 ft(1)

42"(1)

19"(1)

 
Packing Type

Box(10)

Bale(4)

Drum(3)

Roll(3)

Carton(2)

Canister(1)

Bag(1)

Shaker Bottle(1)

Shaker Can(1)

Bucket(1)

 
Scent

Petroleum Odor(8)

Neutral(5)

Lemon(1)

 
Capacity (Weight)

50 lbs.(5)

150 lbs.(3)

100 lbs.(2)

100 lbs(2)

32 oz(1)

1 lbs.(1)

16 oz(1)

50 lbs(1)

12 oz(1)

 
Sorbents Type

Pad(4)

Particulates(3)

Roll(3)

Kit(1)

Sock(1)

Pads(1)

 
Material Absorbed

Chemicals; Oil; Petroleum; Water(4)

All Liquids(3)

Oil; Petroleum(2)

Acids; Bases; Chemicals; Oil; Petroleum; Water(1)

Chemicals; Petroleum; Oil; Water(1)

Grease; Oil; Water(1)

Acids; Bases; Chemicals; Coolants; Petroleum; Oil; Solvents; Water(1)

 
Absorbing Volume (Unit)

720 oz(1)

25 gal(1)

0.24 gal(1)

0.25 gal(1)

63 gal(1)

0.26 gal(1)

62 gal(1)

15 gal(1)

0.3 gal(1)

2 qt(1)

24.3 oz(1)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved