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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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 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` WHERE (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>lorell>lorells)' IN BOOLEAN MODE) OR (`category_name` LIKE 'lorell') OR (`pinfo`.`manufacturer_prefix` LIKE '%lorell%' OR `pinfo`.`manufacturer_name` LIKE '%lorell%' OR `pinfo`.`sku` LIKE '%lorell%' OR `pinfo`.`desc_long` LIKE '%lorell%' OR `pinfo`.`desc_title` LIKE '%lorell%' OR `pinfo`.`keywords` LIKE '%lorell%') ) 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_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 MATCH(`desc_short`) AGAINST ('lorell' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+lorell' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"lorell"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"lorell"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"lorell"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"lorell"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+lorell' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='lorell',`category_4` ='lorell') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'lorell,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('lorell', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Lorell

Refine Search

  GO
Category

Furniture Collection(509)

Chairs & Seating(479)

Tables & Desks(294)

Armoires & Cabinets(239)

Furniture Accessories(104)

Racks & Organizers(96)

Erase Boards/Films(71)

Mats(46)

Lighting Fixtures(42)

Notice & Bulletin Boards(42)

Chairs & Seating Accessories(39)

Stands & Equipment Cabinets(36)

Sign & Name Plates(32)

Carts & Trolleys(30)

Frames(23)

Panel Systems(21)

Pads & Protectors(18)

Lockers & Safes(15)

Clocks(15)

Holders(14)

Hooks & Hangers(12)

Mounting Kits(11)

Fans(11)

Indoor/Outdoor Heaters(9)

Ergonomic Supports(8)

Pins & Clamps(7)

Business Card Files(6)

Wastebaskets & Trash Cans(6)

Desk Pads(6)

Sofas(5)

Shipping & Storage Boxes/Tanks(5)

Power Strips(5)

Wheels/Casters(5)

Keyboard Trays/Drawers(5)

Board Magnets(5)

Sound & Gaming Chairs(5)

Board Erasers & Correctors(5)

Refrigerators & Freezers(4)

Cushions & Pillows(4)

Carrying Cases(3)

Pens/Markers/Highlighters(3)

Furniture Covers & Sheets(3)

Cable Management(2)

Surveillance/Network Cameras(2)

Power/Data Outlets(2)

Surge Suppressors/Protectors(2)

Stools & Ladders(2)

Miscellaneous Kits(2)

Mirrors(2)

Ice Makers(1)

Contemporary - Laminate(1)

Magazine Files(1)

Workstations/Computer Desks(1)

File Frames & Rails(1)

Magnetic Boards(1)

Doorstops(1)

Rulers & Tape Measures(1)

Calendars & Planners(1)

Microwave Ovens(1)

Video Surveillance Systems(1)

Humidifiers/Dehumidifiers & Vaporizers(1)

Air Filters(1)

Air Purifiers(1)

Exercise Bikes(1)

Brand

Lorell(2327)

Color

Black(522)

Clear(85)

White(61)

Silver(51)

Gray(45)

Putty(44)

Mahogany(37)

Light Gray(36)

Charcoal(31)

Chrome(22)

Cherry(21)

Blue(20)

Walnut(20)

Brown(17)

Metallic Silver(15)

Green(14)

Beige(12)

Navy(11)

Platinum(9)

Tan(8)

Pepper(8)

Stratus(7)

Medium Tone(7)

Espresso(7)

Periwinkle Blue(7)

Malted(7)

Real Red(7)

Apple Green(7)

Ocean(7)

Buff(7)

Cloud(7)

Red(6)

Transparent(5)

Chrome - Handle(5)

Aluminum(5)

Satin Nickel - Pull(4)

Satin(4)

Oxblood(4)

Laminate(4)

Charcoal Gray(4)

Green Edge(3)

Chambray(3)

Roulette(3)

Natural(3)

Silver Mist(2)

Latte Laminate(2)

Burgundy(2)

Platinum Gray(2)

Graphite(2)

Dark Blue(2)

Orange(2)

Rosewood(2)

White Shade(2)

Clear Frame(2)

Aqua(2)

Assorted(2)

Gold(2)

Yellow(2)

Black - Top(2)

Black Hanger(2)

Matte(2)

Smoke(2)

Champagne Gold(2)

Hook(1)

Ivory(1)

Weathered Charcoal(1)

Gray/White(1)

Frosted(1)

Stainless Steel(1)

Light Blue(1)

Taupe(1)

Stone(1)

Dark Gray(1)

Midnight Blue(1)

Saddle(1)

Charcoal Black(1)

Chinchilla(1)

Heat Wave(1)

Sand(1)

Cafe(1)

Black Mahogany(1)

Black Cherry(1)

Citronella(1)

Teak(1)

Lime(1)

Blueberry(1)

Size

3" Length(1)

2" Length(1)

Large (L)(1)

Recycled

No(1313)

Yes(450)

Price Range

$0-$499.99(2008)

$500-$999.99(282)

$1000-$1499.99(24)

$1500-$1999.99(2)

$4000-$4499.99(1)

$5000-$5499.99(1)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CleanAir Granite Office

© 2020-2021 Granite Office, LLC, All Rights Reserved