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','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

Keyword

Lorell

Refine Search

  GO
 
Category

Chairs & Seating(1085)

Contemporary - Laminate(459)

Signs & Sign Holders(160)

Reception, Side & Guest Chairs(145)

Executive/High Back Chairs(142)

Task Chairs(136)

Meeting & Conference Room Tables(107)

Metal Lateral Files(82)

Metal Vertical Files(78)

Folding/Stacking Chairs & Carts(75)

Contemporary - Metal(73)

Training Room Tables(72)

Dry-Erase Boards(61)

Utility & Breakroom Tables(56)

Storage Cabinets(52)

Management/Mid-Back Chairs(49)

Mobile Pedestals(49)

Stools & Drafting Chairs(43)

Panels/Partitions(42)

Lamps(42)

Adjustable Worksurfaces(41)

Workstations/Computer Desks(38)

Contemporary - Veneer(35)

Frames(26)

Legs(26)

Book Racks(24)

Carpet Chair Mats(24)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Laminate Tops(21)

Wire Shelving(20)

Wall Clocks(20)

Mobile File Carts & Cabinets(20)

Desktop Risers(20)

Protectors(18)

Metal Bookcases(17)

Wood Veneer Bookcases(17)

Utility/Service Carts(17)

Educational Seating(16)

Hard Floor Chair Mats(16)

Backrests & Seat Cushions(16)

Desktop Organizers(16)

Shelf(16)

Lockers(15)

Folding Tables(15)

Monitor Stands/Risers(15)

Fans(14)

Work Surfaces(13)

Easel Boards(12)

Reception Area & Accent Tables(12)

Certificate Frames & Holders(11)

Ottomans(11)

Bulletin Boards(11)

Heaters(10)

Casters(9)

Portable Storage Files & Bins(8)

Bulletin Bars(8)

Panel System Hardware(8)

Board Erasers(8)

Reception Sofa(7)

Wall Files, Pockets & Accessories(7)

Letter Trays(7)

Monitor Arms(7)

Laminate Bookcases(7)

Keyboard/Mouse Platforms & Trays(7)

Power Strips(7)

Big & Tall Chairs(7)

Desk Pads(6)

Lecterns(6)

Headrest(6)

Wood Lateral Files(6)

Mirrors(6)

Cubicle / Partition Organizers & Accessories(6)

Pencil Holders(6)

Hand Trucks & Dollies(6)

Safety Gear(5)

Magnets(5)

Foot Rests(5)

Arm Sets(5)

Wall Racks(5)

Card Files & Holders(5)

Business Card Holders(5)

Desktop File Sorters(5)

Waste Containers & Accessories(4)

Hooks & Hangers(4)

Anti-Static Chair Mats(4)

Base(4)

Refrigerators(4)

Loveseat Sofa(4)

Compact & Student Desks(4)

Storage Drawers & Accessories(3)

Exam Tables(3)

Coat/Garment Hooks(3)

Dry Erase Markers(3)

Printer/Fax Stands(3)

TV/VCR Stands & Mounts(3)

Coat/Garment Hangers(3)

Open Shelf Files(2)

Paper Clip Holders(2)

Notes Holders / Dispensers(2)

Magazine Files(2)

Traditional - Laminate(2)

Phone Stands(2)

Storage Boxes & Containers(2)

Recycling Bins(2)

Laptop Cases & Bags(2)

Racks & Organizers(2)

Anti-Fatigue Mats(2)

Light Bulbs & Tubes(2)

Multimedia Carts(2)

Cable Management(2)

Active Seating(2)

Desk Center Drawers(2)

Air Purifier/Humidifier Filters(2)

Surge Protectors(2)

Push Pins(2)

Tables & Desks(2)

Combination Bulletin/Dry-Erase Boards(2)

Security Cameras(2)

Business Card Refills(1)

Telephone Stands & Holders(1)

Nameplates(1)

Microwave Ovens(1)

Paper Clips(1)

Video Surveillance Systems(1)

Indoor Mats(1)

Humidifiers(1)

Bookends(1)

Carts & Trolleys(1)

Mail Carts(1)

Desktop Shelves(1)

Strength/Sports Training Equipment(1)

Cubicle Hooks/Clips(1)

Sliders(1)

Laptop Stands & Pads(1)

Board Cleaners & Wipes(1)

File Divider Kit(1)

File Rails/Frames(1)

Doorstops(1)

Desk Clocks(1)

Projector Mounts(1)

Briefcases(1)

Rulers & Yardsticks(1)

Dry-Erase Kits/Holders(1)

Literature Organizers/Sorters(1)

Pad Retainers(1)

Wall Planners & Organizers(1)

Scratch Pads(1)

Pads/Sliders(1)

Drawer Organizers(1)

Ice Buckets(1)

Bulletin Board Sets(1)

 
Brand

Lorell(3955)

Boss(10)

 
Color

Black(835)

White(101)

Clear(93)

Silver(68)

Light Gray(60)

Gray(60)

Mahogany(55)

Putty(52)

Brown(37)

Cherry(35)

Charcoal(35)

Beige(33)

Walnut(26)

Chrome(23)

Green(22)

Ocean(21)

Blue(21)

Coral Azalea(19)

Dark Gray(19)

Apple(17)

Almond(17)

Metallic Silver(15)

Mint Chocolate(15)

Regency Red(15)

Violet(14)

Cordovan(14)

Nightfall(14)

Cobalt(14)

Breezy(14)

Canyon(14)

Carbon(14)

Red Rock(14)

Metal(14)

Sage(14)

Snow(14)

Fiesta(14)

Adobe(14)

Olive(14)

Ebony(14)

Java(13)

Red(12)

Warm Gray(11)

Navy(11)

Espresso(10)

Platinum(9)

Medium Tone(9)

Charcoal Gray(9)

Pepper(8)

Tan(8)

Periwinkle Blue(7)

Apple Green(7)

Real Red(7)

Natural(7)

Stratus(7)

Buff(7)

Cloud(7)

Malted(7)

Parchment(6)

Aluminum(5)

Bronze(5)

Satin(5)

Transparent(5)

Chrome - Handle(5)

Satin Nickel - Pull(4)

Laminate(4)

Oxblood(4)

Quattro Spring Green(3)

Snakeskin Khaki(3)

Quattro Umber(3)

Quattro Hibiscus(3)

Expo Festive(3)

Quattro Chalk(3)

Shire Tulip(3)

Shire Travertine(3)

Snakeskin Candy(3)

Shire Stonewall(3)

Shire Sage(3)

Snakeskin Pumpkin(3)

Canyon Fern(3)

Snakeskin Charcoal(3)

Snakeskin Midnight(3)

Canyon Nugget(3)

Canyon Mudslide(3)

Perfection Olive Green(3)

Canyon Cordovan(3)

Expo Fog(3)

Chambray(3)

Roulette(3)

Aqua(3)

Green Edge(3)

Latte(3)

Shire Chesapeake(3)

Pacific Blue(3)

Perfection Navy(3)

Rain Dance Zenith(3)

Fuse Azurean(3)

Forte Pumice(3)

Forte Port(3)

Forte Cadet(3)

Forte Chive(3)

Forte Fudge(3)

Destiny Celadon(3)

Fuse Cress(3)

Destiny Fiesta(3)

Destiny Sapphire(3)

Destiny Pumpkin(3)

Destiny Granite(3)

Expo Tuexdo(3)

Expo Leaf(3)

Expo Latte(3)

Fuse Carmine(3)

Rain Dance Aubergine(3)

Insight Ebony(3)

Perfection Black(3)

Rain Dance Flame(3)

Lifesaver Mango(3)

Rain Dance Lake(3)

Rain Dance Sterling(3)

Lifesaver Chocolate(3)

Canyon Nutmeg(3)

Perfection Beige(3)

Lifesaver Candy(3)

Perfection Burgundy(3)

Lifesaver Butterscotch(3)

Insight Forest(3)

Insight Fossil(3)

Lifesaver Blueberry(3)

Rain Dance Aloe(3)

Frosted(2)

Platinum Gray(2)

Espresso Laminate(2)

Ash(2)

Orange(2)

Silver Mist(2)

- Frame(2)

Dark Blue(2)

Graphite(2)

Saddle(2)

Assorted(2)

White Shade(2)

Burgundy(2)

Clear Frame(2)

Champagne Gold(2)

Slate(2)

Gold(2)

Smoke(2)

Rosewood(2)

Black - Top(2)

Yellow(2)

Black Hanger(2)

Matte(2)

Black Mahogany(1)

Blueberry(1)

Citronella(1)

Cafe(1)

Ivory(1)

Sand(1)

Brick Beige(1)

Gray/White(1)

Stone(1)

Tango(1)

Latte Laminate(1)

Light Blue(1)

Teak(1)

Stainless Steel(1)

Black Cherry(1)

Weathered Charcoal(1)

Hook(1)

Multi(1)

Cherry - Frame(1)

Mahogany - Frame(1)

Taupe(1)

Midnight Blue(1)

Charcoal Black(1)

Chinchilla(1)

Lime(1)

Heat Wave(1)

 
Size

4" Length(3)

3" Length(1)

2" Length(1)

1.15" Length(1)

Large (L)(1)

 
Recycled

No(2716)

Yes(565)

 
 
 

© 2020-2021 LOP Office Supply, All Rights Reserved