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 (`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(134)

Task Chairs(129)

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)

Mobile Pedestals(38)

Stools & Drafting Chairs(37)

Workstations/Computer Desks(36)

Contemporary - Veneer(35)

Panels/Partitions(33)

Carpet Chair Mats(24)

Legs(24)

Book Racks(24)

Industrial & Commercial Shelving(22)

Laminate Tops(21)

Cork/Fabric Bulletin Boards(21)

Wall Clocks(20)

Wire Shelving(20)

Desktop Risers(18)

Wood Veneer Bookcases(17)

Mobile File Carts & Cabinets(16)

Backrests & Seat Cushions(16)

Metal Bookcases(15)

Folding Tables(15)

Educational Seating(15)

Utility/Service Carts(15)

Protectors(14)

Hard Floor Chair Mats(14)

Desktop Organizers(13)

Shelf(12)

Easel Boards(12)

Ottomans(11)

Certificate Frames & Holders(11)

Bulletin Boards(11)

Fans(11)

Work Surfaces(10)

Big & Tall Chairs(10)

Casters(9)

Monitor Stands/Risers(9)

Reception Area & Accent Tables(9)

Heaters(9)

Panel System Hardware(8)

Bulletin Bars(8)

Monitor Arms(7)

Wall Files, Pockets & Accessories(7)

Keyboard/Mouse Platforms & Trays(6)

Desk Pads(6)

Letter Trays(6)

Power Strips(6)

Hand Trucks & Dollies(6)

Pencil Holders(6)

Wood Lateral Files(6)

Headrest(6)

Business Card Holders(5)

Board Erasers(5)

Foot Rests(5)

Card Files & Holders(5)

Portable Storage Files & Bins(5)

Desktop File Sorters(5)

Laminate Bookcases(5)

Magnets(5)

Wall Racks(5)

Refrigerators(4)

Reception Sofa(4)

Loveseat Sofa(4)

Arm Sets(4)

Anti-Static Chair Mats(4)

Base(4)

Hooks & Hangers(4)

Printer/Fax Stands(3)

Coat/Garment Hooks(3)

Lecterns(3)

Exam Tables(3)

Compact & Student Desks(3)

Dry Erase Markers(3)

Storage Drawers & Accessories(3)

TV/VCR Stands & Mounts(3)

Light Bulbs & Tubes(2)

Push Pins(2)

Phone Stands(2)

Coat/Garment Hangers(2)

Traditional - Laminate(2)

Surge Protectors(2)

Combination Bulletin/Dry-Erase Boards(2)

Storage Boxes & Containers(2)

Active Seating(2)

Paper Clip Holders(2)

Recycling Bins(2)

Magazine Files(2)

Racks & Organizers(2)

Anti-Fatigue Mats(2)

Cable Management(2)

Signs & Sign Holders(2)

Multimedia Carts(2)

Open Shelf Files(2)

Notes Holders / Dispensers(2)

Laptop Cases & Bags(2)

Pad Retainers(1)

Indoor Mats(1)

Bookends(1)

Mounting Putty(1)

Business Card Refills(1)

Mail Carts(1)

Desktop Shelves(1)

Paper Clips(1)

Desk Center Drawers(1)

Nameplates(1)

Telephone Stands & Holders(1)

Pads/Sliders(1)

Literature Organizers/Sorters(1)

Desk Clocks(1)

Frames(1)

Waste Containers & Accessories(1)

Sliders(1)

Drawer Organizers(1)

File Divider Kit(1)

File Rails/Frames(1)

Doorstops(1)

Briefcases(1)

Laptop Stands & Pads(1)

Board Cleaners & Wipes(1)

Wall Planners & Organizers(1)

Projector Mounts(1)

Scratch Pads(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

 
Brand

Lorell(2432)

 
Color

Black(511)

Clear(80)

White(55)

Mahogany(55)

Putty(52)

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

 
 
 

© 2020-2021 Rhino Office Products, All Rights Reserved