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 ('40200')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%LooseLeafAddressBookRefills' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('LooseLeafAddressBookRefills' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+LooseLeafAddressBookRefills' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"LooseLeafAddressBookRefills"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"LooseLeafAddressBookRefills"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"LooseLeafAddressBookRefills"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"LooseLeafAddressBookRefills"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+LooseLeafAddressBookRefills' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='LooseLeafAddressBookRefills',`category_4` ='LooseLeafAddressBookRefills') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'LooseLeafAddressBookRefills,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('LooseLeafAddressBookRefills', `pinfo`.`desc_title`)) DESC
<
GO
Currently Filtered by
Category
Loose Leaf Address Book Refills
Refine Search
GO
Brand
Rubbermaid Commercial(2)
Application
Indoor All-Purpose Waste Disposal(1)
General Waste(1)
For Use With
Rubbermaid Commercial Ranger Square Containers(1)
Country of Origin
US(2)
Height
28.5"(1)
27 5/8"(1)
Width
16.25"(1)
19 1/2"(1)
Depth
16.25"(1)
19 1/2"(1)
Color(s)
Gray(1)
Beige(1)
Material(s)
Plastic(2)
Shape
Rectangular Prism(1)
Square(1)
Capacity (Volume)
24.67 gal(1)
35 gal(1)
Opening Type
Open Top(2)
Waste Receptacle Type
Rigid Waste Bin Liner(1)
Rigid Liner(1)
Liner Material
LLDPE Plastic(1)
Plastic(1)
Filtered By Sort by
Current Page 1 of 1
Result Per Page