Banner1 Banner1
 
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_36` 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 (`brand_id` = "11410") 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 `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


Lorell

Refine Search

  GO
 
Category

Contemporary - Laminate(358)

Executive/High Back Chairs(118)

Reception, Side & Guest Chairs(112)

Task Chairs(90)

Meeting & Conference Room Tables(70)

Metal Lateral Files(65)

Folding/Stacking Chairs & Carts(64)

Metal Vertical Files(61)

Training Room Tables(58)

Dry-Erase Boards(56)

Utility & Breakroom Tables(44)

Management/Mid-Back Chairs(41)

Contemporary - Metal(40)

Lamps(38)

Adjustable Worksurfaces(33)

Stools & Drafting Chairs(32)

Mobile Pedestals(32)

Storage Cabinets(31)

Workstations/Computer Desks(31)

Carpet Chair Mats(24)

Book Racks(23)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Wire Shelving(20)

Wood Veneer Bookcases(17)

Metal Bookcases(15)

Folding Tables(15)

Utility/Service Carts(15)

Mobile File Carts & Cabinets(14)

Backrests & Seat Cushions(14)

Hard Floor Chair Mats(14)

Wall Clocks(14)

Protectors(13)

Desktop Risers(12)

Shelf(12)

Desktop Organizers(12)

Easel Boards(12)

Certificate Frames & Holders(11)

Educational Seating(11)

Bulletin Boards(11)

Panels/Partitions(11)

Big & Tall Chairs(10)

Reception Area & Accent Tables(9)

Monitor Stands/Risers(9)

Legs(9)

Bulletin Bars(8)

Fans(8)

Panel System Hardware(8)

Heaters(8)

Wall Files, Pockets & Accessories(7)

Casters(7)

Monitor Arms(6)

Desk Pads(6)

Hand Trucks & Dollies(6)

Keyboard/Mouse Platforms & Trays(6)

Wood Lateral Files(6)

Power Strips(6)

Headrest(5)

Pencil Holders(5)

Laminate Tops(5)

Letter Trays(5)

Magnets(5)

Card Files & Holders(5)

Foot Rests(4)

Business Card Holders(4)

Arm Sets(4)

Hooks & Hangers(4)

Wall Racks(4)

Desktop File Sorters(4)

Reception Sofa(4)

Loveseat Sofa(4)

Refrigerators(4)

Printer/Fax Stands(3)

Exam Tables(3)

Lecterns(3)

Coat/Garment Hooks(3)

Portable Storage Files & Bins(3)

Compact & Student Desks(3)

Dry Erase Markers(3)

Laminate Bookcases(3)

Storage Drawers & Accessories(3)

Anti-Static Chair Mats(3)

TV/VCR Stands & Mounts(3)

Paper Clip Holders(2)

Recycling Bins(2)

Phone Stands(2)

Multimedia Carts(2)

Coat/Garment Hangers(2)

Surge Protectors(2)

Work Surfaces(2)

Push Pins(2)

Active Seating(2)

Magazine Files(2)

Board Erasers(2)

Storage Boxes & Containers(2)

Signs & Sign Holders(2)

Contemporary - Veneer(2)

Anti-Fatigue Mats(2)

Laptop Cases & Bags(2)

Combination Bulletin/Dry-Erase Boards(2)

Open Shelf Files(2)

Light Bulbs & Tubes(2)

Cable Management(2)

Mail Carts(1)

Paper Clips(1)

Desktop Shelves(1)

Rulers & Yardsticks(1)

Indoor Mats(1)

Bookends(1)

Notes Holders / Dispensers(1)

Business Card Refills(1)

Bulletin Board Sets(1)

Nameplates(1)

Ottomans(1)

Ice Buckets(1)

Telephone Stands & Holders(1)

Waste Containers & Accessories(1)

Laptop Stands & Pads(1)

Wall Planners & Organizers(1)

Dry-Erase Kits/Holders(1)

Pads/Sliders(1)

Scratch Pads(1)

Frames(1)

Doorstops(1)

Board Cleaners & Wipes(1)

Briefcases(1)

File Rails/Frames(1)

File Divider Kit(1)

Pad Retainers(1)

Sliders(1)

Drawer Organizers(1)

 
Brand

Lorell(1993)

 
Color

Black(438)

Clear(75)

White(49)

Putty(43)

Silver(35)

Light Gray(34)

Mahogany(31)

Gray(29)

Charcoal(26)

Chrome(22)

Cherry(18)

Walnut(16)

Blue(16)

Brown(14)

Green(13)

Beige(12)

Navy(11)

Espresso(7)

Medium Tone(7)

Cloud(7)

Ocean(6)

Parchment(6)

Apple Green(6)

Stratus(6)

Buff(6)

Chrome - Handle(5)

Red(5)

Aluminum(5)

Real Red(4)

Platinum(4)

Oxblood(4)

Tan(4)

Malted(4)

Satin(4)

Laminate(4)

Pepper(4)

Charcoal Gray(4)

Periwinkle Blue(3)

Metallic Silver(3)

Transparent(3)

Green Edge(3)

Graphite(2)

White Shade(2)

Dark Blue(2)

Ash(2)

Natural(2)

Burgundy(2)

Silver Mist(2)

Orange(2)

Clear Frame(2)

Black Hanger(2)

Rosewood(2)

Assorted(2)

Matte(2)

Platinum Gray(2)

Champagne Gold(2)

Smoke(2)

Roulette(1)

Dark Gray(1)

Ivory(1)

Stone(1)

Hook(1)

Charcoal Black(1)

Lime(1)

Saddle(1)

Stainless Steel(1)

Light Blue(1)

Weathered Charcoal(1)

Black Cherry(1)

Black Mahogany(1)

Taupe(1)

Midnight Blue(1)

Heat Wave(1)

Chinchilla(1)

 
Recycled

No(1081)

Yes(446)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved