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

Executive/High Back Chairs(118)

Reception, Side & Guest Chairs(114)

Task Chairs(91)

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)

Mobile Pedestals(32)

Stools & Drafting Chairs(32)

Workstations/Computer Desks(31)

Storage Cabinets(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)

Utility/Service Carts(15)

Folding Tables(15)

Wall Clocks(14)

Backrests & Seat Cushions(14)

Mobile File Carts & Cabinets(14)

Hard Floor Chair Mats(14)

Protectors(13)

Shelf(12)

Desktop Risers(12)

Easel Boards(12)

Desktop Organizers(12)

Certificate Frames & Holders(11)

Panels/Partitions(11)

Bulletin Boards(11)

Educational Seating(11)

Monitor Stands/Risers(9)

Reception Area & Accent Tables(9)

Legs(9)

Bulletin Bars(8)

Heaters(8)

Fans(8)

Panel System Hardware(8)

Wall Files, Pockets & Accessories(7)

Big & Tall Chairs(7)

Casters(7)

Keyboard/Mouse Platforms & Trays(6)

Wood Lateral Files(6)

Power Strips(6)

Hand Trucks & Dollies(6)

Monitor Arms(6)

Desk Pads(6)

Magnets(5)

Laminate Tops(5)

Card Files & Holders(5)

Letter Trays(5)

Pencil Holders(5)

Headrest(5)

Refrigerators(4)

Desktop File Sorters(4)

Hooks & Hangers(4)

Loveseat Sofa(4)

Reception Sofa(4)

Arm Sets(4)

Foot Rests(4)

Business Card Holders(4)

Wall Racks(4)

Exam Tables(3)

Storage Drawers & Accessories(3)

Printer/Fax Stands(3)

Portable Storage Files & Bins(3)

Coat/Garment Hooks(3)

Lecterns(3)

Compact & Student Desks(3)

Anti-Static Chair Mats(3)

Dry Erase Markers(3)

TV/VCR Stands & Mounts(3)

Combination Bulletin/Dry-Erase Boards(2)

Active Seating(2)

Multimedia Carts(2)

Signs & Sign Holders(2)

Push Pins(2)

Board Erasers(2)

Phone Stands(2)

Paper Clip Holders(2)

Storage Boxes & Containers(2)

Coat/Garment Hangers(2)

Laminate Bookcases(2)

Magazine Files(2)

Surge Protectors(2)

Anti-Fatigue Mats(2)

Cable Management(2)

Light Bulbs & Tubes(2)

Contemporary - Veneer(2)

Work Surfaces(2)

Recycling Bins(2)

Laptop Cases & Bags(2)

Open Shelf Files(2)

Sliders(1)

Business Card Refills(1)

Drawer Organizers(1)

Indoor Mats(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Frames(1)

Notes Holders / Dispensers(1)

Paper Clips(1)

Bookends(1)

Mail Carts(1)

Desktop Shelves(1)

Waste Containers & Accessories(1)

Telephone Stands & Holders(1)

File Divider Kit(1)

Nameplates(1)

File Rails/Frames(1)

Ottomans(1)

Laptop Stands & Pads(1)

Doorstops(1)

Rulers & Yardsticks(1)

Dry-Erase Kits/Holders(1)

Ice Buckets(1)

Bulletin Board Sets(1)

Pad Retainers(1)

Briefcases(1)

Board Cleaners & Wipes(1)

Scratch Pads(1)

 
Brand

Lorell(1990)

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

Yes(446)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved