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

Currently Filtered by

Category

Sentence Strips

Refine Search

  GO
Brand

HYGLOSS PRODUCTS,INC.(11)

RITECO INC.(5)

Creativity Street(2)

Color

Assorted|FFFFFF(3)

Assorted(2)

Manila|F1D592(1)

White|FFFFFF(1)

Recycled

No(2)

Height

3"(5)

Color(s)

Assorted|FFFFFF(3)

White|FFFFFF(1)

Manila|F1D592(1)

Width

24"(10)

Country of Origin

US(5)

China(2)

Material

Wood(1)

Plastic(1)

Material(s)

Tagboard(4)

Rainbow Kraft Paper(1)

Length

7"(1)

Ferrule

Aluminum(1)

Product Type

Paint Brush(2)

Packaged Quantity

30 / Set(1)

1 Set(1)

Assembly Required

No(2)

Handle Material

Wood(1)

Plastic(1)

Handle Color

Assorted(1)

Handle Length

6"(1)

Application/Usage

All Purpose(1)

Art Project(1)

Bristle

Natural(1)

Environmentally Friendly

Yes(1)

Features

Washable(2)

Product Name

Wood Colossal Brushes(1)

Flat Colossal Brushes(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved