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)

Lamps(41)

Adjustable Worksurfaces(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)

Industrial & Commercial Shelving(22)

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

Folding Tables(15)

Educational Seating(15)

Metal Bookcases(15)

Utility/Service Carts(15)

Hard Floor Chair Mats(14)

Protectors(14)

Desktop Organizers(13)

Shelf(12)

Fans(12)

Easel Boards(12)

Certificate Frames & Holders(11)

Bulletin Boards(11)

Ottomans(11)

Work Surfaces(10)

Casters(9)

Reception Area & Accent Tables(9)

Heaters(9)

Monitor Stands/Risers(9)

Panel System Hardware(8)

Bulletin Bars(8)

Portable Storage Files & Bins(7)

Big & Tall Chairs(7)

Wall Files, Pockets & Accessories(7)

Monitor Arms(7)

Pencil Holders(6)

Desk Pads(6)

Wood Lateral Files(6)

Headrest(6)

Power Strips(6)

Hand Trucks & Dollies(6)

Keyboard/Mouse Platforms & Trays(6)

Letter Trays(6)

Desktop File Sorters(5)

Board Erasers(5)

Laminate Bookcases(5)

Wall Racks(5)

Foot Rests(5)

Business Card Holders(5)

Magnets(5)

Card Files & Holders(5)

TV/VCR Stands & Mounts(4)

Hooks & Hangers(4)

Refrigerators(4)

Base(4)

Arm Sets(4)

Anti-Static Chair Mats(4)

Reception Sofa(4)

Loveseat Sofa(4)

Exam Tables(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

Lecterns(3)

Printer/Fax Stands(3)

Coat/Garment Hooks(3)

Dry Erase Markers(3)

Phone Stands(2)

Recycling Bins(2)

Storage Boxes & Containers(2)

Coat/Garment Hangers(2)

Open Shelf Files(2)

Paper Clip Holders(2)

Laptop Cases & Bags(2)

Anti-Fatigue Mats(2)

Notes Holders / Dispensers(2)

Waste Containers & Accessories(2)

Multimedia Carts(2)

Cable Management(2)

Active Seating(2)

Combination Bulletin/Dry-Erase Boards(2)

Light Bulbs & Tubes(2)

Signs & Sign Holders(2)

Magazine Files(2)

Push Pins(2)

Surge Protectors(2)

Laptop Stands & Pads(1)

Desk Center Drawers(1)

Mail Carts(1)

Bookends(1)

Desktop Shelves(1)

Indoor Mats(1)

Nameplates(1)

Paper Clips(1)

Telephone Stands & Holders(1)

Doorstops(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

Projector Mounts(1)

Pad Retainers(1)

Mounting Putty(1)

Business Card Refills(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Sliders(1)

Frames(1)

Board Cleaners & Wipes(1)

Scratch Pads(1)

Ice Buckets(1)

Briefcases(1)

Desk Clocks(1)

Drawer Organizers(1)

File Divider Kit(1)

File Rails/Frames(1)

Dry-Erase Kits/Holders(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)

Brown(18)

Green(18)

Blue(17)

Beige(13)

Navy(11)

Espresso(10)

Red(10)

Medium Tone(9)

Charcoal Gray(9)

Pepper(8)

Periwinkle Blue(7)

Cloud(7)

Stratus(7)

Malted(7)

Buff(7)

Apple Green(7)

Ocean(7)

Real Red(7)

Parchment(6)

Satin(5)

Aluminum(5)

Chrome - Handle(5)

Bronze(5)

Platinum(4)

Natural(4)

Laminate(4)

Oxblood(4)

Tan(4)

Green Edge(3)

Metallic Silver(3)

Latte(3)

Chambray(3)

Transparent(3)

Roulette(3)

- Frame(2)

Graphite(2)

Saddle(2)

Ash(2)

Dark Blue(2)

Silver Mist(2)

White Shade(2)

Espresso Laminate(2)

Orange(2)

Burgundy(2)

Clear Frame(2)

Slate(2)

Rosewood(2)

Champagne Gold(2)

Matte(2)

Assorted(2)

Platinum Gray(2)

Smoke(2)

Black Hanger(2)

Hook(1)

Blueberry(1)

Frosted(1)

Citronella(1)

Cafe(1)

Ivory(1)

Stone(1)

Brick Beige(1)

Sand(1)

Dark Gray(1)

Stainless Steel(1)

Heat Wave(1)

Mahogany - Frame(1)

Taupe(1)

Midnight Blue(1)

Chinchilla(1)

Cherry - Frame(1)

Multi(1)

Lime(1)

Light Blue(1)

Weathered Charcoal(1)

Black Cherry(1)

Black Mahogany(1)

Charcoal Black(1)

 
Size

Large (L)(1)

 
Recycled

No(1297)

Yes(517)

 
 
 

© 2019-2020 Rhino Office Products, All Rights Reserved