facebook
 
 
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_name` IN ('Cassettes & Diskette Labels','CD/DVD Case Inserts','CD/DVD Labeling Systems','CD/DVD Labels')) 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 '%MediaLabels' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('MediaLabels' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+MediaLabels' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"MediaLabels"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"MediaLabels"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"MediaLabels"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"MediaLabels"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+MediaLabels' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='MediaLabels',`category_4` ='MediaLabels') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'MediaLabels,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('MediaLabels', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Media Labels

Refine Search

  GO
 
Brand

Compucessory(4)

Avery®(2)

Business Source(2)

Fellowes(2)

C-Line(1)

Cardinal(1)

Vaultz(1)

Quality Park(1)

Seiko(1)

 
Color

White(8)

Clear(7)

 
Recycled

No(12)

 
Height

5"(1)

5.8"(1)

11.1"(1)

5.1"(1)

 
Depth

0.1"(3)

 
Manufacturer Part Number

73721(1)

75263(1)

26148(1)

26149(1)

22297(1)

26500(1)

26501(1)

26555(1)

70568(1)

21845(1)

90659(1)

95304(1)

VZ01096(1)

62903(1)

SLP-27210(1)

 
Country of Origin

China(7)

United States(4)

Taiwan(2)

Denmark(1)

 
Width

0.1"(1)

5"(1)

7.4"(1)

5.1"(1)

 
Material

Polypropylene(5)

Vinyl(2)

Plastic(1)

Wove(1)

 
Limited Warranty

1 Year(6)

 
Weight (Approximate)

1.60 lb(1)

0.16 oz(1)

0.80 oz(1)

24 lb(1)

 
Shape

Circle(2)

Rectangular(1)

Rectangle(1)

 
Sheet Size

5" Width x 5" Length(1)

5" Width x 5 3/8" Length(1)

 
Print Technology

Inkjet(3)

Laser(2)

 
Style

Sleeve(2)

 
Mailer/Envelope Length

5"(2)

4 7/8"(1)

 
Mailer/Envelope Width

5"(3)

 
Number of Labels per Roll

150(1)

 
Adhesive Type

Permanent(2)

 
Number of Holes Punched

9(1)

 
Mailer/Envelope Weight

24 lb(1)

 
Media Diameter

4 5/8" Diameter(2)

 
Supported Binder Type

Ring Binder(3)

 
Media Type Capacity

1 CD/DVD(5)

4 CD/DVD(1)

6 CD/DVD(1)

 
Accessibility

Slide Insert(1)

 
Product Type

Binder Pocket(7)

Mailer(3)

Optical Disc Label(2)

Optical Disc Case(2)

Audio Tape Label(1)

 
Packaged Quantity

10 / Pack(3)

100 / Pack(2)

100 / Box(2)

5 / Pack(1)

300 / Pack(1)

25 / Pack(1)

250 / Box(1)

50 / Pack(1)

50(1)

10(1)

1 / Box(1)

 
Product Model

21845(1)

95304(1)

 
Product Line

HOLDit!(1)

 
Mailer/Envelope Type

CD/DVD(3)

 
Capacity

2 x CD/DVD(2)

 
Package Type

Retail(1)