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 ('TV/VCR/DVD Combo','CRT Televisions','LCD Televisions','Plasma Televisions')) 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 '%Televisions' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Televisions' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Televisions' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Televisions"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Televisions"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Televisions"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Televisions"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Televisions' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Televisions',`category_4` ='Televisions') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Televisions,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Televisions', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Televisions

Refine Search

  GO
 
Brand

Samsung(8)

 
Color

Charcoal Black(5)

Titan Gray(2)

Glossy Black(1)

 
Height

28.1"(2)

17.3"(1)

22.2"(1)

25.6"(1)

29.8"(1)

33"(1)

32.9"(1)

 
Depth

2.3"(7)

3.1"(1)

 
Manufacturer Part Number

UN32M4500BFXZA(1)

UN43RU7100FXZA(1)

UN50RU7100FXZA(1)

UN55RU7100FXZA(1)

UN55RU8000FXZA(1)

UN58RU7100FXZA(1)

UN65RU7100FXZA(1)

UN65RU8000FXZA(1)

 
Width

48.7"(2)

28.9"(1)

38.2"(1)

44.3"(1)

51.2"(1)

57.4"(1)

57.3"(1)

 
Limited Warranty

12 Month(2)

 
Weight (Approximate)

9.26 lb(1)

21.20 lb(1)

30 lb(1)

38.10 lb(1)

42.10 lb(1)

44.50 lb(1)

55.10 lb(1)

56.40 lb(1)

 
Input Voltage

120 V AC(8)

 
USB

Yes(8)

 
Aspect Ratio

16:9(8)

 
Sound System

Dolby Digital(7)

Dolby(7)

Dolby Digital Plus(1)

 
Wireless LAN

Yes(8)

 
VESA Mount Standard

200 x 200(6)

100 x 100(1)

400 x 400(1)

 
Ethernet

Yes(8)

 
HDMI

Yes(8)

 
RMS Output Power

20 W(7)

10 W(1)

 
Operating Power Consumption

120 W(2)

48 W(1)

105 W(1)

135 W(1)

140 W(1)

160 W(1)

170 W(1)

 
Streaming Service

Amazon Prime(7)

YouTube(7)

Google Play Movies & TV(7)

Netflix(6)

Spotify(5)

Deezer(5)

HBO NOW(2)

Hulu(2)

VUDU(1)

 
Maximum Resolution

3840 x 2160(7)

1366 x 768(1)

 
Energy Consumption per Year

129 kWh(2)

53 kWh(1)

102 kWh(1)

111 kWh(1)

138 kWh(1)

147 kWh(1)

156 kWh(1)

 
Video Signal Standard

4K UHDTV(7)

HDTV(1)

 
Scan Format

2160p(7)

720p(1)

 
Product Type

Smart LED-LCD TV(8)

 
Product Model

UN32M4500BF(1)

UN43RU7100F(1)

UN50RU7100F(1)

UN55RU7100F(1)

UN55RU8000F(1)

UN58RU7100F(1)

UN65RU7100F(1)

UN65RU8000F(1)