Banner1 Banner1
 
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 (`manufacturer_id` = "1700356") 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

Manufacturer

Lorell

Refine Search

  GO
 
Category

Contemporary - Laminate(409)

Executive/High Back Chairs(134)

Reception, Side & Guest Chairs(131)

Task Chairs(125)

Contemporary - Metal(78)

Meeting & Conference Room Tables(77)

Metal Lateral Files(65)

Metal Vertical Files(64)

Contemporary - Veneer(61)

Training Room Tables(57)

Folding/Stacking Chairs & Carts(55)

Management/Mid-Back Chairs(54)

Dry-Erase Boards(50)

Utility & Breakroom Tables(48)

Adjustable Worksurfaces(39)

Panels/Partitions(39)

Mobile Pedestals(39)

Lamps(39)

Storage Cabinets(36)

Stools & Drafting Chairs(36)

Legs(25)

Carpet Chair Mats(24)

Laminate Tops(22)

Wire Shelving(20)

Wall Clocks(19)

Folding Tables(19)

Hard Floor Chair Mats(19)

Mobile File Carts & Cabinets(17)

Desktop Risers(15)

Book Racks(15)

Desktop Organizers(15)

Metal Bookcases(15)

Educational Seating(15)

Wood Veneer Bookcases(14)

Protectors(14)

Utility/Service Carts(14)

Cork/Fabric Bulletin Boards(13)

Workstations/Computer Desks(13)

Shelf(12)

Casters(11)

Bulletin Boards(11)

Fans(10)

Ottomans(10)

Work Surfaces(10)

Heaters(10)

Easel Boards(9)

Desk Pads(9)

Backrests & Seat Cushions(9)

Bulletin Bars(8)

Panel System Hardware(8)

TV/VCR Stands & Mounts(8)

Industrial & Commercial Shelving(7)

Letter Trays(7)

Big & Tall Chairs(7)

Pencil Holders(6)

Monitor Stands/Risers(6)

Foot Rests(6)

Monitor Arms(6)

Laminate Bookcases(6)

Headrest(6)

Wood Lateral Files(6)

Wall Racks(5)

Power Strips(5)

Magnets(5)

Card Files & Holders(5)

Lecterns(5)

Portable Storage Files & Bins(5)

Business Card Holders(5)

Board Erasers(5)

Desktop File Sorters(5)

Keyboard/Mouse Platforms & Trays(4)

Arm Sets(4)

Refrigerators(4)

Base(4)

Traditional - Laminate(4)

Hand Trucks & Dollies(4)

Reception Area & Accent Tables(4)

Wall Files, Pockets & Accessories(4)

Hooks & Hangers(4)

Laptop Cases & Bags(4)

Anti-Static Chair Mats(4)

Compact & Student Desks(3)

Coat/Garment Hooks(3)

Open Shelf Files(3)

Desk Center Drawers(3)

Printer/Fax Stands(3)

Storage Drawers & Accessories(3)

Dry Erase Markers(3)

Exam Tables(3)

Reception Sofa(2)

Push Pins(2)

Paper Clip Holders(2)

Loveseat Sofa(2)

Multimedia Carts(2)

Frames(2)

Projector Mounts(2)

Phone Stands(2)

Waste Containers & Accessories(2)

Coat/Garment Hangers(2)

Combination Bulletin/Dry-Erase Boards(2)

Signs & Sign Holders(2)

Light Bulbs & Tubes(2)

Notes Holders / Dispensers(2)

Active Seating(2)

Bulletin/Map Rails(1)

Bookends(1)

Nameplates(1)

Mail Carts(1)

Mirrors(1)

Paper Clips(1)

Magazine Files(1)

Surge Protectors(1)

Desktop Shelves(1)

Anti-Fatigue Mats(1)

Doorstops(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

Pad Retainers(1)

Mounting Putty(1)

Business Card Refills(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Sliders(1)

File Divider Kit(1)

Storage Boxes & Containers(1)

Ice Buckets(1)

Laptop Stands & Pads(1)

Board Cleaners & Wipes(1)

Briefcases(1)

File Rails/Frames(1)

Desk Clocks(1)

Telephone Stands & Holders(1)

 
Brand

Lorell(2304)

 
Color

Black(467)

Clear(84)

Mahogany(61)

Putty(53)

Silver(48)

White(47)

Light Gray(43)

Cherry(39)

Charcoal(31)

Gray(28)

Chrome(23)

Walnut(22)

Brown(19)

Green(17)

Blue(16)

Beige(13)

Espresso(10)

Medium Tone(9)

Pepper(8)

Charcoal Gray(8)

Real Red(7)

Malted(7)

Ocean(7)

Periwinkle Blue(7)

Buff(7)

Apple Green(7)

Navy(7)

Cloud(7)

Stratus(7)

Red(6)

Bronze(5)

Satin(5)

Latte(5)

Aluminum(5)

Chrome - Handle(5)

Tan(4)

Natural(4)

Oxblood(4)

Green Edge(3)

Transparent(3)

Latte Laminate(3)

Matte(3)

Laminate(3)

Chambray(3)

Roulette(3)

Saddle(2)

Platinum(2)

Espresso Laminate(2)

Assorted(2)

- Frame(2)

Orange(2)

Frosted(2)

Black Hanger(2)

Slate(2)

Silver Mist(2)

Clear Frame(2)

White Shade(2)

Ash(2)

Wine(2)

Dark Blue(2)

Silver Metal(1)

Light Blue(1)

Brick Beige(1)

Stainless Steel(1)

Black Cherry(1)

Hook(1)

Champagne(1)

Black Base(1)

Lime(1)

Stone(1)

Blueberry(1)

Sand(1)

Cafe(1)

Citronella(1)

Dark Gray(1)

Black Mahogany(1)

Taupe(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Midnight Blue(1)

Gray Black(1)

Heat Wave(1)

Chinchilla(1)

Charcoal Black(1)

Multi(1)

 
Size

Large (L)(1)

8.50" Width x 11" Length(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(1231)

Yes(481)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved