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

Currently Filtered by

Category

Hooded Top Plastic Or Fiberglass

Refine Search

  GO
 
Brand

Rubbermaid Commercial(4)

 
Warranty

Manufacturer's limited one-year warranty.(4)

 
Special Features

For 44-Gallon Containers(1)

 
Application

General Waste(2)

Indoor All-Purpose Waste Disposal(1)

 
For Use With

Rubbermaid Commercial Brute 2643 Series Waste Containers(1)

 
Diameter

18"(1)

24 7/8"(1)

 
Manufacturer Part Number

8182-88 BEI(1)

3970 SAB(1)

3970-01SAB(1)

1834840(1)

 
Country of Origin

US(4)

 
Height

42 1/4"(1)

40"(1)

40 in(1)

12 5/8"(1)

 
Width

26"(2)

18"(1)

 
Depth

26"(2)

18"(1)

 
Color(s)

Sable(2)

Beige(1)

Blue(1)

 
Material(s)

Plastic(3)

LLDPE Plastic(1)

 
Shape

Round(2)

Rectangular Prism(1)

Square(1)

 
Capacity (Volume)

25 gal(1)

35 gal(1)

35.000 gal(1)

 
Finish

Textured(1)

Matte(1)

 
Opening Type

Open Sides(1)

Open Side(1)

 
Waste Receptacle Type

Receptacle with Ashtray(2)

Indoor All-Purpose Waste Bin(1)

 
Lid Type

Lift Off(2)

Hood w/Open Side(1)

Dome Top w/Push Door(1)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved