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 ((`desc_short` like 'water resistant self stick notes' OR `desc_long` like 'water resistant self stick notes' OR `desc_title` like 'water resistant self stick notes' OR `keywords` like 'water resistant self stick notes' OR `category_1` like 'water resistant self stick notes' OR `category_2` like 'water resistant self stick notes' OR `category_3` like 'water resistant self stick notes' OR `category_4` like 'water resistant self stick notes' OR `manufacturer_name` like 'water resistant self stick notes' OR `color` like 'water resistant self stick notes') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>water>waters)+(>resistant>resistants)+(>self>selves)+(>stick>sticks)+(>notes>notes)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"water resistant self stick notes"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%water resistant self stick notes%' OR `pinfo`.`sku` like '%waterresistantselfsticknotes%' OR (FIND_IN_SET('water resistant self stick notes', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('water resistant self stick notes', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('water resistant self stick notes', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('water resistant self stick notes', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('water resistant self stick notes', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'water resistant self stick notes' ELSE `pinfo`.`desc_title` like 'water resistant self stick notes' END))) 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 '%water resistant self stick notes' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('water +resistant +self +stick +notes' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+water +resistant +self +stick +notes' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"water resistant self stick notes"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"water resistant self stick notes"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"water resistant self stick notes"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"water resistant self stick notes"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+water +resistant +self +stick +notes' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='notes',`category_4` ='notes') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'notes,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('notes', `pinfo`.`desc_title`)) DESC

We're sorry, there were no matches for "water resistant self stick notes" on our site.

Search Tips

Please try searching for different keywords that describe the item you're looking for.

  • Descriptive Keyword(s) - example: "Copy Paper Letter"
  • Product Name (full or partial) - example: "Boise Fireworx Copy Paper"
  • Stock Number (full or partial) - example: "UNV21200"
  • Manufacturer Name or Abbreviation - example: "HP"

Continue Shopping

  • Order by Item Number
  • Browse Our Products

Need Help? Contact us at 800-772-7375 or email Customer Service at [email protected].

Recently Viewed

 
 
 

© 2024-2025 Office 8, All Rights Reserved