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

Currently Filtered by

Category

CDs DVDs

Refine Search

  GO
Brand

Verbatim(50)

Maxell(22)

Innovera(12)

Packing Type

Spindle(61)

Jewel Case(11)

Slim Jewel Case(10)

Slim Case(2)

Manufacturer Part Number

95033(1)

95003(1)

95002(1)

94971(1)

95037(1)

95058(1)

95101(1)

95098(1)

95079(1)

94936(1)

94935(1)

94834(1)

94795(1)

94755(1)

94737(1)

94839(1)

94854(1)

94917(1)

94904(1)

94892(1)

95102(1)

95136(1)

96542(1)

96191(1)

95355(1)

95311(1)

96552(1)

97237(1)

98319(1)

97457(1)

97238(1)

95253(1)

95252(1)

95156(1)

95155(1)

95137(1)

95159(1)

95160(1)

95251(1)

95170(1)

95169(1)

94736(1)

94712(1)

630026(1)

630011(1)

630010(1)

78850(1)

634045(1)

634046(1)

638004(1)

638002(1)

635117(1)

78825(1)

77990(1)

46850(1)

46848(1)

46846(1)

46851(1)

46890(1)

77950(1)

77815(1)

46891(1)

638006(1)

638010(1)

94300(1)

43694(1)

648720(1)

648710(1)

94335(1)

94488(1)

94691(1)

94611(1)

94554(1)

648250(1)

648210(1)

638022(1)

638014(1)

638011(1)

639002(1)

639013(1)

648201(1)

648200(1)

639016(1)

46830(1)

Country of Origin

TW(50)

IN(18)

SG(10)

MX(4)

AE(1)

JP(1)

Surface Color

Silver(45)

White(23)

Gold(8)

Assorted(4)

Matte White(3)

Matte Silver(1)

Capacity Range (Data)

4.7 GB(38)

700 MB(37)

25 GB(3)

8.5 GB(3)

50 GB(1)

185 MB(1)

9.4 GB(1)

Hub Printable

No(73)

Yes(11)

Lightscribe

No(84)

Maximum Recording Speed

16x(27)

52x(19)

4x(14)

8x(6)

48x(6)

12x(4)

6x(3)

3x(2)

2x(2)

32x(1)

Recordable Format

“Write Once” format—may not be altered once data is written to the disc.(62)

Rewritable format—may record and re-record data up to 1,000 times.(20)

Rewritable format—may record and re-record data up to 100,000 times.(2)

Single/Double Sided

Single(79)

Double(5)

Branded Surface

Yes(63)

No(21)

Protective Coating

No(65)

Yes(18)

Surface Type

Branded(59)

Inkjet(19)

Thermal(3)

Type IV(2)

Glossy Inkjet(1)

Capacity (Video)

120 min(38)

240 min(3)

Capacity (Music)

80 min(37)

21 min(1)

Thermal/Inkjet Printable

Inkjet Printable(20)

Thermal Printable(3)

Disk Type

CD-R(26)

DVD-R(20)

CD-RW(12)

DVD+R(10)

DVD+RW(5)

BD-R(3)

DVD+R DL(3)

DVD-RW(2)

DVD-RAM(2)

BD-RE(1)

Packaging Details

Jewel case packaging includes jewel case and insert. Spindle product is packaged in a plastic container and does not include jewel cases or inserts.(84)

Price Range

$0-$99.99(82)

$100-$199.99(2)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved