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

Executive/High Back Chairs(134)

Reception, Side & Guest Chairs(132)

Task Chairs(101)

Contemporary - Metal(78)

Meeting & Conference Room Tables(77)

Metal Lateral Files(65)

Metal Vertical Files(64)

Contemporary - Veneer(62)

Training Room Tables(57)

Folding/Stacking Chairs & Carts(55)

Management/Mid-Back Chairs(54)

Utility & Breakroom Tables(48)

Dry-Erase Boards(46)

Adjustable Worksurfaces(39)

Panels/Partitions(39)

Mobile Pedestals(39)

Lamps(39)

Stools & Drafting Chairs(36)

Storage Cabinets(36)

Legs(25)

Carpet Chair Mats(24)

Laminate Tops(21)

Folding Tables(21)

Wire Shelving(20)

Wall Clocks(19)

Hard Floor Chair Mats(19)

Mobile File Carts & Cabinets(17)

Educational Seating(15)

Metal Bookcases(15)

Desktop Risers(15)

Book Racks(15)

Desktop Organizers(15)

Utility/Service Carts(14)

Protectors(14)

Cork/Fabric Bulletin Boards(13)

Workstations/Computer Desks(13)

Shelf(12)

Wood Veneer Bookcases(12)

Casters(11)

Bulletin Boards(11)

Ottomans(10)

Work Surfaces(10)

Heaters(10)

Fans(10)

Desk Pads(9)

Easel Boards(9)

Backrests & Seat Cushions(9)

Bulletin Bars(8)

Panel System Hardware(8)

TV/VCR Stands & Mounts(8)

Laminate Bookcases(8)

Big & Tall Chairs(7)

Letter Trays(7)

Industrial & Commercial Shelving(7)

Traditional - Laminate(6)

Headrest(6)

Monitor Arms(6)

Wood Lateral Files(6)

Pencil Holders(6)

Foot Rests(6)

Monitor Stands/Risers(6)

Desktop File Sorters(5)

Business Card Holders(5)

Wall Racks(5)

Portable Storage Files & Bins(5)

Lecterns(5)

Card Files & Holders(5)

Board Erasers(5)

Power Strips(5)

Magnets(5)

Arm Sets(4)

Reception Area & Accent Tables(4)

Hooks & Hangers(4)

Keyboard/Mouse Platforms & Trays(4)

Laptop Cases & Bags(4)

Hand Trucks & Dollies(4)

Wall Files, Pockets & Accessories(4)

Refrigerators(4)

Base(4)

Anti-Static Chair Mats(4)

Coat/Garment Hooks(3)

Frames(3)

Desk Center Drawers(3)

Compact & Student Desks(3)

Printer/Fax Stands(3)

Open Shelf Files(3)

Exam Tables(3)

Storage Drawers & Accessories(3)

Dry Erase Markers(3)

Phone Stands(2)

Notes Holders / Dispensers(2)

Magazine Files(2)

Projector Mounts(2)

Signs & Sign Holders(2)

Light Bulbs & Tubes(2)

Paper Clip Holders(2)

Active Seating(2)

Wall Planners & Organizers(2)

Combination Bulletin/Dry-Erase Boards(2)

Waste Containers & Accessories(2)

Push Pins(2)

Loveseat Sofa(2)

Coat/Garment Hangers(2)

Multimedia Carts(2)

Storage Boxes & Containers(2)

Reception Sofa(2)

Desktop Shelves(1)

Surge Protectors(1)

Nameplates(1)

Mail Carts(1)

Anti-Fatigue Mats(1)

Bulletin/Map Rails(1)

Paper Clips(1)

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

Pads/Sliders(1)

Sliders(1)

File Divider Kit(1)

Scratch Pads(1)

Ice Buckets(1)

Laptop Stands & Pads(1)

Board Cleaners & Wipes(1)

Briefcases(1)

File Rails/Frames(1)

Desk Clocks(1)

Telephone Stands & Holders(1)

 
Brand

Lorell(2286)

 
Color

Black(469)

Clear(84)

Mahogany(61)

Putty(53)

Silver(48)

White(47)

Light Gray(43)

Cherry(39)

Charcoal(31)

Gray(28)

Chrome(23)

Walnut(22)

Brown(19)

Green(17)

Blue(16)

Beige(13)

Espresso(10)

Medium Tone(9)

Charcoal Gray(8)

Apple Green(7)

Stratus(7)

Ocean(7)

Navy(7)

Buff(7)

Cloud(7)

Red(6)

Satin(5)

Pepper(5)

Aluminum(5)

Latte(5)

Bronze(5)

Chrome - Handle(5)

Natural(4)

Tan(4)

Malted(4)

Real Red(4)

Periwinkle Blue(4)

Oxblood(4)

Green Edge(3)

Latte Laminate(3)

Transparent(3)

Laminate(3)

Matte(3)

Black Hanger(2)

Slate(2)

Platinum(2)

Espresso Laminate(2)

Wine(2)

Assorted(2)

Silver Mist(2)

- Frame(2)

Dark Blue(2)

Ash(2)

White Shade(2)

Orange(2)

Saddle(2)

Clear Frame(2)

Frosted(2)

Brick Beige(1)

Silver Metal(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)

Cherry - Frame(1)

Multi(1)

Light Blue(1)

Mahogany - Frame(1)

Taupe(1)

Gray Black(1)

Midnight Blue(1)

Stainless Steel(1)

 
Size

8.50" Width x 11" Length(2)

Large (L)(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(1232)

Yes(465)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved