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_1` 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(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(37)

Stools & Drafting Chairs(37)

Workstations/Computer Desks(35)

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)

Monitor Arms(7)

Big & Tall Chairs(7)

Portable Storage Files & Bins(7)

Wall Files, Pockets & Accessories(7)

Headrest(6)

Letter Trays(6)

Desk Pads(6)

Keyboard/Mouse Platforms & Trays(6)

Pencil Holders(6)

Wood Lateral Files(6)

Hand Trucks & Dollies(6)

Power Strips(6)

Laminate Bookcases(5)

Foot Rests(5)

Wall Racks(5)

Magnets(5)

Card Files & Holders(5)

Desktop File Sorters(5)

Board Erasers(5)

Business Card Holders(5)

Anti-Static Chair Mats(4)

Hooks & Hangers(4)

Loveseat Sofa(4)

Arm Sets(4)

Base(4)

Refrigerators(4)

Reception Sofa(4)

Printer/Fax Stands(3)

Coat/Garment Hooks(3)

Exam Tables(3)

Compact & Student Desks(3)

Lecterns(3)

TV/VCR Stands & Mounts(3)

Storage Drawers & Accessories(3)

Dry Erase Markers(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)

Active Seating(2)

Storage Boxes & Containers(2)

Paper Clip Holders(2)

Recycling Bins(2)

Magazine Files(2)

Notes Holders / Dispensers(2)

Cable Management(2)

Laptop Cases & Bags(2)

Open Shelf Files(2)

Anti-Fatigue Mats(2)

Signs & Sign Holders(2)

Multimedia Carts(2)

Nameplates(1)

Desk Center Drawers(1)

Paper Clips(1)

Indoor Mats(1)

Desktop Shelves(1)

Business Card Refills(1)

Mail Carts(1)

Literature Organizers/Sorters(1)

Pad Retainers(1)

Bookends(1)

Telephone Stands & Holders(1)

Frames(1)

Bulletin Board Sets(1)

Board Cleaners & Wipes(1)

Sliders(1)

Drawer Organizers(1)

File Divider Kit(1)

File Rails/Frames(1)

Desk Clocks(1)

Briefcases(1)

Doorstops(1)

Laptop Stands & Pads(1)

Wall Planners & Organizers(1)

Projector Mounts(1)

Scratch Pads(1)

Pads/Sliders(1)

Waste Containers & Accessories(1)

Dry-Erase Kits/Holders(1)

Rulers & Yardsticks(1)

Ice Buckets(1)

 
Brand

Lorell(2429)

 
Color

Black(510)

Clear(80)

White(55)

Mahogany(55)

Putty(51)

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

 
 
 

© 2020-2021 LOP Office Supply, All Rights Reserved