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

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)

Folding/Stacking Chairs & Carts(39)

Lamps(39)

Adjustable Worksurfaces(39)

Contemporary - Metal(38)

Contemporary - Veneer(37)

Mobile Pedestals(34)

Storage Cabinets(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)

Metal Bookcases(15)

Desktop Organizers(15)

Mobile File Carts & Cabinets(15)

Folding Tables(15)

Protectors(14)

Cork/Fabric Bulletin Boards(13)

Utility/Service Carts(13)

Educational Seating(13)

Desktop Risers(13)

Wood Veneer Bookcases(12)

Shelf(12)

Bulletin Boards(11)

Casters(11)

Hard Floor Chair Mats(11)

Fans(10)

Heaters(10)

Work Surfaces(10)

Ottomans(10)

Easel Boards(9)

Backrests & Seat Cushions(9)

Laminate Bookcases(8)

Workstations/Computer Desks(8)

Panel System Hardware(8)

Bulletin Bars(8)

Letter Trays(7)

Industrial & Commercial Shelving(7)

Big & Tall Chairs(7)

Desk Pads(6)

Monitor Stands/Risers(6)

Wood Lateral Files(6)

Pencil Holders(6)

Foot Rests(6)

Card Files & Holders(5)

Magnets(5)

Business Card Holders(5)

Monitor Arms(5)

Board Erasers(5)

Desktop File Sorters(5)

Portable Storage Files & Bins(5)

Power Strips(5)

Headrest(5)

Keyboard/Mouse Platforms & Trays(4)

Wall Racks(4)

Arm Sets(4)

Wall Files, Pockets & Accessories(4)

Traditional - Laminate(4)

Refrigerators(4)

Base(4)

Reception Area & Accent Tables(4)

Hand Trucks & Dollies(4)

Hooks & Hangers(4)

Laptop Cases & Bags(4)

Anti-Static Chair Mats(4)

TV/VCR Stands & Mounts(3)

Compact & Student Desks(3)

Printer/Fax Stands(3)

Desk Center Drawers(3)

Storage Drawers & Accessories(3)

Exam Tables(3)

Dry Erase Markers(3)

Lecterns(3)

Coat/Garment Hooks(3)

Waste Containers & Accessories(2)

Phone Stands(2)

Magazine Files(2)

Push Pins(2)

Paper Clip Holders(2)

Multimedia Carts(2)

Loveseat Sofa(2)

Notes Holders / Dispensers(2)

Coat/Garment Hangers(2)

Reception Sofa(2)

Open Shelf Files(2)

Projector Mounts(2)

Active Seating(2)

Combination Bulletin/Dry-Erase Boards(2)

Light Bulbs & Tubes(2)

Signs & Sign Holders(2)

Storage Boxes & Containers(2)

Paper Clips(1)

Mounting Putty(1)

Anti-Fatigue Mats(1)

Surge Protectors(1)

Frames(1)

Wall Planners & Organizers(1)

Desktop Shelves(1)

Mail Carts(1)

Bookends(1)

Bulletin Board Sets(1)

Business Card Refills(1)

Pads/Sliders(1)

Scratch Pads(1)

Board Cleaners & Wipes(1)

Briefcases(1)

File Divider Kit(1)

File Rails/Frames(1)

Ice Buckets(1)

Sliders(1)

Telephone Stands & Holders(1)

Pad Retainers(1)

Literature Organizers/Sorters(1)

Laptop Stands & Pads(1)

Rulers & Yardsticks(1)

Doorstops(1)

Nameplates(1)

Brand

Lorell(2015)

Color

Black(419)

Clear(73)

Mahogany(53)

Putty(50)

Silver(46)

White(42)

Light Gray(41)

Cherry(35)

Charcoal(28)

Gray(24)

Chrome(23)

Walnut(22)

Brown(18)

Green(15)

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

Natural(4)

Oxblood(4)

Real Red(4)

Satin(4)

Malted(4)

Periwinkle Blue(4)

Laminate(3)

Transparent(3)

Green Edge(3)

Frosted(2)

Platinum(2)

- Frame(2)

Espresso Laminate(2)

Saddle(2)

Matte(2)

Silver Mist(2)

Slate(2)

Wine(2)

Clear Frame(2)

White Shade(2)

Black Hanger(2)

Assorted(2)

Stainless Steel(1)

Dark Blue(1)

Brick Beige(1)

Orange(1)

Lime(1)

Black Mahogany(1)

Heat Wave(1)

Black Cherry(1)

Champagne(1)

Black Base(1)

Hook(1)

Chinchilla(1)

Charcoal Black(1)

Cherry - Frame(1)

Multi(1)

Mahogany - Frame(1)

Taupe(1)

Gray Black(1)

Midnight Blue(1)

Light Blue(1)

Size

Large (L)(1)

Size Supported

Lateral File(1)

Recycled

No(1101)

Yes(379)

Price Range

$0-$499.99(1854)

$500-$999.99(150)

$1000-$1499.99(2)

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