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` = "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 `pinfo`.`sku` LIKE '%Lorell' THEN 1 ELSE 0 END DESC, 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

Manufacturer

Lorell

Refine Search

  GO
 
Category

Contemporary - Laminate(415)

Executive/High Back Chairs(136)

Reception, Side & Guest Chairs(132)

Task Chairs(125)

Contemporary - Metal(93)

Contemporary - Veneer(89)

Meeting & Conference Room Tables(77)

Metal Lateral Files(65)

Metal Vertical Files(64)

Training Room Tables(57)

Folding/Stacking Chairs & Carts(56)

Management/Mid-Back Chairs(55)

Utility & Breakroom Tables(53)

Dry-Erase Boards(51)

Panels/Partitions(39)

Mobile Pedestals(39)

Lamps(39)

Adjustable Worksurfaces(39)

Stools & Drafting Chairs(36)

Storage Cabinets(36)

Legs(25)

Carpet Chair Mats(24)

Laminate Tops(21)

Folding Tables(20)

Wire Shelving(20)

Hard Floor Chair Mats(19)

Wall Clocks(19)

Mobile File Carts & Cabinets(17)

Desktop Organizers(16)

Metal Bookcases(15)

Desktop Risers(15)

Book Racks(15)

Educational Seating(15)

Utility/Service Carts(14)

Protectors(14)

Cork/Fabric Bulletin Boards(13)

Workstations/Computer Desks(13)

Wood Veneer Bookcases(13)

Shelf(12)

Casters(11)

Bulletin Boards(11)

Fans(10)

Ottomans(10)

Work Surfaces(10)

Heaters(10)

Easel Boards(9)

Backrests & Seat Cushions(9)

Desk Pads(9)

TV/VCR Stands & Mounts(8)

Bulletin Bars(8)

Laminate Bookcases(8)

Panel System Hardware(8)

Letter Trays(7)

Monitor Arms(7)

Big & Tall Chairs(7)

Industrial & Commercial Shelving(7)

Monitor Stands/Risers(6)

Foot Rests(6)

Headrest(6)

Pencil Holders(6)

Wood Lateral Files(6)

Power Strips(5)

Frames(5)

Board Erasers(5)

Desktop File Sorters(5)

Magnets(5)

Card Files & Holders(5)

Traditional - Laminate(5)

Portable Storage Files & Bins(5)

Wall Racks(5)

Lecterns(5)

Business Card Holders(5)

Keyboard/Mouse Platforms & Trays(4)

Hand Trucks & Dollies(4)

Reception Area & Accent Tables(4)

Refrigerators(4)

Wall Files, Pockets & Accessories(4)

Arm Sets(4)

Laptop Cases & Bags(4)

Base(4)

Anti-Static Chair Mats(4)

Hooks & Hangers(4)

Printer/Fax Stands(3)

Open Shelf Files(3)

Coat/Garment Hooks(3)

Dry Erase Markers(3)

Exam Tables(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

Desk Center Drawers(3)

Loveseat Sofa(2)

Reception Sofa(2)

Storage Boxes & Containers(2)

Notes Holders / Dispensers(2)

Coat/Garment Hangers(2)

Paper Clip Holders(2)

Magazine Files(2)

Phone Stands(2)

Push Pins(2)

Active Seating(2)

Multimedia Carts(2)

Waste Containers & Accessories(2)

Light Bulbs & Tubes(2)

Signs & Sign Holders(2)

Projector Mounts(2)

Combination Bulletin/Dry-Erase Boards(2)

Wall Planners & Organizers(2)

Surge Protectors(1)

Business Card Refills(1)

Paper Clips(1)

Doorstops(1)

Anti-Fatigue Mats(1)

Mounting Putty(1)

Mail Carts(1)

Mirrors(1)

Desktop Shelves(1)

Pads/Sliders(1)

Bookends(1)

Sliders(1)

File Rails/Frames(1)

File Divider Kit(1)

Ice Buckets(1)

Scratch Pads(1)

Desk Clocks(1)

Board Cleaners & Wipes(1)

Briefcases(1)

Traditional - Veneer(1)

Bulletin Board Sets(1)

Literature Organizers/Sorters(1)

Bulletin/Map Rails(1)

Telephone Stands & Holders(1)

Rulers & Yardsticks(1)

Pad Retainers(1)

Laptop Stands & Pads(1)

Nameplates(1)

 
Brand

Lorell(2376)

 
Color

Black(472)

Clear(84)

Mahogany(61)

Putty(53)

Silver(48)

White(47)

Light Gray(43)

Cherry(40)

Charcoal(31)

Gray(28)

Walnut(23)

Chrome(23)

Brown(19)

Green(17)

Blue(16)

Beige(13)

Espresso(10)

Medium Tone(9)

Pepper(8)

Charcoal Gray(8)

Real Red(7)

Navy(7)

Ocean(7)

Periwinkle Blue(7)

Malted(7)

Cloud(7)

Apple Green(7)

Buff(7)

Stratus(7)

Red(6)

Aluminum(5)

Bronze(5)

Latte(5)

Chrome - Handle(5)

Satin(5)

Oxblood(4)

Tan(4)

Natural(4)

Transparent(3)

Burgundy(3)

Green Edge(3)

Roulette(3)

Chambray(3)

Latte Laminate(3)

Laminate(3)

Matte(3)

Espresso Laminate(2)

Saddle(2)

- Frame(2)

Platinum(2)

Slate(2)

Black Hanger(2)

Silver Mist(2)

Assorted(2)

White Shade(2)

Frosted(2)

Champagne Gold(2)

Dark Blue(2)

Ash(2)

Orange(2)

Clear Frame(2)

Silver Metal(1)

Stainless Steel(1)

Brick Beige(1)

Light Blue(1)

Black Mahogany(1)

Stone(1)

Hook(1)

Black Base(1)

Blueberry(1)

Citronella(1)

Dark Gray(1)

Sand(1)

Cafe(1)

Lime(1)

Black Cherry(1)

Taupe(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Midnight Blue(1)

Gray Black(1)

Heat Wave(1)

Chinchilla(1)

Charcoal Black(1)

Multi(1)

 
Size

8.50" Width x 11" Length(2)

Large (L)(1)

8" Width x 10" Length(1)

11" Width x 8.50" Length(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(1278)

Yes(504)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved