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') 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)

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)

Casters(9)

Monitor Stands/Risers(9)

Reception Area & Accent Tables(9)

Heaters(9)

Bulletin Bars(8)

Panel System Hardware(8)

Portable Storage Files & Bins(7)

Monitor Arms(7)

Wall Files, Pockets & Accessories(7)

Big & Tall Chairs(7)

Headrest(6)

Hand Trucks & Dollies(6)

Pencil Holders(6)

Desk Pads(6)

Keyboard/Mouse Platforms & Trays(6)

Wood Lateral Files(6)

Letter Trays(6)

Power Strips(6)

Foot Rests(5)

Laminate Bookcases(5)

Desktop File Sorters(5)

Board Erasers(5)

Card Files & Holders(5)

Magnets(5)

Business Card Holders(5)

Wall Racks(5)

Anti-Static Chair Mats(4)

Base(4)

Refrigerators(4)

Arm Sets(4)

Hooks & Hangers(4)

Reception Sofa(4)

Loveseat Sofa(4)

Coat/Garment Hooks(3)

Printer/Fax Stands(3)

Exam Tables(3)

Lecterns(3)

Compact & Student Desks(3)

Dry Erase Markers(3)

Storage Drawers & Accessories(3)

TV/VCR Stands & Mounts(3)

Light Bulbs & Tubes(2)

Recycling Bins(2)

Anti-Fatigue Mats(2)

Multimedia Carts(2)

Notes Holders / Dispensers(2)

Magazine Files(2)

Traditional - Laminate(2)

Phone Stands(2)

Paper Clip Holders(2)

Coat/Garment Hangers(2)

Combination Bulletin/Dry-Erase Boards(2)

Storage Boxes & Containers(2)

Active Seating(2)

Surge Protectors(2)

Push Pins(2)

Cable Management(2)

Laptop Cases & Bags(2)

Open Shelf Files(2)

Signs & Sign Holders(2)

Drawer Organizers(1)

Business Card Refills(1)

Indoor Mats(1)

Pad Retainers(1)

Mounting Putty(1)

Waste Containers & Accessories(1)

Sliders(1)

Bookends(1)

Mail Carts(1)

Desktop Shelves(1)

Desk Center Drawers(1)

Frames(1)

Paper Clips(1)

Telephone Stands & Holders(1)

Nameplates(1)

Rulers & Yardsticks(1)

Briefcases(1)

Wall Planners & Organizers(1)

Projector Mounts(1)

Desk Clocks(1)

Scratch Pads(1)

Doorstops(1)

Ice Buckets(1)

Board Cleaners & Wipes(1)

Dry-Erase Kits/Holders(1)

File Rails/Frames(1)

Bulletin Board Sets(1)

Laptop Stands & Pads(1)

Literature Organizers/Sorters(1)

File Divider Kit(1)

Pads/Sliders(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