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)

Vaultz(2)

C-Line(1)

Cardinal(1)

Quality Park(1)

Seiko(1)

 
Color

Clear(8)

White(8)

Black(1)

 
Recycled

No(12)

 
Height

5"(1)

5.75"(1)

11.13"(1)

5.1"(1)

 
Depth

0.06"(2)

0.1"(1)

 
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)

VZ01415(1)

62903(1)

SLP-27210(1)

 
Country of Origin

China(9)

United States(4)

Taiwan(2)

Denmark(1)

 
Width

0.1"(1)

5"(1)

7.38"(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)

Album(1)

 
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)

 
Media Type

CD/DVD(7)

 
Number of Holes Punched

9(1)

 
Mailer/Envelope Weight

24 lb(1)

 
Supported Binder Type

Ring Binder(3)

 
Accessibility

Slide Insert(2)

 
Label Width

2 13/16"(1)

 
Product Type

Binder Pocket(7)

Mailer(3)

Optical Disc Label(2)

Optical Disc Case(2)

Optical Disc Album Refill Page(1)

Audio Tape Label(1)

 
Packaged Quantity

10 Pack(2)

50(2)

10 / Pack(1)

5 / Pack(1)

100 Pack(1)

300 Pack(1)

25 Pack(1)

100 Box(1)

250 Box(1)

50 Pack(1)

10(1)

100 / Pack(1)

100 / Box(1)

1 / Each(1)

 
Product Model

21845(1)

95304(1)

 
Product Line

HOLDit!(1)

 
Mailer/Envelope Type

CD/DVD(3)

 
Package Type

Retail(2)

 
Media Capacity

1(4)

10(1)

4(1)

6(1)