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

Reception, Side & Guest Chairs(129)

Executive/High Back Chairs(129)

Task Chairs(94)

Meeting & Conference Room Tables(70)

Folding/Stacking Chairs & Carts(67)

Metal Lateral Files(65)

Training Room Tables(62)

Metal Vertical Files(61)

Dry-Erase Boards(56)

Utility & Breakroom Tables(53)

Management/Mid-Back Chairs(43)

Contemporary - Metal(40)

Mobile Pedestals(38)

Lamps(38)

Stools & Drafting Chairs(37)

Adjustable Worksurfaces(33)

Workstations/Computer Desks(32)

Storage Cabinets(31)

Carpet Chair Mats(24)

Book Racks(23)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Wire Shelving(20)

Legs(19)

Wall Clocks(18)

Wood Veneer Bookcases(17)

Educational Seating(15)

Utility/Service Carts(15)

Folding Tables(15)

Metal Bookcases(15)

Backrests & Seat Cushions(14)

Desktop Risers(14)

Mobile File Carts & Cabinets(14)

Hard Floor Chair Mats(14)

Desktop Organizers(13)

Protectors(13)

Easel Boards(12)

Shelf(12)

Fans(12)

Certificate Frames & Holders(11)

Ottomans(11)

Panels/Partitions(11)

Bulletin Boards(11)

Work Surfaces(10)

Heaters(9)

Reception Area & Accent Tables(9)

Monitor Stands/Risers(9)

Bulletin Bars(8)

Wall Files, Pockets & Accessories(7)

Big & Tall Chairs(7)

Casters(7)

Portable Storage Files & Bins(7)

Panel System Hardware(6)

Hand Trucks & Dollies(6)

Desk Pads(6)

Monitor Arms(6)

Pencil Holders(6)

Keyboard/Mouse Platforms & Trays(6)

Power Strips(6)

Wood Lateral Files(6)

Letter Trays(5)

Business Card Holders(5)

Desktop File Sorters(5)

Board Erasers(5)

Magnets(5)

Laminate Tops(5)

Card Files & Holders(5)

Headrest(5)

Anti-Static Chair Mats(4)

Wall Racks(4)

Arm Sets(4)

Reception Sofa(4)

Loveseat Sofa(4)

Foot Rests(4)

Hooks & Hangers(4)

Refrigerators(4)

Printer/Fax Stands(3)

Exam Tables(3)

Lecterns(3)

TV/VCR Stands & Mounts(3)

Storage Drawers & Accessories(3)

Dry Erase Markers(3)

Coat/Garment Hooks(3)

Laminate Bookcases(3)

Compact & Student Desks(3)

Paper Clip Holders(2)

Recycling Bins(2)

Contemporary - Veneer(2)

Phone Stands(2)

Storage Boxes & Containers(2)

Multimedia Carts(2)

Combination Bulletin/Dry-Erase Boards(2)

Waste Containers & Accessories(2)

Coat/Garment Hangers(2)

Active Seating(2)

Cable Management(2)

Light Bulbs & Tubes(2)

Surge Protectors(2)

Signs & Sign Holders(2)

Magazine Files(2)

Notes Holders / Dispensers(2)

Open Shelf Files(2)

Laptop Cases & Bags(2)

Push Pins(2)

Anti-Fatigue Mats(2)

Telephone Stands & Holders(1)

Paper Clips(1)

Indoor Mats(1)

Bookends(1)

Mail Carts(1)

Desktop Shelves(1)

Nameplates(1)

Doorstops(1)

Literature Organizers/Sorters(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

Pad Retainers(1)

Mounting Putty(1)

Business Card Refills(1)

Pads/Sliders(1)

Wall Planners & Organizers(1)

Sliders(1)

Frames(1)

Scratch Pads(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Board Cleaners & Wipes(1)

Briefcases(1)

Drawer Organizers(1)

File Divider Kit(1)

File Rails/Frames(1)

Laptop Stands & Pads(1)

 
Brand

Lorell(2115)

 
Color

Black(470)

Clear(76)

White(53)

Putty(47)

Silver(39)

Light Gray(36)

Mahogany(35)

Gray(29)

Charcoal(26)

Chrome(22)

Cherry(21)

Walnut(20)

Blue(16)

Brown(16)

Green(15)

Navy(11)

Beige(10)

Charcoal Gray(9)

Espresso(9)

Red(8)

Medium Tone(7)

Cloud(7)

Stratus(6)

Buff(6)

Ocean(6)

Apple Green(6)

Parchment(6)

Bronze(5)

Aluminum(5)

Chrome - Handle(5)

Tan(4)

Malted(4)

Real Red(4)

Pepper(4)

Natural(4)

Satin(4)

Laminate(4)

Platinum(4)

Oxblood(4)

Transparent(3)

Green Edge(3)

Metallic Silver(3)

Periwinkle Blue(3)

Ash(2)

Orange(2)

Dark Blue(2)

Graphite(2)

Saddle(2)

Platinum Gray(2)

Assorted(2)

Black Hanger(2)

Matte(2)

Slate(2)

White Shade(2)

Champagne Gold(2)

Smoke(2)

Burgundy(2)

Silver Mist(2)

Rosewood(2)

Clear Frame(2)

Brick Beige(1)

Ivory(1)

Chinchilla(1)

Dark Gray(1)

Black Cherry(1)

Lime(1)

Hook(1)

Stone(1)

Black Mahogany(1)

Heat Wave(1)

Weathered Charcoal(1)

Light Blue(1)

Taupe(1)

Midnight Blue(1)

Charcoal Black(1)

Stainless Steel(1)

 
Recycled

No(1150)

Yes(458)

 
 
 

© 2019-2020 Legal Name, All Rights Reserved