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(72)

Mats(47)

Notice & Bulletin Boards(42)

Lighting Fixtures(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)

Fans(11)

Mounting Kits(11)

Indoor/Outdoor Heaters(9)

Ergonomic Supports(8)

Pins & Clamps(7)

Desk Pads(6)

Business Card Files(6)

Wastebaskets & Trash Cans(6)

Power Strips(5)

Keyboard Trays/Drawers(5)

Sofas(5)

Wheels/Casters(5)

Shipping & Storage Boxes/Tanks(5)

Board Magnets(5)

Sound & Gaming Chairs(5)

Board Erasers & Correctors(5)

Cushions & Pillows(4)

Refrigerators & Freezers(4)

Furniture Covers & Sheets(3)

Carrying Cases(3)

Pens/Markers/Highlighters(3)

Surveillance/Network Cameras(2)

Stools & Ladders(2)

Cable Management(2)

Power/Data Outlets(2)

Miscellaneous Kits(2)

Mirrors(2)

Surge Suppressors/Protectors(2)

Exercise Bikes(1)

Magazine Files(1)

Ice Makers(1)

Contemporary - Laminate(1)

Rulers & Tape Measures(1)

Humidifiers/Dehumidifiers & Vaporizers(1)

Video Surveillance Systems(1)

Microwave Ovens(1)

Air Filters(1)

Air Purifiers(1)

Doorstops(1)

Calendars & Planners(1)

File Frames & Rails(1)

Brand

Lorell(2327)

Color

Black(522)

Clear(86)

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)

Buff(7)

Apple Green(7)

Stratus(7)

Medium Tone(7)

Espresso(7)

Real Red(7)

Ocean(7)

Periwinkle Blue(7)

Malted(7)

Cloud(7)

Red(6)

Aluminum(5)

Transparent(5)

Chrome - Handle(5)

Satin Nickel - Pull(4)

Charcoal Gray(4)

Oxblood(4)

Satin(4)

Laminate(4)

Green Edge(3)

Natural(3)

Chambray(3)

Roulette(3)

Gold(2)

Smoke(2)

Aqua(2)

Latte Laminate(2)

Platinum Gray(2)

Assorted(2)

Graphite(2)

Burgundy(2)

Silver Mist(2)

Rosewood(2)

Orange(2)

Clear Frame(2)

Matte(2)

Black - Top(2)

Yellow(2)

Dark Blue(2)

Black Hanger(2)

Champagne Gold(2)

White Shade(2)

Ivory(1)

Weathered Charcoal(1)

Stainless Steel(1)

Gray/White(1)

Frosted(1)

Light Blue(1)

Citronella(1)

Cafe(1)

Blueberry(1)

Teak(1)

Sand(1)

Dark Gray(1)

Hook(1)

Stone(1)

Lime(1)

Black Cherry(1)

Saddle(1)

Midnight Blue(1)

Charcoal Black(1)

Chinchilla(1)

Black Mahogany(1)

Heat Wave(1)

Taupe(1)

Size

Large (L)(1)

2" Length(1)

3" Length(1)

Recycled

No(1314)

Yes(450)

Price Range

$0-$499.99(2006)

$500-$999.99(279)

$1000-$1499.99(26)

$1500-$1999.99(4)

$3000-$3499.99(1)

$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