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

Executive/High Back Chairs(136)

Reception, Side & Guest Chairs(109)

Contemporary - Metal(98)

Contemporary - Veneer(94)

Task Chairs(80)

Meeting & Conference Room Tables(70)

Metal Lateral Files(65)

Metal Vertical Files(64)

Training Room Tables(57)

Management/Mid-Back Chairs(53)

Utility & Breakroom Tables(51)

Dry-Erase Boards(46)

Lamps(39)

Mobile Pedestals(39)

Storage Cabinets(38)

Adjustable Worksurfaces(38)

Panels/Partitions(37)

Folding/Stacking Chairs & Carts(32)

Stools & Drafting Chairs(28)

Legs(26)

Carpet Chair Mats(24)

Laminate Tops(22)

Wood Veneer Bookcases(18)

Wire Shelving(17)

Desktop Organizers(16)

Wall Clocks(15)

Metal Bookcases(15)

Folding Tables(14)

Protectors(14)

Book Racks(14)

Workstations/Computer Desks(13)

Cork/Fabric Bulletin Boards(13)

Educational Seating(12)

Shelf(12)

Hard Floor Chair Mats(11)

Casters(11)

Ottomans(11)

Heaters(11)

Mobile File Carts & Cabinets(11)

Bulletin Boards(11)

Desktop Risers(11)

Work Surfaces(10)

Fans(9)

Desk Pads(9)

Easel Boards(9)

Utility/Service Carts(9)

Monitor Arms(8)

Panel System Hardware(8)

TV/VCR Stands & Mounts(8)

Backrests & Seat Cushions(7)

Letter Trays(7)

Industrial & Commercial Shelving(7)

Laminate Bookcases(6)

Headrest(6)

Desktop File Sorters(6)

Wood Lateral Files(6)

Traditional - Laminate(6)

Business Card Holders(6)

Card Files & Holders(5)

Magnets(5)

Monitor Stands/Risers(5)

Portable Storage Files & Bins(5)

Wall Racks(5)

Pencil Holders(5)

Board Erasers(5)

Frames(5)

Coat/Garment Hooks(5)

Hooks & Hangers(4)

Hand Trucks & Dollies(4)

Foot Rests(4)

Reception Area & Accent Tables(4)

Laptop Cases & Bags(4)

Base(4)

Refrigerators(4)

Keyboard/Mouse Platforms & Trays(4)

Bulletin Bars(4)

Anti-Static Chair Mats(4)

Wall Files, Pockets & Accessories(3)

Desk Center Drawers(3)

Printer/Fax Stands(3)

Dry Erase Markers(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

Power Strips(3)

Signs & Sign Holders(2)

Loveseat Sofa(2)

Lecterns(2)

Projector Mounts(2)

Paper Clip Holders(2)

Reception Sofa(2)

Phone Stands(2)

Paper Clips(2)

Multimedia Carts(2)

Notes Holders / Dispensers(2)

Coat/Garment Hangers(2)

Combination Bulletin/Dry-Erase Boards(2)

Big & Tall Chairs(2)

Light Bulbs & Tubes(2)

Waste Containers & Accessories(2)

Open Shelf Files(2)

Anti-Fatigue Mats(1)

Bulletin/Map Rails(1)

Magazine Files(1)

Nameplates(1)

Mirrors(1)

Wall Planners & Organizers(1)

Business Card Refills(1)

Mail Carts(1)

Desktop Shelves(1)

Bookends(1)

Surge Protectors(1)

Briefcases(1)

Mounting Putty(1)

Doorstops(1)

Sliders(1)

Pad Retainers(1)

Literature Organizers/Sorters(1)

Rulers & Yardsticks(1)

Bulletin Board Sets(1)

File Divider Kit(1)

File Rails/Frames(1)

Traditional - Veneer(1)

Laptop Stands & Pads(1)

Ice Buckets(1)

Push Pins(1)

Desk Clocks(1)

Board Cleaners & Wipes(1)

Telephone Stands & Holders(1)

 
Brand

Lorell(2183)

 
Color

Black(443)

Clear(72)

Mahogany(60)

Putty(53)

Silver(47)

Light Gray(44)

Cherry(40)

White(40)

Charcoal(31)

Gray(30)

Chrome(23)

Walnut(21)

Brown(18)

Green(17)

Blue(16)

Beige(11)

Espresso(10)

Medium Tone(9)

Navy(7)

Apple Green(7)

Ocean(7)

Buff(7)

Stratus(7)

Cloud(7)

Charcoal Gray(6)

Red(6)

Satin(5)

Latte(5)

Aluminum(5)

Bronze(5)

Roulette(5)

Pepper(5)

Chrome - Handle(5)

Chambray(5)

Tan(4)

Natural(4)

Real Red(4)

Oxblood(4)

Periwinkle Blue(4)

Malted(4)

Green Edge(3)

Transparent(3)

Laminate(3)

Matte(3)

White Shade(2)

Espresso Laminate(2)

Platinum(2)

Saddle(2)

Silver Metal(2)

- Frame(2)

Silver Mist(2)

Slate(2)

Clear Frame(2)

Black Hanger(2)

Wine(2)

Latte Laminate(2)

Frosted(2)

Assorted(2)

Stainless Steel(1)

Light Blue(1)

Brick Beige(1)

Lime(1)

Cafe(1)

Citronella(1)

Blueberry(1)

Black Cherry(1)

Sand(1)

Dark Gray(1)

Black Base(1)

Hook(1)

Stone(1)

Black Mahogany(1)

Heat Wave(1)

Taupe(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Midnight Blue(1)

Gray Black(1)

Chinchilla(1)

Charcoal Black(1)

Burgundy(1)

Multi(1)

 
Size

8.50" Width x 11" Length(2)

72.50" Width x 59.25" Height(1)

30.50" Width x 71" Height(1)

60.75" Width x 59.25" Height(1)

48.75" Width x 59.25" Height(1)

30.50" Width x 59.25" Height(1)

36.38" Width x 59.25" Height(1)

36.38" Width x 71" Height(1)

60.38" Width x 71" Height(1)

11" Width x 8.50" Length(1)

8" Width x 10" Length(1)

Large (L)(1)

1.20" Diameter(1)

35.38" Width x 7.63" Depth x 12.63" Height(1)

1" Height x 1" Width(1)

48.38" Width x 71" Height(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(1156)

Yes(459)

 
 
 

© 2017-2018 LOP Office Supply, All Rights Reserved