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

Executive/High Back Chairs(140)

Reception, Side & Guest Chairs(136)

Task Chairs(130)

Meeting & Conference Room Tables(93)

Metal Vertical Files(76)

Contemporary - Metal(75)

Folding/Stacking Chairs & Carts(73)

Metal Lateral Files(65)

Training Room Tables(64)

Utility & Breakroom Tables(57)

Dry-Erase Boards(56)

Management/Mid-Back Chairs(46)

Adjustable Worksurfaces(41)

Lamps(41)

Storage Cabinets(40)

Contemporary - Veneer(39)

Mobile Pedestals(38)

Stools & Drafting Chairs(37)

Panels/Partitions(34)

Workstations/Computer Desks(33)

Book Racks(24)

Carpet Chair Mats(24)

Legs(22)

Industrial & Commercial Shelving(22)

Laminate Tops(21)

Cork/Fabric Bulletin Boards(21)

Wire Shelving(20)

Wall Clocks(20)

Desktop Risers(18)

Wood Veneer Bookcases(17)

Mobile File Carts & Cabinets(16)

Backrests & Seat Cushions(16)

Utility/Service Carts(15)

Educational Seating(15)

Metal Bookcases(15)

Folding Tables(15)

Hard Floor Chair Mats(14)

Protectors(14)

Desktop Organizers(13)

Easel Boards(12)

Fans(12)

Shelf(12)

Ottomans(11)

Bulletin Boards(11)

Certificate Frames & Holders(11)

Work Surfaces(10)

Casters(9)

Reception Area & Accent Tables(9)

Monitor Stands/Risers(9)

Heaters(9)

Panel System Hardware(8)

Bulletin Bars(8)

Monitor Arms(7)

Wall Files, Pockets & Accessories(7)

Big & Tall Chairs(7)

Portable Storage Files & Bins(7)

Pencil Holders(6)

Wood Lateral Files(6)

Power Strips(6)

Headrest(6)

Keyboard/Mouse Platforms & Trays(6)

Letter Trays(6)

Hand Trucks & Dollies(6)

Desk Pads(6)

Desktop File Sorters(5)

Business Card Holders(5)

Foot Rests(5)

Magnets(5)

Card Files & Holders(5)

Board Erasers(5)

Laminate Bookcases(5)

Wall Racks(5)

Refrigerators(4)

Reception Sofa(4)

TV/VCR Stands & Mounts(4)

Anti-Static Chair Mats(4)

Base(4)

Arm Sets(4)

Hooks & Hangers(4)

Loveseat Sofa(4)

Printer/Fax Stands(3)

Exam Tables(3)

Lecterns(3)

Compact & Student Desks(3)

Dry Erase Markers(3)

Storage Drawers & Accessories(3)

Coat/Garment Hooks(3)

Anti-Fatigue Mats(2)

Notes Holders / Dispensers(2)

Magazine Files(2)

Coat/Garment Hangers(2)

Push Pins(2)

Phone Stands(2)

Paper Clip Holders(2)

Light Bulbs & Tubes(2)

Combination Bulletin/Dry-Erase Boards(2)

Storage Boxes & Containers(2)

Surge Protectors(2)

Recycling Bins(2)

Multimedia Carts(2)

Cable Management(2)

Laptop Cases & Bags(2)

Waste Containers & Accessories(2)

Active Seating(2)

Signs & Sign Holders(2)

Open Shelf Files(2)

Board Cleaners & Wipes(1)

Paper Clips(1)

Indoor Mats(1)

Drawer Organizers(1)

Sliders(1)

Nameplates(1)

Business Card Refills(1)

Bookends(1)

Mail Carts(1)

Desktop Shelves(1)

Desk Center Drawers(1)

File Divider Kit(1)

File Rails/Frames(1)

Telephone Stands & Holders(1)

Scratch Pads(1)

Desk Clocks(1)

Rulers & Yardsticks(1)

Bulletin Board Sets(1)

Literature Organizers/Sorters(1)

Pad Retainers(1)

Mounting Putty(1)

Frames(1)

Briefcases(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Wall Planners & Organizers(1)

Pads/Sliders(1)

Laptop Stands & Pads(1)

Projector Mounts(1)

Doorstops(1)

 
Brand

Lorell(2425)

 
Color

Black(512)

Clear(80)

White(56)

Mahogany(54)

Putty(52)

Silver(45)

Light Gray(41)

Cherry(37)

Gray(32)

Charcoal(30)

Chrome(23)

Walnut(22)

Green(18)

Brown(18)

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

Clear Frame(2)

Black Hanger(2)

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

Hook(1)

Charcoal Black(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(1297)

Yes(517)

 
 
 

© 2019-2020 Rhino Office Products, All Rights Reserved