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 (`brand_id` = "11410") AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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


Lorell

Refine Search

  GO
 
Category

Contemporary - Laminate(406)

Executive/High Back Chairs(139)

Reception, Side & Guest Chairs(136)

Task Chairs(130)

Meeting & Conference Room Tables(101)

Metal Vertical Files(76)

Contemporary - Metal(73)

Folding/Stacking Chairs & Carts(73)

Metal Lateral Files(65)

Training Room Tables(63)

Utility & Breakroom Tables(56)

Dry-Erase Boards(56)

Management/Mid-Back Chairs(46)

Lamps(41)

Adjustable Worksurfaces(41)

Storage Cabinets(40)

Stools & Drafting Chairs(37)

Mobile Pedestals(37)

Workstations/Computer Desks(35)

Contemporary - Veneer(35)

Panels/Partitions(33)

Carpet Chair Mats(24)

Book Racks(24)

Legs(24)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Laminate Tops(21)

Wall Clocks(20)

Wire Shelving(20)

Desktop Risers(18)

Wood Veneer Bookcases(17)

Backrests & Seat Cushions(16)

Mobile File Carts & Cabinets(16)

Educational Seating(15)

Metal Bookcases(15)

Utility/Service Carts(15)

Folding Tables(15)

Protectors(14)

Hard Floor Chair Mats(14)

Desktop Organizers(13)

Shelf(12)

Easel Boards(12)

Certificate Frames & Holders(11)

Ottomans(11)

Fans(11)

Bulletin Boards(11)

Work Surfaces(10)

Casters(9)

Monitor Stands/Risers(9)

Heaters(9)

Reception Area & Accent Tables(9)

Panel System Hardware(8)

Bulletin Bars(8)

Big & Tall Chairs(7)

Wall Files, Pockets & Accessories(7)

Monitor Arms(7)

Desk Pads(6)

Hand Trucks & Dollies(6)

Pencil Holders(6)

Power Strips(6)

Wood Lateral Files(6)

Letter Trays(6)

Headrest(6)

Keyboard/Mouse Platforms & Trays(6)

Board Erasers(5)

Portable Storage Files & Bins(5)

Wall Racks(5)

Desktop File Sorters(5)

Business Card Holders(5)

Magnets(5)

Foot Rests(5)

Laminate Bookcases(5)

Card Files & Holders(5)

Reception Sofa(4)

Anti-Static Chair Mats(4)

Arm Sets(4)

Refrigerators(4)

Base(4)

Loveseat Sofa(4)

Hooks & Hangers(4)

Exam Tables(3)

Coat/Garment Hooks(3)

Printer/Fax Stands(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

Lecterns(3)

Dry Erase Markers(3)

TV/VCR Stands & Mounts(3)

Light Bulbs & Tubes(2)

Coat/Garment Hangers(2)

Combination Bulletin/Dry-Erase Boards(2)

Paper Clip Holders(2)

Phone Stands(2)

Traditional - Laminate(2)

Multimedia Carts(2)

Storage Boxes & Containers(2)

Magazine Files(2)

Notes Holders / Dispensers(2)

Cable Management(2)

Racks & Organizers(2)

Anti-Fatigue Mats(2)

Active Seating(2)

Signs & Sign Holders(2)

Surge Protectors(2)

Laptop Cases & Bags(2)

Recycling Bins(2)

Push Pins(2)

Open Shelf Files(2)

Rulers & Yardsticks(1)

File Divider Kit(1)

Indoor Mats(1)

Sliders(1)

File Rails/Frames(1)

Bookends(1)

Pads/Sliders(1)

Drawer Organizers(1)

Mail Carts(1)

Desktop Shelves(1)

Desk Center Drawers(1)

Wall Planners & Organizers(1)

Business Card Refills(1)

Nameplates(1)

Paper Clips(1)

Desk Clocks(1)

Frames(1)

Telephone Stands & Holders(1)

Briefcases(1)

Laptop Stands & Pads(1)

Pad Retainers(1)

Board Cleaners & Wipes(1)

Dry-Erase Kits/Holders(1)

Ice Buckets(1)

Scratch Pads(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Waste Containers & Accessories(1)

Projector Mounts(1)

Doorstops(1)

 
Brand

Lorell(2429)

 
Color

Black(510)

Clear(80)

White(55)

Mahogany(55)

Putty(51)

Silver(44)

Light Gray(41)

Cherry(35)

Gray(32)

Charcoal(30)

Chrome(23)

Walnut(22)

Green(18)

Blue(17)

Brown(17)

Beige(13)

Navy(11)

Espresso(10)

Red(10)

Medium Tone(9)

Charcoal Gray(9)

Pepper(8)

Cloud(7)

Buff(7)

Stratus(7)

Apple Green(7)

Ocean(7)

Real Red(7)

Malted(7)

Periwinkle Blue(7)

Parchment(6)

Satin(5)

Aluminum(5)

Bronze(5)

Chrome - Handle(5)

Oxblood(4)

Tan(4)

Laminate(4)

Natural(4)

Platinum(4)

Roulette(3)

Transparent(3)

Green Edge(3)

Metallic Silver(3)

Latte(3)

Chambray(3)

Saddle(2)

Dark Blue(2)

Ash(2)

Espresso Laminate(2)

Burgundy(2)

Silver Mist(2)

White Shade(2)

- Frame(2)

Graphite(2)

Orange(2)

Rosewood(2)

Black Hanger(2)

Clear Frame(2)

Champagne Gold(2)

Smoke(2)

Matte(2)

Platinum Gray(2)

Slate(2)

Assorted(2)

Ivory(1)

Brick Beige(1)

Blueberry(1)

Dark Gray(1)

Citronella(1)

Cafe(1)

Stone(1)

Frosted(1)

Latte Laminate(1)

Charcoal Black(1)

Hook(1)

Chinchilla(1)

Stainless Steel(1)

Light Blue(1)

Lime(1)

Weathered Charcoal(1)

Black Cherry(1)

Black Mahogany(1)

Multi(1)

Cherry - Frame(1)

Mahogany - Frame(1)

Heat Wave(1)

Sand(1)

Midnight Blue(1)

Taupe(1)

 
Size

Large (L)(1)

 
Recycled

No(1294)

Yes(514)

 
 
 

© 2020-2021 LOP Office Supply, All Rights Reserved