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 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 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 (`manufacturer_id` = "1700356") 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 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

Manufacturer

Currently Filtered by

Manufacturer

Lorell

Refine Search

  GO
Category

Contemporary - Laminate(391)

Executive/High Back Chairs(118)

Reception, Side & Guest Chairs(114)

Task Chairs(78)

Meeting & Conference Room Tables(75)

Metal Lateral Files(65)

Training Room Tables(55)

Metal Vertical Files(54)

Management/Mid-Back Chairs(46)

Utility & Breakroom Tables(46)

Dry-Erase Boards(40)

Adjustable Worksurfaces(39)

Lamps(39)

Folding/Stacking Chairs & Carts(39)

Contemporary - Metal(38)

Contemporary - Veneer(36)

Storage Cabinets(34)

Mobile Pedestals(34)

Stools & Drafting Chairs(30)

Panels/Partitions(25)

Carpet Chair Mats(24)

Legs(21)

Wire Shelving(20)

Wall Clocks(19)

Laminate Tops(17)

Book Racks(15)

Educational Seating(15)

Metal Bookcases(15)

Mobile File Carts & Cabinets(15)

Folding Tables(15)

Protectors(14)

Cork/Fabric Bulletin Boards(13)

Desktop Organizers(13)

Utility/Service Carts(13)

Desktop Risers(13)

Shelf(12)

Wood Veneer Bookcases(12)

Casters(11)

Bulletin Boards(11)

Hard Floor Chair Mats(11)

Heaters(10)

Work Surfaces(10)

Fans(10)

Ottomans(10)

Backrests & Seat Cushions(9)

Easel Boards(9)

Workstations/Computer Desks(8)

Panel System Hardware(8)

Bulletin Bars(8)

Letter Trays(7)

Industrial & Commercial Shelving(7)

Big & Tall Chairs(7)

Laminate Bookcases(7)

Monitor Stands/Risers(6)

Foot Rests(6)

Desk Pads(6)

Wood Lateral Files(6)

Pencil Holders(6)

Portable Storage Files & Bins(5)

Card Files & Holders(5)

Board Erasers(5)

Business Card Holders(5)

Monitor Arms(5)

Headrest(5)

Power Strips(5)

Magnets(5)

Desktop File Sorters(5)

Keyboard/Mouse Platforms & Trays(4)

Wall Files, Pockets & Accessories(4)

Refrigerators(4)

Base(4)

Wall Racks(4)

Arm Sets(4)

Reception Area & Accent Tables(4)

Laptop Cases & Bags(4)

Anti-Static Chair Mats(4)

Hand Trucks & Dollies(4)

Hooks & Hangers(4)

Traditional - Laminate(3)

TV/VCR Stands & Mounts(3)

Storage Drawers & Accessories(3)

Dry Erase Markers(3)

Printer/Fax Stands(3)

Compact & Student Desks(3)

Coat/Garment Hooks(3)

Lecterns(3)

Exam Tables(3)

Desk Center Drawers(3)

Paper Clip Holders(2)

Coat/Garment Hangers(2)

Phone Stands(2)

Waste Containers & Accessories(2)

Push Pins(2)

Magazine Files(2)

Notes Holders / Dispensers(2)

Multimedia Carts(2)

Loveseat Sofa(2)

Reception Sofa(2)

Open Shelf Files(2)

Projector Mounts(2)

Light Bulbs & Tubes(2)

Combination Bulletin/Dry-Erase Boards(2)

Active Seating(2)

Signs & Sign Holders(2)

Storage Boxes & Containers(2)

Surge Protectors(1)

Anti-Fatigue Mats(1)

Wall Planners & Organizers(1)

Business Card Refills(1)

Frames(1)

Desktop Shelves(1)

Mail Carts(1)

Sliders(1)

Bookends(1)

Paper Clips(1)

Ice Buckets(1)

Board Cleaners & Wipes(1)

Pads/Sliders(1)

Briefcases(1)

File Rails/Frames(1)

Doorstops(1)

File Divider Kit(1)

Scratch Pads(1)

Rulers & Yardsticks(1)

Telephone Stands & Holders(1)

Mounting Putty(1)

Pad Retainers(1)

Laptop Stands & Pads(1)

Bulletin Board Sets(1)

Literature Organizers/Sorters(1)

Nameplates(1)

Brand

Lorell(2014)

Color

Black(418)

Clear(73)

Mahogany(53)

Putty(50)

Silver(45)

White(42)

Light Gray(41)

Cherry(35)

Charcoal(28)

Gray(25)

Chrome(23)

Walnut(22)

Brown(18)

Blue(15)

Green(15)

Beige(12)

Espresso(9)

Medium Tone(9)

Charcoal Gray(8)

Cloud(7)

Navy(7)

Ocean(7)

Buff(7)

Stratus(7)

Apple Green(7)

Bronze(5)

Aluminum(5)

Latte(5)

Pepper(5)

Red(5)

Tan(4)

Oxblood(4)

Natural(4)

Real Red(4)

Satin(4)

Periwinkle Blue(4)

Malted(4)

Laminate(3)

Green Edge(3)

Transparent(3)

Orange(2)

Espresso Laminate(2)

- Frame(2)

Frosted(2)

Dark Blue(2)

Slate(2)

Assorted(2)

Silver Mist(2)

Black Hanger(2)

White Shade(2)

Platinum(2)

Matte(2)

Burgundy(2)

Saddle(2)

Clear Frame(2)

Champagne Gold(2)

Brick Beige(1)

Lime(1)

Heat Wave(1)

Chinchilla(1)

Black Mahogany(1)

Black Cherry(1)

Black Base(1)

Hook(1)

Charcoal Black(1)

Gray Black(1)

Multi(1)

Light Blue(1)

Cherry - Frame(1)

Mahogany - Frame(1)

Midnight Blue(1)

Taupe(1)

Stainless Steel(1)

Size

Large (L)(1)

Size Supported

Lateral File(1)

Recycled

No(1097)

Yes(382)

Price Range

$0-$499.99(1876)

$500-$999.99(152)

$1000-$1499.99(3)

To  GO

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

© 2018-2019 Granite Office, LLC, All Rights Reserved