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

Currently Filtered by

Manufacturer

Brother

Refine Search

  GO
 
Category

Label Tapes(125)

Laser Toner Cartridges(88)

Ink Cartridges & Printheads(88)

Multifunction/All-in-One Machines(29)

Laser Printer Drums(19)

Label Printer Labels(14)

Electronic Label Makers(13)

Label Maker Supplies(13)

Laser Printers(9)

Sheetfed Scanners(9)

Fax Toner Cartridges(5)

Label Printers(5)

Color Laser Printers(5)

Inks & Toners(4)

Inkjet Printers(4)

Thermal Transfer Cartridges/Films/Ribbons/Rolls(3)

Typewriter Ribbons(3)

Label Makers(3)

Copier/Fax/Multifunction Machines(3)

Extended Warranties(2)

Laser Printer Transfer Kits(2)

Correction Tapes(2)

Typewriter Correction Ribbons(2)

Specialty Batteries(2)

Fax Machines(2)

Mailing & Address Labels(2)

Typewriter Accessories(1)

Waste Toner Bottles(1)

ID & Specialty Labels(1)

Power Adapters(1)

Printer Ribbons(1)

Thermal Fax Paper(1)

Typewriter Printwheels(1)

Scanners(1)

Belts (Printer/Fax/Copier)(1)

Imaging Drums/Photoconductors(1)

Multipurpose Labels(1)

Media Labels(1)

Laser Printer Developer Units(1)

Fax Drums(1)

 
Brand

Brother(456)

Brother P-Touch(14)

 
Color

White(82)

Black(42)

Clear(22)

Yellow(11)

Blue(7)

Gold(4)

Red(4)

Navy Blue(2)

Fluorescent Orange(2)

Dark Gray(2)

Gray(2)

Silver(2)

Green(2)

Pastel Purple(1)

Lime Green(1)

Berry Pink(1)

Matte Silver(1)

Pastel Pink(1)

Pastel Blue(1)

Golden(1)

Blue Gray(1)

Light Gray(1)

Satin Gold(1)

Satin Silver(1)

 
Recycled

No(169)

 
Sheet Size

8 1/2" x 98 ft(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved