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_1` 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 (`category_id` IN ('90089')) 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 '%MediaSleeves' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('MediaSleeves' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MediaSleeves' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MediaSleeves"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MediaSleeves"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MediaSleeves"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MediaSleeves"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MediaSleeves' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MediaSleeves',`category_4` ='MediaSleeves') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MediaSleeves,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MediaSleeves', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Media Sleeves

Refine Search

  GO
 
Brand

Quality Park(4)

Avery(2)

Fellowes(2)

Vaultz(2)

C-Line(1)

 
Warranty

Manufacturer's limited one-year warranty.(1)

 
Special Features

Value Pack-Stock up and save!(1)

Moisture-Resistant TYVEK Material(1)

 
For Use With

Three-Ring Binder(2)

Binder Covers; File Folders; Presentation Books(1)

Standard CD Storage Units(1)

Three-Ring Binder;Media Binder Case IDEVZ01072(1)

 
Capacity (text)

1(7)

2(2)

4(1)

8(1)

 
Manufacturer Part Number

73721(1)

75263(1)

70568(1)

90659(1)

95304(1)

VZ01096(1)

VZ01401(1)

62903(1)

62905(1)

77203(1)

R7050(1)

 
Country of Origin

CN(7)

US(4)

 
Height

5"(3)

5 1/2"(2)

5 3/4"(2)

11.13"(1)

 
Width

5"(4)

5 1/3"(1)

7.38"(1)

6"(1)

5 3/4"(1)

 
Depth

0.06"(1)

3 1/4"(1)

 
Color(s)

Clear(5)

White(5)

Black/Clear(1)

 
Material(s)

Polypropylene(3)

Paper; Polypropylene(2)

Vinyl(1)

Archival-Safe Poly(1)

Tech No-Tear Poly/Paper(1)

Polypropylene; TYVEK(1)

 
Closure

Ungummed Flap(3)

Fold-Over Flap(1)

Tuck-in Flap(1)

Locking Tab(1)

 
Media Stored

CD; DVD(8)

CD(2)

CD; DVD; Zip Disk(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved