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_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 ('182')) 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 '%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

Innovera(5)

Fellowes(3)

Quality Park(3)

C-Line(2)

Avery(1)

find It(1)

Smead(1)

 
Height

5"(4)

5 3/4"(3)

5 1/2"(1)

11 1/8"(1)

10 1/8"(1)

11 1/4"(1)

11 7/8"(1)

 
Color(s)

Clear(8)

White(4)

Clear/White(1)

Clear/Black(1)

Black/Clear(1)

Assorted(1)

 
Depth

1/16"(3)

3/4"(1)

2"(1)

5 3/8"(1)

4 15/16"(1)

5 1/16"(1)

 
Closure

Fold-Over Flap(2)

Ungummed Flap(2)

Tuck Flap(1)

Self-Adhesive(1)

Tuck-In Flap(1)

Locking Tab(1)

Top Flap(1)

 
Manufacturer Part Number

73721(1)

61988(1)

70568(1)

90661(1)

95304(1)

95321(1)

FT07069(1)

39301(1)

39402(1)

39403(1)

39404(1)

39701(1)

62903(1)

77203(1)

R7050(1)

68144(1)

 
Country of Origin

CN(7)

TW(5)

US(4)

 
Width

5"(7)

5 3/8"(2)

5 1/3"(1)

7 3/8"(1)

10 1/8"(1)

13"(1)

11 1/2"(1)

5 3/4"(1)

 
Material(s)

Polypropylene(7)

Paper(2)

Vinyl(1)

Plastic(1)

Paper; Polypropylene(1)

Tech No-Tear Poly/Paper(1)

Polypropylene; TYVEK(1)

Poly(1)

 
For Use With

Three-Ring Binder(2)

Binder Covers; File Folders; Presentation Books(1)

Standard CD/DVD Storage Cases(1)

CD/DVD Binder IVR39300;Three-Ring Binder;Four-Ring Binder(1)

 
Capacity (text)

1(10)

2(3)

8(2)

6(1)

 
Media Stored

CD; DVD(14)

CD; DVD; Zip Disk(1)

CD; Diskettes(1)

 
Media Sleeve Type

Pocket(6)

Self-Adhesive Sleeve(3)

Double-Sided Sleeve(2)

Double-Sided Refill Sheet(2)

Top-Loading, Self-Adhesive(1)

Single-Sided Refill Sheet(1)

Top-Loading Double-Sided Sleeve(1)

 
Media Sleeve Features

Peel-Off Backing; Permanent Adhesive(1)

Index Opening For Labels; Liner Notes(1)

Self-Adhesive Backing(1)

Label Strip(1)

Liner Notes(1)

Black Backing(1)

Fabric-Lined;Removable Index Cards(1)

Built-In Label Tab(1)

Clear Front(1)

 
 
 

© 2019-2020 gemlaser, Inc., All Rights Reserved