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 ((`desc_short` like 'lorell' OR `desc_long` like 'lorell' OR `desc_title` like 'lorell' OR `keywords` like 'lorell' OR `category_1` like 'lorell' OR `category_2` like 'lorell' OR `category_3` like 'lorell' OR `category_4` like 'lorell' OR `manufacturer_name` like 'lorell' OR `color` like 'lorell') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>lorell>lorells)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"lorell"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%lorell%' OR `pinfo`.`sku` like '%lorell%' OR (FIND_IN_SET('lorell', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('lorell', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('lorell', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('lorell', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('lorell', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'lorell' ELSE `pinfo`.`desc_title` like 'lorell' END))) 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

Keyword

Lorell

Refine Search

  GO
 
Category

Contemporary - Laminate(416)

Executive/High Back Chairs(136)

Reception, Side & Guest Chairs(132)

Task Chairs(102)

Contemporary - Metal(93)

Contemporary - Veneer(89)

Meeting & Conference Room Tables(78)

Metal Lateral Files(65)

Metal Vertical Files(64)

Training Room Tables(57)

Folding/Stacking Chairs & Carts(56)

Management/Mid-Back Chairs(55)

Utility & Breakroom Tables(53)

Dry-Erase Boards(46)

Mobile Pedestals(39)

Lamps(39)

Adjustable Worksurfaces(39)

Panels/Partitions(39)

Storage Cabinets(36)

Stools & Drafting Chairs(36)

Legs(25)

Carpet Chair Mats(24)

Laminate Tops(22)

Folding Tables(21)

Wire Shelving(20)

Wall Clocks(19)

Hard Floor Chair Mats(19)

Desktop Organizers(18)

Mobile File Carts & Cabinets(17)

Desktop Risers(15)

Metal Bookcases(15)

Wood Veneer Bookcases(15)

Book Racks(15)

Educational Seating(15)

Workstations/Computer Desks(14)

Protectors(14)

Utility/Service Carts(14)

Cork/Fabric Bulletin Boards(13)

Shelf(12)

Ottomans(11)

Heaters(11)

Casters(11)

Bulletin Boards(11)

Work Surfaces(10)

Easel Boards(9)

Backrests & Seat Cushions(9)

Fans(9)

Desk Pads(9)

Panel System Hardware(8)

TV/VCR Stands & Mounts(8)

Monitor Arms(8)

Big & Tall Chairs(7)

Industrial & Commercial Shelving(7)

Letter Trays(7)

Laminate Bookcases(6)

Traditional - Laminate(6)

Desktop File Sorters(6)

Monitor Stands/Risers(6)

Wood Lateral Files(6)

Headrest(6)

Foot Rests(6)

Business Card Holders(6)

Magnets(5)

Portable Storage Files & Bins(5)

Pencil Holders(5)

Frames(5)

Wall Racks(5)

Card Files & Holders(5)

Board Erasers(5)

Power Strips(5)

Lecterns(5)

Arm Sets(4)

Laptop Cases & Bags(4)

Keyboard/Mouse Platforms & Trays(4)

Anti-Static Chair Mats(4)

Hooks & Hangers(4)

Base(4)

Reception Area & Accent Tables(4)

Hand Trucks & Dollies(4)

Refrigerators(4)

Bulletin Bars(4)

Coat/Garment Hooks(3)

Wall Files, Pockets & Accessories(3)

Signs & Sign Holders(3)

Desk Center Drawers(3)

Open Shelf Files(3)

Printer/Fax Stands(3)

Exam Tables(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

Dry Erase Markers(3)

Loveseat Sofa(2)

Reception Sofa(2)

Coat/Garment Hangers(2)

Paper Clip Holders(2)

Projector Mounts(2)

Active Seating(2)

Phone Stands(2)

Color Hanging Folders(2)

Wall Planners & Organizers(2)

Notes Holders / Dispensers(2)

Combination Bulletin/Dry-Erase Boards(2)

Report Covers(2)

Waste Containers & Accessories(2)

Multimedia Carts(2)

Light Bulbs & Tubes(2)

Desktop Shelves(1)

Mirrors(1)

Mail Carts(1)

Anti-Fatigue Mats(1)

Nameplates(1)

Magazine Files(1)

Surge Protectors(1)

Bookends(1)

Paper Clips(1)

Mechanical Pencils(1)

Doorstops(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

Labels(1)

Pad Retainers(1)

Mounting Putty(1)

Business Card Refills(1)

Push Pins(1)

Pads/Sliders(1)

Sliders(1)

File Divider Kit(1)

Traditional - Veneer(1)

Laptop Stands & Pads(1)

Telephone Stands & Holders(1)

Ice Buckets(1)

Board Cleaners & Wipes(1)

File Rails/Frames(1)

Desk Clocks(1)

Briefcases(1)

Bulletin/Map Rails(1)

 
Brand

Lorell(2356)

 
Color

Black(477)

Clear(84)

Mahogany(62)

Putty(53)

Silver(49)

White(46)

Light Gray(43)

Cherry(40)

Charcoal(31)

Gray(28)

Chrome(23)

Walnut(23)

Brown(19)

Green(17)

Blue(16)

Beige(13)

Espresso(10)

Medium Tone(9)

Charcoal Gray(8)

Stratus(7)

Buff(7)

Ocean(7)

Apple Green(7)

Navy(7)

Cloud(7)

Red(6)

Latte(5)

Satin(5)

Bronze(5)

Pepper(5)

Chrome - Handle(5)

Aluminum(5)

Oxblood(4)

Tan(4)

Natural(4)

Periwinkle Blue(4)

Real Red(4)

Malted(4)

Latte Laminate(3)

Green Edge(3)

Laminate(3)

Matte(3)

Transparent(3)

Silver Mist(2)

- Frame(2)

White Shade(2)

Platinum(2)

Espresso Laminate(2)

Black Hanger(2)

Frosted(2)

Assorted(2)

Slate(2)

Clear Frame(2)

Saddle(2)

Wine(2)

Ash(2)

Orange(2)

Dark Blue(2)

Brick Beige(1)

Silver Metal(1)

Stainless Steel(1)

Lime(1)

Black Cherry(1)

Black Mahogany(1)

Heat Wave(1)

Champagne(1)

Dark Gray(1)

Black Base(1)

Hook(1)

Stone(1)

Chinchilla(1)

Charcoal Black(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Multi(1)

Taupe(1)

Midnight Blue(1)

Burgundy(1)

Gray Black(1)

Light Blue(1)

 
Size

8.50" Width x 11" Length(2)

Large (L)(1)

8" Width x 10" Length(1)

11" Width x 8.50" Length(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(1229)

Yes(521)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved