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_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(103)

Ink Cartridges & Printheads(85)

Laser Toner Cartridges(82)

Multifunction/All-in-One Machines(32)

Label Printer Labels(31)

Laser Printer Drums(18)

Laser Printers(9)

Sheetfed Scanners(9)

Label Printers(8)

Electronic Label Makers(6)

Color Laser Printers(5)

Thermal Transfer Films & Refills(5)

Electronic Label Maker Tapes(3)

Typewriter Ribbons(3)

Printer Ribbons(2)

Extended Warranties(2)

Fax Machines(2)

Mailing & Address Labels(2)

Specialty Batteries(2)

Laser Printer Transfer Kits(2)

Typewriter Correction Ribbons(2)

Inkjet Printers(1)

Waste Toner Bottles(1)

Multipurpose Labels(1)

Thermal Fax Paper(1)

Laser Printer Developer Units(1)

Power Adapters(1)

Label Printer Accessories(1)

Typewriter Printwheels(1)

Filing Labels & Systems(1)

Imaging Units(1)

Media Labels(1)

ID & Specialty Labels(1)

Correction Tapes(1)

 
Brand

Brother(428)

 
Color

White(83)

Black(45)

Clear(23)

Yellow(15)

Blue(8)

Red(5)

Gold(4)

Silver(3)

Navy Blue(2)

Fluorescent Orange(2)

Dark Gray(2)

Gray(2)

Green(2)

Pastel Purple(1)

Lime Green(1)

Matte Silver(1)

Pastel Pink(1)

Berry Pink(1)

Satin Gold(1)

Golden(1)

Blue Gray(1)

Pastel Blue(1)

Light Gray(1)

Satin Silver(1)

 
Recycled

No(164)

 
Sheet Size

8 1/2" x 98 ft(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved