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

Task Chairs(538)

Contemporary - Laminate(410)

Reception, Side & Guest Chairs(357)

Executive/High Back Chairs(318)

Management/Mid-Back Chairs(220)

Stools & Drafting Chairs(181)

Contemporary - Metal(78)

Meeting & Conference Room Tables(77)

Metal Lateral Files(65)

Metal Vertical Files(64)

Contemporary - Veneer(62)

Training Room Tables(59)

Folding/Stacking Chairs & Carts(56)

Utility & Breakroom Tables(48)

Dry-Erase Boards(46)

Lamps(39)

Adjustable Worksurfaces(39)

Mobile Pedestals(39)

Panels/Partitions(39)

Storage Cabinets(36)

Legs(26)

Carpet Chair Mats(24)

Folding Tables(21)

Laminate Tops(21)

Wire Shelving(20)

Hard Floor Chair Mats(19)

Wall Clocks(19)

Mobile File Carts & Cabinets(17)

Educational Seating(15)

Desktop Risers(15)

Book Racks(15)

Desktop Organizers(15)

Metal Bookcases(15)

Utility/Service Carts(14)

Protectors(14)

Workstations/Computer Desks(13)

Cork/Fabric Bulletin Boards(13)

Wood Veneer Bookcases(12)

Shelf(12)

Casters(11)

Bulletin Boards(11)

Fans(10)

Heaters(10)

Ottomans(10)

Work Surfaces(10)

Easel Boards(9)

Backrests & Seat Cushions(9)

Desk Pads(9)

TV/VCR Stands & Mounts(8)

Panel System Hardware(8)

Bulletin Bars(8)

Laminate Bookcases(8)

Big & Tall Chairs(7)

Industrial & Commercial Shelving(7)

Letter Trays(7)

Monitor Stands/Risers(6)

Foot Rests(6)

Monitor Arms(6)

Traditional - Laminate(6)

Headrest(6)

Wood Lateral Files(6)

Pencil Holders(6)

Business Card Holders(5)

Card Files & Holders(5)

Desktop File Sorters(5)

Magnets(5)

Wall Racks(5)

Portable Storage Files & Bins(5)

Lecterns(5)

Board Erasers(5)

Power Strips(5)

Hand Trucks & Dollies(4)

Keyboard/Mouse Platforms & Trays(4)

Reception Area & Accent Tables(4)

Base(4)

Hooks & Hangers(4)

Refrigerators(4)

Anti-Static Chair Mats(4)

Arm Sets(4)

Wall Files, Pockets & Accessories(4)

Laptop Cases & Bags(4)

Open Shelf Files(3)

Compact & Student Desks(3)

Frames(3)

Desk Center Drawers(3)

Printer/Fax Stands(3)

Coat/Garment Hooks(3)

Dry Erase Markers(3)

Storage Drawers & Accessories(3)

Exam Tables(3)

Phone Stands(2)

Light Bulbs & Tubes(2)

Multimedia Carts(2)

Signs & Sign Holders(2)

Paper Clip Holders(2)

Projector Mounts(2)

Combination Bulletin/Dry-Erase Boards(2)

Active Seating(2)

Notes Holders / Dispensers(2)

Magazine Files(2)

Push Pins(2)

Waste Containers & Accessories(2)

Wall Planners & Organizers(2)

Storage Boxes & Containers(2)

Reception Sofa(2)

Loveseat Sofa(2)

Coat/Garment Hangers(2)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Desk Clocks(1)

Briefcases(1)

Board Cleaners & Wipes(1)

Sign Kits(1)

Anti-Fatigue Mats(1)

Surge Protectors(1)

Mail Carts(1)

Desktop Shelves(1)

Bookends(1)

Paper Clips(1)

File Rails/Frames(1)

File Divider Kit(1)

Nameplates(1)

Mounting Putty(1)

Business Card Refills(1)

Ice Buckets(1)

Doorstops(1)

Scratch Pads(1)

Rulers & Yardsticks(1)

Laptop Stands & Pads(1)

Pads/Sliders(1)

Mirrors(1)

Bulletin/Map Rails(1)

Sliders(1)

Telephone Stands & Holders(1)

Pad Retainers(1)

 
Brand

Lorell(3440)

Boss(9)

 
Color

Black(732)

Clear(84)

Mahogany(61)

Putty(53)

Silver(48)

White(47)

Light Gray(43)

Cherry(39)

Charcoal(31)

Gray(28)

Chrome(23)

Walnut(22)

Ocean(21)

Brown(19)

Coral Azalea(19)

Apple(17)

Green(17)

Blue(16)

Regency Red(15)

Mint Chocolate(15)

Nightfall(14)

Snow(14)

Breezy(14)

Cordovan(14)

Fiesta(14)

Olive(14)

Cobalt(14)

Canyon(14)

Violet(14)

Adobe(14)

Carbon(14)

Sage(14)

Metal(14)

Ebony(14)

Red Rock(14)

Beige(13)

Java(13)

Espresso(10)

Medium Tone(9)

Charcoal Gray(8)

Navy(7)

Stratus(7)

Apple Green(7)

Buff(7)

Cloud(7)

Red(6)

Aluminum(5)

Latte(5)

Pepper(5)

Bronze(5)

Satin(5)

Chrome - Handle(5)

Real Red(4)

Malted(4)

Oxblood(4)

Natural(4)

Tan(4)

Periwinkle Blue(4)

Shire Travertine(3)

Shire Tulip(3)

Quattro Chalk(3)

Shire Stonewall(3)

Quattro Spring Green(3)

Rain Dance Zenith(3)

Shire Chesapeake(3)

Perfection Olive Green(3)

Perfection Navy(3)

Quattro Hibiscus(3)

Shire Sage(3)

Green Edge(3)

Laminate(3)

Perfection Burgundy(3)

Transparent(3)

Latte Laminate(3)

Matte(3)

Snakeskin Midnight(3)

Snakeskin Khaki(3)

Snakeskin Pumpkin(3)

Snakeskin Candy(3)

Snakeskin Charcoal(3)

Quattro Umber(3)

Perfection Beige(3)

Expo Tuexdo(3)

Expo Leaf(3)

Expo Latte(3)

Expo Festive(3)

Destiny Granite(3)

Destiny Pumpkin(3)

Destiny Celadon(3)

Destiny Fiesta(3)

Destiny Sapphire(3)

Canyon Nutmeg(3)

Canyon Nugget(3)

Moda Medal(3)

Moda Anthem(3)

Moda Agave(3)

Moda Derby(3)

Moda Tabasco(3)

Canyon Cordovan(3)

Canyon Mudslide(3)

Perfection Black(3)

Canyon Fern(3)

Forte Fudge(3)

Expo Fog(3)

Lifesaver Candy(3)

Lifesaver Butterscotch(3)

Lifesaver Blueberry(3)

Insight Fossil(3)

Lifesaver Chocolate(3)

Rain Dance Aloe(3)

Rain Dance Flame(3)

Lifesaver Mango(3)

Forte Chive(3)

Insight Forest(3)

Rain Dance Lake(3)

Forte Pumice(3)

Forte Port(3)

Rain Dance Aubergine(3)

Forte Cadet(3)

Fuse Carmine(3)

Fuse Azurean(3)

Fuse Cress(3)

Rain Dance Sterling(3)

Insight Ebony(3)

Dark Blue(2)

- Frame(2)

Orange(2)

Ash(2)

Platinum(2)

Espresso Laminate(2)

Frosted(2)

Wine(2)

White Shade(2)

Slate(2)

Assorted(2)

Clear Frame(2)

Silver Mist(2)

Saddle(2)

Black Hanger(2)

Brick Beige(1)

Silver Metal(1)

Tango(1)

Dark Gray(1)

Stone(1)

Hook(1)

Black Base(1)

Lime(1)

Chinchilla(1)

Charcoal Black(1)

Heat Wave(1)

Black Mahogany(1)

Champagne(1)

Black Cherry(1)

Gray Black(1)

Midnight Blue(1)

Multi(1)

Light Blue(1)

Cherry - Frame(1)

Mahogany - Frame(1)

Taupe(1)

Stainless Steel(1)

 
Size

8.50" Width x 11" Length(2)

Large (L)(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(2391)

Yes(465)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved