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_1` 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(416)

Executive/High Back Chairs(136)

Reception, Side & Guest Chairs(132)

Task Chairs(102)

Contemporary - Metal(93)

Contemporary - Veneer(89)

Meeting & Conference Room Tables(78)

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

Panels/Partitions(39)

Adjustable Worksurfaces(39)

Mobile Pedestals(39)

Lamps(39)

Storage Cabinets(36)

Stools & Drafting Chairs(36)

Legs(25)

Carpet Chair Mats(24)

Laminate Tops(22)

Folding Tables(21)

Wire Shelving(20)

Wall Clocks(19)

Hard Floor Chair Mats(19)

Desktop Organizers(18)

Mobile File Carts & Cabinets(17)

Book Racks(15)

Desktop Risers(15)

Metal Bookcases(15)

Educational Seating(15)

Wood Veneer Bookcases(15)

Utility/Service Carts(14)

Protectors(14)

Workstations/Computer Desks(14)

Cork/Fabric Bulletin Boards(13)

Shelf(12)

Bulletin Boards(11)

Heaters(11)

Ottomans(11)

Casters(11)

Work Surfaces(10)

Easel Boards(9)

Fans(9)

Desk Pads(9)

Backrests & Seat Cushions(9)

Panel System Hardware(8)

Monitor Arms(8)

TV/VCR Stands & Mounts(8)

Letter Trays(7)

Industrial & Commercial Shelving(7)

Big & Tall Chairs(7)

Laminate Bookcases(6)

Foot Rests(6)

Desktop File Sorters(6)

Monitor Stands/Risers(6)

Business Card Holders(6)

Traditional - Laminate(6)

Headrest(6)

Wood Lateral Files(6)

Wall Racks(5)

Magnets(5)

Lecterns(5)

Card Files & Holders(5)

Power Strips(5)

Pencil Holders(5)

Board Erasers(5)

Frames(5)

Portable Storage Files & Bins(5)

Keyboard/Mouse Platforms & Trays(4)

Refrigerators(4)

Base(4)

Hand Trucks & Dollies(4)

Arm Sets(4)

Reception Area & Accent Tables(4)

Laptop Cases & Bags(4)

Hooks & Hangers(4)

Bulletin Bars(4)

Anti-Static Chair Mats(4)

Wall Files, Pockets & Accessories(3)

Desk Center Drawers(3)

Coat/Garment Hooks(3)

Open Shelf Files(3)

Compact & Student Desks(3)

Printer/Fax Stands(3)

Storage Drawers & Accessories(3)

Exam Tables(3)

Dry Erase Markers(3)

Loveseat Sofa(2)

Reception Sofa(2)

Multimedia Carts(2)

Phone Stands(2)

Projector Mounts(2)

Light Bulbs & Tubes(2)

Paper Clip Holders(2)

Wall Planners & Organizers(2)

Combination Bulletin/Dry-Erase Boards(2)

Notes Holders / Dispensers(2)

Coat/Garment Hangers(2)

Signs & Sign Holders(2)

Waste Containers & Accessories(2)

Active Seating(2)

Bulletin/Map Rails(1)

Nameplates(1)

Mail Carts(1)

Bookends(1)

Anti-Fatigue Mats(1)

Magazine Files(1)

Paper Clips(1)

Surge Protectors(1)

Desktop Shelves(1)

Mirrors(1)

Doorstops(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

Pad Retainers(1)

Mounting Putty(1)

Business Card Refills(1)

Push Pins(1)

Pads/Sliders(1)

Sliders(1)

File Divider Kit(1)

Ice Buckets(1)

Traditional - Veneer(1)

Laptop Stands & Pads(1)

Board Cleaners & Wipes(1)

Briefcases(1)

File Rails/Frames(1)

Desk Clocks(1)

Telephone Stands & Holders(1)

 
Brand

Lorell(2349)

 
Color

Black(476)

Clear(82)

Mahogany(61)

Putty(53)

Silver(49)

White(46)

Light Gray(43)

Cherry(40)

Charcoal(31)

Gray(28)

Chrome(23)

Walnut(23)

Brown(19)

Green(17)

Blue(16)

Beige(13)

Espresso(10)

Medium Tone(9)

Charcoal Gray(8)

Apple Green(7)

Navy(7)

Stratus(7)

Ocean(7)

Buff(7)

Cloud(7)

Red(6)

Latte(5)

Satin(5)

Bronze(5)

Pepper(5)

Chrome - Handle(5)

Aluminum(5)

Tan(4)

Oxblood(4)

Natural(4)

Periwinkle Blue(4)

Real Red(4)

Malted(4)

Latte Laminate(3)

Green Edge(3)

Laminate(3)

Matte(3)

Transparent(3)

Silver Mist(2)

- Frame(2)

White Shade(2)

Platinum(2)

Espresso Laminate(2)

Black Hanger(2)

Frosted(2)

Assorted(2)

Slate(2)

Clear Frame(2)

Saddle(2)

Wine(2)

Ash(2)

Orange(2)

Dark Blue(2)

Brick Beige(1)

Silver Metal(1)

Stainless Steel(1)

Lime(1)

Black Cherry(1)

Black Mahogany(1)

Heat Wave(1)

Champagne(1)

Dark Gray(1)

Black Base(1)

Hook(1)

Stone(1)

Chinchilla(1)

Charcoal Black(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Multi(1)

Taupe(1)

Midnight Blue(1)

Burgundy(1)

Gray Black(1)

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

Yes(519)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved