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

Contemporary - Laminate(401)

Reception, Side & Guest Chairs(346)

Executive/High Back Chairs(312)

Management/Mid-Back Chairs(202)

Stools & Drafting Chairs(172)

Meeting & Conference Room Tables(93)

Metal Vertical Files(76)

Contemporary - Metal(75)

Folding/Stacking Chairs & Carts(74)

Training Room Tables(66)

Metal Lateral Files(65)

Utility & Breakroom Tables(56)

Dry-Erase Boards(56)

Adjustable Worksurfaces(41)

Lamps(41)

Storage Cabinets(40)

Mobile Pedestals(38)

Contemporary - Veneer(36)

Workstations/Computer Desks(34)

Panels/Partitions(33)

Carpet Chair Mats(24)

Book Racks(24)

Legs(22)

Industrial & Commercial Shelving(22)

Laminate Tops(21)

Cork/Fabric Bulletin Boards(21)

Wire Shelving(20)

Wall Clocks(20)

Desktop Risers(18)

Wood Veneer Bookcases(17)

Backrests & Seat Cushions(16)

Mobile File Carts & Cabinets(16)

Folding Tables(15)

Utility/Service Carts(15)

Educational Seating(15)

Metal Bookcases(15)

Hard Floor Chair Mats(14)

Protectors(14)

Desktop Organizers(13)

Shelf(12)

Easel Boards(12)

Fans(12)

Ottomans(11)

Certificate Frames & Holders(11)

Bulletin Boards(11)

Work Surfaces(10)

Casters(9)

Reception Area & Accent Tables(9)

Monitor Stands/Risers(9)

Heaters(9)

Panel System Hardware(8)

Bulletin Bars(8)

Board Erasers(7)

Portable Storage Files & Bins(7)

Monitor Arms(7)

Big & Tall Chairs(7)

Wall Files, Pockets & Accessories(7)

Pencil Holders(6)

Desk Pads(6)

Headrest(6)

Hand Trucks & Dollies(6)

Keyboard/Mouse Platforms & Trays(6)

Letter Trays(6)

Power Strips(6)

Wood Lateral Files(6)

Laminate Bookcases(5)

Foot Rests(5)

Card Files & Holders(5)

Business Card Holders(5)

Desktop File Sorters(5)

Magnets(5)

Wall Racks(5)

Hooks & Hangers(4)

Reception Sofa(4)

Arm Sets(4)

Base(4)

Refrigerators(4)

Loveseat Sofa(4)

Anti-Static Chair Mats(4)

Compact & Student Desks(3)

Coat/Garment Hooks(3)

TV/VCR Stands & Mounts(3)

Storage Drawers & Accessories(3)

Printer/Fax Stands(3)

Exam Tables(3)

Dry Erase Markers(3)

Lecterns(3)

Recycling Bins(2)

Storage Boxes & Containers(2)

Phone Stands(2)

Anti-Fatigue Mats(2)

Notes Holders / Dispensers(2)

Laptop Cases & Bags(2)

Magazine Files(2)

Paper Clip Holders(2)

Active Seating(2)

Signs & Sign Holders(2)

Push Pins(2)

Light Bulbs & Tubes(2)

Surge Protectors(2)

Multimedia Carts(2)

Combination Bulletin/Dry-Erase Boards(2)

Waste Containers & Accessories(2)

Cable Management(2)

Open Shelf Files(2)

Coat/Garment Hangers(2)

Business Card Refills(1)

Indoor Mats(1)

Paper Clips(1)

Nameplates(1)

Mounting Putty(1)

Wall Planners & Organizers(1)

Telephone Stands & Holders(1)

Mail Carts(1)

Desktop Shelves(1)

Desk Center Drawers(1)

Pads/Sliders(1)

Bookends(1)

Bulletin Board Sets(1)

Drawer Organizers(1)

Frames(1)

Sliders(1)

File Divider Kit(1)

File Rails/Frames(1)

Briefcases(1)

Board Cleaners & Wipes(1)

Doorstops(1)

Scratch Pads(1)

Desk Clocks(1)

Laptop Stands & Pads(1)

Literature Organizers/Sorters(1)

Rulers & Yardsticks(1)

Dry-Erase Kits/Holders(1)

Projector Mounts(1)

Ice Buckets(1)

Pad Retainers(1)

 
Brand

Lorell(3493)

Boss(10)

 
Color

Black(755)

Clear(80)

White(56)

Mahogany(54)

Putty(52)

Silver(45)

Light Gray(41)

Cherry(36)

Gray(32)

Charcoal(30)

Chrome(23)

Walnut(22)

Ocean(21)

Coral Azalea(19)

Apple(17)

Blue(17)

Brown(17)

Green(17)

Regency Red(15)

Mint Chocolate(15)

Nightfall(14)

Snow(14)

Breezy(14)

Cordovan(14)

Violet(14)

Fiesta(14)

Olive(14)

Canyon(14)

Cobalt(14)

Adobe(14)

Ebony(14)

Sage(14)

Metal(14)

Carbon(14)

Red Rock(14)

Java(13)

Beige(12)

Navy(11)

Red(10)

Espresso(10)

Medium Tone(9)

Charcoal Gray(9)

Pepper(7)

Cloud(7)

Malted(7)

Real Red(7)

Stratus(6)

Parchment(6)

Apple Green(6)

Buff(6)

Periwinkle Blue(6)

Bronze(5)

Satin(5)

Chrome - Handle(5)

Aluminum(5)

Laminate(4)

Natural(4)

Tan(4)

Platinum(4)

Oxblood(4)

Quattro Umber(3)

Quattro Spring Green(3)

Quattro Hibiscus(3)

Shire Travertine(3)

Snakeskin Khaki(3)

Shire Chesapeake(3)

Shire Stonewall(3)

Shire Tulip(3)

Quattro Chalk(3)

Green Edge(3)

Metallic Silver(3)

Perfection Olive Green(3)

Transparent(3)

Latte(3)

Roulette(3)

Chambray(3)

Snakeskin Candy(3)

Snakeskin Charcoal(3)

Snakeskin Midnight(3)

Snakeskin Pumpkin(3)

Shire Sage(3)

Destiny Celadon(3)

Destiny Fiesta(3)

Destiny Sapphire(3)

Destiny Pumpkin(3)

Forte Fudge(3)

Forte Chive(3)

Forte Pumice(3)

Forte Port(3)

Forte Cadet(3)

Destiny Granite(3)

Expo Tuexdo(3)

Canyon Nugget(3)

Canyon Mudslide(3)

Canyon Fern(3)

Canyon Cordovan(3)

Canyon Nutmeg(3)

Expo Festive(3)

Perfection Navy(3)

Expo Latte(3)

Expo Fog(3)

Fuse Azurean(3)

Expo Leaf(3)

Perfection Burgundy(3)

Rain Dance Flame(3)

Rain Dance Zenith(3)

Lifesaver Mango(3)

Lifesaver Chocolate(3)

Rain Dance Aloe(3)

Perfection Black(3)

Rain Dance Sterling(3)

Rain Dance Lake(3)

Rain Dance Aubergine(3)

Perfection Beige(3)

Fuse Carmine(3)

Lifesaver Candy(3)

Insight Forest(3)

Insight Fossil(3)

Insight Ebony(3)

Lifesaver Blueberry(3)

Fuse Cress(3)

Lifesaver Butterscotch(3)

Graphite(2)

- Frame(2)

Smoke(2)

Espresso Laminate(2)

Orange(2)

Ash(2)

Black Hanger(2)

Burgundy(2)

Dark Blue(2)

Silver Mist(2)

White Shade(2)

Saddle(2)

Matte(2)

Rosewood(2)

Champagne Gold(2)

Clear Frame(2)

Slate(2)

Platinum Gray(2)

Assorted(2)

Cafe(1)

Sand(1)

Frosted(1)

Citronella(1)

Blueberry(1)

Ivory(1)

Dark Gray(1)

Brick Beige(1)

Stone(1)

Hook(1)

Stainless Steel(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Heat Wave(1)

Taupe(1)

Chinchilla(1)

Midnight Blue(1)

Multi(1)

Black Mahogany(1)

Light Blue(1)

Charcoal Black(1)

Lime(1)

Weathered Charcoal(1)

Black Cherry(1)

Tango(1)

 
Size

Large (L)(1)

 
Recycled

No(2375)

Yes(517)

 
 
 

© 2019-2020 LOP Office Supply, All Rights Reserved