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') 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(387)

Executive/High Back Chairs(135)

Reception, Side & Guest Chairs(131)

Meeting & Conference Room Tables(93)

Task Chairs(85)

Metal Lateral Files(65)

Metal Vertical Files(64)

Training Room Tables(64)

Folding/Stacking Chairs & Carts(63)

Utility & Breakroom Tables(57)

Dry-Erase Boards(56)

Management/Mid-Back Chairs(46)

Lamps(41)

Adjustable Worksurfaces(41)

Storage Cabinets(40)

Contemporary - Metal(40)

Contemporary - Veneer(39)

Mobile Pedestals(38)

Panels/Partitions(34)

Workstations/Computer Desks(34)

Stools & Drafting Chairs(32)

Carpet Chair Mats(24)

Industrial & Commercial Shelving(22)

Legs(22)

Laminate Tops(21)

Cork/Fabric Bulletin Boards(21)

Wall Clocks(20)

Wire Shelving(20)

Desktop Risers(18)

Wood Veneer Bookcases(17)

Mobile File Carts & Cabinets(16)

Backrests & Seat Cushions(16)

Metal Bookcases(15)

Educational Seating(15)

Book Racks(15)

Utility/Service Carts(15)

Folding Tables(15)

Protectors(14)

Hard Floor Chair Mats(14)

Desktop Organizers(13)

Shelf(12)

Easel Boards(12)

Fans(12)

Certificate Frames & Holders(11)

Ottomans(11)

Bulletin Boards(11)

Work Surfaces(10)

Casters(9)

Reception Area & Accent Tables(9)

Heaters(9)

Monitor Stands/Risers(9)

Panel System Hardware(8)

Bulletin Bars(8)

Wall Files, Pockets & Accessories(7)

Monitor Arms(7)

Board Erasers(7)

Portable Storage Files & Bins(7)

Big & Tall Chairs(7)

Hand Trucks & Dollies(6)

Keyboard/Mouse Platforms & Trays(6)

Desk Pads(6)

Pencil Holders(6)

Power Strips(6)

Headrest(6)

Wood Lateral Files(6)

Letter Trays(6)

Card Files & Holders(5)

Business Card Holders(5)

Foot Rests(5)

Magnets(5)

Desktop File Sorters(5)

Wall Racks(5)

Reception Sofa(4)

Refrigerators(4)

Arm Sets(4)

Anti-Static Chair Mats(4)

Base(4)

Hooks & Hangers(4)

TV/VCR Stands & Mounts(4)

Loveseat Sofa(4)

Lecterns(3)

Exam Tables(3)

Compact & Student Desks(3)

Printer/Fax Stands(3)

Laminate Bookcases(3)

Coat/Garment Hooks(3)

Storage Drawers & Accessories(3)

Dry Erase Markers(3)

Recycling Bins(2)

Paper Clip Holders(2)

Notes Holders / Dispensers(2)

Anti-Fatigue Mats(2)

Magazine Files(2)

Phone Stands(2)

Laptop Cases & Bags(2)

Storage Boxes & Containers(2)

Active Seating(2)

Light Bulbs & Tubes(2)

Waste Containers & Accessories(2)

Signs & Sign Holders(2)

Combination Bulletin/Dry-Erase Boards(2)

Multimedia Carts(2)

Surge Protectors(2)

Push Pins(2)

Cable Management(2)

Open Shelf Files(2)

Coat/Garment Hangers(2)

Paper Clips(1)

Mail Carts(1)

Mounting Putty(1)

Nameplates(1)

Telephone Stands & Holders(1)

Indoor Mats(1)

Business Card Refills(1)

Desktop Shelves(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Bookends(1)

Pad Retainers(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)

Rulers & Yardsticks(1)

Dry-Erase Kits/Holders(1)

Projector Mounts(1)

Ice Buckets(1)

Literature Organizers/Sorters(1)

Brand

Lorell(2204)

Active Office(81)

Color

Black(503)

Clear(80)

Mahogany(54)

Putty(52)

White(50)

Silver(45)

Light Gray(41)

Cherry(37)

Gray(31)

Charcoal(26)

Chrome(23)

Walnut(22)

Brown(17)

Green(17)

Blue(16)

Navy(11)

Beige(11)

Red(10)

Espresso(10)

Charcoal Gray(9)

Medium Tone(9)

Cloud(7)

Ocean(6)

Apple Green(6)

Stratus(6)

Buff(6)

Aluminum(5)

Chrome - Handle(5)

Satin(5)

Bronze(5)

Tan(4)

Platinum(4)

Oxblood(4)

Real Red(4)

Natural(4)

Malted(4)

Pepper(4)

Metallic Silver(3)

Laminate(3)

Periwinkle Blue(3)

Green Edge(3)

Transparent(3)

Latte(3)

White Shade(2)

- Frame(2)

Silver Mist(2)

Graphite(2)

Dark Blue(2)

Orange(2)

Espresso Laminate(2)

Burgundy(2)

Rosewood(2)

Clear Frame(2)

Assorted(2)

Platinum Gray(2)

Matte(2)

Saddle(2)

Smoke(2)

Black Hanger(2)

Champagne Gold(2)

Slate(2)

Frosted(1)

Brick Beige(1)

Hook(1)

Stone(1)

Dark Gray(1)

Ivory(1)

Stainless Steel(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Charcoal Black(1)

Taupe(1)

Midnight Blue(1)

Multi(1)

Chinchilla(1)

Light Blue(1)

Black Cherry(1)

Black Mahogany(1)

Heat Wave(1)

Lime(1)

Size

Large (L)(1)

Recycled

No(1226)

Yes(453)

Price Range

$0-$499.99(1954)

$500-$999.99(293)

$1000-$1499.99(27)

$1500-$1999.99(2)

To  GO

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

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