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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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 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` WHERE (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 (`category_name` LIKE 'lorell') OR (`pinfo`.`manufacturer_prefix` LIKE '%lorell%' OR `pinfo`.`manufacturer_name` LIKE '%lorell%' OR `pinfo`.`sku` LIKE '%lorell%' OR `pinfo`.`desc_long` LIKE '%lorell%' OR `pinfo`.`desc_title` LIKE '%lorell%' OR `pinfo`.`keywords` LIKE '%lorell%') ) 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 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(459)

Signs & Sign Holders(160)

Reception, Side & Guest Chairs(145)

Executive/High Back Chairs(142)

Task Chairs(135)

Meeting & Conference Room Tables(107)

Metal Lateral Files(82)

Metal Vertical Files(78)

Folding/Stacking Chairs & Carts(75)

Training Room Tables(72)

Dry-Erase Boards(61)

Utility & Breakroom Tables(56)

Storage Cabinets(52)

Mobile Pedestals(49)

Management/Mid-Back Chairs(49)

Contemporary - Metal(47)

Stools & Drafting Chairs(43)

Panels/Partitions(42)

Lamps(42)

Adjustable Worksurfaces(41)

Workstations/Computer Desks(39)

Contemporary - Veneer(35)

Legs(26)

Frames(26)

Book Racks(24)

Carpet Chair Mats(24)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Laminate Tops(21)

Wall Clocks(20)

Wire Shelving(20)

Mobile File Carts & Cabinets(20)

Desktop Risers(20)

Protectors(18)

Metal Bookcases(17)

Utility/Service Carts(17)

Wood Veneer Bookcases(17)

Educational Seating(16)

Shelf(16)

Backrests & Seat Cushions(16)

Desktop Organizers(16)

Lockers(15)

Folding Tables(15)

Monitor Stands/Risers(15)

Fans(14)

Hard Floor Chair Mats(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)

Bulletin Bars(8)

Portable Storage Files & Bins(8)

Panel System Hardware(8)

Board Erasers(8)

Big & Tall Chairs(7)

Monitor Arms(7)

Power Strips(7)

Reception Sofa(7)

Letter Trays(7)

Keyboard/Mouse Platforms & Trays(7)

Wall Files, Pockets & Accessories(7)

Laminate Bookcases(7)

Wood Lateral Files(6)

Lecterns(6)

Pencil Holders(6)

Headrest(6)

Hand Trucks & Dollies(6)

Cubicle / Partition Organizers & Accessories(6)

Desk Pads(6)

Mirrors(6)

Arm Sets(5)

Card Files & Holders(5)

Business Card Holders(5)

Magnets(5)

Safety Gear(5)

Wall Racks(5)

Desktop File Sorters(5)

Foot Rests(5)

Compact & Student Desks(4)

Waste Containers & Accessories(4)

Anti-Static Chair Mats(4)

Base(4)

Loveseat Sofa(4)

Hooks & Hangers(4)

Refrigerators(4)

Exam Tables(3)

Storage Drawers & Accessories(3)

Printer/Fax Stands(3)

Coat/Garment Hangers(3)

TV/VCR Stands & Mounts(3)

Coat/Garment Hooks(3)

Dry Erase Markers(3)

Racks & Organizers(2)

Notes Holders / Dispensers(2)

Open Shelf Files(2)

Magazine Files(2)

Traditional - Laminate(2)

Storage Boxes & Containers(2)

Phone Stands(2)

Laptop Cases & Bags(2)

Paper Clip Holders(2)

Recycling Bins(2)

Anti-Fatigue Mats(2)

Push Pins(2)

Active Seating(2)

Combination Bulletin/Dry-Erase Boards(2)

Multimedia Carts(2)

Security Cameras(2)

Light Bulbs & Tubes(2)

Surge Protectors(2)

Air Purifier/Humidifier Filters(2)

Cable Management(2)

Bookends(1)

Humidifiers(1)

Video Surveillance Systems(1)

Mail Carts(1)

Indoor Mats(1)

Microwave Ovens(1)

Desktop Shelves(1)

Strength/Sports Training Equipment(1)

Paper Clips(1)

Business Card Refills(1)

Nameplates(1)

Telephone Stands & Holders(1)

Cubicle Hooks/Clips(1)

Drawer Organizers(1)

Ice Buckets(1)

Laptop Stands & Pads(1)

Projector Mounts(1)

File Rails/Frames(1)

Sliders(1)

Desk Clocks(1)

Doorstops(1)

Briefcases(1)

Board Cleaners & Wipes(1)

Bulletin Board Sets(1)

Dry-Erase Kits/Holders(1)

Literature Organizers/Sorters(1)

Pad Retainers(1)

Wall Planners & Organizers(1)

Scratch Pads(1)

Desk Center Drawers(1)

Pads/Sliders(1)

File Divider Kit(1)

Rulers & Yardsticks(1)

Brand

Lorell(2848)

Color

Black(593)

White(101)

Clear(91)

Silver(68)

Light Gray(60)

Gray(60)

Mahogany(55)

Putty(52)

Brown(37)

Cherry(35)

Beige(33)

Charcoal(31)

Walnut(26)

Chrome(23)

Green(22)

Blue(20)

Dark Gray(19)

Almond(17)

Metallic Silver(15)

Red(12)

Warm Gray(11)

Navy(11)

Espresso(10)

Platinum(9)

Medium Tone(9)

Charcoal Gray(9)

Tan(8)

Pepper(8)

Natural(7)

Apple Green(7)

Periwinkle Blue(7)

Malted(7)

Real Red(7)

Cloud(7)

Buff(7)

Stratus(7)

Parchment(6)

Ocean(6)

Transparent(5)

Satin(5)

Bronze(5)

Aluminum(5)

Chrome - Handle(5)

Oxblood(4)

Laminate(4)

Satin Nickel - Pull(4)

Chambray(3)

Roulette(3)

Pacific Blue(3)

Green Edge(3)

Aqua(3)

Latte(3)

Graphite(2)

Saddle(2)

- Frame(2)

Espresso Laminate(2)

Orange(2)

Latte Laminate(2)

Frosted(2)

Dark Blue(2)

Ash(2)

Burgundy(2)

Silver Mist(2)

White Shade(2)

Assorted(2)

Slate(2)

Platinum Gray(2)

Black - Top(2)

Matte(2)

Black Hanger(2)

Yellow(2)

Clear Frame(2)

Rosewood(2)

Champagne Gold(2)

Smoke(2)

Gold(2)

Ivory(1)

Citronella(1)

Blueberry(1)

Cafe(1)

Gray/White(1)

Sand(1)

Stone(1)

Teak(1)

Brick Beige(1)

Stainless Steel(1)

Hook(1)

Heat Wave(1)

Light Blue(1)

Weathered Charcoal(1)

Multi(1)

Cherry - Frame(1)

Mahogany - Frame(1)

Taupe(1)

Midnight Blue(1)

Lime(1)

Black Cherry(1)

Charcoal Black(1)

Black Mahogany(1)

Chinchilla(1)

Size

4" Length(3)

3" Length(1)

2" Length(1)

1.15" Length(1)

Large (L)(1)

Recycled

No(1626)

Yes(542)

Price Range

$0-$499.99(2404)

$500-$999.99(372)

$1000-$1499.99(53)

$1500-$1999.99(8)

$2000-$2499.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CleanAir Granite Office

© 2020-2021 Granite Office, LLC, All Rights Reserved