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

Executive/High Back Chairs(139)

Reception, Side & Guest Chairs(136)

Task Chairs(123)

Meeting & Conference Room Tables(93)

Metal Vertical Files(76)

Contemporary - Metal(74)

Folding/Stacking Chairs & Carts(73)

Metal Lateral Files(65)

Training Room Tables(64)

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)

Contemporary - Veneer(35)

Panels/Partitions(33)

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)

Backrests & Seat Cushions(16)

Mobile File Carts & Cabinets(16)

Utility/Service Carts(15)

Metal Bookcases(15)

Educational Seating(15)

Folding Tables(15)

Protectors(14)

Hard Floor Chair Mats(14)

Desktop Organizers(13)

Easel Boards(12)

Shelf(12)

Certificate Frames & Holders(11)

Bulletin Boards(11)

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

Base(4)

Hooks & Hangers(4)

Refrigerators(4)

Anti-Static Chair Mats(4)

Arm Sets(4)

Loveseat Sofa(4)

Reception Sofa(4)

Exam Tables(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

Lecterns(3)

Printer/Fax Stands(3)

TV/VCR Stands & Mounts(3)

Dry Erase Markers(3)

Coat/Garment Hooks(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(2407)

 
Color

Black(511)

Clear(80)

White(55)

Mahogany(54)

Putty(52)

Silver(45)

Light Gray(41)

Cherry(36)

Gray(32)

Charcoal(30)

Chrome(23)

Walnut(22)

Blue(17)

Green(17)

Brown(16)

Beige(12)

Navy(11)

Espresso(10)

Red(10)

Medium Tone(9)

Charcoal Gray(9)

Real Red(7)

Malted(7)

Ocean(7)

Pepper(7)

Cloud(7)

Parchment(6)

Apple Green(6)

Buff(6)

Stratus(6)

Periwinkle Blue(6)

Aluminum(5)

Chrome - Handle(5)

Bronze(5)

Satin(5)

Laminate(4)

Tan(4)

Oxblood(4)

Platinum(4)

Natural(4)

Roulette(3)

Chambray(3)

Metallic Silver(3)

Green Edge(3)

Latte(3)

Transparent(3)

Graphite(2)

- Frame(2)

Saddle(2)

Espresso Laminate(2)

Silver Mist(2)

Burgundy(2)

Orange(2)

White Shade(2)

Dark Blue(2)

Ash(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(1283)

Yes(516)

 
 
 

© 2019-2020 LOP Office Supply, All Rights Reserved