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

Executive/High Back Chairs(144)

Reception, Side & Guest Chairs(138)

Task Chairs(130)

Meeting & Conference Room Tables(101)

Contemporary - Metal(78)

Metal Vertical Files(76)

Folding/Stacking Chairs & Carts(74)

Metal Lateral Files(65)

Training Room Tables(64)

Utility & Breakroom Tables(57)

Dry-Erase Boards(56)

Management/Mid-Back Chairs(49)

Contemporary - Veneer(48)

Lamps(43)

Storage Cabinets(42)

Adjustable Worksurfaces(42)

Mobile Pedestals(38)

Panels/Partitions(38)

Stools & Drafting Chairs(37)

Workstations/Computer Desks(37)

Legs(25)

Carpet Chair Mats(24)

Industrial & Commercial Shelving(22)

Laminate Tops(21)

Cork/Fabric Bulletin Boards(21)

Wall Clocks(21)

Wire Shelving(20)

Desktop Risers(19)

Mobile File Carts & Cabinets(17)

Wood Veneer Bookcases(17)

Backrests & Seat Cushions(16)

Utility/Service Carts(15)

Book Racks(15)

Educational Seating(15)

Metal Bookcases(15)

Folding Tables(15)

Hard Floor Chair Mats(14)

Protectors(14)

Desktop Organizers(13)

Fans(12)

Shelf(12)

Easel Boards(12)

Certificate Frames & Holders(11)

Bulletin Boards(11)

Casters(11)

Ottomans(11)

Heaters(10)

Work Surfaces(10)

Reception Area & Accent Tables(9)

Desk Pads(9)

Monitor Stands/Risers(9)

Bulletin Bars(8)

Panel System Hardware(8)

Board Erasers(7)

Wall Files, Pockets & Accessories(7)

Big & Tall Chairs(7)

Monitor Arms(7)

Portable Storage Files & Bins(7)

Keyboard/Mouse Platforms & Trays(6)

Pencil Holders(6)

Letter Trays(6)

Headrest(6)

Power Strips(6)

Hand Trucks & Dollies(6)

Wood Lateral Files(6)

Laminate Bookcases(5)

Foot Rests(5)

Business Card Holders(5)

Wall Racks(5)

Card Files & Holders(5)

Desktop File Sorters(5)

Magnets(5)

Loveseat Sofa(4)

Anti-Static Chair Mats(4)

Reception Sofa(4)

Refrigerators(4)

TV/VCR Stands & Mounts(4)

Base(4)

Hooks & Hangers(4)

Arm Sets(4)

Coat/Garment Hooks(3)

Exam Tables(3)

Printer/Fax Stands(3)

Compact & Student Desks(3)

Desk Center Drawers(3)

Storage Drawers & Accessories(3)

Lecterns(3)

Dry Erase Markers(3)

Traditional - Laminate(3)

Laptop Cases & Bags(3)

Storage Boxes & Containers(2)

Coat/Garment Hangers(2)

Anti-Fatigue Mats(2)

Magazine Files(2)

Notes Holders / Dispensers(2)

Recycling Bins(2)

Paper Clip Holders(2)

Phone Stands(2)

Push Pins(2)

Waste Containers & Accessories(2)

Active Seating(2)

Cable Management(2)

Signs & Sign Holders(2)

Surge Protectors(2)

Light Bulbs & Tubes(2)

Combination Bulletin/Dry-Erase Boards(2)

Multimedia Carts(2)

Open Shelf Files(2)

Projector Mounts(2)

Indoor Mats(1)

Paper Clips(1)

Rulers & Yardsticks(1)

Bulletin Board Sets(1)

Pad Retainers(1)

Mail Carts(1)

Desktop Shelves(1)

Bookends(1)

Mounting Putty(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Literature Organizers/Sorters(1)

Laptop Stands & Pads(1)

Drawer Organizers(1)

Frames(1)

File Divider Kit(1)

File Rails/Frames(1)

Board Cleaners & Wipes(1)

Desk Clocks(1)

Sliders(1)

Scratch Pads(1)

Briefcases(1)

Telephone Stands & Holders(1)

Business Card Refills(1)

Doorstops(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Nameplates(1)

Brand

Lorell(2482)

Color

Black(527)

Clear(83)

Mahogany(58)

White(57)

Putty(52)

Silver(48)

Light Gray(41)

Cherry(37)

Gray(32)

Charcoal(31)

Chrome(23)

Walnut(22)

Brown(18)

Blue(18)

Green(18)

Beige(13)

Navy(11)

Espresso(10)

Red(10)

Medium Tone(9)

Charcoal Gray(9)

Pepper(8)

Periwinkle Blue(7)

Malted(7)

Stratus(7)

Buff(7)

Real Red(7)

Apple Green(7)

Cloud(7)

Ocean(7)

Parchment(6)

Chrome - Handle(5)

Satin(5)

Bronze(5)

Aluminum(5)

Latte(5)

Oxblood(4)

Natural(4)

Platinum(4)

Tan(4)

Green Edge(3)

Laminate(3)

Transparent(3)

Metallic Silver(3)

Chambray(3)

Matte(3)

Roulette(3)

Burgundy(2)

Silver Mist(2)

White Shade(2)

- Frame(2)

Espresso Laminate(2)

Graphite(2)

Orange(2)

Dark Blue(2)

Ash(2)

Latte Laminate(2)

Frosted(2)

Rosewood(2)

Clear Frame(2)

Platinum Gray(2)

Assorted(2)

Slate(2)

Black Hanger(2)

Saddle(2)

Champagne Gold(2)

Blueberry(1)

Citronella(1)

Cafe(1)

Sand(1)

Hook(1)

Stone(1)

Dark Gray(1)

Ivory(1)

Brick Beige(1)

Silver Metal(1)

Charcoal Black(1)

Chinchilla(1)

Multi(1)

Cherry - Frame(1)

Taupe(1)

Mahogany - Frame(1)

Heat Wave(1)

Black Mahogany(1)

Smoke(1)

Midnight Blue(1)

Black Cherry(1)

Stainless Steel(1)

Light Blue(1)

Lime(1)

Size

Large (L)(1)

Recycled

No(1318)

Yes(520)

Price Range

$0-$499.99(2087)

$500-$999.99(325)

$1000-$1499.99(53)

$1500-$1999.99(6)

$2000-$2499.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