0

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_4` 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(406)

Executive/High Back Chairs(139)

Reception, Side & Guest Chairs(134)

Task Chairs(129)

Meeting & Conference Room Tables(101)

Metal Vertical Files(76)

Contemporary - Metal(73)

Folding/Stacking Chairs & Carts(73)

Metal Lateral Files(65)

Training Room Tables(63)

Utility & Breakroom Tables(56)

Dry-Erase Boards(56)

Management/Mid-Back Chairs(46)

Lamps(41)

Adjustable Worksurfaces(41)

Storage Cabinets(40)

Mobile Pedestals(38)

Stools & Drafting Chairs(37)

Workstations/Computer Desks(36)

Contemporary - Veneer(35)

Panels/Partitions(33)

Carpet Chair Mats(24)

Legs(24)

Book Racks(24)

Industrial & Commercial Shelving(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)

Folding Tables(15)

Educational Seating(15)

Utility/Service Carts(15)

Protectors(14)

Hard Floor Chair Mats(14)

Desktop Organizers(13)

Shelf(12)

Easel Boards(12)

Ottomans(11)

Certificate Frames & Holders(11)

Bulletin Boards(11)

Fans(11)

Work Surfaces(10)

Big & Tall Chairs(10)

Casters(9)

Monitor Stands/Risers(9)

Reception Area & Accent Tables(9)

Heaters(9)

Bulletin Bars(8)

Panel System Hardware(8)

Monitor Arms(7)

Wall Files, Pockets & Accessories(7)

Keyboard/Mouse Platforms & Trays(6)

Headrest(6)

Letter Trays(6)

Power Strips(6)

Hand Trucks & Dollies(6)

Pencil Holders(6)

Wood Lateral Files(6)

Desk Pads(6)

Business Card Holders(5)

Board Erasers(5)

Card Files & Holders(5)

Portable Storage Files & Bins(5)

Laminate Bookcases(5)

Desktop File Sorters(5)

Magnets(5)

Wall Racks(5)

Refrigerators(4)

Reception Sofa(4)

Loveseat Sofa(4)

Arm Sets(4)

Foot Rests(4)

Anti-Static Chair Mats(4)

Base(4)

Hooks & Hangers(4)

Coat/Garment Hooks(3)

Printer/Fax Stands(3)

Lecterns(3)

Exam Tables(3)

Compact & Student Desks(3)

Dry Erase Markers(3)

Storage Drawers & Accessories(3)

TV/VCR Stands & Mounts(3)

Light Bulbs & Tubes(2)

Push Pins(2)

Phone Stands(2)

Coat/Garment Hangers(2)

Traditional - Laminate(2)

Surge Protectors(2)

Combination Bulletin/Dry-Erase Boards(2)

Storage Boxes & Containers(2)

Active Seating(2)

Paper Clip Holders(2)

Recycling Bins(2)

Magazine Files(2)

Racks & Organizers(2)

Anti-Fatigue Mats(2)

Cable Management(2)

Signs & Sign Holders(2)

Multimedia Carts(2)

Open Shelf Files(2)

Notes Holders / Dispensers(2)

Laptop Cases & Bags(2)

Pad Retainers(1)

Indoor Mats(1)

Bookends(1)

Mounting Putty(1)

Business Card Refills(1)

Mail Carts(1)

Desktop Shelves(1)

Paper Clips(1)

Desk Center Drawers(1)

Nameplates(1)

Telephone Stands & Holders(1)

Pads/Sliders(1)

Literature Organizers/Sorters(1)

Desk Clocks(1)

Frames(1)

Waste Containers & Accessories(1)

Sliders(1)

Drawer Organizers(1)

File Divider Kit(1)

File Rails/Frames(1)

Doorstops(1)

Briefcases(1)

Laptop Stands & Pads(1)

Board Cleaners & Wipes(1)

Wall Planners & Organizers(1)

Projector Mounts(1)

Scratch Pads(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Bulletin Board Sets(1)

Rulers & Yardsticks(1)

 
Brand

Lorell(2431)

 
Color

Black(510)

Clear(80)

White(55)

Mahogany(55)

Putty(52)

Silver(44)

Light Gray(41)

Cherry(35)

Gray(32)

Charcoal(30)

Chrome(23)

Walnut(22)

Green(18)

Blue(17)

Brown(17)

Beige(13)

Navy(11)

Espresso(10)

Red(10)

Medium Tone(9)

Charcoal Gray(9)

Pepper(8)

Cloud(7)

Buff(7)

Stratus(7)

Apple Green(7)

Ocean(7)

Real Red(7)

Malted(7)

Periwinkle Blue(7)

Parchment(6)

Satin(5)

Aluminum(5)

Bronze(5)

Chrome - Handle(5)

Oxblood(4)

Tan(4)

Laminate(4)

Natural(4)

Platinum(4)

Roulette(3)

Transparent(3)

Green Edge(3)

Metallic Silver(3)

Latte(3)

Chambray(3)

Saddle(2)

Dark Blue(2)

Ash(2)

Espresso Laminate(2)

Burgundy(2)

Silver Mist(2)

White Shade(2)

- Frame(2)

Graphite(2)

Orange(2)

Rosewood(2)

Black Hanger(2)

Clear Frame(2)

Champagne Gold(2)

Smoke(2)

Matte(2)

Platinum Gray(2)

Slate(2)

Assorted(2)

Ivory(1)

Brick Beige(1)

Blueberry(1)

Dark Gray(1)

Citronella(1)

Cafe(1)

Stone(1)

Frosted(1)

Latte Laminate(1)

Charcoal Black(1)

Hook(1)

Chinchilla(1)

Stainless Steel(1)

Light Blue(1)

Lime(1)

Weathered Charcoal(1)

Black Cherry(1)

Black Mahogany(1)

Multi(1)

Cherry - Frame(1)

Mahogany - Frame(1)

Heat Wave(1)

Sand(1)

Midnight Blue(1)

Taupe(1)

 
Recycled

No(1293)

Yes(515)

 
 
 

© 2020-2021 CPS Office Products, All Rights Reserved