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

Reception, Side & Guest Chairs(356)

Executive/High Back Chairs(317)

Management/Mid-Back Chairs(220)

Stools & Drafting Chairs(180)

Contemporary - Metal(78)

Meeting & Conference Room Tables(77)

Metal Lateral Files(65)

Metal Vertical Files(64)

Contemporary - Veneer(61)

Training Room Tables(59)

Dry-Erase Boards(56)

Folding/Stacking Chairs & Carts(56)

Utility & Breakroom Tables(48)

Adjustable Worksurfaces(39)

Lamps(39)

Panels/Partitions(39)

Mobile Pedestals(39)

Storage Cabinets(35)

Legs(26)

Carpet Chair Mats(24)

Cork/Fabric Bulletin Boards(21)

Laminate Tops(21)

Wire Shelving(20)

Wall Clocks(19)

Hard Floor Chair Mats(19)

Folding Tables(17)

Mobile File Carts & Cabinets(17)

Educational Seating(15)

Book Racks(15)

Metal Bookcases(15)

Desktop Risers(15)

Utility/Service Carts(14)

Protectors(14)

Workstations/Computer Desks(13)

Desktop Organizers(13)

Shelf(12)

Wood Veneer Bookcases(12)

Casters(11)

Bulletin Boards(11)

Work Surfaces(10)

Fans(10)

Ottomans(10)

Heaters(10)

Easel Boards(9)

Desk Pads(9)

Backrests & Seat Cushions(9)

Bulletin Bars(8)

Panel System Hardware(8)

Big & Tall Chairs(7)

TV/VCR Stands & Mounts(7)

Monitor Stands/Risers(7)

Wall Files, Pockets & Accessories(7)

Letter Trays(7)

Laminate Bookcases(7)

Industrial & Commercial Shelving(7)

Wood Lateral Files(6)

Pencil Holders(6)

Monitor Arms(6)

Headrest(6)

Lecterns(5)

Foot Rests(5)

Business Card Holders(5)

Desktop File Sorters(5)

Portable Storage Files & Bins(5)

Card Files & Holders(5)

Keyboard/Mouse Platforms & Trays(5)

Board Erasers(5)

Magnets(5)

Power Strips(5)

Wall Racks(5)

Arm Sets(4)

Reception Area & Accent Tables(4)

Hooks & Hangers(4)

Traditional - Laminate(4)

Hand Trucks & Dollies(4)

Refrigerators(4)

Base(4)

Anti-Static Chair Mats(4)

Laptop Cases & Bags(4)

Open Shelf Files(3)

Compact & Student Desks(3)

Printer/Fax Stands(3)

Storage Drawers & Accessories(3)

Desk Center Drawers(3)

Exam Tables(3)

Dry Erase Markers(3)

Coat/Garment Hooks(3)

Push Pins(2)

Phone Stands(2)

Loveseat Sofa(2)

Storage Boxes & Containers(2)

Coat/Garment Hangers(2)

Paper Clip Holders(2)

Reception Sofa(2)

Light Bulbs & Tubes(2)

Multimedia Carts(2)

Signs & Sign Holders(2)

Active Seating(2)

Combination Bulletin/Dry-Erase Boards(2)

Projector Mounts(2)

Magazine Files(2)

Notes Holders / Dispensers(2)

Waste Containers & Accessories(2)

Surge Protectors(1)

Mail Carts(1)

Anti-Fatigue Mats(1)

Mirrors(1)

Telephone Stands & Holders(1)

Bookends(1)

Paper Clips(1)

Desktop Shelves(1)

Nameplates(1)

Business Card Refills(1)

File Divider Kit(1)

Doorstops(1)

Sign Kits(1)

Sliders(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Rulers & Yardsticks(1)

Pad Retainers(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Frames(1)

Drawer Organizers(1)

Scratch Pads(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Board Cleaners & Wipes(1)

Briefcases(1)

Mounting Putty(1)

File Rails/Frames(1)

Desk Clocks(1)

Laptop Stands & Pads(1)

 
Brand

Lorell(3444)

Boss(9)

 
Color

Black(730)

Clear(85)

Mahogany(60)

Putty(52)

Silver(47)

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)

Cordovan(14)

Snow(14)

Breezy(14)

Fiesta(14)

Violet(14)

Olive(14)

Cobalt(14)

Canyon(14)

Nightfall(14)

Carbon(14)

Adobe(14)

Ebony(14)

Metal(14)

Sage(14)

Red Rock(14)

Java(13)

Beige(13)

Espresso(10)

Medium Tone(9)

Charcoal Gray(8)

Stratus(7)

Navy(7)

Apple Green(7)

Cloud(7)

Buff(7)

Red(6)

Pepper(5)

Latte(5)

Satin(5)

Aluminum(5)

Chrome - Handle(5)

Bronze(5)

Periwinkle Blue(5)

Malted(4)

Real Red(4)

Oxblood(4)

Tan(4)

Natural(4)

Shire Travertine(3)

Shire Tulip(3)

Quattro Chalk(3)

Quattro Spring Green(3)

Shire Stonewall(3)

Quattro Hibiscus(3)

Shire Chesapeake(3)

Perfection Olive Green(3)

Perfection Navy(3)

Rain Dance Zenith(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)

Moda Agave(3)

Destiny Granite(3)

Destiny Pumpkin(3)

Forte Fudge(3)

Destiny Celadon(3)

Destiny Sapphire(3)

Expo Fog(3)

Expo Festive(3)

Moda Anthem(3)

Moda Medal(3)

Canyon Cordovan(3)

Moda Tabasco(3)

Canyon Fern(3)

Perfection Black(3)

Canyon Nutmeg(3)

Canyon Nugget(3)

Canyon Mudslide(3)

Forte Chive(3)

Destiny Fiesta(3)

Lifesaver Chocolate(3)

Lifesaver Candy(3)

Forte Cadet(3)

Lifesaver Butterscotch(3)

Lifesaver Mango(3)

Rain Dance Flame(3)

Rain Dance Sterling(3)

Rain Dance Lake(3)

Rain Dance Aloe(3)

Rain Dance Aubergine(3)

Lifesaver Blueberry(3)

Fuse Azurean(3)

Forte Pumice(3)

Forte Port(3)

Moda Derby(3)

Insight Fossil(3)

Fuse Carmine(3)

Insight Forest(3)

Insight Ebony(3)

Fuse Cress(3)

Ash(2)

Orange(2)

Dark Blue(2)

Platinum(2)

- Frame(2)

Frosted(2)

Espresso Laminate(2)

Slate(2)

White Shade(2)

Clear Frame(2)

Champagne Gold(2)

Assorted(2)

Silver Mist(2)

Burgundy(2)

Black Hanger(2)

Saddle(2)

Tango(1)

Brick Beige(1)

Hook(1)

Black Base(1)

Stone(1)

Dark Gray(1)

Lime(1)

Chinchilla(1)

Charcoal Black(1)

Heat Wave(1)

Black Mahogany(1)

Smoke(1)

Black Cherry(1)

Midnight Blue(1)

Taupe(1)

Light Blue(1)

Stainless Steel(1)

Multi(1)

Cherry - Frame(1)

Mahogany - Frame(1)

Silver Metal(1)

 
Size

Large (L)(1)

 
Size Supported

Lateral File(1)

 
Recycled

No(2401)

Yes(462)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved